1 neenan 1.1 <!--- Name: dsp_addservices.cfm
2 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
3 resource, expertise or client. These fields are extracted each time the page is loaded from the dservices database.
4 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
5 service table and the final service choices are stored in the dservices and the dOrgtoService tables.
6
7 Date created: 02/23/2005
8 Dependancy: URL.Orgid
9 Variables: ServiceID - Primary Key for each of the services to display the checkbox on the form.
10 Service - Name of the service existing in the Service database
11 OtherExpertise - Other New Expertise, entered by the current user.
12 OtherResources - Other New Resource, entered by the current user.
13 OtherClients - Other New Client , entered by the current user.
14
15 Functions:
16 Date changed:
17 02/23/2005 Prabin & Neena Created
18 02/23/2005 Neena Documentation
|
19 neenan 1.2 03/22/2005 Neena Commented out the Span and image reference tags
|
20 neenan 1.1 --->
21 <cfquery name="expservices" datasource="#programsdb#">
22 Select Service, ServiceID, Type
23 From Service
24 Where Type = 'Expertise' and Approved = 0
25 </cfquery>
26
27 <cfquery name="cliservices" datasource="#programsdb#">
28 Select Service, ServiceID, Type
29 From Service
30 Where Type = 'Clients' and Approved = 0
31 </cfquery>
32
33 <cfquery name="resservices" datasource="#programsdb#">
34 Select Service, ServiceID, Type
35 From Service
36 Where Type = 'Resources' and Approved = 0
37 </cfquery>
38
39
40 <cfquery name="getORG" datasource="#Programsdb#">
41 neenan 1.1 SELECT OrganizationName
42 FROM dOrganization
43 WHERE OrgID = #URL.OrgID#
44 </cfquery>
45
46 <table width="100%" border="0" cellspacing="0" cellpadding="10" name="text">
47 <tr>
48 <td>
49 <p>
|
50 neenan 1.2 <!--- <span class="subheading"> --->
51 ADD A PROGRAM -> <!--- <img src="../images/siteimage/dart.gif" border="0"> --->
52 SERVICES<!--- <img src="../images/siteimage/dart.gif" border="0"></span> --->
53 <!--- <span class="sublink2"> --->Step 4 <!--- <img src="../images/siteimage/dart.gif" border="0"></span> ---><br><br>
|
54 neenan 1.1 <cfoutput query="getORG">Organization Name: <strong>#OrganizationName#</strong></cfoutput><br><br>
55
56 Please select the service(s) which describe your organization.<br>
|
57 neenan 1.2 <!--- <span class="redtext"> ---><font style="color: red">* At least One</font><!--- </span> ---><br><br>
|
58 neenan 1.1
59 <form name="addservices" action="addeditprograms.cfm?fuseaction=FinalProcess&OrgID=<cfoutput>#URL.OrgID#</cfoutput>" onsubmit="return Validate1(this)" method="post">
60 <table width="95%" border="0" cellspacing="0" cellpadding="5" bgcolor="#F4FFE9">
61 <tr>
62 <td valign="top">
63 <div class="formtext"><strong>Area of Expertise</strong></div><br>
64 <cfoutput><div class="formtext"><br>
65 <cfloop query="expservices">
66 <input type="checkbox" name="ServiceID" value="#ServiceID#">
67 #Service#<br>
68 </cfloop>
69 <input type="checkbox" name="OtherExpertise"> Other
70 <input type="text" size=10 name="Other1"> </div>
71 </cfoutput>
72 </td>
73
74 <td valign="top">
75 <div class="formtext"><strong>Resources Offered</strong></div><br>
76
77 <cfoutput><div class="formtext">
78 <cfloop query="resservices">
79 neenan 1.1 <input type="checkbox" name="ServiceID" value="#ServiceID#">
80 #Service#<br>
81 </cfloop>
82 <input type="checkbox" name="OtherResources"> Other
83 <input type="text" size=10 name="Other2"> </div>
84 </cfoutput>
85 <!--- </td>
86
87 <td valign="top"> ---><br>
88 <div class="formtext"><strong>Clients Served</strong></div><br>
89 <cfoutput><div class="formtext">
90 <cfloop query="cliservices">
91 <input type="checkbox" name="ServiceID" value="#ServiceID#">
92 #Service#<br>
93 </cfloop>
94 <input type="checkbox" name="OtherClients"> Other
95 <input type="text" size=10 name="Other3"></div>
96 </cfoutput>
97 </td>
98 </tr>
99 <tr>
100 neenan 1.1 <td> <cfoutput>
101 <input type="hidden" name="OrgID" value="URL.OrgID">
102 </cfoutput>
103
104 </td>
105 </tr>
106 <tr>
107 <td colspan="2"><div class="formtext">
108 <INPUT type="submit" value="Submit">
109 <INPUT type="reset" value="Reset"></div>
110 </td>
111 </tr>
112 </table>
113 </form>
114 </table>
|
Return to
dsp_addservices.cfm
CVS log
Up to [Development] / p2rx-programs