| | |
|---|
| | | @Select("SELECT * FROM queue where glassid=#{glassid}") |
|---|
| | | List<Queue> selectQueues(@Param("glassid") int glassid); |
|---|
| | | |
|---|
| | | @Select("SELECT * FROM queue order by time asc limit 1") |
|---|
| | | @Select("SELECT * FROM queue order by time desc limit 1") |
|---|
| | | Queue selectLastQueue(); |
|---|
| | | |
|---|
| | | @Select("SELECT * FROM queue where state<=0") |
|---|
| | |
|---|
| | | // @Update("UPDATE role_permission SET state = #{state} WHERE role_id = #{roleId} AND permission_id = #{permissionId}") |
|---|
| | | // void updateState(@Param("roleId") int roleId, @Param("permissionId") int permissionId, @Param("state") int state); |
|---|
| | | |
|---|
| | | @Insert("insert into queue (glassid,flowcard,listid,boxid,glasswidth,glassheight,glasswidthmm,glassheightmm,glasstype,state,time) "+ |
|---|
| | | "select glassid,flowcard,null,null,width,height,#{glasswidthmm},#{glassheightmm},glasstype,#{state},NOW() from glassinfo where glassid=#{glassid}") |
|---|
| | | @Insert("insert into queue (glassid,flowcard,listid,boxid,glasswidth,glassheight,glasswidthmm,glassheightmm,glasstype,state,time,thickness) "+ |
|---|
| | | "select glassid,flowcard,null,null,width,height,#{glasswidthmm},#{glassheightmm},glasstype,#{state},NOW(),thickness from glassinfo where glassid=#{glassid}") |
|---|
| | | void insert(@Param("glassid") String glassid, @Param("glasswidthmm") double glasswidthmm, @Param("glassheightmm") double glassheightmm,@Param("state") int state); |
|---|
| | | |
|---|
| | | @Insert("insert into queue (glassid,flowcard,listid,boxid,glasswidth,glassheight,glasswidthmm,glassheightmm,glasstype,state,time) "+ |
|---|
