Skip to main content
E
erikTsomik
Participating Frequently
February 19, 2009
Question

ColdFuison Course display

  • February 19, 2009
  • 3 replies
  • 343 views
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
    This topic has been closed for replies.

    3 replies

    E
    erikTsomikAuthor
    Participating Frequently
    February 19, 2009
    <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>

    E
    erikTsomikAuthor
    Participating Frequently
    February 19, 2009
    <!--- <cfdump
    var="#ReqCourserray#">--->
    <!--- Loop through array and
    display Reqd courses --->
    <cfloop from="1"
    to="#ArrayLen(ReqCourserray)#" index="i">
    <cfset selTGID =
    #ReqCourserray #>
    <cfset selTGNID =
    #ReqCourseNrray    #>
    <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>

    E
    erikTsomikAuthor
    Participating Frequently
    February 19, 2009
    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>
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices