R E D

NAME	SIZE	PERMISSION
bower_components	[ DIR ]	drwxr-xr-x
chart-pie	[ DIR ]	drwxr-xr-x
class	[ DIR ]	drwxr-xr-x
dist	[ DIR ]	drwxr-xr-x
font-awesome	[ DIR ]	drwxr-xr-x
icon	[ DIR ]	drwxr-xr-x
img-banner	[ DIR ]	drwxr-xr-x
img-logo	[ DIR ]	drwxr-xr-x
img-new	[ DIR ]	drwxr-xr-x
img-slide	[ DIR ]	drwxr-xr-x
img-system	[ DIR ]	drwxr-xr-x
img-user	[ DIR ]	drwxr-xr-x
lightbox	[ DIR ]	drwxr-xr-x
modal	[ DIR ]	drwxr-xr-x
plugins	[ DIR ]	drwxr-xr-x
.htaccess	154 B	-rwxr-xr-x
about.php	4.15 KB	-rwxr-xr-x
category.php	11.37 KB	-rwxr-xr-x
check_login.php	424 B	-rwxr-xr-x
company.php	13.02 KB	-rwxr-xr-x
edit_service.php	4.65 KB	-rwxr-xr-x
footer.php	249 B	-rwxr-xr-x
header.php	766 B	-rwxr-xr-x
import_script.php	4.4 KB	-rwxr-xr-x
import_style.php	1.28 KB	-rwxr-xr-x
index.php	2.97 KB	-rwxr-xr-x
logout.php	77 B	-rwxr-xr-x
manage_service.php	4.46 KB	-rwxr-xr-x
menu_left.php	2.87 KB	-rwxr-xr-x
menu_main.php	88 B	-rwxr-xr-x
message.php	3.82 KB	-rwxr-xr-x
new.php	10.32 KB	-rwxr-xr-x
person.php	9.81 KB	-rwxr-xr-x
position.php	7.08 KB	-rwxr-xr-x
report.php	11.55 KB	-rwxr-xr-x
reportSale.php	4.55 KB	-rwxr-xr-x
sent.php	1.78 KB	-rwxr-xr-x
service.php	9.92 KB	-rwxr-xr-x
slide.php	10.61 KB	-rwxr-xr-x
type_user.php	549 B	-rwxr-xr-x
uploadImage.php	9.53 KB	-rwxr-xr-x
upload_img.php	793 B	-rwxr-xr-x
user.php	10.07 KB	-rwxr-xr-x

Code Editor : report.php

<?php session_start();
	include('../config/connect.php');
	include('type_user.php');
?>
<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <title><?php echo $title;?></title>
  <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
  <?php include('import_style.php');?>
  <link href="https://fonts.googleapis.com/css?family=Kanit:100,200,300&amp;subset=thai" rel="stylesheet">
</head>
<body class="hold-transition skin-blue sidebar-mini">
<?php include('check_login.php');?>
<div class="wrapper">

<?php include('header.php');?>
  
  <?php include('menu_left.php');?>

<div class="content-wrapper">
    
    
    <?php
    	include('menu_main.php');
	?>

