001.<?php session_start();
002.include '../js/conn.php';?>
003.<div class="page-title">
004.</div>
005.<div class="row">
006. <div class="col-md-12">
007. <div class="x_panel">
008. <div class="x_title">
009. <h2>Gant Chart </h2>
010. <div class="clearfix"></div>
011. </div>
012. <div class="x_content">
013. <div style="position:relative" class="gantt" id='GanttChartDIV'></div>
014. </div>
015. </div>
016. </div>
017.</div>
018. <?php
019.
020.
021.
022.
023.
024.
025.
026.
027.
028.
029.
030.
031.
032.
033.
034.
035.
036.
037.
038. $sql_gc = " SELECT * FROM tbl_proj WHERE ProDateStart BETWEEN '".$_POST['date1']."' AND '".$_POST['date2']."' AND `ProTeamL` = '".$_POST['user']."' ";
039. $rsgc = mysql_query($sql_gc) or die(mysql_error());
040. ?>
041.<script language="javascript">
042. $(function () {
043. var g = new JSGantt.GanttChart(document.getElementById('GanttChartDIV'), 'week');
044.
045. g.setCaptionType('Complete');
046. g.setQuarterColWidth(86);
047. g.setDateTaskDisplayFormat('day dd month yyyy');
048. g.setDayMajorDateDisplayFormat('mon yyyy - Week ww')
049. g.setWeekMinorDateDisplayFormat('dd mon')
050. g.setShowEndWeekDate(0);
051. g.setUseSingleCell(10000);
052. g.setFormatArr("Day", "Week", "Month", "Quarter");
053.
054.
055. <?php while ($rowgc = mysql_fetch_array($rsgc)) { ?>
056. g.AddTaskItem(new JSGantt.TaskItem(<?php echo $rowgc['ProjID'];?>,
057. '<?php echo $rowgc['ProName'];?> ',
058. '<?php echo $rowgc['ProDateStart'];?>',
059. '<?php echo $rowgc['ProDateEnd']; // $_POST['date2'] ; ?>',
060. <?php $nowd = strtotime(date("Y-m-d"));
061. $endd = strtotime($_POST['date2']);
062. $sum = ceil(abs($endd - $nowd) / 86400) ;
063.
064. <?if($rowgc['ProStatus'] == 1 || $rowgc['ProStatus'] == 2)
065. {?>
066. <?php if (date("Y-m-d") < $rowgc['ProDateEnd'] && $sum <= 7 ){ ?>
067. 'gtaskyellow'
068. <?php }elseif (date("Y-m-d") > $rowgc['ProDateEnd']){ ?>
069. 'gtaskred'
070. <?php }else{ ?>
071. 'gtaskblue'
072. <?php } ?>
073. <?php }
074. elseif($rowgc['ProStatus'] == 3 || $rowgc['ProStatus'] == 4) {?>
075. 'ggroupblack'
076. <?php }
077. elseif($rowgc['ProStatus'] == 5) {?>
078. <?php if ($rowgc['ProDateStu'] > $rowgc['ProDateEnd'] && $rowgc['ProStatus'] == 5)
079. { ?>
080. 'gtaskred'
081. <?php }else{?>'gtaskgreen' <? } ?>
082. <?}?>
083.
084.
085.
086. <? if ($rowgc['ProTeam'] == 'null') {
087. $team = '';
088. }else {
089. $team = ','.$rowgc['ProTeam']; } ?>
090.
091. , '', 0, '<?php //echo $rowgc['ProTeamL'].$team;?>',<?php echo $rowgc['ProPer'];?>, 0, 0, 1, '', '', '', g ));
092. <?php } ?>
093.
094. g.Draw();
095.
096. });
097.
098.</script>
099.
100.
101.
102.ผมงมมา 2 วันแล้ว ขอบพระคุณล่วงหน้าสำหรับคำแนะนำครับ
