目录

一、功能介绍

二、我的会议SQL编写

三、我的会议后台

实体类

dao方法

web层

xml配置

js代码

四、我的会议前端

jsp页面

界面展示

五、取消会议

dao方法

web层

js

一、功能介绍

我的会议：当前登录账号，是 某会议 主持人，则查询出来

所需表：t_oa_meeting_info 

二、我的会议SQL编写

--状态：0取消会议 1新建 2待审核 3驳回 4待开 5进行中 6开启投票 7结束会议，默认值为1 

最初版查询语句

select a.*,a.auditor,b.`name` zhuchiren,c.`name` auditorname from
t_oa_meeting_info a,
t_oa_user b,
t_oa_user c
where a.zhuchiren=b.id and a.auditor=c.id;

第二版

用户表分析，会议没有审批人也要查询出来，name会议信息表就作为主表，用户表作为从表：用会议信息表左外链接

select a.*,a.auditor,b.`name` zhuchiren,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

最终版

1.时间字段要格式化，否则页面会显示一串数字

2.会议状态是数字，前端要显示会议状态描述

select 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 5 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

三、我的会议后台

实体类

package com.maomao.entity;

import java.util.Date;

public class MeetingInfo {
    private Long id;

    private String title;

    private String content;

    private String canyuze;

    private String liexize;

    private String zhuchiren;

    private String location;

    private Date startTime;

    private Date endTime;

    private String fujian;

    private Integer state;

    private String seatPic;

    private String remark;
    
    private String auditor;

	public String getAuditor() {
		return auditor;
	}

	public void setAuditor(String auditor) {
		this.auditor = auditor;
	}

	public Long getId() {
		return id;
	}

	public void setId(Long id) {
		this.id = id;
	}

	public String getTitle() {
		return title;
	}

	public void setTitle(String title) {
		this.title = title;
	}

	public String getContent() {
		return content;
	}

	public void setContent(String content) {
		this.content = content;
	}

	public String getCanyuze() {
		return canyuze;
	}

	public void setCanyuze(String canyuze) {
		this.canyuze = canyuze;
	}

	public String getLiexize() {
		return liexize;
	}

	public void setLiexize(String liexize) {
		this.liexize = liexize;
	}

	public String getZhuchiren() {
		return zhuchiren;
	}

	public void setZhuchiren(String zhuchiren) {
		this.zhuchiren = zhuchiren;
	}

	public String getLocation() {
		return location;
	}

	public void setLocation(String location) {
		this.location = location;
	}

	public Date getStartTime() {
		return startTime;
	}

	public void setStartTime(Date startTime) {
		this.startTime = startTime;
	}

	public Date getEndTime() {
		return endTime;
	}

	public void setEndTime(Date endTime) {
		this.endTime = endTime;
	}

	public String getFujian() {
		return fujian;
	}

	public void setFujian(String fujian) {
		this.fujian = fujian;
	}

	public Integer getState() {
		return state;
	}

	public void setState(Integer state) {
		this.state = state;
	}

	public String getSeatPic() {
		return seatPic;
	}

	public void setSeatPic(String seatPic) {
		this.seatPic = seatPic;
	}

	public String getRemark() {
		return remark;
	}

	public void setRemark(String remark) {
		this.remark = remark;
	}

	public MeetingInfo() {
		super();
		// TODO Auto-generated constructor stub
	}

	@Override
	public String toString() {
		return "MeetingInfo [id=" + id + ", title=" + title + ", content=" + content + ", canyuze=" + canyuze
				+ ", liexize=" + liexize + ", zhuchiren=" + zhuchiren + ", location=" + location + ", startTime="
				+ startTime + ", endTime=" + endTime + ", fujian=" + fujian + ", state=" + state + ", seatPic=" + seatPic + ", remark=" + remark + "]";
	}
    
}

dao方法

