Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-611.41.1.el9_7.x86_64

PHP Version:

8.3.30

User:

u838833262

Directory:

/home/u838833262/domains/school.marvsoftwares.in/public_html/app/Traits

Free Space:

10.06 TB

🔧 Quick Actions

✏️ Editing: DatabaseTableTrait.php

<?php

namespace App\Traits;

use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Schema;

trait DatabaseTableTrait
{
    public function tableWithRecordId(): array
    {
        $tables = $this->getAllTables();
        $withRecords = [];
        $db = "Tables_in_".env('DB_DATABASE');
        foreach($tables as $table) {
            if(config('database.default') == 'mysql'){
                $table_name = $table->{$db};
            } else{
                $table_name = $table->tablename;
            }
            if ((Schema::hasColumn($table_name, 'record_id'))) {
                $withRecords[] = $table_name;
            }
            if ((Schema::hasColumn($table_name, 'student_record_id'))) {
                $withRecords[] = $table_name;
            }
        }
        return $withRecords;
    }
    public function tableWithRecordIdActiveStatus(): array
    {
        $tables = $this->getAllTables();
        $db = "Tables_in_".env('DB_DATABASE');
        $recordWithActiveStatus = [];
        foreach($tables as $table) {
            if(config('database.default') == 'mysql'){
                $table_name = $table->{$db};
            } else{
                $table_name = $table->tablename;
            }
            if ((Schema::hasColumns($table_name, ['record_id', 'active_status']))) {
                $recordWithActiveStatus[] = $table_name;
            }
            if ((Schema::hasColumns($table_name, ['student_record_id', 'active_status']))) {
                $recordWithActiveStatus[] = $table_name;
            }
        }
        return $recordWithActiveStatus;
    }
    private function getAllTables()
    {
        return Schema::getAllTables();
    }
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: DatabaseTableTrait.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation