task.go 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731
  1. package services
  2. import (
  3. "context"
  4. "errors"
  5. "fmt"
  6. "github.com/beego/beego/v2/task"
  7. "hongze/hongze_task/models"
  8. "hongze/hongze_task/services/company_contract"
  9. "hongze/hongze_task/services/data"
  10. "hongze/hongze_task/utils"
  11. "strconv"
  12. "strings"
  13. "sync"
  14. "time"
  15. )
  16. func Task() {
  17. fmt.Println("task start")
  18. //如果是生产环境,才需要走这些任务
  19. if utils.RunMode == "release" {
  20. releaseTask()
  21. }
  22. //每日定时合同处理
  23. handleCompanyContract := task.NewTask("handleCompanyContract", "0 1 2 * * *", company_contract.HandleCompanyContract)
  24. task.AddTask("每日定时合同处理", handleCompanyContract)
  25. //正式->试用
  26. companyTryOut := task.NewTask("companyTryOut", "0 5 2 * * *", CompanyTryOut)
  27. task.AddTask("正式->试用", companyTryOut)
  28. //试用->冻结
  29. companyFreeze := task.NewTask("companyFreeze", "0 10 2 * * *", CompanyFreeze)
  30. task.AddTask("试用->冻结", companyFreeze)
  31. //冻结->流失
  32. companyLoss := task.NewTask("companyLoss", "0 20 2 * * *", CompanyLoss)
  33. task.AddTask("冻结->流失", companyLoss)
  34. //用户产品权限试用-->关闭
  35. companyReportPermissionClose := task.NewTask("companyReportPermissionClose", "0 30 2 * * *", CompanyReportPermissionClose)
  36. task.AddTask("用户产品权限试用-->关闭", companyReportPermissionClose)
  37. //删除日志记录
  38. //deleteReportSaveLog := task.NewTask("deleteReportSaveLog", "0 30 08 * * *", DeleteReportSaveLog)
  39. //task.AddTask("deleteReportSaveLog", deleteReportSaveLog)
  40. // 存量客户数据统计
  41. stackCompanyStatistic := task.NewTask("stackCompanyStatistic", "0 35 2 * * *", StackCompanyStatistic)
  42. task.AddTask("存量客户数据统计", stackCompanyStatistic)
  43. // 定时往同花顺推送报告
  44. sendWaitReport := task.NewTask("sendWaitReport", "0 */1 * * * * ", SendWaitReport)
  45. task.AddTask("定时往同花顺推送报告", sendWaitReport)
  46. // 研报电话会提醒
  47. ybTelRemind := task.NewTask("YbTelRemind", "0 */1 * * * * ", YbTelRemind)
  48. task.AddTask("研报电话会提醒", ybTelRemind)
  49. // 研报沙龙提醒
  50. ybSalonRemind := task.NewTask("ybSalonRemind", "0 */1 * * * * ", YbSalonRemind)
  51. task.AddTask("研报沙龙提醒", ybSalonRemind)
  52. //GetHistoryLzProductDetail()
  53. //GetLzPrice()
  54. //GetLzProductDetail()
  55. //LzExportExcel()
  56. //GetLzProductList()GetLzProductDetail
  57. // 定时新增手工指标数据提醒
  58. addEdbTask := task.NewTask("sendWaitReport", "1 0 2 * * * ", AddEdbTask)
  59. task.AddTask("定时新增手工指标数据提醒", addEdbTask)
  60. //每次服务启动都需要执行一次的
  61. _ = AddEdbTask(nil)
  62. //每日用户阅读数据统计
  63. statisticsUserView := task.NewTask("statisticsUserView", "0 5 2 * * *", StatisticsUserView)
  64. task.AddTask("每日用户阅读数据统计", statisticsUserView)
  65. task.StartTask()
  66. fmt.Println("task end")
  67. }
  68. //生产环境需要走的任务
  69. func releaseTask() {
  70. //隆众调研指标获取
  71. getLzSurveyProduct := task.NewTask("getLzSurveyProduct", "0 5 08-19/1 * * * ", GetLzSurveyProduct)
  72. task.AddTask("getLzSurveyProduct", getLzSurveyProduct)
  73. //隆众调研指标数据获取
  74. getLzSurveyProductData := task.NewTask("getLzSurveyProductData", "0 10 08-19/1 * * * ", GetLzSurveyProductData)
  75. task.AddTask("getLzSurveyProductData", getLzSurveyProductData)
  76. //发送邮件
  77. sendEmail := task.NewTask("sendEmail", "0 0 12 * * 0 ", SendEmail)
  78. task.AddTask("sendEmail", sendEmail)
  79. //oneMinute := task.NewTask("oneMinute", "0 */1 7-23 * * * ", OneMinute)
  80. //task.AddTask("oneMinute", oneMinute)
  81. // 正式/试用 用户到期提醒
  82. companyRemind := task.NewTask("companyRemind", "0 30 08 * * *", CompanyRemind)
  83. task.AddTask("companyRemind", companyRemind)
  84. //潜在客户
  85. freeViewerDetail := task.NewTask("freeViewerDetail", "0 0 9 * * 1 ", FreeViewerDetail)
  86. task.AddTask("潜在客户", freeViewerDetail)
  87. //刷新指标数据
  88. refreshData := task.NewTask("refreshData", "0 1 0,19 * * *", RefreshData)
  89. task.AddTask("refreshData", refreshData)
  90. //刷新交易所指标数据
  91. refreshTradeData := task.NewTask("refreshData", "0 1 4 * * *", RefreshTradeData)
  92. task.AddTask("refreshTradeData", refreshTradeData)
  93. //刷新指标基础数据
  94. refreshBaseData := task.NewTask("refreshBaseData", "0 */30 * * * * ", RefreshBaseData)
  95. task.AddTask("refreshBaseData", refreshBaseData)
  96. //同步弘则数据库中来自,钢联,隆众,有色,人工等基础数据--每隔五分钟,同步一次最新数据
  97. syncBaseData := task.NewTask("syncBaseData", "0 */5 * * * * ", SyncBaseData)
  98. task.AddTask("syncBaseData", syncBaseData)
  99. syncBaseDataExt := task.NewTask("syncBaseDataExt", "0 */30 * * * * ", SyncBaseDataExt)
  100. task.AddTask("syncBaseDataExt", syncBaseDataExt)
  101. // 定时往同花顺同步微信群的截止日期(凌晨4点)
  102. syncThsWxGroupEveryDay := task.NewTask("syncThsWxGroupEveryDay", "0 1 4 * * * ", SyncWxGroupEveryDay)
  103. task.AddTask("定时往同花顺同步微信群的截止日期", syncThsWxGroupEveryDay)
  104. checkDataInterface := task.NewTask("checkDataInterface", "0 */2 * * * * ", data.CheckDataInterface)
  105. task.AddTask("checkDataInterface", checkDataInterface)
  106. checkPbDataInterface := task.NewTask("checkPbDataInterface", "0 */2 * * * * ", data.CheckPbDataInterface)
  107. task.AddTask("checkPbDataInterface", checkPbDataInterface)
  108. //初始化指标更新状态
  109. resetEdbInfoIsUpdate := task.NewTask("resetEdbInfoIsUpdate", "0 0 0 * * *", data.ResetEdbInfoIsUpdate)
  110. task.AddTask("resetEdbInfoIsUpdate", resetEdbInfoIsUpdate)
  111. }
  112. func TaskTest() {
  113. fmt.Println("The task is start")
  114. //companyReportPermissionClose := task.NewTask("companyTryOut", "0 5 0 * * *", CompanyReportPermissionClose)
  115. companyReportPermissionClose := task.NewTask("companyReportPermissionClose", "0/30 * * * * *", CompanyReportPermissionClose)
  116. task.AddTask("用户产品权限试用-->关闭", companyReportPermissionClose)
  117. task.StartTask()
  118. fmt.Println("The task is end")
  119. }
  120. func SendEmail(cont context.Context) (err error) {
  121. //报告历史访问次数
  122. go ReportViewTimes()
  123. //报告访问详情
  124. go ReportViewDetail()
  125. //用户权限统计
  126. go HongzeUsers()
  127. return
  128. }
  129. func OneMinute(cont context.Context) (err error) {
  130. //日度
  131. //FrequencyByDay()
  132. //周度
  133. FrequencyByWeek()
  134. //月度
  135. FrequencyByMonth()
  136. return
  137. }
  138. func RefreshData(cont context.Context) (err error) {
  139. wg := sync.WaitGroup{}
  140. wg.Add(8)
  141. //wind
  142. go data.RefreshDataFromWind(&wg)
  143. //同花顺
  144. go data.RefreshDataFromThs(&wg)
  145. //彭博
  146. go data.RefreshDataFromPb(&wg)
  147. //手工数据
  148. go data.RefreshDataFromManual(&wg)
  149. //隆众数据
  150. go data.RefreshDataFromLz(&wg)
  151. //有色
  152. go data.RefreshDataFromYs(&wg)
  153. //钢联
  154. go data.RefreshDataFromGl(&wg)
  155. //路透
  156. go data.RefreshDataFromLt(&wg)
  157. wg.Wait()
  158. //计算指标
  159. data.RefreshDataFromCalculateAll()
  160. time.Sleep(2 * time.Second)
  161. data.RefreshNotice()
  162. return
  163. }
  164. // RefreshTradeData 刷新交易所数据
  165. func RefreshTradeData(cont context.Context) (err error) {
  166. wg := sync.WaitGroup{}
  167. wg.Add(5)
  168. //郑商所
  169. go data.RefreshDataFromZz(&wg)
  170. //上期所
  171. go data.RefreshDataFromSh(&wg)
  172. //上期能源
  173. go data.RefreshDataFromShfe(&wg)
  174. //中金所
  175. go data.RefreshDataFromCffex(&wg)
  176. //大商所
  177. go data.RefreshDataFromDl(&wg)
  178. wg.Wait()
  179. //计算指标
  180. data.RefreshDataFromCalculateAll()
  181. return
  182. }
  183. //刷新基础数据
  184. func RefreshBaseData(cont context.Context) (err error) {
  185. now := time.Now()
  186. if now.Hour() == 0 || now.Hour() == 19 {
  187. return nil
  188. }
  189. //同步有色基础指标数据
  190. go data.SyncSmmIndexDataBase()
  191. return
  192. }
  193. //刷新基础数据
  194. func SyncBaseData(cont context.Context) (err error) {
  195. now := time.Now()
  196. if now.Hour() == 0 || now.Hour() == 19 {
  197. return nil
  198. }
  199. //同步钢联基础数据
  200. go data.SyncGlDataBase()
  201. return
  202. }
  203. //刷新基础数据
  204. func SyncBaseDataExt(cont context.Context) (err error) {
  205. now := time.Now()
  206. if now.Hour() == 0 || now.Hour() == 19 {
  207. return nil
  208. }
  209. //同步隆众基础数据
  210. go data.SyncLzDataBase()
  211. //同步手工数据
  212. go data.SyncManualDataBase()
  213. //同步有色基础数据
  214. go data.SyncSmmDataBase()
  215. //刷新图表中,指标的最新日期
  216. go data.SetChartEdbEndDate()
  217. return
  218. }
  219. //func RefreshCalculateData(cont context.Context) (err error) {
  220. // //计算指标
  221. // go data.RefreshDataFromCalculateAll()
  222. // //刷新公历转农历数据
  223. // //go data.RefreshDataFromQuarterAll()
  224. // return
  225. //}
  226. //func Task() {
  227. // fmt.Println("start")
  228. // data.RefreshDataFromCalculateAll()
  229. // //startDate := time.Now().AddDate(-30, 0, 0).UnixNano() / 1e6
  230. //
  231. // //fmt.Println(startDate)
  232. // //fmt.Println(endDate)
  233. // fmt.Println("end")
  234. //}
  235. /*
  236. endData:=time.Now().UnixNano()/1e6
  237. dateTime:=time.Unix(endData/1000,0)
  238. fmt.Println(dateTime)
  239. */
  240. // EdbTaskNameMap 手工指标定时任务名称map集合
  241. var EdbTaskNameMap map[string]map[string]bool
  242. // EdbTaskNameChannel 手工指标定时任务名称channel
  243. var EdbTaskNameChannel chan string
  244. // EdbTaskStopChannel 手工指标定时任务停止channel
  245. var EdbTaskStopChannel chan string
  246. // EdbTaskRunNum 手工指标定时任务开始次数
  247. var EdbTaskRunNum int
  248. // AddEdbTask 新增手工指标数据录入提醒
  249. func AddEdbTask(cont context.Context) (err error) {
  250. //失败列表
  251. failList := make([]string, 0)
  252. defer func() {
  253. if len(failList) > 0 {
  254. fmt.Println("提醒失败:")
  255. for _, v := range failList {
  256. fmt.Println(v)
  257. }
  258. }
  259. }()
  260. list, err := models.GetEdbInfoByFrequencyNotDay()
  261. if err != nil {
  262. fmt.Println("查询获取频度非日度 且 提醒时间不为空 的指标数据失败,Err:", err.Error())
  263. }
  264. //如果还没有初始化map,那么先初始
  265. if EdbTaskNameMap == nil {
  266. EdbTaskNameMap = make(map[string]map[string]bool)
  267. }
  268. tmpEdbTaskNameMap := make(map[string]bool)
  269. // 今天的日期字符串(格式:2021-10-25)
  270. todayStr := time.Now().Format(utils.FormatDate)
  271. //当前周的周一与周日
  272. nowWeekFirstDay := utils.GetNowWeekMonday()
  273. nowWeekLastDay := utils.GetNowWeekLastDay()
  274. //当前月的一号与最后一天
  275. nowMonthFirstDay := utils.GetNowMonthFirstDay()
  276. nowMonthLastDay := utils.GetNowMonthLastDay()
  277. //当前季度的第一天与最后一天
  278. nowQuarterFirstDay := utils.GetNowQuarterFirstDay()
  279. nowQuarterLastDay := utils.GetNowQuarterLastDay()
  280. //当前半年的第一天与最后一天
  281. nowHalfYearFirstDay := utils.GetNowHalfYearFirstDay()
  282. nowHalfYearLastDay := utils.GetNowHalfYearLastDay()
  283. // 当前年的第一天与最后一天
  284. nowYearFirstDay := utils.GetNowYearFirstDay()
  285. nowYearLastDay := utils.GetNowYearLastDay()
  286. debugNoticeUserId := 0 //测试环境,需要发送消息的用户
  287. //测试环境也不发了
  288. //if utils.RunMode == "debug" {
  289. // tmpWxUser, tmpErr := models.GetWxUserByMobile("17634786714")
  290. // if tmpErr == nil && tmpWxUser != nil {
  291. // //debugNoticeUserId = 44078 //测试环境的话,发送邮箱给颜鹏
  292. // debugNoticeUserId = int(tmpWxUser.UserId) //测试环境的话,发送邮箱给嘉豪
  293. // }
  294. //}
  295. //task.globalTaskManager.adminTaskList
  296. for _, edb := range list {
  297. if edb.UserId <= 0 {
  298. continue //没有配置user_id的话,那么不需要提醒
  299. }
  300. tmpEdb := edb //指标信息
  301. isNotice := false //是否需要提醒
  302. noticeTime := "12:00:00" //提醒时间
  303. var dataDtTime time.Time
  304. edbData, tmpErr := models.GetLastEdbdataInfo(tmpEdb.TradeCode)
  305. if tmpErr != nil {
  306. if tmpErr.Error() != utils.ErrNoRow() {
  307. failList = append(failList, fmt.Sprint(tmpEdb.TradeCode, "失败,Err:", tmpErr.Error()))
  308. continue
  309. }
  310. }
  311. //如果确实是有数据的
  312. if edbData != nil {
  313. tmpDataDtTime, _ := time.ParseInLocation(utils.FormatDate, edbData.Dt, time.Now().Location())
  314. dataDtTime = tmpDataDtTime
  315. }
  316. switch tmpEdb.Frequency {
  317. case "周度":
  318. modifyDate := nowWeekLastDay //下次更新日期
  319. if tmpEdb.NoticeTime != "" {
  320. addDay := 7
  321. noticeArr := strings.Split(tmpEdb.NoticeTime, " ")
  322. if len(noticeArr) >= 2 {
  323. noticeTime = noticeArr[1]
  324. }
  325. noticeWeek := noticeArr[0]
  326. switch noticeWeek {
  327. case "周一":
  328. addDay = 1
  329. case "周二":
  330. addDay = 2
  331. case "周三":
  332. addDay = 3
  333. case "周四":
  334. addDay = 4
  335. case "周五":
  336. addDay = 5
  337. case "周六":
  338. addDay = 6
  339. case "周日":
  340. addDay = 7
  341. }
  342. modifyDate = modifyDate.AddDate(0, 0, addDay-7)
  343. }
  344. //如果正好是提醒日,同时本周没有过记录,那么需要提醒
  345. if todayStr == modifyDate.Format(utils.FormatDate) && !nowWeekFirstDay.Before(dataDtTime) {
  346. isNotice = true
  347. }
  348. case "月度":
  349. addDay := 0
  350. modifyDate := nowMonthLastDay //下次更新日期
  351. if tmpEdb.NoticeTime != "" {
  352. strArr := strings.Split(tmpEdb.NoticeTime, "日")
  353. if len(strArr) >= 2 {
  354. noticeTime = strArr[1]
  355. }
  356. tmpAddDay, tmpErr := strconv.Atoi(strArr[0])
  357. if tmpErr != nil {
  358. continue
  359. }
  360. addDay = tmpAddDay - 1
  361. modifyDate = nowMonthFirstDay.AddDate(0, 0, addDay)
  362. }
  363. //如果正好是提醒日,同时本月没有过记录,那么需要提醒
  364. if todayStr == modifyDate.Format(utils.FormatDate) && !nowMonthFirstDay.Before(dataDtTime) {
  365. isNotice = true
  366. }
  367. case "季度":
  368. //提醒时间
  369. if tmpEdb.NoticeTime != "" {
  370. noticeArr := strings.Split(tmpEdb.NoticeTime, " ")
  371. if len(noticeArr) >= 2 {
  372. noticeTime = noticeArr[1]
  373. }
  374. }
  375. //每季度更新数据时间
  376. //如果正好是提醒日(每季度最后一天),同时本季度没有过记录,那么需要提醒
  377. if todayStr == nowQuarterLastDay.Format(utils.FormatDate) && !nowQuarterFirstDay.Before(dataDtTime) {
  378. isNotice = true
  379. }
  380. case "半年度":
  381. //提醒时间
  382. if tmpEdb.NoticeTime != "" {
  383. noticeArr := strings.Split(tmpEdb.NoticeTime, " ")
  384. if len(noticeArr) >= 2 {
  385. noticeTime = noticeArr[1]
  386. }
  387. }
  388. //每半年度更新数据时间
  389. //如果正好是提醒日(每半年度最后一天),同时本半年度没有过记录,那么需要提醒
  390. if todayStr == nowHalfYearLastDay.Format(utils.FormatDate) && !nowHalfYearFirstDay.Before(dataDtTime) {
  391. isNotice = true
  392. }
  393. case "年度":
  394. //提醒时间
  395. if tmpEdb.NoticeTime != "" {
  396. noticeArr := strings.Split(tmpEdb.NoticeTime, " ")
  397. if len(noticeArr) >= 2 {
  398. noticeTime = noticeArr[1]
  399. }
  400. }
  401. //每年度更新数据时间
  402. //如果正好是提醒日(每年度最后一天),同时半年度没有过记录,那么需要提醒
  403. if todayStr == nowYearLastDay.Format(utils.FormatDate) && !nowYearFirstDay.Before(dataDtTime) {
  404. isNotice = true
  405. }
  406. }
  407. if isNotice {
  408. taskName := "edb_task_" + todayStr + ":" + fmt.Sprint(tmpEdb.TradeCode)
  409. //fmt.Println(taskName, ";", tmpEdb.SecName)
  410. //定时任务
  411. tmpTaskFunc := func(ctx context.Context) (funcErr error) {
  412. //方法执行结束后,移除定时任务
  413. defer func() {
  414. EdbTaskNameChannel <- taskName
  415. }()
  416. // 匿名方法内判断是否发送提醒,因为可能时间到的时候,发现
  417. funcIsNotice := false
  418. // 再次获取指标数据详情
  419. edbData, tmpErr := models.GetLastEdbdataInfo(tmpEdb.TradeCode)
  420. if tmpErr != nil {
  421. if tmpErr.Error() != utils.ErrNoRow() {
  422. funcErr = tmpErr
  423. return
  424. }
  425. }
  426. if utils.RunMode == "debug" && debugNoticeUserId > 0 {
  427. tmpEdb.UserId = debugNoticeUserId //测试环境的话,发送邮箱给嘉豪
  428. }
  429. //数据过期时间
  430. var funcDataDtTime time.Time
  431. //如果确实是有数据的
  432. if edbData != nil {
  433. tmpDataDtTime, _ := time.ParseInLocation(utils.FormatDate, edbData.Dt, time.Now().Location())
  434. funcDataDtTime = tmpDataDtTime
  435. }
  436. //提示频度文案
  437. notifyFrequency := "每日"
  438. switch tmpEdb.Frequency {
  439. case "周度":
  440. notifyFrequency = "每周"
  441. modifyDate := nowWeekLastDay //下次更新日期
  442. if tmpEdb.NoticeTime != "" {
  443. addDay := 7
  444. noticeArr := strings.Split(tmpEdb.NoticeTime, " ")
  445. if len(noticeArr) >= 2 {
  446. noticeTime = noticeArr[1]
  447. }
  448. noticeWeek := noticeArr[0]
  449. switch noticeWeek {
  450. case "周一":
  451. addDay = 1
  452. case "周二":
  453. addDay = 2
  454. case "周三":
  455. addDay = 3
  456. case "周四":
  457. addDay = 4
  458. case "周五":
  459. addDay = 5
  460. case "周六":
  461. addDay = 6
  462. case "周日":
  463. addDay = 7
  464. }
  465. modifyDate = modifyDate.AddDate(0, 0, addDay-7)
  466. }
  467. //如果正好是提醒日,同时本周没有过记录,那么需要提醒
  468. if todayStr == modifyDate.Format(utils.FormatDate) && !nowWeekFirstDay.Before(funcDataDtTime) {
  469. funcIsNotice = true
  470. }
  471. case "月度":
  472. notifyFrequency = "每月"
  473. addDay := 0
  474. modifyDate := nowMonthLastDay //下次更新日期
  475. if tmpEdb.NoticeTime != "" {
  476. strArr := strings.Split(tmpEdb.NoticeTime, "日")
  477. if len(strArr) >= 2 {
  478. noticeTime = strArr[1]
  479. }
  480. tmpAddDay, tmpErr := strconv.Atoi(strArr[0])
  481. if tmpErr != nil {
  482. funcErr = tmpErr
  483. }
  484. addDay = tmpAddDay - 1
  485. modifyDate = nowMonthFirstDay.AddDate(0, 0, addDay)
  486. }
  487. //如果正好是提醒日,同时本月没有过记录,那么需要提醒
  488. if todayStr == modifyDate.Format(utils.FormatDate) && !nowMonthFirstDay.Before(funcDataDtTime) {
  489. funcIsNotice = true
  490. }
  491. case "季度":
  492. notifyFrequency = "每季度"
  493. //提醒时间
  494. if tmpEdb.NoticeTime != "" {
  495. noticeArr := strings.Split(tmpEdb.NoticeTime, " ")
  496. if len(noticeArr) >= 2 {
  497. noticeTime = noticeArr[1]
  498. }
  499. }
  500. //每季度更新数据时间
  501. //如果正好是提醒日(每季度最后一天),同时本季度没有过记录,那么需要提醒
  502. if todayStr == nowQuarterLastDay.Format(utils.FormatDate) && !nowQuarterFirstDay.Before(funcDataDtTime) {
  503. funcIsNotice = true
  504. }
  505. case "半年度":
  506. notifyFrequency = "每半年度"
  507. //提醒时间
  508. if tmpEdb.NoticeTime != "" {
  509. noticeArr := strings.Split(tmpEdb.NoticeTime, " ")
  510. if len(noticeArr) >= 2 {
  511. noticeTime = noticeArr[1]
  512. }
  513. }
  514. //每半年度更新数据时间
  515. //如果正好是提醒日(每半年度最后一天),同时本半年度没有过记录,那么需要提醒
  516. if todayStr == nowHalfYearLastDay.Format(utils.FormatDate) && !nowHalfYearFirstDay.Before(funcDataDtTime) {
  517. funcIsNotice = true
  518. }
  519. case "年度":
  520. notifyFrequency = "每年"
  521. //提醒时间
  522. if tmpEdb.NoticeTime != "" {
  523. noticeArr := strings.Split(tmpEdb.NoticeTime, " ")
  524. if len(noticeArr) >= 2 {
  525. noticeTime = noticeArr[1]
  526. }
  527. }
  528. //每年度更新数据时间
  529. //如果正好是提醒日(每年度最后一天),同时半年度没有过记录,那么需要提醒
  530. if todayStr == nowYearLastDay.Format(utils.FormatDate) && !nowYearFirstDay.Before(funcDataDtTime) {
  531. funcIsNotice = true
  532. }
  533. }
  534. //fmt.Println(tmpEdb.TradeCode, " funcIsNotice:", funcIsNotice)
  535. //如果还是要提醒
  536. if funcIsNotice {
  537. //用户微信openid列表数据
  538. openIdList := make([]*models.OpenIdList, 0)
  539. //获取用户信息
  540. isAdmin := true
  541. admin, err := models.GetAdminByAdminId(tmpEdb.UserId)
  542. if err != nil {
  543. if err.Error() == utils.ErrNoRow() {
  544. isAdmin = false
  545. } else {
  546. return err
  547. }
  548. }
  549. if admin == nil {
  550. isAdmin = false
  551. }
  552. if isAdmin {
  553. if admin.Mobile == "" {
  554. } else {
  555. wxUser, err := models.GetWxUserByMobile(admin.Mobile)
  556. if err != nil {
  557. return err
  558. }
  559. if wxUser == nil {
  560. funcErr = errors.New("用户信息不存在:mobile:" + admin.Mobile)
  561. return err
  562. }
  563. tmpOpenidList, err := models.GetUserOpenidListByUserId(int(wxUser.UserId))
  564. if err != nil {
  565. return err
  566. }
  567. openIdList = tmpOpenidList
  568. }
  569. } else {
  570. tmpOpenidList, err := models.GetUserOpenidListByUserId(tmpEdb.UserId)
  571. if err != nil {
  572. return err
  573. }
  574. openIdList = tmpOpenidList
  575. }
  576. //发送消息
  577. if len(openIdList) <= 0 {
  578. funcErr = errors.New("openId 列表为空" + strconv.Itoa(tmpEdb.UserId))
  579. return
  580. }
  581. first := "数据录入提醒"
  582. keyword1 := tmpEdb.SecName
  583. keyword2 := notifyFrequency + " " + tmpEdb.NoticeTime
  584. remark := tmpEdb.SecName + "该更新了"
  585. err = SendWxMsgWithFrequency(first, keyword1, keyword2, remark, openIdList)
  586. if err != nil {
  587. return err
  588. }
  589. //发送成功,记录发送日志
  590. {
  591. sendRecord := new(models.EdbinfoSendMsgRecord)
  592. sendRecord.UserId = tmpEdb.UserId
  593. sendRecord.TradeCode = tmpEdb.TradeCode
  594. sendRecord.CreateTime = time.Now()
  595. err = models.AddEdbinfoSendMsgRecord(sendRecord)
  596. if err != nil {
  597. return err
  598. }
  599. }
  600. }
  601. return
  602. }
  603. //添加定时任务(没有设置通知时间就不进行定时任务通知了)
  604. spec := ``
  605. if noticeTime != "" {
  606. noticeArr := strings.Split(noticeTime, ":")
  607. if len(noticeArr) == 3 {
  608. //spec = ` */20 * * * * * `
  609. spec = fmt.Sprintf(` %s %s %s * * * `, noticeArr[2], noticeArr[1], noticeArr[0])
  610. //定时任务开始的时间
  611. tmpTask := task.NewTask(taskName, spec, tmpTaskFunc)
  612. task.AddTask(taskName, tmpTask)
  613. tmpEdbTaskNameMap[taskName] = true
  614. }
  615. }
  616. }
  617. }
  618. //将当天的手工指标加入到手工指标池去
  619. EdbTaskNameMap[todayStr] = tmpEdbTaskNameMap
  620. //开启协程,用来清除定时任务
  621. go deleteTask()
  622. //如果当前定时任务执行次数大于0次,那么需要往手工指标定时任务停止channel写入数据,用来关闭昨天没有执行的的定时任务
  623. if EdbTaskRunNum > 0 {
  624. //清除昨天的数据
  625. EdbTaskStopChannel <- time.Now().AddDate(0, 0, -1).Format(utils.FormatDate)
  626. }
  627. //手工指标定时任务开始次数累加
  628. EdbTaskRunNum++
  629. return
  630. //fmt.Println(task.NewMapSorter())
  631. }
  632. // deleteTask 清除已通知的任务
  633. func deleteTask() {
  634. for {
  635. select {
  636. case taskName := <-EdbTaskNameChannel:
  637. task.DeleteTask(taskName)
  638. delete(EdbTaskNameMap, taskName)
  639. case dayStr := <-EdbTaskStopChannel: //收到停止信号,先清除掉那一天的定时任务,
  640. for taskName := range EdbTaskNameMap[dayStr] {
  641. task.DeleteTask(taskName)
  642. delete(EdbTaskNameMap, taskName)
  643. }
  644. break
  645. }
  646. }
  647. }