常用资料
已归档至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("数据请求失败，请稍候重试");
[泛微EC9] 丸子的E9小本本 by https://oneszhang.com/archives/e9notebook.html
