searchBy = [ 'name' => 'By Name', 'value' => 'By Value', 'description' => 'By Description' ]; $this->searchByPage = TabSpnpage::select('pagecode', 'pagename')->get()->toArray(); logger($this->searchByPage); } public function render() { $query = ConfParameter::select('conf_parameter.PID', 'conf_parameter.name', 'conf_parameter.value', 'conf_parameter.description', 'conf_parameter.active', 'tab_parameter_info.pageCode') ->leftJoin('tab_parameter_info', 'conf_parameter.name', '=', 'tab_parameter_info.parameterName'); if ($this->searchSelected && $this->keyword) { $query->where($this->searchSelected, 'LIKE', '%' . $this->keyword . '%'); } if ($this->searchSelectedPage) { $query->where('tab_parameter_info.pageCode', $this->searchSelectedPage); } $query->orderBy('PID', 'DESC'); $results = $query->paginate($this->perPage); return view('livewire.pages.parameter.parameter-index', compact('results')); } public function search() { $this->resetPage(); } public function showparameterListForm() { $this->action = 'list'; } public function showparameterAddForm() { $this->action = 'add'; } public function showparameterEditForm($pid) { $this->editPid = $pid; $this->action = 'edit'; // $this->emit('showpatchEditForm'); } }