Viewing file:  CustomField.php (2.96 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Model;
class CustomField extends Model
{
protected $fillable = [
'name',
'type',
'module',
'created_by',
];
public static $fieldTypes = [
'text' => 'Text',
'email' => 'Email',
'number' => 'Number',
'date' => 'Date',
'textarea' => 'Textarea',
];
public static $modules = [
'user' => 'User',
'customer' => 'Customer',
'vendor' => 'Vendor',
'product' => 'Product',
'proposal' => 'Proposal',
'Invoice' => 'Invoice',
'Bill' => 'Bill',
'account' => 'Account',
];
public static function saveData($obj, $data)
{
if($data)
{
$RecordId = $obj->id;
foreach($data as $fieldId => $value)
{
\DB::insert(
'insert into custom_field_values (`record_id`, `field_id`,`value`,`created_at`,`updated_at`) values (?, ?, ?, ?, ?) ON DUPLICATE KEY UPDATE `value` = VALUES(`value`),`updated_at` = VALUES(`updated_at`) ', [
$RecordId,
$fieldId,
$value,
date('Y-m-d H:i:s'),
date('Y-m-d H:i:s'),
]
);
}
}
}
public static function getData($obj, $module)
{
return \DB::table('custom_field_values')->select(
[
'custom_field_values.value',
'custom_fields.id',
]
)->join('custom_fields', 'custom_field_values.field_id', '=', 'custom_fields.id')->where('custom_fields.module', '=', $module)->where('record_id', '=', $obj->id)->get()->pluck('value', 'id');
}
}
|