/**
* 获取用户负责区域内波次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;
}
}
