data_stat_run.py 1.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263
  1. from model.DateUtils import DateUtils
  2. import logging
  3. from model.DingTalkUtils import DingTalkUtils
  4. from data_stat_task import *
  5. from sync_to_ck_task import *
  6. from app.etl.dm.dm_pitcher_daily_overview import dm_pitcher_daily_overview
  7. from app.etl.dw.dw_channel_daily import dw_channel_daily
  8. from app.etl.dw.dw_pitcher_daily import dw_pitcher_trend
  9. from app.etl.src.src_book_info import src_book_info
  10. from app.etl.dw.dw_book_trend import book_trend
  11. from app.etl.src import book_annual_expect_profit
  12. du = DateUtils()
  13. logger = logging.getLogger("")
  14. # logger.setLevel(logging.ERROR)
  15. logging.getLogger().setLevel(logging.WARNING)
  16. def do_order(st,et):
  17. for i in du.getDateLists(st,et):
  18. print(i)
  19. ods_order(i)
  20. order_sync_ck(i)
  21. def do_cost(st,et):
  22. for i in du.getDateLists(st,et):
  23. print(i)
  24. channel_by_account_daily(i)
  25. channel_info_daily(i)
  26. dw_daily_channel_cost(i)
  27. def main(st,et):
  28. try:
  29. do_order(st,et)
  30. do_cost(st,et)
  31. src_book_info() # 书籍卡点信息
  32. # book_annual_expect_profit.run() # 年预期收益
  33. dw_channel_daily()
  34. dw_pitcher_trend()
  35. book_trend()
  36. dm_pitcher_daily_overview()
  37. except Exception as e:
  38. print(e)
  39. DingTalkUtils.send("hourlyRun fail!! "+str(e),'18860455786')
  40. def hourly():
  41. thedate=du.getTodayOrYestoday()
  42. main(thedate, thedate)
  43. def daily():
  44. "往前跑10天"
  45. st=du.get_n_days(-10)
  46. et=du.get_n_days(-1)
  47. do_order(st, et)
  48. do_cost(st, et)
  49. if __name__ == '__main__':
  50. hourly()
  51. # do_cost('2021-02-10','2021-02-10')
  52. # do_order('2021-04-16','2021-04-17')