处理历史数据

同步所有单位

--团体任务【新增】
   insert into TBL_HANDLELOG(BUSCODE, KEYID, HANDLETYPE, STATUS, MEMO,CREATEDATE)
        select 'COMPANYADD', RWID00,2,0,'团体任务【新增】',(select sysdate from dual) from HM_YW_TTRW00;

同步所有单位分组，同步到现场变成单位套餐

--任务分组【新增】
insert into TBL_HANDLELOG(BUSCODE, KEYID, HANDLETYPE, STATUS, MEMO,CREATEDATE)
        select 'MEALCHANGE', RWFZID,2,0,'任务分组【新增】',(select sysdate from dual) from HM_YW_TTRWFZ where rwid00='1282';

同步订单

--订单
insert into TX_JK.TBL_HANDLELOG(BUSCODE, KEYID, HANDLETYPE, STATUS, MEMO,CREATEDATE)
                select 'GROUPPERSON',TJH000,2,0,'备单任务,订单状态'||YDJ000||'【修改】',(select sysdate from dual) from HM_YW_TJZ000 where rwid00='1607'