1 neenan 1.1 <!--- Name: dsp_editProgramtypes.cfm
2 Purpose: It helps to edit the relation between existing program types and organization in your dummy program database.
3 It also transfers all the programTypeID values that the user selects to act_editProgramsTypes.cfm where
4 the actual action of inserting the association between the organization and its related program
5 types in table dOrgToProgramType.
6 Date created: 02/23/2005
7 Dependancy: URL.Orgid
8 Variables: ProgramTypeID - Unique ID of each ProgramType
9 ProgramType - Type of the Program organization
10 OrganizationName - Name of the organization
11
12 Functions:
13 Date changed: 02/23/2005 Prabin & Neena Creation and Documentation
|
14 neenan 1.2 3/22/2005 Neena Commented out the Span tags
|
15 neenan 1.1 --->
16
17 <cfquery name="progtypes" datasource="#Programsdb#">
18 Select ProgramType, ProgramTypeID
19 From dProgramTypes
20 Where Approved = 0
21 </cfquery>
22
23 <cfquery name="getORG" datasource="#Programsdb#">
24 SELECT OrganizationName
25 FROM dOrganization
26 WHERE OrgID = #URL.OrgID#
27 </cfquery>
28
29 <cfquery datasource="#programsdb#" name="getCheckedprograms">
30 SELECT OrgID, ProgramTypeID
31 FROM dOrgToProgramType
32 WHERE OrgID = #URL.OrgID#
33 </cfquery>
34
35 <cfset qryProgramTypeList = Valuelist(getCheckedprograms.ProgramTypeID)>
36 neenan 1.1
37 <!-- #BeginEditable "Content" -->
38 <table width="100%" border="0" cellspacing="0" cellpadding="10" name="text">
39 <tr>
40 <td>
41 <p>
|
42 neenan 1.2 <!--- <span class="subheading"> --->
43 EDIT A PROGRAM -> <!--- <img src="../images/siteimage/dart.gif" border="0"> --->
44 PROGRAM TYPES - <!--- <img src="../images/siteimage/dart.gif" border="0"></span> --->
45 <!--- <span class="sublink2"> --->Step 3 <!--- <img src="../images/siteimage/dart.gif" border="0"></span> ---><br><br>
|
46 neenan 1.1 <cfoutput query="getORG"><strong>#OrganizationName#</strong></cfoutput><br>
|
47 neenan 1.2 Please select the program type(s) which describe your organization. <font style="color: red">* At least One</font><br><br>
|
48 neenan 1.1
49 <cfif #URL.fuseaction# IS "editprogramtypes">
50 <form name="editProgramsTypes" action="addeditprograms.cfm?fuseaction=EditServices&OrgID=<cfoutput>#URL.OrgID#</cfoutput>" onsubmit="return Validate(this)" method="post">
51 <cfelseif #URL.fuseaction# IS "editprogramtypes1">
52 <form name="editProgramsTypes" action="addeditprograms.cfm?fuseaction=EditServices1&OrgID=<cfoutput>#URL.OrgID#</cfoutput>" onsubmit="return Validate(this)" method="post">
53 </cfif>
54
55 <table width="95%" border="0" cellspacing="0" cellpadding="5" bgcolor="#F4FFE9">
56 <cfloop query="progtypes">
57 <tr>
58 <cfoutput>
59 <td colspan="2"><div class="formtext">
60 <input type="checkbox" name="ProgramTypeID" value="#ProgramTypeID#" <cfif ListFind(QryProgramTypeList, "#ProgramTypeID#")>CHECKED</cfif>>#ProgramType#</div>
61 </td>
62 </cfoutput>
63 </tr>
64 </cfloop>
65 <tr>
66 <td colspan="2"><div class="formtext">
67 <INPUT type="submit" value="Submit">
68 <INPUT type="reset" value="Reset"></div></td>
69 neenan 1.1 </tr>
70 </table>
71 </form>
72
73 </td>
74 </tr>
75 </table>
76 </p>
77 </body>
|
Return to
dsp_editprogramstypes.cfm
CVS log
Up to [Development] / p2rx-programs