{{-- filter bookmarked --}}
{{-- 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';