Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.34.1.lve.el8.x86_64

PHP Version:

8.1.34

User:

u823300664

Directory:

/home/u823300664/public_html/app.allspikes.in/app/Http/Controllers/Admin/FaqOptions

Free Space:

1.9 TB

🔧 Quick Actions

✏️ Editing: 2023_03_15_FaqOptionsController.php

<?php
namespace App\Http\Controllers\Admin\FaqOptions;
use Image;
use Exception;
use PDOException;
use App\Models\Faq;
use App\Models\Language;
use App\Models\FaqOption;
use Illuminate\Support\Str;
use Illuminate\Http\Request;
use App\Models\EmailTemplate;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\App;
use App\Http\Controllers\Controller;
use Illuminate\Support\Facades\Auth;
use App\Traits\checkPermissionsTrait;
use App\Exceptions\InvalidOrderException;
use Illuminate\Support\Facades\Validator;
use Symfony\Component\HttpKernel\Exception\NotFoundHttpException;

class FaqOptionsController extends Controller
{
    /**
     * Handle an authentication attempt.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */

use checkPermissionsTrait;

public function __construct()
    {
        $this->middleware('admin');
    }

public function index()
    {
        if( !$this->checkPermission(Auth::user()->role_id, 'faq', 'is_read') )
        {
            return  redirect()->route('dashboard')->with('warning',app('translator')->get('messages.You are not authorised to access that location'));
        }

$languages = Language::where('status',1)->where('is_default',1)->first();

$FaqOptions = FaqOption::where('language_id',$languages->id)->orderBy('id' ,'DESC')->get();
		$metatitle = "Catégorie FAQ";       
	   return view('Admin.FaqOptions.index',compact('metatitle','FaqOptions'));
    }

public function getFaqOptions(Request $request)
    {
        ## Read value
        $draw = $request->get('draw');
        $start = $request->get("start");
        $rowperpage = $request->get("length"); // Rows display per page

$order_arr = $request->get('order');
        $search_arr = $request->get('search');
        $columnName_arr = $request->get('columns');
        $columnIndex_arr = $request->get('order');

$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

// Total records
		$languages = Language::where('status',1)->where('is_default',1)->first();
        $totalRecords = FaqOption::select('count(*) as allcount')->where('language_id',$languages->id)->count();
        $totalRecordswithFilter = FaqOption::select('count(*) as allcount')
		->where('language_id',$languages->id)
		->where('title', 'like', '%' .$searchValue . '%')->count();

// Fetch records
        $records =  FaqOption::orderBy($columnName,$columnSortOrder)
                    ->where('title', 'like', '%' .$searchValue . '%')
					->where('language_id',$languages->id)
                    ->select('*')
                    ->skip($start)
                    ->take($rowperpage)
                    ->get();

$data_arr = array();

$incKey = 0;
        foreach($records as $record){

$id = $record->common_id;
            $title = $record->title;
            $status = $record->status;

$data_arr[$incKey]['id'] = $record->common_id;;
            $data_arr[$incKey]['title'] = $record->title;

if($status == 1)
			{
				$data_arr[$incKey]['status'] =	'<a id="atag'.$record->common_id.'" class="btn btn-success updatestates btn-sm" data-id="'.$record->common_id.'" data-status="1" href="javascript:void(0)">Actif</a>';
			}
			else
			{
				$data_arr[$incKey]['status'] =	'<a id="atag'.$record->common_id.'" class="btn btn-danger updatestates btn-sm" data-id="'.$record->common_id.'" data-status="0" href="javascript:void(0)">Inactif</a>';
			}

$are_you_sure_want_to_delete = app('translator')->get('messages.are_you_sure_want_to_delete');

$actions = '';
			$are_you_sure_want_to_delete = app('translator')->get('messages.are_you_sure_want_to_delete');
 $actions .= '<a href="'.route('faq.index', $record->common_id).'" class="btn btn-warning btn-sm"> '.app('translator')->get('messages.See questions').'</a> ';
 if($this->checkPermission(Auth::user()->role_id, 'faq', 'is_edit') )
 {
 $actions .= '<a href="'.route('faq_option.edit', $record->common_id).'" class="btn btn-warning btn-sm"> '.app('translator')->get('messages.edit').'</a> ';
 }
 if($this->checkPermission(Auth::user()->role_id, 'faq', 'is_delete') )
 {
 $actions .= '<a href="'.route('faq_option.delete', $record->common_id).'" class="btn btn-danger btn-sm" onclick="return confirm(`'.$are_you_sure_want_to_delete.'`)"> '.app('translator')->get('messages.delete').'</a> ';
 }

$data_arr[$incKey]['action'] = $actions;

$incKey++;
        }

$response = array(
            "draw" => intval($draw),
            "aaData" => $data_arr,
            "iTotalRecords" => $totalRecords,
            "iTotalDisplayRecords" => $totalRecordswithFilter,
        );

echo json_encode($response);
        exit;
    }

public function create()
    {
        if( !$this->checkPermission(Auth::user()->role_id, 'faq', 'is_add') )
        {
            return  redirect()->route('dashboard')->with('warning',app('translator')->get('messages.You are not authorised to access that location'));
        }
        $Languages = Language::where('status',1)->orderBy('is_default' ,'DESC')->get();
        $metatitle = "Catégorie FAQ";
		return view('Admin.FaqOptions.create',compact('metatitle','Languages'));
    }

public function store(Request $request)
    {
        try
        {

$languages = Language::where('status',1)->where('is_default',1)->first();

$default_title = request('title')[$languages->id];

$count = FaqOption::count();
            $count = $count + 1;

$create =   FaqOption::create([
                            'title' => $default_title,
                            'status' => !empty(request('status')) ? true : false ,
                            'sort_order' => $count ,
                        ]);

if ($create)
            {
                $result_id = $create->id;

FaqOption::where('id',$result_id)->update(['common_id' => $result_id]);
                $title = request('title');
                unset($title[$languages->id]);
            }

foreach ($title as $key => $value)
            {
                if(!empty($value))
                {
                    $data_arr['title'] = !empty(request('title')[$key]) ? request('title')[$key] :  $default_title;
                    $data_arr['status'] = !empty(request('status')) ? true : false ;
                    $data_arr['common_id'] = $result_id;
                    $data_arr['sort_order'] = $count;
                    $data_arr['language_id'] = $key;
                    $create = FaqOption::create($data_arr);
                }
            }

return  redirect()
                    ->route('faq_option.index')
                    ->with('success',app('translator')->get('messages.The category was successfully added'));

}
        catch (PDOException $e)
        {
            return back()->with('error',"Oups ! Une erreur s'est produite. Merci de bien vouloir réessayer.");;
        }

}

public function edit(FaqOption $FaqOption , $id)
    {
        try
        {
            if( !$this->checkPermission(Auth::user()->role_id, 'faq', 'is_edit') )
            {
                return  redirect()->route('dashboard')->with('warning',app('translator')->get('messages.You are not authorised to access that location'));
            }

$faq = FaqOption::with('getLanguage')->where('id', $id )->first();
            $Languages = Language::where('status',1)->orderBy('is_default' ,'DESC')->get();
            $FaqOptions = FaqOption::with('getLanguage')->where('common_id', $id )->get();
            $metatitle = "Catégorie FAQ";
			return view('Admin.FaqOptions.edit',compact('metatitle','FaqOptions','id','Languages','faq'));
        }
        catch (Exception $e)
        {

$route = route('faq_option.index');
            return view('Admin.Error.error400',compact('route'));
        }
        catch (\Illuminate\Database\Eloquent\ModelNotFoundException $e)
        {
            $route = route('faq_option.index');
            return view('Admin.Error.error404',compact('route'));
        }
    }

public function update(Request $request, $id)
    {
        try
        {
            $languages = Language::where('status',1)->where('is_default',1)->first();

$default_title = $title = request('title')[$languages->id];
            $getOptionData = FaqOption::where('common_id' , $id)->where('language_id' , 1)->first();

if (!empty( request('title') ) )
            {
                foreach (request('title') as $key => $value)
                {
                    if(!empty($value))
                    {
                        $getFaqOptionData = FaqOption::where('common_id' , $id)->where('language_id' , $key)->first();

if (!empty($getFaqOptionData))
                        {
                            $data_arr['title'] = !empty(request('title')[$key]) ? request('title')[$key] :  $getFaqOptionData->title;
                            $data_arr['status'] = !empty(request('status')[$key]) ? true :  false;

FaqOption::whereId($getFaqOptionData->id)->update($data_arr);

}
                        else
                        {
                            $data_arr['title'] = !empty(request('title')[$key]) ? request('title')[$key] :  $default_title;
                            $data_arr['status'] = !empty(request('status')[$key]) ? true :  false;
                            $data_arr['common_id'] = $id;
                            $data_arr['sort_order'] = $getOptionData->sort_order;
                            $data_arr['language_id'] = $key;
                            $create = FaqOption::create($data_arr);
                        }
                    }
                }
            }

return redirect()->route('faq_option.index')->with('success',app('translator')->get('messages.Your category has been successfully updated'));
        }
        catch (PDOException $e)
        {
            return back()->with('error',"Oups ! Une erreur s'est produite. Merci de bien vouloir réessayer.");;
        }
    }

public function distroy($faq_option_id)
    {
        try
        {
            if( !$this->checkPermission(Auth::user()->role_id, 'faq', 'is_delete') )
            {
                return  redirect()->route('dashboard')->with('warning',app('translator')->get('messages.You are not authorised to access that location'));
            }

$faqOptionData = FaqOption::where('common_id', $faq_option_id )->where('language_id' , 1)->firstOrFail();
            if ($faqOptionData->delete())
            {
                Faq::where('faq_option_id',$faq_option_id)->delete();
                FaqOption::where('common_id', $faq_option_id )->delete();
            }
            return redirect()->route('faq_option.index')->with('success',app('translator')->get('messages.The category has been successfully deleted'));
        }
        catch (Exception $e)
        {
            $route = route('faq_option.index');
            return view('Admin.Error.error400',compact('route'));
        }
        catch (\Illuminate\Database\Eloquent\ModelNotFoundException $e)
        {
            $route = route('faq_option.index');
            return view('Admin.Error.error404',compact('route'));
        }
    }

public function updateStatus(Request $request)
    {
        if ($request->ajax())
        {
            if( !$this->checkPermission(Auth::user()->role_id, 'faq', 'is_edit') )
            {
                return  redirect()->route('dashboard')->with('warning',app('translator')->get('messages.You are not authorised to access that location'));
            }

$id = request('id');
            $output = array('success' => '', 'error' => '');
            $status = request('status') ? false : true;

$update = FaqOption::where('common_id', $id)->update(['status' => $status]);

if ($update)
            {
                $output['success'] = trans('messages.status_updated_successfully');
            }
            else
            {
                $output['error'] = trans('messages.something_worng');
            }

return response()->json($output);
        }

}
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: 2023_03_15_FaqOptionsController.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation