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\Backend;

use App\Models\District;
use App\Models\Division;
use Illuminate\Http\Request;
use App\Http\Controllers\Controller;

class DistrictController 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_district'))
        {
            return redirect('/');
        }
        
        return view('district.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 =District::orderBy($columnName,$columnSortOrder)
            ->leftJoin('divisions','districts.division_id','divisions.division_id')
            ->select('districts.*','divisions.division_name');
        if($columnName_arr[0]['search']['value'] != null){
            $chalans=$chalans->Where('district_id', $columnName_arr[0]['search']['value'] );
        }
        if($columnName_arr[1]['search']['value'] != null){
            $chalans=$chalans->Where('division_name', 'like', $columnName_arr[1]['search']['value'] . '%');
        }
         if($columnName_arr[2]['search']['value'] != null){
            $chalans=$chalans->Where('district_name', 'like', $columnName_arr[2]['search']['value'] . '%');
        }
        if($columnName_arr[3]['search']['value'] != null){
            $chalans=$chalans->Where('districts.status', $columnName_arr[3]['search']['value'] );
        }
            
        if($rowperpage < 0) {
            $rowperpage = 8999999999999999999;
        }
            $totalRecords =$chalans->count();
        $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_district'))
        {
           $action .='<a href="'.url('edit_district/'.$chalan->district_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(
                "district_id" => $chalan->district_id,
                "district_name" => $chalan->district_name,
                'division_name' => $chalan->division_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;
    }
    public function getAllDistrictById(Request $request){
        if(isset($request->division_list)){
            return District::whereIn('division_id',$request->division_list)->where('status',1)->get();
        }
        return District::where('division_id',$request->division_id)->where('status',1)->get();
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        if(!auth()->user()->canEvent('add_district'))
        {
            return redirect('/');
        }
        $divisions = Division::where('status',1)->get();
        return view('district.create',['divisions'=>$divisions]);
    }

    /**
     * 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(), [
            'district_name' => 'required|unique:districts|max:150',
            'division' => 'required',
           
        ]);
        
        if ($validator->fails())
        {
            return response()->json(['errors'=>$validator->errors()->all()]);
        }else{
           //return  response()->json(['re'=> auth()->user()->user_id]);
            $district =  new District;
            $district->district_name = $request->district_name;
            $district->division_id = $request->division;
            $district->status = $request->status ? $request->status : 0;
            $district->created_by = auth()->user()->user_id;
            $district->save();
        }
        return response()->json(['errors'=>'0','success'=>$request->district_name.' is successfully added']);
    }

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

    /**
     * Show the form for editing the specified resource.
     *
     * @param  \App\Models\District  $district
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        if(!auth()->user()->canEvent('edit_district'))
        {
            return redirect('/');
        }
         $divisions = Division::where('status',1)->get();
        $district = District::where('district_id',$id)->first();
        return view('district.edit',['divisions'=>$divisions,'district'=>$district]);
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\Models\District  $district
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, District $district)
    {
        $id=$request->district_id;
       
        $validator = \Validator::make($request->all(), [
            'district_name' => 'required|max:150|unique:districts,district_name,'.$id.',district_id',
            'division' => 'required',
           
        ]);
        
        if ($validator->fails())
        {
            return response()->json(['errors'=>$validator->errors()->all()]);
        }else{
           //return  response()->json(['re'=> auth()->user()->user_id]);
            $district =  District::find($request->district_id);
            $district->district_name = $request->district_name;
            $district->division_id = $request->division;
            $district->status = $request->status ? $request->status : 0;
            $district->created_by = auth()->user()->user_id;
            $district->save();
        }
        return response()->json(['errors'=>'0','success'=>$request->district_name.' is successfully Updated']);
    }

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