function PaymentEncode($sess, $http_post_vars)
{
$this->sess = $sess;
$this->tpl = new rpts_Template(getcwd(), "keep");
foreach ($http_post_vars as $key => $value) {
$this->formArray[$key] = un_number_format($value);
}
$this->formArray["maxLinesPerReceipt"] = 6;
}
function formatCurrency($key)
{
if ($this->formArray[$key] == "") {
return false;
}
if (is_numeric($this->formArray[$key])) {
$this->formArray[$key] = number_format(un_number_format($this->formArray[$key]), 2, ".", ",");
}
}
function calculateAssessedValue()
{
$this->adjustedMarketValue = un_number_format($this->adjustedMarketValue);
$this->assessmentLevel = un_number_format($this->assessmentLevel);
$this->assessedValue = roundToNearestTen($this->adjustedMarketValue * ($this->assessmentLevel / 100));
}
function displayMachineriesList($machineriesList)
{
if (count($machineriesList)) {
foreach ($machineriesList as $mkey => $machineries) {
// "kind" is assumed to be treated as "classes" for machineries
$machineriesClasses = new MachineriesClasses();
if (is_numeric($machineries->getKind())) {
$machineriesClasses->selectRecord($machineries->getKind());
$machineriesClassesDescription = $machineriesClasses->getDescription();
$machineriesClassesCode = $machineriesClasses->getCode();
} else {
$machineriesClassesDescription = $machineries->getKind();
$machineriesClassesCode = $machineries->getActualUse();
}
// "classification" is assumed to be treated as "actualUse" for machineries
$machineriesActualUses = new MachineriesActualUses();
if (is_numeric($machineries->getActualUse())) {
$machineriesActualUses->selectRecord($machineries->getActualUse());
$machineriesActualUsesDescription = $machineriesActualUses->getDescription();
$machineriesActualUsesCode = $machineriesActualUses->getCode();
} else {
$machineriesActualUsesDescription = $machineries->getActualUse();
$machineriesActualUsesCode = $machineries->getActualUse();
}
if ($this->formArray["p"] <= 10) {
$p = $this->formArray["p"];
$this->formArray["ypos"] -= 12;
$offset = $this->formArray["ypos"];
$items .= "<textitem xpos=\"40\" ypos=\"" . $offset . "\" font=\"Helvetica\" size=\"10\" align=\"left\">" . $machineriesClassesDescription . "</textitem>";
$items .= "<textitem xpos=\"146\" ypos=\"" . $offset . "\" font=\"Helvetica\" size=\"9\" align=\"left\">" . $machineriesActualUsesDescription . "</textitem>";
$items .= "<textitem xpos=\"337\" ypos=\"" . $offset . "\" font=\"Helvetica\" size=\"10\" align=\"right\">" . number_format($machineries->getMarketValue(), 2) . "</textitem>";
$items .= "<textitem xpos=\"430\" ypos=\"" . $offset . "\" font=\"Helvetica\" size=\"10\" align=\"right\">" . number_format($machineries->getAssessmentLevel(), 2) . "</textitem>";
$items .= "<textitem xpos=\"558\" ypos=\"" . $offset . "\" font=\"Helvetica\" size=\"10\" align=\"right\">" . $machineries->getAssessedValue() . "</textitem>";
$offsetx = $offset - 3;
$items .= "<lineitem x1=\"40\" y1=\"" . $offsetx . "\" x2=\"120\" y2=\"" . $offsetx . "\">blurb</lineitem>";
$items .= "<lineitem x1=\"147\" y1=\"" . $offsetx . "\" x2=\"220\" y2=\"" . $offsetx . "\">blurb</lineitem>";
$items .= "<lineitem x1=\"244\" y1=\"" . $offsetx . "\" x2=\"337\" y2=\"" . $offsetx . "\">blurb</lineitem>";
$items .= "<lineitem x1=\"358\" y1=\"" . $offsetx . "\" x2=\"445\" y2=\"" . $offsetx . "\">blurb</lineitem>";
$items .= "<lineitem x1=\"457\" y1=\"" . $offsetx . "\" x2=\"558\" y2=\"" . $offsetx . "\">blurb</lineitem>";
$this->formArray["totalMarketValue"] += $machineries->getMarketValue();
$this->formArray["totalAssessedValue"] += un_number_format($machineries->getAssessedValue());
/*
$this->formArray["kind".$p] = $machineriesClassesDescription;
$this->formArray["classification".$p] = $machineriesActualUsesDescription;
$this->formArray["marketValue".$p] = un_number_format($machineries->getMarketValue());
$this->formArray["assessmentLevel".$p] = un_number_format($machineries->getAssessmentLevel());
$this->formArray["assessedValue".$p] = un_number_format($machineries->getAssessedValue());
$this->formArray["totalMarketValue"] += un_number_format($this->formArray["marketValue".$p]);
$this->formArray["totalAssessedValue"] += un_number_format($this->formArray["assessedValue".$p]);
*/
$this->formArray["p"]++;
}
}
}
}
function Main()
{
$eRPTSSettings = new eRPTSSettings();
if ($eRPTSSettings->selectRecord(1)) {
$this->tpl->set_var("lguType", strtoupper($eRPTSSettings->getLguType()));
$this->tpl->set_var("lguName", strtoupper($eRPTSSettings->getLguName()));
}
$dbPayment = new DB_RPTS();
$dbTD = new DB_RPTS();
$dbBacktaxTD = new DB_RPTS();
$dbDue = new DB_RPTS();
$dbPaymentTD = new DB_RPTS();
$dbPaymentBacktaxTD = new DB_RPTS();
$dbCollection = new DB_RPTS();
// gather unique TD's and BacktaxTD's from Payments for year
$sqlPayment = "SELECT paymentID, " . "tdID, " . "backtaxTDID " . "FROM Payment " . "WHERE status!='cancelled' " . "AND YEAR(paymentDate) LIKE '" . $this->formArray["year"] . "' " . "GROUP BY tdID, backtaxTDID " . "ORDER BY paymentID DESC ";
$dbPayment->query($sqlPayment);
if ($dbPayment->nf() > 0) {
while ($dbPayment->next_record()) {
$year = "";
$pageRecord = array("propertyIndexNumber" => "", "tdNumber" => "", "paidBasic" => 0, "paidSef" => 0, "discount" => 0, "basicSef" => 0, "yearDel" => "", "basicDel" => 0, "sefDel" => 0, "penalty" => 0, "totalDel" => 0, "totalAmount" => 0);
if ($dbPayment->f("backtaxTDID") != 0) {
// ------- start of BacktaxTD condition ------------------------- //
// gather BacktaxTD details
$sqlBacktaxTD = "SELECT tdNumber as tdNumber, " . "startYear as year " . "FROM BacktaxTD " . "WHERE " . "backtaxTDID = '" . $dbPayment->f("backtaxTDID") . "' ";
$dbBacktaxTD->query($sqlBacktaxTD);
if ($dbBacktaxTD->next_record()) {
$pageRecord["tdNumber"] = $dbBacktaxTD->f("tdNumber");
$year = $dbBacktaxTD->f("year");
}
// gather Payments for BacktaxTD for this year
$sqlPaymentBacktaxTD = "SELECT * " . "FROM Payment WHERE " . "backtaxTDID='" . $dbPayment->f("backtaxTDID") . "' " . "AND YEAR(paymentDate) LIKE '" . $this->formArray["year"] . "' " . "AND status!='cancelled' " . "ORDER BY paymentID DESC ";
$dbPaymentBacktaxTD->query($sqlPaymentBacktaxTD);
if ($dbPaymentBacktaxTD->nf() > 0) {
while ($dbPaymentBacktaxTD->next_record()) {
// gather Collections for Payment
$sqlCollection = "SELECT * " . "FROM Collection " . "WHERE paymentID='" . $dbPaymentBacktaxTD->f("paymentID") . "' " . "AND Collection.status!='cancelled' " . "ORDER BY collectionID DESC ";
$dbCollection->query($sqlCollection);
if ($dbCollection->nf() > 0) {
while ($dbCollection->next_record()) {
switch ($dbCollection->f("taxType")) {
case "basic":
// paidBasic
$paidBasic = 0;
if ($dbCollection->f("amnesty") != "true") {
$paidBasic = $dbCollection->f("amountPaid") - $dbCollection->f("penalty");
// penalty, basicDel and totalDel
if ($dbCollection->f("penalty") > 0) {
$pageRecord["yearDel"] = $year;
// basicDel
$basicDel = 0;
$basicDel = $dbCollection->f("taxDue");
// penalty
$penalty = 0;
$penalty = $dbCollection->f("penalty");
// totalDel
$totalDel = $basicDel + $penalty;
$pageRecord["basicDel"] += $basicDel;
$pageRecord["penalty"] += $penalty;
$pageRecord["totalDel"] += $totalDel;
// totalAmount
$pageRecord["totalAmount"] += $penalty;
}
}
$paidBasic = $paidBasic + ($dbCollection->f("earlyPaymentDiscount") + $dbCollection->f("advancedPaymentDiscount"));
// discount
$discount = $dbCollection->f("earlyPaymentDiscount") + $dbCollection->f("advancedPaymentDiscount");
// basicSef
$basicSef = $paidBasic - $discount;
$pageRecord["paidBasic"] += $paidBasic;
$pageRecord["discount"] += $discount;
$pageRecord["basicSef"] += $basicSef;
// totalAmount
$pageRecord["totalAmount"] += $basicSef;
break;
case "sef":
// paidSef
$paidSef = 0;
if ($dbCollection->f("amnesty") != "true") {
$paidSef = $dbCollection->f("amountPaid") - $dbCollection->f("penalty");
// penalty, sefDel and totalDel
if ($dbCollection->f("penalty") > 0) {
$pageRecord["yearDel"] = $year;
// sefDel
$sefDel = 0;
$sefDel = $dbCollection->f("taxDue");
// penalty
$penalty = 0;
$penalty = $dbCollection->f("penalty");
// totalDel
$totalDel = $sefDel + $penalty;
$pageRecord["sefDel"] += $sefDel;
$pageRecord["penalty"] += $penalty;
$pageRecord["totalDel"] += $totalDel;
// totalAmount
$pageRecord["totalAmount"] += $penalty;
}
}
$paidSef = $paidSef + ($dbCollection->f("earlyPaymentDiscount") + $dbCollection->f("advancedPaymentDiscount"));
// discount
$discount = $dbCollection->f("earlyPaymentDiscount") + $dbCollection->f("advancedPaymentDiscount");
// basicSef
$basicSef = $paidSef - $discount;
$pageRecord["paidSef"] += $paidSef;
$pageRecord["discount"] += $discount;
$pageRecord["basicSef"] += $basicSef;
// totalAmount
$pageRecord["totalAmount"] += $basicSef;
break;
}
}
}
}
}
// ------- start of BacktaxTD condition ------------------------- //
} else {
if ($dbPayment->f("tdID") != 0) {
// ------- start of TD condition ------------------------- //
// gather TD details
$sqlTD = "SELECT AFS.propertyIndexNumber as propertyIndexNumber, " . "TD.taxDeclarationNumber as taxDeclarationNumber " . "FROM TD, AFS " . "WHERE " . "TD.afsID = AFS.afsID " . "AND TD.tdID='" . $dbPayment->f("tdID") . "' " . "AND TD.archive!='true' " . "AND AFS.archive!='true' ";
$dbTD->query($sqlTD);
if ($dbTD->next_record()) {
$pageRecord["propertyIndexNumber"] = $dbTD->f("propertyIndexNumber");
$pageRecord["tdNumber"] = $dbTD->f("taxDeclarationNumber");
}
// gather dueDate Year from Due
$sqlDue = "SELECT YEAR(dueDate) as year " . "FROM Due " . "WHERE tdID='" . $dbPayment->f("tdID") . "' " . "AND dueType='Annual' ";
$dbDue->query($sqlDue);
if ($dbDue->next_record()) {
$year = $dbDue->f("year");
}
// gather Payments for TD for this year
$sqlPaymentTD = "SELECT * " . "FROM Payment WHERE " . "tdID='" . $dbPayment->f("tdID") . "' " . "AND YEAR(paymentDate) LIKE '" . $this->formArray["year"] . "' " . "AND status!='cancelled' " . "ORDER BY paymentID DESC ";
$dbPaymentTD->query($sqlPaymentTD);
if ($dbPaymentTD->nf() > 0) {
while ($dbPaymentTD->next_record()) {
// gather Collections for Payment
$sqlCollection = "SELECT * " . "FROM Collection " . "WHERE paymentID='" . $dbPaymentTD->f("paymentID") . "' " . "AND Collection.status!='cancelled' " . "ORDER BY collectionID DESC ";
$dbCollection->query($sqlCollection);
if ($dbCollection->nf() > 0) {
while ($dbCollection->next_record()) {
switch ($dbCollection->f("taxType")) {
case "basic":
// paidBasic
$paidBasic = 0;
if ($dbCollection->f("amnesty") != "true") {
$paidBasic = $dbCollection->f("amountPaid") - $dbCollection->f("penalty");
// penalty, basicDel and totalDel
if ($dbCollection->f("penalty") > 0) {
$pageRecord["yearDel"] = $year;
// basicDel
$basicDel = 0;
$basicDel = $dbCollection->f("taxDue");
// penalty
$penalty = 0;
$penalty = $dbCollection->f("penalty");
// totalDel
$totalDel = $basicDel + $penalty;
$pageRecord["basicDel"] += $basicDel;
$pageRecord["penalty"] += $penalty;
$pageRecord["totalDel"] += $totalDel;
// totalAmount
$pageRecord["totalAmount"] += $penalty;
}
}
$paidBasic = $paidBasic + ($dbCollection->f("earlyPaymentDiscount") + $dbCollection->f("advancedPaymentDiscount"));
// discount
$discount = $dbCollection->f("earlyPaymentDiscount") + $dbCollection->f("advancedPaymentDiscount");
// basicSef
$basicSef = $paidBasic - $discount;
$pageRecord["paidBasic"] += $paidBasic;
$pageRecord["discount"] += $discount;
$pageRecord["basicSef"] += $basicSef;
// totalAmount
$pageRecord["totalAmount"] += $basicSef;
break;
case "sef":
// paidSef
$paidSef = 0;
if ($dbCollection->f("amnesty") != "true") {
$paidSef = $dbCollection->f("amountPaid") - $dbCollection->f("penalty");
// penalty, sefDel and totalDel
if ($dbCollection->f("penalty") > 0) {
$pageRecord["yearDel"] = $year;
// sefDel
$sefDel = 0;
$sefDel = $dbCollection->f("taxDue");
// penalty
$penalty = 0;
$penalty = $dbCollection->f("penalty");
// totalDel
$totalDel = $sefDel + $penalty;
$pageRecord["sefDel"] += $sefDel;
$pageRecord["penalty"] += $penalty;
$pageRecord["totalDel"] += $totalDel;
// totalAmount
$pageRecord["totalAmount"] += $penalty;
}
}
$paidSef = $paidSef + ($dbCollection->f("earlyPaymentDiscount") + $dbCollection->f("advancedPaymentDiscount"));
// discount
$discount = $dbCollection->f("earlyPaymentDiscount") + $dbCollection->f("advancedPaymentDiscount");
// basicSef
$basicSef = $paidSef - $discount;
$pageRecord["paidSef"] += $paidSef;
$pageRecord["discount"] += $discount;
$pageRecord["basicSef"] += $basicSef;
// totalAmount
$pageRecord["totalAmount"] += $basicSef;
break;
}
}
}
}
}
// ------- end of TD condition ------------------------- //
}
}
$pageRecordArrayList[] = $pageRecord;
unset($pageRecord);
}
if (is_array($pageRecordArrayList)) {
$ypos = 426;
$decrementYposBy = 12;
$linesPerPage = 24;
$count = count($pageRecordArrayList);
$numOfPages = ceil($count / $linesPerPage);
$pageCtr = 1;
$lineCtr = 1;
$recordCtr = 1;
$this->tpl->set_var("year", $this->formArray["year"]);
$this->tpl->set_var("numOfPages", $numOfPages);
$this->tpl->set_block("rptsTemplate", "Page", "PageBlock");
$this->tpl->set_block("Page", "Row", "RowBlock");
$this->tpl->set_block("Page", "Totals", "TotalsBlock");
$totalsArray = array("totalPaidBasic" => 0, "totalPaidSef" => 0, "totalDiscount" => 0, "totalBasicSef" => 0, "totalBasicDel" => 0, "totalSefDel" => 0, "totalPenalty" => 0, "totalTotalDel" => 0, "totalTotalAmount" => 0);
foreach ($pageRecordArrayList as $recordArray) {
$this->tpl->set_var("ypos", $ypos);
$this->tpl->set_var("recordCtr", $recordCtr);
// write values
$totalsArray["totalPaidBasic"] += un_number_format($recordArray["paidBasic"]);
$totalsArray["totalPaidSef"] += un_number_format($recordArray["paidSef"]);
$totalsArray["totalDiscount"] += un_number_format($recordArray["discount"]);
$totalsArray["totalBasicSef"] += un_number_format($recordArray["basicSef"]);
$totalsArray["totalBasicDel"] += un_number_format($recordArray["basicDel"]);
$totalsArray["totalSefDel"] += un_number_format($recordArray["sefDel"]);
$totalsArray["totalPenalty"] += un_number_format($recordArray["penalty"]);
$totalsArray["totalTotalDel"] += un_number_format($recordArray["totalDel"]);
$totalsArray["totalTotalAmount"] += un_number_format($recordArray["totalAmount"]);
foreach ($recordArray as $key => $value) {
switch ($key) {
case "paidBasic":
case "paidSef":
case "discount":
case "basicSef":
case "basicDel":
case "sefDel":
case "penalty":
case "totalDel":
case "totalAmount":
$value = formatCurrency($value);
break;
}
$this->tpl->set_var($key, $value);
}
$this->tpl->parse("RowBlock", "Row", true);
if ($recordCtr == count($pageRecordArrayList) || $lineCtr == $linesPerPage) {
if ($pageCtr == $numOfPages) {
foreach ($totalsArray as $key => $value) {
$value = formatCurrency($value);
$this->tpl->set_var($key, $value);
}
$this->tpl->parse("TotalsBlock", "Totals", true);
} else {
$this->tpl->set_var("TotalsBlock", "");
}
$this->tpl->set_var("page", $pageCtr);
$this->tpl->parse("PageBlock", "Page", true);
$this->tpl->set_var("RowBlock", "");
$this->tpl->set_var("TotalsBlock", "");
$ypos = 426;
$lineCtr = 0;
$pageCtr++;
}
$lineCtr++;
$recordCtr++;
$ypos = $ypos - $decrementYposBy;
}
$this->tpl->parse("templatePage", "rptsTemplate");
$this->tpl->finish("templatePage");
} else {
exit("no collections to list for " . $this->formArray["year"]);
}
} else {
exit("no collections to list for " . $this->formArray["year"]);
}
$this->tpl->parse("templatePage", "rptsTemplate");
$this->tpl->finish("templatePage");
$testpdf = new PDFWriter();
$testpdf->setOutputXML($this->tpl->get("templatePage"), "test");
if (isset($this->formArray["print"])) {
$testpdf->writePDF($name);
//,$this->formArray["print"]);
} else {
$testpdf->writePDF($name);
}
}
function displayBacktaxTD($tdID)
{
$BacktaxTDDetails = new SoapObject(NCCBIZ . "BacktaxTDDetails.php", "urn:Object");
$PaymentList = new SoapObject(NCCBIZ . "PaymentList.php", "urn:Object");
$CollectionList = new SoapObject(NCCBIZ . "CollectionList.php", "urn:Object");
if (!($xmlStr = $BacktaxTDDetails->getBacktaxTDList($tdID))) {
$this->tpl->set_block("TDList", "BacktaxesTable", "BacktaxesTableBlock");
$this->tpl->set_var("BacktaxesTableBlock", "no backtaxes");
$this->tpl->set_var("BacktaxesListBlock", "");
$this->tpl->set_var("JSBacktaxesListBlock", "");
} else {
//echo $xmlStr;
if (!($domDoc = domxml_open_mem($xmlStr))) {
$this->tpl->set_block("TDList", "BacktaxesTable", "BacktaxesTableBlock");
$this->tpl->set_var("BacktaxesTableBlock", "no backtaxes");
$this->tpl->set_var("BacktaxesListBlock", "");
$this->tpl->set_var("JSBacktaxesListBlock", "");
} else {
$backtaxTDRecords = new BacktaxTDRecords();
$backtaxTDRecords->parseDomDocument($domDoc);
$backTaxTDList = $backtaxTDRecords->getArrayList();
//$this->tpl->set_block("TDList", "BacktaxesList", "BacktaxesListBlock");
//$this->tpl->set_block("rptsTemplate", "BacktaxesDBEmpty", "BacktaxesDBEmptyBlock");
if (count($backTaxTDList)) {
//$this->tpl->set_var("BacktaxesDBEmptyBlock", "");
foreach ($backTaxTDList as $key => $val) {
// get paymentHistory
$defaultDueType = "Annual";
$allowableDueTypesArray = array("Annual", "Q1", "Q2", "Q3", "Q4");
/* alxjvr 2006.03.22
if(!$paymentHistory = $this->getPaymentHistory("",$val->getBacktaxTDID())){
$defaultDueType = "Annual";
$allowableDueTypesArray = array("Annual","Q1");
}
else{
$defaultDueType = $paymentHistory->arrayList[0]->getDueType();
if($defaultDueType=="Annual"){
$allowableDueTypesArray = array("Annual");
}
else{
switch($defaultDueType){
case "Q1":
$allowableDueTypesArray = array("Q1", "Q2");
break;
case "Q2":
$allowableDueTypesArray = array("Q2", "Q3");
break;
case "Q3":
$allowableDueTypesArray = array("Q3", "Q4");
break;
case "Q4":
$allowableDueTypesArray = array("Q4");
break;
}
}
}
*/
// check Paid values from Payments and increment to paid value in BacktaxTD
$condition = " WHERE status='' ";
$condition .= " AND backtaxTDID = '" . $val->getBacktaxTDID() . "'";
$condition .= " ORDER BY paymentDate DESC, paymentID DESC ";
if (!($xmlStr = $PaymentList->getPaymentList($condition))) {
// error xmlStr. do nothing
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
// error domDoc. do nothing
} else {
$paymentRecords = new PaymentRecords();
$paymentRecords->parseDomDocument($domDoc);
$paymentArrayList = $paymentRecords->getArrayList();
$collectionCondition = "WHERE status='' AND (";
$paymentCount = 0;
foreach ($paymentArrayList as $payment) {
if ($paymentCount > 0) {
$collectionCondition .= " OR";
} else {
$lastPaymentDate = $payment->getPaymentDate();
$lastPaymentDueType = $payment->getDueType();
$amnestyStatus = $payment->getAmnesty();
}
$collectionCondition .= " paymentID = '" . $payment->getPaymentID() . "' ";
$paymentCount++;
}
$collectionCondition .= ") ";
if (!($xmlStr = $CollectionList->getCollectionList($collectionCondition))) {
// error xmlStr
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
// error domDoc
} else {
$collectionRecords = new CollectionRecords();
$collectionRecords->parseDomDocument($domDoc);
$collectionArrayList = $collectionRecords->getArrayList();
$totalPaid = 0;
foreach ($collectionArrayList as $collection) {
$totalPaid += $collection->getAmountPaid();
}
$totalPaid += $val->getPaid();
// to avoid -0.01, 0.01 balances
if ($totalPaid != $payment->getAmountPaid()) {
$totalPaid = $payment->getAmountPaid();
}
$val->setPaid($totalPaid);
}
}
}
}
if ($amnestyStatus == "true") {
$this->tpl->set_var("btAmnesty_status", "checked");
} else {
$this->tpl->set_var("btAmnesty_status", "");
}
// calculate Penalties verses either today or verses the last paymentDate
$treasurySettings = $this->getTreasurySettings();
$btDueDate = date("M. d, Y", strtotime($val->getStartYear() . "-" . $treasurySettings->getAnnualDueDate()));
if ($lastPaymentDate != "") {
$val->calculatePenalty($lastPaymentDate);
// if balance is 0 leave penalty as is, otherwise calculatePenalty according to date now
$balanceB = $val->getTotalTaxDue();
$penaltyLUTArray = $this->getPenaltyLUTArray();
switch ($lastPaymentDueType) {
case "Q1":
$btDueDate = date("M. d, Y", strtotime($val->getStartYear() . "-03-31"));
$btBasicTax = roundUpNearestFiveCent($val->getBasicTax() / 4);
$btSefTax = roundUpNearestFiveCent($val->getSEFTax() / 4);
$btIdleTax = roundUpNearestFiveCent($val->getIdleTax() / 4);
$btTaxDue = $btBasicTax + $btSefTax + $btIdleTax;
$btPenalty = $this->btCalculateQuarterlyPenalty($lastPaymentDate, $btTaxDue, $lastPaymentDueType, $btDueDate);
$balanceB = $btTaxDue + $btPenalty - $totalPaid;
break;
case "Q2":
$btDueDate = date("M. d, Y", strtotime($val->getStartYear() . "-06-30"));
$btBasicTax = roundUpNearestFiveCent($val->getBasicTax() / 4);
$btSefTax = roundUpNearestFiveCent($val->getSEFTax() / 4);
$btIdleTax = roundUpNearestFiveCent($val->getIdleTax() / 4);
$btTaxDue = $btBasicTax + $btSefTax + $btIdleTax;
$btPenalty = $this->btCalculateQuarterlyPenalty($lastPaymentDate, $btTaxDue, $lastPaymentDueType, $btDueDate);
$balanceB = $btTaxDue + $btPenalty - $totalPaid;
break;
case "Q3":
$btDueDate = date("M. d, Y", strtotime($val->getStartYear() . "-09-30"));
$btBasicTax = roundUpNearestFiveCent($val->getBasicTax() / 4);
$btSefTax = roundUpNearestFiveCent($val->getSEFTax() / 4);
$btIdleTax = roundUpNearestFiveCent($val->getIdleTax() / 4);
$btTaxDue = $btBasicTax + $btSefTax + $btIdleTax;
$btPenalty = $this->btCalculateQuarterlyPenalty($lastPaymentDate, $btTaxDue, $lastPaymentDueType, $btDueDate);
$balanceB = $btTaxDue + $btPenalty - $totalPaid;
break;
case "Q4":
$btDueDate = date("M. d, Y", strtotime($val->getStartYear() . "-12-31"));
$btBasicTax = roundUpNearestFiveCent($val->getBasicTax() / 4);
$btSefTax = roundUpNearestFiveCent($val->getSEFTax() / 4);
$btIdleTax = roundUpNearestFiveCent($val->getIdleTax() / 4);
$btTaxDue = $btBasicTax + $btSefTax + $btIdleTax;
$btPenalty = $this->btCalculateQuarterlyPenalty($lastPaymentDate, $btTaxDue, $lastPaymentDueType, $btDueDate);
$balanceB = $btTaxDue + $btPenalty - $totalPaid;
break;
}
$penaltyComputeDate = $lastPaymentDate;
// 0.1 is used instead of 0 because sometimes rounded off balances intended to be 0 end up appearing as 0.002 or so...
if (round($balanceB, 4) > 0.1) {
$val->calculatePenalty($this->now);
$penaltyComputeDate = $this->now;
$btBasicTax = $val->getBasicTax();
$btSefTax = $val->getSEFTax();
$btIdleTax = $val->getIdleTax();
$btTaxDue = $val->getBasicTax + $val->getSEFTax() + $val->getIdleTax();
$btPenalty = $val->getPenalties();
$btDueDate = date("M. d, Y", strtotime($val->getStartYear() . "-" . $treasurySettings->getAnnualDueDate()));
}
} else {
$val->calculatePenalty($this->now);
$penaltyComputeDate = $this->now;
$btBasicTax = $val->getBasicTax();
$btSefTax = $val->getSEFTax();
$btIdleTax = $val->getIdleTax();
$btTaxDue = $val->getBasicTax + $val->getSEFTax() + $val->getIdleTax();
$btPenalty = $val->getPenalties();
$btDueDate = date("M. d, Y", strtotime($val->getStartYear() . "-" . $treasurySettings->getAnnualDueDate()));
}
// if Backtax Penalties is greater than 0, allow only "Annual" payments
$defaultDueType = "Annual";
$allowableDueTypesArray = array("Annual", "Q1", "Q2", "Q3", "Q4");
/* alxjvr 2006.03.22
if($btPenalty>0){
$defaultDueType = "Annual";
$allowableDueTypesArray = array("Annual");
}
*/
foreach ($allowableDueTypesArray as $allowableDueType) {
$this->tpl->set_var("backtaxAllowableDueType", $allowableDueType);
$this->tpl->parse("BacktaxDueTypeListBlock", "BacktaxDueTypeList", true);
}
$this->tpl->set_var("backtaxTDID", $val->getBacktaxTDID());
$this->tpl->set_var("tdNumberB", $val->getTdNumber());
$this->tpl->set_var("startYearB", $val->getStartYear());
$this->tpl->set_var("endYearB", $val->getEndYear());
$this->tpl->set_var("startQuarterB", $val->getStartQuarter());
$this->tpl->set_var("assessedValueB", number_format($val->getAssessedValue(), 2));
$this->tpl->set_var("basicRateB", number_format($val->getBasicRate(), 2));
$this->tpl->set_var("sefRateB", number_format($val->getSEFRate(), 2));
$this->tpl->set_var("basicTaxB", number_format($val->getBasicTax(), 2));
$this->tpl->set_var("sefTaxB", number_format($val->getSEFTax(), 2));
$this->tpl->set_var("idleTaxB", number_format($val->getIdleTax(), 2));
$this->tpl->set_var("penaltiesB", number_format($val->getPenalties(), 2));
$this->tpl->set_var("paidB", number_format($val->getPaid(), 2));
$this->tpl->set_var("balanceB", number_format($val->getTotalTaxDue(), 2));
$this->tpl->set_var("totalTaxDueB", number_format($val->getTotal(), 2));
$btDueTypeArray = array(1 => "Q1", 2 => "Q2", 3 => "Q3", 4 => "Q4");
// set default backtax values based on latest payments
$this->tpl->set_var("btDueDate", $btDueDate);
$this->tpl->set_var("btBasicTax", formatCurrency($btBasicTax));
$this->tpl->set_var("btSefTax", formatCurrency($btSefTax));
$this->tpl->set_var("btIdleTax", formatCurrency($btIdleTax));
$this->tpl->set_var("btTaxDue", formatCurrency($btTaxDue));
$this->tpl->set_var("btAdvancedPaymentDiscount", formatCurrency(0));
$this->tpl->set_var("btEarlyPaymentDiscount", formatCurrency(0));
$this->tpl->set_var("btPenalty", formatCurrency($btPenalty));
$this->tpl->set_var("btTotalPaid", formatCurrency($val->getPaid()));
$btBalance = $val->getTotalTaxDue();
if ($btBalance < 0) {
$btBalance = 0;
} else {
if ($btBalance == "-0") {
$btBalance = 0;
}
}
$this->tpl->set_var("btBalance", formatCurrency($btBalance));
$this->tpl->set_var("btDueID[Annual]", $this->getDueIDFromBacktaxTDID($val->getBacktaxTDID(), "Annual"));
$this->tpl->set_var("btDueID[Q1]", $this->getDueIDFromBacktaxTDID($val->getBacktaxTDID(), "Q1"));
$this->tpl->set_var("btDueID[Q2]", $this->getDueIDFromBacktaxTDID($val->getBacktaxTDID(), "Q2"));
$this->tpl->set_var("btDueID[Q3]", $this->getDueIDFromBacktaxTDID($val->getBacktaxTDID(), "Q3"));
$this->tpl->set_var("btDueID[Q4]", $this->getDueIDFromBacktaxTDID($val->getBacktaxTDID(), "Q4"));
$this->tpl->set_var("btDueDate[Annual]", date("M. d, Y", strtotime($val->getStartYear() . "-" . $treasurySettings->getAnnualDueDate())));
$this->tpl->set_var("btDueDate[Q1]", date("M. d, Y", strtotime($val->getStartYear() . "-03-31")));
$this->tpl->set_var("btDueDate[Q2]", date("M. d, Y", strtotime($val->getStartYear() . "-06-30")));
$this->tpl->set_var("btDueDate[Q3]", date("M. d, Y", strtotime($val->getStartYear() . "-09-30")));
$this->tpl->set_var("btDueDate[Q4]", date("M. d, Y", strtotime($val->getStartYear() . "-12-31")));
$this->tpl->set_var("btBasicTax[Annual]", formatCurrency($val->getBasicTax()));
$this->tpl->set_var("btBasicTax[Q1]", roundUpNearestFiveCent($val->getBasicTax() / 4));
$this->tpl->set_var("btBasicTax[Q2]", roundUpNearestFiveCent(un_number_format($val->getBasicTax() / 4)));
$this->tpl->set_var("btBasicTax[Q3]", roundUpNearestFiveCent(un_number_format($val->getBasicTax() / 4)));
$this->tpl->set_var("btBasicTax[Q4]", roundUpNearestFiveCent(un_number_format($val->getBasicTax() / 4)));
$this->tpl->set_var("btSefTax[Annual]", formatCurrency($val->getSEFTax()));
$this->tpl->set_var("btSefTax[Q1]", roundUpNearestFiveCent(un_number_format($val->getSEFTax() / 4)));
$this->tpl->set_var("btSefTax[Q2]", roundUpNearestFiveCent(un_number_format($val->getSEFTax() / 4)));
$this->tpl->set_var("btSefTax[Q3]", roundUpNearestFiveCent(un_number_format($val->getSEFTax() / 4)));
$this->tpl->set_var("btSefTax[Q4]", roundUpNearestFiveCent(un_number_format($val->getSEFTax() / 4)));
$this->tpl->set_var("btIdleTax[Annual]", formatCurrency($val->getIdleTax()));
$this->tpl->set_var("btIdleTax[Q1]", roundUpNearestFiveCent(un_number_format($val->getIdleTax() / 4)));
$this->tpl->set_var("btIdleTax[Q2]", roundUpNearestFiveCent(un_number_format($val->getIdleTax() / 4)));
$this->tpl->set_var("btIdleTax[Q3]", roundUpNearestFiveCent(un_number_format($val->getIdleTax() / 4)));
$this->tpl->set_var("btIdleTax[Q4]", roundUpNearestFiveCent(un_number_format($val->getIdleTax() / 4)));
$this->tpl->set_var("btTaxDue[Annual]", formatCurrency($val->getBasicTax() + $val->getSEFTax() + $val->getIdleTax()));
$this->tpl->set_var("btTaxDue[Q1]", formatCurrency(un_number_format($this->tpl->get_var("btBasicTax[Q1]")) + un_number_format($this->tpl->get_var("btSefTax[Q1]")) + un_number_format($this->tpl->get_var("btIdleTax[Q1]"))));
$this->tpl->set_var("btTaxDue[Q2]", formatCurrency(un_number_format($this->tpl->get_var("btBasicTax[Q2]")) + un_number_format($this->tpl->get_var("btSefTax[Q2]")) + un_number_format($this->tpl->get_var("btIdleTax[Q2]"))));
$this->tpl->set_var("btTaxDue[Q3]", formatCurrency(un_number_format($this->tpl->get_var("btBasicTax[Q3]")) + un_number_format($this->tpl->get_var("btSefTax[Q3]")) + un_number_format($this->tpl->get_var("btIdleTax[Q3]"))));
$this->tpl->set_var("btTaxDue[Q4]", formatCurrency(un_number_format($this->tpl->get_var("btBasicTax[Q4]")) + un_number_format($this->tpl->get_var("btSefTax[Q4]")) + un_number_format($this->tpl->get_var("btIdleTax[Q4]"))));
$this->tpl->set_var("btAdvancedPaymentDiscount[Annual]", formatCurrency(0));
$this->tpl->set_var("btAdvancedPaymentDiscount[Q1]", formatCurrency(0));
$this->tpl->set_var("btAdvancedPaymentDiscount[Q2]", formatCurrency(0));
$this->tpl->set_var("btAdvancedPaymentDiscount[Q3]", formatCurrency(0));
$this->tpl->set_var("btAdvancedPaymentDiscount[Q4]", formatCurrency(0));
$this->tpl->set_var("btEarlyPaymentDiscount[Annual]", formatCurrency(0));
$this->tpl->set_var("btEarlyPaymentDiscount[Q1]", formatCurrency(0));
$this->tpl->set_var("btEarlyPaymentDiscount[Q2]", formatCurrency(0));
$this->tpl->set_var("btEarlyPaymentDiscount[Q3]", formatCurrency(0));
$this->tpl->set_var("btEarlyPaymentDiscount[Q4]", formatCurrency(0));
$this->tpl->set_var("btPenalty[Annual]", formatCurrency($val->getPenalties()));
// compute quarterly penalties
$penaltyLUTArray = $this->getPenaltyLUTArray();
foreach ($btDueTypeArray as $btDueTypeKey => $btDueType) {
$btPenalty = 0;
if ($lastPaymentDueType != "") {
if ($btDueTypeKey > substr($lastPaymentDueType, 1, 1)) {
$penaltyComputeDate = $this->now;
}
}
if (strtotime($penaltyComputeDate) > strtotime($this->tpl->get_var("btDueDate[" . $btDueType . "]"))) {
$numYears = date("Y", strtotime($penaltyComputeDate)) - date("Y", strtotime($this->tpl->get_var("btDueDate[" . $btDueType . "]")));
$numMonths = date("n", strtotime($penaltyComputeDate)) - date("n", strtotime($this->tpl->get_var("btDueDate[" . $btDueType . "]")));
$totalMonths = $this->btCalculateMonthOverDue(date("Y-m-d", strtotime($penaltyComputeDate)), $this->tpl->get_var("btDueDate[" . $btDueType . "]"), $btDueType);
if ($totalMonths >= count($penaltyLUTArray)) {
$penaltyPercentage = 0.72;
} else {
$penaltyPercentage = $penaltyLUTArray[$totalMonths];
}
$btPenalty = un_number_format($this->tpl->get_var("btTaxDue[" . $btDueType . "]")) * $penaltyPercentage;
}
$this->tpl->set_var("btPenalty[" . $btDueType . "]", formatCurrency($btPenalty));
}
// get totalPaid for backtax
$totalPaid = 0;
if ($paymentHistory = $this->getPaymentHistory("", $val->getBacktaxTDID())) {
$paymentArrayList = $paymentHistory->getArrayList();
foreach ($paymentArrayList as $payment) {
$totalPaid += $payment->getAmountPaid();
}
$this->tpl->set_var("btTotalPaid[Annual]", formatCurrency($totalPaid));
} else {
$this->tpl->set_var("btTotalPaid[Annual]", formatCurrency(0));
}
// get quarterlyPayments for backtax
$totalPaidForQuarter = 0;
foreach ($btDueTypeArray as $btDueType) {
if ($btQuarterPaymentHistory = $this->getBacktaxQuarterPaymentHistory($val->getBacktaxTDID(), $btDueType)) {
$btQuarterPaymentArrayList = $btQuarterPaymentHistory->getArrayList();
foreach ($btQuarterPaymentArrayList as $payment) {
$totalPaidForQuarter += $payment->getAmountPaid();
}
$this->tpl->set_var("btTotalPaid[" . $btDueType . "]", formatCurrency($totalPaidForQuarter));
if ($lastPaymentDueType == $btDueType) {
$this->tpl->set_var("btTotalPaid", formatCurrency($totalPaidForQuarter));
}
$totalPaidForQuarter = 0;
} else {
$this->tpl->set_var("btTotalPaid[" . $btDueType . "]", formatCurrency(0));
}
}
// set default backtax values based on latest payments
if ($defaultDueType != "Annual") {
$this->tpl->set_var("btBasicTax", $this->tpl->get_var("btBasicTax[" . $defaultDueType . "]"));
$this->tpl->set_var("btSefTax", $this->tpl->get_var("btSefTax[" . $defaultDueType . "]"));
$this->tpl->set_var("btIdleTax", $this->tpl->get_var("btIdleTax[" . $defaultDueType . "]"));
$this->tpl->set_var("btTaxDue", $this->tpl->get_var("btTaxDue[" . $defaultDueType . "]"));
$this->tpl->set_var("btAdvancedPaymentDiscount", formatCurrency(0));
$this->tpl->set_var("btEarlyPaymentDiscount", formatCurrency(0));
$this->tpl->set_var("btPenalty", $this->tpl->get_var("btPenalty[" . $defaultDueType . "]"));
$this->tpl->set_var("btTotalPaid", $this->tpl->get_var("btTotalPaid[" . $defaultDueType . "]"));
$btBalance = un_number_format($this->tpl->get_var("btTaxDue"));
if ($this->tpl->get_var("btAdvancedPaymentDiscount") > 0) {
$btBalance = un_number_format($this->tpl->get_var("btTaxDue")) - un_number_format($this->tpl->get_var("btAdvancedPaymentDiscount"));
} else {
if ($this->tpl->get_var("btEarlyPaymentDiscount") > 0) {
$btBalance = un_number_format($this->tpl->get_var("btTaxDue")) - un_number_format($this->tpl->get_var("btEarlyPaymentDiscount"));
}
}
$btBalance += un_number_format($this->tpl->get_var("btPenalty"));
$btBalance -= un_number_format($this->tpl->get_var("btTotalPaid"));
$this->tpl->set_var("btBalance", formatCurrency($btBalance));
} else {
$this->tpl->set_var("btBasicTax", formatCurrency($val->getBasicTax()));
$this->tpl->set_var("btSefTax", formatCurrency($val->getSEFTax()));
$this->tpl->set_var("btIdleTax", formatCurrency($val->getIdleTax()));
$this->tpl->set_var("btTaxDue", formatCurrency($val->getBasicTax() + $val->getSEFTax() + $val->getIdleTax()));
$this->tpl->set_var("btAdvancedPaymentDiscount", formatCurrency(0));
$this->tpl->set_var("btEarlyPaymentDiscount", formatCurrency(0));
$this->tpl->set_var("btPenalty", formatCurrency($val->getPenalties()));
$this->tpl->set_var("btTotalPaid", formatCurrency($val->getPaid()));
$this->tpl->set_var("btBalance", formatCurrency($val->getTotalTaxDue()));
}
$this->backtaxTDIDArray[] = $val->getBacktaxTDID();
$this->tpl->parse("BacktaxesListBlock", "BacktaxesList", true);
$this->tpl->parse("JSBacktaxesListBlock", "JSBacktaxesList", true);
$this->tpl->set_var("BacktaxDueTypeListBlock", "");
}
} else {
//$this->tpl->set_block("TDList", "Backtax", "BacktaxBlock");
//$this->tpl->set_var("BacktaxBlock", "");
}
}
}
}
function Main()
{
switch ($this->formArray["formAction"]) {
case "save":
$DueEncode = new SoapObject(NCCBIZ . "DueEncode.php", "urn:Object");
if ($this->formArray["dueID"] != "") {
$DueDetails = new SoapObject(NCCBIZ . "DueDetails.php", "urn:Object");
if (!($xmlStr = $DueDetails->getDue($this->formArray["dueID"]))) {
$this->tpl->set_block("rptsTemplate", "Table", "TableBlock");
$this->tpl->set_var("TableBlock", "record not found");
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
$this->tpl->set_block("rptsTemplate", "Table", "TableBlock");
$this->tpl->set_var("TableBlock", "error xmlDoc");
} else {
$dueArray = $this->setDues();
foreach ($dueArray as $due) {
$doc = $due->getDomDocument();
$xmlStr = $doc->dump_mem(true);
if (!($ret = $DueEncode->updateDue($xmlStr))) {
exit("error update");
}
unset($doc);
unset($xmlStr);
}
}
}
} else {
$dueArray = $this->setDues();
foreach ($dueArray as $due) {
$doc = $due->getDomDocument();
$xmlStr = $doc->dump_mem(true);
if (!($ret = $DueEncode->saveDue($xmlStr))) {
exit("error saving");
}
unset($doc);
unset($xmlStr);
}
}
$this->formArray["dueID"] = $ret;
header("location: DueClose.php" . $this->sess->url("") . $this->sess->add_query(array("rptopID" => $this->formArray["rptopID"])));
exit($ret);
break;
default:
// grab current tax rates from TreasurySettings
$treasurySettings = new TreasurySettings();
$treasurySettings->selectRecord();
$this->formArray["masterBasicTaxRate"] = $treasurySettings->getPctRPTax();
$this->formArray["masterSEFTaxRate"] = $treasurySettings->getPctSEF();
$this->formArray["masterIdleTaxRate"] = $treasurySettings->getPctIdle();
$this->formArray["discountPeriod"] = $treasurySettings->getDiscountPeriod();
$TDDetails = new SoapObject(NCCBIZ . "TDDetails.php", "urn:Object");
if (!($xmlStr = $TDDetails->getTD($this->formArray["tdID"]))) {
// xml failed
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
// domDoc empty
} else {
$td = new TD();
$td->parseDomDocument($domDoc);
$this->formArray["afsID"] = $td->getAfsID();
$this->formArray["taxDeclarationNumber"] = $td->getTaxDeclarationNumber();
$this->formArray["taxBeginsWithTheYear"] = $td->getTaxBeginsWithTheYear();
}
}
unset($xmlStr);
unset($domDoc);
$AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object");
if (!($xmlStr = $AFSDetails->getAFS($this->formArray["afsID"]))) {
// xml failed
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
// domDoc empty
} else {
$afs = new AFS();
$afs->parseDomDocument($domDoc);
$this->formArray["assessedValue"] = $afs->getTotalAssessedValue();
$this->formArray["taxability"] = $afs->getTaxability();
$this->formArray["effectivity"] = $afs->getEffectivity();
$this->formArray["propertyType"] = $td->getPropertyType();
$this->formArray["idle"] = "No";
if ($td->getPropertyType() == "Land") {
if (is_array($afs->landArray)) {
// if land is stripped
if (count($afs->landArray) > 1) {
foreach ($afs->landArray as $land) {
if ($land->getIdle() == "Yes") {
$this->formArray["idle"] = "Yes";
break;
}
}
} else {
$this->formArray["idle"] = $afs->landArray[0]->getIdle();
}
}
}
if ($this->formArray["idle"] == "") {
$this->formArray["idle"] = "No";
}
}
}
if ($this->formArray["dueID"] != "") {
$DueDetails = new SoapObject(NCCBIZ . "DueDetails.php", "urn:Object");
if (!($xmlStr = $DueDetails->getDue($this->formArray["dueID"]))) {
echo "xml failed";
} else {
//echo $xmlStr;
if (!($domDoc = domxml_open_mem($xmlStr))) {
echo "error xmlDoc";
} else {
$due = new Due();
$due->parseDomDocument($domDoc);
foreach ($due as $key => $value) {
switch ($key) {
default:
$this->formArray[$key] = $value;
}
}
$this->formArray["dueDate_str"] = date("F d, Y", strtotime($this->formArray["dueDate"]));
$this->formArray["taxDue"] = $due->getTaxDue();
}
}
} else {
// select RPTOP taxable year from rptopID
$RPTOPDetails = new SoapObject(NCCBIZ . "RPTOPDetails.php", "urn:Object");
if (!($xmlStr = $RPTOPDetails->getRPTOP($this->formArray["rptopID"]))) {
exit("xml failed");
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
exit("error domDoc");
} else {
$rptop = new RPTOP();
$rptop->parseDomDocument($domDoc);
$this->formArray["taxableYear"] = $rptop->getTaxableYear();
}
}
// display default Due details
$this->formArray["dueDate"] = date("Y-n-d", strtotime($this->formArray["taxableYear"] . "-" . $treasurySettings->getAnnualDueDate()));
$this->formArray["dueDate_str"] = date("F d, Y", strtotime($this->formArray["dueDate"]));
$this->formArray["basicTaxRate"] = $this->formArray["masterBasicTaxRate"];
$this->formArray["sefTaxRate"] = $this->formArray["masterSEFTaxRate"];
$this->formArray["idleTaxRate"] = $this->formArray["masterIdleTaxRate"];
$this->formArray["basicTax"] = un_number_format($this->formArray["assessedValue"]) * $this->formArray["basicTaxRate"];
$this->formArray["sefTax"] = un_number_format($this->formArray["assessedValue"]) * $this->formArray["sefTaxRate"];
// if land->idle is "Yes", compute idleTax, otherwise set idleTax to zero
if ($this->formArray["propertyType"] == "Land") {
if ($this->formArray["idle"] == "Yes") {
$this->formArray["idleTax"] = un_number_format($this->formArray["assessedValue"]) * $this->formArray["idleTaxRate"];
} else {
$this->formArray["idleTax"] = "0.00";
}
}
// if afs->taxability is "Exempt", reset computations to zero.
if ($this->formArray["taxability"] == "Exempt") {
$this->formArray["basicTax"] = 0.0;
$this->formArray["sefTax"] = 0.0;
$this->formArray["idleTax"] = 0.0;
}
$this->formArray["taxDue"] = $this->formArray["basicTax"] + $this->formArray["sefTax"] + $this->formArray["idleTax"];
}
}
$this->setForm();
$this->tpl->set_var("Session", $this->sess->url("") . $this->sess->add_query(array("dueID" => $this->formArray["dueID"], "tdID" => $this->formArray["tdID"], "rptopID" => $this->formArray["rptopID"])));
$this->tpl->parse("templatePage", "rptsTemplate");
$this->tpl->finish("templatePage");
$this->tpl->p("templatePage");
}
function Main()
{
$eRPTSSettings = new eRPTSSettings();
if ($eRPTSSettings->selectRecord(1)) {
$this->tpl->set_var("lguType", strtoupper($eRPTSSettings->getLguType()));
$this->tpl->set_var("lguName", strtoupper($eRPTSSettings->getLguName()));
}
$dbTD = new DB_RPTS();
$dbBacktaxTD = new DB_RPTS();
$dbPaymentBacktaxTD = new DB_RPTS();
$dbPaymentTD = new DB_RPTS();
$dbCollectionBacktaxTD = new DB_RPTS();
$dbCollectionTD = new DB_RPTS();
$dbDue = new DB_RPTS();
// gather TD's
$sql = "SELECT Due.dueID as dueID, " . "Due.tdID as tdID, " . "Due.dueType as dueType, " . "Due.dueDate as dueDate, " . "Due.basicTax as basicTax, " . "Due.basicTaxRate as basicTaxRate, " . "Due.sefTax as sefTax, " . "Due.sefTaxRate as sefTaxRate, " . "Due.idleTax as idleTax, " . "Due.idleTaxRate as idleTaxRate, " . "TD.afsID as afsID, " . "TD.propertyType as propertyType, " . "TD.taxDeclarationNumber as taxDeclarationNumber, " . "AFS.odID as odID, " . "AFS.arpNumber as arpNumber, " . "AFS.propertyIndexNumber as propertyIndexNumber, " . "AFS.taxability as taxability, " . "AFS.effectivity as effectivity, " . "AFS.totalMarketValue as totalMarketValue, " . "AFS.totalAssessedValue as totalAssessedValue " . "FROM Due, TD, AFS " . "WHERE Due.tdID = TD.tdID " . "AND TD.afsID = AFS.afsID " . "AND AFS.archive != 'true' " . "AND TD.archive != 'true' " . "AND Due.dueType = 'Annual' " . "AND TD.propertyType LIKE '" . $this->formArray["classification"] . "' " . "GROUP BY Due.tdID, YEAR(Due.dueDate) " . "ORDER BY Due.dueDate DESC";
$dbTD->query($sql);
if ($dbTD->nf() > 0) {
// gather BacktaxTD's
while ($dbTD->next_record()) {
$sqlBacktaxTD = "SELECT backtaxTDID, " . "tdID, " . "tdNumber, " . "startYear, " . "endYear, " . "startQuarter, " . "assessedValue, " . "basicRate, " . "sefRate, " . "basicTax, " . "sefTax, " . "idleTax, " . "penalties, " . "paid, " . "balance, " . "total " . "FROM BacktaxTD " . "WHERE tdID='" . $dbTD->f("tdID") . "' " . "ORDER BY startYear ASC ";
$dbBacktaxTD->query($sqlBacktaxTD);
if ($dbBacktaxTD->nf() > 0) {
while ($dbBacktaxTD->next_record()) {
$backtaxTDRecordArray[] = $dbBacktaxTD->Record;
}
}
$tdRecordArray[] = array("td" => $dbTD->Record, "backtaxTD" => $backtaxTDRecordArray);
unset($backtaxTDRecordArray);
}
}
if (is_array($tdRecordArray)) {
foreach ($tdRecordArray as $recordArray) {
// gather backtaxTD details
if (is_array($recordArray["backtaxTD"])) {
foreach ($recordArray["backtaxTD"] as $backtaxTDRecord) {
$paidBasic = 0;
$paidSEF = 0;
$paidPenalty = 0;
$totalTaxCollected = 0;
$basic = 0;
$sef = 0;
$penalty = 0;
$totalCollectible = 0;
// get totalTaxCollected
$sqlPaymentBacktaxTD = "SELECT paymentID, " . "dueType, " . "backtaxTDID, " . "taxDue, " . "earlyPaymentDiscount, " . "advancedPaymentDiscount, " . "penalty, " . "amnesty, " . "balanceDue, " . "amountPaid, " . "dueDate, " . "paymentDate " . "FROM Payment " . "WHERE backtaxTDID='" . $backtaxTDRecord["backtaxTDID"] . "' " . "AND status!='cancelled'";
$dbPaymentBacktaxTD->query($sqlPaymentBacktaxTD);
if ($dbPaymentBacktaxTD->nf() > 0) {
while ($dbPaymentBacktaxTD->next_record()) {
$sqlCollectionBacktaxTD = "SELECT * " . "FROM Collection " . "WHERE paymentID='" . $dbPaymentBacktaxTD->f("paymentID") . "' " . "AND status!='cancelled' ";
$dbCollectionBacktaxTD->query($sqlCollectionBacktaxTD);
if ($dbCollectionBacktaxTD->nf() > 0) {
while ($dbCollectionBacktaxTD->next_record()) {
switch ($dbCollectionBacktaxTD->f("taxType")) {
case "basic":
if ($dbCollectionBacktaxTD->f("amnesty") != "true") {
$paidBasic += $dbCollectionBacktaxTD->f("amountPaid") - $dbCollectionBacktaxTD->f("penalty");
$paidPenalty += $dbCollectionBacktaxTD->f("penalty");
$totalTaxCollected += $dbCollectionBacktaxTD->f("amountPaid");
} else {
$paidBasic += $dbCollectionBacktaxTD->f("amountPaid");
$totalTaxCollected += $paidBasic;
}
break;
case "sef":
if ($dbCollectionBacktaxTD->f("amnesty") != "true") {
$paidSEF += $dbCollectionBacktaxTD->f("amountPaid") - $dbCollectionBacktaxTD->f("penalty");
$paidPenalty += $dbCollectionBacktaxTD->f("penalty");
$totalTaxCollected += $dbCollectionBacktaxTD->f("amountPaid");
} else {
$paidSEF += $dbCollectionBacktaxTD->f("amountPaid");
$totalTaxCollected += $paidSEF;
}
break;
}
}
}
}
}
// get totalCollectible
$basic = $backtaxTDRecord["basicTax"];
$sef = $backtaxTDRecord["sefTax"];
$backtaxTD = new BacktaxTD();
$backtaxTD->selectRecord("", $backtaxTDRecord["backtaxTDID"], "");
$backtaxTD->calculatePenalty(date("Y-m-d"));
$penalty = $backtaxTD->getPenalties();
$totalCollectible = $basic + $sef + $penalty;
$lineRecordArray[] = array("propertyIndexNumber" => "TD#:" . $backtaxTDRecord["tdNumber"] . " (" . $backtaxTDRecord["startYear"] . ")", "tdNumber" => $backtaxTDRecord["tdNumber"], "paidBasic" => $paidBasic, "paidSEF" => $paidSEF, "paidPenalty" => $paidPenalty, "totalTaxCollected" => $totalTaxCollected, "basic" => $basic, "sef" => $sef, "penalty" => $penalty, "totalCollectible" => $totalCollectible);
}
}
$paidBasic = 0;
$paidSEF = 0;
$paidPenalty = 0;
$totalTaxCollected = 0;
$basic = 0;
$sef = 0;
$penalty = 0;
$totalCollectible = 0;
// gather TD details
if (is_array($recordArray["td"])) {
$tdRecord = $recordArray["td"];
// get totalTaxCollected
$sqlPaymentTD = "SELECT paymentID, " . "dueType, " . "backtaxTDID, " . "taxDue, " . "earlyPaymentDiscount, " . "advancedPaymentDiscount, " . "penalty, " . "amnesty, " . "balanceDue, " . "amountPaid, " . "dueDate, " . "paymentDate " . "FROM Payment " . "WHERE tdID='" . $tdRecord["tdID"] . "' " . "AND status!='cancelled'";
$dbPaymentTD->query($sqlPaymentTD);
if ($dbPaymentTD->nf() > 0) {
while ($dbPaymentTD->next_record()) {
$sqlCollectionTD = "SELECT * " . "FROM Collection " . "WHERE paymentID='" . $dbPaymentTD->f("paymentID") . "' " . "AND status!='cancelled' ";
$dbCollectionTD->query($sqlCollectionTD);
if ($dbCollectionTD->nf() > 0) {
while ($dbCollectionTD->next_record()) {
switch ($dbCollectionTD->f("taxType")) {
case "basic":
if ($dbCollectionTD->f("amnesty") != "true") {
$paidBasic += $dbCollectionTD->f("amountPaid") - $dbCollectionTD->f("penalty");
$paidPenalty += $dbCollectionTD->f("penalty");
$totalTaxCollected += $dbCollectionTD->f("amountPaid");
} else {
$paidBasic += $dbCollectionTD->f("amountPaid");
$totalTaxCollected += $paidBasic;
}
break;
case "sef":
if ($dbCollectionTD->f("amnesty") != "true") {
$paidSEF += $dbCollectionTD->f("amountPaid") - $dbCollectionTD->f("penalty");
$paidPenalty += $dbCollectionTD->f("penalty");
$totalTaxCollected += $dbCollectionTD->f("amountPaid");
} else {
$paidSEF += $dbCollectionTD->f("amountPaid");
$totalTaxCollected += $paidSEF;
}
break;
}
}
}
}
}
// get totalCollectible
$due = new Due();
if ($due->selectRecord($tdRecord["dueID"])) {
$basic = $due->getBasicTax();
$sef = $due->getSefTax();
$due = $this->computePenalty(date("Y-m-d"), $due);
$penalty = $due->getPenalty();
$totalCollectible = $basic + $sef + $penalty;
}
$lineRecordArray[] = array("propertyIndexNumber" => $tdRecord["propertyIndexNumber"], "tdNumber" => $tdRecord["taxDeclarationNumber"], "paidBasic" => $paidBasic, "paidSEF" => $paidSEF, "paidPenalty" => $paidPenalty, "totalTaxCollected" => $totalTaxCollected, "basic" => $basic, "sef" => $sef, "penalty" => $penalty, "totalCollectible" => $totalCollectible);
}
}
}
// print page
if (is_array($lineRecordArray)) {
$ypos = 400;
$decrementYposBy = 12;
$linesPerPage = 20;
$count = count($lineRecordArray);
$numOfPages = ceil($count / $linesPerPage);
$pageCtr = 1;
$lineCtr = 1;
$recordCtr = 1;
$this->tpl->set_var("classification", $this->formArray["classification"]);
$this->tpl->set_var("numOfPages", $numOfPages);
$this->tpl->set_block("rptsTemplate", "Page", "PageBlock");
$this->tpl->set_block("Page", "Row", "RowBlock");
$this->tpl->set_block("Page", "Totals", "TotalsBlock");
$totalsArray = array("totalPaidBasic" => 0, "totalPaidSEF" => 0, "totalPaidPenalty" => 0, "totalTotalTaxCollected" => 0, "totalBasic" => 0, "totalSef" => 0, "totalPenalty" => 0, "totalTotalCollectible" => 0);
foreach ($lineRecordArray as $recordArray) {
$this->tpl->set_var("ypos", $ypos);
$this->tpl->set_var("recordCtr", $recordCtr);
// tally totals
$totalsArray["totalPaidBasic"] += un_number_format($recordArray["paidBasic"]);
$totalsArray["totalPaidSEF"] += un_number_format($recordArray["paidSEF"]);
$totalsArray["totalPaidPenalty"] += un_number_format($recordArray["paidPenalty"]);
$totalsArray["totalTotalTaxCollected"] += un_number_format($recordArray["totalTaxCollected"]);
$totalsArray["totalBasic"] += un_number_format($recordArray["basic"]);
$totalsArray["totalSef"] += un_number_format($recordArray["sef"]);
$totalsArray["totalPenalty"] += un_number_format($recordArray["penalty"]);
$totalsArray["totalTotalCollectible"] += un_number_format($recordArray["totalCollectible"]);
// write values
foreach ($recordArray as $key => $value) {
switch ($key) {
case "paidBasic":
case "paidSEF":
case "paidPenalty":
case "totalTaxCollected":
case "basic":
case "sef":
case "penalty":
case "totalCollectible":
$value = formatCurrency($value);
break;
}
$this->tpl->set_var($key, $value);
}
$this->tpl->parse("RowBlock", "Row", true);
if ($recordCtr == count($lineRecordArray) || $lineCtr == $linesPerPage) {
if ($pageCtr == $numOfPages) {
foreach ($totalsArray as $key => $value) {
$value = formatCurrency($value);
$this->tpl->set_var($key, $value);
}
$this->tpl->parse("TotalsBlock", "Totals", true);
} else {
$this->tpl->set_var("TotalsBlock", "");
}
$this->tpl->set_var("page", $pageCtr);
$this->tpl->parse("PageBlock", "Page", true);
$this->tpl->set_var("RowBlock", "");
$this->tpl->set_var("TotalsBlock", "");
$ypos = 400;
$lineCtr = 0;
$pageCtr++;
}
$lineCtr++;
$recordCtr++;
$ypos = $ypos - $decrementYposBy;
}
$this->tpl->parse("templatePage", "rptsTemplate");
$this->tpl->finish("templatePage");
$testpdf = new PDFWriter();
$testpdf->setOutputXML($this->tpl->get("templatePage"), "test");
if (isset($this->formArray["print"])) {
$testpdf->writePDF($name);
//,$this->formArray["print"]);
} else {
$testpdf->writePDF($name);
}
} else {
exit("no records to display");
}
}
function Main()
{
global $_POST;
$this->tpl->set_var("uname", $this->user["uname"]);
$this->tpl->set_var("today", date("F j, Y"));
$this->setPageDetailPerms();
$this->formArray["formAction"] = $_POST["formAction"];
switch ($this->formArray["formAction"]) {
case "applyPayment":
// show owner
$RPTOPDetails = new SoapObject(NCCBIZ . "RPTOPDetails.php", "urn:Object");
if (!($xmlStr = $RPTOPDetails->getRPTOP($this->formArray["rptopID"]))) {
exit("xml failed");
} else {
//echo($xmlStr);
if (!($domDoc = domxml_open_mem($xmlStr))) {
$this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock");
$this->tpl->set_var("OwnerListTableBlock", "error xmlDoc");
} else {
$rptop = new RPTOP();
$rptop->parseDomDocument($domDoc);
//print_r($rptop);
if (is_object($rptop->owner)) {
//$RPTOPEncode = new SoapObject(NCCBIZ."RPTOPEncode.php", "urn:Object");
if (is_a($rptop->owner, "Owner")) {
$this->formArray["ownerID"] = $rptop->owner->getOwnerID();
$xmlStr = $rptop->owner->domDocument->dump_mem(true);
if (!$xmlStr) {
$this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock");
$this->tpl->set_var("OwnerListTableBlock", "");
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
$this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock");
$this->tpl->set_var("OwnerListTableBlock", "error xmlDoc");
} else {
$this->displayOwnerList($domDoc);
}
}
} else {
$this->tpl->set_block("rptsTemplate", "PersonList", "PersonListBlock");
$this->tpl->set_var("PersonListBlock", "");
$this->tpl->set_block("rptsTemplate", "CompanyList", "CompanyListBlock");
$this->tpl->set_var("CompanyListBlock", "");
}
}
}
}
// gather payments
$this->tdArray = $_POST["td"];
if (is_array($this->tdArray)) {
foreach ($this->tdArray as $tdID => $tdElementArray) {
// grab dueID from tdID
$dueID = $dueType = $tdElementArray["dueType"];
// start: the following 'for' loop is an un_number_format sweep added February 10, 2005
foreach ($tdElementArray as $tdElementKey => $tdElementValue) {
$tdElementArray[$tdElementKey] = un_number_format($tdElementValue);
}
// end: un_number_format sweep loop of February 10, 2005
foreach ($tdElementArray as $tdElementKey => $tdElementValue) {
switch ($tdElementKey) {
case "amountPaid":
if ($tdElementValue > 0) {
$payment = new Payment();
$payment->setPaymentID("");
$payment->setTdID($tdID);
$payment->setDueID($tdElementArray["dueID"]);
$payment->setDueType($tdElementArray["dueType"]);
$payment->setBacktaxTDID("");
$payment->setTaxDue($tdElementArray["taxDue"]);
$payment->setAdvancedPaymentDiscount($tdElementArray["advancedPaymentDiscount"]);
$payment->setEarlyPaymentDiscount($tdElementArray["earlyPaymentDiscount"]);
$payment->setPenalty($tdElementArray["penalty"]);
$payment->setAmnesty($tdElementArray["amnesty"]);
$payment->setBalanceDue($tdElementArray["balance"]);
$payment->setAmountPaid(un_number_format($tdElementArray["amountPaid"]));
$payment->setDueDate(date("Y-m-d", strtotime($tdElementArray["dueDate"])));
$payment->setPaymentDate(date("Y-m-d", strtotime("now")));
$payment->setOwnerID($this->formArray["ownerID"]);
$payment->setTdNumber($this->getTDNumberFromPayment($tdID, ""));
$payment->setBasicReceipt($this->initReceipt($payment, "basic"));
$payment->setSefReceipt($this->initReceipt($payment, "sef"));
$payment->setIdleReceipt($this->initReceipt($payment, "idle"));
$this->paymentArrayList[] = $payment;
}
break;
case "btTD":
if (is_array($tdElementValue)) {
$btTDArray = $tdElementValue;
foreach ($btTDArray as $backtaxTDID => $btTDElementArray) {
if ($btTDElementArray["amountPaid"] > 0) {
$payment = new Payment();
$payment->setPaymentID("");
$payment->setTdID("");
$payment->setDueID($btTDElementArray["dueID"]);
$payment->setDueType($btTDElementArray["dueType"]);
$payment->setBacktaxTDID($backtaxTDID);
$payment->setTaxDue($btTDElementArray["taxDue"]);
$payment->setAdvancedPaymentDiscount($btTDElementArray["advancedPaymentDiscount"]);
$payment->setEarlyPaymentDiscount($btTDElementArray["earlyPaymentDiscount"]);
$payment->setPenalty($btTDElementArray["penalty"]);
$payment->setAmnesty($btTDElementArray["amnesty"]);
$payment->setBalanceDue($btTDElementArray["balance"]);
$payment->setAmountPaid(un_number_format($btTDElementArray["amountPaid"]));
$payment->setDueDate(date("Y-m-d", strtotime($btTDElementArray["dueDate"])));
$payment->setPaymentDate(date("Y-m-d", strtotime("now")));
$payment->setOwnerID($this->formArray["ownerID"]);
$payment->setTdNumber($this->getTDNumberFromPayment("", $backtaxTDID));
$payment->setBasicReceipt($this->initReceipt($payment, "basic"));
$payment->setSefReceipt($this->initReceipt($payment, "sef"));
$payment->setIdleReceipt($this->initReceipt($payment, "idle"));
$this->paymentArrayList[] = $payment;
}
}
}
break;
default:
break;
}
}
}
}
$this->tpl->set_block("rptsTemplate", "PaymentList", "PaymentListBlock");
$this->tpl->set_block("rptsTemplate", "BasicReceipt", "BasicReceiptBlock");
$this->tpl->set_block("BasicReceipt", "BasicReceiptList", "BasicReceiptListBlock");
$this->tpl->set_block("BasicReceipt", "BasicPreviousReceiptDateYearList", "BasicPreviousReceiptDateYearListBlock");
$this->tpl->set_block("BasicReceipt", "BasicPreviousReceiptDateMonthList", "BasicPreviousReceiptDateMonthListBlock");
$this->tpl->set_block("BasicReceipt", "BasicPreviousReceiptDateDayList", "BasicPreviousReceiptDateDayListBlock");
$this->tpl->set_block("rptsTemplate", "SefReceipt", "SefReceiptBlock");
$this->tpl->set_block("SefReceipt", "SefReceiptList", "SefReceiptListBlock");
$this->tpl->set_block("SefReceipt", "SefPreviousReceiptDateYearList", "SefPreviousReceiptDateYearListBlock");
$this->tpl->set_block("SefReceipt", "SefPreviousReceiptDateMonthList", "SefPreviousReceiptDateMonthListBlock");
$this->tpl->set_block("SefReceipt", "SefPreviousReceiptDateDayList", "SefPreviousReceiptDateDayListBlock");
$this->tpl->set_block("rptsTemplate", "IdleReceipt", "IdleReceiptBlock");
$this->tpl->set_block("IdleReceipt", "IdleReceiptList", "IdleReceiptListBlock");
$this->tpl->set_block("IdleReceipt", "IdlePreviousReceiptDateYearList", "IdlePreviousReceiptDateYearListBlock");
$this->tpl->set_block("IdleReceipt", "IdlePreviousReceiptDateMonthList", "IdlePreviousReceiptDateMonthListBlock");
$this->tpl->set_block("IdleReceipt", "IdlePreviousReceiptDateDayList", "IdlePreviousReceiptDateDayListBlock");
$paymentCtr = 0;
$basicCtr = 0;
$sefCtr = 0;
$idleCtr = 0;
$basicReceiptCtr = 0;
$sefReceiptCtr = 0;
$idleReceiptCtr = 0;
foreach ($this->paymentArrayList as $payment) {
$this->tpl->set_var("tdNumber", $payment->getTdNumber());
$this->tpl->set_var("year", date("Y", strtotime($payment->getDueDate())));
$this->tpl->set_var("balanceDue_formatted", formatCurrency($payment->getBalanceDue()));
$this->tpl->set_var("amountPaid_formatted", formatCurrency($payment->getAmountPaid()));
$this->tpl->set_var("paymentCtr", $paymentCtr);
$this->tpl->set_var("tdID", $payment->getTdID());
$this->tpl->set_var("dueID", $payment->getDueID());
$this->tpl->set_var("dueType", $payment->getDueType());
$this->tpl->set_var("backtaxTDID", $payment->getBacktaxTDID());
$this->tpl->set_var("taxDue", $payment->getTaxDue());
$this->tpl->set_var("advancedPaymentDiscount", $payment->getAdvancedPaymentDiscount());
$this->tpl->set_var("earlyPaymentDiscount", $payment->getEarlyPaymentDiscount());
$this->tpl->set_var("penalty", $payment->getPenalty());
$this->tpl->set_var("amnesty", $payment->getAmnesty());
$this->tpl->set_var("balanceDue", $payment->getBalanceDue());
$this->tpl->set_var("amountPaid", $payment->getAmountPaid());
$this->tpl->set_var("dueDate", date("Y-m-d", strtotime($payment->getDueDate())));
$this->tpl->set_var("paymentDate", date($payment->getPaymentDate(), strtotime($payment->getPaymentDate())));
$this->tpl->set_var("ownerID", $payment->getOwnerID());
$this->tpl->set_var("basicReceipt[receiptDate]", $payment->basicReceipt->getReceiptDate());
$this->tpl->set_var("basicReceipt[receivedFrom]", $payment->basicReceipt->getReceivedFrom());
$this->tpl->set_var("basicReceipt[taxType]", $payment->basicReceipt->getTaxType());
$this->tpl->set_var("basicReceipt[taxDue]", $payment->basicReceipt->getTaxDue());
$this->tpl->set_var("basicReceipt[advancedPaymentDiscount]", $payment->basicReceipt->getAdvancedPaymentDiscount());
$this->tpl->set_var("basicReceipt[earlyPaymentDiscount]", $payment->basicReceipt->getEarlyPaymentDiscount());
$this->tpl->set_var("basicReceipt[penalty]", $payment->basicReceipt->getPenalty());
$this->tpl->set_var("basicReceipt[amnesty]", $payment->basicReceipt->getAmnesty());
$this->tpl->set_var("basicReceipt[balanceDue]", $payment->basicReceipt->getBalanceDue());
$this->tpl->set_var("basicReceipt[amountPaid]", $payment->basicReceipt->getAmountPaid());
$this->tpl->set_var("basicReceipt[cityTreasurer]", $payment->basicReceipt->getCityTreasurer());
$this->tpl->set_var("basicReceipt[deputyTreasurer]", $payment->basicReceipt->getDeputyTreasurer());
$this->tpl->set_var("sefReceipt[receiptDate]", $payment->sefReceipt->getReceiptDate());
$this->tpl->set_var("sefReceipt[receivedFrom]", $payment->sefReceipt->getReceivedFrom());
$this->tpl->set_var("sefReceipt[taxType]", $payment->sefReceipt->getTaxType());
$this->tpl->set_var("sefReceipt[taxDue]", $payment->sefReceipt->getTaxDue());
$this->tpl->set_var("sefReceipt[advancedPaymentDiscount]", $payment->sefReceipt->getAdvancedPaymentDiscount());
$this->tpl->set_var("sefReceipt[earlyPaymentDiscount]", $payment->sefReceipt->getEarlyPaymentDiscount());
$this->tpl->set_var("sefReceipt[penalty]", $payment->sefReceipt->getPenalty());
$this->tpl->set_var("sefReceipt[amnesty]", $payment->sefReceipt->getAmnesty());
$this->tpl->set_var("sefReceipt[balanceDue]", $payment->sefReceipt->getBalanceDue());
$this->tpl->set_var("sefReceipt[amountPaid]", $payment->sefReceipt->getAmountPaid());
$this->tpl->set_var("sefReceipt[cityTreasurer]", $payment->sefReceipt->getCityTreasurer());
$this->tpl->set_var("sefReceipt[deputyTreasurer]", $payment->sefReceipt->getDeputyTreasurer());
$this->tpl->set_var("idleReceipt[receiptDate]", $payment->idleReceipt->getReceiptDate());
$this->tpl->set_var("idleReceipt[receivedFrom]", $payment->idleReceipt->getReceivedFrom());
$this->tpl->set_var("idleReceipt[taxType]", $payment->idleReceipt->getTaxType());
$this->tpl->set_var("idleReceipt[taxDue]", $payment->idleReceipt->getTaxDue());
$this->tpl->set_var("idleReceipt[advancedPaymentDiscount]", $payment->idleReceipt->getAdvancedPaymentDiscount());
$this->tpl->set_var("idleReceipt[earlyPaymentDiscount]", $payment->idleReceipt->getEarlyPaymentDiscount());
$this->tpl->set_var("idleReceipt[penalty]", $payment->idleReceipt->getPenalty());
$this->tpl->set_var("idleReceipt[amnesty]", $payment->idleReceipt->getAmnesty());
$this->tpl->set_var("idleReceipt[balanceDue]", $payment->idleReceipt->getBalanceDue());
$this->tpl->set_var("idleReceipt[amountPaid]", $payment->idleReceipt->getAmountPaid());
$this->tpl->set_var("idleReceipt[cityTreasurer]", $payment->idleReceipt->getCityTreasurer());
$this->tpl->set_var("idleReceipt[deputyTreasurer]", $payment->idleReceipt->getDeputyTreasurer());
$this->tpl->set_var("basicBalanceDue", formatCurrency($payment->basicReceipt->getBalanceDue()));
$this->tpl->set_var("sefBalanceDue", formatCurrency($payment->sefReceipt->getBalanceDue()));
$this->tpl->set_var("idleBalanceDue", formatCurrency($payment->idleReceipt->getBalanceDue()));
$this->tpl->set_var("basicAmountPaid", formatCurrency($payment->basicReceipt->getAmountPaid()));
$this->tpl->set_var("sefAmountPaid", formatCurrency($payment->sefReceipt->getAmountPaid()));
$this->tpl->set_var("idleAmountPaid", formatCurrency($payment->idleReceipt->getAmountPaid()));
$this->tpl->parse("BasicReceiptListBlock", "BasicReceiptList", true);
$this->tpl->parse("SefReceiptListBlock", "SefReceiptList", true);
$this->tpl->parse("IdleReceiptListBlock", "IdleReceiptList", true);
$this->tpl->parse("PaymentListBlock", "PaymentList", true);
if ($basicCtr == 5 || $paymentCtr == count($this->paymentArrayList) - 1) {
$basicCtr = 0;
$this->tpl->set_var("basicReceiptCtr", $basicReceiptCtr);
$this->displayPreviousReceiptDateList("basic");
$this->tpl->parse("BasicReceiptBlock", "BasicReceipt", true);
$this->tpl->set_var("BasicReceiptListBlock", "");
$this->tpl->set_var("BasicPreviousReceiptDateYearListBlock", "");
$this->tpl->set_var("BasicPreviousReceiptDateMonthListBlock", "");
$this->tpl->set_var("BasicPreviousReceiptDateDayListBlock", "");
$basicReceiptCtr++;
}
if ($sefCtr == 5 || $paymentCtr == count($this->paymentArrayList) - 1) {
$sefCtr = 0;
$this->tpl->set_var("sefReceiptCtr", $sefReceiptCtr);
$this->displayPreviousReceiptDateList("sef");
$this->tpl->parse("SefReceiptBlock", "SefReceipt", true);
$this->tpl->set_var("SefReceiptListBlock", "");
$this->tpl->set_var("SefPreviousReceiptDateYearListBlock", "");
$this->tpl->set_var("SefPreviousReceiptDateMonthListBlock", "");
$this->tpl->set_var("SefPreviousReceiptDateDayListBlock", "");
$sefReceiptCtr++;
}
if ($idleCtr == 5 || $paymentCtr == count($this->paymentArrayList) - 1) {
$idleCtr = 0;
$this->tpl->set_var("idleReceiptCtr", $idleReceiptCtr);
$this->displayPreviousReceiptDateList("idle");
$this->tpl->parse("IdleReceiptBlock", "IdleReceipt", true);
$this->tpl->set_var("IdleReceiptListBlock", "");
$this->tpl->set_var("IdlePreviousReceiptDateYearListBlock", "");
$this->tpl->set_var("IdlePreviousReceiptDateMonthListBlock", "");
$this->tpl->set_var("IdlePreviousReceiptDateDayListBlock", "");
$idleReceiptCtr++;
}
$paymentCtr++;
$basicCtr++;
$sefCtr++;
$idleCtr++;
}
break;
default:
header("Location: Unauthorized.php" . $this->sess->url(""));
exit;
}
$this->setForm();
$this->tpl->set_var("Session", $this->sess->url(""));
$this->tpl->parse("templatePage", "rptsTemplate");
$this->tpl->finish("templatePage");
$this->tpl->p("templatePage");
}
function Main()
{
$this->displayPageHeading();
$this->tpl->set_block("rptsTemplate", "Page", "PageBlock");
$this->tpl->set_var("pageNumber", 1);
$this->tpl->set_block("Page", "Row", "RowBlock");
$this->tpl->set_block("Page", "Totals", "TotalsBlock");
$this->formArray["dayArray"] = $this->getDayArrayFromMonthYear();
$totalsArray = array("totalPaidBasic" => 0, "totalPriorBasic" => 0, "totalPenaltyBasic" => 0, "totalDiscountBasic" => 0, "totalPaidSEF" => 0, "totalPriorSEF" => 0, "totalPenaltySEF" => 0, "totalDiscountSEF" => 0);
if (is_array($this->formArray["dayArray"])) {
foreach ($this->formArray["dayArray"] as $day) {
if ($this->paymentRecords = $this->filterPaymentsByDate($this->formArray["year"], $this->formArray["month"], $day)) {
if (is_array($this->paymentRecords->getArrayList())) {
$list = $this->paymentRecords->getArrayList();
$list2 = $list;
$merged = array_merge($list, $list2);
$this->formArray["paidBasic"] = 0.0;
$this->formArray["priorBasic"] = 0.0;
$this->formArray["penaltyBasic"] = 0.0;
$this->formArray["discountBasic"] = 0.0;
$this->formArray["paidSEF"] = 0.0;
$this->formArray["priorSEF"] = 0.0;
$this->formArray["penaltySEF"] = 0.0;
$this->formArray["discountSEF"] = 0.0;
foreach ($list as $payment) {
$this->incrementValues($payment);
}
$totalsArray["totalPaidBasic"] += un_number_format($this->formArray["paidBasic"]);
$totalsArray["totalPriorBasic"] += un_number_format($this->formArray["priorBasic"]);
$totalsArray["totalPenaltyBasic"] += un_number_format($this->formArray["penaltyBasic"]);
$totalsArray["totalDiscountBasic"] += un_number_format($this->formArray["discountBasic"]);
$totalsArray["totalPaidSEF"] += un_number_format($this->formArray["paidSEF"]);
$totalsArray["totalPriorSEF"] += un_number_format($this->formArray["priorSEF"]);
$totalsArray["totalPenaltySEF"] += un_number_format($this->formArray["penaltySEF"]);
$totalsArray["totalDiscountSEF"] += un_number_format($this->formArray["discountSEF"]);
$this->tpl->set_var("collectionDate", date("M d, Y", strtotime($this->formArray["year"] . "-" . $this->formArray["month"] . "-" . $day)));
$this->tpl->set_var("paidBasic", formatCurrency($this->formArray["paidBasic"]));
$this->tpl->set_var("priorBasic", formatCurrency($this->formArray["priorBasic"]));
$this->tpl->set_var("penaltyBasic", formatCurrency($this->formArray["penaltyBasic"]));
$this->tpl->set_var("discountBasic", formatCurrency($this->formArray["discountBasic"]));
$this->tpl->set_var("paidSEF", formatCurrency($this->formArray["paidSEF"]));
$this->tpl->set_var("priorSEF", formatCurrency($this->formArray["priorSEF"]));
$this->tpl->set_var("penaltySEF", formatCurrency($this->formArray["penaltySEF"]));
$this->tpl->set_var("discountSEF", formatCurrency($this->formArray["discountSEF"]));
$this->tpl->set_var("yposLine", $this->formArray["yposLine"]);
$this->tpl->parse("RowBlock", "Row", true);
$this->formArray["yposLine"] = $this->formArray["yposLine"] - 10;
if ($this->formArray["yposLine"] < 70) {
// new page
$this->tpl->set_var("TotalsBlock", "");
$this->tpl->set_var("pageNumber", $this->formArray["pageNumber"]);
$this->tpl->parse("PageBlock", "Page", true);
$this->tpl->set_var("RowBlock", "");
$this->tpl->set_var("TotalsBlock", "");
$this->formArray["yposLine"] = 460;
$this->formArray["pageNumber"]++;
}
}
}
}
}
$this->tpl->set_var("totalPages", $this->formArray["pageNumber"]);
// last page
// print totals:
foreach ($totalsArray as $key => $value) {
$value = formatCurrency($value);
$this->tpl->set_var($key, $value);
}
$this->tpl->parse("TotalsBlock", "Totals", true);
if ($this->formArray["yposLine"] == 460) {
if ($this->formArray["pageNumber"] - 1 >= 1) {
$this->tpl->set_var("totalPages", $this->formArray["pageNumber"] - 1);
} else {
$this->tpl->set_var("pageNumber", 1);
$this->tpl->set_var("totalPages", 1);
$this->tpl->parse("PageBlock", "Page", true);
$this->tpl->set_var("RowBlock", "");
$this->tpl->set_var("TotalsBlock", "");
}
} else {
if ($this->formArray["yposLine"] < 460 && $this->formArray["yposLine"] >= 70) {
$this->tpl->set_var("pageNumber", $this->formArray["pageNumber"]);
$this->tpl->parse("PageBlock", "Page", true);
$this->tpl->set_var("RowBlock", "");
$this->tpl->set_var("TotalsBlock", "");
}
}
$this->tpl->parse("templatePage", "rptsTemplate");
$this->tpl->finish("templatePage");
$testpdf = new PDFWriter();
$testpdf->setOutputXML($this->tpl->get("templatePage"), "test");
if (isset($this->formArray["print"])) {
$testpdf->writePDF($name);
//,$this->formArray["print"]);
} else {
$testpdf->writePDF($name);
}
}
function Main()
{
$eRPTSSettings = new eRPTSSettings();
if ($eRPTSSettings->selectRecord(1)) {
$this->tpl->set_var("lguType", strtoupper($eRPTSSettings->getLguType()));
$this->tpl->set_var("lguName", strtoupper($eRPTSSettings->getLguName()));
}
$dbTD = new DB_RPTS();
$dbBacktaxTD = new DB_RPTS();
$dbPaymentBacktaxTD = new DB_RPTS();
$dbPaymentTD = new DB_RPTS();
$dbDues = new DB_RPTS();
// gather TD's
$sql = "SELECT Due.dueID as dueID, " . "Due.tdID as tdID, " . "Due.dueType as dueType, " . "Due.dueDate as dueDate, " . "Due.basicTax as basicTax, " . "Due.basicTaxRate as basicTaxRate, " . "Due.sefTax as sefTax, " . "Due.sefTaxRate as sefTaxRate, " . "Due.idleTax as idleTax, " . "Due.idleTaxRate as idleTaxRate, " . "TD.afsID as afsID, " . "TD.propertyType as propertyType, " . "TD.taxDeclarationNumber as taxDeclarationNumber, " . "AFS.odID as odID, " . "AFS.arpNumber as arpNumber, " . "AFS.propertyIndexNumber as propertyIndexNumber, " . "AFS.taxability as taxability, " . "AFS.effectivity as effectivity, " . "AFS.totalMarketValue as totalMarketValue, " . "AFS.totalAssessedValue as totalAssessedValue " . "FROM Due, TD, AFS " . "WHERE Due.tdID = TD.tdID " . "AND TD.afsID = AFS.afsID " . "AND AFS.archive != 'true' " . "AND TD.archive != 'true' " . "AND Due.dueType = 'Annual' " . "AND YEAR(Due.dueDate) <= YEAR(NOW()) " . "AND TD.propertyType LIKE '" . $this->formArray["classification"] . "' " . "GROUP BY Due.tdID, YEAR(Due.dueDate) " . "ORDER BY Due.dueDate DESC";
$dbTD->query($sql);
if ($dbTD->nf() > 0) {
// gather BacktaxTD's
while ($dbTD->next_record()) {
$sqlBacktaxTD = "SELECT backtaxTDID, " . "tdID, " . "tdNumber, " . "startYear, " . "endYear, " . "startQuarter, " . "assessedValue, " . "basicRate, " . "sefRate, " . "basicTax, " . "sefTax, " . "idleTax, " . "penalties, " . "paid, " . "balance, " . "total " . "FROM BacktaxTD " . "WHERE tdID='" . $dbTD->f("tdID") . "' " . "ORDER BY startYear ASC ";
$dbBacktaxTD->query($sqlBacktaxTD);
if ($dbBacktaxTD->nf() > 0) {
while ($dbBacktaxTD->next_record()) {
$backtaxTDRecordArray[] = $dbBacktaxTD->Record;
}
}
$tdRecordArray[] = array("td" => $dbTD->Record, "backtaxTD" => $backtaxTDRecordArray);
unset($backtaxTDRecordArray);
}
}
if (is_array($tdRecordArray)) {
// verify whether each TD Record or BacktaxTD Record is delinquent by comparing it to Payment
// if it is not in Payment it is considered delinquent
// if amountPaid is insufficient to amountDue, it is considered delinquent
foreach ($tdRecordArray as $recordArray) {
$basicAmountDelinquent = 0;
$sefAmountDelinquent = 0;
$penalty = 0;
$totalDelinquent = 0;
// find delinquent backtaxTD's
if (is_array($recordArray["backtaxTD"])) {
foreach ($recordArray["backtaxTD"] as $backtaxTDRecord) {
$basicAmountDelinquent = 0;
$sefAmountDelinquent = 0;
$penalty = 0;
$totalDelinquent = 0;
$sqlPaymentBacktaxTD = "SELECT paymentID, " . "dueType, " . "backtaxTDID, " . "taxDue, " . "earlyPaymentDiscount, " . "advancedPaymentDiscount, " . "penalty, " . "amnesty, " . "balanceDue, " . "amountPaid, " . "dueDate, " . "paymentDate " . "FROM Payment " . "WHERE backtaxTDID='" . $backtaxTDRecord["backtaxTDID"] . "' " . "AND status!='cancelled'";
$dbPaymentBacktaxTD->query($sqlPaymentBacktaxTD);
if ($dbPaymentBacktaxTD->nf() > 0) {
if ($dbPaymentBacktaxTD->next_record()) {
// if amountPaid is less than balanceDue, it is delinquent
if ($dbPaymentBacktaxTD->f("amountPaid") < $dbPaymentBacktaxTD->f("balanceDue")) {
$paidBasic = $backtaxTDRecord["basicRate"] / ($backtaxTDRecord["basicRate"] + $backtaxTDRecord["sefRate"]) * $dbPaymentBacktaxTD->f("amountPaid");
$paidSef = $backtaxTDRecord["sefRate"] / ($backtaxTDRecord["basicRate"] + $backtaxTDRecord["sefRate"]) * $dbPaymentBacktaxTD->f("amountPaid");
$basicAmountDelinquent = $backtaxTDRecord["basicTax"] - $paidBasic;
$sefAmountDelinquent = $backtaxTDRecord["sefTax"] - $paidSef;
$backtaxTD = new BacktaxTD();
$backtaxTD->selectRecord("", $backtaxTDRecord["backtaxTDID"], "");
$backtaxTD->calculatePenalty(date("Y-m-d"));
$penalty = $backtaxTD->getPenalties();
$totalDelinquent = $basicAmountDelinquent + $sefAmountDelinquent + $penalty;
$delinquentRecordArray[] = array("propertyIndexNumber" => "", "taxDeclarationNumber" => $backtaxTDRecord["tdNumber"], "yearDelinquent" => $backtaxTDRecord["startYear"], "basicAmountDelinquent" => $basicAmountDelinquent, "sefAmountDelinquent" => $sefAmountDelinquent, "penalty" => $penalty, "totalDelinquent" => $totalDelinquent);
}
}
} else {
$paidBasic = $backtaxTDRecord["basicRate"] / ($backtaxTDRecord["basicRate"] + $backtaxTDRecord["sefRate"]) * $backtaxTDRecord["paid"];
$paidSef = $backtaxTDRecord["sefRate"] / ($backtaxTDRecord["basicRate"] + $backtaxTDRecord["sefRate"]) * $backtaxTDRecord["paid"];
$basicAmountDelinquent = $backtaxTDRecord["basicTax"] - $paidBasic;
$sefAmountDelinquent = $backtaxTDRecord["sefTax"] - $paidSef;
$backtaxTD = new BacktaxTD();
$backtaxTD->selectRecord("", $backtaxTDRecord["backtaxTDID"], "");
$backtaxTD->calculatePenalty(date("Y-m-d"));
$penalty = $backtaxTD->getPenalties();
$totalDelinquent = $basicAmountDelinquent + $sefAmountDelinquent + $penalty;
$delinquentRecordArray[] = array("propertyIndexNumber" => "", "taxDeclarationNumber" => $backtaxTDRecord["tdNumber"], "yearDelinquent" => $backtaxTDRecord["startYear"], "basicAmountDelinquent" => $basicAmountDelinquent, "sefAmountDelinquent" => $sefAmountDelinquent, "penalty" => $penalty, "totalDelinquent" => $totalDelinquent);
}
}
}
// find delinquent TD's
if (is_array($recordArray["td"])) {
$tdRecord = $recordArray["td"];
$basicAmountDelinquent = 0;
$sefAmountDelinquent = 0;
$penalty = 0;
$totalDelinquent = 0;
$sqlPaymentTD = "SELECT paymentID, " . "dueID, " . "dueType, " . "tdID, " . "taxDue, " . "earlyPaymentDiscount, " . "advancedPaymentDiscount, " . "penalty, " . "amnesty, " . "balanceDue, " . "amountPaid, " . "dueDate, " . "paymentDate " . "FROM Payment " . "WHERE tdID='" . $tdRecord["tdID"] . "' " . "AND status!='cancelled'";
$dbPaymentTD->query($sqlPaymentTD);
if ($dbPaymentTD->nf() > 0) {
while ($dbPaymentTD->next_record()) {
if ($dbPaymentTD->f("dueType") == "Annual") {
if ($dbPaymentTD->f("amountPaid") < $dbPaymentTD->f("balanceDue")) {
$paidBasic = $tdRecord["basicRate"] / ($tdRecord["basicRate"] + $tdRecord["sefRate"]) * $dbPaymentTD->f("amountPaid");
$paidSef = $tdRecord["sefRate"] / ($tdRecord["basicRate"] + $tdRecord["sefRate"]) * $dbPaymentTD->f("amountPaid");
$basicAmountDelinquent = $tdRecord["basicTax"] - $paidBasic;
$sefAmountDelinquent = $tdRecord["sefTax"] - $paidSef;
$due = new Due();
$due->selectRecord($tdRecord["dueID"]);
$due = $this->computePenalty(date("Y-m-d"), $due);
$penalty = $due->getPenalty();
$totalDelinquent = $basicAmountDelinquent + $sefAmountDelinquent + $penalty;
$delinquentRecordArray[] = array("propertyIndexNumber" => $tdRecord["propertyIndexNumber"], "taxDeclarationNumber" => $tdRecord["taxDeclarationNumber"], "yearDelinquent" => date("Y", strtotime($tdRecord["dueDate"])), "basicAmountDelinquent" => $basicAmountDelinquent, "sefAmountDelinquent" => $sefAmountDelinquent, "penalty" => $penalty, "totalDelinquent" => $totalDelinquent);
}
break;
} else {
$tmpPaidQuarterDues[] = $dbPaymentTD->f("dueID");
}
}
if (is_array($tmpPaidQuarterDues)) {
// not all quarters have been paid if less than four
if (count($tmpPaidQuarterDues) < 4) {
foreach ($tmpPaidQuarterDues as $dueID) {
$sqlDueCondition .= " AND Due.dueID!='" . $dueID . "' ";
}
// grab unpaid quarterly dues that have not been paid before quarterly dueDate
$sqlDues = "SELECT Due.dueID as dueID, " . "Due.dueType as dueType, " . "Due.tdID as tdID " . "FROM Due, TD, AFS " . "WHERE TD.afsID = AFS.afsID " . "AND AFS.archive != 'true' " . "AND TD.archive != 'true' " . "AND Due.dueType != 'Annual' " . "AND Due.tdID = '" . $tdRecord["tdID"] . "'" . "AND TD.propertyType LIKE '" . $this->formArray["classification"] . "' " . "AND YEAR(Due.dueDate) <= " . date("Y", strtotime($tdRecord["dueDate"])) . " " . "AND Due.dueDate <= '" . date("Y-m-d") . "' " . $sqlDueCondition . " " . "GROUP BY Due.tdID, Due.dueDate " . "ORDER BY Due.dueDate DESC";
$dbDues->query($sqlDues);
while ($dbDues->next_record()) {
$due = new Due();
$due->selectRecord($dbDues->f("dueID"));
$basicAmountDelinquent += $due->getBasicTax();
$sefAmountDelinquent += $due->getSefTax();
$due = $this->computePenalty(date("Y-m-d"), $due);
$penalty += $due->getPenalty();
}
$totalDelinquent = $basicAmountDelinquent + $sefAmountDelinquent + $penalty;
$delinquentRecordArray[] = array("propertyIndexNumber" => $tdRecord["propertyIndexNumber"], "taxDeclarationNumber" => $tdRecord["taxDeclarationNumber"], "yearDelinquent" => date("Y", strtotime($tdRecord["dueDate"])), "basicAmountDelinquent" => $basicAmountDelinquent, "sefAmountDelinquent" => $sefAmountDelinquent, "penalty" => $penalty, "totalDelinquent" => $totalDelinquent);
}
unset($sqlDueCondition);
unset($tmpPaidQuarterDues);
}
} else {
$basicAmountDelinquent = $tdRecord["basicTax"];
$sefAmountDelinquent = $tdRecord["sefTax"];
$due = new Due();
$due->selectRecord($tdRecord["dueID"]);
$due = $this->computePenalty(date("Y-m-d"), $due);
$penalty = $due->getPenalty();
$totalDelinquent = $basicAmountDelinquent + $sefAmountDelinquent + $penalty;
$delinquentRecordArray[] = array("propertyIndexNumber" => $tdRecord["propertyIndexNumber"], "taxDeclarationNumber" => $tdRecord["taxDeclarationNumber"], "yearDelinquent" => date("Y", strtotime($tdRecord["dueDate"])), "basicAmountDelinquent" => $basicAmountDelinquent, "sefAmountDelinquent" => $sefAmountDelinquent, "penalty" => $penalty, "totalDelinquent" => $totalDelinquent);
}
}
}
}
// print page
if (is_array($delinquentRecordArray)) {
$ypos = 615;
$decrementYposBy = 12;
$linesPerPage = 42;
$count = count($delinquentRecordArray);
$numOfPages = ceil($count / $linesPerPage);
$pageCtr = 1;
$lineCtr = 1;
$recordCtr = 1;
$this->tpl->set_var("classification", $this->formArray["classification"]);
$this->tpl->set_var("numOfPages", $numOfPages);
$this->tpl->set_block("rptsTemplate", "Page", "PageBlock");
$this->tpl->set_block("Page", "Row", "RowBlock");
$this->tpl->set_block("Page", "Totals", "TotalsBlock");
$totalsArray = array("totalBasicAmountDelinquent" => 0, "totalSefAmountDelinquent" => 0, "totalPenalty" => 0, "totalTotalDelinquent" => 0);
foreach ($delinquentRecordArray as $recordArray) {
$this->tpl->set_var("ypos", $ypos);
$this->tpl->set_var("recordCtr", $recordCtr);
// write values
$totalsArray["totalBasicAmountDelinquent"] += un_number_format($recordArray["basicAmountDelinquent"]);
$totalsArray["totalSefAmountDelinquent"] += un_number_format($recordArray["sefAmountDelinquent"]);
$totalsArray["totalPenalty"] += un_number_format($recordArray["penalty"]);
$totalsArray["totalTotalDelinquent"] += un_number_format($recordArray["totalDelinquent"]);
foreach ($recordArray as $key => $value) {
switch ($key) {
case "basicAmountDelinquent":
case "sefAmountDelinquent":
case "penalty":
case "totalDelinquent":
$value = formatCurrency($value);
break;
}
$this->tpl->set_var($key, $value);
}
$this->tpl->parse("RowBlock", "Row", true);
if ($recordCtr == count($delinquentRecordArray) || $lineCtr == $linesPerPage) {
if ($pageCtr == $numOfPages) {
foreach ($totalsArray as $key => $value) {
$value = formatCurrency($value);
$this->tpl->set_var($key, $value);
}
$this->tpl->parse("TotalsBlock", "Totals", true);
} else {
$this->tpl->set_var("TotalsBlock", "");
}
$this->tpl->set_var("page", $pageCtr);
$this->tpl->parse("PageBlock", "Page", true);
$this->tpl->set_var("RowBlock", "");
$this->tpl->set_var("TotalsBlock", "");
$ypos = 615;
$lineCtr = 0;
$pageCtr++;
}
$lineCtr++;
$recordCtr++;
$ypos = $ypos - $decrementYposBy;
}
$this->tpl->parse("templatePage", "rptsTemplate");
$this->tpl->finish("templatePage");
$testpdf = new PDFWriter();
$testpdf->setOutputXML($this->tpl->get("templatePage"), "test");
if (isset($this->formArray["print"])) {
$testpdf->writePDF($name);
//,$this->formArray["print"]);
} else {
$testpdf->writePDF($name);
}
} else {
exit("no delinquent collectible records to display");
}
}
function displayMachineriesList($machineriesList)
{
if (count($machineriesList)) {
foreach ($machineriesList as $mkey => $machineries) {
// "kind" is assumed to be treated as "classes" for machineries
$machineriesClasses = new MachineriesClasses();
if (is_numeric($machineries->getKind())) {
$machineriesClasses->selectRecord($machineries->getKind());
$machineriesClassesDescription = $machineriesClasses->getDescription();
$machineriesClassesCode = $machineriesClasses->getCode();
} else {
$machineriesClassesDescription = $machineries->getKind();
$machineriesClassesCode = $machineries->getActualUse();
}
// "classification" is assumed to be treated as "actualUse" for machineries
$machineriesActualUses = new MachineriesActualUses();
if (is_numeric($machineries->getActualUse())) {
$machineriesActualUses->selectRecord($machineries->getActualUse());
$machineriesActualUsesDescription = $machineriesActualUses->getDescription();
$machineriesActualUsesCode = $machineriesActualUses->getCode();
} else {
$machineriesActualUsesDescription = $machineries->getActualUse();
$machineriesActualUsesCode = $machineries->getActualUse();
}
// NCC Modification checked and implemented by K2 : November 21, 2005
// details:
// - changed `if($this->formArray["p"] <= 3)` to `if(...<=10)` in line xx
// - added lines 547 to 561
// - added line 585
if ($this->formArray["p"] <= 10) {
$p = $this->formArray["p"];
$this->formArray["ypos"] -= 12;
$offset = $this->formArray["ypos"];
$items .= "<textitem xpos=\"40\" ypos=\"" . $offset . "\" font=\"Helvetica\" size=\"10\" align=\"left\">" . $machineriesClassesDescription . "</textitem>";
$items .= "<textitem xpos=\"146\" ypos=\"" . $offset . "\" font=\"Helvetica\" size=\"9\" align=\"left\">" . $machineriesActualUsesDescription . "</textitem>";
$items .= "<textitem xpos=\"337\" ypos=\"" . $offset . "\" font=\"Helvetica\" size=\"10\" align=\"right\">" . number_format($machineries->getMarketValue(), 2) . "</textitem>";
$items .= "<textitem xpos=\"430\" ypos=\"" . $offset . "\" font=\"Helvetica\" size=\"10\" align=\"right\">" . number_format($machineries->getAssessmentLevel(), 2) . "</textitem>";
$items .= "<textitem xpos=\"558\" ypos=\"" . $offset . "\" font=\"Helvetica\" size=\"10\" align=\"right\">" . $machineries->getAssessedValue() . "</textitem>";
$offsetx = $offset - 3;
$items .= "<lineitem x1=\"40\" y1=\"" . $offsetx . "\" x2=\"120\" y2=\"" . $offsetx . "\">blurb</lineitem>";
$items .= "<lineitem x1=\"147\" y1=\"" . $offsetx . "\" x2=\"220\" y2=\"" . $offsetx . "\">blurb</lineitem>";
$items .= "<lineitem x1=\"244\" y1=\"" . $offsetx . "\" x2=\"337\" y2=\"" . $offsetx . "\">blurb</lineitem>";
$items .= "<lineitem x1=\"358\" y1=\"" . $offsetx . "\" x2=\"445\" y2=\"" . $offsetx . "\">blurb</lineitem>";
$items .= "<lineitem x1=\"457\" y1=\"" . $offsetx . "\" x2=\"558\" y2=\"" . $offsetx . "\">blurb</lineitem>";
$this->formArray["kind" . $p] = $machineriesClassesDescription;
$this->formArray["classification" . $p] = $machineriesActualUsesDescription;
$this->formArray["marketValue" . $p] = un_number_format($machineries->getMarketValue());
$this->formArray["assessmentLevel" . $p] = un_number_format($machineries->getAssessmentLevel());
$this->formArray["assessedValue" . $p] = un_number_format($machineries->getAssessedValue());
} else {
if ($this->formArray["p"] > 3) {
if ($this->formArray["kindOthers"] != "") {
$this->formArray["kindOthers"] .= "; ";
}
if ($this->formArray["kindOthers"] == "") {
$this->formArray["kindOthers"] = "Others: ";
}
$this->formArray["kindOthers"] .= $machineriesClassesDescription;
$this->formArray["kindOthers"] .= " MV=P" . formatCurrency($machineries->getMarketValue());
$this->formArray["kindOthers"] .= " AV=P" . formatCurrency($machineries->getAssessedValue());
}
}
$this->formArray["totalMarketValue"] += toFloat($machineries->getMarketValue());
$this->formArray["totalAssessedValue"] += toFloat($machineries->getAssessedValue());
$this->formArray["p"]++;
}
$this->formArray["landitems"] = $items;
}
}
function Main()
{
$RPTOPDetails = new SoapObject(NCCBIZ . "RPTOPDetails.php", "urn:Object");
if (!($xmlStr = $RPTOPDetails->getRPTOP($this->formArray["rptopID"]))) {
exit("xml failed");
} else {
//echo $xmlStr;
if (!($domDoc = domxml_open_mem($xmlStr))) {
$this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock");
$this->tpl->set_var("OwnerListTableBlock", "error xmlDoc");
} else {
$rptop = new RPTOP();
$rptop->parseDomDocument($domDoc);
foreach ($rptop as $key => $value) {
switch ($key) {
case "owner":
//$RPTOPEncode = new SoapObject(NCCBIZ."RPTOPEncode.php", "urn:Object");
if (is_a($value, "Owner")) {
$this->formArray["ownerID"] = $rptop->owner->getOwnerID();
$xmlStr = $rptop->owner->domDocument->dump_mem(true);
if (!$xmlStr) {
$this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock");
$this->tpl->set_var("OwnerListTableBlock", "");
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
$this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock");
$this->tpl->set_var("OwnerListTableBlock", "error xmlDoc");
} else {
$this->displayOwnerList($domDoc);
}
}
} else {
$this->tpl->set_block("rptsTemplate", "PersonList", "PersonListBlock");
$this->tpl->set_var("PersonListBlock", "");
$this->tpl->set_block("rptsTemplate", "CompanyList", "CompanyListBlock");
$this->tpl->set_var("CompanyListBlock", "");
}
break;
case "cityAssessor":
if (is_a($value, Assessor)) {
$this->tpl->set_var("cityAssessorID", $value->getAssessorID());
$this->tpl->set_var("cityAssessorName", $value->getFullName());
$this->formArray["cityAssessorName"] = $value->getFullName();
} else {
$this->tpl->set_var($key, "");
}
break;
case "cityTreasurer":
if (is_a($value, Assessor)) {
$this->tpl->set_var("cityTreasurerID", $value->getAssessorID());
$this->tpl->set_var("cityTreasurerName", $value->getFullName());
$this->formArray["cityTreasurerName"] = $value->getFullName();
} else {
$this->tpl->set_var($key, "");
}
break;
case "tdArray":
$this->tpl->set_block("rptsTemplate", "defaultTDList", "defaultTDListBlock");
$this->tpl->set_block("rptsTemplate", "toggleTDList", "toggleTDListBlock");
$this->tpl->set_block("rptsTemplate", "TDList", "TDListBlock");
$tdCtr = 0;
$totalBalance = 0;
if (count($value)) {
$this->tpl->set_block("rptsTemplate", "TDDBEmpty", "TDDBEmptyBlock");
$this->tpl->set_var("TDDBEmptyBlock", "");
$this->tpl->set_block("TDList", "Land", "LandBlock");
$this->tpl->set_block("TDList", "PlantsTrees", "PlantsTreesBlock");
$this->tpl->set_block("TDList", "ImprovementsBuildings", "ImprovementsBuildingsBlock");
$this->tpl->set_block("TDList", "Machineries", "MachineriesBlock");
foreach ($value as $tkey => $tvalue) {
$propertyType = $tvalue->getPropertyType();
$assessedValue = $tvalue->getAssessedValue();
$afs = new AFS();
$afs->selectRecord($tvalue->getAfsID());
$propertyIndexNumber = $afs->getPropertyIndexNumber();
/*$propertyID = $tvalue->getPropertyID();
switch ($propertyType){
case "Land":
$land = new Land;
$land->selectRecord($propertyID);
$assessedValue = $land->getAssessedValue();
$propertyIdentityNumber = $land->getPropertyIndexNumber();
break;
case "PlantsTrees":
$plantsTrees = new PlantsTrees;
$plantsTrees->selectRecord($propertyID);
$assessedValue = $plantsTrees->getAssessedValue();
$PropertyIndexNumber = $plantsTrees->getPropertyIndexNumber();
break;
case "ImprovementsBuildings":
$improvementsBuildings = new ImprovementsBuildings;
$improvementsBuildings->selectRecord($propertyID);
$assessedValue = $improvementsBuildings->getAssessedValue();
$PropertyIndexNumber = $improvementsBuildings->getPropertyIndexNumber();
break;
case "Machineries":
$machineries = new Machineries;
$machineries->selectRecord($propertyID);
$assessedValue = $machineries->getAssessedValue();
$PropertyIndexNumber = $machineries->getPropertyIndexNumber();
break;
default:
break;
}*/
# set or get the due for this TD
//$taxDue = new Dues();
$taxDue = new Dues($tvalue->getTdID(), $rptop->getTaxableYear(), $assessedValue);
//$taxDue->create($tvalue->getTaxDeclarationNumber(), "Jan 1, ".$rptop->getRptopdate());
//$taxDue->setBasic($assessedValue);
//$taxDue->setSEF($assessedValue);
//$taxDue->store();
$dueValues['basic'] = number_format($taxDue->getBasic(), 2);
$dueValues['penalty'] = number_format($taxDue->getPenalty(), 2);
$dueValues['sef'] = number_format($taxDue->getSEF(), 2);
$dueValues['total'] = number_format($taxDue->getBasic() + $taxDue->getSEF() + $taxDue->getPenalty(), 2);
$this->tpl->set_var($dueValues);
$paidValues['paidBasic'] = number_format($taxDue->getPaidBasic(), 2);
$paidValues['paidPenalty'] = number_format($taxDue->getPaidPenalty(), 2);
$paidValues['paidSEF'] = number_format($taxDue->getPaidSEF(), 2);
$paidValues['paidTotal'] = number_format($taxDue->getPaidBasic() + $taxDue->getPaidPenalty() + $taxDue->getPaidSEF(), 2);
$this->tpl->set_var($paidValues);
$balance = round($taxDue->getBasic(), 2) + round($taxDue->getSEF(), 2) + round($taxDue->getPenalty(), 2) - ($taxDue->getPaidBasic() + $taxDue->getPaidPenalty() + $taxDue->getPaidSEF());
$totalBalance += $balance;
$this->tpl->set_var(balance, number_format(abs($balance), 2));
$totalValues['totAssessedValue'] += $assessedValue;
$totalValues['totBasic'] += round($taxDue->getBasic(), 2);
$totalValues['totPenalty'] += round($taxDue->getPenalty(), 2);
$totalValues['totSEF'] += round($taxDue->getSEF(), 2);
$totalValues['totTotal'] += round($taxDue->getBasic(), 2) + round($taxDue->getPenalty(), 2) + round($taxDue->getSEF(), 2);
$totPaidBasic += $taxDue->getPaidBasic();
$totPaidPenalty += $taxDue->getPaidPenalty();
$totPaidSEF += $taxDue->getPaidSEF();
$totPaidTotal += $taxDue->getPaidBasic() + $taxDue->getPaidPenalty() + $taxDue->getPaidSEF();
$totalValues['totPaidBasic'] = number_format($totPaidBasic, 2);
$totalValues['totPaidPenalty'] = number_format($totPaidPenalty, 2);
$totalValues['totPaidSEF'] = number_format($totPaidSEF, 2);
$totalValues['totPaidTotal'] = number_format($totPaidTotal, 2);
$tdValues['assessedValue'] = number_format($assessedValue, 2);
$tdValues['tdNumber'] = $tvalue->getTaxDeclarationNumber();
$tdValues['propertyIndexNumber'] = $propertyIndexNumber;
$this->tpl->set_var($tdValues);
$this->tpl->set_var("ctr", $tdCtr);
$this->tpl->parse("TDListBlock", "TDList", true);
$tdCtr++;
}
} else {
$this->tpl->set_var("TDListBlock", "");
}
$this->tpl->set_var("tdCtr", $tdCtr);
break;
default:
$this->formArray[$key] = $value;
}
}
}
}
$this->setForm();
$this->tpl->set_var("uname", $this->user["uname"]);
$this->tpl->set_var("today", date("F j, Y"));
$this->setPageDetailPerms();
$this->tpl->set_var(totBalance, number_format(abs($totalBalance), 2));
$this->tpl->set_var(amountDue, number_format(abs($totalValues['totTotal'] - un_number_format($totalValues['totPaidTotal'])), 2));
$totalValues['totAssessedValue'] = number_format($totalValues['totAssessedValue'], 2);
$totalValues['totBasic'] = number_format($totalValues['totBasic'], 2);
$totalValues['totPenalty'] = number_format($totalValues['totPenalty'], 2);
$totalValues['totSEF'] = number_format($totalValues['totSEF'], 2);
$totalValues['totTotal'] = number_format($totalValues['totTotal'], 2);
$totPaidalValues['totPaidBasic'] = number_format($totPaidalValues['totPaidBasic'], 2);
$totPaidalValues['totPaidPenalty'] = number_format($totPaidalValues['totPaidPenalty'], 2);
$totPaidalValues['totPaidSEF'] = number_format($totPaidalValues['totPaidSEF'], 2);
$totPaidalValues['totPaidTotal'] = number_format($totPaidalValues['totPaidTotal'], 2);
$this->tpl->set_var($totalValues);
$this->tpl->set_var("Session", $this->sess->url("") . $this->sess->add_query(array("rptopID" => $this->formArray["rptopID"], "ownerID" => $this->formArray["ownerID"])));
$this->tpl->parse("templatePage", "rptsTemplate");
$this->tpl->finish("templatePage");
$this->tpl->p("templatePage");
}
function displayMachineriesList($machineriesList)
{
if (count($machineriesList)) {
foreach ($machineriesList as $mkey => $machineries) {
// "kind" is assumed to be treated as "classes" for machineries
$machineriesClasses = new MachineriesClasses();
if (is_numeric($machineries->getKind())) {
$machineriesClasses->selectRecord($machineries->getKind());
$machineriesClassesDescription = $machineriesClasses->getDescription();
$machineriesClassesCode = $machineriesClasses->getCode();
} else {
$machineriesClassesDescription = $machineries->getKind();
$machineriesClassesCode = $machineries->getActualUse();
}
// "classification" is assumed to be treated as "actualUse" for machineries
$machineriesActualUses = new MachineriesActualUses();
if (is_numeric($machineries->getActualUse())) {
$machineriesActualUses->selectRecord($machineries->getActualUse());
$machineriesActualUsesDescription = $machineriesActualUses->getDescription();
$machineriesActualUsesCode = $machineriesActualUses->getCode();
} else {
$machineriesActualUsesDescription = $machineries->getActualUse();
$machineriesActualUsesCode = $machineries->getActualUse();
}
if ($this->formArray["p"] <= 24) {
$p = $this->formArray["p"];
$this->formArray["kind" . $p] = $machineriesClassesDescription;
$this->formArray["classification" . $p] = $machineriesActualUsesDescription;
$this->formArray["propertyMarketValue" . $p] = un_number_format($machineries->getAdjustedMarketValue());
$this->formArray["assessmentLevel" . $p] = un_number_format($machineries->getAssessmentLevel());
$this->formArray["assessedValue" . $p] = un_number_format($machineries->getAssessedValue());
$this->formArray["totalMarketValue"] += un_number_format($this->formArray["propertyMarketValue" . $p]);
$this->formArray["totalAssessedValue"] += un_number_format($this->formArray["assessedValue" . $p]);
$this->formArray["p"]++;
}
}
}
}
function Main()
{
switch ($this->formArray["formAction"]) {
case "delete":
//print_r($this->formArray);
if (count($this->formArray["rptopID"]) > 0) {
$RPTOPList = new SoapObject(NCCBIZ . "RPTOPList.php", "urn:Object");
if (!($deletedRows = $RPTOPList->deleteRPTOP($this->formArray["rptopID"]))) {
$this->tpl->set_var("msg", "SOAP failed");
} else {
$this->tpl->set_var("msg", $deletedRows . " records deleted");
}
} else {
$this->tpl->set_var("msg", "0 records deleted");
}
break;
case "updateCalculation":
if (is_array($this->formArray["rptopID"])) {
$RPTOPDetails = new SoapObject(NCCBIZ . "RPTOPDetails.php", "urn:Object");
$AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object");
$DueDetails = new SoapObject(NCCBIZ . "DueDetails.php", "urn:Object");
$DueEncode = new SoapObject(NCCBIZ . "DueEncode.php", "urn:Object");
$DueList = new SoapObject(NCCBIZ . "DueList.php", "urn:Object");
$dueIDArray = array("Annual" => "", "Q1" => "", "Q2" => "", "Q3" => "", "Q4" => "");
$treasurySettings = new TreasurySettings();
$treasurySettings->selectRecord();
$this->formArray["masterBasicTaxRate"] = $treasurySettings->getPctRPTax();
$this->formArray["masterSEFTaxRate"] = $treasurySettings->getPctSEF();
$this->formArray["masterIdleTaxRate"] = $treasurySettings->getPctIdle();
$this->formArray["discountPeriod"] = $treasurySettings->getDiscountPeriod();
$this->formArray["annualDueDate"] = $treasurySettings->getAnnualDueDate();
foreach ($this->formArray["rptopID"] as $rptopID) {
if (!($xmlStr = $RPTOPDetails->getRPTOP($rptopID))) {
// error xmlStr
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
// error domDoc
} else {
$rptop = new RPTOP();
$rptop->parseDomDocument($domDoc);
$this->formArray["taxableYear"] = $rptop->getTaxableYear();
$tdArray = $rptop->getTDArray();
if (is_array($tdArray)) {
foreach ($tdArray as $td) {
$this->formArray["assessedValue"] = "";
$this->formArray["taxability"] = "";
$this->formArray["idle"] = "";
$this->formArray["tdID"] = $td->getTdID();
$this->formArray["dueID"] = "";
$this->formArray["propertyType"] = $td->getPropertyType();
if (!($afsXmlStr = $AFSDetails->getAFS($td->getAfsID()))) {
// error afsXmlStr
} else {
if (!($afsDomDoc = domxml_open_mem($afsXmlStr))) {
// error afsDomDoc
} else {
$afs = new AFS();
$afs->parseDomDocument($afsDomDoc);
$this->formArray["assessedValue"] = $afs->getTotalAssessedValue();
$this->formArray["taxability"] = $afs->getTaxability();
$this->formArray["effectivity"] = $afs->getEffectivity();
$this->formArray["dueDate"] = date("Y-n-d", strtotime($this->formArray["taxableYear"] . "-" . $this->formArray["annualDueDate"]));
if ($this->formArray["propertyType"] == "Land") {
if (is_array($afs->getLandArray())) {
$this->formArray["idle"] = $afs->landArray[0]->getIdle();
}
}
}
}
if (!($dueXmlStr = $DueList->getDueList($td->getTdID(), $rptop->getTaxableYear()))) {
$this->formArray["dueID"] = "";
$dueIDArray["Annual"] = "";
} else {
if (!($dueDomDoc = domxml_open_mem($dueXmlStr))) {
$this->formArray["dueID"] = "";
$dueIDArray["Annual"] = "";
} else {
//print_r(htmlspecialchars($xmlStr));
//exit;
$dueRecords = new DueRecords();
$dueRecords->parseDomDocument($dueDomDoc);
foreach ($dueRecords->getArrayList() as $due) {
foreach ($due as $dueKey => $dueValue) {
switch ($dueKey) {
case "dueType":
$dueIDArray[$dueValue] = $due->getDueID();
break;
}
}
}
$this->formArray["dueID"] = $dueIDArray["Annual"];
}
}
$this->formArray["basicTaxRate"] = $this->formArray["masterBasicTaxRate"];
$this->formArray["sefTaxRate"] = $this->formArray["masterSEFTaxRate"];
$this->formArray["idleTaxRate"] = $this->formArray["masterIdleTaxRate"];
$this->formArray["basicTax"] = un_number_format($this->formArray["assessedValue"]) * $this->formArray["basicTaxRate"];
$this->formArray["sefTax"] = un_number_format($this->formArray["assessedValue"]) * $this->formArray["sefTaxRate"];
// if land->idle is "Yes", compute idleTax, otherwise set idleTax to zero
if ($this->formArray["propertyType"] == "Land") {
if ($this->formArray["idle"] == "Yes") {
$this->formArray["idleTax"] = un_number_format($this->formArray["assessedValue"]) * $this->formArray["idleTaxRate"];
} else {
$this->formArray["idleTax"] = "0.00";
}
}
// if afs->taxability is "Exempt", reset computations to zero.
if ($this->formArray["taxability"] == "Exempt") {
$this->formArray["basicTax"] = "0.00";
$this->formArray["sefTax"] = "0.00";
$this->formArray["idleTax"] = "0.00";
}
if ($dueIDArray["Annual"] != "") {
$dueArray = $this->setDues();
foreach ($dueArray as $due) {
$doc = $due->getDomDocument();
$xmlStr = $doc->dump_mem(true);
if (!($ret = $DueEncode->updateDue($xmlStr))) {
// error update
}
unset($doc);
unset($xmlStr);
}
} else {
$dueArray = $this->setDues();
foreach ($dueArray as $due) {
$doc = $due->getDomDocument();
$xmlStr = $doc->dump_mem(true);
if (!($ret = $DueEncode->saveDue($xmlStr))) {
// error save
}
unset($doc);
unset($xmlStr);
}
}
$this->formArray["taxableYear"] = $rptop->getTaxableYear();
$this->refreshTDHistory($td);
}
}
unset($tdArray);
}
}
}
}
if ($this->formArray["searchKey"] != "") {
$this->formArray["formAction"] = "search";
} else {
$this->formArray["formAction"] = "";
}
header("Location: CalculateRPTOPBatch.php" . $this->sess->url("") . "&page=" . $this->formArray["page"] . "&sortBy=" . $this->formArray["sortBy"] . "&sortOrder=" . $this->formArray["sortOrder"] . "&formAction=" . $this->formArray["formAction"] . "&searchKey=" . $this->formArray["searchKey"]);
exit;
break;
case "search":
$RPTOPList = new SoapObject(NCCBIZ . "RPTOPList.php", "urn:Object");
$this->tpl->set_block("rptsTemplate", "Pages", "PagesBlock");
$this->tpl->set_block("rptsTemplate", "PagesList", "PagesListBlock");
if (!($count = $RPTOPList->getSearchCount($this->formArray["searchKey"]))) {
$this->tpl->set_var("PagesBlock", "");
$this->tpl->set_var("PagesListBlock", "");
$numOfPages = 1;
$this->tpl->set_block("rptsTemplate", "PageNavigator", "PageNavigatorBlock");
$this->tpl->set_var("PageNavigatorBlock", "");
} else {
$numOfPages = ceil($count / PAGE_BY);
// page list nav
$this->formArray["pageLinksInLine"] = 7;
if ($this->formArray["page"] < round($this->formArray["pageLinksInLine"] / 2)) {
$startPageLinks = 1;
} else {
$startPageLinks = $this->formArray["page"] - round($this->formArray["pageLinksInLine"] / 2);
if ($startPageLinks < 1) {
$startPageLinks = 1;
}
}
$endPageLinks = $startPageLinks + ($this->formArray["pageLinksInLine"] - 1);
if ($endPageLinks > $numOfPages) {
$endPageLinks = $numOfPages;
}
for ($i = $startPageLinks; $i <= $endPageLinks; $i++) {
if ($i == $this->formArray["page"]) {
$this->tpl->set_var("pageListPages", "");
$this->tpl->set_var("pageListPagesUrl", "");
$this->tpl->set_var("pageListPaged", $i);
} else {
$this->tpl->set_var("pageListPages", $i);
$this->tpl->set_var("pageListPagesUrl", $i . "&formAction=search&searchKey=" . urlencode($this->formArray["searchKey"]));
$this->tpl->set_var("pageListPaged", "");
}
$this->tpl->parse("PagesListBlock", "PagesList", true);
}
// drop down nav
for ($i = 1; $i <= $numOfPages; $i++) {
if ($i == $this->formArray["page"]) {
$this->tpl->set_var("pages", $i);
$this->tpl->set_var("pagesUrl", $i . "&formAction=search&searchKey=" . urlencode($this->formArray["searchKey"]));
$this->tpl->set_var("paged", "selected");
} else {
$this->tpl->set_var("pages", $i);
$this->tpl->set_var("pagesUrl", $i . "&formAction=search&searchKey=" . urlencode($this->formArray["searchKey"]));
$this->tpl->set_var("paged", "");
}
$this->tpl->parse("PagesBlock", "Pages", true);
}
}
if ($numOfPages == $this->formArray["page"]) {
$this->tpl->set_var("nextTxt", "");
} else {
$this->tpl->set_var("next", $this->formArray["page"] + 1 . "&formAction=search&searchKey=" . urlencode($this->formArray["searchKey"]));
$this->tpl->set_var("nextTxt", "next");
}
if ($this->formArray["page"] == 1) {
$this->tpl->set_var("previousTxt", "");
} else {
$this->tpl->set_var("previous", $this->formArray["page"] - 1 . "&formAction=search&searchKey=" . urlencode($this->formArray["searchKey"]));
$this->tpl->set_var("previousTxt", "previous");
}
$this->tpl->set_var("pageOf", $this->formArray["page"] . " of " . $numOfPages);
$condition = $this->sortBlocks();
if (!($xmlStr = $RPTOPList->searchRPTOP($this->formArray["page"], $condition, $this->formArray["searchKey"]))) {
$this->tpl->set_var("pageOf", "");
$this->tpl->set_block("rptsTemplate", "RPTOPTable", "RPTOPTableBlock");
$this->tpl->set_var("RPTOPTableBlock", "");
$this->tpl->set_block("rptsTemplate", "RPTOPDBEmpty", "RPTOPDBEmptyBlock");
$this->tpl->set_var("RPTOPDBEmptyBlock", "");
$this->tpl->set_block("rptsTemplate", "Pages", "PagesBlock");
$this->tpl->set_var("PagesBlock", "");
$this->tpl->set_var("PagesListBlock", "");
$this->tpl->set_var("previousTxt", "");
$this->tpl->set_var("nextTxt", "");
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
$this->tpl->set_block("rptsTemplate", "RPTOPListTable", "RPTOPListTableBlock");
$this->tpl->set_var("RPTOPListTableBlock", "error xmlDoc");
} else {
$this->tpl->set_block("rptsTemplate", "NotFound", "NotFoundBlock");
$this->tpl->set_var("NotFoundBlock", "");
$rptopRecords = new RPTOPRecords();
$rptopRecords->parseDomDocument($domDoc);
$list = $rptopRecords->getArrayList();
if (count($list)) {
$this->tpl->set_block("rptsTemplate", "RPTOPDBEmpty", "RPTOPDBEmptyBlock");
$this->tpl->set_var("RPTOPDBEmptyBlock", "");
$this->tpl->set_block("rptsTemplate", "RPTOPList", "RPTOPListBlock");
$this->tpl->set_block("RPTOPList", "PersonList", "PersonListBlock");
$this->tpl->set_block("RPTOPList", "CompanyList", "CompanyListBlock");
foreach ($list as $key => $value) {
$this->tpl->set_var("rptopID", $value->getRptopID());
$oValue = $value->owner;
$pOwnerStr = "";
if (count($oValue->personArray)) {
foreach ($oValue->personArray as $pKey => $pValue) {
$this->tpl->set_var("personID", $pValue->getPersonID());
$this->tpl->set_var("OwnerPerson", $pValue->getFullName());
$this->tpl->parse("PersonListBlock", "PersonList", true);
}
}
if (count($oValue->companyArray)) {
foreach ($oValue->companyArray as $cKey => $cValue) {
$this->tpl->set_var("companyID", $cValue->getCompanyID());
$this->tpl->set_var("OwnerCompany", $cValue->getCompanyName());
$this->tpl->parse("CompanyListBlock", "CompanyList", true);
}
}
if (count($oValue->personArray) || count($oValue->companyArray)) {
$this->tpl->set_var("none", "");
} else {
$this->tpl->set_var("none", "none");
}
$this->tpl->set_var("totalMarketValue", number_format($value->getTotalMarketValue(), 2, '.', ','));
$this->tpl->set_var("totalAssessedValue", number_format($value->getTotalAssessedValue(), 2, '.', ','));
$this->tpl->set_var("taxableYear", $value->getTaxableYear());
// grab Dues of rptop to get totalTaxDue
$totalTaxDue = 0.0;
if (is_array($value->tdArray)) {
foreach ($value->tdArray as $td) {
$DueDetails = new SoapObject(NCCBIZ . "DueDetails.php", "urn:Object");
$AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object");
$afsXml = $AFSDetails->getAfs($td->getAfsID());
$afsDomDoc = domxml_open_mem($afsXml);
$afs = new AFS();
$afs->parseDomDocument($afsDomDoc);
if (!($xmlStr = $DueDetails->getDueFromTdID($td->getTdID(), $value->getTaxableYear()))) {
$totalTaxDue = "uncalculated";
break;
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
$totalTaxDue = "uncalculated";
} else {
$due = new Due();
$due->parseDomDocument($domDoc);
$totalTaxDue += $due->getTaxDue();
}
}
}
} else {
$totalTaxDue = "no TD's";
}
if (is_numeric($totalTaxDue)) {
$totalTaxDue = formatCurrency($totalTaxDue);
}
$this->tpl->set_var("totalTaxDue", $totalTaxDue);
$this->setRPTOPListBlockPerms();
$this->tpl->parse("RPTOPListBlock", "RPTOPList", true);
$this->tpl->set_var("PersonListBlock", "");
$this->tpl->set_var("CompanyListBlock", "");
}
} else {
$this->tpl->set_block("rptsTemplate", "RPTOPList", "RPTOPListBlock");
$this->tpl->set_var("RPTOPListBlock", "huh");
}
}
}
break;
case "cancel":
header("location: CalculateRPTOPBatch.php");
exit;
break;
default:
$this->tpl->set_var("msg", "");
$RPTOPList = new SoapObject(NCCBIZ . "RPTOPList.php", "urn:Object");
$this->tpl->set_block("rptsTemplate", "Pages", "PagesBlock");
$this->tpl->set_block("rptsTemplate", "PagesList", "PagesListBlock");
$this->tpl->set_block("rptsTemplate", "NotFound", "NotFoundBlock");
$this->tpl->set_var("NotFoundBlock", "");
if (!($count = $RPTOPList->getRPTOPCount())) {
$this->tpl->set_var("PagesBlock", "");
$this->tpl->set_var("PagesListBlock", "");
$this->tpl->set_block("rptsTemplate", "PageNavigator", "PageNavigatorBlock");
$this->tpl->set_var("PageNavigatorBlock", "");
} else {
$numOfPages = ceil($count / PAGE_BY);
// page list nav
$this->formArray["pageLinksInLine"] = 7;
if ($this->formArray["page"] < round($this->formArray["pageLinksInLine"] / 2)) {
$startPageLinks = 1;
} else {
$startPageLinks = $this->formArray["page"] - round($this->formArray["pageLinksInLine"] / 2);
if ($startPageLinks < 1) {
$startPageLinks = 1;
}
}
$endPageLinks = $startPageLinks + ($this->formArray["pageLinksInLine"] - 1);
if ($endPageLinks > $numOfPages) {
$endPageLinks = $numOfPages;
}
for ($i = $startPageLinks; $i <= $endPageLinks; $i++) {
if ($i == $this->formArray["page"]) {
$this->tpl->set_var("pageListPages", "");
$this->tpl->set_var("pageListPagesUrl", "");
$this->tpl->set_var("pageListPaged", $i);
} else {
$this->tpl->set_var("pageListPages", $i);
$this->tpl->set_var("pageListPagesUrl", $i);
$this->tpl->set_var("pageListPaged", "");
}
$this->tpl->parse("PagesListBlock", "PagesList", true);
}
// drop down nav
for ($i = 1; $i <= $numOfPages; $i++) {
if ($i == $this->formArray["page"]) {
$this->tpl->set_var("pages", $i);
$this->tpl->set_var("pagesUrl", $i);
$this->tpl->set_var("paged", "selected");
} else {
$this->tpl->set_var("pages", $i);
$this->tpl->set_var("pagesUrl", $i);
$this->tpl->set_var("paged", "");
}
$this->tpl->parse("PagesBlock", "Pages", true);
}
}
if ($numOfPages == $this->formArray["page"]) {
$this->tpl->set_var("nextTxt", "");
} else {
$this->tpl->set_var("next", $this->formArray["page"] + 1);
$this->tpl->set_var("nextTxt", "next");
}
if ($this->formArray["page"] == 1) {
$this->tpl->set_var("previousTxt", "");
} else {
$this->tpl->set_var("previous", $this->formArray["page"] - 1);
$this->tpl->set_var("previousTxt", "previous");
}
if ($numOfPages == "") {
$this->tpl->set_var("pageOf", "");
} else {
$this->tpl->set_var("pageOf", $this->formArray["page"] . " of " . $numOfPages);
}
$condition = $this->sortBlocks();
if (!($xmlStr = $RPTOPList->getRPTOPList($this->formArray["page"], $condition))) {
$this->tpl->set_block("rptsTemplate", "RPTOPTable", "RPTOPTableBlock");
$this->tpl->set_var("RPTOPTableBlock", "");
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
$this->tpl->set_block("rptsTemplate", "RPTOPListTable", "RPTOPListTableBlock");
$this->tpl->set_var("RPTOPListTableBlock", "");
} else {
$rptopRecords = new RPTOPRecords();
$rptopRecords->parseDomDocument($domDoc);
$list = $rptopRecords->getArrayList();
if (count($list)) {
$this->tpl->set_block("rptsTemplate", "RPTOPDBEmpty", "RPTOPDBEmptyBlock");
$this->tpl->set_var("RPTOPDBEmptyBlock", "");
$this->tpl->set_block("rptsTemplate", "RPTOPList", "RPTOPListBlock");
$this->tpl->set_block("RPTOPList", "PersonList", "PersonListBlock");
$this->tpl->set_block("RPTOPList", "CompanyList", "CompanyListBlock");
foreach ($list as $key => $value) {
$this->tpl->set_var("rptopID", $value->getRptopID());
$oValue = $value->owner;
$pOwnerStr = "";
if (count($oValue->personArray)) {
foreach ($oValue->personArray as $pKey => $pValue) {
$this->tpl->set_var("personID", $pValue->getPersonID());
$this->tpl->set_var("OwnerPerson", $pValue->getFullName());
$this->tpl->parse("PersonListBlock", "PersonList", true);
}
}
if (count($oValue->companyArray)) {
foreach ($oValue->companyArray as $cKey => $cValue) {
$this->tpl->set_var("companyID", $cValue->getCompanyID());
$this->tpl->set_var("OwnerCompany", $cValue->getCompanyName());
$this->tpl->parse("CompanyListBlock", "CompanyList", true);
}
}
if (count($oValue->personArray) || count($oValue->companyArray)) {
$this->tpl->set_var("none", "");
} else {
$this->tpl->set_var("none", "none");
}
$this->tpl->set_var("totalMarketValue", number_format($value->getTotalMarketValue(), 2, '.', ','));
$this->tpl->set_var("totalAssessedValue", number_format($value->getTotalAssessedValue(), 2, '.', ','));
$this->tpl->set_var("taxableYear", $value->getTaxableYear());
// grab Dues of rptop to get totalTaxDue
$totalTaxDue = 0.0;
if (is_array($value->tdArray)) {
foreach ($value->tdArray as $td) {
$DueDetails = new SoapObject(NCCBIZ . "DueDetails.php", "urn:Object");
$AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object");
$afsXml = $AFSDetails->getAfs($td->getAfsID());
$afsDomDoc = domxml_open_mem($afsXml);
$afs = new AFS();
$afs->parseDomDocument($afsDomDoc);
if (!($xmlStr = $DueDetails->getDueFromTdID($td->getTdID(), $value->getTaxableYear()))) {
$totalTaxDue = "uncalculated";
break;
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
$totalTaxDue = "uncalculated";
} else {
$due = new Due();
$due->parseDomDocument($domDoc);
$totalTaxDue += $due->getTaxDue();
}
}
}
} else {
$totalTaxDue = "no TD's";
}
if (is_numeric($totalTaxDue)) {
$totalTaxDue = formatCurrency($totalTaxDue);
}
$this->tpl->set_var("totalTaxDue", $totalTaxDue);
$this->setRPTOPListBlockPerms();
$this->tpl->parse("RPTOPListBlock", "RPTOPList", true);
$this->tpl->set_var("PersonListBlock", "");
$this->tpl->set_var("CompanyListBlock", "");
}
} else {
$this->tpl->set_block("rptsTemplate", "RPTOPList", "RPTOPListBlock");
$this->tpl->set_var("RPTOPListBlock", "huh");
}
}
}
}
$this->setForm();
$this->setPageDetailPerms();
$this->tpl->set_var("uname", $this->user["uname"]);
$this->tpl->set_var("today", date("F j, Y"));
$this->tpl->set_var("Session", $this->sess->url(""));
$this->tpl->parse("templatePage", "rptsTemplate");
$this->tpl->finish("templatePage");
$this->tpl->p("templatePage");
}
