OwlCyberSecurity - MANAGER

Edit File: GalleryController.php

<?php

namespace App\Http\Controllers;

use App\Http\Requests\GalleryAddRequest;
use App\Http\Requests\GalleryUpdateRequest;
use App\Models\Gallery;
use App\Models\Categories;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Storage;
use Throwable;
use Illuminate\Support\Str;

class GalleryController extends Controller
{
    public $data = [];
    public function __construct()
    {
        // parent::__construct();
    }

public function index()
    {
        return view('gallery.index', ['title' => 'Gallery']);
    }

public function 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 = Gallery::selectRaw('
            id,
            title,
            image
        ');

$total = $q->count();

// search functionality
        if (isset($searchValue) && !empty($searchValue)) {
            $formated_search = preg_replace('/[^\sA-Za-z0-9@.\/\-]/', '', strtolower($searchValue));
            $q->whereRaw('(
                title LIKE "%' . $formated_search . '%"
            )');
        }

// column ordering
        if (isset($orderBy) && isset($orderDir)) {
            $columns = [
                1 => 'title'
            ];
            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 . '">',
                'title' => $r->title,
                'image' => '<img src="'.url('storage/gallery/'.$r->image).'" width="100" />',
                'url' => url('storage/gallery/'.$r->image),
                'action' => '<a href="' . route('edit_gallery.edit_gallery', ['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);
    }

public function add()
    {
        $this->data['title'] = 'Add Gallery';
        return view('gallery.add', $this->data);
    }

public function store(GalleryAddRequest $request)
    {
        try {
            // new gallery object
            $gallery = new Gallery();
            // add data
            $gallery->title = $request->get('title');
            if ($request->has('image')) {
                $image = $request->file('image');
                $image_name = 'image_' . Str::slug($request->get('title')) . '_' . now()->format('Y_m_d_H_i_s') . '.' . $image->getClientOriginalExtension();
                $saved = Storage::disk('gallery')->put($image_name, file_get_contents($image));
                if ($saved) {
                    $gallery->image = $image_name;
                }
            }
            // creating new gallery
            $gallery->save();
            return redirect('admin/gallery')->with('success', 'Gallery added.');
        } catch (Throwable $th) {
            return redirect()->back()->with('message', $th->getMessage())->withInput($request->except('image'));
        }
    }

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

public function update(GalleryUpdateRequest $request, $id)
    {
        if ((int)$id > 0) {
            $gallery = Gallery::where('id', $id)->first();
            if (!empty($gallery)) {
                DB::beginTransaction();
                try {
                    // add data
                    $gallery->title = $request->get('title');
                    if ($request->has('image')) {
                        if (isset($gallery->image) && !empty($gallery->image)) {
                            if (Storage::disk('gallery')->exists($gallery->image)) {
                                Storage::disk('gallery')->delete($gallery->image);
                            }
                        }
                        $image = $request->file('image');
                        $image_name = 'image_' . Str::slug($request->get('title')) . '_' . now()->format('Y_m_d_H_i_s') . '.' . $image->getClientOriginalExtension();
                        $saved = Storage::disk('gallery')->put($image_name, file_get_contents($image));
                        if ($saved) {
                            $gallery->image = $image_name;
                        }
                    }
                    // update gallery
                    $gallery->update();
                    DB::commit();
                    return redirect('admin/gallery')->with('success', 'Gallery updated.');
                } catch (Throwable $th) {
                    DB::rollBack();
                    return redirect()->back()->with('message', $th->getMessage())->withInput($request->except('image'));
                }
            }
        }
        return route('login');
    }

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