Return to act_finalprocess.cfm CVS log

Up to [Development] / p2rx-programs

Enhancements made to resolve programs added or udpated by Outsite users.

<!--- 	Name:  act_finalprocess.cfm
    	Purpose: This file is as action file to bring up all the information such as organization details, services selected. The 
				email of the user is also selected so the details can be emailed to the concerned person. The hidden variable - Visitor_id
				using the GetUserEmail query passed onto the next dsp_adduser.cfm form if user selects "Edit the program" on the final 
				confirmation page.
		Date created: 02/23/2005
       	Dependancy: URl.Orgid
		Variables: 	
					
		Functions: 
		Date changed: 
					02/24/2005		Prabin & Neena  Created & Documentation
					08/26/2005		Terry & Prabin	Added new queries to display all the 
													programtypes and services when the e-mail
													is send out to the center director.
---> 	

<cfquery name="GetUserEmail" datasource="#programsdb#">
	Select 		*
	From 		OutsideUsers
	where orgid= #URL.OrgID#
</cfquery>


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

<cfquery name="DisPlayProgramExpertise" datasource="#programsdb#">
select s.*
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> 
<cfset qryExpertiseList = Valuelist(DisPlayProgramExpertise.Service)>


<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> 
<cfset qryClientList = Valuelist(DisPlayProgramClients.Service)>

<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> 
<cfset qryResourceList = Valuelist(DisPlayProgramResource.Service)>

<cfquery name="DisPlayProgramType" datasource="#programsdb#">
	select *
	from dProgramTypes s, dOrgtoProgramType os, dOrganization o
	where o.orgID=os.orgID and os.ProgramTypeID=s.ProgramTypeID and o.OrgID=#URL.OrgID#
</cfquery> 
<cfset qryProgramsList = Valuelist(DisPlayProgramType.ProgramType)>


<cfoutput><input type="hidden" name="vid" value="#GetUserEmail.visitor_id#"></cfoutput>

<cfmail from="ryoder@unomaha.edu" to="pKanel@mail.unomaha.edu, #getUserEmail.Email#" subject="Information of the organization has been changed">
#GetUserEmail.fname# #GetUserEmail.lname#
This e-mail is automatically generated to let you know that the information for your organization
has been changed in our database. We might contact you to validate the information. Once the information has been 
validated, the status for the organization will be changed and will be displayed on our site.

Current Information:
====================

Organization Name: #getORG.OrganizationName#
Profile: #getOrg.Profile#
Division: #getOrg.Division#
Address: #getOrg.Address1# #getOrg.Address1#
		 #getOrg.City# #getOrg.StateOrProvince# #getOrg.PostalCode#
		 #getOrg.Country#  
Region:	 #getOrg.Region#
TimeZone: #getOrg.TimeZone#
Phone Number: #getOrg.Phone#
Extension: #getOrg.Extension#
Fax Number: #getOrg.FaxNumber#  
Email Address: #getOrg.EmailName#  
HotLine:  #getOrg.Hotline#
URL: #getOrg.URL#  
Graphic URL: #getOrg.GraphicURL#  
Resources: #qryResourceList#
Expertise: #qryExpertiseList#
Clients:   #qryClientList#
ProgramType: #qryProgramsList#	  
</cfmail>