function recordReceipt($varValues)
{
# create receipt object
$collections = new Collections();
# set the details of the receipt
$collections->setOldReceiptNum($varValues['prevORNum']);
$collections->setRPTOPNum($varValues['rptopNum']);
$tdID = $varValues['tdID'];
$amountPaid = $varValues['amountPaid'];
$isAmnesty = isset($varValues['amnesty']) ? "Yes" : "No";
$proceed = true;
// insert backtaxTD record as a payment
// and FLAG backtaxTD as PAID!!! ;)
if ($_POST["backtaxTDCheckbox"]) {
$backtaxTDID = $_POST['backtaxTDCheckbox'];
$backtaxTD = new BacktaxTD();
$backtaxTD->selectRecord("", $backtaxTDID);
$assessedValue = $backtaxTD->getTotalAssessedValue();
$paymentPeriod = $_POST['paymentPeriod'];
$application = $paymentPeriod;
$penalty = $backtaxTD->getTotalPenalties();
$totalTaxDue = $backtaxTD->getTotalTaxDue();
$totalTaxes = $backtaxTD->getTotalTaxes();
$amountPaid = str_replace(",", "", $amountPaid);
if ($totalTaxDue > $amountPaid) {
// payment is partial
$totalPaid = $backtaxTD->getTotalPaid() + $amountPaid;
$backtaxTD->setTotalPaid($totalPaid);
$backtaxTD->updateRecord();
// FLAG paidStatus as "" (NOT YET FULLY PAID) for backtaxTDRecord
$backtaxTD->updatePaidStatus("");
$amountPaid = 0;
} else {
if ($totalTaxDue <= $amountPaid) {
// payment is full or exceeding full to payoff successive TD's
// FLAG paidStatus as PAID for backtaxTDRecord
$backtaxTD->updatePaidStatus("PAID");
$backtaxTD->setTotalPaid($totalTaxes);
$backtaxTD->updateRecord();
$amountPaid = $amountPaid - $totalTaxDue;
}
}
//Partial payment handler??
$basic = $backtaxTD->getTotalBasicTax();
$sef = $backtaxTD->getTotalSEFTax();
$idle = $backtaxTD->getTotalIdleTax();
$discount = 0;
# record the payments for each receipt
# recomputed instead of getting values from $_POST
# used createRecord
$payments[0] = new Payment("sef");
$payments[0]->setApplication($application);
$payments[0]->createRecord("000");
$payments[0]->setAmount($sef);
$payments[0]->setDiscount("0");
$payments[0]->setPenalty("0");
$payments[0]->setDueID("000");
$payments[0]->setDueType("backtaxTDID-sef,backtaxTDID=" . $backtaxTD->getBacktaxTDID());
$payments[0]->setReceiptNum($varValues['receiptNo']);
$payments[0]->storeRecord();
$collections->addPayment($payments[0]);
$payments[1] = new Payment("basic");
$payments[1]->setApplication($application);
$payments[1]->createRecord("000");
$payments[1]->setAmount($basic);
$payments[1]->setDiscount("0");
$payments[1]->setPenalty("0");
$payments[1]->setDueID("000");
$payments[1]->setDueType("backtaxTD-basic,backtaxTDID=" . $backtaxTD->getBacktaxTDID());
$payments[1]->setReceiptNum($varValues['receiptNo']);
$payments[1]->storeRecord();
$collections->addPayment($payments[1]);
$payments[2] = new Payment("idle");
$payments[2]->setApplication($application);
$payments[2]->createRecord("000");
$payments[2]->setAmount($idle);
$payments[2]->setDiscount("0");
$payments[2]->setPenalty("0");
$payments[2]->setDueID("000");
$payments[2]->setDueType("backtaxTD-idle,backtaxTDID=" . $backtaxTD->getBacktaxTDID());
$payments[2]->setReceiptNum($varValues['receiptNo']);
$payments[2]->storeRecord();
$collections->addPayment($payments[2]);
$payments[3] = new Payment("penalty");
$payments[3]->setApplication($application);
$payments[3]->createRecord("0");
$payments[3]->setAmount($penalty);
$payments[3]->setDiscount("0");
$payments[3]->setPenalty("0");
$payments[3]->setDueID("000");
$payments[3]->setDueType("backtaxTD-penalty,backtaxTDID=" . $backtaxTD->getBacktaxTDID());
$payments[3]->setReceiptNum($varValues['receiptNo']);
$payments[3]->storeRecord();
$collections->addPayment($payments[3]);
$payments[4] = new Payment("pd1185");
$payments[4]->setApplication($application);
$payments[4]->createRecord("000");
$payments[4]->setAmount("0");
$payments[4]->setDiscount("0");
$payments[4]->setPenalty("0");
$payments[4]->setDueID("000");
$payments[4]->setDueType("backtaxTD-pd1185,backtaxTDID=" . $backtaxTD->getBacktaxTDID());
$payments[4]->setReceiptNum($varValues['receiptNo']);
$payments[4]->storeRecord();
$collections->addPayment($payments[4]);
//$taxDue->reapplyPayments();
//$taxDue->store();
//print_r($payments);
if (!$proceed) {
break;
}
}
if (is_array($tdID)) {
foreach ($tdID as $key => $id) {
$td = new TD();
$td->selectRecord($id);
# get assessed value and use it to compute taxes -- 07 Aug 2003
$propertyType = $td->getPropertyType();
$propertyID = $td->getPropertyID();
$assessedValue = number_format($td->getAssessedValue(), 2, ".", "");
$tdNum = $td->getTaxDeclarationNumber();
$collections->setTDNum($tdNum);
# get the specific due by using the tdNum and the date on the RPTOP
$rptop = new RPTOP();
# changed to taxableYear & selected record using rptopID instead of rptopNum
if ($rptop->selectRecord($varValues['rptopID'])) {
$dueDate = $rptop->getTaxableYear();
} else {
# did not find due date in POST
// if there is no valid RPTOP provided, then just use the dueDate
$dueDate = $varValues['dueDate'];
}
$dueDate = $td->getTaxBeginsWithTheYear();
$taxDue = new Dues($id, $dueDate);
/*$taxDue = new Dues();*/
if (!$taxDue->create($id, $dueDate)) {
$taxDue->setBasic($assessedValue);
$taxDue->setSEF($assessedValue);
# check if land is idle, if yes, set assessed value
if ($taxDue->getIdleStatus() == 1) {
$taxDue->setIdle($assessedValue);
$idleStatus = 1;
} else {
$taxDue->setIdle(0);
$idleStatus = 0;
}
}
$paymentPeriod = $taxDue->getPaymentMode();
if ($taxDue->getPctPenalty() > 0 && $paymentPeriod != "Annual") {
$paymentPeriod = "Annual";
}
$application = $paymentPeriod;
if ($application == "Quarter") {
$application = "Q" . ceil(date("n") / 3);
$taxDue->setPaidQuarters(ceil(date("n") / 3));
}
#echo("b=$basic<br>s=$sef<br>i=$idle");
# if amnesty declared, no interest on late payments, set penalty to 0
if (isset($varValues['amnesty']) || $taxDue->getIsDiscount()) {
$taxDue->setAmnesty("Yes");
$taxDue->resetPenalty();
$interest = 0;
} else {
$taxDue->setAmnesty("No");
$interest = $taxDue->getPctPenalty();
}
$penalty = $taxDue->getBalancePenalty($paymentPeriod);
$totalTaxDue = $taxDue->getTotalDue($paymentPeriod);
//Partial payment handler
$basic = $taxDue->getBalanceBasic($paymentPeriod);
$sef = $taxDue->getBalanceSEF($paymentPeriod);
$idle = $taxDue->getBalanceIdle($paymentPeriod);
$discount = $taxDue->getDiscount();
$discountSEF = $taxDue->getIsDiscount() ? $sef * $taxDue->getDiscountPercentage() / 100 : 0;
$discountBasic = $taxDue->getIsDiscount() ? $basic * $taxDue->getDiscountPercentage() / 100 : 0;
if (str_replace(",", "", $amountPaid) < $totalTaxDue) {
$basic = round(str_replace(",", "", $amountPaid) * (($basic - $discountBasic) / $totalTaxDue), 2);
$sef = round(str_replace(",", "", $amountPaid) * (($sef - $discountSEF) / $totalTaxDue), 2);
$idle = round(str_replace(",", "", $amountPaid) * ($idle / $totalTaxDue), 2);
$penalty = round(str_replace(",", "", $amountPaid) * ($penalty / $totalTaxDue), 2);
$proceed = false;
}
# record the payments for each receipt
# recomputed instead of getting values from $_POST
# used createRecord
$payments[0] = new Payment("sef");
$payments[0]->setApplication($application);
$payments[0]->createRecord($taxDue->getDueID());
$payments[0]->setAmount($sef);
$payments[0]->setDiscount($discountSEF);
$payments[0]->setPenalty($sef * $interest);
$payments[0]->setDueID($taxDue->getDueID());
$payments[0]->setDueType("sef");
$payments[0]->setReceiptNum($varValues['receiptNo']);
$payments[0]->storeRecord();
$collections->addPayment($payments[0]);
# $gfTotal = ($basic*0.7)*(1+interest);
# $ibTotal = ($basic*0.15)*(1+interest);
# $cbTotal = ($basic*0.15)*(1+interest);
$payments[1] = new Payment("basic");
$payments[1]->setApplication($application);
$payments[1]->createRecord($taxDue->getDueID());
$payments[1]->setAmount($basic);
$payments[1]->setDiscount($discountBasic);
$payments[1]->setPenalty($basic * $interest);
$payments[1]->setDueID($taxDue->getDueID());
$payments[1]->setDueType("basic");
$payments[1]->setReceiptNum($varValues['receiptNo']);
$payments[1]->storeRecord();
$collections->addPayment($payments[1]);
$payments[2] = new Payment("idle");
$payments[2]->setApplication($application);
$payments[2]->createRecord($taxDue->getDueID());
$payments[2]->setAmount($idle);
$payments[2]->setDiscount(0);
$payments[2]->setPenalty($idle * $interest);
$payments[2]->setDueID($taxDue->getDueID());
$payments[2]->setDueType("idle");
$payments[2]->setReceiptNum($varValues['receiptNo']);
$payments[2]->storeRecord();
$collections->addPayment($payments[2]);
$payments[3] = new Payment("penalty");
$payments[3]->setApplication($application);
$payments[3]->createRecord($taxDue->getDueID());
$payments[3]->setAmount($penalty);
$payments[3]->setDiscount(0);
$payments[3]->setPenalty(0);
$payments[3]->setDueID($taxDue->getDueID());
$payments[3]->setDueType("penalty");
$payments[3]->setReceiptNum($varValues['receiptNo']);
$payments[3]->storeRecord();
$collections->addPayment($payments[3]);
$payments[4] = new Payment("pd1185");
$payments[4]->setApplication($application);
$payments[4]->createRecord($taxDue->getDueID());
$payments[4]->setAmount(round(0, 2));
$payments[4]->setDiscount(0);
$payments[4]->setPenalty(0);
$payments[4]->setDueID($taxDue->getDueID());
$payments[4]->setDueType("pd1185");
$payments[4]->setReceiptNum($varValues['receiptNo']);
# print_r($payments);
$payments[4]->storeRecord();
$collections->addPayment($payments[4]);
$taxDue->reapplyPayments();
$taxDue->store();
if (!$proceed) {
break;
}
}
}
# end foreach
//*
// get parent TD
//$tdID = $backtaxTD->getTDID();
//*/
# set collection details and save to db; no receipt number yet
# format date to db date YYYY-MM-DD
list($month, $day, $year) = explode("-", $varValues['checkDate']);
list($oldReceiptMonth, $oldReceiptDay, $oldReceiptYear) = explode("-", $varValues['prevORDate']);
$collections->setCollectionDate(date("Y-m-d"));
$collections->setCollectionSum($varValues['collectionSum']);
$collections->setReceivedFrom($varValues['receivedFrom']);
$collections->setKindOfPayment($varValues['kindOfPayment']);
$collections->setCheckNum($varValues['checkNum']);
$collections->setCheckDate($year . "-" . $month . "-" . $day);
$collections->setOldReceiptNum($varValues['prevORNum']);
$collections->setOldReceiptDate($oldReceiptYear . "-" . $oldReceiptMonth . "-" . $oldReceiptDay);
$collections->setMunicipality($varValues['municipalityCityID']);
$collections->setAmnesty($isAmnesty);
$collections->createRecord();
$collections->storeRecord();
# get collection id and use it to close receipt
$collectionID = $collections->getCollectionID();
$_POST['collectionID'] = $collectionID;
}
function displayBacktaxTD($tdID)
{
$BacktaxTDDetails = new SoapObject(NCCBIZ . "BacktaxTDDetails.php", "urn:Object");
if (!($xmlStr = $BacktaxTDDetails->getBacktaxTD($tdID))) {
$this->tpl->set_var("BacktaxTDTableBlock", "");
$this->backtaxTDExists = false;
return false;
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
$this->tpl->set_var("BacktaxTDTableBlock", "");
$this->backtaxTDExists = false;
return false;
} else {
$backtaxTD = new BacktaxTD();
$backtaxTD->parseDomDocument($domDoc);
$backtaxTDID = $backtaxTD->getBacktaxTDID();
$paidStatus = $backtaxTD->getPaidStatus();
if ($paidStatus == "PAID") {
return false;
}
$tdID = $backtaxTD->getTdID();
$yearRange = $backtaxTD->getStartYear() . " - " . $backtaxTD->getEndYear();
$totalAssessedValue = $backtaxTD->getAssessedValue();
$totalBasicTax = $backtaxTD->getBasicTax();
$totalSEFTax = $backtaxTD->getSefTax();
$totalPenalties = $backtaxTD->getPenalties();
$totalIdleTax = $backtaxTD->getIdleTax();
$totalPaid = $backtaxTD->getPaid();
$totalBacktaxDue = $backtaxTD->getTotalTaxDue();
$totalTaxes = 0;
$totalTaxes += $totalBasicTax;
$totalTaxes += $totalSEFTax;
$totalTaxes += $totalPenalties;
$totalTaxes += $totalIdleTax;
$this->tpl->set_var("backtaxTDID", $backtaxTDID);
$this->tpl->set_var("tdID", $tdID);
$this->tpl->set_var("yearRange", $yearRange);
$this->tpl->set_var("totalTaxes", number_format($totalTaxes, 2));
//$this->tpl->set_var("totalBacktaxAssessedValue", number_format($totalAssessedValue,2));
//$this->tpl->set_var("totalBasicTax", number_format($totalBasicTax,2));
//$this->tpl->set_var("totalSEFTax", number_format($totalSEFTax,2));
//$this->tpl->set_var("totalPenalties", number_format($totalPenalties,2));
//$this->tpl->set_var("totalIdleTax", number_format($totalIdleTax,2));
$this->tpl->set_var("totalPaid", number_format($totalPaid, 2));
$this->tpl->set_var("totalBacktaxDue", $totalBacktaxDue);
$this->tpl->set_var("totalBacktaxDueStr", number_format($totalBacktaxDue, 2));
$this->tpl->parse("BacktaxTDTableBlock", "BacktaxTDTable", true);
$this->backtaxTDExists = true;
return true;
}
}
}
