001.<form name="frmSearch" method="get" action="<?php echo $_SERVER['SCRIPT_NAME'];?>">
002. <table width="45%" border="0" align="center">
003. <tr>
004. <td width="9%" ><i class="icon-calendar"></i> ตั้งแต่</td>
005. <td width="1%" height="1%"></td>
006. <td width="9%"><i class="icon-calendar"></i> จนถึง</td>
007. <td width="1%" ></td>
008. </tr>
009. <tr>
010. <td width="9%"><input type="text" name="datestart" id="dateStart" class="form-control" value="<?php echo $_GET["datestart"];?>"/></td>
011. <td width="1%"align="center"><strong>to </strong></td>
012. <td width="9%"><input type="text" name="dateend" id="dateEnd" class="form-control" value="<?php echo $_GET["dateend"];?>"/></td>
013. <td width="7%" rowspan="2"width="10%" ><button type="submit" name="button" id="button" class="btn btn-success"/>ค้นหา</button></td>
014. </tr>
015. </table>
016.</form>
017.
018. </br>
019. <table width="75%" border="1" cellpadding="0" cellspacing="0" align="center" id="datatable">
020. <tr>
021. <td height="35" colspan="4" bgcolor="#CCFF00"><div align="center"><strong>RESULT OF ENGINEERING WORK</strong></div></td>
022. </tr>
023. <tr>
024. <td width="15%" height="25" bgcolor="#FFFFFF"><div align="center"> </div></td>
025. <td width="12%" height="25" bgcolor="#FFFFFF"><div align="center">ชนิดใบแจ้งซ่อม</div></td>
026. <td width="12%" height="25" bgcolor="#FFFFFF"><div align="center">จำนวนงานที่แล้วเสร็จ</div></td>
027. <td width="20%" height="25" bgcolor="#FFFFFF"><div align="center">PERCENT COMPLETED WORK</div></td>
028. </tr>
029.
030. <?php
031. if($_GET["datestart"] != "")
032. {
033. $objConnect = mysql_connect("localhost","root","password") or die("Error Connect to Database");
034. $objDB = mysql_select_db("it");
035. mysql_query("SET NAMES UTF8");
036.
037.
038. $date_start= $_GET["datestart"];
039. $date_end= $_GET["dateend"];
040. $Status="สำเร็จ";
041.
042. $sql="SELECT * FROM addjob WHERE dateInput BETWEEN '$date_start' AND '$date_end' GROUP BY type_work ";
043. $dbquery= mysql_query($sql);
044. $num_rows= mysql_num_rows($dbquery);
045. $i=0;
046. $j=0;
047. while ($i<$num_rows){
048. $result=mysql_fetch_array($dbquery);
049. $Type_work =$result['type_work'];
050.
051. $sql2="SELECT * FROM addjob WHERE type_work = '$Type_work' AND dateInput BETWEEN '$date_start' AND '$date_end' ";
052. $dbquery2= mysql_query($sql2);
053. $num_rows2= mysql_num_rows($dbquery2);
054.
055. $sql3="SELECT * FROM addjob WHERE type_work = '$Type_work' AND status ='$Status' AND dateInput BETWEEN '$date_start' AND '$date_end'";
056. $dbquery3= mysql_query($sql3);
057. $num_rows3= mysql_num_rows($dbquery3);
058. ?>
059. <tr>
060. <td width="274" align="left" bgcolor="#66FFCC"><?=" $Type_work"?></td>
061. <td width="210" align="center" bgcolor="#66FFCC"><?=$num_rows2?></td>
062. <td width="210" align="center" bgcolor="#66FFCC"><?=$num_rows3?></td>
063.<?php $pc =($num_rows3/$num_rows2)*100 ?>
064.<?php
065. $sum_g = "{name: '$Type_work' ,y: $num_rows2} ,";
066. echo $sum_g;
067. ?>
068. <td width="210" align="center" bgcolor="#66FFCC"><?="$pc%"?></td>
069. </tr>
070.<?php
071. $sum_numrows+=$num_rows2;
072. $sum_numrows2+=$num_rows3;
073. $i++;
074. $j++;
075. }
076.
077. ?>
078. <tr>
079. <td width="274" align="left" bgcolor="#FFFFFF"><div align="center">ผลรวมทั้งหมด</div></td>
080. <td width="210" align="center" bgcolor="#FFCC00"><?="$sum_numrows งาน"?></td>
081. <td width="210" align="center" bgcolor="#FFCC00"><?="$sum_numrows2 งาน"?></td>
082. <?php
083. if($sum_numrows2 != ""){
084. $pc2= ($sum_numrows2/$sum_numrows)*100 ;
085. $pcf2= round($pc2,2);
086. }
087. ?>
088. <td width="210" align="center" bgcolor="#FFCC00"><?="$pcf2%"?></td>
089. </tr>
090. <?php
091. } ?>
092.
093. </table>
094.
095. </br></br>
096.
097. <?php
098. echo $sum_g; ?>
099.
100. <div style="width:80%;margin:auto;">
101. <div id="hc_container" style="min-width: 310px; height: 400px; margin: 0 auto"></div>
102.</div>
105. <script type="text/javascript">
106.$(function () {
107. $('#hc_container').highcharts({
108. chart: {
109. plotBackgroundColor: null,
110. plotBorderWidth: null,
111. plotShadow: false,
112. type: 'pie'
113. },
114. title: {
115. text: 'RESULT'
116. },
117. tooltip: {
118. pointFormat: '{series.name}: <b>{point.percentage:.1f}%</b>'
119. },
120. plotOptions: {
121. pie: {
122. allowPointSelect: true,
123. cursor: 'pointer',
124. dataLabels: {
125. enabled: false
126. },
127. showInLegend: true
128. }
129. },
130. series: [{
131. name: 'Brands',
132. colorByPoint: true,
133. data: [ <?php echo $sum_g?> ]
134. }]
135. });
136.});
137.</script>
