| | |
|---|
| | | }) |
|---|
| | | public List<Map> getHwList(String sdepartNo); |
|---|
| | | |
|---|
| | | // 义瑞LED显示 序号 车号 装车区 状态 |
|---|
| | | /** 义瑞、科技LED显示 序号 车号 装车区 状态 **/ |
|---|
| | | @Select({ |
|---|
| | | "select bs.numberplates,businessNo,zcWz,firstzxhtime," , |
|---|
| | | "case WHEN EXISTS ( SELECT * FROM bussinessitems WHERE bussinessNo = x.businessNo ) THEN '在装'" , |
|---|
| | | " when x.firstgbtime is not null then '待装' else '完成' end zcStatus " , |
|---|
| | | " from xs_taskmonitor x" , |
|---|
| | | " join bussinesssheet bs on x.businessNo=bs.bussinessNo and bs.sstatus='在办' " , |
|---|
| | | " where sdepartNo=#{sdepartNo} and firstgbtime is not null and x.lastgbtime is null" |
|---|
| | | " where sdepartNo=#{sdepartNo} and firstgbtime is not null and x.lastgbtime is null order by jctime" |
|---|
| | | }) |
|---|
| | | public List<Map> yRZcList(String sdepartNo); |
|---|
| | | |
|---|
