public function act_updOrderErpFeedBack()
{
$comUserId = $_GET['userid'];
//买家ID
$itemId = $_GET['itemid'];
//Ebay产品编码
$tranId = $_GET['tranid'];
//交易号
$comType = $_GET['comtype'];
//平价类型
$rtnData = FeedbackAPIModel::updFeedBack($comUserId, $itemId, $tranId, $comType);
return $rtnData;
}
/**
*说明:更新订单评价
*author:王民伟
*date:2014-02-28
*/
public static function updFeedBack($comUserId, $itemId, $tranId, $comType)
{
self::initDB();
$reviews = 0;
//1:好评,2:中评,3:差评
switch ($comType) {
case 'Positive':
$reviews = 1;
break;
case 'Neutral':
$reviews = 2;
break;
case 'Negative':
$reviews = 3;
break;
default:
$reviews = 0;
break;
}
$unSql = "SELECT a.omOrderId, c.sku, c.amount FROM om_unshipped_order_userInfo AS a ";
$unSql .= "JOIN om_unshipped_order_detail_extension_ebay AS b ON a.omOrderId = b.omOrderdetailId ";
$unSql .= "JOIN om_unshipped_order_detail AS c ON c.omOrderId = a.omOrderId ";
$unSql .= "WHERE a.platformUsername = '******' AND b.transId = '{$tranId}' AND b.itemId = '{$itemId}'";
$unQuery = self::$dbConn->query($unSql);
if ($unQuery) {
$unRtnData = self::$dbConn->fetch_array_all($unQuery);
if (isset($unRtnData)) {
//找到数据,更新订单评价
$orderId = $unRtnData[0]['omOrderId'];
$sku = $unRtnData[0]['sku'];
$unUpdSql = "UPDATE om_unshipped_order_detail set reviews = '{$reviews}' WHERE omOrderId = '{$orderId}' AND sku = '{$sku}'";
$unRtnUpd = self::$dbConn->query($unUpdSql);
if ($unRtnUpd) {
return $unRtnData;
//返回料号、数量反写Feedback系统
} else {
return false;
}
} else {
$sql = "SELECT a.omOrderId, c.sku, c.amount FROM om_shipped_order_userInfo AS a ";
$sql .= "JOIN om_shipped_order_detail_extension_ebay AS b ON a.omOrderId = b.omOrderdetailId ";
$sql .= "JOIN om_shipped_order_detail AS c ON c.omOrderId = a.omOrderId ";
$sql .= "WHERE a.platformUsername = '******' AND b.transId = '{$transId}' AND b.itemId = '{$itemId}'";
$query = self::$dbConn->query($Sql);
if ($query) {
$rtnData = self::$dbConn->fetch_array_all($query);
$orderId = $rtnData[0]['omOrderId'];
$sku = $rtnData[0]['sku'];
$updSql = "UPDATE om_shipped_order_detail set reviews = '{$reviews}' WHERE omOrderId = '{$orderId}' AND sku = '{$sku}'";
$rtnUpd = self::$dbConn->query($updSql);
if ($rtnUpd) {
return $rtnData;
//返回料号、数量反写Feedback系统
} else {
return false;
}
} else {
self::$errCode = "001";
self::$errMsg = "获取数据失败";
return false;
}
}
} else {
self::$errCode = "001";
self::$errMsg = "获取数据失败";
return false;
}
}
