searchBy = [ 'PID' => 'PID', 'PATCHNAME' => 'Patch Name', 'PDESC' => 'Description', 'MAJOR_VERSION' => 'Major Vaersion', 'Remark' => 'Remark' ]; // dd($results); // $this->selectedPatches = []; } public function search() { $this->resetPage(); } public function updatedPerPage($value) { $this->adjustPageForNewPerPage(); } public function adjustPageForNewPerPage() { $lastPage = ceil($this->totalItems / $this->perPage); if ($this->page > $lastPage) { $this->setPage($lastPage); } } public function updateServerkey($serverkey) { $serverLicense = ConfServerLicense::where("SNKEY", $serverkey)->first(); if (isset($serverLicense)) { $this->serverId = $serverLicense->ID; } $this->render(); } public function updateSelectPatchAfterDeleted() { $this->selectedPatches = []; $this->render(); } public function removePatchSelected($key) { $this->selectedPatches = array_filter($this->selectedPatches, function ($patch) use ($key) { return $patch!== $key; }); $this->resetPage(); } public function render() { $query = ConfServerPendding::select('PID', 'PATCHNAME', 'PDESC', 'PDATE', 'PLEVEL', 'Remark', 'MAJOR_VERSION') ->join('conf_smartupdate', 'conf_smartupdate.PID', '=', 'conf_server_pendding.PatchID') ->where('conf_server_pendding.ServerID', $this->serverId) ->where('conf_server_pendding.TaskStatus' , '!=', '999'); if ($this->searchSelected && $this->keyword) { $query->where($this->searchSelected, 'LIKE', '%' . $this->keyword . '%'); } $query->orderBy('PID', 'DESC'); $results = $query->paginate($this->perPage); $this->totalItems = $results->total(); return view('livewire.pages.send-patch.delete-multi-patch-list', [ 'results' => $results ]); } }