/** * 获取经纪人的累计消费信息 * * @param int $cityId * @param int $brokerId * @return array */ public static function getBrokerChoiceConsume($cityId, $brokerId) { $cacheKey = sprintf('ajk_broker_choice_consume_%d_%d', $cityId, $brokerId); $memcache = APF_Cache_Factory::get_instance()->get_memcache(); $brokerChoiceConsume = $memcache->get($cacheKey); if (is_array($brokerChoiceConsume) && !empty($brokerChoiceConsume)) { return $brokerChoiceConsume; } $ajkBrokerChoiceConsumeLastUploadDate = Model_Config_huTablesUploadStatus::getTableLastCalculateDate('ajk_broker_choice_consume'); if (empty($ajkBrokerChoiceConsumeLastUploadDate)) { return array(); } $lastUploadDate = date('Ymd', strtotime($ajkBrokerChoiceConsumeLastUploadDate['calDt'])); $brokerChoiceConsume = Model_Stats_AjkBrokerChoiceConsume::getBrokerChoiceConsume($cityId, $brokerId, $lastUploadDate); $memcache->set($cacheKey, $brokerChoiceConsume, 0, 1800); return $brokerChoiceConsume; }
/** * 批量获取经纪人的累计消费记录 * * @param int $date * @return array */ private function getBrokerChoiceConsume($date) { try { $dataAccess = Model_Stats_AjkBrokerChoiceConsume::data_access(''); $dataAccess->filter('calculateDate', $date); $dataAccess->filter_by_op('id', '>', $this->_startId); $dataAccess->limit(self::BATCH_LIMIT); return $dataAccess->get_all(); } catch (Exception $e) { return array(); } }