public.go 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953
  1. package p
  2. import (
  3. "encoding/json"
  4. "fmt"
  5. "net/http"
  6. "reflect"
  7. "sort"
  8. "strconv"
  9. "strings"
  10. "sync"
  11. "time"
  12. . "app.yhyue.com/moapp/jybase/common"
  13. util "app.yhyue.com/moapp/jybase/common"
  14. . "app.yhyue.com/moapp/jybase/date"
  15. "app.yhyue.com/moapp/jybase/es"
  16. "app.yhyue.com/moapp/jybase/logger"
  17. . "app.yhyue.com/moapp/jybase/mongodb"
  18. . "app.yhyue.com/moapp/jybase/mysql"
  19. "app.yhyue.com/moapp/jybase/redis"
  20. rcDb "bp.jydev.jianyu360.cn/BaseService/resourceCenter/public/db"
  21. rcService "bp.jydev.jianyu360.cn/BaseService/resourceCenter/public/service"
  22. . "bp.jydev.jianyu360.cn/BaseService/userCenter/identity"
  23. "jygit.jydev.jianyu360.cn/BaseService/ossClient"
  24. "jygit.jydev.jianyu360.cn/BaseService/ossClient/entity"
  25. )
  26. // 金额转化 金额:0-万元以下单位为元 ,万元以上至亿元以下单位为万元 ,亿元以上单位为亿元。保留 小数点后 2 位,不进行四舍五入。
  27. func ConversionMoney(i_money interface{}) string {
  28. m := ""
  29. if reflect.TypeOf(i_money).Name() == "float64" {
  30. m = strconv.FormatFloat(Float64All(i_money), 'f', -1, 64)
  31. } else {
  32. m = ObjToString(i_money)
  33. }
  34. if m == "" {
  35. return m
  36. }
  37. m_arr := strings.Split(m, ".")
  38. m_1 := m_arr[0]
  39. len_m1 := len([]rune(m_1))
  40. if len_m1 >= 9 {
  41. m = m_1[0:len_m1-8] + "." + m_1[len_m1-8:len_m1-6] + "亿元"
  42. } else if len_m1 >= 5 {
  43. m = m_1[0:len_m1-4] + "." + m_1[len_m1-4:len_m1-2] + "万元"
  44. } else {
  45. if len(m_arr) == 1 {
  46. return m + ".00元"
  47. }
  48. m_2 := m_arr[1]
  49. if len([]rune(m_2)) > 1 {
  50. m_2 = m_2[0:2]
  51. } else {
  52. m_2 = m_2[0:1] + "0"
  53. }
  54. m = m_1 + "." + m_2 + "元"
  55. }
  56. return m
  57. }
  58. // 微信模板消息 remark
  59. func WxTplRemark(titles []string, lastTime int64, hasLen int) string {
  60. tip := ""
  61. second := time.Now().Unix() - lastTime
  62. if second > 0 {
  63. if second < 61 {
  64. tip = fmt.Sprintf("%d秒前发布的:\n", second)
  65. } else {
  66. second = second / 60
  67. if second < 121 {
  68. if second < 1 {
  69. second = 1
  70. }
  71. tip = fmt.Sprintf("%d分钟前发布的:\n", second)
  72. }
  73. }
  74. }
  75. lastTip := ""
  76. if len(titles) > 1 {
  77. lastTip = fmt.Sprintf("...(共%d条)", len(titles))
  78. }
  79. reLen := 199 - hasLen - len([]rune(tip))
  80. lastTipLen := len([]rune(lastTip))
  81. wxTplMsgTitle := ""
  82. bshow := false
  83. for n := 1; n < len(titles)+1; n++ {
  84. curTitle := titles[n-1]
  85. tmptitle := wxTplMsgTitle + fmt.Sprintf("%d %s\n", n, curTitle)
  86. ch := reLen - len([]rune(tmptitle))
  87. if ch < lastTipLen { //加上后大于后辍,则没有完全显示
  88. if ch == 0 && n == len(titles) {
  89. wxTplMsgTitle = tmptitle
  90. bshow = true
  91. } else {
  92. ch_1 := reLen - len([]rune(wxTplMsgTitle)) - lastTipLen
  93. if ch_1 > 8 {
  94. curLen := len([]rune(curTitle))
  95. if ch_1 > curLen {
  96. ch_1 = curLen
  97. }
  98. wxTplMsgTitle += fmt.Sprintf("%d %s\n", n, string([]rune(curTitle)[:ch_1-3]))
  99. }
  100. }
  101. } else {
  102. wxTplMsgTitle = tmptitle
  103. if n == len(titles) {
  104. bshow = true
  105. }
  106. }
  107. }
  108. if bshow {
  109. lastTip = ""
  110. }
  111. return tip + wxTplMsgTitle + lastTip
  112. }
  113. // 获取信息行业
  114. func GetSubScopeClass(subscopeclass interface{}) string {
  115. industry := ""
  116. if subscopeclass != nil {
  117. k2sub := strings.Split(ObjToString(subscopeclass), ",")
  118. if len(k2sub) > 0 {
  119. industry = k2sub[0]
  120. if industry != "" {
  121. ss := strings.Split(industry, "_")
  122. if len(ss) > 1 {
  123. industry = ss[0]
  124. }
  125. }
  126. }
  127. }
  128. return industry
  129. }
  130. // 控制一分钟最大推送数,均匀调度
  131. func LimitMaxOneMinutePush(pushPoll *chan bool, maxOneMinute int) {
  132. max := int(maxOneMinute / 60)
  133. *pushPoll = make(chan bool, max)
  134. go func() {
  135. for {
  136. time.Sleep(time.Second)
  137. for i := 0; i < max; i++ {
  138. select {
  139. case *pushPoll <- true:
  140. default:
  141. continue
  142. }
  143. }
  144. }
  145. }()
  146. }
  147. func UpdateUserIsPush(Mgo *MongodbSim, userId string, err error) {
  148. if err == nil {
  149. return
  150. }
  151. if strings.Contains(err.Error(), "[43004]") {
  152. Mgo.UpdateById("user", userId, map[string]interface{}{
  153. "$set": map[string]interface{}{
  154. "i_ispush": 0,
  155. },
  156. })
  157. }
  158. }
  159. // 查找我的子账号
  160. func MySonAccounts(Mgo *MongodbSim, coll, userId string, field map[string]interface{}) *[]map[string]interface{} {
  161. users, _ := Mgo.Find(coll, map[string]interface{}{
  162. "i_member_sub_status": 1,
  163. "s_member_mainid": userId,
  164. "i_member_status": map[string]interface{}{"$gt": 0},
  165. }, nil, field, false, -1, -1)
  166. if users == nil {
  167. users = &[]map[string]interface{}{}
  168. }
  169. return users
  170. }
  171. // 是否购买此服务
  172. func HasService(msl *Mysql, userId string, params ...int) *MemberService {
  173. args := []interface{}{}
  174. ws := []string{}
  175. for _, v := range params {
  176. args = append(args, v)
  177. ws = append(ws, "?")
  178. }
  179. args = append(args, args...)
  180. args = append(args, userId, NowFormat(Date_Full_Layout))
  181. list := msl.SelectBySql(`SELECT a.l_starttime,b.id from jianyu.bigmember_service_user a
  182. INNER JOIN jianyu.bigmember_service b on (((b.id in (`+strings.Join(ws, ",")+`) and a.s_serviceid=b.id) or (b.i_pid in (`+strings.Join(ws, ",")+`) and a.s_serviceid=b.i_pid)) and b.i_status=0 and a.s_userid=? and a.i_status=0 and a.l_endtime>?)`, args...)
  183. ms := &MemberService{
  184. Services: map[int]*memberService{},
  185. }
  186. if list != nil {
  187. for _, v := range *list {
  188. ms.IsBuy = true
  189. id := util.IntAll(v["id"])
  190. ms.Services[id] = &memberService{
  191. Id: id,
  192. StartTime: util.ObjToString(v["l_starttime"]),
  193. }
  194. }
  195. }
  196. return ms
  197. }
  198. func GetInfoTitle(info map[string]interface{}) string {
  199. title, _ := info["title"].(string)
  200. jsondata, _ := info["jsondata"].(map[string]interface{})
  201. if jsondata != nil {
  202. goods, _ := jsondata["goods"].(string)
  203. title += goods
  204. }
  205. title = strings.ToUpper(title)
  206. return title
  207. }
  208. // 加载数据到内存中
  209. func LoadBidding(mgo *MongodbSim, dbName, coll, incField string, startTime, maxSize int64, redisCache bool, query, fields map[string]interface{}, ossAddr string) (*[]map[string]interface{}, int64) {
  210. defer util.Catch()
  211. endTime := time.Now().Unix()
  212. if query == nil || len(query) == 0 {
  213. query = map[string]interface{}{
  214. incField: map[string]interface{}{
  215. "$gte": startTime,
  216. "$lt": endTime,
  217. },
  218. }
  219. }
  220. logger.Info("开始加载", coll, "数据", query)
  221. queryField := map[string]interface{}{
  222. "title": 1,
  223. "detail": 1,
  224. "purchasing": 1,
  225. "projectname": 1,
  226. "projectcode": 1,
  227. "buyer": 1,
  228. "buyerperson": 1,
  229. "buyertel": 1,
  230. "s_winner": 1,
  231. "agency": 1,
  232. "bidopentime": 1,
  233. "projectscope": 1,
  234. "publishtime": 1,
  235. "toptype": 1,
  236. "subtype": 1,
  237. "area": 1,
  238. "s_subscopeclass": 1,
  239. "city": 1,
  240. "district": 1,
  241. "buyerclass": 1,
  242. "jsondata": 1,
  243. "budget": 1,
  244. "bidamount": 1,
  245. "isValidFile": 1,
  246. "site": 1,
  247. "agencyperson": 1,
  248. "agencytel": 1,
  249. "winnerperson": 1,
  250. "winnertel": 1,
  251. "signendtime": 1,
  252. "bidendtime": 1,
  253. "entidlist": 1,
  254. "autoid": 1,
  255. }
  256. if fields != nil {
  257. for k, v := range fields {
  258. if util.IntAll(v) == 0 {
  259. delete(queryField, k)
  260. } else {
  261. queryField[k] = v
  262. }
  263. }
  264. }
  265. var res []map[string]interface{}
  266. sess := mgo.GetMgoConn()
  267. defer mgo.DestoryMongoConn(sess)
  268. it := sess.DB(dbName).C(coll).Find(query).Select(queryField).Iter()
  269. var index int64
  270. for temp := make(map[string]interface{}); it.Next(&temp); {
  271. _id := BsonIdToSId(temp["_id"])
  272. if publishtime := util.Int64All(temp["publishtime"]); startTime-publishtime > 7*86400 {
  273. logger.Info(_id, "发布时间大于7天,不参与匹配", startTime, publishtime)
  274. continue
  275. }
  276. temp["_id"] = _id
  277. title, _ := temp["title"].(string)
  278. title = strings.ReplaceAll(title, "\n", "")
  279. temp["title"] = title
  280. if util.ObjToString(temp["area"]) == "A" {
  281. temp["area"] = "全国"
  282. }
  283. temp["attachment_count"] = GetAttachmentCount(temp)
  284. res = append(res, temp)
  285. index++
  286. if index%500 == 0 {
  287. logger.Info("加载", coll, "数据:", index)
  288. }
  289. if maxSize > 0 && index == maxSize {
  290. break
  291. }
  292. }
  293. if util.IntAll(queryField["detail"]) > 0 {
  294. for _, temp := range res {
  295. _id := ObjToString(temp["_id"])
  296. if ossAddr != "" {
  297. repl, err := client.GetBidDetailByRpc(ossAddr, &entity.Args{"detail", _id})
  298. if err != nil {
  299. temp["detail"] = repl.Data
  300. }
  301. }
  302. if redisCache {
  303. //信息缓存3天
  304. info := map[string]interface{}{}
  305. for _, v := range SaveBiddingField {
  306. if v == "_id" || temp[v] == nil {
  307. continue
  308. }
  309. info[v] = temp[v]
  310. }
  311. if temp["detail"] != nil {
  312. info["detail"] = temp["detail"]
  313. }
  314. redis.Put(Pushcache_1, "info_"+_id, info, OneDaySecond)
  315. }
  316. }
  317. }
  318. if util.IntAll(queryField["filetext"]) > 0 {
  319. BiddingRepair(res, "filetext")
  320. }
  321. logger.Info(coll, "数据已经加载结束。。。", index)
  322. return &res, endTime
  323. }
  324. func BiddingRepair(res []map[string]interface{}, fields string) {
  325. array := []map[string]interface{}{}
  326. for _, v := range res {
  327. array = append(array, v)
  328. if len(array) == 50 {
  329. OnceBiddingRepair(array, fields)
  330. array = []map[string]interface{}{}
  331. }
  332. }
  333. if len(array) > 0 {
  334. OnceBiddingRepair(array, fields)
  335. array = []map[string]interface{}{}
  336. }
  337. }
  338. func OnceBiddingRepair(array []map[string]interface{}, fields string) {
  339. if es.VarEs == nil {
  340. return
  341. }
  342. ids := []string{}
  343. for _, v := range array {
  344. ids = append(ids, fmt.Sprintf(`"%s"`, util.ObjToString(v["_id"])))
  345. }
  346. m := map[string]map[string]interface{}{}
  347. list := es.VarEs.Get(Es_Bidding, Es_Bidding, fmt.Sprintf(Es_Query_By_Ids, strings.Join(ids, ","), fields, len(ids)))
  348. if list == nil {
  349. return
  350. }
  351. for _, v := range *list {
  352. m[util.ObjToString(v["_id"])] = v
  353. }
  354. for _, v := range array {
  355. obj := m[util.ObjToString(v["_id"])]
  356. if obj == nil {
  357. continue
  358. }
  359. for kk, vv := range obj {
  360. v[kk] = vv
  361. }
  362. }
  363. }
  364. func ToSortList(list interface{}) *SortList {
  365. sl := make(SortList, 0)
  366. if list == nil {
  367. return &sl
  368. }
  369. b, err := json.Marshal(list)
  370. if err != nil {
  371. return &sl
  372. }
  373. err = json.Unmarshal(b, &sl)
  374. if err != nil {
  375. return &sl
  376. }
  377. sort.Sort(sl)
  378. return &sl
  379. }
  380. // 第一个参数是老数据,第二个参数是新进数据
  381. func MergeSortList(o, n interface{}, maxPushSize int) *SortList {
  382. of, oo := o.(*SortList)
  383. if !oo {
  384. of = ToSortList(o)
  385. }
  386. nf, no := n.(*SortList)
  387. if !no {
  388. nf = ToSortList(n)
  389. }
  390. idMap := map[string]bool{}
  391. for _, v := range *nf {
  392. idMap[util.ObjToString(v.Info["_id"])] = true
  393. }
  394. for _, v := range *of {
  395. if idMap[util.ObjToString(v.Info["_id"])] {
  396. continue
  397. }
  398. *nf = append(*nf, v)
  399. }
  400. sort.Sort(nf)
  401. if maxPushSize > 0 && len(*nf) > maxPushSize {
  402. *nf = (*nf)[:maxPushSize]
  403. }
  404. return nf
  405. }
  406. // 获取招标信息附件数量
  407. func GetAttachmentCount(temp map[string]interface{}) int {
  408. isValidFile, _ := temp["isValidFile"].(bool)
  409. if isValidFile {
  410. return 1
  411. }
  412. return 0
  413. }
  414. // 获取招标信息附件数量
  415. func GetAttachmentCountById(mgo *MongodbSim, dbName, coll, _id string) int {
  416. sess := mgo.GetMgoConn()
  417. defer mgo.DestoryMongoConn(sess)
  418. temp := map[string]interface{}{}
  419. sess.DB(dbName).C(coll).Find(map[string]interface{}{
  420. "_id": StringTOBsonId(_id),
  421. }).Select(map[string]interface{}{
  422. "isValidFile": 1,
  423. }).One(&temp)
  424. if temp != nil {
  425. return GetAttachmentCount(temp)
  426. }
  427. return -1
  428. }
  429. func NewBiddingInfo(info map[string]interface{}, keys []string) *BiddingInfo {
  430. bi := &BiddingInfo{}
  431. bi.Title, _ = info["title"].(string)
  432. bi.ClearTitle = TitleClearRe.ReplaceAllString(strings.Replace(bi.Title, "\n", "", -1), "$1")
  433. bi.Area, _ = info["area"].(string)
  434. if bi.Area == "A" {
  435. bi.Area = "全国"
  436. }
  437. bi.AreaTitle = fmt.Sprintf("[%s]%s", bi.Area, bi.ClearTitle)
  438. bi.Publishtime = util.Int64All(info["publishtime"])
  439. bi.PublishtimeYMD = FormatDateByInt64(&bi.Publishtime, Date_Short_Layout)
  440. bi.PublishtimeDiff = util.TimeDiff(time.Unix(bi.Publishtime, 0))
  441. bi.Buyerclass, _ = info["buyerclass"].(string)
  442. bi.Subscopeclass = GetSubScopeClass(info["s_subscopeclass"])
  443. bi.Bidamount = info["bidamount"]
  444. bi.Budget = info["budget"]
  445. if bi.Bidamount != nil {
  446. bi.Acount = ConversionMoney(bi.Bidamount)
  447. } else if bi.Budget != nil {
  448. bi.Acount = ConversionMoney(bi.Budget)
  449. }
  450. bi.Id, _ = info["_id"].(string)
  451. bi.AutoId = Int64All(info["autoid"])
  452. bi.Subtype, _ = info["subtype"].(string)
  453. bi.Toptype, _ = info["toptype"].(string)
  454. bi.Infotype = bi.Subtype
  455. if bi.Infotype == "" {
  456. bi.Infotype = bi.Toptype
  457. }
  458. bi.HighlightTitle = bi.ClearTitle
  459. for _, kw := range keys {
  460. kws := strings.Split(kw, "+")
  461. n := 0
  462. otitle := bi.HighlightTitle
  463. for _, kwn := range kws {
  464. ot := strings.Replace(otitle, kwn, "<span class='keys'>"+kwn+"</span>", 1)
  465. if ot != bi.HighlightTitle {
  466. n++
  467. otitle = ot
  468. } else {
  469. break
  470. }
  471. }
  472. if n == len(kws) {
  473. bi.HighlightTitle = otitle
  474. break
  475. }
  476. }
  477. return bi
  478. }
  479. func SortListSplit(list *SortList, f func(v interface{})) {
  480. l := len(*list)
  481. if l == 0 {
  482. return
  483. }
  484. i := Mgo_ListSize
  485. for {
  486. if l > i {
  487. arr := (*list)[i-Mgo_ListSize : i]
  488. f(&arr)
  489. } else if l > i-Mgo_ListSize {
  490. arr := (*list)[i-Mgo_ListSize:]
  491. f(&arr)
  492. break
  493. }
  494. i += Mgo_ListSize
  495. }
  496. }
  497. func CSortListSplit(list *CSortList, f func(v interface{})) {
  498. l := len(*list)
  499. if l == 0 {
  500. return
  501. }
  502. i := Mgo_ListSize
  503. for {
  504. if l > i {
  505. arr := (*list)[i-Mgo_ListSize : i]
  506. f(&arr)
  507. } else if l > i-Mgo_ListSize {
  508. arr := (*list)[i-Mgo_ListSize:]
  509. f(&arr)
  510. break
  511. }
  512. i += Mgo_ListSize
  513. }
  514. }
  515. // 获取企业授权超级订阅/大会员的用户
  516. func LoadEntProductUsers(msl *Mysql, testUserIds []int) (map[string]*UserInfo, map[int]*UserInfo, map[int]*UserInfo, []*UserInfo) {
  517. logger.Info("开始加载企业授权用户。。。")
  518. phoneMap := map[string]*UserInfo{}
  519. userMap := map[int]*UserInfo{}
  520. entMap := map[int]*UserInfo{}
  521. all := []*UserInfo{}
  522. query := `SELECT DISTINCT a.ent_id,IF(instr(a.product_type,'` + Ent_EmpowerMember + `')>0,'` + Ent_EmpowerMember + `','` + Ent_EmpowerVip + `') as product_type,c.phone,b.ent_user_id,d.name as ent_name,d.power_source,d.isNew from jianyu.entniche_wait_empower a
  523. inner join jianyu.entniche_power b on (a.end_time>? and b.status=1 and (a.product_type like '%` + Ent_EmpowerVip + `%' or a.product_type like '%` + Ent_EmpowerMember + `%') and a.id=b.wait_empower_id)
  524. inner join jianyu.entniche_user c on (`
  525. if len(testUserIds) > 0 {
  526. array := []string{}
  527. for _, v := range testUserIds {
  528. array = append(array, fmt.Sprint(v))
  529. }
  530. query += `c.id in (` + strings.Join(array, ",") + `) and `
  531. }
  532. query += `b.ent_user_id=c.id)
  533. inner join jianyu.entniche_info d on (d.id=a.ent_id)`
  534. msl.SelectByBath(200, func(l *[]map[string]interface{}) bool {
  535. for _, v := range *l {
  536. phone, _ := v["phone"].(string)
  537. if phone == "" {
  538. continue
  539. }
  540. u := &UserInfo{
  541. Entniche: &Entniche{
  542. EntId: util.IntAll(v["ent_id"]),
  543. EntName: util.ObjToString(v["ent_name"]),
  544. UserId: util.IntAll(v["ent_user_id"]),
  545. ProductType: util.ObjToString(v["product_type"]),
  546. PowerSource: util.IntAll(v["power_source"]),
  547. IsNew: util.IntAll(v["isNew"]),
  548. },
  549. Phone: phone,
  550. }
  551. if strings.Contains(u.Entniche.ProductType, Ent_EmpowerMember) {
  552. u.MemberStatus = 1
  553. } else if strings.Contains(u.Entniche.ProductType, Ent_EmpowerVip) {
  554. u.VipStatus = 1
  555. } else {
  556. continue
  557. }
  558. phoneMap[phone] = u
  559. userMap[u.Entniche.UserId] = u
  560. all = append(all, u)
  561. entMap[u.Entniche.EntId] = u
  562. logger.Info("加载企业授权用户", u.Entniche.EntName, u.Entniche.EntId, u.Entniche.UserId, u.Entniche.ProductType, u.Phone)
  563. }
  564. return true
  565. }, query, NowFormat(Date_Full_Layout))
  566. logger.Info("企业授权用户加载结束。。。", len(phoneMap), len(userMap), len(entMap), len(all))
  567. return phoneMap, userMap, entMap, all
  568. }
  569. // 加载商机管理用户
  570. func LoadEntnicheUsers(msl *Mysql) map[string]bool {
  571. logger.Info("开始加载新版商机管理用户。。。")
  572. r := map[string]bool{}
  573. msl.SelectByBath(200, func(l *[]map[string]interface{}) bool {
  574. for _, v := range *l {
  575. phone := util.ObjToString(v["phone"])
  576. if phone != "" {
  577. r[phone] = true
  578. logger.Info("加载商机管理用户", phone)
  579. }
  580. }
  581. return true
  582. }, `SELECT b.phone from jianyu.entniche_info a INNER JOIN jianyu.entniche_user b on (a.status=1 and a.power_source is null and b.power=1 and a.id=b.ent_id)`)
  583. logger.Info("商机管理用户加载结束。。。", len(r))
  584. return r
  585. }
  586. func GetWxTplMsg(subSet *SubSet) (string, string) {
  587. keyword := strings.Join(subSet.Keys, " ")
  588. if len([]rune(keyword)) > 100 {
  589. keyword = string([]rune(keyword)[:100]) + "..."
  590. }
  591. area := strings.Join(subSet.Areas, " ")
  592. if len([]rune(area)) > 100 {
  593. area = string([]rune(area)[:100]) + "..."
  594. }
  595. if area == "" {
  596. area = "全国"
  597. }
  598. return keyword, area
  599. }
  600. func GetPhone(u map[string]interface{}) string {
  601. phone := util.ObjToString(u["s_phone"])
  602. if phone == "" {
  603. phone = util.ObjToString(u["s_m_phone"])
  604. }
  605. return phone
  606. }
  607. func GetAllByEntUserId(mgo *MongodbSim, msl *Mysql, entUserId int) *map[string]interface{} {
  608. entUsers := msl.SelectBySql(`select phone from jianyu.entniche_user where id=?`, entUserId)
  609. if entUsers == nil || len(*entUsers) == 0 {
  610. logger.Info("entniche_user表中没有找到该企业用户", entUserId)
  611. return nil
  612. }
  613. phone, _ := (*entUsers)[0]["phone"].(string)
  614. if phone == "" {
  615. return nil
  616. }
  617. return getEntPushSet(mgo, msl, entUserId, phone)
  618. }
  619. func GetAllByEntPositionId(mgo *MongodbSim, msl *Mysql, positionId int) *map[string]interface{} {
  620. position := msl.SelectBySql(`select a.ent_id,b.phone from base_service.base_position a inner join base_service.base_user b on (a.id=? and a.user_id=b.id)`, positionId)
  621. if position == nil || len(*position) == 0 {
  622. logger.Info("无效的职位id", position)
  623. return nil
  624. }
  625. entId := util.Int64All((*position)[0]["ent_id"])
  626. if entId == 0 {
  627. logger.Info("该职位id没有找到对应的企业id", position)
  628. return nil
  629. }
  630. phone, _ := (*position)[0]["phone"].(string)
  631. if phone == "" {
  632. logger.Info("该职位id没有找到对应的手机号", position)
  633. return nil
  634. }
  635. entUsers := msl.SelectBySql(`select id from jianyu.entniche_user where phone=? and ent_id=?`, phone, entId)
  636. if entUsers == nil || len(*entUsers) == 0 {
  637. logger.Info("entniche_user表中没有找到该企业用户", phone, entId)
  638. return nil
  639. }
  640. return getEntPushSet(mgo, msl, util.IntAll((*entUsers)[0]["id"]), phone)
  641. }
  642. func getEntPushSet(mgo *MongodbSim, msl *Mysql, entUserId int, phone string) *map[string]interface{} {
  643. users, ok := mgo.Find(Mgo_User, map[string]interface{}{
  644. "$or": []map[string]interface{}{
  645. map[string]interface{}{
  646. "s_phone": phone,
  647. },
  648. map[string]interface{}{
  649. "s_m_phone": phone,
  650. },
  651. },
  652. }, `{"s_phone":-1}`, map[string]interface{}{
  653. "_id": 1,
  654. "s_m_openid": 1,
  655. "a_m_openid": 1,
  656. "s_phone": 1,
  657. "s_m_phone": 1,
  658. "i_ispush": 1,
  659. "s_jpushid": 1,
  660. "s_opushid": 1,
  661. "s_appponetype": 1,
  662. "base_user_id": 1,
  663. }, false, -1, -1)
  664. if !ok || users == nil || len(*users) == 0 {
  665. logger.Info("user表中没有找到该企业用户", entUserId, phone)
  666. return nil
  667. }
  668. user := map[string]interface{}{}
  669. for _, v := range *users {
  670. if user["_id"] == nil {
  671. user["_id"] = v["_id"]
  672. user["base_user_id"] = v["base_user_id"]
  673. }
  674. if user["s_phone"] == nil && util.ObjToString(v["s_phone"]) != "" {
  675. user["s_phone"] = v["s_phone"]
  676. }
  677. if user["s_m_phone"] == nil && util.ObjToString(v["s_m_phone"]) != "" {
  678. user["s_m_phone"] = v["s_m_phone"]
  679. }
  680. if user["a_m_openid"] == nil && util.ObjToString(v["a_m_openid"]) != "" {
  681. user["a_m_openid"] = v["a_m_openid"]
  682. }
  683. s_m_openid := util.ObjToString(v["s_m_openid"])
  684. i_ispush := util.IntAll(v["i_ispush"])
  685. s_jpushid := util.ObjToString(v["s_jpushid"])
  686. s_opushid := util.ObjToString(v["s_opushid"])
  687. s_appponetype := util.ObjToString(v["s_appponetype"])
  688. if user["s_m_openid"] == nil && user["i_ispush"] == nil && s_m_openid != "" && i_ispush == 1 {
  689. user["s_m_openid"] = s_m_openid
  690. user["i_ispush"] = i_ispush
  691. }
  692. if user["s_jpushid"] == nil && user["s_opushid"] == nil && user["s_appponetype"] == nil && s_appponetype != "" && (s_jpushid != "" || s_opushid != "") {
  693. user["s_jpushid"] = s_jpushid
  694. user["s_opushid"] = s_opushid
  695. user["s_appponetype"] = s_appponetype
  696. }
  697. }
  698. entniche_user, ok := mgo.FindOneByField(Mgo_Ent_User, map[string]interface{}{
  699. "i_userid": entUserId,
  700. }, `{"_id":0,"i_member_status":1,"i_vip_status":1,"o_pushset":1}`)
  701. if ok && entniche_user != nil && len(*entniche_user) > 0 {
  702. for k, v := range *entniche_user {
  703. user[k] = v
  704. }
  705. }
  706. entniche_rule, ok := mgo.Find("entniche_rule", map[string]interface{}{
  707. "i_userid": entUserId,
  708. }, nil, `{"_id":0,"o_entniche":1,"i_type":1}`, false, -1, -1)
  709. if ok && entniche_rule != nil {
  710. for _, v := range *entniche_rule {
  711. i_type := util.IntAll(v["i_type"])
  712. if i_type == 0 {
  713. user["o_entniche"] = v["o_entniche"]
  714. } else if i_type == 1 {
  715. user["o_vipjy"] = v["o_entniche"]
  716. user["o_member_jy"] = v["o_entniche"]
  717. } else if i_type == 2 {
  718. user["o_jy"] = v["o_entniche"]
  719. }
  720. }
  721. }
  722. return &user
  723. }
  724. func GetEntUserPushset(mgo *MongodbSim, entUserId int) map[string]interface{} {
  725. temp, ok := mgo.FindOneByField(Mgo_Ent_User, map[string]interface{}{
  726. "i_userid": entUserId,
  727. }, `{"o_pushset":1}`)
  728. if ok && temp != nil && len(*temp) > 0 {
  729. o_pushset, _ := (*temp)["o_pushset"].(map[string]interface{})
  730. return o_pushset
  731. }
  732. return nil
  733. }
  734. func GetEntUserSubset(mgo *MongodbSim, entUserId, tp int) map[string]interface{} {
  735. temp, ok := mgo.FindOneByField("entniche_rule", map[string]interface{}{
  736. "i_userid": entUserId,
  737. "i_type": tp,
  738. }, `{"o_entniche":1}`)
  739. if ok && temp != nil && len(*temp) > 0 {
  740. o_msgset, _ := (*temp)["o_entniche"].(map[string]interface{})
  741. return o_msgset
  742. }
  743. return nil
  744. }
  745. // 格式化小时
  746. func HourFormat(hour int) string {
  747. if hour < 10 {
  748. return fmt.Sprintf("0%d:00", hour)
  749. } else {
  750. return fmt.Sprintf("%d:00", hour)
  751. }
  752. }
  753. // 数组中的小时是否结束
  754. func TimesIsOver(times []string, hour int) (bool, time.Time, time.Time) {
  755. now := time.Now()
  756. if len(times) == 0 {
  757. return false, now, now
  758. }
  759. sort.Strings(times)
  760. lastHour := util.IntAll(strings.Split(times[len(times)-1], ":")[0])
  761. //跨天
  762. if lastHour == 23 && hour == 0 {
  763. start := time.Date(now.Year(), now.Month(), now.Day()-1, 0, 0, 0, 0, time.Local)
  764. end := time.Date(now.Year(), now.Month(), now.Day()-1, 23, 59, 59, 0, time.Local)
  765. return true, start, end
  766. } else {
  767. start := time.Date(now.Year(), now.Month(), now.Day(), 0, 0, 0, 0, time.Local)
  768. return hour-1 == lastHour, start, now
  769. }
  770. }
  771. // 监听超时
  772. func MonitorTimeOut(pool chan bool, timeout time.Duration, warn string, f func()) bool {
  773. select {
  774. case <-time.After(timeout):
  775. go func() {
  776. f()
  777. if warn != "" {
  778. if _, err := http.Get(warn); err != nil {
  779. logger.Error("发送告警邮件错误", err)
  780. }
  781. }
  782. }()
  783. return false
  784. case pool <- true:
  785. }
  786. return true
  787. }
  788. // 根据职位id获取用户信息
  789. func GetUserInfoByPosition(msl *Mysql, mgo *MongodbSim, id int64) *UserInfo {
  790. list := msl.SelectBySql(`select user_id from base_service.base_position where id=?`, id)
  791. if list == nil || len(*list) == 0 {
  792. return nil
  793. }
  794. data, ok := mgo.FindOneByField("user", map[string]interface{}{
  795. "base_user_id": util.Int64All((*list)[0]["user_id"]),
  796. }, `{"_id":1}`)
  797. if !ok || data == nil || len(*data) == 0 {
  798. return nil
  799. }
  800. return &UserInfo{
  801. Id: BsonIdToSId((*data)["_id"]),
  802. }
  803. }
  804. // 资源中台权益
  805. var rcpLock = &sync.Mutex{}
  806. func ResourceCenterPowers(msl *Mysql, positionId int64) map[string]bool {
  807. rcpLock.Lock()
  808. if rcDb.Mysql_BaseService == nil {
  809. rcDb.Mysql_BaseService = &Mysql{
  810. Address: msl.Address,
  811. UserName: msl.UserName,
  812. PassWord: msl.PassWord,
  813. DBName: "base_service",
  814. MaxOpenConns: msl.MaxOpenConns,
  815. MaxIdleConns: msl.MaxIdleConns,
  816. }
  817. rcDb.Mysql_BaseService.Init()
  818. }
  819. rcpLock.Unlock()
  820. powers := map[string]bool{}
  821. if identity := IdentityByPositionId(msl, positionId); identity != nil {
  822. list, _ := rcService.HasPowers("10000", identity.AccountId, identity.EntAccountId, identity.EntId, identity.EntUserId)
  823. for _, v := range list {
  824. powers[v] = true
  825. }
  826. }
  827. return powers
  828. }
  829. func MergeDiffIndustry(wuye, other *[]map[string]interface{}) *[]map[string]interface{} {
  830. m := map[string]map[string]interface{}{}
  831. for _, v := range *wuye {
  832. _id := BsonIdToSId(v["_id"])
  833. tag_topinformation, _ := v["tag_topinformation"].([]interface{})
  834. for _, vv := range tag_topinformation {
  835. if vv != "情报_物业" {
  836. continue
  837. }
  838. m[_id] = v
  839. }
  840. }
  841. for _, v := range *other {
  842. _id := BsonIdToSId(v["_id"])
  843. tag_topinformation, _ := v["tag_topinformation"].([]interface{})
  844. if len(tag_topinformation) == 1 && tag_topinformation[0] == "情报_物业" {
  845. continue
  846. }
  847. m[_id] = v
  848. }
  849. datas := []map[string]interface{}{}
  850. for _, v := range m {
  851. datas = append(datas, v)
  852. }
  853. return &datas
  854. }
  855. // 获取无消息提醒微信模板消息的可用数量
  856. func WxNoMsgTmplUsableNum(mgo *MongodbSim, wxNodeNum, dayNum, count, retain int64) int64 {
  857. if count < 0 {
  858. return -1
  859. }
  860. ymds := []string{}
  861. now := time.Now()
  862. for i := 0; i < int(dayNum); i++ {
  863. now = now.AddDate(0, 0, -1)
  864. ymds = append(ymds, FormatDate(&now, Date_Short_Layout))
  865. }
  866. list, ok := mgo.Find("wxtmplsend_tj", map[string]interface{}{"type": map[string]interface{}{"$in": []string{"all", "free_nomsg"}}, "ymd": map[string]interface{}{"$in": ymds}}, `{"ymd":-1}`, `{"count":1,"node":1,"ymd":1,"type":1}`, false, -1, -1)
  867. if !ok || list == nil || len(*list) == 0 {
  868. logger.Error("wxtmplsend_tj没有找到记录", ymds)
  869. return 0
  870. }
  871. all := map[string]map[string]int64{}
  872. ymdCount := map[string]int64{}
  873. ymdNoMsgCount := map[string]int64{}
  874. for _, v := range *list {
  875. ymd, _ := v["ymd"].(string)
  876. if all[ymd] == nil {
  877. all[ymd] = map[string]int64{}
  878. }
  879. tp := ObjToString(v["type"])
  880. all[ymd][fmt.Sprintf("%s %s", tp, ObjToString(v["node"]))]++
  881. if tp == "all" {
  882. ymdCount[ymd] += Int64All(v["count"])
  883. } else {
  884. ymdNoMsgCount[ymd] += Int64All(v["count"])
  885. }
  886. }
  887. var index, maxNum, maxNoMsgNum int64
  888. var hitYmd string
  889. L:
  890. for _, v := range ymds {
  891. if all[v] == nil || int64(len(all[v])) != wxNodeNum+1 {
  892. continue
  893. }
  894. for _, vv := range all[v] {
  895. if vv != 1 {
  896. continue L
  897. }
  898. }
  899. index++
  900. if maxNum < ymdCount[v] {
  901. hitYmd = v
  902. maxNum = ymdCount[v]
  903. maxNoMsgNum = ymdNoMsgCount[v]
  904. }
  905. }
  906. if index < dayNum/2 {
  907. logger.Error("计算以往最大推送量异常", index, dayNum/2)
  908. return 0
  909. }
  910. surplus := count - maxNum - retain + maxNoMsgNum
  911. if surplus < 0 {
  912. return 0
  913. }
  914. logger.Info("微信模板消息最大量", count, ",过去", dayNum, "天", hitYmd, "的推送量最大", maxNum, ",无消息提醒的推送量", maxNoMsgNum, ",保留", retain, ",剩余可用", surplus)
  915. return surplus
  916. }