/**
* http://stackoverflow.com/a/4128377/2790481
*
* @param $needle
* @param $terms
* @param bool $strict
* @return bool
*/
function getTerm($needle, $terms, $strict = false)
{
foreach ($terms as $term) {
if (($strict ? $term === $needle : $term == $needle) || is_array($term) && getTerm($needle, $term, $strict)) {
return $term;
}
}
return false;
}
<?php
$subjectID = $_REQUEST['subjectID'];
$scoreType = $_REQUEST['scoreType'];
$addStatus = $_REQUEST['addStatus'];
$instructorID = $confUserID;
$term = getTerm();
$year = getYear();
$scoreID = $_REQUEST['scoreID'];
$objQuery = getStuRegList($subjectID, $instructorID, $year, $term);
if ($objQuery && mysql_num_rows($objQuery) > 0) {
while ($row = mysql_fetch_array($objQuery)) {
if ($scoreType == 'GRADE') {
$grade = getGrade($row['studentID'], $subjectID, $term, $year);
$select = '<select name="score" style="width: 80px;">';
$select .= '<option value="">--</option>';
$select .= '<option value="4"' . selected($grade, '4') . '>4.0</option>';
$select .= '<option value="3.5"' . selected($grade, '3.5') . '>3.5</option>';
$select .= '<option value="3"' . selected($grade, '3') . '>3.0</option>';
$select .= '<option value="2.5"' . selected($grade, '2.5') . '>2.5</option>';
$select .= '<option value="2"' . selected($grade, '2') . '>2.0</option>';
$select .= '<option value="1.5"' . selected($grade, '1.5') . '>1.5</option>';
$select .= '<option value="1"' . selected($grade, '1') . '>1.0</option>';
$select .= '<option value="0"' . selected($grade, '0') . '>0</option>';
$select .= '<option value="W"' . selected($grade, 'W') . '>W</option>';
$select .= '</select>';
$data['data'][] = array('cardID' => '<span style="display:none;">' . $row['cardID'] . '</span>', 'secondCardID' => '<span style="display:none;">' . $row['secondCardID'] . '</span>', 'studentID' => $row['studentID'], 'firstName' => $row['firstName'], 'lastName' => $row['lastName'], 'score' => '<input type="hidden" name="studentID" value="' . $row['studentID'] . '">' . $select);
} else {
$dataScore = $addStatus == '1' ? '' : getScore($scoreID, $row['studentID']);
$data['data'][] = array('cardID' => '<span style="display:none;">' . $row['cardID'] . '</span>', 'secondCardID' => '<span style="display:none;">' . $row['secondCardID'] . '</span>', 'studentID' => $row['studentID'], 'firstName' => $row['firstName'], 'lastName' => $row['lastName'], 'score' => '<input type="hidden" name="studentID" value="' . $row['studentID'] . '"><input type="text" name="score" value="' . $dataScore . '" />');
}
function radioTerm($t)
{
$check = '';
if (getTerm() == $t) {
$check = ' checked';
}
return $check;
}
public function view($page = 'home')
{
//require 'Globals.php';
//$enableCaching = false;
//require_once 'CacheConfig.php';
require_once 'JsonClientUtil.php';
require_once 'Config.php';
$this->load->helper('url');
$this->loadJsonConfig($data);
//init();
/*if ( ! file_exists(APPPATH.'/views/pages/'.$page.'.php'))
{
// Whoops, we don't have a page for that!
show_404();
}*/
$pageName = NULL;
$termObj = NULL;
$pageName = $page;
$pos = strpos($pageName, ":");
//echo "----pos:".$pos;
if ($pos == false) {
$pageName = str_replace("_", "%20", $page);
$pageName = str_replace(",", "%2c", $pageName);
$data["page"] = $page;
}
$isNifID = false;
$originalPageName = "";
//Loading sources configurations
$sources = $this->loadSourcesConfig($data);
if ($sources != null) {
$data['ks_sources'] = $sources;
}
//Loading categories configurations
$categories = $this->loadCategoriesConfig($data);
if ($categories != null) {
$data['categories'] = $categories;
}
if ($pos != false) {
$termObj[0] = getObjByCurie($pageName);
#echo "\n-------Willy----!is_null(termObj):".!is_null($termObj)."\n";
if (!is_null($termObj) && !is_null($termObj[0])) {
$data['curie'] = $termObj[0]->curie;
if (count($termObj[0]->labels) > 0) {
$data['pageName'] = $termObj[0]->labels[0];
$pageName = $data['pageName'];
//echo "PageName here-----".$pageName;
$originalPageName = $pageName;
$pageName = str_replace(" ", "%20", $pageName);
// echo "<br/>PageName here-----".$pageName;
$pageName = str_replace(",", "%2c", $pageName);
// echo "<br/>PageName here-----".$pageName;
$data['pageName'] = $pageName;
$isNifID = true;
} else {
$data['pageName'] = $pageName;
}
} else {
$data['pageName'] = $pageName;
$termObj = getTerm($pageName);
}
} else {
$data['pageName'] = $pageName;
//echo "-----pageName:".$pageName;
$termObj = getTerm($pageName);
//var_dump($termObj);
$protocol = !empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] !== 'off' || $_SERVER['SERVER_PORT'] == 443 ? "https://" : "http://";
$domainName = $_SERVER['HTTP_HOST'];
if (!is_null($termObj)) {
//echo "-------------termObj size: ".count($termObj);
if (count($termObj) == 1 && isset($termObj[0]) && !is_null($termObj[0]->curie)) {
//redirect('http://google.com', 'location');
redirect($protocol . "://" . $domainName . "/" . Config::$localContextName . "/index.php/pages/view/" . $termObj[0]->curie, 'refresh');
}
if (count($termObj) > 1) {
//http://localhost/NeuroKS/index.php/TermLanding/view/cerebellum%20purkinje%20cell
//redirect($protocol.":/".$domainName."/".Config::$localContextName."/index.php/Term/view/".$page, 'refresh');
$data['termObj'] = $termObj;
$temp_page_title = $pageName = str_replace(str_split('_,'), ' ', $page);
$data['page_title'] = "Term:" . $temp_page_title;
$data['enable_config'] = false;
//redirect('http://google.com', 'location');
//redirect($protocol."://".$domainName."/".Config::$localContextName."/index.php/pages/view/".$termObj[0]->curie, 'refresh');
//exit(0);
$this->load->view('templates/header2', $data);
$this->load->view('pages/DisplayTermLanding', $data);
$this->load->view('templates/footer2', $data);
return;
//exit(0);
}
$data['curie'] = $termObj[0]->curie;
}
}
//$pageName = str_replace(" ", "%20", $pageName);
//$pageName = str_replace(",", "%2c", $pageName);
//$pageName = str_replace("/", "%20", $pageName);
$pageName = str_replace(str_split('_'), '%20', $pageName);
$pageName = str_replace(str_split(','), '%2c', $pageName);
$pageName = str_replace(str_split('/'), '%20', $pageName);
$data['pageName'] = $pageName;
$data['page_title'] = $pageName;
$data['enable_config'] = true;
//////////////////////
$cachefile = '/webCache/' . basename($_SERVER['PHP_SELF']) . '.cache';
// e.g. cache/index.php.cache
$cachetime = 3600 * 24;
// time to cache in seconds
$c = "";
if ($this->enableCaching) {
if (!file_exists($cachefile)) {
//Do nothing
} else {
if (file_exists($cachefile) && time() - $cachetime <= filemtime($cachefile)) {
$c = @file_get_contents($cachefile);
echo $c;
exit;
} else {
unlink($cachefile);
}
}
///////////////////////
if (is_null($termObj)) {
show_404();
return;
}
ob_start();
}
///////////////////////////////////////////////////////
$this->handleSummary($data, $termObj, $pageName);
//$data['title'] = ucfirst($page); // Capitalize the first letter
$stitle = "";
if (!$isNifID) {
$stitle = ucfirst($page);
$stitle = str_replace("_", " ", $stitle);
$data['title'] = $stitle;
} else {
$stitle = $originalPageName;
$data['title'] = $stitle;
}
#echo "\nWilly--------pageName:".$pageName."\n";
$this->handleDataSpace($data, $pageName);
if (isset($termObj[0])) {
$this->handleLexicon($data, $termObj[0]->curie);
}
$this->handleLiterature($data, $pageName);
$this->load->view('templates/header2', $data);
//$this->load->view('pages/'.$page, $data);
//$this->load->view('pages/term', $data);
$this->load->view('pages/layout', $data);
$this->load->view('templates/footer2', $data);
///////////////////////////////////////////////
if ($this->enableCaching) {
$c = ob_get_contents();
file_put_contents($cachefile, $c);
}
}
<?php
$strSQL = sprintf("\n SELECT\n *\n FROM\n student\n WHERE\n instructorID = '%s'\n ", mysql_real_escape_string($confUserID));
if ($confUserType == 'instructor') {
$objQuery = mysql_query($strSQL);
if ($objQuery && mysql_num_rows($objQuery) > 0) {
while ($row = mysql_fetch_array($objQuery)) {
$gendata[] = array('studentID' => $row['studentID'], 'firstName' => $row['firstName'], 'lastName' => $row['lastName'], 'cardID' => "<span style='display:none;'>" . $row['cardID'] . "</span>", 'secondCardID' => "<span style='display:none;'>" . $row['secondCardID'] . "</span>", 'atd' => "<button name='viewAtd' data-studentID='" . $row['studentID'] . "'>ดูเวลาเรียน</button>", 'sco' => "<button name='viewSco' data-studentID='" . $row['studentID'] . "'>ดูคะแนน</button>", 'grade' => getAvgGrade($row['studentID'], getTerm(), getYear()));
}
$data['data'] = $gendata;
echo json_encode($data);
}
}
}
?>
<a href="javascript:showAttendance();" class="card-face__social" title="ดูข้อมูลเวลาเรียน">
<img src="images/clock.png" width="36" height="36" draggable="false"/>
</a>
<a href="javascript:showScore();" class="card-face__social" title="ดูข้อมูลคะแนน">
<img src="images/list.png" width="36" height="36" draggable="false"/>
</a>
<?php
if ($confUserType == 'instructor') {
?>
<a href="preview.php?type=gradeReport&studentID=<?php
echo $studentID;
?>
&term=<?php
echo getTerm();
?>
&year=<?php
echo getYear();
?>
" target="_blank" class="card-face__social" title="พิมพ์ใบเกรด">
<img src="images/print.png" width="36" height="36" draggable="false"/>
</a>
<?php
}
?>
<!-- <a href="https://plus.google.com/u/0/+MattiaAstorino/posts" target="_blank" class="card-face__social"> -->
<!-- <img src="http://imgh.us/plus_5.svg" width="36" height="36" draggable="false"/> -->
<!-- </a> -->
</div>
</div>
}
$return['subjectID'] = $subjectID;
} elseif ($tag == 'preview') {
$max = $_REQUEST['max'];
if ($subjectID && $max) {
$max = json_decode($max);
$maxPass = true;
for ($i = 0; $i < sizeof($max); $i++) {
if ($max[$i] == '' || $max[$i] == null || !isset($max[$i])) {
$maxPass = false;
break;
}
}
if ($maxPass) {
$maxScore = $max[7];
$strSQL = sprintf("\n SELECT\n stu.studentID,stu.firstName,stu.lastName,SUM(stusco.score) AS score\n FROM\n `studentscore` stusco RIGHT JOIN `student` stu ON stusco.studentID = stu.studentID\n WHERE\n stusco.scoreID IN\n (\n SELECT\n scoreID\n FROM\n scoreinfo\n WHERE\n subjectID = '%s' AND\n registerID =\n (\n SELECT\n registerID\n FROM\n registerinfo\n WHERE\n term = '%s' AND\n year = '%s'\n )\n ) OR (stu.studentID IN (\n SELECT\n studentID\n FROM\n `register-student` regstu\n WHERE\n regstu.subjectID = '%s' AND\n regstu.registerID =\n (\n SELECT\n registerID\n FROM\n registerinfo\n WHERE\n term = '%s' AND\n year = '%s'\n )\n ) AND stusco.subjectID IS NULL\n )\n GROUP BY\n studentID\n ", mysql_real_escape_string($subjectID), mysql_real_escape_string(getTerm()), mysql_real_escape_string(getYear()), mysql_real_escape_string($subjectID), mysql_real_escape_string(getTerm()), mysql_real_escape_string(getYear()), mysql_real_escape_string($subjectID));
$objQuery = mysql_query($strSQL);
if ($objQuery && mysql_num_rows($objQuery)) {
while ($row = mysql_fetch_assoc($objQuery)) {
$preData = $row;
if ($row['score'] == '') {
$preData['score'] = 0;
}
$grade = gradeCal(0, $max, 0, $row['score']);
$select = '<select name="grade" style="width: 80px;">';
// $select.= '<option value="">--</option>';
$select .= '<option value="' . $grade . '" selected>' . $grade . '</option>';
$select .= '<option value="W">W</option>';
$select .= '</select>';
$preData['grade'] = '<input type="hidden" name="studentID" value="' . $row['studentID'] . '">' . $select;
$preData['score'] = $preData['score'] . '/' . $maxScore;
public function summary($page)
{
require_once 'ServiceUtil.php';
$util = new ServiceUtil();
require_once 'Config.php';
$myConfig = new Config();
$myConfig->loadJsonConfig($data);
$pageName = NULL;
$termObj = NULL;
$pageName = $page;
$pos = strpos($pageName, ":");
//echo "----pos:".$pos;
if ($pos == false) {
$pageName = str_replace("_", "%20", $page);
$pageName = str_replace(",", "%2c", $pageName);
$data["page"] = $page;
}
$isNifID = false;
$originalPageName = "";
if ($pos != false) {
$termObj[0] = $util->getObjByCurie($pageName);
#echo "\n-------Willy----!is_null(termObj):".!is_null($termObj)."\n";
if (!is_null($termObj) && !is_null($termObj[0])) {
$data['curie'] = $termObj[0]->curie;
if (count($termObj[0]->labels) > 0) {
$data['pageName'] = $termObj[0]->labels[0];
$pageName = $data['pageName'];
$originalPageName = $pageName;
$pageName = str_replace(" ", "%20", $pageName);
$pageName = str_replace(",", "%2c", $pageName);
$data['pageName'] = $pageName;
$isNifID = true;
} else {
$data['pageName'] = $pageName;
}
} else {
$data['pageName'] = $pageName;
$termObj = getTerm($pageName);
}
}
$pageName = str_replace(str_split('_'), '%20', $pageName);
$pageName = str_replace(str_split(','), '%2c', $pageName);
$pageName = str_replace(str_split('/'), '%2f', $pageName);
$data['pageName'] = $pageName;
$data['page_title'] = $pageName;
$data['enable_config'] = true;
$stitle = "";
if (!$isNifID) {
$stitle = ucfirst($page);
$stitle = str_replace("_", " ", $stitle);
$data['title'] = $stitle;
} else {
$stitle = $originalPageName;
$data['title'] = $stitle;
}
$this->handleDataSpace($data, $pageName);
$this->load->view('api/view_summary', $data);
}
<?php
$scoreID = $_REQUEST['scoreID'];
$score = json_decode($_REQUEST['score']);
$studentID = json_decode($_REQUEST['studentID']);
$scoreType = $_REQUEST['scoreType'];
$subjectID = $_REQUEST['subjectID'];
$result['sizeOf'] = sizeof($score);
for ($i = 0; $i < sizeof($score); $i++) {
$result['data'][$studentID[$i]] = $score[$i];
if ($score[$i] != '') {
if ($scoreType == 'GRADE') {
if (!gradeSet($subjectID, getTerm(), getYear(), $studentID[$i], $score[$i])) {
$result['error'][$studentID[$i]] = TRUE;
}
} else {
if (!scoreSet($scoreID, $studentID[$i], $score[$i])) {
$result['error'][$studentID[$i]] = TRUE;
}
}
}
}
echo json_encode($result);
} elseif ($report == "score") {
$strSQL = sprintf("\n SELECT\n regstu.subjectID,sub.name,regstu.grade\n FROM\n `register-student` regstu,\n `subject` sub\n WHERE\n regstu.subjectID = sub.subjectID AND\n regstu.studentID = '%s' AND\n regstu.registerID =\n (\n SELECT\n registerID\n FROM\n `registerinfo`\n WHERE\n `term` = '%s' AND\n `year` = '%s'\n )\n ", mysql_real_escape_string($studentID), mysql_real_escape_string(getTerm()), mysql_real_escape_string(getYear()));
$objQuery = mysql_query($strSQL);
if ($objQuery && mysql_num_rows($objQuery) > 0) {
while ($row = mysql_fetch_array($objQuery)) {
$preData['grade'] = $row['grade'] != '' ? $row['grade'] : '--';
$preData['subjectID'] = $row['subjectID'];
$preData['subjectName'] = $row['name'];
$strSQL = sprintf("\n SELECT\n scoreID,maxScore\n FROM\n `scoreinfo`\n WHERE\n subjectID = '%s' AND\n registerID =\n (\n SELECT\n registerID\n FROM\n `registerinfo`\n WHERE\n `term` = '%s' AND\n `year` = '%s'\n )\n ", mysql_real_escape_string($row['subjectID']), mysql_real_escape_string(getTerm()), mysql_real_escape_string(getYear()));
$objQuery2 = mysql_query($strSQL);
if ($objQuery2 && mysql_num_rows($objQuery2) > 0) {
$maxScore = 0;
$sumScore = 0;
while ($row2 = mysql_fetch_array($objQuery2)) {
$maxScore += $row2['maxScore'];
$strSQL = sprintf("\n SELECT\n score\n FROM\n `studentscore`\n WHERE\n scoreID = '%s' AND\n subjectID = '%s' AND\n studentID = '%s' AND\n registerID =\n (\n SELECT\n registerID\n FROM\n `registerinfo`\n WHERE\n `term` = '%s' AND\n `year` = '%s'\n )\n ", mysql_real_escape_string($row2['scoreID']), mysql_real_escape_string($row['subjectID']), mysql_real_escape_string($studentID), mysql_real_escape_string(getTerm()), mysql_real_escape_string(getYear()));
$objQuery3 = mysql_query($strSQL);
if ($objQuery3 && mysql_num_rows($objQuery3) > 0) {
while ($row3 = mysql_fetch_array($objQuery3)) {
$sumScore += $row3['score'];
}
}
}
if ($confUserType == 'instructor') {
$preData['score'] = $sumScore . '/' . $maxScore;
}
$data['data'][] = $preData;
} else {
$preData['score'] = '--';
$data['data'][] = $preData;
}
<?php
$subjectID = $_REQUEST['subjectID'];
$scoreType = $_REQUEST['scoreType'];
$scoreMax = $_REQUEST['scoreMax'];
$scoreID = $_REQUEST['scoreID'];
$addStatus = $_REQUEST['addStatus'];
$date = date("Y-m-d H:i:s", time());
if ($addStatus == '1') {
if ($scoreType == 'GRADE') {
$data['status'] = 'SUCCESS';
echo json_encode($data);
exit;
}
$strSQL = sprintf("\n INSERT INTO\n scoreinfo\n (\n SELECT\n NULL,\n '%s',\n registerID,\n '%s',\n '%s',\n '%s'\n FROM\n registerinfo\n WHERE\n term = '%s' AND\n year = '%s'\n )\n ", mysql_real_escape_string($subjectID), mysql_real_escape_string($date), mysql_real_escape_string($scoreType), mysql_real_escape_string($scoreMax), mysql_real_escape_string(getTerm()), mysql_real_escape_string(getYear()));
$objQuery = mysql_query($strSQL);
$scoreID = mysql_insert_id();
$data['status'] = 'SUCCESS';
$data['strSQL'] = $strSQL;
$data['scoreID'] = $scoreID;
} elseif ($addStatus == '2') {
$strSQL = sprintf("\n UPDATE\n `scoreinfo`\n SET\n type = '%s',\n maxScore = '%s'\n WHERE\n scoreID = '%s'\n ", mysql_real_escape_string($scoreType), mysql_real_escape_string($scoreMax), mysql_real_escape_string($scoreID));
$objQuery = mysql_query($strSQL);
$data['status'] = 'SUCCESS';
$data['strSQL'] = $strSQL;
$data['scoreID'] = $scoreID;
} else {
$data['status'] = 'FAIL';
}
echo json_encode($data);
