DOPJAVA/IQC来料质量检验.md

IQC来料品质检验

• 来料检验申请

业务流程

功能:

-新建、编辑、查看、删除申请单

-列表展示（支持搜索、筛选、分页）

操作按钮

列表操作：

1. 添加 - 打开来料检验申请添加表单

行操作：

1. 编辑 - 当点击后打开点击行的来料检验申请编辑表单

2. 查看 - 打开点击行的来料检验申请单查看表单

列表展示sql：

SELECT[id],[FBILLNO],[FBILLSTATUS],[FCREATORID],[FMODIFIERID],[FAUDITORID],[FAUDITDATE],[FMODIFYTIME],[FCREATETIME],[FORGID],[FQUALITYORG],[FAPPLYUSER],[FAPPLYTIME],[FBILLTYPE],[FBIZTYPE],[FINSPECORGID],[FCOMMENT],[FAUTHORIZEOBJID],[FINTERFACEID]FROM[dbo].[qms_qcp_inspecapplyn]

• 来料检验任务

业务流程：

功能:

-任务认领

-优先级调整

-检验员调配

-来料检验

操作按钮

列表操作

优先级调整：勾选需要调整的行后，在优先级搜索栏，输入需要的优先级，点击【优先级调整】，当前行优先级字段变更

任务认领：勾选当前行，点击任务认领后，更新检验人字段为当前用户名称 检验员调配：勾选当前行，将检验人字段清空

来料检验：更新任务状态，进入流程状态来料检验单页面

列表展示sql:

Select DISTINCT*,casewhenb.FINSPECTSTATUS='待检验'then'FINSPECTSTATUS:#FF3300;'whenb.FINSPECTSTATUS='检验中'then'FINSPECTSTATUS:#FFFF00;'whenb.FINSPECTSTATUS='检验完成'then'FINSPECTSTATUS:#00CC00;'else'rwzt:#4472c4;'end+phcolorbackgroundfrom(selectb.idasid/*ID不能动*/,[FBILLNO]/*来料检验申请单编号*/,[FBILLSTATUS],[FCREATORID],FAPPLYUSER,FAPPLYTIME,FBILLTYPE,FBIZTYPE,FINSPECORGID,FCOMMENT,FORGID,[FMATERIALCFG],[wlmc],[ggxh],[FAPPLYQTY],[FUNIT],FINSPECTSTATUS,jyfzr,yxj,jykssj,jywcsj,sfpc,b.FSRCORDERNUM/*收货单号*/,b.shdh/*送货单号*/,b.yy,b.FLOTNUMBER,FWAREHOUSEID/*仓位*/,FLOCATIONID/*货架*/,SortName/*供应商名称*/,g.Supp/*供应商编码*/,f.scph,isnull(h.phcs,1)scphcs,b.wllb,casewhenisnull(h.phcs,1)=1orh.id=f.glidthen''else'scph: #00CC00'endphcolor,d.sort,remarksfrom[dbo].[qms_qcp_inspecapplyn]awith(nolock)/*来料检验申请主表*/innerjoin[dbo].[qms_qcp_insappnentry]bwith(nolock)ona.id=b.glid/*来料检验申请子表*/leftjoin[dbo].[PurOrdRctDetail]ewith(nolock)one.barcode=a.FBILLNOleftjoinSuppMastergwith(nolock)ong.Supp=b.FSUPPLIER/*供应商基础档案*/leftjoinscm_shdcwith(nolock)onb.shdh=c.shddh/*送货单*/leftjoin(SELECTscph,shpc,sh_material_code,glid,STRING_AGG(remarks,';')ASremarksFROMscm_shdzbGROUPBYscph,shpc,sh_material_code,glid)fonf.shpc=b.FLOTNUMBERandf.sh_material_code=b.FMATERIALCFGandf.glid=c.idleftjoin[dbo].[rf_dictionary]dond.id=yxj/*优先级排序*/leftjoin(selectc.sh_purchase_num,f.scph,sh_material_code,count(*)phcs,min(c.id)idfromscm_shdcinnerjoinscm_shdzbfonc.id=f.glidinnerjoin(selectgysbm,wlbmfromqms_lymjbmdminnerjoinqms_lymjbmdzbnonm.id=n.glid)tont.gysbm=c.sh_purchase_numandt.wlbm=f.sh_material_codewhereisnull(c.sh_purchase_num,'')<>''andisnull(f.scph,'')<>''groupbyc.sh_purchase_num,f.scph,sh_material_code)honc.sh_purchase_num=h.sh_purchase_numandf.scph=h.scphandh.sh_material_code=f.sh_material_code)b

