neenan 1.2 <!--- 
                Please change the 'To' & 'From' fields in the CFmail tag to include each center admin email address 
            
             	Name:  act_finalprocess.cfm

 neenan 1.1     	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
            ---> 	
            
            <cfquery name="GetUserEmail" datasource="#programsdb#">
            	Select 		*
            	From 		OutsideUsers
            	where orgid= #URL.OrgID#
            </cfquery>
            
            
            <cfquery name="DisPlayProgramExpertise" datasource="#programsdb#">
 neenan 1.1 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="getOrg" datasource="#programsdb#">
            select * from dorganization
            where OrgID=#URL.OrgID#
            </cfquery>
 neenan 1.1 
            <cfoutput><input type="hidden" name="vid" value="#GetUserEmail.visitor_id#"></cfoutput>
            

 neenan 1.2 <cfmail from="ryoder@unomaha.edu" to="pkanel@mail.unomaha.edu,nnaidu@mail.unomaha.edu, #getUserEmail.Email#" subject="Information of the organization has been changed">

 neenan 1.1 #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#
 neenan 1.1 URL: #getOrg.URL#  
            Graphic URL: #getOrg.GraphicURL#  
            Resources: #DisplayProgramResource.Service# 
            Expertise: #DisplayProgramExpertise.Service#
            Clients:   #DisplayProgramClients.Service#
            		  
            </cfmail>