format("Y-m-d");
$dasTime = date('H:i:s');
$daDate = explode('-',$dasDate);
$dasYear = $daDate[0]; //One
$dasYearA = $dasYear - 1;//Two
$dasYearB = $dasYear - 2;//Three
$dasYearC = $dasYear - 3;//Four
$dasYearD = $dasYear - 4;//Five
$dasYearE = $dasYear - 5;//Six
$dasYearF = $dasYear - 6;//Seven
$dasYearG = $dasYear - 7;//Eight
//echo $dasYear ." - " .$dasYearA." - " .$dasYearB." - " .$dasYearC." - " .$dasYearD." - " .$dasYearE." - " .$dasYearF." - " .$dasYearG;
//CurrentYear
$YearFirstQStart = $dasYear ."-01-31";
$YearFirstQEnd = $dasYear ."-03-31";
$YearSecondQStart = $dasYear ."-04-01";
$YearSecondQEnd = $dasYear ."-06-30";
$YearThirdQStart = $dasYear ."-07-01";
$YearThirdQEnd = $dasYear ."-09-30";
$YearFourtQStart = $dasYear ."-10-01";
$YearFourtQEnd = $dasYear ."-12-31";
//CurrentYear - 1
$aYearFirstQStart = $dasYearA ."-01-31";
$aYearFirstQEnd = $dasYearA ."-03-31";
$aYearSecondQStart = $dasYearA ."-04-01";
$aYearSecondQEnd = $dasYearA ."-06-30";
$aYearThirdQStart = $dasYearA ."-07-01";
$aYearThirdQEnd = $dasYearA ."-09-30";
$aYearFourtQStart = $dasYearA ."-10-01";
$aYearFourtQEnd = $dasYearA ."-12-31";
//CurrentYear - 2
$bYearFirstQStart = $dasYearB ."-01-31";
$bYearFirstQEnd = $dasYearB ."-03-31";
$bYearSecondQStart = $dasYearB ."-04-01";
$bYearSecondQEnd = $dasYearB ."-06-30";
$bYearThirdQStart = $dasYearB ."-07-01";
$bYearThirdQEnd = $dasYearB ."-09-30";
$bYearFourtQStart = $dasYearB ."-10-01";
$bYearFourtQEnd = $dasYearB ."-12-31";
//CurrentYear - 3
$cYearFirstQStart = $dasYearC ."-01-31";
$cYearFirstQEnd = $dasYearC ."-03-31";
$cYearSecondQStart = $dasYearC ."-04-01";
$cYearSecondQEnd = $dasYearC ."-06-30";
$cYearThirdQStart = $dasYearC ."-07-01";
$cYearThirdQEnd = $dasYearC ."-09-30";
$cYearFourtQStart = $dasYearC ."-10-01";
$cYearFourtQEnd = $dasYearC ."-12-31";
//CurrentYear - 4
$dYearFirstQStart = $dasYearD ."-01-31";
$dYearFirstQEnd = $dasYearD ."-03-31";
$dYearSecondQStart = $dasYearD ."-04-01";
$dYearSecondQEnd = $dasYearD ."-06-30";
$dYearThirdQStart = $dasYearD ."-07-01";
$dYearThirdQEnd = $dasYearD ."-09-30";
$dYearFourtQStart = $dasYearD ."-10-01";
$dYearFourtQEnd = $dasYearD ."-12-31";
//CurrentYear - 5
$eYearFirstQStart = $dasYearE ."-01-31";
$eYearFirstQEnd = $dasYearE ."-03-31";
$eYearSecondQStart = $dasYearE ."-04-01";
$eYearSecondQEnd = $dasYearE ."-06-30";
$eYearThirdQStart = $dasYearE ."-07-01";
$eYearThirdQEnd = $dasYearE ."-09-30";
$eYearFourtQStart = $dasYearE ."-10-01";
$eYearFourtQEnd = $dasYearE ."-12-31";
//CurrentYear - 6
$fYearFirstQStart = $dasYearF ."-01-31";
$fYearFirstQEnd = $dasYearF ."-03-31";
$fYearSecondQStart = $dasYearF ."-04-01";
$fYearSecondQEnd = $dasYearF ."-06-30";
$fYearThirdQStart = $dasYearF ."-07-01";
$fYearThirdQEnd = $dasYearF ."-09-30";
$fYearFourtQStart = $dasYearF ."-10-01";
$fYearFourtQEnd = $dasYearF ."-12-31";
//CurrentYear - 7
$gYearFirstQStart = $dasYearG ."-01-31";
$YearFirstQEnd = $dasYearG ."-03-31";
$gYearSecondQStart = $dasYearG ."-04-01";
$gYearSecondQEnd = $dasYearG ."-06-30";
$gYearThirdQStart = $dasYearG ."-07-01";
$gYearThirdQEnd = $dasYearG ."-09-30";
$gYearFourtQStart = $dasYearG ."-10-01";
$gYearFourtQEnd = $dasYearG ."-12-31";
//CurrentYear Quarterly Count
$dataYearOneA = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$YearFirstQStart' AND '$YearFirstQEnd'"),0);
$dataYearOneB = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$YearSecondQStart' AND '$YearSecondQEnd'"),0);
$dataYearOneC = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$YearThirdQStart' AND '$YearThirdQEnd'"),0);
$dataYearOneD = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$YearFourtQStart' AND '$YearFourtQEnd'"),0);
if($dataYearOneC ==''){$dataYearOneC=0;}
if($dataYearOneB ==''){$dataYearOneB=0;}
if($dataYearOneD ==''){$dataYearOneD=0;}
if($dataYearOneA ==''){$dataYearOneA=0;}
$dataYearTwoA = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$aYearFirstQStart' AND '$aYearFirstQEnd'"),0);
$dataYearTwoB = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$aYearSecondQStart' AND '$aYearSecondQEnd'"),0);
$dataYearTwoC = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$aYearThirdQStart' AND '$aYearThirdQEnd'"),0);
$dataYearTwoD = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$aYearFourtQStart' AND '$aYearFourtQEnd'"),0);
if($dataYearTwoA ==''){$dataYearTwoA=0;}
if($dataYearTwoB ==''){$dataYearTwoB=0;}
if($dataYearTwoC ==''){$dataYearTwoC=0;}
if($dataYearTwoD ==''){$dataYearTwoD=0;}
$dataYearThreeA =mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$bYearFirstQStart' AND '$bYearFirstQEnd'"),0);
$dataYearThreeB = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$bYearSecondQStart' AND '$bYearSecondQEnd'"),0);
$dataYearThreeC = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$bYearThirdQStart' AND '$bYearThirdQEnd'"),0);
$dataYearThreeD = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$bYearFourtQStart' AND '$bYearFourtQEnd'"),0);
if($dataYearThreeA ==''){$dataYearThreeA=0;}
if($dataYearThreeB ==''){$dataYearThreeB=0;}
if($dataYearThreeC ==''){$dataYearThreeC=0;}
if($dataYearThreeD ==''){$dataYearThreeD=0;}
$dataYearFourA = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$cYearFirstQStart' AND '$cYearFirstQEnd'"),0);
$dataYearFourB = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$cYearSecondQStart' AND '$cYearSecondQEnd'"),0);
$dataYearFourC = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$cYearThirdQStart' AND '$cYearThirdQEnd'"),0);
$dataYearFourD = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$cYearFourtQStart' AND '$cYearFourtQEnd'"),0);
if($dataYearFourA ==''){$dataYearFourA=0;}
if($dataYearFourB ==''){$dataYearFourB=0;}
if($dataYearFourC ==''){$dataYearFourC=0;}
if($dataYearFourD ==''){$dataYearFourD=0;}
$dataYearFiveA = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$dYearFirstQStart' AND '$dYearFirstQEnd'"),0);
$dataYearFiveB = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$dYearSecondQStart' AND '$dYearSecondQEnd'"),0);
$dataYearFiveC = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$dYearThirdQStart' AND '$dYearThirdQEnd'"),0);
$dataYearFiveD = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$dYearFourtQStart' AND '$dYearFourtQEnd'"),0);
if($dataYearFiveA ==''){$dataYearFiveA=0;}
if($dataYearFiveB ==''){$dataYearFiveB=0;}
if($dataYearFiveC ==''){$dataYearFiveC=0;}
if($dataYearFiveD ==''){$dataYearFiveD=0;}
$dataYearSixA = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$eYearFirstQStart' AND '$eYearFirstQEnd'"),0);
$dataYearSixB = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$eYearSecondQStart' AND '$eYearSecondQEnd'"),0);
$dataYearSixC = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$eYearThirdQStart' AND '$eYearThirdQEnd'"),0);
$dataYearSixD = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$eYearFourtQStart' AND '$eYearFourtQEnd'"),0);
if($dataYearSixA ==''){$dataYearSixA=0;}
if($dataYearSixB ==''){$dataYearSixB=0;}
if($dataYearSixC ==''){$dataYearSixC=0;}
if($dataYearSixD ==''){$dataYearSixD=0;}
$dataYearSevenA = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$gYearFirstQStart' AND '$gYearFirstQEnd'"),0);
$dataYearSevenB = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$gYearSecondQStart' AND '$gYearSecondQEnd'"),0);
$dataYearSevenC = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$gYearThirdQStart' AND '$gYearThirdQEnd'"),0);
$dataYearSevenD = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$gYearFourtQStart' AND '$gYearFourtQEnd'"),0);
if($dataYearSevenA ==''){$dataYearSevenA=0;}
if($dataYearSevenB ==''){$dataYearSevenB=0;}
if($dataYearSevenC ==''){$dataYearSevenC=0;}
if($dataYearSevenD ==''){$dataYearSevenD=0;}
$dataYearEightA = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$fYearFirstQStart' AND '$fYearFirstQEnd'"),0);
$dataYearEightB = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$fYearSecondQStart' AND '$fYearSecondQEnd'"),0);
$dataYearEightC = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$fYearThirdQStart' AND '$fYearThirdQEnd'"),0);
$dataYearEightD = mysql_result(mysql_query("SELECT SUM(dr_amount) FROM `prf_delivery_receiving_logs` WHERE `date_delivered` BETWEEN '$fYearFourtQStart' AND '$fYearFourtQEnd'"),0);
if($dataYearEightA ==''){$dataYearEightA=0;}
if($dataYearEightB ==''){$dataYearEightB=0;}
if($dataYearEightC ==''){$dataYearEightC=0;}
if($dataYearEightD ==''){$dataYearEightD=0;}
$getDataA = mysql_query("SELECT * FROM `prf_expensecategory` WHERE 1");
while($row=mysql_fetch_array($getDataA)){
$catID = $row['id'];
$catSum = number_format($countCat,2,'.',',');
//echo $row['description'].$catSum;
switch($catID){
case '1':
$CapexAmount = mysql_result(mysql_query("SELECT SUM(invoice_amount) FROM `prf_request_detl` WHERE `category_id`='1' AND `po_code`!=''"),0);
$CapexCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `category_id`='1' AND `po_code`!=''"),0);
break;
case '2':
$MarketingAmount = mysql_result(mysql_query("SELECT SUM(invoice_amount) FROM `prf_request_detl` WHERE `category_id`='2' AND `po_code`!=''"),0);
$MarketingCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `category_id`='2' AND `po_code`!=''"),0);
break;
case '3':
$OfficeSupplies = mysql_result(mysql_query("SELECT SUM(invoice_amount) FROM `prf_request_detl` WHERE `category_id`='3' AND `po_code`!=''"),0);
$OfficeCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `category_id`='3' AND `po_code`!=''"),0);
break;
case '4':
$vehicleRepair = mysql_result(mysql_query("SELECT SUM(invoice_amount) FROM `prf_request_detl` WHERE `category_id`='4' AND `po_code`!=''"),0);
$vehicleCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `category_id`='4' AND `po_code`!=''"),0);
break;
case '5':
$RepairMaintenance = mysql_result(mysql_query("SELECT SUM(invoice_amount) FROM `prf_request_detl` WHERE `category_id`='5' AND `po_code`!=''"),0);
$RepairMaintenanceCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `category_id`='5' AND `po_code`!=''"),0);
break;
case '6':
$Consumables = mysql_result(mysql_query("SELECT SUM(invoice_amount) FROM `prf_request_detl` WHERE `category_id`='6' AND `po_code`!=''"),0);
$ConsumablesCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `category_id`='6' AND `po_code`!=''"),0);
break;
case '7':
$Constructions = mysql_result(mysql_query("SELECT SUM(invoice_amount) FROM `prf_request_detl` WHERE `category_id`='7' AND `po_code`!=''"),0);
$ConstructionsCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `category_id`='7' AND `po_code`!=''"),0);
break;
}
}
if($CapexAmount==''){
$CapexAmount=0;
}
if($MarketingAmount==''){
$MarketingAmount=0;
}
if($OfficeSupplies==''){
$OfficeSupplies=0;
}
if($vehicleRepair==''){
$vehicleRepair=0;
}
if($RepairMaintenance==''){
$RepairMaintenance=0;
}
if($Consumables==''){
$Consumables=0;
}
if($Constructions==''){
$Constructions=0;
}
?>
View More
View More
View More