/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function getsheet()
{
$inputs = Input::all();
$input = (object) $inputs;
$subjects = Subject::select('name')->where('class', $input->class)->orderby('code', 'asc')->get();
if (count($subjects) < 1) {
return Redirect::to('/tabulation')->withInput(Input::all())->with("error", "There are not subjects for this class!");
}
$students = Student::select('regiNo', 'firstName', 'middleName', 'lastName')->where('class', $input->class)->where('section', $input->section)->where('session', trim($input->session))->where('shift', $input->shift)->get();
if (count($students) < 1) {
return Redirect::to('/tabulation')->withInput(Input::all())->with("error", "There are not student for this class!");
}
$merit = DB::table('MeritList')->select('regiNo', 'grade', 'point', 'totalNo')->where('exam', $input->exam)->where('class', $input->class)->where('session', trim($input->session))->orderBy('point', 'DESC')->orderBy('totalNo', 'DESC')->get();
if (count($merit) < 1) {
return Redirect::to('/tabulation')->withInput(Input::all())->with("error", "Marks not submit or result not generate for this exam!");
}
foreach ($students as $student) {
$marks = Marks::select('written', 'mcq', 'practical', 'ca', 'total', 'grade', 'point')->where('regiNo', $student->regiNo)->where('exam', $input->exam)->orderby('subject', 'asc')->get();
if (count($marks) < 1) {
return Redirect::to('/tabulation')->withInput(Input::all())->with("error", "Marks not submited yet!");
}
/*$marks = DB::table('Marks')
->join('MeritList', 'Marks.regiNo', '=', 'MeritList.regiNo')
->select('Marks.written','Marks.mcq', 'Marks.practical', 'Marks.ca', 'Marks.total', 'Marks.grade', 'Marks.point', 'MeritList.totalNo', 'MeritList.grade as tgrade','MeritList.point as tpoint')
->where('Marks.regiNo',$student->regiNo)
->where('Marks.exam', '=',$input->exam)
->orderby('Marks.subject','asc')
->get();*/
$meritdata = new Meritdata();
$position = 0;
foreach ($merit as $m) {
$position++;
if ($m->regiNo === $student->regiNo) {
$meritdata->regiNo = $m->regiNo;
$meritdata->point = $m->point;
$meritdata->grade = $m->grade;
$meritdata->position = $position;
$meritdata->totalNo = $m->totalNo;
break;
}
}
$student->marks = $marks;
$student->meritdata = $meritdata;
}
$cl = ClassModel::Select('name')->where('code', $input->class)->first();
$input->class = $cl->name;
$fileName = $input->class . '-' . $input->section . '-' . $input->session . '-' . $input->exam;
// return $students;
Excel::create($fileName, function ($excel) use($input, $subjects, $students) {
$excel->sheet('New sheet', function ($sheet) use($input, $subjects, $students) {
$sheet->loadView('app.excel', compact('subjects', 'input', 'students'));
});
})->download('xlsx');
}
<?php
require_once '../core/init.php';
if (privilege() == NULL) {
die;
}
if (Input::exists()) {
if (Input::get('from_aa') > 100) {
die("Grade AA cannot be more than 100.");
}
$scale = "100," . Input::get('from_aa') . "," . Input::get('to_ab') . "," . Input::get('from_ab') . "," . Input::get('to_ba') . "," . Input::get('from_ba') . "," . Input::get('to_bb') . "," . Input::get('from_bb') . "," . Input::get('to_cc') . "," . Input::get('from_cc') . "," . Input::get('to_cd') . "," . Input::get('from_cd') . "," . Input::get('to_dd') . "," . Input::get('from_dd');
$m = new Marks();
$mm = $m->setGradingScale(Input::get('tid'), Input::get('cid'), Input::get('dep'), $scale);
if ($mm == 1) {
echo '<div class="alert alert-success alert-dismissible" role="alert">';
echo 'Saved Successfully!';
echo '</div>';
} else {
if ($mm == 0) {
echo '<div class="alert alert-danger alert-dismissible" role="alert">';
echo 'Temporary Error!';
echo '</div>';
} else {
if ($mm == 2) {
echo '<div class="alert alert-warning alert-dismissible" role="alert">';
echo 'No changes made!';
echo '</div>';
}
}
}
}
<?php
require_once 'core/init.php';
if (!loggedIn()) {
die;
exit;
}
$cid_dep = explode(',', Input::get('id'));
$cid = $cid_dep[0];
$dep = $cid_dep[1];
$gmarks = new Marks();
$scale = $gmarks->getGradeScale($cid, $dep);
$grade_set = explode(',', $scale);
?>
<div class="box box-default" id="grade_scale">
<div class="box-header">
<h3 class="box-title">Grading Scale</h3>
</div> <!-- /.box header -->
<div class="box-body table-responsive no-padding">
<form role="form" id="grade_scale">
<input class="form-control" type="hidden" name="tid" value="<?php
echo Session::get('teacher_id');
?>
" />
<input class="form-control" type="hidden" name="cid" value="<?php
echo $cid;
?>
" />
<input class="form-control" type="hidden" name="dep" value="<?php
echo $dep;
?>
$date = date_create($lastdate);
echo '<div class="alert alert-danger alert-dismissible" role="alert">';
echo '<button type="button" class="close" data-dismiss="alert"><span aria-hidden="true">×</span><span class="sr-only">Close</span></button>';
echo "Last Date for " . strtoupper(Input::get('examtype')) . " was " . date_format($date, 'd-M-Y');
echo '</div>';
die;
}
if (empty($_FILES["file"]["tmp_name"])) {
echo '<div class="alert alert-danger alert-dismissible" role="alert">';
echo '<button type="button" class="close" data-dismiss="alert"><span aria-hidden="true">×</span><span class="sr-only">Close</span></button>';
echo 'Please Select CSV File';
echo '</div>';
die;
}
$input = explode(',', Input::get('course_id'));
$m = new Marks();
$import = $m->importCSV($input[0], $input[1], Input::get('examtype'), Input::get('category'), $_FILES["file"]["tmp_name"]);
if ($import) {
echo '<div class="alert alert-success alert-dismissible" role="alert">';
echo '<button type="button" class="close" data-dismiss="alert"><span aria-hidden="true">×</span><span class="sr-only">Close</span></button>';
echo "Successfully Imported";
echo '</div>';
} else {
echo '<div class="alert alert-danger alert-dismissible" role="alert">';
echo '<button type="button" class="close" data-dismiss="alert"><span aria-hidden="true">×</span><span class="sr-only">Close</span></button>';
echo "Temporary problem!";
echo '</div>';
}
} else {
echo '<div class="alert alert-warning alert-dismissible" role="alert">';
echo '<button type="button" class="close" data-dismiss="alert"><span aria-hidden="true">×</span><span class="sr-only">Close</span></button>';
<?php
require_once '../core/init.php';
if (privilege() == NULL) {
die;
}
if (Input::exists('post')) {
$validate = new Validate();
$validation = $validate->check($_POST, array('examtype' => array('required' => true), 'lastdate' => array('required' => true)));
if ($validate->passed()) {
$dep = new Marks();
$date = changeDateFormatToDB(Input::get('lastdate'));
$setDate = $dep->setLastDate(Input::get('examtype'), $date);
if ($setDate == 3) {
echo '<div class="alert alert-danger alert-dismissible" role="alert">';
echo '<button type="button" class="close" data-dismiss="alert"><span aria-hidden="true">×</span><span class="sr-only">Close</span></button>';
echo 'Sorry, you don\'t have privilege to set Last date for examination.';
echo '</div>';
} else {
if ($setDate == 1) {
echo '<div class="alert alert-success alert-dismissible" role="alert">';
echo '<button type="button" class="close" data-dismiss="alert"><span aria-hidden="true">×</span><span class="sr-only">Close</span></button>';
echo 'Last date saved successfully.';
echo '</div>';
} else {
if ($setDate == 0) {
echo '<div class="alert alert-danger alert-dismissible" role="alert">';
echo '<button type="button" class="close" data-dismiss="alert"><span aria-hidden="true">×</span><span class="sr-only">Close</span></button>';
echo 'Temporary Error!';
echo '</div>';
} else {
<?php
require_once '../core/init.php';
if (!loggedIn()) {
die;
}
if (privilege() == NULL) {
die;
}
if (Input::exists()) {
if (Input::get('course_id') != '') {
$var = explode(',', Input::get('course_id'));
$m = new Marks();
if (!$m->getGradeScale($var[0], $var[1])) {
echo '<div class="alert alert-danger alert-dismissible" role="alert">';
echo '<button type="button" class="close" data-dismiss="alert"><span aria-hidden="true">×</span><span class="sr-only">Close</span></button>';
echo 'Set grading scale first!';
echo '</div>';
die;
}
$m->generateResult($var[0], $var[1]);
$c = new Course();
$c->getInfobyId($var[0]);
?>
<div class="box box-success">
<div class="box-header">
<h1 class="box-title">Final Result ( <?php
echo $var[0] . ' - ' . $c->getCourseName();
unset($c);
?>
)</h1>
<?php
require_once '../core/init.php';
if (privilege() == NULL) {
die;
}
if (Input::exists()) {
$i = 1;
$j = 0;
$k = 0;
$status = "Marks was left empty of Scholar Number :-";
while (Input::get('scholar_number' . $i)) {
$m = new Marks();
if (Input::get('marks' . $i) != '') {
$mm = $m->MarksEntryLoad(Input::get('scholar_number' . $i), Input::get('c_code'), Input::get('c_dep'), Input::get('examtype'), Input::get('marks' . $i));
if ($mm == 2) {
$k++;
//die("Something went wrong after Scholar number: ".Input::get('scholar_number'.$i)." . Please Try again.");
}
} else {
$status = $status . Input::get('scholar_number' . $i) . ", ";
$k++;
$j++;
}
$i++;
}
if ($k) {
echo "Number of rows effected:" . ($i - $k - 1) . "<br />";
}
if ($j != 0) {
$log = new Log();
</div>
</div>
<div class="row">
<div class="col-md-12">
<div class="box box-default">
<div class="box-header">
<h3 class="box-title">Sessional Formula</h3>
<div class="box-tools pull-right">
<button class="btn btn-default btn-sm" data-widget="collapse"><i class="fa fa-minus"></i></button>
</div>
</div> <!-- /.box header -->
<div class="box-body">
<h3><strong>
<?php
unset($gmarks);
$marks = new Marks();
$sf = $marks->getSessionalFormula('', $cid, $dep);
if ($sf->num_rows) {
$formula = $sf->fetch_object()->formula;
} else {
$formula = 1;
}
switch ($formula) {
case 1:
echo 'Highest of Two Class Tests + Internal Assessment';
break;
case 2:
echo 'Average of Two Class Tests + Internal Assessment';
break;
default:
echo 'Highest of Two Class Tests + Internal Assessment';
/**
* Update the specified resource in storage.
*
* @param int $id
* @return Response
*/
public function update()
{
$rules = ['written' => 'required', 'mcq' => 'required', 'practical' => 'required', 'ca' => 'required'];
$validator = \Validator::make(Input::all(), $rules);
if ($validator->fails()) {
return Redirect::to('/mark/edit/' . Input::get('id'))->withErrors($validator);
} else {
$gparules = GPA::select('gpa', 'grade', 'markfrom')->get();
$marks = Marks::find(Input::get('id'));
$marks->written = Input::get('written');
$marks->mcq = Input::get('mcq');
$marks->practical = Input::get('practical');
$marks->ca = Input::get('ca');
$totalmark = Input::get('written') + Input::get('mcq') + Input::get('practical') + Input::get('ca');
$marks->total = $totalmark;
foreach ($gparules as $gpa) {
if ($totalmark >= $gpa->markfrom) {
$marks->grade = $gpa->gpa;
$marks->point = $gpa->grade;
break;
}
}
$marks->Absent = Input::get('Absent');
$marks->save();
return Redirect::to('/mark/list')->with("success", "Marks Update Sucessfully.");
}
}
<?php
require_once 'core/init.php';
if (!loggedIn() || privilege() == NULL) {
die;
}
$cid_dep = explode(',', Input::get('id'));
$cid = $cid_dep[0];
$dep = $cid_dep[1];
$gmarks = new Marks();
$scale = $gmarks->getGradeScale($cid, $dep);
$grade_set = explode(',', $scale);
?>
<div class="box box-default" id="formula">
<div class="box-header">
<h3 class="box-title">Sessional Formula</h3>
</div> <!-- /.box header -->
<!-- form start -->
<form role="form" action="post" id="sessional_formula">
<div class="box-body">
<div class="form-group">
<label for="formula">Select formula</label>
<?php
$sf = $gmarks->getSessionalFormula(Session::get('teacher_id'), $cid, $dep);
if ($sf->num_rows) {
$formula = $sf->fetch_object()->formula;
} else {
$formula = 1;
}
<?php
require_once '../core/init.php';
if (privilege() == NULL) {
die;
}
if (Input::exists()) {
$validate = new Validate();
$validation = $validate->check($_POST, array('formula' => array('required' => true)));
if ($validate->passed()) {
$m = new Marks();
$add = $m->setSessionalFormula(Session::get('teacher_id'), Input::get('ccode'), Input::get('cdep'), Input::get('formula'));
if ($add == 1) {
echo '<div class="alert alert-success alert-dismissible" role="alert">';
echo 'Saved Successfully!';
echo '</div>';
} else {
if ($add == 0) {
echo '<div class="alert alert-danger alert-dismissible" role="alert">';
echo 'Temporary Error!';
echo '</div>';
} else {
if ($add == 2) {
echo '<div class="alert alert-warning alert-dismissible" role="alert">';
echo 'No changes made!';
echo '</div>';
}
}
}
} else {
echo '<div class="alert alert-warning alert-dismissible" role="alert">';
$courses = $s->getCoursesLoad();
$courses = explode(',', $courses);
foreach ($courses as $course) {
?>
<tr>
<td><?php
echo $course;
?>
</td>
<td>
<?php
$c = new Course();
$c->getInfobyId($course);
echo $c->getCourseName();
unset($c);
$m = new Marks();
$marks = $m->getMarksLoad(Session::get('sn'), $course, '*');
if ($marks == '') {
$ct1 = '-';
$ct2 = '-';
$ia = '-';
$ms = '-';
$es = '-';
$g = '-';
} else {
$marks = $marks->fetch_object();
$ct1 = $marks->ct1;
$ct2 = $marks->ct2;
$ia = $marks->ct3;
$ms = $marks->midsem;
$es = $marks->endsem;
<?php
require_once '../core/init.php';
if (!Input::exists('get')) {
die;
}
if (privilege() == NULL) {
die;
} else {
if (Input::get('examtype') == '') {
?>
<input type="text" placeholder="mm/dd/yyyy" class="form-control" data-provide="datepicker" data-inputmask="'alias': 'mm/dd/yyyy'" data-mask="" name="lastdate" id="lastdate">
<?php
} else {
$dep = new Marks();
$last_date = $dep->getLastDate(Input::get('examtype'));
if ($last_date->num_rows) {
$last_date = changeDateFormatFromDB($last_date->fetch_object()->date);
if ($last_date == '00/00/0000') {
$last_date = '';
}
} else {
$last_date = '';
}
?>
<input type="text" placeholder="mm/dd/yyyy" class="form-control" data-provide="datepicker" data-inputmask="'alias': 'mm/dd/yyyy'" data-mask="" name="lastdate" id="lastdate" value="<?php
echo $last_date;
?>
">
<?php
}
<?php
require_once '../core/init.php';
require_once ROOT_DIR . 'functions/spline.php';
if (!loggedIn() || !Token::check(Input::get('token'))) {
die;
}
if (Input::exists('get')) {
$m = new Marks();
$aa = $m->totalNumOfGivenGrade('10', Input::get('cid'), Input::get('did'));
$ab = $m->totalNumOfGivenGrade('9', Input::get('cid'), Input::get('did'));
$bb = $m->totalNumOfGivenGrade('8', Input::get('cid'), Input::get('did'));
$bc = $m->totalNumOfGivenGrade('7', Input::get('cid'), Input::get('did'));
$cc = $m->totalNumOfGivenGrade('6', Input::get('cid'), Input::get('did'));
$cd = $m->totalNumOfGivenGrade('5', Input::get('cid'), Input::get('did'));
$dd = $m->totalNumOfGivenGrade('4', Input::get('cid'), Input::get('did'));
$f = $m->totalNumOfGivenGrade('0', Input::get('cid'), Input::get('did'));
createSpline(array($aa, $ab, $bb, $bc, $cc, $cd, $dd, $f));
}
case 'endsem':
echo "End-Semester <i>(Max Marks : 50)</i>";
$max = "50";
break;
}
?>
</th>
</tr>
</thead>
<tbody>
<?php
$j = 0;
while ($students = $studs->fetch_object()) {
$mmm = new Marks();
$saved_m = $mmm->getMarksLoad($students->scholar_no, $c_code, $type);
if (!empty($saved_m) && $saved_m->num_rows) {
$marks = $saved_m->fetch_object()->{$type};
} else {
$marks = 0.0;
}
?>
<tr>
<th><?php
echo $j + 1;
?>
</th>
<th><input type="hidden" name="scholar_number<?php
echo $j + 1;
?>
include 'header.php';
if (!loggedIn()) {
Redirect::to('index.php');
} else {
if (loggedIn() && !Session::exists('teacher_id')) {
Session::destroy();
Redirect::to('includes/errors/unauthorized.php');
}
}
if (Input::exists()) {
$validate = new Validate();
$validation = $validate->check($_POST, array('course_id' => array('required' => true), 'examtype' => array('required' => true), 'category' => array('required' => true)));
if ($validate->passed()) {
$input = Input::get('course_id');
$input = explode(',', Input::get('course_id'));
$m = new Marks();
if ($m->exportCSV($input[0], $input[1], Input::get('examtype'), Input::get('category'))) {
echo '<div class="alert alert-success alert-dismissible" role="alert">';
echo '<button type="button" class="close" data-dismiss="alert"><span aria-hidden="true">×</span><span class="sr-only">Close</span></button>';
echo '<strong>Export successful</strong>';
echo '</div>';
} else {
echo '<div class="alert alert-danger alert-dismissible" role="alert">';
echo '<button type="button" class="close" data-dismiss="alert"><span aria-hidden="true">×</span><span class="sr-only">Close</span></button>';
echo 'Temporary Error!';
echo '</div>';
}
} else {
echo '<div class="alert alert-warning alert-dismissible" role="alert">';
echo '<button type="button" class="close" data-dismiss="alert"><span aria-hidden="true">×</span><span class="sr-only">Close</span></button>';
foreach ($validate->errors() as $errors) {
public function postgenerate()
{
$rules = ['class' => 'required', 'exam' => 'required', 'session' => 'required'];
$validator = \Validator::make(Input::all(), $rules);
if ($validator->fails()) {
return Redirect::to('/result/generate')->withErrors($validator)->withInput();
} else {
$subjects = Subject::select('name', 'code', 'type', 'subgroup')->where('class', '=', Input::get('class'))->get();
$marksubmit = Marks::select('subject')->where('class', '=', Input::get('class'))->where('session', trim(Input::get('session')))->where('exam', Input::get('exam'))->distinct()->get();
if (count($subjects) == count($marksubmit)) {
$fourthsubjectCode = "";
foreach ($subjects as $subject) {
if ($subject->type === "Electives") {
$fourthsubjectCode = $subject->code;
}
}
$students = Student::select('regiNo')->where('class', '=', Input::get('class'))->where('session', '=', trim(Input::get('session')))->get();
if (count($students) != 0) {
$gparules = GPA::select('gpa', 'grade', 'markfrom')->get();
$foobar = array();
foreach ($students as $student) {
$marks = Marks::select('subject', 'grade', 'point', 'total')->where('regiNo', '=', $student->regiNo)->where('exam', '=', Input::get('exam'))->get();
if (count($marks) != 0) {
$totalpoint = 0;
$totalmarks = 0;
$subcounter = 0;
$banglamark = 0;
$englishmark = 0;
$isfail = false;
foreach ($marks as $mark) {
if ($this->getSubGroup($subjects, $mark->subject) === "Bangla") {
$banglamark += $mark->total;
} else {
if ($this->getSubGroup($subjects, $mark->subject) === "English") {
$englishmark += $mark->total;
} else {
if ($mark->subject === $fourthsubjectCode) {
if ($mark->point >= 2.0) {
$totalmarks += $mark->total;
$totalpoint += $mark->point - 2;
} else {
$totalmarks += $mark->total;
}
$subcounter--;
} else {
$totalmarks += $mark->total;
$totalpoint += $mark->point;
}
}
}
$subcounter++;
if ($mark->subject !== $fourthsubjectCode && $mark->grade === "F") {
$isfail = true;
}
}
if ($banglamark > 0) {
$blmarks = floor($banglamark / 2);
$totalmarks += $banglamark;
$totalpoint += $this->pointCalculator($blmarks, $gparules);
$subcounter--;
}
if ($englishmark > 0) {
$enmarks = floor($englishmark / 2);
$totalmarks += $englishmark;
$totalpoint += $this->pointCalculator($enmarks, $gparules);
$subcounter--;
}
$grandPoint = $totalpoint / $subcounter;
if ($isfail) {
$grandGrade = $this->gradnGradeCal(0.0, $gparules);
} else {
$grandGrade = $this->gradnGradeCal($grandPoint, $gparules);
}
$merit = new MeritList();
$merit->class = Input::get('class');
$merit->session = trim(Input::get('session'));
$merit->exam = Input::get('exam');
$merit->regiNo = $student->regiNo;
$merit->totalNo = $totalmarks;
$merit->point = $grandPoint;
$merit->grade = $grandGrade;
$merit->save();
} else {
return Redirect::to('/result/generate')->withInput()->with("noresult", "This examintaion marks not submited yet!!");
}
}
} else {
return Redirect::to('/result/generate')->withInput()->with("noresult", "There is no students in this class!!");
}
return Redirect::to('/result/generate')->with("success", "Result Generate and Publish Successfull.");
} else {
return Redirect::to('/result/generate')->withInput()->with("noresult", "All subjects marks not submited yet!!");
}
}
}
