TaskData.go 38 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262
  1. package controllers
  2. import (
  3. "ColdVerify_local/Nats"
  4. "ColdVerify_local/Nats/NatsServer"
  5. "ColdVerify_local/conf"
  6. "ColdVerify_local/lib"
  7. "ColdVerify_local/logs"
  8. "ColdVerify_local/models/System"
  9. "ColdVerify_local/models/Task"
  10. "fmt"
  11. beego "github.com/beego/beego/v2/server/web"
  12. "github.com/vmihailenco/msgpack/v5"
  13. "github.com/xuri/excelize/v2"
  14. "math"
  15. "os"
  16. "strconv"
  17. "strings"
  18. "sync"
  19. "time"
  20. )
  21. type TaskDataController struct {
  22. beego.Controller
  23. }
  24. // 列表 -
  25. func (c *TaskDataController) TaskData_List() {
  26. var r_jsons lib.R_JSONS
  27. page, _ := c.GetInt("page")
  28. if page < 1 {
  29. page = 1
  30. }
  31. page_z, _ := c.GetInt("page_z")
  32. if page_z < 1 {
  33. page_z = conf.Page_size
  34. }
  35. Time_start := c.GetString("Time_start")
  36. Time_end := c.GetString("Time_end")
  37. T_sn := c.GetString("T_sn")
  38. T_id, err := c.GetInt("T_id")
  39. if err != nil {
  40. T_id = -1
  41. }
  42. T_task_id := c.GetString("T_task_id")
  43. Task_r, err := NatsServer.Read_Task(T_task_id)
  44. if err != nil {
  45. c.Data["json"] = lib.JSONS{Code: 202, Msg: "T_task_id 错误!"}
  46. c.ServeJSON()
  47. return
  48. }
  49. if Task_r.T_collection_state == 2 {
  50. c.Data["json"] = lib.JSONS{Code: 202, Msg: "数据采集中,请稍后!"}
  51. c.ServeJSON()
  52. return
  53. }
  54. var cnt int64
  55. List, cnt := Task.Read_TaskData_ById_List(Task_r.T_task_id, T_sn, T_id, Time_start, Time_end, page, page_z)
  56. page_size := math.Ceil(float64(cnt) / float64(page_z))
  57. r_jsons.List = List
  58. r_jsons.Page = page
  59. r_jsons.Page_size = int(page_size)
  60. r_jsons.Pages = lib.Func_page(int64(page), int64(page_size))
  61. r_jsons.Num = int(cnt)
  62. c.Data["json"] = lib.JSONS{Code: 200, Msg: "ok!", Data: r_jsons}
  63. c.ServeJSON()
  64. return
  65. }
  66. // 列表 -
  67. func (c *TaskDataController) TaskDataClass_List() {
  68. page, _ := c.GetInt("page")
  69. if page < 1 {
  70. page = 1
  71. }
  72. page_z, _ := c.GetInt("page_z")
  73. if page_z < 1 {
  74. page_z = conf.Page_size
  75. }
  76. T_task_id := c.GetString("T_task_id")
  77. Task_r, err := NatsServer.Read_Task(T_task_id)
  78. if err != nil {
  79. c.Data["json"] = lib.JSONS{Code: 202, Msg: "T_task_id 错误!"}
  80. c.ServeJSON()
  81. return
  82. }
  83. if Task_r.T_collection_state == 2 {
  84. c.Data["json"] = lib.JSONS{Code: 202, Msg: "数据采集中,请稍后!"}
  85. c.ServeJSON()
  86. return
  87. }
  88. List := Task.Read_TaskData_ById_ClassList(Task_r.T_task_id)
  89. c.Data["json"] = lib.JSONS{Code: 200, Msg: "ok!", Data: List}
  90. c.ServeJSON()
  91. return
  92. }
  93. func (c *TaskDataController) TaskDataClass_Edit() {
  94. T_uuid, _ := lib.GetAdminT_Uuid(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey"))
  95. T_task_id := c.GetString("T_task_id")
  96. T_sn := c.GetString("T_sn")
  97. T_id := c.GetString("T_id")
  98. Task_r, err := NatsServer.Read_Task(T_task_id)
  99. if err != nil {
  100. c.Data["json"] = lib.JSONS{Code: 202, Msg: "T_task_id 错误!"}
  101. c.ServeJSON()
  102. return
  103. }
  104. err = Task.Update_TaskData_ByT_sn(Task_r.T_task_id, T_sn, T_id)
  105. if err != nil {
  106. c.Data["json"] = lib.JSONS{Code: 202, Msg: "修改失败!"}
  107. c.ServeJSON()
  108. return
  109. }
  110. System.Add_UserLogs_T(T_uuid, "本地版-任务分裂", "修改分类数据"+Task_r.T_name, Task_r.T_task_id+"|"+T_sn+"|"+T_id)
  111. c.Data["json"] = lib.JSONS{Code: 200, Msg: "ok!"}
  112. c.ServeJSON()
  113. return
  114. }
  115. func (c *TaskDataController) TaskDataClass_Del() {
  116. T_uuid, _ := lib.GetAdminT_Uuid(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey"))
  117. T_task_id := c.GetString("T_task_id")
  118. T_sn := c.GetString("T_sn")
  119. Task_r, err := NatsServer.Read_Task(T_task_id)
  120. if err != nil {
  121. c.Data["json"] = lib.JSONS{Code: 202, Msg: "T_task_id 错误!"}
  122. c.ServeJSON()
  123. return
  124. }
  125. err = Task.Delete_TaskData_ByT_sn(Task_r.T_task_id, T_sn)
  126. if err != nil {
  127. c.Data["json"] = lib.JSONS{Code: 202, Msg: "删除失败!"}
  128. c.ServeJSON()
  129. return
  130. }
  131. System.Add_UserLogs_T(T_uuid, "本地版-任务分裂", "删除分类数据"+Task_r.T_name, Task_r.T_task_id+"|"+T_sn)
  132. c.Data["json"] = lib.JSONS{Code: 200, Msg: "ok!"}
  133. c.ServeJSON()
  134. return
  135. }
  136. // 添加-
  137. func (c *TaskDataController) TaskData_AddS() {
  138. // 获取登录用户的uuid
  139. T_uuid, _ := lib.GetAdminT_Uuid(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey"))
  140. T_task_id := c.GetString("T_task_id")
  141. Task_r, err := NatsServer.Read_Task(T_task_id)
  142. if err != nil {
  143. c.Data["json"] = lib.JSONS{Code: 202, Msg: "T_task_id 错误!"}
  144. c.ServeJSON()
  145. return
  146. }
  147. //T_sn|T_id|T_t|T_rh|T_time?
  148. T_Data := c.GetString("T_Data")
  149. if len(T_Data) < 5 {
  150. c.Data["json"] = lib.JSONS{Code: 201, Msg: "err T_Data!"}
  151. c.ServeJSON()
  152. return
  153. }
  154. T_Data_list := strings.Split(T_Data, "?")
  155. println(len(T_Data_list), "len(T_Data_list)")
  156. var T_Data_list_x = 0
  157. for _, v := range T_Data_list {
  158. // 2022-08-09 14:25:00|27.7|55.2
  159. if len(v) < 5 {
  160. println(v, "len(v) < 5")
  161. continue
  162. }
  163. v_list := strings.Split(v, "|")
  164. is := Task.Add_TaskData(Task_r.T_task_id, v_list[0], v_list[1], v_list[2], v_list[3], v_list[4])
  165. if is {
  166. T_Data_list_x += 1
  167. }
  168. }
  169. System.Add_UserLogs_T(T_uuid, "本地版-任务数据", "添加数据"+Task_r.T_name, Task_r.T_task_id+"结果:"+string(len(T_Data_list))+"/"+string(T_Data_list_x)+"|=> "+T_Data)
  170. c.Data["json"] = lib.JSONS{Code: 200, Msg: "ok!", Data: strconv.Itoa(T_Data_list_x)}
  171. c.ServeJSON()
  172. return
  173. }
  174. // 添加-
  175. func (c *TaskDataController) TaskData_Add() {
  176. // 获取登录用户的uuid
  177. T_uuid, _ := lib.GetAdminT_Uuid(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey"))
  178. T_sn := c.GetString("T_sn")
  179. T_id, _ := c.GetInt("T_id")
  180. T_t, _ := c.GetFloat("T_t")
  181. T_rh, _ := c.GetFloat("T_rh")
  182. T_time := c.GetString("T_time")
  183. T_task_id := c.GetString("T_task_id")
  184. Task_r, err := NatsServer.Read_Task(T_task_id)
  185. if err != nil {
  186. c.Data["json"] = lib.JSONS{Code: 202, Msg: "T_task_id 错误!"}
  187. c.ServeJSON()
  188. return
  189. }
  190. is := Task.Add_TaskData(Task_r.T_task_id, T_sn, strconv.Itoa(T_id), fmt.Sprintf("%.2f", T_t), fmt.Sprintf("%.2f", T_rh), T_time)
  191. if !is {
  192. c.Data["json"] = lib.JSONS{Code: 202, Msg: "添加失败!"}
  193. c.ServeJSON()
  194. return
  195. }
  196. System.Add_UserLogs_T(T_uuid, "本地版-任务数据", "添加数据"+Task_r.T_name, Task_r.T_task_id+"|"+T_sn+"|"+strconv.Itoa(T_id)+"|"+fmt.Sprintf("%.2f", T_t)+"|"+fmt.Sprintf("%.2f", T_rh)+T_time)
  197. c.Data["json"] = lib.JSONS{Code: 200, Msg: "ok!"}
  198. c.ServeJSON()
  199. return
  200. }
  201. // 修改-
  202. func (c *TaskDataController) TaskData_Up() {
  203. // 获取登录用户的uuid
  204. T_uuid, _ := lib.GetAdminT_Uuid(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey"))
  205. Id, err := c.GetInt("Id")
  206. if err != nil {
  207. c.Data["json"] = lib.JSONS{Code: 201, Msg: "Id 错误!"}
  208. c.ServeJSON()
  209. return
  210. }
  211. T_t, err := c.GetFloat("T_t")
  212. if err != nil {
  213. c.Data["json"] = lib.JSONS{Code: 202, Msg: "T_t 错误!"}
  214. c.ServeJSON()
  215. return
  216. }
  217. T_rh, err := c.GetFloat("T_rh")
  218. if err != nil {
  219. c.Data["json"] = lib.JSONS{Code: 202, Msg: "T_rh 错误!"}
  220. c.ServeJSON()
  221. return
  222. }
  223. T_time := c.GetString("T_time")
  224. T_task_id := c.GetString("T_task_id")
  225. Task_r, err := NatsServer.Read_Task(T_task_id)
  226. if err != nil {
  227. c.Data["json"] = lib.JSONS{Code: 202, Msg: "T_task_id 错误!"}
  228. c.ServeJSON()
  229. return
  230. }
  231. is := Task.Up_TaskData(Task_r.T_task_id, strconv.Itoa(Id), fmt.Sprintf("%.2f", T_t), fmt.Sprintf("%.2f", T_rh), T_time)
  232. if !is {
  233. c.Data["json"] = lib.JSONS{Code: 202, Msg: "修改失败!"}
  234. c.ServeJSON()
  235. return
  236. }
  237. System.Add_UserLogs_T(T_uuid, "本地版-任务数据", "修改数据"+Task_r.T_name, Task_r.T_task_id+"|"+strconv.Itoa(Id)+"|"+fmt.Sprintf("%.2f", T_t)+"|"+fmt.Sprintf("%.2f", T_rh)+T_time)
  238. c.Data["json"] = lib.JSONS{Code: 200, Msg: "ok!"}
  239. c.ServeJSON()
  240. return
  241. }
  242. // 删除-
  243. func (c *TaskDataController) TaskData_Del() {
  244. // 获取登录用户的uuid
  245. T_uuid, _ := lib.GetAdminT_Uuid(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey"))
  246. Id, err := c.GetInt("Id")
  247. if err != nil {
  248. c.Data["json"] = lib.JSONS{Code: 201, Msg: "Id 错误!"}
  249. c.ServeJSON()
  250. return
  251. }
  252. T_task_id := c.GetString("T_task_id")
  253. Task_r, err := NatsServer.Read_Task(T_task_id)
  254. if err != nil {
  255. c.Data["json"] = lib.JSONS{Code: 202, Msg: "T_task_id 错误!"}
  256. c.ServeJSON()
  257. return
  258. }
  259. is := Task.Del_TaskData(Task_r.T_task_id, strconv.Itoa(Id))
  260. if !is {
  261. c.Data["json"] = lib.JSONS{Code: 202, Msg: "删除失败!"}
  262. c.ServeJSON()
  263. return
  264. }
  265. System.Add_UserLogs_T(T_uuid, "本地版-任务数据", "删除"+Task_r.T_name, Task_r.T_task_id+"|"+strconv.Itoa(Id))
  266. c.Data["json"] = lib.JSONS{Code: 200, Msg: "ok!"}
  267. c.ServeJSON()
  268. return
  269. }
  270. // 删除-
  271. func (c *TaskDataController) TaskData_Del_t_id() {
  272. // 获取登录用户的uuid
  273. T_uuid, _ := lib.GetAdminT_Uuid(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey"))
  274. Id, err := c.GetInt("Id")
  275. if err != nil {
  276. c.Data["json"] = lib.JSONS{Code: 201, Msg: "Id 错误!"}
  277. c.ServeJSON()
  278. return
  279. }
  280. T_task_id := c.GetString("T_task_id")
  281. Task_r, err := NatsServer.Read_Task(T_task_id)
  282. if err != nil {
  283. c.Data["json"] = lib.JSONS{Code: 202, Msg: "T_task_id 错误!"}
  284. c.ServeJSON()
  285. return
  286. }
  287. is := Task.Del_TaskData_t_id(Task_r.T_task_id, strconv.Itoa(Id))
  288. if !is {
  289. c.Data["json"] = lib.JSONS{Code: 202, Msg: "删除失败!"}
  290. c.ServeJSON()
  291. return
  292. }
  293. System.Add_UserLogs_T(T_uuid, "本地版-任务数据", "删除"+Task_r.T_name, Task_r.T_task_id+"|"+strconv.Itoa(Id))
  294. c.Data["json"] = lib.JSONS{Code: 200, Msg: "ok!"}
  295. c.ServeJSON()
  296. return
  297. }
  298. // 列表 - 接口
  299. func (c *TaskDataController) Export_Data_Excel() {
  300. Time_start := c.GetString("Time_start")
  301. Time_end := c.GetString("Time_end")
  302. T_sn_str := c.GetString("T_sn_list") //865901058809339,865901058815849,865901058818991,865901058810568
  303. //T_id, err := c.GetInt("T_id")
  304. //if err != nil {
  305. // T_id = -1
  306. //
  307. //}
  308. T_task_id := c.GetString("T_task_id")
  309. Task_r, err := NatsServer.Read_Task(T_task_id)
  310. if err != nil {
  311. c.Data["json"] = lib.JSONS{Code: 202, Msg: "T_task_id 错误!"}
  312. c.ServeJSON()
  313. return
  314. }
  315. if Task_r.T_collection_state == 2 {
  316. c.Data["json"] = lib.JSONS{Code: 202, Msg: "数据采集中,请稍后!"}
  317. c.ServeJSON()
  318. return
  319. }
  320. T_sn_list := strings.Split(T_sn_str, ",")
  321. DeviceSensor_data_list := []Task.TaskData_{}
  322. for _, v := range T_sn_list {
  323. DeviceSensor_data, _ := Task.Read_TaskData_ById_List(Task_r.T_task_id, v, -1, Time_start, Time_end, 1, 9999)
  324. DeviceSensor_data_list = append(DeviceSensor_data_list, DeviceSensor_data...)
  325. }
  326. f := excelize.NewFile() // 设置单元格的值
  327. // 这里设置表头
  328. f.SetCellValue("Sheet1", "A1", "编号")
  329. f.SetCellValue("Sheet1", "B1", "SN")
  330. f.SetCellValue("Sheet1", "C1", "温度℃")
  331. f.SetCellValue("Sheet1", "D1", "湿度%")
  332. f.SetCellValue("Sheet1", "E1", "记录时间")
  333. // 设置列宽
  334. f.SetColWidth("Sheet1", "A", "A", 7)
  335. f.SetColWidth("Sheet1", "B", "B", 20)
  336. f.SetColWidth("Sheet1", "C", "C", 10)
  337. f.SetColWidth("Sheet1", "D", "D", 10)
  338. f.SetColWidth("Sheet1", "E", "E", 22)
  339. line := 1
  340. // 循环写入数据
  341. for _, v := range DeviceSensor_data_list {
  342. line++
  343. f.SetCellValue("Sheet1", fmt.Sprintf("A%d", line), v.T_id)
  344. f.SetCellValue("Sheet1", fmt.Sprintf("B%d", line), v.T_sn)
  345. f.SetCellValue("Sheet1", fmt.Sprintf("C%d", line), strconv.FormatFloat(float64(v.T_t), 'f', 1, 64))
  346. f.SetCellValue("Sheet1", fmt.Sprintf("D%d", line), strconv.FormatFloat(float64(v.T_rh), 'f', 1, 64))
  347. f.SetCellValue("Sheet1", fmt.Sprintf("E%d", line), v.T_time)
  348. }
  349. fmt.Println("DeviceSensor_data:", len(DeviceSensor_data_list))
  350. lib.Create_Dir("./ofile")
  351. timeStr := time.Now().Format("20060102150405")
  352. // 保存文件
  353. if err := f.SaveAs("ofile/" + timeStr + ".xlsx"); err != nil {
  354. fmt.Println(err)
  355. }
  356. if !lib.Pload_qiniu("ofile/"+timeStr+".xlsx", "ofile/"+timeStr+".xlsx") {
  357. c.Data["json"] = lib.JSONS{Code: 203, Msg: "oss!"}
  358. c.ServeJSON()
  359. return
  360. }
  361. //删除目录
  362. //err = os.Remove("ofile/" + timeStr + ".xlsx")
  363. //if err != nil {
  364. // fmt.Println(err)
  365. //}
  366. c.Data["json"] = lib.JSONS{Code: 200, Msg: "ok!", Data: "https://bzdcoldverifyoss.baozhida.cn/" + "ofile/" + timeStr + ".xlsx"}
  367. c.ServeJSON()
  368. return
  369. }
  370. func (c *TaskDataController) Check() {
  371. T_task_id := c.GetString("T_task_id")
  372. Task_r, err := NatsServer.Read_Task(T_task_id)
  373. if Task_r.T_collection_state == 2 {
  374. c.Data["json"] = lib.JSONS{Code: 202, Msg: "数据采集中,请稍后!"}
  375. c.ServeJSON()
  376. return
  377. }
  378. if err != nil {
  379. c.Data["json"] = lib.JSONS{Code: 202, Msg: "T_task_id 错误!"}
  380. c.ServeJSON()
  381. return
  382. }
  383. type R_JSONS struct {
  384. T_sn string // SN
  385. T_id string // 编号
  386. T_unm int // 数据量
  387. T_time_interval int64 // 时间间隔
  388. Time_start string // 开始
  389. Time_end string // 结束
  390. Result int // 200 OK, 201 可以补 , 202 不能补
  391. Result_str string // 提示内容
  392. Result_Time_start string // 2022-8-05 21:01
  393. Result_Time_defect int64 // 缺失时间间隔
  394. }
  395. var r_jsons []R_JSONS
  396. List := Task.Read_TaskData_ById_ClassList(Task_r.T_task_id)
  397. for _, v := range List {
  398. var r_json R_JSONS
  399. r_json.T_sn = v.T_sn
  400. r_json.T_id = v.T_id
  401. r_json.Result = 200
  402. DeviceSensor_data := Task.Read_TaskData_ById_List_(Task_r.T_task_id, v.T_sn)
  403. r_json.T_unm = len(DeviceSensor_data)
  404. if r_json.T_unm > 2 {
  405. r_json.T_id = DeviceSensor_data[0].T_id
  406. r_json.Time_end = DeviceSensor_data[len(DeviceSensor_data)-1].T_time
  407. r_json.Time_start = DeviceSensor_data[0].T_time
  408. formatTime_a, _ := time.Parse("2006-1-2 15:04", DeviceSensor_data[0].T_time)
  409. formatTime_b, _ := time.Parse("2006-1-2 15:04", DeviceSensor_data[1].T_time)
  410. formatTime_x := formatTime_b.Unix() - formatTime_a.Unix()
  411. r_json.T_time_interval = formatTime_x
  412. println("formatTime_x:", v.T_id, v.T_sn, formatTime_x)
  413. if formatTime_x > 60*30 || formatTime_x < 60 {
  414. r_json.Result = 202
  415. r_json.Result_str = "数据异常(数据的第一个时间与第二个时间相差 " + strconv.FormatInt(formatTime_x, 10) + "秒),必须大于60秒,小于30分钟"
  416. r_jsons = append(r_jsons, r_json)
  417. continue
  418. }
  419. for data_i := 2; data_i < len(DeviceSensor_data); data_i++ {
  420. formatTime_a = formatTime_b
  421. formatTime_b, _ = time.Parse("2006-1-2 15:04", DeviceSensor_data[data_i].T_time)
  422. formatTime_ := formatTime_b.Unix() - formatTime_a.Unix()
  423. println("formatTime_x-:", formatTime_)
  424. if formatTime_ < formatTime_x {
  425. r_json.Result = 202
  426. r_json.Result_str = "开始时间:" + DeviceSensor_data[data_i-1].T_time + " 离下一条时间间隔:" + strconv.FormatInt(formatTime_, 10) + "秒,间隔小于时间间隔,不能自动补充"
  427. break
  428. }
  429. if formatTime_x != formatTime_ {
  430. if formatTime_ > 60*30 {
  431. r_json.Result = 202
  432. r_json.Result_str = "开始时间:" + DeviceSensor_data[data_i-1].T_time + " 离下一条时间间隔:" + strconv.FormatInt(formatTime_, 10) + "秒,相差时间大于30分钟,不能自动补充"
  433. break
  434. }
  435. r_json.Result = 201
  436. r_json.Result_str = "开始时间:" + DeviceSensor_data[data_i-1].T_time + " 离下一条时间间隔:" + strconv.FormatInt(formatTime_, 10) + "秒"
  437. r_json.Result_Time_start = DeviceSensor_data[data_i-1].T_time
  438. r_json.Result_Time_defect = formatTime_
  439. println(r_json.Result_str)
  440. break
  441. }
  442. }
  443. } else {
  444. r_json.Result = 202
  445. r_json.Result_str = "数据量太少 必须大于 2条以上!"
  446. }
  447. r_jsons = append(r_jsons, r_json)
  448. }
  449. c.Data["json"] = lib.JSONS{Code: 200, Msg: "ok!", Data: r_jsons}
  450. c.ServeJSON()
  451. return
  452. }
  453. func (c *TaskDataController) Check_Asyn() {
  454. T_task_id := c.GetString("T_task_id")
  455. Task_r, err := NatsServer.Read_Task(T_task_id)
  456. if Task_r.T_collection_state == 2 {
  457. c.Data["json"] = lib.JSONS{Code: 202, Msg: "数据采集中,请稍后!"}
  458. c.ServeJSON()
  459. return
  460. }
  461. if err != nil {
  462. c.Data["json"] = lib.JSONS{Code: 202, Msg: "T_task_id 错误!"}
  463. c.ServeJSON()
  464. return
  465. }
  466. type R_JSONS struct {
  467. T_sn string // SN
  468. T_id string // 编号
  469. T_unm int // 数据量
  470. T_time_interval int64 // 时间间隔
  471. Time_start string // 开始
  472. Time_end string // 结束
  473. Result int // 200 OK, 201 可以补 , 202 不能补
  474. Result_str string // 提示内容
  475. Result_Time_start string // 2022-8-05 21:01
  476. Result_Time_defect int64 // 缺失时间间隔
  477. }
  478. List := Task.Read_TaskData_ById_ClassList(Task_r.T_task_id)
  479. r_jsons := make([]R_JSONS, len(List))
  480. var limitMaxNum = 10
  481. var chData = make(chan int, limitMaxNum)
  482. var jobGroup sync.WaitGroup
  483. var tasknum = len(List)
  484. for i := 0; i < tasknum; i++ {
  485. chData <- 1
  486. jobGroup.Add(1)
  487. go func(index int, wg *sync.WaitGroup, res *[]R_JSONS) {
  488. defer wg.Done()
  489. var r_json R_JSONS
  490. r_json.T_sn = List[index].T_sn
  491. r_json.T_id = List[index].T_id
  492. r_json.Result = 200
  493. DeviceSensor_data := Task.Read_TaskData_ById_List_(Task_r.T_task_id, List[index].T_sn)
  494. r_json.T_unm = len(DeviceSensor_data)
  495. if r_json.T_unm > 2 {
  496. r_json.T_id = DeviceSensor_data[0].T_id
  497. r_json.Time_end = DeviceSensor_data[len(DeviceSensor_data)-1].T_time
  498. r_json.Time_start = DeviceSensor_data[0].T_time
  499. formatTime_a, _ := time.Parse("2006-1-2 15:04", DeviceSensor_data[0].T_time)
  500. formatTime_b, _ := time.Parse("2006-1-2 15:04", DeviceSensor_data[1].T_time)
  501. formatTime_x := formatTime_b.Unix() - formatTime_a.Unix()
  502. r_json.T_time_interval = formatTime_x
  503. println("formatTime_x:", List[index].T_id, List[index].T_sn, formatTime_x)
  504. if formatTime_x > 60*30 || formatTime_x < 60 {
  505. r_json.Result = 202
  506. r_json.Result_str = "数据异常(数据的第一个时间与第二个时间相差 " + strconv.FormatInt(formatTime_x, 10) + "秒),必须大于60秒,小于30分钟"
  507. *res = append(*res, r_json)
  508. <-chData
  509. return
  510. }
  511. for data_i := 2; data_i < len(DeviceSensor_data); data_i++ {
  512. formatTime_a = formatTime_b
  513. formatTime_b, _ = time.Parse("2006-1-2 15:04", DeviceSensor_data[data_i].T_time)
  514. formatTime_ := formatTime_b.Unix() - formatTime_a.Unix()
  515. if formatTime_ < formatTime_x {
  516. println("formatTime_x-:", formatTime_)
  517. r_json.Result = 202
  518. r_json.Result_str = "开始时间:" + DeviceSensor_data[data_i-1].T_time + " 离下一条时间间隔:" + strconv.FormatInt(formatTime_, 10) + "秒,间隔小于时间间隔,不能自动补充"
  519. break
  520. }
  521. if formatTime_x != formatTime_ {
  522. if formatTime_ > 60*30 {
  523. println("formatTime_x-:", formatTime_)
  524. r_json.Result = 202
  525. r_json.Result_str = "开始时间:" + DeviceSensor_data[data_i-1].T_time + " 离下一条时间间隔:" + strconv.FormatInt(formatTime_, 10) + "秒,相差时间大于30分钟,不能自动补充"
  526. break
  527. }
  528. r_json.Result = 202
  529. r_json.Result_str = "开始时间:" + DeviceSensor_data[data_i-1].T_time + " 离下一条时间间隔:" + strconv.FormatInt(formatTime_, 10) + "秒"
  530. r_json.Result_Time_start = DeviceSensor_data[data_i-1].T_time
  531. r_json.Result_Time_defect = formatTime_
  532. println(r_json.Result_str)
  533. break
  534. }
  535. }
  536. } else {
  537. r_json.Result = 202
  538. r_json.Result_str = "数据量太少 必须大于 2条以上!"
  539. }
  540. *res = append(*res, r_json)
  541. <-chData
  542. }(i, &jobGroup, &r_jsons)
  543. }
  544. //使用Wait等待所有任务执行完毕
  545. jobGroup.Wait()
  546. jsonsMap := map[string]R_JSONS{}
  547. resp := make([]R_JSONS, 0)
  548. for _, json := range r_jsons {
  549. jsonsMap[json.T_id] = json
  550. }
  551. for _, v := range List {
  552. resp = append(resp, jsonsMap[v.T_id])
  553. }
  554. c.Data["json"] = lib.JSONS{Code: 200, Msg: "ok!", Data: resp}
  555. c.ServeJSON()
  556. return
  557. }
  558. // 打包数据本地数据
  559. func (c *TaskDataController) TaskData_Import_TaskData() {
  560. // 获取登录用户的uuid
  561. T_uuid, _ := lib.GetAdminT_Uuid(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey"))
  562. T_task_id := c.GetString("T_task_id")
  563. _, err := NatsServer.Read_Task(T_task_id)
  564. if err != nil {
  565. c.Data["json"] = lib.JSONS{Code: 202, Msg: "T_task_id 错误!"}
  566. c.ServeJSON()
  567. return
  568. }
  569. if err = lib.Create_Dir(conf.Sql_Temp_Dir); err != nil {
  570. logs.Println("创建sql临时文件失败")
  571. }
  572. sql_file := fmt.Sprintf("%sZ_TaskData_%s.sql", conf.Sql_Temp_Dir, T_task_id)
  573. org, err := Task.Dump_TaskData(T_task_id, conf.MysqlServer2_Username, conf.MysqlServer2_Password, conf.MysqlServer2_UrlPort, conf.MysqlServer2_Database, sql_file)
  574. if err != nil {
  575. c.Data["json"] = lib.JSONS{Code: 202, Msg: "z_task_data_" + T_task_id + "线上数据导出失败!"}
  576. c.ServeJSON()
  577. return
  578. }
  579. System.Add_UserLogs_T(T_uuid, "本地版-任务数据-打包本地数据", "导出线上数据Z_TaskData_"+T_task_id, org)
  580. i := 0
  581. flag := false
  582. Task.CREATE_TaskData(conf.Local_AliasName, T_task_id)
  583. for i < 10 {
  584. Task.Truncate_TaskData(conf.Local_AliasName, T_task_id)
  585. org, err = Task.Insert_TaskData(conf.MysqlServer_Username, conf.MysqlServer_Password, conf.MysqlServer_UrlPort, conf.MysqlServer_Database, sql_file)
  586. if err != nil {
  587. logs.Println("任务数据-打包本地数据", "线下导入数据Z_TaskData_"+T_task_id, err.Error())
  588. } else {
  589. if Task.Check_TaskData_Num(T_task_id) {
  590. System.Add_UserLogs_T(T_uuid, "本地版-任务数据-打包本地数据", "线下导入数据Z_TaskData_"+T_task_id, org)
  591. flag = true
  592. break
  593. }
  594. }
  595. i++
  596. }
  597. // 重试10次后仍然没有成功导入数据
  598. if !flag {
  599. c.Data["json"] = lib.JSONS{Code: 202, Msg: "z_task_data_" + T_task_id + "线下导入数据失败!"}
  600. c.ServeJSON()
  601. return
  602. }
  603. //删除导出的sql文件
  604. _ = os.Remove(sql_file)
  605. c.Data["json"] = lib.JSONS{Code: 200, Msg: "ok!"}
  606. c.ServeJSON()
  607. }
  608. // 更新线上数据
  609. func (c *TaskDataController) TaskData_Up_TaskData() {
  610. // 获取登录用户的uuid
  611. T_uuid, _ := lib.GetAdminT_Uuid(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey"))
  612. T_task_id := c.GetString("T_task_id")
  613. Task_r, err := NatsServer.Read_Task(T_task_id)
  614. if err != nil {
  615. c.Data["json"] = lib.JSONS{Code: 202, Msg: "T_task_id 错误!"}
  616. c.ServeJSON()
  617. return
  618. }
  619. if err = lib.Create_Dir(conf.Sql_Temp_Dir); err != nil {
  620. logs.Println("创建sql临时文件失败")
  621. }
  622. sql_file := fmt.Sprintf("%sZ_TaskData_%s.sql", conf.Sql_Temp_Dir, T_task_id)
  623. org, err := Task.Dump_TaskData(T_task_id, conf.MysqlServer_Username, conf.MysqlServer_Password, conf.MysqlServer_UrlPort, conf.MysqlServer_Database, sql_file)
  624. if err != nil {
  625. logs.Println(T_uuid, "任务数据-更新线上数据", "导出线下数据Z_TaskData_"+T_task_id, err.Error())
  626. c.Data["json"] = lib.JSONS{Code: 202, Msg: "z_task_data_" + T_task_id + "线下数据导出失败!"}
  627. c.ServeJSON()
  628. return
  629. }
  630. System.Add_UserLogs_T(T_uuid, "本地版-任务数据-更新线上数据", "线上导入数据Z_TaskData_"+T_task_id, org)
  631. i := 0
  632. flag := false
  633. for i < 10 {
  634. Task.Truncate_TaskData(conf.Server_AliasName, T_task_id)
  635. org, err = Task.Insert_TaskData(conf.MysqlServer2_Username, conf.MysqlServer2_Password, conf.MysqlServer2_UrlPort, conf.MysqlServer2_Database, sql_file)
  636. if err != nil {
  637. logs.Println(T_uuid, "任务数据-更新线上数据", "线上导入数据Z_TaskData_"+T_task_id, err.Error())
  638. } else {
  639. if Task.Check_TaskData_Num(T_task_id) {
  640. System.Add_UserLogs_T(T_uuid, "本地版-任务数据-更新线上数据", "线上导入数据Z_TaskData_"+T_task_id, org)
  641. flag = true
  642. break
  643. }
  644. }
  645. i++
  646. }
  647. // 重试10次后仍然没有成功导入数据
  648. if !flag {
  649. c.Data["json"] = lib.JSONS{Code: 202, Msg: "z_task_data_" + T_task_id + "线上导入数据失败!"}
  650. c.ServeJSON()
  651. return
  652. }
  653. //删除导出的sql文件
  654. _ = os.Remove(sql_file)
  655. // 线上数据更新后 将当前任务 交付审核 标志 为 1
  656. Task_r.T_delivery_state = 1
  657. err = NatsServer.Update_Task(Task_r)
  658. if err != nil {
  659. c.Data["json"] = lib.JSONS{Code: 202, Msg: "修改失败!"}
  660. c.ServeJSON()
  661. return
  662. }
  663. // 向线上用户日志表写入数据
  664. System.Add_UserLogs_T(T_uuid, "本地版-任务", "修改", Task_r)
  665. c.Data["json"] = lib.JSONS{Code: 200, Msg: "ok!"}
  666. c.ServeJSON()
  667. }
  668. // 更新线上数据后台执行
  669. func (c *TaskDataController) TaskData_Up_TaskData_Back() {
  670. // 获取登录用户的uuid
  671. T_uuid, _ := lib.GetAdminT_Uuid(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey"))
  672. T_task_id := c.GetString("T_task_id")
  673. Task_r, err := NatsServer.Read_Task(T_task_id)
  674. if err != nil {
  675. c.Data["json"] = lib.JSONS{Code: 202, Msg: "T_task_id 错误!"}
  676. c.ServeJSON()
  677. return
  678. }
  679. if Task_r.T_delivery_state == 2 {
  680. c.Data["json"] = lib.JSONS{Code: 200, Msg: "ok!"}
  681. c.ServeJSON()
  682. return
  683. }
  684. // 采集中
  685. Task_r.T_delivery_state = 2
  686. err = NatsServer.Update_Task(Task_r)
  687. if err != nil {
  688. c.Data["json"] = lib.JSONS{Code: 202, Msg: "提交失败!"}
  689. c.ServeJSON()
  690. return
  691. }
  692. data := Nats.Up_TaskData_Back{
  693. T_uuid: T_uuid,
  694. Task: Task_r,
  695. }
  696. b, _ := msgpack.Marshal(&data)
  697. _ = lib.Nats.Publish("ColdVerify_Local_Up_TaskData", b)
  698. c.Data["json"] = lib.JSONS{Code: 200, Msg: "ok!"}
  699. c.ServeJSON()
  700. return
  701. }
  702. // CopyFromPosition 数据拷贝
  703. func (c *TaskDataController) CopyFromPosition() {
  704. T_uuid, _ := lib.GetAdminT_Uuid(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey"))
  705. //if !b_ {
  706. // c.Data["json"] = lib.JSONS{Code: 201, Msg: "User_tokey Err!"}
  707. // c.ServeJSON()
  708. // return
  709. //}
  710. StartTime := c.GetString("StartTime")
  711. startTime, ok := lib.TimeStrToTime(StartTime)
  712. if !ok {
  713. c.Data["json"] = lib.JSONS{Code: 202, Msg: "时间格式错误!"}
  714. c.ServeJSON()
  715. return
  716. }
  717. EndTime := c.GetString("EndTime")
  718. endTime, ok := lib.TimeStrToTime(EndTime)
  719. if !ok {
  720. c.Data["json"] = lib.JSONS{Code: 202, Msg: "时间格式错误!"}
  721. c.ServeJSON()
  722. return
  723. }
  724. CopyTime := c.GetString("CopyTime")
  725. copyTime, ok := lib.TimeStrToTime(CopyTime)
  726. if !ok {
  727. c.Data["json"] = lib.JSONS{Code: 202, Msg: "时间格式错误!"}
  728. c.ServeJSON()
  729. return
  730. }
  731. CopyEndTime := copyTime.Add(endTime.Sub(startTime)).Format("2006-01-02 15:04:05")
  732. // 时间间隔 分钟
  733. T_saveT, _ := c.GetInt("T_saveT")
  734. SN_List := strings.Split(strings.Trim(c.GetString("SN_List"), "|"), "|")
  735. T_task_id := c.GetString("T_task_id")
  736. Task_r, err := NatsServer.Read_Task(T_task_id)
  737. if err != nil {
  738. c.Data["json"] = lib.JSONS{Code: 202, Msg: "T_task_id 错误!"}
  739. c.ServeJSON()
  740. return
  741. }
  742. if Task_r.T_collection_state == 2 {
  743. c.Data["json"] = lib.JSONS{Code: 202, Msg: "数据采集中,请稍后!"}
  744. c.ServeJSON()
  745. return
  746. }
  747. for _, v := range SN_List {
  748. sn_id := strings.Split(v, ",")
  749. if len(sn_id) != 2 {
  750. continue
  751. }
  752. sn, id_str := sn_id[0], sn_id[1]
  753. id, _ := strconv.Atoi(id_str)
  754. Task.DeleteTaskDataByTimeRange(Task_r.T_task_id, sn, id, CopyTime, CopyEndTime)
  755. List, _ := Task.Read_TaskData_ById_List_AES(Task_r.T_task_id, sn, id, StartTime, EndTime, 0, 9999)
  756. ct := copyTime
  757. go func(TaskDataList []Task.TaskData_, task_id string, T_saveT int) {
  758. for _, taskData := range TaskDataList {
  759. taskData.T_time = ct.Format("2006-01-02 15:04:05")
  760. Task.InsertTaskData(task_id, taskData)
  761. ct = ct.Add(time.Second * time.Duration(T_saveT))
  762. }
  763. }(List, Task_r.T_task_id, T_saveT)
  764. }
  765. System.Add_UserLogs_T(T_uuid, "数据复制", fmt.Sprintf("数据复制(%s)[%s|%s],复制时间:%s,,时间间隔:%d", T_task_id, StartTime, EndTime, CopyTime, T_saveT), SN_List)
  766. c.Data["json"] = lib.JSONS{200, "数据复制已提交后台处理!", nil}
  767. c.ServeJSON()
  768. return
  769. }
  770. // RepairSensorData 数据补漏
  771. func (c *TaskDataController) RepairSensorData() {
  772. T_uuid, _ := lib.GetAdminT_Uuid(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey"))
  773. //if !b_ {
  774. // c.Data["json"] = lib.JSONS{Code: 201, Msg: "User_tokey Err!"}
  775. // c.ServeJSON()
  776. // return
  777. //}
  778. StartTime := c.GetString("StartTime")
  779. _, ok := lib.TimeStrToTime(StartTime)
  780. if !ok {
  781. c.Data["json"] = lib.JSONS{Code: 202, Msg: "时间格式错误!"}
  782. c.ServeJSON()
  783. return
  784. }
  785. EndTime := c.GetString("EndTime")
  786. _, ok = lib.TimeStrToTime(EndTime)
  787. if !ok {
  788. c.Data["json"] = lib.JSONS{Code: 202, Msg: "时间格式错误!"}
  789. c.ServeJSON()
  790. return
  791. }
  792. // 时间间隔 秒
  793. saveTime, _ := c.GetInt("T_saveT")
  794. SN_List := strings.Split(strings.Trim(c.GetString("SN_List"), "|"), "|")
  795. T_task_id := c.GetString("T_task_id")
  796. Task_r, err := NatsServer.Read_Task(T_task_id)
  797. if err != nil {
  798. c.Data["json"] = lib.JSONS{Code: 202, Msg: "T_task_id 错误!"}
  799. c.ServeJSON()
  800. return
  801. }
  802. if Task_r.T_collection_state == 2 {
  803. c.Data["json"] = lib.JSONS{Code: 202, Msg: "数据采集中,请稍后!"}
  804. c.ServeJSON()
  805. return
  806. }
  807. num := 0
  808. for _, v := range SN_List {
  809. sn_id := strings.Split(v, ",")
  810. if len(sn_id) != 2 {
  811. continue
  812. }
  813. sn, id_str := sn_id[0], sn_id[1]
  814. id, _ := strconv.Atoi(id_str)
  815. list, _ := Task.Read_TaskData_ById_List_AES(Task_r.T_task_id, sn, id, StartTime, EndTime, 0, 9999)
  816. for i := 0; i < len(list)-1; i++ {
  817. current := list[i].T_time
  818. next := list[i+1].T_time
  819. c, _ := time.Parse("2006-01-02 15:04:05", current)
  820. n, _ := time.Parse("2006-01-02 15:04:05", next)
  821. interval := n.Unix() - c.Unix()
  822. logs.Debug("时间间隔:", interval, "保存时间:", saveTime)
  823. fmt.Println("当前:", current, "下一个:", next)
  824. if int(interval) > saveTime {
  825. ttInterval := list[i+1].T_t - list[i].T_t
  826. ttt := list[i].T_t // 温度临时变量
  827. trhInterval := list[i+1].T_rh - list[i].T_rh
  828. trht := list[i].T_rh //湿度临时变量
  829. count := (int(interval) - saveTime) / saveTime
  830. if int(interval)%saveTime != 0 {
  831. count++
  832. }
  833. num += count
  834. for k := 0; k < count; k++ {
  835. t := c.Add(time.Second * time.Duration(saveTime)).Format("2006-01-02 15:04:05") //时间临时变量
  836. ttt += ttInterval / float32(count)
  837. trht += trhInterval / float32(count)
  838. Task.InsertTaskData(Task_r.T_task_id, Task.TaskData_{
  839. T_sn: list[i].T_sn,
  840. T_id: list[i].T_id,
  841. T_t: ttt,
  842. T_rh: trht,
  843. T_time: t,
  844. })
  845. c = c.Add(time.Second * time.Duration(saveTime))
  846. }
  847. }
  848. }
  849. }
  850. System.Add_UserLogs_T(T_uuid, "数据补漏", fmt.Sprintf("数据补漏(%s)[%s|%s],时间间隔:%d", T_task_id, StartTime, EndTime, saveTime), SN_List)
  851. c.Data["json"] = lib.JSONS{200, fmt.Sprintf("补漏完成!共补漏%d条数据", num), nil}
  852. c.ServeJSON()
  853. return
  854. }
  855. // DataSensorDataTrend 数据趋势
  856. func (c *TaskDataController) DataSensorDataTrend() {
  857. T_uuid, _ := lib.GetAdminT_Uuid(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey"))
  858. //if !b_ {
  859. // c.Data["json"] = lib.JSONS{Code: 201, Msg: "User_tokey Err!"}
  860. // c.ServeJSON()
  861. // return
  862. //}
  863. StartTime := c.GetString("StartTime")
  864. _, ok := lib.TimeStrToTime(StartTime)
  865. if !ok {
  866. c.Data["json"] = lib.JSONS{Code: 202, Msg: "时间格式错误!"}
  867. c.ServeJSON()
  868. return
  869. }
  870. EndTime := c.GetString("EndTime")
  871. _, ok = lib.TimeStrToTime(EndTime)
  872. if !ok {
  873. c.Data["json"] = lib.JSONS{Code: 202, Msg: "时间格式错误!"}
  874. c.ServeJSON()
  875. return
  876. }
  877. // 时间间隔 秒
  878. saveTime, _ := c.GetInt("T_saveT")
  879. SN_List := strings.Split(strings.Trim(c.GetString("SN_List"), "|"), "|")
  880. T_task_id := c.GetString("T_task_id")
  881. Task_r, err := NatsServer.Read_Task(T_task_id)
  882. if err != nil {
  883. c.Data["json"] = lib.JSONS{Code: 202, Msg: "T_task_id 错误!"}
  884. c.ServeJSON()
  885. return
  886. }
  887. if Task_r.T_collection_state == 2 {
  888. c.Data["json"] = lib.JSONS{Code: 202, Msg: "数据采集中,请稍后!"}
  889. c.ServeJSON()
  890. return
  891. }
  892. for _, v := range SN_List {
  893. sn_id := strings.Split(v, ",")
  894. if len(sn_id) != 2 {
  895. continue
  896. }
  897. sn, id_str := sn_id[0], sn_id[1]
  898. id, _ := strconv.Atoi(id_str)
  899. list, _ := Task.Read_TaskData_ById_List_AES(Task_r.T_task_id, sn, id, StartTime, EndTime, 0, 9999)
  900. if len(list) == 0 {
  901. continue
  902. }
  903. Task.DeleteTaskDataByTimeRange(Task_r.T_task_id, sn, id, StartTime, EndTime)
  904. first := list[0]
  905. last := list[len(list)-1]
  906. current, _ := time.Parse("2006-01-02 15:04:05", first.T_time)
  907. next, _ := time.Parse("2006-01-02 15:04:05", last.T_time)
  908. interval := next.Sub(current).Seconds() / float64(saveTime)
  909. ttInterval := (last.T_t - first.T_t) / float32(interval)
  910. trhInterval := (last.T_rh - first.T_rh) / float32(interval)
  911. tt := first.T_t
  912. ttrh := first.T_rh
  913. for current.Unix() < next.Unix() {
  914. tt += ttInterval
  915. ttrh += trhInterval
  916. ttime := current.Format("2006-01-02 15:04:05")
  917. Task.InsertTaskData(Task_r.T_task_id, Task.TaskData_{
  918. //加保存时间
  919. T_sn: first.T_sn,
  920. T_id: strconv.Itoa(id),
  921. T_t: tt,
  922. T_rh: ttrh,
  923. T_time: ttime,
  924. })
  925. current = current.Add(time.Second * time.Duration(saveTime))
  926. }
  927. }
  928. System.Add_UserLogs_T(T_uuid, "数据趋势", fmt.Sprintf("数据趋势(%s)[%s|%s],时间间隔:%d", T_task_id, StartTime, EndTime, saveTime), SN_List)
  929. c.Data["json"] = lib.JSONS{200, "设置趋势操作成功", nil}
  930. c.ServeJSON()
  931. return
  932. }
  933. // UpdateRand 数据随机
  934. func (c *TaskDataController) UpdateRand() {
  935. T_uuid, _ := lib.GetAdminT_Uuid(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey"))
  936. //if !b_ {
  937. // c.Data["json"] = lib.JSONS{Code: 201, Msg: "User_tokey Err!"}
  938. // c.ServeJSON()
  939. // return
  940. //}
  941. StartTime := c.GetString("StartTime")
  942. _, ok := lib.TimeStrToTime(StartTime)
  943. if !ok {
  944. c.Data["json"] = lib.JSONS{Code: 202, Msg: "时间格式错误!"}
  945. c.ServeJSON()
  946. return
  947. }
  948. EndTime := c.GetString("EndTime")
  949. _, ok = lib.TimeStrToTime(EndTime)
  950. if !ok {
  951. c.Data["json"] = lib.JSONS{Code: 202, Msg: "时间格式错误!"}
  952. c.ServeJSON()
  953. return
  954. }
  955. TemperatureMin, _ := c.GetInt("TemperatureMin") // 温度
  956. TemperatureMax, _ := c.GetInt("TemperatureMax")
  957. HumidityMax, _ := c.GetInt("HumidityMax") // 湿度
  958. HumidityMin, _ := c.GetInt("HumidityMin")
  959. SN_List := strings.Split(strings.Trim(c.GetString("SN_List"), "|"), "|")
  960. T_task_id := c.GetString("T_task_id")
  961. Task_r, err := NatsServer.Read_Task(T_task_id)
  962. if err != nil {
  963. c.Data["json"] = lib.JSONS{Code: 202, Msg: "T_task_id 错误!"}
  964. c.ServeJSON()
  965. return
  966. }
  967. if Task_r.T_collection_state == 2 {
  968. c.Data["json"] = lib.JSONS{Code: 202, Msg: "数据采集中,请稍后!"}
  969. c.ServeJSON()
  970. return
  971. }
  972. for _, v := range SN_List {
  973. sn_id := strings.Split(v, ",")
  974. if len(sn_id) != 2 {
  975. continue
  976. }
  977. sn, id := sn_id[0], sn_id[1]
  978. Task.UpdateTaskDataTemperatureAndHumidityRandom(Task_r.T_task_id, sn, id, StartTime, EndTime, TemperatureMax, TemperatureMin, HumidityMax, HumidityMin)
  979. }
  980. System.Add_UserLogs_T(T_uuid, "数据随机", fmt.Sprintf("数据随机(%s)[%s|%s],温度[%d-%d],湿度[%d-%d]", T_task_id, StartTime, EndTime, TemperatureMin, TemperatureMax, HumidityMax, HumidityMin), SN_List)
  981. //反馈成功
  982. c.Data["json"] = lib.JSONS{200, "调整随机偏移值成功!", nil}
  983. c.ServeJSON()
  984. return
  985. }
  986. // UpdateFix 更新固定值
  987. func (c *TaskDataController) UpdateFix() {
  988. T_uuid, _ := lib.GetAdminT_Uuid(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey"))
  989. //if !b_ {
  990. // c.Data["json"] = lib.JSONS{Code: 201, Msg: "User_tokey Err!"}
  991. // c.ServeJSON()
  992. // return
  993. //}
  994. StartTime := c.GetString("StartTime")
  995. _, ok := lib.TimeStrToTime(StartTime)
  996. if !ok {
  997. c.Data["json"] = lib.JSONS{Code: 202, Msg: "时间格式错误!"}
  998. c.ServeJSON()
  999. return
  1000. }
  1001. EndTime := c.GetString("EndTime")
  1002. _, ok = lib.TimeStrToTime(EndTime)
  1003. if !ok {
  1004. c.Data["json"] = lib.JSONS{Code: 202, Msg: "时间格式错误!"}
  1005. c.ServeJSON()
  1006. return
  1007. }
  1008. FixTemperature := c.GetString("FixTemperature")
  1009. FixHumidity := c.GetString("FixHumidity")
  1010. //2.得到数据进行统一设置访问修改
  1011. humidity, _ := strconv.ParseFloat(FixHumidity, 64)
  1012. temperature, _ := strconv.ParseFloat(FixTemperature, 64)
  1013. SN_List := strings.Split(strings.Trim(c.GetString("SN_List"), "|"), "|")
  1014. T_task_id := c.GetString("T_task_id")
  1015. Task_r, err := NatsServer.Read_Task(T_task_id)
  1016. if err != nil {
  1017. c.Data["json"] = lib.JSONS{Code: 202, Msg: "T_task_id 错误!"}
  1018. c.ServeJSON()
  1019. return
  1020. }
  1021. if Task_r.T_collection_state == 2 {
  1022. c.Data["json"] = lib.JSONS{Code: 202, Msg: "数据采集中,请稍后!"}
  1023. c.ServeJSON()
  1024. return
  1025. }
  1026. //3.循环更新数据
  1027. for _, v := range SN_List {
  1028. sn_id := strings.Split(v, ",")
  1029. if len(sn_id) != 2 {
  1030. continue
  1031. }
  1032. sn, id := sn_id[0], sn_id[1]
  1033. Task.UpdateTaskDataTemperatureAndHumidity(Task_r.T_task_id, sn, id, StartTime, EndTime, temperature, humidity)
  1034. }
  1035. System.Add_UserLogs_T(T_uuid, "更新固定值", fmt.Sprintf("更新固定值(%s)[%s|%s],温度[%f],湿度[%f]", T_task_id, StartTime, EndTime, temperature, humidity), SN_List)
  1036. //4.反馈成功
  1037. c.Data["json"] = lib.JSONS{200, "调整固定偏移值成功!", nil}
  1038. c.ServeJSON()
  1039. }
  1040. // DataSensorDataSmooth 数据平滑
  1041. func (c *TaskDataController) DataSensorDataSmooth() {
  1042. T_uuid, _ := lib.GetAdminT_Uuid(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey"))
  1043. //if !b_ {
  1044. // c.Data["json"] = lib.JSONS{Code: 201, Msg: "User_tokey Err!"}
  1045. // c.ServeJSON()
  1046. // return
  1047. //}
  1048. StartTime := c.GetString("StartTime")
  1049. _, ok := lib.TimeStrToTime(StartTime)
  1050. if !ok {
  1051. c.Data["json"] = lib.JSONS{Code: 202, Msg: "时间格式错误!"}
  1052. c.ServeJSON()
  1053. return
  1054. }
  1055. EndTime := c.GetString("EndTime")
  1056. _, ok = lib.TimeStrToTime(EndTime)
  1057. if !ok {
  1058. c.Data["json"] = lib.JSONS{Code: 202, Msg: "时间格式错误!"}
  1059. c.ServeJSON()
  1060. return
  1061. }
  1062. tRange, _ := c.GetFloat("tRange")
  1063. hRange, _ := c.GetFloat("hRange")
  1064. SN_List := strings.Split(strings.Trim(c.GetString("SN_List"), "|"), "|")
  1065. T_task_id := c.GetString("T_task_id")
  1066. Task_r, err := NatsServer.Read_Task(T_task_id)
  1067. if err != nil {
  1068. c.Data["json"] = lib.JSONS{Code: 202, Msg: "T_task_id 错误!"}
  1069. c.ServeJSON()
  1070. return
  1071. }
  1072. if Task_r.T_collection_state == 2 {
  1073. c.Data["json"] = lib.JSONS{Code: 202, Msg: "数据采集中,请稍后!"}
  1074. c.ServeJSON()
  1075. return
  1076. }
  1077. var count int
  1078. for _, v := range SN_List {
  1079. sn_id := strings.Split(v, ",")
  1080. if len(sn_id) != 2 {
  1081. continue
  1082. }
  1083. sn := sn_id[0]
  1084. id_str := sn_id[1]
  1085. id, _ := strconv.Atoi(id_str)
  1086. list, _ := Task.Read_TaskData_ById_List_AES(Task_r.T_task_id, sn, id, StartTime, EndTime, 0, 9999)
  1087. for i := 1; i < len(list); i++ {
  1088. n := list[i-1]
  1089. old := list[i]
  1090. newO := list[i]
  1091. //变化差
  1092. var tInterval = old.T_t - n.T_t
  1093. var hInterval = old.T_rh - n.T_rh
  1094. fmt.Println("温度:", n.T_t, "温度next:", old.T_t, "差值:", n.T_t-old.T_t)
  1095. if tRange != 0 {
  1096. if tInterval > float32(tRange) {
  1097. newO.T_t = n.T_t + float32(tRange)
  1098. } else if tInterval < -float32(tRange) {
  1099. newO.T_t = n.T_t - float32(tRange)
  1100. }
  1101. }
  1102. if hRange != 0 {
  1103. if hInterval > float32(hRange) {
  1104. newO.T_rh = n.T_rh + float32(hRange)
  1105. } else if hInterval < -float32(hRange) {
  1106. newO.T_rh = n.T_rh - float32(hRange)
  1107. }
  1108. }
  1109. if old.T_rh != newO.T_rh || old.T_t != newO.T_t {
  1110. fmt.Println("原始数据:", old, "新数据:", newO)
  1111. list[i] = newO
  1112. Task.UpdateTaskData(Task_r.T_task_id, sn, id_str, old, newO)
  1113. count++
  1114. }
  1115. }
  1116. }
  1117. System.Add_UserLogs_T(T_uuid, "数据平滑", fmt.Sprintf("数据平滑(%s)[%s|%s],温度[%f],湿度[%f]", T_task_id, StartTime, EndTime, tRange, hRange), SN_List)
  1118. c.Data["json"] = lib.JSONS{200, "操作成功处理" + fmt.Sprint(count) + "条数据", nil}
  1119. c.ServeJSON()
  1120. }