public function remove($id) { try { $this->_db->beginTransaction(); $data = $this->select('SELECT id_pegawai FROM ' . $this->_table . ' WHERE role=1'); if (count($data) == 0) { return; } $pic = $data[0]['id_pegawai']; //ubah pic assesment ke pic admin yg ada $asses = new Assesment($this->registry); $asses->select('UPDATE assesment SET pic=' . $pic . ' WHERE 1'); $this->_db->commit(); } catch (PDOException $ex) { //Something went wrong rollback! $db->rollBack(); echo $ex->getMessage(); } $this->_db->delete($this->_table, 'id=' . $id); }