activity_meet_detail_log.go 9.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366
  1. package models
  2. import (
  3. "fmt"
  4. "github.com/beego/beego/v2/client/orm"
  5. "strconv"
  6. "strings"
  7. "time"
  8. )
  9. // 报名
  10. type CygxActivityMeetDetailLog struct {
  11. AttendanceId int `orm:"column(attendance_id);pk;"description:"主键ID"`
  12. ActivityId int `description:"活动ID"`
  13. RealName string `description:"姓名"`
  14. Mobile string `description:"手机号"`
  15. CompanyName string `description:"公司名称"`
  16. CompanyId int `description:"公司id 不在数据库的用户为0"`
  17. CreateTime time.Time `description:"创建时间"`
  18. ActivityTime string `description:"活动时间"`
  19. }
  20. func GetOfflineMeetingDetailListCompanyIdStr(companyIdStr string) (item []*CygxActivityMeetDetailLog, err error) {
  21. o := orm.NewOrm()
  22. sql := `SELECT * FROM cygx_activity_offline_meeting_detail WHERE company_id IN (` + companyIdStr + `)`
  23. _, err = o.Raw(sql).QueryRows(&item)
  24. return
  25. }
  26. func GetOfflineMeetingDetailListCompanyName(companyName string) (item []*CygxActivityMeetDetailLog, err error) {
  27. o := orm.NewOrm()
  28. sql := `SELECT l.*
  29. FROM
  30. cygx_activity_meet_detail_log AS l INNER JOIN company AS c ON c.company_name = l.company_name
  31. WHERE
  32. l.company_name IN (` + companyName + `) GROUP BY l.company_name`
  33. _, err = o.Raw(sql).QueryRows(&item)
  34. return
  35. }
  36. // 添加
  37. func AddCygxActivityMeetDetailLog(item *CygxActivityMeetDetailLog) (lastId int64, err error) {
  38. o := orm.NewOrm()
  39. lastId, err = o.Insert(item)
  40. return
  41. }
  42. func GetActivityMeetDetailLog(mobileStr string) (item []*CygxActivityMeetDetailLog, err error) {
  43. o := orm.NewOrm()
  44. sql := `SELECT l.*
  45. FROM
  46. cygx_activity_meet_detail_log as l
  47. INNER JOIN wx_user as u ON u.outbound_mobile = l.mobile
  48. WHERE l.mobile IN (` + mobileStr + `) GROUP BY l.mobile `
  49. _, err = o.Raw(sql).QueryRows(&item)
  50. return
  51. }
  52. func GetActivityMeetDetailLogByMobile() (item []*CygxActivityMeetDetailLog, err error) {
  53. o := orm.NewOrm()
  54. sql := `SELECT * FROM cygx_activity_meet_detail_log WHERE mobile !='' GROUP BY mobile `
  55. _, err = o.Raw(sql).QueryRows(&item)
  56. return
  57. }
  58. // 获取数量
  59. func GetActivityMeetDetailLogCount(condition string) (count int, err error) {
  60. o := orm.NewOrm()
  61. sqlCount := ` SELECT COUNT(1) AS count FROM cygx_activity_meet_detail_log WHERE 1=1 `
  62. if condition != "" {
  63. sqlCount += condition
  64. }
  65. err = o.Raw(sqlCount).QueryRow(&count)
  66. return
  67. }
  68. // 修改公司参会数量
  69. func UpdateActivityMeetDetailLog(companyName string, num int) (err error) {
  70. sql := ` UPDATE cygx_activity_meet_detail_log SET company_meet_num= ? WHERE company_name = ?`
  71. o := orm.NewOrm()
  72. _, err = o.Raw(sql, num, companyName).Exec()
  73. return
  74. }
  75. // 修改个人参会数量
  76. func UpdateActivityMeetDetailLogByUser(mobile string, num int) (err error) {
  77. sql := ` UPDATE cygx_activity_meet_detail_log SET user_meet_num= ? WHERE mobile = ?`
  78. o := orm.NewOrm()
  79. _, err = o.Raw(sql, num, mobile).Exec()
  80. return
  81. }
  82. // 添加线上到会记录(下载使用)
  83. func AddCygxActivityMeetDetailLogOnline(list []*CygxActivityAttendanceDetail, activityId int) (err error) {
  84. o, err := orm.NewOrm().Begin()
  85. if err != nil {
  86. return
  87. }
  88. defer func() {
  89. fmt.Println(err)
  90. if err == nil {
  91. o.Commit()
  92. } else {
  93. o.Rollback()
  94. }
  95. }()
  96. var CompanyName string
  97. var MobileStr string
  98. var items []*CygxActivityMeetDetailLog
  99. //删除原有数据
  100. sql := ` DELETE FROM cygx_activity_meet_detail_log WHERE activity_id = ?`
  101. _, err = o.Raw(sql, activityId).Exec()
  102. if err != nil {
  103. return
  104. }
  105. //插入新的数据
  106. for _, v := range list {
  107. item := new(CygxActivityMeetDetailLog)
  108. item.ActivityId = v.ActivityId
  109. item.Mobile = v.Mobile
  110. item.CompanyName = v.CompanyName
  111. item.CompanyId = v.CompanyId
  112. item.CreateTime = v.CreateTime
  113. CompanyName += "'" + v.CompanyName + "',"
  114. MobileStr += v.Mobile + ","
  115. items = append(items, item)
  116. }
  117. CompanyName = strings.TrimRight(CompanyName, ",")
  118. MobileStr = strings.TrimRight(MobileStr, ",")
  119. _, err = o.InsertMulti(1, items)
  120. listCompany, err := GetOfflineMeetingDetailListCompanyName(CompanyName)
  121. if err != nil {
  122. return
  123. }
  124. //修改公司对应的数量
  125. var condition string
  126. for _, v := range listCompany {
  127. var total int
  128. condition = ` AND company_name = '` + v.CompanyName + `' `
  129. total, err = GetActivityMeetDetailLogCount(condition)
  130. if err != nil {
  131. return
  132. }
  133. sql := ` UPDATE cygx_activity_meet_detail_log SET company_meet_num= ? WHERE company_name = ?`
  134. _, err = o.Raw(sql, total, v.CompanyName).Exec()
  135. if err != nil {
  136. return
  137. }
  138. }
  139. listMobile, err := GetActivityMeetDetailLog(MobileStr)
  140. if err != nil {
  141. return
  142. }
  143. //修改个人对应的数量
  144. for _, v := range listMobile {
  145. var total int
  146. condition = ` AND mobile = '` + v.Mobile + `' `
  147. total, err = GetActivityMeetDetailLogCount(condition)
  148. if err != nil {
  149. return
  150. }
  151. sql := ` UPDATE cygx_activity_meet_detail_log SET user_meet_num= ? WHERE mobile = ?`
  152. _, err = o.Raw(sql, total, v.Mobile).Exec()
  153. if err != nil {
  154. return
  155. }
  156. }
  157. return
  158. }
  159. // 添加线上到会记录
  160. func AddCygxActivityMeetDetailLogOnlineByList(list []*CygxActivityAttendanceDetail, activityIds string) (err error) {
  161. o, err := orm.NewOrm().Begin()
  162. if err != nil {
  163. return
  164. }
  165. defer func() {
  166. fmt.Println(err)
  167. if err == nil {
  168. o.Commit()
  169. } else {
  170. o.Rollback()
  171. }
  172. }()
  173. var CompanyName string
  174. var MobileStr string
  175. var items []*CygxActivityMeetDetailLog
  176. //删除原有数据
  177. sql := ` DELETE FROM cygx_activity_meet_detail_log WHERE activity_id IN (` + activityIds + `)`
  178. _, err = o.Raw(sql).Exec()
  179. if err != nil {
  180. return
  181. }
  182. //插入新的数据
  183. for _, v := range list {
  184. item := new(CygxActivityMeetDetailLog)
  185. item.ActivityId = v.ActivityId
  186. item.Mobile = v.Mobile
  187. fmt.Println(v.CompanyName)
  188. item.CompanyName = v.CompanyName
  189. item.CompanyId = v.CompanyId
  190. item.ActivityTime = v.ActivityTime
  191. item.CreateTime = v.CreateTime
  192. if strings.Index(CompanyName, v.CompanyName) == -1 && v.CompanyName != "" {
  193. CompanyName += "'" + v.CompanyName + "',"
  194. }
  195. if strings.Index(MobileStr, v.Mobile) == -1 && v.Mobile != "" {
  196. MobileStr += v.Mobile + ","
  197. }
  198. items = append(items, item)
  199. }
  200. CompanyName = strings.TrimRight(CompanyName, ",")
  201. MobileStr = strings.TrimRight(MobileStr, ",")
  202. _, err = o.InsertMulti(1, items)
  203. listCompany, err := GetOfflineMeetingDetailListCompanyName(CompanyName)
  204. fmt.Println("公司数量", len(listCompany))
  205. if err != nil {
  206. return
  207. }
  208. //修改公司对应的数量
  209. var condition string
  210. for _, v := range listCompany {
  211. var total int
  212. condition = ` AND company_name = '` + v.CompanyName + `' `
  213. total, err = GetActivityMeetDetailLogCount(condition)
  214. if err != nil {
  215. return
  216. }
  217. sql := ` UPDATE cygx_activity_meet_detail_log SET company_meet_num= ? WHERE company_name = ?`
  218. _, err = o.Raw(sql, total, v.CompanyName).Exec()
  219. fmt.Println("处理公司", v.CompanyName)
  220. if err != nil {
  221. return
  222. }
  223. }
  224. listMobile, err := GetActivityMeetDetailLog(MobileStr)
  225. fmt.Println("用户数量", len(listMobile))
  226. if err != nil {
  227. return
  228. }
  229. //修改个人对应的数量
  230. for _, v := range listMobile {
  231. var total int
  232. condition = ` AND mobile = '` + v.Mobile + `' `
  233. total, err = GetActivityMeetDetailLogCount(condition)
  234. if err != nil {
  235. return
  236. }
  237. sql := ` UPDATE cygx_activity_meet_detail_log SET user_meet_num= ? WHERE mobile = ?`
  238. _, err = o.Raw(sql, total, v.Mobile).Exec()
  239. fmt.Println("处理用户", v.Mobile)
  240. if err != nil {
  241. return
  242. }
  243. }
  244. fmt.Println("user_end")
  245. return
  246. }
  247. // 添加线下到会记录
  248. func AddCygxActivityMeetDetailLogOffline(activityId int) (err error) {
  249. o := orm.NewOrm()
  250. to, err := o.Begin()
  251. if err != nil {
  252. return
  253. }
  254. defer func() {
  255. if err != nil {
  256. fmt.Println(err)
  257. _ = to.Rollback()
  258. } else {
  259. _ = to.Commit()
  260. }
  261. }()
  262. var condition string
  263. var pars []interface{}
  264. condition = ` AND activity_id = ? `
  265. pars = append(pars, activityId)
  266. listOfflineMeeting, err := GetOfflineMeetingList(condition, pars)
  267. if err != nil {
  268. return
  269. }
  270. var meetingUids string
  271. for _, v := range listOfflineMeeting {
  272. meetingUids += strconv.Itoa(v.UserId) + ","
  273. }
  274. meetingUids = strings.TrimRight(meetingUids, ",")
  275. if meetingUids == "" {
  276. meetingUids = "-1"
  277. }
  278. var CompanyIdStr string
  279. var MobileStr string
  280. var items []*CygxActivityMeetDetailLog
  281. list, err := GetOfflineMeetingListByUser(meetingUids, activityId)
  282. fmt.Println(len(list))
  283. if err != nil {
  284. return
  285. }
  286. //删除原有数据
  287. sql := ` DELETE FROM cygx_activity_meet_detail_log WHERE activity_id = ?`
  288. _, err = to.Raw(sql, activityId).Exec()
  289. if err != nil {
  290. return
  291. }
  292. //插入新的数据
  293. for _, v := range list {
  294. item := new(CygxActivityMeetDetailLog)
  295. item.ActivityId = v.ActivityId
  296. item.Mobile = v.Mobile
  297. item.CompanyName = v.CompanyName
  298. item.CompanyId = v.CompanyId
  299. item.CreateTime = v.CreateTime
  300. CompanyIdStr += strconv.Itoa(v.CompanyId) + ","
  301. if v.Mobile != "" {
  302. MobileStr += v.Mobile + ","
  303. }
  304. items = append(items, item)
  305. }
  306. CompanyIdStr = strings.TrimRight(CompanyIdStr, ",")
  307. MobileStr = strings.TrimRight(MobileStr, ",")
  308. for _, v := range items {
  309. _, err = to.Insert(v)
  310. if err != nil {
  311. return
  312. }
  313. }
  314. listCompanyId, err := GetOfflineMeetingDetailListCompanyIdStr(CompanyIdStr)
  315. if err != nil {
  316. return
  317. }
  318. //修改公司对应的数量
  319. //var condition string
  320. for _, v := range listCompanyId {
  321. var total int
  322. condition = ` AND company_name = '` + v.CompanyName + `' `
  323. total, err = GetActivityMeetDetailLogCount(condition)
  324. if err != nil {
  325. return
  326. }
  327. sql := ` UPDATE cygx_activity_meet_detail_log SET company_meet_num= ? WHERE company_name = ?`
  328. _, err = to.Raw(sql, total, v.CompanyName).Exec()
  329. if err != nil {
  330. return
  331. }
  332. }
  333. listMobile, err := GetActivityMeetDetailLog(MobileStr)
  334. if err != nil {
  335. return
  336. }
  337. //修改个人对应的数量
  338. for _, v := range listMobile {
  339. var total int
  340. condition = ` AND mobile = '` + v.Mobile + `' `
  341. total, err = GetActivityMeetDetailLogCount(condition)
  342. if err != nil {
  343. return
  344. }
  345. sql := ` UPDATE cygx_activity_meet_detail_log SET user_meet_num= ? WHERE mobile = ?`
  346. _, err = to.Raw(sql, total, v.Mobile).Exec()
  347. if err != nil {
  348. return
  349. }
  350. }
  351. return
  352. }