openPower.go 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496
  1. package main
  2. import (
  3. "context"
  4. "encoding/json"
  5. "flag"
  6. "fmt"
  7. "log"
  8. "time"
  9. . "app.yhyue.com/moapp/jybase/common"
  10. "app.yhyue.com/moapp/jybase/date"
  11. "app.yhyue.com/moapp/jybase/mongodb"
  12. ml "app.yhyue.com/moapp/jybase/mysql"
  13. . "app.yhyue.com/moapp/jypkg/middleground"
  14. "bp.jydev.jianyu360.cn/BaseService/resourceCenter/rpc/pb"
  15. "bp.jydev.jianyu360.cn/BaseService/resourceCenter/rpc/resource"
  16. upb "bp.jydev.jianyu360.cn/BaseService/userCenter/rpc/pb"
  17. "bp.jydev.jianyu360.cn/BaseService/userCenter/rpc/usercenter"
  18. )
  19. const (
  20. appid = "10000"
  21. )
  22. var (
  23. etcdAddress []string
  24. BaseService *ml.Mysql
  25. Mgo *mongodb.MongodbSim
  26. JyOrder *ml.Mysql
  27. goodsCode string
  28. goodsSpecId int64
  29. all map[string]string
  30. powerType string
  31. middleground *Middleground
  32. allEntity = map[string]Entity{
  33. "yxy": &Yxy{},
  34. }
  35. c *Config
  36. )
  37. type Config struct {
  38. EtcdAddr []string
  39. Mongodb struct {
  40. Main *mgoConf
  41. }
  42. Mysql struct {
  43. Main *mysqlConf
  44. Base *mysqlConf
  45. }
  46. Products map[string]*Common
  47. }
  48. type mgoConf struct {
  49. Address string
  50. Size int
  51. DbName string
  52. ReplSet string
  53. UserName string
  54. Password string
  55. Collection string
  56. }
  57. type mysqlConf struct {
  58. DbName string
  59. Address string
  60. UserName string
  61. PassWord string
  62. MaxOpenConns int
  63. MaxIdleConns int
  64. }
  65. func init() {
  66. ReadConfig(&c)
  67. }
  68. func main() {
  69. allT := "yxy:医械云"
  70. for k, v := range c.Products {
  71. allEntity[k] = v
  72. allT += " " + k + ":" + v.Name
  73. }
  74. phone := flag.String("p", "", "手机号")
  75. m := flag.Int("m", 0, "1:查询权益 2:开通权益 3:取消权益")
  76. t := flag.String("t", "", allT)
  77. dayCount := flag.Int("c", 0, "自定义设置需要开通权益的天数,包含今天")
  78. entName := flag.String("n", "", "企业名称")
  79. isCheck := flag.Int("b", 1, "是否前置校验和后置处理")
  80. powerWay := flag.Int("a", 0, "权益开通/取消方式;0:一个身份 1:全部身份 2:仅仅企业上")
  81. flag.Parse()
  82. if *phone == "" {
  83. log.Fatalln("-p 参数无效")
  84. }
  85. entity := allEntity[*t]
  86. if entity == nil {
  87. log.Fatalln("-t 参数无效")
  88. }
  89. powerType, goodsCode, goodsSpecId, all = entity.init()
  90. middleground = NewMiddleground(c.EtcdAddr)
  91. middleground.RegResourceCenter("resource.rpc").RegUserCenter("usercenter.rpc")
  92. //
  93. BaseService = &ml.Mysql{
  94. Address: c.Mysql.Base.Address,
  95. UserName: c.Mysql.Base.UserName,
  96. PassWord: c.Mysql.Base.PassWord,
  97. DBName: c.Mysql.Base.DbName,
  98. MaxOpenConns: c.Mysql.Base.MaxOpenConns,
  99. MaxIdleConns: c.Mysql.Base.MaxIdleConns,
  100. }
  101. BaseService.Init()
  102. //
  103. JyOrder = &ml.Mysql{
  104. Address: c.Mysql.Main.Address,
  105. UserName: c.Mysql.Main.UserName,
  106. PassWord: c.Mysql.Main.PassWord,
  107. DBName: c.Mysql.Main.DbName,
  108. MaxOpenConns: c.Mysql.Main.MaxOpenConns,
  109. MaxIdleConns: c.Mysql.Main.MaxIdleConns,
  110. }
  111. JyOrder.Init()
  112. //
  113. Mgo = &mongodb.MongodbSim{
  114. MongodbAddr: c.Mongodb.Main.Address,
  115. Size: c.Mongodb.Main.Size,
  116. DbName: c.Mongodb.Main.DbName,
  117. ReplSet: c.Mongodb.Main.ReplSet,
  118. UserName: c.Mongodb.Main.UserName,
  119. Password: c.Mongodb.Main.Password,
  120. }
  121. Mgo.InitPool()
  122. //
  123. ur, _ := Mgo.Find("user", map[string]interface{}{
  124. "$or": []map[string]interface{}{
  125. map[string]interface{}{
  126. "s_phone": *phone,
  127. },
  128. map[string]interface{}{
  129. "s_m_phone": *phone,
  130. },
  131. },
  132. "i_appid": 2,
  133. }, nil, `{"base_user_id":1}`, false, -1, -1)
  134. if ur == nil || len(*ur) <= 0 {
  135. log.Fatalln("没有找到该用户!")
  136. }
  137. for _, v := range *ur {
  138. id := Int64All(v["base_user_id"])
  139. for _, identity := range middleground.UserCenter.IdentityList(id) {
  140. if *powerWay == 0 {
  141. if *entName == "" && identity.PositionType == 1 {
  142. continue
  143. } else if *entName != "" && (identity.PositionType == 0 || *entName != identity.Name) {
  144. continue
  145. }
  146. } else if *powerWay == 2 {
  147. if *entName == "" {
  148. continue
  149. } else if identity.PositionType == 0 || *entName != identity.Name {
  150. continue
  151. }
  152. }
  153. msg := "身份信息:" + fmt.Sprintf("%+v", identity) + " 手机号:" + *phone
  154. var c = resource.NewResource(middleground.ResourceCenter.NewClient())
  155. if *m == 1 {
  156. r, err := c.Haspowers(context.Background(), &pb.HaspowersReq{
  157. Appid: "10000",
  158. EntId: identity.EntId,
  159. EntUserId: identity.EntUserId,
  160. AccountId: identity.AccountId,
  161. EntAccountId: identity.EntAccountId,
  162. })
  163. if err != nil {
  164. log.Println(msg, "查询", powerType, "权益失败!", err)
  165. } else {
  166. mp := map[string]bool{}
  167. for _, v := range r.Powers {
  168. mp[v] = true
  169. }
  170. flag := true
  171. for k, v := range all {
  172. if !mp[v] {
  173. log.Println(msg, powerType, "权益异常,缺少权益:", k)
  174. flag = false
  175. continue
  176. }
  177. }
  178. if flag {
  179. for k, _ := range all {
  180. log.Println(msg, "拥有", powerType, "权益:", k)
  181. }
  182. }
  183. }
  184. } else if *m == 2 {
  185. if *isCheck == 1 && !entity.beforeOpen(phone, identity) {
  186. return
  187. }
  188. endTime := ""
  189. if *dayCount > 0 {
  190. now := time.Now()
  191. end_time := time.Date(now.Year(), now.Month(), now.Day(), 23, 59, 59, 0, time.Local)
  192. end_time = end_time.AddDate(0, 0, *dayCount-1)
  193. endTime = date.FormatDate(&end_time, date.Date_Full_Layout)
  194. }
  195. powerReq := &pb.PowerReq{
  196. Appid: appid,
  197. GoodsCode: goodsCode,
  198. GoodsSpecId: goodsSpecId,
  199. BuyNum: 1,
  200. Type: 1,
  201. EndTime: endTime,
  202. }
  203. if *powerWay == 2 {
  204. powerReq.EntAccountId = identity.EntAccountId
  205. powerReq.EntId = identity.EntId
  206. } else {
  207. powerReq.AccountId = identity.AccountId
  208. }
  209. r, err := c.PowerHandle(context.Background(), powerReq)
  210. if err != nil {
  211. log.Println(msg, powerType, "开通失败!", err)
  212. } else if r.Status == 1 {
  213. if *isCheck == 1 {
  214. entity.afterOpen(phone, identity)
  215. }
  216. log.Println(msg, powerType, "已开通!")
  217. } else {
  218. log.Println(msg, powerType, "开通失败!")
  219. }
  220. } else if *m == 3 {
  221. powerReq := &pb.PowerReq{
  222. Appid: appid,
  223. GoodsCode: goodsCode,
  224. GoodsSpecId: goodsSpecId,
  225. BuyNum: 1,
  226. Type: -1,
  227. }
  228. if *powerWay == 2 {
  229. powerReq.EntAccountId = identity.EntAccountId
  230. powerReq.EntId = identity.EntId
  231. } else {
  232. powerReq.AccountId = identity.AccountId
  233. }
  234. r, err := c.PowerHandle(context.Background(), powerReq)
  235. if err != nil {
  236. log.Println(msg, powerType, "取消失败!", err)
  237. } else if r.Status == 1 {
  238. log.Println(msg, powerType, "已取消!")
  239. } else {
  240. log.Println(msg, powerType, "取消失败!", r.Status)
  241. }
  242. } else {
  243. log.Fatalln("-m 参数无效")
  244. }
  245. if *m == 2 || *m == 3 {
  246. _, err := usercenter.NewUserCenter(middleground.UserCenter.NewClient()).WorkDesktopClearUserInfo(context.Background(), &upb.WorkDesktopClearUserInfoReq{
  247. PositionId: fmt.Sprint(identity.PositionId),
  248. AppId: appid,
  249. })
  250. if err != nil {
  251. log.Println("清除用户工作桌面缓存失败", err)
  252. }
  253. }
  254. }
  255. }
  256. }
  257. type Entity interface {
  258. init() (string, string, int64, map[string]string)
  259. beforeOpen(phone *string, identity *upb.Identity) bool
  260. afterOpen(phone *string, identity *upb.Identity)
  261. }
  262. type Common struct {
  263. Name string
  264. GoodsCode string
  265. GoodsSpecId int64
  266. All map[string]string
  267. }
  268. //
  269. func (c *Common) init() (string, string, int64, map[string]string) {
  270. return c.Name, c.GoodsCode, c.GoodsSpecId, c.All
  271. }
  272. //
  273. func (c *Common) beforeOpen(phone *string, identity *upb.Identity) bool {
  274. return true
  275. }
  276. //
  277. func (c *Common) afterOpen(phone *string, identity *upb.Identity) {
  278. }
  279. /******************************医械云******************************************/
  280. type Yxy struct {
  281. }
  282. //
  283. func (y *Yxy) init() (string, string, int64, map[string]string) {
  284. return "医械云权益", "lyh", 13, map[string]string{
  285. "医疗标讯搜索": "lyh_yl_ylbxss",
  286. "医疗机构搜索": "lyh_yl_yljgss",
  287. "经销商搜索": "lyh_yl_jxsss",
  288. "医疗机构画像": "lyh_yl_yljghx",
  289. "医疗机构认领": "lyh_yl_yljgrl",
  290. "经销商认领": "lyh_yl_jxsrl",
  291. "医疗订阅": "lyh_yl_yldy",
  292. }
  293. }
  294. //
  295. func (y *Yxy) beforeOpen(phone *string, identity *upb.Identity) bool {
  296. order_user_id, u := y.getUser(identity)
  297. if u == nil {
  298. return false
  299. }
  300. ok, _, _, _ := y.isOK(*phone, *u, order_user_id)
  301. return ok
  302. }
  303. //
  304. func (y *Yxy) getUser(identity *upb.Identity) (string, *map[string]interface{}) {
  305. if identity.PositionType == 0 {
  306. u, _ := Mgo.FindOneByField("user", map[string]interface{}{"base_user_id": identity.UserId}, `{"_id":1,"l_vip_endtime":1,"i_member_endtime":1,"s_member_mainid":1,"i_member_sub_status":1}`)
  307. if u == nil || len(*u) == 0 {
  308. log.Println(fmt.Sprintf("%+v", identity), "mongodb user 中没有找到该用户!")
  309. return "", nil
  310. }
  311. return mongodb.BsonIdToSId((*u)["_id"]), u
  312. } else {
  313. u, _ := Mgo.FindOneByField("ent_user", map[string]interface{}{"i_userid": identity.EntUserId}, `{"_id":1,"l_vip_endtime":1,"i_member_endtime":1,"s_member_mainid":1,"i_member_sub_status":1}`)
  314. if u == nil || len(*u) == 0 {
  315. log.Println(fmt.Sprintf("%+v", identity), "mongodb ent_user 中没有找到该用户!")
  316. return "", nil
  317. }
  318. return fmt.Sprint(identity.PositionId), u
  319. }
  320. }
  321. //
  322. func (y *Yxy) afterOpen(phone *string, identity *upb.Identity) {
  323. order_user_id, u := y.getUser(identity)
  324. if u == nil {
  325. return
  326. }
  327. ok, orderVip, vipRs, bigRs := y.isOK(*phone, *u, order_user_id)
  328. if ok {
  329. y.createYxtOrder(*phone, *u, orderVip, vipRs, bigRs)
  330. }
  331. }
  332. func (y *Yxy) isOK(phone string, user map[string]interface{}, order_user_id string) (bool, bool, *[]map[string]interface{}, *[]map[string]interface{}) {
  333. orderVip := true // 是否根据超级订阅订单处理 如果是大会员也是超级订阅则按大会员处理
  334. flag1 := false
  335. flag2 := false
  336. mainUserId := order_user_id
  337. if IntAllDef(user["i_member_sub_status"], -1) == 1 {
  338. mainUser, ok := Mgo.FindById("user", ObjToString(user["s_member_mainid"]), `{"s_phone"1:,"s_m_phone":1}`)
  339. if ok && mainUser != nil {
  340. mainUserId = mongodb.BsonIdToSId((*mainUser)["_id"])
  341. } else {
  342. log.Println("该用户是子账号,没有找到其主账号的信息")
  343. return false, false, nil, nil
  344. }
  345. }
  346. bigMemberRs := JyOrder.SelectBySql(`select * from dataexport_order where user_id=? and order_status=1 and product_type ="大会员" and (timestampdiff(day,vip_starttime,vip_endtime)>=365) order by create_time desc limit 1`, mainUserId)
  347. if bigMemberRs != nil && len(*bigMemberRs) == 1 {
  348. (*bigMemberRs)[0]["user_phone"] = phone
  349. (*bigMemberRs)[0]["user_id"] = order_user_id
  350. }
  351. vipRs := JyOrder.SelectBySql(`select * from dataexport_order where user_id=? and order_status=1 and product_type ="VIP订阅" and (timestampdiff(day,vip_starttime,vip_endtime)>=365) order by create_time desc limit 1`, order_user_id)
  352. if (bigMemberRs == nil || len(*bigMemberRs) == 0) && (vipRs == nil || len(*vipRs) == 0) {
  353. log.Println("没有查询到该用户的年度超级订阅或者大会员订单")
  354. return false, false, nil, nil
  355. }
  356. // 同时存在超级订阅和大会员年度订单 不再判断最晚到期时间 大会员优先
  357. if vipRs != nil && len(*vipRs) == 1 {
  358. vipEndTime := Int64All(user["l_vip_endtime"])
  359. leftdayvip := time.Unix(vipEndTime, 0).Sub(time.Now()).Hours() / 24
  360. if leftdayvip >= 90 {
  361. orderVip = true
  362. flag1 = true
  363. }
  364. }
  365. if *bigMemberRs != nil && len(*bigMemberRs) == 1 {
  366. // 判断最晚到期时间
  367. bigMemberEndTime := IntAll(user["i_member_endtime"])
  368. leftdaybig := time.Unix(int64(bigMemberEndTime), 0).Sub(time.Now()).Hours() / 24
  369. if leftdaybig >= 90 {
  370. orderVip = false
  371. flag2 = true
  372. }
  373. }
  374. if !flag1 && !flag2 {
  375. log.Println("该用户剩余不符合条件")
  376. return false, false, nil, nil
  377. }
  378. return true, orderVip, vipRs, bigMemberRs
  379. }
  380. // 生成医械通订单
  381. func (y *Yxy) createYxtOrder(phone string, user map[string]interface{}, orderVip bool, vipRs, bigMemberRs *[]map[string]interface{}) {
  382. var insertOrder map[string]interface{}
  383. filterMap := map[string]interface{}{}
  384. // 超级订阅
  385. if orderVip {
  386. insertOrder = (*vipRs)[0]
  387. // 生订单信息
  388. orderMoney := Float64All(insertOrder["order_money"])
  389. endTime := Int64All(user["l_vip_endtime"])
  390. var money int
  391. filterData := (*vipRs)[0]["filter"]
  392. err := json.Unmarshal([]byte(filterData.(string)), &filterMap)
  393. if err != nil {
  394. log.Println("反序列化失败", err)
  395. return
  396. }
  397. if IntAll(insertOrder["is_backstage_order"]) == 1 {
  398. cycle := Float64All(filterMap["cyclecount"])
  399. cycleUnit := Float64All(filterMap["cycleunit"])
  400. money = y.getPriceBack(orderMoney, time.Unix(endTime, 0), cycle, cycleUnit)
  401. } else {
  402. money = y.getPrice(orderMoney, time.Unix(endTime, 0))
  403. }
  404. insertOrder["order_money"] = money
  405. insertOrder["original_price"] = money
  406. insertOrder["vip_endtime"] = time.Unix(endTime, 0).Format(date.Date_Full_Layout)
  407. } else {
  408. // 大会员
  409. endTime := Int64All(user["i_member_endtime"])
  410. filterData := (*bigMemberRs)[0]["filter"]
  411. err := json.Unmarshal([]byte(filterData.(string)), &filterMap)
  412. if err != nil {
  413. log.Println("反序列化失败", err)
  414. return
  415. }
  416. filterMap["area"] = "-"
  417. insertOrder = (*bigMemberRs)[0]
  418. insertOrder["order_money"] = 0
  419. insertOrder["original_price"] = 0
  420. insertOrder["vip_endtime"] = time.Unix(endTime, 0).Format(date.Date_Full_Layout)
  421. }
  422. filterMap["source"] = "qmx" // 后台订单
  423. // 生订单信息
  424. filter, _ := json.Marshal(filterMap)
  425. insertOrder["filter"] = string(filter)
  426. insertOrder["is_backstage_order"] = 1 // 后台创建
  427. insertOrder["product_type"] = "医械通"
  428. insertOrder["order_code"] = fmt.Sprintf("%s%s", time.Now().Format("150405"), GetRandom(6))
  429. insertOrder["prepay_id"] = ""
  430. insertOrder["pay_money"] = 0
  431. insertOrder["discount_price"] = 0
  432. insertOrder["pay_way"] = ""
  433. insertOrder["out_trade_no"] = ""
  434. insertOrder["create_time"] = date.NowFormat(date.Date_Full_Layout)
  435. insertOrder["vip_starttime"] = date.NowFormat(date.Date_Full_Layout)
  436. insertOrder["pay_time"] = insertOrder["vip_starttime"]
  437. insertOrder["prepay_time"] = insertOrder["vip_starttime"]
  438. delete(insertOrder, "id")
  439. saveRs := JyOrder.Insert("dataexport_order", insertOrder)
  440. if saveRs > 0 {
  441. log.Println("医械通订单保存成功")
  442. } else {
  443. log.Println("医械通订单保存失败", saveRs)
  444. }
  445. }
  446. // 计算价格 线上的
  447. func (y *Yxy) getPrice(orderMoney float64, endTime time.Time) int {
  448. // 计算价格
  449. dis := endTime.Sub(time.Now())
  450. days := dis.Hours() / 24 // 剩余天数
  451. money := int(orderMoney / 360 * float64(int(days)))
  452. return money
  453. }
  454. // 计算价格 管理后台创建的
  455. func (y *Yxy) getPriceBack(orderMoney float64, endTime time.Time, cycle, cycleUnit float64) int {
  456. //(1:年 2:月 3:天 4:季)
  457. // 计算价格
  458. unitPrice := 0.0
  459. switch cycleUnit {
  460. case 1:
  461. unitPrice = orderMoney / cycle / 360
  462. case 2:
  463. unitPrice = orderMoney / cycle / 30
  464. case 3:
  465. unitPrice = orderMoney / cycle
  466. case 4:
  467. unitPrice = orderMoney / cycle / 90
  468. }
  469. dis := endTime.Sub(time.Now())
  470. days := dis.Hours() / 24 // 剩余天数
  471. //log.Println("=========", int(days), "=================")
  472. money := unitPrice * float64(int(days))
  473. return int(money)
  474. }