Esempio n. 1
0
 function act_getGroupInfo()
 {
     $userId = $_SESSION['userId'];
     $shipOrderGroup = $_POST['order_group'];
     $group_sql = GroupRouteBModel::getOrderGroupB("*", "where shipOrderGroup='{$shipOrderGroup}'");
     if (empty($group_sql)) {
         self::$errCode = "003";
         self::$errMsg = "该提货单不存在,请重新输入!";
         return false;
     } else {
         $scan_sql = GroupDistributionBModel::getGroupDistListB("shipOrderGroup", "where shipOrderGroup='{$shipOrderGroup}'");
         if (empty($scan_sql)) {
             $string = "";
             $time = time();
             foreach ($group_sql as $info) {
                 $string .= "('" . $info['shipOrderGroup'] . "','" . $info['sku'] . "','" . $info['id'] . "','" . $info['skuAmount'] . "','" . $info['shipOrderId'] . "','0','0','" . $info['pName'] . "','" . $userId . "','" . $time . "'),";
             }
             $string = trim($string, ",");
             //插入配货提货单表
             $insert_info = GroupDistributionBModel::insertGroupDistB($string);
             if ($insert_info) {
                 $show_info = array();
                 $show_sql = GroupDistributionBModel::getGroupSkuInfoB("and a.shipOrderGroup='{$shipOrderGroup}' and a.status=0 group by a.pName order by a.groupId asc");
                 if (!empty($show_sql)) {
                     $order_sku_info = $this->get_valid_order($show_sql[0]['shipOrderGroup'], $show_sql[0]['sku'], $show_sql[0]['pName']);
                     if ($order_sku_info) {
                         $show_info['group_id'] = $show_sql[0]['groupId'];
                         $show_info['sku'] = $show_sql[0]['sku'];
                         $show_info['sku_amount'] = $show_sql[0]['skuAmount'];
                         $show_info['goods_location'] = $show_sql[0]['pName'];
                     }
                 }
                 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 = GroupDistributionBModel::getGroupDistListB("*", "where shipOrderGroup='{$shipOrderGroup}' and status=0");
             if (empty($iscan)) {
                 self::$errCode = "003";
                 self::$errMsg = "该单已扫描配货完成,请扫描其他单!";
                 return false;
             } else {
                 //更新配货人
                 $data = array('userID' => $userId);
                 GroupDistributionBModel::update($data, "and shipOrderGroup='{$shipOrderGroup}' and status=0");
                 //检查是否有出库过
                 $isout = GroupDistributionBModel::getGroupDistListB("*", "where shipOrderGroup='{$shipOrderGroup}' and status=1");
                 $show_info = array();
                 $show_sql = GroupDistributionBModel::getGroupSkuInfoB("and a.shipOrderGroup='{$shipOrderGroup}' and a.status=0 group by a.pName order by a.groupId asc");
                 if (!empty($show_sql)) {
                     $order_sku_info = $this->get_valid_order($show_sql[0]['shipOrderGroup'], $show_sql[0]['sku'], $show_sql[0]['pName']);
                     if ($order_sku_info) {
                         $show_info['group_id'] = $show_sql[0]['groupId'];
                         $show_info['sku'] = $show_sql[0]['sku'];
                         $show_info['sku_amount'] = $show_sql[0]['skuAmount'];
                         $show_info['goods_location'] = $show_sql[0]['pName'];
                     }
                 }
                 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;
                 }
             }
         }
     }
 }