17,377
社区成员
select
b.FactoryNameCN '工厂',
case a.WorkShop
when 1 then '阀泵车间'
when 2 then '液压缸车间'
else '未知' end '车间',
a.PcnCode 'PCN编号',
a.DefectDesc 'PCN描述',
a.UserName '负责人',
a.BeginDate '执行开始时间',
a.EndDate '执行结束时间',
a.DefectCategoryName '主类型',
a.DefectItemName '子类型',
a.CtTime 'CT影响',
a.RiskRank '风险大小',
a.LineName '产线',
a.ProcessName '工序',
a.WorkOrderNos '工单号',
a.PartCount '数量',
c.ActivityName '当前节点',
a.PartNo'零件号',
case c.IsFinish
when 0 then '进行中'
when 1 then '完成'
when 4 then '驳回'
else '未知' end '状态',
IF(a.Step1EndDate > now(),a.Step2EndDate > now(),a.Step3EndDate > now(),a.Step4EndDate > now()) then '超时'
c.isfinish
from frm_pcn a
left join tpm_info_factory b on b.id = a.Factory
left join flowinstance c on c.id = a.id
ORDER BY a.CreatedTime desc
各位大神该怎么写呢