コード例 #1
0
 public function handle_request()
 {
     // 获取查询范围
     $beginTime = $this->cursor['updatedDatetime'];
     $endTime = $beginTime + $this->interval;
     // 获取当前的DB最新时间(考虑到Web Server和DB时间可能有差异,以DB时间为准)
     $fetchTime = $this->getDbCurrentTime();
     $formatBeginTime = date('Y-m-d H:i:s', $beginTime);
     $formatEndTime = date('Y-m-d H:i:s', $endTime);
     $formatFetchTime = date('Y-m-d H:i:s', $fetchTime);
     $this->log("*** BeginTime: {$formatBeginTime}; EndTime: {$formatEndTime}; FetchTime: {$formatFetchTime}");
     // 获取更新信息的经纪人列表,逐个判断待同步的字段是否有更新
     $brokers = Model_Broker_AjkBrokerExtend::getBrokersBetween($formatBeginTime, $formatEndTime);
     foreach ($brokers as $broker) {
         // 获取经纪人待同步字段
         $columns = $broker->getSyncFields();
         $columns = array_merge($columns, array('From' => 'User_BrokerSyncQueue'));
         // 提取新字段的MD5值
         ksort($columns);
         $context = json_encode($columns);
         $md5 = md5($context);
         // 获取经纪人最新同步记录
         $brokerInfo = Model_Log_LogMergeQueneNew::getLatestBroker($broker->brokerId);
         // 经纪人同步记录不存在 或者 存在且MD5值不一致,插入新纪录
         if (!$brokerInfo || $brokerInfo->md5 != $md5) {
             $params = array();
             $params['cityId'] = $broker->cityId;
             $params['brokerId'] = $broker->brokerId;
             $params['context'] = $context;
             $params['md5'] = $md5;
             $params['addTime'] = date('Y-m-d H:i:s');
             Model_Log_LogMergeQueneNew::insertQuene($params);
             $this->log("BrokerId: {$broker->brokerId} - Remark: Success,CheckState: {$broker->checkState}");
         } else {
             $this->log("BrokerId: {$broker->brokerId} - Remark: 经纪人待同步字段没有变更,CheckState: {$broker->checkState}");
         }
     }
     // 更新游标
     $this->cursor['updatedDatetime'] = min($endTime, $fetchTime);
     $this->setFlag($this->cursor);
 }
コード例 #2
0
 /**
  * @return array|bool
  */
 protected function getBrokers()
 {
     switch ($this->action) {
         case 'hotfix':
             // 获取指定的经纪人
             $brokers = Model_Broker_AjkBrokerExtend::findMultiBrokers($this->brokerIds);
             break;
         case 'default':
             // 获取最近更新过的经纪人记录
         // 获取最近更新过的经纪人记录
         default:
             $brokers = array();
             $items = Model_Log_LogMergeQueneNew::getMultiBrokersByIdCursor($this->cursor['id'], $this->per);
             foreach ($items as $item) {
                 $id = $item['id'];
                 $brokers[$id] = $item->getContext();
                 $brokers[$id]['brokerId'] = $item['brokerId'];
                 $brokers[$id]['id'] = $id;
             }
     }
     return $brokers;
 }
コード例 #3
0
 /**
  * 获取经纪人最新的更新记录
  */
 public static function getLatestBroker($brokerId)
 {
     $da = Model_Log_LogMergeQueneNew::data_access();
     $data = $da->filter('brokerId', $brokerId)->sort('id', 'desc')->find();
     return $data[0];
 }