<?php

namespace App\Http\Controllers;

use Illuminate\Foundation\Auth\Access\AuthorizesRequests;
use Illuminate\Foundation\Bus\DispatchesJobs;
use Illuminate\Foundation\Validation\ValidatesRequests;
use Illuminate\Routing\Controller as BaseController;
use App\Models\SaveContactUs;
use App\Models\Student_registered;
use App\Models\Admission_query;
use App\Models\Campus_tour;
use App\Models\Leads;

use App\Models\Applications;
use Illuminate\Http\Request;
use App\Http\Requests;
use DB;
use Session;
class FrontController extends BaseController
{
    use AuthorizesRequests, DispatchesJobs, ValidatesRequests;

    public function index()
    {
        // $data['notice_board']= DB::table('notice_board')->get();
        $data['principle_msg']= DB::table('message')->where('msg_to','principle')->first();
        $data['chairmen_msg']= DB::table('message')->where('msg_to','chairmen')->first();
        $data['director_msg']= DB::table('message')->where('msg_to','director')->first();
        // $data['curricular']= DB::table('curicular')->get();
         $data['banners']= DB::table('banners')->get();
         $data['reviews']=DB::table('sip_review')->orderBy('id','desc')->get();
        return view('front.index',$data);
    }
    

    
   public function about_us()
    {
        $data['about']= DB::table('about')->first();
        return view('front.about-us',$data);
    }
    public function our_teaching_staff()
    {
         $data['school_cord']= DB::table('teachers')->where([
                                                            ['status',1],
                                                            ['featured',1],
                                                            ['category',6]
                                                        ])->get();
                                                        
                                                        
     
                                                        
         $data['tgt_teachers']= DB::table('teachers')->where([
                                                            ['status',1],
                                                            ['featured',0],
                                                            ['category',2]
                                                        ])->get();
                                                        
         $data['prt_teachers']= DB::table('teachers')->where([
                                                            ['status',1],
                                                            ['featured',0],
                                                            ['category',3]
                                                        ])->get(); 
                                                        
         $data['dpi_teachers']= DB::table('teachers')->where([
                                                            ['status',1],
                                                            ['featured',0],
                                                            ['category',4]
                                                        ])->get(); 
                                                        
         $data['art_teachers']= DB::table('teachers')->where([
                                                            ['status',1],
                                                            ['featured',0],
                                                            ['category',5]
                                                        ])->get();
          
        //   $data['pgt_teachers']=[];                                              
         $data['pgt_teachers']= DB::table('teachers')->where([
                                                            ['status',1],
                                                            ['featured',0],
                                                            ['category',1]
                                                        ])->get();                                               
                                                    
        return view('front.our-teaching-staff',$data);
    }  
    public function apply_to_karnal_international()
    {
       return view('front.apply-to-karnal-international');
    } 
    
    public function director(){
       
        $data['director_msg']= DB::table('message')->where('msg_to','director')->first();
       return view('front.chairman-message',$data);
    } 
    
    public function principal(){
         $data['principle_msg']= DB::table('message')->where('msg_to','principle')->first();
       return view('front.principal-message',$data);
    }
    
    public function registration(){
       return view('front.registration');
    } 
    
    public function privacy_policy(){
       return view('front.privacy-policy');
    }
    
    public function terms_and_condition(){
       return view('front.terms-and-condition');
    } 
    
    public function refund_cancellation (){
       return view('front.refund-and-cancellation');
    } 
    
    public function infrastructure(){
       return view('front.infrastructure');
    }
    
    public function registration_form()
    {
        $data['countries'] = DB::table('countries')->orderBy('name','asc')->get();
       return view('front.registration-form',$data);
    }
    
    public function get_state(Request $request)
    {
        $states = DB::table('states')->where('country_id',$request->country_id)->orderBy('name','asc')->get();
        
        foreach($states as $row){
             ?>
               <option id="<?php echo $row->id;?>" value="<?php echo $row->name;?>"><?php echo $row->name;?></option>
             <?php
        }
    }
    public function get_city(Request $request)
    {
        $cities = DB::table('cities')->where('state_id',$request->state_id)->orderBy('city','asc')->get();
        
        foreach($cities as $row){
             ?>
               <option id="<?php echo $row->id;?>" value="<?php echo $row->city;?>"><?php echo $row->city;?></option>
             <?php
        }
    }
    
        
    public function prospectus(Request $request){
        return view('front.prospectus');
    }
    
    public function news(){
        return view('front.news');
    }
    
    public function school_integrated_program()
    {
       return view('front.school-integrated-program');
    }
    
    
    public function curriculum()
    {
       return view('front.curriculum');
    }
    public function slc(Request $request)
    {
        $no = $request->admission_no;
        if($no !=''){
        $data['slc'] = DB::table('slc')->where('admission_number',$no)->first();
        }else{
            $data['slc'] =[];
        }
       return view('front.slc',$data);
    }
    public function school_uniforms()
    {
        $data['summer_uniforms'] = DB::table('uniforms')->where('session','summer')->get();
          $data['winter_uniforms'] = DB::table('uniforms')->where('session','winter')->get();
       return view('front.school-uniforms',$data);
       return view('front.school-uniforms',$data);
    } 
     public function list_of_books()
    {
         $data['books'] = DB::table('books')->get();
       return view('front.list-of-books',$data);
    }  
     public function acedemic_calendar()
    {
           $data['calender'] = DB::table('academic_calender')->select('month_title')->distinct()->get();
           $data['session_year'] = DB::table('session_year')->orderby('id','desc')->first();
       return view('front.acedemic-calendar',$data);
    } 
     public function computer_lab()
    {
       return view('front.computer-lab');
    }
    public function first_aid_room()
    {
       return view('front.first-aid-room');
    } 
     public function activity_room(){
       return view('front.activity-room');
    }
    
    public function athletics(){
        $data['athletics'] = DB::table('athletics')->get();
        return view('front.athletics',$data);
    }
    
    public function campus_tour(){
       return view('front.campus-tour');
    } 
    
    public function application_form()
    {
       return view('front.application_form');
    }
    
    public function careers()
    {$data['careers']= DB::table('vacancy')->get();
       return view('front.careers',$data);
    }
    
    public function mandatory_public_disclosure()
    {
       return view('front.mandatory-public-disclosure');
    } 
   public function gallery()
    {
        $data['gallery']= DB::table('gallery')->where([
                                                              ['status',1]
                                                            ])->orderBy('id','desc')->get();
                                                            
        $data['categories']= DB::table('gallery_categories')->distinct()->get();                                                    
                                                            
       return view('front.gallery',$data);
    } 
   public function contact()
    {
       return view('front.contact');
    }  
   public function save_contact_details(Request $request){
   
       $table = new SaveContactUs;
       $table->name = $request->name;
       $table->email = $request->email;
       $table->message = $request->message;
       $table->save();
       return redirect()->back()->with('message','success');
   }
   
   public function save_application(Request $request){
   									
       $table = new Applications;
       $table->student_name = $request->student_name;
       $table->parent_name = $request->parent_name;
       $table->relation = $request->relation;
       $table->gender = $request->gender;
       $table->phone = $request->phone;
       $table->parent_phone = $request->parent_phone;
       $table->dob = $request->dob;
       $table->grade = $request->grade;
       $table->address = $request->address;
       $table->save();
       return redirect()->back()->with('message','Thanks your application successfully submitted We will contact you soon.');
   }
  
  public function save_student_details(Request $request)
    {
       
        $table = new Student_registered;
          
        $table->student_name=$request->student_name;
        $table->dob=$request->dob;
        $table->gender=$request->gender;
        $table->class=$request->class;
        $table->aadhar_number=$request->aadhar_number;
        $table->email=$request->email; 
        $table->phone=$request->phone; 
        $table->address=$request->address;
        $table->father_name=$request->father_name;
        $table->father_education=$request->father_education;
        $table->father_profession=$request->father_profession;
        $table->father_mobile=$request->father_mobile;
        $table->father_office_address=$request->father_office_address;
        $table->mother_name=$request->mother_name;
        $table->mother_education=$request->mother_education;
        $table->mother_profession=$request->mother_profession;
        $table->mother_mobile=$request->mother_mobile;
        $table->mother_office_address=$request->mother_office_address;
        $table->guardian_name=$request->guardian_name;
        $table->guardian_mobile=$request->guardian_mobile;
        
        $table->guardian_relation=$request->guardian_relation;
        $table->guardian_address=$request->guardian_address;
        $table->school_transport=$request->school_transport;
        $table->pickup_location=$request->pickup_location;
            

         if ($request->hasFile('image')) {
                $file = $request->file('image');
                $extension = $file->getClientOriginalExtension(); // getting image extension
                  $filename = time().'.'.$extension;
                  $file->move('images/', $filename);
                $table->image = $filename;
            }

        $table->save();

        return redirect()->back();
    } 
 public function save_student_query(Request $request)
    {
       
        $table = new Admission_query;
          
        $table->student_name=$request->student_name;
        $table->father_name=$request->father_name;
        $table->email=$request->email; 
        $table->phone=$request->phone; 
         $table->class=$request->class; 
        $table->enquiry_for=$request->enquiry_for; 
        $table->msg=$request->msg; 
     
        $table->save();

        return redirect()->back();
    }   
public function save_campus_tour(Request $request)
    {
       
        $table = new Campus_tour;
          
        $table->name=$request->name;
        $table->date=$request->date;
        $table->time=$request->time;
        $table->email=$request->email; 
        $table->phone=$request->phone; 
        $table->special_request=$request->special_request; 
        
        $table->save();

        return redirect()->back();
    }  
    
