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/Faqs

Free Space:

1.9 TB

🔧 Quick Actions

✏️ Editing: FaqsController.php

<?php
namespace App\Http\Controllers\Admin\Faqs;
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\Exceptions\InvalidOrderException;
use Illuminate\Support\Facades\Validator;
// use Intervention\Image\Facades\Image as Image;
use Symfony\Component\HttpKernel\Exception\NotFoundHttpException;
 
class FaqsController extends Controller
{
    /**
     * Handle an authentication attempt.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */

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

public function index($faq_option_id){

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

$faqs = Faq::where('language_id',$languages->id)->where('faqs.faq_option_id' , $faq_option_id)->orderBy('faqs.sort_order','asc')->get();

$metatitle = "FAQ";	
        return view('Admin.Faqs.index',compact('metatitle','faqs','faq_option_id','faqOptionData'));
    }

public function create($faq_option_id){

$Languages = Language::where('status',1)->orderBy('is_default' ,'DESC')->get();
		$FaqOption = FaqOption::where('id', $faq_option_id )->first();
        $metatitle = "FAQ";
		return view('Admin.Faqs.create',compact('metatitle','Languages','faq_option_id','FaqOption'));
    }

public function store(Request $request , $faq_option_id){

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

$default_answer = request('answer')[$languages->id];
            $default_question = request('question')[$languages->id];

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

$create =   Faq::create([
                            'status' => !empty(request('status')) ? true : false ,
                            'answer' => $default_answer,
                            'question' => $default_question,
                            'sort_order' => $count ,
                            'faq_option_id' => $faq_option_id ,
                        ]);

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

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

foreach ($question as $key => $value) 
            {
                if(!empty($value))
                {
                    $data_arr['status'] = !empty(request('status')) ? true : false ;
                    $data_arr['answer'] = !empty(request('answer')[$key]) ? request('answer')[$key] :  $default_answer;
                    $data_arr['question'] = !empty(request('question')[$key]) ? request('question')[$key] :  $default_question;
                    $data_arr['common_id'] = $result_id;
                    $data_arr['sort_order'] = $count;
                    $data_arr['language_id'] = $key;
                    $data_arr['faq_option_id'] = $faq_option_id;
                    $create = Faq::create($data_arr);
                }
            }

return  redirect()
                    ->route('faq.index', $faq_option_id)
                    ->with('success',__('messages.Your faqs has been added.'));

} 
        catch (PDOException $e) 
        {
            return back()->with('error','Database error occured');;
        }
    }

public function edit(Faq $Faq , $id){
        try 
        {
            $Languages = Language::where('status',1)->orderBy('is_default' ,'DESC')->get();
			$FaqOption = Faq::with('FaqOption')->where('common_id', $id )->first();
			
            $faqs = Faq::with('getLanguage')->where('common_id', $id )->get();
			$metatitle = "FAQ";           
		   return view('Admin.Faqs.edit',compact('metatitle','faqs','id','Languages','FaqOption'));
			
        } 
        catch (Exception $e) 
        {

$route = route('faq.index');
            return view('Admin.Error.error400',compact('route'));
        }
        catch (\Illuminate\Database\Eloquent\ModelNotFoundException $e) 
        {
            $route = route('faq.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_answer = $answer = request('answer')[$languages->id];
            $default_question = $question = request('question')[$languages->id];
            
            $getFaqData = Faq::where('common_id' , $id)->where('language_id' , $languages->id)->first();
            $faq_option_id = $getFaqData->faq_option_id;

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

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

Faq::whereId($getFaq->id)->update($data_arr);
                            
                        }
                        else
                        {
                            $data_arr['answer'] = !empty(request('answer')[$key]) ? request('answer')[$key] :  $default_answer;
                            $data_arr['question'] = !empty(request('question')[$key]) ? request('question')[$key] :  $default_question;
                            $data_arr['status'] = !empty(request('status')) ? true :  false;
                            $data_arr['common_id'] = $id;
                            $data_arr['sort_order'] = $getFaqData->sort_order;
                            $data_arr['language_id'] = $key;
                            $data_arr['faq_option_id'] = $getFaqData->faq_option_id;
                            $create = Faq::create($data_arr);
                        }
                    }
                }
            }
            return redirect()->route('faq.index',$faq_option_id)->with('success',__('messages.Faqs has been updated'));
        } 
        catch (PDOException $e) 
        {
            return back()->with('error','Database error occured');;
        }
    }

public function distroy($faq_id){

try 
        {
            $faqData = Faq::where('common_id', $faq_id )->where('language_id' , 1)->firstOrFail();
            $faq_option_id = $faqData->faq_option_id;
            if ($faqData->delete()) 
            {
                Faq::where('common_id', $faq_id )->delete();
            }
            return redirect()->route('faq.index',$faq_option_id)->with('success',__('messages.Faq has been removed.'));
            
        } 
        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()) 
        {
            $id = request('id');
            $output = array('success' => '', 'error' => '');
            $status = request('status') ? false : true;

$update = Faq::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);
        }
    }

public function reposition(Request $request){

if ($request->ajax()){

$position = request('position');
            $output = array('success' => '', 'error' => '');
            $i = 1;
            foreach ($position as $k => $id) {
                $update = Faq::where('common_id', $id)->update(['sort_order' => $i]);
                $i++;
            }

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: FaqsController.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation