Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.37.1.lve.el8.x86_64

PHP Version:

8.2.27

User:

u732469475

Directory:

/home/u732469475/domains/taresitare.com/public_html/app/Http/Controllers

Free Space:

3.37 TB

🔧 Quick Actions

✏️ Editing: Faqs.php

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Auth;
use DB;
use Illuminate\Support\Facades\Input;
use Illuminate\Support\Facades\Validator;
use Illuminate\Support\Facades\Hash;
use Storage;
use Session;
use Illuminate\Support\Facades\Crypt;
use DataTables;

class Faqs extends Controller
{
    # construct function
    public function __construct()
    {
        $this->middleware('auth');
        $this->middleware('admin');
    }

// Website page faqs etc
    public function page_faq(Request $request)
    {
        $category = $request->category;
        //$sub_category = $request->sub_category;
        //$city = $request->city;
        //$business = $request->business;
        //$page = $request->page;
        //$getAreas = $request->areas;
        $question1 = $request->question1;
        $answer1 = $request->answer1;        
        $question2 = $request->question2;
        $answer2 = $request->answer2;        
        $question3 = $request->question3;
        $answer3 = $request->answer3;        
        $question4 = $request->question4;
        $answer4 = $request->answer4;        
        $question5 = $request->question5;
        $answer5 = $request->answer5;
        $date = date('Y-m-d H:i:s');
        $status = '';

// First of all check if page url and page titles are already created or not for selected category, subcategory and city
        $rows = DB::table('faqs')
                ->where(['category' => $category, 'status' => 1]);
                
                //$rows->where('encoded_params', '!=', null);
                
        // If the sub category is selected
        if(!empty($sub_category)){
            $rows->where('subcategory', $sub_category);
        }else{
            $rows->where('subcategory', null);
        }

$exist = $rows->first();

// define blank array for ignore error when admin go to page directly
        $sub_category_info = array();

// If the entry is already not exist for selected data then process this to create page url and titles n all
        if(empty($exist)){
            
            if(!empty($question1) && !empty($answer1))
            {
                // Create page url
                //$page_url = $page;

// when category is selected and page name and business name is not seleted
                if(!empty($category))
                {
                    // define page url blank
                    $page_url = '';

// If sub category selected then page url will create with sub category
                    if(!empty($sub_category))
                    {
                        //$params = $sub_category.'-2-'.$city;

// Get sub Category Name
                        $p_subcategory = DB::table('subcategory')->where(array('id' => $sub_category, 'status' => 1))->first();
                        $page_url .= preg_replace('/[^A-Za-z0-9\-]/', '-', $p_subcategory->subcategory);
                    }
                    else    // Page url will create with Category
                    {
                        //$params = $category.'-1-'.$city;

// Get Category Name
                        $p_category = DB::table('category')->where(array('id' => $category, 'status' => 1))->first();
                        $page_url .= preg_replace('/[^A-Za-z0-9\-]/', '-', $p_category->category);
                    }

//$encrypted = base64_encode($params);

// first insert selected city titles
                    $insert = DB::table('faqs')->insert(array(
                        'category'       => $category,
                        //'subcategory'    => $sub_category,
                        //'city'           => $city,
                        //'business_page'  => $business,
                        //'page_url'       => strtolower($page_url),
                        //'encoded_params' => $encrypted,
                        'question1'      => $question1,
                        'answer1'        => $answer1,                        
                        'question2'      => $question2,
                        'answer2'        => $answer2,                        
                        'question3'      => $question3,
                        'answer3'        => $answer3,                        
                        'question4'      => $question4,
                        'answer4'        => $answer4,                        
                        'question5'      => $question5,
                        'answer5'        => $answer5,
                        'created_at'     => $date,
                        'updated_at'     => $date,
                        'status'         => 1
                    ));

}

if(!empty($page) && $page != '')    // If page name is selected and category name and business name not selected
                {
                    // Insert page titles when category and business name not selected
                    $insert = DB::table('faqs')->insert(array(
                        //'page_url'   => $page_url,
                        'question1'  => $question1,
                        'answer1'    => $answer1,                        
                        'question2'  => $question2,
                        'answer2'    => $answer2,                        
                        'question3'  => $question3,
                        'answer3'    => $answer3,                        
                        'question4'  => $question4,
                        'answer4'    => $answer4,                        
                        'question5'  => $question5,
                        'answer5'    => $answer5,
                        'created_at' => $date,
                        'updated_at' => $date,
                        'status'     => 1
                    ));
                }

$status = "Page url and Faqs created successfully.";
            }
        }else{

// If enteries are already exist then hit error
            $status = "Page url and titles are already created for the category / subcategory with this city ! You can update this information.";
        }

//  Get All Categories
        $business = DB::table('user_location')->where('status', 1)->get();

//  Get All Categories
        $category = DB::table('category')->where('status', 1)->get();

//  Get All Page titles
        $titles = DB::table('faqs')->where('status', 1)->get();

return view('faqs.page_titles', array('category' => $category, 'business' => $business, 'titles' => $titles, 'status' => $status, 'exist' => $exist, 'sub_category_info' => $sub_category_info));
    }

// Get page titles and urls using ajax
    public function getAllFaqs(Request $request)
    {
        //  Get All Page titles
        $titles = DB::table('faqs')
                    ->join('category', 'category.id', '=', 'faqs.category')
                    ->where('faqs.status', 1)
                    ->select('faqs.*', 'category.category')
                    ->get();
        return Datatables::of($titles)->addColumn('action', function ($row) {
            /*return '<a class="btn btn-success editPageUrlTitle" href="javascript:;" id="editPageUrlTitle_'.$row->id.'"> Edit </a><a class="btn btn-danger deletePageUrlTitle" href="javascript:;" id="editPageUrlTitle_'.$row->id.'"> Delete </a>'*/;
        })->make(true);  
    }

// Update Website page head titles like Title, Meta title, Keyword, Description etc
    public function update_page_faq(Request $request){

$category     = $request->u_cat_id;
        $sub_category = $request->u_subcat_id;
        //$city         = $request->u_city_id;
        $question1    = $request->question1;
        $answer1      = $request->answer1;        
        $question2    = $request->question2;
        $answer2      = $request->answer2;        
        $question3    = $request->question3;
        $answer3      = $request->answer3;        
        $question4    = $request->question4;
        $answer4      = $request->answer4;        
        $question5    = $request->question5;
        $answer5      = $request->answer5;
        $date         = date('Y-m-d H:i:s');

// if anyone directly come to this function then through back
        if(empty($category) &&  empty($sub_category)){
            return redirect('page_titles');
        }

// If subcategory is exist
        if($sub_category){            
            $where = array('category' => $category, 'subcategory' => $sub_category);
        }else{            
            $where = array('category' => $category, 'subcategory' => null);
        }

// Update title, keyword and description
        $update = DB::table('faqs')->where($where)->update([
            'question1'      => $question1,
            'answer1'        => $answer1,                        
            'question2'      => $question2,
            'answer2'        => $answer2,                        
            'question3'      => $question3,
            'answer3'        => $answer3,                        
            'question4'      => $question4,
            'answer4'        => $answer4,                        
            'question5'      => $question5,
            'answer5'        => $answer5,
            'updated_at'     => $date
        ]);

$status = "Page url and titles are description updated successfully.";
        
        //  Get All users with location
        $business = DB::table('user_location')->where('status', 1)->get();

//  Get All Categories
        $category = DB::table('category')->where('status', 1)->get();

//  Get All Page titles
        $titles = DB::table('faqs')->where('status', 1)->get();

return view('faqs.page_titles', array('category' => $category, 'business' => $business, 'titles' => $titles, 'status' => $status));
    }
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Faqs.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation