dhtmlxscheduler使用

lcpstyle

浏览: 14146 次
性别:
来自: 成都

最近访客更多访客>>

hzjdwb

suncong1024

hwthwt

woodding2008

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

博客分类：

scheduler

scheduler

　　最近项目中需要一个日程管理的功能，找啊找，先是用的fullcalendar，不知道是人品还是版本问题，events接受后台JSON参数总是出错，试了许多方法，也没有试出什么结果来。所以果断换到了dhtmlxscheduler，这个插件网上搜索结果较少，我也是自己从官方网站的文档自己慢慢摸索，做了一个不算日程表的日程表。主要是样式这些还没搞懂，对于英文实在缺乏的我感到很吃力。现在已经萌生了重拾英语的想法。闲话不多说，留此文已做记录，免得下次用到无从下手。

　　结果是这样的，样式基本没有改动，但功能齐全。springMVC+mysql。

dhtmlscheduler下载地址：http://docs.dhtmlx.com/scheduler/index.html

dhtmlscheduler文档地址：http://docs.dhtmlx.com/scheduler/api__refs__scheduler.html

可以删除一些不必要的，只留需要的就可以了。

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>日程管理</title>
   
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->
	<!-- jquery -->
	<script type="text/javascript" src='<%=basePath %>static/js/jquery/jquery-1.11.0.min.js'></script>	
	<script src="${res}/static/js/artDialog/jquery.artDialog.js?skin=default" type="text/javascript"></script>
	<link rel="stylesheet" type="txt/css" href="${res}/static/css/yz.css" />
	<!-- dhtmlscheduler -->
	<script src="<%=basePath %>static/js/dhtmlxscheduler/codebase/dhtmlxscheduler.js" type="text/javascript" charset="utf-8"></script>
    <link rel="stylesheet" href="<%=basePath %>static/js/dhtmlxscheduler/codebase/dhtmlxscheduler.css" type="text/css" media="screen" title="no title" charset="utf-8">
	<script src="<%=basePath %>static/js/dhtmlxscheduler/codebase/sources/ext/dhtmlxscheduler_minical.js" type="text/javascript"></script>
	<script src="<%=basePath %>static/js/dhtmlxscheduler/codebase/sources/dhtmlxscheduler.js" type="text/javascript"></script>
	<script src="<%=basePath %>static/js/dhtmlxscheduler/codebase/ext/dhtmlxscheduler_minical.js" type="text/javascript"></script>
	<script src="<%=basePath %>static/js/dhtmlxscheduler/codebase/sources/locale/locale_cn.js" type="text/javascript"></script>

<style type="text/css" media="screen">
   html, body{
      margin:0px;
      padding:0px;
      height:100%;
      overflow:hidden;
   }   
</style>

<script type="text/javascript" charset="utf-8">
$(function() {
    init();
    $("#dhx_minical_icon").click(show_minical);


	function init() {
		scheduler.config.multi_day = true;  
		scheduler.config.drag_move = false;
		scheduler.config.icons_edit = ['icon_custom', 'icon_save', 'icon_cancel'];
		scheduler.config.icons_select = ['icon_details', 'icon_delete'];
        scheduler.config.xml_date="%Y-%m-%d %H:%i";  
        scheduler.init('scheduler_here',new Date(),"month");  
		$.ajax({    
	        url: '/calendar/calendar',  
	        cache:false,    
	        success:function(data) {    
	            var events = [];    
	            var info = eval(data);    
	            for (var i = 0; i < info.length; i++) {
	                var ev = info[i];
	                var title = ev.event;
	                var start = ev.startDate;
	                var end = ev.endDate;
	                var id = ev.pid;
	                //组装日程
	               events.push({
	                    id:id,
	                    text:title,
	                    start_date:start,
	                    end_date:end
	               });
	                 
	            }
	            scheduler.parse(events, "json");
	          },
	          error:function() {
	              alert('数据错误！');
	          }
	      });
	      
	      /**
	      *添加保存事件数据操作
	      */
	      scheduler.attachEvent("onEventSave",function(id,ev,is_new){
    	if (!ev.text) {
    		alert("描述信息不能为空！");
    		
        	return false;
    		}
    	if(ev.start_date>ev.end_date){
    		alert("开始时间不能在结束时间之后");
    		return false;
    	}
    		var parms = {pid:id,event:ev.text,startDate:ev.start_date,endDate:ev.end_date};
    		$.post("/calendar/add",parms,function(data,status){
    			if(data.result=="SUCCESS"){
    				
    				$.dialog({
						title: '消息',
						id: "T90" ,
					    time: 3 ,
					    icon: 'warning' ,
					    content: data.msg,
					    close:function(){
							$("#loginName").focus();
					    }
					});

    			}
    			if(data.result=="ERROR"){
    				$.dialog({
						title: '消息',
						id: "T90" ,
					    time: 3 ,
					    icon: 'warning' ,
					    content: data.msg ,
					    close:function(){
							$("#loginName").focus();
					    }
					});
    				scheduler.deleteEvent(id); 
    			}
    			
    		});
    		return true;
});		
	      /**
	      *添加删除事件数据操作
	      */
	      scheduler.attachEvent("onBeforeEventDelete", function(id,e){
	    	  var parms = {pid:id};
	    		$.post("/calendar/delete",parms,function(data,status){
	    			if(data.result=="SUCCESS"){
	    				$.dialog({
	    					title: '消息',
	    					id: "T90" ,
	    				    time: 3 ,
	    				    icon: 'warning' ,
	    				    content: data.msg ,
	    				    close:function(){
	    						$("#loginName").focus();
	    				    }
	    				});
	    			}
	    		});	    		
	    	    return true;
	    	});
	      /**
		      *添加编辑事件数据操作
		      */
	      scheduler.attachEvent("onEventChanged", function(id,ev){
	    	  var parms = {pid:id,event:ev.text,startDate:ev.start_date,endDate:ev.end_date};
	    		$.post("/calendar/add",parms,function(data,status){
	    			
	    			if(data.result=="SUCCESS"){
	    				$.dialog({
	    					title: '消息',
	    					id: "T90" ,
	    				    time: 3 ,
	    				    icon: 'warning' ,
	    				    content: data.msg ,
	    				    close:function(){
	    						$("#loginName").focus();
	    				    }
	    				});
	    			}
	    		});
	    		return true;
	    	});
	}
	//显示迷你日历表
	function show_minical(){
		if (scheduler.isCalendarVisible())
			scheduler.destroyCalendar();
		else
			scheduler.renderCalendar({
				position:"dhx_minical_icon",
				date:scheduler._date,
				navigation:true,
				handler:function(date,calendar){
					scheduler.setCurrentView(date);
					scheduler.destroyCalendar()
				}
			});
	}
});

