| | |
| | | // 到达拣选位,控制播种墙亮灯
|
| | | CacheSite cacheSite = cacheSiteService.getOne(new LambdaQueryWrapper<CacheSite>()
|
| | | .eq(CacheSite::getChannel, task.getTargetSite())
|
| | | .isNull(CacheSite::getOrderId).orderByAsc(CacheSite::getId));
|
| | | .isNull(CacheSite::getOrderId).orderByAsc(CacheSite::getId),false);
|
| | | // List<CacheSite> cacheSites = cacheSiteService.list(new LambdaQueryWrapper<CacheSite>()
|
| | | // .eq(CacheSite::getBarcode, task.getBarcode()));
|
| | | if(Objects.isNull(cacheSite)) {
|
| | |
| | | </foreach>
|
| | | </select>
|
| | | <select id="getTaskDetlByTaskNo" resultType="com.zy.asrs.wms.apis.wcs.entity.domain.WaveTaskDetl">
|
| | | SELECT mt.task_no,mtd.matnr, mtd.anfme ,mtd.wave_no, mt.site_no, mtd.stock, mtd.batch FROM man_task mt INNER JOIN
|
| | | SELECT mt.task_no,mtd.matnr, mtd.anfme ,mtd.wave_no, mt.origin_site AS site_n4o, mtd.stock, mtd.batch FROM man_task mt INNER JOIN
|
| | | man_task_detl mtd ON mt.id = mtd.task_id
|
| | | WHERE 1 = 1
|
| | | <if test="taskNo != null and taskNo != ''">
|