//通用的会议查询SQL语句，包含会议信息表数据，主持人姓名、审批人姓名、会议状态
	private String getSQL() {
		return "SELECt a.id,a.title,a.content,a.canyuze,a.liexize,a.zhuchiren,b.`name`,a.locationrn" + 
				",DATE_FORMAT(a.startTime,'%Y-%m-%d %H:%i:%s') as startTimern" + 
				",DATE_FORMAT(a.endTime,'%Y-%m-%d %H:%i:%s') as endTimern" + 
				",a.statern" + 
				",(case a.statern" + 
				"when 0 then '取消会议'rn" + 
				"when 1 then '新建'rn" + 
				"when 2 then '待审核'rn" + 
				"when 3 then '驳回'rn" + 
				"when 4 then '待开'rn" + 
				"when 5 then '进行中'rn" + 
				"when 6 then '开启投票'rn" + 
				"else '结束会' endrn" + 
				") as meetingStatern" + 
				",a.seatPic,a.remark,a.auditor,c.`name` as auditorNamern" + 
				"FROM t_oa_meeting_info arn" + 
				"inner join t_oa_user b on a.zhuchiren = b.idrn" + 
				"left JOIN t_oa_user c on a.auditor = c.id where 1=1 ";
	}
	
//	我的会议
	public List> myInfos(MeetingInfo info, PageBean pageBean) throws Exception {
		String sql = getSQL();
		String title = info.getTitle();
		if(StringUtils.isNotBlank(title)) {
			sql += " and title like '%"+title+"%'";
		}
		//根据当前登陆用户ID作为主持人字段的条件
		sql+=" and zhuchiren="+info.getZhuchiren();
		//按照会议ID降序排序
		sql+=" order by a.id desc";
		System.out.println(sql);
		return super.executeQuery(sql, pageBean);
	}

//	状态：0取消会议 1新建 2待审核 3驳回 4待开 5进行中 6开启投票 7结束会议，默认值为1
	public int updatezt(MeetingInfo m) throws Exception {
		String sql = "update t_oa_meeting_info set state=? where id = ?";
		return super.executeUpdate(sql, m, new String[] {"state","id"});
	}

web层

package com.maomao.web;

import java.io.IOException;
import java.util.Date;
import java.util.List;
import java.util.Map;
import java.util.UUID;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.commons.beanutils.ConvertUtils;

import com.maomao.dao.MeetingInfoDao;
import com.maomao.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{
	private MeetingInfo info = new MeetingInfo();
	private MeetingInfoDao meetingInfoDao = new MeetingInfoDao();

	@Override
	public MeetingInfo getModel() {
		//方式二：
	    ConvertUtils.register(new MyDateConverter(),Date.class);
		return info;
	}
	
	// 我的会议
	public String myInfos(HttpServletRequest req, HttpServletResponse resp) {
		try {
			PageBean pageBean = new PageBean();
			pageBean.setRequest(req);
			List> infos = meetingInfoDao.myInfos(info, pageBean);
			ResponseUtil.writeJson(resp, R.ok(0, "我的会议查询成功！！！", pageBean.getTotal(), infos));
		} catch (Exception e) {
			e.printStackTrace();
			try {
				ResponseUtil.writeJson(resp, R.error(0, "我的会议查询失败！！！"));
			} catch (Exception e1) {
				e1.printStackTrace();
			}
		}
		return null;
	}
	

}

xml配置

js代码

let layer,table,$,form;
let row;
layui.use(['layer','table','jquery','form'],function(){
	layer=layui.layer,
	table=layui.table,
	form=layui.form,
	$=layui.jquery;
	
	initTable();
	
	//查询事件
	$('#btn_search').click(function(){
		query();
	});
	
});

//1.初始化数据表格
function initTable(){
	table.render({          //执行渲染
        elem: '#tb',   //指定原始表格元素选择器（推荐id选择器）
        height: 400,         //自定义高度
        loading: false,      //是否显示加载条（默认 true）
        cols: [[             //设置表头
            {field: 'id', title: '会议编号', width: 90},
            {field: 'title', title: '会议标题', width: 120},
            {field: 'location', title: '会议地点', width: 140},
            {field: 'startTime', title: '开始时间', width: 120},
            {field: 'endTime', title: '结束时间', width: 120},
            {field: 'meetingState', title: '会议状态', width: 120},
            {field: 'seatPic', title: '会议排座', width: 120,
            	templet: function(d){
                    if(d.seatPic==null || d.seatPic=="")
                    	return "尚未排座";
                    else
                    	return "";
                }
            },
            {field: 'auditName', title: '审批人', width: 120},
            {field: '', title: '操作', width: 200,toolbar:'#tbar'},
        ]]
   });
}

