目录
待开会议:
所有会议
编辑
待开和所有会议功能实现
前台
哈喽大家好~~我来啦~~今天给大家分享我们会议0A的最后一期啦！！！
是我们会议的待开会议和我们的所有会议！！！
待开会议:
与我的会议的区别在于，待开会议匹配参与者、列席者、主持人个数据库列段
接下来我们看一下sql语句！！！！
查询包含三个列段中包含六的信息:
select CONCAT(canyuze,',',liexize,',',zhuchiren), a.id,a.title,a.content,a.canyuze,a.liexize,a.zhuchiren
,b.name zhuchirenname,
a.location,
DATE_FORMAT(a.startTime,'%Y-%m-%d %h-%m-%s') startTime,
DATE_FORMAT(a.endTime,'%Y-%m-%d %h-%m-%s') endTime,
a.state,
(
case a.state
when 0 then '取消会议'
when 1 then '新建'
when 2 then '待审核'
when 3 then '驳回'
when 4 then '待开'
when 4 then '进行中'
when 6 then '开启投票'
when 7 then '结束会议'
else '其他' end
) meetingstate,
a.seatPic,a.remark,a.auditor,
c.name auditorname
from t_oa_meeting_info a
inner join t_oa_user b on a.zhuchiren = b.id
left join t_oa_user c on a.auditor = c.id
where 1=1 and state=4 and FIND_IN_SET(6,CONCAT(canyuze,',',liexize,',',zhuchiren))
运行结果：
所有会议
与待开会议的区别在于，待开会议匹配参与者、列席者、主持人，审批人四个数据库列段
当前登录账号，只要是某会议的参与者、列席者、主持人、审批人中的一员，那么必须查出来。
sql语句：
select CONCAT(a.canyuze,',',a.liexize,',',a.zhuchiren,',',IFNULL(a.auditor,-1)), a.id,a.title,a.content,a.canyuze,a.liexize,a.zhuchiren
,b.name zhuchirenname,
a.location,
DATE_FORMAT(a.startTime,'%Y-%m-%d %h-%m-%s') startTime,
DATE_FORMAT(a.endTime,'%Y-%m-%d %h-%m-%s') endTime,
a.state,
(
case a.state
when 0 then '取消会议'
when 1 then '新建'
when 2 then '待审核'
when 3 then '驳回'
when 4 then '待开'
when 4 then '进行中'
when 6 then '开启投票'
when 7 then '结束会议'
else '其他' end
) meetingstate,
a.seatPic,a.remark,a.auditor,
c.name auditorname
from t_oa_meeting_info a
inner join t_oa_user b on a.zhuchiren = b.id
left join t_oa_user c on a.auditor = c.id
where 1=1
and FIND_IN_SET(6,CONCAT(a.canyuze,',',a.liexize,',',a.zhuchiren,',',IFNULL(a.auditor,-1)))
运行结果：
待开和所有会议功能实现
先带大家看看我们的后台代码
MeetingInfodao：
public List<Map<String, Object>> queryMeetingInfoByState(MeetingInfo info, PageBean pageBean) throws Exception{String sql = "select CONCAT(canyuze,',',liexize,',',zhuchiren), a.id,a.title,a.content,a.canyuze,a.liexize,a.zhuchiren\r\n" + " ,b.name zhuchirenname,\r\n" + " a.location,\r\n" + " DATE_FORMAT(a.startTime,'%Y-%m-%d %h-%m-%s') startTime,\r\n" + " DATE_FORMAT(a.endTime,'%Y-%m-%d %h-%m-%s') endTime,\r\n" + " a.state,\r\n" + " (\r\n" + "case a.state\r\n" + "when 0 then '取消会议'\r\n" + "when 1 then '新建'\r\n" + "when 2 then '待审核'\r\n" + "when 3 then '驳回'\r\n" + "when 4 then '待开'\r\n" + "when 4 then '进行中'\r\n" + "when 6 then '开启投票'\r\n" + "when 7 then '结束会议'\r\n" + "else '其他' end\r\n" + "\r\n" + " ) meetingstate,\r\n" + " a.seatPic,a.remark,a.auditor,\r\n" + " c.name auditorname \r\n" + " from t_oa_meeting_info a\r\n" + " inner join t_oa_user b on a.zhuchiren = b.id\r\n" + " left join t_oa_user c on a.auditor = c.id\r\n" + " where 1=1 and state=4 and FIND_IN_SET("+info.getZhuchiren()+",CONCAT(canyuze,',',liexize,',',zhuchiren))";return super.executeQuery(sql, pageBean);}
MeetingInfoAction：
package com.zking.web;import java.util.Date;import java.util.List;import java.util.Map;import java.util.UUID;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import mons.beanutils.ConvertUtils;import com.zking.dao.MeetingInfoDao;import com.zking.entity.MeetingInfo;import com.zking.framework.ActionSupport;import com.zking.framework.ModelDriver;import com.zking.util.Base64ImageUtils;import com.zking.util.MyDateConverter;import com.zking.util.PageBean;import com.zking.util.PropertiesUtil;import com.zking.util.R;import com.zking.util.ResponseUtil;public class MeetingInfoAction extends ActionSupport implements ModelDriver<MeetingInfo>{private MeetingInfo info = new MeetingInfo();private MeetingInfoDao meetingInfoDao = new MeetingInfoDao();@Overridepublic MeetingInfo getModel() {//方式二：ConvertUtils.register(new MyDateConverter(),Date.class);return info;}public String updateSeatPicById(HttpServletRequest req, HttpServletResponse resp) {/** 1.接收前端页面传递到后台的图片对应的字符串* 2.借助工具类将字符串生成一个图片，保存到配置文件所配置的路径下* 3.添加服务器硬盘与请求地址的映射，即可访问* 4.将请求地址保存到数据库中*/try {//E:/temp/images/T280/abcdefg.png//获取图片的存放地址dirPath=E:/temp/images/T280/String dirPath = PropertiesUtil.getValue("dirPath");//获取浏览器请求路径，为了后续保存到数据库 serverPath=/upload/paizuo/String serverPath = PropertiesUtil.getValue("serverPath");//随机生成一个图片名称String fileName = UUID.randomUUID().toString().replaceAll("-", "")+".png";info.getSeatPic();//图片字符串Base64ImageUtils.GenerateImage(info.getSeatPic().replaceAll("data:image/png;base64,", ""), dirPath+fileName);//将seatPic中内容修改为 请求地址info.setSeatPic(serverPath+fileName);//修改会议排座 数据库图片 对应的数据库列段int rs = meetingInfoDao.updateSeatPicById(info);if (rs > 0) {ResponseUtil.writeJson(resp, R.ok(200, "会议排座成功"));}else {ResponseUtil.writeJson(resp, R.error(0, "会议排座失败"));}} catch (Exception e) {e.printStackTrace();try {ResponseUtil.writeJson(resp, R.error(0, "会议排座失败"));} catch (Exception e1) {e1.printStackTrace();}}return null;}//会议发布public String add(HttpServletRequest req, HttpServletResponse resp) {try {int rs = meetingInfoDao.add(info);if (rs > 0) {ResponseUtil.writeJson(resp, R.ok(200, "会议发布成功"));}else {ResponseUtil.writeJson(resp, R.error(0, "会议发布失败"));}} catch (Exception e) {e.printStackTrace();try {ResponseUtil.writeJson(resp, R.error(0, "会议发布失败"));} catch (Exception e1) {e1.printStackTrace();}}return null;}//我的审批public String myAudit(HttpServletRequest req,HttpServletResponse resp) {try {PageBean pageBean = new PageBean();pageBean.setRequest(req);List<Map<String, Object>> lst = meetingInfoDao.myAudit(info, pageBean);//注意：layui中的数据的格式ResponseUtil.writeJson(resp, R.ok(0, "我的会议数据查询成功",pageBean.getTotal(),lst));} catch (Exception e) {e.printStackTrace();try {ResponseUtil.writeJson(resp,R.error(0, "我的会议数据查询失败"));} catch (Exception e1) {e1.printStackTrace();}}return null;}//所有会议public String allInfos(HttpServletRequest req,HttpServletResponse resp) {try {PageBean pageBean = new PageBean();pageBean.setRequest(req);List<Map<String, Object>> lst = meetingInfoDao.allInfos(info, pageBean);//注意：layui中的数据的格式ResponseUtil.writeJson(resp, R.ok(0, "所有会议数据查询成功",pageBean.getTotal(),lst));} catch (Exception e) {e.printStackTrace();try {ResponseUtil.writeJson(resp,R.error(0, "所有会议数据查询失败"));} catch (Exception e1) {e1.printStackTrace();}}return null;}//待开会议public String queryMeetingInfoByState(HttpServletRequest req,HttpServletResponse resp) {try {PageBean pageBean = new PageBean();pageBean.setRequest(req);List<Map<String, Object>> lst = meetingInfoDao.queryMeetingInfoByState(info, pageBean);//注意：layui中的数据的格式ResponseUtil.writeJson(resp, R.ok(0, "待开会议数据查询成功",pageBean.getTotal(),lst));} catch (Exception e) {e.printStackTrace();try {ResponseUtil.writeJson(resp,R.error(0, "待开会议数据查询失败"));} catch (Exception e1) {e1.printStackTrace();}}return null;}//我的会议public String myInfos(HttpServletRequest req,HttpServletResponse resp) {try {PageBean pageBean = new PageBean();pageBean.setRequest(req);List<Map<String, Object>> lst = meetingInfoDao.myInfos(info, pageBean);//注意：layui中的数据的格式ResponseUtil.writeJson(resp, R.ok(0, "我的会议数据查询成功",pageBean.getTotal(),lst));} catch (Exception e) {e.printStackTrace();try {ResponseUtil.writeJson(resp,R.error(0, "我的会议数据查询失败"));} catch (Exception e1) {e1.printStackTrace();}}return null;}//根据会议ID更新会议的审批人（送审）public String updateAuditorById(HttpServletRequest req, HttpServletResponse resp) {try {int rs = meetingInfoDao.updateAuditorById(info);if (rs > 0) {ResponseUtil.writeJson(resp, R.ok(200, "会议审批成功"));}else {ResponseUtil.writeJson(resp, R.error(0, "会议审批失败"));}} catch (Exception e) {e.printStackTrace();try {ResponseUtil.writeJson(resp, R.error(0, "会议审批失败"));} catch (Exception e1) {e1.printStackTrace();}}return null;}}
前台
Meetingwaiting.jsp:
<%@ page language="java" contentType="text/html; charset=UTF-8"pageEncoding="UTF-8"%><%@include file="/common/head.jsp"%><!DOCTYPE html><html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><script type="text/javascript" src="${pageContext.request.contextPath }/static/js/meeting/meetingWaiting.js"></script></head><style>body{margin:15px;}.layui-table-cell {height: inherit;}.layui-layer-page .layui-layer-content { overflow: visible !important;}</style><body><div class="layui-form-item"><div class="layui-inline"><label class="layui-form-label">会议标题：</label><div class="layui-input-inline"><input type="hidden" id="userid" value="${sessionScope.user.id }"/><input type="text" id="title" autocomplete="off"class="layui-input"></div></div><div class="layui-inline"><button id="btn_meeting_search" class="layui-btn layui-btn-normal"><i class="layui-icon"></i> 查询</button></div></div><table style="margin-top: -15px;" id="tb_meeting" lay-filter="tb_meeting"></table></body></html>
MeetingWaiting.js
let layer,form,table,$;var row;layui.use(['layer','form','table'],function(){layer=layui.layer,form=layui.form,table=layui.table,$=layui.jquery;//初始化会议列表initMeeting();//绑定查询按钮的点击事件$('#btn_meeting_search').click(function(){query();});});//1.初始化会议列表function initMeeting(){table.render({ //执行渲染elem: '#tb_meeting', //指定原始表格元素选择器（推荐id选择器）height: 400, //自定义高度loading: false,//是否显示加载条（默认 true）cols: [[ //设置表头{field: 'title', title: '会议标题', width: 180},{field: 'location', title: '会议地点', width: 120},{field: 'startTime', title: '开始时间', width: 180},{field: 'endTime', title: '结束时间', width: 180},{field: 'meetingstate', title: '会议状态', width: 90},{field: 'zhuchirenname', title: '主持人', width: 120},//{field: '', title: '操作', width: 260, toolbar: '#tbMeeting'}]]});}//2.待开会议function query(){table.reload('tb_meeting', {url: 'info.action',//请求地址method: 'POST',//请求方式，GET或者POSTloading: true, //是否显示加载条（默认 true）page: true, //是否分页where: { //设定异步数据接口的额外参数，任意设'methodName':'queryMeetingInfoByState','title':$('#title').val(),'zhuchiren':$('#userid').val(),'state':4},request: {//自定义分页请求参数名pageName: 'page', //页码的参数名称，默认：pagelimitName: 'rows' //每页数据量的参数名，默认：limit},done: function (res, curr, count) {//查询完成的回调函数}});}
运行结果：
测试
