<?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\Notice_board; 
use App\Models\AcademicCalender;
use App\Models\Curicular;
use App\Models\Vacancy;
use App\Models\Books;
use App\Models\Message;
use App\Models\Athletics; 
use App\Http\Requests;
use Session;
use DB;

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

   public function save_notice(Request $request)
    {
        if($request->edit_id ==''){
           $table = new Notice_board;
           $type='success';
           $msg='New Notice Added Successfully';
      }else{
         
           $table =Notice_board::find($request->edit_id);
           $type='info';
           $msg='Notice Updated Successfully';
      }  
      

        $table->notice_name=$request->notice_name;
       
         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();

        return redirect()->back()->with('type',$type)->with('msg',$msg);;
    } 
    
    public function save_curricular(Request $request)
    {
        if($request->edit_id ==''){
           $table = new Curicular;
           $type='success';
           $msg='New Curicular Added Successfully';
      }else{
         
           $table =Curicular::find($request->edit_id);
           $type='info';
           $msg='Curicular Updated Successfully';
      }  
      

        $table->curicular_name=$request->curicular_name;
       
         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();

        return redirect()->back()->with('type',$type)->with('msg',$msg);;
    } 
    public function save_vacancy(Request $request)
    {
        if($request->edit_id ==''){
           $table = new Vacancy;
           $type='success';
           $msg='New Vacancy Added Successfully';
      }else{
         
           $table =Vacancy::find($request->edit_id);
           $type='info';
           $msg='Vacancy Updated Successfully';
      }  
      

        $table->job_title=$request->job_title;
        $table->qualification=$request->qualification;
        $table->total_position=$request->total_position;
        $table->status=1;

        $table->save();

        return redirect()->back()->with('type',$type)->with('msg',$msg);;
    }  
    
     public function save_calender(Request $request)
    {
        if($request->edit_id ==''){
           $table = new AcademicCalender;
           $type='success';
           $msg='New Calender Added Successfully';
      }else{
         
           $table =AcademicCalender::find($request->edit_id);
           $type='info';
           $msg='Calender Updated Successfully';
      }  
      

        $table->name=$request->name;
        $table->month_title=$request->month_title;
        $table->date=$request->date;
        $table->time=$request->time;
        
       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();

        return redirect()->back()->with('type',$type)->with('msg',$msg);;
    }  
    public function delete_calender($id){
     $data = DB::table('academic_calender')->where('id',$id)->delete();
     if($data){
         return 1;
     }
    }    
    
 public function save_msg(Request $request)
    {
        if($request->edit_id ==''){
           $table = new Message;
           $type='success';
           $msg='New Message Added Successfully';
      }else{
         
           $table =Message::find($request->edit_id);
           $type='info';
           $msg='Message Updated Successfully';
      }  
      

        $table->name=$request->name;
        $table->message=$request->message;
        $table->msg_to=$request->msgfor;

       
         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();

        return redirect()->back()->with('type',$type)->with('msg',$msg);;
    } 
 public function delete_msg($id){
     $data = DB::table('message')->where('id',$id)->delete();
     if($data){
         return 1;
     }
    } 
    
 public function delete_notice($id){
     $data = DB::table('notice_board')->where('id',$id)->delete();
     if($data){
         return 1;
     }
    }  
public function delete_curricular($id){
     $data = DB::table('curicular')->where('id',$id)->delete();
     if($data){
         return 1;
     }
    }   
public function save_athletic(Request $request)
    {
        if($request->edit_id ==''){
           $table = new Athletics;
           $type='success';
           $msg='New Athletics Added Successfully';
      }else{
         
           $table =Athletics::find($request->edit_id);
           $type='info';
           $msg='Athletics Updated Successfully';
      }  
      

        $table->sport_name=$request->sport_name;
        $table->description=$request->description;

         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();

        return redirect()->back()->with('type',$type)->with('msg',$msg);;
    }     
    public function delete_athletic($id){
     $data = DB::table('athletics')->where('id',$id)->delete();
     if($data){
         return 1;
     }
    }
    public function save_book(Request $request)
    {
        if($request->edit_id ==''){
           $table = new Books;
           $type='success';
           $msg='New Books Added Successfully';
      }else{
         
           $table =Books::find($request->edit_id);
           $type='info';
           $msg='Books Updated Successfully';
      }  
      

        $table->book_name=$request->book_name;
        $table->class_name=$request->class_name;

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

        $table->save();

        return redirect()->back()->with('type',$type)->with('msg',$msg);;
    }     
    public function delete_book($id){
     $data = DB::table('books')->where('id',$id)->delete();
     if($data){
         return 1;
     }
    }
}