/** * 计算过期事件条数 */ public function getCountEvents() { $sql_str = "select count(*) as count from "; $sql_str .= UserDeviceMeta::model()->tableName() . " where meta_name < 'event_id' group by user_id,meta_name"; $sql = Yii::app()->db->createCommand($sql_str); $user_devices = $sql->queryAll(); if (empty($user_devices)) { return 0; } return $user_devices[0]['count']; }
/** * 更新设备对应的事件ID * @param int $deviceId * @param string $key */ public function updateEvent($deviceId, $value) { $item = UserDeviceMeta::model()->find("device_id=:device_id and meta_name=:meta_name", array("device_id" => $deviceId, "meta_name" => "event_id")); if (isset($item)) { $item->meta_value = $value; $item->save(); } }