| 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/Admin/Class/ |
Upload File : |
<?
// Admin/Folders.php
$TRACK = "<b>".basename(__FILE__).'</b> <span class="pv_fl">('.__FILE__.")</span>\n<ol>\n";
#setDebugOn();
ini_set('include_path',ini_get('include_path').PATH_SEPARATOR.$_SERVER['DOCUMENT_ROOT']."/"); // Add the DOCUMENT_ROOT to the include_path.
include('application.phpinc');
debugTrackBegin();
if (dc()) { echo basename(__FILE__)," line ",__LINE__,": ","<b>".__FILE__."</b><br>\n"; }
$headTitle = '_CST_ - Folders';
$pageTitle = '_CST_<br>Folders';
include('common/pageHeader.phpinc');
$sectionTitle = '_CST_ - Classes';
include('common/sectionHeader.phpinc');
include('common/sessionList.phpinc');
// Get list of courses.
$query = "
SELECT
courseId,
courseNumber
FROM course
WHERE userId = ".$_SESSION['userId']."
AND courseInactive = 0
ORDER BY courseNumber
";
$courseResult = query_do($query);
$courseCount = $_SESSION['qry']['count'];
if (dc()) { echo basename(__FILE__)," line ",__LINE__,": ","\$courseCount=".$courseCount."<br>\n"; }
if ($courseCount) {
#printQuery('$courseResult',$courseResult);
?>
<br>
<table border="0" class="grayborder" cellpadding="0" cellspacing="0">
<tr>
<td>
<?
if ($sessionCount) {
?>
Session:
<?
include('common/sessionListSelect.phpinc');
} else {
?>
None available.
<?
}
?>
<br><br>
</td>
</tr>
<tr>
<td><textarea style="width:1000px; height:600px;">
<?
#$eol = "<br>\n";
$eol = "\n";
echo ":: This program will create class and student folders for the ".$sessionName.".".$eol;
mysqli_data_seek($courseResult , 0);
while ($courseRow = mysqli_fetch_assoc($courseResult)) {
// Get class information.
$query = "
SELECT *
FROM class
WHERE courseId = ".$courseRow['courseId']."
AND YRTR = '".$_SESSION['YRTR']['User']."'
ORDER BY RCclassId
";
$classResult = query_do($query);
$classCount = $_SESSION['qry']['count'];
$rowCount = $classCount + 1;
if ($classCount) {
$classIdList = query_to_list($classResult,'classId');
#printVar("\$courseRow['courseNumber']=",$courseRow['courseNumber']);
#printVar('$classIdList',$classIdList);
#printQuery('$classResult',$classResult);
$lastName = '';
#mysqli_data_seek($classResult, 0);
#while ($classRow = mysqli_fetch_assoc($classResult)) {
// Get the classStudents.
/** /
$query = "
SELECT DISTINCT
user.userId,
user.userFirstName,
user.userLastName,
user.userStudentId
FROM user
INNER JOIN classstudent ON classstudent.userStudentId = user.userStudentId
WHERE classstudent.classId IN (".$classIdList.")
ORDER BY user.userFirstName, user.userLastName
";
$query = "
SELECT DISTINCT
classstudent.userFirstName
, classstudent.userMiddleName
, classstudent.userLastName
, classstudent.userStudentId
, user.userId
FROM classstudent
INNER JOIN user ON user.userStudentId = classstudent.userStudentId
WHERE classstudent.classId IN (".$classIdList.")
ORDER BY classstudent.userFirstName, classstudent.userLastName
";
/**/
$query = "
SELECT DISTINCT
classstudent.userFirstName
, classstudent.userMiddleName
, classstudent.userLastName
, classstudent.userStudentId
FROM classstudent
WHERE classstudent.classId IN (".$classIdList.")
ORDER BY classstudent.userFirstName, classstudent.userLastName
";
$classstudentResult = query_do($query);
$classStudentCount = $_SESSION['qry']['count'];
#printVar('$classstudentResult',$classstudentResult);
echo $eol.":: ".$courseRow['courseNumber']." has $classStudentCount students".$eol;
echo "if NOT exist ".$courseRow['courseNumber']."\\ md ".$courseRow['courseNumber'].$eol;
if ($classStudentCount) {
$lastName = '';
mysqli_data_seek($classstudentResult, 0);
while ($classstudentRow = mysqli_fetch_assoc($classstudentResult)) {
$thisName = str_replace(" ","",htmlView($classstudentRow['userFirstName']."_".$classstudentRow['userLastName'])."_".$classstudentRow['userStudentId']);
if ($lastName != $thisName) {
echo "if NOT exist ".$courseRow['courseNumber']."\\".$thisName."\\ md ".$courseRow['courseNumber']."\\".$thisName.$eol;
$lastName = $thisName;
}
} // while ($classstudentRow = mysqli_fetch_assoc($classstudentResult)) {
#}
#echo $eol; // if ($classStudentCount) {
} // while ($classRow = mysqli_fetch_assoc($classResult)) {
} // if ($classCount) {
} // while ($courseRow = mysqli_fetch_assoc($courseResult)) {
?>
</textarea>
</td>
</tr>
</table>
<?
} else { // if ($courseCount) {
?>
<table cellpadding="0" cellspacing="0"><tr><th colspan="6">
You have no course links at this time.
<br> You may
<form action="CourseLinks.php" method="post" name="form_courseadd" id="form_courseadd" style="display:inline;">
<input name="f_uuid" type="hidden" value="<?=uuid()?>" />
<input name="f_form" type="hidden" value="form_courseadd" />
<input name="f_courseId" type="hidden" value="0" />
<input type="submit" name="f_task" value="Add" class="small" />
</form>
a course link.
</th></tr>
<tr><th colspan="6"> </th></tr></table>
<?
} // if ($courseCount) {
include('common/sectionFooter.phpinc');
debugTrackEnd();
include('common/pageFooter.phpinc');
?>