📄 meetingserviceimpl.java
字号:
while(it.hasNext()){
permission = (BusinessMeetingPermission)it.next();
// status : 0-待审批、1-批准、2-不批准、3-转批、4-待通过、5-通过、6-不通过
if((permission.getStatus() == 0 || permission.getStatus() == 4)&& permission.getRemoved()== 0){
permission.setRemoved(1);
}
}
/*处理领导口头同意
* status : 0-待审批、1-批准、2-不批准、3-转批
*/
// if(!leader.equals("")){
// permission = new BusinessMeetingPermission();
// permission.setComment("口头同意");
// permission.setMeeting(meeting);
// permission.setOperateT(operateT);
// permission.setOperator(userName);
// permission.setRemoved(0);
// permission.setStatus(1);//批准
// permission.setPerson(leaderId);
// permissionDAO.save(permission);
// }
/*
* 审批申请
*/
permission = new BusinessMeetingPermission();
permission.setMeeting(meeting);
permission.setPerson(leader2Id);
if(status == 3){//当选择的是结束流程
permission.setStatus(4);//待通过
}else{
permission.setStatus(0);//待审批
}
permissionDAO.save(permission);
meeting.setMeetingInfo(meetingInfo);
meeting.setPermission(permissionRel);
meeting.setStatus(status);
meetingDAO.update(meeting);
}
/* (non-Javadoc)
* @see com.wondersgroup.businessmodule.meetingmanage.service.MeetingService#
* cancelRequest(java.lang.String)
* 取消会议申请
* 0 待发送、1 待审批、2审批未通过 3、审批通过 4、发布状态
* status : 0-待审批、1-批准、2-不批准、3-转批、4-待通过、5-通过、6-不通过
*
*/
public void cancelRequest(String code) {
meeting = (BusinessMeeting)meetingDAO.load(code);
meeting.setRemoved(3);
meetingDAO.update(meeting);
}
/* (non-Javadoc)
* @see com.wondersgroup.businessmodule.meetingmanage.service.MeetingService#
* countermandRequest(java.lang.String)
* 撤销会议申请
*/
public void countermandRequest(String code) {
meeting = (BusinessMeeting)meetingDAO.load(code);
meeting.setStatus(0);
Iterator it = meeting.getPermission().iterator();
while(it.hasNext()){
permission = (BusinessMeetingPermission)it.next();
// status : 0-待审批、1-批准、2-不批准、3-转批、4-待通过、5-通过、6-不通过
if(permission.getStatus() == 0 || permission.getStatus() == 4){
permission.setRemoved(1);
}
}
/*设置默认会议申请人
* 默认人员ID
* */
long defPerson = 1001;
permission = new BusinessMeetingPermission();
permission.setMeeting(meeting);
permission.setPerson(defPerson);
permission.setStatus(0);//待审批
permissionDAO.save(permission);
meetingDAO.update(meeting);
}
/* (non-Javadoc)
* @see com.wondersgroup.businessmodule.meetingmanage.service.MeetingService#
* removeRequest(java.lang.String)
* 逻辑删除会议申请
*/
public void removeRequest(String code) {
meeting = (BusinessMeeting)meetingDAO.load(code);
meeting.setRemoved(1);
meetingDAO.update(meeting);
}
/* (non-Javadoc)
* @see com.wondersgroup.businessmodule.meetingmanage.service.MeetingService#
* submitRequest(java.lang.String)
* 提交会议申请
*/
public void submitRequest(String code) {
meeting = (BusinessMeeting)meetingDAO.load(code);
meeting.setStatus(1);
meetingDAO.update(meeting);
}
/* (non-Javadoc)
* @see com.wondersgroup.businessmodule.meetingmanage.service.MeetingService#
* getMyPermissionMeetingList(java.lang.String, java.lang.String, java.lang.String,
* long, java.lang.String, int, int)
* 分页查询我的待审批会议申请记录
*/
public Page getMyPermissionMeetingList(String userId, String startTime,
String endTime, long roomId, String title, int curPage, int pageSize) {
System.out.println("待审批");
String hql = "select per from BusinessMeetingPermission per left outer join per.meeting meeting " +
"left outer join meeting.meetingInfo info " +
"where per.removed=0 and meeting.removed=0 and per.status=0 and meeting.status=1 and per.person=" + userId + " ";
String hql2 = "select count(per) from BusinessMeetingPermission per left outer join per.meeting meeting " +
"left outer join meeting.meetingInfo info " +
"where per.removed=0 and meeting.removed=0 and meeting.status=1 and per.status=0 and per.person=" + userId + " ";
List list1; // BO查询出来的List
List<MeetingRequestListElement> list2 = new ArrayList<MeetingRequestListElement>(); // 封装VO后的List
MeetingRequestListElement element;
/* 判断开始时间 */
if (!startTime.equals("")) {
hql += "and days(info.startTime)>days('" + startTime + "') ";
hql2 += "and days(info.startTime)>days('" + startTime + "') ";
}
/* 判断结束时间 */
if (!endTime.equals("")) {
hql += "and days(info.endTime)<days('" + endTime + "') ";
hql2 += "and days(info.endTime)<days('" + endTime + "') ";
}
/* 判断会议室查询条件 */
if (roomId != 0) {
hql += "and info.room.id=" + roomId + " ";
hql2 += "and info.room.id=" + roomId + " ";
}
/* 会议标题 */
if (!title.equals("")) {
hql += "and info.title like '%" + title + "%' ";
hql2 += "and info.title like '%" + title + "%' ";
}
page = meetingDAO.findByHQLWithPage(hql, curPage, pageSize, hql2);
list1 = page.getResult();
/* 如果查询出来的结果存在,进行封装为VO */
for (int i = 0; i < list1.size(); i++) {
permission = (BusinessMeetingPermission) list1.get(i);
element = new MeetingRequestListElement();
element.setTitle(permission.getMeeting().getMeetingInfo().getTitle());
System.out.println(permission.getId());
element.setPerId(String.valueOf(permission.getId()));
if (permission.getMeeting().getMeetingInfo().getEndTime() != null)
element.setEndTime(permission.getMeeting().getMeetingInfo().getEndTime().toLocaleString());
else
element.setEndTime("--/--");
element.setId(String.valueOf(permission.getMeeting().getId()));
element.setPerson(permission.getMeeting().getMeetingInfo().getModerator());
element.setPosition(permission.getMeeting().getMeetingInfo().getRoom()
.getRoomInfo().getPosition());
if (permission.getMeeting().getMeetingInfo().getStartTime() != null)
element.setStartTime(permission.getMeeting().getMeetingInfo().getStartTime().toLocaleString());
else
element.setStartTime("--/--");
/*
* 判断申请状态 标示符 表示当前请求所处的状态: 0 待发送、1 待审批、2审批未通过 3、审批通过 4、发布状态
*/
if (permission.getMeeting().getStatus() == 0)
element.setStatus("待发送");
else if (permission.getMeeting().getStatus() == 1)
element.setStatus("待审批");
else if (permission.getMeeting().getStatus() == 2)
element.setStatus("审批未通过");
else if (permission.getMeeting().getStatus() == 3)
element.setStatus("审批通过");
else
element.setStatus("发布状态");
list2.add(element);
}
/*重新将VO的List封装到Page里*/
page.setResult(list2);
return page;
}
/* (non-Javadoc)
* @see com.wondersgroup.businessmodule.meetingmanage.service.MeetingService#
* getMyPermissionMeetingList(java.lang.String, java.lang.String, java.lang.String,
* long, java.lang.String, int, int)
* 分页查询我的已审批会议申请记录
*/
public Page getMyPermissionMeetingList(String userId, String startTime,
String endTime, long roomId, String title, String flag, int curPage, int pageSize) {
// status : 0-待审批、1-批准、2-不批准、3-转批、4-待通过、5-通过、6-不通过
String hql = "select distinct meeting from BusinessMeetingPermission per right outer join per.meeting meeting " +
"left outer join meeting.meetingInfo info " +
"where per.removed=0 and meeting.removed=0 and meeting.status>0 " +
" and (per.status=1 or per.status=2 or per.status=3) and per.person=" + userId + " ";
String hql2 = "select count(distinct meeting) from BusinessMeetingPermission per right outer join per.meeting meeting " +
"left outer join meeting.meetingInfo info " +
"where per.removed=0 and meeting.removed=0 and meeting.status>0 and " +
"(per.status>0) and per.person=" + userId + " ";
List list1; // BO查询出来的List
List<MeetingRequestListElement> list2 = new ArrayList<MeetingRequestListElement>(); // 封装VO后的List
MeetingRequestListElement element;
/* 判断开始时间 */
if (!startTime.equals("")) {
hql += "and days(info.startTime)>days('" + startTime + "') ";
hql2 += "and days(info.startTime)>days('" + startTime + "') ";
}
/* 判断结束时间 */
if (!endTime.equals("")) {
hql += "and days(info.endTime)<days('" + endTime + "') ";
hql2 += "and days(info.endTime)<days('" + endTime + "') ";
}
/* 判断会议室查询条件 */
if (roomId != 0) {
hql += "and info.room.id=" + roomId + " ";
hql2 += "and info.room.id=" + roomId + " ";
}
/* 会议标题 */
if (!title.equals("")) {
hql += "and info.title like '%" + title + "%' ";
hql2 += "and info.title like '%" + title + "%' ";
}
page = meetingDAO.findByHQLWithPage(hql, curPage, pageSize, hql2);
list1 = page.getResult();
/* 如果查询出来的结果存在,进行封装为VO */
for (int i = 0; i < list1.size(); i++) {
meeting = (BusinessMeeting) list1.get(i);
element = new MeetingRequestListElement();
element.setTitle(meeting.getMeetingInfo().getTitle());
if (meeting.getMeetingInfo().getEndTime() != null)
element.setEndTime(meeting.getMeetingInfo().getEndTime().toLocaleString());
else
element.setEndTime("--/--");
element.setId(String.valueOf(meeting.getId()));
element.setPerson(meeting.getMeetingInfo().getModerator());
element.setPosition(meeting.getMeetingInfo().getRoom()
.getRoomInfo().getPosition());
if (meeting.getMeetingInfo().getStartTime() != null)
element.setStartTime(meeting.getMeetingInfo().getStartTime().toLocaleString());
else
element.setStartTime("--/--");
/*
* 判断申请状态 标示符 表示当前请求所处的状态: 0 待发送、1 待审批、2审批未通过 3、审批通过 4、发布状态
*/
if (meeting.getStatus() == 0)
element.setStatus("待发送");
else if (meeting.getStatus() == 1)
element.setStatus("待审批");
else if (meeting.getStatus() == 2)
element.setStatus("审批未通过");
else if (meeting.getStatus() == 3)
element.setStatus("审批通过");
else
element.setStatus("发布状态");
list2.add(element);
}
/*重新将VO的List封装到Page里*/
page.setResult(list2);
return page;
}
/* (non-Javadoc)
* @see com.wondersgroup.businessmodule.meetingmanage.service.MeetingService#
* getMyPromulgateMeetingList(java.lang.String, java.lang.String, java.lang.String,
* long, java.lang.String, int, int)
*/
public Page getMyPromulgateMeetingList(String userId, String startTime,
String endTime, long roomId, String title, String flag, int curPage, int pageSize) {
// TODO Auto-generated method stub
String hql = "select per from BusinessMeetingPermission per left outer join per.meeting meeting " +
"left outer join meeting.meetingInfo info " +
"where per.removed=0 and meeting.removed=0 and per.person=" + userId + " ";
String hql2 = "select count(per) from BusinessMeetingPermission per left outer join per.meeting meeting " +
"left outer join meeting.meetingInfo info " +
"where per.removed=0 and meeting.removed=0 and per.person=" + userId + " ";
List list1; // BO查询出来的List
List<MeetingRequestListElement> list2 = new ArrayList<MeetingRequestListElement>(); // 封装VO后的List
MeetingRequestListElement element;
/* 判断开始时间 */
if (!startTime.equals("")) {
hql += "and days(info.startTime)>days('" + startTime + "') ";
hql2 += "and days(info.startTime)>days('" + startTime + "') ";
}
/* 判断结束时间 */
if (!endTime.equals("")) {
hql += "and days(info.endTime)<days('" + endTime + "') ";
hql2 += "and days(info.endTime)<days('" + endTime + "') ";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -