Server : Apache System : Linux host44.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64 User : vapecompany ( 2719) PHP Version : 7.4.33 Disable Function : NONE Directory :  /home/vapecompany/demo.vapecompany.com.bd/app/Http/Controllers/Backend/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php

namespace App\Http\Controllers;

use App\Models\Department;
use Illuminate\Http\Request;

class DepartmentController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function __construct()
    {
        $this->middleware('auth');
       
    }
    public function index()
    {
        if(!auth()->user()->canEvent('all_department'))
        {
            return redirect('/');
        }
        return view('department.list');
    }
    function get_all(Request $request){
        $draw = $request->get('draw');
        $start = $request->get("start");
        $rowperpage = $request->get("length"); // Rows display per page

        $columnIndex_arr = $request->get('order');
        $columnName_arr = $request->get('columns');
        $order_arr = $request->get('order');
        $search_arr = $request->get('search');

        $columnIndex = $columnIndex_arr[0]['column']; // Column index
        $columnName = $columnName_arr[$columnIndex]['data']; // Column name
        $columnSortOrder = $order_arr[0]['dir']; // asc or desc
        $searchValue = $search_arr['value']; // Search value

        
        $chalans =Department::orderBy($columnName,$columnSortOrder);
        if($columnName_arr[0]['search']['value'] != null){
            $chalans=$chalans->Where('department_id',  $columnName_arr[0]['search']['value'] );
        }
        if($columnName_arr[1]['search']['value'] != null){
            $chalans=$chalans->Where('department_name', 'like', $columnName_arr[1]['search']['value'] . '%');
        }
        if($columnName_arr[2]['search']['value'] != null){
            $chalans=$chalans->Where('status',$columnName_arr[2]['search']['value'] );
        }    
            
           // ->Where('department_name', 'like', $searchValue . '%');

            $totalRecords =$chalans->count();
            if($rowperpage < 0) {
            $rowperpage = 8999999999999999999;
        }
        $chalans =$chalans->skip($start)
            ->take($rowperpage)
            ->get();
        $data_arr = array();

        foreach($chalans as $chalan){


            $action ='<div role="group" aria-label="Basic example" class="btn-group btn-group-sm">';
            if(auth()->user()->canEvent('edit_department'))
            {
                $action .='<a href="'.url('edit_department/'.$chalan->department_id).'" class="mr-2">
                                                        <i class="fa fa-edit text-warning"></i>
                                                    </a> ';
            }
            //if(auth()->user()->canEvent('viewchalan'))
           // {                                    
             // $action .='<a href="'.url('document/model/'.$chalan->category_id).'" class="mr-2">
             //                                            Documents
             //                                        </a> ';
          //  }
            $action .='</div>';
          
                                   
            $data_arr[] = array(
                "department_id" => $chalan->department_id,
                "department_name" => $chalan->department_name,
                "status" => $chalan->status == 1 ? 'Active' : 'In Active',
               
                "Action" => $action,
            );
        }
        $response = array(
            "draw" => intval($draw),
            "recordsTotal" => $totalRecords,
            "recordsFiltered" => $totalRecords,
            "data" => $data_arr
        ); 

        echo json_encode($response);
        exit;
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        if(!auth()->user()->canEvent('new_department'))
        {
            return redirect('/');
        }
       return view('department.create');
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        $validator = \Validator::make($request->all(), [
            'department_name' => 'required|unique:departments|max:150',
           
        ]);
        
        if ($validator->fails())
        {
            return response()->json(['errors'=>$validator->errors()->all()]);
        }else{
           //return  response()->json(['re'=> auth()->user()->user_id]);
            $department =  new Department;
            $department->department_name = $request->department_name;
            $department->status = $request->status ? $request->status : 0;
            $department->created_by = auth()->user()->user_id;
            $department->save();
        }
        return response()->json(['errors'=>'0','success'=>$request->department_name.' is successfully added']);
    }

    /**
     * Display the specified resource.
     *
     * @param  \App\Models\Department  $department
     * @return \Illuminate\Http\Response
     */
    public function show(Department $department)
    {
        
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  \App\Models\Department  $department
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        if(!auth()->user()->canEvent('edit_department'))
        {
            return redirect('/');
        }
        $department=Department::where('department_id',$id)->first();
        return view('department.edit',['department'=>$department]);
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\Models\Department  $department
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, Department $department)
    {
         $id=$request->department_id;
        $validator = \Validator::make($request->all(), [
            'department_name' => 'required|max:150|unique:departments,department_name,'.$id.',department_id',
           
        ]);
        
        if ($validator->fails())
        {
            return response()->json(['errors'=>$validator->errors()->all()]);
        }else{
           //return  response()->json(['re'=> auth()->user()->user_id]);
            $department =   Department::where('department_id',$id)->first();
            $department->department_name = $request->department_name;
            $department->status = $request->status ? $request->status : 0;
            $department->created_by = auth()->user()->user_id;
            $department->save();
        }
        return response()->json(['errors'=>'0','success'=>$request->department_name.' is successfully added']);
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  \App\Models\Department  $department
     * @return \Illuminate\Http\Response
     */
    public function destroy(Department $department)
    {
        //
    }
}