/**
*获取每个平台对应的账号列表
*/
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
}
}
