ant.cpp 12 KB

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