ant.cpp 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471
  1. #include <stdio.h>
  2. #include <string.h>
  3. #include <math.h>
  4. #include "ant.h"
  5. #include "db_api/CDBSingletonDefine.h"
  6. #include "event.h"
  7. template<> std::shared_ptr<sit_list>
  8. single_base<sit_list, int, std::shared_ptr<site>>::m_instance=std::make_shared<sit_list>();
  9. int site::index()const
  10. {
  11. return m_algo+(m_num_dims<<1);
  12. }
  13. site::site(int id)
  14. :m_algo(0)
  15. ,m_num_dims(0)
  16. ,m_id(id)
  17. ,m_path_empty(true)
  18. {
  19. m_time=time(0);
  20. }
  21. const algo_config&site::config()const
  22. {
  23. return g_config[index()];
  24. }
  25. bool visit_site_status::visit(std::shared_ptr<site> s)
  26. {
  27. time_t now = time(0);
  28. int diff = now - s->m_time;
  29. if(diff > READER_TIMEOUT)
  30. {
  31. auto ev_ptr = event_list::instance()->get_event_reader(s->m_id,ET_READER_ERROR);
  32. if(!ev_ptr)
  33. {
  34. auto ev_ptr = event_list::create_event_reader(s->m_id,ET_READER_ERROR);
  35. event_list::copy_event(s, ev_ptr);
  36. ev_ptr->m_limit_value = READER_TIMEOUT;
  37. ev_ptr->m_cur_value = diff;
  38. //保存到数据库
  39. event_list::save_event(ev_ptr);
  40. event_list::instance()->add(ev_ptr->get_list_id(),ev_ptr);
  41. log_info("reader_error_create: %d,diff:%d",s->m_id,diff);
  42. }
  43. }
  44. else
  45. {
  46. auto ev_ptr = event_list::instance()->get_event_reader(s->m_id,ET_READER_ERROR);
  47. if(ev_ptr && !ev_ptr->is_end())
  48. {
  49. event_list::copy_event(s, ev_ptr);
  50. ev_ptr->m_cur_value = diff;
  51. ev_ptr->m_status = ES_END;
  52. //保存到数据库
  53. event_list::save_event(ev_ptr);
  54. log_info("reader_error_delete: %d,diff:%d",s->m_id,diff);
  55. }
  56. }
  57. return true;
  58. }
  59. void sit_list::read_ant_path(int id)
  60. {
  61. std::string sql = "SELECT reader_id,tof_flag,b_x,b_y,b_z,e_x,e_y,e_z,spacing_ratio FROM dat_reader_path_tof_n";
  62. if(-1 == id)
  63. {
  64. sql.append(";");
  65. }
  66. else
  67. {
  68. sql.append(" AND reader_id=");
  69. sql.append(std::to_string(id));
  70. sql.append(";");
  71. std_debug("修改path sql=%s", sql.c_str());
  72. log_info("修改path sql=%s", sql.c_str());
  73. }
  74. std::string Error;
  75. YADB::CDBResultSet DBRes;
  76. sDBConnPool.Query(sql.c_str(),DBRes,Error);
  77. int nCount = DBRes.GetRecordCount( Error );
  78. if (nCount < 1)
  79. {
  80. log_error("修改path失败,数据库中找不到(dat_reader_path_tof_n): 分站id=%d", id);
  81. return ;
  82. }
  83. while ( DBRes.GetNextRecod(Error) )
  84. {
  85. int reader_id = 0;
  86. DBRes.GetField( "reader_id",reader_id, Error );
  87. auto site_ptr=sit_list::instance()->get(reader_id);
  88. if(nullptr==site_ptr)
  89. continue;
  90. int pid=0;
  91. DBRes.GetField( "tof_flag",pid, Error );
  92. double b_x= 0;
  93. DBRes.GetField( "b_x",b_x, Error );
  94. double b_y= 0;
  95. DBRes.GetField( "b_y",b_y, Error );
  96. double b_z= 0;
  97. DBRes.GetField( "b_z",b_z, Error );
  98. double e_x= 0;
  99. DBRes.GetField( "e_x",e_x, Error );
  100. double e_y= 0;
  101. DBRes.GetField( "e_y",e_y, Error );
  102. double e_z= 0;
  103. DBRes.GetField( "e_z",e_z, Error );
  104. double spacing_ratio = 0;
  105. DBRes.GetField( "spacing_ratio",spacing_ratio, Error );
  106. log_info("ant_path:%d,%.2f,%.2f,%.2f,%.2f",reader_id,b_x,b_y,e_x,e_y);
  107. point p1(b_x,-b_y);
  108. point p2(e_x,-e_y);
  109. auto &sit_ = *site_ptr;
  110. if(-1!=id)//清空path
  111. {
  112. sit_.clear_path();
  113. log_info( "修改path 清空path,分站id=%d\n", id );
  114. std_debug( "修改path 清空path,分站id=%d\n", id );
  115. }
  116. if(pid == 0)
  117. {
  118. line_v l(p1,p2);
  119. {
  120. point px = l.line::projection(sit_);
  121. sit_.set(px);
  122. for(int i=0;i<2;i++)
  123. {
  124. path p;
  125. p.m_slope[0] = spacing_ratio;
  126. p.m_line[0] = line_v(px,l[i]);
  127. sit_.m_ant[i].m_path.push_back(p);
  128. }
  129. }
  130. }
  131. else
  132. {
  133. ant &a = pid<0?sit_.m_ant[0]:sit_.m_ant[1];
  134. if(a.m_path.size()!=0)
  135. {
  136. path &p = a.m_path[0];
  137. p.m_line[abs(pid)-1] = line_v(p1,p2);
  138. p.m_slope[abs(pid)-1] = spacing_ratio;
  139. }
  140. else
  141. {
  142. path p;
  143. p.m_line[abs(pid)-1] = line_v(p1,p2);
  144. p.m_slope[abs(pid)-1] = spacing_ratio;
  145. a.m_path.push_back(p);
  146. }
  147. if(abs(pid)==1)
  148. sit_.set(p1);
  149. }
  150. }
  151. if(-1==id)
  152. {
  153. log_info( "read_ant_path. The record count=%ld\n", nCount );
  154. for(auto&_s:sit_list::instance()->m_map)
  155. {
  156. _s.second->deal_path();
  157. }
  158. }
  159. else
  160. {
  161. auto sit_ptr=sit_list::instance()->get(id);
  162. if(sit_ptr)
  163. {
  164. sit_ptr->deal_path();
  165. log_info( "修改path成功,分站id=%d\n", id );
  166. std_debug( "修改path成功,分站id=%d\n", id );
  167. }
  168. }
  169. }
  170. void sit_list::init_site(int id)
  171. {
  172. std::string sql = "SELECT reader_id, reader_type_id, dat_reader.map_id, \
  173. area_id, device_type_id, dimension, dat_map.scale\
  174. FROM dat_reader, dat_map where \
  175. dat_reader.map_id=dat_map.map_id and state=0";
  176. if(-1 == id)
  177. {
  178. sql.append(";");
  179. }
  180. else
  181. {
  182. sql.append(" AND reader_id=");
  183. sql.append(std::to_string(id));
  184. sql.append(";");
  185. std_debug("增加或修改分站 sql=%s", sql.c_str());
  186. log_info("增加或修改分站 sql=%s", sql.c_str());
  187. }
  188. std::string Error;
  189. YADB::CDBResultSet DBRes;
  190. sDBConnPool.Query(sql.c_str(),DBRes,Error);
  191. int nCount = DBRes.GetRecordCount( Error );
  192. if (nCount < 1)
  193. {
  194. log_error("增加或修改失败,数据库中找不到: 分站id=%d", id);
  195. return ;
  196. }
  197. log_info( "增加或修改 init_site. The record count=%ld\n", nCount );
  198. while ( DBRes.GetNextRecod(Error) )
  199. {
  200. int reader_id = 0;
  201. DBRes.GetField( "reader_id",reader_id, Error );
  202. auto site_ptr=sit_list::instance()->get(reader_id);
  203. if(nullptr==site_ptr)
  204. {
  205. site_ptr = std::make_shared<site>(reader_id);
  206. sit_list::instance()->add(reader_id,site_ptr);
  207. }
  208. int reader_type_id = 0;
  209. DBRes.GetField( "reader_type_id",reader_type_id, Error );
  210. int map_id = 0;
  211. DBRes.GetField( "map_id",map_id, Error );
  212. int area_id = 0;
  213. DBRes.GetField( "area_id",area_id, Error );
  214. int device_type_id = 0;
  215. DBRes.GetField( "device_type_id",device_type_id, Error );
  216. int dimension = 0;
  217. DBRes.GetField( "dimension",dimension, Error );
  218. double scale= 0;
  219. DBRes.GetField( "scale",scale, Error );
  220. site_ptr->m_reader_type_id = reader_type_id;
  221. site_ptr->m_map_id = map_id;
  222. site_ptr->m_area_id = area_id;
  223. site_ptr->m_device_type_id = device_type_id;
  224. site_ptr->m_dimension = dimension;
  225. site_ptr->m_scale = scale;
  226. }
  227. }
  228. void sit_list::read_sit_list(int id)
  229. {
  230. std::string sql = "SELECT antenna_id, a.reader_id, idx, a.x, a.y, a.z, a.angle \
  231. FROM dat_antenna a, dat_reader r \
  232. WHERE a.reader_id = r.reader_id";
  233. if(-1 == id)
  234. {
  235. sql.append(";");
  236. }
  237. else
  238. {
  239. sql.append(" AND antenna_id=");
  240. sql.append(std::to_string(id));
  241. sql.append(";");
  242. std_debug("基础数据 增加或修改天线 sql=%s", sql.c_str());
  243. log_info("基础数据 增加或修改天线 sql=%s", sql.c_str());
  244. }
  245. std::string Error;
  246. YADB::CDBResultSet DBRes;
  247. sDBConnPool.Query(sql.c_str(),DBRes,Error);
  248. int nCount = DBRes.GetRecordCount( Error );
  249. if (nCount < 1)
  250. {
  251. log_error("基础数据 增加或修改失败,数据库中找不到: 天线id=%d", id);
  252. return ;
  253. }
  254. std::unordered_map<int,std::shared_ptr<site>> map;
  255. while ( DBRes.GetNextRecod(Error) )
  256. {
  257. int antenna_id = 0;
  258. DBRes.GetField( "antenna_id",antenna_id, Error );
  259. int reader_id = 0;
  260. DBRes.GetField( "reader_id",reader_id, Error );
  261. int idx=0;
  262. DBRes.GetField( "idx",idx, Error );
  263. int antid = idx-1;
  264. if(antid >= 2)
  265. continue;
  266. double x= 0;
  267. DBRes.GetField( "x",x, Error );
  268. double y= 0;
  269. DBRes.GetField( "y",y, Error );
  270. double z= 0;
  271. DBRes.GetField( "z",z, Error );
  272. if(-1 == id)
  273. {
  274. std::shared_ptr<site> site_ptr=nullptr;
  275. auto it = map.find(reader_id);
  276. if(it==map.end())
  277. {
  278. site_ptr = std::make_shared<site>(reader_id);
  279. map.insert({reader_id,site_ptr});
  280. }
  281. else
  282. site_ptr=it->second;
  283. site_ptr->m_ant[antid].m_id = antenna_id;
  284. site_ptr->m_ant[antid].set(x,-y);
  285. log_info("reand_ant..%d,%d,%.2f,%.2f",reader_id,antid,x,y);
  286. }
  287. else
  288. {
  289. auto site_ptr = sit_list::instance()->get(reader_id);
  290. if(site_ptr)
  291. {
  292. site_ptr->m_ant[antid].set(x,-y);
  293. site_ptr->set_ex();
  294. }
  295. log_info("基础数据 增加或修改天线成功:天线id:%d,分站id:%d",id,reader_id);
  296. std_debug("基础数据 增加或修改天线成功:天线id:%d,分站id:%d",id,reader_id);
  297. }
  298. }
  299. if(-1 == id)
  300. {
  301. log_info( "init_antenna. The record count=%ld\n", nCount );
  302. sit_list::instance()->add(map);
  303. for(auto&sit_:map)
  304. {
  305. sit_.second->set_ex();
  306. }
  307. }
  308. }
  309. /*
  310. 处理分站供电状态,交流供电时,ac_down=false,直流供电时,ac_down=true
  311. 目前只有大分站实现了这个功能,并且井下安装时是否接入了该电信号也不确定
  312. ,所以需要有张表定义某个ID是否需要告警
  313. */
  314. void site::on_power_status(bool ac_down)//电源状态
  315. {
  316. if(!m_power_check_enable)
  317. return;
  318. if(ac_down == m_power_ac_down)
  319. return;
  320. if(m_power_ac_down=ac_down)
  321. {
  322. //掉电告警
  323. }
  324. else
  325. {
  326. //撤销警告
  327. }
  328. }
  329. #if 0
  330. void sit_list::init_site()
  331. {
  332. const char *sql = "SELECT reader_id, reader_type_id, dat_reader.map_id, \
  333. area_id, device_type_id, dimension, dat_map.scale\
  334. FROM dat_reader, dat_map where \
  335. dat_reader.map_id=dat_map.map_id and state=0;";
  336. std::string Error;
  337. YADB::CDBResultSet DBRes;
  338. sDBConnPool.Query(sql,DBRes,Error);
  339. uint64_t nCount = DBRes.GetRecordCount( Error );
  340. if (nCount > 0)
  341. {
  342. log_info( "init_site. The record count=%ld\n", nCount );
  343. while ( DBRes.GetNextRecod(Error) )
  344. {
  345. int reader_id = 0;
  346. DBRes.GetField( "reader_id",reader_id, Error );
  347. auto site_ptr=sit_list::instance()->get(reader_id);
  348. if(nullptr==site_ptr)
  349. {
  350. site_ptr = std::make_shared<site>(reader_id);
  351. sit_list::instance()->add(reader_id,site_ptr);
  352. }
  353. int reader_type_id = 0;
  354. DBRes.GetField( "reader_type_id",reader_type_id, Error );
  355. int map_id = 0;
  356. DBRes.GetField( "map_id",map_id, Error );
  357. int area_id = 0;
  358. DBRes.GetField( "area_id",area_id, Error );
  359. int device_type_id = 0;
  360. DBRes.GetField( "device_type_id",device_type_id, Error );
  361. int dimension = 0;
  362. DBRes.GetField( "dimension",dimension, Error );
  363. double scale= 0;
  364. DBRes.GetField( "scale",scale, Error );
  365. site_ptr->m_reader_type_id = reader_type_id;
  366. site_ptr->m_map_id = map_id;
  367. site_ptr->m_area_id = area_id;
  368. site_ptr->m_device_type_id = device_type_id;
  369. site_ptr->m_dimension = dimension;
  370. site_ptr->m_scale = scale;
  371. }
  372. }
  373. }
  374. #endif
  375. algo_config site::g_config[]=
  376. {
  377. { "tof-1", 1, 2, 0.1, 1 },
  378. { "tdoa-1", 2, 2, 0.1, 1 },
  379. { "tof-2", 2, 3, 0.1, 1 },
  380. { "tdoa-2", 3, 3, 0.1, 1 },
  381. { "tof-3", 3, 4, 0.1, 1 },
  382. { "tdoa-3", 4, 4, 0.1, 1 }
  383. };
  384. #ifdef _TEST
  385. int main()
  386. {
  387. log_init("./log.ini");
  388. //sit_list *sl = sit_list::instance();
  389. sit_list::instance()->load("data_reader_antenna.txt","path_tof.txt");
  390. sit_list::instance()->get(209)->solving(0,100);
  391. sit_list::instance()->get(209)->solving(1,100.5);
  392. //std_info("---%d",(*sl)[209].m_ant[0].m_path.size());
  393. //std_info("---%d",(*sl)[209][0].size());
  394. //std_info("---%s",(*sl)[209][0][0][0].to_string().c_str());
  395. }
  396. #endif