泛微OA-常用操作

查询有问题的流程

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 (t1.deleted=0 or t1.deleted is null)
and t2.islasttimes=1
and (nvl(t1.currentstatus,-1) = -1 or (nvl(t1.currentstatus,-1)=0))
and t1.workflowid in (
select id
from workflow_base
where (isvalid=’1′ or isvalid=’3′) )

——-流程创建节点页面
addwfnode.jsp
Editwfnode.jsp
addwfnodeportal.jsp

–流程属性相关页面
\workflow\form\editformfield.jsp
\workflow\form\addfieldbatch.jsp

查询系统中表的记录数
select a.name as 表名,max(b.rows) as 记录条数 from sysobjects a ,sysindexes b
where a.id=b.id and a.xtype=’u’
group by a.name
order by max(b.rows) desc

emessage重装
解决:openfire设置的配置文件路径为:../openfire/conf/openfire.xml。
打开xml文件发现安装设置完成后setup的值为true
<setup>true</setup>
首先关闭openfire服务器,
然后删除<setup>属性,
然后重新启动 Openfire 并重新装入设置工具。
http://127.0.0.1:9090/setup/index.jsp就可以重新设置了。

—-IE退出的问题,是由于Nginx的配置

–流程 表单 模板设计及JS 代码块
select b.workflowname,a.* from workflow_nodehtmllayout a,workflow_base b
where a.workflowid = b.id –and a.workflowid=511
and workflowname like ‘%ITGL19%’
— and layoutname like ‘%显示%’
and type = 0

select layoutname,datajson,pluginjson,scripts from workflow_nodehtmllayout
where workflowid=511 and type = 0

修复待办流程,显示不了的问题
update workflow_currentoperator set isremark=’2′ where isremark=’f’ ;

清除审批意见:
update workflow_approvelog set remark =” where requestid =471512 and nodeid = 5664;
update workflow_requestLog set remark =” where requestid =471512 and nodeid = 5664;

建模,表单设计
select * from modehtmllayout

删除历史的表单
–delete from modehtmllayout where isdefault =0;
–delete from workflow_nodehtmllayout where isactive=0

select count(1) from workflow_currentoperator where userid = 716 and isremark =0 –待办数量

节点操作人
select * from Workflow_HrmOperator where objid in ()

select d.id,d.workflowname,a.nodeid,b.nodename,c.groupname,g.objid,h.lastname
from workflow_flownode a,workflow_nodebase b, workflow_nodegroup c,workflow_base d,
Workflow_HrmOperator g,hrmresource h–,workflow_groupdetail_matrix m
where a.nodeid = b.id and b.id = c.nodeid
and a.workflowid = d.id
and c.id = g.groupid
and (d.isvalid =1 or isvalid =3)
–and g.type = 3
–and g.groupid =7811
and g.objid=h.id
and g.objid =1044

— 待办事宜
select distinct t1.requestid, t1.createdate, t1.createtime,t1.creater, t1.creatertype,
t1.workflowid, t1.requestname, t1.status,t1.requestlevel,t1.currentnodeid,t2.viewtype,
t2.receivedate,t2.receivetime,t2.isremark,t2.nodeid,t2.agentorbyagentid,t2.agenttype
from workflow_requestbase t1,workflow_currentoperator t2
where t1.requestid = t2.requestid
and t2.userid = 1 — 用户ID
and t1.workflowid in(301) — 流程ID
— 下面这些条件没有仔细研究过,我也不知道分别有什么作用,只知道这样可以查到待办事宜
and t2.usertype=0 — 用户类型,1为普通用户,2为客户
and t2.isremark in( ‘0’,’1′,’5′,’8′,’9′,’7′)
and t2.islasttimes=1
— 按时间倒序
order by t2.receivedate ,t2.receivetime Desc

删除/关闭管理员-流程
–del pending flow
update workflow_requestbase set deleted =1 where requestid in(
select DISTINCT a.requestid from workflow_requestbase a,workflow_currentoperator b,workflow_base c,workflow_type d
where a.requestid = b.requestid and a.workflowid = c.id and c.workflowtype = d.id
and b.userid = 1 and a.deleted =0 and d.id = 1 –workflowtype
);

组织架构:select loginid,dbo.ryjg(id) ‘组织架构’,lastname,email from hrmresource where status = 1

 

 

 

发表评论