public static function getOrCreateVenueRelation($keyword_id, $venue_id) { if ($entry = \Model_Keyword_Venue::query()->where('keyword_id', $keyword_id)->where('venue_id', $venue_id)->get_one()) { return $entry; } $system_id = \Collection\Singleton::create('keyword'); $entry = new \Model_Keyword_Venue(); $entry->id = $system_id; $entry->keyword_id = $keyword_id; $entry->venue_id = $venue_id; $entry->count = 0; $entry->save(); return $entry; }
public static function saveVenueJsonToDB($venue, $region_id = NULL) { // skip this venue if it already exists if (self::venueFoursquareIdExists($venue->id)) { return false; } $response = array(); // create a new global identifier $system_venue_id = \Collection\Singleton::create('venue'); $response['system_venue_id'] = $system_venue_id; // create a base venue entry self::createVenue($system_venue_id, $venue, $region_id); $response['log'] = 'Added new venue: ' . $venue->name . ' / ' . $venue->id; // save foursquare relevant data self::createOrUpdateVenueMetaFoursquare($system_venue_id, $venue); // save general meta data for this venue self::createVenueMetaCommon($system_venue_id, $venue); // write initial stats to DB > $stats array $response['stats'] = self::saveVenueStats($system_venue_id, $venue); return $response; }
public static function getInternalUserId($interaction) { // 2do: prevent duplicate querying $query = \DB::select('*')->from('user_meta_instagram'); $query->join('user'); $query->on('user.id', '=', 'user_meta_instagram.id'); $query->where('instagram_user_id', $interaction->user->id); $results = $query->as_object()->execute(); if ($results && isset($results[0])) { return $results[0]->id; } $system_user_id = \Collection\Singleton::create('interaction'); $BaseUser = new \Model_User(); $BaseUser->id = $system_user_id; $BaseUser->username = $interaction->user->username; $BaseUser->save(); $InstagramUser = new \Model_User_Meta_Instagram(); $InstagramUser->id = $system_user_id; $InstagramUser->username = $interaction->user->username; $InstagramUser->instagram_user_id = $interaction->user->id; $InstagramUser->save(); return $system_user_id; }