$this->db->trans_start();

        $sSql = 'SELECT COUNT(*) AS nCnt FROM hrSupervisor WHERE uid = ?';
        $oQuery = $this->db->query($sSql, array($nUid));
        if(0 < $oQuery->num_rows()) {
            $aRow = $oQuery->row_array();

            if(1 == $aRow['nCnt']) {
                $sSql = 'UPDATE hrSupervisor SET
                            upd_date = NOW()
                            , name = ?
                        WHERE uid = ?';
                $oQuery = $this->db->query($sSql, array($sSupervisorFullName, $nUid));

                if(false === $this->db->affected_rows() ) {
                    return false;
                }

                $sSql = 'INSERT INTO hrSupervisor_history (reg_date, status, name, fkSupervisor) SELECT NOW(), status, name, uid FROM hrSupervisor WHERE uid = ?';
                $oQuery = $this->db->query($sSql, array($nUid));

                if(false === $this->db->affected_rows() ) {
                    return false;
                }
            }
            else {
                return false;
            }
        } else {
            $oQuery->free_result();

            return false;
        }

        $this->db->trans_complete();