public function listAll()
{
$toReturn['exams'] = examsList::where('examAcYear', $this->panelInit->selectAcYear)->get()->toArray();
if ($this->data['users']->role == "teacher") {
$toReturn['classes'] = classes::where('classAcademicYear', $this->panelInit->selectAcYear)->where('classTeacher', 'LIKE', '%"' . $this->data['users']->id . '"%')->get()->toArray();
} else {
$toReturn['classes'] = classes::where('classAcademicYear', $this->panelInit->selectAcYear)->get()->toArray();
}
$toReturn['userRole'] = $this->data['users']->role;
$newrole = $this->data['users']->newrole;
$newrole_array = json_decode($newrole);
$params = permissions::where('moduleId', 1)->where('permission', 1)->get();
$uniparam = array(5, 6, 7, 8, 15);
if ($toReturn['userRole'] == "teacher") {
if (array_intersect($newrole_array, $uniparam)) {
$toReturn['access'] = 1;
} else {
$toReturn['access'] = 0;
}
} elseif ($toReturn['userRole'] == "admin") {
$toReturn['access'] = 1;
} else {
$toReturn['access'] = 0;
}
$toReturn['newuserRole'] = $this->data['users']->newrole;
return $toReturn;
}
public function preAttendaceStats()
{
$toReturn = array();
$classes = classes::where('classAcademicYear', $this->panelInit->selectAcYear)->get();
$toReturn['classes'] = array();
$subjList = array();
foreach ($classes as $class) {
$class['classSubjects'] = json_decode($class['classSubjects'], true);
if (is_array($class['classSubjects'])) {
foreach ($class['classSubjects'] as $subject) {
$subjList[] = $subject;
}
}
$toReturn['classes'][$class->id] = $class->className;
}
$subjList = array_unique($subjList);
if ($this->data['panelInit']->settingsArray['attendanceModel'] == "subject") {
$toReturn['subjects'] = array();
if (count($subjList) > 0) {
$subjects = subject::whereIN('id', $subjList)->get();
foreach ($subjects as $subject) {
$toReturn['subjects'][$subject->id] = $subject->subjectTitle;
}
}
}
$toReturn['role'] = $this->data['users']->role;
$toReturn['attendanceModel'] = $this->data['panelInit']->settingsArray['attendanceModel'];
return $toReturn;
}
public function listAll()
{
$toReturn = array();
$toReturn['classes'] = classes::where('classAcademicYear', $this->panelInit->selectAcYear)->get()->toArray();
$toReturn['subject'] = subject::get()->toArray();
$toReturn['days'] = $arrayOfDays = array(0 => $this->panelInit->language['Sunday'], 1 => $this->panelInit->language['Monday'], 2 => $this->panelInit->language['Tuesday'], 3 => $this->panelInit->language['Wednesday'], 4 => $this->panelInit->language['Thurusday'], 5 => $this->panelInit->language['Friday'], 6 => $this->panelInit->language['Saturday']);
$toReturn['userRole'] = $this->data['users']->role;
return $toReturn;
}
static function InsertNewClassFromFranchise($data)
{
$insert = new classes();
$insert->class_name = $data['className'];
$getSlug = ClassesMaster::select('slug', 'id')->where('class_name', '=', $data['className'])->get();
//return $getSlug[0]['slug'];
$insert->slug = $getSlug[0]['slug'];
$insert->base_price_no = $data['basePriceNo'];
$insert->course_id = $data['Course_id'];
$insert->franchisee_id = Session::get('franchiseId');
$insert->class_master_id = $getSlug[0]['id'];
$insert->created_by = Session::get('userId');
$insert->updated_by = Session::get('userId');
$insert->save();
return $insert;
}
public function listAll()
{
$toReturn = array();
$toReturn['classes'] = classes::where('classAcademicYear', $this->panelInit->selectAcYear)->get()->toArray();
$classesArray = array();
while (list(, $class) = each($toReturn['classes'])) {
$classesArray[$class['id']] = $class['className'];
}
$toReturn['subject'] = subject::get()->toArray();
$subjectArray = array();
while (list(, $subject) = each($toReturn['subject'])) {
$subjectArray[$subject['id']] = $subject['subjectTitle'];
}
$toReturn['materials'] = array();
$studyMaterial = new studyMaterial();
if ($this->data['users']->role == "student") {
$studyMaterial = $studyMaterial->where('class_id', 'LIKE', '%"' . $this->data['users']->studentClass . '"%');
}
if ($this->data['users']->role == "teacher") {
$studyMaterial = $studyMaterial->where('teacher_id', $this->data['users']->id);
}
$studyMaterial = $studyMaterial->get();
foreach ($studyMaterial as $key => $material) {
$classId = json_decode($material->class_id);
if ($this->data['users']->role == "student" and !in_array($this->data['users']->studentClass, $classId)) {
continue;
}
$toReturn['materials'][$key]['id'] = $material->id;
$toReturn['materials'][$key]['subjectId'] = $material->subject_id;
$toReturn['materials'][$key]['subject'] = $subjectArray[$material->subject_id];
$toReturn['materials'][$key]['material_title'] = $material->material_title;
$toReturn['materials'][$key]['material_description'] = $material->material_description;
$toReturn['materials'][$key]['material_file'] = $material->material_file;
$toReturn['materials'][$key]['classes'] = "";
if (is_array($classId)) {
while (list(, $value) = each($classId)) {
if (isset($classesArray[$value])) {
$toReturn['materials'][$key]['classes'] .= $classesArray[$value] . ", ";
}
}
}
}
$toReturn['userRole'] = $this->data['users']->role;
return $toReturn;
exit;
}
<?php
/**
* Create a quiz
*/
if ($_SESSION['username'] != "") {
require_once 'web/core/navigation.php';
if ($_SESSION['utype'] >= '5') {
// get and initiate the course class to access the functions
require_once 'src/core/controller/classes.php';
$ObjClass = new classes();
require_once 'src/core/controller/quiz.php';
$ObjQuiz = new quiz();
// set class id for form and links
if ($_POST['classid'] != "") {
$classid = $_POST['classid'];
} else {
$classid = $d;
}
if ($_POST['y'] == 'quiz' && $_POST['z'] == 'create' && $_POST['action'] == "save") {
$createContent = $ObjQuiz->createQuiz($_POST['quizTitle'], $_POST['quizState'], $_POST['quizDescription'], $ObjClass->convertUUIDToClassID($_POST['classid']));
if ($createContent !== false) {
$responseMsg = "Your quiz has been created successfully";
} else {
$responseMsg = "Could not create your quiz at this time - something went wrong, sorry";
}
}
// create the view for coursek information
require_once 'web/core/quiz/create.php';
} else {
require_once 'web/core/security/insufficientrights.php';
function export($id, $type)
{
if ($this->data['users']->role != "admin") {
exit;
}
if ($type == "excel") {
$classArray = array();
$classes = classes::get();
foreach ($classes as $class) {
$classArray[$class->id] = $class->className;
}
$data = array(1 => array('Student Roll', 'Full Name', 'Date took', 'Exam Grade'));
$grades = \DB::table('onlineExamsGrades')->where('examId', $id)->leftJoin('users', 'users.id', '=', 'onlineExamsGrades.studentId')->select('onlineExamsGrades.id as id', 'onlineExamsGrades.examGrade as examGrade', 'onlineExamsGrades.examDate as examDate', 'users.fullName as fullName', 'users.id as studentId', 'users.studentRollId as studentRollId')->get();
foreach ($grades as $value) {
$data[] = array($value->studentRollId, $value->fullName, date("m/d/y", $value->examDate), $value->examGrade);
}
$xls = new Excel_XML('UTF-8', false, 'Exam grades Sheet');
$xls->addArray($data);
$xls->generateXML('Exam grades Sheet');
} elseif ($type == "pdf") {
$classArray = array();
$classes = classes::get();
foreach ($classes as $class) {
$classArray[$class->id] = $class->className;
}
$header = array('Student Roll', 'Full Name', 'Date took', 'Exam Grade');
$data = array();
$grades = \DB::table('onlineExamsGrades')->where('examId', $id)->leftJoin('users', 'users.id', '=', 'onlineExamsGrades.studentId')->select('onlineExamsGrades.id as id', 'onlineExamsGrades.examGrade as examGrade', 'onlineExamsGrades.examDate as examDate', 'users.fullName as fullName', 'users.id as studentId', 'users.studentRollId as studentRollId')->get();
foreach ($grades as $value) {
$data[] = array($value->studentRollId, $value->fullName, date("m/d/y", $value->examDate), $value->examGrade);
}
$pdf = new FPDF();
$pdf->SetFont('Arial', '', 10);
$pdf->AddPage();
// Header
foreach ($header as $col) {
$pdf->Cell(60, 7, $col, 1);
}
$pdf->Ln();
// Data
foreach ($data as $row) {
foreach ($row as $col) {
$pdf->Cell(60, 6, $col, 1);
}
$pdf->Ln();
}
$pdf->Output();
}
exit;
}
private function rewrite_tree_node($node_html, $new_classes)
{
$opening_tag = strstr($node_html, ' ', true);
$pattern = '/class=\\"([^"]+)/';
if (preg_match($pattern, $node_html, $matches)) {
$existing_classes = $matches[1];
$new_classes = classes::add_to($new_classes, $existing_classes);
}
$node_html = substr($node_html, strlen($opening_tag));
$node_html = substr($node_html, 0, -1 * strlen($opening_tag));
return '<a class="' . implode(' ', $new_classes) . '"' . $node_html . 'a>';
}
function export($type)
{
if ($this->data['users']->role != "admin") {
exit;
}
if ($type == "excel") {
$classArray = array();
$classes = classes::get();
foreach ($classes as $class) {
$classArray[$class->id] = $class->className;
}
$data = array(1 => array('Title', 'Description', 'Student', 'Amount', 'Date', 'Status'));
$payments = \DB::table('payments')->leftJoin('users', 'users.id', '=', 'payments.paymentStudent')->select('payments.id as id', 'payments.paymentTitle as paymentTitle', 'payments.paymentDescription as paymentDescription', 'payments.paymentAmount as paymentAmount', 'payments.paymentStatus as paymentStatus', 'payments.paymentDate as paymentDate', 'payments.paymentStudent as studentId', 'users.fullName as fullName')->get();
foreach ($payments as $value) {
if ($value->paymentStatus == 1) {
$paymentStatus = "PAID";
} else {
$paymentStatus = "UNPAID";
}
$data[] = array($value->paymentTitle, $value->paymentDescription, $value->fullName, $value->paymentAmount, $value->paymentDate, $paymentStatus);
}
$xls = new Excel_XML('UTF-8', false, 'Students Sheet');
$xls->addArray($data);
$xls->generateXML('Students-Sheet');
} elseif ($type == "pdf") {
$classArray = array();
$classes = classes::get();
foreach ($classes as $class) {
$classArray[$class->id] = $class->className;
}
$header = array('Title', 'Description', 'Student', 'Amount', 'Date', 'Status');
$data = array();
$payments = \DB::table('payments')->leftJoin('users', 'users.id', '=', 'payments.paymentStudent')->select('payments.id as id', 'payments.paymentTitle as paymentTitle', 'payments.paymentDescription as paymentDescription', 'payments.paymentAmount as paymentAmount', 'payments.paymentStatus as paymentStatus', 'payments.paymentDate as paymentDate', 'payments.paymentStudent as studentId', 'users.fullName as fullName')->get();
foreach ($payments as $value) {
if ($value->paymentStatus == 1) {
$paymentStatus = "PAID";
} else {
$paymentStatus = "UNPAID";
}
$data[] = array($value->paymentTitle, $value->paymentDescription, $value->fullName, $value->paymentAmount, $value->paymentDate, $paymentStatus);
}
$pdf = new FPDF();
$pdf->SetFont('Arial', '', 10);
$pdf->AddPage();
// Header
foreach ($header as $col) {
$pdf->Cell(40, 7, $col, 1);
}
$pdf->Ln();
// Data
foreach ($data as $row) {
foreach ($row as $col) {
$pdf->Cell(40, 6, $col, 1);
}
$pdf->Ln();
}
$pdf->Output();
}
exit;
}
$out['CONTROLPANEL']=1;
}
$qry="1";
// search filters
if (IsSet($this->object_id)) {
$object_id=$this->object_id;
$qry.=" AND OBJECT_ID='".$this->object_id."'";
} else {
global $object_id;
}
if (IsSet($this->class_id)) {
$class_id=$this->class_id;
$qry.=" AND CLASS_ID='".$this->class_id."'";
include_once(DIR_MODULES.'classes/classes.class.php');
$cl=new classes();
$out['PARENT_METHODS']=$cl->getParentMethods($this->class_id);
if (!$out['PARENT_METHODS'][0]['ID']) {
unset($out['PARENT_METHODS']);
}
} else {
global $class_id;
}
// QUERY READY
global $save_qry;
if ($save_qry) {
$qry=$session->data['methods_qry'];
} else {
$session->data['methods_qry']=$qry;
$my_meth['ID'] = SQLInsert('methods', $my_meth);
}
$out['OK'] = 1;
}
}
if (!$my_meth['ID']) {
$out['CALL_PARENT'] = 1;
} else {
$out['CODE'] = htmlspecialchars($my_meth['CODE']);
$out['SCRIPT_ID'] = $my_meth['SCRIPT_ID'];
$out['CALL_PARENT'] = (int) $my_meth['CALL_PARENT'];
}
$out['OVERWRITE'] = 1;
}
include_once DIR_MODULES . 'classes/classes.class.php';
$cl = new classes();
$methods = $cl->getParentMethods($rec['CLASS_ID'], '', 1);
$total = count($methods);
for ($i = 0; $i < $total; $i++) {
$my_meth = SQLSelectOne("SELECT ID FROM methods WHERE OBJECT_ID='" . $rec['ID'] . "' AND TITLE LIKE '" . DBSafe($methods[$i]['TITLE']) . "'");
if ($my_meth['ID']) {
$methods[$i]['CUSTOMIZED'] = 1;
}
}
$out['METHODS'] = $methods;
}
// step: history
if ($this->tab == 'history') {
}
if (is_array($rec)) {
foreach ($rec as $k => $v) {
<?php
/**
* Delete a class
*/
if ($_SESSION['username'] != "") {
require_once 'web/core/navigation.php';
// get and initiate the course class to access the functions
require_once 'src/core/controller/classes.php';
$ObjClass = new classes();
// Set what we are loading up for editing
if ($d) {
$classid = $d;
} elseif ($_POST['classid'] != "") {
$classid = $_POST['classid'];
} else {
$classid = "";
}
// If a valid id comes forth then utilise that to load data or save
if ($classid) {
$classid = $ObjClass->convertUUIDToClassID($classid);
// Update information if it has ben requested
if ($_POST['action'] == "remove" && $classid != "") {
$deleteClass = $ObjClass->deleteClass($classid);
if ($createClass !== false) {
$responseMsg = "Your class has been removed successfully";
} else {
$responseMsg = "Could not remove your class at this time - something went wrong, sorry";
}
}
// else display the information
public function proceed()
{
if (Input::get('nextStep') == "1") {
if (filter_var(Input::get('email'), FILTER_VALIDATE_EMAIL)) {
if (!Auth::attempt(array('email' => Input::get('email'), 'password' => Input::get('password'), 'activated' => 1, 'role' => 'admin'))) {
$loginError = false;
$this->data['loginError'] = "loginError";
}
} else {
if (!Auth::attempt(array('username' => Input::get('email'), 'password' => Input::get('password'), 'activated' => 1, 'role' => 'admin'))) {
$loginError = false;
$this->data['loginError'] = "loginError";
}
}
if (!isset($loginError)) {
file_put_contents('app/storage/meta/lc', Input::get('cpc'));
if ($this->sbApi() == "err") {
@unlink('app/storage/meta/lc');
$this->data['installErrors'][] = "Purchase code is missing";
$loginError = false;
$this->data['loginError'] = "loginError";
}
}
$this->data['currStep'] = "welcome";
if (!isset($loginError)) {
$this->data['currStep'] = "1";
$this->data['nextStep'] = "2";
$testData = uniqid();
@file_put_contents("uploads/assignments/test", $testData);
@file_put_contents("uploads/books/test", $testData);
@file_put_contents("uploads/cache/test", $testData);
@file_put_contents("uploads/media/test", $testData);
@file_put_contents("uploads/profile/test", $testData);
@file_put_contents("uploads/studyMaterial/test", $testData);
@file_put_contents("uploads/assignmentsAnswers/test", $testData);
@file_put_contents("app/storage/cache/test", $testData);
@file_put_contents("app/storage/logs/test", $testData);
@file_put_contents("app/storage/meta/test", $testData);
@file_put_contents("app/storage/sessions/test", $testData);
@file_put_contents("app/storage/views/test", $testData);
if (@file_get_contents("uploads/assignments/test") != $testData) {
$this->data['perrors'][] = "uploads/assignments";
$this->data['nextStep'] = "1";
} else {
$this->data['success'][] = "uploads/assignments";
}
if (@file_get_contents("uploads/books/test") != $testData) {
$this->data['perrors'][] = "uploads/books";
$this->data['nextStep'] = "1";
} else {
$this->data['success'][] = "uploads/books";
}
if (@file_get_contents("uploads/cache/test") != $testData) {
$this->data['perrors'][] = "uploads/cache";
$this->data['nextStep'] = "1";
} else {
$this->data['success'][] = "uploads/cache";
}
if (@file_get_contents("uploads/media/test") != $testData) {
$this->data['perrors'][] = "uploads/media";
$this->data['nextStep'] = "1";
} else {
$this->data['success'][] = "uploads/media";
}
if (@file_get_contents("uploads/profile/test") != $testData) {
$this->data['perrors'][] = "uploads/profile";
$this->data['nextStep'] = "1";
} else {
$this->data['success'][] = "uploads/profile";
}
if (@file_get_contents("uploads/studyMaterial/test") != $testData) {
$this->data['perrors'][] = "uploads/studyMaterial";
$this->data['nextStep'] = "1";
} else {
$this->data['success'][] = "uploads/studyMaterial";
}
if (@file_get_contents("uploads/assignmentsAnswers/test") != $testData) {
$this->data['perrors'][] = "uploads/assignmentsAnswers";
$this->data['nextStep'] = "1";
} else {
$this->data['success'][] = "uploads/assignmentsAnswers";
}
if (@file_get_contents("app/storage/cache/test") != $testData) {
$this->data['perrors'][] = "app/storage/cache";
$this->data['nextStep'] = "1";
} else {
$this->data['success'][] = "app/storage/cache";
}
if (@file_get_contents("app/storage/logs/test") != $testData) {
$this->data['perrors'][] = "app/storage/logs";
$this->data['nextStep'] = "1";
} else {
$this->data['success'][] = "app/storage/logs";
}
if (@file_get_contents("app/storage/meta/test") != $testData) {
$this->data['perrors'][] = "app/storage/meta";
$this->data['nextStep'] = "1";
} else {
$this->data['success'][] = "app/storage/meta";
}
if (@file_get_contents("app/storage/sessions/test") != $testData) {
$this->data['perrors'][] = "app/storage/sessions";
$this->data['nextStep'] = "1";
} else {
$this->data['success'][] = "app/storage/sessions";
}
if (@file_get_contents("app/storage/views/test") != $testData) {
$this->data['perrors'][] = "app/storage/views";
$this->data['nextStep'] = "1";
} else {
$this->data['success'][] = "app/storage/views";
}
}
}
if (Input::get('nextStep') == "2") {
$this->data['currStep'] = "2";
$this->data['nextStep'] = "3";
$testInstalled = settings::where('fieldName', 'thisVersion')->first();
if ($testInstalled->fieldValue == "1.2" || $testInstalled->fieldValue == "1.3") {
//Upgrade from first version to 1.4
DB::unprepared(file_get_contents('app/storage/dbsqlUp14'));
$settings = settings::where('fieldName', 'thisVersion')->first();
$settings->fieldValue = '1.4';
$settings->save();
$testInstalled->fieldValue = "1.4";
}
if ($testInstalled->fieldValue == "1.4") {
//Upgrade from first version to 1.4
DB::unprepared(file_get_contents('app/storage/dbsqlUp20'));
//Classes and relation with subjects
$classes = classes::get();
foreach ($classes as $class) {
$classesUpdateArray = array();
$subjects = subject::where('classId', $class->id)->get();
foreach ($subjects as $subject) {
$classesUpdateArray[] = $subject->id;
}
$classesUpdateArray = json_encode($classesUpdateArray);
classes::where('id', $class->id)->update(array('classSubjects' => $classesUpdateArray));
unset($classesUpdateArray);
}
//create academic years
$users = User::where('role', 'student')->get();
foreach ($users as $user) {
$studentAcademicYears = new studentAcademicYears();
$studentAcademicYears->studentId = $user->id;
$studentAcademicYears->academicYearId = 1;
$studentAcademicYears->classId = $user->studentClass;
$studentAcademicYears->save();
}
DB::unprepared('ALTER TABLE `subject` CHANGE `teacherId` `teacherId` int(250) NOT NULL after `subjectTitle` ,DROP COLUMN `classId` ;');
$settings = settings::where('fieldName', 'thisVersion')->first();
$settings->fieldValue = '2.0';
$settings->save();
}
}
if (Input::get('nextStep') == "3") {
$this->data['currStep'] = "3";
$settings = settings::where('fieldName', 'thisVersion')->first();
$settings->fieldValue = '1.4';
$settings->save();
}
return View::make('upgrade', $this->data);
}
protected function disabled_navigation_node(navigation_node $node, $wrap = true)
{
$items = $node->children;
if ($items->count() == 0) {
return '';
}
foreach ($items as $item) {
if (!$item->display) {
continue;
}
$isbranch = $item->children->count() > 0 || $item->nodetype == navigation_node::NODETYPE_BRANCH;
if ($isbranch) {
$item->hideicon = true;
}
$content = $this->output->render($item);
$classes = 'tree_item';
$expanded = 'true';
if (!$item->forceopen || !$item->forceopen && $item->collapse || $item->children->count() == 0 && $item->nodetype == navigation_node::NODETYPE_BRANCH) {
$classes = classes::add_to($classes, 'collapsed');
if ($isbranch) {
$expanded = "false";
$classes = classes::add_to($classes, 'branch');
}
}
if ($item->isactive === true) {
$classes = classes::add_to($classes, 'active');
}
$attributes = array('class' => $classes, 'aria-expanded' => $expanded);
$content .= $this->navigation_node($item);
$lis[] = html::li($attributes, $content);
}
$output = implode($lis);
if ($wrap) {
return html::ul('nav nav-list block_tree', $output);
}
return $output;
}
<?php
/**
* View a course
*/
if ($_SESSION['username'] != "") {
if ($_SESSION['utype'] >= '5') {
require_once 'web/core/navigation.php';
// get and initiate the course class to access the functions
require_once 'src/core/controller/classes.php';
$ObjClass = new classes();
if ($_POST['y'] == 'class' && $_POST['z'] == 'create' && $_POST['action'] == "save") {
$createClass = $ObjClass->createClass($_POST['className'], $_POST['classTutor'], $_POST['classDescription'], $_POST['classState'], $_POST['classSubject'], $_POST['classSet']);
if ($createClass !== false) {
$responseMsg = "Your class has been created successfully";
} else {
$responseMsg = "Could not create your class at this time - something went wrong, sorry";
}
}
// create the view for course information
require_once 'web/core/class/create.php';
} else {
require_once 'web/core/security/insufficientrights.php';
}
} else {
require_once 'web/core/login/index.php';
}
/**
* @dataProvider replace
* @depends test_replace
*/
public function test_replace_in_array($existing, $replacements, $expected)
{
$attributes['class'] = $existing;
$actual = classes::replace($attributes, $replacements);
$this->assertArrayHasKey('class', $actual);
$this->assertSame($expected, $actual['class']);
$attributes = array();
$actual = classes::replace($attributes, $replacements);
$this->assertArrayHasKey('class', $actual);
$this->assertSame('', $actual['class']);
}
public function registerClasses()
{
return classes::where('classAcademicYear', $this->panelInit->selectAcYear)->get();
}
function profile($id)
{
$data = User::where('role', 'student')->where('id', $id)->first()->toArray();
$data['birthday'] = date('m/d/Y', $data['birthday']);
if ($data['studentClass'] != "" and $data['studentClass'] != "0") {
$class = classes::where('id', $data['studentClass'])->first();
}
$return = array();
$return['title'] = $data['fullName'] . " " . $this->panelInit->language['Profile'];
$return['content'] = "<div class='text-center'>";
$return['content'] .= "<img alt='" . $data['fullName'] . "' class='user-image img-circle' style='width:70px; height:70px;' src='dashboard/profileImage/" . $data['id'] . "'>";
$return['content'] .= "</div>";
$return['content'] .= "<h4>" . $this->panelInit->language['studentInfo'] . "</h4>";
$return['content'] .= "<table class='table table-bordered'><tbody>\n <tr>\n <td>" . $this->panelInit->language['FullName'] . "</td>\n <td>" . $data['fullName'] . "</td>\n </tr>\n <tr>\n <td>" . $this->panelInit->language['rollid'] . "</td>\n <td>" . $data['studentRollId'] . "</td>\n </tr>";
if (isset($class)) {
$return['content'] .= "<tr>\n\t <td>" . $this->panelInit->language['class'] . "</td>\n\t <td>" . $class->className . "</td>\n\t </tr>";
}
$return['content'] .= "<tr>\n <td>" . $this->panelInit->language['username'] . "</td>\n <td>" . $data['username'] . "</td>\n </tr>\n <tr>\n <td>" . $this->panelInit->language['email'] . "</td>\n <td>" . $data['email'] . "</td>\n </tr>\n <tr>\n <td>" . $this->panelInit->language['Birthday'] . "</td>\n <td>" . $data['birthday'] . "</td>\n </tr>\n <tr>\n <td>" . $this->panelInit->language['Gender'] . "</td>\n <td>" . $data['gender'] . "</td>\n </tr>\n <tr>\n <td>" . $this->panelInit->language['Address'] . "</td>\n <td>" . $data['address'] . "</td>\n </tr>\n <tr>\n <td>" . $this->panelInit->language['phoneNo'] . "</td>\n <td>" . $data['phoneNo'] . "</td>\n </tr>\n <tr>\n <td>" . $this->panelInit->language['mobileNo'] . "</td>\n <td>" . $data['mobileNo'] . "</td>\n </tr>\n\n </tbody></table>";
return $return;
}
public function getStats($date = "")
{
if ($date == "") {
$date = date('m/Y');
}
$date = explode("/", $date);
$toReturn = array();
$classes = classes::where('classAcademicYear', $this->panelInit->selectAcYear)->get();
$toReturn['classes'] = array();
$subjList = array();
foreach ($classes as $class) {
$class['classSubjects'] = json_decode($class['classSubjects'], true);
if (is_array($class['classSubjects'])) {
foreach ($class['classSubjects'] as $subject) {
$subjList[] = $subject;
}
}
$toReturn['classes'][$class->id] = $class->className;
}
$subjList = array_unique($subjList);
if ($this->data['panelInit']->settingsArray['attendanceModel'] == "subject") {
$toReturn['subjects'] = array();
if (count($subjList) > 0) {
$subjects = subject::whereIN('id', $subjList)->get();
foreach ($subjects as $subject) {
$toReturn['subjects'][$subject->id] = $subject->subjectTitle;
}
}
}
$toReturn['role'] = $this->data['users']->role;
$toReturn['attendanceModel'] = $this->data['panelInit']->settingsArray['attendanceModel'];
if ($this->data['users']->role == "admin" || $this->data['users']->role == "teacher") {
$attendanceArray = attendance::where('date', 'like', $date[0] . "%")->where('date', 'like', "%" . $date[1])->orderBy('date')->get();
foreach ($attendanceArray as $value) {
$dateHere = str_replace("/" . $date[1], "", $value->date);
$dateHere = str_replace($date[0] . "/", "", $dateHere);
$dateHere = preg_replace('/^0/', "", $dateHere);
if (!isset($toReturn['attendance'][$dateHere][0])) {
$toReturn['attendance'][$dateHere][0] = 0;
$toReturn['attendance'][$dateHere][1] = 0;
$toReturn['attendance'][$dateHere][2] = 0;
$toReturn['attendance'][$dateHere][3] = 0;
$toReturn['attendance'][$dateHere][4] = 0;
}
$toReturn['attendance'][$dateHere][$value->status]++;
}
$attendanceArrayToday = attendance::where('date', date('m/d/Y'))->get();
if ($this->data['panelInit']->settingsArray['attendanceModel'] == "subject") {
foreach ($attendanceArrayToday as $value) {
if (isset($toReturn['subjects'][$value->subjectId])) {
if (!isset($toReturn['attendanceDay'][$toReturn['subjects'][$value->subjectId]])) {
$toReturn['attendanceDay'][$toReturn['subjects'][$value->subjectId]] = 0;
}
$toReturn['attendanceDay'][$toReturn['subjects'][$value->subjectId]]++;
}
}
} else {
foreach ($attendanceArrayToday as $value) {
if (isset($toReturn['classes'][$value->classId])) {
if (!isset($toReturn['attendanceDay'][$toReturn['classes'][$value->classId]])) {
$toReturn['attendanceDay'][$toReturn['classes'][$value->classId]] = 0;
}
$toReturn['attendanceDay'][$toReturn['classes'][$value->classId]]++;
}
}
}
} elseif ($this->data['users']->role == "student") {
$attendanceArray = attendance::where('studentId', $this->data['users']->id)->where('date', 'like', $date[0] . "%")->where('date', 'like', "%" . $date[1])->get();
foreach ($attendanceArray as $value) {
$toReturn['studentAttendance'][] = array("date" => $value->date, "status" => $value->status, "subject" => isset($toReturn['subjects'][$value->subjectId]) ? $toReturn['subjects'][$value->subjectId] : "");
}
} elseif ($this->data['users']->role == "parent") {
if ($this->data['users']->parentOf != "") {
$parentOf = json_decode($this->data['users']->parentOf, true);
$ids = array();
while (list(, $value) = each($parentOf)) {
$ids[] = $value['id'];
}
$studentArray = User::where('role', 'student')->whereIn('id', $ids)->get();
foreach ($studentArray as $stOne) {
$students[$stOne->id] = array('name' => $stOne->fullName, 'studentRollId' => $stOne->studentRollId);
}
if (count($ids) > 0) {
$attendanceArray = attendance::whereIn('studentId', $ids)->where('date', 'like', $date[0] . "%")->where('date', 'like', "%" . $date[1])->get();
foreach ($attendanceArray as $value) {
if (!isset($toReturn['studentAttendance'][$value->studentId])) {
$toReturn['studentAttendance'][$value->studentId]['n'] = $students[$value->studentId];
$toReturn['studentAttendance'][$value->studentId]['d'] = array();
}
$toReturn['studentAttendance'][$value->studentId]['d'][] = array("date" => $value->date, "status" => $value->status, "subject" => $value->subjectId);
}
}
}
}
return $toReturn;
}
<?php
/*
* Remove stored content from the system
*/
if ($_SESSION['username'] != "") {
require_once 'web/core/navigation.php';
if ($_SESSION['utype'] >= 3) {
// get and initiate the course class to access the functions
require_once 'src/core/controller/classes.php';
$ObjClass = new classes();
require_once 'src/core/controller/content.php';
$ObjContent = new content();
if ($d) {
$documentID = $d;
} elseif ($_POST['docid']) {
$documentID = $_POST['docid'];
} else {
$documentID = "";
}
if ($documentID) {
if ($_POST['action'] == "confirm") {
// Remove the document
$deleteDoc = $ObjContent->deleteDoc($documentID);
if ($deleteDoc) {
$responseMsg = "Your document has been marked for removal";
} else {
$responseMsg = "I couldn't mark this for removal right now, please try again.";
}
}
$document = $ObjContent->getSingleDocument($ObjContent->convertUUIDToDocumentID($documentID));
<?php
/**
* Create a register - build the view and form to create a register
*/
if ($_SESSION['username'] != "") {
if ($_SESSION['utype'] >= '5') {
require_once 'web/core/navigation.php';
// get and initiate the course class to access the functions
require_once 'src/core/controller/classes.php';
$ObjClass = new classes();
require_once 'src/core/controller/register.php';
$ObjRegister = new register();
if ($_POST['y'] == 'register' && $_POST['z'] == 'create' && $_POST['action'] == "save") {
$saveRegister = $ObjRegister->storeRegister($ObjClass->convertUUIDToClassID($_POST['classid']), $ObjAkonga->usernametoid($_SESSION['username']), $_POST['pupil'], $_POST['mark']);
if ($saveRegister === false) {
$responseMsg = "Could not create your register at this time - something went wrong, sorry";
} else {
$responseMsg = "Register saved";
}
// return to class view
$classid = $ObjClass->convertUUIDToClassID($_POST['classid']);
$className = $ObjClass->getClassName($classid);
require_once 'web/core/register/create.php';
} else {
// create the view for course information
$classid = $ObjClass->convertUUIDToClassID($d);
$className = $ObjClass->getClassName($classid);
$myRegister = $ObjRegister->createRegister($classid);
require_once 'web/core/register/create.php';
}
public function listAll()
{
$toReturn = array();
$toReturn['classes'] = classes::where('classAcademicYear', $this->panelInit->selectAcYear)->get()->toArray();
$classesArray = array();
while (list(, $class) = each($toReturn['classes'])) {
$classesArray[$class['id']] = $class['className'];
}
$toReturn['assignments'] = array();
if (count($classesArray) > 0) {
$assignments = new assignments();
if ($this->data['users']->role == "student") {
$assignments = $assignments->where('classId', 'LIKE', '%"' . $this->data['users']->studentClass . '"%');
} else {
while (list($key, ) = each($classesArray)) {
$assignments = $assignments->orWhere('classId', 'LIKE', '%"' . $key . '"%');
}
}
if ($this->data['users']->role == "teacher") {
$assignments = $assignments->where('teacherId', $this->data['users']->id);
}
$assignments = $assignments->get();
foreach ($assignments as $key => $assignment) {
$classId = json_decode($assignment->classId);
if ($this->data['users']->role == "student" and !in_array($this->data['users']->studentClass, $classId)) {
continue;
}
$toReturn['assignments'][$key]['id'] = $assignment->id;
$toReturn['assignments'][$key]['subjectId'] = $assignment->subjectId;
$toReturn['assignments'][$key]['AssignTitle'] = $assignment->AssignTitle;
$toReturn['assignments'][$key]['AssignDescription'] = $assignment->AssignDescription;
$toReturn['assignments'][$key]['AssignFile'] = $assignment->AssignFile;
$toReturn['assignments'][$key]['AssignDeadLine'] = $assignment->AssignDeadLine;
$toReturn['assignments'][$key]['classes'] = "";
while (list(, $value) = each($classId)) {
if (isset($classesArray[$value])) {
$toReturn['assignments'][$key]['classes'] .= $classesArray[$value] . ", ";
}
}
}
}
$toReturn['userRole'] = $this->data['users']->role;
$newrole = $this->data['users']->newrole;
$newrole_array = json_decode($newrole);
$params = permissions::where('moduleId', 1)->where('permission', 1)->get();
foreach ($params as $param) {
$uniparam[] = $param->roleId;
}
if ($toReturn['userRole'] == "teacher") {
if (array_intersect($newrole_array, $uniparam)) {
$toReturn['access'] = 1;
} else {
$toReturn['access'] = 0;
}
} elseif ($toReturn['userRole'] == "admin") {
$toReturn['access'] = 1;
} else {
$toReturn['access'] = 0;
}
$toReturn['newuserRole'] = $this->data['users']->newrole;
return $toReturn;
}
/*
* @version 0.1 (auto-set)
*/
global $session;
if ($this->owner->name=='panel') {
$out['CONTROLPANEL']=1;
}
$qry="1";
// search filters
if (IsSet($this->class_id)) {
$class_id=$this->class_id;
$qry.=" AND CLASS_ID='".$this->class_id."'";
include_once(DIR_MODULES.'classes/classes.class.php');
$cl=new classes();
$out['PARENT_PROPERTIES']=$cl->getParentProperties($this->class_id);
if (!$out['PARENT_PROPERTIES'][0]['ID']) {
unset($out['PARENT_PROPERTIES']);
}
} else {
global $class_id;
}
// QUERY READY
global $save_qry;
if ($save_qry) {
$qry=$session->data['properties_qry'];
} else {
$session->data['properties_qry']=$qry;
}
<?php
/**
* View a register on the system
*/
if ($_SESSION['username'] != "") {
if ($_SESSION['utype'] >= '5') {
require_once 'web/core/navigation.php';
// get and initiate the course class to access the functions
require_once 'src/core/controller/classes.php';
$ObjClass = new classes();
require_once 'src/core/controller/register.php';
$ObjRegister = new register();
// create the view for register
$classid = $ObjClass->convertUUIDToClassID($d);
$className = $ObjClass->getClassName($classid);
if ($_POST['action'] == "load") {
$myRegister = $ObjRegister->createRegister($classid);
} else {
$availableRegisters = $ObjRegister->listRegisters($classid);
}
require_once 'web/core/register/view.php';
} else {
require_once 'web/core/security/insufficientrights.php';
}
} else {
require_once 'web/core/login/index.php';
}
function profile($id)
{
$data = User::where('role', 'student')->where('id', $id)->first()->toArray();
$data['birthday'] = date('m/d/Y', $data['birthday']);
if ($data['studentClass'] != "" and $data['studentClass'] != "0") {
$class = classes::where('id', $data['studentClass'])->first();
}
$return = array();
$return['title'] = $data['fullName'] . " " . $this->panelInit->language['Profile'];
$return['content'] = "<div class='text-center'>";
if ($data['photo'] == "") {
$return['content'] .= "<img src='uploads/profile/user.png'/>";
} else {
$return['content'] .= "<img width='200' src='uploads/profile/" . $data['photo'] . "'/><br/>" . "<h3>" . $data['fullName'] . "</h3>";
}
$return['content'] .= "</div>";
$return['content'] .= "<h4>" . $this->panelInit->language['studentInfo'] . "</h4>";
$return['content'] .= "<table class='table table-bordered'><tbody>\n <tr>\n <td>" . $this->panelInit->language['FullName'] . "</td>\n <td>" . $data['fullName'] . "</td>\n </tr>\n <tr>\n <td>" . $this->panelInit->language['rollid'] . "</td>\n <td>" . $data['studentRollId'] . "</td>\n </tr>";
if (isset($class)) {
$return['content'] .= "<tr>\n\t <td>" . $this->panelInit->language['class'] . "</td>\n\t <td>" . $class->className . "</td>\n\t </tr>";
}
$return['content'] .= "<tr>\n <td>" . $this->panelInit->language['username'] . "</td>\n <td>" . $data['username'] . "</td>\n </tr>\n <tr>\n <td>" . $this->panelInit->language['email'] . "</td>\n <td>" . $data['email'] . "</td>\n </tr>\n <tr>\n <td>" . $this->panelInit->language['Birthday'] . "</td>\n <td>" . $data['birthday'] . "</td>\n </tr>\n <tr>\n <td>" . $this->panelInit->language['Gender'] . "</td>\n <td>" . $data['gender'] . "</td>\n </tr>\n <tr>\n <td>" . $this->panelInit->language['Address'] . "</td>\n <td>" . $data['address'] . "</td>\n </tr>\n <tr>\n <td>" . $this->panelInit->language['phoneNo'] . "</td>\n <td>" . $data['phoneNo'] . "</td>\n </tr>\n <tr>\n <td>" . $this->panelInit->language['mobileNo'] . "</td>\n <td>" . $data['mobileNo'] . "</td>\n </tr>\n\n </tbody></table>";
return $return;
}
<?php
/**
* Toggle a course visibility
*/
if ($_SESSION['username'] != "") {
require_once 'web/core/navigation.php';
// get and initiate the course class to access the functions
require_once 'src/core/controller/classes.php';
$ObjClass = new classes();
require_once 'src/core/controller/quiz.php';
$ObjQuiz = new quiz();
if ($d) {
$classid = $ObjClass->convertUUIDToClassID($d);
$classes = $ObjClass->getClassInformation($classid);
$documents = $ObjClass->getClassDocuments($classid);
$classActivity = $ObjClass->getClassActivity($classid);
$today = date('Y-m-d');
$classDiary = $ObjClass->getClassDiary($classid, $today, $today);
// Check if an administrator or owner of the class to b eable to toggle visibility
if ($_SESSION['utype'] >= 8 || $ObjAkonga->usernametoid($_SESSION['username']) == $classes['teacherid']) {
if ($e == "1") {
$visibility = 1;
} else {
$visibility = 0;
}
$toggleClass = $ObjClass->toggleClass($classid, $visibility);
if ($toggleClass != false) {
$responseMsg = "Your class visibility has been changed.";
$classes = $ObjClass->getClassInformation($classid);
// Reload class information to stop it pulling in the wrong data now it's changed
protected function render_single_button(single_button $button)
{
// Just because it says "single_botton" doesn't mean it's going to be rendered on its own
// but it does mean it gets its own unique form and a div round it.
$attributes = array('title' => $button->tooltip, 'class' => classes::add_to($button->class, 'btn btn-primary'), 'value' => $button->label, 'disabled' => $button->disabled ? 'disabled' : null);
if ($button->actions) {
$id = html_writer::random_id('single_button');
$attributes['id'] = $id;
foreach ($button->actions as $action) {
$this->add_action_handler($action, $id);
}
}
$output = html::submit($attributes);
if ($button->method === 'post') {
$params['sesskey'] = sesskey();
}
$output .= html::hidden_inputs($button->url->params());
if ($button->method === 'get') {
$url = $button->url->out_omit_querystring(true);
} else {
$url = $button->url->out_omit_querystring();
}
if ($url === '') {
$url = '#';
}
$attributes = array('method' => $button->method, 'action' => $url, 'id' => $button->formid);
return html::form($attributes, $output);
}
<?php
/**
* Create course content
*/
if ($_SESSION['username'] != "") {
require_once 'web/core/navigation.php';
if ($_SESSION['utype'] >= '5') {
// get and initiate the course class to access the functions
require_once 'src/core/controller/content.php';
$ObjContent = new content();
require_once 'src/core/controller/classes.php';
$ObjClass = new classes();
// Sort out the class ID
if ($d) {
$classid = $d;
} elseif ($_POST['classid'] != "") {
$classid = $_POST['classid'];
} else {
$classid = "";
}
if ($_POST['y'] == 'content' && $_POST['z'] == 'create' && $_POST['action'] == "save") {
// $contentTitle, $classid, $userid, $contentType, $contentDescription='', $contentLink='', $contentFile='', $contentFileExtension='', $documentContent=''
$createContent = $ObjContent->createContent($_POST['contentTitle'], $ObjClass->convertUUIDToClassID($_POST['classid']), $ObjAkonga->usernametoid($_SESSION['username']), $_POST['contentType'], $_POST['contentDescription'], $_POST['contentLink'], $_FILES['contentFile']['name'], $_FILES['contentFile']['tmp_name'], $_POST['documentContent'], $_POST['contentState']);
if ($createContent !== false) {
$responseMsg = "Your content has been created successfully";
} else {
$responseMsg = "Could not create your content at this time - something went wrong, sorry";
}
}
// create the view for course information
function LoadClass()
{
$db = new DB_Connect();
$major_id = (string) $_POST['major_id'];
$statement = 'select * from class where state = 1 and major_id=:major_id';
$result = $db->prepare($statement);
$result->execute(array(':major_id' => $major_id));
$index = 0;
$ret = "";
while ($row = $result->fetch()) {
$element = new classes();
$element->setVal($row['class_id'], $row['class_name']);
$ret[$index++] = $element;
}
echo json_encode($ret);
}
public function subjectList($classes = "")
{
$subjectList = array();
$classesCount = 1;
if ($classes == "") {
$classes = Input::get('classes');
if (!Input::has('classes')) {
return $subjectList;
}
}
if (is_array($classes)) {
$classes = classes::whereIn('id', $classes)->get()->toArray();
$classesCount = count($classes);
} else {
$classes = classes::where('id', $classes)->get()->toArray();
}
while (list(, $value) = each($classes)) {
$value['classSubjects'] = json_decode($value['classSubjects'], true);
if (is_array($value['classSubjects'])) {
while (list(, $value2) = each($value['classSubjects'])) {
$subjectList[] = $value2;
}
}
}
if ($classesCount == 1) {
$finalClasses = $subjectList;
} else {
$subjectList = array_count_values($subjectList);
$finalClasses = array();
while (list($key, $value) = each($subjectList)) {
if ($value == $classesCount) {
$finalClasses[] = $key;
}
}
}
if (count($finalClasses) > 0) {
return subject::whereIn('id', $finalClasses)->get()->toArray();
}
return array();
}
