表名
<h2>流程表单:</h2>
<ul>
<li>流程表单字段fieldid对应数据库字段名表单:
<strong>workflow_billfield</strong> (需要关联workflow_bill表单查出billid)</li>
<li>流程请求基本信息表单:<strong>workflow_requestbase</strong></li>
<li>流程基本信息表单:<strong>workflow_base</strong>
(workflow_base表中的当前流程所属活动版本ID activeVersionID 在只有一个版本的情况下是null)</li>
<li>流程操作日志记录主表(有当前流程的操作类型):<strong>workflow_requestoperatelog</strong></li>
<li>流程下拉框对应表单:<strong>workflow_selectItem</strong></li>
<li>流程签字意见表:<strong>workflow_requestlog</strong></li>
<li>附件id表:<strong>docimagefile (石榴置业)</strong></li>
<li>主子流程对应表:<strong>workflow_subwfrequest</strong></li>
<li>字段显示名:<strong>htmllabelindex</strong> (存的label,查出显示名,从而在workflow_billfield表中查出数据库名称)</li>
<li>公共节日表:<strong>hrmpubholiday</strong>(存着每年的节假日及类型。)</li>
<li>根据requestid查表单名称
<strong>select t3.tablename from workflow_requestbase t1 join workflow_base t2 on t1.workflowid = t2.id join workflow_bill t3 on t2.formid = t3.id where t1.requestid = ?</strong></li>
</ul>
<ul>
<li>有效的流程节点操作者与矩阵表字段对应关系(可能会有多条是流程有多个版本):
<strong>select b.workflowname,n.nodename,g.groupname,concat('matrixtable_', m.MATRIX),i.name,mfi.DISPLAYNAME AS tableName from workflow_base b
left join workflow_flownode f on b.id=f.workflowid
left join workflow_nodebase n on f.nodeid=n.id
left join workflow_nodegroup g on n.id=g.nodeid
left join workflow_groupdetail d on g.id=d.groupid
left join workflow_groupdetail_matrix m on d.id=m.groupdetailid
left join MatrixInfo i on i.id = m.MATRIX
left join MatrixFieldInfo mfi on mfi.ID = m.VALUE_FIELD
where b.isvalid=1 and m.matrix is not null</strong></li>
</ul>
<h2>建模表单:</h2>
<ul>
<li>建模信息表:<strong>modeinfo</strong></li>
<li>下拉框:<strong>workflow_SelectItem</strong>
<ul>
<li>select * from workflow_selectitem where fieldid=(select id from workflow_billfield where billid=(select id from workflow_bill where tablename='uf_hetongtaizhang') and fieldname='htlx') and selectvalue=1</li>
</ul></li>
</ul>
<p>自定义浏览框:存的是自定义浏览框在表中的id,不是显示值。表名在建模配置的浏览框中能看到。</p>
<h2>自定义字段表</h2>
<ul>
<li>人员:
<ul>
<li>select <em> from cus_formfield--自定义字段存储表 select </em> from cus_fielddata--自定义字段数据存储表 scope='HrmCustomFieldByInfoType' and scopeid=-1(基本信息) scope='HrmCustomFieldByInfoType' and scopeid=1(个人信息)
scope='HrmCustomFieldByInfoType' and scopeid=3(工作信息)</li>
</ul></li>
</ul>
<h2>权限</h2>
<ul>
<li>SystemRights --权限设置中全部权限</li>
<li>SystemRightRoles -- 权限与角色对应关系roleid和rightid</li>
<li>hrmroles和hrmrolemember -- 角色及成功关联表</li>
</ul>
<h2>菜单</h2>
<ul>
<li>leftmenuinfo -- 左侧菜单及前端菜单,需要用labelid对应菜单名称</li>
<li>mainmenuinfo -- 后端菜单</li>
</ul>
<h2>文档</h2>
<pre><code>//获取用户有权限查看的文档
ShareManager sharemanager = new ShareManager();
sharemanager.getShareDetailTableByUserNew(&quot;doc&quot;, user)</code></pre>
<h2>其他</h2>
<ul>
<li>HtmlLabelInfo -- 前端labelid对应取值表 indexid对应workflow_billfield表中的fieldlabel</li>
</ul>