(file) Return to printpage.cfm CVS log (file) (dir) Up to [Development] / p2rx-programs
File: [Development] / p2rx-programs / printpage.cfm (download)
Revision: 1.1, Mon Jun 20 19:09:48 2005 UTC (4 years, 5 months ago) by pKanel
Branch: MAIN
CVS Tags: HEAD 
Initial Commit

<!--- 	Name:  printpage.cfm
    	Purpose: It opens up a printer friendly page for display the details of programs. 
		Date created: 06/20/2005
       	Dependancy: called from details.cfm
		Variables: OrgID
		Functions: 
		Date changed: 
					06/20/2005     	Prabin		Created
---> 


<cfset programsdb="programs">

<cfquery name="provider" datasource="#programsdb#">
SELECT *
FROM Organization
WHERE OrgID=#OrgID#
</cfquery>

<CFQUERY name="displayProgramDetails" datasource="#programsdb#">
select distinct * 
from organization 
where OrgID=#OrgID# 
</CFQUERY>


<CFQUERY name="displayProgramContacts" datasource="#programsdb#">
select distinct * 
from contacts 
where OrgID=#OrgID#
</CFQUERY>


<cfquery name="DisPlayProgramType" datasource="#programsdb#">
select *
from Organization o, OrgtoProgramtype op, ProgramTypes p
where o.orgID=op.orgID and op.ProgramTypeID=p.ProgramTypeID and o.OrgID=#OrgID#
</cfquery>



<cfquery name="DisplayProgramGeo" datasource="#programsdb#">
select *
from Organization o, Geoservices g
where o.GeoServiceID=g.GeoServiceID and o.OrgID=#OrgID#

</cfquery>

<cfquery name="DisPlayProgramExpertise" datasource="#programsdb#">
select *
from Service s, OrgtoService os, Organization o
where o.orgID=os.orgID and os.ServiceID=s.ServiceID and s.type='Expertise' and o.OrgID=#OrgID#
</cfquery> 

<cfquery name="DisPlayProgramClients" datasource="#programsdb#">
select *
from Service s, OrgtoService os, Organization o
where o.orgID=os.orgID and os.ServiceID=s.ServiceID and s.type='Clients' and o.OrgID=#OrgID#
</cfquery> 

<cfquery name="DisPlayProgramResource" datasource="#programsdb#">
select *
from Service s, OrgtoService os, Organization o
where o.orgID=os.orgID and os.ServiceID=s.ServiceID and s.type='Resources' and o.OrgID=#OrgID#
</cfquery> 


<cfquery name="memo1" datasource="#programsdb#">
select * from organization
where OrgID=#OrgID#
</cfquery>

<html>
<head>
<title>Pollution Prevention Agencies and Programs</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="../css/newstyle.css" type="text/css">
</head>
<body leftmargin="20" topmargin="20" marginwidth="20" marginheight="20">

<img src="http://www.p2ric.org/images/p2ricshort.gif" alt="P2RIC logo"><font size="+2"><strong>&nbsp;&nbsp;&nbsp;Programs Directory</strong></font>
<p>	<a href="details.cfm?OrgID=<cfoutput>#URL.ORgID#</cfoutput>">GO BACK</a></p>
 
<table width="100%" border="0" cellspacing="0" cellpadding="10" name="text">
	<cfoutput query="displayProgramDetails">  
	 <cfif #GraphicURL# is not ""> 
	 <tr> 
          <td valign="top" height="80"><a href="#URL#"><img src="#GraphicURL#" alt="#OrganizationName#" border="0" vspace="2"></a></td>
	</tr>
	</cfif>
	</cfoutput>
	<tr><td valign="top">

<cfoutput query="DisplayProgramDetails"><a href="#URL#">#OrganizationName#</a><br><br>

</cfoutput>
    <!---information display start--->


<cfoutput query="memo1">#profile#</cfoutput>

<!--- Start: if clauses are added by Daeho on 5/16/02 --->

<!--- Division --->
<cfoutput query="displayprogramdetails">
<cfif #Division# is not "">
	Division<br>
	#Division#
</cfif>
</cfoutput>

<!--- Expertise --->
<cfset counter = 1>
<cfoutput query="DisplayProgramExpertise">
   <cfif #DisplayProgramExpertise.RecordCount# is not 0 and counter is 1>
<strong><br><br>	Expertise</strong><br>
	<cfset counter = 2>
   </cfif>
   <cfif #DisplayProgramExpertise.RecordCount# is not 0>
	#Service#,&nbsp;
   </cfif>
