常用资料

已归档至OA工程师导航站 OA工程师导航 huahan.cc 点击前往 →

E9系统URL相关

E9本地地址

• PC端调试手机端地址
  /spa/portal/static4mobilelogin/index.html

E9单页地址获取规则

标准模块

• 前台
  将URL中 /wui/index.html 替换成 /spa/hrm/index_mobx.html
• 后台
  将URL中 /wui/engine.html 替换成 /spa/hrm/engine.html

非标模块

• 考勤前台
  将URL中 /wui/index.html 替换成 /spa/hrm/static4attendance/index.html
• 考勤后台
  将URL中 /wui/engine.html 替换成 /spa/hrm/staticAttendance4engine/engine.html

新建流程

• 新建流程地址
  /workflow/request/AddRequest.jsp?workflowid=xxx

查询接口执行的SQL（存在dataKey）

• 接口执行的SQL查询
  /api/ec/dev/table/getxml?dataKey=

SQL查询

查询某流程节点的所有提交时间

SELECT requestid, userid, processUser, workflowid, nodeid, isbereject, isremark, operatedate, operatetime
FROM workflow_currentoperator
WHERE (nodeid = 465 OR nodeid = 368) 
AND (isbereject IS NULL OR isbereject = '') 
AND isremark = 2;

SQL Server 查询OA离职人员信息

SELECT
  b.lastname AS 姓名,
  c.departmentname AS 部门,
  d.subcompanyname AS 分部,
  d.subcompanyname AS 公司名称,
  b.companystartdate AS 入职日期,
  a.operatedate AS 离职日期,
  a.operatetime AS 离职时间
FROM hrmstatushistory AS a
LEFT JOIN hrmresource b ON b.id = a.resourceid
LEFT JOIN HrmDepartment c ON c.id = b.departmentid
LEFT JOIN hrmsubcompany d ON d.id = b.subcompanyid1
WHERE a.type_n = 5 
AND a.resourceid = 6;

查询当前年的人员数据

SELECT *  
FROM HrmResource 
WHERE status = 5 
AND YEAR(enddate) = YEAR(GETDATE());

查询流程节点

查询流程节点名称及ID

SELECT wfn.nodeid, wfn.workflowid, wnb.nodename
FROM workflow_flownode AS wfn
JOIN workflow_nodebase AS wnb ON wfn.nodeid = wnb.id
WHERE wfn.workflowid IN (149, 145, 140, 133, 106);

通过表单ID查询流程ID（多版本）

SELECT id, workflowname, version 
FROM workflow_base 
WHERE formid = {表单ID};

通过流程ID（多版本）查询节点ID及节点名称

SELECT wfn.nodeid, wfn.workflowid, wnb.nodename
FROM workflow_flownode AS wfn
JOIN workflow_nodebase AS wnb ON wfn.nodeid = wnb.id
WHERE wfn.workflowid IN ({流程ID});

通过表单ID查询节点ID及节点名称

SELECT wfn.nodeid, wfn.workflowid, wnb.nodename
FROM workflow_base AS wb
JOIN workflow_flownode AS wfn ON wb.id = wfn.workflowid
JOIN workflow_nodebase AS wnb ON wfn.nodeid = wnb.id
WHERE wb.formid = {表单ID};

关于选择框

• 独立单选用ID，公共单选用ID排序
  结论：非必要情况（多处引用），不使用公共单选

查询选择框字段值对应ID

SELECT selectvalue, selectname 
FROM workflow_selectitem 
WHERE fieldid = "$这里填写你要查询的字段ID$,如12346";

公共选择项信息表

• 表名: mode_selectitempage

公共选择框明细表

• 表名: mode_selectitempagedetail

小技巧记录

• JS赋值只读字段，不会保入数据库（字段联动除外）
• 字段显示名（多国语言）存放在数据库表 HtmlLabelInfo
• 获取当前用户信息
  JSON.parse(localStorage.getItem("theme-account"))
• 流程的签字意见在 workflow_requestlog 表 remark 字段
• 侧栏打开 openSlideModal(true,"https://oneszhang.com",50);
• 微信扫码免登录空白页 &unloadjem=1
• 创建流程传参
  /spa/workflow/index_form.jsp#/main/workflow/req?iscreate=1&workflowid=132&field10681=1&field10712=16
• 抛出异常 throw new Error("数据请求失败，请稍候重试");
• 流程待办页面tab顺序 workflow_dimension
• 隐藏左侧树&隐藏标题 needTree=false&needTop=false

[泛微EC9] 丸子的E9小本本 by https://oneszhang.com/archives/e9notebook.html