01.<!doctype html>
02.<html>
03.<link href="../../css/css_body.css" rel="stylesheet" type="text/css">
04.<head>
05.<meta charset="utf-8">
06.<title>ปฏิทินกิจกรรม</title>
07.<?php
08.$data = array();
09. $sql = "SELECT * FROM tbl_event left join member on tbl_event.member_id=member.member_id where tbl_event.member_id='".$_GET['member_id']."' ORDER BY event_id DESC";
10. $query=@mysql_query($sql);
11.
12.
13. while($rs=@mysql_fetch_object($query)){
14. $bgColor=null;
15. if($rs->id_type=='00001'){
16. $bgColor="#990000";
17. }elseif($rs->id_type=='00002'){
18. $bgColor="#0099FF";
19. }else{
20. $bgColor="#00CCFF";
21. }
22. $data[] = array(
23. "id"=>$rs->event_id,
24. "id_type"=>$rs->id_type,
25. "start"=>$rs->event_start,
26. "end"=>$rs->event_end,
27. "member_id"=>$rs->member_id,
28. "color"=>$bgColor,
29. );
30. }
31.?>
32.<script>
33. $(function(){
34. $('#calendar').fullCalendar({
35. header: {
36. left: 'prev,next today',
37. center: 'title',
38. right: 'month,agendaWeek,agendaDay',
39. },
40. defaultDate: '<?php echo date('Y-m-d H:i');?>',
41.
42. eventLimit: true,
43. lang: 'th',
44. events : <?php echo json_encode($data);?>
45. });
46. });
47.</script>
48.</head>
49.
50.<body>
51.
52.<!-- ส่วนที่แสดงปฏิทิน -->
53. <div id='calendar'></div>
54.<!-- ปิดส่วนที่แสดงปฏิทิน -->
55.
56.</body>
57.
58.</html>
