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