Return to dsp_editprogramstypes.cfm CVS log

Up to [Development] / p2rx-programs

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

<!--- 	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
						08/15/2005		Terry			Added URL variable for skipping step (line 49)
						08/15/2005		Terry			Documentation
---> 

<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> &nbsp;
				<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 
		or click <a href="addeditprograms.cfm?fuseaction=EditServices1&OrgID=<cfoutput>#URL.OrgID#</cfoutput>&skip=1"><strong>here</strong></a> to proceed to the next step.&nbsp; <span class="redtext"><font style="color: red">* At least One</font></span><br><br>
	
		<cfif #URL.fuseaction# IS "editprogramtypes">
		<form name="editProgramsTypes" action="addeditprograms.cfm?fuseaction=EditServices&OrgID=<cfoutput>#URL.OrgID#</cfoutput>&skip=0" onsubmit="return Validate(this)" method="post">
		<cfelseif #URL.fuseaction# IS "editprogramtypes1">
		<form name="editProgramsTypes" action="addeditprograms.cfm?fuseaction=EditServices1&OrgID=<cfoutput>#URL.OrgID#</cfoutput>&skip=0" 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>