| 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/StudentProfile/List/ |
Upload File : |
<?
// StudentProfile/List/index.php
$TRACK = "<b>".basename(__FILE__).'</b> <span class="pv_fl">('.__FILE__.")</span>\n<ol>\n";
ini_set('include_path',ini_get('include_path').PATH_SEPARATOR.$_SERVER['DOCUMENT_ROOT']."/"); // Add the DOCUMENT_ROOT to the include_path.
#$skipAuthentication = true;
require('application.phpinc');
$headTitle = '_CST_ - Student Profiles'.'';
$pageTitle = '_CST_<br>Student Profiles'.'';
require('common/pageHeader.phpinc');
$sectionTitle = 'Student Profile ('.$_SESSION['YRTR']['User_NAME'].' only)';
require('common/sectionHeader.phpinc');
#d_Var('$_POST',$_POST,'d');
#exit;
require('Course/get_HTTP_REFERER.phpinc');
$sp_userId = '';
if ( $urlQuery != '' ) {
if ( stristr($urlQuery,'f_userId') !== false ) {
$urlQueryParts = explode('&',$urlQuery);
foreach ( $urlQueryParts as $urlQueryPart ) {
if ( stristr($urlQueryPart,'f_userId') !== false ) {
$sp_userId = explode('=',$urlQueryPart);
$sp_userId = '#user_'.$sp_userId[1];
}
}
}
} else {
$urlQuery = 'ph=';
}
#d_Var('$sp_userId',$sp_userId,'d');
#d_On();
if ( !isset($_SESSION['ORDERBY']) ) $_SESSION['ORDERBY'] = 'userFirstName';
if ( !isset($_SESSION['ORDER']) ) $_SESSION['ORDER'] = 'ASC';
$ORDER = formValue('ORDER','');
if ( !$ORDER ) $ORDER = $_SESSION['ORDER'];
$_SESSION['ORDER'] = $ORDER;
if ( $_SESSION['ORDER'] == 'ASC' ) {
$ORDERNEXT = 'DESC';
} else {
$ORDERNEXT = 'ASC';
}
$ORDERBY = formValue('ORDERBY','');
d_Var('$ORDERBY',$ORDERBY);
switch ( $ORDERBY ) {
case '':
$ORDERBY = $_SESSION['ORDERBY'];
break;
case 'StudentID':
$ORDERBY = 'userStudentId';
break;
case 'StarID':
$ORDERBY = 'userUsername';
break;
case 'First':
$ORDERBY = 'userFirstName';
break;
case 'Last':
$ORDERBY = 'userLastName';
break;
case 'Submitted':
$ORDERBY = 'studentprofileSubmitted';
break;
case 'Grade':
$ORDERBY = 'studentprofileSubmitted DESC, studentprofileGraded '.$_SESSION['ORDER'].', studentprofileGrade';
break;
}
$_SESSION['ORDERBY'] = $ORDERBY;
#d_Var("\$_SESSION['YRTR']['User_Start']",$_SESSION['YRTR']['User_Start'],'d');
$date_start=date_create($_SESSION['YRTR']['User_Start']);
date_sub($date_start,date_interval_create_from_date_string("2 days"));
#d_Var('$date_start',$date_start,'d');
$date_string = $date_start->format('Y-m-d H:i:s');
#d_Var('$date_string',$date_string,'d');
$query = "
SELECT user.*,
studentprofile.studentprofileId,
studentprofile.studentprofileImage,
studentprofile.studentprofileCredential,
studentprofile.studentprofilePrimaryCampus,
studentprofile.studentprofilePast,
studentprofile.studentprofileFuture,
studentprofile.studentprofileEmail1,
studentprofile.studentprofileEmail2,
studentprofile.studentprofilePhone1,
studentprofile.studentprofilePhone2,
studentprofile.studentprofilePhoneType1,
studentprofile.studentprofilePhoneType2,
studentprofile.studentprofileSubmitted,
studentprofile.studentprofileGraded,
IF ( studentprofile.studentprofileGrade = '' , 0, IFNULL(studentprofile.studentprofileGrade,0) ) AS studentprofileGrade,
studentprofile.studentprofileComment,
studentprofile.studentprofileInternalComment,
studentprofile.studentprofileGradedOn,
studentprofile.studentprofileGradedBy,
user.userUsername,
user.userId
FROM `studentprofile`
JOIN `user` ON user.userId = studentprofile.userId
WHERE studentprofile.lastModified BETWEEN '".query_safe($date_string)."' AND '".query_safe($_SESSION['YRTR']['User_End'])." 23:59:59'
OR ( studentprofile.studentprofileSubmitted = true AND studentprofile.studentprofileGraded = false )
ORDER BY ".$_SESSION['ORDERBY']." ".$_SESSION['ORDER']."
";
#d_Var('studentprofileResult',$query,'dq');
$studentprofileResult = query_do($query);
$studentprofileResultCount = $_SESSION['qry']['count'];
#d_Var('$studentprofileResultCount',$studentprofileResultCount,'d');
if ( $studentprofileResultCount ) {
?>
<h3>If a student is not listed below then they have not updated or submitted their Student Profile this semester.</h3>
Color coding: <span style="color:#FF9900;">Not submitted</span>, <span style="color:#0000C0;">Not graded</span>, or <span style="color:#008000;">Graded</span>
<table>
<tr>
<td></td>
<th><a href="?ORDERBY=StudentID&ORDER=<?=$ORDERNEXT?>" title="Order by StudentID">StudentID</a></th>
<th><a href="?ORDERBY=StarID&ORDER=<?=$ORDERNEXT?>" title="Order by StarID">StarID</a></th>
<th style="text-align:right;"><a href="?ORDERBY=First&ORDER=<?=$ORDERNEXT?>" title="Order by First name">First</a></th>
<th style="text-align:left;"><a href="?ORDERBY=Last&ORDER=<?=$ORDERNEXT?>" title="Order by Last name">Last</a></th>
<th style="text-align:right;"><a href="?ORDERBY=Grade&ORDER=<?=$ORDERNEXT?>" title="Order by Grade">Grade</a></th>
<th><a href="?ORDERBY=Submitted&ORDER=<?=$ORDERNEXT?>" title="Order by Submitted">Submitted</a></th>
<td></td>
</tr>
<?
mysqli_data_seek($studentprofileResult, 0);
while ($studentprofileRow = mysqli_fetch_assoc($studentprofileResult)) {
if ( $studentprofileRow['studentprofileSubmitted'] ) {
if ( $studentprofileRow['studentprofileGraded'] ) {
$spColor = 'color:#008000;'; // userGraded.
} else {
$spColor = 'color:#0000C0;'; // userUnGraded.
}
} else {
$spColor = 'color:#FF9900;'; //userNotSubmitted.
}
$trId = 'user_'.$studentprofileRow['userId'];
if ( $sp_userId != '#'.$trId ) {
$spColorBack = $spColor;
} else {
$spColorBack = $spColor.' background-color:#ff8;';
}
?>
<tr id="<?=$trId?>">
<td><a href="https://cst.ridgewater.edu/Admin/Class/?f_userId=<?=$studentprofileRow['userId']?>&f_task=Student%20Profile&f_subtask=View" target="_blank">View</a></td>
<td style="text-align:left; <?=$spColorBack?>;"><?=$studentprofileRow['userStudentId']?></td>
<td style="text-align:left; <?=$spColorBack?>;"><?=strtolower($studentprofileRow['userUsername'])?></td>
<td style="text-align:right; <?=$spColorBack?>;"><?=$studentprofileRow['userFirstName']?></td>
<td style="text-align:left; <?=$spColorBack?>;"><?=$studentprofileRow['userLastName']?></td>
<td style="text-align:right; <?=$spColorBack?>;"><? if ( $studentprofileRow['studentprofileGraded'] ) { ?><?=$studentprofileRow['studentprofileGrade']?>%<? } ?></td><?
if ( $studentprofileRow['studentprofileSubmitted'] && !$studentprofileRow['studentprofileGraded'] ) { $spColorBackGrade = $spColor.' background-color:#f88;'; } else { $spColorBackGrade = $spColorBack; } ?>
<td style="text-align:center; <?=$spColorBackGrade?>;"><? if ( $studentprofileRow['studentprofileSubmitted'] ) { ?>Yes<? } else { ?><span style="color:#FF9900;">No</span><? } ?></td>
<td style="text-align:left; <?=$spColorBack?>;"><a href="https://cst.ridgewater.edu/StudentProfile/?task=Student Profile&f_subtask=Grade&f_userId=<?=$studentprofileRow['userId']?>&sId=<?=$studentprofileRow['userStudentId']?>&List=List">Grade</a></td><!-- &ORDERBY=<?=$_SESSION['ORDERBY']?>&ORDER=<?=$_SESSION['ORDER']?> -->
</tr>
<? /** / <? d_Var("\$studentprofileRow['studentprofileGrade']",$studentprofileRow['studentprofileGrade'],'d'); ?> /**/
}
?>
</table>
<?
} else {
?><h3>No profiles.</h3><?
}
/** /
<td class="<?=$spColor?>"><?=$studentprofileRow['studentprofileGrade']?></td>
AND SUBSTRING(lastModified,0,10) <= ".query_safe($_SESSION['YRTR']['User_End'])."
#if ($studentprofileResultCount != 1) {
if ( $studentprofileResultCount ) {
$studentprofileRow = false;
$thisFile=__FILE__; $thisLine=__LINE__; require('common/pageHeader.phpinc');
$f_error = 'error_message_goes_here from query: "<span class="d_s_q">'.$query.'</span>".<span class="d_s_fl"> '.basename(__FILE__).':'.__LINE__.'</span><span class="d_s_fp"> '.basename(__FILE__).':'.__LINE__.'</span>';
$thisFile=__FILE__; $thisLine=__LINE__; require('common/displayErrorsAndMessages.phpinc');
$thisFile=__FILE__; $thisLine=__LINE__; require('common/pageFooter.phpinc');
}
/**/
#d_Var('studentprofileInfo',$query,'q');
#$studentprofileInfo = query_info($query);
#d_Var('$studentprofileInfo',$studentprofileInfo);
require('common/sectionFooter.phpinc');
#setDebugOn();
require('common/pageFooter.phpinc');
?>