泛微OA

— remove doc task update DocChangeSetting set autoSend=0,autoReceive =0; –remove all webservices truncate table wsregiste; –remove all tasks or update SCHEDULESETTING set cronexpr =’0 0 0 1 1 ?’; delete from SCHEDULESETTING; –change pwd update hrmresource set password=’C4CA4238A0B923820DCC509A6F75849B’; –1 update HrmResourceManager set password=’C4CA4238A0B923820DCC509A6F75849B’ where loginid=’sysadmin’; –1 –change page temp update SystemLoginTemplate set isCurrent =0; update … Read more

查询有问题的流程 select t1.requestid,t1.requestmark,t1.createdate, t1.createtime,t1.creater, t1.creatertype, t1.workflowid, t1.requestname, t1.requestnamenew, t1.status,t1.requestlevel,t1.currentnodeid, t2.viewtype,t2.userid,t2.receivedate,t2.receivetime,t2.isremark,t2.nodeid,t2.agentorbyagentid, t2.agenttype,t2.isprocessed,t2.usertype,t1.deleted,t2.takisremark,t2.islasttimes,t1.currentstatus from workflow_requestbase t1,workflow_currentoperator t2 where (t1.deleted <> 1 or t1.deleted is null or t1.deleted=”) and t1. requestid = t2.requestid and t2.userid = 3774 and t2.usertype=0 and (t1.deleted=0 or t1.deleted is null) and ((t2.isremark=0 and (t2.takisremark is null or t2.takisremark=0 )) or t2.isremark in(‘1′,’5′,’8′,’9′,’7′)) and … Read more

根据字段查流程 select c.id,c.workflowname,b.indexdesc,a.fieldname from workflow_billfield a, HtmlLabelIndex b ,workflow_base c where b.id = a.fieldlabel and a.billid = c.formid and b.indexdesc like ‘%订单号%’ 表名查流程 –表名查流程 select a.workflowname,a.formid from workflow_base a, workflow_bill b where a.formid = b.id and b.tablename=’formtable_main_333′

–删除归档结点的doFieldSQL delete from workflow_nodefieldattr where nodeid in ( select nodeid from workflow_flownode where nodetype =3 );

泛微明细表、子表， 数据删除后，再添加行，JS添加的数据不起作用的问题 function changeReq(){ var v = cus_getFieldValue(‘field11022’); var els0 = $(‘input[name^=field11173_]’) // 获取子表，从0开始，此处为明细表1 var len0 = els0.length // 获取子表行数 for (var i = 0; i < len0; i++) { // 子表数据 if(v==1){ setUnReq(els0.eq(i).attr(‘name’)) }else{ setReq(els0.eq(i).attr(‘name’)) } } }

根据流程名称找流程表单 select a.workflowname,b.tablename from workflow_base a,workflow_bill b where a.formid = b.id

—— 顶部菜单，菜单排序 SELECT c.labelname,a.* FROM HrmUserMenuStatictics a,LeftMenuInfo b,HtmlLabelInfo c WHERE a.menuid=b.id and b.labelid=c.indexid and c.languageid=7 and a.userid=123 order by clickCnt desc, menuid update HrmUserMenuStatictics set clickcnt =600 where id = 22 –1 update HrmUserMenuStatictics set clickcnt =500 where id = 81 –2 update HrmUserMenuStatictics set clickcnt =400 where id = 176 –4 update HrmUserMenuStatictics set … Read more

流程创建方式: 1.生成表单 2.调整表单 >申请人，申请部门，浏览框 >调整所有表单属性 3.建流程（要加前缀），创建/修改附件路径，标题调整 4.建节点， 5.建出口线 5.生成第一个节点表单，格式调整 6.工号生成，doFieldSQL(” select loginid from hrmresource where id= $6790$ “) 7.设置表单默认值 8.生成流程编号 9.除第一个节点表单生成， 10.节点加操作者 11.除第一个节点表单配置, 字段权限 12.字段联动， 12.添加JS控制(如果有) 12.出口线配置 13.流程简单测试 14.接口开发 15.接口测试(如果有) 16.流程整体测试