</cfoutput>
<cfset counter = 1>
<cfoutput query="DisplayProgramExpertise">
   <cfif #DisplayProgramExpertise.RecordCount# is not 0 and counter is 1>
	<br><br>
	<cfset counter = 2>
   </cfif>
</cfoutput>

<!--- Clients --->
<cfset counter = 1>
<cfoutput query="DisplayProgramClients">
<cfif #DisplayProgramClients.RecordCount# is not 0 and counter is 1>
	<strong>Clients</strong><br>
	<cfset counter = 2>
</cfif>
<cfif #DisplayProgramClients.RecordCount# is not 0>
	#Service#,&nbsp;
</cfif>
</cfoutput>
<cfset counter = 1>
<cfoutput query="DisplayProgramClients">
   <cfif #DisplayProgramClients.RecordCount# is not 0 and counter is 1>
	<br><br>
	<cfset counter = 2>
   </cfif>
</cfoutput>


<!--- Resources --->
<cfset counter = 1>
<cfoutput query="DisplayProgramResource">
<cfif #DisplayProgramResource.RecordCount# is not 0 and counter is 1>
	<strong>Resources</strong><br>
	<cfset counter = 2>
</cfif>
<cfif #DisplayProgramResource.RecordCount# is not 0>
#Service#,&nbsp;
</cfif>
</cfoutput>
<cfset counter = 1>
<cfoutput query="DisplayProgramResource">
   <cfif #DisplayProgramResource.RecordCount# is not 0 and counter is 1>
	<br><br>
	<cfset counter = 2>
   </cfif>
</cfoutput>

<!--- Program Type --->
<cfset counter = 1>
<cfoutput query="DisplayProgramType">
<cfif #DisplayProgramType.RecordCount# is not 0 and counter is 1>
	<strong>Program Type</strong><br>
	<cfset counter = 2>
</cfif>
<cfif #DisplayProgramType.RecordCount# is not 0>
#ProgramType#,&nbsp;
</cfif>
</cfoutput>
<cfset counter = 1>
<cfoutput query="DisplayProgramType">
   <cfif #DisplayProgramType.RecordCount# is not 0 and counter is 1>
	<br><br>
	<cfset counter = 2>
   </cfif>
</cfoutput>

<!--- Service Area --->
<cfset counter = 1>
<cfoutput query="DisplayProgramGeo">
<cfif #DisplayProgramGeo.RecordCount# is not 0 and counter is 1>
	<strong>Service Area</strong><br>
	<cfset counter = 2>
</cfif>
<cfif #GeoService# is not "">
#GeoService#
</cfif>
</cfoutput>
<cfset counter = 1>
<cfoutput query="DisplayProgramGeo">
   <cfif #DisplayProgramGeo.RecordCount# is not 0 and counter is 1>
	<br><br>
	<cfset counter = 2>
   </cfif>
</cfoutput>

<!--- End of adding if clauses by Daeho on 5/16/02 --->

<cfoutput query="DisplayProgramContacts">
<strong>#Title#</strong><br>
#prefix# #FirstName# #Middle# #lastName#
<cfif #Address# is not ""><br>#Address#</cfif>
<cfif #City# is not ""><br>#City#,</cfif><cfif #state#is not "">#State#</cfif><cfif #zip# is not ""> #zip#</cfif>
<cfif #WorkPhone# is not ""><br>#WorkPhone#</cfif> <cfif #workExtension# is not ""> x#workExtension#</cfif>
<cfif #MobilePhone# is not "">
<br>MOBILE TEL: #MobilePhone#</cfif>
<cfif #FaxNumber# is not "">
<br>FAX: #FaxNumber#</cfif>
<cfif #emailName# is not "">
<br><a href="mailto:#emailName#">#emailName#</a></cfif><br><br></cfoutput>


<cfoutput query="DisplayProgramDetails">
<strong>Contact Information</strong>
<br>#Division#
<br>#Address1#
<cfif #Address2# is not "">
<br>#Address2#</cfif>
<br>#City#, #StateOrProvince# #PostalCode#
<br>#Region# #country#
<br>Timezone: #timezone#
<br>#phone# <cfif #extension# is not "">ext:#extension#</cfif>
<cfif #hotline# is not "">
<br>Hotline: #hotline#</cfif>
<cfif #FaxNumber# is not "">
<br>FAX: #FaxNumber#</cfif>
<br><a href="mailto:#emailName#">#emailName#</a>
		</cfoutput>

</td>
        </tr>
      </table>

  </body>
</html>
CVS Admin
 Powered by
ViewCVS 1.0-dev