1 pKanel 1.1 <!--- Name: printpage.cfm
2 Purpose: It opens up a printer friendly page for display the details of programs.
3 Date created: 06/20/2005
4 Dependancy: called from details.cfm
5 Variables: OrgID
6 Functions:
7 Date changed:
8 06/20/2005 Prabin Created
9 --->
10
11
12 <cfset programsdb="programs">
13
14 <cfquery name="provider" datasource="#programsdb#">
15 SELECT *
16 FROM Organization
17 WHERE OrgID=#OrgID#
18 </cfquery>
19
20 <CFQUERY name="displayProgramDetails" datasource="#programsdb#">
21 select distinct *
22 pKanel 1.1 from organization
23 where OrgID=#OrgID#
24 </CFQUERY>
25
26
27 <CFQUERY name="displayProgramContacts" datasource="#programsdb#">
28 select distinct *
29 from contacts
30 where OrgID=#OrgID#
31 </CFQUERY>
32
33
34 <cfquery name="DisPlayProgramType" datasource="#programsdb#">
35 select *
36 from Organization o, OrgtoProgramtype op, ProgramTypes p
37 where o.orgID=op.orgID and op.ProgramTypeID=p.ProgramTypeID and o.OrgID=#OrgID#
38 </cfquery>
39
40
41
42 <cfquery name="DisplayProgramGeo" datasource="#programsdb#">
43 pKanel 1.1 select *
44 from Organization o, Geoservices g
45 where o.GeoServiceID=g.GeoServiceID and o.OrgID=#OrgID#
46
47 </cfquery>
48
49 <cfquery name="DisPlayProgramExpertise" datasource="#programsdb#">
50 select *
51 from Service s, OrgtoService os, Organization o
52 where o.orgID=os.orgID and os.ServiceID=s.ServiceID and s.type='Expertise' and o.OrgID=#OrgID#
53 </cfquery>
54
55 <cfquery name="DisPlayProgramClients" datasource="#programsdb#">
56 select *
57 from Service s, OrgtoService os, Organization o
58 where o.orgID=os.orgID and os.ServiceID=s.ServiceID and s.type='Clients' and o.OrgID=#OrgID#
59 </cfquery>
60
61 <cfquery name="DisPlayProgramResource" datasource="#programsdb#">
62 select *
63 from Service s, OrgtoService os, Organization o
64 pKanel 1.1 where o.orgID=os.orgID and os.ServiceID=s.ServiceID and s.type='Resources' and o.OrgID=#OrgID#
65 </cfquery>
66
67
68 <cfquery name="memo1" datasource="#programsdb#">
69 select * from organization
70 where OrgID=#OrgID#
71 </cfquery>
72
73 <html>
74 <head>
75 <title>Pollution Prevention Agencies and Programs</title>
76 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
77 <link rel="stylesheet" href="../css/newstyle.css" type="text/css">
78 </head>
79 <body leftmargin="20" topmargin="20" marginwidth="20" marginheight="20">
80
81 <img src="http://www.p2ric.org/images/p2ricshort.gif" alt="P2RIC logo"><font size="+2"><strong> Programs Directory</strong></font>
82 <p> <a href="details.cfm?OrgID=<cfoutput>#URL.ORgID#</cfoutput>">GO BACK</a></p>
83
84 <table width="100%" border="0" cellspacing="0" cellpadding="10" name="text">
85 pKanel 1.1 <cfoutput query="displayProgramDetails">
86 <cfif #GraphicURL# is not "">
87 <tr>
88 <td valign="top" height="80"><a href="#URL#"><img src="#GraphicURL#" alt="#OrganizationName#" border="0" vspace="2"></a></td>
89 </tr>
90 </cfif>
91 </cfoutput>
92 <tr><td valign="top">
93
94 <cfoutput query="DisplayProgramDetails"><a href="#URL#">#OrganizationName#</a><br><br>
95
96 </cfoutput>
97 <!---information display start--->
98
99
100 <cfoutput query="memo1">#profile#</cfoutput>
101
102 <!--- Start: if clauses are added by Daeho on 5/16/02 --->
103
104 <!--- Division --->
105 <cfoutput query="displayprogramdetails">
106 pKanel 1.1 <cfif #Division# is not "">
107 Division<br>
108 #Division#
109 </cfif>
110 </cfoutput>
111
112 <!--- Expertise --->
113 <cfset counter = 1>
114 <cfoutput query="DisplayProgramExpertise">
115 <cfif #DisplayProgramExpertise.RecordCount# is not 0 and counter is 1>
116 <strong><br><br> Expertise</strong><br>
117 <cfset counter = 2>
118 </cfif>
119 <cfif #DisplayProgramExpertise.RecordCount# is not 0>
120 #Service#,
121 </cfif>
122 </cfoutput>
123 <cfset counter = 1>
124 <cfoutput query="DisplayProgramExpertise">
125 <cfif #DisplayProgramExpertise.RecordCount# is not 0 and counter is 1>
126 <br><br>
127 pKanel 1.1 <cfset counter = 2>
128 </cfif>
129 </cfoutput>
130
131 <!--- Clients --->
132 <cfset counter = 1>
133 <cfoutput query="DisplayProgramClients">
134 <cfif #DisplayProgramClients.RecordCount# is not 0 and counter is 1>
135 <strong>Clients</strong><br>
136 <cfset counter = 2>
137 </cfif>
138 <cfif #DisplayProgramClients.RecordCount# is not 0>
139 #Service#,
140 </cfif>
141 </cfoutput>
142 <cfset counter = 1>
143 <cfoutput query="DisplayProgramClients">
144 <cfif #DisplayProgramClients.RecordCount# is not 0 and counter is 1>
145 <br><br>
146 <cfset counter = 2>
147 </cfif>
148 pKanel 1.1 </cfoutput>
149
150
151 <!--- Resources --->
152 <cfset counter = 1>
153 <cfoutput query="DisplayProgramResource">
154 <cfif #DisplayProgramResource.RecordCount# is not 0 and counter is 1>
155 <strong>Resources</strong><br>
156 <cfset counter = 2>
157 </cfif>
158 <cfif #DisplayProgramResource.RecordCount# is not 0>
159 #Service#,
160 </cfif>
161 </cfoutput>
162 <cfset counter = 1>
163 <cfoutput query="DisplayProgramResource">
164 <cfif #DisplayProgramResource.RecordCount# is not 0 and counter is 1>
165 <br><br>
166 <cfset counter = 2>
167 </cfif>
168 </cfoutput>
169 pKanel 1.1
170 <!--- Program Type --->
171 <cfset counter = 1>
172 <cfoutput query="DisplayProgramType">
173 <cfif #DisplayProgramType.RecordCount# is not 0 and counter is 1>
174 <strong>Program Type</strong><br>
175 <cfset counter = 2>
176 </cfif>
177 <cfif #DisplayProgramType.RecordCount# is not 0>
178 #ProgramType#,
179 </cfif>
180 </cfoutput>
181 <cfset counter = 1>
182 <cfoutput query="DisplayProgramType">
183 <cfif #DisplayProgramType.RecordCount# is not 0 and counter is 1>
184 <br><br>
185 <cfset counter = 2>
186 </cfif>
187 </cfoutput>
188
189 <!--- Service Area --->
190 pKanel 1.1 <cfset counter = 1>
191 <cfoutput query="DisplayProgramGeo">
192 <cfif #DisplayProgramGeo.RecordCount# is not 0 and counter is 1>
193 <strong>Service Area</strong><br>
194 <cfset counter = 2>
195 </cfif>
196 <cfif #GeoService# is not "">
197 #GeoService#
198 </cfif>
199 </cfoutput>
200 <cfset counter = 1>
201 <cfoutput query="DisplayProgramGeo">
202 <cfif #DisplayProgramGeo.RecordCount# is not 0 and counter is 1>
203 <br><br>
204 <cfset counter = 2>
205 </cfif>
206 </cfoutput>
207
208 <!--- End of adding if clauses by Daeho on 5/16/02 --->
209
210 <cfoutput query="DisplayProgramContacts">
211 pKanel 1.1 <strong>#Title#</strong><br>
212 #prefix# #FirstName# #Middle# #lastName#
213 <cfif #Address# is not ""><br>#Address#</cfif>
214 <cfif #City# is not ""><br>#City#,</cfif><cfif #state#is not "">#State#</cfif><cfif #zip# is not ""> #zip#</cfif>
215 <cfif #WorkPhone# is not ""><br>#WorkPhone#</cfif> <cfif #workExtension# is not ""> x#workExtension#</cfif>
216 <cfif #MobilePhone# is not "">
217 <br>MOBILE TEL: #MobilePhone#</cfif>
218 <cfif #FaxNumber# is not "">
219 <br>FAX: #FaxNumber#</cfif>
220 <cfif #emailName# is not "">
221 <br><a href="mailto:#emailName#">#emailName#</a></cfif><br><br></cfoutput>
222
223
224 <cfoutput query="DisplayProgramDetails">
225 <strong>Contact Information</strong>
226 <br>#Division#
227 <br>#Address1#
228 <cfif #Address2# is not "">
229 <br>#Address2#</cfif>
230 <br>#City#, #StateOrProvince# #PostalCode#
231 <br>#Region# #country#
232 pKanel 1.1 <br>Timezone: #timezone#
233 <br>#phone# <cfif #extension# is not "">ext:#extension#</cfif>
234 <cfif #hotline# is not "">
235 <br>Hotline: #hotline#</cfif>
236 <cfif #FaxNumber# is not "">
237 <br>FAX: #FaxNumber#</cfif>
238 <br><a href="mailto:#emailName#">#emailName#</a>
239 </cfoutput>
240
241 </td>
242 </tr>
243 </table>
244
245 </body>
246 </html>
|
Return to
printpage.cfm
CVS log
Up to [Development] / p2rx-programs