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);
}
