OwlCyberSecurity - MANAGER

Edit File: SlidersController.php

<?php

namespace App\Http\Controllers;

use App\Http\Requests\SliderAddRequest;
use App\Http\Requests\SliderUpdateRequest;
use App\Models\Slider;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Storage;
use Throwable;

class SlidersController extends Controller
{
    //Returns slider view
    public function index(){
        return view('Sliders.index' , ['title' => 'Sliders Listing']);
    }

//Returns sliders listing
    public function sliders_listing(Request $request){
        // Get required data
        $draw = $request->get('draw');
        $start = $request->get('start');
        $length = $request->get('length');
        $orderArray = $request->get('order');
        $orderBy = $orderArray[0]['column'];
        $orderDir = $orderArray[0]['dir'];
        $searchArray = $request->get('search');
        $searchValue = $searchArray['value'];

// preparing select query
        $q = Slider::selectRaw('
            sliders.id,
            sliders.heading,
            sliders.link,
            FORMAT(sliders.price,2) as price_formatted,
            IF(sliders.status = 1 , "Active" , "Inactive") as status_fomated,
            DATE_FORMAT(sliders.created_at,"%d/%m/%Y<br>%h:%i:%s %p") as created_date
        ');

$total = $q->count();

// search functionality
        if(isset($searchValue) && !empty($searchValue)){
            $formated_search = preg_replace('/[^\sA-Za-z0-9@.\/\-]/', '', strtolower($searchValue));
            $q->whereRaw('(
                sliders.heading LIKE "%'.$formated_search.'%"
                OR sliders.link LIKE "%'.$formated_search.'%"
                OR FORMAT(sliders.price,2) LIKE "%'.$formated_search.'%"
                OR IF(sliders.status = 1 , "Active" , "Inactive") LIKE "%'.$formated_search.'%"
                OR DATE_FORMAT(sliders.created_at,"%d/%m/%Y<br>%h:%i:%s %p") LIKE "%'.$formated_search.'%"
            )');
        }

// column ordering
        if(isset($orderBy) && isset($orderDir)){
            $columns = [
                1 => 'sliders.heading',
                2 => 'sliders.link',
                3 => 'price_formatted',
                4 => 'status_fomated',
                5 => 'created_date',
            ];
            if(array_key_exists($orderBy , $columns)){
                $q->orderBy($columns[$orderBy] , $orderDir);
            }
        }

// filtered cound
        $filtered = $q->count();
        // requested data size
        $records = $q->skip($start)->take($length)->get();

// formating data
        $data = [];
        foreach($records as $r){
            $data[] = [
                'checkbox' => '<input type="checkbox" name="checkbox'.$r->id.'" id="checkbox'.$r->id.'" class="checkboxes" value="'.$r->id.'">',
                'heading' => $r->heading,
                'link' => $r->link,
                'price' => $r->price_formatted,
                'status' => $r->status_fomated,
                'created_at' => $r->created_date,
                'action' => '<a href="'.route('get_sliders_edit.edit_sliders' , ['id' => $r->id ]).'"><button class="custom-blue-btn w-100">Edit</button></a>',
            ];
        }

// returning response
        return response()->json([
            "draw" => intval($draw),
            "iTotalRecords" => $total,
            "iTotalDisplayRecords" => $filtered,
            "aaData" => $data
        ] ,200);
    }

// Returns sliders add view
    public function add(){
        return view('Sliders.add' , ['title' => 'Add Slider']);
    }

// Return sliders add view
    public function store(SliderAddRequest $request){
        try {
            // new slider object
            $slider = new Slider();
            // add data
            $slider->heading = $request->get('heading');
            $slider->link = $request->get('link');
            $slider->price = $request->get('price');
            $slider->description = $request->get('description');
            $slider->status = $request->get('status');
            if($request->has('image')){
                $image = $request->file('image');
                $image_name = 'slider_'.now()->format('Y_m_d_H_i_s').'.'.$image->getClientOriginalExtension();
                $saved = Storage::disk('sliders')->put($image_name , file_get_contents($image));
                if($saved){
                    $slider->image = $image_name;
                }
            }
            $slider->created_at = new \DateTime();
            $slider->updated_at = null;
            // creating new slider
            $slider->save();
            return redirect('admin/sliders')->with('success' , 'Slider added.');
        } catch (Throwable $th){
            return redirect()->back()->with('message' , $th->getMessage())->withInput($request->except('image'));
        }
    }

// Return sliders edit view
    public function edit($id){
        // requested slider data
        if($id > 0){
            $slider = Slider::where('id' , $id)->first();
            if(!empty($slider)){
                return view('Sliders.edit', ['title' => 'Edit Slider' , 'slider' => $slider]);
            }
            else{
                return redirect('admin/sliders')->with('message' , 'Slider not found');
            }
        }
        return redirect('login');
    }

// updates slider
    public function update(SliderUpdateRequest $request , $id){
        if($id > 0){
            $slider = Slider::where('id' , $id)->first();
            if(!empty($slider)){
                DB::beginTransaction();
                try {
                    // add data
                    $slider->heading = $request->get('heading');
                    $slider->link = $request->get('link');
                    $slider->price = $request->get('price');
                    $slider->description = $request->get('description');
                    $slider->status = $request->get('status');
                    if($request->has('image')){
                        if(isset($slider->image) && !empty($slider->image)){
                            if(Storage::disk('sliders')->exists($slider->image)){
                                Storage::disk('sliders')->delete($slider->image);
                            }
                        }
                        $image = $request->file('image');
                        $image_name = 'slider_'.now()->format('Y_m_d_H_i_s').'.'.$image->getClientOriginalExtension();
                        $saved = Storage::disk('sliders')->put($image_name , file_get_contents($image));
                        if($saved){
                            $slider->image = $image_name;
                        }
                    }
                    $slider->updated_at = new \DateTime();
                    // update slider
                    $slider->update();
                    DB::commit();
                    return redirect('admin/sliders')->with('success' , 'Slider updated.');
                } catch (Throwable $th){
                    DB::rollBack();
                    return redirect()->back()->with('message' , $th->getMessage())->withInput($request->except('image'));
                }
            }
        }
        return route('login');
    }

// delete selected slider ajax function
    public function delete(Request $request){
        DB::beginTransaction();
        try {
            $ids = is_array($request->get('ids')) ? $request->get('ids') : [];
            if(count($ids)){
                $all_image_name = Slider::whereIn('id' , $ids)->pluck('image')->toArray();
                foreach($all_image_name as $i){
                    if(isset($i) && !empty($i)){
                        if(Storage::disk('sliders')->exists($i)){
                            Storage::disk('sliders')->delete($i);
                        }
                    }
                }
                Slider::whereIn('id' , $ids)->delete();
                DB::commit();
                return response()->json(['success' => true , 'message' => 'Slider'.(count($ids) > 1 ? "s" : "").' deleted successfully.'] , 200);
            }
            return response()->json(['message' => 'No slider selected'] , 422);
        } catch (Throwable $th){
            DB::rollBack();
            return response()->json(['message' => $th->getMessage()] , 422);
        }
    }

// delete slider image
    function deleteImage($id){
        if($id > 0){
            $slider = Slider::where('id' , $id)->first();
            try {
                if(!empty($slider)){
                    if(isset($slider->image) && !empty($slider->image)){
                        if(Storage::disk('sliders')->exists($slider->image)){
                            Storage::disk('sliders')->delete($slider->image);
                            $slider->image = null;
                            $slider->update();
                        }
                        return response()->json(['message' => 'Slider image deleted'] , 200);
                    }
                }
                return response()->json(['message' => 'Slider not found'] , 422);
            } catch (Throwable $th){
                return response()->json(['message' => $th->getMessage()] , 422);
            }
        }
        return response()->json(['message' => 'Slider not found'] , 422);
    }
}