/** * 根据 `onlineDate` 字段删除数据 * * @param int $date * @return int */ public static function deleteByOnlineDate($date) { $effectRowAllCount = 0; for ($splitSuffix = 0; $splitSuffix < 10; $splitSuffix++) { try { $effectRowCount = Model_Stats_HzPropPromotionTime::data_access($splitSuffix)->filter('onlineDate', $date)->delete(); $effectRowAllCount = $effectRowAllCount + $effectRowCount; } catch (Exception $e) { } } return $effectRowAllCount; }
public function savePropPromotionTime($data) { $this->logMessage(sprintf('保存房源在线统计数据: %s', json_encode($data))); try { Model_Stats_HzPropPromotionTime::create($data, $data['brokerId'])->save(); } catch (Exception $e) { $table_data = Model_Stats_HzPropPromotionTime::get_mapping($data['brokerId']); $dao = Model_Stats_HzPropPromotionTime::data_access($data['brokerId']); $dao->force_master(); $dao->native_sql('update ' . $table_data['table'] . ' set online_hour=?,min_online_datetime=?,max_offline_datetime=? where plan_type=? and online_date=? and proid=? and plan_id=?', array($data['onlineHour'], $data['minOnlineDatetime'], $data['maxOfflineDatetime'], $data['planType'], $data['onlineDate'], $data['propId'], $data['planId'])); } }