OwlCyberSecurity - MANAGER

Edit File: NetworksController.php

<?php

namespace App\Http\Controllers;

use App\Http\Requests\NetworkAddRequest;
use App\Http\Requests\NetworkUpdateRequest;
use App\Models\Network;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Storage;
use Throwable;

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

//Returns networks listing
    public function networks_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 = Network::selectRaw('
            networks.id,
            networks.name,
            networks.meta_title,
            networks.meta_keywords,
            IF(networks.status = 1 , "Active" , "Inactive") as status_fomated,
            DATE_FORMAT(networks.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('(
                networks.name LIKE "%'.$formated_search.'%"
                OR networks.meta_title LIKE "%'.$formated_search.'%"
                OR FIND_IN_SET("'.$formated_search.'" , networks.meta_keywords)
                OR IF(networks.status = 1 , "Active" , "Inactive") LIKE "%'.$formated_search.'%"
                OR DATE_FORMAT(networks.created_at,"%d/%m/%Y<br>%h:%i:%s %p") LIKE "%'.$formated_search.'%"
            )');
        }

// column ordering
        if(isset($orderBy) && isset($orderDir)){
            $columns = [
                1 => 'networks.name',
                2 => 'networks.meta_title',
                3 => 'networks.meta_keywords',
                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){
            $keywords = '';
            if(isset($r->meta_keywords) && !empty($r->meta_keywords)){
                foreach(explode(',',$r->meta_keywords) as $k){
                    $keywords .= '<span class="keywords_class" onclick="addThisToSearch(\''.$k.'\')">'.$k.'</span>';
                }
            }
            $data[] = [
                'checkbox' => '<input type="checkbox" name="checkbox'.$r->id.'" id="checkbox'.$r->id.'" class="checkboxes" value="'.$r->id.'">',
                'name' => $r->name,
                'title' => $r->meta_title,
                'keywords' => $keywords,
                'status' => $r->status_fomated,
                'created_at' => $r->created_date,
                'action' => '<a href="'.route('get_networks_edit.edit_networks' , ['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);
    }

// Return networks add view
    public function add(){
        return view('Networks.add', ['title' => 'Add Network']);
    }

// Return networks add view
    public function store(NetworkAddRequest $request){
        try {
            // new network object
            $network = new Network();
            // add data
            $network->name = $request->get('name');
            $network->meta_title = $request->get('title');
            $network->meta_keywords = ($request->has('keywords') && is_array($request->get('keywords'))) ? implode(',' , $request->get('keywords')) : '';
            $network->meta_description = $request->get('description');
            $network->status = $request->get('status');
            $network->created_at = new \DateTime();
            $network->updated_at = null;
            // creating new network
            $network->save();
            return redirect('admin/networks')->with('success' , 'Network added.');
        } catch (Throwable $th){
            return redirect()->back()->with('message' , $th->getMessage())->withInput($request->except('image'));
        }
    }

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

public function update(NetworkUpdateRequest $request , $id){
        if($id > 0){
            $network = Network::where('id' , $id)->first();
            if(!empty($network)){
                DB::beginTransaction();
                try {
                    // add data
                    $network->name = $request->get('name');
                    $network->meta_title = $request->get('title');
                    $network->meta_keywords = ($request->has('keywords') && is_array($request->get('keywords'))) ? implode(',' , $request->get('keywords')) : '';
                    $network->meta_description = $request->get('description');
                    $network->status = $request->get('status');
                    $network->updated_at = new \DateTime();
                    // update network
                    $network->update();
                    DB::commit();
                    return redirect('admin/networks')->with('success' , 'Network updated.');
                } catch (Throwable $th){
                    DB::rollBack();
                    return redirect()->back()->with('message' , $th->getMessage())->withInput($request->except('image'));
                }
            }
        }
        return route('login');
    }

// delete selected network ajax function
    public function delete(Request $request){
        DB::beginTransaction();
        try {
            $ids = is_array($request->get('ids')) ? $request->get('ids') : [];
            if(count($ids)){
                Network::whereIn('id' , $ids)->delete();
                DB::commit();
                return response()->json(['success' => true , 'message' => 'Network'.(count($ids) > 1 ? "s" : "").' deleted successfully.'] , 200);
            }
            return response()->json(['message' => 'No Network selected'] , 422);
        } catch (Throwable $th){
            DB::rollBack();
            return response()->json(['message' => $th->getMessage()] , 422);
        }
    }
}