card.cpp 28 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982
  1. #include <memory>
  2. #include <log.h>
  3. #include <zloop.h>
  4. #include "select_tool.h"
  5. #include "loc_tool.h"
  6. #include <area.h>
  7. #include <site_area.h>
  8. #include <card.h>
  9. #include "config_file.h"
  10. #include "db_api/CDBConnPool.h"
  11. #include "websocket/wsTimerThread.h"
  12. #include "websocket/wsClientMgr.h"
  13. #include "timestamp.h"
  14. #include "monkey_car/monkeycar_area.h"
  15. #include "monkey_car/monkeycar_person.h"
  16. #include "special_area.h"
  17. #include "cardMgr.h"
  18. #include "ant.h"
  19. #include "mine.h"
  20. #include "module_service/module_mgr.h"
  21. #include "visit.h"
  22. #include "his_location.h"
  23. extern config_file config;
  24. //一张卡一个ct的所有不同天线的信息
  25. struct one_ct_message_handle
  26. {
  27. static loc_tool_main m_loc_tool;
  28. ev::timer m_min_timer,m_max_timer;
  29. //loc_message.
  30. std::vector<loc_message> m_msg_list;
  31. card_location_base*m_card;
  32. const algo_config*m_ac=nullptr;
  33. int m_ct;
  34. bool m_min_timeout=false;
  35. ev::dynamic_loop * m_loop = nullptr;
  36. one_ct_message_handle(card_location_base*card)
  37. {
  38. m_card=card;
  39. m_ct=-1;
  40. }
  41. void reset()
  42. {
  43. m_ct=-1;
  44. m_min_timeout=false;
  45. m_msg_list.clear();
  46. }
  47. void on_min_timer()
  48. {
  49. m_min_timer.stop();
  50. if((int)m_msg_list.size()>=m_ac->best_msg_cnt)
  51. {
  52. m_max_timer.stop();
  53. calc_location();
  54. return;
  55. }
  56. m_min_timeout=true;
  57. }
  58. void on_max_timer()
  59. {
  60. m_max_timer.stop();
  61. calc_location();
  62. }
  63. void set(ev::dynamic_loop * loop)
  64. {
  65. m_loop = loop;
  66. m_min_timer.set(*m_loop);
  67. m_min_timer.set<one_ct_message_handle,&one_ct_message_handle::on_min_timer>(this);
  68. m_max_timer.set(*m_loop);
  69. m_max_timer.set<one_ct_message_handle,&one_ct_message_handle::on_max_timer>(this);
  70. }
  71. void on_message(ev::dynamic_loop *loop,const message_locinfo&loc)
  72. {
  73. if(m_loop == nullptr && loop!=nullptr)
  74. set(loop);
  75. else if(loop == nullptr)
  76. return;
  77. if(!m_msg_list.empty()&& m_ct!=loc.m_card_ct)
  78. {
  79. m_msg_list.clear();
  80. }
  81. auto sitPtr = sit_list::instance()->get(loc.m_site_id);
  82. if(sitPtr==nullptr)
  83. {
  84. log_warn("分站信息缺失,SitId:%d",loc.m_site_id);
  85. return;
  86. }
  87. const site &s=*(sit_list::instance()->get(loc.m_site_id));
  88. if(m_msg_list.empty())
  89. {
  90. m_ct=loc.m_card_ct;
  91. m_ac=&s.config();
  92. m_min_timeout=false;
  93. //这里构造loc_message 保存数据
  94. m_msg_list.push_back(loc_message(s,loc.m_tof,loc.m_time_stamp,loc.m_card_id,
  95. loc.m_card_ct,loc.m_card_type,loc.m_ant_id,loc.m_rav,loc.m_acc,
  96. loc.m_sync_ct,loc.m_rssi));
  97. //启动本CT的最小、最大两个定时器
  98. m_min_timer.start(m_ac->min_wait_time);
  99. m_max_timer.start(m_ac->min_wait_time);
  100. return;
  101. }
  102. m_msg_list.push_back(loc_message(s,loc.m_tof,loc.m_time_stamp,loc.m_card_id,
  103. loc.m_card_ct,loc.m_card_type,loc.m_ant_id,loc.m_rav,loc.m_acc,
  104. loc.m_sync_ct,loc.m_rssi));
  105. if(m_min_timeout && (int)m_msg_list.size()>=m_ac->best_msg_cnt)
  106. {
  107. calc_location();
  108. m_max_timer.stop();
  109. }
  110. }
  111. void calc_location()
  112. {
  113. auto v = m_msg_list;
  114. std::vector<point> rc=std::move(m_loc_tool.calc_location(v));
  115. if(!rc.empty()) m_card->on_location(std::move(rc),v);
  116. reset();
  117. }
  118. };
  119. struct card_message_handle
  120. {
  121. card_location_base*m_card;
  122. std::array<one_ct_message_handle*,16> m_ct_list;
  123. card_message_handle(card_location_base*card)
  124. {
  125. m_card=card;
  126. for(size_t i=0;i<m_ct_list.size();i++)
  127. {
  128. m_ct_list[i]=new one_ct_message_handle(card);
  129. }
  130. }
  131. ~card_message_handle()
  132. {
  133. for(auto&it:m_ct_list)
  134. {
  135. delete it;
  136. }
  137. }
  138. void on_message(zloop<task*> * loop,const message_locinfo&loc,bool is_history)
  139. {
  140. if(is_history)
  141. {
  142. log_warn("%s","当前代码没有处理历史消息记录。");
  143. return;
  144. }
  145. //
  146. m_card->site_hover(loc.m_site_id);
  147. if(loc.m_batty_status == 2)
  148. {
  149. m_card->do_status(STATUS_POWER_LOWER_SERIOUS);
  150. }
  151. else
  152. {
  153. m_card->do_status(STATUS_POWER_NOMARL);
  154. }
  155. if(loc.m_callinfo & 0x80)
  156. {
  157. m_card->do_status(STATUS_HELP);
  158. }
  159. if((loc.m_callinfo & 0x01) || (loc.m_callinfo & 0x02))
  160. {
  161. m_card->do_status(STATUS_CALL);
  162. }
  163. m_ct_list[loc.m_card_ct&(m_ct_list.size()-1)]->on_message(loop,loc);
  164. }
  165. };
  166. struct card_area
  167. {
  168. card_area()
  169. {
  170. m_site_area.reset(new site_area_hover);
  171. m_area_tool.reset(new area_tool);
  172. m_mine_tool.reset(new mine_tool);
  173. }
  174. std::shared_ptr<site_area_hover> m_site_area=nullptr;
  175. std::shared_ptr<area_tool> m_area_tool=nullptr;
  176. std::shared_ptr<mine_tool> m_mine_tool=nullptr;
  177. };
  178. struct person:card_location_base, card_area
  179. {
  180. std::weak_ptr<monkey_person> m_monkeyPerson;
  181. person(std::string type,uint32_t cardid,uint16_t needdisplay,int16_t t,int32_t deptid,int32_t level_id)
  182. :card_location_base(type,cardid,needdisplay,t,deptid,level_id)
  183. {
  184. m_message_handle.reset(new card_message_handle(this));
  185. m_his_location_card.reset(new location_staff(m_id,m_type));
  186. }
  187. void on_message(zloop<task*> * loop,const message_locinfo&loc,bool is_history)
  188. {
  189. m_message_handle->on_message(loop,loc,is_history);
  190. }
  191. void clear()
  192. {
  193. m_site_area.reset(new site_area_hover);
  194. m_area_tool.reset(new area_tool);
  195. m_mine_tool.reset(new mine_tool);
  196. card_location_base::clear();
  197. }
  198. virtual void site_hover(int sid)
  199. {
  200. if(m_time<=0)
  201. {
  202. return;
  203. }
  204. m_site_area->on_point(m_id,sid,nullptr, m_type);
  205. }
  206. virtual std::shared_ptr<area_hover> get_area_hover()
  207. {
  208. return m_area_tool->m_area_hover;
  209. }
  210. virtual std::shared_ptr<mine_tool> get_mine_tool()
  211. {
  212. return m_mine_tool;
  213. }
  214. virtual std::shared_ptr<site_area_hover> get_site_area()
  215. {
  216. return m_site_area;
  217. }
  218. virtual void do_business(const point &pt)
  219. {
  220. m_area_tool->on_point(m_id,pt,m_speed,m_type);
  221. m_site_area->on_point(m_id,0,this, m_type);
  222. }
  223. void reset(std::shared_ptr<monkey_person> mp)
  224. {
  225. m_monkeyPerson = mp;
  226. }
  227. ~person(){}
  228. private:
  229. void on_timer()
  230. {
  231. if(!m_mine_tool->is_attendance())
  232. return;
  233. YA::_CARD_POS_ cp;
  234. uint64_t _time=0;
  235. point pt = getSmoothPoint(_time);
  236. const auto lm = m_area_tool->getLandmark();
  237. cp.enter_area_time = std::get<0>(lm)*1000;
  238. cp.rec_time = std::get<1>(lm);
  239. int32_t map_id = std::get<2>(lm);
  240. int32_t area_id = std::get<3>(lm);
  241. cp.map_id=map_id;cp.area_id=area_id;
  242. cp.landmark_id = std::get<4>(lm);
  243. cp.lm_direction = std::get<5>(lm);
  244. cp.landmark_dis=std::get<6>(lm);
  245. cp.biz_stat = get_stat();
  246. cp.down_time = m_mine_tool->get_down_time();
  247. cp.work_time = m_mine_tool->get_work_time();
  248. cp.is_on_duty= m_mine_tool->is_on_duty();
  249. m_his_location_card->push(_time,pt,area_id,map_id);
  250. upt_card_pos(cp,pt);
  251. }
  252. point getSmoothPoint(uint64_t t)
  253. {
  254. point pt;
  255. loc_point lp = m_smo_tool->smooth_strategy();
  256. m_speed = lp.m_speed;
  257. m_stat = lp.m_stat;
  258. pt.x = lp.x;
  259. pt.y = -lp.y;
  260. t=lp.m_time;
  261. if(auto p = m_monkeyPerson.lock() )
  262. {
  263. if(p->is_on_bus())
  264. {
  265. m_stat = 7;
  266. pt = p->getPoint(t);
  267. }
  268. }
  269. return pt;
  270. }
  271. };
  272. struct car:card_location_base,card_area
  273. {
  274. int m_vehicle_category_id=0;
  275. int m_vehicle_type_id=0;
  276. car(std::string type,uint32_t cardid,uint16_t needdisplay,int16_t t,int32_t deptid,
  277. int32_t categoryid, int type_id,int32_t level_id)
  278. :card_location_base(type,cardid,needdisplay,t,deptid,level_id)
  279. ,m_vehicle_category_id(categoryid)
  280. ,m_vehicle_type_id(type_id)
  281. {
  282. m_message_handle.reset(new card_message_handle(this));
  283. m_his_location_card.reset(new location_vehicle(m_id,m_type));
  284. }
  285. virtual void site_hover(int sid)
  286. {
  287. if(m_time<=0)
  288. {
  289. return;
  290. }
  291. m_site_area->on_point(m_id,sid,0, m_type);
  292. }
  293. virtual std::shared_ptr<area_hover> get_area_hover()
  294. {
  295. return m_area_tool->m_area_hover;
  296. }
  297. virtual std::shared_ptr<mine_tool> get_mine_tool()
  298. {
  299. return m_mine_tool;
  300. }
  301. virtual std::shared_ptr<site_area_hover> get_site_area()
  302. {
  303. return m_site_area;
  304. }
  305. virtual void do_business(const point &pt)
  306. {
  307. m_area_tool->on_point(m_id,pt,m_speed,m_type);
  308. m_site_area->on_point(m_id,0,this, m_type);
  309. m_mine_tool->on_point(m_id, m_type, m_vehicle_category_id);
  310. }
  311. int get_vehicle_type_id()
  312. {
  313. return m_vehicle_type_id;
  314. }
  315. ~car(){}
  316. private:
  317. void on_timer()
  318. {
  319. make_package();
  320. }
  321. int statbiz(int32_t special_id)
  322. {
  323. int status = get_stat();
  324. if(status == STATUS_LOST)
  325. {
  326. if(!m_area_tool->special_area())
  327. {
  328. special_id = special_area_list::instance()->get_special_id(m_id,*this,m_vehicle_category_id);
  329. log_info("enter_special_area:%.2f,%2.f,id:%d,special_area_id:%d",x,y,m_id,special_id);
  330. if(special_id != -1)
  331. m_area_tool->change_area(m_id,m_speed,m_type,special_id);//自动拖车
  332. }
  333. }
  334. return status;
  335. }
  336. void make_package()
  337. {
  338. int32_t special_id=-1;
  339. YA::_CARD_POS_ cp;
  340. loc_point pt = getSmoothPoint();
  341. const auto lm = m_area_tool->getLandmark();
  342. cp.enter_area_time = std::get<0>(lm);
  343. cp.rec_time = std::get<1>(lm);
  344. uint32_t map_id = std::get<2>(lm);
  345. uint32_t area_id = std::get<3>(lm);
  346. cp.map_id =map_id;cp.area_id=area_id;
  347. cp.landmark_id = std::get<4>(lm);
  348. cp.lm_direction = std::get<5>(lm);
  349. cp.landmark_dis=std::get<6>(lm);
  350. int32_t biz_stat=statbiz(special_id);
  351. cp.biz_stat=biz_stat;
  352. cp.down_time = m_mine_tool->get_down_time();
  353. cp.work_time = m_mine_tool->get_work_time();
  354. //for now
  355. cp.is_on_duty=m_mine_tool->is_on_duty();
  356. upt_card_pos(cp,pt);
  357. m_his_location_card->push(pt.m_time,pt,area_id,map_id);
  358. if(biz_stat==STATUS_LOST && special_id != -1 && m_display==1)
  359. {
  360. cp.area_id = special_id;
  361. swsClientMgr.SendSpecialAreaProcess(cp);
  362. }
  363. }
  364. loc_point getSmoothPoint()
  365. {
  366. loc_point lp = m_smo_tool->smooth_strategy();
  367. m_speed = lp.m_speed;
  368. m_stat = lp.m_stat;
  369. lp.y = -lp.y;
  370. return lp;
  371. }
  372. };
  373. loc_tool_main one_ct_message_handle::m_loc_tool;
  374. uint64_t card_list::getId(uint32_t cardid,uint64_t type)
  375. {
  376. return type<<32|cardid;
  377. }
  378. void card_list::init_vehicle()
  379. {
  380. std::unordered_map<uint64_t,std::shared_ptr<card_location_base>> map;
  381. std::string strategy = config.get("car.strategy","car1");
  382. const char *sql = "SELECT ve.vehicle_id, ve.card_id, c.card_type_id, \
  383. ve.dept_id, ve.group_id, v.vehicle_type_id, vt.vehicle_level_id, \
  384. vt.is_railroad AS vt_is_railroad,ve.need_display ,ve.power_alarm,\
  385. vt.vehicle_category_id,v.bigger_car_flag,vc.over_speed \
  386. FROM dat_vehicle_extend ve \
  387. LEFT JOIN dat_vehicle v ON ve.vehicle_id = v.vehicle_id \
  388. LEFT JOIN dat_card c ON ve.card_id = c.card_id \
  389. LEFT JOIN dat_dept d ON ve.dept_id = d.dept_id \
  390. LEFT JOIN dat_group g ON ve.group_id = g.group_id \
  391. LEFT JOIN dat_vehicle_type vt ON v.vehicle_type_id = vt.vehicle_type_id \
  392. LEFT JOIN dat_vehicle_category vc ON vc.vehicle_category_id = vt.vehicle_category_id \
  393. WHERE c.card_type_id = 2 AND c.state_id = 0;";
  394. std::string Error;
  395. YADB::CDBResultSet DBRes;
  396. sDBConnPool.Query(sql,DBRes,Error);
  397. int nCount = DBRes.GetRecordCount( Error );
  398. if (nCount > 0)
  399. {
  400. log_info( "init_staffer. The record count=%d\n", nCount );
  401. while ( DBRes.GetNextRecod(Error) )
  402. {
  403. unsigned int vehicle_id = 0;
  404. DBRes.GetField( "vehicle_id",vehicle_id, Error );
  405. std::string card_id;
  406. DBRes.GetField( "card_id",card_id, Error );
  407. uint32_t vsid = atoi(card_id.substr(3).c_str());
  408. unsigned int card_type_id = 0;
  409. DBRes.GetField( "card_type_id",card_type_id, Error );
  410. int dept_id = 0;
  411. DBRes.GetField( "dept_id",dept_id, Error );
  412. int group_id = 0;
  413. DBRes.GetField( "group_id",group_id, Error );
  414. int vehicle_type_id = 0;
  415. DBRes.GetField( "vehicle_type_id",vehicle_type_id, Error );
  416. int vehicle_level_id = 0;
  417. DBRes.GetField( "vehicle_level_id",vehicle_level_id, Error );
  418. int need_display = 0;
  419. DBRes.GetField( "need_display",need_display, Error );
  420. int power_alarm = 0;
  421. DBRes.GetField( "power_alarm",power_alarm, Error );
  422. int vehicle_category_id = 0;
  423. DBRes.GetField( "vehicle_category_id",vehicle_category_id, Error );
  424. int bigger_car_flag= 0;
  425. DBRes.GetField( "bigger_car_flag",bigger_car_flag, Error );
  426. double over_speed= 0;
  427. DBRes.GetField( "over_speed",over_speed, Error );
  428. //for now
  429. vehicle_id = vsid;
  430. std::shared_ptr<card_location_base> clb = std::make_shared<car>(strategy,vehicle_id,
  431. need_display,card_type_id,dept_id,vehicle_category_id, vehicle_type_id,vehicle_level_id);
  432. uint64_t cardid = getId(vehicle_id,2);
  433. log_info("cardId:%llu,vehicle_id:%d dept_id:%d,need_display:%d---cardid:%s,categoryid:%d",cardid,vehicle_id,dept_id,need_display,card_id.c_str(),vehicle_category_id);
  434. map.insert({cardid,clb});
  435. }
  436. }
  437. card_list::instance()->add(map);
  438. }
  439. void card_list::init_staffer()
  440. {
  441. std::unordered_map<uint64_t,std::shared_ptr<card_location_base>> map;
  442. std::string strategy = config.get("person.strategy","person1");
  443. const char *sql = "SELECT staff_id, s.card_id, c.card_type_id, s.dept_id, s.group_id, s.occupation_id, \
  444. ol.occupation_level_id,s.worktype_id,s.need_display \
  445. FROM dat_staff_extend s \
  446. LEFT JOIN dat_card c ON s.card_id = c.card_id \
  447. LEFT JOIN dat_occupation o ON s.occupation_id = o.occupation_id \
  448. LEFT JOIN dat_occupation_level ol ON ol.occupation_level_id = o.occupation_level_id \
  449. WHERE c.card_type_id = 1 AND s.duty_id = 0 AND c.state_id = 0;";
  450. std::string Error;
  451. YADB::CDBResultSet DBRes;
  452. sDBConnPool.Query(sql,DBRes,Error);
  453. int nCount = DBRes.GetRecordCount( Error );
  454. if (nCount > 0)
  455. {
  456. log_info( "init_staffer. The record count=%d\n", nCount );
  457. while ( DBRes.GetNextRecod(Error) )
  458. {
  459. unsigned int staff_id = 0;
  460. DBRes.GetField( "staff_id",staff_id, Error );
  461. std::string card_id;
  462. DBRes.GetField( "card_id",card_id, Error );
  463. uint32_t vsid = atoi(card_id.substr(3).c_str());
  464. unsigned int card_type_id = 0;
  465. DBRes.GetField( "card_type_id",card_type_id, Error );
  466. int dept_id = 0;
  467. DBRes.GetField( "dept_id",dept_id, Error );
  468. int group_id = 0;
  469. DBRes.GetField( "group_id",group_id, Error );
  470. int occupation_id = 0;
  471. DBRes.GetField( "occupation_id",occupation_id, Error );
  472. int occupation_level_id = 0;
  473. DBRes.GetField( "occupation_level_id",occupation_level_id, Error );
  474. int need_display = 0;
  475. DBRes.GetField( "need_display",need_display, Error );
  476. //for now;
  477. staff_id = vsid;
  478. std::shared_ptr<card_location_base> clb = std::make_shared<person>(strategy,staff_id,need_display,card_type_id,dept_id,occupation_level_id);
  479. uint64_t cardid = getId(staff_id,1);
  480. log_info("cardId:%llu,staff_id:%d dept_id:%d,need_display:%d--c-ard:%s",cardid,staff_id,dept_id,need_display,card_id.c_str());
  481. map.insert({cardid,clb});
  482. }
  483. }
  484. card_list::instance()->add(map);
  485. }
  486. void card_list::init_card_from_db()
  487. {
  488. init_staffer();
  489. init_vehicle();
  490. }
  491. void card_list::load_his_card_postion_from_db()
  492. {
  493. load_his_card_postion_vehicle();
  494. load_his_card_postion_staff();
  495. run();
  496. for(auto&iter: m_map)
  497. {
  498. auto card_ptr = iter.second;
  499. auto mine_tool_ptr = card_ptr->get_mine_tool();
  500. if(mine_tool_ptr->is_attendance())
  501. {
  502. auto str = tool_time::to_str_ex( tool_time::to_ms(mine_tool_ptr->m_attendance_start_time));
  503. std_debug("加载考勤,考勤开始时间: %s, 卡id=%d,卡type=%d", str.c_str(), card_ptr->m_id, card_ptr->m_type);
  504. log_info("加载考勤,考勤开始时间: %s, 卡id=%d,卡type=%d", str.c_str(), card_ptr->m_id, card_ptr->m_type);
  505. }
  506. }
  507. auto area_map = area_list::instance()->m_map;
  508. for(auto&iter: area_map)
  509. {
  510. auto area_ptr = iter.second;
  511. if(area_ptr->m_person_count)
  512. {
  513. std_debug("加载区域人数: 区域id=%d,区域人数=%d",area_ptr->m_id, area_ptr->m_person_count.load());
  514. log_info("加载区域人数: 区域id=%d,区域人数=%d",area_ptr->m_id, area_ptr->m_person_count.load());
  515. }
  516. if(area_ptr->m_vehicle_count)
  517. {
  518. std_debug("加载区域车数: 区域id=%d,区域车数=%d",area_ptr->m_id, area_ptr->m_vehicle_count.load());
  519. log_info("加载区域车数: 区域id=%d,区域车数=%d",area_ptr->m_id, area_ptr->m_vehicle_count.load());
  520. }
  521. }
  522. }
  523. void card_list::load_his_card_postion_vehicle()
  524. {
  525. const char *sql = "select l.card_id, l.cur_time, l.x, l.y, l.z, l.map_id, la.area_id, l.state, \
  526. case when l.cur_time >= date_sub(now(), interval 2 minute) then l.speed else 0 end as speed, \
  527. l.mileage, la.enter_time, att.start_time, \
  528. att.end_time, \
  529. l.landmark_id, l.direction_mapper_id, l.landmark_dist \
  530. from rt_location l, rt_location_area la, rt_att_vehicle att, dat_card c, dat_vehicle_extend v \
  531. where l.card_id = c.card_id and l.card_id = la.card_id and l.card_id = att.card_id and l.card_id=v.card_id \
  532. and c.state_id=0;";
  533. std::string Error;
  534. YADB::CDBResultSet DBRes;
  535. sDBConnPool.Query(sql,DBRes,Error);
  536. if(!Error.empty())
  537. log_error("load_his_card_postion_vehicle列表 Error,%s",Error.c_str());
  538. uint64_t nCount = DBRes.GetRecordCount( Error );
  539. if (nCount > 0)
  540. {
  541. log_info( "load_his_card_postion_vehicle. The record count=%ld\n", nCount );
  542. while ( DBRes.GetNextRecod(Error) )
  543. {
  544. std::string card_id = "";
  545. DBRes.GetField( "card_id",card_id, Error );
  546. uint32_t id = tool_other::id64_to_id(card_id);
  547. int type = tool_other::id64_to_type(card_id);
  548. auto temp_ptr = card_list::instance()->get(card_list::to_id64(type, id));
  549. if(!temp_ptr || !temp_ptr->is_vehicle())
  550. {
  551. log_error("全局卡列表中找不到卡,卡id=%d,卡type=%d", id, type);
  552. continue;
  553. }
  554. auto card_ptr = static_cast<car*>(temp_ptr.get());
  555. double x = 0;
  556. DBRes.GetField( "x",x, Error );
  557. double y = 0;
  558. DBRes.GetField( "y",y, Error );
  559. double z = 0;
  560. DBRes.GetField( "z",z, Error );
  561. int map_id = 0;
  562. DBRes.GetField( "map_id",map_id, Error );
  563. int area_id = 0;
  564. DBRes.GetField( "area_id",area_id, Error );
  565. int state = 0;
  566. DBRes.GetField( "state",state, Error );
  567. double speed = 0;
  568. DBRes.GetField( "speed",speed, Error );
  569. std::string enter_time = "";
  570. DBRes.GetField( "enter_time",enter_time, Error );
  571. std::string start_time = "";
  572. DBRes.GetField( "start_time",start_time, Error );
  573. std::string end_time = "";
  574. DBRes.GetField( "end_time",end_time, Error );
  575. int landmark_id = 0;
  576. DBRes.GetField( "landmark_id",landmark_id, Error );
  577. int direction_mapper_id = 0;
  578. DBRes.GetField( "direction_mapper_id",direction_mapper_id, Error );
  579. double landmark_dist = 0;
  580. DBRes.GetField( "landmark_dist",landmark_dist, Error );
  581. card_ptr->x = x;
  582. card_ptr->y = y;
  583. card_ptr->z = z;
  584. auto area = area_list::instance()->get(area_id);
  585. if(area == nullptr)
  586. {
  587. log_error("load_vehicle...area_list 找不到区域:区域id=%d", area_id);
  588. continue;
  589. }
  590. area->m_vehicle_count++;
  591. point pt = *card_ptr;
  592. card_ptr->m_area_tool->m_area_hover = std::make_shared<area_hover>( area, pt,speed);
  593. auto area_hover_ptr = card_ptr->get_area_hover();
  594. auto e_t = tool_time::to_time_ex(enter_time);
  595. area_hover_ptr->m_enter_time = std::chrono::system_clock::to_time_t(e_t);
  596. //int map_id = 0;
  597. //int state = 0;
  598. card_ptr->m_speed = speed;
  599. if(end_time.empty())
  600. {
  601. auto mine_tool_ptr = card_ptr->get_mine_tool();
  602. mine_tool_ptr->m_attendance_start_time = tool_time::to_time_ex(start_time);
  603. mine_tool_ptr->m_stat_attendance = AS_ATTENDANCE;
  604. }
  605. area_hover_ptr->landmark_id = landmark_id;
  606. area_hover_ptr->landmark_dir = direction_mapper_id;
  607. area_hover_ptr->landmark_dis = landmark_dist;
  608. card_ptr->m_time = tool_time::now_to_ms();
  609. }
  610. }
  611. }
  612. void card_list::load_his_card_postion_staff()
  613. {
  614. const char *sql = "select l.card_id, l.cur_time, l.x, l.y, l.z, l.map_id, la.area_id, l.state, \
  615. case when l.cur_time >= date_sub(now(), interval 2 minute) then l.speed else 0 end as speed, \
  616. l.mileage, la.enter_time, att.start_time, \
  617. att.end_time, \
  618. l.landmark_id, l.direction_mapper_id, l.landmark_dist \
  619. from rt_location l, rt_location_area la, rt_att_staff att, dat_card c, dat_staff_extend s \
  620. where l.card_id = c.card_id and l.card_id = la.card_id and l.card_id = att.card_id and l.card_id=s.card_id\
  621. and c.state_id=0;";
  622. std::string Error;
  623. YADB::CDBResultSet DBRes;
  624. sDBConnPool.Query(sql,DBRes,Error);
  625. if(!Error.empty())
  626. log_error("load_his_card_postion_vehicle列表 Error,%s",Error.c_str());
  627. uint64_t nCount = DBRes.GetRecordCount( Error );
  628. if (nCount > 0)
  629. {
  630. log_info( "load_his_card_postion_vehicle. The record count=%ld\n", nCount );
  631. while ( DBRes.GetNextRecod(Error) )
  632. {
  633. std::string end_time = "";
  634. DBRes.GetField( "end_time",end_time, Error );
  635. if(!end_time.empty()) // 已升井,不再读入
  636. {
  637. continue;
  638. }
  639. std::string card_id = "";
  640. DBRes.GetField( "card_id",card_id, Error );
  641. uint32_t id = tool_other::id64_to_id(card_id);
  642. int type = tool_other::id64_to_type(card_id);
  643. auto temp_ptr = card_list::instance()->get(card_list::to_id64(type, id));
  644. if(!temp_ptr || !temp_ptr->is_person())
  645. {
  646. log_error("全局卡列表中找不到卡,卡id=%d,卡type=%d", id, type);
  647. continue;
  648. }
  649. auto card_ptr = static_cast<car*>(temp_ptr.get());
  650. double x = 0;
  651. DBRes.GetField( "x",x, Error );
  652. double y = 0;
  653. DBRes.GetField( "y",y, Error );
  654. double z = 0;
  655. DBRes.GetField( "z",z, Error );
  656. int map_id = 0;
  657. DBRes.GetField( "map_id",map_id, Error );
  658. int area_id = 0;
  659. DBRes.GetField( "area_id",area_id, Error );
  660. int state = 0;
  661. DBRes.GetField( "state",state, Error );
  662. double speed = 0;
  663. DBRes.GetField( "speed",speed, Error );
  664. std::string enter_time = "";
  665. DBRes.GetField( "enter_time",enter_time, Error );
  666. std::string start_time = "";
  667. DBRes.GetField( "start_time",start_time, Error );
  668. int landmark_id = 0;
  669. DBRes.GetField( "landmark_id",landmark_id, Error );
  670. int direction_mapper_id = 0;
  671. DBRes.GetField( "direction_mapper_id",direction_mapper_id, Error );
  672. double landmark_dist = 0;
  673. DBRes.GetField( "landmark_dist",landmark_dist, Error );
  674. card_ptr->x = x;
  675. card_ptr->y = y;
  676. card_ptr->z = z;
  677. auto area = area_list::instance()->get(area_id);
  678. if(area == nullptr)
  679. {
  680. log_error("area_list 找不到区域:区域id=%d", area_id);
  681. continue;
  682. }
  683. area->m_person_count++;
  684. point pt = *card_ptr;
  685. card_ptr->m_area_tool->m_area_hover = std::make_shared<area_hover>(area,pt,speed);
  686. auto area_hover_ptr = card_ptr->get_area_hover();
  687. auto e_t = tool_time::to_time_ex(enter_time);
  688. area_hover_ptr->m_enter_time = std::chrono::system_clock::to_time_t(e_t);
  689. log_info("load_staff...%d,areaid:%d,mapid:%d",id,area->id(),area->mapid());
  690. //int map_id = 0;
  691. //int state = 0;
  692. card_ptr->m_speed = speed;
  693. if(end_time.empty())
  694. {
  695. auto mine_tool_ptr = card_ptr->get_mine_tool();
  696. mine_tool_ptr->m_attendance_start_time = tool_time::to_time_ex(start_time);
  697. mine_tool_ptr->m_stat_attendance = AS_ATTENDANCE;
  698. }
  699. area_hover_ptr->landmark_id = landmark_id;
  700. area_hover_ptr->landmark_dir = direction_mapper_id;
  701. area_hover_ptr->landmark_dis = landmark_dist;
  702. card_ptr->m_time = tool_time::now_to_ms();
  703. }
  704. }
  705. }
  706. void card_list::on_message(zloop<task*> *loop,const message_locinfo&loc,bool is_history)
  707. {
  708. //std::shared_ptr<card_location_base>c=get(loc.m_card_id);
  709. uint64_t cardid = getId(loc.m_card_id,loc.m_card_type);
  710. const auto c=get(cardid);
  711. if(c==nullptr)
  712. {
  713. log_warn("数据库中未定义该卡的信息,card_id=%d", loc.m_card_id);
  714. return;
  715. }
  716. log_info("card message:site=%d,ant=%d,card=%d,tof=%lld,rav=%02X,acc=%02X,rssi=%d,stamp=%llu",
  717. loc.m_site_id,loc.m_ant_id,loc.m_card_id,loc.m_tof,loc.m_rav,loc.m_acc,loc.m_rssi,loc.m_time_stamp);
  718. c->on_message(loop,loc,is_history);
  719. }
  720. struct local_visit:visitor<std::shared_ptr<card_location_base>>
  721. {
  722. bool visit(std::shared_ptr<card_location_base> c)
  723. {
  724. c->on_timer();
  725. return true;
  726. }
  727. };
  728. void card_list::onTimer()
  729. {
  730. local_visit lv;
  731. while(!m_bflag)
  732. {
  733. card_list::instance()->accept(lv);
  734. std::this_thread::sleep_for(std::chrono::seconds(1));
  735. }
  736. }
  737. //-----------------card_location_base..
  738. card_location_base::card_location_base(std::string type,uint32_t id,uint16_t dis,int16_t t,int32_t deptid,int32_t level_id)
  739. :card(id,dis,t,deptid,level_id)
  740. {
  741. select_tool_manage::instance()->create_tool(type,m_sel_tool,m_smo_tool);
  742. }
  743. void card_location_base::do_status(STATUS_CARD st)
  744. {
  745. module_mgr::do_status(st, m_id, m_type);
  746. }
  747. void card_location_base::on_location(const std::vector<point>&vp,const std::vector<loc_message> &lm )
  748. {
  749. //ct timestamp;
  750. //m_ct = lm[0].m_card_ct;
  751. //m_time = lm[0].m_loc_time;
  752. loc_point pt = m_sel_tool->select_solution(vp,lm);
  753. pt.y=-pt.y;
  754. if(pt.m_useless)
  755. {
  756. x = pt.x;
  757. y = pt.y;
  758. Msg m;
  759. m.type=m_type;m.x=(int)x;m.y=(int)y;m.cmd=CMD_HANDLE;m.cardid=m_type<<32|m_id;
  760. cardMgr::instance()->tryPut(m);
  761. log_info("useful:card_id:%d,ct:%d,timestamp:%llu, loc_point,x:%.2f,y:%.2f ",m_id,m_ct,m_time,pt.x,pt.y);
  762. do_business(pt);
  763. }
  764. }
  765. void card_location_base::on_message(zloop<task*> * loop,const message_locinfo&loc,bool is_history)
  766. {
  767. m_ct = loc.m_card_ct;
  768. m_time = loc.m_time_stamp;
  769. m_message_handle->on_message(loop,loc,is_history);
  770. }
  771. //前端推送位置函数
  772. void card_location_base::upt_card_pos(YA::_CARD_POS_ &cp,const point &pt)
  773. {
  774. cp.x = pt.x;
  775. cp.y = pt.y;
  776. cp.z = pt.z;
  777. cp.Type=m_type;
  778. cp.ID = m_id;
  779. cp.speed = abs(ceil(m_speed));
  780. cp.running_stat = m_stat;
  781. cp.dept_id = m_deptid;
  782. cp.display=m_display;
  783. cp.rec_time=m_time;
  784. cp.level_id = m_level_id;
  785. swsTimerThrd.upt_card_pos(cp);
  786. }
  787. void card_location_base::del_card_pos()
  788. {
  789. YA::_CARD_POS_ cp;
  790. cp.ID = m_id;
  791. cp.Type=m_type;
  792. swsTimerThrd.del_card_pos(cp);
  793. }
  794. int card_location_base::get_stat()
  795. {
  796. //盲区>呼救>呼叫>超时>超速>正常
  797. uint64_t now = time(0)*1000;
  798. if(now-m_time>CARD_LOST_TIME_OUT)
  799. {
  800. return STATUS_LOST;
  801. }
  802. else if(auto ev_ptr = event_list::instance()->get_event_card(m_id, m_type, ET_CARD_HELP))
  803. {
  804. return (ES_DEAL_HELP == ev_ptr->m_status) ? STATUS_HELP_DEALED : STATUS_HELP;
  805. }
  806. else if(CALL_NONE != get_mine_tool()->m_status_call)
  807. {
  808. return STATUS_CALL;
  809. }
  810. else if(event_list::instance()->get_event_card(m_id, m_type,
  811. is_person()? ET_CARD_AREA_OVER_TIME_PERSON: ET_CARD_AREA_OVER_TIME_VEHICLE))
  812. {
  813. return STATUS_AREA_OVER_TIME;
  814. }
  815. else if(event_list::instance()->get_event_card(m_id, m_type, ET_CARD_OVER_SPEED))
  816. {
  817. return STATUS_OVER_SPEED;
  818. }
  819. return STATUS_NORMAL;
  820. }
  821. void card_location_base::clear()
  822. {
  823. // uint16_t m_display; //1显示0不显示,往前端推送
  824. m_speed=0; //速度
  825. m_is_attendance=0; //井上井下状态 0初始状态 1 井上 2 井下
  826. m_stat=0; //运动静止状态
  827. //m_ct; //ct
  828. m_time=0; //时间戳
  829. }
  830. card_location_base::~card_location_base()
  831. {
  832. }
  833. template<> std::shared_ptr<card_list>
  834. single_base<card_list, uint64_t, std::shared_ptr<card_location_base>>::m_instance=std::make_shared<card_list>();