public.go 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952
  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 util.ObjToString(temp["detail"]) == "" && ossAddr != "" {
  297. if repl, err := ossClient.GetBidDetailByGrpc(ossAddr, &entity.Args{"detail", _id}); err != nil {
  298. temp["detail"] = repl.Data
  299. }
  300. }
  301. if redisCache {
  302. //信息缓存3天
  303. info := map[string]interface{}{}
  304. for _, v := range SaveBiddingField {
  305. if v == "_id" || temp[v] == nil {
  306. continue
  307. }
  308. info[v] = temp[v]
  309. }
  310. if temp["detail"] != nil {
  311. info["detail"] = temp["detail"]
  312. }
  313. redis.Put(Pushcache_1, "info_"+_id, info, OneDaySecond)
  314. }
  315. }
  316. }
  317. if util.IntAll(queryField["filetext"]) > 0 {
  318. BiddingRepair(res, "filetext")
  319. }
  320. logger.Info(coll, "数据已经加载结束。。。", index)
  321. return &res, endTime
  322. }
  323. func BiddingRepair(res []map[string]interface{}, fields string) {
  324. array := []map[string]interface{}{}
  325. for _, v := range res {
  326. array = append(array, v)
  327. if len(array) == 50 {
  328. OnceBiddingRepair(array, fields)
  329. array = []map[string]interface{}{}
  330. }
  331. }
  332. if len(array) > 0 {
  333. OnceBiddingRepair(array, fields)
  334. array = []map[string]interface{}{}
  335. }
  336. }
  337. func OnceBiddingRepair(array []map[string]interface{}, fields string) {
  338. if es.VarEs == nil {
  339. return
  340. }
  341. ids := []string{}
  342. for _, v := range array {
  343. ids = append(ids, fmt.Sprintf(`"%s"`, util.ObjToString(v["_id"])))
  344. }
  345. m := map[string]map[string]interface{}{}
  346. list := es.VarEs.Get(Es_Bidding, Es_Bidding, fmt.Sprintf(Es_Query_By_Ids, strings.Join(ids, ","), fields, len(ids)))
  347. if list == nil {
  348. return
  349. }
  350. for _, v := range *list {
  351. m[util.ObjToString(v["_id"])] = v
  352. }
  353. for _, v := range array {
  354. obj := m[util.ObjToString(v["_id"])]
  355. if obj == nil {
  356. continue
  357. }
  358. for kk, vv := range obj {
  359. v[kk] = vv
  360. }
  361. }
  362. }
  363. func ToSortList(list interface{}) *SortList {
  364. sl := make(SortList, 0)
  365. if list == nil {
  366. return &sl
  367. }
  368. b, err := json.Marshal(list)
  369. if err != nil {
  370. return &sl
  371. }
  372. err = json.Unmarshal(b, &sl)
  373. if err != nil {
  374. return &sl
  375. }
  376. sort.Sort(sl)
  377. return &sl
  378. }
  379. // 第一个参数是老数据,第二个参数是新进数据
  380. func MergeSortList(o, n interface{}, maxPushSize int) *SortList {
  381. of, oo := o.(*SortList)
  382. if !oo {
  383. of = ToSortList(o)
  384. }
  385. nf, no := n.(*SortList)
  386. if !no {
  387. nf = ToSortList(n)
  388. }
  389. idMap := map[string]bool{}
  390. for _, v := range *nf {
  391. idMap[util.ObjToString(v.Info["_id"])] = true
  392. }
  393. for _, v := range *of {
  394. if idMap[util.ObjToString(v.Info["_id"])] {
  395. continue
  396. }
  397. *nf = append(*nf, v)
  398. }
  399. sort.Sort(nf)
  400. if maxPushSize > 0 && len(*nf) > maxPushSize {
  401. *nf = (*nf)[:maxPushSize]
  402. }
  403. return nf
  404. }
  405. // 获取招标信息附件数量
  406. func GetAttachmentCount(temp map[string]interface{}) int {
  407. isValidFile, _ := temp["isValidFile"].(bool)
  408. if isValidFile {
  409. return 1
  410. }
  411. return 0
  412. }
  413. // 获取招标信息附件数量
  414. func GetAttachmentCountById(mgo *MongodbSim, dbName, coll, _id string) int {
  415. sess := mgo.GetMgoConn()
  416. defer mgo.DestoryMongoConn(sess)
  417. temp := map[string]interface{}{}
  418. sess.DB(dbName).C(coll).Find(map[string]interface{}{
  419. "_id": StringTOBsonId(_id),
  420. }).Select(map[string]interface{}{
  421. "isValidFile": 1,
  422. }).One(&temp)
  423. if temp != nil {
  424. return GetAttachmentCount(temp)
  425. }
  426. return -1
  427. }
  428. func NewBiddingInfo(info map[string]interface{}, keys []string) *BiddingInfo {
  429. bi := &BiddingInfo{}
  430. bi.Title, _ = info["title"].(string)
  431. bi.ClearTitle = TitleClearRe.ReplaceAllString(strings.Replace(bi.Title, "\n", "", -1), "$1")
  432. bi.Area, _ = info["area"].(string)
  433. if bi.Area == "A" {
  434. bi.Area = "全国"
  435. }
  436. bi.AreaTitle = fmt.Sprintf("[%s]%s", bi.Area, bi.ClearTitle)
  437. bi.Publishtime = util.Int64All(info["publishtime"])
  438. bi.PublishtimeYMD = FormatDateByInt64(&bi.Publishtime, Date_Short_Layout)
  439. bi.PublishtimeDiff = util.TimeDiff(time.Unix(bi.Publishtime, 0))
  440. bi.Buyerclass, _ = info["buyerclass"].(string)
  441. bi.Subscopeclass = GetSubScopeClass(info["s_subscopeclass"])
  442. bi.Bidamount = info["bidamount"]
  443. bi.Budget = info["budget"]
  444. if bi.Bidamount != nil {
  445. bi.Acount = ConversionMoney(bi.Bidamount)
  446. } else if bi.Budget != nil {
  447. bi.Acount = ConversionMoney(bi.Budget)
  448. }
  449. bi.Id, _ = info["_id"].(string)
  450. bi.AutoId = Int64All(info["autoid"])
  451. bi.Subtype, _ = info["subtype"].(string)
  452. bi.Toptype, _ = info["toptype"].(string)
  453. bi.Infotype = bi.Subtype
  454. if bi.Infotype == "" {
  455. bi.Infotype = bi.Toptype
  456. }
  457. bi.HighlightTitle = bi.ClearTitle
  458. for _, kw := range keys {
  459. kws := strings.Split(kw, "+")
  460. n := 0
  461. otitle := bi.HighlightTitle
  462. for _, kwn := range kws {
  463. ot := strings.Replace(otitle, kwn, "<span class='keys'>"+kwn+"</span>", 1)
  464. if ot != bi.HighlightTitle {
  465. n++
  466. otitle = ot
  467. } else {
  468. break
  469. }
  470. }
  471. if n == len(kws) {
  472. bi.HighlightTitle = otitle
  473. break
  474. }
  475. }
  476. return bi
  477. }
  478. func SortListSplit(list *SortList, f func(v interface{})) {
  479. l := len(*list)
  480. if l == 0 {
  481. return
  482. }
  483. i := Mgo_ListSize
  484. for {
  485. if l > i {
  486. arr := (*list)[i-Mgo_ListSize : i]
  487. f(&arr)
  488. } else if l > i-Mgo_ListSize {
  489. arr := (*list)[i-Mgo_ListSize:]
  490. f(&arr)
  491. break
  492. }
  493. i += Mgo_ListSize
  494. }
  495. }
  496. func CSortListSplit(list *CSortList, f func(v interface{})) {
  497. l := len(*list)
  498. if l == 0 {
  499. return
  500. }
  501. i := Mgo_ListSize
  502. for {
  503. if l > i {
  504. arr := (*list)[i-Mgo_ListSize : i]
  505. f(&arr)
  506. } else if l > i-Mgo_ListSize {
  507. arr := (*list)[i-Mgo_ListSize:]
  508. f(&arr)
  509. break
  510. }
  511. i += Mgo_ListSize
  512. }
  513. }
  514. // 获取企业授权超级订阅/大会员的用户
  515. func LoadEntProductUsers(msl *Mysql, testUserIds []int) (map[string]*UserInfo, map[int]*UserInfo, map[int]*UserInfo, []*UserInfo) {
  516. logger.Info("开始加载企业授权用户。。。")
  517. phoneMap := map[string]*UserInfo{}
  518. userMap := map[int]*UserInfo{}
  519. entMap := map[int]*UserInfo{}
  520. all := []*UserInfo{}
  521. 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
  522. 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)
  523. inner join jianyu.entniche_user c on (`
  524. if len(testUserIds) > 0 {
  525. array := []string{}
  526. for _, v := range testUserIds {
  527. array = append(array, fmt.Sprint(v))
  528. }
  529. query += `c.id in (` + strings.Join(array, ",") + `) and `
  530. }
  531. query += `b.ent_user_id=c.id)
  532. inner join jianyu.entniche_info d on (d.id=a.ent_id)`
  533. msl.SelectByBath(200, func(l *[]map[string]interface{}) bool {
  534. for _, v := range *l {
  535. phone, _ := v["phone"].(string)
  536. if phone == "" {
  537. continue
  538. }
  539. u := &UserInfo{
  540. Entniche: &Entniche{
  541. EntId: util.IntAll(v["ent_id"]),
  542. EntName: util.ObjToString(v["ent_name"]),
  543. UserId: util.IntAll(v["ent_user_id"]),
  544. ProductType: util.ObjToString(v["product_type"]),
  545. PowerSource: util.IntAll(v["power_source"]),
  546. IsNew: util.IntAll(v["isNew"]),
  547. },
  548. Phone: phone,
  549. }
  550. if strings.Contains(u.Entniche.ProductType, Ent_EmpowerMember) {
  551. u.MemberStatus = 1
  552. } else if strings.Contains(u.Entniche.ProductType, Ent_EmpowerVip) {
  553. u.VipStatus = 1
  554. } else {
  555. continue
  556. }
  557. phoneMap[phone] = u
  558. userMap[u.Entniche.UserId] = u
  559. all = append(all, u)
  560. entMap[u.Entniche.EntId] = u
  561. logger.Info("加载企业授权用户", u.Entniche.EntName, u.Entniche.EntId, u.Entniche.UserId, u.Entniche.ProductType, u.Phone)
  562. }
  563. return true
  564. }, query, NowFormat(Date_Full_Layout))
  565. logger.Info("企业授权用户加载结束。。。", len(phoneMap), len(userMap), len(entMap), len(all))
  566. return phoneMap, userMap, entMap, all
  567. }
  568. // 加载商机管理用户
  569. func LoadEntnicheUsers(msl *Mysql) map[string]bool {
  570. logger.Info("开始加载新版商机管理用户。。。")
  571. r := map[string]bool{}
  572. msl.SelectByBath(200, func(l *[]map[string]interface{}) bool {
  573. for _, v := range *l {
  574. phone := util.ObjToString(v["phone"])
  575. if phone != "" {
  576. r[phone] = true
  577. logger.Info("加载商机管理用户", phone)
  578. }
  579. }
  580. return true
  581. }, `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)`)
  582. logger.Info("商机管理用户加载结束。。。", len(r))
  583. return r
  584. }
  585. func GetWxTplMsg(subSet *SubSet) (string, string) {
  586. keyword := strings.Join(subSet.Keys, " ")
  587. if len([]rune(keyword)) > 100 {
  588. keyword = string([]rune(keyword)[:100]) + "..."
  589. }
  590. area := strings.Join(subSet.Areas, " ")
  591. if len([]rune(area)) > 100 {
  592. area = string([]rune(area)[:100]) + "..."
  593. }
  594. if area == "" {
  595. area = "全国"
  596. }
  597. return keyword, area
  598. }
  599. func GetPhone(u map[string]interface{}) string {
  600. phone := util.ObjToString(u["s_phone"])
  601. if phone == "" {
  602. phone = util.ObjToString(u["s_m_phone"])
  603. }
  604. return phone
  605. }
  606. func GetAllByEntUserId(mgo *MongodbSim, msl *Mysql, entUserId int) *map[string]interface{} {
  607. entUsers := msl.SelectBySql(`select phone from jianyu.entniche_user where id=?`, entUserId)
  608. if entUsers == nil || len(*entUsers) == 0 {
  609. logger.Info("entniche_user表中没有找到该企业用户", entUserId)
  610. return nil
  611. }
  612. phone, _ := (*entUsers)[0]["phone"].(string)
  613. if phone == "" {
  614. return nil
  615. }
  616. return getEntPushSet(mgo, msl, entUserId, phone)
  617. }
  618. func GetAllByEntPositionId(mgo *MongodbSim, msl *Mysql, positionId int) *map[string]interface{} {
  619. 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)
  620. if position == nil || len(*position) == 0 {
  621. logger.Info("无效的职位id", position)
  622. return nil
  623. }
  624. entId := util.Int64All((*position)[0]["ent_id"])
  625. if entId == 0 {
  626. logger.Info("该职位id没有找到对应的企业id", position)
  627. return nil
  628. }
  629. phone, _ := (*position)[0]["phone"].(string)
  630. if phone == "" {
  631. logger.Info("该职位id没有找到对应的手机号", position)
  632. return nil
  633. }
  634. entUsers := msl.SelectBySql(`select id from jianyu.entniche_user where phone=? and ent_id=?`, phone, entId)
  635. if entUsers == nil || len(*entUsers) == 0 {
  636. logger.Info("entniche_user表中没有找到该企业用户", phone, entId)
  637. return nil
  638. }
  639. return getEntPushSet(mgo, msl, util.IntAll((*entUsers)[0]["id"]), phone)
  640. }
  641. func getEntPushSet(mgo *MongodbSim, msl *Mysql, entUserId int, phone string) *map[string]interface{} {
  642. users, ok := mgo.Find(Mgo_User, map[string]interface{}{
  643. "$or": []map[string]interface{}{
  644. map[string]interface{}{
  645. "s_phone": phone,
  646. },
  647. map[string]interface{}{
  648. "s_m_phone": phone,
  649. },
  650. },
  651. }, `{"s_phone":-1}`, map[string]interface{}{
  652. "_id": 1,
  653. "s_m_openid": 1,
  654. "a_m_openid": 1,
  655. "s_phone": 1,
  656. "s_m_phone": 1,
  657. "i_ispush": 1,
  658. "s_jpushid": 1,
  659. "s_opushid": 1,
  660. "s_appponetype": 1,
  661. "base_user_id": 1,
  662. }, false, -1, -1)
  663. if !ok || users == nil || len(*users) == 0 {
  664. logger.Info("user表中没有找到该企业用户", entUserId, phone)
  665. return nil
  666. }
  667. user := map[string]interface{}{}
  668. for _, v := range *users {
  669. if user["_id"] == nil {
  670. user["_id"] = v["_id"]
  671. user["base_user_id"] = v["base_user_id"]
  672. }
  673. if user["s_phone"] == nil && util.ObjToString(v["s_phone"]) != "" {
  674. user["s_phone"] = v["s_phone"]
  675. }
  676. if user["s_m_phone"] == nil && util.ObjToString(v["s_m_phone"]) != "" {
  677. user["s_m_phone"] = v["s_m_phone"]
  678. }
  679. if user["a_m_openid"] == nil && util.ObjToString(v["a_m_openid"]) != "" {
  680. user["a_m_openid"] = v["a_m_openid"]
  681. }
  682. s_m_openid := util.ObjToString(v["s_m_openid"])
  683. i_ispush := util.IntAll(v["i_ispush"])
  684. s_jpushid := util.ObjToString(v["s_jpushid"])
  685. s_opushid := util.ObjToString(v["s_opushid"])
  686. s_appponetype := util.ObjToString(v["s_appponetype"])
  687. if user["s_m_openid"] == nil && user["i_ispush"] == nil && s_m_openid != "" && i_ispush == 1 {
  688. user["s_m_openid"] = s_m_openid
  689. user["i_ispush"] = i_ispush
  690. }
  691. if user["s_jpushid"] == nil && user["s_opushid"] == nil && user["s_appponetype"] == nil && s_appponetype != "" && (s_jpushid != "" || s_opushid != "") {
  692. user["s_jpushid"] = s_jpushid
  693. user["s_opushid"] = s_opushid
  694. user["s_appponetype"] = s_appponetype
  695. }
  696. }
  697. entniche_user, ok := mgo.FindOneByField(Mgo_Ent_User, map[string]interface{}{
  698. "i_userid": entUserId,
  699. }, `{"_id":0,"i_member_status":1,"i_vip_status":1,"o_pushset":1}`)
  700. if ok && entniche_user != nil && len(*entniche_user) > 0 {
  701. for k, v := range *entniche_user {
  702. user[k] = v
  703. }
  704. }
  705. entniche_rule, ok := mgo.Find("entniche_rule", map[string]interface{}{
  706. "i_userid": entUserId,
  707. }, nil, `{"_id":0,"o_entniche":1,"i_type":1}`, false, -1, -1)
  708. if ok && entniche_rule != nil {
  709. for _, v := range *entniche_rule {
  710. i_type := util.IntAll(v["i_type"])
  711. if i_type == 0 {
  712. user["o_entniche"] = v["o_entniche"]
  713. } else if i_type == 1 {
  714. user["o_vipjy"] = v["o_entniche"]
  715. user["o_member_jy"] = v["o_entniche"]
  716. } else if i_type == 2 {
  717. user["o_jy"] = v["o_entniche"]
  718. }
  719. }
  720. }
  721. return &user
  722. }
  723. func GetEntUserPushset(mgo *MongodbSim, entUserId int) map[string]interface{} {
  724. temp, ok := mgo.FindOneByField(Mgo_Ent_User, map[string]interface{}{
  725. "i_userid": entUserId,
  726. }, `{"o_pushset":1}`)
  727. if ok && temp != nil && len(*temp) > 0 {
  728. o_pushset, _ := (*temp)["o_pushset"].(map[string]interface{})
  729. return o_pushset
  730. }
  731. return nil
  732. }
  733. func GetEntUserSubset(mgo *MongodbSim, entUserId, tp int) map[string]interface{} {
  734. temp, ok := mgo.FindOneByField("entniche_rule", map[string]interface{}{
  735. "i_userid": entUserId,
  736. "i_type": tp,
  737. }, `{"o_entniche":1}`)
  738. if ok && temp != nil && len(*temp) > 0 {
  739. o_msgset, _ := (*temp)["o_entniche"].(map[string]interface{})
  740. return o_msgset
  741. }
  742. return nil
  743. }
  744. // 格式化小时
  745. func HourFormat(hour int) string {
  746. if hour < 10 {
  747. return fmt.Sprintf("0%d:00", hour)
  748. } else {
  749. return fmt.Sprintf("%d:00", hour)
  750. }
  751. }
  752. // 数组中的小时是否结束
  753. func TimesIsOver(times []string, hour int) (bool, time.Time, time.Time) {
  754. now := time.Now()
  755. if len(times) == 0 {
  756. return false, now, now
  757. }
  758. sort.Strings(times)
  759. lastHour := util.IntAll(strings.Split(times[len(times)-1], ":")[0])
  760. //跨天
  761. if lastHour == 23 && hour == 0 {
  762. start := time.Date(now.Year(), now.Month(), now.Day()-1, 0, 0, 0, 0, time.Local)
  763. end := time.Date(now.Year(), now.Month(), now.Day()-1, 23, 59, 59, 0, time.Local)
  764. return true, start, end
  765. } else {
  766. start := time.Date(now.Year(), now.Month(), now.Day(), 0, 0, 0, 0, time.Local)
  767. return hour-1 == lastHour, start, now
  768. }
  769. }
  770. // 监听超时
  771. func MonitorTimeOut(pool chan bool, timeout time.Duration, warn string, f func()) bool {
  772. select {
  773. case <-time.After(timeout):
  774. go func() {
  775. f()
  776. if warn != "" {
  777. if _, err := http.Get(warn); err != nil {
  778. logger.Error("发送告警邮件错误", err)
  779. }
  780. }
  781. }()
  782. return false
  783. case pool <- true:
  784. }
  785. return true
  786. }
  787. // 根据职位id获取用户信息
  788. func GetUserInfoByPosition(msl *Mysql, mgo *MongodbSim, id int64) *UserInfo {
  789. list := msl.SelectBySql(`select user_id from base_service.base_position where id=?`, id)
  790. if list == nil || len(*list) == 0 {
  791. return nil
  792. }
  793. data, ok := mgo.FindOneByField("user", map[string]interface{}{
  794. "base_user_id": util.Int64All((*list)[0]["user_id"]),
  795. }, `{"_id":1}`)
  796. if !ok || data == nil || len(*data) == 0 {
  797. return nil
  798. }
  799. return &UserInfo{
  800. Id: BsonIdToSId((*data)["_id"]),
  801. }
  802. }
  803. // 资源中台权益
  804. var rcpLock = &sync.Mutex{}
  805. func ResourceCenterPowers(msl *Mysql, positionId int64) map[string]bool {
  806. rcpLock.Lock()
  807. if rcDb.Mysql_BaseService == nil {
  808. rcDb.Mysql_BaseService = &Mysql{
  809. Address: msl.Address,
  810. UserName: msl.UserName,
  811. PassWord: msl.PassWord,
  812. DBName: "base_service",
  813. MaxOpenConns: msl.MaxOpenConns,
  814. MaxIdleConns: msl.MaxIdleConns,
  815. }
  816. rcDb.Mysql_BaseService.Init()
  817. }
  818. rcpLock.Unlock()
  819. powers := map[string]bool{}
  820. if identity := IdentityByPositionId(msl, positionId); identity != nil {
  821. list, _ := rcService.HasPowers("10000", identity.AccountId, identity.EntAccountId, identity.EntId, identity.EntUserId)
  822. for _, v := range list {
  823. powers[v] = true
  824. }
  825. }
  826. return powers
  827. }
  828. func MergeDiffIndustry(wuye, other *[]map[string]interface{}) *[]map[string]interface{} {
  829. m := map[string]map[string]interface{}{}
  830. for _, v := range *wuye {
  831. _id := BsonIdToSId(v["_id"])
  832. tag_topinformation, _ := v["tag_topinformation"].([]interface{})
  833. for _, vv := range tag_topinformation {
  834. if vv != "情报_物业" {
  835. continue
  836. }
  837. m[_id] = v
  838. }
  839. }
  840. for _, v := range *other {
  841. _id := BsonIdToSId(v["_id"])
  842. tag_topinformation, _ := v["tag_topinformation"].([]interface{})
  843. if len(tag_topinformation) == 1 && tag_topinformation[0] == "情报_物业" {
  844. continue
  845. }
  846. m[_id] = v
  847. }
  848. datas := []map[string]interface{}{}
  849. for _, v := range m {
  850. datas = append(datas, v)
  851. }
  852. return &datas
  853. }
  854. // 获取无消息提醒微信模板消息的可用数量
  855. func WxNoMsgTmplUsableNum(mgo *MongodbSim, wxNodeNum, dayNum, count, retain int64) int64 {
  856. if count < 0 {
  857. return -1
  858. }
  859. ymds := []string{}
  860. now := time.Now()
  861. for i := 0; i < int(dayNum); i++ {
  862. now = now.AddDate(0, 0, -1)
  863. ymds = append(ymds, FormatDate(&now, Date_Short_Layout))
  864. }
  865. 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)
  866. if !ok || list == nil || len(*list) == 0 {
  867. logger.Error("wxtmplsend_tj没有找到记录", ymds)
  868. return 0
  869. }
  870. all := map[string]map[string]int64{}
  871. ymdCount := map[string]int64{}
  872. ymdNoMsgCount := map[string]int64{}
  873. for _, v := range *list {
  874. ymd, _ := v["ymd"].(string)
  875. if all[ymd] == nil {
  876. all[ymd] = map[string]int64{}
  877. }
  878. tp := ObjToString(v["type"])
  879. all[ymd][fmt.Sprintf("%s %s", tp, ObjToString(v["node"]))]++
  880. if tp == "all" {
  881. ymdCount[ymd] += Int64All(v["count"])
  882. } else {
  883. ymdNoMsgCount[ymd] += Int64All(v["count"])
  884. }
  885. }
  886. var index, maxNum, maxNoMsgNum int64
  887. var hitYmd string
  888. L:
  889. for _, v := range ymds {
  890. if all[v] == nil || int64(len(all[v])) != wxNodeNum+1 {
  891. continue
  892. }
  893. for _, vv := range all[v] {
  894. if vv != 1 {
  895. continue L
  896. }
  897. }
  898. index++
  899. if maxNum < ymdCount[v] {
  900. hitYmd = v
  901. maxNum = ymdCount[v]
  902. maxNoMsgNum = ymdNoMsgCount[v]
  903. }
  904. }
  905. if index < dayNum/2 {
  906. logger.Error("计算以往最大推送量异常", index, dayNum/2)
  907. return 0
  908. }
  909. surplus := count - maxNum - retain + maxNoMsgNum
  910. if surplus < 0 {
  911. return 0
  912. }
  913. logger.Info("微信模板消息最大量", count, ",过去", dayNum, "天", hitYmd, "的推送量最大", maxNum, ",无消息提醒的推送量", maxNoMsgNum, ",保留", retain, ",剩余可用", surplus)
  914. return surplus
  915. }