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 --->
|
15 neenan 1.1
16 <cfquery name="provider" datasource="#programsdb#">
17 SELECT *
18 FROM dOrganization
19 WHERE OrgID=#URL.OrgID#
20 </cfquery>
21
22 <CFQUERY name="displayProgramDetails" datasource="#programsdb#">
23 select distinct *
24 from dorganization
25 where OrgID=#URL.OrgID#
26 </CFQUERY>
27
28
29 <CFQUERY name="displayProgramContacts" datasource="#programsdb#">
30 select distinct *
31 from dcontacts
32 where OrgID=#URL.OrgID#
33 </CFQUERY>
34
35 <cfquery name="DisPlayProgramType" datasource="#programsdb#">
36 neenan 1.1 select *
37 from dOrganization o, dOrgtoProgramtype op, dProgramTypes p
38 where o.orgID=op.orgID and op.ProgramTypeID=p.ProgramTypeID and o.OrgID=#URL.OrgID#
39 </cfquery>
40
41 <cfquery name="DisplayProgramGeo" datasource="#programsdb#">
42 select *
43 from dOrganization o, Geoservices g
44 where o.GeoServiceID=g.GeoServiceID and o.OrgID=#URL.OrgID#
45
46 </cfquery>
47
48 <cfquery name="DisPlayProgramExpertise" datasource="#programsdb#">
49 select *
50 from dService s, dOrgtoService os, dOrganization o
51 where o.orgID=os.orgID and os.ServiceID=s.ServiceID and s.type='Expertise' and o.OrgID=#URL.OrgID#
52 </cfquery>
53
54 <cfquery name="DisPlayProgramClients" datasource="#programsdb#">
55 select *
56 from dService s, dOrgtoService os, dOrganization o
57 neenan 1.1 where o.orgID=os.orgID and os.ServiceID=s.ServiceID and s.type='Clients' and o.OrgID=#URL.OrgID#
58 </cfquery>
59
60 <cfquery name="DisPlayProgramResource" datasource="#programsdb#">
61 select *
62 from dService s, dOrgtoService os, dOrganization o
63 where o.orgID=os.orgID and os.ServiceID=s.ServiceID and s.type='Resources' and o.OrgID=#URL.OrgID#
64 </cfquery>
65
66
67 <cfquery name="memo1" datasource="#programsdb#">
68 select * from dOrganization
69 where OrgID=#URL.OrgID#
70 </cfquery>
71
72 <table width="100%" border="0" cellspacing="0" cellpadding="10" name="text">
73 <tr>
74 <td>
75 <p>
76 <span class="subheading">
77 ADD A PROGRAM <img src="../images/siteimage/dart.gif" border="0">
78 neenan 1.1 CONFIRMATION PAGE <img src="../images/siteimage/dart.gif" border="0"></span>
79 <span class="sublink2">Step 5 <img src="../images/siteimage/dart.gif" border="0"></span><br><br>
80
81 <!-- #BeginEditable "Content" -->
82 <table width="95%" border="0" cellspacing="0" cellpadding="5" bgcolor="#F4FFE9">
83 <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>
84
|
85 neenan 1.2 <!--- <cfoutput query="displayProgramDetails">
|
86 neenan 1.1 <cfif #GraphicURL# is not "">
87 <tr>
88 <td valign="top" height="80"><p><a href="#URL#"><img src="#GraphicURL#" alt="#OrganizationName#" border="0" vspace="2"></a></td>
|
89 neenan 1.2 <cfif #URl.fuseaction# is "editfinalprocess" or #URL.fuseaction# is "FinalProcess">
|
90 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>
91 <cfelseif #URl.fuseaction# is "editfinalprocess1">
92 <td align="left"><a href="AddEditPrograms.cfm?FuseAction=EditOrg&OrgID=<cfoutput>#URL.OrgID#</cfoutput>" class="subheading">Edit your program</a></td>
93 </cfif>
94
95 </tr>
96 </cfif>
|
97 neenan 1.2 </cfoutput>
98 --->
99 <cfoutput query="displayProgramDetails">
100 <cfset graURL = #GraphicURL#>
101 <cfset visitor =#visitor_ID#>
102 <cfset url =#URL#>
103 <cfset orgname =#OrganizationName#>
104 </cfoutput>
105
106 <cfif #graURL# is not "">
107 <tr>
108 <cfoutput query="displayProgramDetails"><td valign="top" height="80"><p><a href="#URL#"><img src="#GraphicURL#" alt="#OrganizationName#" border="0" vspace="2"></a></td></cfoutput>
109 <cfif #URl.fuseaction# is "editfinalprocess">
110 <td align="left"><a href="AddEditPrograms.cfm?FuseAction=Edit&Vid=<cfoutput>#visitor#</cfoutput>&OrgID=<cfoutput>#URL.OrgID#</cfoutput>" class="subheading">Edit your program</a></td>
111 <cfelseif #URL.fuseaction# is "FinalProcess">
112 <td align="left"><a href="AddEditPrograms.cfm?FuseAction=Edit&Vid=<cfoutput>#visitor#</cfoutput>&OrgID=<cfoutput>#URL.OrgID#</cfoutput>" class="subheading">Edit your program</a></td>
113 <cfelseif #URl.fuseaction# is "editfinalprocess1">
114 <td align="left"><a href="AddEditPrograms.cfm?FuseAction=EditOrg&OrgID=<cfoutput>#URL.OrgID#</cfoutput>" class="subheading">Edit your program</a></td>
115 </cfif>
116
117 </tr>
118 neenan 1.2 </cfif>
119
120
|
121 neenan 1.1 <tr><td valign="top">
122 <p>
123 <cfoutput query="DisplayProgramDetails"><a href="#URL#" class="subheading">#OrganizationName#</a>
124
125 </cfoutput></span>
126 <!---information display start--->
127 <p>
128
129 <cfoutput query="memo1">#profile#<p></cfoutput><p>
130
131 <!--- Division --->
132 <cfoutput query="displayprogramdetails">
133 <cfif #Division# is not "">
134 <span class="bold">Division</span><br>
135 #Division#
136 </cfif>
137 </cfoutput>
138
139 <!--- Expertise --->
140 <cfset counter = 1>
141 <cfoutput query="DisplayProgramExpertise">
142 neenan 1.1 <cfif #DisplayProgramExpertise.RecordCount# is not 0 and counter is 1>
143 <span class="tableheading"><p><span class="bold">Expertise</span><br>
144 <cfset counter = 2>
145 </cfif>
146 <cfif #DisplayProgramExpertise.RecordCount# is not 0>
147 #Service#,
148 </cfif>
149 </cfoutput>
150 <cfset counter = 1>
151 <cfoutput query="DisplayProgramExpertise">
152 <cfif #DisplayProgramExpertise.RecordCount# is not 0 and counter is 1>
153 <br><br>
154 <cfset counter = 2>
155 </cfif>
156 </cfoutput>
157
158 <!--- Clients --->
159 <cfset counter = 1>
160 <cfoutput query="DisplayProgramClients">
161 <cfif #DisplayProgramClients.RecordCount# is not 0 and counter is 1>
162 <span class="bold">Clients</span><br>
163 neenan 1.1 <cfset counter = 2>
164 </cfif>
165 <cfif #DisplayProgramClients.RecordCount# is not 0>
166 #Service#,
167 </cfif>
168 </cfoutput>
169 <cfset counter = 1>
170 <cfoutput query="DisplayProgramClients">
171 <cfif #DisplayProgramClients.RecordCount# is not 0 and counter is 1>
172 <br><br>
173 <cfset counter = 2>
174 </cfif>
175 </cfoutput>
176
177
178 <!--- Resources --->
179 <cfset counter = 1>
180 <cfoutput query="DisplayProgramResource">
181 <cfif #DisplayProgramResource.RecordCount# is not 0 and counter is 1>
182 <span class="bold">Resources</span><br>
183 <cfset counter = 2>
184 neenan 1.1 </cfif>
185 <cfif #DisplayProgramResource.RecordCount# is not 0>
186 #Service#,
187 </cfif>
188 </cfoutput>
189 <cfset counter = 1>
190 <cfoutput query="DisplayProgramResource">
191 <cfif #DisplayProgramResource.RecordCount# is not 0 and counter is 1>
192 <br><br>
193 <cfset counter = 2>
194 </cfif>
195 </cfoutput>
196
197 <!--- Program Type --->
198 <cfset counter = 1>
199 <cfoutput query="DisplayProgramType">
200 <cfif #DisplayProgramType.RecordCount# is not 0 and counter is 1>
201 <span class="bold">Program Type</span><br>
202 <cfset counter = 2>
203 </cfif>
204 <cfif #DisplayProgramType.RecordCount# is not 0>
205 neenan 1.1 #ProgramType#,
206 </cfif>
207 </cfoutput>
208 <cfset counter = 1>
209 <cfoutput query="DisplayProgramType">
210 <cfif #DisplayProgramType.RecordCount# is not 0 and counter is 1>
211 <br><br>
212 <cfset counter = 2>
213 </cfif>
214 </cfoutput>
215
216 <!--- Service Area --->
217 <cfset counter = 1>
218 <cfoutput query="DisplayProgramGeo">
219 <cfif #DisplayProgramGeo.RecordCount# is not 0 and counter is 1>
220 <span class="bold">Service Area</span><br>
221 <cfset counter = 2>
222 </cfif>
223 <cfif #GeoService# is not "">
224 #GeoService#
225 </cfif>
226 neenan 1.1 </cfoutput>
227 <cfset counter = 1>
228 <cfoutput query="DisplayProgramGeo">
229 <cfif #DisplayProgramGeo.RecordCount# is not 0 and counter is 1>
230 <br><br>
231 <cfset counter = 2>
232 </cfif>
233 </cfoutput>
234
235 <cfoutput query="DisplayProgramContacts">
236 <span class="bold">#Title#</span><br>
237 #prefix# #FirstName# #Middle# #lastName#
238 <cfif #Address# is not ""><br>#Address#</cfif>
239 <cfif #City# is not ""><br>#City#,</cfif><cfif #state#is not "">#State#</cfif><cfif #zip# is not ""> #zip#</cfif>
240 <cfif #WorkPhone# is not ""><br>#WorkPhone#</cfif> <cfif #workExtension# is not ""> x#workExtension#</cfif>
241 <cfif #MobilePhone# is not "">
242 <br>MOBILE TEL: #MobilePhone#</cfif>
243 <cfif #FaxNumber# is not "">
244 <br>FAX: #FaxNumber#</cfif>
245 <cfif #emailName# is not "">
246 <br><a href="mailto:#emailName#" class="subheading">#emailName#</a></cfif><br><br></cfoutput>
247 neenan 1.1
248
249 <cfoutput query="DisplayProgramDetails">
250 <span class="bold">Contact Information</span>
251 <br>#Division#
252 <br>#Address1#
253 <cfif #Address2# is not "">
254 <br>#Address2#</cfif>
255 <br>#City#, #StateOrProvince# #PostalCode#
256 <br>#Region# #country#
257 <br>Timezone: #timezone#
258 <br>#phone# <cfif #extension# is not "">ext:#extension#</cfif>
259 <cfif #hotline# is not "">
260 <br>Hotline: #hotline#</cfif>
261 <cfif #FaxNumber# is not "">
262 <br>FAX: #FaxNumber#</cfif>
263 <br><a href="mailto:#emailName#" class="subheading">#emailName#</a>
264 </cfoutput>
265
266 </p>
267 </td>
268 neenan 1.1 </tr>
269 </table>
270
271 </td>
272 </tr>
273 <tr>
274 <td> </td>
275 </tr>
276 <tr>
277 <td> </td>
278 </tr>
279 </table>
280 </p>
281
282
283
|
Return to
act_displayOrgInfo.cfm
CVS log
Up to [Development] / p2rx-programs