/**
*修改指定表记录
*/
public static function updateTnameProducts($tName, $set, $where)
{
self::initDB();
$sql = "UPDATE {$tName} {$set} {$where}";
$query = self::$dbConn->query($sql);
if ($query) {
$affectRows = self::$dbConn->affected_rows($query);
return $affectRows;
//成功， 返回列表数据
} else {
self::$errCode = "003";
self::$errMsg = "修改失败";
return false;
//失败则设置错误码和错误信息， 返回false
}
}
public function act_updateTNameProducts()
{
$tName = isset($_GET['tName']) ? post_check($_GET['tName']) : '';
$set = isset($_GET['set']) ? post_check($_GET['set']) : '';
$where = base64_decode($where);
if (empty($tName) || empty($set)) {
//参数不完整
self::$errCode = 301;
self::$errMsg = 'tName or set is empty';
return false;
} else {
$data = OpenapiModel::updateTNameProducts($tName, $set, $where);
if ($data) {
self::$errCode = 200;
self::$errMsg = 'Success';
return $data;
} else {
self::$errCode = OpenapiModel::$errCode;
self::$errMsg = OpenapiModel::$errMsg;
}
}
}
public function act_getGoodsList()
{
$select = isset($_GET['select']) ? $_GET['select'] : '';
$where = isset($_GET['where']) ? $_GET['where'] : '';
$where = base64_decode($where);
if (empty($select)) {
//参数不完整
self::$errCode = 301;
self::$errMsg = 'select is empty';
return false;
} else {
$data = OpenapiModel::getGoodsListWhere($select, $where);
if ($data) {
self::$errCode = 200;
self::$errMsg = 'Success';
return $data;
} else {
self::$errCode = OpenapiModel::$errCode;
self::$errMsg = OpenapiModel::$errMsg;
}
}
}
public static function getPropertyRelationList($id)
{
self::initDB();
$sql = "SELECT a.propertyId,b.propertyName FROM pc_goods_property_relation AS a \n\t\t\t\t LEFT JOIN pc_goods_property as b on a.propertyId=b.id WHERE a.goodsId='{$id}'";
$query = self::$dbConn->query($sql);
if ($query) {
$ret = self::$dbConn->fetch_array_all($query);
return $ret;
} else {
self::$errCode = "003";
self::$errMsg = "444444444";
return false;
}
}
