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; }