泛微oa帮助文档之人员动态看板

元素地址：/page/element/hdpanel/View.jsp
元素更多按钮地址：/hdpanel/data/DataFrame.jsp
后台数据源配置页面：/hdpanel/base/SourceEdit.jsp 对应权限：人员状态来源维护
读取日程来源配置（SQL语句如下）

select a.resourceid as hrmid,
b.workPlanTypeName as content,
b.workPlanTypeColor as color,
a.begindate as startdate,
a.begintime as starttime,
a.enddate as enddate,
a.endtime as endtime  
from WorkPlan a join 
WorkPlanType b on a.type_n=b.workPlanTypeID 
where a.status=0 and a.deleted <> 1

解决数据来源设置页面无法保存问题：
以下语句放在
…\WEB—INF\securityXML\weaver_security_custom_rules_1.xml中。

<special-reg>
	<urls>
		<url>
			<value>/hdpanel/base/SourceOperation.jsp </value>
			<params>
				<param>
					<value>^sqlstr_\d+$</value>
					<rules>
						<rule >##sqlkeyword1##</rule>
					</rules>
				</param>
			</params>
		</url>
		<url>
			<value>/hdpanel/base/SourceOperation.jsp </value>
			<params>
				<param>
					<value>sqlstr</value>
					<rules>
						<rule >##sqlkeyword1##</rule>
					</rules>
				</param>
			</params>
		</url>
	</urls>
</special-reg>

添加保存后，再更新下rules，在浏览器地址栏输入http://ip:port/updateRules.jsp,enter键后，页面刷出来即可生效。

请在评论区留言，共同探讨~~~

如有需要，请联系微信：hdygzh2019 同时请说明来意，共同进步！！！