发送通知Sql

-- 向供应商交期计划变更发送通知
SELECT--     a.pur_order_detail_id,
a.purchase_id purchaseId,
TY.user_id ucUserid,
a.vendor_tenant_id vendorTenantId,
a.id id 
FROM
    delivery_plan_version_supplier a
    LEFT JOIN delivery_plan_version_pur b ON b.pur_order_detail_id = a.pur_order_detail_id 
    AND b.is_latest_version = "Y"
    LEFT JOIN iuap_apdoc_basedoc.bd_staff TY ON TY.id = a.purchase_id 
    WHERE                a.pur_order_detail_id =  #{purOrderDetailId}  and
    a.is_latest_version = "Y";
    
--     向供应商交期计划发送通知
SELECT--     a.pur_order_detail_id,
TY.user_id ucUserid,
b.purchase_id purchaseId,
b.vendor_tenant_id vendorTenantId,
b.id id 
FROM
    delivery_plan_vendor b
    LEFT JOIN delivery_plan_buyer a ON a.pur_order_detail_id = b.pur_order_detail_id
    LEFT JOIN iuap_apdoc_basedoc.bd_staff TY ON TY.id = b.purchase_id 
WHERE
    a.pur_order_detail_id = #{purOrderDetailId}
    
--     向采购商交期计划发送通知
    SELECT-- dpv.pur_order_detail_id,
    dpb.purchase_id purchaseId,
    TY.user_id ucUserid,
    dpb.id id 
FROM
    delivery_plan_buyer dpb
    LEFT JOIN delivery_plan_vendor dpv ON dpv.pur_order_detail_id = dpb.pur_order_detail_id
    LEFT JOIN iuap_apdoc_basedoc.bd_staff TY ON TY.id = dpb.purchase_id 
WHERE
    dpv.pur_order_detail_id = #{purOrderDetailId}
    
    
--     向采购商交期计划变更发送通知
    SELECT--   dpv.pur_order_detail_id,
    dpb.purchase_id purchaseId,
    TY.user_id ucUserid,
    dpb.id id 
FROM
    delivery_plan_version_pur dpb
    LEFT JOIN delivery_plan_version_pur dpv ON dpv.pur_order_detail_id = dpb.pur_order_detail_id 
    AND dpv.is_latest_version = "Y"
    LEFT JOIN iuap_apdoc_basedoc.bd_staff TY ON TY.id = dpb.purchase_id 
WHERE
    dpv.pur_order_detail_id = #{purOrderDetailId}  and
    dpb.is_latest_version = "Y";