USING ( afsID ) 
		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);
예제 #2
0
 function computeProperty($column, $sql)
 {
     $db = new DB_SelectLGU($this->dbName);
     $db->query($sql);
     while ($db->next_record()) {
         $code = $db->f("reportCode");
         switch ($code) {
             case "RE":
                 $this->totalRETaxableMarketValue += $db->f("adjustedMarketValue");
                 eval('$this->totalTaxable' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 eval('$this->subRETaxable' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 $this->totalRETaxableAssessedValue += $db->f("assessedValue");
                 eval('$this->totalTaxable' . $column . 'AssessedValue += $db->f("assessedValue");');
                 eval('$this->subRETaxable' . $column . 'AssessedValue += $db->f("assessedValue");');
                 $this->totalTaxableMarketValue += $db->f("adjustedMarketValue");
                 $this->totalTaxableAssessedValue += $db->f("assessedValue");
                 break;
             case "AG":
                 $this->totalAGTaxableMarketValue += $db->f("adjustedMarketValue");
                 eval('$this->totalTaxable' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 eval('$this->subAGTaxable' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 $this->totalAGTaxableAssessedValue += $db->f("assessedValue");
                 eval('$this->totalTaxable' . $column . 'AssessedValue += $db->f("assessedValue");');
                 eval('$this->subAGTaxable' . $column . 'AssessedValue += $db->f("assessedValue");');
                 $this->totalTaxableMarketValue += $db->f("adjustedMarketValue");
                 $this->totalTaxableAssessedValue += $db->f("assessedValue");
                 break;
             case "CO":
                 $this->totalCOTaxableMarketValue += $db->f("adjustedMarketValue");
                 eval('$this->totalTaxable' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 eval('$this->subCOTaxable' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 $this->totalCOTaxableAssessedValue += $db->f("assessedValue");
                 eval('$this->totalTaxable' . $column . 'AssessedValue += $db->f("assessedValue");');
                 eval('$this->subCOTaxable' . $column . 'AssessedValue += $db->f("assessedValue");');
                 $this->totalTaxableMarketValue += $db->f("adjustedMarketValue");
                 $this->totalTaxableAssessedValue += $db->f("assessedValue");
                 break;
             case "IN":
                 $this->totalINTaxableMarketValue += $db->f("adjustedMarketValue");
                 eval('$this->totalTaxable' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 eval('$this->subINTaxable' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 $this->totalINTaxableAssessedValue += $db->f("assessedValue");
                 eval('$this->totalTaxable' . $column . 'AssessedValue += $db->f("assessedValue");');
                 eval('$this->subINTaxable' . $column . 'AssessedValue += $db->f("assessedValue");');
                 $this->totalTaxableMarketValue += $db->f("adjustedMarketValue");
                 $this->totalTaxableAssessedValue += $db->f("assessedValue");
                 break;
             case "MI":
                 $this->totalMITaxableMarketValue += $db->f("adjustedMarketValue");
                 eval('$this->totalTaxable' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 eval('$this->subMITaxable' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 $this->totalMITaxableAssessedValue += $db->f("assessedValue");
                 eval('$this->totalTaxable' . $column . 'AssessedValue += $db->f("assessedValue");');
                 eval('$this->subMITaxable' . $column . 'AssessedValue += $db->f("assessedValue");');
                 $this->totalTaxableMarketValue += $db->f("adjustedMarketValue");
                 $this->totalTaxableAssessedValue += $db->f("assessedValue");
                 break;
             case "TI":
                 $this->totalTITaxableMarketValue += $db->f("adjustedMarketValue");
                 eval('$this->totalTaxable' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 eval('$this->subTITaxable' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 $this->totalTITaxableAssessedValue += $db->f("assessedValue");
                 eval('$this->totalTaxable' . $column . 'AssessedValue += $db->f("assessedValue");');
                 eval('$this->subTITaxable' . $column . 'AssessedValue += $db->f("assessedValue");');
                 $this->totalTaxableMarketValue += $db->f("adjustedMarketValue");
                 $this->totalTaxableAssessedValue += $db->f("assessedValue");
                 break;
             case "SP":
                 $this->totalSPTaxableMarketValue += $db->f("adjustedMarketValue");
                 eval('$this->totalTaxable' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 eval('$this->subSPTaxable' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 $this->totalSPTaxableAssessedValue += $db->f("assessedValue");
                 eval('$this->totalTaxable' . $column . 'AssessedValue += $db->f("assessedValue");');
                 eval('$this->subSPTaxable' . $column . 'AssessedValue += $db->f("assessedValue");');
                 $this->totalTaxableMarketValue += $db->f("adjustedMarketValue");
                 $this->totalTaxableAssessedValue += $db->f("assessedValue");
                 break;
             case "HO":
                 $this->totalHOTaxableMarketValue += $db->f("adjustedMarketValue");
                 eval('$this->totalTaxable' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 eval('$this->subHOTaxable' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 $this->totalHOTaxableAssessedValue += $db->f("assessedValue");
                 eval('$this->totalTaxable' . $column . 'AssessedValue += $db->f("assessedValue");');
                 eval('$this->subHOTaxable' . $column . 'AssessedValue += $db->f("assessedValue");');
                 $this->totalTaxableMarketValue += $db->f("adjustedMarketValue");
                 $this->totalTaxableAssessedValue += $db->f("assessedValue");
                 break;
             case "SC":
                 $this->totalSCTaxableMarketValue += $db->f("adjustedMarketValue");
                 eval('$this->totalTaxable' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 eval('$this->subSCTaxable' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 $this->totalSCTaxableAssessedValue += $db->f("assessedValue");
                 eval('$this->totalTaxable' . $column . 'AssessedValue += $db->f("assessedValue");');
                 eval('$this->subSCTaxable' . $column . 'AssessedValue += $db->f("assessedValue");');
                 $this->totalTaxableMarketValue += $db->f("adjustedMarketValue");
                 $this->totalTaxableAssessedValue += $db->f("assessedValue");
                 break;
             case "CU":
                 $this->totalCUTaxableMarketValue += $db->f("adjustedMarketValue");
                 eval('$this->totalTaxable' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 eval('$this->subCUTaxable' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 $this->totalCUTaxableAssessedValue += $db->f("assessedValue");
                 eval('$this->totalTaxable' . $column . 'AssessedValue += $db->f("assessedValue");');
                 eval('$this->subCUTaxable' . $column . 'AssessedValue += $db->f("assessedValue");');
                 $this->totalTaxableMarketValue += $db->f("adjustedMarketValue");
                 $this->totalTaxableAssessedValue += $db->f("assessedValue");
                 break;
             case "OTX":
                 $this->totalOTTaxableMarketValue += $db->f("adjustedMarketValue");
                 eval('$this->totalTaxable' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 eval('$this->subOTTaxable' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 $this->totalOTTaxableAssessedValue += $db->f("assessedValue");
                 eval('$this->totalTaxable' . $column . 'AssessedValue += $db->f("assessedValue");');
                 eval('$this->subOTTaxable' . $column . 'AssessedValue += $db->f("assessedValue");');
                 $this->totalTaxableMarketValue += $db->f("adjustedMarketValue");
                 $this->totalTaxableAssessedValue += $db->f("assessedValue");
                 break;
             case "GO":
                 $this->totalGOExemptMarketValue += $db->f("adjustedMarketValue");
                 eval('$this->totalExempt' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 eval('$this->subGOExempt' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 $this->totalGOExemptAssessedValue += $db->f("assessedValue");
                 eval('$this->totalExempt' . $column . 'AssessedValue += $db->f("assessedValue");');
                 eval('$this->subGOExempt' . $column . 'AssessedValue += $db->f("assessedValue");');
                 $this->totalExemptMarketValue += $db->f("adjustedMarketValue");
                 $this->totalExemptAssessedValue += $db->f("assessedValue");
                 break;
             case "RL":
                 $this->totalRLExemptMarketValue += $db->f("adjustedMarketValue");
                 eval('$this->totalExempt' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 eval('$this->subRLExempt' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 $this->totalRLExemptAssessedValue += $db->f("assessedValue");
                 eval('$this->totalExempt' . $column . 'AssessedValue += $db->f("assessedValue");');
                 eval('$this->subRLExempt' . $column . 'AssessedValue += $db->f("assessedValue");');
                 $this->totalExemptMarketValue += $db->f("adjustedMarketValue");
                 $this->totalExemptAssessedValue += $db->f("assessedValue");
                 break;
             case "CH":
                 $this->totalCHExemptMarketValue += $db->f("adjustedMarketValue");
                 eval('$this->totalExempt' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 eval('$this->subCHExempt' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 $this->totalCHExemptAssessedValue += $db->f("assessedValue");
                 eval('$this->totalExempt' . $column . 'AssessedValue += $db->f("assessedValue");');
                 eval('$this->subCHExempt' . $column . 'AssessedValue += $db->f("assessedValue");');
                 $this->totalExemptMarketValue += $db->f("adjustedMarketValue");
                 $this->totalExemptAssessedValue += $db->f("assessedValue");
                 break;
             case "ED":
                 $this->totalEDExemptMarketValue += $db->f("adjustedMarketValue");
                 eval('$this->totalExempt' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 eval('$this->subEDExempt' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 $this->totalEDExemptAssessedValue += $db->f("assessedValue");
                 eval('$this->totalExempt' . $column . 'AssessedValue += $db->f("assessedValue");');
                 eval('$this->subEDExempt' . $column . 'AssessedValue += $db->f("assessedValue");');
                 $this->totalExemptMarketValue += $db->f("adjustedMarketValue");
                 $this->totalExemptAssessedValue += $db->f("assessedValue");
                 break;
             case "OTE":
                 $this->totalOTExemptMarketValue += $db->f("adjustedMarketValue");
                 eval('$this->totalExempt' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 eval('$this->subOTExempt' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
                 $this->totalOTExemptAssessedValue += $db->f("assessedValue");
                 eval('$this->totalExempt' . $column . 'AssessedValue += $db->f("assessedValue");');
                 eval('$this->subOTExempt' . $column . 'AssessedValue += $db->f("assessedValue");');
                 $this->totalExemptMarketValue += $db->f("adjustedMarketValue");
                 $this->totalExemptAssessedValue += $db->f("assessedValue");
                 break;
         }
         if ($column == "Land") {
             $areaInSquareMeters = $this->getLandAreaInSquareMeters($code);
             $this->totalLandArea += $areaInSquareMeters;
             switch ($code) {
                 case "RE":
                 case "AG":
                 case "CO":
                 case "IN":
                 case "MI":
                 case "TI":
                 case "SP":
                 case "HO":
                 case "SC":
                 case "CU":
                 case "OTX":
                     if ($code == "OTX") {
                         $code = "OT";
                     }
                     $this->totalTaxableLandArea += $areaInSquareMeters;
                     eval('$this->sub' . $code . 'TaxableLandArea += $areaInSquareMeters;');
                     break;
                 case "GO":
                 case "RL":
                 case "CH":
                 case "ED":
                 case "OTE":
                     if ($code == "OTE") {
                         $code = "OT";
                     }
                     $this->totalExemptLandArea += $areaInSquareMeters;
                     eval('$this->sub' . $code . 'ExemptLandArea += $areaInSquareMeters;');
                     break;
             }
         }
         eval('$this->total' . $column . 'MarketValue += $db->f("adjustedMarketValue");');
         eval('$this->total' . $column . 'AssessedValue += $db->f("assessedValue");');
         $this->totalMarketValue += $db->f("adjustedMarketValue");
         $this->totalAssessedValue += $db->f("assessedValue");
     }
 }