<?php
require "./global.php";
$socket = stream_socket_server("udp://10.210.136.100:21345", $errno, $errstr, STREAM_SERVER_BIND);
if (!$socket) {
die("{$errstr} ({$errno})");
}
do {
$pkt = stream_socket_recvfrom($socket, 1, 0, $peer);
echo "{$peer}\n";
$listDB = new AlarmListModelDB();
$messageDB = new AlarmMessageModelDB();
$userDB = new AlarmUserModelDB();
$lastId = 0;
while (1) {
//$message = pack("h", '01');
$userId = 1;
$sql = "SELECT * FROM `" . $listDB->getTableName() . "` WHERE `user_id` = ? AND `id` > ? ORDER BY `id` ASC LIMIT 10";
$data = $listDB->getData($sql, array($userId, $lastId));
if (!empty($data)) {
$messageIds = array();
foreach ($data as $key => $val) {
$messageIds[$val['message_id']] = $val['message_id'];
}
$sql = "SELECT * FROM `" . $messageDB->getTableName() . "` WHERE `id` IN ?";
$messageData = $messageDB->getData($sql, array($messageIds));
$messageFkData = array();
foreach ($messageData as $v) {
$messageFkData[$v['id']] = $v;
}
$showArr = array();
/**
*
*@description: android获取client_id 是第三方推送过来的信息, 不能保证 登陆前一定能获取到.. 不阻塞用户登陆, 只有获取到之后再进行更新
*/
public function updateClientId()
{
Switcher::close('masterDbPostOnly');
$username = $_POST['username'];
$clientId = $_POST['client_id'];
$userDB = new AlarmUserModelDB();
if (!empty($username) && !empty($clientId)) {
$sql = "SELECT `id` FROM `" . $userDB->getTableName() . "` WHERE `username` = ?";
$userId = $userDB->getFirst($sql, array($username));
if (!empty($userId)) {
$updateArr = array();
$updateArr['client_id'] = $clientId;
$userDB->update($updateArr, array('id' => $userId));
Message::showSucc('succ');
} else {
Message::showError('no such user');
}
} else {
Message::showError('username or clientid is empty');
}
}