3.来料检验单

业务流程：

功能:

.流程进入：根据来料检验单模板，通过表单javascript进行数据填充，数据填充完毕后，可转交给其他用户审查，最后流程结束先后调用

[sql][q]exec qms_WMS_SaveIQCcheck @id='{}'

[sql-json][q]exec qms_WMS_SaveIQCResult @id='{}'

表单javascript：

this.keydown=true;debuggerletpo="{Get}";letid="{Get}";letstepid="{}";lettype="{Get}";letid020="{}";letwlbm="{Get}";constconname="dopflow";//步骤判定：领导自动赋值if(stepid==475644329312325){this.formData['qms_qcp_inspbill-leader']='{}';this.formData['qms_qcp_inspbill-leaderTime']='{}'}//检验人默认当前用户if(!this.formData['qms_qcp_inspbill-jyr']){this.formData['qms_qcpinspbill-jyr']='u'+'{}';}//物料编码默认从表单中取if(!wlbm){wlbm=this.formData['qms_qcp_inspbill-fmaterialcfg'];}//根据实例ID获取领用数量if(id020){letsql=SELECTlysl,phslFROMqms_qcp_inspbillWHEREid=${id020};utils.getSelect(conname,sql).then((res)=>{if(res.data.rows.length>0){letrow=res.data.rows[0];this.formData['qms_qcp_inspbill-lysl']=row.lysl;this.formData['qms_qcp_inspbill-phsl']=row.phsl;}});}//基础字段赋值if(type)this.formData['qms_qcp_inspbill-fbiztype']=type;if(po)this.formData['qms_qcp_inspbill-lydjbh']=po;//获取申请单信息if(id){letsql=SELECTb.idASid,c.shddhASshddh,FBILLNO,FBILLSTATUS,FCREATORID,FAPPLYUSER,FAPPLYTIME,FBILLTYPE,FBIZTYPE,FINSPECORGID,FCOMMENT,FORGID,FMATERIALCFG,wlmc,ggxh,FAPPLYQTY,FUNIT,sfpc,pcsm,FLOTNUMBER,c.sh_purchase_nameFROMqms_qcp_inspecapplynaINNERJOINqms_qcp_insappnentrybONa.id=b.glidLEFTJOINscm_shdcONb.shdh=c.shddhWHEREb.id=${id};utils.getSelect(conname,sql).then((res)=>{if(res.data.rows.length>0){constrow=res.data.rows[0];this.formData['qms_qcp_inspbill-hid']=row.id;this.formData['qms_qcp_inspbill-fmaterialcfg']=row.FMATERIALCFG;this.formData['qms_qcp_inspbill-wlmc']=row.wlmc;this.formData['qms_qcp_inspbill-ggxh']=row.ggxh;this.formData['qms_qcp_inspbill-jysl']=row.FAPPLYQTY;this.formData['qms_qcp_inspbill-dhsl']=row.FAPPLYQTY;this.formData['qms_qcp_inspbill-pch']=row.FLOTNUMBER;this.formData['qms_qcp_inspbill-shdh']=row.shddh;this.formData['qms_qcp_inspbill-gysmc']=row.sh_purchase_name;//设置标题（放在数据拉取之后）this.formData['qms_qcp_inspbill-title']=来料检验：${row.FMATERIALCFG}、${row.wlmc}、${row.FLOTNUMBER};}});}//检验数量默认设置if(!this.formData['qms_qcp_inspbill-frinsqty']){this.formData['qms_qcp_inspbill-frinsqty']='5';}letNum=parseInt(this.formData['qms_qcp_inspbill-frinsqty']);showcols.value=",";for(leti=Num+1;i<=80;i++){showcols.value+="j"+i+",";}//加载检验规范子表（如果为空）if(!(this.formData['subtable_1678759169443']?.length)){letsql=WITHFilteredDataAS(SELECTa.wlbm,b.glid,a.sxrq,a.th,b.jyxm,b.jybz,b.txfl,b.jygjjyff,b.cyfa,b.zs,a.bb,a.fj,a.wjbh,b.sx,b.xxFROMqms_jygfaINNERJOINqms_jygfzbbONa.id=b.glidWHEREa.wlbmLIKE'%${wlbm}%'andisEnable=1),MaxGlidAS(SELECTMAX(glid)ASmax_glidFROMFilteredData),MaxSxrqAS(SELECTMAX(sxrq)ASmax_sxrqFROMFilteredDataWHEREglid=(SELECTmax_glidFROMMaxGlid))SELECT*FROMFilteredDataWHEREglid=(SELECTmax_glidFROMMaxGlid)ANDsxrq=(SELECTmax_sxrqFROMMaxSxrq);this.addSubtableRow('subtable_1678759169443');utils.getSelect(conname,sql).then((res)=>{constrows=res.data.rows||[];for(letrowofrows){letnewRow={key:utils.createGuid(false),jyxm:row.jyxm,bz:row.jybz,txfl:row.txfl,jygjjyff:row.jygjjyff,cyfa:row.cyfa,zs:row.zs,sx:row.sx,xx:row.xx,remarks:""};//设置检验规范相关字段（主表）if(row.fj!=null){this.formData['qms_qcp_inspbill-fj']=row.fj;this.$refs['formRef_qms_qcp_inspbill_fj']?.initTitle(row.fj);}this.formData['qms_qcp_inspbill-jgbh']=row.wjbh;this.formData['qms_qcp_inspbill-jgbb']=row.bb;this.formData['qms_qcp_inspbill-jgsxrq']=row.sxrq;this.formData['qms_qcp_inspbill-drawingid']=row.th;this.formData['subtable_1678759169443'].push(newRow);}//删除初始化时插入的空子表行this.delSubtableRow('subtable_1678759169443',this.formData['subtable_1678759169443'][0]);});}

4.来料检验单列表

业务流程

功能

-新建、编辑、查看、删除申请单

-列表展示（支持搜索、筛选、分页）

行操作：

1. 编辑 - 当点击后打开点击行的来料检验单编辑表单

2. 查看 - 打开点击行的来料检验单查看表单

列表展示sql:

selectc.idassqid,a.*,f.scph,cd.sh_purchase_namefromqms_qcp_inspbilla/检验单/leftjoinqms_qcp_inspecapplynb/检验申请主表/ona.lydjbh=b.FBILLNOleftjoinqms_qcp_insappnentryc/检验申请单子表/onb.id=c.glidleftjoinscm_shdcdwith(nolock)onc.shdh=cd.shddh/送货单/leftjoin(SELECTscph,shpc,sh_material_code,glid,STRING_AGG(remarks,';')ASremarksFROMscm_shdzbGROUPBYscph,shpc,sh_material_code,glid)fonf.shpc=c.FLOTNUMBERandf.sh_material_code=c.FMATERIALCFGandf.glid=cd.id

数据表及字段

qms_qcp_inspecapplyn	id	主表id
qms_qcp_inspecapplyn	FBILLNO	单据编号
qms_qcp_inspecapplyn	FBILLSTATUS	单据状态
qms_qcp_inspecapplyn	FCREATORID	创建人
qms_qcp_inspecapplyn	FMODIFIERID	修改人
qms_qcp_inspecapplyn	FAUDITORID	审核人
qms_qcp_inspecapplyn	FAUDITDATE	审核时间
qms_qcp_inspecapplyn	FMODIFYTIME	修改时间
qms_qcp_inspecapplyn	FCREATETIME	创建时间
qms_qcp_inspecapplyn	FORGID	申请组织
qms_qcp_inspecapplyn	FQUALITYORG	申请部门
qms_qcp_inspecapplyn	FAPPLYUSER	申请人
qms_qcp_inspecapplyn	FAPPLYTIME	申请时间
qms_qcp_inspecapplyn	FBILLTYPE	单据类型
qms_qcp_inspecapplyn	FBIZTYPE	业务类型
qms_qcp_inspecapplyn	FINSPECORGID	质检组织
qms_qcp_inspecapplyn	FCOMMENT	备注
qms_qcp_inspecapplyn	FAUTHORIZEOBJID	鉴权对象
qms_qcp_inspecapplyn	FINTERFACEID	接口候选
qms_qcp_inspbill	id	id
qms_qcp_inspbill	lydjbh	来源单据编号
qms_qcp_inspbill	FBILLNO	单据编号
qms_qcp_inspbill	FBILLSTATUS	单据状态
qms_qcp_inspbill	FCREATORID	创建人
qms_qcp_inspbill	FMODIFIERID	修改人
qms_qcp_inspbill	FAUDITORID	审核人
qms_qcp_inspbill	FAUDITDATE	审核时间
qms_qcp_inspbill	FMODIFYTIME	修改时间
qms_qcp_inspbill	FCREATETIME	创建时间
qms_qcp_inspbill	FORGID	质检组织
qms_qcp_inspbill	FINSPESTARTDATE	检验开始日期
qms_qcp_inspbill	FINSPEENDDATE	检验完成时间
qms_qcp_inspbill	FINSPEDEPTID	质检部门
qms_qcp_inspbill	FINSPECTORID	质检员
qms_qcp_inspbill	FBILLTYPE	单据类型
qms_qcp_inspbill	FBIZTYPE	业务类型
qms_qcp_inspbill	FCOMMENT	备注
qms_qcp_inspbill	FMATERIALCFG	物料编码
qms_qcp_inspbill	wlmc	物料名称
qms_qcp_inspbill	ggxh	规格型号
qms_qcp_inspbill	FRINSQTY	样本数量
qms_qcp_inspbill	ypxx	样品信息
qms_qcp_inspbill	pd	判定
qms_qcp_inspbill	jyr	检验人
qms_qcp_inspbill	jysj	检验数量
qms_qcp_inspbill	dhsl	到货数量
qms_qcp_inspbill	hid	申请单行id
qms_qcp_inspbill	lysl	留样数量
qms_qcp_inspbill	phsl	破坏数量
qms_qcp_inspbill	pcsq	偏差申请
qms_qcp_inspbill	pcsm	偏差说明
qms_qcp_inspbill	clfs	处理方式
qms_qcp_inspbill	bhgsl	不合格数量
qms_qcp_inspbill	blwtflid	不良问题分类id
qms_qcp_inspbill	blwtflmc	不良问题分类名称
qms_qcp_inspbill	pch	批次号
qms_qcp_inspbill	jlqjbh	计量器具编号
qms_qcp_inspbill	jykyd	检验宽严度
qms_qcp_inspbill	jygfid	ID
qms_qcp_inspbill	jygfbbm	没有用
qms_qcp_inspbill	cbzx	成本中心
qms_qcp_inspbill	bqjl	标签记录
qms_qcp_inspbill	cbzxmc	成本中心名称
qms_qcp_inspbill	fj	附件
qms_qcp_inspbill	fs	供应商分数
qms_qcp_inspbill	ffj	附件
qms_qcp_inspbill	bdbh	表单编号
qms_qcp_inspbill	bb	版本
qms_qcp_inspbill	sxrq	生效日期
qms_qcp_inspbill	jysl	检验数量
qms_qcp_inspbill	title	表单标题
qms_qcp_inspbill	shdh	送货单号
qms_qcp_inspbill	jgbh	检规编号
qms_qcp_inspbill	jgbb	检规版本
qms_qcp_inspbill	jgsxrq	检规生效日期
qms_qcp_inspbill	gysmc	供应商名称
qms_qcp_inspbill	thyy	退货原因
qms_qcp_inspbill	DrawingID	图号
qms_qcp_inspbill	UnqualifiedDescription
qms_qcp_inspbill	leader
qms_qcp_inspbill	SampleQty
qms_qcp_inspbill	TestQty
qms_qcp_inspbilllist	id	主表id
qms_qcp_inspbilllist	billid	单据ID
qms_qcp_inspbilllist	jyxm	检验项目
qms_qcp_inspbilllist	sx	上限
qms_qcp_inspbilllist	xx	下限
qms_qcp_inspbilllist	bz	标准
qms_qcp_inspbilllist	czf	操作符
qms_qcp_inspbilllist	j1	样本1
qms_qcp_inspbilllist	j2	样本2
qms_qcp_inspbilllist	j3	样本3
qms_qcp_inspbilllist	j4	样本4
qms_qcp_inspbilllist	j5	样本5
qms_qcp_inspbilllist	j6	样本6
qms_qcp_inspbilllist	j7	样本7
qms_qcp_inspbilllist	j8	样本8
qms_qcp_inspbilllist	j9	样本9
qms_qcp_inspbilllist	j10	样本10
qms_qcp_inspbilllist	j11	样本11
qms_qcp_inspbilllist	j12	样本12
qms_qcp_inspbilllist	j13	样本13
qms_qcp_inspbilllist	j14	样本14
qms_qcp_inspbilllist	j15	样本15
qms_qcp_inspbilllist	j16	样本16
qms_qcp_inspbilllist	j17	样本17
qms_qcp_inspbilllist	j18	样本18
qms_qcp_inspbilllist	j19	样本19
qms_qcp_inspbilllist	j20	样本20
qms_qcp_inspbilllist	j21	样本21
qms_qcp_inspbilllist	j22	样本22
qms_qcp_inspbilllist	j23	样本23
qms_qcp_inspbilllist	j24	样本24
qms_qcp_inspbilllist	j25	样本25
qms_qcp_inspbilllist	j26	样本26
qms_qcp_inspbilllist	j27	样本27
qms_qcp_inspbilllist	j28	样本28
qms_qcp_inspbilllist	j29	样本29
qms_qcp_inspbilllist	j30	样本30
qms_qcp_inspbilllist	j31	样本31
qms_qcp_inspbilllist	j32	样本32
qms_qcp_inspbilllist	j33	样本33
qms_qcp_inspbilllist	j34	样本34
qms_qcp_inspbilllist	j35	样本35
qms_qcp_inspbilllist	j36	样本36
qms_qcp_inspbilllist	j37	样本37
qms_qcp_inspbilllist	j38	样本38
qms_qcp_inspbilllist	j39	样本39
qms_qcp_inspbilllist	j40	样本40
qms_qcp_inspbilllist	j41	样本41
qms_qcp_inspbilllist	j42	样本42
qms_qcp_inspbilllist	j43	样本43
qms_qcp_inspbilllist	j44	样本44
qms_qcp_inspbilllist	j45	样本45
qms_qcp_inspbilllist	j46	样本46
qms_qcp_inspbilllist	j47	样本47
qms_qcp_inspbilllist	j48	样本48
qms_qcp_inspbilllist	j49	样本49
qms_qcp_inspbilllist	j50	样本50
qms_qcp_inspbilllist	pd	判定
qms_qcp_inspbilllist	ybl	样本量
qms_qcp_inspbilllist	txfl	指标分类
qms_qcp_inspbilllist	bhgyy	不合格原因
qms_qcp_inspbilllist	cyfa	抽样方案
qms_qcp_inspbilllist	zs	注释
qms_qcp_inspbilllist	jygjjyff	检验工具/检验方
qms_qcp_inspbilllist	jlqjbh	计量器具编号
qms_qcp_inspbilllist	fj	附件
qms_qcp_inspbilllist	j51	样本51
qms_qcp_inspbilllist	j52	样本52
qms_qcp_inspbilllist	j53	样本53
qms_qcp_inspbilllist	j54	样本54
qms_qcp_inspbilllist	j55	样本55
qms_qcp_inspbilllist	j56	样本56
qms_qcp_inspbilllist	j57	样本57
qms_qcp_inspbilllist	j58	样本58
qms_qcp_inspbilllist	j59	样本59
qms_qcp_inspbilllist	j60	样本60
qms_qcp_inspbilllist	j61	样本61
qms_qcp_inspbilllist	j62	样本62
qms_qcp_inspbilllist	j63	样本63
qms_qcp_inspbilllist	j64	样本64
qms_qcp_inspbilllist	j65	样本65
qms_qcp_inspbilllist	j66	样本66
qms_qcp_inspbilllist	j67	样本67
qms_qcp_inspbilllist	j68	样本68
qms_qcp_inspbilllist	j69	样本69
qms_qcp_inspbilllist	j70	样本70
qms_qcp_inspbilllist	j71	样本71
qms_qcp_inspbilllist	j72	样本72
qms_qcp_inspbilllist	j73	样本73
qms_qcp_inspbilllist	j74	样本74
qms_qcp_inspbilllist	j75	样本75
qms_qcp_inspbilllist	j76	样本76
qms_qcp_inspbilllist	j77	样本77
qms_qcp_inspbilllist	j78	样本78
qms_qcp_inspbilllist	j79	样本79
qms_qcp_inspbilllist	j80	样本80
qms_qcp_inspbilllist	j81	样本81
qms_qcp_inspbilllist	j82	样本82
qms_qcp_inspbilllist	j83	样本83
qms_qcp_inspbilllist	j84	样本84
qms_qcp_inspbilllist	j85	样本85
qms_qcp_inspbilllist	j86	样本86
qms_qcp_inspbilllist	j87	样本87
qms_qcp_inspbilllist	j88	样本88
qms_qcp_inspbilllist	j89	样本89
qms_qcp_inspbilllist	j90	样本90
qms_qcp_inspbilllist	j91	样本91
qms_qcp_inspbilllist	j92	样本92
qms_qcp_inspbilllist	j93	样本93
qms_qcp_inspbilllist	j94	样本94
qms_qcp_inspbilllist	j95	样本95
qms_qcp_inspbilllist	j96	样本96
qms_qcp_inspbilllist	j97	样本97
qms_qcp_inspbilllist	j98	样本98
qms_qcp_inspbilllist	j99	样本99
qms_qcp_inspbilllist	j100	样本100
qms_qcp_inspbilllist	j101	样本101
qms_qcp_inspbilllist	j102	样本102
qms_qcp_inspbilllist	j103	样本103
qms_qcp_inspbilllist	j104	样本104
qms_qcp_inspbilllist	j105	样本105
qms_qcp_inspbilllist	j106	样本106
qms_qcp_inspbilllist	j107	样本107
qms_qcp_inspbilllist	j108	样本108
qms_qcp_inspbilllist	j109	样本109
qms_qcp_inspbilllist	j110	样本110
qms_qcp_inspbilllist	j111	样本111
qms_qcp_inspbilllist	j112	样本112
qms_qcp_inspbilllist	j113	样本113
qms_qcp_inspbilllist	j114	样本114
qms_qcp_inspbilllist	j115	样本115
qms_qcp_inspbilllist	j116	样本116
qms_qcp_inspbilllist	j117	样本117
qms_qcp_inspbilllist	j118	样本118
qms_qcp_inspbilllist	j119	样本119
qms_qcp_inspbilllist	j120	样本120
qms_qcp_inspbilllist	j121	样本121
qms_qcp_inspbilllist	j122	样本122
qms_qcp_inspbilllist	j123	样本123
qms_qcp_inspbilllist	j124	样本124
qms_qcp_inspbilllist	j125	样本125
qms_qcp_inspbilllist	j126	样本126
qms_qcp_inspbilllist	j127	样本127
qms_qcp_inspbilllist	j128	样本128
qms_qcp_inspbilllist	j129	样本129
qms_qcp_inspbilllist	j130	样本130
qms_qcp_inspbilllist	j131	样本131
qms_qcp_inspbilllist	j132	样本132
qms_qcp_inspbilllist	j133	样本133
qms_qcp_inspbilllist	j134	样本134
qms_qcp_inspbilllist	j135	样本135
qms_qcp_inspbilllist	j136	样本136
qms_qcp_inspbilllist	j137	样本137
qms_qcp_inspbilllist	j138	样本138
qms_qcp_inspbilllist	j139	样本139
qms_qcp_inspbilllist	j140	样本140
qms_qcp_inspbilllist	j141	样本141
qms_qcp_inspbilllist	j142	样本142
qms_qcp_inspbilllist	j143	样本143
qms_qcp_inspbilllist	j144	样本144
qms_qcp_inspbilllist	j145	样本145
qms_qcp_inspbilllist	j146	样本146
qms_qcp_inspbilllist	j147	样本147
qms_qcp_inspbilllist	j148	样本148
qms_qcp_inspbilllist	j149	样本149
qms_qcp_inspbilllist	j150	样本150
qms_qcp_inspbilllist	bzz	备注