• 会议OA项目（五）---- 会议通知、反馈详情

    前言

    上一篇博客分享了我的审批功能。那么根据业务流程来，审批通过就到了会议通知。

    本次分享，会议通知以及通知后参会情况反馈。

    一、功能需求分析

            明确了，这次的目标，会议通知和反馈详情。

    会议通知：需要参加会议的人都能再自己登陆后再会议通知界面查看会议，并反馈是否参会，以及原因。

    反馈详情：会议的主持人可以在我的会议中查看会议详情，哪些人参会，哪些人不参加会议。哪些人未读会议通知。

    编写对应的SQL语句

    既然，分析完毕，那么就开始我们的编码工作吧。

    二、编码工作 

          1、  后台：

            MeetingFeedBack实体类

    1. package com.zking.entity;
    2.  
    3. import java.io.Serializable;
    4. /**
    5.  * 会议反馈表
    6.  * @author Administrator
    7.  *
    8.  */
    9. public class MeetingFeedBack implements Serializable {
    10.  
    11. 	private String id;
    12. 	private Long meetingId;
    13. 	private Integer personType;
    14. 	private Long personId;
    15. 	private Integer result;
    16. 	private String reason;
    17.  
    18. 	
    19. 	private String title;
    20.  
    21. 	public String getTitle() {
    22. 		return title;
    23. 	}
    24.  
    25. 	public void setTitle(String title) {
    26. 		this.title = title;
    27. 	}
    28.  
    29. 	public String getId() {
    30. 		return id;
    31. 	}
    32.  
    33. 	public void setId(String id) {
    34. 		this.id = id;
    35. 	}
    36.  
    37. 	public Long getMeetingId() {
    38. 		return meetingId;
    39. 	}
    40.  
    41. 	public void setMeetingId(Long meetingId) {
    42. 		this.meetingId = meetingId;
    43. 	}
    44.  
    45. 	public Integer getPersonType() {
    46. 		return personType;
    47. 	}
    48.  
    49. 	public void setPersonType(Integer personType) {
    50. 		this.personType = personType;
    51. 	}
    52.  
    53. 	public Long getPersonId() {
    54. 		return personId;
    55. 	}
    56.  
    57. 	public void setPersonId(Long personId) {
    58. 		this.personId = personId;
    59. 	}
    60.  
    61. 	public Integer getResult() {
    62. 		return result;
    63. 	}
    64.  
    65. 	public void setResult(Integer result) {
    66. 		this.result = result;
    67. 	}
    68.  
    69. 	public String getReason() {
    70. 		return reason;
    71. 	}
    72.  
    73. 	public void setReason(String reason) {
    74. 		this.reason = reason;
    75. 	}
    76.  
    77. 	public MeetingFeedBack() {
    78. 		super();
    79. 		// TODO Auto-generated constructor stub
    80. 	}
    81.  
    82. 	@Override
    83. 	public String toString() {
    84. 		return "MeetingFeedBack [id=" + id + ", meetingId=" + meetingId + ", personType=" + personType + ", personId="
    85. 				+ personId + ", result=" + result + ", reason=" + reason + "]";
    86. 	}
    87.  
    88. }

     MeetingFeedBackDao

    1. package com.zking.dao;
    2.  
    3. import java.sql.SQLException;
    4. import java.util.List;
    5. import java.util.Map;
    6. import java.util.UUID;
    7.  
    8. import com.zking.entity.MeetingFeedBack;
    9. import com.zking.util.BaseDao;
    10. import com.zking.util.PageBean;
    11.  
    12. public class MeetingFeedBackDao extends BaseDao {
    13. 		
    14. 	/**
    15. 	 * 会议通知：查询出我（当前登陆用户）需要参与的会议及会议的反馈信息（参会、缺席以及未读）
    16. 	 * @param back
    17. 	 * @param pageBean
    18. 	 * @return
    19. 	 */
    20. 	public List> 
    21. 			queryMeetingFeedBackByUserId(MeetingFeedBack back,PageBean pageBean) throws InstantiationException, IllegalAccessException, SQLException{
    22. 		String sql="select t1.*,ifnull(f.result,-1) result from \r\n" + 
    23. 				"(select * from t_oa_meeting_info where "
    24. 				+ "find_in_set('"+back.getPersonId()+"',concat(canyuze,',',liexize,',',zhuchiren))) t1 \r\n" + 
    25. 				"left join t_oa_meeting_feedback f on "
    26. 				+ "t1.id=f.meetingId and personId="+back.getPersonId()+" where f.result is null ";
    27. 		sql += " order by t1.id desc";
    28. 		System.out.println(sql);
    29. 		return super.executeQuery(sql, pageBean);
    30. 	}
    31. //会议反馈
    32. 	public int add(MeetingFeedBack back) throws Exception {
    33. 		String sql = "insert into t_oa_meeting_feedback values(?,?,?,?,?,?)";
    34. 		//前端没有传递id到后台 自己生成
    35. 		back.setId(UUID.randomUUID().toString().replaceAll("-", ""));
    36. 		return super.executeUpdate(sql, back, new String[] {"id","meetingId","personType","personId","result","reason"});
    37. 	}
    38.  
    39.  
    40. }

     MeetingFeedBackAction 

    1. package com.zking.web;
    2.  
    3. import java.io.IOException;
    4. import java.util.List;
    5. import java.util.Map;
    6.  
    7. import javax.servlet.ServletException;
    8. import javax.servlet.http.HttpServletRequest;
    9. import javax.servlet.http.HttpServletResponse;
    10.  
    11. import com.zking.dao.MeetingFeedBackDao;
    12. import com.zking.entity.MeetingFeedBack;
    13. import com.zking.framework.ActionSupport;
    14. import com.zking.framework.ModelDriver;
    15. import com.zking.util.CommonUtils;
    16. import com.zking.util.PageBean;
    17. import com.zking.util.R;
    18. import com.zking.util.ResponseUtil;
    19.  
    20.  
    21. public class MeetingFeedBackAction extends ActionSupport implements ModelDriver {
    22. 	private MeetingFeedBack back=new MeetingFeedBack();
    23. 	private MeetingFeedBackDao backDao=new MeetingFeedBackDao();
    24. 	@Override
    25. 	public MeetingFeedBack getModel() {
    26. 		return back;
    27. 	}
    28.  
    29. 	/**
    30. 	 * 会议通知分页查询
    31. 	 * @param req
    32. 	 * @param resp
    33. 	 */
    34. 	public String queryMeetingFeedBackByUserId(HttpServletRequest req,
    35. 			HttpServletResponse resp) throws ServletException,IOException{
    36. 		try {
    37. 			PageBean pageBean=new PageBean();
    38. 			pageBean.setRequest(req);
    39. 			List> lst = backDao.queryMeetingFeedBackByUserId(back, pageBean);
    40. 			ResponseUtil.writeJson(resp, R.ok(0, "会议通知数据查询成功", pageBean.getTotal(), lst));
    41. 		} catch (Exception e) {
    42. 			e.printStackTrace();
    43. 			try {
    44. 				ResponseUtil.writeJson(resp, R.error(0, "会议通知数据查询失败"));
    45. 			} catch (Exception e1) {
    46. 				e1.printStackTrace();
    47. 			}
    48. 		}
    49. 		
    50. 		return null;
    51. 	}
    52. }

          2、前台：

    meetingNotify.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/meetingNotify.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>
    19. <div class="layui-form-item" style="margin:15px 0px;">
    20.   <div class="layui-inline">
    21.     <label class="layui-form-label">会议标题label>
    22.     <div class="layui-input-inline">
    23.       <input type="hidden" id="personId" value="${user.id }"/>
    24.       <input type="text" id="title" autocomplete="off" class="layui-input">
    25.     div>
    26.   div>
    27.   <div class="layui-inline">
    28.     <button id="btn_search" type="button" class="layui-btn"><i class="layui-icon layui-icon-search">i> 查询button>
    29.   div>
    30. div>
    32. <table id="tb" lay-filter="tb" class="layui-table" style="margin-top:-15px">table>
    33.  
    34. <script type="text/html" id="tbar">
    35.   {{# if(d.result==-1){ }}
    36.   <a class="layui-btn layui-btn-xs" lay-event="edit">是否参会a>
    37.   {{# } }}
    38. script>
    39. body>
    40. html>

    meetingNotify.js

    1. let layer,table,$,form,test;
    2. var row;
    3. layui.use(['layer','table','jquery','form','test'],function(){
    4. 	layer=layui.layer,
    5. 	table=layui.table,
    6. 	form=layui.form,
    7. 	test=layui.test,
    8. 	$=layui.jquery;
    9. 	
    10. 	initTable();
    11. 	
    12. 	//查询事件
    13. 	$('#btn_search').click(function(){
    14. 		query();
    15. 	});
    16. 	
    17. });
    18.  
    19. //初始化数据表格（我的审批）
    20. function initTable(){
    21. 	table.render({          //执行渲染
    22.         elem: '#tb',   //指定原始表格元素选择器（推荐id选择器）
    23.         height: 400,         //自定义高度
    24.         loading: false,      //是否显示加载条（默认 true）
    25.         cols: [[             //设置表头
    26.             {field: 'id', title: '会议编号', width: 90},
    27.             {field: 'title', title: '会议标题', width: 120},
    28.             {field: 'location', title: '会议地点', width: 140},
    29.             {field: 'startTime', title: '开始时间', width: 120,
    30.             	templet:function(d){
    31.             		return test.toDate(new Date(d.startTime));
    32.             	}
    33.             },
    34.             {field: 'endTime', title: '结束时间', width: 120,
    35.             	templet:function(d){
    36.             		return test.toDate(new Date(d.endTime));
    37.             	}
    38.             },
    39.             {field: 'result', title: '反馈状态', width: 120,
    40.             	templet: function(d){
    41.                     if(d.result==1)
    42.                     	return "参会";
    43.                     else if(d.result==2)
    44.                     	return "缺席";
    45.                     else
    46.                     	return "未读";
    47.                 }
    48.             },
    49.             {field: '', title: '操作', width: 200,toolbar:'#tbar'},
    50.         ]]
    51.    });
    52. }
    53.  
    54. //点击查询
    55. function query(){
    56. 	table.reload('tb', {
    57.         url: '/feedBack.action',     //请求地址
    58.         method: 'POST',                    //请求方式，GET或者POST
    59.         loading: true,                     //是否显示加载条（默认 true）
    60.         page: true,                        //是否分页
    61.         where: {                           //设定异步数据接口的额外参数，任意设
    62.         	'methodName':'queryMeetingFeedBackByUserId',
    63.         	'personId':$('#personId').val(),
    64.         	'title':$('#title').val(),
    65.         },  
    66.         request: {                         //自定义分页请求参数名
    67.             pageName: 'page', //页码的参数名称，默认：page
    68.             limitName: 'rows' //每页数据量的参数名，默认：limit
    69.         },
    70.         done: function (res, curr, count) {
    71.         	console.log(res);
    72.         }
    73.    });
    74. 	
    75. 	//工具条事件
    76. 	table.on('tool(tb)', function(obj){ 
    77. 	  row = obj.data; //获得当前行数据
    78. 	  var layEvent = obj.event; 
    79. 	  var tr = obj.tr; 
    80. 	  console.log(row);
    81. 	  if(layEvent === 'edit'){ //是否参会
    82. 		  openLayer(row.id);
    83. 	  } else {
    84. 		  
    85. 	  }
    86. 	});
    87. }
    88. function openLayer(id){
    89.     layer.open({
    90.         type: 2,                    
    91.         title: '会议反馈',                   //对话框标题
    92.         area: ['660px', '400px'],   //宽高
    93.         skin: 'layui-layer-rim',    //样式类名
    94.         content: 'jsp/meeting/addFeedBack.jsp?id='+id,               
    95.         btn:['会议反馈','关闭'],
    96.         yes:function(index,layero){
    97.             let data= $(layero).find("iframe")[0].contentWindow.getData();
    98.             addMeetingFeedBack(data);
    99.         },
    100.         btn2:function(){
    101.         	layer.closeAll();
    102.         }
    103.     });
    104. }
    105.  
    106. // 对会议通知进行 参会/不参会的反馈
    107. function addMeetingFeedBack(params){
    108. 	params['methodName']="add";
    109. 	console.log(params);
    110. 	$.post('/feedBack.action',params,function(rs){
    111. 		if(rs.success){
    112. 			layer.closeAll();
    113. 			query();
    114. 		}else{
    115. 			layer.msg(rs.msg,{icon:5},function(){});
    116. 		}
    117. 	},'json');
    118. }

    addFeedBack.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/addFeedBack.js">script>
    9. head>
    10. <style>
    11. body{
    12. 	margin:5px;
    13. }
    14. style>
    15. <body>
    16. <div style="padding:10px;">
    17.     <form class="layui-form layui-form-pane" lay-filter="back">
    18.     	
    19.   		<input type="hidden" name="meetingId" value="${param.id }"/>
    20.   		<input type="hidden" name="personId" value="${sessionScope.user.id }"/>
    21.          <div class="layui-form-item">
    22.             <label class="layui-form-label">人员类型label>
    23.             <div class="layui-input-block">
    24.                 <select id="personType" name="personType">
    25.                 <option value="">请选择人员类型option>
    26.                 <option value="1">参会option>
    27.                 <option value="2">列席option>
    28. 			select>
    29.             div>
    30.         div>
    31.         <div class="layui-form-item">
    32.             <label class="layui-form-label">反馈结果label>
    33.             <div class="layui-input-block">
    34.                 <select id="result" name="result">
    35.                 <option value="">请选择反馈结果option>
    36.                 <option value="1">参加option>
    37.                 <option value="2">不参加option>
    38. 			select>
    39.             div>
    40.         div>
    41.         <div class="layui-form-item layui-form-text">
    42. 		    <label class="layui-form-label">不参与会议的原因label>
    43. 		    <div class="layui-input-block">
    44. 		      <textarea placeholder="请输入内容" name="reason" class="layui-textarea">textarea>
    45. 		    div>
    46. 		div>
    47.     form>
    48. div>
    49. body>
    50. html>

    addFeedBack.js

    1. let form,$;
    2. layui.use(['form','jquery'],function(){
    3. 	form=layui.form,
    4. 	$=layui.jquery;
    5. });
    6.  
    7.  
    8. function getData(){
    9. 	return form.val('back');
    10. }

     

     

  • 相关阅读:
    代码随想录笔记_动态规划_337打家劫舍III
    将小部分源码设计精髓带入到开发中来（工厂模式、适配器模式、抽象类、监听器）
    Lec14 File systems 笔记
    【算法与数据结构】回溯算法、贪心算法、动态规划、图论（笔记三）
    2、Flowable基础表结构
    查看指定 SAP CRM One Order 的 note 数据
    淘宝API接口，获得淘宝app商品详情原数据（Onebound数据）
    win10无损升级到win11
    模拟QQ相册上传图片（上传指定文件夹下所有的图片） 多线程上传（每个图片开辟一个子线程）
    数据结构（八）双向循环链表
  • 原文地址：https://blog.csdn.net/qq_62331938/article/details/126042763