/**
* 计算过期事件条数
*/
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();
}
}
