• 会议OA项目（六）--- （待开会议、历史会议、所有会议）

    前言

            上一篇分享了会议通知以及会议反馈，根据需求来今天应该到了，历史会议、待开会议以及所有会议了。

    一、需求分析

    历史会议：登录人员，属于参与者列席者或者主人其中一个时，并且会议状态为已结束时，要将数据查询出来。

    待开会议：登录人员，属于参与者列席者或者主人其中一个时，并且会议状态为待开时，要将数据查询出来。

    所有会议：登录人员，属于参与者列席者或者主人其中一个时，要将数据查询出来。

    编写SQL语句

     待开会议

    1. select a.id,a.title,a.content,a.canyuze,a.liexize,a.zhuchiren 
    2. 				,b.name zhuchirenname,
    3. 				a.location,
    4. 				DATE_FORMAT(a.startTime,'%Y-%m-%d %H-%m-%s') startTime,
    5. 				DATE_FORMAT(a.endTime,'%Y-%m-%d %H-%m-%s') endTime, 
    6. 				a.state, 
    7. 				(case a.state
    8. 				when 0 then '取消会议'
    9. 				when 1 then '新建' 
    10. 				when 2 then '待审核' 
    11. 				when 3 then '驳回' 
    12. 				when 4 then '待开'
    13. 				when 5 then '进行中'
    14. 				when 6 then '开启投票' 
    15. 				when 7 then '结束会议'
    16. 				else '其他' end
    17. 				) meetingstate,
    18. 				a.seatPic,a.remark,a.auditor, 
    19. 				c.name auditorname 
    20. 				from t_oa_meeting_info a 
    21. 				inner join t_oa_user b on a.zhuchiren=b.id 
    22. 				left join t_oa_user c on a.auditor=c.id where 1=1 
    23. 				and state = 4 and FIND_IN_SET(6,CONCAT(canyuze,',',liexize,',',zhuchiren))

    所有会议

    1. ​
    2. select a.id,a.title,a.content,a.canyuze,a.liexize,a.zhuchiren 
    3. 				,b.name zhuchirenname,
    4. 				a.location,
    5. 				DATE_FORMAT(a.startTime,'%Y-%m-%d %H-%m-%s') startTime,
    6. 				DATE_FORMAT(a.endTime,'%Y-%m-%d %H-%m-%s') endTime, 
    7. 				a.state, 
    8. 				(case a.state
    9. 				when 0 then '取消会议'
    10. 				when 1 then '新建' 
    11. 				when 2 then '待审核' 
    12. 				when 3 then '驳回' 
    13. 				when 4 then '待开'
    14. 				when 5 then '进行中'
    15. 				when 6 then '开启投票' 
    16. 				when 7 then '结束会议'
    17. 				else '其他' end
    18. 				) meetingstate,
    19. 				a.seatPic,a.remark,a.auditor, 
    20. 				c.name auditorname 
    21. 				from t_oa_meeting_info a 
    22. 				inner join t_oa_user b on a.zhuchiren=b.id 
    23. 				left join t_oa_user c on a.auditor=c.id where 1=1 
    24. 				and FIND_IN_SET(6,CONCAT(a.canyuze,',',a.liexize,',',a.zhuchiren,',',IFNULL(a.auditor,-1)))
    25.  
    26. ​

    历史会议

    1. ​
    2. select a.id,a.title,a.content,a.canyuze,a.liexize,a.zhuchiren 
    3. 				,b.name zhuchirenname,
    4. 				a.location,
    5. 				DATE_FORMAT(a.startTime,'%Y-%m-%d %H-%m-%s') startTime,
    6. 				DATE_FORMAT(a.endTime,'%Y-%m-%d %H-%m-%s') endTime, 
    7. 				a.state, 
    8. 				(case a.state
    9. 				when 0 then '取消会议'
    10. 				when 1 then '新建' 
    11. 				when 2 then '待审核' 
    12. 				when 3 then '驳回' 
    13. 				when 4 then '待开'
    14. 				when 5 then '进行中'
    15. 				when 6 then '开启投票' 
    16. 				when 7 then '结束会议'
    17. 				else '其他' end
    18. 				) meetingstate,
    19. 				a.seatPic,a.remark,a.auditor, 
    20. 				c.name auditorname 
    21. 				from t_oa_meeting_info a 
    22. 				inner join t_oa_user b on a.zhuchiren=b.id 
    23. 				left join t_oa_user c on a.auditor=c.id where 1=1 
    24. 				and state = 7 and FIND_IN_SET(6,CONCAT(canyuze,',',liexize,',',zhuchiren))
    25.  
    26. ​

     二、编码

            后端：

            MeetingInfoDao

    1. package com.zking.dao;
    2.  
    3. import java.sql.SQLException;
    4. import java.util.List;
    5. import java.util.Map;
    6.  
    7. import com.zking.entity.MeetingInfo;
    8. import com.zking.util.BaseDao;
    9. import com.zking.util.PageBean;
    10. import com.zking.util.StringUtils;
    11.  
    12. public class MeetingInfoDao extends BaseDao {
    13. 	// 添加会议信息
    14. 	public int add(MeetingInfo info) throws Exception {
    15. 		String sql = "insert into t_oa_meeting_info(title,content,canyuze,liexize,zhuchiren,\r\n"
    16. 				+ "location,startTime,endTime,remark) values(?,?,?,?,?,?,?,?,?)";
    17. 		return super.executeUpdate(sql, info, new String[] { "title", "content", "canyuze", "liexize", "zhuchiren",
    18. 				"location", "startTime", "endTime", "remark" });
    19. 	}
    20. 	
    21. 	//我的会议SQL，后续其他的菜单也会使用
    22. 	private String getSQL() {
    23. 		return "select a.id,a.title,a.content,a.canyuze,a.liexize,a.zhuchiren\r\n" + 
    24. 				",b.name zhuchirenname,\r\n" + 
    25. 				"a.location,\r\n" + 
    26. 				"DATE_FORMAT(a.startTime,'%Y-%m-%d %H-%m-%s') startTime,\r\n" + 
    27. 				"DATE_FORMAT(a.endTime,'%Y-%m-%d %H-%m-%s') endTime,\r\n" + 
    28. 				"a.state,\r\n" + 
    29. 				"(\r\n" + 
    30. 				"	case a.state\r\n" + 
    31. 				"	when 0 then '取消会议'\r\n" + 
    32. 				"	when 1 then '新建'\r\n" + 
    33. 				"	when 2 then '待审核'\r\n" + 
    34. 				"	when 3 then '驳回'\r\n" + 
    35. 				"	when 4 then '待开'\r\n" + 
    36. 				"	when 5 then '进行中'\r\n" + 
    37. 				"	when 6 then '开启投票'\r\n" + 
    38. 				"	when 7 then '结束会议'\r\n" + 
    39. 				"	else '其他' end\r\n" + 
    40. 				") meetingstate,\r\n" + 
    41. 				"a.seatPic,a.remark,a.auditor,\r\n" + 
    42. 				"c.name auditorname\r\n" + 
    43. 				"from t_oa_meeting_info a\r\n" + 
    44. 				"inner join t_oa_user b on a.zhuchiren=b.id\r\n" + 
    45. 				"left join t_oa_user c on a.auditor=c.id where 1=1 ";
    46. 	}
    47. 	//我的会议
    48. 	public List> myInfos(MeetingInfo info, PageBean pageBean)
    49. 			throws SQLException, InstantiationException, IllegalAccessException {
    50. 		String sql = getSQL();
    51. 		//会议标题
    52. 		String title = info.getTitle();
    53. 		if(StringUtils.isNotBlank(title)) {
    54. 			sql+=" and title like '%"+title+"%'";
    55. 		}
    56. 		sql+=" and zhuchiren="+info.getZhuchiren();
    57. //		排序按照降序展示
    58. 		sql+=" order by a.id desc ";
    59. 		return super.executeQuery(sql, pageBean);
    60. 	}
    61.  
    62. //	设置会议排座图片
    63. 	public int updateSeatPicById(MeetingInfo info) throws Exception {
    64. 		String sql =" update t_oa_meeting_info set seatPic=? where id=?";
    65. 		return super.executeUpdate(sql, info, new String[] {"seatPic","id"});
    66. 	}
    67.  
    68. //	根据会议ID更新会议的审批人（送审）
    69. 	public int updateAuditorById(MeetingInfo info) throws Exception {
    70. 		String sql="update t_oa_meeting_info set auditor=?,state=2 where id=?";
    71. 		return super.executeUpdate(sql, info, new String[] {"auditor","id"});
    72. 	}
    73.  
    74. 	public List> myAudit(MeetingInfo info, PageBean pageBean) throws Exception {
    75. 		String sql = getSQL();
    76. 		//会议标题
    77. 		String title = info.getTitle();
    78. 		if(StringUtils.isNotBlank(title)) {
    79. 			sql+=" and title like '%"+title+"%'";
    80. 		}
    81. //		当前登录账号是会议信息表中 审批人字段值
    82. 		sql+=" and a.auditor="+info.getAuditor();
    83. //		只查询会议状态为 2 即待审核的会议
    84. 		sql+=" and state = 2 ";
    85. //		排序按照降序展示
    86. 		sql+=" order by a.id desc ";
    87. 		return super.executeQuery(sql, pageBean);
    88. 	}
    89.  
    90. //	待开会议
    91. 	public List> queryMeetingInfoByState(MeetingInfo info, PageBean pageBean) throws InstantiationException, IllegalAccessException, SQLException {
    92. 		String sql="select a.id,a.title,a.content,a.canyuze,a.liexize,a.zhuchiren \r\n" + 
    93. 				"				,b.name zhuchirenname,\r\n" + 
    94. 				"				a.location,\r\n" + 
    95. 				"				DATE_FORMAT(a.startTime,'%Y-%m-%d %H-%m-%s') startTime,\r\n" + 
    96. 				"				DATE_FORMAT(a.endTime,'%Y-%m-%d %H-%m-%s') endTime, \r\n" + 
    97. 				"				a.state, \r\n" + 
    98. 				"				(case a.state\r\n" + 
    99. 				"				when 0 then '取消会议'\r\n" + 
    100. 				"				when 1 then '新建' \r\n" + 
    101. 				"				when 2 then '待审核' \r\n" + 
    102. 				"				when 3 then '驳回' \r\n" + 
    103. 				"				when 4 then '待开'\r\n" + 
    104. 				"				when 5 then '进行中'\r\n" + 
    105. 				"				when 6 then '开启投票' \r\n" + 
    106. 				"				when 7 then '结束会议'\r\n" + 
    107. 				"				else '其他' end\r\n" + 
    108. 				"				) meetingstate,\r\n" + 
    109. 				"				a.seatPic,a.remark,a.auditor, \r\n" + 
    110. 				"				c.name auditorname \r\n" + 
    111. 				"				from t_oa_meeting_info a \r\n" + 
    112. 				"				inner join t_oa_user b on a.zhuchiren=b.id \r\n" + 
    113. 				"				left join t_oa_user c on a.auditor=c.id where 1=1 \r\n" + 
    114. 				"				and state = 4 and FIND_IN_SET("+info.getZhuchiren()+",CONCAT(canyuze,',',liexize,',',zhuchiren))";
    115. 		return super.executeQuery(sql, pageBean);
    116. 	}
    117.  
    118. //	所有会议
    119. 	public List> allInfos(MeetingInfo info, PageBean pageBean) throws InstantiationException, IllegalAccessException, SQLException {
    120. 		String sql="select a.id,a.title,a.content,a.canyuze,a.liexize,a.zhuchiren \r\n" + 
    121. 				"				,b.name zhuchirenname,\r\n" + 
    122. 				"				a.location,\r\n" + 
    123. 				"				DATE_FORMAT(a.startTime,'%Y-%m-%d %H-%m-%s') startTime,\r\n" + 
    124. 				"				DATE_FORMAT(a.endTime,'%Y-%m-%d %H-%m-%s') endTime, \r\n" + 
    125. 				"				a.state, \r\n" + 
    126. 				"				(case a.state\r\n" + 
    127. 				"				when 0 then '取消会议'\r\n" + 
    128. 				"				when 1 then '新建' \r\n" + 
    129. 				"				when 2 then '待审核' \r\n" + 
    130. 				"				when 3 then '驳回' \r\n" + 
    131. 				"				when 4 then '待开'\r\n" + 
    132. 				"				when 5 then '进行中'\r\n" + 
    133. 				"				when 6 then '开启投票' \r\n" + 
    134. 				"				when 7 then '结束会议'\r\n" + 
    135. 				"				else '其他' end\r\n" + 
    136. 				"				) meetingstate,\r\n" + 
    137. 				"				a.seatPic,a.remark,a.auditor, \r\n" + 
    138. 				"				c.name auditorname \r\n" + 
    139. 				"				from t_oa_meeting_info a \r\n" + 
    140. 				"				inner join t_oa_user b on a.zhuchiren=b.id \r\n" + 
    141. 				"				left join t_oa_user c on a.auditor=c.id where 1=1 \r\n" + 
    142. 				"				and FIND_IN_SET("+info.getZhuchiren()+",CONCAT(a.canyuze,',',a.liexize,',',a.zhuchiren,',',IFNULL(a.auditor,-1)))";
    143. 		return super.executeQuery(sql, pageBean);
    144. 	}
    145. //历史会议
    146.     public List> queryMeetingHistoryInfoByState(MeetingInfo info, PageBean pageBean) throws InstantiationException, IllegalAccessException, SQLException {
    147.       String sql = "select CONCAT(\r\n" + 
    148.           " canyuze,',',liexize,',',zhuchiren),a.id,a.title,a.content,a.canyuze,a.liexize,a.zhuchiren,\r\n" + 
    149.           " b.`name` zhuchirenname,\r\n" + 
    150.           " a.location,\r\n" + 
    151.           " DATE_FORMAT(a.startTime,'%y-%m-%d %h-%M-%s') startTime,\r\n" + 
    152.           " DATE_FORMAT(a.endTime,'%y-%m-%d %h-%M-%s') endTime,\r\n" + 
    153.           " a.state,\r\n" + 
    154.           " (\r\n" + 
    155.           "  case a.state\r\n" + 
    156.           "  when 0 then '取消会议'\r\n" + 
    157.           "  when 1 then '新建'\r\n" + 
    158.           "  when 2 then '待审核'\r\n" + 
    159.           "  when 3 then '驳回'\r\n" + 
    160.           "  when 4 then '待开'\r\n" + 
    161.           "  when 5 then '进行中'\r\n" + 
    162.           "  when 6 then '开启投票'\r\n" + 
    163.           "  when 7 then '结束'\r\n" + 
    164.           "  else '其它' end \r\n" + 
    165.           " ) meetingstate,\r\n" + 
    166.           " a.seatPic,a.remark,a.auditor,\r\n" + 
    167.           " c.`name` auditorname from t_oa_meeting_info a\r\n" + 
    168.           " inner join t_oa_user b on a.zhuchiren = b.id\r\n" + 
    169.           " left join t_oa_user c on a.auditor = c.id where 1=1\r\n" + 
    170.           " and state = 7 and FIND_IN_SET("+info.getZhuchiren()+",CONCAT(\r\n" + 
    171.           " canyuze,',',liexize,',',zhuchiren))";
    172.       return super.executeQuery(sql, pageBean);
    173.     }
    174. 	
    175. }

            MeetingInfoAction

    1. package com.zking.web;
    2.  
    3. import java.util.Date;
    4. import java.util.List;
    5. import java.util.Map;
    6. import java.util.UUID;
    7.  
    8. import javax.servlet.http.HttpServletRequest;
    9. import javax.servlet.http.HttpServletResponse;
    10.  
    11. import org.apache.commons.beanutils.ConvertUtils;
    12.  
    13. import com.zking.dao.MeetingInfoDao;
    14. import com.zking.entity.MeetingInfo;
    15. import com.zking.framework.ActionSupport;
    16. import com.zking.framework.ModelDriver;
    17. import com.zking.util.Base64ImageUtils;
    18. import com.zking.util.MyDateConverter;
    19. import com.zking.util.PageBean;
    20. import com.zking.util.PropertiesUtil;
    21. import com.zking.util.R;
    22. import com.zking.util.ResponseUtil;
    23.  
    24. public class MeetingInfoAction extends ActionSupport implements ModelDriver{
    25. 	private MeetingInfo info = new MeetingInfo();
    26. 	private MeetingInfoDao infoDao = new MeetingInfoDao();
    27.  
    28. 	@Override
    29. 	public MeetingInfo getModel() {
    30. //		注册一个转换器
    31. 		ConvertUtils.register(new MyDateConverter(), Date.class);
    32. 		return info;
    33. 	}
    34.  
    35. 	public String add(HttpServletRequest req, HttpServletResponse resp) {
    36. 		try {
    37. //			rs是sql语句执行的影响行数
    38. 			int rs = infoDao.add(info);
    39. 			if(rs > 0) {
    40. 				ResponseUtil.writeJson(resp, R.ok(200, "会议信息数据新增成功"));
    41. 			}else {
    42. 				ResponseUtil.writeJson(resp, R.error(0, "会议信息数据新增失败"));
    43. 			}
    44. 			
    45. 		} catch (Exception e) {
    46. 			e.printStackTrace();
    47. 			try {
    48. 				ResponseUtil.writeJson(resp, R.error(0, "会议信息数据新增失败"));
    49. 			} catch (Exception e1) {
    50. 				e1.printStackTrace();
    51. 			}
    52. 		}
    53. 		return null;
    54. 	}
    55. 	
    56. //	我的会议
    57. 	public String myInfos(HttpServletRequest req, HttpServletResponse resp) {
    58. 		try {
    59. 			PageBean pageBean = new PageBean();
    60. 			pageBean.setRequest(req);
    61. 			List> list = infoDao.myInfos(info, pageBean);
    62. //			注意：layui中的数据表格的格式
    63. 			ResponseUtil.writeJson(resp, R.ok(0, "我的会议数据查询成功" , pageBean.getTotal(), list));
    64. 		} catch (Exception e) {
    65. 			e.printStackTrace();
    66. 			try {
    67. 				ResponseUtil.writeJson(resp, R.error(0, "我的会议数据查询失败"));
    68. 			} catch (Exception e1) {
    69. 				e1.printStackTrace();
    70. 			}
    71. 		}
    72. 		return null;
    73. 	}
    74. 	
    75. 	
    76. //	我的审批
    77. 	public String myAudit(HttpServletRequest req, HttpServletResponse resp) {
    78. 		try {
    79. 			PageBean pageBean = new PageBean();
    80. 			pageBean.setRequest(req);
    81. 			List> infos = infoDao.myAudit(info, pageBean);
    82. 			ResponseUtil.writeJson(resp, R.ok(0, "我的审批查询成功", pageBean.getTotal(), infos));
    83. 		} catch (Exception e) {
    84. 			e.printStackTrace();
    85. 			try {
    86. 				ResponseUtil.writeJson(resp, R.error(0, "我的审批查询失败"));
    87. 			} catch (Exception e1) {
    88. 				e1.printStackTrace();
    89. 			}
    90. 		}
    91. 		return null;
    92. 	}
    93. 	
    94. //	取消会议
    95. 	public String del(HttpServletRequest req, HttpServletResponse resp) {
    96. 		try {
    97. 			PageBean pageBean = new PageBean();
    98. 			pageBean.setRequest(req);
    99. 			int upd = infoDao.updateState(info);
    100. //			注意：layui中的数据表格的格式
    101. 			if(upd > 0) {
    102. 				ResponseUtil.writeJson(resp, R.ok(200, "会议取消成功"));
    103. 			}else {
    104. 				ResponseUtil.writeJson(resp, R.error(0, "会议取消失败"));
    105. 			}
    106. 					} catch (Exception e) {
    107. 			e.printStackTrace();
    108. 			try {
    109. 				ResponseUtil.writeJson(resp, R.error(0, "会议取消失败"));
    110. 			} catch (Exception e1) {
    111. 				e1.printStackTrace();
    112. 			}
    113. 		}
    114. 		return null;
    115. 	}
    116. 	
    117. 	
    118. 	
    119. //	根据会议id更新排座
    120. 	public String updateSeatPicById(HttpServletRequest req,
    121. 			HttpServletResponse resp) throws Exception{
    122. 		try {
    123. 			//1.将排座图片保存到指定的位置并得到图片路径
    124. 			//1) 定义会议图片的保存路径
    125. 			String serverPath=PropertiesUtil.getValue("serverPath");
    126. 			String dirPath=PropertiesUtil.getValue("dirPath");
    127. 			//2) 定义会议排座图片的名称(最终要保存到数据库表中)，例如：/uploads/xxxxx.jpg
    128. 			String fileName=UUID.randomUUID().toString().replace("-", "")+".jpg";
    129. 			//3) 拼接成完整的路径
    130. 			String realPath=dirPath+fileName;
    131. 			//4) 将图片保存到指定位置
    132. 			Base64ImageUtils.GenerateImage(info.getSeatPic().replace("data:image/png;base64,",""), realPath);
    133. 			
    134. 			//2.根据会议ID修改会议图片信息
    135. 			info.setSeatPic(serverPath+fileName);
    136. 			infoDao.updateSeatPicById(info);
    137. 			ResponseUtil.writeJson(resp, R.ok(200, "更新会议的排座图片成功"));
    138. 		} catch (Exception e) {
    139. 			e.printStackTrace();
    140. 			try {
    141. 				ResponseUtil.writeJson(resp, R.error(0, "更新会议的排座图片失败"));
    142. 			} catch (Exception e1) {
    143. 				e1.printStackTrace();
    144. 			}
    145. 		}
    146. 		return null;
    147. 	}
    148. 	
    149. //	根据会议ID更新会议的审批人（送审）
    150. 	public String updateAuditorById(HttpServletRequest req, HttpServletResponse resp) {
    151. 		try {
    152. 			int rs = infoDao.updateAuditorById(info);
    153. 			if (rs > 0) {
    154. 				ResponseUtil.writeJson(resp, R.ok(200, "会议审批成功"));
    155. 			}else {
    156. 				ResponseUtil.writeJson(resp, R.error(0, "会议审批失败"));
    157. 			}
    158. 		} catch (Exception e) {
    159. 			e.printStackTrace();
    160. 			try {
    161. 				ResponseUtil.writeJson(resp, R.error(0, "会议审批失败"));
    162. 			} catch (Exception e1) {
    163. 				e1.printStackTrace();
    164. 			}
    165. 		}
    166. 		return null;
    167. 	}
    168. 	 // 历史会议
    169. 	  public String queryMeetingHistoryInfoByState(HttpServletRequest req, HttpServletResponse resp) {
    170. 	    try {
    171. 	      PageBean pageBean = new PageBean();
    172. 	      pageBean.setRequest(req);
    173. 	      List> infos = infoDao.queryMeetingHistoryInfoByState(info, pageBean);
    174. 	      ResponseUtil.writeJson(resp, R.ok(0, "历史会议查询成功！！！", pageBean.getTotal(), infos));
    175. 	    } catch (Exception e) {
    176. 	      e.printStackTrace();
    177. 	      try {
    178. 	        ResponseUtil.writeJson(resp, R.error(0, "历史会议查询失败！！！"));
    179. 	      } catch (Exception e1) {
    180. 	        e1.printStackTrace();
    181. 	      }
    182. 	    }
    183. 	    return null;
    184. 	  }
    185. 	  
    186. 	  
    187. 	  public String queryMeetingInfoByState(HttpServletRequest req, HttpServletResponse resp) {
    188. 			try {
    189. 				PageBean pageBean = new PageBean();
    190. 				pageBean.setRequest(req);
    191. 				List> infos = infoDao.queryMeetingInfoByState(info, pageBean);
    192. 				ResponseUtil.writeJson(resp, R.ok(0, "会议查询成功！！！", pageBean.getTotal(), infos));
    193. 			} catch (Exception e) {
    194. 				e.printStackTrace();
    195. 				try {
    196. 					ResponseUtil.writeJson(resp, R.error(0, "会议查询失败"));
    197. 				} catch (Exception e1) {
    198. 					e1.printStackTrace();
    199. 				}
    200. 			}
    201. 			return null;
    202. 		}
    203. 	
    204. 	  
    205. 	  public String allInfos(HttpServletRequest req, HttpServletResponse resp) {
    206. 			try {
    207. 				PageBean pageBean = new PageBean();
    208. 				pageBean.setRequest(req);
    209. 				List> infos = infoDao.allInfos(info, pageBean);
    210. 				ResponseUtil.writeJson(resp, R.ok(0, "会议查询成功！！！", pageBean.getTotal(), infos));
    211. 			} catch (Exception e) {
    212. 				e.printStackTrace();
    213. 				try {
    214. 					ResponseUtil.writeJson(resp, R.error(0, "会议查询失败"));
    215. 				} catch (Exception e1) {
    216. 					e1.printStackTrace();
    217. 				}
    218. 			}
    219. 			return null;
    220. 		}
    221.  
    222. }

            前端：

            meetingAll.jsp

    1. <%@ page language="java" contentType="text/html; charset=UTF-8"
    2.     pageEncoding="UTF-8"%>
    3. <%@include file="/common/header.jsp"%>
    4. html>
    5. <html>
    6. <head>
    7. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    8. <script type="text/javascript" src="${pageContext.request.contextPath }/static/js/meeting/meetingAll.js">script>
    9. head>
    10. <style>
    11. body{
    12. 	margin:15px;
    13. }
    14. .layui-table-cell {height: inherit;}
    15. .layui-layer-page .layui-layer-content {  overflow: visible !important;}
    16. style>
    17. <body>
    18. 	<div class="layui-form-item">
    19. 		<div class="layui-inline">
    20. 			<label class="layui-form-label">会议标题：label>
    21. 			<div class="layui-input-inline">
    22. 				<input type="hidden" id="userid" value="${sessionScope.user.id }"/>
    23. 				<input type="text" id="title" autocomplete="off"
    24. 					class="layui-input">
    25. 			div>
    26. 		div>
    27. 		<div class="layui-inline">
    28. 			<button id="btn_meeting_search" class="layui-btn layui-btn-normal">
    29. 				<i class="layui-icon">i> 查询
    30. 			button>
    31. 		div>
    32. 	div>
    33. 	<table style="margin-top: -15px;" id="tb_meeting" lay-filter="tb_meeting">table>
    34. body>
    35. html>

            meetingAll.js

    1. let layer,form,table,$;
    2. var row;
    3. layui.use(['layer','form','table'],function(){
    4.     layer=layui.layer,form=layui.form,table=layui.table,$=layui.jquery;
    5.     
    6.     //初始化会议列表
    7.     initMeeting();
    8.    
    9.     //绑定查询按钮的点击事件
    10.     $('#btn_meeting_search').click(function(){
    11.         query();
    12.     });
    13. });
    14.  
    15. //1.初始化会议列表
    16. function initMeeting(){
    17.     table.render({           //执行渲染
    18.         elem: '#tb_meeting',   //指定原始表格元素选择器（推荐id选择器）
    19.         height: 400,         //自定义高度
    20.         loading: false,      //是否显示加载条（默认 true）
    21.         cols: [[             //设置表头
    22.             {field: 'title', title: '会议标题', width: 180},
    23.             {field: 'location', title: '会议地点', width: 120},
    24.             {field: 'startTime', title: '开始时间', width: 180},
    25.             {field: 'endTime', title: '结束时间', width: 180},
    26.             {field: 'meetingState', title: '会议状态', width: 90},
    27.             {field: 'name', title: '主持人', width: 120},
    28.             //{field: '', title: '操作', width: 260, toolbar: '#tbMeeting'}
    29.         ]]
    30.     });
    31. }
    32.  
    33. //2.查询所有会议
    34. function query(){
    35.     table.reload('tb_meeting', {
    36.         url: 'info.action',     //请求地址
    37.         method: 'POST',                    //请求方式，GET或者POST
    38.         loading: true,                     //是否显示加载条（默认 true）
    39.         page: true,                        //是否分页
    40.         where: {                           //设定异步数据接口的额外参数，任意设
    41.             'methodName':'allInfos',
    42.             'title':$('#title').val(),
    43.             'zhuchiren':$('#userid').val()
    44.         },
    45.         request: {                         //自定义分页请求参数名
    46.             pageName: 'page', //页码的参数名称，默认：page
    47.             limitName: 'rows' //每页数据量的参数名，默认：limit
    48.         },
    49.         done: function (res, curr, count) {
    50.             //查询完成的回调函数
    51.         }
    52.     });
    53. }

            meetingWaiting.jsp

    1. <%@ page language="java" contentType="text/html; charset=UTF-8"
    2.     pageEncoding="UTF-8"%>
    3. <%@include file="/common/header.jsp"%>
    4. html>
    5. <html>
    6. <head>
    7. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    8. <script type="text/javascript" src="${pageContext.request.contextPath }/static/js/meeting/meetingWaiting.js">script>
    9. head>
    10. <style>
    11. body{
    12. 	margin:15px;
    13. }
    14. .layui-table-cell {height: inherit;}
    15. .layui-layer-page .layui-layer-content {  overflow: visible !important;}
    16. style>
    17. <body>
    18. 	<div class="layui-form-item">
    19. 		<div class="layui-inline">
    20. 			<label class="layui-form-label">会议标题：label>
    21. 			<div class="layui-input-inline">
    22. 				<input type="hidden" id="userid" value="${sessionScope.user.id }"/>
    23. 				<input type="text" id="title" autocomplete="off"
    24. 					class="layui-input">
    25. 			div>
    26. 		div>
    27. 		<div class="layui-inline">
    28. 			<button id="btn_meeting_search" class="layui-btn layui-btn-normal">
    29. 				<i class="layui-icon">i> 查询
    30. 			button>
    31. 		div>
    32. 	div>
    33. 	<table style="margin-top: -15px;" id="tb_meeting" lay-filter="tb_meeting">table>
    34. body>
    35. html>

            meetingWaiting.js

    1. let layer,form,table,$;
    2. var row;
    3. layui.use(['layer','form','table'],function(){
    4.     layer=layui.layer,form=layui.form,table=layui.table,$=layui.jquery;
    5.     
    6.     //初始化会议列表
    7.     initMeeting();
    8.    
    9.     //绑定查询按钮的点击事件
    10.     $('#btn_meeting_search').click(function(){
    11.         query();
    12.     });
    13. });
    14.  
    15. //1.初始化会议列表
    16. function initMeeting(){
    17.     table.render({           //执行渲染
    18.         elem: '#tb_meeting',   //指定原始表格元素选择器（推荐id选择器）
    19.         height: 400,         //自定义高度
    20.         loading: false,      //是否显示加载条（默认 true）
    21.         cols: [[             //设置表头
    22.             {field: 'title', title: '会议标题', width: 180},
    23.             {field: 'location', title: '会议地点', width: 120},
    24.             {field: 'startTime', title: '开始时间', width: 180},
    25.             {field: 'endTime', title: '结束时间', width: 180},
    26.             {field: 'meetingstate', title: '会议状态', width: 90},
    27.             {field: 'auditorname', title: '主持人', width: 120},
    28.             //{field: '', title: '操作', width: 260, toolbar: '#tbMeeting'}
    29.         ]]
    30.     });
    31. }
    32.  
    33. //2.待开会议
    34. function query(){
    35.     table.reload('tb_meeting', {
    36.         url: 'info.action',     //请求地址
    37.         method: 'POST',                    //请求方式，GET或者POST
    38.         loading: true,                     //是否显示加载条（默认 true）
    39.         page: true,                        //是否分页
    40.         where: {                           //设定异步数据接口的额外参数，任意设
    41.             'methodName':'queryMeetingInfoByState',
    42.             'title':$('#title').val(),
    43.             'zhuchiren':$('#userid').val(),
    44.             'state':4
    45.         },
    46.         request: {                         //自定义分页请求参数名
    47.             pageName: 'page', //页码的参数名称，默认：page
    48.             limitName: 'rows' //每页数据量的参数名，默认：limit
    49.         },
    50.         done: function (res, curr, count) {
    51.             //查询完成的回调函数
    52.         }
    53.     });
    54. }

            meetingHistory.jsp

    1. <%@ page language="java" contentType="text/html; charset=UTF-8"
    2.     pageEncoding="UTF-8"%>
    3. <%@include file="/common/header.jsp"%>
    4. html>
    5. <html>
    6. <head>
    7. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    8. <script type="text/javascript" src="${pageContext.request.contextPath }/static/js/meeting/meetingHistory.js">script>
    9. head>
    10. <style>
    11. history
    12. body{
    13. 	margin:15px;
    14. }
    15. .layui-table-cell {height: inherit;}
    16. .layui-layer-page .layui-layer-content {  overflow: visible !important;}
    17. style>
    18. <body>
    19. 	<div class="layui-form-item">
    20. 		<div class="layui-inline">
    21. 			<label class="layui-form-label">会议标题：label>
    22. 			<div class="layui-input-inline">
    23. 				<input type="hidden" id="userid" value="${sessionScope.user.id }"/>
    24. 				<input type="text" id="title" autocomplete="off"
    25. 					class="layui-input">
    26. 			div>
    27. 		div>
    28. 		<div class="layui-inline">
    29. 			<button id="btn_meeting_search" class="layui-btn layui-btn-normal">
    30. 				<i class="layui-icon">i> 查询
    31. 			button>
    32. 		div>
    33. 	div>
    34. 	<table style="margin-top: -15px;" id="tb_meeting" lay-filter="tb_meeting">table>
    35. body>
    36. html>

            meetingHistory.js

    1. let layer,form,table,$;
    2. var row;
    3. layui.use(['layer','form','table'],function(){
    4.     layer=layui.layer,form=layui.form,table=layui.table,$=layui.jquery;
    5.     
    6.     //初始化会议列表
    7.     initMeeting();
    8.    
    9.     //绑定查询按钮的点击事件
    10.     $('#btn_meeting_search').click(function(){
    11.         query();
    12.     });
    13. });
    14.  
    15. //1.初始化会议列表
    16. function initMeeting(){
    17.     table.render({           //执行渲染
    18.         elem: '#tb_meeting',   //指定原始表格元素选择器（推荐id选择器）
    19.         height: 400,         //自定义高度
    20.         loading: false,      //是否显示加载条（默认 true）
    21.         cols: [[             //设置表头
    22.             {field: 'title', title: '会议标题', width: 180},
    23.             {field: 'location', title: '会议地点', width: 120},
    24.             {field: 'startTime', title: '开始时间', width: 180},
    25.             {field: 'endTime', title: '结束时间', width: 180},
    26.             {field: 'meetingstate', title: '会议状态', width: 90},
    27.             {field: 'auditorname', title: '主持人', width: 120},
    28.             //{field: '', title: '操作', width: 260, toolbar: '#tbMeeting'}
    29.         ]]
    30.     });
    31. }
    32.  
    33. //2.待开会议
    34. function query(){
    35.     table.reload('tb_meeting', {
    36.         url: 'info.action',     //请求地址
    37.         method: 'POST',                    //请求方式，GET或者POST
    38.         loading: true,                     //是否显示加载条（默认 true）
    39.         page: true,                        //是否分页
    40.         where: {                           //设定异步数据接口的额外参数，任意设
    41.             'methodName':'queryMeetingHistoryInfoByState',
    42.             'title':$('#title').val(),
    43.             'zhuchiren':$('#userid').val(),
    44.             'state':4
    45.         },
    46.         request: {                         //自定义分页请求参数名
    47.             pageName: 'page', //页码的参数名称，默认：page
    48.             limitName: 'rows' //每页数据量的参数名，默认：limit
    49.         },
    50.         done: function (res, curr, count) {
    51.             //查询完成的回调函数
    52.         	console.log(res);
    53.         }
    54.     });
    55. }

    三、运行效果

            

     

     

     

  • 相关阅读:
    OpenCV学习笔记-环境搭建
    91. 存钱罐
    IIS短文件名泄露漏洞复现
    基于Matlab实现多个图像去噪案例（附上源码+数据集）
    Ground Truth
    sharding分片键 groovy公式带有非数字字符启动失败
    maven本地仓库同步上传到nexus远程仓库
    python使用appium打开程序后，为什么没有操作后程序就自动退出了
    服务访问质量（QoS）介绍与技术 二
    C++输入输出总结
  • 原文地址：https://blog.csdn.net/qq_62331938/article/details/126078583