/** * 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);