def read_from_db(self,subwhere=None):
today=self.date
timespan=timedelta(days=1)
today_date=datetime.strptime(today, "%Y-%m-%d")
today_pre=(today_date-timespan).strftime("%Y-%m-%d")
print today
sqlres=DB_G.query("select sum(total_num) as num from ad_stats.ad_daily_report where sta_date>='%s' and sta_date<'%s' and ad_status=14 and campaign_id<1000000" % (today_pre,today))
qres=sqlres[0]
m_ins=int(CUtils.none2zero(qres['num']))
sqlres=DB_G.query("select sum(total_num) as num from ad_stats.ad_daily_report where sta_date>='%s' and sta_date<'%s' and ad_status=14" % (today_pre,today))
qres=sqlres[0]
t_ins=int(CUtils.none2zero(qres['num']))
sqlres=DB3_G.query("select count(DISTINCT(guid)) as num,sum(bid) as rev from adex_postback_partner where create_time>'%s' and create_time<'%s'" % (today_pre,today))
qres=sqlres[0]
t_cov=int(CUtils.none2zero(qres['num']))
t_rev=CUtils.none2zero(qres['rev'])
sqlres=DB3_G.query("select count(DISTINCT(guid)) as num,sum(bid) as rev from adex_postback_partner where create_time>'%s' and create_time<'%s' and campaign_id<1000000" % (today_pre,today))
qres=sqlres[0]
m_cov=int(CUtils.none2zero(qres['num']))
m_rev=CUtils.none2zero(qres['rev'])
sqlres=DB3_G.query("select count(DISTINCT(guid)) as num,sum(bid) as rev from adex_postback_partner where create_time>'%s' and create_time<'%s' and source_type=1" % (today_pre,today))
qres=sqlres[0]
r_cov=int(CUtils.none2zero(qres['num']))
r_rev=CUtils.none2zero(qres['rev'])
m_cov_r=CUtils.rate_it(m_cov,m_ins)
a_cov_r=CUtils.rate_it(t_cov-m_cov,t_ins-m_ins)
revenue_report={"t_rev":t_rev,"a_rev":t_rev-m_rev,"m_rev":m_rev,"r_rev":r_rev,"t_cov":t_cov,"a_cov":t_cov-m_cov,"m_cov":m_cov,"r_cov":r_cov,"m_cov_r":m_cov_r,"a_cov_r":a_cov_r,"t_ins":t_ins,"a_ins":t_ins-m_ins,"m_ins":m_ins}
return revenue_report
