--上传接口监控
SELECT 'v_erp_gjtc_his' AS tbname, COUNT(*) as num FROM v_erp_gjtc_his UNION ALL
SELECT 'v_erp_psck' AS tbname, COUNT(*) as num FROM v_erp_psck UNION ALL
SELECT 'v_erp_psck_his' AS tbname, COUNT(*) as num FROM v_erp_psck_his UNION ALL
SELECT 'v_erp_qcrk' AS tbname, COUNT(*) as num FROM v_erp_qcrk UNION ALL
SELECT 'v_erp_qcrk_his' AS tbname, COUNT(*) as num FROM v_erp_qcrk_his UNION ALL
SELECT 'v_erp_xsck' AS tbname, COUNT(*) as num FROM v_erp_xsck UNION ALL
SELECT 'v_erp_cgdd' AS tbname, COUNT(*) as num FROM v_erp_cgdd UNION ALL
SELECT 'v_erp_xsck_his' AS tbname, COUNT(*) as num FROM v_erp_xsck_his UNION ALL
SELECT 'v_erp_cgdd_his' AS tbname, COUNT(*) as num FROM v_erp_cgdd_his UNION ALL
SELECT 'v_erp_xsth' AS tbname, COUNT(*) as num FROM v_erp_xsth UNION ALL
SELECT 'V_ERP_DGRK' AS tbname, COUNT(*) as num FROM V_ERP_DGRK UNION ALL
SELECT 'V_ERP_DGRK_HIS' AS tbname, COUNT(*) as num FROM V_ERP_DGRK_HIS UNION ALL
SELECT 'v_erp_gjtc' AS tbname, COUNT(*) as num FROM v_erp_gjtc UNION ALL
SELECT 'v_erp_xsth_his' AS tbname, COUNT(*) as num FROM v_erp_xsth_his UNION ALL
SELECT 'v_erp_ykcrk' AS tbname, COUNT(*) as num FROM v_erp_ykcrk UNION ALL
SELECT 'v_erp_ykcrk_his' AS tbname, COUNT(*) as num FROM v_erp_ykcrk_his
ORDER BY num DESC
--返回接口监控
SELECT 'int_wms_xsth_bill' AS tbname, COUNT(*) as num FROM int_wms_xsth_bill UNION ALL
SELECT 'int_wms_cgrk_bill' AS tbname, COUNT(*) as num FROM int_wms_cgrk_bill UNION ALL
SELECT 'int_wms_xsth_his' AS tbname, COUNT(*) as num FROM int_wms_xsth_his UNION ALL
SELECT 'int_wms_cgrk_his' AS tbname, COUNT(*) as num FROM int_wms_cgrk_his UNION ALL
SELECT 'INT_WMS_YKCRK_bill' AS tbname, COUNT(*) as num FROM INT_WMS_YKCRK_bill UNION ALL
SELECT 'INT_WMS_YKCRK_his' AS tbname, COUNT(*) as num FROM INT_WMS_YKCRK_his UNION ALL
SELECT 'INT_WMS_DGRK' AS tbname, COUNT(*) as num FROM INT_WMS_DGRK UNION ALL
SELECT 'int_wms_gjtc_bill' AS tbname, COUNT(*) as num FROM int_wms_gjtc_bill UNION ALL
SELECT 'int_wms_gjtc_his' AS tbname, COUNT(*) as num FROM int_wms_gjtc_his UNION ALL
SELECT 'int_wms_xsck_bill' AS tbname, COUNT(*) as num FROM int_wms_xsck_bill UNION ALL
SELECT 'int_wms_bsbssc_bill' AS tbname, COUNT(*) as num FROM int_wms_bsbssc_bill UNION ALL
SELECT 'int_wms_xsck_his' AS tbname, COUNT(*) as num FROM int_wms_xsck_his UNION ALL
SELECT 'int_wms_bsbssc_his' AS tbname, COUNT(*) as num FROM int_wms_bsbssc_his
ORDER BY num DESC
--查漏
SELECT a.yongyfl,*
FROM jxddhz AS a
WHERE a.rq ='2019-04-15' AND a.is_sc='是' AND a.shenhe ='是' AND a.is_zx='否'
AND NOT EXISTS(SELECT 1 FROM v_erp_cgdd AS mm WHERE a.djbh =mm.djbh)
AND NOT EXISTS(SELECT 1 FROM v_erp_cgdd_his AS mm WHERE a.djbh =mm.djbh)
SELECT a.yongyfl,*
FROM jzorder_hz AS a
WHERE a.rq ='2019-04-15' AND a.is_sc='是' AND a.shenhe ='是' AND a.is_zx='否' AND a.djbs='XSG'
AND NOT EXISTS(SELECT 1 FROM v_erp_xsck AS mm WHERE a.djbh =mm.djbh)
AND NOT EXISTS(SELECT 1 FROM v_erp_xsck_his AS mm WHERE a.djbh =mm.djbh)
SELECT a.yongyfl,*
FROM jzorder_hz AS a
WHERE a.rq ='2019-04-15' AND a.is_sc='是' AND a.shenhe ='是' AND a.is_zx='否' AND a.djbs='JHT'
AND NOT EXISTS(SELECT 1 FROM v_erp_gjtc AS mm WHERE a.djbh =mm.djbh)
AND NOT EXISTS(SELECT 1 FROM v_erp_gjtc_his AS mm WHERE a.djbh =mm.djbh)
SELECT a.yongyfl,*
FROM pf_djhz2 AS a
WHERE a.rq ='2019-04-15' AND a.is_sc='是' AND a.shenhe ='是' AND a.is_zx='否' AND a.djbs='XSG'
AND NOT EXISTS(SELECT 1 FROM v_erp_xsth AS mm WHERE a.djbh =mm.djbh)
AND NOT EXISTS(SELECT 1 FROM v_erp_xsth_his AS mm WHERE a.djbh =mm.djbh)