[易飞]二、邮件预警-检查工时底数和暂收明细

--检查电子-工时底数为1 请及时维护

--条件为在工单一个月内有生产过的产品 

SQL:

SELECT  MB001 品号,MB002 品名,MB003 规格,MB096 工时底数 
FROM ZE.dbo.INVMB left join ZE.dbo.INVML on MB001=ML001  inner join (select distinct TA006 FROM ZE.dbo.MOCTA WHERE LEFT(TA003,6)=CONVERT(CHAR(6),GETDATE(),112)) MOCTA ON MB001=TA006 WHERE MB025='M' AND MB096=1 and MB002<>'' and left(MB001,1) not in('4','2') and MB017='03' AND ML009<>'' AND ZE.dbo.Producttype(MB001)=1  and MB001 in (select TA006 from MOCTA 
WHERE DATEDIFF(day,ZE.dbo.Date10(TA003),getdate())<30)

SQL:

SELECT DATEDIFF(DAY,SUBSTRING(T.CREATE_DATE,1,8),GETDATE()) 进货日距今天数 ,ZE.dbo.Date10(SUBSTRING(T.CREATE_DATE,1,8)) 进货日期,
CASE WHEN TH028='0' THEN '免检'
     WHEN TH028=