|
Server IP : 103.191.208.50 / Your IP : 216.73.216.53 Web Server : LiteSpeed System : Linux orion.herosite.pro 4.18.0-553.53.1.lve.el8.x86_64 #1 SMP Wed May 28 17:01:02 UTC 2025 x86_64 User : celkcksm ( 1031) PHP Version : 7.4.33 Disable Function : show_source, system, shell_exec, passthru, popen, exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home/celkcksm/demo.ncriptech.com/../hrms.ncriptech.com/app/Models/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
namespace App\Models;
use DB;
use Illuminate\Database\Eloquent\Model;
class TableList extends Model
{
public static function getTableList($colunm_name_id, $id)
{
try {
$db_name = env('DB_DATABASE', null);
$table_list = DB::select("SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME ='$colunm_name_id'
AND TABLE_SCHEMA='$db_name'");
$tables = '';
foreach ($table_list as $row) {
$data_test = DB::table($row->TABLE_NAME)->select('*')->where($colunm_name_id, $id)->first();
if ($data_test != "") {
$name = str_replace('sm_', '', $row->TABLE_NAME);
$name = str_replace('_', ' ', $name);
$name = ucfirst($name);
$tables .= $name . ', ';
}
}
return $tables;
} catch (\Exception $e) {
$tables = 'Exception';
return $tables;
}
}
public static function getTableFullName($colunm_name_id, $id)
{
try {
$db_name = env('DB_DATABASE', null);
$table_list = DB::select("SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME ='$colunm_name_id'
AND TABLE_SCHEMA='$db_name'");
$tables = '';
foreach ($table_list as $row) {
$data_test = DB::table($row->TABLE_NAME)->select('*')->where($colunm_name_id, $id)->first();
if ($data_test != "") {
$name = $row->TABLE_NAME;
$tables .= $name . ', ';
}
}
return $tables;
} catch (\Exception $e) {
$tables = 'Exception';
return $tables;
}
}
}