ant.cpp 12 KB

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