function act_getGroupInfo() { $userId = $_SESSION['userId']; $shipOrderGroup = $_POST['order_group']; $group_sql = GroupRouteModel::getOrderGroup("*", "where shipOrderGroup='{$shipOrderGroup}'"); if (empty($group_sql)) { self::$errCode = "003"; self::$errMsg = "该配货清单号不存在,请重新输入!"; return false; } else { $scan_sql = GroupDistributionModel::getGroupDistList("shipOrderGroup", "where shipOrderGroup='{$shipOrderGroup}'"); if (empty($scan_sql)) { $string = ""; $time = strtotime(date('Y-m-d H:i:s')); foreach ($group_sql as $info) { $string .= "('" . $info['shipOrderGroup'] . "','" . $info['sku'] . "','" . $info['id'] . "','" . $info['skuAmount'] . "','" . $info['shipOrderId'] . "','0','0','" . $info['carNumber'] . "','" . $info['pName'] . "','" . $userId . "','" . $time . "'),"; } $string = trim($string, ","); //插入配货清单表 $insert_info = GroupDistributionModel::insertGroupDist($string); if ($insert_info) { $show_info = array(); $show_sql = GroupDistributionModel::getGroupSkuInfo("and a.shipOrderGroup='{$shipOrderGroup}' and a.status=0 group by a.pName order by a.groupId asc"); if (!empty($show_sql)) { foreach ($show_sql as $show) { $order_sku_info = $this->get_valid_order($show['shipOrderGroup'], $show['sku'], $show['pName']); if ($order_sku_info['sku_amount'] != 0) { $show_info['group_id'] = $show['groupId']; $show_info['sku'] = $show['sku']; $show_info['sku_amount'] = $order_sku_info['sku_amount']; $show_info['goods_location'] = $show['pName']; break; } } } if (empty($show_info)) { self::$errCode = "003"; self::$errMsg = "该清单不在等待配货状态,请确认!"; return false; } else { self::$errMsg = "请扫描该配货清单下的料号!"; return $show_info; } } else { self::$errCode = "003"; self::$errMsg = "订单料号初始化出错,请重试"; return false; } } else { $iscan = GroupDistributionModel::getGroupDistList("*", "where shipOrderGroup='{$shipOrderGroup}' and status=0"); if (empty($iscan)) { self::$errCode = "003"; self::$errMsg = "该清单已扫描配货完成,请扫描其他清单!"; return false; } else { //更新配货人 $data = array('userID' => $userId); GroupDistributionModel::update($data, "and shipOrderGroup='{$shipOrderGroup}' and status=0"); //检查是否有出库过 $isout = GroupDistributionModel::getGroupDistList("*", "where shipOrderGroup='{$shipOrderGroup}' and status=1"); $show_info = array(); $show_sql = GroupDistributionModel::getGroupSkuInfo("and a.shipOrderGroup='{$shipOrderGroup}' and a.status=0 group by a.pName order by a.groupId asc"); if (!empty($show_sql)) { foreach ($show_sql as $show) { $order_sku_info = $this->get_valid_order($show['shipOrderGroup'], $show['sku'], $show['pName']); if ($order_sku_info['sku_amount'] != 0) { $show_info['group_id'] = $show['groupId']; $show_info['sku'] = $show['sku']; $show_info['sku_amount'] = $order_sku_info['sku_amount']; $show_info['goods_location'] = $show['pName']; break; } } } if (empty($show_info)) { if (empty($isout)) { self::$errCode = "003"; self::$errMsg = "该清单不在等待配货状态,请确认!"; return false; } else { self::$errCode = "003"; self::$errMsg = "该清单已扫描配货完成,请扫描其他清单!"; return false; } } else { self::$errMsg = "请扫描该配货清单下的料号!"; return $show_info; } } } } }