会议通知和代开会议

目录

1.待开会议及所有会议功能开发

2.界面展示

---

1.待开会议及所有会议功能开发

package com.zking.dao;

import java.sql.SQLException;
import java.util.List;
import java.util.Map;
import java.util.UUID;

import com.zking.entity.MeetingFeedBack;
import com.zking.util.BaseDao;
import com.zking.util.PageBean;

public class MeetingFeedBackDao extends BaseDao<MeetingFeedBack> {
		
	/**
	 * 会议通知：查询出我（当前登陆用户）需要参与的会议及会议的反馈信息（参会、缺席以及未读）
	 * @param back
	 * @param pageBean
	 * @return
	 * @throws SQLException 
	 * @throws IllegalAccessException 
	 * @throws InstantiationException 
	 */
	public List<Map<String,Object>> 
			queryMeetingFeedBackByUserId(MeetingFeedBack back,PageBean pageBean) throws InstantiationException, IllegalAccessException, SQLException{
		String sql = "SELECT\r\n" + 
				"	IFNULL(f.result,-1)result,t1.*\r\n" + 
				" FROM\r\n" + 
				" (SELECT * FROM t_oa_meeting_info where FIND_IN_SET("+back.getPersonId()+",CONCAT(canyuze,',',liexize,',',zhuchiren)) and state = 4) t1\r\n" + 
				" left join t_oa_meeting_feedback f on t1.id = f.meetingId\r\n" + 
				" and f.personId = "+back.getPersonId()+"\r\n" + 
				" ORDER BY result";
		return super.executeQuery(sql, pageBean);
	}
//会议反馈
	public int add(MeetingFeedBack back) throws Exception {
		String sql = " insert into t_oa_meeting_feedback values(?,?,?,?,?,?)";
		back.setId(UUID.randomUUID().toString().replaceAll("-", ""));
		return super.executeUpdate(sql, back, new String[] {"id","meetingId","personType","personId","result","reason"});
	}
//	反馈详情
	public List<Map<String, Object>> queryMeetingBackByMeetingId(MeetingFeedBack back, PageBean pageBean) throws InstantiationException, IllegalAccessException, SQLException {
		String sql = " SELECT\r\n" + 
				" t.result,GROUP_CONCAT(t.name) names\r\n" + 
				" FROM\r\n" + 
				" (SELECT \r\n" + 
				" t1.name,IFNULL(f.result,-1) result\r\n" + 
				" FROM\r\n" + 
				" (SELECT * FROM t_oa_user where FIND_IN_SET(id,(SELECT CONCAT(canyuze,',',liexize,',',zhuchiren)FROM t_oa_meeting_info where id = "+back.getMeetingId()+"\r\n" + 
				" )))t1 \r\n" + 
				" left join t_oa_meeting_feedback f on t1.id = f.personId and f.meetingId = "+back.getMeetingId()+") t\r\n" + 
				" GROUP BY t.result";
		System.out.println(sql);
		return super.executeQuery(sql, pageBean);
	}
}

2.界面展示