";print_r($pickedSupplier);
	        $supplierType = Retail::getSupplierType($pickedSupplier['SupplierUnit']);
	        $costAvgLast = $this->retail->calculateCostAvg($pickedSupplier, $supplierType['StockUnit']);
		}
        return $costAvgLast;
    }
	// private function calculateCostAvgLast($inventoryItem, $moneyRates) {

	private function calculateItemCost($inventoryItem, $step, $purchaseQuantity, $recipeItem, $moneyRates) {
		$itemCost = 0;
		$costAvgLast = $this->calculateCostAvgLast($inventoryItem, $moneyRates);
		if ($step['Format']=='Packaging') {
			$itemCost += $step['StepQuantity'] * $recipeItem['RecipeQuantity'] * $costAvgLast;
		} else {
			$itemCost = $step['StepQuantity'] * $purchaseQuantity * $costAvgLast;
		}
		return $itemCost;
	}

	private function calculateItemCostForNonInventory($step, $recipe, $purchaseQuantity, $recipeItem, $moneyRates) {
		$itemCost = 0;

// FACTORS FOR PRODUCTION TIME
		if (isset($step['Instruction']) && strtolower($step['Instruction']) == 'add label') {
			$itemCost = $step['StepQuantity'] * 0.25;
		} else if (isset($step['Instruction']) && strtolower($step['Instruction']) == 'production time') {
			if (floatval($recipeItem['RecipeQuantity']) > 0) {
				$itemCost = ($recipeItem['RecipeTime'] / floatval($recipeItem['RecipeQuantity'])) * 0.25;
			} else {
				$itemCost = 0;
			}
		}

		return $itemCost;
	}

 	private function countInTotal($productType) {
 		$ProductUnitNotCountInTotal = array('item');
 		return $productType && !in_array($productType, $ProductUnitNotCountInTotal);
 	}
	private function calculateItemCostTotal($recipe, $moneyRates) {
		$itemCostTotal = 0;
		for ($i = 0; $i < sizeof($recipe['Steps']); $i++) {
			$step = $recipe['Steps'][$i];
			if (!isset($step['Ingredient']))
				continue;
			$inventoryItem = $this->findInventoryItemByProductNameAndFormat($step['Ingredient'], $step['Format']);
			$purchaseQuantity = $recipe['RecipeQuantity']  * ($this->countInTotal($step['Format'])?$recipe['Serving']:1);
			if ($inventoryItem) {
				$itemCost = $this->calculateItemCost($inventoryItem, $step, $purchaseQuantity, $recipe, $moneyRates);
			} else {
				$itemCost = $this->calculateItemCostForNonInventory($step, $recipe, $purchaseQuantity, $recipe, $moneyRates);
			}
			$itemCostTotal += round($itemCost, 3);
		}
		return $itemCostTotal;
	}
	private function calculateRecipeCost($recipe, $purchaseQuantity, $moneyRates) {
		$recipeCost = $this->calculateItemCostTotal($recipe, $moneyRates);
		$recipeTime = $recipe['RecipeTime'] ? $recipe['RecipeTime'] : 0;
		$recipeQuantity = $recipe['RecipeQuantity'] ? $recipe['RecipeQuantity'] : 0;

		if ($recipeQuantity != 0) {
			$recipeCost /= $recipeQuantity;
			$recipeCost +=  (floatval($recipeTime) / floatval($recipeQuantity)) * 0.25;
		}

		$recipeCost=$recipeCost;

		return number_format($recipeCost, 3, '.', '');
	}

	private function findInventoryItemByProductNameAndFormat($productionName, $format) {
		if (!isset($this->allInventories))
			$this->allInventories = $this->loadAllInventory();
		$inventory = $this->allInventories;

		if ($productionName == null || $productionName == ''
				|| $format == null || $format == '') {
					return null;
				}

				$inventoryItem = null;
				for ($i = 0; $i < sizeof($inventory); $i++) {
					if (strtolower($inventory[$i]['Product']) == strtolower($productionName)
							&& strtolower($inventory[$i]['category']) == strtolower($format)) {
								$inventoryItem = $inventory[$i];
								break;
							}
				}

				return $inventoryItem;
	}


	/**** End port from JS ****/
