public function instituteReport($Iid) { /****Admin****/ $today = date('Y-m-d'); $y = date("Y"); //return $today; $totalStudents = Students::where('status', '=', 1)->where('institute_code', '=', $Iid)->count(); $totalStudentsMale = Students::where('status', '=', 1)->where('institute_code', '=', $Iid)->where('gender', '=', 'Male')->count(); $totalStudentsFemale = Students::where('status', '=', 1)->where('institute_code', '=', $Iid)->where('gender', '=', 'Female')->count(); $totalTeachesrs = Teacher::where('institute_code', '=', $Iid)->count(); $teacherAttendence = Attendence::where('institute_code', '=', $Iid)->where('type', '=', 'Teacher')->where('status', '=', 0)->where('created_at', 'LIKE', "%{$today}%")->count(); $teacherAttendence1 = Attendence::where('institute_code', '=', $Iid)->where('type', '=', 'Teacher')->where('status', '=', 1)->where('created_at', 'LIKE', "%{$today}%")->count(); $total = $teacherAttendence + $teacherAttendence1; //return $total; $today_atten = (int) ($total / $totalTeachesrs * 100); //return $today_atten; $a1 = Attendence::where('institute_code', '=', $Iid)->where('created_at', 'LIKE', "%{$y}%")->where('type', '=', 'Teacher')->where('status', '=', 1)->count(); $a0 = Attendence::where('institute_code', '=', $Iid)->where('created_at', 'LIKE', "%{$y}%")->where('type', '=', 'Teacher')->where('status', '=', 0)->count(); $ay = $a1 + $a0; //return $ay; if ($y % 4 == 0) { $x = 366; $year_percent = (int) ($ay / $x * 100); } else { $yx = 365; $year_percent = (int) ($ay / $yx * 100); } //return $atten_percent; // return $AtotalInstitute; $totalTeacherMale = Teacher::where('institute_code', '=', $Iid)->where('gender', '=', 'Male')->count(); $totalTeacherFemale = Teacher::where('institute_code', '=', $Iid)->where('gender', '=', 'Female')->count(); $m = date("Y-m"); ///$h=Holyday::where('holiday_date','LIKE',"%2016-03%")->get(); //$h=Holyday::where('holiday_date','LIKE',"%$m%")->get(); $d = date('t'); $at = Holyday::where('holiday_date', 'LIKE', "%{$m}%")->count(); $p = $d - $at; //return $p; $a12 = Attendence::where('institute_code', '=', $Iid)->where('created_at', 'LIKE', "%{$m}%")->where('type', '=', 'Teacher')->where('status', '=', 1)->count(); $a02 = Attendence::where('institute_code', '=', $Iid)->where('created_at', 'LIKE', "%{$m}%")->where('type', '=', 'Teacher')->where('status', '=', 0)->count(); $ay2 = $a12 + $a02; //return $a12.$a02; $t = $totalTeachesrs * $p; $ms = (int) ($ay2 / $t * 100); $at = Holyday::where('holiday_date', 'LIKE', "%{$m}%")->count(); $InstiHolyday = InstiHolyday::where('holiday_date', 'LIKE', "%{$m}%")->where('institute_code', '=', $Iid)->count(); $InstiWeekEnd = AcademicCalender::where('institute_code', '=', $Iid)->pluck('weekendday'); $WeekEnd1 = str_limit($InstiWeekEnd, 3, ''); $WeekEnd2 = substr($InstiWeekEnd, 4); $WeekEnd3 = substr($InstiWeekEnd, 9); // return date('d', strtotime($WeekEnd1)); $month = date('m'); $year = date("Y"); $start_date = "01-" . $month . "-" . $year; $start_time = strtotime($start_date); $end_time = strtotime("+1 month", $start_time); for ($i = $start_time; $i < $end_time; $i += 86400) { $list[] = date('D', $i); } $p = $d - ($at + $InstiHolyday); $ms = (int) ($p / $d * 100); //students attendence report saif... //today attendence calculation $totalStudents = Students::where('institute_code', '=', $Iid)->count(); $totalstudentsAtten = Attendence::where('institute_code', '=', $Iid)->where('type', '=', 'Student')->where('status', '=', 0)->where('created_at', 'LIKE', "%{$today}%")->count(); $studentTodayReport = (int) ($totalstudentsAtten / $totalStudents * 100); //monthly calculation $stdPrestAve = Attendence::where('institute_code', '=', $Iid)->where('type', '=', 'Student')->where('status', '=', 0)->where('created_at', 'LIKE', "%{$m}%")->count(); //$presentPersent= (int)(($stdPrestAve/$p)*100); $mtotal = $totalStudents * $p; $monthpresentPersent = (int) ($stdPrestAve / $mtotal * 100); ///yearly calculation return view('superadmin.ListofInstituteReport')->with('totalStudents', $totalStudents)->with('totalTeachesrs', $totalTeachesrs)->with('totalStudentsMale', $totalStudentsMale)->with('totalStudentsFemale', $totalStudentsFemale)->with('today', $today_atten)->with('year', $year_percent)->with('m', $totalTeacherMale)->with('f', $totalTeacherFemale)->with('mon', $ms)->with('studentTodayReport', $studentTodayReport)->with('monthpresentPersent', $monthpresentPersent); }
public function getMarkViews($roll, $cid) { $stdInfo = Students::where('institute_code', '=', Auth::user()->institute_id)->where('roll', '=', $roll)->where('class', '=', $cid)->first(); $stdClass = ClassAdd::where('class_id', '=', $stdInfo->class)->pluck('class_name'); $showAllMark = Mark::where('institute_code', '=', Auth::user()->institute_id)->where('roll', '=', $roll)->where('class_id', '=', $cid)->get(); $showAllMarkExamName = Mark::where('institute_code', '=', Auth::user()->institute_id)->where('roll', '=', $roll)->where('class_id', '=', $cid)->select('exam_name')->distinct()->get(); // $showAllMarkExamName=Mark::where('institute_code','=',Auth::user()->institute_id)->where('roll','=', $roll)->where('class_id','=',$cid)->get(); $MarkViewGrade = Mark::where('institute_code', '=', Auth::user()->institute_id)->where('roll', '=', $roll)->where('class_id', '=', $cid)->first(); //return $showAllMark->sub_mark; $allGrad = GradeSystem::where('institute_code', '=', Auth::user()->institute_id)->get(); $MarkViewGrade = Mark::where('institute_code', '=', Auth::user()->institute_id)->where('roll', '=', $roll)->where('class_id', '=', $cid)->get(); /* foreach ($allGrad as $key => $value) { //return $MarkViewGrade->sub_mark; $MarkViewGrade=Mark::where('institute_code','=',Auth::user()->institute_id)->where('roll','=', $roll)->where('class_id','=',$cid)->get(); //return $MarkViewGrade; foreach ($MarkViewGrade as $key => $markget) { // return $value->mark_form; if ($markget->sub_mark>=$value->mark_form && $markget->sub_mark<=$value->mark_upto) { $point=$value->grade_point ; $grade=$value->grade_name ; return view('admin.resultMark.markviews')->with('stdInfo',$stdInfo)->with('stdClass',$stdClass) ->with('showAllMark',$showAllMark)->with('MarkViewGrade',$MarkViewGrade)->with('allGrad',$allGrad)->with('point',$point)->with('grade',$grade); } else { return 2 ; } } }*/ // return $point.$grade; return view('admin.resultMark.markviews')->with('stdInfo', $stdInfo)->with('stdClass', $stdClass)->with('showAllMark', $showAllMark)->with('MarkViewGrade', $MarkViewGrade)->with('allGrad', $allGrad)->with('showAllMarkExamName', $showAllMarkExamName); }
public function getMarkViews() { // $stdInfo=Students::where('institute_code','=',Auth::user()->institute_id)->where('roll','=', $roll)->where('class','=',$cid)->first(); $stdInfo = Students::where('institute_code', '=', Auth::user()->institute_id)->where('st_id', '=', Auth::user()->uid)->first(); $stdClass = ClassAdd::where('class_id', '=', $stdInfo->class)->pluck('class_name'); //return $stdInof->class; $showAllMark = Mark::where('institute_code', '=', Auth::user()->institute_id)->where('roll', '=', $stdInfo->roll)->where('class_id', '=', $stdInfo->class)->get(); $showAllMarkExamName = Mark::where('institute_code', '=', Auth::user()->institute_id)->where('roll', '=', $stdInfo->roll)->where('class_id', '=', $stdInfo->class)->select('exam_name')->distinct()->get(); // $showAllMarkExamName=Mark::where('institute_code','=',Auth::user()->institute_id)->where('roll','=', $roll)->where('class_id','=',$cid)->get(); $MarkViewGrade = Mark::where('institute_code', '=', Auth::user()->institute_id)->where('roll', '=', $stdInfo->roll)->where('class_id', '=', $stdInfo->class)->first(); //return $showAllMark->sub_mark; $allGrad = GradeSystem::where('institute_code', '=', Auth::user()->institute_id)->get(); $MarkViewGrade = Mark::where('institute_code', '=', Auth::user()->institute_id)->where('roll', '=', $stdInfo->roll)->where('class_id', '=', $stdInfo->class)->get(); return view('admin.resultMark.markviews')->with('stdInfo', $stdInfo)->with('stdClass', $stdClass)->with('showAllMark', $showAllMark)->with('MarkViewGrade', $MarkViewGrade)->with('allGrad', $allGrad)->with('showAllMarkExamName', $showAllMarkExamName); }
public function updateInvoice($id) { $class = Input::get('class'); $section = Input::get('section'); $student = Input::get('student'); $feetype = Input::get('feetype'); $amount = Input::get('amount'); $paidamountid = Input::get('paid'); $answer = Input::get('answer'); $date = Input::get('date'); //return $paidamountid; $studentid = Students::where('institute_code', '=', Auth::user()->institute_id)->where('name', '=', $student)->where('class', '=', $class)->pluck('st_id'); return $studentid; $classname = ClassAdd::where('institute_code', '=', Auth::user()->institute_id)->where('class_id', '=', $class)->pluck('class_name'); $feetypename = AccountFeeType::where('institute_code', '=', Auth::user()->institute_id)->where('fee_id', '=', $feetype)->pluck('fee_type'); $up = Invoice::where('institute_code', '=', Auth::user()->institute_id)->where('id', '=', $id)->update(['class_id' => $class, 'class_name' => $classname, 'section_id' => $section, 'student_name' => $student, 'student_id' => $studentid, 'fee_type' => $feetypename, 'fee_id' => $feetype, 'total_amount' => $amount, 'payment_ammount' => $paidamountid, 'due_amount' => $answer, 'date' => $date]); Session::flash('data', 'Success!'); return redirect::to('admin/edit/invoice/' . $id); }