from model.DataBaseUtils import MysqlUtils
from model.DateUtils import DateUtils
from model.DingTalkUtils import DingTalkUtils

db=MysqlUtils()
dt=DateUtils()


def run(dt):
    sql="select count(1) from `order` where date=UNIX_TIMESTAMP('{}')".format(dt)
    sql2="select count(1) from daily_qq where date='{} 00:00:00' ".format(dt)
    sql3="select count(1) from daily_vx where date='{} 00:00:00' ".format(dt)
    sql4="select count(1) from daily_vx_campaign where date='{} 00:00:00' ".format(dt)



    a = db.quchen_text.getOne(sql)
    b = db.quchen_text.getOne(sql2)
    c = db.quchen_text.getOne(sql3)
    d = db.quchen_text.getOne(sql4)
    DingTalkUtils.send("[{}]\norder: {}\ndaily_qq: {}\ndaily_vx: {}\ndaily_vx_campaign: {}".format(dt,a,b,c,d))


if __name__ == '__main__':
    run(dt.get_n_days(-1))