| | |
|---|
| | | " left join nc_hw hw on mx.tdmx_hwbh=hw.pkid and hw.state=1 " , |
|---|
| | | " join xs_taskmonitor xt on mx.tdmx_fdywbh = xt.businessNo ", |
|---|
| | | " join fd_bsheet on bsNo=tdmx_fdywbh and status='在办' " , |
|---|
| | | " where SdepartNo=#{sdepartNo} and xt.firstgbtime is not null and xt.lastgbtime is null and zcWc=0" |
|---|
| | | " where SdepartNo=#{sdepartNo} and xt.firstgbtime is not null and xt.lastgbtime is null" |
|---|
| | | }) |
|---|
| | | public List<Map> getHwList(String sdepartNo); |
|---|
| | | |
|---|
| | |
|---|
| | | "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" , |
|---|
| | | " where sdepartNo=#{sdepartNo} and x.lastgbtime is null and zcWc=0" |
|---|
| | | " join bussinesssheet bs on x.businessNo=bs.bussinessNo and bs.sstatus='在办' " , |
|---|
| | | " where sdepartNo=#{sdepartNo} and firstgbtime is not null and x.lastgbtime is null " |
|---|
| | | }) |
|---|
| | | public List<Map> yRZcList(String sdepartNo); |
|---|
| | | |
|---|
