<?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 App\Models\Teachers;
use App\Models\SLC;
use App\Models\Sip_review;
use Illuminate\Http\Request;
use App\Http\Requests;
use Session;
use DB;
class TeacherController extends BaseController
{
    use AuthorizesRequests, DispatchesJobs, ValidatesRequests;

   
    public function save_teacher(Request $request)
    {
        
      if($request->edit_id ==''){
           $table = new Teachers;
           $type='success';
           $msg='New Teacher Added Successfully';
      }else{
         
           $table =Teachers::find($request->edit_id);
           $type='info';
           $msg='Teacher Updated Successfully';
      }  
       
        $table->name=$request->name;
        $table->post=$request->post;
        $table->featured=empty($request->featured) ? 0 : $request->featured;
        $table->description=$request->description;
        $table->category=$request->category;
        $table->status=1;
     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_review(Request $request)
    {
        
      if($request->edit_id ==''){
           $table = new Sip_review;
           $type='success';
           $msg='New Review Added Successfully';
      }else{
         
           $table =Sip_review::find($request->edit_id);
           $type='info';
           $msg='Review Updated Successfully';
      }  
       	
        $table->name=$request->name;
        $table->class=$request->class;
        $table->description=$request->description;
        $table->review=$request->review;
   
         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 teachers(Request $request){
      $data['teachers']=DB::table('teachers')->get();
      return view('admin.teacher-list',$data);
  }  
 public function delete_teacher($id){
     $data = DB::table('teachers')->where('id',$id)->delete();
     if($data){
         return 1;
     }
 } 
 
 public function delete_review($id){
     $data = DB::table('sip_review')->where('id',$id)->delete();
     if($data){
         return 1;
     }
 } 
 
  public function save_slc(Request $request)
    {
        
      if($request->edit_id ==''){
           $table = new SLC;
           $type='success';
           $msg='New SLC Added Successfully';
      }else{
         
           $table =SLC::find($request->edit_id);
           $type='info';
           $msg='SLC Updated Successfully';
      }  
       
        $table->student_name=$request->student_name;
        $table->admission_number=$request->admission_number;
        
         $table->father_name=$request->father_name;
        $table->status=1;
     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 slc_issued_list(){
        $data['slc']=DB::table('slc')->get();
        return view('admin.slc_issued_list',$data);
    }
    public function delete_slc($id){
     $data = DB::table('slc')->where('id',$id)->delete();
     if($data){
         return 1;
     }
 } 
}