/** * UserCompetencesModel::getCompetencesById() * 获取某个开放权限ID信息 * @param integer $id 权限ID * @return array */ public static function getCompetencesById($id) { self::initDB(); $sql = "SELECT * FROM `" . self::$prefix . self::$table . "` WHERE id = {$id}"; $query = self::$dbConn->query($sql); if ($query) { return self::$dbConn->fetch_array($query); } else { self::$errCode = 10000; self::$errMsg = "执行SQL语句出错"; return false; } }
/** * UserCompetenceAct::actModify() * 返回某个用户开放授权 * @param int $gid 查询ID * @return array */ public function actModify() { $data = array(); $id = isset($_GET['id']) ? intval(trim($_GET['id'])) : 0; if (empty($id)) { show_message($this->smarty, "用户开放授权ID不能为空?", ""); return false; } $data['gid'] = $id; $data['gids'] = UserCompetenceModel::getGlobalUser(); $data['lists'] = UserCompetencesModel::getCompetencesByCat(); $data['res'] = UserCompetenceModel::modModify($id); self::$errCode = UserCompetenceModel::$errCode; self::$errMsg = UserCompetenceModel::$errMsg; if (self::$errCode != 0) { show_message($this->smarty, self::$errMsg, ""); return false; } return $data; }
/** * UserCompetencesAct::act_delUserCompetences() * 删除开放权限信息 * @param int $id 开放权限ID * @return bool */ public function act_delUserCompetences() { $id = isset($_POST["id"]) ? intval(trim($_POST["id"])) : 0; $act = isset($_REQUEST["act"]) ? post_check($_REQUEST["act"]) : ""; $mod = isset($_REQUEST["mod"]) ? post_check($_REQUEST["mod"]) : ""; if (!AuthUser::checkLogin($mod, $act)) { self::$errCode = 30001; self::$errMsg = "对不起,您无数据删除权限!"; return false; } if (empty($id) || !is_numeric($id)) { self::$errCode = 30000; self::$errMsg = "开放权限ID有误!"; return false; } $res = UserCompetencesModel::delUserCompetences($id); self::$errCode = UserCompetencesModel::$errCode; self::$errMsg = UserCompetencesModel::$errMsg; return $res; }