data_stat_run.py 1.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051
  1. from model.DateUtils import DateUtils
  2. from model.log import logger
  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.dm.dm_channel_summary import dm_channel_summary
  8. from app.etl.dw.dw_channel_daily import dw_daily_channel
  9. from app.etl.dw.dw_pitcher_daily import dw_pitcher_daily
  10. log=logger()
  11. du = DateUtils()
  12. import sys
  13. def do_order(st,et):
  14. for i in du.getDateLists(st,et):
  15. ods_order(i)
  16. order_sync_ck(i)
  17. def do_cost(st,et):
  18. for i in du.getDateLists(st,et):
  19. channel_by_account_daily(i)
  20. channel_info_daily(i)
  21. dw_daily_channel_cost(i)
  22. dw_order_channel_cost_sync_ck(i)
  23. dw_channel_daily_total(i)
  24. def main(st,et):
  25. do_order(st,et)
  26. do_cost(st,et)
  27. dw_daily_channel()
  28. dw_pitcher_daily()
  29. dm_pitcher_daily_overview()
  30. dm_channel_summary()
  31. def hourly():
  32. thedate=du.getTodayOrYestoday()
  33. main(thedate, thedate)
  34. def daily():
  35. dt=du.get_n_days(-1)
  36. main(dt, dt)