• OA项目之待开会议&历史会议&所有会议

    目录

    一、待开会议&所有会议SQL编写

    1.待开会议SQL编写 

    2.所有会议SQL编写 

     二、待开会议及所有会议功能开发

    一、待开会议&所有会议SQL编写

    待开会议：
    当前登录账号，只要是 某会议 的参与者、列席者、主持人中的一员，并且会议状态是待开，则查询出来

    1. -- 待开会议
    2. -- 与我的会议的区别在于，待开会议需要匹配3个数据库列段
    3. select a.id,a.title,a.content,a.canyuze,a.liexize,a.zhuchiren
    4. ,b.`name` zhuchirennmae,
    5. a.location,
    6. DATE_FORMAT(a.startTime,'%Y-%m-%d %H-%m-%s') startTime,
    7. DATE_FORMAT(a.endTime,'%Y-%m-%d %H-%m-%s') endTime,
    8. a.state,
    9. (
    10. 	case a.state
    11. 	when 0 then '取消会议'
    12. 	when 1 then '新建'
    13. 	when 2 then '待审核'
    14. 	when 3 then '驳回'
    15. 	when 4 then '待开'
    16. 	when 5 then '进行中'
    17. 	when 6 then '开始投票'
    18. 	when 7 then '结束会议'
    19. 	else '其他' end
    20. ) meetingstate,
    21. a.seatPic,a.remark,a.auditor,
    22. c.`name` auditorname from t_oa_meeting_info a 
    23. inner join t_oa_user b on a.zhuchiren=b.id
    24. left join t_oa_user c on a.auditor=c.id where 1=1


    历史会议：当前登录账号，只要是 某会议 的参与者、列席者、主持人中的一员，并且会议状态是结束，则查询出来


    所有会议：
    当前登录账号，只要是 某会议 的参与者、列席者、主持人、审批人中的一员，那么必须查询出来

    1.待开会议SQL编写 

    1. select CONCAT(canyuze,',',liexize,',',zhuchiren),a.id,a.title,a.content,a.canyuze,a.liexize,a.zhuchiren
    2. ,b.`name` zhuchirennmae,
    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. (
    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 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))
    24.

    2.所有会议SQL编写 

     假设id为6的用户，是会议A的列席人员，会议A又处于新建状态，意味着没有审批人，这条数据一定要查询出来 

    最终的所有会议SQL语句：

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

     错误示范如图所示：

     二、待开会议及所有会议功能开发

    先运行我们的待开会议和所有会议项目如图所示：

    缺失这两个jsp代码块注意路径问题，还有我们的js代码块

    -----------------

    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: 'zhuchirennmae', 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: 'zhuchirennmae', 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. }

    我们先写待开会议如图所示：

    现在目前没有数据因为我们还没有写我们的后台的方法 

    接着写所有会议如图所示 

    现在目前没有数据因为我们还没有写我们的后台的方法 

     

    MeetingInfoAction.java代码块：

    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<MeetingInfo>{
    25.  
    26. 	private MeetingInfo info = new MeetingInfo();
    27. 	private MeetingInfoDao infoDao = new MeetingInfoDao();
    28. 	
    29. 	@Override
    30. 	public MeetingInfo getModel() {
    31. //		注册一个转换器
    32. 		ConvertUtils.register(new MyDateConverter(), Date.class);
    33. 		return info;
    34. 	}
    35. 	
    36. 	
    37. 	public String updateSeatPicById(HttpServletRequest req, HttpServletResponse resp) {
    38. 		try {
    39. //			E:/temp/images/T280/abcdefg.png
    40. //			获取图片的存放地址 		dirPath=/temp/images/T280/
    41. 			String dirPath = PropertiesUtil.getValue("dirPath");
    42. //			获取浏览器请求路径，为了后续保存到数据库   serverPath=/upload/paizuo/
    43. 			String serverPath = PropertiesUtil.getValue("serverPath");
    44. //			随机生成一个图片名称
    45. 			String fileName=UUID.randomUUID().toString().replace("-", "")+".png";
    46. 			info.getSeatPic();// 图片字符串
    47. 			Base64ImageUtils.GenerateImage(info.getSeatPic().replaceAll("data:image/png;base64", ""), dirPath+fileName);
    48. 		
    49. //			将seatPic中的内容修改为  请求地址
    50. 			info.setSeatPic(serverPath+fileName);
    51. 			
    52. //			修改会议排座  数据库 图片 对应的 数据库列段
    53. 			int rs = infoDao.updateSeatPicById(info);
    54. 			if(rs>0) {
    55. 				ResponseUtil.writeJson(resp, R.ok(200, "会议排座成功"));
    56. 			}
    57. 			else {
    58. 				ResponseUtil.writeJson(resp, R.ok(0, "会议排座失败"));
    59. 			}
    60. 		} catch (Exception e) {
    61. 			e.printStackTrace();
    62. 			try {
    63. 				ResponseUtil.writeJson(resp, R.error(0, "会议排座失败"));
    64. 			} catch (Exception e1) {
    65. 				// TODO Auto-generated catch block
    66. 				e1.printStackTrace();
    67. 			}
    68. 		 finally {
    69. }}
    70. 		return null;
    71. 	}
    72.  
    73. //	会议送审
    74. 	public String updateAuditorById(HttpServletRequest req, HttpServletResponse resp) {
    75. 		try {
    76. //			n是sql语句执行的影响行数
    77. 			int n=infoDao.updateAuditorById(info);
    78. //			如果大于0说明可以新增
    79. 			if(n>0) {
    80. 				ResponseUtil.writeJson(resp, R.ok(200, "会议送审成功"));
    81. 			}
    82. 			else {
    83. 				ResponseUtil.writeJson(resp, R.ok(0, "会议送审失败"));
    84. 			}
    85. 		} catch (Exception e) {
    86. 			e.printStackTrace();
    87. 			try {
    88. 				ResponseUtil.writeJson(resp, R.error(0, "会议送审失败"));
    89. 			} catch (Exception e1) {
    90. 				// TODO Auto-generated catch block
    91. 				e1.printStackTrace();
    92. 			}
    93. 		}
    94. 		return null;
    95. 	}
    96. 	
    97. 	public String add(HttpServletRequest req, HttpServletResponse resp) {
    98. 		try {
    99. //			n是sql语句执行的影响行数
    100. 			int n=infoDao.add(info);
    101. //			如果大于0说明可以新增
    102. 			if(n>0) {
    103. 				ResponseUtil.writeJson(resp, R.ok(200, "会议信息数据新增成功"));
    104. 			}
    105. 			else {
    106. 				ResponseUtil.writeJson(resp, R.ok(0, "会议信息数据新增失败"));
    107. 			}
    108. 		} catch (Exception e) {
    109. 			e.printStackTrace();
    110. 			try {
    111. 				ResponseUtil.writeJson(resp, R.error(0, "会议信息数据新增失败"));
    112. 			} catch (Exception e1) {
    113. 				// TODO Auto-generated catch block
    114. 				e1.printStackTrace();
    115. 			}
    116. 		}
    117. 		return null;
    118. 	}
    119. 	
    120. 	
    121. //	我的会议
    122. 	public String myInfos(HttpServletRequest req, HttpServletResponse resp) {
    123. 		try {
    124. 			PageBean pageBean = new PageBean();
    125. 			pageBean.setRequest(req);
    126. 			List<Map<String, Object>> infos = infoDao.myInfos(info, pageBean);	
    127. //			注意：layui中的数据格式
    128. 			ResponseUtil.writeJson(resp, R.ok(0, "我的会议数据查询成功", pageBean.getTotal(), infos));
    129. 		} catch (Exception e) {
    130. 			e.printStackTrace();
    131. 			try {
    132. 				ResponseUtil.writeJson(resp, R.error(0, "我的会议数据查询错误"));
    133. 			} catch (Exception e1) {
    134. 				e1.printStackTrace();
    135. 			}
    136. 		}
    137. 		return null;
    138. 	}
    139. 	
    140. //	我的审批
    141. 	public String myAudit(HttpServletRequest req, HttpServletResponse resp) {
    142. 		try {
    143. 			PageBean pageBean = new PageBean();
    144. 			pageBean.setRequest(req);
    145. 			List<Map<String, Object>> list = infoDao.myAudit(info, pageBean);	
    146. //			注意：layui中的数据格式
    147. 			ResponseUtil.writeJson(resp, R.ok(0, "我的审批查询成功", pageBean.getTotal(), list));
    148. 		} catch (Exception e) {
    149. 			e.printStackTrace();
    150. 			try {
    151. 				ResponseUtil.writeJson(resp, R.error(0, "我的审批查询错误"));
    152. 			} catch (Exception e1) {
    153. 				e1.printStackTrace();
    154. 			}
    155. 		}
    156. 		return null;
    157. 	}
    158. 	
    159. 	
    160. //	待开会议
    161. 	public String queryMeetingInfoByState(HttpServletRequest req, HttpServletResponse resp) {
    162. 		try {
    163. 			PageBean pageBean = new PageBean();
    164. 			pageBean.setRequest(req);
    165. 			List<Map<String, Object>> list = infoDao.queryMeetingInfoByState(info, pageBean);	
    166. //			注意：layui中的数据格式
    167. 			ResponseUtil.writeJson(resp, R.ok(0, "待开会议数据查询成功", pageBean.getTotal(), list));
    168. 		} catch (Exception e) {
    169. 			e.printStackTrace();
    170. 			try {
    171. 				ResponseUtil.writeJson(resp, R.error(0, "待开会议数据查询错误"));
    172. 			} catch (Exception e1) {
    173. 				e1.printStackTrace();
    174. 			}
    175. 		}
    176. 		return null;
    177. 	}
    178. 	
    179. //	所有会议
    180. 	public String allInfos(HttpServletRequest req, HttpServletResponse resp) {
    181. 		try {
    182. 			PageBean pageBean = new PageBean();
    183. 			pageBean.setRequest(req);
    184. 			List<Map<String, Object>> list = infoDao.allInfos(info, pageBean);	
    185. //			注意：layui中的数据格式
    186. 			ResponseUtil.writeJson(resp, R.ok(0, "所有会议数据查询成功", pageBean.getTotal(), list));
    187. 		} catch (Exception e) {
    188. 			e.printStackTrace();
    189. 			try {
    190. 				ResponseUtil.writeJson(resp, R.error(0, "所有会议数据查询错误"));
    191. 			} catch (Exception e1) {
    192. 				e1.printStackTrace();
    193. 			}
    194. 		}
    195. 		return null;
    196. 	}
    197. 	
    198.  
    199. }

    MeetingInfoDao.java代码块：

    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<MeetingInfo>{
    13. 	
    14. 	
    15. 	
    16. //	会议信息新增
    17. 	public int add(MeetingInfo t) throws Exception {
    18. 		String sql="insert into t_oa_meeting_info(title,content,canyuze,liexize,zhuchiren,location,startTime,endTime,remark) values(?,?,?,?,?,?,?,?,?)";
    19. 		return super.executeUpdate(sql, t, new String[] {"title","content","canyuze","liexize","zhuchiren","location","startTime","endTime","remark"});
    20. 	}
    21. 	
    22. //	我的会议，后续其他的菜单也会使用
    23. 	private String getSQL() {
    24. 		return "select a.id,a.title,a.content,a.canyuze,a.liexize,a.zhuchiren\r\n" + 
    25. 				",b.`name` zhuchirennmae,\r\n" + 
    26. 				"a.location,\r\n" + 
    27. 				"DATE_FORMAT(a.startTime,'%Y-%m-%d %H-%m-%s') startTime,\r\n" + 
    28. 				"DATE_FORMAT(a.endTime,'%Y-%m-%d %H-%m-%s') endTime,\r\n" + 
    29. 				"a.state,\r\n" + 
    30. 				"(\r\n" + 
    31. 				"	case a.state\r\n" + 
    32. 				"	when 0 then '取消会议'\r\n" + 
    33. 				"	when 1 then '新建'\r\n" + 
    34. 				"	when 2 then '待审核'\r\n" + 
    35. 				"	when 3 then '驳回'\r\n" + 
    36. 				"	when 4 then '待开'\r\n" + 
    37. 				"	when 5 then '进行中'\r\n" + 
    38. 				"	when 6 then '开始投票'\r\n" + 
    39. 				"	when 7 then '结束会议'\r\n" + 
    40. 				"	else '其他' end\r\n" + 
    41. 				") meetingstate,\r\n" + 
    42. 				"a.seatPic,a.remark,a.auditor,\r\n" + 
    43. 				"c.`name` auditorname 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. //	我的会议
    49. 	public List<Map<String, Object>> myInfos(MeetingInfo info, PageBean pageBean)
    50. 			throws SQLException, InstantiationException, IllegalAccessException {
    51. //		拿到那些可能传的条件
    52. //		拿到我们封装好的SQL语句
    53. 		String sql = getSQL();
    54. //		会议标题
    55. 		String title = info.getTitle();
    56. 		if(StringUtils.isNotBlank(title)) {
    57. 			sql+=" and a.title like '%"+title+"%'";
    58. 		}
    59. 		sql+=" and a.zhuchiren = "+info.getZhuchiren();
    60. //		降序
    61. 		sql+=" order by a.id desc ";
    62. 		return super.executeQuery(sql, pageBean);
    63. 	}
    64.  
    65. //	设置会议排座图片
    66. 	public int updateSeatPicById(MeetingInfo info) throws Exception {
    67. 		String sql = " update t_oa_meeting_info set seatPic=? where id=?";
    68. 		return super.executeUpdate(sql, info, new String[] {"seatPic","id"});
    69. 	}
    70.  
    71. //	会议送审
    72. 	public int updateAuditorById(MeetingInfo info) throws Exception {
    73. 		String sql = " update t_oa_meeting_info set auditor=?,state=2 where id=?";
    74. 		return super.executeUpdate(sql, info, new String[] {"auditor","id"});
    75. 	}
    76.  
    77. //	我的审批
    78. 	public List<Map<String, Object>> myAudit(MeetingInfo info, PageBean pageBean)
    79. 			throws SQLException, InstantiationException, IllegalAccessException {
    80. //		拿到那些可能传的条件
    81. //		拿到我们封装好的SQL语句
    82. 		String sql = getSQL();
    83. //		会议标题
    84. 		String title = info.getTitle();
    85. 		if(StringUtils.isNotBlank(title)) {
    86. 			sql+=" and a.title like '%"+title+"%'";
    87. 		}
    88. //		当前登录账号等于审批人字段值
    89. 		sql+=" and a.auditor = "+info.getAuditor();
    90. //		待审核状态的会议信息才需要查询出来
    91. 		sql+=" and a.state=2 ";
    92. //		降序
    93. 		sql+=" order by a.id desc ";
    94. 		return super.executeQuery(sql, pageBean);
    95. 	}
    96.  
    97. //	待开会议
    98. 	public List<Map<String, Object>> queryMeetingInfoByState(MeetingInfo info, PageBean pageBean) throws InstantiationException, IllegalAccessException, SQLException {
    99. 		String sql="select CONCAT(canyuze,',',liexize,',',zhuchiren),a.id,a.title,a.content,a.canyuze,a.liexize,a.zhuchiren\r\n" + 
    100. 				" ,b.`name` zhuchirennmae,\r\n" + 
    101. 				" a.location,\r\n" + 
    102. 				" DATE_FORMAT(a.startTime,'%Y-%m-%d %H-%m-%s') startTime,\r\n" + 
    103. 				" DATE_FORMAT(a.endTime,'%Y-%m-%d %H-%m-%s') endTime,\r\n" + 
    104. 				" a.state,\r\n" + 
    105. 				" (\r\n" + 
    106. 				"	case a.state\r\n" + 
    107. 				"	when 0 then '取消会议'\r\n" + 
    108. 				"	when 1 then '新建'\r\n" + 
    109. 				"	when 2 then '待审核'\r\n" + 
    110. 				"	when 3 then '驳回'\r\n" + 
    111. 				"	when 4 then '待开'\r\n" + 
    112. 				"	when 5 then '进行中'\r\n" + 
    113. 				"	when 6 then '开始投票'\r\n" + 
    114. 				"	when 7 then '结束会议'\r\n" + 
    115. 				"	else '其他' end\r\n" + 
    116. 				" ) meetingstate,\r\n" + 
    117. 				" a.seatPic,a.remark,a.auditor,\r\n" + 
    118. 				" c.`name` auditorname from t_oa_meeting_info a \r\n" + 
    119. 				" inner join t_oa_user b on a.zhuchiren=b.id\r\n" + 
    120. 				" left join t_oa_user c on a.auditor=c.id where 1=1\r\n" + 
    121. 				" and state=4 and FIND_IN_SET("+info.getZhuchiren()+",CONCAT(canyuze,',',liexize,',',zhuchiren)) ";
    122. 		return super.executeQuery(sql, pageBean);
    123. 	}
    124.  
    125. //	所有会议
    126. 	public List<Map<String, Object>> allInfos(MeetingInfo info, PageBean pageBean) throws InstantiationException, IllegalAccessException, SQLException {
    127. 		String sql="select CONCAT(a.canyuze,',',a.liexize,',',a.zhuchiren,',',IFNULL(a.auditor,-1)),a.id,a.title,a.content,\r\n" + 
    128. 				" a.canyuze,a.liexize,a.zhuchiren,b.`name` zhuchirennmae,a.location,\r\n" + 
    129. 				" DATE_FORMAT(a.startTime,'%Y-%m-%d %H-%m-%s') \r\n" + 
    130. 				" startTime,DATE_FORMAT(a.endTime,'%Y-%m-%d %H-%m-%s') endTime,\r\n" + 
    131. 				" a.state,(\r\n" + 
    132. 				"	case a.state\r\n" + 
    133. 				"	when 0 then '取消会议' \r\n" + 
    134. 				"	when 1 then '新建' \r\n" + 
    135. 				"	when 2 then '待审核' \r\n" + 
    136. 				"	when 3 then '驳回' \r\n" + 
    137. 				"	when 4 then '待开' \r\n" + 
    138. 				"	when 5 then '进行中' \r\n" + 
    139. 				"	when 6 then '开始投票' \r\n" + 
    140. 				"	when 7 then '结束会议' \r\n" + 
    141. 				"	else '其他' end\r\n" + 
    142. 				" ) \r\n" + 
    143. 				" meetingstate,a.seatPic,a.remark,a.auditor,c.`name` auditorname \r\n" + 
    144. 				" from t_oa_meeting_info a \r\n" + 
    145. 				" inner join t_oa_user b on a.zhuchiren=b.id \r\n" + 
    146. 				" left join t_oa_user c on a.auditor=c.id where 1=1 \r\n" + 
    147. 				" and FIND_IN_SET("+info.getZhuchiren()+",CONCAT(a.canyuze,',',a.liexize,',',a.zhuchiren,',',a.auditor))";
    148. 		return super.executeQuery(sql, pageBean);
    149. 	}
    150.  
    151. 	
    152.  
    153. }

     我们在来重新运行一下我就用id为6的登录如图所示：

    对应数据库里的 

     

    在对应一下数据库里的是不是也是这么多条记录

  • 相关阅读:
    浅浅的 Cmake
    关于IDEA没有显示日志输出？IDEA控制台没有显示Tomcat Localhost Log和Catalina Log 怎么办？
    java基于微信小程序的新冠疫苗接种预约系统 uinapp
    arthas进阶版排查问题之idea插件工具操作
    Docker 容器中运行 Kibana
    理“ Druid 元数据”之乱
    07-垃圾收集算法详解
    【ViT详解】Vision Transformer网络结构及代码解读
    快速创建软件安装包-ClickOnce
    FPGA 学习笔记：IP Clocking Wizard 的基本操作
  • 原文地址：https://blog.csdn.net/weixin_67465673/article/details/126061516