get_order_history_data.py 2.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354
  1. ## 上一个月核对,补数据脚本
  2. import get_order_dairly_yangguang
  3. import get_order_dairly_wending
  4. from util import platform_order_api_util
  5. from util import platform_config_util
  6. from util import date_util
  7. from util import db_order_util
  8. from util import platform_config_util
  9. def get_order_job(st_unix,et_unix):
  10. print('查询开始时间:', st_unix, date_util.getSecondsToDatetime(st_unix))
  11. print('查询结束时间:', et_unix, date_util.getSecondsToDatetime(et_unix))
  12. ##
  13. '''
  14. ## 直接读取所有账号
  15. account_list_yuewen = platform_config_util.get_yuewen_account_list()
  16. account_list_zhangzhongyun = platform_config_util.get_zhangzhongyun_account_list()
  17. account_list_huasheng = platform_config_util.get_huasheng_account_list()
  18. account_list_youshuge = platform_config_util.get_youshuge_account_list()
  19. account_list_zhangdu = platform_config_util.get_zhangdu_account_list()
  20. account_list_wending = platform_config_util.get_wending_account_list()
  21. account_list_yangguang = get_yangguang_account_list()
  22. '''
  23. ## 数据缺失账户读取
  24. account_list_yuewen = platform_config_util.get_account_list('阅文', 'new_account/new_yuewen.csv')
  25. account_list_zhangzhongyun = platform_config_util.get_account_list('掌中云', 'new_account/new_zhangzhongyun.csv')
  26. account_list_huasheng = platform_config_util.get_account_list('花生', 'new_account/new_huasheng.csv')
  27. account_list_youshuge = platform_config_util.get_account_list('悠书阁', 'new_account/new_youshuge.csv')
  28. account_list_zhangdu = platform_config_util.get_account_list('掌读', 'new_account/new_zhangdu.csv')
  29. account_list_wending = platform_config_util.get_account_list('文鼎', 'new_account/new_wending.csv')
  30. account_list_yangguang = platform_config_util.get_account_list('阳光', 'new_account/new_yangguang.csv')
  31. db_order_util.batch_save_order(platform_order_api_util.get_zhangzhongyun_order(st_unix, et_unix,account_list_zhangzhongyun))
  32. db_order_util.batch_save_order(platform_order_api_util.get_yuewen_order(st_unix, et_unix,account_list_yuewen))
  33. db_order_util.batch_save_order(platform_order_api_util.get_huasheng_order(st_unix, et_unix,account_list_huasheng))
  34. db_order_util.batch_save_order(platform_order_api_util.get_youshuge_order(st_unix, et_unix,account_list_youshuge))
  35. db_order_util.batch_save_order(platform_order_api_util.get_zhangdu_order(st_unix, et_unix,account_list_zhangdu))
  36. db_order_util.batch_save_order(get_order_dairly_wending.get_wending_order(st_unix, et_unix,account_list_wending))
  37. db_order_util.batch_save_order(get_order_dairly_yangguang.get_yangguang_order(st_unix, et_unix,account_list_yangguang))
  38. if __name__ == "__main__":
  39. st_unix = 1604505600 # 2020/11/05 00:0:0
  40. et_unix = 1604937600 # 2020/11/10 00:0:0
  41. get_order_job(st_unix,et_unix)