function getConversion($conversionID, $renewCache = false) { $redis = new RedisBaseModel(Config::get('redis.redis_2.host'), Config::get('redis.redis_2.port'), false); $cacheKey = "Conversion"; $cacheField = $conversionID; $retval = $redis->hGet($cacheKey, $cacheField); if (Input::get('cleared') || $renewCache) { $redis->hDel($cacheKey, $cacheField); if (!empty($retval->campaign_id)) { $redis->hDel("CampConv_{$retval->campaign_id}", $cacheField); } $retval = 0; } if (!$retval) { $retval = DB::table('conversion')->join('campaign', 'conversion.campaign_id', '=', 'campaign.id')->where('conversion.id', $conversionID)->where('conversion.status', 1)->select('conversion.id', 'conversion.name', 'conversion.campaign_id', 'conversion.param', 'conversion.source', 'campaign.name')->first(); if ($retval) { $retval->param = json_decode($retval->param); $redis->hSet("CampConv_{$retval->campaign_id}", $conversionID, $conversionID); } $redis->hSet($cacheKey, $cacheField, $retval); } return $retval; }
/** * * Get campaign * @param int $campaignID * @param bool $renewCache */ public function getCampaign($campaignID, $renewCache = false) { $redis = new RedisBaseModel(Config::get('redis.redis_2.host'), Config::get('redis.redis_2.port'), false); $cacheKey = "Campaign"; $cacheField = $campaignID; $retval = $redis->hGet($cacheKey, $cacheField); if (Input::get('cleared') || $renewCache) { $redis->hDel($cacheKey, $cacheField); $retval = 0; } if (!$retval) { $retval = DB::table('campaign')->select('id', 'name', 'advertiser_id', 'category_id')->where('id', $campaignID)->first(); $redis->hSet($cacheKey, $cacheField, $retval); } return $retval; }