//2.点击查询
function query(){
	table.reload('tb', {
        url: $("#ctx").val()+'/info.action',     //请求地址
        method: 'POST',                    //请求方式，GET或者POST
        loading: true,                     //是否显示加载条（默认 true）
        page: true,                        //是否分页
        where: {                           //设定异步数据接口的额外参数，任意设
        	'methodName':'myInfos',
        	'zhuchiren':$('#zhuchiren').val(),
        	'title':$('#title').val(),
        },  
        request: {                         //自定义分页请求参数名
            pageName: 'page', //页码的参数名称，默认：page
            limitName: 'rows' //每页数据量的参数名，默认：limit
        },
        done: function (res, curr, count) {
        	console.log(res);
        }
   });
	
	//工具条事件
	table.on('tool(tb)', function(obj){ //注：tool 是工具条事件名，test 是 table 原始容器的属性 lay-filter="对应的值"
	  row = obj.data; //获得当前行数据
	  var layEvent = obj.event; //获得 lay-event 对应的值（也可以是表头的 event 参数对应的值）
	  var tr = obj.tr; //获得当前行 tr 的 DOM 对象（如果有的话）
	  console.log(row);
	  if(layEvent === 'seat'){ //会议排座
		 
	  } else if(layEvent === 'send'){ //送审
		
	  } else if(layEvent==="back"){ //反馈详情
	  
	  } else {//删除
		  layer.confirm('确认要删除吗?', {icon: 3, title:'提示'}, function(index){
				$.post($("#ctx").val()+'/info.action',{
					'methodName':'updatezt',
					'state':0,
					'id':row.id
				},function(rs){
					if(rs.success){
						//调用查询方法刷新数据
						query();
					}else{
						layer.msg(rs.msg,function(){});
					}
				},'json');
				layer.close(index);
			});
	  }
	});

四、我的会议前端

jsp页面

<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%@include file="/common/header.jsp"%>












  
    会议标题
    
      
      
    
  
  
     查询
  





	

		
		   送审人
		   
		      
		      
				---请选择---
		      
		   
		   
		     送审
		   
		
	



	

	  
参会人员
	
	

	

	  
缺席人员
	
	

	

	  
未读人员
	
	

界面展示

五、取消会议

这里的删除是取消会议

把状态修改为0

dao方法

//	状态：0取消会议 1新建 2待审核 3驳回 4待开 5进行中 6开启投票 7结束会议，默认值为1
	public int updatezt(MeetingInfo m) throws Exception {
		String sql = "update t_oa_meeting_info set state=? where id = ?";
		return super.executeUpdate(sql, m, new String[] {"state","id"});
	}

	

web层

//我的会议：取消会议
	public String updatezt(HttpServletRequest req, HttpServletResponse resp) {
		try {
			int rs = meetingInfoDao.updatezt(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;
	}

js

//工具条事件
	table.on('tool(tb)', function(obj){ //注：tool 是工具条事件名，test 是 table 原始容器的属性 lay-filter="对应的值"
	  row = obj.data; //获得当前行数据
	  var layEvent = obj.event; //获得 lay-event 对应的值（也可以是表头的 event 参数对应的值）
	  var tr = obj.tr; //获得当前行 tr 的 DOM 对象（如果有的话）
	  console.log(row);
	  if(layEvent === 'seat'){ //会议排座
		 
	  } else if(layEvent === 'send'){ //送审
		
	  } else if(layEvent==="back"){ //反馈详情
	  
	  } else {//删除
		  layer.confirm('确认要删除吗?', {icon: 3, title:'提示'}, function(index){
				$.post($("#ctx").val()+'/info.action',{
					'methodName':'updatezt',
					'state':0,
					'id':row.id
				},function(rs){
					if(rs.success){
						//调用查询方法刷新数据
						query();
					}else{
						layer.msg(rs.msg,function(){});
					}
				},'json');
				layer.close(index);
			});
	  }
	});

 效果展示