修改上报时间

日报

select * from g_sycompany where sycompname like '%南昌%'

select * from o_dailyreport where report_date = '2111-01-01' and sycompany_id in (99999)

把2111-01-01公司id为99999的日报上报时间提前1小时

上报时间晚于次日9时算 迟报

update o_dailyreport

set inputtime=inputtime - 1 hours --把上报时间提前1小时

where

report_date = '2111-01-01'--上报日期

and sycompany_id in (99999)--公司id

旬报

--select * from info_report_master where year=2011 and month=4 and channelid=61 and areacode in ('1','1640') and day=21

update info_report_master set inputdate=inputdate- 1 days where year=2011 and month=4 and channelid=61 and areacode in ('1','1640') and day=21

旬运行分析

--select * from info_report_master where year=2011 and month=4 and channelid=181 and day=21 and areacode in ('110000')

update info_report_master set inputdate=inputdate- 1 days where year=2011 and month=4 and channelid=181 and day=21 and areacode in ('110000')

月运行分析

--select * from info_report_master where year=2011 and month=4 and channelid=42  and areacode in ('110000') --and day=21

update info_report_master set inputdate=inputdate- 1 days where year=2011 and month=4 and channelid=42  and areacode in ('110000') --and day=21

佛光周结

--select * from info_report_master where  channelid=341 and year=2011 and month=5 and areatype=3 and areacode in ('27','28')

update info_report_master set inputdate=inputdate-1 days where  channelid=341 and year=2011 and month=5 and areatype=3 and areacode in ('27','28')

佛光月结

--select * from info_report_master where  channelid=342 and year=2011 and month=4 and personid=242--and areatype=3 and areacode in ('27','28')

update info_report_master set inputdate=inputdate-1 days where  channelid=342 and year=2011 and month=4 and personid=242--and areatype=3 and areacode in ('27','28')

--月报

--select * from R_MONTHREPORTLOG where personid=242(或者用公司company_id=) and report_month='201104'

update R_MONTHREPORTLOG set report_time=report_time -1 days where personid=242 and report_month='201104'