|
|
|
|
File: [Development] / p2rx-programs / dsp_editprogramstypes.cfm
(download)
Revision: 1.2, Tue Mar 22 20:01:18 2005 UTC (4 years, 8 months ago) by neenan Branch: MAIN Changes since 1.1: +6 -5 lines Commented out span and image reference links. |
<!--- Name: dsp_editProgramtypes.cfm
Purpose: It helps to edit the relation between existing program types and organization in your dummy program database.
It also transfers all the programTypeID values that the user selects to act_editProgramsTypes.cfm where
the actual action of inserting the association between the organization and its related program
types in table dOrgToProgramType.
Date created: 02/23/2005
Dependancy: URL.Orgid
Variables: ProgramTypeID - Unique ID of each ProgramType
ProgramType - Type of the Program organization
OrganizationName - Name of the organization
Functions:
Date changed: 02/23/2005 Prabin & Neena Creation and Documentation
3/22/2005 Neena Commented out the Span tags
--->
<cfquery name="progtypes" datasource="#Programsdb#">
Select ProgramType, ProgramTypeID
From dProgramTypes
Where Approved = 0
</cfquery>
<cfquery name="getORG" datasource="#Programsdb#">
SELECT OrganizationName
FROM dOrganization
WHERE OrgID = #URL.OrgID#
</cfquery>
<cfquery datasource="#programsdb#" name="getCheckedprograms">
SELECT OrgID, ProgramTypeID
FROM dOrgToProgramType
WHERE OrgID = #URL.OrgID#
</cfquery>
<cfset qryProgramTypeList = Valuelist(getCheckedprograms.ProgramTypeID)>
<!-- #BeginEditable "Content" -->
<table width="100%" border="0" cellspacing="0" cellpadding="10" name="text">
<tr>
<td>
<p>
<!--- <span class="subheading"> --->
EDIT A PROGRAM -> <!--- <img src="../images/siteimage/dart.gif" border="0"> --->
PROGRAM TYPES - <!--- <img src="../images/siteimage/dart.gif" border="0"></span> --->
<!--- <span class="sublink2"> --->Step 3 <!--- <img src="../images/siteimage/dart.gif" border="0"></span> ---><br><br>
<cfoutput query="getORG"><strong>#OrganizationName#</strong></cfoutput><br>
Please select the program type(s) which describe your organization. <font style="color: red">* At least One</font><br><br>
<cfif #URL.fuseaction# IS "editprogramtypes">
<form name="editProgramsTypes" action="addeditprograms.cfm?fuseaction=EditServices&OrgID=<cfoutput>#URL.OrgID#</cfoutput>" onsubmit="return Validate(this)" method="post">
<cfelseif #URL.fuseaction# IS "editprogramtypes1">
<form name="editProgramsTypes" action="addeditprograms.cfm?fuseaction=EditServices1&OrgID=<cfoutput>#URL.OrgID#</cfoutput>" onsubmit="return Validate(this)" method="post">
</cfif>
<table width="95%" border="0" cellspacing="0" cellpadding="5" bgcolor="#F4FFE9">
<cfloop query="progtypes">
<tr>
<cfoutput>
<td colspan="2"><div class="formtext">
<input type="checkbox" name="ProgramTypeID" value="#ProgramTypeID#" <cfif ListFind(QryProgramTypeList, "#ProgramTypeID#")>CHECKED</cfif>>#ProgramType#</div>
</td>
</cfoutput>
</tr>
</cfloop>
<tr>
<td colspan="2"><div class="formtext">
<INPUT type="submit" value="Submit">
<INPUT type="reset" value="Reset"></div></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
</p>
</body>
| CVS Admin |
Powered by ViewCVS 1.0-dev |