Layui实现二级数据表格

1.html代码

详细参考layui官网文档

注意 table标签的id 和lay-filter 必须填写 后面做查询要用到

url 请求数据 接口

https://layui.itze.cn/doc/modules/table.html#parseTablela

  
学院名称
学院人数
已分配人数
未分配人数
操作
状态
男
女
男
女
男
女

2.js代码 (不做查询可不要)

 form.on('submit(datagrid-query)', function(data) {table.reload('datagrid', {page: {curr: 1},where : {// 查询条件传值xqdm : $('#xqdm').val(),ssqdm : $('#ssqdm').val(),sslmc : $('#sslmc').val()}},'data')return false;});

3.java代码

controller

package vip.jzbao.dhu.pc.controller.dorm;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import vip.jzbao.dhu.common.dto.LayuiGrid;
import vip.jzbao.dhu.common.student.dto.StudentRoomAllotDto;
import vip.jzbao.dhu.common.student.service.IStudentRoomCarefulService;
import java.util.List;/*** 学院宿舍资源分配情况*/
@Controller
@RequestMapping("/dorm/allot")
@PreAuthorize("hasAuthority('dorm:allot')")
public class AllotController {@Autowiredprivate IStudentRoomCarefulService studentRoomCarefulService;@GetMapping("/list")public void list() {}@GetMapping("/add")public void add() {}@PostMapping("/queryList")@ResponseBodypublic List queryList() {return studentRoomCarefulService.queryList();}@ResponseBody@RequestMapping("/page")public LayuiGrid selectPage(Page page) {Page pages = studentRoomCarefulService.selectStudentRoomAllot(page);return new LayuiGrid(pages);}}

service

package vip.jzbao.dhu.common.student.service;import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import vip.jzbao.dhu.common.student.dto.StudentNewDormDto;
import vip.jzbao.dhu.common.student.dto.StudentRoomAllotDto;
import vip.jzbao.dhu.common.student.entity.StudentRoomCareful;
import com.baomidou.mybatisplus.extension.service.IService;import java.util.List;/*** 
*  服务类* 
** @author 唐小恕* @since 2022-03-04*/
public interface IStudentRoomCarefulService extends IService {/*** 新生住宿信息* @param page* @return*/Page selectStudentNewDorm(Page page);/*** 查询学生宿舍分配* @param page* @return*/Page selectStudentRoomAllot(Page page);List queryList();/*** 新生住宿情况 导出* @return*/List queryNewList();
}

serviceImpl

package vip.jzbao.dhu.pc.controller.dorm;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import vip.jzbao.dhu.common.dto.LayuiGrid;
import vip.jzbao.dhu.common.student.dto.StudentRoomAllotDto;
import vip.jzbao.dhu.common.student.service.IStudentRoomCarefulService;
import java.util.List;/*** 学院宿舍资源分配情况*/
@Controller
@RequestMapping("/dorm/allot")
@PreAuthorize("hasAuthority('dorm:allot')")
public class AllotController {@Autowiredprivate IStudentRoomCarefulService studentRoomCarefulService;@GetMapping("/list")public void list() {}@GetMapping("/add")public void add() {}@PostMapping("/queryList")@ResponseBodypublic List queryList() {return studentRoomCarefulService.queryList();}@ResponseBody@RequestMapping("/page")public LayuiGrid selectPage(Page page) {Page pages = studentRoomCarefulService.selectStudentRoomAllot(page);return new LayuiGrid(pages);}}

mapper

package vip.jzbao.dhu.common.student.mapper;import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;
import vip.jzbao.dhu.common.student.dto.StudentNewDormDto;
import vip.jzbao.dhu.common.student.dto.StudentRoomAllotDto;
import vip.jzbao.dhu.common.student.entity.StudentRoomCareful;
import org.apache.ibatis.annotations.Mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;import java.util.List;/*** 
*  Mapper 接口* 
** @author 唐小恕* @since 2022-03-04*/
@Mapper
public interface StudentRoomCarefulMapper extends BaseMapper {@Select("select  c.fprq , c.xq,c.ssl,c.lc,c.fjh,s.cwh,c.xh,c.xm,c.pycc,c.yx,c.zy,c.bj,c.stay " +"from student_room_careful  c left join student_stay s  on  c.xsbh = s.xsbh")Page selectStudentNewDorm(Page page);@Select("SELECT\n" +"yx,\n" +"COUNT( CASE WHEN XB = '男' THEN '男' END ) MAN,\n" +"count( CASE WHEN xb = '女' THEN '女' END ) woman,\n" +"COUNT( CASE WHEN stay = '1' AND XB = '男' THEN '1' END ) manacd,\n" +"COUNT( CASE WHEN stay = '1' AND XB = '女' THEN '1' END ) womanacd,\n" +"COUNT( CASE WHEN stay = '0' AND XB = '男' THEN '0' END ) mannacd,\n" +"COUNT( CASE WHEN stay = '0' AND XB = '女' THEN '0' END ) womannacd \n" +"FROM\n" +"student_room_careful \n" +"GROUP BY\n" +"yx")Page selectStudentRoomAllot(Page page);@Select("SELECT\n" +"yx,\n" +"COUNT( CASE WHEN XB = '男' THEN '男' END ) MAN,\n" +"count( CASE WHEN xb = '女' THEN '女' END ) woman,\n" +"COUNT( CASE WHEN stay = '1' AND XB = '男' THEN '1' END ) manacd,\n" +"COUNT( CASE WHEN stay = '1' AND XB = '女' THEN '1' END ) womanacd,\n" +"COUNT( CASE WHEN stay = '0' AND XB = '男' THEN '0' END ) mannacd,\n" +"COUNT( CASE WHEN stay = '0' AND XB = '女' THEN '0' END ) womannacd \n" +"FROM\n" +"student_room_careful \n" +"GROUP BY\n" +"yx")List queryList();@Select("select  c.fprq , c.xq,c.ssl,c.lc,c.fjh,s.cwh,c.xh,c.xm,c.pycc,c.yx,c.zy,c.bj,c.stay " +"from student_room_careful  c left join student_stay s  on  c.xsbh = s.xsbh")List queryNewList();
}

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！