<?php 
//error_reporting(E_ALL);
//ini_set('display_errors', 1);
require_once('wp-load.php'); 
session_start();
date_default_timezone_set("Asia/Hong_Kong"); 
global $wpdb, $sitepress;



$sku_arr = array(
	'BD-SBR-180',
	'BD-ABR-180',
	'TS-CHS-170',
	'TS-CAN-260',
	'TS-HCT-100',
	'BD-YBR-180',
	'TS-CBS-170',
	'BD-RBL-460',
	'BD-CMB-300',
	'BD-JPL-425',
	'BD-FPB-300',
	'BD-BAG-300',
	'TS-CCC-163',
	'BD-FCB-210',
	'BD-WLR-300',
	'BD-WNL-460',
	'BD-CBL-390',
	'BD-BRL-460',
	'BD-CCB-400',
	'BD-CMR-085',
	'BD-CRC-200',
	'BD-NNS-330',
	'BD-CCR-160',
	'BD-MCB-125',
	'BD-KTB-270',
	'BD-LCB-320',
	'BD-HMB-150',
	'BD-BGL-200',
	'BD-GML-400',
	'BD-SPB-200',
	'BD-CJB-280',
	'BD-CMC-200',
	'BD-KRB-230',
	'BD-CSB-160',
	'BD-PPB-260',
	'BD-MBR-200',
	'BD-JBL-320',
	'BD-KCB-340',
	'BD-CSL-330',
	'TS-CRS-120',
	'BD-CSP-440',
	'BD-CCB-120',
	'BD-CGB-260',
	'BD-MMB-125',
	'BD-CCF-240',
	'BD-MBT-200',
	'BD-SRL-176',
	'TS-CSP-450',
	'GB-CCC-163',
	'GB-CCN-211',
	'GB-CCC-287',
	'GB-CNP-348',
	'TS-APM-290',
	'TS-APM-390',
	'TS-PAL-270',
	'TS-PAL-330',
	'TS-CSP-320',
	'CE-GBM-20',
	'BD-PNT-600',
	'BD-CST-200',
	'BD-FPB-155',
	'BD-CBR-180',
	'BD-HMC-240',
	'CK-SRC-390',
	'SC-CSF-175',
	'BD-SSB-430',
	'GB-CNP-325',
	'TS-APM-275',
	'TS-PAL-200',
	'TS-PAL-250',
	'TS-YYP-300',
	'CM-HSP-330',
	'GB-CCC-286',
	'CK-PCC-624',
	'GB-CAN-357' 
);


foreach($sku_arr as $sku) {

	$product_id = wc_get_product_id_by_sku($sku);
	$product_obj = wc_get_product($product_id);

	
	//echo $sku;
	echo "Name: ".$product_obj->get_name();
	echo ". Price: $".number_format($product_obj->get_price(),2);
	echo " ".get_post_meta($product_id, '_woo_uom_input', true)=="each"?" / each":" ".get_post_meta($product_id, '_woo_uom_input', true);
	echo ". Description: ".strip_tags($product_obj->get_description());
	echo " ".strip_tags($product_obj->get_short_description());
	echo ". Ingredient: ";
	
	$init = get_sku_init_info($sku);

	$productResult = $wpdb->get_results("SELECT * FROM inventory_product WHERE sku_id = '".$init->id."' LIMIT 1");
	if(count($productResult)>0){		
		$productObj = $productResult[0];
		$reference_id = $productObj->id;
	}

	$dataResult = getIngredientLabelData(1, $reference_id, 0);

	$arrNameResult = array();
	 $arrDisplayNameResult = array();

	foreach($dataResult as $itemArr){
		$arrNameResult[$itemArr['name']."=".$itemArr['display_name']] += $itemArr['qty'];
		$arrDisplayNameResult[$itemArr['display_name']] += $itemArr['qty'];
	}

	arsort($arrNameResult);	
	arsort($arrDisplayNameResult);	


	$rank = 1; 
	foreach($arrDisplayNameResult as $name=>$qty){
		echo $name;		
		if($rank!=count($arrDisplayNameResult))
			echo ", ";	
		else	
			echo ".";	
		$rank++;
	}		

	echo "<br>";
	echo "<br>";

	
}