ThaiSEOBoard.com

$query = "  
          SELECT 
            T1.id,T1.orders_dates
          FROM
            orders AS T1
          INNER JOIN order_details AS T2 
            SUM(order_detail_quantity * order_detail_price) total
          ON 
            T1.id = T2.order_id
          GROUP BY 
            order_id
          WHERE 
            orders_dates 
          BETWEEN '".$_POST["from_date"]."' AND '".$_POST["to_date"]."'  
          ";  
      $result = mysqli_query($connect, $query);  

$query = "  
          SELECT T1.id, T1.orders_dates, SUM(T2.order_detail_quantity * T2.order_detail_price) total
          FROM orders AS T1
          INNER JOIN order_details AS T2 ON (T1.id = T2.order_id)
          GROUP BY T2.order_id
          WHERE T1.orders_dates 
          BETWEEN '".$_POST["from_date"]."' AND '".$_POST["to_date"]."'  
          ";  
      $result = mysqli_query($connect, $query);

$query = "  
          SELECT T1.id, T1.orders_dates, SUM(T2.order_detail_quantity * T2.order_detail_price) total
          FROM orders AS T1
          INNER JOIN order_details AS T2 ON (T1.id = T2.order_id)
          GROUP BY T2.order_id
          WHERE T1.orders_dates 
          BETWEEN '".$_POST["from_date"]."' AND '".$_POST["to_date"]."'  
          ";  
      $result = mysqli_query($connect, $query);

$query = "  
          SELECT 
            T1.id,T1.orders_dates
          FROM
            orders AS T1
          INNER JOIN order_details AS T2 
            SUM(order_detail_quantity * order_detail_price) total
          ON 
            T1.id = T2.order_id
          GROUP BY 
            order_id
          WHERE 
            orders_dates 
          BETWEEN '".$_POST["from_date"]."' AND '".$_POST["to_date"]."'  
          ";  
      $result = mysqli_query($connect, $query);  

CREATE TABLE IF NOT EXISTS `oc_order` (
  `order_id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` int(11) NOT NULL,
  `date_added` datetime NOT NULL,
  `date_modified` datetime NOT NULL,
  PRIMARY KEY (`order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `oc_order` (`order_id`, `customer_id`, `date_added`, `date_modified`) VALUES (null,9, '2017-05-22 12:11:28', '2017-05-22 12:11:28');
INSERT INTO `oc_order` (`order_id`, `customer_id`, `date_added`, `date_modified`) VALUES (null,12, '2017-05-25 14:20:48', '2017-05-25 14:20:48');

CREATE TABLE IF NOT EXISTS `oc_order_detail` (
  `order_detail_id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `product_name` varchar(128) NOT NULL,
  `quantity` int(11) NOT NULL,
  `unit_price` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`order_detail_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `oc_order_detail` (`order_detail_id`, `order_id`, `product_id`, `product_name`, `quantity`,`unit_price`,`date_added`) VALUES (null,1,77,'Samsung Galaxy Tab10.2', 2, '120.0000', '2017-05-22 12:11:28');
INSERT INTO `oc_order_detail` (`order_detail_id`, `order_id`, `product_id`, `product_name`, `quantity`,`unit_price`,`date_added`) VALUES (null,1,88,'Galaxy Note 7', 3, '220.0000', '2017-05-22 14:20:48');

INSERT INTO `oc_order_detail` (`order_detail_id`, `order_id`, `product_id`, `product_name`, `quantity`,`unit_price`,`date_added`) VALUES (null,2,34,'Acer Notebook 001', 1, '1800.0000', '2017-05-25 12:11:28');
INSERT INTO `oc_order_detail` (`order_detail_id`, `order_id`, `product_id`, `product_name`, `quantity`,`unit_price`,`date_added`) VALUES (null,2,45,'HP Notebook 002', 1, '2900.0000', '2017-05-25 14:20:48');

select order_id,sum(quantity) as qty,sum(sub_total) as total from
(
select o.order_id,o.date_added,od.product_id,od.quantity,od.unit_price,(od.quantity*od.unit_price) as sub_total   
from oc_order as o 
left join oc_order_detail as od on (od.order_id=o.order_id)
where o.date_added between '2017-05-20 00:00:00' and '2017-05-30 00:00:00' 
) out_t group by order_id