/**** WHY THERE IS STOCKRETAILLB ****/
	private function calculateStockTotal($inventoryItem) {
		$stockTotal = 0;
		foreach ($inventoryItem['Suppliers'] as $supplier) {
			$stockTotal += floatval($supplier['StockRetailLB']);
		}
		return $stockTotal;
	}

	private function calculatePurchaseTotal($inventoryItem) {
		$purchaseTotal = 0;
		foreach ($inventoryItem['Suppliers'] as $supplier) {
			$purchaseTotal += floatval($supplier['Purchase']);
		}
		return $purchaseTotal;
	}

	private function standardlizeSteps(&$recipe) {
		for ($i = 0; $i < count($recipe['Steps']); $i++) {
			$recipe['Steps'][$i]['Step'] = ($i + 1) . '';
		}

		return $recipe;
	}

	private function isPureNutrientProduct($product) {
		$isPuretrientProduct = false;
		$productNameArray = explode(' - ', $product);

		if (count($productNameArray) > 1) {
			if (trim(strtolower($productNameArray[0])) == 'mixture') {
				$isPuretrientProduct = true;
			}
		}

		return $isPuretrientProduct;
	}

	private function findPureNutrientIndexByRecipeName($inventories, $recipeName) {
		$index = -1;
		$recipeNameArray = explode(' - ', $recipeName);
		$format = null;
		$product = null;

		if (count($recipeNameArray) > 1) {
			$format = trim($recipeNameArray[0]);
			$product = trim($recipeNameArray[1]);
		}

		foreach ($inventories['purenutrients'] as $ind => $item) {
			if (strtolower($item['Format']) == strtolower($format) && strtolower($item['Product']) == strtolower($product)) {
				$index = $ind;
				$found = true;
				break;
			}
		}

		return $index;
	}

	private function findPureNutrientIndexByRecipeNameAndFormat($inventories, $recipeName, $recipeFormat) {
		$index = -1;

		foreach ($inventories['purenutrients'] as $ind => $item) {
			if (strtolower($item['Format']) == strtolower($recipeFormat) && strtolower($item['Product']) == strtolower($recipeName)) {
				$index = $ind;
				$found = true;
				break;
			}
		}

		return $index;
	}

	private function updatePureNutrientInventoryStock(&$inventoryItem, $purchaseQuantity, $recipeCost) {
		uasort($inventoryItem['Suppliers'], 'compareSupplier');
		$inventoryItem['Suppliers'] = array_values($inventoryItem['Suppliers']);

		if (count($inventoryItem['Suppliers']) > 0) {
			$inventoryItem['Suppliers'][0]['StockRetailLB'] += $purchaseQuantity;
			$inventoryItem['Suppliers'][0]['Cost'] = $recipeCost;
			if ($inventoryItem['Suppliers'][0]['DateDelivery'] == '') {
				$inventoryItem['Suppliers'][0]['DateDelivery'] = date('Y-m-d');
			}
		}

		$inventoryItem['Suppliers'] = array_reverse($inventoryItem['Suppliers']);
	}

	private function findHorseInventoryIndexByProduct($inventories, $product) {
		$index = -1;

		$found = false;
		foreach ($inventories['equinesolution'] as $ind => $item) {
			if (strtolower($item['Product']) == strtolower($product)) {
				$index = $ind;
				$found = true;
				break;
			}
		}

		return $index;
	}

	private function findInventoryIndexByProduct($inventories, $product) {
		$index = -1;
		foreach ($inventories as $ind => $item) {
			if (strtolower($item['Product']) == strtolower($product)) {
				$index = $ind;
				break;
			}
		}

		return $index;
	}

	private function addNewHorseInventoryStock(&$inventoryItem, $purchaseQuantity, $recipeCost) {
		$inventoryItem['Suppliers'][] = [
				"Supplier" =>  "Equine Solution",
				"Quality" => "",
				"Produce" => "",
				"Volume"=> "1",
				"SupplierUnit" => "Item",
				"Cost" => $recipeCost,
				"Purchase" => 0,
				"Link" => "",
				"Lots" => "",
				"DateExpiration" => "",
				"Tracking" => "",
				"StockRetailLB" => $purchaseQuantity,
				"DateDelivery" => date('Y-m-d'),
		];
	}

	private function addNewInventoryStock($inventoryItem, $format, $setting) {
		$retail = new Retail();
		$date = new DateTime();
		if (!empty($setting[$format])) {
			$date->add(new DateInterVal("P{$setting[$format]}"));
		}
		$supplier = Template::createTemplateSupplier();
		$pickedSupplier = $retail->pickSupplier($inventoryItem);
		$supplier = array_merge($supplier, array_intersect_key($pickedSupplier, $supplier));
		$supplier['Purchase'] = '1';
		$supplier['DateOrdered'] = date('Y-m-d');
		$supplier['DateDelivery'] = date('Y-m-d');
		$supplier['DateExpiration'] = $date->format('Y-m-d');
		$inventoryItem['Suppliers'][] = $supplier;
		uasort($inventoryItem['Suppliers'], 'compareSupplierForStocking');
		$inventoryItem['Suppliers'] = array_values($inventoryItem['Suppliers']);
		$order = ['bulk', 'recipe', 'shop'];
		$addup = false;
		foreach ($order as $location) {
			foreach ($inventoryItem['Retail'] as $key => $variation) {
				if (strtolower($variation['StockLocation']) == $location) {
					$addup = true;
					$value = (float)$variation['StockRetailShop'];
					$stock = Conversion::convertStockValue((float)$supplier['SupplierSize']*(float)$supplier['Purchase'], $supplier['SupplierUnit'], 'gr');
					$inventoryItem['Retail'][$key]['StockRetailShop'] = (string)($value + $stock);
					break;
				}
			}
			if ($addup) break;
		}
		return $inventoryItem;
	}


// CONVERTION FORMULA FROM WEIGHT TO VOLUME (TO BE CANCEL)
	private function calculateOriginalOpenStockFromStockNeed($openStockNeed, $volume, $weight, $unit) {
		$originalOpenStock = 0;

		if ($unit == null ) {
			$unit = '';
		}
		if ($volume == 0 || $volume == '' || $volume == null) {
			$volume = 0;
		}
		if ($openStockNeed == null || $openStockNeed == '') {
			$openStockNeed = 0;
		}

		if ($weight == 0 || $weight == '' || $weight == null) {
			$weight = 0;
		}

		if ($volume != 0) {
			switch (strtolower($unit)) {
				case 'ml':
					$originalOpenStock = $openStockNeed / ((100/$weight) * 1);
					break;
				case 'gr':
					$originalOpenStock = $openStockNeed;
					break;
				default:
					$originalOpenStock = $openStockNeed;
					break;
			}
		}

		$originalOpenStock =  0.001 * intval($originalOpenStock*1000);



		return $originalOpenStock;

	}

	private function calculateOriginalStockFromStockNeed($stockNeed, $volume, $weight, $unit) {

		$originalStock = 0;

		if ($unit == null ) {
			$unit = '';
		}
		if ($volume == 0 || $volume == '' || $volume == null) {
			$volume = 0;
		}
		if ($stockNeed == null || $stockNeed == '') {
			$stockNeed = 0;
		}

		if ($weight == 0 || $weight == '' || $weight == null) {
			$weight = 0;
		}

		if ($volume != 0) {
			switch (strtolower($unit)) {
				case 'ml':
					$originalStock = $stockNeed / ($volume * (100/$weight) * 1);
					break;
				case 'gr':
					$originalStock = $stockNeed / ($volume);
					break;
				default:
					$originalStock = $stockNeed / ($volume);
					break;
			}
		}

		$originalStock =  0.001 * intval($originalStock*1000);

		return $originalStock;
	}

	private function calculateStockNeedFromOriginalStock($originalStock, $originalOpenStock, $volume, $weight, $unit) {
		$stockNeed = 0;
		$openStockNeed = 0;

		if ($unit == null ) {
			$unit = '';
		}
		if ($volume == 0 || $volume == '' || $volume == null) {
			$volume = 0;
		}
		if ($originalStock == null || $originalStock == '') {
			$originalStock = 0;
		}
		if ($originalOpenStock == null || $originalOpenStock == '') {
			$originalOpenStock = 0;
		}

		if ($weight == 0 || $weight == '' || $weight == null) {
			$weight = 0;
		}

		if ($volume != 0) {
			switch (strtolower($unit)) {
				case 'ml':
					$stockNeed = $originalStock * $volume * (100/$weight);
					$openStockNeed = $originalOpenStock * (100/$weight);
					break;
				case 'gr':
					$stockNeed = $originalStock * $volume;
					$openStockNeed = $originalOpenStock;
					break;
				default:
					$stockNeed = $originalStock * $volume;
					$openStockNeed = $originalOpenStock;
					break;
			}
		}

		$stockNeed =  floor($stockNeed);

		$openStockNeed =  floor($openStockNeed);

		return ['stockNeed' => $stockNeed, 'openStockNeed' => $openStockNeed];
	}

