One Hat Cyber Team

Your IP: 216.73.216.19
Server IP: 178.33.27.10
Server: Linux cpanel.dev-unit.com 3.10.0-1160.108.1.el7.x86_64 #1 SMP Thu Jan 25 16:17:31 UTC 2024 x86_64
Server Software: Apache/2.4.57 (Unix) OpenSSL/1.0.2k-fips
PHP Version: 8.2.11
Buat File | Buat Folder

Dir : ~/home/id/dalily.dev-unit.com/app/Models/Builders/

View File Name : HasEnumFields.php

<?php
/*
 * LaraClassifier - Classified Ads Web Application
 * Copyright (c) BeDigit. All Rights Reserved
 *
 * Website: https://laraclassifier.com
 * Author: Mayeul Akpovi (BeDigit - https://bedigit.com)
 *
 * LICENSE
 * -------
 * This software is provided under a license agreement and may only be used or copied
 * in accordance with its terms, including the inclusion of the above copyright notice.
 * As this software is sold exclusively on CodeCanyon,
 * please review the full license details here: https://codecanyon.net/licenses/standard
 */

namespace App\Models\Builders;

use Illuminate\Support\Facades\DB;

trait HasEnumFields
{
	public static function getPossibleEnumValues(string $column): array
	{
		$instance = new static(); // Create an instance of the model to be able to get the table name
		$connectionName = $instance->getConnection()->getName();
		$table = DB::getTablePrefix() . $instance->getTable();
		
		try {
			$sql = 'SHOW COLUMNS FROM ' . $table . ' WHERE Field = "' . $column . '"';
			$type = DB::connection($connectionName)->select($sql)[0]->Type;
		} catch (\Throwable $e) {
			$type = '';
		}
		
		$enum = [];
		
		if (!empty($type)) {
			preg_match('/^enum\((.*)\)$/', $type, $matches);
			$exploded = explode(',', $matches[1]);
			foreach ($exploded as $value) {
				$enum[] = trim($value, "'");
			}
		}
		
		return $enum;
	}
	
	public static function getEnumValuesAsAssocArray(string $column): array
	{
		$enumValues = static::getPossibleEnumValues($column);
		
		return collect($enumValues)
			->mapWithKeys(fn ($item) => [$item => $item])
			->toArray();
	}
}