function getSalesSummaryByDistrict($suppNo, $distNo = null)
{
//if distNo not set --> get all district and return an array
// $districts[distNo] --> result
include_once "District.php";
if (!isset($distNo)) {
$result = getAllDistricts();
while ($row = $result->fetch_array()) {
$districts[$row[distNo]] = getSalesSummaryByDistrict($suppNo, $row[distNo], "Sold", "DESC");
}
return $districts;
}
$query = "SELECT District." . distNo . ", District." . distName . ", OrderLine." . prodNo . ", Product." . prodName . ", Product." . prodPhoto . ", Product." . catNo . ", Category." . catName . ", SUM(OrderLine." . qty . ") AS Sold " . "FROM OrderLine " . "JOIN CustOrder ON OrderLine." . ordNo . " = CustOrder." . ordNo . " " . "JOIN Product ON Product." . prodNo . " = OrderLine." . prodNo . " " . "JOIN Category ON Product." . catNo . " = Category." . catNo . " " . "JOIN District ON CustOrder." . distNo . " = District." . distNo . " " . "WHERE Product." . suppNo . " = '{$suppNo}' " . "AND District." . distNo . " = '{$distNo}' " . "AND " . isDeleted . " = 0 " . "GROUP BY Product." . prodNo . " " . DB::genOrderByStr(func_get_args(), func_num_args(), 2);
return DB::query($query);
}
case 1:
$chart = getSalesSummaryByGender($suppNo);
$chart = $chart["M"];
break;
case 2:
$chart = getSalesSummaryByGender($suppNo);
$chart = $chart["F"];
break;
case 3:
$chart = getSalesSummaryByDistrict($suppNo, "DST01");
break;
case 4:
$chart = getSalesSummaryByDistrict($suppNo, "DST02");
break;
case 5:
$chart = getSalesSummaryByDistrict($suppNo, "DST03");
break;
case 6:
if (isset($_POST[catNo])) {
$chart = getSalesSummaryByCat($suppNo, $_POST[catNo]);
break;
} else {
return null;
}
}
if (!$chart) {
return json_encode($array);
}
while ($row = $chart->fetch_assoc()) {
$newArr["label"] = $row[prodName];
$newArr["y"] = intval($row["Sold"]);