 public function save_lead(Request $request)
    {
        

        $six_digit_random_number = random_int(100000, 999999);
        
        $series = $this->get_roll_number_series($request->grade);
     
        $lastNumber = DB::table('leads')->select('series')->where('class',$request->grade)->orderBy('id','desc')->first();
  
        if(isset($lastNumber->series)){
            //  dd($lastNumber);
          $latestSeries = $lastNumber->series+1;
          $admission_number = "KIS-".$latestSeries;
        }else{
           $latestSeries = $series;    
           $admission_number = "KIS-".$series;  
        }
        
        
        $table = Leads::find($request->edit_id);
        $table->full_name=$request->full_name;
        $table->aadhar_number=$request->aadhar_number;
        $table->admission_number=$admission_number;
        $table->series=$latestSeries;
        $table->father_name=$request->father_name;
        $table->mother_name=$request->mother_name;
        $table->dob=$request->dob; 
        $table->class=$request->grade; 
        $table->phone=$request->phone; 
        $table->email=$request->email;
        $table->password=password_hash($six_digit_random_number, PASSWORD_DEFAULT); ; 
        
        $table->how_reach=$request->how_reach; 
        $table->employee_email=$request->employee_email;
        
        $table->country=$request->country; 
        $table->state=$request->state; 
        $table->city=$request->city; 
        $table->address=$request->address; 
        $table->registration_type=$request->registration_type;
        
        if ($request->hasFile('image')) {
                $file = $request->file('image');
                $extension = $file->getClientOriginalExtension(); // getting image extension
                  $filename = time().'.'.$extension;
                  $file->move('public/images/', $filename);
                $table->image = $filename;
            }
            
        $table->save();
 
         session()->forget('admission_number');
         session()->forget('username');
         session()->forget('password');
         session()->forget('lead');
         session()->forget('phone');
   
        
         Session::put('admission_number',$admission_number);
         Session::put('username',$request->email);
         Session::put('phone',$request->phone);
         Session::put('password',$six_digit_random_number);
         Session::put('lead',$table);

        
        return redirect()->to('payment-page')->with('message', 'Registration successfully done !');
        
       
    } 
    
    public function save_lead_testing(Request $request){
     
 

        $six_digit_random_number = random_int(100000, 999999);

        $series = $this->get_roll_number_series($request->grade);
     
        $lastNumber = DB::table('leads')->select('series')->where('class',$request->grade)->orderBy('id','desc')->first();
  
        if(isset($lastNumber->series)){
            //  dd($lastNumber);
          $latestSeries = $lastNumber->series+1;
          $admission_number = "KIS-".$latestSeries;
        }else{
           $latestSeries = $series;    
           $admission_number = "KIS-".$series;  
        }
        
        $table = new Leads;
        // $table->full_name=$request->full_name;
        // $table->aadhar_number=$request->aadhar_number;
        $table->admission_number=$admission_number;
        $table->series=$latestSeries;
        // $table->father_name=$request->father_name;
        // $table->mother_name=$request->mother_name;
        // $table->dob=$request->dob; 
        $table->class=$request->grade; 
        $table->phone=$request->phone; 
        $table->email=$request->email;
        $table->password=password_hash($six_digit_random_number, PASSWORD_DEFAULT); ; 
        
        // $table->how_reach=$request->how_reach; 
        // $table->employee_email=$request->employee_email;
        
        // $table->country=$request->country; 
        // $table->state=$request->state; 
        // $table->city=$request->city; 
        // $table->address=$request->address; 
        // $table->registration_type=$request->registration_type;
        
        // if ($request->hasFile('image')) {
        //         $file = $request->file('image');
        //         $extension = $file->getClientOriginalExtension(); // getting image extension
        //           $filename = time().'.'.$extension;
        //           $file->move('public/images/', $filename);
        //         $table->image = $filename;
        //     }
            
        $table->save();
 
        //  session()->forget('admission_number');
        //  session()->forget('username');
        //  session()->forget('password');
        //  session()->forget('lead');
        //  session()->forget('phone');
   
        
        //  Session::put('admission_number',$admission_number);
        //  Session::put('username',$request->email);
        //  Session::put('phone',$request->phone);
        //  Session::put('password',$six_digit_random_number);
        //  Session::put('lead',$table);
       
        
        // return redirect()->to('payment-page')->with('message', 'Registration successfully done !');
        
      
    }
    public function get_roll_number_series($class){
        
        if($class =='6th Class'){
         return 6000;
        }
        else if($class =='7th Class'){
         return 7000;
        }
        else if($class =='8th Class'){
         return 8000;
        }
        else if($class =='9th Class'){
         return 9000;
        }
        else if($class =='10th Class'){
         return 10000;
        }
        else if($class =='11th Class'){
         return 11000;
        }
        else if($class =='12th Class'){
         return 12000;
        }
        
    }
    public function send_otp(Request $request){
       
       if($this->validate_mobile($request->number)){
           
       if(empty($request->otp)){
           
           //if request come without otp then register new lead
           
            $six_digit_random_number = random_int(100000, 999999);
            $otp = random_int(1000, 9999);
            
            $checkEntryExist = DB::table('leads')->where('phone',$request->number)->first();
            
                   if(empty($checkEntryExist)){
                   
                   //if new lead 
                   
                    $table = new Leads;
                    $table->phone=$request->number;

                   }else{
                      
                     $table = Leads::find($checkEntryExist->id); 
                       
                   }
                    
                    $table->otp=$otp;
                    $table->save();
                
                    // send otp to number 
                     $this->sendOtpToNumber($request->number,$otp);
                    $data['status']=1;
                    $data['Message']='OTP send successfull !';
                    
                    return json_encode($data,true);
        
       
       }else{
          
          //varify OTP here
           $getOtp = DB::table('leads')->where([
               
                                                ['phone',$request->number],
                                                ['otp',$request->otp]
                                                
                                               ])->first();
           
           if(!empty($getOtp)){
              
              // OTP valid 
              
              $data['status']=2;
              $data['Message']='OTP Verified !';
              $data['id'] = base64_encode($getOtp->id);
              return json_encode($data,true);
               
           }else{
               
             //OTP invalid
             
             $data['status']=3;
             $data['Message']='Invalid OTP !';
             return json_encode($data,true);
             
           } 
       } 
       
      }else{
              $data['status']=3;
             $data['Message']='Invalid Mobile number !';
             return json_encode($data,true);
      }
      
    } 
    
