| | |
| | | @RequestMapping("/available/put/site") |
| | | @ManagerAuth(memo = "获取有效的入库站点") |
| | | public R availablePutSite(){ |
| | | return R.ok().add(basDevpService.getAvailableDevp()); |
| | | return R.ok().add(basDevpService.getAvailableInSite()); |
| | | } |
| | | |
| | | @RequestMapping("/available/take/site") |
| | | @ManagerAuth(memo = "获取有效的出库站点") |
| | | public R availableTakeSite(){ |
| | | return R.ok().add(basDevpService.getAvailableDevp()); |
| | | return R.ok().add(basDevpService.getAvailableOutSite()); |
| | | } |
| | | |
| | | @RequestMapping("/full/store/start") |
| | |
| | | @Repository |
| | | public interface BasDevpMapper extends BaseMapper<BasDevp> { |
| | | |
| | | List<Integer> getAvailableDevp(); |
| | | List<Integer> getAvailableInSite(); |
| | | |
| | | List<Integer> getAvailableOutSite(); |
| | | } |
| | |
| | | |
| | | public interface BasDevpService extends IService<BasDevp> { |
| | | |
| | | List<Integer> getAvailableDevp(); |
| | | List<Integer> getAvailableInSite(); |
| | | |
| | | List<Integer> getAvailableOutSite(); |
| | | |
| | | BasDevp checkSiteStatus(Integer devpNo); |
| | | |
| | |
| | | private WrkMastService wrkMastService; |
| | | |
| | | @Override |
| | | public List<Integer> getAvailableDevp() { |
| | | return this.baseMapper.getAvailableDevp(); |
| | | public List<Integer> getAvailableInSite() { |
| | | return this.baseMapper.getAvailableInSite(); |
| | | } |
| | | |
| | | @Override |
| | | public List<Integer> getAvailableOutSite() { |
| | | return this.baseMapper.getAvailableOutSite(); |
| | | } |
| | | |
| | | @Override |
| | |
| | | |
| | | </resultMap> |
| | | |
| | | <select id="getAvailableDevp" resultType="java.lang.Integer"> |
| | | <select id="getAvailableInSite" resultType="java.lang.Integer"> |
| | | select |
| | | abd.dev_no |
| | | from asr_bas_devp abd |
| | |
| | | group by abd.dev_no |
| | | </select> |
| | | |
| | | <select id="getAvailableOutSite" resultType="java.lang.Integer"> |
| | | select |
| | | abd.dev_no |
| | | from asr_bas_devp abd |
| | | left join asr_sta_desc asd on abd.dev_no = asd.stn_no |
| | | where 1=1 |
| | | and asd.type_no = 110 |
| | | and abd.out_enable = 'Y' |
| | | group by abd.dev_no |
| | | </select> |
| | | |
| | | </mapper> |
| | |
| | | // ,{field: 'typeId', align: 'center',title: '路径ID'} |
| | | ,{field: 'typeNo$', align: 'center',title: '入出库类型'} |
| | | // ,{field: 'typeDesc', align: 'center',title: '作业类型'} |
| | | ,{field: 'stnNo$', align: 'center',title: '起始站点'} |
| | | ,{field: 'stnNo$', align: 'center',title: '作业站点'} |
| | | ,{field: 'stnDesc', align: 'center',title: '站点名称', edit:'text'} |
| | | ,{field: 'crnNo$', align: 'center',title: '堆垛机号'} |
| | | ,{field: 'crnStn$', align: 'center',title: '目标站点'} |
| | | ,{field: 'crnStn$', align: 'center',title: '堆垛机站点'} |
| | | ,{field: 'memo', align: 'center',title: '备注'} |
| | | // ,{field: 'modiUser$', align: 'center',title: '修改人员',event: 'modiUser', style: 'cursor:pointer'} |
| | | // ,{field: 'modiTime$', align: 'center',title: '修改时间'} |
| | |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline" style="width:31%;"> |
| | | <label class="layui-form-label"><span class="not-null">*</span>起始站点:</label> |
| | | <label class="layui-form-label"><span class="not-null">*</span>作业站点:</label> |
| | | <div class="layui-input-inline cool-auto-complete"> |
| | | <input id="stnNo" class="layui-input" type="text" onkeyup="check(this.id, 'staDesc')" lay-verify="required|number" style="display: none"> |
| | | <input id="stnNo$" class="layui-input cool-auto-complete-div" onclick="autoShow(this.id)" type="text" placeholder="请输入..." onfocus=this.blur()> |
| | |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline" style="width:31%;"> |
| | | <label class="layui-form-label">目标站点:</label> |
| | | <label class="layui-form-label">堆垛机站点:</label> |
| | | <div class="layui-input-inline cool-auto-complete"> |
| | | <input id="crnStn" class="layui-input" type="text" lay-verify="number" style="display: none"> |
| | | <input id="crnStn$" class="layui-input cool-auto-complete-div" onclick="autoShow(this.id)" type="text" placeholder="请输入..." onfocus=this.blur()> |