</script>

<body>
	<%@ include file="/WEB-INF/layouts/header.jsp"%>
   <div id="scheduler_here" class="dhx_cal_container" style='width:100%; height:64%;'>
      <div class="dhx_cal_navline">
         <div class="dhx_cal_prev_button"></div>
         <div class="dhx_cal_next_button"></div>
         <div class="dhx_cal_today_button"></div>
         <div class="dhx_cal_date"></div>
         <div class="dhx_minical_icon" id="dhx_minical_icon"></div>
         <div class="dhx_cal_tab" name="day_tab" style="right:204px;"></div>
         <div class="dhx_cal_tab" name="week_tab" style="right:140px;"></div>
         <div class="dhx_cal_tab" name="month_tab" style="right:76px;"></div>
      </div>
      <div class="dhx_cal_header">
      </div>
      <div class="dhx_cal_data">
      </div>
   </div>
   <%@ include file="/WEB-INF/layouts/footer.jsp"%>
</body>  
  
</html>

这是jsp代码，下面是calendarPo.java：

package com.glory.learn.po.studentLog;

import java.util.Date;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;

import org.codehaus.jackson.map.annotate.JsonSerialize;

import com.glory.learn.util.CustomDateSerializer;

/**
 * 日程表
 * @param 
 * @param 
 * @return
 */
@Entity
@Table(name = "calendar_info")
public class CalendarPo {

	private Integer id;		//数据库标识
	private String pid;		//页面ID
	private Integer studentId;		//学生Id
	private String event;	//事件
	private Date startDate;	//开始时间
	private Date endDate;	//结束时间
	
	@Id
	@Column(name = "id")
	@GeneratedValue(strategy = GenerationType.AUTO)
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	
	@Column(name = "pid")
	public String getPid() {
		return pid;
	}
	public void setPid(String pid) {
		this.pid = pid;
	}
	@Column(name = "studentId")
	public Integer getStudentId() {
		return studentId;
	}
	public void setStudentId(Integer studentId) {
		this.studentId = studentId;
	}
	
	@Column(name = "event")
	public String getEvent() {
		return event;
	}
	public void setEvent(String event) {
		this.event = event;
	}
	
	@Column(name = "startDate")
	@Temporal(TemporalType.TIMESTAMP)
	@JsonSerialize(using = CustomDateSerializer.class)
	public Date getStartDate() {
		return startDate;
	}
	public void setStartDate(Date startDate) {
		this.startDate = startDate;
	}
	
	@Column(name = "endDate")
	@Temporal(TemporalType.TIMESTAMP)
	@JsonSerialize(using = CustomDateSerializer.class)
	public Date getEndDate() {
		return endDate;
	}
	public void setEndDate(Date endDate) {
		this.endDate = endDate;
	}
	
	
}

日期get方法上的@JsonSerialize(using = CustomDateSerializer.class)是让json返回的日期类型按指定的样式返回。CustomDateSerializer.java代码如下：

