/** * 获取用户负责区域内波次SKU配货路由 * @param $waveId:波次 * @param $uid:用户ID * @param $limit:返回SKU条数 * @return 返回用户负责区域内需配货的SKU * @author cmf */ public static function getUserAreaSkuList($waveId, $uid, $areas, $limit = 0) { //$whereArr[] = "(a.scanUserId=0 OR a.scanUserId='{$uid}')"; $whereArr[] = "a.scanUserId='{$uid}'"; //$whereArr[] = 'a.scanStatus=0'; $whereArr[] = "a.is_delete=0"; $whereArr[] = "a.waveId='{$waveId}'"; $whereArr[] = "a.area IN('" . implode("','", $areas) . "')"; $whereArr[] = "b.is_delete=0"; $whereArr[] = "b.routeType=4"; //$whereArr[] = "e.userId='$uid'"; $sql = implode(' AND ', $whereArr); /*$sql = "select a.id, a.sku, a.skuAmount, a.amount, a.scanUserId, a.scanStatus, a.scanTime, a.storey, a.pName, c.id as skuid from wh_wave_scan_record a left join wh_wave_area_info d ON(d.areaName=a.area AND d.is_delete=0) left join wh_wave_route_relation b ON(d.id=b.name AND b.is_delete=0) left join pc_goods c ON(c.sku=a.sku AND c.is_delete=0) left join wh_wave_area_user_relation e ON (e.areaId=d.id AND e.is_delete=0 AND e.userId='".$uid."') where ".$sql." order by a.scanStatus ASC, a.scanTime ASC, a.storey DESC, b.route asc, a.pName ASC".($limit ? " limit ".$limit : "");*/ /*$sql = "select w.areaName from wh_wave_area_user_relation e left join wh_wave_area_info as w on e.areaId = w.id where e.userId='{$uid}' "; $areaNames = WhWaveScanRecordModel::query($sql);*/ $sql = "select a.* from wh_wave_scan_record as a\n\t\t\t\tleft join wh_wave_route_relation as b \n\t\t\t\ton a.pName = b.name\n\t\t\t\twhere " . $sql . " order by a.scanTime ASC, b.route ASC, a.pName ASC" . ($limit ? " limit " . $limit : ""); //echo $sql; echo "<br>"; $list = WhWaveScanRecordModel::query($sql); foreach ($list as $key => $val) { $val['skucode'] = get_skuGoodsCode($val['sku']); $list[$key] = $val; } return $list ? $list : array(); }
</head> <body> <?php $printId = $_SESSION['userId']; //print_r($_GET); $max_num = 10000; //isset($_GET['max_num'])?$_GET['max_num']:1000000; $idarr = isset($_GET['idarr']) ? $_GET['idarr'] : array(); $idarr = explode(",", $idarr); $lists = array(); $time = time(); foreach ($idarr as $key => $id) { $where = "where id={$id}"; $list = packageCheckModel::selectList($where); $goodscode = get_skuGoodsCode($list[0]['sku']); $pname_info = GroupRouteModel::getSkuPosition("where a.sku='{$list[0]['sku']}' and b.is_delete=0"); if (!empty($pname_info)) { $pname = $pname_info[0]['pName']; } else { $pname = ''; } $print_num = $list[0]['num'] > $max_num ? $max_num : $list[0]['num']; $groupInfo = printLabelModel::getGroupInfoByTallyListId($id); if (!empty($groupInfo)) { $group_id = $groupInfo[0]['id']; } else { //没有打标ID则跳转到打标页面 header("Location:index.php?act=printLabelPrint&mod=printLabel&max_num=10000000&idarr={$id}"); exit; $group_id = '';
$max_num = isset($_GET['max_num']) ? $_GET['max_num'] : 100; $str = isset($_GET['str']) ? $_GET['str'] : ""; $arr = explode(",", $str); $lists = array(); foreach ($arr as $key => $value) { $value_arr = explode("*", $value); $sku = $value_arr[0]; $num = $value_arr[1]; //$lists[] = $list; $pname_info = GroupRouteModel::getSkuPosition("where a.sku='{$sku}' and b.is_delete=0"); if (!empty($pname_info)) { $pname = $pname_info[0]['pName']; } else { $pname = ''; } $skuCode = get_skuGoodsCode($sku); ?> <?php for ($i = 0; $i < $num; $i = $i + 2) { ?> <table width="420" border="0" cellspacing="0" cellpadding="0" style="margin-top: 3px;"> <tr valign="middle"> <td width="200"> <table width="100%" height="100" border="0" cellspacing="0" cellpadding="0"> <tr>
/** * 仓库点货、打标信息推送给qc系统 * $tallyListId 点货Id集合 */ public static function pushTallyingList($tallyListId) { self::initDB(); $rmq_config = C("RMQ_CONFIG"); $rabbitMQClass = new RabbitMQClass($rmq_config['sendOrder'][1], $rmq_config['sendOrder'][2], $rmq_config['sendOrder'][4], $rmq_config['sendOrder'][0]); //队列对象 $orderDataInfo = array(); //基础信息 $sql = "select * from `wh_tallying_list` where id in({$tallyListId})"; $query = self::$dbConn->query($sql); $tallyingInfo = self::$dbConn->fetch_array_all($query); foreach ($tallyingInfo as &$info) { $info['googsCode'] = get_skuGoodsCode($info['sku']); $info['googsName'] = getSKUName($info['sku']); } $exchange = 'send_tallying_list'; if ($rabbitMQClass->queue_publish($exchange, $tallyingInfo)) { self::$errMsg = "推送成功!"; return true; } else { self::$errCode = "401"; self::$errMsg = "推送失败!"; return false; } }