OA项目之我的会议（查询or送审）
这里写目录标题
- 一、后端编写
- ①查询我的会议
- ②会议送审
- 二、前端编写
- ①我的会议
- ②会议送审
一、后端编写
①查询我的会议
实体类MeetingInfo.java
package com.xlb.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}@Overridepublic 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方法层
private String getSQL() {return "SELECT\r\n" + " a.id,\r\n" + " a.title,\r\n" + " a.content,\r\n" + " a.liexize,\r\n" + " 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\r\n" + " a.state \r\n" + " WHEN 0 THEN\r\n" + " '取消会议' \r\n" + " WHEN 1 THEN\r\n" + " '新建' \r\n" + " WHEN 2 THEN\r\n" + " '待审核' \r\n" + " WHEN 3 THEN\r\n" + " '驳回' \r\n" + " WHEN 4 THEN\r\n" + " '待开' \r\n" + " WHEN 5 THEN\r\n" + " '进行中' \r\n" + " WHEN 6 THEN\r\n" + " '开启投票' \r\n" + " WHEN 7 THEN\r\n" + " '结束会议' ELSE '其他' \r\n" + "END \r\n" + " ) meetingstate,\r\n" + " a.seatPic,\r\n" + " a.remark,\r\n" + " a.auditor,\r\n" + " c.`name` auditorname \r\n" + "FROM\r\n" + " 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 and 1=1 ";}//我的会议SQL，后续其他的菜单也会使用public List<Map<String, Object>> myInfos(MeetingInfo info,PageBean pageBean)throws SQLException, InstantiationException, IllegalAccessException {String sql=getSQL();//拿到会议标题String title = info.getTitle();if(StringUtils.isNotBlank(title)) {sql +=" and title like '%"+title+"%' ";}sql +=" and zhuchiren = "+info.getZhuchiren()+" ";return super.executeQuery(sql, pageBean);}
测试类MeetingInfoDaoTest.java
package com.xlb.dao;import static org.junit.Assert.*;import java.sql.SQLException;
import java.util.List;
import java.util.Map;import org.junit.After;
import org.junit.Before;
import org.junit.Test;import com.xlb.entity.MeetingInfo;
import com.zking.util.PageBean;public class MeetingInfoDaoTest {MeetingInfoDao mid = new MeetingInfoDao();@Beforepublic void setUp() throws Exception {}@Afterpublic void tearDown() throws Exception {}@Testpublic void m() {MeetingInfo info = new MeetingInfo();PageBean pageBean = new PageBean();try {List<Map<String, Object>> myInfos = mid.myInfos(info, pageBean);for (Map<String, Object> map : myInfos) {System.out.println(map);}System.out.println(pageBean);} catch (Exception e) {e.printStackTrace();} }}结果
web层MeetingInfoAction.java
//我的会议public String myInfos(HttpServletRequest req, HttpServletResponse resp) {try {PageBean pageBean = new PageBean();//初始化pageBeanpageBean.setRequest(req);//调用方法List<Map<String, Object>> lst = infoDao.myInfos(info, pageBean);
// layui 的code 返回一定要是 0，不能是200，否者返回不了数据//传输到界面//pageBean.getTotal()总记录数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;}②会议送审
dao方法层
// 根据会议ID更新会议的审批人（送审）public int edit(MeetingInfo info) throws Exception {String sql="update t_oa_meeting_info set auditor=?,state=2 where id=?";return super.executeUpdate(sql, info, new String[] {"auditor","id"});}
web层
//送审public String edit(HttpServletRequest req, HttpServletResponse resp) {try {//rs是影响行数int rs = infoDao.edit(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;}
二、前端编写
①我的会议
我的会议页面
<%@ page language="java" contentType="text/html; charset=UTF-8"pageEncoding="UTF-8"%>
<%@include file="/common/header.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/myMeeting.js"></script>
<title>用户管理</title>
</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" style="margin:15px 0px;"><div class="layui-inline"><label class="layui-form-label">会议标题</label><div class="layui-input-inline"><input type="hidden" id="zhuchiren" value="${user.id }"/><input type="text" id="title" autocomplete="off" class="layui-input"></div></div><div class="layui-inline"><button id="btn_search" type="button" class="layui-btn"><i class="layui-icon layui-icon-search"></i> 查询</button></div>
</div>
<!-- 数据表格 -->
<table id="tb" lay-filter="tb" class="layui-table" style="margin-top:-15px"></table><!-- 对话框（送审） -->
<div id="audit" style="display:none;"><form style="margin:20px 15px;" class="layui-form layui-form-pane" lay-filter="audit"><div class="layui-inline"><label class="layui-form-label">送审人</label><div class="layui-input-inline"><input type="hidden" id="meetingId" value=""/><select id="auditor" style="poistion:relative;z-index:1000"><option value="">---请选择---</option></select></div><div class="layui-input-inline"><button id="btn_auditor" class="layui-btn">送审</button></div></div></form>
</div><!-- 对话框（反馈详情） -->
<div id="feedback" style="display:none;padding:15px;"><fieldset class="layui-elem-field layui-field-title"><legend>参会人员</legend></fieldset><blockquote class="layui-elem-quote" id="meeting_ok"></blockquote><fieldset class="layui-elem-field layui-field-title"><legend>缺席人员</legend></fieldset><blockquote class="layui-elem-quote" id="meeting_no"></blockquote><fieldset class="layui-elem-field layui-field-title"><legend>未读人员</legend></fieldset><blockquote class="layui-elem-quote" id="meeting_noread"></blockquote>
</div>
<script type="text/html" id="tbar">{{# if(d.state==1 || d.state==3){ }}<a class="layui-btn layui-btn-xs" lay-event="seat">会议排座</a><a class="layui-btn layui-btn-xs" lay-event="send">送审</a><a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">删除</a>{{# } }}{{# if(d.state!=1 && d.state!=2 && d.state!=3){ }}<a class="layui-btn layui-btn-xs" lay-event="back">反馈详情</a>{{# } }}
</script>
</body>
</html>对应的js
let layer,$,table,form;
var row;
layui.use(['jquery', 'layer', 'table','form'], function(){layer = layui.layer,$ = layui.jquery,form = layui.form,table = layui.table;//初始化数据表格initTable();//绑定查询按钮的点击事件$('#btn_search').click(function(){query();});});//1.初始化数据表格
function initTable(){table.render({ //执行渲染elem: '#tb', //指定原始表格元素选择器（推荐id选择器）
// url: 'user.action?methodName=list', //请求地址height: 340, //自定义高度loading: false, //是否显示加载条（默认 true）cols: [[ //设置表头{field: 'id', title: '会议编号', width: 120},{field: 'title', title: '会议标题', width: 120},{field: 'location', title: '会议地点', width: 140},{field: 'startTime', title: '开始时间', width: 120},{field: 'endTime', title: '结束时间', width: 120},{field: 'meetingstate', title: '会议状态', width: 140},{field: 'seatPic', title: '会议排座', width: 140 ,templet: function(d){//d代表当前行console.log(d.LAY_INDEX); //得到序号。一般不常用console.log(d.LAY_COL); //得到当前列表头配置信息（layui 2.6.8 新增）。一般不常用//得到当前行数据，并拼接成自定义模板return '<img src="'+d.seaPic+'" />'}},{field: 'auditor', title: '审批人', width: 120},{field: '', title: '操作', width: 220,toolbar:'#tbar'},]]});//在页面中的中必须配置lay-filter="tb_goods"属性才能触发属性!!!table.on('tool(tb)', function (obj) {row = obj.data;if (obj.event == "seat") {layer.msg('排座');}else if(obj.event == "send"){layer.msg('送审');}else if(obj.event == "del"){layer.msg("取消会议");}else if(obj.event == "back"){layer.msg("反馈详情");}else{}});
}//2.点击查询
function query(){table.reload('tb', {url: 'info.action', //请求地址method: 'POST', //请求方式，GET或者POSTloading: true, //是否显示加载条（默认 true）page: true, //是否分页where: { //设定异步数据接口的额外参数，任意设'methodName':'myInfos','title':$('#title').val(),'zhuchiren':$("#zhuchiren").val()}, request: { //自定义分页请求参数名pageName: 'page', //页码的参数名称，默认：pagelimitName: 'rows'//每页数据量的参数名，默认：limit}});}
效果
②会议送审
对应的js
let layer,$,table,form;
var row;
layui.use(['jquery', 'layer', 'table','form'], function(){layer = layui.layer,$ = layui.jquery,form = layui.form,table = layui.table;//初始化数据表格initTable();//绑定查询按钮的点击事件$('#btn_search').click(function(){query();});//送审$('#btn_auditor').click(function(){$.post($("#ctx").val()+'/info.action',{'methodName':'edit','id':$('#meetingId').val(),'auditor':$('#auditor').val()},function(rs){if(rs.success){//关闭对话框layer.closeAll();//刷新列表query();}else{layer.msg(rs.msg,{icon:5},function(){});}},'json');return false;});});//1.初始化数据表格
function initTable(){table.render({ //执行渲染elem: '#tb', //指定原始表格元素选择器（推荐id选择器）
// url: 'user.action?methodName=list', //请求地址height: 340, //自定义高度loading: false, //是否显示加载条（默认 true）cols: [[ //设置表头{field: 'id', title: '会议编号', width: 120},{field: 'title', title: '会议标题', width: 120},{field: 'location', title: '会议地点', width: 140},{field: 'startTime', title: '开始时间', width: 120},{field: 'endTime', title: '结束时间', width: 120},{field: 'meetingstate', title: '会议状态', width: 140},{field: 'seatPic', title: '会议排座', width: 140 ,templet: function(d){//d代表当前行console.log(d.LAY_INDEX); //得到序号。一般不常用console.log(d.LAY_COL); //得到当前列表头配置信息（layui 2.6.8 新增）。一般不常用//得到当前行数据，并拼接成自定义模板return '<img src="'+d.seaPic+'" />'}},{field: 'auditor', title: '审批人', width: 120},{field: '', title: '操作', width: 220,toolbar:'#tbar'},]]});//在页面中的中必须配置lay-filter="tb_goods"属性才能触发属性!!!table.on('tool(tb)', function (obj) {row = obj.data;if (obj.event == "seat") {layer.msg('排座');}else if(obj.event == "send"){openLayerAudit();initFormSelects();}else if(obj.event == "del"){layer.msg("取消会议");}else if(obj.event == "back"){layer.msg("反馈详情");}else{}});
}//2.点击查询
function query(){table.reload('tb', {url: 'info.action', //请求地址method: 'POST', //请求方式，GET或者POSTloading: true, //是否显示加载条（默认 true）page: true, //是否分页where: { //设定异步数据接口的额外参数，任意设'methodName':'myInfos','title':$('#title').val(),'zhuchiren':$("#zhuchiren").val()}, request: { //自定义分页请求参数名pageName: 'page', //页码的参数名称，默认：pagelimitName: 'rows'//每页数据量的参数名，默认：limit}});}//初始化审批人
function initFormSelects(){$.getJSON($("#ctx").val()+'/user.action',{'methodName':'queryUserAll'},function(rs){console.log(rs);let data=rs.data;$.each(data,function(i,e){$('#auditor').append(new Option(e.name,e.value));});//重新渲染form.render('select');});
}//会议送审
function openLayerAudit(){//每次打开都对送审人进行初始化默认值设置$('#auditor').val("");//必须重新渲染form.render('select');//弹出对话框layer.open({type: 1, title:'会议送审',area: ['426px', '140px'], //宽高skin: 'layui-layer-rim', //样式类名content: $('#audit'), //弹出内容。可以传入普通的html内容，还可以指定DOM，更可以随着type的不同而不同});
}
效果
没有填写送审人
送审成功后就直接关闭了
本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！
