<?php

namespace App\Http\Controllers\Cashier;

use Illuminate\Http\Request;
use App\Http\Controllers\Controller;
use PDF;
use DB;
use Auth;

class ExamPermit extends Controller {

    public function __construct() {
        $this->middleware('auth');
    }

    function index() {
        return view("cashier.exam_permits");
    }

    function shs(Request $request) {
        $track = $request->course;
        $level = $request->level;
        $section = $request->section;
        $is_reprint = $request->is_bulk;
        $school_year = \App\CtrGradeSchoolYear::where('academic_type', 'Senior High School')->first();
        if ($is_reprint == 'No') {
            $control = \App\CtrReferenceId::where('idno', Auth::user()->idno)->first();
            $students_1 = \App\User::join('statuses', 'statuses.idno', '=', 'users.idno')->join('student_infos', 'student_infos.idno', '=', 'users.idno')->where('statuses.section', $section)->where('statuses.level', $level)->where('statuses.track', $track)->orderBy('users.lastname', 'asc')->get();
            $students = \App\User::join('statuses', 'statuses.idno', '=', 'users.idno')->join('student_infos', 'student_infos.idno', '=', 'users.idno')->where('statuses.section', $section)->where('statuses.level', $level)->where('statuses.track', $track)->where('statuses.school_year',$school_year->school_year)->orderBy('users.lastname', 'asc')->get(            $cnt_no = $control->permit_shs;
            DB::beginTransaction();
            foreach ($students as $student) {
                $savePermit = new \App\ExamPermitShs();
                $savePermit->idno = $student->idno;
                $savePermit->cnt_no = $cnt_no;
                $savePermit->school_year = $school_year->school_year;
                $savePermit->period = $school_year->period;
                $savePermit->processed_by = Auth::user()->idno;
                $savePermit->save();
                $cnt_no += 1;
            }
            $controlUpdate = \App\CtrReferenceId::where('idno', Auth::user()->idno)->first();
            $controlUpdate->permit_shs = $cnt_no;
            $controlUpdate->update();
            DB::commit();
        }
        $students = \App\User::join('statuses', 'statuses.idno', '=', 'users.idno')->join('student_infos', 'student_infos.idno', '=', 'users.idno')->join('exam_permit_shs', 'exam_permit_shs.idno', '=', 'users.idno')->where('exam_permit_shs.period', $school_year->period)->where('exam_permit_shs.school_year', $school_year->school_year)->where('statuses.section', $section)->where('statuses.level', $level)->where('statuses.track', $track)->orderBy('users.lastname', 'asc')->get();
        \App\Http\Controllers\Admin\Logs::log("Exam Permit","Generate exam permit for SHS students");
        $pdf = PDF::loadView("cashier.print.print_exam_permit_shs", compact('students', 'level', 'track', 'school_year'));
        $pdf->setPaper('letter', 'portrait');
        return $pdf->stream("exam-permit-shs.pdf");

//        return view("cashier.print.print_exam_permit_shs",compact('students','level','track','school_year'));
    }

    function shsReprint($code) {
        $control = \App\ExamPermitShs::where('cnt_no', $code)->first();
        $idno = $control->idno;
        $school_year = $control->school_year;
        $period = $control->period;
        $student = \App\User::join('statuses', 'statuses.idno', '=', 'users.idno')->join('student_infos', 'student_infos.idno', '=', 'users.idno')->join('exam_permit_shs', 'exam_permit_shs.idno', '=', 'users.idno')->where('users.idno', $idno)->where('exam_permit_shs.period', $period)->where('exam_permit_shs.school_year', $school_year)->first();
//        dd($student);

        $pdf = PDF::loadView("cashier.print.print_exam_permit_shs_single", compact('student', 'period', 'school_year'));
        $pdf->setPaper('letter', 'portrait');
        return $pdf->stream("exam-permit-shs.pdf");

//        return view("cashier.print.print_exam_permit_shs_single",compact('student','period','school_year'));
    }
    
    function shsReset(){
        $controlUpdate = \App\CtrReferenceId::where('idno', Auth::user()->idno)->first();
        $controlUpdate->permit_shs = 1;
        $controlUpdate->update();
        \App\Http\Controllers\Admin\Logs::log("Exam Permit","Reset SHS control number");
        return redirect(url("exam_permit"));
    }
        
    function college_index() {
        return view("cashier.exam_permits_college");
    }
    
    function college(Request $request) {
//        dd($request);
        $course = $request->course;
        $level = $request->level;
        $unit = $request->unit;
        $category = $request->category;
        $is_reprint = $request->is_bulk;
        $school_year = \App\CtrSchoolYear::where('academic_type', 'College')->first();
        //$students = \App\User::join('statuses', 'statuses.idno', '=', 'users.idno')->join('student_infos', 'student_infos.idno', '=', 'users.idno')->where('statuses.level', $level)->where('statuses.program_code', $course)->get();
        $release = $request->post;
        //dd($release,$school_year,$course,$level);
        if ($is_reprint == 'No') {
//            $control = \App\CtrReferenceId::where('idno', Auth::user()->idno)->first();
//            $cnt_no = $control->permit_college;
            DB::beginTransaction();
            foreach ($release as $ids){
                $savePermit = new \App\ExamPermitCollege;
                $savePermit->idno = $ids;
                $savePermit->cnt_no = $this->getCntNo($request,$ids);
                $savePermit->unit = $unit;
                $savePermit->category = $category;
                $savePermit->school_year = $school_year->school_year;
                $savePermit->period = $school_year->period;
                $savePermit->prepare_by = Auth::user()->idno;
                $savePermit->save();
//                $cnt_no += 1;
            }
//            $controlUpdate = \App\CtrReferenceId::where('idno', Auth::user()->idno)->first();
//            $controlUpdate->permit_college = $cnt_no;
//            $controlUpdate->update();
            DB::commit();
        }
        $students = \App\User::join('statuses', 'statuses.idno', '=', 'users.idno')->join('student_infos', 'student_infos.idno', '=', 'users.idno')->join('exam_permit_colleges', 'exam_permit_colleges.idno', '=', 'users.idno')->where('exam_permit_colleges.period', $school_year->period)->where('exam_permit_colleges.school_year', $school_year->school_year)->where('exam_permit_colleges.unit', $unit)->where('exam_permit_colleges.category', $category)->where('statuses.level', $level)->where('statuses.program_code', $course)->orderBy('users.lastname', 'asc')->get();        
        \App\Http\Controllers\Admin\Logs::log("Exam Permit","Generate exam permit for College Students");
        $pdf = PDF::loadView("cashier.print.print_exam_permit_college", compact('students', 'level', 'track', 'school_year','unit','category'));
        $pdf->setPaper('letter', 'portrait');
        return $pdf->stream("exam-permit-college.pdf");
//        return view("cashier.print.print_exam_permit_college", compact('students', 'level', 'track', 'school_year','unit','category'));
    }
    
    function getCntNo($request,$idno){
        $category = $request->category;
        $countrol = 0;
        if($category == "Prelim"){
            $control = \App\CtrReferenceId::where('idno', Auth::user()->idno)->first();
            $countrol = $control->permit_college;
            $control->permit_college = $countrol+1;
            $control->update();
        }
        else{
            $school_year = \App\CtrSchoolYear::where('academic_type', 'College')->first();
            $control = \App\ExamPermitCollege::where('idno',$idno)->where('school_year',$school_year->school_year)->where('period',$school_year->period)->where('category','Prelims')->first();
            if(!empty($control)){
                $countrol = $control->cnt_no;
            }
            else{
                $control = \App\CtrReferenceId::where('idno', Auth::user()->idno)->first();
                $countrol = $control->permit_college;
                $control->permit_college = $countrol+1;
                $control->update();
            }
        }
        return $countrol;
    }
    
    function collegeReset(){
        $controlUpdate = \App\CtrReferenceId::where('idno', Auth::user()->idno)->first();
        $controlUpdate->permit_college = 1;
        $controlUpdate->update();
        \App\Http\Controllers\Admin\Logs::log("Exam Permit","Reset College control number");
        return redirect(url("exam_permit/college"));
    }
    
    function collegeReprint($category,$code) {
        $control = \App\ExamPermitCollege::where('cnt_no', $code)->where('category', $category)->first();
        $idno = $control->idno;
        $school_year = $control->school_year;
        $period = $control->period;
        $unit = $control->unit;
        $student = \App\User::join('statuses', 'statuses.idno', '=', 'users.idno')->join('student_infos', 'student_infos.idno', '=', 'users.idno')->join('exam_permit_colleges', 'exam_permit_colleges.idno', '=', 'users.idno')->where('users.idno', $idno)->where('exam_permit_colleges.period', $period)->where('exam_permit_colleges.school_year', $school_year)->where('exam_permit_colleges.unit', $unit)->where('exam_permit_colleges.category', $category)->first();
//        dd($student);

        $pdf = PDF::loadView("cashier.print.print_exam_permit_college_single", compact('student', 'period', 'school_year'));
        $pdf->setPaper('letter', 'portrait');
        return $pdf->stream("exam-permit-college.pdf");

//        return view("cashier.print.print_exam_permit_shs_single",compact('student','period','school_year'));
    }

}