get_order.py 6.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212
  1. from app.api_data.platform_order.order_util import *
  2. from model.DataBaseUtils import MysqlUtils
  3. from concurrent.futures import ThreadPoolExecutor
  4. from model.DingTalkUtils import DingTalkDecorators
  5. from app.api_data.platform_order.audio_qiyue import AudioQiyue
  6. from app.api_data.platform_order.youshuge import get_youshuge_order_task
  7. from app.api_data.platform_order.yuewen import get_yuewen_order_task
  8. from app.api_data.platform_order.yuewen_fast_app import get_yuewen_fast_app_order_task
  9. from app.api_data.platform_order.yangguang import yangguang
  10. from app.api_data.platform_order.QiYue import get_qiyue_order_task
  11. import logging
  12. db = MysqlUtils()
  13. def get_new_account(plactform):
  14. data = db.quchen_text.getData(
  15. f"select text from order_account_text where platform='{plactform}' and create_time>='{du.get_n_days(-1)}'")
  16. new_data = []
  17. for i in data:
  18. new_data.append(i[0].replace('\n', '').split(","))
  19. return new_data
  20. @DingTalkDecorators("花生")
  21. def huasheng(start=None, end=None):
  22. logging.info('花生订单数据拉取,开始')
  23. if start is None:
  24. start = end = du.getNow()
  25. accounts = get_account("花生")
  26. if len(accounts) == 0:
  27. return
  28. else:
  29. logging.info(f'花生有账号{len(accounts)}个')
  30. # 花生有请求限制 不用多线程
  31. for account in accounts:
  32. get_hs_order_task(start, end, account)
  33. logging.info('花生订单数据拉取,结束')
  34. @DingTalkDecorators("七悦")
  35. def qiyue(start=None, end=None, new=None):
  36. logging.info('七悦订单数据拉取,开始')
  37. if start is None:
  38. start = end = du.getNow()
  39. accounts = get_account("七悦")
  40. if len(accounts) == 0:
  41. return
  42. else:
  43. logging.info(f'七悦有账号{len(accounts)}个')
  44. for account in accounts:
  45. get_qiyue_order_task(start, end, account)
  46. logging.info('七悦订单数据拉取,结束')
  47. @DingTalkDecorators("文鼎")
  48. def wending(start=None, end=None, new=None):
  49. logging.info('文鼎订单数据拉取,开始')
  50. if start is None:
  51. start = end = du.getNow()
  52. accounts = get_account("文鼎") if new is None else get_new_account('文鼎')
  53. if len(accounts) == 0:
  54. return
  55. else:
  56. logging.info(f'文鼎有账号{len(accounts)}个')
  57. for account in accounts:
  58. get_wd_order_task(start, end, account)
  59. logging.info('文鼎订单数据拉取,结束')
  60. @DingTalkDecorators("国风")
  61. def guofeng(start=None, end=None, new=None):
  62. if start:
  63. start = start if start > '2021-07-09' else '2021-07-09'
  64. logging.info('国风订单数据拉取,开始')
  65. if start is None:
  66. start = end = du.getNow()
  67. accounts = get_account("国风") if new is None else get_new_account('国风')
  68. if len(accounts) == 0:
  69. return
  70. else:
  71. logging.info(f'国风有账号{len(accounts)}个')
  72. for account in accounts:
  73. get_gf_order_task(start, end, account)
  74. logging.info('国风订单数据拉取,结束')
  75. @DingTalkDecorators("掌读")
  76. def zhangdu(start=None, end=None, new=None):
  77. logging.info('掌读订单数据拉取,开始')
  78. if start is None:
  79. start = end = du.getNow()
  80. accounts = get_account("掌读")
  81. if len(accounts) == 0:
  82. return
  83. else:
  84. logging.info(f'掌读有账号{len(accounts)}个')
  85. for account in accounts:
  86. get_zd_order_task(start, end, account)
  87. logging.info('掌读订单数据拉取,结束')
  88. @DingTalkDecorators("掌中云")
  89. def zhangzhongyun(start=None, end=None, new=None):
  90. logging.info('掌中云订单数据拉取,开始')
  91. if start is None:
  92. start = du.getNow()
  93. end = du.get_n_days(1)
  94. executor = ThreadPoolExecutor(max_workers=5)
  95. accounts = get_account("掌中云")
  96. if len(accounts) == 0:
  97. return
  98. else:
  99. logging.info(f'掌中云有账号{len(accounts)}个')
  100. for account in accounts:
  101. executor.submit(
  102. get_zzy_order_task, start, end, account)
  103. executor.shutdown()
  104. logging.info('掌中云订单数据拉取,结束')
  105. @DingTalkDecorators("阅文")
  106. def yueweng(start=None, end=None):
  107. logging.info('阅文订单数据拉取,开始')
  108. if start is None:
  109. start = end = du.getNow()
  110. executor = ThreadPoolExecutor(max_workers=5)
  111. accounts = get_account("阅文")
  112. if len(accounts) == 0:
  113. return
  114. else:
  115. logging.info(f'阅文有账号{len(accounts)}个')
  116. for account in accounts:
  117. executor.submit(get_yuewen_order_task, start, end, account)
  118. executor.shutdown()
  119. logging.info('阅文订单数据拉取,结束')
  120. @DingTalkDecorators("阅文快应用")
  121. def yueweng_fastapp(start=None, end=None):
  122. logging.info('阅文快应用订单数据拉取,开始')
  123. if start is None:
  124. start = end = du.getNow()
  125. executor = ThreadPoolExecutor(max_workers=5)
  126. accounts = get_account("阅文快应用")
  127. if len(accounts) == 0:
  128. return
  129. else:
  130. logging.info(f'阅文快应用有账号{len(accounts)}个')
  131. for account in accounts:
  132. executor.submit(get_yuewen_fast_app_order_task, start, end, account)
  133. executor.shutdown()
  134. logging.info('阅文快应用订单数据拉取,结束')
  135. @DingTalkDecorators("七悦有声")
  136. def qiyueyousheng(start=None, end=None):
  137. logging.info('七悦有声订单数据拉取,开始')
  138. if start is None:
  139. start = end = du.getNow()
  140. accounts = get_account("七悦有声")
  141. if len(accounts) == 0:
  142. return
  143. else:
  144. logging.info(f'七悦有声有账号{len(accounts)}个')
  145. for account in accounts:
  146. AudioQiyue().get_order(start, end, account)
  147. logging.info('七悦有声订单数据拉取,结束')
  148. @DingTalkDecorators("悠书阁")
  149. def youshuge(start=None, end=None):
  150. logging.info('悠书阁订单数据拉取,开始')
  151. if start is None:
  152. start = end = du.getNow()
  153. executor = ThreadPoolExecutor(max_workers=5)
  154. accounts = get_account("悠书阁")
  155. if len(accounts) == 0:
  156. return
  157. else:
  158. logging.info(f'悠书阁有账号{len(accounts)}个')
  159. for account in accounts:
  160. executor.submit(get_youshuge_order_task, start, end, account)
  161. executor.shutdown()
  162. logging.info('悠书阁订单数据拉取,结束')
  163. def yestoday():
  164. st = et = du.get_n_days(-1)
  165. huasheng(st, et)
  166. qiyue(st, et)
  167. qiyueyousheng(st, et)
  168. wending(st, et)
  169. zhangdu(st, et)
  170. zhangzhongyun(st, et)
  171. yueweng(st, et)
  172. youshuge(st, et)
  173. yangguang(st, et)
  174. if __name__ == '__main__':
  175. # zhangzhongyun()
  176. # yangguang()
  177. # huasheng("2021-04-12",'2021-05-10')
  178. yueweng(du.get_n_days(-3), du.get_n_days(0))
  179. # qiyue('2020-11-01', '2021-06-03')