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

db=MysqlUtils()
du=DateUtils()


def cost_data(dt=du.get_n_days(-1)):
    sql="select count(1) from `ods_order` where date='{}'".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))


def order_data():
    sql = f"select platform,count(1) n from ods_order where date='{du.get_n_days(-1)}' group by platform order by n desc"
    data = db.quchen_text.getData(sql)
    # print(data)
    info = ""
    for i in data:
        info += f"{i[0]}: {i[1]}\n"

    # print(info)
    DingTalkUtils().send(info)




if __name__ == '__main__':
    cost_data()
    order_data()