1 pKanel 1.4 <!--- Name: act_finalprocess.cfm
|
2 neenan 1.1 Purpose: This file is as action file to bring up all the information such as organization details, services selected. The
3 email of the user is also selected so the details can be emailed to the concerned person. The hidden variable - Visitor_id
4 using the GetUserEmail query passed onto the next dsp_adduser.cfm form if user selects "Edit the program" on the final
5 confirmation page.
6 Date created: 02/23/2005
7 Dependancy: URl.Orgid
8 Variables:
9
10 Functions:
11 Date changed:
|
12 pKanel 1.4 02/24/2005 Prabin & Neena Created & Documentation
13 08/26/2005 Terry & Prabin Added new queries to display all the
14 programtypes and services when the e-mail
15 is send out to the center director.
|
16 neenan 1.1 --->
17
18 <cfquery name="GetUserEmail" datasource="#programsdb#">
19 Select *
20 From OutsideUsers
21 where orgid= #URL.OrgID#
22 </cfquery>
23
24
|
25 pKanel 1.4 <cfquery name="getOrg" datasource="#programsdb#">
26 select * from dorganization
27 where OrgID=#URL.OrgID#
28 </cfquery>
29
|
30 neenan 1.1 <cfquery name="DisPlayProgramExpertise" datasource="#programsdb#">
|
31 pKanel 1.4 select s.*
|
32 neenan 1.1 from dService s, dOrgtoService os, dOrganization o
33 where o.orgID=os.orgID and os.ServiceID=s.ServiceID and s.type='Expertise' and o.OrgID=#URL.OrgID#
34 </cfquery>
|
35 pKanel 1.4 <cfset qryExpertiseList = Valuelist(DisPlayProgramExpertise.Service)>
36
|
37 neenan 1.1
38 <cfquery name="DisPlayProgramClients" datasource="#programsdb#">
39 select *
40 from dService s, dOrgtoService os, dOrganization o
41 where o.orgID=os.orgID and os.ServiceID=s.ServiceID and s.type='Clients' and o.OrgID=#URL.OrgID#
42 </cfquery>
|
43 pKanel 1.4 <cfset qryClientList = Valuelist(DisPlayProgramClients.Service)>
|
44 neenan 1.1
45 <cfquery name="DisPlayProgramResource" datasource="#programsdb#">
|
46 pKanel 1.4 select *
47 from dService s, dOrgtoService os, dOrganization o
48 where o.orgID=os.orgID and os.ServiceID=s.ServiceID and s.type='Resources' and o.OrgID=#URL.OrgID#
49 </cfquery>
50 <cfset qryResourceList = Valuelist(DisPlayProgramResource.Service)>
51
52 <cfquery name="DisPlayProgramType" datasource="#programsdb#">
53 select *
54 from dProgramTypes s, dOrgtoProgramType os, dOrganization o
55 where o.orgID=os.orgID and os.ProgramTypeID=s.ProgramTypeID and o.OrgID=#URL.OrgID#
|
56 neenan 1.1 </cfquery>
|
57 pKanel 1.4 <cfset qryProgramsList = Valuelist(DisPlayProgramType.ProgramType)>
|
58 neenan 1.1
59
60 <cfoutput><input type="hidden" name="vid" value="#GetUserEmail.visitor_id#"></cfoutput>
61
|
62 pKanel 1.4 <cfmail from="ryoder@unomaha.edu" to="pKanel@mail.unomaha.edu, #getUserEmail.Email#" subject="Information of the organization has been changed">
|
63 neenan 1.1 #GetUserEmail.fname# #GetUserEmail.lname#
64 This e-mail is automatically generated to let you know that the information for your organization
65 has been changed in our database. We might contact you to validate the information. Once the information has been
66 validated, the status for the organization will be changed and will be displayed on our site.
67
68 Current Information:
69 ====================
70
71 Organization Name: #getORG.OrganizationName#
72 Profile: #getOrg.Profile#
73 Division: #getOrg.Division#
|
74 pKanel 1.4 Address: #getOrg.Address1# #getOrg.Address1#
|
75 neenan 1.1 #getOrg.City# #getOrg.StateOrProvince# #getOrg.PostalCode#
76 #getOrg.Country#
77 Region: #getOrg.Region#
78 TimeZone: #getOrg.TimeZone#
79 Phone Number: #getOrg.Phone#
80 Extension: #getOrg.Extension#
81 Fax Number: #getOrg.FaxNumber#
82 Email Address: #getOrg.EmailName#
83 HotLine: #getOrg.Hotline#
84 URL: #getOrg.URL#
85 Graphic URL: #getOrg.GraphicURL#
|
86 pKanel 1.4 Resources: #qryResourceList#
87 Expertise: #qryExpertiseList#
88 Clients: #qryClientList#
89 ProgramType: #qryProgramsList#
|
90 neenan 1.1 </cfmail>
|
Return to
act_finalprocess.cfm
CVS log
Up to [Development] / p2rx-programs