<?php
include "../../myDatabase3.php";
$stockCardNo = $_GET['stockCardNo'];
$ro = new database3();
//$stockCardNo = "1720";
$highestCost = $ro->salesCost("MAX", $stockCardNo);
$lowestCost = $ro->salesCost("MIN", $stockCardNo);
$average = $highestCost + $lowestCost;
$average1 = $average / 2;
echo $ro->selectNow("inventoryStockCard", "description", "stockCardNo", $stockCardNo);
echo "<br>";
echo "Highest: " . $highestCost;
echo "<br>";
echo "Lowest: " . $lowestCost;
echo "<br>";
echo "Average: " . $average1;
echo "<br>";
echo "Dispense: " . $ro->countDispense($stockCardNo);
echo "<br>";
echo "Cost of Sales " . number_format($ro->countDispense($stockCardNo) * $average1, 2);
