<?php
include_once "web/prepend.php";
require_once 'collection/Receipt.php';
//require_once('collection/Collection.php');
require_once 'collection/Payment.php';
//require_once('collection/Due.php');
page_open(array("sess" => "rpts_Session", "auth" => "rpts_Challenge_Auth"));
$tpl = new rpts_Template();
$tpl->set_file(array(report => "collectionReport2Form.htm"));
global $auth;
$this->sess = $sess;
$this->user = $auth->auth;
$this->formArray["uid"] = $auth->auth["uid"];
$this->user = $auth->auth;
$tpl->set_var("uname", $this->user["uname"]);
$tpl->set_var("today", date("F j, Y"));
// must have atleast TM-VIEW access
$pageType = "%%%%1%%%%%";
if (!checkPerms($this->user["userType"], $pageType)) {
header("Location: Unauthorized.php" . $this->sess->url(""));
exit;
}
$tpl->set_block(report, LGUBLK, lguBlk);
$db = new DB_RPTS();
$sql = "select * from MunicipalityCity order by description;";
$db->query($sql);
for ($i = 0; $db->next_record(); $i++) {
$tpl->set_var($db->Record);
$tpl->parse(lguBlk, LGUBLK, true);
}
<?
include_once("web/prepend.php");
include_once('web/panachart.php');
$tpl=new rpts_Template();
$tpl->set_file(array(report=>"Form.htm"));
$db = new DB_SelectLGU("erpts-test");
$db->query("SELECT * FROM Barangay ORDER BY description");
$tpl->set_block(report,BRGY,bBlk);
if($db->num_rows()>0){
for($r=0;$db->next_record();$r++){
$tpl->set_var(barangayID,$db->f("barangayID"));
$tpl->set_var(barangayName,$db->f("description"));
$tpl->parse(bBlk,BRGY,true);
}
}
$tpl->set_var(fileName,$PHP_SELF);
if($isSubmit){
$db = new DB_SelectLGU("erpts-test");
if($brgyID==0)
$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
GROUP BY ( ".$classification."ActualUsesID )";
$buffer[$i][penaltyIdle] = $db->f("penaltyIdle");
} else {
$buffer[$i][priorPenaltyIdle] += $db->f("penaltyIdle");
}
}
$buffer[$i][totalIdle] = $buffer[$i][paidIdle] + $buffer[$i][priorIdle] + $buffer[$i][penaltyIdle];
$buffer[$i][specialLevy] = 0;
$sql = "SELECT sum(payments.amount) as paidTotal, sum(payments.penalty) as paidPenalty" . " FROM collections" . " INNER JOIN collectionPayments ON collectionPayments.collectionID = collections.collectionID" . " INNER JOIN payments ON payments.paymentID = collectionPayments.paymentID" . " INNER JOIN dues ON dues.dueID = payments.dueID" . " WHERE payments.receiptNum = {$receiptNo}" . " AND collections.kindOfPayment <> 'cash';";
$db->query($sql);
$buffer[$i][totalNonCash] = $db->f("paidTotal") + $db->f("paidPenalty");
$buffer[$i][grandTotalGrossColl] = $buffer[$i][totalGrossBasic] + $buffer[$i][totalGrossSEF] + $buffer[$i][totalIdle] + $buffer[$i][specialLevy] + $buffer[$i][totalNonCash];
$buffer[$i][grandTotalNetColl] = $buffer[$i][totalNetBasic] + $buffer[$i][totalNetSEF] + $buffer[$i][totalIdle] + $buffer[$i][specialLevy] + $buffer[$i][totalNonCash];
}
$tpl = new rpts_Template();
//$tpl->set_file(array(report=>"collectionReport2.htm"));
$tpl->set_file(array(report => "report2Asoa.xml"));
$tpl->set_var(lgu, $lguName);
$tpl->set_var(startDate, $startDate);
$tpl->set_var(endDate, $endDate);
$tpl->set_var(rpuClass, $rpuClassDesc);
$ypos = 424;
$ypos1 = 416;
$yposx = 428;
$yposx1 = 420;
$iStart = 0;
$jStart = 0;
$rowPerPage = 16;
//echo count($buffer)."<br>";
//echo ceil(count($buffer)/$rowPerPage)."<br>";
$tpl->set_block(report, PAGE, pageBlk);
$tpl->set_block(PAGE, ROW, rowBlk);