Return to dsp_addservices.cfm CVS log

Up to [Development] / p2rx-programs

Enhancements made to resolve programs added or udpated by Outsite users.

<!--- 	Name:  dsp_addservices.cfm
    	Purpose: It helps to retreive the services offered by default for each program, it also provides the user to add a new service of type
		resource, expertise or client. These fields are extracted each time the page is loaded from the dservices database.
		It also transfers all the form variables to act_addservices.cfm. The name of the existing services are extracted from the preapproved services in the 
		service table and the final service choices are stored in the dservices and the dOrgtoService tables.

		Date created: 02/23/2005
       	Dependancy: URL.Orgid 
		Variables: 	ServiceID - Primary Key for each of the services to display the checkbox on the form.
					Service - Name of the service existing in the Service database
					OtherExpertise - Other New Expertise, entered by the current user. 
					OtherResources - Other New Resource, entered by the current user.
					OtherClients - Other New Client , entered by the current user.
					
		Functions: 
		Date changed: 
					02/23/2005			Prabin & Neena  Created
					02/23/2005			Neena		    Documentation
					08/15/2005			Terry			Added URL variable for skipping step (line 60)
					08/15/2005			Terry			Documentation
---> 
<cfquery name="expservices" datasource="#programsdb#">
Select Service, ServiceID, Type
From Service
Where Type = 'Expertise' and Approved = 0
</cfquery>

<cfquery name="cliservices" datasource="#programsdb#">
Select Service, ServiceID, Type
From Service
Where Type = 'Clients' and Approved = 0
</cfquery>

<cfquery name="resservices" datasource="#programsdb#">
Select Service, ServiceID, Type
From Service
Where Type = 'Resources' and Approved = 0
</cfquery>


<cfquery name="getORG" datasource="#Programsdb#">
	SELECT 	OrganizationName
	FROM	dOrganization
	WHERE	OrgID = #URL.OrgID#
</cfquery>

<table width="100%" border="0" cellspacing="0" cellpadding="10" name="text">
        <tr> 
          <td> 
            <p>	
			<span class="subheading">
				ADD A PROGRAM <img src="../images/siteimage/dart.gif" border="0">
				SERVICES<img src="../images/siteimage/dart.gif" border="0"></span> &nbsp;
				<span class="sublink2">Step 4<img src="../images/siteimage/dart.gif" border="0"></span><br><br>
				<cfoutput query="getORG">Organization Name: &nbsp;&nbsp;&nbsp; <strong>#OrganizationName#</strong></cfoutput><br><br>
		
				Please select the service(s) which describe your organization.<br>
				<span class="redtext"><font style="color: red">* At least One</font></span><br><br>

<form name="addservices" action="addeditprograms.cfm?fuseaction=FinalProcess&OrgID=<cfoutput>#URL.OrgID#</cfoutput>&skip=0" onsubmit="return Validate1(this)" method="post">
<table width="95%" border="0" cellspacing="0" cellpadding="5" bgcolor="#F4FFE9">
		<tr>
			<td valign="top">
				<div class="formtext"><strong>Area of Expertise</strong></div><br>
						<cfoutput><div class="formtext"><br>
							<cfloop query="expservices">
								<input type="checkbox" name="ServiceID" value="#ServiceID#">
								#Service#<br>
							</cfloop>
							<input type="checkbox" name="OtherExpertise"> Other 
						 	<input type="text" size=10 name="Other1"> </div>
						</cfoutput>
			</td>

			<td valign="top">
				<div class="formtext"><strong>Resources Offered</strong></div><br>
					
					<cfoutput><div class="formtext">
						<cfloop query="resservices">
								<input type="checkbox" name="ServiceID" value="#ServiceID#">
								#Service#<br>
						</cfloop>
							<input type="checkbox" name="OtherResources"> Other
							<input type="text" size=10 name="Other2"> </div>
					</cfoutput>
			<!--- </td>

			<td valign="top"> ---><br>
				<div class="formtext"><strong>Clients Served</strong></div><br>
					<cfoutput><div class="formtext">
						<cfloop query="cliservices">
						  <input type="checkbox" name="ServiceID" value="#ServiceID#">
						  #Service#<br>
						</cfloop>
						<input type="checkbox" name="OtherClients"> Other
						<input type="text" size=10 name="Other3"></div>
					</cfoutput>
			</td>
		</tr>
		<tr> 
      		<td>&nbsp;<cfoutput>
						<input type="hidden" name="OrgID" value="URL.OrgID">
					</cfoutput>
				
			</td>
    	</tr>
		<tr> 
      		<td colspan="2"><div class="formtext">
				<INPUT type="submit" value="Submit">
	  			<INPUT type="reset" value="Reset"></div>
			</td>
    	</tr>
</table>
</form>
</table>