/**
* 获取用户负责区域内波次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();
}
/**
* 获取多SKU波次对应的全部发货单
* 注：单SKU波次对应发货单调用：WhWaveScanRecordModel::getShipOrders($waveId, $shipOrderId);
* @param $waveId:波次
* @param $shipOrderId:发货单号
* @author cmf
*/
public static function getShipOrders($waveId = '', $shipOrderId = '')
{
$sql = "select b.transportId, a.waveId, a.shipOrderId from wh_wave_shipping_relation a \n\t\t\t\tleft join wh_shipping_order b ON(a.shipOrderId=b.id)\n\t\t\t\twhere a.is_delete=0 AND a.waveId='{$waveId}'" . ($shipOrderId ? " AND a.shipOrderId='{$shipOrderId}'" : "") . " group by a.shipOrderId order by a.id ASC";
$list = WhWaveScanRecordModel::query($sql);
return $list ? $list : array();
}