 public  function validate_mobile($mobile)
{
    return preg_match('/^[0-9]{10}+$/', $mobile);
}
    public function sendOtpToNumber($number,$otp){
        
        // $msg =urlencode("".$otp." is your OTP to verify your mobile number for Scholarship cum Admission Test. Do not share your OTP with anyone for security reasons -BALAJI ADMISSION CONSULTANCY");
           
        // $url = "https://pgapi.vispl.in/fe/api/v1/send?username=sademo.trans&password=@Demo@123&unicode=false&from=BACPNP&to=".$number."&text=".$msg."&dltContentId=1307170270571289225";
    
        $msg =urlencode("Your Registration OTP is: ".$otp." Note: Please DO NOT SHARE this OTP with anyone. From : Karnal International School");
        $url="https://sms.k7marketinghub.com/app/smsapi/index.php?key=465AFA26A5C479&campaign=15724&routeid=100922&type=text&contacts=".$number."&senderid=KARlNS&msg=".$msg."&template_id=1707170600536930998";
    
        // Initialize a CURL session.
        $ch = curl_init(); 
         
        // Return Page contents.
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
         
        //grab URL and pass it to the variable.
        curl_setopt($ch, CURLOPT_URL, $url);
         
        $result = curl_exec($ch);

    }

     public function test_otp(){
        
        $number=9896907582;
        $reg_no ='KIS-000122';
        $msg=urlencode("Your registration has been done successfully and your registration no. is ".$reg_no." and you can download your admit card on click of below link: https://kiskarnal.in/parent/login From : Karnal International School");

        $url="https://sms.k7marketinghub.com/app/smsapi/index.php?key=465AFA26A5C479&campaign=15724&routeid=100922&type=text&contacts=".$number."&senderid=KARlNS&msg=".$msg."&template_id=1707170904010667940";
    
        // Initialize a CURL session.
        $ch = curl_init(); 
         
        // Return Page contents.
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
         
        //grab URL and pass it to the variable.
        curl_setopt($ch, CURLOPT_URL, $url);
         
        $result = curl_exec($ch);

    }
      public function make_payment(Request $request){
        
        return view('parent.payment');
       
    }
    
    public function payment_page(Request $request){
        
        $admission_number = Session::get('admission_number');
        
        $data['row'] = DB::table('leads')->where('admission_number',$admission_number)->first();
        
        if(empty($data['row'])){
            return redirect()->back()->with('message', 'Invalid Registration number !');
        }
        
        $amount=200;
        $lead = Session::get('lead');
        if($lead->registration_type =='Boarding School'){
            $amount =500;
        }
      
        return view('front.razorpay-payment-page')->with('amount',$amount);
       
    }
    
    public function notice_board(){
        $data['notice_board']= DB::table('notice_board')->orderBy('id','desc')->get();
       return view('front.notice-board',$data);
    } 

    public function announcements(){
        $data['curricular']= DB::table('curicular')->orderBy('id','desc')->get();
       return view('front.announcements',$data);
    } 
    
}