public function act_getSkuList()
{
$shipOrderGroup = isset($_REQUEST['orderid']) ? $_REQUEST['orderid'] : '';
if (empty($shipOrderGroup)) {
self::$errCode = 0;
self::$errMsg = '请输入提货单号!';
return;
}
$orderinfo = GroupDistributionBModel::getGroupDistListB("*", "where shipOrderGroup='{$shipOrderGroup}'");
if (empty($orderinfo)) {
self::$errCode = 0;
self::$errMsg = '该提货单不存在或未配货!';
return;
}
$san_info = ReviewBModel::getReviewListB("*", "where shipOrderGroup='{$shipOrderGroup}'");
if (empty($san_info)) {
$string = "";
foreach ($orderinfo as $info) {
$string .= "('" . $info['shipOrderGroup'] . "','" . $info['shipOrderId'] . "','" . $info['sku'] . "','" . $info['skuAmount'] . "'),";
}
$string = trim($string, ",");
//插入复核表
$insert_info = ReviewBModel::insertReviewB($string);
if ($insert_info) {
$skulist = ReviewBModel::getReviewListB("*", "where shipOrderGroup='{$shipOrderGroup}' and status=0");
} else {
self::$errCode = "0";
self::$errMsg = "订单料号初始化出错，请重试";
return false;
}
} else {
$skulist = ReviewBModel::getReviewListB("*", "where shipOrderGroup='{$shipOrderGroup}' and status=0");
}
if (empty($skulist)) {
self::$errCode = "0";
self::$errMsg = "该提货单已复核完成";
return false;
}
self::$errCode = 1;
self::$errMsg = 'OK';
return $skulist;
}
public static function getShipOrderPay($select, $where)
{
self::initDB();
$sql = "select {$select} from `wh_shipping_order` as a left join \n\t\t\t\t`wh_shipping_order_group_distribution` as b on a.id=b.shipOrderId {$where} ";
$query = self::$dbConn->query($sql);
if ($query) {
$ret = self::$dbConn->fetch_array_all($query);
return $ret;
} else {
self::$errCode = "003";
self::$errMsg = "error";
return false;
}
}
function get_valid_order($order_group, $sku, $pName)
{
$goup_sql = GroupDistributionBModel::getGroupDistListB("*", "where shipOrderGroup='{$order_group}' and sku='{$sku}' and pName='{$pName}' and status=0");
foreach ($goup_sql as $group) {
$infos = GroupDistributionBModel::getShipOrder("orderStatus", "where id in ({$group['shipOrderId']})");
foreach ($infos as $info) {
if ($info['orderStatus'] != 407) {
return false;
break;
}
}
}
return true;
}
