| | |
| | | import org.apache.ibatis.annotations.*; |
| | | |
| | | import com.example.springboot.entity.CarPosition; |
| | | import com.example.springboot.entity.FlowCard; |
| | | import com.example.springboot.entity.Flowcard; |
| | | import com.example.springboot.entity.GlassInfo; |
| | | import com.example.springboot.entity.StorageCage; |
| | | import com.example.springboot.entity.StorageTask; |
| | |
| | | void StorageCageAddGlass(String cell, GlassInfo glassInfo); |
| | | |
| | | @Select("select * from flowcard where state!=2") |
| | | List<FlowCard> SelectOrderTask(); |
| | | List<Flowcard> SelectOrderTask(); |
| | | |
| | | @Select("select gi.*,sum(sc.number) as cageno from glassinfo gi left join storage_cage sc on gi.glasstype=sc.glasstype where gi.flowcard=#{flowcard} group by gi.id order by gi.mateid,gi.tier") |
| | | List<GlassInfo> SelectOrderView(String flowcard); |