<?php

namespace App\Http\Controllers\Admin;

use Illuminate\Foundation\Auth\Access\AuthorizesRequests;
use Illuminate\Foundation\Bus\DispatchesJobs;
use Illuminate\Foundation\Validation\ValidatesRequests;
use Illuminate\Routing\Controller as BaseController;
use Illuminate\Http\Request;
use App\Models\Gallery_category;
use App\Models\SessionYear;
use App\Http\Requests;
use Session;
use DB;
use Carbon\Carbon;


class AdminController extends BaseController
{
    use AuthorizesRequests, DispatchesJobs, ValidatesRequests;

    public function dashboard()
    {
        return view('admin.index');
    }
    public function gallery(Request $request){
         if($request->q !=''){
              $data['gallery'] = DB::table('gallery')->where('id',$request->q)->first();
         }
         $data['categories'] = DB::table('gallery_categories')->get();
        return view('admin.gallery',$data);
    } 
    
    public function gallery_list(){
        $data['gallery_list']=DB::table('gallery')->get();
        return view('admin.gallery_list',$data);
    } 
    
    public function add_teachers(Request $request){
        if($request->q !=''){
            
            $data['teacher'] = DB::table('teachers')->where('id',$request->q)->first();
            return view('admin.add-teachers',$data);
            
        }else{
          return view('admin.add-teachers');
        }
    } 
    
    public function add_slc(Request $request){
        if($request->q !=''){
            
             $data['slc'] = DB::table('slc')->where('id',$request->q)->first();
             return view('admin.add_slc',$data);
             
        }else{
            
             return view('admin.add_slc');
        }
        
    }
    
    public function sip_review(Request $request){
        if($request->q !=''){
            
             $data['row'] = DB::table('sip_review')->where('id',$request->q)->first();
             return view('admin.sip_review',$data);
             
        }else{
            
             return view('admin.sip_review');
        }
        
        
    }
    
    public function sip_review_list(Request $request){
        $data['row']=DB::table('sip_review')->orderBy('id','desc')->get();
        
        return view('admin.sip_review_list',$data);
    }
    
    public function add_vacant_post(Request $request){
        return view('admin.add_vacant_post');
    }
    
    public function vacant_list(Request $request){
        return view('admin.vacant_list');
    }
    
    public function leads(Request $request){
        $data['leads']=DB::table('leads')
        // ->whereMonth('created_at', Carbon::now()->month)
        ->where('created_at','>=', '2024-08-01 00:00:00')
        // ->where('amount','!=','')
        ->orderBy('id','desc')->get();
        return view('admin.leads',$data);
    }
    
    public function gallery_category(Request $request){
        $data['gallery_category']=DB::table('gallery_categories')->get();
        return view('admin.gallery-category',$data);
    }
    
    public function save_category(Request $request){
        $table = new Gallery_category;
        $table->name = $request->name;
        $table->save();
        return redirect()->back();
    }
    public function delete_category($id){
     $data = DB::table('gallery_categories')->where('id',$id)->delete();
     if($data){
         return 1;
     }
    }
    
    public function add_notice(Request $request){
         if($request->q !=''){
            
             $data['notice'] = DB::table('notice_board')->where('id',$request->q)->first();
             return view('admin.add_notice',$data);
             
        }else{
             return view('admin.add_notice');
        }
    }
    
    public function add_curicular(Request $request){
         if($request->q !=''){
            
             $data['curricular'] = DB::table('curicular')->where('id',$request->q)->first();
             return view('admin.add_curicular',$data);
             
        }else{
        return view('admin.add_curicular');
        }
    }
    
    
    public function notice_list(Request $request){
         $data['notice_list']=DB::table('notice_board')->get();
        return view('admin.notice_list',$data);
    }
    
    public function curicular_list(Request $request){
         $data['curicular_list']=DB::table('curicular')->get();
        return view('admin.curicular_list',$data);
    }
    
    public function add_principal_message(Request $request){
          if($request->q !=''){
            
             $data['message'] = DB::table('message')->where('id',$request->q)->first();
             return view('admin.add_principal_message',$data);
             
        }else{
        return view('admin.add_principal_message');
        }
    }

    public function message_list(Request $request){
         $data['messages']=DB::table('message')->get();
        return view('admin.message_list',$data);
    }
    
    public function add_athletics(Request $request){
         if($request->q !=''){
            
             $data['athletic'] = DB::table('athletics')->where('id',$request->q)->first();
             return view('admin.add_athletics',$data);
             
        }else{
               return view('admin.add_athletics');
        }
    }
    
    public function athletics_list(Request $request){
         $data['athletics']=DB::table('athletics')->get();
        return view('admin.athletics_list',$data);
    }
    
    
    
    public function add_acedemic_calender(Request $request){
         if($request->q !=''){
            
             $data['calender'] = DB::table('academic_calender')->where('id',$request->q)->first();
             return view('admin.add_acedemic_calender',$data);
             
        }else{
               return view('admin.add_acedemic_calender');
         }
    }
    
    public function acedemic_calender_list(Request $request){
        $data['calenders']=DB::table('academic_calender')->get();
        return view('admin.acedemic_calender_list',$data);
    }
    
    public function add_books(Request $request){
        if($request->q !=''){
            
             $data['book'] = DB::table('books')->where('id',$request->q)->first();
             return view('admin.add_books',$data);
             
        }else{
                 return view('admin.add_books');
        }     
    }
    
    public function books_list(Request $request){
         $data['books']=DB::table('books')->get();
        return view('admin.books_list',$data);
    }
    
    public function add_banners(Request $request){
        if($request->q !=''){
            
             $data['banner'] = DB::table('banners')->where('id',$request->q)->first();
             return view('admin.add_banners',$data);
             
        }else{
                 return view('admin.add_banners');
        }
    }
    
    public function banner_list(Request $request){
        $data['banners']=DB::table('banners')->get();
        return view('admin.banner_list',$data);
    }
    
    public function add_school_uniform(Request $request){
         if($request->q !=''){
            
             $data['uniform'] = DB::table('uniforms')->where('id',$request->q)->first();
             return view('admin.add_school_uniform',$data);
             
        }else{
        return view('admin.add_school_uniform');
        }
    }
    
    public function school_uniform_list(Request $request){
         $data['uniforms']=DB::table('uniforms')->get();
        return view('admin.school_uniform_list',$data);
    }
    
    public function add_about(Request $request){
        if($request->q !=''){
            
             $data['about'] = DB::table('about')->where('id',$request->q)->first();
             return view('admin.add_about',$data);
             
        }else{
               return view('admin.add_about');
        }
    }
    
    public function about_list(Request $request){
        $data['about']=DB::table('about')->get();
        return view('admin.about_list',$data);
    }
    
    
    public function login(Request $request){
        session()->forget('admin');
        return view('admin.login');
    }
    
    public function register(Request $request){
        return view('admin.register');
    }
    
    public function users_profile(Request $request){
        return view('admin.users_profile');
    }
    
    public function save_year(Request $request){
      $table= new SessionYear;
      $table->year= $request->year;
      $table->save();
      return redirect()->back();
    }
    
}