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\Region;
use Illuminate\Http\Request;

class RegionController 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_region'))
        {
            return redirect('/');
        }
        //$regions = Region::get();
        return view('region.index');
    }
    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

        $totalRecords = Region::count();
        $chalans =Region::orderBy($columnName,$columnSortOrder);
        if($columnName_arr[0]['search']['value'] != null){
            $chalans=$chalans->Where('region_id' ,$columnName_arr[0]['search']['value']);
        }
        if($columnName_arr[1]['search']['value'] != null){
            $chalans=$chalans->Where('region_name', 'Like', $columnName_arr[1]['search']['value'] . '%');
        }
        if($columnName_arr[2]['search']['value'] != null){
            $chalans=$chalans->Where('status', $columnName_arr[2]['search']['value']);
        }   
            
        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_region'))
            { 
              $action .='<a href="'.url('edit_region/'.$chalan->region_id).'" class="mr-2">
                                                        <i class="fa fa-edit text-warning"></i>
                                                    </a> ';
            }
        
            $action .='</div>';
          
                                   
            $data_arr[] = array(
                "region_id" => $chalan->region_id,
                "region_name" => $chalan->region_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_region'))
        {
            return redirect('/');
        }
        return view('region.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(), [
            'region_name' => 'required|unique:regions|max:150',
           
        ]);
        
        if ($validator->fails())
        {
            return response()->json(['errors'=>$validator->errors()->all()]);
        }else{
           //return  response()->json(['re'=> auth()->user()->user_id]);
            $region =  new Region;
            $region->region_name = $request->region_name;
            $region->status = $request->status ? $request->status : 0;
            $region->created_by = auth()->user()->user_id;
            $region->save();
        }
        return response()->json(['errors'=>'0','success'=>$request->region_name.' is successfully added']);
    }

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

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

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

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