neenan 1.1 <!--- 	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
            ---> 
            <cfquery name="expservices" datasource="#programsdb#">
            Select Service, ServiceID, Type
 neenan 1.1 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#
 neenan 1.1 </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>" 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>
 neenan 1.1 							<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>
 neenan 1.1 
            			<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> 
 neenan 1.1       		<td colspan="2"><div class="formtext">
            				<INPUT type="submit" value="Submit">
            	  			<INPUT type="reset" value="Reset"></div>
            			</td>
                	</tr>
            </table>
            </form>
            </table>