<section class="content">
	
    
<?php
	if($_GET['order_start'] != '' && $_GET['order_end'] != '')
	{
		$stmtx = $conn->prepare("SELECT SUM(o.order_total) AS total, p.product_name
		FROM tb_order_head AS o
		INNER JOIN tb_order_detail AS d ON d.order_id = o.order_id
		INNER JOIN tb_product AS p ON d.product_id = p.product_id
		WHERE o.order_status = '1'
		AND o.order_record >= :order_start
		AND o.order_record <= :order_end
		GROUP BY p.product_name
		ORDER BY p.product_name DESC");
		$stmtx->bindParam(':order_start', $_GET['order_start']);
		$stmtx->bindParam(':order_end', $_GET['order_end']);
	}
	else
	{
		$stmtx = $conn->prepare("SELECT SUM(o.order_total) AS total, p.product_name
		FROM tb_order_head AS o
		INNER JOIN tb_order_detail AS d ON d.order_id = o.order_id
		INNER JOIN tb_product AS p ON d.product_id = p.product_id
		WHERE o.order_status = '1'
		GROUP BY p.product_name
		ORDER BY p.product_name DESC");
	}
	
	$stmtx->execute();
	$resultx = $stmtx->fetchAll();

$datax = array();
    foreach ($resultx as $k) {
      $datax[] = "['".$k['product_name']."'".", ".$k['total']."]";
    }

$datax = implode(",", $datax);
?>

<?php
	if($_GET['order_start'] != '' && $_GET['order_end'] != '')
	{
		$stmtxx = $conn->prepare("SELECT SUM(o.order_total) AS total2, c.category_name
		FROM tb_order_head AS o
		INNER JOIN tb_order_detail AS d ON d.order_id = o.order_id
		INNER JOIN tb_product AS p ON d.product_id = p.product_id
		INNER JOIN tb_category AS c ON p.category_id = c.category_id
		WHERE o.order_status = '1'
		AND o.order_record >= :order_start
		AND o.order_record <= :order_end
		GROUP BY c.category_name
		ORDER BY c.category_name DESC");
		$stmtxx->bindParam(':order_start', $_GET['order_start']);
		$stmtxx->bindParam(':order_end', $_GET['order_end']);
	}
	else
	{
		$stmtxx = $conn->prepare("SELECT SUM(o.order_total) AS total2, c.category_name
		FROM tb_order_head AS o
		INNER JOIN tb_order_detail AS d ON d.order_id = o.order_id
		INNER JOIN tb_product AS p ON d.product_id = p.product_id
		INNER JOIN tb_category AS c ON p.category_id = c.category_id
		WHERE o.order_status = '1'
		GROUP BY c.category_name
		ORDER BY c.category_name DESC");
	}
	
	$stmtxx->execute();
	$resultxx = $stmtxx->fetchAll();

$dataxx = array();
    foreach ($resultxx as $k2) {
      $dataxx[] = "['".$k2['category_name']."'".", ".$k2['total2']."]";
    }

$dataxx = implode(",", $dataxx);
?>

<div class="row">
		<div class="col-md-12">
          <div class="box">
            <div class="box-header bg-theme text-center">
              <h3 class="box-title">สรุปรายงานการขายสินค้า</h3>
            </div>
            
            <div class="box-body">
            
            					<div class="row">
                                	<form method="get">
                            <div class="col-md-2"></div>                          
                            <div class="col-md-3">
                                    <label style="color:#000;"><b>จากวันที่</b></label>
                                    <input type="date" name="order_start" value="<?php echo $_GET['order_start'];?>" class="form-control">
                            </div>
                            <div class="col-md-3">
                                    <label style="color:#000;"><b>ถึงวันที่</b></label>
                                    <input type="date" name="order_end" value="<?php echo $_GET['order_end'];?>" class="form-control">
                            </div>
                            <div class="col-md-2">
                            	<button type="submit" class="btn btn-success" style="margin-top:25px;"><i class="fa fa-search"></i> ค้นหา</button>
                            </div>
                            <div class="col-md-3"></div>
                            </form>
                                </div> 
            
            					<div class="row">
                                	<div class="col-md-6">
                                    	<div id="piechart" style="width:100%; height:40vh;"></div>
                                    </div> 
                                    
                                    <div class="col-md-6">
                                    	<div id="piechart2" style="width:100%; height:40vh;"></div>
                                    </div> 
                                </div> 
 
                                
                                
                                <table width="100%" id="table1" class="table table-hover">
                                	<thead>
                                    	<tr>
                                            <th width="5%" class="text-center">ลำดับ</th>
                                        	<th width="6%">รหัสสินค้า</th>
                                        	<th width="5%">รูปภาพสินค้า</th>
                                            <th width="43%">ชื่อสินค้า</th>
                                            <th width="20%">หมวดหมู่</th>
                                            <th width="7%" class="text-center">จำนวน / ชิ้น</th>
                                            <th width="6%" class="text-center">ราคาต่อชิ้น</th>
                                            <th width="8%" class="text-center">รวมจำนวนเงิน</th>
                                        </tr>
                                    </thead>
                                    
                                    <tbody>
                                    <?php
										$order_status = "1";
										if($_GET['order_start'] != '' && $_GET['order_end'] != '')
										{
											$stmt = $conn->prepare("SELECT o.*, c.*, s.status_name, p.payment_name, d.*, pro.product_name, pro.product_img, 
											ca.category_name  FROM tb_order_head AS o										    
											LEFT JOIN tb_order_detail AS d ON o.order_id = d.order_id
											LEFT JOIN tb_product AS pro ON d.product_id = pro.product_id
										    LEFT JOIN tb_customer AS c ON o.customer_id = c.customer_id
											LEFT JOIN tb_status AS s ON o.status_id = s.status_id
											LEFT JOIN tb_payment AS p ON o.payment_id = p.payment_id
											INNER JOIN tb_category AS ca ON pro.category_id = ca.category_id
											WHERE o.order_status=:order_status
											AND o.order_record >= :order_start
											AND o.order_record <= :order_end
											ORDER BY d.detail_id ASC");
											
											$stmt->bindParam(':order_start', $_GET['order_start']);
											$stmt->bindParam(':order_end', $_GET['order_end']);	
										}
										else
										{
											$stmt = $conn->prepare("SELECT o.*, c.*, s.status_name, p.payment_name, d.*, pro.product_name, pro.product_img, 
											ca.category_name  FROM tb_order_head AS o										    
											LEFT JOIN tb_order_detail AS d ON o.order_id = d.order_id
											LEFT JOIN tb_product AS pro ON d.product_id = pro.product_id
										    LEFT JOIN tb_customer AS c ON o.customer_id = c.customer_id
											LEFT JOIN tb_status AS s ON o.status_id = s.status_id
											LEFT JOIN tb_payment AS p ON o.payment_id = p.payment_id
											INNER JOIN tb_category AS ca ON pro.category_id = ca.category_id
											WHERE o.order_status=:order_status
											ORDER BY d.detail_id ASC");
										}
										
										$stmt->bindParam(':order_status', $order_status , PDO::PARAM_STR);
										$stmt->execute();
										$result = $stmt->fetchAll();
										$i2 = 1;
										foreach($result as $row) {
									?>	
                                    	<tr>
                                        	<td align="center"><?php echo $i2;?></td>
                                            <td><?php echo $row['product_id'];?></td>
                                        	<td><img src="img-product/<?php echo $row['product_img'];?>" width="100%"></td>
                                            <td><?php echo $row['product_name'];?></td>
                                            <td><?php echo $row['category_name'];?></td>
                                            <td align="center"><?php echo number_format($row['detail_qty'],0); ?></td>
                                            <td align="center"><?php echo number_format($row['detail_price'],0); ?></td>
                                            <td align="center"><?php echo number_format($row['detail_subtotal'],0); ?></td> 
                                        </tr>
                                                                                    
                                    <?php $i2++; } ?>
                                    </tbody>
                                </table>
                                                                
                                
            </div>
            
          </div>
          
        </div>
        
</div>

</section>
    
  </div>

  
  <?php include('footer.php');?>

<?php include('import_script.php');?>
    <script type="text/javascript" src="chart-pie/loader.js"></script>
    <script type="text/javascript">
      google.charts.load('current', {'packages':['corechart']});
      google.charts.setOnLoadCallback(drawChart);

function drawChart() {

var data = google.visualization.arrayToDataTable([
          ['Task', 'Summary per roomName'],
          <?php echo $datax;?>
        ]);

var options = {
          title: 'สรุปรายงานการขายสินค้า (แยกตามสินค้า)'
        };

var chart = new google.visualization.PieChart(document.getElementById('piechart'));

chart.draw(data, options);
      }
    </script>
    
    <script type="text/javascript">
      google.charts.load('current', {'packages':['corechart']});
      google.charts.setOnLoadCallback(drawChart);

function drawChart() {

var data = google.visualization.arrayToDataTable([
          ['Task', 'Summary per departmentName'],
          <?php echo $dataxx;?>
        ]);

var options = {
          title: 'สรุปรายงานการขายสินค้า (แยกตามหมวดหมู่)'
        };

var chart = new google.visualization.PieChart(document.getElementById('piechart2'));

chart.draw(data, options);
      }
    </script>
</body>
</html>
<?php
  $conn = null;
?>

${this.title}

Code Editor : report.php