INNER JOIN ".ucwords($classification)."ActualUses ON ".ucwords($classification).".actualUse = ".ucwords($classification)."ActualUses.".$classification."ActualUsesID
GROUP BY ( ".$classification."ActualUsesID )";
else
$sql ="SELECT ".ucwords($classification)."ActualUses.code as description, sum( ".ucwords($classification).".marketValue ) as total
FROM AFS
INNER JOIN ".ucwords($classification)."
USING ( afsID )
INNER JOIN ".ucwords($classification)."ActualUses ON ".ucwords($classification).".actualUse = ".ucwords($classification)."ActualUses.".$classification."ActualUsesID
LEFT JOIN Location ON AFS.odID = Location.odID
LEFT JOIN LocationAddress ON Location.locationAddressID = LocationAddress.locationAddressID
LEFT JOIN Barangay ON LocationAddress.barangayID = Barangay.barangayID
WHERE AFS.archive != 'true' AND Barangay.barangayID = $brgyID
GROUP BY ( ".$classification."ActualUsesID )";
$db->query($sql);
if($db->num_rows() >0){
for($i=0;$db->next_record();$i++){
$total += $db->f("total");
$t[$i] = $db->f("total");
$barangay[$i] = $db->f("description");
}
}
/*for($i=0;$i<count($t);$i++){
$percentage[$i] = ($t[$i]/$total) * 100;
}*/
//$vCht4 = array(1,20,20,34,5,52,41,20,34,43,64,40);
// $vCht5 = array(12,21,36,27,14,23,3,5,29,23,12,5);
// $vCht6 = array(5,7,3,15,7,8,2,2,2,11,22,3);
