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