/** *获取每个平台对应的账号列表 */ public static function getPlatformAccount() { self::initDB(); $sql = "SELECT id,account,platformId from om_account WHERE is_delete=0"; $query = self::$dbConn->query($sql); if ($query) { $data = array(); $ret = self::$dbConn->fetch_array_all($query); foreach ($ret as $v) { $data[self::getPlatformById($v['platformId'])][$v['id']] = $v['account']; } return $data; //成功, 返回列表数据 } else { self::$errCode = "003"; self::$errMsg = "修改失败"; return false; //失败则设置错误码和错误信息, 返回false } }
/** *根据平台id取得其名称 */ public static function getPlatformById($id) { self::initDB(); $sql = "SELECT platform from om_platform WHERE id='{$id}'"; $query = self::$dbConn->query($sql); if ($query) { $ret = self::$dbConn->fetch_array_all($query); return $ret[0]['platform']; //成功, 返回列表数据 } else { self::$errCode = "003"; self::$errMsg = "修改失败"; return false; //失败则设置错误码和错误信息, 返回false } }
/** *根据属性id取得对应的属性名的字符串 */ public static function getProValNameById($id) { self::initDB(); $sql = "SELECT propertyName from pc_archive_property WHERE id='{$id}'"; $query = self::$dbConn->query($sql); if ($query) { $ret = self::$dbConn->fetch_array_all($query); return $ret[0]['propertyName']; //成功, 返回列表数据 } else { self::$errCode = "003"; self::$errMsg = "失败"; return false; //失败则设置错误码和错误信息, 返回false } }