// CONVERTION FORMULA FROM WEIGHT TO VOLUME (TO BE CANCEL)
	private function createNewSupplier($product) {
		$supplier = array();

		$supplier["Supplier"] = "";
		$supplier["Quality"] = "";
		$supplier["Produce"] = "";
		$supplier["SupplierSize"] = "1";
		$supplier["SupplierUnit"] = "Item";
		$supplier["Cost"] = 0;
		$supplier["Purchase"] = 0;
		$supplier["Link"] = "";
		$supplier["Lots"] = "";
		$supplier["DateExpiration"] = "";
		$supplier["Tracking"] = "";
		$supplier["StockRetailLB"] = 0;
		$supplier["StockRecipe"] = 0;
		$supplier["DateDelivery"] = "";

		return $supplier;
	}
	private function createNewRecipe() {
		$recipe = array();
        $recipe["RecipeFormat"] = '';
        $recipe["RecipeName"] = '';
        $recipe["RecipeDate"] = date('Y-m-d');
        $recipe["RecipeQuantity"] = 0;
        $recipe["Serving"] = 0;
        $recipe["RecipeCost"] = 1;
        $recipe["RecipeTime"] = 1;
        $recipe["Steps"] = array();
        return $recipe;
	}
    public function addRecipes($recipes) {
    	$rs = array('success' => true);
    	$data = $this->loadData();
		if (count($data) <= 0) {
			$rs['success'] = false;
			$rs['error'] = 'Cannot update data';
    		return $rs;
		}
		$addedRecipes = array();
    	foreach ($recipes as $input) {
	    	if (empty($input['RecipeName'])) {
	    		$rs['success'] = false;
	    		$rs['error'] = 'RecipeName is empty';
	    		return $rs;
	    	}
	    	if (empty($input['RecipeFormat'])) {
	    		$rs['success'] = false;
	    		$rs['error'] = 'RecipeFormat is empty';
	    		return $rs;
	    	}
			$newRecipe = $this->createNewRecipe();
			$newRecipe['RecipeName'] = $input['RecipeName'];
			$newRecipe['RecipeFormat'] = $input['RecipeFormat'];
			$data[] = $newRecipe;
			$newRecipe['index'] = count($data)-1;
			$addedRecipes[] = $newRecipe;
    	}

		$update = $this->writeFile($data);
		if (!$update['success']) {
			$rs['success'] = false;
			$rs['error'] = $update['error'];
			return $rs;
		}
		$rs['recipes'] = $addedRecipes;
		return $rs;
    }
    private function writeFile($data) {
    	$result = array('success' => true);
		if (!file_put_contents($this->dataPath . '_temp', json_encode($data, JSON_PRETTY_PRINT))) {
			$result['success'] = false;
		}


		if ($result['success']) {
			$moveSuccess = rename($this->dataPath . '_temp', $this->dataPath);
		} else {
			$result['success'] = false;
			$result['error'] = 'Cannot update data';
		}
		return $result;
    }
	public function printRecipe($recipe) {
		$categoryCss = $this->loadCategoryCssData() ?? [];
		$inventories = array();
		$categoryCss = $categoryCss['CategoryCss'];
		foreach ($recipe['Steps'] as $index => $step) {
			foreach ($categoryCss as $category) {
				if (isset($step['Format']) && $step['Format'] == $category['category']) {
					$recipe['Steps'][$index]['Format_color'] = $category['style']['background-color'];
				}
			}
			if (isset($step['Format']) && !isset($inventories[$step['Format']])) {
				$inventories[$step['Format']] = $this->inventory->loadInventory($step['Format']);
			}
			if (isset($step['Format']) && isset($inventories[$step['Format']])) {
				$product = new Product($step['Format'], $step['Ingredient'], $inventories[$step['Format']]);
				if ($product->data) {
					$recipe['Steps'][$index]['product'] = $product->data;
					$bulkRetail = array_filter($product->data['Retail'], function($r) {
						return $r['StockLocation'] == 'Bulk';
					});
					$recipe['Steps'][$index]['bulkRetail'] = count($bulkRetail)?array_pop($bulkRetail):null;
				}
			}
		}
		$stepWeightTotal = 0;
		$stepQuantityTotal = 0;
		for ($i = count($recipe['Steps'])-1; $i >= 0 ; $i--) {
			$step = &$recipe['Steps'][$i];
			if (isset($step['SubTotal'])) {
				$step['StepWeight'] = $stepWeightTotal;
				$step['StepQuantity'] = $stepQuantityTotal;
				$stepWeightTotal = 0;
				$stepQuantityTotal = 0;
			} elseif (isset($step['Instruction'])) {
				$stepWeightTotal = 0;
				$stepQuantityTotal = 0;
			} elseif (isset($step['Ingredient'])) {
				if ($step['Format'] !== 'Packaging') {
					$stepWeightTotal += $this->getWeight($recipe, $step);
					$stepQuantityTotal += (float)$step['StepQuantity'];
				}
			}
		}
		$blocks = [];
		$block = ['instruction' => [], 'steps' => []];
		foreach ($recipe['Steps'] as $step) {
			if (isset($step['Instruction'])) {
				if ($block['instruction']) {
					$blocks[] = $block;
					$block = ['instruction' => [], 'steps' => []];
				}
				$block['instruction'] = $step;
			} else {
				$block['steps'][] = $step;
			}
		}
		if ($block['instruction']) {
			$blocks[] = $block;
		}
		require 'recipe-print-tpl.php';
	}
	private function getWeight($recipe, $step) {
		if ($step['StepMultiplier'] == 'true') {
			$stepWeightTotalForCondition = $step['StepQuantity'] * $recipe['RecipeQuantity'] * $recipe['Serving'];
		} else {
			$stepWeightTotalForCondition = $step['StepQuantity'] * $recipe['Serving'];
		}
		$weight = $stepWeightTotalForCondition>=4.5?round($stepWeightTotalForCondition):round($stepWeightTotalForCondition, 3);
		return $weight;
	}
    //add product sold weekly
    private function getDate($base = null) {
        if ($base == null)
            $base = time();
        if (date('N', $base) == 7) {
            return date('Y-m-d', $base);
        } else {
            return date('Y-m-d', strtotime('next sunday', $base));
        }
    }
    private function limitProductSoldWeekly($inventoryItem, $type = '') {
        $productSoldField = 'ProductSoldWeekly'.$type;
        if (is_array($inventoryItem[$productSoldField]) && count($inventoryItem[$productSoldField])) {
            $inventoryItem[$productSoldField] = array_filter(
                $inventoryItem[$productSoldField],
                function ($date) {
                    $now= new DateTime();
                    try {
                    	$target = new DateTime($date);
                    } catch (Exception $e) {
                    	return false;
                    }
                    if (!$target) {
                        return false;
                    }
                    $diff = (int)$now->diff($target)->format('%a');
                    return $diff < 365;
                },
                ARRAY_FILTER_USE_KEY
            );
        }
        return $inventoryItem;
    }
    public function addProductSold($inventoryItem, $productSold, $productSoldNeed) {
        $productSold = round($productSold, 2);
        $productSoldField = 'ProductSoldWeeklyRecipe';
        if (!isset($inventoryItem[$productSoldField])) {
        	$inventoryItem[$productSoldField] = array();
        }
        $dateKey = $this->getDate();
        if (!isset($inventoryItem[$productSoldField][$dateKey])) {
        	$inventoryItem[$productSoldField] = array($dateKey => 0) + $inventoryItem[$productSoldField];
        }
        $inventoryItem[$productSoldField][$dateKey] += $productSoldNeed;
        $inventoryItem[$productSoldField][$dateKey] = (string)floor($inventoryItem[$productSoldField][$dateKey]);
        $inventoryItem = $this->limitProductSoldWeekly($inventoryItem, 'Recipe');
        return $inventoryItem;
    }
    //add product sold weekly
}

function compareSupplier($s1, $s2) {
	return strcmp($s1['DateDelivery'], $s2['DateDelivery']);
}

function compareSupplierToGetLatest($s1, $s2) {
	return strcmp($s1['DateDelivery'], $s2['DateDelivery']);
}

function compareSupplierForStocking($s1, $s2) {
	return strcmp($s2['DateDelivery'], $s1['DateDelivery']);
}
if (!function_exists('pr')) {
	function pr($var) {
		$template = php_sapi_name() !== 'cli' ? '
%s
' : "\n%s\n";
		printf($template, print_r($var, true));
	}
}