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: WebsitePages.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 WebsitePages extends Controller
{
    # construct function
    public function __construct()
    {
        $this->middleware('auth');
        $this->middleware('admin');
    }

//website pages
    public function website_pages()
    {
        $web_pages = DB::table('website_pages')->where('status',1)->get();

return view('website_pages.index', array('web_pages' => $web_pages));
    }

public function update_page(Request $request)
    {
        $date = date('Y-m-d H:i:s');

$id = $request->id;
        $content = $request->content;

$web_page_update = DB::table('website_pages')->where('id', $id)->update(['page_description' => $content, 'updated_at' => $date]);

if($web_page_update)
        {
            $status = "successfully Update.";
        }
        else
        {
            $status = 'Something went wrong !';
        }

return redirect('website_pages')->with('status', $status);
    }

// Website page head titles like Title, Meta title, Keyword, Description etc
    public function page_titles(Request $request)
    {
        $category = $request->category;
        $sub_category = $request->sub_category;
        /*$country = $request->country;
        $state = $request->state;*/
        $business = $request->business;
        /*$page = $request->page;*/
        $title = $request->title;
        $keyword = $request->keyword;
        $description = $request->description;
        $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('websites_page_head_titles');
        
        if($category){
            $rows->where(['category' => $category, 'country_id' => 101, 'status' => 1]);
            $rows->where('encoded_params', '!=', null);
        }else{
            $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($title) && !empty($keyword) && !empty($description))
            {
                // when category is selected and page name and business name is not seleted
                if(!empty($category))
                {
                    // define page url blank
                    $page_url = '';
                    $all_countries = DB::table('countries')->get();

// If sub category selected then page url will create with sub category
                    if(!empty($sub_category))
                    {
                        // 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);

$params = $sub_category.'-2-'."India";
                        $encrypted = base64_encode($params);

// first insert selected state titles
                        $insert = DB::table('websites_page_head_titles')->insert(array(
                            'category' => $category,
                            'subcategory' => $sub_category,
                            'country_id' => $country,
                            'state_id' => null,
                            'business_page' => $business,
                            'page_url' => strtolower($page_url),
                            'encoded_params' => $encrypted,
                            'title' => ucfirst(strtolower($title)),
                            'keyword' => ucfirst(strtolower($keyword)),
                            'description' => ucfirst(strtolower($description)),
                            'created_at' => $date,
                            'updated_at' => $date,
                            'status' => 1
                        ));
                    }
                    else    // Page url will create with Category
                    {
                        // 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);

$country_page_url = $page_url.'-in--'."India";

$params = $category.'-1-'."101";
                        $encrypted = base64_encode($params);

// first insert selected state titles
                        $insert = DB::table('websites_page_head_titles')->insert(array(
                            'category' => $category,
                            'subcategory' => null,
                            'country_id' => "101",
                            'state_id' => null,
                            'business_page' => $business,
                            'page_url' => strtolower($country_page_url),
                            'encoded_params' => $encrypted,
                            'title' => ucfirst(strtolower($title)),
                            'keyword' => ucfirst(strtolower($keyword)),
                            'description' => ucfirst(strtolower($description)),
                            'created_at' => $date,
                            'updated_at' => $date,
                            'status' => 1
                        ));
                    }
                }

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

// get sub category name if selected
            //$sub_category_info = DB::table('subcategory')->where('id', $sub_category)->first();

// 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('websites_page_head_titles')->where('status', 1)->get();

$all_countries = DB::table('countries')->where('status', 1)->get();
        $countries = array('' => 'Select Country');
        foreach($all_countries as $country)
        {
            $countries[$country->id] = $country->name;
        }
        
        return view('website_pages.page_titles', array('category' => $category, 'business' => $business, 'titles' => $titles, 'status' => $status, 'exist' => $exist));
    }

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

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

$category = $request->u_cat_id;
        //$sub_category = $request->u_subcat_id;
        //$country = $request->u_country_id;
        //$state = $request->u_state_id;
        $title = $request->u_title;
        $keyword = $request->u_keyword;
        $description = $request->u_description;
        $date = date('Y-m-d H:i:s');
        
        // if anyone directly come to this function then through back
        if(empty($category)){
            return redirect('page_titles');
        }
        
        // 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);
        $where = array('category' => $category);

$country_page_url = $page_url.'-in--'."india";

$params = $category.'-1-'."101";
        $encrypted = base64_encode($params);

$update = DB::table('websites_page_head_titles')->where(['category' => $category, 'country_id' => 101, 'state_id' => null, 'city' => null])->update([
            'title' => ucfirst(strtolower($title)),
            'keyword' => ucfirst(strtolower($keyword)),
            'description' => ucfirst(strtolower($description)),
            '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('websites_page_head_titles')->where('status', 1)->get();

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

# Update page titles data
    public function editPageUrlTitle(Request $request)
    {
        $date = date('Y-m-d H:i:s');

$id = $request->row_id;
        $title = $request->edit_title;
        $keyword = $request->edit_keyword;
        $description = $request->edit_description;

$update = DB::table('websites_page_head_titles')->where('id', $id)->update([
            'title' => $title,
            'keyword' => $keyword,
            'description' => $description,
            'updated_at' => $date
        ]);

if($update)
        {
            $status = "Page Titles Updated Successfully.";
        }
        else
        {
            $status = 'Something Went Wrong !';
        }

return redirect('page_titles')->with('status', $status);
    }
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: WebsitePages.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation