def yjf_update():
yjf_data_report_id=request.args.get('yjf_data_report_id')
value=request.args.get('value')
type=request.args.get('type')
rp=mr.myreport(yjf_data_report_id=yjf_data_report_id,value=value,update_type=type)
rp.yjf_update()
return jsonify({"code":"200"})
def reportZoneTrend():
myform=ft.myreportZoneTrend()
if myform.validate_on_submit():
begintime=str(myform.data['begindate'])[0:10]
endtime=str(myform.data['enddate'])[0:10]
rp=mr.myreport(begintime=begintime,endtime=endtime)
data,filed,tmpsql,colspanx,dataSum=rp.getreportZoneTrend()
return render_template('reportZoneTrend.html',form=myform,data=data,filed=filed,tmpsql=tmpsql,colspanx=colspanx,dataSum=dataSum)
return render_template('reportZoneTrend.html',form=myform)
def repotptmaoli():
myform=ft.myreportall()
if myform.validate_on_submit():
begintime=str(myform.data['begindate'])[0:10]
endtime=str(myform.data['enddate'])[0:10]
rp=mr.myreport(begintime=begintime,endtime=endtime)
data,filed,tmpsql,datasum=rp.getptmaoli()
return render_template('repotptmaoli.html',form=myform,data=data,filed=filed,tmpsql=tmpsql,datasum=datasum)
data=[]
return render_template('repotptmaoli.html',data=data,form=myform)
def repotadvliandong():
myform=ft.myreportall()
if myform.validate_on_submit():
begintime=str(myform.data['begindate'])[0:10]
endtime=str(myform.data['enddate'])[0:10]
rp=mr.myreport(begintime=begintime,endtime=endtime)
data,filed,tmpsql,headtr=rp.getadvliandong()
return render_template('reportliandong.html',form=myform,data=data,filed=filed,tmpsql=tmpsql,headtr=headtr)
data=[]
return render_template('reportliandong.html',data=data,form=myform)
def reportOrderState():
myform=ft.myreportOrderState()
if myform.validate_on_submit():
begintime=str(myform.data['begindate'])[0:10]
adzoneid=str(myform.data['adzoneid'])
isstatus=str(myform.data['isstatus'])
rp=mr.myreport(begintime=begintime,adzoneids=adzoneid,isstatus=isstatus)
data,filed,tmpsql=rp.getreportOrderState()
return render_template('reportOrderState.html',form=myform,data=data,filed=filed,tmpsql=tmpsql)
return render_template('reportOrderState.html',form=myform)
def repotyijifenall():
myform=ft.myreportyijifen()
if myform.validate_on_submit():
begintime=str(myform.data['begindate'])[0:10]
endtime=str(myform.data['enddate'])[0:10]
type=str(myform.data['type'])[0:10]
rp=mr.myreport(begintime=begintime,endtime=endtime,type=type)
data,filed,tmpsql,headtr=rp.getyijifenall()
return render_template('reportyjfall.html',form=myform,data=data,filed=filed,tmpsql=tmpsql,headtr=headtr)
data=[]
return render_template('reportyjfall.html',data=data,form=myform)
def reporregionbyadv():
myform=ft.myreporregionbyadv()
if myform.validate_on_submit():
begintime=str(myform.data['begindate'])[0:10]
endtime=str(myform.data['enddate'])[0:10]
adzoneid=str(myform.data['adzoneid'])
region=str(myform.data['region'])
rp=mr.myreport(begintime=begintime,endtime=endtime,adzoneids=adzoneid,region=region)
data,filed,tmpsql,colspanx=rp.getregionbyadv()
return render_template('reporregionbyadv.html',form=myform,data=data,filed=filed,tmpsql=tmpsql,colspanx=colspanx)
return render_template('reporregionbyadv.html',form=myform)
def reportByadvtag():
myform=ft.myreportByadvtag()
if myform.validate_on_submit():
begintime=str(myform.data['begindate'])[0:10]
endtime=str(myform.data['enddate'])[0:10]
adzoneid=str(myform.data['adzoneid'])
rp=mr.myreport(begintime=begintime,endtime=endtime,adzoneids=adzoneid)
data,filed,tmpsql=rp.getreportByadvtag()
return render_template('reportByadvtag.html',form=myform,data=data,filed=filed,tmpsql=tmpsql)
data=[]
return render_template('reportByadvtag.html',data=data,form=myform)
def reportAdzoneActEffect():
myform=ft.myreportAdzoneActEffect()
if myform.validate_on_submit():
begintime=str(myform.data['begindate'])[0:10]
endtime=str(myform.data['enddate'])[0:10]
adzoneid=str(myform.data['adzoneid'])
advertiser=str(myform.data['advertiser'])
act=str(myform.data['act'])
rp=mr.myreport(begintime=begintime,endtime=endtime,adzoneids=adzoneid,advertiser_id=advertiser,actid=act)
data,filed,tmpsql,colspanx,datasum=rp.getreportAdzoneActEffect()
return render_template('reportAdzoneActEffect.html',form=myform,data=data,filed=filed,tmpsql=tmpsql,colspanx=colspanx,datasum=datasum)
return render_template('reportAdzoneActEffect.html',form=myform)
def reportPreProfitbyDay():
myform=ft.myreportPreProfitbyDay()
if myform.validate_on_submit():
begintime=str(myform.data['begindate'])[0:10]
endtime=str(myform.data['enddate'])[0:10]
if myform.data['showbaidu']:
showbaidu='1'
else:
showbaidu='0'
rp=mr.myreport(begintime=begintime,endtime=endtime,showbaidu=showbaidu)
data,filed,tmpsql=rp.getreportPreProfitbyDay()
return render_template('reportPreProfitbyDay.html',form=myform,data=data,filed=filed,tmpsql=tmpsql)
return render_template('reportPreProfitbyDay.html',form=myform)
def reportall():
myform=ft.myreportall()
if myform.validate_on_submit():
begintime=str(myform.data['begindate'])[0:10]
endtime=str(myform.data['enddate'])[0:10]
searchword=str(myform.data['searchword'])
# data=adzone.getadzoneinfo(mytype=type,begintime=begintime,endtime=endtime,adzoneid=adzone_id)
# rp=mr.myreport(begintime='2020-04-17',endtime='2020-04-17')
rp=mr.myreport(begintime=begintime,endtime=endtime,searchword=searchword)
data,filed,tmpsql,headtr,datasum=rp.getallreport()
return render_template('reportall.html',form=myform,data=data,filed=filed,tmpsql=tmpsql,headtr=headtr,datasum=datasum)
data=[]
return render_template('reportall.html',data=data,form=myform)
def reportptmaoliadtag():
myform=ft.myreportptmaoliadtag()
if myform.validate_on_submit():
begintime=str(myform.data['begindate'])[0:10]
endtime=str(myform.data['enddate'])[0:10]
adzoneid=str(myform.data['adzoneid'])
advertiser=str(myform.data['advertiser'])
tagorad=str(myform.data['tagorad'])
if myform.data['showadzone']:
showadzone='1'
else:
showadzone='0'
rp=mr.myreport(begintime=begintime,endtime=endtime,adzoneids=adzoneid,advertiser_id=advertiser,tagorad=tagorad,showadzone=showadzone)
data,filed,tmpsql,colspanx,datasum=rp.getreportptmaoliadtag()
return render_template('reportptmaoliadtag.html',form=myform,data=data,filed=filed,tmpsql=tmpsql,colspanx=colspanx,datasum=datasum)
return render_template('reportptmaoliadtag.html',form=myform)
def reportmtpingguhour():
myform=ft.myreporpingguhour()
addfieldnum=0
if request.args.get('begindate') and request.args.get('enddate'):
adzoneid=request.args.get('adzoneid')
begindate=request.args.get('begindate')
enddate=request.args.get('enddate')
myform.adzoneid.data=adzoneid
myform.begindate.data=begindate
myform.enddate.data=enddate
if myform.validate_on_submit():
begintime=str(myform.data['begindate'])[0:10]
endtime=str(myform.data['enddate'])[0:10]
adzoneid=str(myform.data['adzoneid'])
advertiser=str(myform.data['advertiser'])
if advertiser :
addfieldnum=2
else:
addfieldnum=0
rp=mr.myreport(begintime=begintime,endtime=endtime,adzoneids=adzoneid,advertiser_id=advertiser)
data,filed,tmpsql,datasum=rp.getmtpinguhour()
return render_template('reportmtpingguhour.html',form=myform,data=data,filed=filed,tmpsql=tmpsql,datasum=datasum,advertiser=advertiser,addfieldnum=addfieldnum)
return render_template('reportmtpingguhour.html',form=myform)