Return to act_displayOrgInfo.cfm CVS log

Up to [Development] / p2rx-programs

*** empty log message ***

<!--- 	Name:  act_displayOrgInfo.cfm
    	Purpose: This functions as the action file in the to pull up the record of the currently added organization from the 
				Dorganization,dservices and dprogramtypes tables.The form also gives the user a way to edit the existing 
				information about the organization and contact details.In the edit mode, the visitor id for this organization is 
				extracted using a query GetProgramdetails.The information is passed onto the first input form of Dsp_addUser.cfm.
		Date created: 02/24/2005
       	Dependancy: URL.Vid - visitor Id - used only in the editing of the initial user.
		Variables: 	
					
		Functions: 
		Date changed: 
					02/24/2005			Prabin & Neena  Created & Documentation
---> 	

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

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


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

<cfquery name="DisPlayProgramType" datasource="#programsdb#">
select *
from dOrganization o, dOrgtoProgramtype op, dProgramTypes p
where o.orgID=op.orgID and op.ProgramTypeID=p.ProgramTypeID and o.OrgID=#URL.OrgID#
</cfquery>

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

</cfquery>

<cfquery name="DisPlayProgramExpertise" datasource="#programsdb#">
select *
from dService s, dOrgtoService os, dOrganization o
where o.orgID=os.orgID and os.ServiceID=s.ServiceID and s.type='Expertise' and o.OrgID=#URL.OrgID#
</cfquery> 

<cfquery name="DisPlayProgramClients" datasource="#programsdb#">
select *
from dService s, dOrgtoService os, dOrganization o
where o.orgID=os.orgID and os.ServiceID=s.ServiceID and s.type='Clients' and o.OrgID=#URL.OrgID#
</cfquery> 

<cfquery name="DisPlayProgramResource" datasource="#programsdb#">
select *
from dService s, dOrgtoService os, dOrganization o
where o.orgID=os.orgID and os.ServiceID=s.ServiceID and s.type='Resources' and o.OrgID=#URL.OrgID#
</cfquery> 


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

<table width="100%" border="0" cellspacing="0" cellpadding="10" name="text">
        <tr> 
          <td> 
            <p>	
			<span class="subheading">
				ADD A PROGRAM <img src="../images/siteimage/dart.gif" border="0">
				CONFIRMATION PAGE <img src="../images/siteimage/dart.gif" border="0"></span>
				<span class="sublink2">Step 5 <img src="../images/siteimage/dart.gif" border="0"></span><br><br>
			
<!-- #BeginEditable "Content" -->
<table width="95%" border="0" cellspacing="0" cellpadding="5" bgcolor="#F4FFE9">
<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>
     
	 <cfoutput query="displayProgramDetails">  
	 <cfif #GraphicURL# is not ""> 
	 <tr> 
          <td valign="top" height="80"><p><a href="#URL#"><img src="#GraphicURL#" alt="#OrganizationName#" border="0" vspace="2"></a></td>
		<cfif #URl.fuseaction# is "editfinalprocess" or #URL.fuseaction# is "FinalProcess" >
				<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>
		<cfelseif #URl.fuseaction# is "editfinalprocess1">
				<td align="left"><a href="AddEditPrograms.cfm?FuseAction=EditOrg&OrgID=<cfoutput>#URL.OrgID#</cfoutput>" class="subheading">Edit your program</a></td>
		</cfif>

	</tr>
	</cfif>
	</cfoutput>
	<tr><td valign="top">
<p>
<cfoutput query="DisplayProgramDetails"><a href="#URL#" class="subheading">#OrganizationName#</a>

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

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

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

<!--- Expertise --->
<cfset counter = 1>
<cfoutput query="DisplayProgramExpertise">
   <cfif #DisplayProgramExpertise.RecordCount# is not 0 and counter is 1>
	<span class="tableheading"><p><span class="bold">Expertise</span><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>
	<span class="bold">Clients</span><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>
	<span class="bold">Resources</span><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>
	<span class="bold">Program Type</span><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>
	<span class="bold">Service Area</span><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>

<cfoutput query="DisplayProgramContacts">
<span class="bold">#Title#</span><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#" class="subheading">#emailName#</a></cfif><br><br></cfoutput>


<cfoutput query="DisplayProgramDetails">
<span class="bold">Contact Information</span>
<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#" class="subheading">#emailName#</a>
		</cfoutput>

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

</td>
</tr>
        <tr>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td>&nbsp;</td>
        </tr>
</table>
</p>