I have a code that i wrote looking for the specific courses and check for the
completion. Now the requirenment has changed.
4. Date Rule: This will have a number of possibilities.
0: Ignore start and end dates. Display this course for all EDITs
1: This course will be displayed to an edit if the EDIT date is after the
Start date.
2: This course will be displayed to an edit if the EDIT date is before the End
date.
3: This course will be displayed to an edit if the EDIT date is between the
Start date and the End date.
5. Equivalent Course: Chosen from a dropdown list of all Sunrise
courses. If the main course has been completed display that one. If the
main course has not been completed but the Equivalent one has, then display the
equivalent one. If neither have been done then display main course but without
a completion date. The EDIT may put in a completion if course rules allow
this. Note the date rules still apply.
The Equivalent course is to be a list of courses. This will allow a course to
be equivalent to 2 or 3 courses. If displaying the Equivalents display all
the courses in the list.
6. Online: Yes or no. Display only this is automated by the system and
cannot be set by the Administrator. If the course is an online course the
EDIT will not be able to input a completion date. This completion date will
then be automated.
The Equivalent stored in the list. How would I achieve this code change
Here is my current code
<!--- Get employee --->
<cfquery name="getEmployee" datasource="cfelsunrise"
dbtype="ODBC">
select *
from Employee e
Join EmployeeJobHistory h on e.EmployeeID =
h.EmployeeID
inner join JobAssignment a on (h.sequence =
a.sequence and a.EndDate is NULL)
inner join Location l ON l.LocationID =
a.LocationID
inner join JobCode_List j on h.JobCode = j.JobCode
where e.terminationdate is NULL
and e.EmployeeID = #sel_EmpID#
Order by a.startDate DESC
</cfquery>
<cfquery name="getDynamicCourses" datasource="cfelsunrise">
Select
d.Courseid,d.ISoNLINE,c.description,c.name,d.equivalentto from
DynamicCourseList d
inner join Course_catalog c on c.courseID =
d.courseID
where whatFor = 'EDIT'
</cfquery>
<cfset lstartDt = DateFormat(getEmployee.StartDate, "mm/dd/yy")>
<cfset ReqCourseNrray = ArrayNew(1)>
<cfset ReqCourserray = ArrayNew(1)>
<cfset ReqdEquivalentCourserray = ArrayNew (1)>
<cfif getDynamicCourses.recordcount gt 0>
<cfloop query="getDynamicCourses">
<cfset ArrayAppend(ReqCourseNrray,
#getDynamicCourses.description#)>
<cfset ArrayAppend(ReqCourserray,
#getDynamicCourses.name#)>
</cfloop>
</cfif>
<!---- get non-requiredmtraining --->
<cfset lLast_Name = getEmployee.Last_Name>
<cfset lFirst_Name = getEmployee.First_Name>
<cfset lmiddle_Name = getEmployee.middle_Name>
<cfset lEmployeeID = getEmployee.EmployeeID>
<cfset lName = getEmployee.Name>
<cfset lState = getEmployee.State>
<cfset lDeptName = getEmployee.DeptName>
<cfset lBusiness = getEmployee.Business>
<cfset lHireDate = getEmployee.HireDate>
<cfset lServiceDate = getEmployee.ServiceDate>
<cfset lReHireDate = getEmployee.ReHireDate>
<cfset lpositionDate = getEmployee.StartDate>
<cfset reqdHrs = 0>
<cfset reqdHrsCompl = 0>
<cfset TotalHrs = 0>
<!--- Display info --->
<div align="center">
<!--- If Basic, display the current page.
If book, include the book page
if misc, include misc page
--->
<cfset lasttg = "**">
<table width="100%" align="center"
border="0">
<tr>
<td align="center"
valign="bottom"><font size="2"><b>Course/Certification </b></font></td>
<td width="11"
align="left" valign="bottom"><font size="2"><b>Attended</b></font></td>
<td valign="bottom"
align="left"><font size="2"><b>Facilitator/SME</b></font></td>
<td valign="bottom"
align="left"><font size="2"><b>Comments</b></font></td>
</tr>
<!--- <cfdump
var="#ReqCourserray#">--->
<!--- Loop through array and
display Reqd courses --->
<cfloop from="1"
to="#ArrayLen(ReqCourserray)#" index="i">
<cfset selTGID =
#ReqCourserray[i]#>
<cfset selTGNID =
#ReqCourseNrray[i]#>
<cfquery
name="getDynamicCourses2" datasource="cfelsunrise">
Select d.Courseid,d.ISoNLINE,c.description,c.name from DynamicCourseList d
inner join Course_catalog c on c.courseID = d.courseID
where c.name = '#selTGID#'
</cfquery>
<cfset reqmtmsg = "">
<!--- Get Course from
Array --->
<cfquery
name="getcOURSE" datasource="cfelsunrise" dbtype="ODBC">
select
c.CourseID as reqCourseID, c.Type,
c.Name
as CourseName, c.Description as CourseDesc, c.HrsLength
from
Course_Catalog c
where c.Name =
'#selTGID#'
</cfquery>
<cfif
getCourse.recordcount is not 0>
<cfset selCID =
getCoURSe.reqCourseID>
<cfquery
name="getReqmts" datasource="cfelsunrise" dbtype="ODBC">
select
et.StartDate, et.CompletionDate, et.Sequence, et.CourseLength, et.Instructor,
et.Comments
from
EmployeeTraining et
where
et.CourseID = '#selCID#'
and
et.EmployeeID = #sel_EmpID#
</cfquery>
</cfif>
<cfoutput>
<input
type="hidden" name="ETCourseName#i#" value="#TRIM(selTGNID)#">
<cfif
getCourse.recordcount is not 0>
<input
type="hidden" name="ETCourseID#i#" value="#getCourse.reqCourseID#">
<input
type="hidden" name="ETCourseType#i#" value="#getCourse.Type#">
<input
type="hidden" name="ETCourseLength#i#" value="#getCourse.HrsLength#">
<input
type="hidden" name="ETSequence#i#" value=<cfif getReqmts.recordcount is not
0>"#getReqmts.Sequence#"<cfelse>"0"</cfif>>
<cfif
getReqmts.recordcount is not 0>
<input type="hidden" name="ETCourseLength#i#"
value="#TRIM(getReqmts.CourseLength)#">
</cfif>
<cfset
reqdHrs = reqdHrs + getcourse.HrsLength>
<cfif
(#DateFormat(getReqmts.CompletionDate, "mm/dd/yy")# is not "")>
<cfset reqdHrsCompl = reqdHrsCompl + getReqmts.CourseLength>
<cfset TotalHrs = TotalHrs + getReqmts.CourseLength>
</cfif>
<tr>
<td valign="top"><font size=2>#TRIM(selTGNID)# [#TRIM(selTGID)#]</td>
<td width="11" valign="top" align="center"><font size=2>
<input type="text" name="ETCompletionDate#i#" value
="#DateFormat(getReqmts.CompletionDate, "mm-dd-yyyy")#" size=10 maxlength=10
<cfif getDynamicCourses2.isOnline eq 1>disabled</cfif>></td>
<td valign="top" align="left"><font size=2>
<input type="text" name="ETInstructor#i#" value
="#TRIM(getReqmts.Instructor)#" <cfif getDynamicCourses2.isOnline eq
1>disabled</cfif>></td>
<td valign="top" align="left"><font size=2>
<input type="text" size=40 name="ETComments#i#" value
="#TRIM(getReqmts.Comments)#" <cfif getDynamicCourses2.isOnline eq
1>disabled</cfif>></td>
</tr>
<cfelse>
<input
type="hidden" name="ETCourseID#i#" value="0">
<input
type="hidden" name="ETCourseType#i#" value="0">
<input
type="hidden" name="ETCourseLength#i#" value="0">
<input
type="hidden" name="ETSequence#i#" value="0">
<input
type="hidden" name="ETCompletionDate#i#" value="0">
<input
type="hidden" name="ETInstructor#i#" value="0">
<input
type="hidden" name="ETComments#i#" value="0">
<tr>
<td width="40%" valign="top"><font size=2>#TRIM(selTGNID)# [course not yet
available]</td>
<td valign="top" align="center"><font size=2>
<input type="text" name="blank" size="10" disabled
style="background-color:CCCCCC"></td>
<td valign="top" align="left"><font size=2>
<input type="text" name="blank" style="background-color:CCCCCC"
DISABLED></td>
<td valign="top" align="left"><font size=2>
<input type="text" size=40 "blank" style="background-color:CCCCCC"
DISABLED></td>
</tr>
</cfif>
</cfoutput>
</cfloop>
</table></td>
</tr>
<tr>
<td><table width="90%" align="center"
border="0">
<tr>
<td colspan="3"
><hr></td>
</tr>
<tr>
<td colspan="3"
align="center"><font size=2><cfoutput><b>Hours Summary - </b>Required Courses:
#NumberFormat(reqdHrs, "999.99")# - Required Courses Taken:
#NUmberFormat(reqdHrsCompl, "999.99")#</cfoutput> </td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="90%" align="center"
border="0">
<tr>
<td> </td>
</tr>
<tr>
<td
align="center"><input type="submit" name="submit" value="Process Update">
<input
type="button" name="Cancel" id="Cancel" value="Cancel" onClick="goCancel()">
</td>
</tr>
</table></td>
</tr>
<!--- End content here --->
</td></tr></table>
</form>
</div>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319557
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
