コード例 #1
0
ファイル: HotComm.php プロジェクト: emilymwang8/ajk-broker
 public static function getMostHotComms($cityId, $commIds, $fields = array())
 {
     // TYPE = 0 AND scoreRank IN (2,3) AND isY = 1";
     try {
         $allComm_today = Model_Mobile_HotComm::data_access()->filter('cityId', $cityId)->filter('type', 0)->filter_by_op('scoreRank', 'in', array(2, 3))->filter('isY', 1)->filter_by_op('commId', 'in', $commIds)->load_field($fields)->get_all();
         $yesterday = date("Ymd", time() - 86400);
         $allComm_yesterday = Model_Mobile_HotComm::data_access($yesterday)->filter('cityId', $cityId)->filter('type', 0)->filter_by_op('scoreRank', 'in', array(2, 3))->filter('isY', 1)->filter_by_op('commId', 'in', $commIds)->load_field($fields)->get_all();
     } catch (Exception $e) {
         $allComm = false;
     }
     return array_merge($allComm_today, $allComm_yesterday);
 }
コード例 #2
0
ファイル: NearbyComm.php プロジェクト: emilymwang8/ajk-broker
 public function handle_request_internal()
 {
     $nearby_comm = new V1_Comm_GetNearbyController();
     $this->_params['pageSize'] = $this->_params['pageSize'] ? $this->_params['pageSize'] : self::NEARBY_COMM_NUM;
     //小区数目为40
     $key = self::MEMCACHE_KEY_FIND_NEARBY_COMMS . '_';
     foreach ($this->_params as $k => $v) {
         if (in_array($k, array('brokerId', 'cityId', 'mapType', 'lat', 'lng'))) {
             $key .= $k . '=' . $v;
         }
     }
     $key .= '_' . date("Ymd");
     $memcache = APF_Cache_Factory::get_instance()->get_memcache();
     $result = $memcache->get($key);
     $cityId = $this->_params['cityId'];
     if (empty($result)) {
         //初始化数组
         $commId = array();
         $topComms = array();
         $commonComms = array();
         $lanHaiComms = array();
         $hotComms = array();
         $nearby_comm = $nearby_comm->getNearbyComm($this->_params, 1, 0);
         if (!empty($nearby_comm) && $nearby_comm['count'] > 0) {
             //获取全部小区ID数组
             foreach ($nearby_comm['communities'] as $comm) {
                 $commIds[] = $comm['id'];
             }
             //从蓝海小区表获取相关数据
             //蓝海小区城市开关(产品表示暂不启用?)
             //$isOpenCity = Model_Mobile_TightCommCity::checkOpenCity($this->_params['cityId']);
             $allLanHaiComms = Model_Mobile_LanHaiComm::getAllLanHaiComms($commIds, array('commId', 'spreadNum', 'averageVPPV'));
             if (!empty($allLanHaiComms)) {
                 $maxVPPVComm = 0;
                 foreach ($allLanHaiComms as $lanHaiComm) {
                     $totalVPPV = ceil($lanHaiComm->averageVPPV * $lanHaiComm->spreadNum);
                     if ($totalVPPV > $maxVPPVComm) {
                         $maxVPPVComm = $totalVPPV;
                         $topCommIds[0] = $lanHaiComm->commId;
                     }
                     $lanHaiComms[$lanHaiComm->commId]['spreadNum'] = $lanHaiComm->spreadNum;
                     $lanHaiComms[$lanHaiComm->commId]['totalVPPV'] = $totalVPPV;
                 }
                 //从返还小区表里获取返还小区
                 $lanHaiCommIds = array_keys($lanHaiComms);
                 $allFanComms = Model_Mobile_FanComm::getAllFanComms($lanHaiCommIds, array('commId'));
             }
             //从热门小区表、竞争激烈表获取相关数据
             $allHotComms = Model_Mobile_HotComm::getMostHotComms($cityId, $commIds, array('commId', 'spreadPropNum', 'totalVPPV', 'type'));
             if (!empty($allHotComms)) {
                 $maxVPPVComm = 0;
                 $totalVPPV = array();
                 foreach ($allHotComms as $hotComm) {
                     $totalVPPV[$hotComm['commId']]['totalVPPV'] += $hotComm['totalVPPV'];
                     $spreadNum[$hotComm['commId']]['spreadNum'] += $hotComm['spreadPropNum'];
                     if ($totalVPPV[$hotComm['commId']]['totalVPPV'] > $maxVPPVComm) {
                         $maxVPPVComm = $totalVPPV[$hotComm['commId']]['totalVPPV'];
                         if (!in_array($hotComm['commId'], $lanHaiCommIds)) {
                             $topCommIds[1] = $hotComm['commId'];
                         }
                     }
                     $hotComms[$hotComm['commId']]['spreadNum'] = $spreadNum[$hotComm['commId']]['spreadNum'];
                     $hotComms[$hotComm['commId']]['totalVPPV'] = $totalVPPV[$hotComm['commId']]['totalVPPV'];
                 }
             }
             //循环小区数组,加上小区类型(蓝海、热门),房源数,vppv
             foreach ($nearby_comm['communities'] as $k => &$comm) {
                 $comm['commType'] = '';
                 $comm['isFanComm'] = 0;
                 $comm['spreadNum'] = 0;
                 $comm['totalVPPV'] = 0;
                 //打标签
                 if (isset($hotComms[$comm['id']])) {
                     $comm['commType'] = self::COMMTYPE_HOT;
                     $comm['spreadNum'] = $hotComms[$comm['id']]['spreadNum'];
                     $comm['totalVPPV'] = $hotComms[$comm['id']]['totalVPPV'];
                 }
                 if (isset($lanHaiComms[$comm['id']])) {
                     $comm['commType'] = self::COMMTYPE_LAN;
                     $comm['spreadNum'] = $lanHaiComms[$comm['id']]['spreadNum'];
                     $comm['totalVPPV'] = $lanHaiComms[$comm['id']]['totalVPPV'];
                     if (!empty($allFanComms)) {
                         foreach ($allFanComms as $fanComm) {
                             if ($fanComm->commId == $comm['id']) {
                                 $comm['isFanComm'] = 1;
                             }
                         }
                     }
                 } else {
                     //获取该小区的VPPV和推广房源数
                 }
                 if (!empty($topCommIds)) {
                     //从普通小区数组中去除top小区位的小区
                     if (in_array($comm['id'], $topCommIds)) {
                         foreach ($topCommIds as $k => $commId) {
                             if ($comm['id'] == $commId) {
                                 $topComms[] = $comm;
                             }
                         }
                     } else {
                         $common_comms[] = $comm;
                     }
                 } else {
                     $common_comms[] = $comm;
                 }
             }
             $commonComms = $common_comms;
             ksort($topComms);
         }
         $result['topComms'] = $topComms;
         $result['commonComms'] = $commonComms;
         if (!(empty($result['topComms']) && empty($result['commonComms']))) {
             $memcache->add($key, $result, 0, 86400);
             //24h
         }
     }
     $ret = array('status' => 'ok', 'data' => $result);
     return $ret;
 }