| | |
|---|
| | | |
|---|
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
|---|
| | | import com.example.springboot.entity.GlassInfo; |
|---|
| | | import com.example.springboot.entity.RolePermission; |
|---|
| | | |
|---|
| | | |
|---|
| | | import org.apache.ibatis.annotations.*; |
|---|
| | | import org.springframework.stereotype.Repository; |
|---|
| | | |
|---|
| | | import java.util.List; |
|---|
| | | import java.util.Map; |
|---|
| | | |
|---|
| | | @Mapper |
|---|
| | | @Repository |
|---|
| | | public interface GlassInfoMapper extends BaseMapper<GlassInfo> { |
|---|
| | | |
|---|
| | | @Select("SELECT * FROM glassinfo where width<=#{maxwidth} and width>=#{minwidth} and height<=#{maxheight} and height>=#{minheight} and measurenumber<number") |
|---|
| | | List<GlassInfo> selectGlassInfos(@Param("maxwidth") double maxwidth, @Param("minwidth") double minwidth, @Param("maxheight") double maxheight, @Param("minheight") double minheight); |
|---|
| | | @Select("select gi.* from flowcard as fd LEFT JOIN glassinfo as gi on fd.flowcard=gi.flowcard where fd.orderstate=1 and gi.flowcard is not null and gi.width<=#{maxwidth} and gi.width>=#{minwidth} and gi.height<=#{maxheight} and gi.height>=#{minheight} and gi.films=#{Films} and gi.thickness>=#{Thickness}") |
|---|
| | | List<GlassInfo> selectGlassInfos(@Param("maxwidth") double maxwidth, @Param("minwidth") double minwidth, @Param("maxheight") double maxheight, @Param("minheight") double minheight,Integer Thickness,String Films); |
|---|
| | | |
|---|
| | | // @Select("SELECT COUNT(*) FROM role_permission WHERE role_id = #{roleId} AND permission_id = #{permissionId}") |
|---|
| | | // boolean checkExists(@Param("roleId") int roleId, @Param("permissionId") int permissionId); |
|---|
| | | |
|---|
| | | // @Select("SELECT g.* FROM flowcard as f left join glassinfo as g on f.flowcard=g.flowcard WHERE f.orderstate = #{orderstate} and state!=2 and g.number>measurenumber") |
|---|
| | | @Select("SELECT g.flowcard,g.mateid,g.tier,g.films,g.width,g.height,g.thickness,g.number,(g.number-g.measurenumber)as measurenumber FROM flowcard as f left join glassinfo as g on f.flowcard=g.flowcard WHERE f.orderstate = 1 and state!=2 and g.number>measurenumber") |
|---|
| | | List<GlassInfo> selectOrderState(@Param("orderstate") int orderstate); |
|---|
| | | |
|---|
| | | @Update("UPDATE glassinfo SET measurenumber = measurenumber+1 WHERE id = #{id}") |
|---|
| | | void updatemeasurenumber(@Param("id") int roleId); |
|---|
| | | @Update("UPDATE glassinfo SET measurenumber = measurenumber-1 WHERE glasstype = #{glasstype}") |
|---|
| | | void updateGlassNumber(@Param("glasstype") int glasstype); |
|---|
| | | |
|---|
| | | // @Insert("INSERT INTO role_permission (role_id, permission_id, state) VALUES (#{roleId}, #{permissionId}, #{state})") |
|---|
| | | // void insert(@Param("roleId") int roleId, @Param("permissionId") int permissionId, @Param("state") int state); |
|---|
