Api.php 48 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158
  1. <?php
  2. namespace catchAdmin\api\controller;
  3. use catchAdmin\api\service\dispose;
  4. use catchAdmin\tag_history\model\Access;
  5. use catchAdmin\tag_history\model\Dormitory;
  6. use catchAdmin\tag_history\model\TagHistory;
  7. use catchAdmin\worklocation\model\WorkRecord as ModelWorkRecord;
  8. use catcher\base\CatchRequest as Request;
  9. use catcher\CatchResponse;
  10. use catcher\base\CatchController;
  11. use Exception;
  12. use think\facade\Cache;
  13. use \think\facade\Db;
  14. error_reporting(0);
  15. class Api extends CatchController
  16. {
  17. public function report()
  18. {
  19. $token = $_GET['token'];
  20. if (!$token || $token != '22723927C') {
  21. json_fail('缺少token或者token不对');
  22. }
  23. $param = json_decode(optimize_json(file_get_contents("php://input")), true);
  24. debug_log("上报数据",json_encode($param));
  25. if (json_last_error() != 0) {
  26. json_fail('解析异常', json_last_error_msg());
  27. }
  28. $mac = $param['mac'];
  29. if (empty($mac)) {
  30. json_fail('mac地址不存在');
  31. }
  32. $data = [];
  33. foreach ($param['list'] as $item) {
  34. // $onetime= TagHistory::where("mac",$mac)->where('lable',$item['label'])->order("id","desc")->value("time");
  35. $data[] = [
  36. 'mac' => $mac,
  37. 'lable' => $item['label'],
  38. 'rssi' => $item['rssi'],
  39. 'time' => $item['time'],
  40. 'addTime' => time(),
  41. 'move' => $item['move'],
  42. 'step' => empty($item['step']) ? 0 : $item['step'],
  43. 'temperature' => empty($item['temperature']) ? 0 : $item['temperature'],
  44. //告警
  45. 'temperWarn' => empty($item['temperWarn']) ? 00 : $item['temperWarn'],
  46. // "interval_time"=>empty($onetime) ?0:($item['time']-$onetime)
  47. ];
  48. }
  49. $tage = new TagHistory();
  50. $tage->saveAll($data);
  51. json_success('上传成功');
  52. }
  53. //储存数据到redis
  54. public function redis_to_mysql(){
  55. $ues_redis=Cache::store('redis')->handler();
  56. $dispose = new dispose($ues_redis);
  57. $text=null;
  58. while(1){
  59. $jsonData= $ues_redis->rpop("mqtt_data");
  60. if(empty($jsonData)){
  61. sleep(1);
  62. continue;
  63. }
  64. debug_log("InAndOUT",'数据redis'.$jsonData);
  65. $data=json_decode($jsonData,true);
  66. $time=$data['time'];
  67. $mac=$data['devId'];
  68. //存入基站的最新时间
  69. $dispose->setStations($mac,$time);
  70. $list=[];
  71. $text=$text.$data['cnt'];
  72. if(strlen($text)<24){
  73. continue;
  74. }
  75. while(strlen($text)>=24){
  76. $da=substr($text,0,24);
  77. $t1 = substr($da,8,2)=='00'||substr($da,8,2)=='10'||substr($da,8,2)=='01' ? true:false;
  78. $t2 =substr($da,10,6)=="FFFFFF"||substr($da,10,6)=="000000" ?true:false;
  79. if($t1&&$t2){
  80. $label= substr($da,0,8);
  81. $rssi1= substr($da,16,2);
  82. $rssi2= substr($da,18,2);
  83. $rssi3= substr($da,20,2);
  84. $rssi4= substr($da,22,2);
  85. $DA=[
  86. 'mac' => $mac,
  87. 'label' =>$label,
  88. 'rssi1' => hexdec($rssi1),
  89. 'rssi2' => hexdec($rssi2),
  90. 'rssi3' => hexdec($rssi3),
  91. 'rssi4' => hexdec($rssi4),
  92. 'report_time'=>$time
  93. ];
  94. $vs=false;
  95. $history_status=false;
  96. $DA['other_time']=date("Y-m-d H:i:s",$time);
  97. //打印原始的数据日志
  98. debug_log("label_log","cssh: ".json_encode($DA));
  99. if($DA['rssi1']<=85||$DA['rssi2']<=85||$DA['rssi3']<=85||$DA['rssi4']<=85){
  100. //原始数据只要其中有一条信号小于85 都存入redis 历史数据
  101. $history_status=true;
  102. }
  103. if($DA['rssi1']<=72||$DA['rssi2']<=72||$DA['rssi3']<=72||$DA['rssi4']<=72){
  104. //原始数据只要其中有一条信号小于72 都参与计算
  105. $vs=true;
  106. }
  107. $DA['rssi1']=$DA['rssi1']==255?100:$DA['rssi1'];
  108. $DA['rssi2']=$DA['rssi2']==255?100:$DA['rssi2'];
  109. $DA['rssi3']=$DA['rssi3']==255?100:$DA['rssi3'];
  110. $DA['rssi4']=$DA['rssi4']==255?100:$DA['rssi4'];
  111. $DA["rssi1"]=$DA["rssi1"]<=$DA["rssi3"]?$DA["rssi1"]:$DA["rssi3"];
  112. $DA["rssi2"]=$DA["rssi2"]<=$DA["rssi4"]?$DA["rssi2"]:$DA["rssi4"];
  113. /**
  114. * 缓存到redis中历史数据
  115. */
  116. if(substr($da,8,2)=='01'&&$history_status&&$DA["rssi1"]!=$DA["rssi2"]){
  117. debug_log("label_log","cache: ".json_encode($DA));
  118. $diff= $DA["rssi1"]-$DA["rssi2"];
  119. if(abs($diff)>2){
  120. //历史数据朝前和朝后的信号的差值大于2参与存储
  121. $dispose->set_label_history($DA);
  122. }
  123. debug_log("label_log","cache_diff: ".$diff);
  124. }
  125. /**
  126. * 参与计算的数据
  127. */
  128. if($vs&&(substr($da,8,2)=='01')){
  129. try{
  130. $DA= $dispose->check_data($DA);
  131. //处理的数据参与计算
  132. debug_log("label_log","xsj:".json_encode($DA));
  133. $dispose->computeResout($DA);
  134. }catch(Exception $e){
  135. debug_log("InAndOUT","抛出异常:".$e->getMessage());
  136. }
  137. }
  138. $text=substr($text,24);
  139. }else{
  140. $text=substr($text,1);
  141. }
  142. }
  143. }
  144. }
  145. public function redis_to_mysql2(){
  146. $redis=Cache::store('redis')->handler();
  147. // $dispose = new dispose($redis);
  148. $text=null;
  149. while(1){
  150. $jsonData= $redis->rpop("mqtt_data");
  151. if(empty($jsonData)){
  152. sleep(1);
  153. continue;
  154. }
  155. debug_log("920_redis_data",'数据redis'.$jsonData);
  156. $jsonData='{"devId":"20001001","time":1692605425,"imei":"861714055251247","cnt":"A4A8F901FFFFFFFF52FFFF5DD9CFDD01FFFFFF514A534DEB98D34301FFFFFF584858FF1A6A890301FFFFFF5040494A2E33BD1201FFFFFF5255515734CA3F9C01FFFFFFFF4C4B5152A516F901FFFFFFFF4DFFFF52A49DC901FFFFFF584F59FF52A5453901FFFFFF473E4548EB98490301FFFFFF53495055706319AC01FFFFFFFF51FFFF2E3B90C201FFFFFF5548525352A5501901FFFFFF50454F4D52A4BC2901FFFFFF5950FFFFE2B02B2501FFFFFF4F46554B52A4CBC901FFFFFF51404B501A6A566301FFFFFF584B525152A4AC1901FFFFFF534650FF52A5264901FFFFFFFF50FFFF52A4CFD901FFFFFFFF4A57FF52A51ED901FFFFFFFF52FFFFE2B9D59501FFFFFFFF52FFFFEB98AD5301FFFFFFFF4BFFFFEC327C2301FFFFFF504C5255EA5C309E01FFFFFF504B4F4AEC335A4301FFFFFFFF50FF5421E13A9101FFFFFF4E4E4C5034C5E13C01FFFFFF503B4E4A34ABC1AC01FFFFFF4E3F49425DDE252D01FFFFFF4C4C4B485DD841CD01FFFFFFFF4850522E2F0C4201FFFFFFFF5357FFC639206301FFFFFF55545450E2BFAEE501FFFFFFFF52535021DEDEB101FFFFFF4F494FFF52A4FA5901FFFFFFFF5AFF5752A5505901FFFFFFFFFF5852EC33624301FFFFFFFFFF5757E2B5CE6501FFFFFF5750FF5752A4DB0901FFFFFF524C4F4E52A51E5901FFFFFFFF52FFFF52A5168901FFFFFF594DFFFFE98EEC5B01FFFFFF584EFFFF52A4C05901FFFFFFFF4EFFFF34C39FDC01FFFFFFFF51FFFF52A4F77901FFFFFFFF50FF595DD6741D01FFFFFFFF"}';
  157. //{"devId":"637405","time":1691596816,"imei":"863488051843244","cnt":"FFFFFFFFFF00002CFF0000032000005DD9E37D01FFFFFF4EFFFFFF5DDADB3D01FFFFFFFF4EFFFF5DDDFF1D01FFFFFF4FFFFFFFA7"}
  158. $data=json_decode($jsonData,true);
  159. $time=$data['time'];
  160. $mac=$data['devId'];
  161. $list=[];
  162. $text=$text.$data['cnt'];//FFFFFFFFFF00002CFF0000032000005DD9E37D01FFFFFF4EFFFFFF5DDADB3D01FFFFFFFF4EFFFF5DDDFF1D01FFFFFF4FFFFFFFA7
  163. if(strlen($text)<24){
  164. continue;
  165. }
  166. $redis=Cache::store('redis')->handler();
  167. $received_state=$redis->hget('api_receiver_asset_state', 'accessClassReport');
  168. while(strlen($text)>=24){
  169. $str=substr($text,0,24);//FFFFFFFFFF00002CFF000003
  170. var_dump($str);
  171. $t1 = substr($str,8,2)=='00'||substr($str,8,2)=='10'||substr($str,8,2)=='01' ? true:false;
  172. $t2 =substr($str,10,6)=="FFFFFF"||substr($str,10,6)=="000000" ?true:false;
  173. var_dump($t1);
  174. var_dump($t2);
  175. if($t1&&$t2){
  176. $label= substr($str,0,8);
  177. $rssi1= substr($str,16,2);
  178. $rssi2= substr($str,18,2);
  179. $rssi3= substr($str,20,2);
  180. $rssi4= substr($str,22,2);
  181. $report_data=[
  182. 'mac' => $mac,
  183. 'label' =>$label,
  184. 'rssi1' => hexdec($rssi1),
  185. 'rssi2' => hexdec($rssi2),
  186. 'rssi3' => hexdec($rssi3),
  187. 'rssi4' => hexdec($rssi4),
  188. 'report_time'=>$time
  189. ];
  190. var_dump($report_data);
  191. var_dump($received_state);
  192. if($received_state=='1'){
  193. //如果开启盘点 则有数据就推送
  194. $url="http://localhost:8115/api/assetReceiveReport";
  195. $postFields = http_build_query($report_data);
  196. $url_res= curl_http_post($postFields,$url,false);
  197. echo 'assetReceiveReport res'.PHP_EOL;
  198. var_dump($url_res);
  199. }
  200. if($report_data['rssi1']==255 && $report_data['rssi2']!=255){
  201. $report_data['loc']=2;
  202. }elseif($report_data['rssi1']!=255 && $report_data['rssi2']==255){
  203. $report_data['loc']=1;
  204. }
  205. $hashKey='station_access_data';
  206. $key=$mac.'_'.$label;
  207. $old_data=json_decode($redis->hGet($hashKey,$key),true);
  208. if($$old_data){
  209. //取出历史数据 对比两次数据变化
  210. if($old_data['loc']==$report_data['loc']){
  211. //相同 则更新时间
  212. $redis->hSet($hashKey,$key,json_encode($report_data));
  213. }else{
  214. //比较数据时间
  215. //默认新数据更晚上报
  216. $send_data=[
  217. "mac"=>$mac,
  218. "label"=>$label,
  219. 'time'=>$time,
  220. ];
  221. if($report_data['loc']>$old_data['loc']){
  222. //1->2 内到外 出
  223. $send_data['dirt']=2;
  224. }else{
  225. //2>1 外到内 进
  226. $send_data['dirt']=1;
  227. }
  228. //推送数据
  229. $url="http://localhost:8115/api/assetReport";
  230. $postFields = http_build_query($report_data);
  231. $url_res= curl_http_post($postFields,$url,false);
  232. echo 'assetReceiveReport res'.PHP_EOL;
  233. var_dump($url_res);
  234. }
  235. }else{
  236. $redis->hSet($hashKey,$key,json_encode($report_data));
  237. }
  238. $text=substr($text,24);
  239. }else{
  240. $text=substr($text,1);
  241. }
  242. }
  243. }
  244. }
  245. /**
  246. * 清除数据
  247. *
  248. * @return void
  249. */
  250. public function clear_redis(){
  251. //清理超时的标签
  252. while(1){
  253. sleep(1);
  254. $redis=Cache::store('redis')->handler();
  255. $dispose = new dispose($redis);
  256. $keylist= $dispose->getStations();
  257. //获取存储的的基站
  258. debug_log("clear_label","查询数据".json_encode($keylist));
  259. if(empty($keylist)){
  260. continue;
  261. }
  262. foreach($keylist as $station){
  263. //结果key值
  264. $key="res".$station;
  265. //存取旧的数据的reids数据
  266. $catchkey=$station."station";
  267. //获取该基站的所有key
  268. $keys= $redis->hKeys($key);
  269. if(empty($keys)){
  270. continue;
  271. }
  272. foreach($keys as $item){
  273. if( $json_data=$redis->hget($key,$item)){
  274. debug_log("clear_label",'基站'.$station.'获取的数据'.'标签'.$item.$json_data);
  275. $json_data=json_decode($json_data,true);
  276. //列表
  277. $a=$json_data['a'];
  278. //状态
  279. $status=$json_data['status'];
  280. //是否形成进出考勤
  281. $in_and_out=$json_data["in_and_out"];
  282. //总数
  283. $count= count($a);
  284. $time= $dispose->getNowStationTime($station);
  285. debug_log("clear_label","标签最新最新时间". date('Y-m-d H:i:s', $time));
  286. //如果标签间隔超过7s,则超时并判断能否生成进出
  287. if(($time-$json_data["time"])<=7){
  288. debug_log("clear_label", $item.':'. "标签上报间隔没有超过7秒进行跳过");
  289. continue;
  290. }
  291. if($count<5){
  292. //如果信号条数小于等于2条不参与计算,信号条数大于2小于5条,则直接进行判断是否形成进出
  293. if($count>2){
  294. debug_log("clear_label", $item.':'. "标签信号个数等于超过2个,参与计算");
  295. $frist=$a[0]['dirt'];
  296. $end=$a[$count-1]['dirt'];
  297. if($frist!=$end){
  298. debug_log("clear_label", $item.':'. "标签信号个数等于超过2个,参与计算,得出结果:".$frist);
  299. $dispose->network_push($station,$item,$a[$count-1]['time'],$frist==1?1:2);
  300. }else{
  301. debug_log("clear_label", $item.':'. "标签信号个数没有超过2个,全部去清除");
  302. }
  303. }
  304. }else{
  305. //如果信号条数大于5条,则判断最后三条数据的信号强的方向是否和初始方向相反
  306. $front=0;
  307. $back=0;
  308. $res=0;
  309. if($a[$count-3]['dirt']==1){
  310. $front+=1;
  311. }else{
  312. $back+=1;
  313. }
  314. if($a[$count-2]['dirt']==1){
  315. $front+=1;
  316. }else{
  317. $back+=1;
  318. }
  319. if($a[$count-1]['dirt']==1){
  320. $front+=1;
  321. }else{
  322. $back+=1;
  323. }
  324. if($front>$back){
  325. $res=1;
  326. }else{
  327. $res=2;
  328. }
  329. if($status['dirt']!=$res){
  330. //最后三条数据的信号强的方向和初始方向相反,则形成进出考勤
  331. debug_log("clear_label", $item.':'. "最后一个信号,方向相反,得出结果,清除缓存数据");
  332. $dispose->network_push($station,$item,$a[$count-1]['time'],$status['dirt']==1?1:2);
  333. }else{
  334. //最后三条数据的信号强的方向和初始方向不相反,并且在连续的时间内没有生成考勤,则开始第二次判断
  335. if(empty($in_and_out)){
  336. //判断第二次能否生成考勤结果
  337. $res=$dispose->second_create_direction($station,$item);
  338. if(!empty($res)){
  339. //获取该标签的之前最新的考勤,和当前形成考勤时间间隔是否大于10,
  340. //如果大于10则生成考勤结果
  341. $res_time= $dispose->get_time_results($station,$item);
  342. $res_time= empty($res_time)?0:$res_time;
  343. $diff_time=$res['time']-$res_time;
  344. debug_log("clear_label", $item.':'. "间隔时间".$diff_time);
  345. //判断如果结果超过时间
  346. if($diff_time>10){
  347. debug_log("clear_label", $item.':'. "二次生成进出");
  348. $dispose->network_push($station,$item,$res['time'],$res['dirt']);
  349. }
  350. }else{
  351. //二次判断如果也没生成考勤,如果朝前的信号最大强度低于65,
  352. //朝后的信号最大强度也低于65,则记录下来最后的朝向,
  353. //存入没有生成考勤时的初始数据
  354. //获取朝前的最大值
  355. //获取朝后的最大值
  356. $frontMax= $dispose->get_label_history(4,$station,$item);
  357. $backMax= $dispose->get_label_history(5,$station,$item);
  358. $records=false;
  359. if($status['dirt']==1){
  360. $records=$frontMax<65;
  361. }
  362. if($status['dirt']==2){
  363. $records=$backMax<65;
  364. }
  365. if($records){
  366. $dispose->no_check_data($station,$item,$status['dirt'],$a[$count-1]['time'],1);
  367. }
  368. }
  369. }
  370. //二次进出
  371. debug_log("clear_label", $item.':'. "最后一个信号,方向没有变化,清除缓存数据");
  372. }
  373. }
  374. //清除对应的键值对
  375. //清空头部尾部历史
  376. $dispose->get_label_history(3,$station,$item);
  377. $redis->hdel($key,$item);
  378. $redis->hdel($catchkey,$item);
  379. }
  380. }
  381. }
  382. }
  383. }
  384. /**
  385. * 远程推送数据
  386. *
  387. * @return void
  388. */
  389. public function remotePush(){
  390. while(true){
  391. $redis=Cache::store('redis')->handler();
  392. $key="push_data";
  393. $url="http://localhost:8115/api/accessReport";
  394. sleep(2);
  395. while($data=$redis->lPop($key)){
  396. if(!empty($data)){
  397. debug_log($key,"远程推送的数据".$data);
  398. $url_res= curl_http_post($data,$url,false);
  399. $num=1;
  400. while($url_res==false){
  401. $num++;
  402. $url_res= curl_http_post($data,$url,false);
  403. if($num>=3){
  404. debug_log($key,"远程推送的地址".$url);
  405. debug_log($key,"连续推送三次失败,远程推送的数据".$data);
  406. break;
  407. }
  408. }
  409. debug_log($key,"远程返回结果".$url_res);
  410. }
  411. }
  412. }
  413. }
  414. public function redis_to_mysql_parea(){
  415. $ues_redis=Cache::store('redis')->handler();
  416. $text="";
  417. $dispose = new dispose($ues_redis);
  418. while(1){
  419. $jsonData= $ues_redis->rpop("mqtt_data_parea4rssi");
  420. debug_log("pare_InAndOUT",'数据redis'.$jsonData);
  421. if(empty($jsonData)){
  422. debug_log("pare_InAndOUT",'没有数据');
  423. sleep(1);
  424. continue;
  425. }
  426. // debug_log("InAndOUT",$jsonData);
  427. $data=json_decode($jsonData,true);
  428. // debug_log("InAndOUT",$data['cnt']);
  429. $time=$data['time'];
  430. $mac=$data['devId'];
  431. $text=$text.$data['cnt'];
  432. if(strlen($text)<24){
  433. continue;
  434. }
  435. $text = $this->handleMessage($text, $mac, $time, $ues_redis);
  436. }
  437. }
  438. public function redis_to_mysql_indoor(){
  439. $ues_redis=Cache::store('redis')->handler();
  440. $text="";
  441. $dispose = new dispose($ues_redis);
  442. while(1){
  443. $jsonData= $ues_redis->lpop("mqtt_data_indoor4rssi");
  444. debug_log("indoor_InAndOUT",'mqtt数据redis'.$jsonData);
  445. if(!$jsonData){
  446. debug_log("indoor_InAndOUT",'mqtt没有数据');
  447. sleep(1);
  448. continue;
  449. }
  450. // debug_log("InAndOUT",$jsonData);
  451. $data=json_decode($jsonData,true);
  452. // debug_log("InAndOUT",$data['cnt']);
  453. $time=$data['time'];
  454. $mac=$data['devId'];
  455. $text=$text.$data['cnt'];
  456. if(strlen($text)<24){
  457. continue;
  458. }
  459. // var_dump("before",microtime());
  460. $text = $this->handleMessageIndoor($text, $mac, $time, $ues_redis);
  461. // var_dump("after",microtime());
  462. }
  463. }
  464. //打印日志
  465. public function temporary_label_log(){
  466. $redis=Cache::store('redis')->handler();
  467. // $key="temporary_label";
  468. // $list= $redis->HgetAll($key);
  469. // debug_log($key,json_encode($list));
  470. // debug_log($key,"所有的标签");
  471. // foreach($list as $k=>$value){
  472. // debug_log($key,json_encode([$k=>$value]));
  473. // }
  474. // debug_log($key,"所有总数".count($list));
  475. // debug_log($key,"上报的标签");
  476. // $i=0;
  477. // foreach($list as $k=>$value){
  478. // if($value==2){
  479. // debug_log($key,json_encode([$k=>$value]));
  480. // $i++;
  481. // }
  482. // }
  483. // debug_log($key,"正常上报的标签总数".$i);
  484. // debug_log($key,"补出的标签");
  485. // $t=0;
  486. // foreach($list as $k=>$value){
  487. // if($value==3){
  488. // $t++;
  489. // debug_log($key,json_encode([$k=>$value]));
  490. // }
  491. // }
  492. // debug_log($key,"补出的标签总数".$t);
  493. // debug_log($key,"没有上报的的标签");
  494. // $f=0;
  495. // foreach($list as $k=>$value){
  496. // if($value==1){
  497. // debug_log($key,json_encode([$k=>$value]));
  498. // $f++;
  499. // }
  500. // }
  501. // debug_log($key,"没有上报的的标签总数".$f);
  502. // // $redis->del($key);
  503. $dis= new dispose($redis);
  504. $dis->analysisLog();
  505. }
  506. // public function temporary_label($redis,$label,$type){
  507. // $key="temporary_label";
  508. // if($type==1){
  509. // $res= $redis->hGet($key,$label);
  510. // if($res==false){
  511. // $redis->hSet($key,$label,1);
  512. // }
  513. // }else{
  514. // $redis->hSet($key,$label,3);
  515. // }
  516. // }
  517. //消息处理--重点区域
  518. public function handleMessage($text, $mac, $time, $ues_redis){
  519. while(strlen($text)>=24){
  520. $da=substr($text,0,24);
  521. $t1 = substr($da,8,2)=='00'||substr($da,8,2)=='10'||substr($da,8,2)=='01' ? true:false;
  522. $t2 =substr($da,10,6)=="FFFFFF"||substr($da,10,6)=="000000" ?true:false;
  523. if($t1&&$t2){
  524. // var_dump($text);
  525. $rfid= substr($da,0,8);
  526. $rssi1= hexdec(substr($da,16,2));
  527. $rssi2= hexdec(substr($da,18,2));
  528. $rssi3= hexdec(substr($da,20,2));
  529. $rssi4= hexdec(substr($da,22,2));
  530. // $rc1 = ($rssi1 == 255 ? 0 : 1);
  531. // $rc2 = ($rssi2 == 255 ? 0 : 1);
  532. // $rc3 = ($rssi3 == 255 ? 0 : 1);
  533. // $rc4 = ($rssi4 == 255 ? 0 : 1);
  534. $DA=[
  535. 'mac' => $mac,
  536. 'label' =>$rfid,
  537. 'rssi1' => $rssi1,
  538. 'rssi2' => $rssi2,
  539. 'rssi3' => $rssi3,
  540. 'rssi4' => $rssi4,
  541. 'report_time'=>$time
  542. ];
  543. $field = $mac."_".$rfid;
  544. $info = $ues_redis->hget("parea_rfidinfos",$field);
  545. debug_log("pare_InAndOUT","数据:".json_encode($DA,true));
  546. if($rssi1 ==255 && $rssi2 == 255 && $rssi3 == 255 && $rssi4 == 255){
  547. debug_log("pare_InAndOUT","无效数据:".json_encode($DA,true));
  548. }else{
  549. if(!$info){
  550. $info = [
  551. "mac" => $mac,
  552. "id" => $rfid,
  553. "firs_time" => $time,
  554. "time" => $time,
  555. "status" => 2,//2出状态,1进状态
  556. "rssi" => [
  557. [
  558. "front" => $rssi1,
  559. "behind" => $rssi2,
  560. "left" => $rssi3,
  561. "right" => $rssi4,
  562. "time" => $time
  563. ]
  564. ]
  565. ];
  566. $ues_redis->hset("parea_rfidinfos",$field, json_encode($info,true));
  567. debug_log("parea_rfidinfos_redis_set_record","redis更新记录".json_encode($info,true));
  568. }else{
  569. $info = json_decode($info,true);
  570. $config = $ues_redis->hget("anbang_four_wire", $info["mac"]);
  571. if (!$config) {
  572. # code...
  573. $config = [
  574. "front_in" => 80,
  575. "behind_in" => 80,
  576. "left_in" => 80,
  577. "right_in" => 80,
  578. "front_out" => 255,
  579. "behind_out" => 255,
  580. "left_out" => 255,
  581. "right_out" => 255,
  582. "expInt" => 12,
  583. "effSigNum" => 6
  584. ];
  585. }else{
  586. $config = json_decode($config,true);
  587. }
  588. // var_dump("+++++++++++++++++",$config);
  589. $info["time"] = $time;
  590. $newRssi = [
  591. "front" => $rssi1,
  592. "behind" => $rssi2,
  593. "left" => $rssi3,
  594. "right" => $rssi4,
  595. "time" => $time
  596. ];
  597. $rssisArr = $info["rssi"];
  598. // var_dump("+++++++++++++++++", $time, $newRssi["time"]);
  599. foreach ($rssisArr as $k => $v) {
  600. # code...
  601. if( ($time - $v["time"] ) > $config['expInt'] ){
  602. unset($rssisArr[$k]);
  603. }
  604. }
  605. // var_dump("+++++++++++++++++",$rssisArr);
  606. if(count($rssisArr) == $config['effSigNum']){
  607. array_shift($rssisArr);
  608. array_push($rssisArr, $newRssi);
  609. }else{
  610. array_push($rssisArr, $newRssi);
  611. }
  612. $rssisArr =array_values($rssisArr);
  613. // var_dump("+++++++++++++++++",$rssisArr);
  614. $info["rssi"] = $rssisArr;
  615. // var_dump("------------",$info["rssi"]);
  616. $cacCount = count($rssisArr);
  617. // if($cacCount > $EFF_SIG_NUM){
  618. $sum1 = 0;
  619. $sum2 = 0;
  620. $sum3 = 0;
  621. $sum4 = 0;
  622. foreach ($rssisArr as $k => $v) {
  623. # code...
  624. $sum1 += ($v["front"] == 255 ? 90 : $v["front"]);
  625. $sum2 += ($v["behind"] == 255 ? 90 : $v["behind"]);
  626. $sum3 += ($v["left"] == 255 ? 90 : $v["left"]);
  627. $sum4 += ($v["right"] == 255 ? 90 : $v["right"]);
  628. }
  629. $info["avg"] = [
  630. "front" => number_format( $sum1/$cacCount, 2 ),
  631. "behind" => number_format( $sum2/$cacCount, 2 ),
  632. "left" => number_format( $sum3/$cacCount, 2 ),
  633. "right" => number_format( $sum4/$cacCount, 2 ),
  634. ];
  635. // var_dump($cacCount, $EFF_SIG_NUM, "dddddddd");
  636. if ($cacCount == $config['effSigNum']) {
  637. # code...
  638. $info = $this->compAndPush($info ,$config, $ues_redis);
  639. }
  640. $ues_redis->hset("parea_rfidinfos",$field, json_encode($info,true));
  641. debug_log("parea_rfidinfos_redis_set_record","redis更新记录".json_encode($info,true));
  642. }
  643. }
  644. $text=substr($text,24);
  645. }else{
  646. $text=substr($text,1);
  647. }
  648. }
  649. return $text ?$text : "";
  650. }
  651. //消息处理--室内
  652. public function handleMessageIndoor($text, $mac, $time, $ues_redis){
  653. while(strlen($text)>=24){
  654. $da=substr($text,0,24);
  655. $t1 = substr($da,8,2)=='00'||substr($da,8,2)=='10'||substr($da,8,2)=='01' ? true:false;
  656. $t2 =substr($da,10,6)=="FFFFFF"||substr($da,10,6)=="000000" ?true:false;
  657. if($t1&&$t2){
  658. // var_dump($text);
  659. $rfid= substr($da,0,8);
  660. $rssi1= hexdec(substr($da,16,2));
  661. $rssi2= hexdec(substr($da,18,2));
  662. $rssi3= hexdec(substr($da,20,2));
  663. $rssi4= hexdec(substr($da,22,2));
  664. $DA=[
  665. 'mac' => $mac,
  666. 'label' =>$rfid,
  667. 'rssi1' => $rssi1,
  668. 'rssi2' => $rssi2,
  669. 'rssi3' => $rssi3,
  670. 'rssi4' => $rssi4,
  671. 'report_time'=>$time
  672. ];
  673. $field = $mac."_".$rfid;
  674. $info = $ues_redis->hget("indoor_rfidinfos",$field);
  675. debug_log("indoor_InAndOUT","数据:".json_encode($DA,true));
  676. if($rssi1 ==255 && $rssi2 == 255 && $rssi3 == 255 && $rssi4 == 255){
  677. debug_log("indoor_InAndOUT","无效数据:".json_encode($DA,true));
  678. }else{
  679. if(!$info){
  680. $info = [
  681. "mac" => $mac,
  682. "id" => $rfid,
  683. "first_time" => $time,
  684. "time" => $time,
  685. "status" => 2,//2出状态,1进状态
  686. "rssi" => [
  687. [
  688. "front" => $rssi1,
  689. "behind" => $rssi2,
  690. "left" => $rssi3,
  691. "right" => $rssi4,
  692. "time" => $time
  693. ]
  694. ]
  695. ];
  696. $ues_redis->hset("indoor_rfidinfos",$field, json_encode($info,true));
  697. debug_log("indoor_rfidinfos_redis_set_record","redis更新记录".json_encode($info,true));
  698. }else{
  699. $info = json_decode($info,true);
  700. $config = $ues_redis->hget("anbang_four_wire", $info["mac"]);
  701. if (!$config) {
  702. # code...
  703. $config = [
  704. "front_in" => 80,
  705. "behind_in" => 80,
  706. "left_in" => 80,
  707. "right_in" => 80,
  708. "front_out" => 255,
  709. "behind_out" => 255,
  710. "left_out" => 255,
  711. "right_out" => 255,
  712. "expInt" => 12,
  713. "effSigNum" => 6
  714. ];
  715. }else{
  716. $config = json_decode($config,true);
  717. }
  718. // var_dump("+++++++++++++++++",$config);
  719. $info["time"] = $time;
  720. $newRssi = [
  721. "front" => $rssi1,
  722. "behind" => $rssi2,
  723. "left" => $rssi3,
  724. "right" => $rssi4,
  725. "time" => $time
  726. ];
  727. $rssisArr = $info["rssi"];
  728. // var_dump("+++++++++++++++++", $time, $newRssi["time"]);
  729. foreach ($rssisArr as $k => $v) {
  730. # code...
  731. if( ($time - $v["time"] ) > $config['expInt'] ){
  732. unset($rssisArr[$k]);
  733. }
  734. }
  735. // var_dump("+++++++++++++++++",$rssisArr);
  736. if(count($rssisArr) == $config['effSigNum']){
  737. array_shift($rssisArr);
  738. array_push($rssisArr, $newRssi);
  739. }else{
  740. array_push($rssisArr, $newRssi);
  741. }
  742. $rssisArr =array_values($rssisArr);
  743. // var_dump("+++++++++++++++++",$rssisArr);
  744. $info["rssi"] = $rssisArr;
  745. // var_dump("------------",$info["rssi"]);
  746. $cacCount = count($rssisArr);
  747. // if($cacCount > $EFF_SIG_NUM){
  748. $sum1 = 0;
  749. $sum2 = 0;
  750. $sum3 = 0;
  751. $sum4 = 0;
  752. foreach ($rssisArr as $k => $v) {
  753. # code...
  754. $sum1 += ($v["front"] == 255 ? 90 : $v["front"]);
  755. $sum2 += ($v["behind"] == 255 ? 90 : $v["behind"]);
  756. $sum3 += ($v["left"] == 255 ? 90 : $v["left"]);
  757. $sum4 += ($v["right"] == 255 ? 90 : $v["right"]);
  758. }
  759. $info["avg"] = [
  760. "front" => number_format( $sum1/$cacCount, 2 ),
  761. "behind" => number_format( $sum2/$cacCount, 2 ),
  762. "left" => number_format( $sum3/$cacCount, 2 ),
  763. "right" => number_format( $sum4/$cacCount, 2 ),
  764. ];
  765. // var_dump($cacCount, $EFF_SIG_NUM, "dddddddd");
  766. if ($cacCount == $config['effSigNum']) {
  767. # code...
  768. $info = $this->compAndPushIndoor($info ,$config, $ues_redis);
  769. }
  770. $ues_redis->hset("indoor_rfidinfos",$field, json_encode($info,true));
  771. debug_log("indoor_rfidinfos_redis_set_record","redis更新记录".json_encode($info,true));
  772. }
  773. }
  774. $text=substr($text,24);
  775. }else{
  776. $text=substr($text,1);
  777. }
  778. }
  779. return $text ?$text : "";
  780. }
  781. //判断进出和推送--室内考勤
  782. public function compAndPushIndoor($info, $config, $ues_redis){
  783. //标签多,数据多时候,判断完成后放入redis,异步推送,当前暂时直接推
  784. // $config = $ues_redis->hget("anbang_four_wire", $info["mac"]);
  785. //{"front_in":44,"front_out":44,"behind_in":50,"behind_out":50,"left_in":55,"left_out":55,"right_out":44,"right_out":44}
  786. $avg = $info['avg'];
  787. $status = $info['status'];
  788. $flagIn = $avg["front"] < $config["front_in"] || $avg["behind"] < $config["behind_in"] || $avg["left"] < $config["left_in"] || $avg["right"] < $config["right_in"];
  789. $flagOut = $avg["front"] > $config["front_out"] && $avg["behind"] > $config["behind_out"] && $avg["left"] > $config["left_out"] && $avg["right"] > $config["right_out"];
  790. $url="http://localhost:8115/api/api/accessClassReport";
  791. // $url="http://61.175.203.188:10001/api/accessClassReport";
  792. // if($flagIn && $status == 2){
  793. if($flagIn){
  794. if ($info["pushTime"] && (time()-$info['pushTime']) < 120 ) {
  795. # code...
  796. return $info;
  797. }
  798. //推送进
  799. $info['status'] = 1;
  800. $url_data = [
  801. "mac" => $info["mac"],
  802. "data" => [
  803. [
  804. "label" => $info["id"],
  805. "time" => $info["time"],
  806. "dirt" => 1,
  807. "rssi" => $info["rssi"],//数组 [{"front":72,"behind":255,"left":255,"right":255,"time":1685067709},{"front":76,"behind":255,"left":255,"right":255,"time":1685067710}]
  808. "avg" => $info["avg"] //{"front":"77.17","behind":"90.00","left":"90.00","right":"90.00"}
  809. ]
  810. ]
  811. ];
  812. $ues_redis->lpush("indoor_inoutres_push", json_encode($url_data));
  813. $info['pushTime'] = time();
  814. // debug_log("push_indoor_res","进推送依赖:".json_encode($info));
  815. // $url_res= curl_http_post(json_encode($url_data),$url,false);
  816. // debug_log("push_indoor_res","远程返回结果".$url_res);
  817. }
  818. // if($info['id'] == "E2B15AD5"){
  819. // var_dump($flagIn, $flagOut, $status, $avg["front"],$avg["behind"],$avg["left"], $avg["right"]);
  820. // }
  821. if($flagOut && $status == 1){
  822. if ($info["pushTime"] && (time()-$info['pushTime']) < 5 ) {
  823. # code...
  824. return $info;
  825. }
  826. //推送出
  827. $info['status'] = 2;
  828. $url_data = [
  829. "mac" => $info["mac"],
  830. "data" => [
  831. [
  832. "label" => $info["id"],
  833. "time" => $info["time"],
  834. "dirt" => 2,
  835. "rssi" => $info["rssi"],//数组 [{"front":72,"behind":255,"left":255,"right":255,"time":1685067709},{"front":76,"behind":255,"left":255,"right":255,"time":1685067710}]
  836. "avg" => $info["avg"] //{"front":"77.17","behind":"90.00","left":"90.00","right":"90.00"}
  837. ]
  838. ]
  839. ];
  840. $ues_redis->lpush("indoor_inoutres_push", json_encode($url_data));
  841. // debug_log("push_indoor_res","出推送依赖:".json_encode($info));
  842. // $url_res= curl_http_post(json_encode($url_data),$url,false);
  843. $info['pushTime'] = time();
  844. // debug_log("push_indoor_res","远程返回结果".$url_res);
  845. }
  846. return $info;
  847. }
  848. //判断进出和推送
  849. public function compAndPush($info, $config,$ues_redis){
  850. //标签多,数据多时候,判断完成后放入redis,异步推送,当前暂时直接推
  851. $avg = $info['avg'];
  852. $status = $info['status'];
  853. $flagIn = $avg["front"] < $config["front_in"] || $avg["behind"] < $config["behind_in"] || $avg["left"] < $config["left_in"] || $avg["right"] < $config["right_in"];
  854. $flagOut = $avg["front"] > $config["front_out"] && $avg["behind"] > $config["behind_out"] && $avg["left"] > $config["left_out"] && $avg["right"] > $config["right_out"];
  855. if($flagIn && $status == 2){
  856. // if($flagIn){
  857. $inoutIntFilter = $ues_redis->hget("anbang_four_wire", "anbang_4rssi_intFilter");
  858. $inoutIntFilter = $inoutIntFilter ? $inoutIntFilter : 20;
  859. if ($info["pushTime"] && (time()-$info['pushTime']) < $inoutIntFilter ) {
  860. # code...
  861. return $info;
  862. }
  863. //推送进
  864. $info['status'] = 1;
  865. $url_data = [
  866. "mac" => $info["mac"],
  867. "data" => [
  868. [
  869. "label" => $info["id"],
  870. "time" => $info["time"],
  871. "first_time" => $info["first_time"],
  872. "dirt" => 1,
  873. "rssi" => $info["rssi"],//数组 [{"front":72,"behind":255,"left":255,"right":255,"time":1685067709},{"front":76,"behind":255,"left":255,"right":255,"time":1685067710}]
  874. "avg" => $info["avg"] //{"front":"77.17","behind":"90.00","left":"90.00","right":"90.00"}
  875. ]
  876. ]
  877. ];
  878. // debug_log("pushPareaRes","进推送依赖:".json_encode($info));
  879. // $url_res= curl_http_post(json_encode($url_data),$url,false);
  880. $ues_redis->lpush("parea_inoutres_push", json_encode($url_data));
  881. $info['pushTime'] = time();
  882. // debug_log("pushPareaRes","远程返回结果".$url_res);
  883. }
  884. // if($info['id'] == "E2B15AD5"){
  885. // var_dump($flagIn, $flagOut, $status, $avg["front"],$avg["behind"],$avg["left"], $avg["right"]);
  886. // }
  887. if($flagOut && $status == 1){
  888. if ($info["pushTime"] && (time()-$info['pushTime']) < 5 ) {
  889. # code...
  890. return $info;
  891. }
  892. //推送出
  893. $info['status'] = 2;
  894. $url_data = [
  895. "mac" => $info["mac"],
  896. "data" => [
  897. [
  898. "label" => $info["id"],
  899. "time" => $info["time"],
  900. "dirt" => 2,
  901. "rssi" => $info["rssi"],//数组 [{"front":72,"behind":255,"left":255,"right":255,"time":1685067709},{"front":76,"behind":255,"left":255,"right":255,"time":1685067710}]
  902. "avg" => $info["avg"] //{"front":"77.17","behind":"90.00","left":"90.00","right":"90.00"}
  903. ]
  904. ]
  905. ];
  906. // debug_log("pushPareaRes","出推送依赖:".json_encode($info));
  907. // $url_res= curl_http_post(json_encode($url_data),$url,false);
  908. $ues_redis->lpush("parea_inoutres_push", json_encode($url_data));
  909. $info['pushTime'] = time();
  910. // debug_log("pushPareaRes","远程返回结果".$url_res);
  911. }
  912. if($flagIn && $info['status'] == 1){
  913. $inoutIntFilter = $ues_redis->hget("anbang_four_wire", "anbang_4rssi_intFilter");
  914. $inoutIntFilter = $inoutIntFilter ? $inoutIntFilter : 20;
  915. if ($info["camPushTime"] && (time()-$info['camPushTime']) < $inoutIntFilter ) {
  916. # code...
  917. return $info;
  918. }
  919. //推送进
  920. $url_data = [
  921. "mac" => $info["mac"],
  922. "first_time" => $info["first_time"],
  923. "data" => [
  924. [
  925. "label" => $info["id"],
  926. "time" => $info["time"],
  927. "dirt" => 1,
  928. "rssi" => $info["rssi"],//数组 [{"front":72,"behind":255,"left":255,"right":255,"time":1685067709},{"front":76,"behind":255,"left":255,"right":255,"time":1685067710}]
  929. "avg" => $info["avg"] //{"front":"77.17","behind":"90.00","left":"90.00","right":"90.00"}
  930. ]
  931. ]
  932. ];
  933. $ues_redis->lpush("parea_inoutres_push", json_encode($url_data));
  934. $info["camPushTime"] = time();
  935. }
  936. return $info;
  937. }
  938. public function test(){
  939. try{
  940. $ues_redis=Cache::store('redis')->handler();
  941. $jsonData= $ues_redis->rpop("mqtt_data");
  942. debug_log("InAndOUT","1212");
  943. }catch(Exception $e){
  944. var_dump($e->getMessage());
  945. }
  946. }
  947. /**
  948. * 删除前1天的数据
  949. *
  950. * @return void
  951. */
  952. public function deleteHistory()
  953. {
  954. while(true)
  955. {
  956. $where[] = ['addTime','<',strtotime("-1 day")];
  957. Db::name('tag_history')->where($where)->delete();
  958. sleep(60*60*24);
  959. }
  960. }
  961. /**
  962. * 检测小程序版本版本 function
  963. *
  964. * @return void
  965. */
  966. public function detectionVersion(){
  967. $token = $_GET['token'];
  968. if (!$token || $token != '444333d3') {
  969. json_fail('缺少token或者token不对');
  970. }
  971. $data["url"]="http://116.62.220.88:8112/static/app/蓝牙小程序/1.1.1/rl-release.apk";
  972. $data["version"]="1.1.1";
  973. json_success("查询版本成功",$data);
  974. }
  975. }