function displayBacktaxTD($ownerSwitch = false) { $backtaxTDID = $_POST['backtaxTDCheckbox']; $backtaxTD = new BacktaxTD(); $backtaxTD->selectRecord("", $backtaxTDID); // get parent TD $tdID = $backtaxTD->getTDID(); if ($ownerSwitch != true) { $rptopID = isset($_POST['rptopID']) ? $_POST['rptopID'] : $_GET['rptopID']; $rptop = new RPTOP(); $rptop->selectRecord($rptopID); $owner = $rptop->getOwner(); $personArray = $owner->getPersonArray(); if (is_array($personArray)) { foreach ($personArray as $person) { $ownerValues['ownerKey'] = "personID"; $ownerValues['ownerScript'] = "PersonDetails.php"; $ownerValues['ownerID'] = $person->getPersonID(); $ownerValues['ownerName'] = $person->getLastName() . ", " . $person->getFirstName() . " " . $person->getMiddleName(); $this->tpl->set_var($ownerValues); $this->tpl->parse('Owners', 'Owner', 'true'); } } $companyArray = $owner->getCompanyArray(); if (is_array($companyArray)) { foreach ($companyArray as $company) { $ownerValues['cownerKey'] = "companyID"; $ownerValues['cownerScript'] = "CompanyDetails.php"; $ownerValues['cownerID'] = $company->getCompanyID(); $ownerValues['cownerName'] = $company->getCompanyName(); $this->tpl->set_var($ownerValues); $this->tpl->parse('Owners', 'Owner', 'true'); } } if (is_array($personArray)) { if (count($personArray) > 1) { $receivedFrom = $personArray[0]->getFirstName() . " " . $personArray[0]->getMiddleName() . " " . $personArray[0]->getLastName() . " et al."; } else { $receivedFrom = $personArray[0]->getFirstName() . " " . $personArray[0]->getMiddleName() . " " . $personArray[0]->getLastName(); } } else { if (is_array($companyArray)) { if (count($companyArray) > 1) { $receivedFrom = $companyArray[0]->getCompanyName() . " et al."; } else { $receivedFrom = $companyArray[0]->getCompanyName(); } } } $this->tpl->set_var('receivedFrom', $receivedFrom); } $this->tpl->set_var("lotAddress", ""); $this->tpl->set_var("idleStatus", ""); $this->tpl->set_var("tdNum", ""); $this->tpl->set_var("assessedValueLand", ""); $this->tpl->set_var("assessedValueOthers", ""); $this->tpl->set_var("num", ""); $this->tpl->set_var("partialPmt", ""); $this->tpl->set_var("fullPmt", ""); $this->tpl->set_var("penalty", ""); $assessedValue = $backtaxTD->getTotalAssessedValue(); $subTotal = $backtaxTD->getTotalTaxDue(); $this->tpl->set_var("assessedValue", number_format($assessedValue, 2)); $this->tpl->set_var("subTotal", number_format($subTotal, 2)); $this->tpl->set_var("grandTotal", number_format($subTotal, 2)); $this->tpl->parse("Properties", "Property", true); return $backtaxTD->getTotalTaxDue(); }
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 Main() { switch ($this->formArray["formAction"]) { case "save": $BacktaxTDEncode = new SoapObject(NCCBIZ . "BacktaxTDEncode.php", "urn:Object"); if ($this->formArray["backtaxTDID"] != "") { $BacktaxTDDetails = new SoapObject(NCCBIZ . "BacktaxTDDetails.php", "urn:Object"); if (!($xmlStr = $BacktaxTDDetails->getBacktaxTD2($this->formArray["backtaxTDID"]))) { $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 { $backtaxTD = new BacktaxTD(); $backtaxTD->parseDomDocument($domDoc); $backtaxTD->setBacktaxTDID($this->formArray["backtaxTDID"]); $backtaxTD->setTDID($this->formArray["tdID"]); $backtaxTD->setTdNumber($this->formArray["tdNumber"]); $backtaxTD->setStartYear($this->formArray["startYear"]); $backtaxTD->setEndYear($this->formArray["startYear"]); $backtaxTD->setStartQuarter($this->formArray["startQuarter"]); $backtaxTD->setAssessedValue($this->formArray["assessedValue"]); $backtaxTD->setBasicRate($this->formArray["basicRate"]); $backtaxTD->setSefRate($this->formArray["sefRate"]); $backtaxTD->setBasicTax($this->formArray["basicTax"]); $backtaxTD->setSefTax($this->formArray["sefTax"]); $backtaxTD->setIdleTax($this->formArray["idleTax"]); $backtaxTD->setPenalties($this->formArray["penalties"]); $backtaxTD->setPaid($this->formArray["paid"]); $backtaxTD->setBalance($this->formArray["balance"]); $backtaxTD->setModifiedBy($this->userID); //$backtaxTD->setPaidStatus($this->formArray["paidStatus"]); //$backtaxTD->setTotal($this->formArray["total"]); $backtaxTD->setDomDocument(); $doc = $backtaxTD->getDomDocument(); $xmlStr = $doc->dump_mem(true); if (!($ret = $BacktaxTDEncode->updateBacktaxTD($xmlStr))) { exit("error update"); } } } } else { $startYear = $this->formArray["startYear"]; //print_r($startYear); //exit; ///* $endYear = $this->formArray["endYear"]; //echo($startYear."->".$endYear); sort($startYear, SORT_NUMERIC); //print_r($startYear); //exit; foreach ($startYear as $key => $value) { //for ($i = $startYear; $i<=$endYear; $i++){ //echo $i."<br>"; ///* $backtaxTD = new BacktaxTD(); $backtaxTD->selectRecord($this->formArray["backtaxTDID"]); //$backtaxTD->parseDomDocument($domDoc); $backtaxTD->setBacktaxTDID($this->formArray["backtaxTDID"]); $backtaxTD->setTDID($this->formArray["tdID"]); $backtaxTD->setTdNumber($this->formArray["tdNumber"]); $backtaxTD->setStartYear($value); $backtaxTD->setEndYear($value); $quarter = $key == 0 ? $this->formArray["startQuarter"] : 1; $backtaxTD->setStartQuarter($quarter); $backtaxTD->setAssessedValue($this->formArray["assessedValue"]); $backtaxTD->setBasicRate($this->formArray["basicRate"]); $backtaxTD->setSefRate($this->formArray["sefRate"]); $backtaxTD->setBasicTax($this->formArray["basicTax"]); $backtaxTD->setSefTax($this->formArray["sefTax"]); $backtaxTD->setIdleTax($this->formArray["idleTax"]); $backtaxTD->setPenalties($this->formArray["penalties"]); $paid = $key == 0 ? $this->formArray["paid"] : 0; $backtaxTD->setPaid($paid); $backtaxTD->setBalance($backtaxTD->getTotalTaxDue()); $backtaxTD->setCreatedBy($this->userID); //$backtaxTD->setPaidStatus($this->formArray["paidStatus"]); //$backtaxTD->setTotal($this->formArray["total"]); $backtaxTD->setDomDocument(); $doc = $backtaxTD->getDomDocument(); $xmlStr = $doc->dump_mem(true); //echo $i." - ".$xmlStr."<br>"; if (!($ret = $BacktaxTDEncode->saveBacktaxTD($xmlStr))) { echo "Error saving"; } } //*/ } //exit; $this->formArray["backtaxTDID"] = $ret; header("location: BacktaxTDClose.php" . $this->sess->url("") . $this->sess->add_query(array("afsID" => $this->formArray["afsID"]))); exit($ret); break; default: if ($this->formArray["backtaxTDID"]) { $BacktaxTDDetails = new SoapObject(NCCBIZ . "BacktaxTDDetails.php", "urn:Object"); if (!($xmlStr = $BacktaxTDDetails->getBacktaxTD2($this->formArray["backtaxTDID"]))) { echo "xml failed"; } else { //echo $xmlStr; if (!($domDoc = domxml_open_mem($xmlStr))) { // } else { $backtaxTD = new BacktaxTD(); $backtaxTD->parseDomDocument($domDoc); foreach ($backtaxTD as $key => $value) { switch ($key) { default: $this->formArray[$key] = $value; } } } } } } $this->setForm(); $this->tpl->set_var("Session", $this->sess->url("") . $this->sess->add_query(array("tdID" => $this->formArray["tdID"], "afsID" => $this->formArray["afsID"]))); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); }
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; } } }