{{-- end filter bookmarked --}}
@php
use App\Traits\DynamicQueryHelper;
use DynamicQueryHelper;
$query = $this->applyDynamicQuery($query, (new EtPreProject)->getTable(), $request->input('dynamicQuery'));
@endphp
dynamicQuery: [],
handleDynamicSearch(query) {
this.dynamicQuery = query || [];
this.page = 1;
this.onLoadPagination();
},
data: {
...that.filterObj, // Các filter cũ nếu có
dynamicQuery: JSON.stringify(that.dynamicQuery) // Dữ liệu filter động mới
},
UPDATE em_general_purpose
SET key3 = 'email'
WHERE key2 = 'column'
AND key3 = 'mail';
UPDATE em_general_purpose
SET key3 = 'file_id'
WHERE key1 = 'consultation_record'
AND key2 = 'column'
AND key3 = 'id';
UPDATE em_general_purpose
SET key3 = 'file_id'
WHERE key1 = 'regular_interview_report_for_supervisor'
AND key2 = 'column'
AND key3 = 'id';
regular_interview_report
consultation_record
regular_interview_report_for_supervisor
SELECT * FROM `em_general_purpose` WHERE `key1` LIKE '%form%' AND `key2` LIKE '%column%' AND `key3` LIKE '%type%';
UPDATE em_general_purpose
SET key3 = 'template_id'
WHERE key1 = 'mail_template'
AND key2 = 'column'
AND key3 = 'mail_template_id';
UPDATE em_general_purpose
SET key3 = 'template_id'
WHERE key1 = 'mail_template'
AND key2 = 'column'
AND key3 = 'id';
UPDATE em_general_purpose
SET key3 = 'candidate_id'
WHERE key1 = 'candidate'
AND key2 = 'column'
AND key3 = 'id';
UPDATE em_general_purpose
SET key3 = 'document_template_id'
WHERE key1 = 'document_template'
AND key2 = 'column'
AND key3 = 'id';
UPDATE em_general_purpose
SET key3 = 'file_template_id'
WHERE key1 = 'file_template'
AND key2 = 'column'
AND key3 = 'id';