function lfGetOrderProducts($type, $sdate, $edate) {
        $objQuery = SC_Query_Ex::getSingletonInstance();

        list($where, $arrWhereVal) = $this->lfGetWhereMember('create_date', $sdate, $edate, $type);

        $where .= ' AND dtb_order.del_flg = 0 AND dtb_order.status <> ?';
        $arrWhereVal[] = ORDER_CANCEL;
		$where = "WHERE $where";

		
		$query = '
		SELECT
				product_id,
				dtb_order_detail.product_class_id,				
				product_code,
				CONCAT(product_name,classname) as product_name,
				SUM(quantity) AS products_count,
				COUNT(dtb_order_detail.order_id) AS order_count,
				price,
				(price * SUM(quantity)) AS total
		FROM
			dtb_order_detail JOIN 
			dtb_order ON dtb_order_detail.order_id = dtb_order.order_id INNER JOIN
			(
				SELECT
					product_class_id,
					CONCAT(
						(SELECT name FROM dtb_classcategory WHERE classcategory_id = dtb_products_class.classcategory_id1),
						(SELECT name FROM dtb_classcategory WHERE classcategory_id = dtb_products_class.classcategory_id2)
						) as classname
				FROM
					dtb_products_class
			) dp ON dtb_order_detail.product_class_id =dp.product_class_id
		'.$where.'
		GROUP BY
			dtb_order_detail.product_class_id
		ORDER BY total DESC
		
		';

		$arrTotalResults = $objQuery->getAll($query,$arrWhereVal);
        $tpl_image  = $this->lfGetGraphPie($arrTotalResults, 'product_name', 'products_' . $type, '(売上比率)', $sdate, $edate);

        return array($arrTotalResults, $tpl_image);
    }