helpdesk.page

网站开发模板框架 网站开发模板 网站开发模板 网站开发模板框架

<?xml version="1.0" encoding="gb2312"?>
<jvc>
	<views>
	    <view name="add" path="/jsp/project/helpdesk/additem.jsp"/>
	    <view name="myitem" path="/jsp/project/helpdesk/myitem.jsp"/>
	    <view name="viewitem" path="/jsp/project/helpdesk/viewitem.jsp"/>
	    <view name="allitem" path="/jsp/project/helpdesk/allitem.jsp"/>	    
	    <view name="queryitem" path="/jsp/project/helpdesk/queryitem.jsp"/>	    	    
	    <view name="updateitem" path="/jsp/project/helpdesk/updateitem.jsp"/>	    	    	    
	    <view name="msg" path="/jsp/common/msg.jsp"/>	    	    	    	    
	</views>
	
	<commands>	
		<!--查询字典表-->
		<command name="querydict" allow="true">
			<action name="Dict"><input name="name" value="helpdeskitemtype"/></action>
			<action name="Dict"><input name="name" value="helpdeskitemstatus"/></action>
			<action name="Dict"><input name="name" value="helpdeskitempriority"/></action>
			<action name="Dict"><input name="name" value="helpdeskitemsource"/></action>
			<action name="Dict"><input name="name" value="helpdeskitemseverity"/></action>
			<action name="Dict"><input name="name" value="OperateSystem"/></action>
			<action name="Dict"><input name="name" value="helpdeskitemapplication"/></action>
			<action name="Query">
				<input name="sql" value="select UserName,UserID from jvc_User" />
				<input name="prestr" value="none" />
				<input name="name" value="jvc_user"/>
			</action>
		</command>		
		
		<!--增加记录-->
		<command name="add" allow="true" transparam="true">
			<command name="querydict"/>
			<action name="GetCheck"><input name="name" value="item" /></action>	
			<action name="Forward"><input name="view" value="add"/></action>
		</command>		

		<command name="doadd" allow="true" >
				<action name="Insert">
					<input name="tablename" value="helpdesk_items"/>					
					<input name="fault" value="[add]"/>				
				</action>
		</command>

		
		<!--浏览记录-->
		<command name="viewitem" allow="true">
			<command name="querydict"/>
			<action name="GetCheck"><input name="name" value="log" /></action>
			<action name="Query">
				<input name="sql" value="select * from helpdesk_items "/>
				<input name="name" value="res"/>
				<input name="resulttype" value="single"/>
				<input name="fault" value="viewitem"/>	
			    							
			</action>	

			<action name="Query">
				<input name="sql" value="select * from task_log "/>
				<input name="prestr" value="query1"/>
				<input name="query1.task_log_help_desk_id.equ.int" value="!custom!query.item_id.equ.int"/>				
				<input name="name" value="restasklog"/>
				<input name="success" value="viewitem"/>
				<input name="fault" value="viewitem"/>	
			</action>	
			
			
		</command>		

		<!--所有问题-->
		<command name="allitem" allow="true">
				<action name="Dict"><input name="name" value= "helpdeskitemtype" /></action>
				<action name="Dict"><input name="name" value= "helpdeskitemstatus" /></action>
				<action name="Query">
					<input name="sql" value="select item_calltype,item_status,count(*) as item_count from helpdesk_items group by item_calltype,item_status"/>
					<input name="name" value="res"/>
					<input name="success" value="allitem"/>
					<input name="fault" value="allitem"/>	
				</action>				
		</command>			

		<!--查询问题-->
		<command name="queryitem" transparam="true" allow="true">
				<command name="querydict"/>
				<action name="Query">
					<input name="sql" value="select * from helpdesk_items "/>
					<input name="name" value="res"/>
					<input name="success" value="queryitem"/>
					<input name="fault" value="queryitem"/>	
				</action>				
		</command>
	
		<!--更新问题-->
		<command name="updateitem" allow="true">
			<command name="viewitem"/>
			<action name="GetCheck"><input name="name" value="item" /></action>
			<action name="Forward"><input name="view" value="updateitem"/></action>
		</command>

		 <command name="doupdateitem" allow="true">
				<action name="Update">
					<input name="tablename" value="helpdesk_items"/>
					<input name="query.item_id.equ.int" value="!custom!key.item_id.int"/>
					<input name="success" value="[viewitem]"/>
					<input name="fault" value="updateitem"/>	
				</action>			
		  </command>

		<!--删除问题-->
		<command name="delitem" dbtrans="true">
				<action name="Del">
					<input name="tablename" value="helpdesk_items"/>
				</action>
				<action name="Del">
					<input name="prekey" value="key1"/>
					<input name="key1.task_log_help_desk_id.equ.int" value="!custom!key.item_id.int"/>				
					<input name="tablename" value="task_log"/>
					<input name="success" value="[queryitem]"/>
					<input name="fault" value="[viewitem]"/>
				</action>
				
										
		</command>		

	
		<!--增加日志-->
		<command name="doaddlog" dbtrans="true" allow="true">
				<action name="Insert">
					<input name="tablename" value="task_log"/>
					<input name="query.item_id.equ.int" value="!custom!modle.task_log_help_desk_id" set="true"/>			
					<input name="success" value="viewitem"/>
					<input name="fault" value="viewitem"/>				
				</action>
				
				<action name="Update">
					<input name="key.item_id.int" value="!custom!modle.task_log_help_desk_id"/>							
					<input name="tablename" value="helpdesk_items"/>
					<input name="modle1.item_modified" value="!now!"/>				
					<input name="prestr" value="modle1"/>				
				</action>
				<command name="viewitem"/>					
		</command>
	
		<!--删除日志-->
		<command name="dellog">
				<action name="Del">
					<input name="tablename" value="task_log"/>
				</action>
				<command name="viewitem"/>
		</command>	

</commands>

	<validators>
		<validator name="item">
			<expression value="len(item_title)&gt;=1" msg="标题不能为空" />
			<expression value="isemail(item_requestor_email) || len(item_requestor_email)==0" msg="email格式不正确" />
			<expression value="isphone(item_requestor_phone) || len(item_requestor_phone)==0" msg="电话号码填写不正确" />
			<expression value="len(item_summary)" msg="简介不能为空" />
		</validator>
		<validator name="log">
			<expression value="len(task_log_name)&gt;=1" msg="简介不能为空" />
			<expression value="isdouble(task_log_hours)" msg="工作小时数格式不对" />
			<expression value="len(task_log_description)" msg="概述不能为空" />
		</validator>
	</validators>

</jvc>