反向同步

   --查看最近订单中间表数据
   select a.inserttime,b.upload,b.mycompanyid,b.mycompanyname, 
   c.upload,c.hisgroupcode,c.hisgroupname,c.mealid,c.groupid,a.*
 from 
 tbl_inv_group_person a left join tbl_inv_company b on a.hiscompanycode = b.hiscompanycode 
 left join tbl_inv_meal c on a.hisgroupcode = c.hisgroupcode
 --  left join tbl_errorlog d on c.hisgroupcode = d.relatedid
 where 1=1 
 and a.upload = 0
 order by a.inserttime desc
--查看最近订单视图
select * from tbl_inv_group_person_v  where 1=1
 and hisexamineenum ='2311290113' 
 and  modifydate >'20231127'
 order by modifydate desc
--查看单位表
select * from tbl_inv_company where =1=1 
and hiscompanycode ='1839'
--查看套餐视图
select * from TBL_INV_MEAL_v where 1=1
and hiscompanycode ='1839'
--查看套餐项目视图
select   a.RWFZID as hisGroupCode,  a.SQXMID as hisItemId,  1 as basicfrom HM_YW_TTFZXM a,hm_zd_tjsqxm b 
where a.sqxmid=b.sqxmid  and a.RWFZID ='4448'
-- 查看套餐中间表
select * from TBL_INV_MEAL where 1=1
and hiscompanycode ='1839'
and hisGroupCode ='4445'
--删除中间表订单
--    delete from tbl_inv_group_person where hisexamineenum ='2311290113'