| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /nginx/html/qry/ |
Upload File : |
<!--- NonDepartmentCurrentCredentialCourses.cfqry --->
<cfparam name="NonDepartmentCourseDebug" default=false>
<cfif NonDepartmentCourseDebug AND REMOTE_ADDR eq "173.29.36.219">
<cfoutput>NonDepartmentCourseDebug is on.<br></cfoutput>
</cfif>
<cfparam name="DepartmentID" default="">
<cfif NonDepartmentCourseDebug AND REMOTE_ADDR eq "173.29.36.219">
<cfoutput>DepartmentID=#DepartmentID#<br></cfoutput>
<cfoutput><pre>
SELECT First(Course.CourseID) AS FirstCourseID, Department.DepartmentCode, Course.CourseNumber
FROM (Program INNER JOIN (Credential INNER JOIN ((Course INNER JOIN Department ON Course.DepartmentID = Department.DepartmentID) INNER JOIN CredentialSection_Course ON (Course.CourseID = CredentialSection_Course.CourseID) AND (Course.CourseID = CredentialSection_Course.CourseID)) ON Credential.CredentialID = CredentialSection_Course.CredentialID) ON Program.ProgramID = Credential.ProgramID) INNER JOIN ProgramCategory ON Program.ProgramCategoryID = ProgramCategory.ProgramCategoryID
GROUP BY Department.DepartmentCode, Course.CourseNumber, Program.ProgramName, Course.CourseIsUnavailable
HAVING Department.DepartmentCode <> '#DepartmentCode#'
AND Course.CourseIsUnavailable = 0
AND (Program.ProgramName='Computer Programmer' OR Program.ProgramName='Computer Support Technician' OR Program.ProgramName='Network Systems Administration')
ORDER BY Department.DepartmentCode, Course.CourseNumber
</pre></cfoutput>
</cfif>
<cfquery datasource="#APPLICATION.DATASOURCE_RC#"
name="NonDepartmentCurrentCredentialCoursesCF">
SELECT First(Course.CourseID) AS FirstCourseID, Department.DepartmentCode, Course.CourseNumber
FROM (Program INNER JOIN (Credential INNER JOIN ((Course INNER JOIN Department ON Course.DepartmentID = Department.DepartmentID) INNER JOIN CredentialSection_Course ON (Course.CourseID = CredentialSection_Course.CourseID) AND (Course.CourseID = CredentialSection_Course.CourseID)) ON Credential.CredentialID = CredentialSection_Course.CredentialID) ON Program.ProgramID = Credential.ProgramID) INNER JOIN ProgramCategory ON Program.ProgramCategoryID = ProgramCategory.ProgramCategoryID
GROUP BY Department.DepartmentCode, Course.CourseNumber, Program.ProgramName, Course.CourseIsUnavailable
HAVING Department.DepartmentCode <> '#DepartmentCode#'
AND Course.CourseIsUnavailable = 0
AND (Program.ProgramName='Computer Programmer' OR Program.ProgramName='Computer Support Technician' OR Program.ProgramName='Network Systems Administration')
ORDER BY Department.DepartmentCode, Course.CourseNumber
</cfquery>
<cfif NonDepartmentCourseDebug AND REMOTE_ADDR eq "173.29.36.219">
<cfoutput>NonDepartmentCurrentCredentialCoursesCF.RecordCount=#NonDepartmentCurrentCredentialCoursesCF.RecordCount#<br><cfdump label="NonDepartmentCurrentCredentialCoursesCF" var="#NonDepartmentCurrentCredentialCoursesCF#"></cfoutput>
</cfif>
<cfset CurrentCoursesURL = APPLICATION.HTTP_SERVER & "/qry/NonDepartmentCurrentCredentialCourses.php">
<cfhttp url="#CurrentCoursesURL#" method="GET" resolveurl="Yes" throwonerror="Yes"/>
<cfset CurrentCourses = CFHTTP.FileContent>
<cfif NonDepartmentCourseDebug AND REMOTE_ADDR eq "173.29.36.219">
<cfoutput>
<br>
CurrentCoursesURL= #CurrentCoursesURL#<br>
CurrentCoursest= #CurrentCourses#<br>
ListLen(CurrentCourses,";")=#ListLen(CurrentCourses,";")#<br>
ListGetAt(CurrentCourses,1,";")=#ListGetAt(CurrentCourses,1,";")#<br>
<br>
</cfoutput>
</cfif>
<cfloop index="CourseInfo" list="#CurrentCourses#" delimiters=";">
<cfset CourseInfo = trim(#CourseInfo#)>
<cfif NonDepartmentCourseDebug AND REMOTE_ADDR eq "173.29.36.219">
<cfoutput>
<br>
CourseInfo=#CourseInfo#<br>
ListLen(CourseInfo,",")=#ListLen(CourseInfo,",")#<br>
</cfoutput>
</cfif>
<cfif ListLen(CourseInfo,",") eq 3>
<cfset CourseNumber = #ListGetAt(CourseInfo,2,",")#>
<cfset DepartmentCode = #ListGetAt(CourseInfo,1,",")#>
<cfset FirstCourseID = #ListGetAt(CourseInfo,3,",")#>
<cfif NonDepartmentCourseDebug AND REMOTE_ADDR eq "173.29.36.219">
<cfoutput>
CourseNumber=#CourseNumber#<br>
DepartmentCode=#DepartmentCode#<br>
FirstCourseID=#FirstCourseID#<br>
</cfoutput>
</cfif>
<cfquery name="newCourse" dbtype="query">
SELECT *
FROM NonDepartmentCurrentCredentialCoursesCF
WHERE CourseNumber = '#CourseNumber#'
AND DepartmentCode = '#DepartmentCode#'
</cfquery>
<cfif NonDepartmentCourseDebug AND REMOTE_ADDR eq "173.29.36.219">
<cfoutput>
newCourse.RecordCount=#newCourse.RecordCount#<br>
</cfoutput>
</cfif>
<cfif newCourse.RecordCount eq 0>
<!--- Add the missing course --->
<cfset temp = QueryAddRow(NonDepartmentCurrentCredentialCoursesCF)>
<cfset Temp = QuerySetCell(NonDepartmentCurrentCredentialCoursesCF, "CourseNumber", #CourseNumber#)>
<cfset Temp = QuerySetCell(NonDepartmentCurrentCredentialCoursesCF, "DepartmentCode", #DepartmentCode#)>
<cfset Temp = QuerySetCell(NonDepartmentCurrentCredentialCoursesCF, "FirstCourseID", #FirstCourseID#)>
</cfif>
</cfif>
</cfloop>
<cfquery name="NonDepartmentCurrentCredentialCourses" dbtype="query">
SELECT *
FROM NonDepartmentCurrentCredentialCoursesCF
ORDER BY DepartmentCode, CourseNumber, FirstCourseID
</cfquery>
<cfif NonDepartmentCourseDebug AND REMOTE_ADDR eq "173.29.36.219">
<cfoutput>
NonDepartmentCurrentCredentialCourses.RecordCount=#NonDepartmentCurrentCredentialCourses.RecordCount#<br>
<cfdump label="NonDepartmentCurrentCredentialCourses" var="#NonDepartmentCurrentCredentialCourses#">
</cfoutput>
</cfif>