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 pKanel 1.3 08/15/2005 Terry Added URL variable for skipping step (line 49)
15 08/15/2005 Terry Documentation
|
16 neenan 1.1 --->
17
18 <cfquery name="progtypes" datasource="#Programsdb#">
19 Select ProgramType, ProgramTypeID
20 From dProgramTypes
21 Where Approved = 0
22 </cfquery>
23
24 <cfquery name="getORG" datasource="#Programsdb#">
25 SELECT OrganizationName
26 FROM dOrganization
27 WHERE OrgID = #URL.OrgID#
28 </cfquery>
29
30 <cfquery datasource="#programsdb#" name="getCheckedprograms">
31 SELECT OrgID, ProgramTypeID
32 FROM dOrgToProgramType
33 WHERE OrgID = #URL.OrgID#
34 </cfquery>
35
36 <cfset qryProgramTypeList = Valuelist(getCheckedprograms.ProgramTypeID)>
37 neenan 1.1
38 <!-- #BeginEditable "Content" -->
39 <table width="100%" border="0" cellspacing="0" cellpadding="10" name="text">
40 <tr>
41 <td>
42 <p>
|
43 pKanel 1.3 <span class="subheading">
44 EDIT A PROGRAM <img src="../images/siteimage/dart.gif" border="0">
45 PROGRAM TYPES<img src="../images/siteimage/dart.gif" border="0"></span>
46 <span class="sublink2">Step 3 <img src="../images/siteimage/dart.gif" border="0"></span><br><br>
|
47 neenan 1.1 <cfoutput query="getORG"><strong>#OrganizationName#</strong></cfoutput><br>
|
48 pKanel 1.3 Please select the program type(s) which describe your organization
49 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. <span class="redtext"><font style="color: red">* At least One</font></span><br><br>
|
50 neenan 1.1
51 <cfif #URL.fuseaction# IS "editprogramtypes">
|
52 pKanel 1.3 <form name="editProgramsTypes" action="addeditprograms.cfm?fuseaction=EditServices&OrgID=<cfoutput>#URL.OrgID#</cfoutput>&skip=0" onsubmit="return Validate(this)" method="post">
|
53 neenan 1.1 <cfelseif #URL.fuseaction# IS "editprogramtypes1">
|
54 pKanel 1.3 <form name="editProgramsTypes" action="addeditprograms.cfm?fuseaction=EditServices1&OrgID=<cfoutput>#URL.OrgID#</cfoutput>&skip=0" onsubmit="return Validate(this)" method="post">
|
55 neenan 1.1 </cfif>
56
57 <table width="95%" border="0" cellspacing="0" cellpadding="5" bgcolor="#F4FFE9">
58 <cfloop query="progtypes">
59 <tr>
60 <cfoutput>
61 <td colspan="2"><div class="formtext">
62 <input type="checkbox" name="ProgramTypeID" value="#ProgramTypeID#" <cfif ListFind(QryProgramTypeList, "#ProgramTypeID#")>CHECKED</cfif>>#ProgramType#</div>
63 </td>
64 </cfoutput>
65 </tr>
66 </cfloop>
67 <tr>
68 <td colspan="2"><div class="formtext">
69 <INPUT type="submit" value="Submit">
70 <INPUT type="reset" value="Reset"></div></td>
71 </tr>
72 </table>
73 </form>
74
75 </td>
76 neenan 1.1 </tr>
77 </table>
78 </p>
79 </body>
|
Return to
dsp_editprogramstypes.cfm
CVS log
Up to [Development] / p2rx-programs