keossteven-优快云博客

原创创建固定资产视图

when faah005='3' then '3:土地' when faah005='4' then '4:递耗资产' when faah005='5' then '5:费用' else '' end) as 财产类型,when faah015='3' then '3:外送/收回' when faah015='4' then '4:折毕' when faah015='5' then '5:出售'select distinct faah001||'-'||faah003 as 卡片财产编号,

2025-03-27 10:01:18 257

原创 OA加班申请明细表

(case when fi_history='1' then '办结' when fi_history='0' then '在处理' when fi_history='4' then '作废' else '' end ) as 状态,'多人' as 来自单据,AND 1=1 ${if(len(部门名称) == 0," ","and 加班人部门= ('" + 部门名称 + "')")}AND 1=1 ${if(len(姓名) == 0," ","and 加班人姓名= ('" + 姓名 + "')")}

2025-03-17 09:30:18 341

原创上周销售额

LEFT JOIN glaa_t on glaaent=xmdkent and xmdksite=glaald WHERE xmdksite in('SU','TS','SZ','US','HK') and xmdk007 not in('00001','00010','T0159','T0160','T0164','XTEMP')--不包括内部订单。(CASE --指定结案，根据已交数量*单价计算金额 round((apba014/l_oldsy*l_newsy),4)

2025-03-05 16:53:20 265

原创上周接单金额按销售组车加工

(case when xmdc045 in ('1','5') then'1:一般' when xmdc045='2'then '2:正常结案' when xmdc045='3' then '3:长结' when xmdc045='4' then '4:短结' when xmdc045='5'then '5:留置'else'有错'end)as 行状态,and xmdasite in ('SZ') and xmda005<>'5'--排除预先。

2025-03-04 15:30:13 1055

原创上周接单每日汇总，按销售组

where xmdastus IN ('y','C')AND xmdaent=100 and xmda021 not in ('00001','00010','T0159','T0160','T0164','XTEMP')--不包括内部订单。and xmdasite in ('SU','TS','SZ','US','HK')and xmda005<>'5'--排除预先。SELECT xmdadoct,sum(xmdc007) as 上周订单数量,sum(jg) as 未税金额 FROM(

2025-02-25 13:03:05 1293

原创 copyofAFN天线滤波器绑定查询

select SN AS 天线序列号，[TOP] as TOP 滤波器内部序列号,(SELECT CustomerSN from CustomerSN b where b.sn=a.[TOP]--AND 1=1${if(len(TOP滤波器客户序列号)==0,"","and CustomerSN=('"+TOP滤波器客户序列号+”’)")})asTOP滤波器客户序列号，BOTTOM as BOTTOM 滤波器内部序列号,（SELECT CustomerSN from CustomerSN b whe

2025-02-14 10:17:31 225

原创天线滤波器绑定查询

AND 1=1${if(len(BOTTOM滤波器内部序列号)==0," ","and a. BOTTOM in ('"+replace(BOTTOM滤波器内部序列号,",","','")+"')","")}AND 1=1${if(len(TOP滤波器内部序列号)==0," ","and a.[TOP]in('"+replace(TOP滤波器内部序列号,",","','")+"')","')}--AND 1=1 ${if(len(TOP滤波器客户序列号)==0," ","and。

2025-01-24 11:34:26 261

原创二层包装明细表

CONVERT(VARCHAR(10),A1.ModifiedTime,120)>=(' " +开始日期+"')")} and 1=1${if(len(截止日期)==0," ","and CONVERT(VARCHAR(10),A1.ModifiedTime,120)<=(' "+截止日期+" ')")}and 1=1 ${if(len(一层包装号码)==0," "," and A1.PackNumber in(' "+replace(一层包装号码,",","','")+"')","")}

2025-01-23 16:08:38 580

原创一层包装明细表

and 1= 1 ${if(len(开始日期) == 0,"","and CONVERT(VARCHAR(10),A,ModifiedTime,120)>=('" +开始日期 +"')"} and 1 = 1 $ {if(len(截止日期) == 0,"," and CONVERT(VARCHAR(10),A.ModifiedTime,120)<= ('"+ 截止日期 + " ')")}A.productionstatus <6 THEN'在线WIP' when A.status = 1 AND。

2025-01-23 10:21:59 319

keossteven的博客