function act_removeRollback()
{
$userId = $_SESSION['userId'];
$time = time();
$shipOrderId = $_POST['order'];
$sku = $_POST['sku'];
$pName = $_POST['pname'];
$scan_record = OmAvailableModel::getTNameList("wh_order_picking_records", "*", "where shipOrderId='{$shipOrderId}' and sku='{$sku}' and pName='{$pName}' and is_delete=0 ");
if (empty($scan_record)) {
self::$errCode = "401";
self::$errMsg = "配货单号 {$shipOrderId} 其中料号 {$sku} 在仓位 {$pName} 的配货记录不存在！";
return false;
} else {
OmAvailableModel::begin();
$amount = $scan_record[0]['amount'];
//配货数量
$sql = "update ebay_order_scan_record set is_show = 1,canceltime='{$mctime}' where ebay_id = '{$ebay_id}' and sku = '{$ebay_sku}' and is_show = 0 ";
$update_record = OmAvailableModel::updateTNameRow("wh_order_picking_records", "set cancelUserId='{$userId}',cancelTime='{$time}',is_delete=1", "where shipOrderId='{$shipOrderId}' and sku='{$sku}' and pName='{$pName}' and is_delete=0");
if (!$update_record) {
self::$errCode = "402";
self::$errMsg = "配货单删除配货记录失败";
return false;
}
$sku_info = OmAvailableModel::getTNameList("pc_goods", "id", "where sku='{$sku}' and is_delete=0");
$position_info = OmAvailableModel::getTNameList("wh_position_distribution", "id", "where pName='{$pName}' and storeId=1");
if (!$position_info || !$sku_info) {
self::$errCode = "403";
self::$errMsg = "配货单删除配货记录失败，找不到对应仓位id或者skuid";
OmAvailableModel::rollback();
return false;
}
$update_product_position = OmAvailableModel::updateTNameRow("wh_product_position_relation", "set nums=nums+'{$amount}'", "where pId={$sku_info[0]['id']} and positionId={$position_info[0]['id']}");
if (!$update_product_position) {
self::$errCode = "404";
self::$errMsg = "配货单删除配货记录失败,更新仓位数量出错";
OmAvailableModel::rollback();
return false;
}
$update_sku_location = OmAvailableModel::updateTNameRow("wh_sku_location", "set actualStock=actualStock+'{$amount}'", "where sku='{$sku}' and storeId=1");
if (!$update_sku_location) {
self::$errCode = "405";
self::$errMsg = "配货单删除配货记录失败,更新库存数量出错";
OmAvailableModel::rollback();
return false;
}
self::$errMsg = "配货单删除配货记录成功";
OmAvailableModel::commit();
return false;
}
}