package com.glory.learn.util;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.Date;

import org.codehaus.jackson.JsonGenerator;
import org.codehaus.jackson.JsonProcessingException;
import org.codehaus.jackson.map.JsonSerializer;
import org.codehaus.jackson.map.SerializerProvider;

/**
 * 自定义返回JSON 数据格中日期格式化处理
*
 * @author <a href="http://www.micmiu.com">Michael Sun</a>
*/
public class CustomDateSerializer extends JsonSerializer<Date> {

@Override

public void serialize(Date value, JsonGenerator jgen,



SerializerProvider provider) throws IOException,



JsonProcessingException {


SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");


String formattedDate = formatter.format(value);


jgen.writeString(formattedDate);

}

}

下面为controller代码：

package com.glory.learn.action.student.log;

import java.util.List;

import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;

import com.glory.learn.bo.studentLog.CalendarBo;
import com.glory.learn.po.studentLog.CalendarPo;
import com.glory.learn.po.user.UserPo;
import com.glory.learn.util.Statics;
import com.glory.learn.vo.common.JsonResult;
import com.glory.learn.vo.common.Result;

@Controller
@RequestMapping(value = "/student/calendar/")
public class CalendarController {
	
	@Autowired
	CalendarBo calendarBo;
	
	@RequestMapping(value = "list",method = RequestMethod.GET)
	public String goPage() {
		
		return "student/calendar/dhtmlcal";
	}
	
	
	/**
	 * 返回用户所有日程信息（json格式）
	 * @param session
	 * @param response
	 * @return
	 */
	@RequestMapping(value = "calendar",method = RequestMethod.GET)
	public @ResponseBody List<CalendarPo> getPage(HttpSession session,HttpServletResponse response) {
		UserPo userPo = (UserPo) session.getAttribute(Statics.USERPO);
		List<CalendarPo> list = calendarBo.getByStudent(userPo.getId());
		
		return list;
	}
	
	/**
	 * 添加OR修改
	 * @param session
	 * @param calendarPo
	 * @param id
	 * @return
	 */
	@RequestMapping(value = "add")
	public @ResponseBody JsonResult addCalendar(HttpSession session,CalendarPo calendarPo){
		JsonResult jResult = new JsonResult();
		
		if (calendarPo==null) {
			jResult.setResult(Result.ERROR);
			jResult.setMsg("日程信息添加失败，请重新输入！");
		}
		
		UserPo userPo = (UserPo) session.getAttribute(Statics.USERPO);
		CalendarPo cpoPo= calendarBo.getByPid(userPo.getId(), calendarPo.getPid());
		System.out.println(cpoPo);
		if(cpoPo!=null){
			cpoPo.setEvent(calendarPo.getEvent());
			cpoPo.setStartDate(calendarPo.getStartDate());
			cpoPo.setEndDate(calendarPo.getEndDate());
			calendarBo.updateCalendar(cpoPo);
			jResult.setResult(Result.SUCCESS);
			jResult.setMsg("日程信息修改成功！");
		}else if (calendarBo.getByDate(calendarPo.getStartDate(), calendarPo.getEndDate(), userPo.getId())!=null) {
			jResult.setResult(Result.ERROR);
			jResult.setMsg("日程信息时间冲突,请重新选择时间");
		}else {
		
		calendarPo.setStudentId(userPo.getId());
		calendarBo.saveCalendar(calendarPo);
		jResult.setResult(Result.SUCCESS);
		jResult.setMsg("已添加日程！");		
		}
		return jResult;
	}
	
	/**
	 * 删除日程
	 * @param session
	 * @param pid
	 * @return
	 */
	@RequestMapping(value = "delete")
	public @ResponseBody JsonResult deleteCalendar(HttpSession session,String pid){
		JsonResult jResult = new JsonResult();
		
		UserPo userPo = (UserPo) session.getAttribute(Statics.USERPO);
		CalendarPo calendarPos = calendarBo.getByPid(userPo.getId(), pid);
		calendarBo.deleteCalendar(calendarPos);
		jResult.setResult(Result.SUCCESS);
		jResult.setMsg("已删除此日程");
		return jResult;
		
	}
}

添加时前台接受过来的也是标准时间，所以就没有做日期转换，有需要就肯定要转换的。

如果你的Po参数跟插件的日程属性匹配，返回json直接可以用，不用在组装。我这边是用fullcalendar写好了，难得改。呵呵。数据库表结构如下：

CREATE TABLE `calendar_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` varchar(20) DEFAULT NULL,
  `studentId` int(11) DEFAULT NULL,
  `event` varchar(200) NOT NULL,
  `startDate` datetime NOT NULL,
  `endDate` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8;

这插件功能还有许多没有搞清楚，这只是最基本的功能，界面也还不美观，有懂的朋友请指导下，不胜感激。

分享到：