公司又不想买云之家,又想移动审批,只有自己动手撸代码了
我在Api 中没有没看关于审批流这块的Api只能通过数据库Sql去实现了
已经成功在移动端实现审批,运行比较稳定
待办任务
SELECT
--APPROVALASSIGN.FDISPOSITION,APPROVALASSIGN_L.FRESULTNAME,
'kingdee' DBType,t.FSTATUS,t.finstcode,t3.FPROCDEFID,t3.FDISPLAYNAME,t.FBILLNUMBER,t.FSenderId,t2.FNAME FSendName,t1.FRECEIVERID ,
t21.FNAME FRECEIVERNAME,t.FCREATETIME as FRECEIVERDATE,convert(varchar(10),t.FCREATETIME,120) as FDATE,c.F_HYKD_ID as FRECEIVEREMPID,
t1.FTitle,t.FOBJECTTYPEID,t.FASSIGNID,t1.fitemid FApprovalItemId FROM AIS2021..v_wf_PMAssign t
left join AIS2021..T_WF_APPROVALASSIGN APPROVALASSIGN ON APPROVALASSIGN.FASSIGNID = t.FASSIGNID
left join AIS2021..T_WF_APPROVALASSIGN_L APPROVALASSIGN_L ON APPROVALASSIGN_L.FAPPROVALASSIGNID = APPROVALASSIGN.FAPPROVALASSIGNID and APPROVALASSIGN_L.FLOCALEID=2052
LEFT JOIN AIS2021..v_wf_PMReceiverItem t1 on t.FASSIGNID = t1.FASSIGNID
inner JOIN AIS2021..T_SEC_user t2 on t.FSENDERID = t2.FUSERID
inner JOIN AIS2021..T_SEC_user t21 on t1.FRECEIVERID = t21.FUSERID
INNER JOIN AIS2021..T_BD_PERSON b ON t21.FLINKOBJECT = b.FPERSONID
LEFT JOIN AIS2021..T_HR_EMPINFO c on c.FID = b.FID AND c.FUSEORGID = 100004
left JOIN AIS2021..T_WF_PROCDEF_L t3 on t.fprocdefid = t3.FPROCDEFID
WHERE t.FSTATUS = 0 AND t.FBILLNUMBER <> '.'
已办任务
SELECT t0.FTITLE 流程标题,t0.FObjectTypeId 表单类型,t0.FNUMBER 流程实例编码,PROCDEF_L.FDISPLAYNAME 流程模版名称,
ISNULL(PMAssign.fbillnumber,SUBSTRING(t0.FNUMBER,0,CHARINDEX('_',t0.FNUMBER))) 单据编码,
t0.FCOMPLETEDTIME 审批完成时间,t0_L.FPRERESULTNAME 审批动作,t0.FCREATETIME 审批到达时间,
t0.FRECEIVERID 审批人Id,t0.FSENDERID 发送人Id,
t0.FDISPOSITION 审批意见 --t0.FREADSTATUS freadstatus
FROM AIS2021..V_WF_ASSIGNEND t0
--审批动作记录
LEFT OUTER JOIN AIS2021..V_WF_ASSIGNEND_L t0_L ON (t0.FASSIGNID = t0_L.FASSIGNID AND t0_L.FLocaleId = 2052)
--还在运行中的流程信息
LEFT JOIN AIS2021..v_wf_PMAssign PMAssign ON PMAssign.FASSIGNID = t0.FAssignId
--流程模版
left JOIN AIS2021..T_WF_PROCDEF_L PROCDEF_L on t0.fprocdefid = PROCDEF_L.FPROCDEFID
order by fbillnumber desc