| | |
| | | private String locno; |
| | | |
| | | // 货主 |
| | | private Integer owner; |
| | | private String owner; |
| | | |
| | | //组托物料 |
| | | private List<CombMat> combMats; |
| | |
| | | private Long hostId; |
| | | |
| | | @ApiModelProperty(value= "货主") |
| | | private Integer owner; |
| | | private String owner; |
| | | |
| | | public LocDetl() {} |
| | | |
| | | public LocDetl(String locNo,String zpallet,Double anfme,String matnr,String maktx,String batch,String orderNo,String specs,String model,String color,String brand,String unit,Double price,String sku,Double units,String barcode,String origin,String manu,String manuDate,String itemNum,Double safeQty,Double weight,Double length,Double volume,String threeCode,String supp,String suppCode,Integer beBatch,String deadTime,Integer deadWarn,Integer source,Integer inspect,Integer danger,Long modiUser,Date modiTime,Long appeUser,Date appeTime,String memo,Long hostId,Integer owner) { |
| | | public LocDetl(String locNo,String zpallet,Double anfme,String matnr,String maktx,String batch,String orderNo,String specs,String model,String color,String brand,String unit,Double price,String sku,Double units,String barcode,String origin,String manu,String manuDate,String itemNum,Double safeQty,Double weight,Double length,Double volume,String threeCode,String supp,String suppCode,Integer beBatch,String deadTime,Integer deadWarn,Integer source,Integer inspect,Integer danger,Long modiUser,Date modiTime,Long appeUser,Date appeTime,String memo,Long hostId,String owner) { |
| | | this.locNo = locNo; |
| | | this.zpallet = zpallet; |
| | | this.anfme = anfme; |
| | |
| | | return String.valueOf(locMast.getLocNo()); |
| | | } |
| | | return null; |
| | | } |
| | | |
| | | public String getOwner$(){ |
| | | if (null == this.owner){ return null; } |
| | | switch (this.owner){ |
| | | case 1: |
| | | return "宁波"; |
| | | case 2: |
| | | return "新昌"; |
| | | default: |
| | | return String.valueOf(this.owner); |
| | | } |
| | | } |
| | | |
| | | public String getModiUser$(){ |
| | |
| | | private String pic; |
| | | |
| | | @ApiModelProperty(value= "货主") |
| | | private Integer owner; |
| | | private String owner; |
| | | |
| | | public LocMast() {} |
| | | |
| | | public LocMast(String locNo,Long whsType,String locSts,Integer crnNo,Integer row1,Integer bay1,Integer lev1,String fullPlt,Short locType1,Short locType2,Short locType3,Date ioTime,Date firstTime,Long modiUser,Date modiTime,Long appeUser,Date appeTime,Date errorTime,String errorMemo,String mk,String barcode,String memo,Long hostId, Integer owner) { |
| | | public LocMast(String locNo,Long whsType,String locSts,Integer crnNo,Integer row1,Integer bay1,Integer lev1,String fullPlt,Short locType1,Short locType2,Short locType3,Date ioTime,Date firstTime,Long modiUser,Date modiTime,Long appeUser,Date appeTime,Date errorTime,String errorMemo,String mk,String barcode,String memo,Long hostId, String owner) { |
| | | this.locNo = locNo; |
| | | this.whsType = whsType; |
| | | this.locSts = locSts; |
| | |
| | | return null; |
| | | } |
| | | |
| | | public String getOwner$(){ |
| | | if (null == this.owner){ return null; } |
| | | switch (this.owner){ |
| | | case 1: |
| | | return "宁波"; |
| | | case 2: |
| | | return "新昌"; |
| | | default: |
| | | return String.valueOf(this.owner); |
| | | } |
| | | } |
| | | |
| | | public String getLocSts$(){ |
| | | BasLocStsService service = SpringUtils.getBean(BasLocStsService.class); |
| | |
| | | private String fullPlt; |
| | | |
| | | @ApiModelProperty(value= "货主") |
| | | private Integer owner; |
| | | private String owner; |
| | | |
| | | public WaitPakin() {} |
| | | |
| | | public WaitPakin(String zpallet,Double anfme,String locNo,String matnr,String maktx,String batch,String orderNo,String specs,String model,String color,String brand,String unit,Double price,String sku,Double units,String barcode,String origin,String manu,String manuDate,String itemNum,Double safeQty,Double weight,Double length,Double volume,String threeCode,String supp,String suppCode,Integer beBatch,String deadTime,Integer deadWarn,Integer source,Integer inspect,Integer danger,String status,String ioStatus,Long modiUser,Date modiTime,Long appeUser,Date appeTime,String memo,Long hostId,Integer owner) { |
| | | public WaitPakin(String zpallet,Double anfme,String locNo,String matnr,String maktx,String batch,String orderNo,String specs,String model,String color,String brand,String unit,Double price,String sku,Double units,String barcode,String origin,String manu,String manuDate,String itemNum,Double safeQty,Double weight,Double length,Double volume,String threeCode,String supp,String suppCode,Integer beBatch,String deadTime,Integer deadWarn,Integer source,Integer inspect,Integer danger,String status,String ioStatus,Long modiUser,Date modiTime,Long appeUser,Date appeTime,String memo,Long hostId,String owner) { |
| | | this.zpallet = zpallet; |
| | | this.anfme = anfme; |
| | | this.locNo = locNo; |
| | |
| | | } |
| | | } |
| | | |
| | | public String getOwner$(){ |
| | | if (null == this.owner){ return null; } |
| | | switch (this.owner){ |
| | | case 1: |
| | | return "宁波"; |
| | | case 2: |
| | | return "新昌"; |
| | | default: |
| | | return String.valueOf(this.owner); |
| | | } |
| | | } |
| | | |
| | | public String getFullPlt$(){ |
| | | if (null == this.fullPlt){ return null; } |
| | |
| | | private String fullPlt; |
| | | |
| | | @ApiModelProperty(value= "货主") |
| | | private Integer owner; |
| | | private String owner; |
| | | |
| | | public WaitPakinLog() {} |
| | | |
| | | public WaitPakinLog(Long id,String zpallet,Double anfme,String locNo,String matnr,String maktx,String batch,String orderNo,String specs,String model,String color,String brand,String unit,Double price,String sku,Double units,String barcode,String origin,String manu,String manuDate,String itemNum,Double safeQty,Double weight,Double length,Double volume,String threeCode,String supp,String suppCode,Integer beBatch,String deadTime,Integer deadWarn,Integer source,Integer inspect,Integer danger,String status,String ioStatus,Long modiUser,Date modiTime,Long appeUser,Date appeTime,String memo,Long hostId,Integer owner) { |
| | | public WaitPakinLog(Long id,String zpallet,Double anfme,String locNo,String matnr,String maktx,String batch,String orderNo,String specs,String model,String color,String brand,String unit,Double price,String sku,Double units,String barcode,String origin,String manu,String manuDate,String itemNum,Double safeQty,Double weight,Double length,Double volume,String threeCode,String supp,String suppCode,Integer beBatch,String deadTime,Integer deadWarn,Integer source,Integer inspect,Integer danger,String status,String ioStatus,Long modiUser,Date modiTime,Long appeUser,Date appeTime,String memo,Long hostId,String owner) { |
| | | this.id = id; |
| | | this.zpallet = zpallet; |
| | | this.anfme = anfme; |
| | |
| | | return "否"; |
| | | default: |
| | | return String.valueOf(this.beBatch); |
| | | } |
| | | } |
| | | public String getOwner$(){ |
| | | if (null == this.owner){ return null; } |
| | | switch (this.owner){ |
| | | case 1: |
| | | return "宁波"; |
| | | case 2: |
| | | return "新昌"; |
| | | default: |
| | | return String.valueOf(this.owner); |
| | | } |
| | | } |
| | | |
| | |
| | | private Long wrkMastId; |
| | | |
| | | @ApiModelProperty(value= "货主") |
| | | private Integer owner; |
| | | private String owner; |
| | | |
| | | public WrkDetl() {} |
| | | |
| | | public WrkDetl(Integer wrkNo,Date ioTime,Double anfme,String zpallet,String matnr,String maktx,String batch,String orderNo,String specs,String model,String color,String brand,String unit,Double price,String sku,Double units,String barcode,String origin,String manu,String manuDate,String itemNum,Double safeQty,Double weight,Double length,Double volume,String threeCode,String supp,String suppCode,Integer beBatch,String deadTime,Integer deadWarn,Integer source,Integer inspect,Integer danger,Long modiUser,Date modiTime,Long appeUser,Date appeTime,String memo,Long hostId,Integer owner) { |
| | | public WrkDetl(Integer wrkNo,Date ioTime,Double anfme,String zpallet,String matnr,String maktx,String batch,String orderNo,String specs,String model,String color,String brand,String unit,Double price,String sku,Double units,String barcode,String origin,String manu,String manuDate,String itemNum,Double safeQty,Double weight,Double length,Double volume,String threeCode,String supp,String suppCode,Integer beBatch,String deadTime,Integer deadWarn,Integer source,Integer inspect,Integer danger,Long modiUser,Date modiTime,Long appeUser,Date appeTime,String memo,Long hostId,String owner) { |
| | | this.wrkNo = wrkNo; |
| | | this.ioTime = ioTime; |
| | | this.anfme = anfme; |
| | |
| | | return ""; |
| | | } |
| | | return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.ioTime); |
| | | } |
| | | public String getOwner$(){ |
| | | if (null == this.owner){ return null; } |
| | | switch (this.owner){ |
| | | case 1: |
| | | return "宁波"; |
| | | case 2: |
| | | return "新昌"; |
| | | default: |
| | | return String.valueOf(this.owner); |
| | | } |
| | | } |
| | | public String getBeBatch$(){ |
| | | if (null == this.beBatch){ return null; } |
| | |
| | | private Long wrkMastId; |
| | | |
| | | @ApiModelProperty(value= "货主") |
| | | private Integer owner; |
| | | private String owner; |
| | | |
| | | public WrkDetlLog() {} |
| | | |
| | | public WrkDetlLog(Long id,Integer wrkNo,Date ioTime,Double anfme,String zpallet,String matnr,String maktx,String batch,String orderNo,String specs,String model,String color,String brand,String unit,Double price,String sku,Double units,String barcode,String origin,String manu,String manuDate,String itemNum,Double safeQty,Double weight,Double length,Double volume,String threeCode,String supp,String suppCode,Integer beBatch,String deadTime,Integer deadWarn,Integer source,Integer inspect,Integer danger,Long modiUser,Date modiTime,Long appeUser,Date appeTime,String memo,Long hostId,Integer owner) { |
| | | public WrkDetlLog(Long id,Integer wrkNo,Date ioTime,Double anfme,String zpallet,String matnr,String maktx,String batch,String orderNo,String specs,String model,String color,String brand,String unit,Double price,String sku,Double units,String barcode,String origin,String manu,String manuDate,String itemNum,Double safeQty,Double weight,Double length,Double volume,String threeCode,String supp,String suppCode,Integer beBatch,String deadTime,Integer deadWarn,Integer source,Integer inspect,Integer danger,Long modiUser,Date modiTime,Long appeUser,Date appeTime,String memo,Long hostId,String owner) { |
| | | this.id = id; |
| | | this.wrkNo = wrkNo; |
| | | this.ioTime = ioTime; |
| | |
| | | private String pic; |
| | | |
| | | @ApiModelProperty(value= "货主") |
| | | private Integer owner; |
| | | private String owner; |
| | | |
| | | public WrkMast() {} |
| | | |
| | | public WrkMast(Integer wrkNo, Long wrkSts, Integer ioType, Double ioPri, String locNo, Integer staNo, Integer sourceStaNo, String sourceLocNo, String picking, String exitMk, Integer pltType, String emptyMk, Date ioTime, Integer ctnType, String modiUser, Date modiTime, String appeUser, Date appeTime, Date errorTime, String errorMemo, String manuType, String memo, String barcode, String fullPlt, Long hostId, String oveMk, String invWh, Integer crnNo,Integer owner) { |
| | | public WrkMast(Integer wrkNo, Long wrkSts, Integer ioType, Double ioPri, String locNo, Integer staNo, Integer sourceStaNo, String sourceLocNo, String picking, String exitMk, Integer pltType, String emptyMk, Date ioTime, Integer ctnType, String modiUser, Date modiTime, String appeUser, Date appeTime, Date errorTime, String errorMemo, String manuType, String memo, String barcode, String fullPlt, Long hostId, String oveMk, String invWh, Integer crnNo,String owner) { |
| | | this.wrkNo = wrkNo; |
| | | this.wrkSts = wrkSts; |
| | | this.ioType = ioType; |
| | |
| | | // null // 授权商户 |
| | | // ); |
| | | |
| | | public String getOwner$(){ |
| | | if (null == this.owner){ return null; } |
| | | switch (this.owner){ |
| | | case 1: |
| | | return "宁波"; |
| | | case 2: |
| | | return "新昌"; |
| | | default: |
| | | return String.valueOf(this.owner); |
| | | } |
| | | } |
| | | |
| | | public String getWrkSts$(){ |
| | | BasWrkStatusService service = SpringUtils.getBean(BasWrkStatusService.class); |
| | |
| | | @ApiModelProperty(value= "拍照图片") |
| | | private String pic; |
| | | @ApiModelProperty(value= "货主") |
| | | private Integer owner; |
| | | private String owner; |
| | | |
| | | public WrkMastLog() {} |
| | | |
| | | public WrkMastLog(Long id,Integer wrkNo,Long wrkSts,Integer ioType,Double ioPri,String locNo,Integer staNo,Integer sourceStaNo,String sourceLocNo,String picking,String exitMk,Integer pltType,String emptyMk,Date ioTime,Integer ctnType,String modiUser,Date modiTime,String appeUser,Date appeTime,Date errorTime,String errorMemo,String manuType,String memo,String barcode,String fullPlt,Long hostId,Integer owner) { |
| | | public WrkMastLog(Long id,Integer wrkNo,Long wrkSts,Integer ioType,Double ioPri,String locNo,Integer staNo,Integer sourceStaNo,String sourceLocNo,String picking,String exitMk,Integer pltType,String emptyMk,Date ioTime,Integer ctnType,String modiUser,Date modiTime,String appeUser,Date appeTime,Date errorTime,String errorMemo,String manuType,String memo,String barcode,String fullPlt,Long hostId,String owner) { |
| | | this.id = id; |
| | | this.wrkNo = wrkNo; |
| | | this.wrkSts = wrkSts; |
| | |
| | | // null, // 满板(checkBox) |
| | | // null // 授权商户 |
| | | // ); |
| | | public String getOwner$(){ |
| | | if (null == this.owner){ return null; } |
| | | switch (this.owner){ |
| | | case 1: |
| | | return "宁波"; |
| | | case 2: |
| | | return "新昌"; |
| | | default: |
| | | return String.valueOf(this.owner); |
| | | } |
| | | } |
| | | public String getWrkSts$(){ |
| | | BasWrkStatusService service = SpringUtils.getBean(BasWrkStatusService.class); |
| | | BasWrkStatus basWrkStatus = service.getById(this.wrkSts); |
| | |
| | | <if test="map.anfme!=null and map.anfme!='' "> |
| | | and a.anfme like '%' + #{map.anfme} + '%' |
| | | </if> |
| | | <if test="map.owner!=null and map.owner!='' "> |
| | | and a.owner like '%' + #{map.owner} + '%' |
| | | </if> |
| | | <if test="map.startTime!=null and map.endTime!=null"> |
| | | and a.modi_time between #{map.startTime} and #{map.endTime} |
| | | </if> |
| | |
| | | import com.alibaba.fastjson.JSONArray; |
| | | import com.alibaba.fastjson.JSONObject; |
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.zy.asrs.common.wms.entity.LocDetl; |
| | |
| | | // 检索库位 |
| | | List<String> matNos = waitPakins.stream().map(WaitPakin::getMatnr).distinct().collect(Collectors.toList()); |
| | | String batch = waitPakins.get(0).getBatch(); |
| | | Integer owner = waitPakins.get(0).getOwner(); |
| | | String owner = waitPakins.get(0).getOwner(); |
| | | StartupDto dto = commonService.getLocNo(1, devpNo, matNos, batch, hostId, locTypeDto, 0); |
| | | int workNo = dto.getWorkNo(); |
| | | Date now = new Date(); |
| | |
| | | import com.alibaba.fastjson.JSONArray; |
| | | import com.alibaba.fastjson.JSONObject; |
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.zy.asrs.common.wms.entity.WrkMast; |
| | | import com.zy.asrs.common.wms.service.WrkMastService; |
| | |
| | | @RequestParam(required = false) String condition, |
| | | @RequestParam(required = false) String timeRange, |
| | | @RequestParam Map<String, Object> param) { |
| | | LambdaQueryWrapper<WrkMast> wrapper = new LambdaQueryWrapper<>(); |
| | | wrapper.eq(WrkMast::getHostId, getHostId()); |
| | | if (!Cools.isEmpty(condition)) { |
| | | wrapper.like(WrkMast::getWrkNo, condition); |
| | | } |
| | | if (!Cools.isEmpty(timeRange)) { |
| | | String[] range = timeRange.split(RANGE_TIME_LINK); |
| | | wrapper.ge(WrkMast::getIoTime, DateUtils.convert(range[0])); |
| | | wrapper.le(WrkMast::getIoTime, DateUtils.convert(range[1])); |
| | | } |
| | | if (!Cools.isEmpty(param.get("wrk_no"))) { |
| | | wrapper.eq(WrkMast::getWrkNo, param.get("wrk_no")); |
| | | } |
| | | if (!Cools.isEmpty(param.get("wrk_sts"))) { |
| | | wrapper.eq(WrkMast::getWrkSts, param.get("wrk_sts")); |
| | | } |
| | | excludeTrash(param); |
| | | QueryWrapper<WrkMast> wrapper = new QueryWrapper<>(); |
| | | wrapper.eq("host_id",getHostId()); |
| | | convert(param, wrapper); |
| | | return R.ok(wrkMastService.page(new Page<>(curr, limit), wrapper)); |
| | | } |
| | | |
| | | private <T> void convert(Map<String, Object> map, QueryWrapper<T> wrapper){ |
| | | for (Map.Entry<String, Object> entry : map.entrySet()){ |
| | | String val = String.valueOf(entry.getValue()); |
| | | if (val.contains(RANGE_TIME_LINK)){ |
| | | String[] dates = val.split(RANGE_TIME_LINK); |
| | | wrapper.ge(entry.getKey(), DateUtils.convert(dates[0])); |
| | | wrapper.le(entry.getKey(), DateUtils.convert(dates[1])); |
| | | } else { |
| | | wrapper.like(entry.getKey(), val); |
| | | } |
| | | } |
| | | } |
| | | |
| | | @RequestMapping(value = "/wrkMast/add/auth") |
| | | @ManagerAuth |
| | |
| | | ,{field: 'batch', align: 'center',title: '序列码', width: 300, sort:true} |
| | | ,{field: 'anfme', align: 'center',title: '数量'} |
| | | ,{field: 'zpallet', align: 'center',title: '托盘条码'} |
| | | ,{field: 'owner', align: 'center',title: '货主'} |
| | | ,{field: 'fullPlt$', align: 'center',title: '是否满板'} |
| | | ,{field: 'specs', align: 'center',title: '规格'} |
| | | ,{field: 'model', align: 'center',title: '代码', hide: false} |
| | |
| | | ,{field: 'row1', align: 'center',title: '排'} |
| | | ,{field: 'bay1', align: 'center',title: '列'} |
| | | ,{field: 'lev1', align: 'center',title: '层'} |
| | | ,{field: 'owner$', align: 'center',title: '货主'} |
| | | ,{field: 'owner', align: 'center',title: '货主'} |
| | | ,{field: 'fullPlt', align: 'center',title: '满板', templet:function(row){ |
| | | var html = "<input value='fullPlt' type='checkbox' lay-skin='primary' lay-filter='tableCheckbox' table-index='"+row.LAY_TABLE_INDEX+"'"; |
| | | if(row.fullPlt === 'Y'){html += " checked ";} |
| | |
| | | html += ">"; |
| | | return html; |
| | | }} |
| | | ,{field: 'owner$', align: 'center',title: '货主'} |
| | | ,{field: 'owner', align: 'center',title: '货主'} |
| | | ,{fixed: 'right', title:'操作', align: 'center', toolbar: '#operate', width:250} |
| | | ]], |
| | | request: { |
| | |
| | | ,{field: 'zpallet', align: 'center',title: '托盘条码'} |
| | | ,{field: 'bname', align: 'center',title: '用户ID'} |
| | | ,{field: 'memo', align: 'center',title: '备注'} |
| | | ,{field: 'owner$', align: 'center',title: '货主'} |
| | | ,{field: 'owner', align: 'center',title: '货主'} |
| | | |
| | | ,{fixed: 'right', title:'操作', align: 'center', toolbar: '#operate', width:50} |
| | | ]], |
| | |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" type="text" name="owner" placeholder="拥有者编号" autocomplete="off"> |
| | | <input class="layui-input" type="text" name="owner" placeholder="货主" autocomplete="off"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |