<myweb createdb="true" dbname="dotproject">
	<views>

	    <view name="update" path="/jsp/project/company/updatecompany.jsp"/>
	    <view name="companyinfo" path="/jsp/project/company/companyinfo.jsp"/>
	    <view name="queryitem" path="/jsp/project/company/querycompany.jsp"/>	    	    
		<view name="add" path="/jsp/project/company/addcompany.jsp"/>
	    
	    <view name="updatecontact" path="/jsp/project/company/updatecontact.jsp"/>	    	    
	    <view name="addcontact" path="/jsp/project/company/addcontact.jsp"/>	    	    	    
	    <view name="del" path="/jsp/common/msg.jsp"/>	    	    	    	    
	</views>
	
	


	<controls>	
	
	
	
	
		<control name="add"  transparam="true">
			<action name="Forward"><input name="view" value="add"/></action>			
		</control>
		
		<control name="doadd">
			<action name="Insert">
				<input name="tablename" value="companies"/>
				<input name="sucess" value="add"/>
				<input name="fault" value="add"/>				
			</action>
		</control>

		<control name="doadd1">
			<action name="Insert">
				<input name="tablename" value="companies"/>
			</action>
					<control name="queryitem"/>
		</control>
	
	<control name="del">
			<action name="Del">
				<input name="tablename" value="companies"/>
			</action>
			<action name="Forward"><input name="view" value="del"/></action>						
	</control>	
		
		
		<control name="myitem">
			<action name="SysType"><input name="typename" value= "helpdeskitemstatus" /></action>
			<action name="SysType"><input name="typename" value= "helpdeskitempriority" /></action>
			
			<action name="Select">
				<input name="sql" value="select project_name,project_id from projects "/>
				<input name="name" value="project"/>			
			</action>

			<action name="Select">
				<input name="sql" value="select project_color_identifier,project_id from projects "/>
				<input name="name" value="color"/>			
			</action>


			<action name="Select">
				<input name="sql" value="select CONCAT(user_last_name,user_first_name),user_id from users "/>
				<input name="name" value="user"/>			
			</action>

						
			<action name="Query">
				<input name="sql" value="select * from helpdesk_items "/>
				<input name="query.item_created_by.equ.int" value="!id!"/>
				<input name="name" value="res"/>
				<input name="sucess" value="myitem"/>
				<input name="fault" value="myitem"/>				
			</action>	
			
	</control>		
	
	<control name="companyinfo">
			<action name="SysType"><input name="typename" value= "companytype" /></action>												
			<action name="Query">
				<input name="sql" value="select * from companies "/>
				<input name="name" value="res"/>
			    <input name="resulttype" value="single"/>			    							
			</action>
			<action name="Query">
				<input name="sql" value="select * from contacts,companies "/>
				<input name="where" value="where contact_company=company_name"/>
				<input name="name" value="rscontacts"/>
			    <input name="prestr" value="query1"/>
			    <input name="query1.company_id.int" value="!custom!query.company_id.equ.int"/>			    
			    <input name="resulttype" value="multy"/>				    
				<input name="sucess" value="companyinfo"/>
				<input name="fault" value="companyinfo"/>	
			</action>
	</control>		
	
	<control name="updatecontact">
		<action name="Query">
				<input name="sql" value="select * from contacts "/>
				<input name="name" value="res"/>
			    <input name="resulttype" value="single"/>			    							
				<input name="sucess" value="updatecontact"/>
				<input name="fault" value="updatecontact"/>				    
			</action>
	</control>
	  <control name="doupdatecontact">
			<action name="Update">
				<input name="tablename" value="contacts"/>
			</action>			
			<control name="companyinfo"/>								
	  </control>	
	  
	  
	<control name="addcontact" transparam="true">	
			<action name="Query">
				<input name="sql" value="select * from companies "/>
				<input name="name" value="res"/>
			    <input name="resulttype" value="single"/>			    							
			</action>
				
		<action name="Forward">
				<input name="view" value="addcontact"/>
			</action>
	</control>	  
	
	<control name="doaddcontact">
			<action name="Insert">
				<input name="tablename" value="contacts"/>
			</action>			
			<control name="companyinfo"/>		
		</control>	
		
<control name="delcontact">
			<action name="Del">
				<input name="tablename" value="contacts"/>
			</action>
			<control name="companyinfo"/>	
	</control>	
				
	
	<control name="queryitem" transparam="true">
			<action name="SysType"><input name="typename" value= "companytype" /></action>				
			<action name="Select">
				<input name="sql" value="select count(*) as cc,project_company from projects where project_active=1 group by project_company"/>
				<input name="name" value="projecton"/>			
			</action>
			<action name="Select">
				<input name="sql" value="select count(*) as cc,project_company from projects where project_active=0 group by project_company"/>
				<input name="name" value="projectoff"/>			
			</action>


						
			<action name="Query">
				<input name="sql" value="select * from companies "/>
				<input name="prestr" value="query"/>
				<input name="name" value="res"/>
				<input name="sucess" value="queryitem"/>
				<input name="fault" value="queryitem"/>	
			</action>				
	</control>				

	<control name="update">
			<action name="SysType"><input name="typename" value= "companytype" /></action>												
			<action name="Select">
				<input name="sql" value="select CONCAT(user_last_name,user_first_name),user_id from users "/>
				<input name="name" value="user"/>			
			</action>
			
			<action name="Query">
				<input name="sql" value="select * from companies "/>
				<input name="name" value="res"/>
				<input name="sucess" value="update"/>
				<input name="fault" value="update"/>	
			    <input name="resulttype" value="single"/>			    							
			</action>
	</control>		
		
	  <control name="doupdateback">
			<action name="Update">
				<input name="tablename" value="companies"/>
				<input name="sucess" value="companyinfo"/>
				<input name="fault" value="companyinfo"/>				
			</action>			
			<control name="companyinfo"/>								
	  </control>	
	  
	  <control name="doupdate">
			<action name="Update">
				<input name="tablename" value="companies"/>
				<input name="query.company_id.equ.int" value="!custom!key.company_id" />
			</action>	
			<control name="update"/>			
	  </control>		  
		
</controls>
</myweb>