Merge remote-tracking branch 'origin/master'
| | |
| | | |
| | | @ApiModelProperty(value = "当前页", example = "1", required = true) |
| | | private Long currentPage; |
| | | |
| | | @ApiModelProperty(value = "每页多少条", example = "10", required = true) |
| | | private Long pageSize; |
| | | |
| | | @ApiModelProperty(value = "计划单号", required = false) |
| | | private String plannedOrderNumber; |
| | | } |
| | |
| | | from metering_plan |
| | | where 1=1 |
| | | <if test="dto.plannedOrderNumber!=null and dto.plannedOrderNumber!=''"> |
| | | and planned_order_number=#{plannedOrderNumber} |
| | | and planned_order_number like concat('%',#{dto.plannedOrderNumber},'%') |
| | | </if> |
| | | LIMIT #{limitPage.start},#{limitPage.end}) p |
| | | LEFT JOIN metrical_information i ON p.id = i.plan |
| | |
| | | <select id="getTotal" resultType="java.util.Map"> |
| | | select count(id) num from metering_plan where 1=1 |
| | | <if test="dto.plannedOrderNumber!=null and dto.plannedOrderNumber!=''"> |
| | | and planned_order_number=#{plannedOrderNumber} |
| | | and planned_order_number like concat('%',#{dto.plannedOrderNumber},'%') |
| | | </if> |
| | | </select> |
| | | <select id="getPlanMeasureInstrument" |
| | |
| | | )); |
| | | }); |
| | | if(roleMenuList.size()<1){ |
| | | roleMenuList.add(new RoleMenu(null,nextId,39L,false,false,false,false,createTime)); |
| | | roleMenuList.add(new RoleMenu(null,nextId,39L,true,false,false,false,createTime)); |
| | | } |
| | | //roleMenuAddList.forEach(System.out::println); |
| | | int i = roleManageMapper.insertBatchRoleMenu(roleMenuList); |
| | |
| | | from menu |
| | | where state = 1 |
| | | and id != 39 |
| | | and parent_id != 39 |
| | | and parent_id != 39 |
| | | </select> |
| | | <select id="getMenuNameAndId" resultType="map"> |
| | | select url, id, name |