| | |
|---|
| | | //获取进片数据 |
|---|
| | | @Select("select glassid,flowcard,glasswidth as width,glassheight as height,glasswidthmm,glassheightmm,glasstype,thickness from queue where state=1 limit 1") |
|---|
| | | GlassInfo SelectGlass(); |
|---|
| | | //一号线查询任务 |
|---|
| | | @Select("select * from v_cagerelease1 where mateid not in(select mateid from v_cagerelease1 where surplus=0 group by mateid);") |
|---|
| | | GlassInfo SelectOutGlass1(); |
|---|
| | | //二号线查询任务 |
|---|
| | | @Select("select * from v_cagerelease2 where mateid not in(select mateid from v_cagerelease2 where surplus=0 group by mateid)LIMIT 1;") |
|---|
| | | GlassInfo SelectOutGlass2(); |
|---|
| | | |
|---|
| | | //待出片任务查询 |
|---|
| | | @Select("select * from out_task where task_state=0 order by id asc;") |
|---|
| | | List<StorageTask> SelectOutTask(); |
|---|
| | |
|---|
| | | @Select("select method,flowcard from flowcard where state=1 and line=#{line} ORDER BY starttime LIMIT 1;") |
|---|
| | | GlassInfo SelectMethod(int line); |
|---|
| | | //直出模式任务查询 |
|---|
| | | @Select("select b.flowcard,b.glassid,b.glasstype,b.mateid,b.width,b.tier,a.totaltier as id,IFNULL(c.number,0)as number,b.glassid from flowcard a left join glassinfo b on a.flowcard=b.flowcard left join(select sum(number)as number,glasstype from storage_cage GROUP BY glasstype)c on b.glasstype=c.glasstype where a.line=1 and a.state=1 and c.number>0 ORDER BY b.mateid,b.tier asc limit 1") |
|---|
| | | GlassInfo SelectOutGlass2(int line); |
|---|
| | | @Select("select b.flowcard,b.glassid,b.glasstype,b.mateid,b.width,b.tier,a.totaltier as id,IFNULL(c.number,0)as number from flowcard a left join glassinfo b on a.flowcard=b.flowcard left join(select sum(number)as number,glasstype from storage_cage GROUP BY glasstype)c on b.glasstype=c.glasstype where a.state=1 and c.number>0 ORDER BY b.mateid,b.tier asc limit 1") |
|---|
| | | GlassInfo SelectOutGlass2(); |
|---|
| | | //查询直通模式下最后一块 |
|---|
| | | @Select("select IFNULL(b.tier, 0) from flowcard a left join glassinfo b on a.flowcard=b.flowcard left join(select sum(number)as number,glasstype from storage_cage GROUP BY glasstype)c on b.glasstype=c.glasstype where a.line=#{line} and c.number>0 ORDER BY b.tier desc LIMIT 1") |
|---|
| | | int SelectOutGlassend(int line); |
|---|
| | |
|---|
| | | @Select("select*from glassinfo where glasstype=#{glasstype} limit 1;") |
|---|
| | | GlassInfo SelectGlassinfo(Integer glasstype); |
|---|
| | | //查询纯配片模式可出配片id |
|---|
| | | @Select("select gls.flowcard,gls.mateid,gls.tier,gls.glasstype,kc.number from glassinfo as gls left join (select glasstype,sum(number) as number from storage_cage where number>0 and disabled=0 GROUP BY glasstype)as kc on gls.glasstype=kc.glasstype where gls.flowcard=#{flowcard} and gls.number>gls.finishnumber and kc.number>0 GROUP BY gls.flowcard, gls.mateid, gls.tier, gls.glasstype, kc.number,mateid order by gls.mateid;") |
|---|
| | | @Select("select gls.flowcard,gls.mateid,gls.tier,gls.glasstype,kc.number from glassinfo as gls left join (select glasstype,sum(number) as number from storage_cage where number>0 and disabled=0 GROUP BY glasstype)as kc on gls.glasstype=kc.glasstype where gls.flowcard=#{flowcard} and kc.number>0 GROUP BY gls.flowcard, gls.mateid, gls.tier, gls.glasstype, kc.number,mateid order by gls.mateid;") |
|---|
| | | List<GlassInfo> SelectOutGlass3(String flowcard); |
|---|
| | | //判断此配片id是否有足够的玻璃 |
|---|
| | | @Select("SELECT CASE WHEN storage.number >= required.number THEN '足够' ELSE '不足' END AS status FROM (SELECT a.glasstype, COUNT(a.glasstype) AS number FROM glassinfo a WHERE a.flowcard =#{flowcard} AND a.mateid =#{mateid} GROUP BY a.glasstype) AS required LEFT JOIN (SELECT a.glasstype, SUM(a.number) AS number FROM storage_cage a WHERE a.number > 0 and disabled=0 GROUP BY a.glasstype) AS storage ON required.glasstype = storage.glasstype;") |
|---|
| | |
|---|
| | | //完成出片队列的任务 |
|---|
| | | @Update("update out_task set task_state=1 where id=#{id};") |
|---|
| | | void UpdateOutTask(int id); |
|---|
| | | //判断此格子是否在出片队列有数据 |
|---|
| | | @Select("select count(*) from out_task where shelf_rack=#{cell} and (task_state=0 or task_state=2)") |
|---|
| | | int SelectOutTasksum(int cell); |
|---|
| | | } |
|---|
