function purge()
{
$rptsDB = new DB_RPTS();
$rptsDB2 = new DB_RPTS();
$sqlselect = "SELECT collectionID FROM collections WHERE receiptNum = '' OR receiptNum is NULL;";
$rptsDB->query($sqlselect);
$due = new Dues();
while ($rptsDB->next_record()) {
$collectionID = $rptsDB->f("collectionID");
$this->collectionID = $collectionID;
$this->isStoredInDatabase = true;
$sqlselect2 = "select payments.paymentID, payments.dueID from payments \n \t\t\t\t\t\tinner join collectionPayments on payments.paymentID=collectionPayments.paymentID \n where collectionPayments.collectionID ={$collectionID}";
#echo("$sqlselect2<br>");
$rptsDB2->query($sqlselect2);
$payment = new Payment();
while ($rptsDB2->next_record()) {
$payment->setPaymentID($rptsDB2->f("paymentID"));
$payment->selectRecord();
// if Payment is BacktaxTD, FLAG BacktaxTD paidStatus as '' for false / UNPAID
if ($strstr = strstr($payment->dueType, ",")) {
$backtaxTDID = strstr($strstr, "=");
$backtaxTDID = str_replace("=", "", $backtaxTDID);
$backtaxTD = new BacktaxTD();
$backtaxTD->selectRecord("", $backtaxTDID);
$backtaxTD->setBacktaxTDID($backtaxTDID);
$backtaxTD->setTotalPaid(0);
$backtaxTD->updatePaidStatus("");
$backtaxTD->updateRecord();
}
$dueID = $rptsDB2->f("dueID");
$due->setDueID($dueID);
$due->select();
$due->resetPayments();
$due->store();
}
if (!$this->deleteRecord()) {
return false;
}
}
return true;
}
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;
}