neenan 1.1 <!--- 	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
            ---> 
            
            <cfquery name="progtypes" datasource="#Programsdb#">
            Select ProgramType, ProgramTypeID
            From dProgramTypes
            Where Approved = 0
            </cfquery>
            
 neenan 1.1 <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">
 neenan 1.1 				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. &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>" 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>
 neenan 1.1 				<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>