|
version 1.3, 2005/03/24 17:23:02 UTC
|
version 1.4, 2005/08/26 16:08:19 UTC
|
|
|
|
| <!--- |
<!--- Name: act_finalprocess.cfm |
| Please change the 'To' & 'From' fields in the CFmail tag to include each center admin email address |
|
| |
|
| Name: act_finalprocess.cfm |
|
| Purpose: This file is as action file to bring up all the information such as organization details, services selected. The |
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 |
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 |
using the GetUserEmail query passed onto the next dsp_adduser.cfm form if user selects "Edit the program" on the final |
|
|
|
| Functions: |
Functions: |
| Date changed: |
Date changed: |
| 02/24/2005 Prabin & Neena Created & Documentation |
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#"> |
<cfquery name="GetUserEmail" datasource="#programsdb#"> |
|
|
|
| </cfquery> |
</cfquery> |
| |
|
| |
|
| |
<cfquery name="getOrg" datasource="#programsdb#"> |
| |
select * from dorganization |
| |
where OrgID=#URL.OrgID# |
| |
</cfquery> |
| |
|
| <cfquery name="DisPlayProgramExpertise" datasource="#programsdb#"> |
<cfquery name="DisPlayProgramExpertise" datasource="#programsdb#"> |
| select * |
select s.* |
| from dService s, dOrgtoService os, dOrganization o |
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# |
where o.orgID=os.orgID and os.ServiceID=s.ServiceID and s.type='Expertise' and o.OrgID=#URL.OrgID# |
| </cfquery> |
</cfquery> |
| |
<cfset qryExpertiseList = Valuelist(DisPlayProgramExpertise.Service)> |
| |
|
| |
|
| <cfquery name="DisPlayProgramClients" datasource="#programsdb#"> |
<cfquery name="DisPlayProgramClients" datasource="#programsdb#"> |
| select * |
select * |
| from dService s, dOrgtoService os, dOrganization o |
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# |
where o.orgID=os.orgID and os.ServiceID=s.ServiceID and s.type='Clients' and o.OrgID=#URL.OrgID# |
| </cfquery> |
</cfquery> |
| |
<cfset qryClientList = Valuelist(DisPlayProgramClients.Service)> |
| |
|
| <cfquery name="DisPlayProgramResource" datasource="#programsdb#"> |
<cfquery name="DisPlayProgramResource" datasource="#programsdb#"> |
| select * |
select * |
| from dService s, dOrgtoService os, dOrganization o |
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# |
where o.orgID=os.orgID and os.ServiceID=s.ServiceID and s.type='Resources' and o.OrgID=#URL.OrgID# |
| </cfquery> |
</cfquery> |
| |
<cfset qryResourceList = Valuelist(DisPlayProgramResource.Service)> |
| |
|
| <cfquery name="getOrg" datasource="#programsdb#"> |
<cfquery name="DisPlayProgramType" datasource="#programsdb#"> |
| select * from dorganization |
select * |
| where OrgID=#URL.OrgID# |
from dProgramTypes s, dOrgtoProgramType os, dOrganization o |
| |
where o.orgID=os.orgID and os.ProgramTypeID=s.ProgramTypeID and o.OrgID=#URL.OrgID# |
| </cfquery> |
</cfquery> |
| |
<cfset qryProgramsList = Valuelist(DisPlayProgramType.ProgramType)> |
| |
|
| |
|
| <cfoutput><input type="hidden" name="vid" value="#GetUserEmail.visitor_id#"></cfoutput> |
<cfoutput><input type="hidden" name="vid" value="#GetUserEmail.visitor_id#"></cfoutput> |
| |
|
| <cfmail from="ryoder@unomaha.edu" to="pkanel@mail.unomaha.edu,nnaidu@mail.unomaha.edu, #getUserEmail.Email#" subject="Information of the organization has been changed"> |
<cfmail from="ryoder@unomaha.edu" to="pKanel@mail.unomaha.edu, #getUserEmail.Email#" subject="Information of the organization has been changed"> |
| #GetUserEmail.fname# #GetUserEmail.lname# |
#GetUserEmail.fname# #GetUserEmail.lname# |
| This e-mail is automatically generated to let you know that the information for your organization |
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 |
has been changed in our database. We might contact you to validate the information. Once the information has been |
|
|
|
| Organization Name: #getORG.OrganizationName# |
Organization Name: #getORG.OrganizationName# |
| Profile: #getOrg.Profile# |
Profile: #getOrg.Profile# |
| Division: #getOrg.Division# |
Division: #getOrg.Division# |
| Address: #getOrg.Address1# #getOrg.Address2# |
Address: #getOrg.Address1# #getOrg.Address1# |
| #getOrg.City# #getOrg.StateOrProvince# #getOrg.PostalCode# |
#getOrg.City# #getOrg.StateOrProvince# #getOrg.PostalCode# |
| #getOrg.Country# |
#getOrg.Country# |
| Region: #getOrg.Region# |
Region: #getOrg.Region# |
|
|
|
| HotLine: #getOrg.Hotline# |
HotLine: #getOrg.Hotline# |
| URL: #getOrg.URL# |
URL: #getOrg.URL# |
| Graphic URL: #getOrg.GraphicURL# |
Graphic URL: #getOrg.GraphicURL# |
| Resources: #DisplayProgramResource.Service# |
Resources: #qryResourceList# |
| Expertise: #DisplayProgramExpertise.Service# |
Expertise: #qryExpertiseList# |
| Clients: #DisplayProgramClients.Service# |
Clients: #qryClientList# |
| |
ProgramType: #qryProgramsList# |
| </cfmail> |
</cfmail> |
Return to
act_finalprocess.cfm
CVS log
Up to [Development] / p2rx-programs