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