zboameetingcontentmanager.java

java基础教程

	/**
	 * 根据具体的会议室id号得到这一会议室在某天的具体会议开始时间，得到一数字内容的字符串
	 * @param roomid
	 * @param date
	 * @param session
	 * @return
	 * @throws Exception
	 */
	public static String getStartTime(	int roomid,
										String date,
										Session session) throws Exception
	{
		String inittime = date + " " + "08:00:00";
		String overtime = date + " " + "17:30:00";
		String starttime = "";
		String star = "";
		String sqlst = "from ZboaMeetingcontent meeting where meeting.Roomid=" + roomid
				+ " and meeting.Starttime between to_date('" + inittime + "', 'YYYY-MM-DD HH24:MI:SS')"
				+ " and to_date('" + overtime + "', 'YYYY-MM-DD HH24:MI:SS')" + " and  meeting.Meetingstatus in (2,3) ";
		Query query1 = session.createQuery(sqlst);
		List st = query1.list();
		if (st != null && st.size() > 0)
		{
			for (int i = 0; i < st.size(); i++)
			{
				ZboaMeetingcontent meetingcontent = (ZboaMeetingcontent) st.get(i);
				String startDateTime = Tools.getDateTimeString((meetingcontent.getStarttime()).getTime());
				starttime = starttime + Integer.toString(Tools.getTimeInt(startDateTime)) + ",";
			}
			star = starttime.substring(0, starttime.length() - 1);
		}
		return star;
	}

	/**
	 * 根据具体的会议室id号得到这一会议室在某天的具体会议结束时间，得到一数字内容的字符串
	 * @param roomid
	 * @param date
	 * @param session
	 * @return
	 * @throws Exception
	 */
	public static String getEndTime(int roomid,
									String date,
									Session session) throws Exception
	{
		String inittime = date + " " + "08:00:00";
		String overtime = date + " " + "17:30:00";
		String endtime = "";
		String end = "";
		String sqlst = "from ZboaMeetingcontent meeting where meeting.Roomid=" + roomid
				+ " and meeting.Endtime between to_date('" + inittime + "', 'YYYY-MM-DD HH24:MI:SS')"
				+ " and to_date('" + overtime + "', 'YYYY-MM-DD HH24:MI:SS')" + " and  meeting.Meetingstatus in (2,3) ";
		Query query1 = session.createQuery(sqlst);
		List st = query1.list();
		if (st != null && st.size() > 0)
		{
			for (int i = 0; i < st.size(); i++)
			{
				ZboaMeetingcontent meetingcontent = (ZboaMeetingcontent) st.get(i);
				String endDateTime = Tools.getDateTimeString((meetingcontent.getEndtime()).getTime());
				endtime = endtime + Integer.toString(Tools.getTimeInt(endDateTime)) + ",";
			}
			end = endtime.substring(0, endtime.length() - 1);
		}
		return end;
	}

	/**
	 * 根据会议编号查找相应的会议
	 * @param id 会议id号
	 */
	public static ZboaMeetingcontent viewMeetingcontent(int id) throws Exception
	{
		Session session = SessionDAO.createSession();
		ZboaMeetingcontent meetingcontent = new ZboaMeetingcontent();
		String sql = "from ZboaMeetingcontent meeting where meeting.Meetingid=" + id;
		Query query = session.createQuery(sql);
		List listQueryResult = query.list();
		if (listQueryResult != null && listQueryResult.size() > 0)
		{
			meetingcontent = (ZboaMeetingcontent) listQueryResult.get(0);
		}
		return meetingcontent;

	}

	/**
	 * 对请示的会议作出审批
	 * @param form ActionForm
	 */
	public static void ExamiMeeting(ActionForm form) throws Exception
	{

		MeetingcontentForm meeting = (MeetingcontentForm) form;
		ZboaMeetingcontent meetingcontent = meetingDao.load(new Integer(meeting.getId()));
		TodoManager.DelTodoItem(Integer.toString(meeting.getId()), new Integer(meeting.getOaUserId()),  FwConst.TODO_HUIYI);
		String userids=JztinyrightusersroleManager.getRoleuserId(FwConst.OA_ROLEID_ZONGJB);
		if (meeting.getIsaccept() == 1)
		{
			meetingcontent.setMeetingstatus(new Integer(1));
			ArangeToDoAdd(meeting.getId(), userids,meeting.getOaUserName());
		}
		else
		{
			meetingcontent.setMeetingstatus(new Integer(4));
		}
		meetingcontent.setAuditcontent(meeting.getAuditconten());
		Calendar cal = Calendar.getInstance();
		meetingcontent.setAudittime(cal);
		Integer user = new Integer(Integer.parseInt(meeting.getOaUserId()));
		meetingcontent.setAudituser(user);
		meetingDao.update(meetingcontent);

	}

	/**
	 * 对通过审批的会议作出具体安排
	 * @param form ActionForm
	 */
	public static void ArrangeMeeting(ActionForm form) throws Exception
	{

		MeetingcontentForm meeting = (MeetingcontentForm) form;
		String flag = meeting.getFlag();
		ZboaMeetingcontent meetingcontent = meetingDao.load(new Integer(meeting.getId()));
		TodoManager.DelTodoAll(Integer.toString(meeting.getId()), FwConst.TODO_HUIYI);
        PostNoticeToDoAdd(meeting.getId(),meetingcontent.getMeetingcharge().toString(),meeting.getOaUserName());
		if (meeting.getRoomid() != null)
		{
			ZboaMeetingroom room = roomDao.load(new Integer(meeting.getRoomid()));
			meetingcontent.setRoomid(room);
		}
		if (meeting.getMeettitle() != null && !meeting.getMeettitle().equals(""))
		{
			meetingcontent.setMeetingtitle(meeting.getMeettitle());
		}
		if (meeting.getMeetcontent() != null && !meeting.getMeetcontent().equals(""))
		{
			meetingcontent.setMeetingcontent(meeting.getMeetcontent());
		}

		if (flag == null)
		{
			meetingcontent.setMeetingstatus(new Integer(2));
		}
		else if (flag.equals("nochange"))
		{

			meetingcontent.setMeetingstatus(new Integer(0));
			if (meeting.getMeetinchargeleader() != null && !meeting.getMeetinchargeleader().equals(""))
			{
				meetingcontent.setAudituser(new Integer(Integer.parseInt(meeting.getMeetinchargeleader())));
			}
			// meetingcontent.setAudituser(null);
			meetingcontent.setAuditcontent(null);
			meetingcontent.setAudittime(null);

		}
		Calendar star = Calendar.getInstance();
		star.clear();
		star.setTime(Tools.getDateTime(meeting.getStarttime()));
		Calendar end = Calendar.getInstance();
		end.clear();
		end.setTime(Tools.getDateTime(meeting.getEndtime()));
		meetingcontent.setStarttime(star);
		meetingcontent.setEndtime(end);

		if (meeting.getMeetingdepartid() != null && !meeting.getMeetingdepartid().equals(""))			
		{    
			meetingcontent.setMeetingusers(checkUsers(meeting.getMeetingleaderid(),meeting.getMeetingdepartid()));
			//meetingcontent.setMeetingusers(meeting.getMeetingdepartid());
		}
		if (meeting.getMeetingleaderid() != null && !meeting.getMeetingleaderid().equals(""))
		{
			meetingcontent.setMeetingleaders(meeting.getMeetingleaderid());
		}

		meetingcontent.setIndexorno(new Integer(meeting.getIsindex()));

		meetingcontent.setMeetingtype(new Integer(meeting.getMeetingType()));
		meetingcontent.setSignify(new Integer(meeting.getImportant()));
		meetingDao.update(meetingcontent);

	}

	/**
	 * 根据会议室编号查出对应的会议
	 * @param form ActionForm
	 */
	public static ZboaMeetingcontent Roomview(ActionForm form) throws Exception
	{
		Session session = SessionDAO.createSession();
		ZboaMeetingcontent meetingcontent = new ZboaMeetingcontent();
		MeetingcontentForm meeting = (MeetingcontentForm) form;
		int roomid = Integer.parseInt(meeting.getRoomid());
		String sql = "from ZboaMeetingcontent meeting where meeting.Roomid=" + roomid;
		Query query = session.createQuery(sql);
		List listQueryResult = query.list();
		if (listQueryResult != null && listQueryResult.size() > 0)
		{
			meetingcontent = (ZboaMeetingcontent) listQueryResult.get(0);
		}

		return meetingcontent;

	}

	/**
	 * 删除会议，先删会议记录表，后删会议人员表
	 * @param form ActionForm
	 */
	public static void deleteEntiny(ActionForm form) throws Exception
	{
		Session session = SessionDAO.createSession();
		Transaction tx = session.beginTransaction();
		try
		{
			MeetingcontentForm meeting = (MeetingcontentForm) form;
			int id = meeting.getId();
			deleteMeeting(id, session);
			// deletemeetinguser(id, session);

			tx.commit();
		}
		catch (Exception Ex)
		{
			Ex.printStackTrace();
			tx.rollback();
		}
	}

	/**
	 * 删除会议记录表
	 * @param meetingid 会议id
	 * @param session session
	 * @throws Exception
	 */

	public static void deleteMeeting(	int id,
										Session session) throws Exception
	{
		// Session session = SessionDAO.createSession();
		ZboaMeetingcontent meetingcontent = meetingDao.load(new Integer(id), session);
		meetingDao.delete(meetingcontent, session);

	}

	/**
	 * 删除会议人员表
	 * @param meetingid 会议id
	 * @param form actionform
	 * @param session session
	 * @throws Exception
	 */

	public static void deletemeetinguser(	int meetingid,
											Session session) throws Exception
	{

		// MeetingcontentForm meeting = (MeetingcontentForm) form;
		ZboaMeetinguserManger.delUsers(meetingid, session);

	}

	/**
	 * 发送会议通知，通过修改会议状态来实现,在发送通知的同时创建参会人员表的记录
	 * @param form
	 * @throws Exception
	 */
	public static void postNotice(ActionForm form) throws Exception
	{

		Session session = _BaseRootDAO.createSession();
		Transaction tx = session.beginTransaction();
		MeetingcontentForm meeting = (MeetingcontentForm) form;
		
		
		try
		{
		

			beforeMeetingstart(meeting, session);
			createReflectUser(meeting, session);
			tx.commit();
			
		}

		catch (Exception ex)
		{
			tx.rollback();
			ex.printStackTrace();
			throw new FWException(ex.getMessage());
		}
	}

	/**
	 * 调整会议人员，把会议状态变为已通知
	 * @param form
	 * @param session
	 * @throws Exception
	 */
	public static void beforeMeetingstart(	ActionForm form,
											Session session) throws Exception
	{
		MeetingcontentForm meeting = (MeetingcontentForm) form;
		ZboaMeetingcontent meetingcontent = meetingDao.load(new Integer(meeting.getId()), session);
		if (meeting.getMeetingleaderid() != null && !meeting.getMeetingleaderid().equals(""))
		{
			
			meetingcontent.setMeetingleaders(meeting.getMeetingleaderid());
		}
		if (meeting.getMeetingdepartid() != null && !meeting.getMeetingdepartid().equals(""))
		{  
			meetingcontent.setMeetingusers(checkUsers(meeting.getMeetingleaderid(),meeting.getMeetingdepartid()));
			//meetingcontent.setMeetingusers(meeting.getMeetingdepartid());
		}
		// meetingcontent.setIndexorno(new Integer(meeting.getIsindex()));

		meetingcontent.setMeetingstatus(new Integer(3));
		// meetingDao.update(meetingcontent, session);
		// session.update(meetingcontent);
		meetingDao.update(meetingcontent, session);
	}

	/**
	 * 根据会议室id创建参会人员记录
	 * @param form
	 * @param session
	 * @throws Exception
	 */
	public static void createReflectUser(	ActionForm form,
											Session session) throws Exception
	{
		MeetingcontentForm meeting = (MeetingcontentForm) form;
		if (meeting.getMeetingleaderid() != null && !meeting.getMeetingleaderid().equals(""))
		{
			ZboaMeetinguserManger.AddmeetingLeadUser(meeting.getId(), meeting.getMeetingleaderid(), session);
		}
		if (meeting.getMeetingdepartid() != null && !meeting.getMeetingdepartid().equals(""))
		{   
			//ZboaMeetinguserManger.AddmeetingDepartUser(meeting.getId(), meeting.getMeetingdepartid(), session);
			ZboaMeetinguserManger.AddmeetingDepartUser(meeting.getId(), checkUsers(meeting.getMeetingleaderid(),meeting.getMeetingdepartid()), session);
		}
	}

	/**
	 * 在进入查看页面前的formbean中数据的预处理
	 * @param id
	 * @param form
	 * @return
	 * @throws Exception
	 */
	public static MeetingcontentForm viewInit(	int id,
												ActionForm form) throws Exception
	{

		ZboaMeetingcontent meetingcontent = ZboaMeetingcontentManager.viewMeetingcontent(id);
		String startDateTime = Tools.getDateTimeString((meetingcontent.getStarttime()).getTime());
		String endDateTime = Tools.getDateTimeString((meetingcontent.getEndtime()).getTime());
		MeetingcontentForm meeting = (MeetingcontentForm) form;
		if (meetingcontent.getMeetingid() != null)
		{
			meeting.setId((meetingcontent.getMeetingid()).intValue());
		}
		if (meetingcontent.getSignify() != null)
		{
			meeting.setImportant((meetingcontent.getSignify()).intValue());
		}
		if (meetingcontent.getIndexorno() != null)
		{
			meeting.setIsindex((meetingcontent.getIndexorno()).intValue());
		}
		if (meetingcontent.getMeetingtype() != null && !meetingcontent.getMeetingtype().equals(""))
		{
			meeting.setMeetingType((meetingcontent.getMeetingtype()).toString());
		}
		if (meetingcontent.getRoomid() != null)
		{
			meeting.setRoomid((meetingcontent.getRoomid().getRoomid()).toString());
		}

		meeting.setMeettitle(meetingcontent.getMeetingtitle());
		String operaname = JzdepartmentuserManger.IdtransName((meetingcontent.getMeetingcharge()).intValue());
		meeting.setMeetopera(operaname);
		meeting.setMeetcontent(meetingcontent.getMeetingcontent());
		if (meetingcontent.getMeetingusers() != null && !meetingcontent.getMeetingusers().equals(""))
		{
			meeting.setMeetdepart(ZboaMeetinguserManger.getusername(meetingcontent.getMeetingusers()));
		}
		if (meetingcontent.getMeetingleaders() != null && !meetingcontent.getMeetingleaders().equals(""))
		{
			meeting.setMeetleader(ZboaMeetinguserManger.getusername(meetingcontent.getMeetingleaders()));
		}
		meeting.setMeetingdepartid(meetingcontent.getMeetingusers());
		meeting.setMeetingleaderid(meetingcontent.getMeetingleaders());
		meeting.setMeetingDate(Tools.getTimesDate(startDateTime));

		meeting.setStarttime(Integer.toString(Tools.getTimeInt(startDateTime)));
		meeting.setEndtime(Integer.toString(Tools.getTimeInt(endDateTime)));

		String auditconten = "";
		String audituer = "";
		String auditime = "";
		if (meetingcontent.getAuditcontent() != null)
		{
			auditconten = meetingcontent.getAuditcontent();
		}
		if (meetingcontent.getAudituser() != null)
		{
			int audituerid = meetingcontent.getAudituser().intValue();
			audituer = JzdepartmentuserManger.IdtransName(audituerid);
		}
		if (meetingcontent.getAudittime() != null)
		{
			auditime = Tools.getDateTimeString((meetingcontent.getAudittime()).getTime());
		}
		meeting.setAuditconten(auditconten);
		meeting.setAudiuser(audituer);
		meeting.setAuditime(auditime);
		return meeting;
	}

	

	protected Query getQuery(	Session session,
								ActionForm form) throws Exception
	{

		return session.createQuery(this.getHql((AbstractForm) form, session));
	}

	protected Query getQueryForNoPage(	Session session,
										ActionForm form) throws Exception
	{

		return null;
	}
}