1 neenan 1.1 <!--- Name: act_displayOrgInfo.cfm
2 Purpose: This functions as the action file in the to pull up the record of the currently added organization from the
3 Dorganization,dservices and dprogramtypes tables.The form also gives the user a way to edit the existing
4 information about the organization and contact details.In the edit mode, the visitor id for this organization is
5 extracted using a query GetProgramdetails.The information is passed onto the first input form of Dsp_addUser.cfm.
6 Date created: 02/24/2005
7 Dependancy: URL.Vid - visitor Id - used only in the editing of the initial user.
8 Variables:
9
10 Functions:
11 Date changed:
12 02/24/2005 Prabin & Neena Created & Documentation
|
13 neenan 1.2 03/11/2005 Neena Made changes to the display of organization information on line 99.
|
14 neenan 1.3 03/24/2005 Neena Enhancements included if the organization does not have a graphic URl and viceversa.
15 --->
|
16 neenan 1.1
17 <cfquery name="provider" datasource="#programsdb#">
18 SELECT *
19 FROM dOrganization
20 WHERE OrgID=#URL.OrgID#
21 </cfquery>
22
23 <CFQUERY name="displayProgramDetails" datasource="#programsdb#">
24 select distinct *
25 from dorganization
26 where OrgID=#URL.OrgID#
27 </CFQUERY>
28
29
30 <CFQUERY name="displayProgramContacts" datasource="#programsdb#">
31 select distinct *
32 from dcontacts
33 where OrgID=#URL.OrgID#
34 </CFQUERY>
35
36 <cfquery name="DisPlayProgramType" datasource="#programsdb#">
37 neenan 1.1 select *
38 from dOrganization o, dOrgtoProgramtype op, dProgramTypes p
39 where o.orgID=op.orgID and op.ProgramTypeID=p.ProgramTypeID and o.OrgID=#URL.OrgID#
40 </cfquery>
41
42 <cfquery name="DisplayProgramGeo" datasource="#programsdb#">
43 select *
44 from dOrganization o, Geoservices g
45 where o.GeoServiceID=g.GeoServiceID and o.OrgID=#URL.OrgID#
46
47 </cfquery>
48
49 <cfquery name="DisPlayProgramExpertise" datasource="#programsdb#">
50 select *
51 from dService s, dOrgtoService os, dOrganization o
52 where o.orgID=os.orgID and os.ServiceID=s.ServiceID and s.type='Expertise' and o.OrgID=#URL.OrgID#
53 </cfquery>
54
55 <cfquery name="DisPlayProgramClients" datasource="#programsdb#">
56 select *
57 from dService s, dOrgtoService os, dOrganization o
58 neenan 1.1 where o.orgID=os.orgID and os.ServiceID=s.ServiceID and s.type='Clients' and o.OrgID=#URL.OrgID#
59 </cfquery>
60
61 <cfquery name="DisPlayProgramResource" datasource="#programsdb#">
62 select *
63 from dService s, dOrgtoService os, dOrganization o
64 where o.orgID=os.orgID and os.ServiceID=s.ServiceID and s.type='Resources' and o.OrgID=#URL.OrgID#
65 </cfquery>
66
67
68 <cfquery name="memo1" datasource="#programsdb#">
69 select * from dOrganization
70 where OrgID=#URL.OrgID#
71 </cfquery>
72
73 <table width="100%" border="0" cellspacing="0" cellpadding="10" name="text">
74 <tr>
75 <td>
76 <p>
|
77 neenan 1.3 <!--- <span class="subheading"> --->
78 ADD A PROGRAM -> <!--- <img src="../images/siteimage/dart.gif" border="0"> --->
79 CONFIRMATION PAGE - <!--- <img src="../images/siteimage/dart.gif" border="0"></span> --->
80 Step 5 <!--- <img src="../images/siteimage/dart.gif" border="0"></span> ---><br><br>
|
81 neenan 1.1
82 <!-- #BeginEditable "Content" -->
83 <table width="95%" border="0" cellspacing="0" cellpadding="5" bgcolor="#F4FFE9">
84 <p><strong>Following is the information you have submitted. It will take us 1-2 business days to update the information on our site. Thank You.</strong><br><br>
85
|
86 neenan 1.2 <!--- <cfoutput query="displayProgramDetails">
|
87 neenan 1.1 <cfif #GraphicURL# is not "">
88 <tr>
89 <td valign="top" height="80"><p><a href="#URL#"><img src="#GraphicURL#" alt="#OrganizationName#" border="0" vspace="2"></a></td>
|
90 neenan 1.2 <cfif #URl.fuseaction# is "editfinalprocess" or #URL.fuseaction# is "FinalProcess">
|
91 neenan 1.1 <td align="left"><a href="AddEditPrograms.cfm?FuseAction=Edit&Vid=<cfoutput>#displayProgramDetails.visitor_Id#</cfoutput>&OrgID=<cfoutput>#URL.OrgID#</cfoutput>" class="subheading">Edit your program</a></td>
92 <cfelseif #URl.fuseaction# is "editfinalprocess1">
93 <td align="left"><a href="AddEditPrograms.cfm?FuseAction=EditOrg&OrgID=<cfoutput>#URL.OrgID#</cfoutput>" class="subheading">Edit your program</a></td>
94 </cfif>
95
96 </tr>
97 </cfif>
|
98 neenan 1.2 </cfoutput>
99 --->
100 <cfoutput query="displayProgramDetails">
101 <cfset graURL = #GraphicURL#>
102 <cfset visitor =#visitor_ID#>
|
103 neenan 1.3 <cfset url1 =#URL#>
|
104 neenan 1.2 <cfset orgname =#OrganizationName#>
105 </cfoutput>
106
|
107 neenan 1.3 <tr>
|
108 neenan 1.2 <cfif #URl.fuseaction# is "editfinalprocess">
|
109 neenan 1.3 <td align="right"><a href="Include your program directory page here programs.cfm" class="subheading">Return to Program Directory</a><br><a href="AddEditPrograms.cfm?FuseAction=Edit&Vid=<cfoutput>#visitor#</cfoutput>&OrgID=<cfoutput>#URL.OrgID#</cfoutput>" class="subheading">Edit your program</a></td>
110 <cfelseif #URL.fuseaction# is "FinalProcess">
111 <td align="right"><a href="Include your program directory page here programs.cfm" class="subheading">Return to Program Directory</a><br><a href="AddEditPrograms.cfm?FuseAction=Edit&Vid=<cfoutput>#visitor#</cfoutput>&OrgID=<cfoutput>#URL.OrgID#</cfoutput>" class="subheading">Edit your program</a></td>
|
112 neenan 1.2 <cfelseif #URl.fuseaction# is "editfinalprocess1">
|
113 neenan 1.3 <td align="right"><a href="Include your program directory page here programs.cfm" class="subheading">Return to Program Directory</a><br><a href="AddEditPrograms.cfm?FuseAction=EditOrg&OrgID=<cfoutput>#URL.OrgID#</cfoutput>" class="subheading">Edit your program</a></td>
|
114 neenan 1.2 </cfif>
|
115 neenan 1.3 </tr>
116
117 <cfif #graURL# is not "">
118 <tr>
119 <cfif #graURL# is not "http://" AND #url1# is not "http://"> <!--- case when both Graphic URl and URl are valid --->
120 <cfoutput query="displayProgramDetails"><td valign="top" height="80"><p><a href="#URL#"><img src="#GraphicURL#" alt="#OrganizationName#" border="0" vspace="2"></a></td></cfoutput>
121 <cfelseif #url1# EQ "http://" AND #graURL# is not "http://"> <!--- case when URL is not valid but graURl is valid or present --->
122 <cfoutput query="displayProgramDetails"><td valign="top" height="80"><p><img src="#GraURL#" border="0" vspace="2"></td></cfoutput>
123
124 </cfif>
|
125 neenan 1.2 </tr>
126 </cfif>
|
127 neenan 1.3
|
128 neenan 1.2
|
129 neenan 1.1 <tr><td valign="top">
130 <p>
|
131 neenan 1.3 <cfif #url1# EQ "http://" OR #url1# EQ "">
132 <cfoutput query="DisplayProgramDetails"><Strong>#OrganizationName#</STRONG> </cfoutput>
133 <cfelseif #graURL# EQ "http://"> <!--- case when graURL is not valid but URl is valid or present --->
134 <cfoutput query="DisplayProgramDetails"><a href="#URL#" class="subheading">#OrganizationName#</a></cfoutput>
135 <cfelse>
136 <cfoutput query="DisplayProgramDetails"><a href="#URL#" class="subheading">#OrganizationName#</a></cfoutput>
137 </cfif>
|
138 neenan 1.1 <!---information display start--->
139 <p>
140
141 <cfoutput query="memo1">#profile#<p></cfoutput><p>
142
143 <!--- Division --->
144 <cfoutput query="displayprogramdetails">
145 <cfif #Division# is not "">
146 <span class="bold">Division</span><br>
147 #Division#
148 </cfif>
149 </cfoutput>
150
151 <!--- Expertise --->
152 <cfset counter = 1>
153 <cfoutput query="DisplayProgramExpertise">
154 <cfif #DisplayProgramExpertise.RecordCount# is not 0 and counter is 1>
155 <span class="tableheading"><p><span class="bold">Expertise</span><br>
156 <cfset counter = 2>
157 </cfif>
158 <cfif #DisplayProgramExpertise.RecordCount# is not 0>
159 neenan 1.1 #Service#,
160 </cfif>
161 </cfoutput>
162 <cfset counter = 1>
163 <cfoutput query="DisplayProgramExpertise">
164 <cfif #DisplayProgramExpertise.RecordCount# is not 0 and counter is 1>
165 <br><br>
166 <cfset counter = 2>
167 </cfif>
168 </cfoutput>
169
170 <!--- Clients --->
171 <cfset counter = 1>
172 <cfoutput query="DisplayProgramClients">
173 <cfif #DisplayProgramClients.RecordCount# is not 0 and counter is 1>
174 <span class="bold">Clients</span><br>
175 <cfset counter = 2>
176 </cfif>
177 <cfif #DisplayProgramClients.RecordCount# is not 0>
178 #Service#,
179 </cfif>
180 neenan 1.1 </cfoutput>
181 <cfset counter = 1>
182 <cfoutput query="DisplayProgramClients">
183 <cfif #DisplayProgramClients.RecordCount# is not 0 and counter is 1>
184 <br><br>
185 <cfset counter = 2>
186 </cfif>
187 </cfoutput>
188
189
190 <!--- Resources --->
191 <cfset counter = 1>
192 <cfoutput query="DisplayProgramResource">
193 <cfif #DisplayProgramResource.RecordCount# is not 0 and counter is 1>
194 <span class="bold">Resources</span><br>
195 <cfset counter = 2>
196 </cfif>
197 <cfif #DisplayProgramResource.RecordCount# is not 0>
198 #Service#,
199 </cfif>
200 </cfoutput>
201 neenan 1.1 <cfset counter = 1>
202 <cfoutput query="DisplayProgramResource">
203 <cfif #DisplayProgramResource.RecordCount# is not 0 and counter is 1>
204 <br><br>
205 <cfset counter = 2>
206 </cfif>
207 </cfoutput>
208
209 <!--- Program Type --->
210 <cfset counter = 1>
211 <cfoutput query="DisplayProgramType">
212 <cfif #DisplayProgramType.RecordCount# is not 0 and counter is 1>
213 <span class="bold">Program Type</span><br>
214 <cfset counter = 2>
215 </cfif>
216 <cfif #DisplayProgramType.RecordCount# is not 0>
217 #ProgramType#,
218 </cfif>
219 </cfoutput>
220 <cfset counter = 1>
221 <cfoutput query="DisplayProgramType">
222 neenan 1.1 <cfif #DisplayProgramType.RecordCount# is not 0 and counter is 1>
223 <br><br>
224 <cfset counter = 2>
225 </cfif>
226 </cfoutput>
227
228 <!--- Service Area --->
229 <cfset counter = 1>
230 <cfoutput query="DisplayProgramGeo">
231 <cfif #DisplayProgramGeo.RecordCount# is not 0 and counter is 1>
232 <span class="bold">Service Area</span><br>
233 <cfset counter = 2>
234 </cfif>
235 <cfif #GeoService# is not "">
236 #GeoService#
237 </cfif>
238 </cfoutput>
239 <cfset counter = 1>
240 <cfoutput query="DisplayProgramGeo">
241 <cfif #DisplayProgramGeo.RecordCount# is not 0 and counter is 1>
242 <br><br>
243 neenan 1.1 <cfset counter = 2>
244 </cfif>
245 </cfoutput>
246
247 <cfoutput query="DisplayProgramContacts">
248 <span class="bold">#Title#</span><br>
249 #prefix# #FirstName# #Middle# #lastName#
250 <cfif #Address# is not ""><br>#Address#</cfif>
251 <cfif #City# is not ""><br>#City#,</cfif><cfif #state#is not "">#State#</cfif><cfif #zip# is not ""> #zip#</cfif>
252 <cfif #WorkPhone# is not ""><br>#WorkPhone#</cfif> <cfif #workExtension# is not ""> x#workExtension#</cfif>
253 <cfif #MobilePhone# is not "">
254 <br>MOBILE TEL: #MobilePhone#</cfif>
255 <cfif #FaxNumber# is not "">
256 <br>FAX: #FaxNumber#</cfif>
257 <cfif #emailName# is not "">
258 <br><a href="mailto:#emailName#" class="subheading">#emailName#</a></cfif><br><br></cfoutput>
259
260
261 <cfoutput query="DisplayProgramDetails">
262 <span class="bold">Contact Information</span>
263 <br>#Division#
264 neenan 1.1 <br>#Address1#
265 <cfif #Address2# is not "">
266 <br>#Address2#</cfif>
267 <br>#City#, #StateOrProvince# #PostalCode#
268 <br>#Region# #country#
269 <br>Timezone: #timezone#
270 <br>#phone# <cfif #extension# is not "">ext:#extension#</cfif>
271 <cfif #hotline# is not "">
272 <br>Hotline: #hotline#</cfif>
273 <cfif #FaxNumber# is not "">
274 <br>FAX: #FaxNumber#</cfif>
275 <br><a href="mailto:#emailName#" class="subheading">#emailName#</a>
276 </cfoutput>
277
278 </p>
279 </td>
280 </tr>
281 </table>
282
283 </td>
284 </tr>
285 neenan 1.1 <tr>
286 <td> </td>
287 </tr>
288 <tr>
289 <td> </td>
290 </tr>
291 </table>
292 </p>
293
294
295
|
Return to
act_displayOrgInfo.cfm
CVS log
Up to [Development] / p2rx-programs