function Main() { $RPUEncode = new SoapObject(NCCBIZ . "RPUEncode.php", "urn:Object"); if (!($newOdID = $RPUEncode->CreateNewRPU_AFS_TD($this->formArray["odID"], $this->formArray["uid"], $this->formArray["transactionCode"]))) { echo $this->formArray["odID"] . "<br>"; exit("create failed"); } else { $ODList = new SoapObject(NCCBIZ . "ODList.php", "urn:Object"); $archiveValue = "true"; $userID = $this->formArray["uid"]; $odIDArray[] = $this->formArray["odID"]; if (!($archiveRows = $ODList->archiveOD($odIDArray, $archiveValue, $userID))) { exit("archive failed"); } else { $this->formArray["odID"] = $newOdID; $AFSEncode = new SoapObject(NCCBIZ . "AFSEncode.php", "urn:Object"); if ($newAfsID = $AFSEncode->getAfsID($newOdID)) { $this->formArray["afsID"] = $newAfsID; header("location: AFSDetails.php" . $this->sess->url("") . "&odID=" . $newOdID . "&afsID=" . $newAfsID . "&transactionCode=" . $this->formArray["transactionCode"]); } else { header("location: ODDetails.php" . $this->sess->url("") . "&odID=" . $newOdID); } } } $this->tpl->set_var("Session", $this->sess->url("") . $this->sess->add_query(array("odID" => $this->formArray["odID"], "ownerID" => $this->formArray["ownerID"]))); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); }
function Main() { $this->tpl->set_block("rptsTemplate", "MunicipalityCityList", "MunicipalityCityListBlock"); $MunicipalityCityList = new SoapObject(NCCBIZ . "MunicipalityCityList.php", "urn:Object"); if (!($xmlStr = $MunicipalityCityList->getMunicipalityCityList(0, " WHERE " . MUNICIPALITYCITY_TABLE . ".status='active'"))) { $this->tpl->set_var("municipalityCityID", ""); $this->tpl->set_var("description", "empty list"); $this->tpl->parse("MunicipalityCityListBlock", "MunicipalityCityList", true); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { $this->tpl->set_var("municipalityCityID", ""); $this->tpl->set_var("description", "empty list"); $this->tpl->parse("MunicipalityCityListBlock", "MunicipalityCityList", true); } else { $municipalityCityRecords = new MunicipalityCityRecords(); $municipalityCityRecords->parseDomDocument($domDoc); $list = $municipalityCityRecords->getArrayList(); foreach ($list as $municipalityCity) { $this->tpl->set_var("municipalityCityID", $municipalityCity->getMunicipalityCityID()); $this->tpl->set_var("description", $municipalityCity->getDescription()); $this->tpl->parse("MunicipalityCityListBlock", "MunicipalityCityList", true); } } } $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("Session", $this->sess->url("")); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); }
function initBarangayList() { $this->tpl->set_block("rptsTemplate", "BarangayList", "BarangayListBlock"); $BarangayList = new SoapObject(NCCBIZ . "BarangayList.php", "urn:Object"); if (!($xmlStr = $BarangayList->getBarangayList(0, " WHERE " . BARANGAY_TABLE . ".status='active' ORDER BY description"))) { $this->tpl->set_var("barangayID", ""); $this->tpl->set_var("barangay", "empty barangay list"); $this->tpl->parse("BarangayListBlock", "BarangayList", true); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { $this->tpl->set_var("barangayID", ""); $this->tpl->set_var("barangay", "empty barangay list"); $this->tpl->parse("BarangayListBlock", "BarangayList", true); } else { $barangayRecords = new BarangayRecords(); $barangayRecords->parseDomDocument($domDoc); if (is_array($barangayRecords->arrayList)) { foreach ($barangayRecords->arrayList as $key => $value) { $this->tpl->set_var("barangayID", $value->getBarangayID()); $this->tpl->set_var("barangay", $value->getDescription()); $this->tpl->parse("BarangayListBlock", "BarangayList", true); } } } } }
function Main() { switch ($this->formArray["formAction"]) { case "delete": if (count($this->formArray["propAssessKindsID"]) > 0) { $PropAssessKindsList = new SoapObject(NCCBIZ . "PropAssessKindsList.php", "urn:Object"); if (!($deletedRows = $PropAssessKindsList->deletePropAssessKinds($this->formArray["propAssessKindsID"]))) { $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 "activate": $PropAssessKindsList = new SoapObject(NCCBIZ . "PropAssessKindsList.php", "urn:Object"); if (!($activeRows = $PropAssessKindsList->updateStatus($this->formArray["status"]))) { $this->tpl->set_var("msg", "All records have status made <i>inactive</i>"); } else { $this->tpl->set_var("msg", $activeRows . " records have status made <i>active</i>"); } break; case "cancel": header("location: PropAssessKindsList.php"); exit; break; default: $this->tpl->set_var("msg", ""); } $PropAssessKindsList = new SoapObject(NCCBIZ . "PropAssessKindsList.php", "urn:Object"); if (!($xmlStr = $PropAssessKindsList->getPropAssessKindsList())) { $this->tpl->set_block("rptsTemplate", "Table", "TableBlock"); $this->tpl->set_var("TableBlock", "database is empty"); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { $this->tpl->set_block("rptsTemplate", "Table", "TableBlock"); $this->tpl->set_var("TableBlock", "error xmlDoc"); } else { $propAssessKindsRecords = new PropAssessKindsRecords(); $propAssessKindsRecords->parseDomDocument($domDoc); $list = $propAssessKindsRecords->getArrayList(); $this->tpl->set_block("rptsTemplate", "PropAssessKindsList", "PropAssessKindsListBlock"); foreach ($list as $key => $listValue) { $this->tpl->set_var("propAssessKindsID", $listValue->getPropAssessKindsID()); $this->tpl->set_var("code", $listValue->getCode()); $this->tpl->set_var("description", $listValue->getDescription()); $this->tpl->set_var("value", $listValue->getValue()); $this->tpl->set_var("status", $listValue->getStatus()); $this->tpl->set_var("statusCheck", $this->getStatusCheck($listValue->getStatus())); $this->tpl->parse("PropAssessKindsListBlock", "PropAssessKindsList", true); } } } $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); }
function Main($referer = "") { if (!$referer || !isset($referer)) { $referer = "OwnerList.php"; } $this->tpl->set_var("referer", $referer); switch ($this->formArray["formAction"]) { case "save" || "view" || "viewOnly": $this->tpl->set_var("referer", $referer); $CompanyDetails = new SoapObject(NCCBIZ . "CompanyDetails.php", "urn:Object"); if (!($xmlStr = $CompanyDetails->getCompanyDetails($this->formArray["companyID"]))) { $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 { $company = new Company(); $company->parseDomDocument($domDoc); $this->formArray["companyID"] = $company->getCompanyID(); $this->formArray["companyName"] = $company->getCompanyName(); $this->formArray["tin"] = $company->getTin(); $this->formArray["telephone"] = $company->getTelephone(); $this->formArray["fax"] = $company->getFax(); $address = $company->addressArray[0]; if (is_a($address, Address)) { $this->formArray["addressID"] = $address->getAddressID(); $this->formArray["number"] = $address->getNumber(); $this->formArray["street"] = $address->getStreet(); $this->formArray["barangay"] = $address->getBarangay(); $this->formArray["district"] = $address->getDistrict(); $this->formArray["municipalityCity"] = $address->getMunicipalitycity(); $this->formArray["province"] = $address->getProvince(); } $this->formArray["email"] = $company->getEmail(); $this->formArray["website"] = $company->getWebsite(); } } if ($this->formArray["formAction"] == "viewOnly") { $this->tpl->set_block("rptsTemplate", "ViewOnly", "ViewOnlyBlock"); $this->tpl->set_var("ViewOnlyBlock", ""); } break; case "cancel": //header("location: CompanyList.php"); exit; break; default: $this->tpl->set_block("rptsTemplate", "ACK", "ACKBlock"); $this->tpl->set_var("ACKBlock", ""); } //*/ $this->setForm(); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); }
function Main() { switch ($this->formArray["formAction"]) { case "save": $AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object"); if (!($xmlStr = $AFSDetails->getAFS($this->formArray["afsID"]))) { exit("error xml"); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { exit("error domDoc"); } else { $AFSEncode = new SoapObject(NCCBIZ . "AFSEncode.php", "urn:Object"); $afs = new AFS(); $afs->parseDomDocument($domDoc); $afs->setArpNumber($this->formArray["arpNumber"]); $afs->setPropertyIndexNumber($this->formArray["propertyIndexNumber"]); $afs->setTaxability($this->formArray["taxability"]); $afs->setEffectivity($this->formArray["effectivity"]); $afs->setDomDocument(); $doc = $afs->getDomDocument(); $xmlStr = $doc->dump_mem(true); if (!($ret = $AFSEncode->updateAFS($xmlStr))) { exit("error update"); } } } header("location: RPUIdentificationClose.php" . $this->sess->url("") . $this->sess->add_query(array("afsID" => $this->formArray["afsID"]))); exit; break; default: $AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object"); $AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object"); if (!($xmlStr = $AFSDetails->getAFS($this->formArray["afsID"]))) { exit("error xml"); } else { //echo $xmlStr; if (!($domDoc = domxml_open_mem($xmlStr))) { exit("error domDoc"); } else { $afs = new AFS(); $afs->parseDomDocument($domDoc); $this->formArray["afsID"] = $afs->getAfsID(); $this->formArray["arpNumber"] = $afs->getArpNumber(); $this->formArray["taxability"] = $afs->getTaxability(); $this->formArray["effectivity"] = $afs->getEffectivity(); $this->formArray["propertyIndexNumber"] = $afs->getPropertyIndexNumber(); } } break; } $this->setForm(); $this->tpl->set_var("Session", $this->sess->url("") . $this->sess->add_query(array("afsID" => $this->formArray["afsID"]))); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); }
function Main() { switch ($this->formArray["formAction"]) { case "delete": //print_r($this->formArray); if (count($this->formArray["companyID"]) > 0) { $CompanyList = new SoapObject(NCCBIZ . "CompanyList.php", "urn:Object"); if (!($deletedRows = $CompanyList->deleteCompany($this->formArray["companyID"]))) { $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 "cancel": header("location: CompanyList.php"); exit; break; default: $this->tpl->set_var("msg", ""); } $CompanyList = new SoapObject(NCCBIZ . "CompanyList.php", "urn:Object"); if (!($xmlStr = $CompanyList->getCompanyList())) { $this->tpl->set_block("rptsTemplate", "Table", "TableBlock"); $this->tpl->set_var("TableBlock", "database empty"); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { $this->tpl->set_block("rptsTemplate", "Table", "TableBlock"); $this->tpl->set_var("TableBlock", "error xmlDoc"); } else { $companyRecords = new CompanyRecords(); $companyRecords->parseDomCompanyRecords($domDoc); $list = $companyRecords->getCompanyList(); $this->tpl->set_block("rptsTemplate", "CompanyList", "CompanyListBlock"); foreach ($list as $key => $value) { $this->tpl->set_var("companyID", $value->getCompanyID()); if (!($cname = $value->getCompanyName())) { $cname = "none"; } $this->tpl->set_var("companyName", $cname); $this->tpl->set_var("tin", $value->getTin()); $this->tpl->set_var("telephone", $value->getTelephone()); $this->tpl->set_var("fax", $value->getFax()); $this->tpl->parse("CompanyListBlock", "CompanyList", true); } } } $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); }
function Main() { switch ($this->formArray["formAction"]) { case "delete": if (count($this->formArray["personID"]) > 0) { $PersonList = new SoapObject(NCCBIZ . "PersonList.php", "urn:Object"); if (!($deletedRows = $PersonList->deletePerson($this->formArray["personID"]))) { $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 "cancel": header("location: PersonList.php"); exit; break; default: $this->tpl->set_var("msg", ""); } $PersonList = new SoapObject(NCCBIZ . "PersonList.php", "urn:Object"); if (!($xmlStr = $PersonList->getPersonList())) { $this->tpl->set_block("rptsTemplate", "Table", "TableBlock"); $this->tpl->set_var("TableBlock", "database empty"); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { $this->tpl->set_block("rptsTemplate", "Table", "TableBlock"); $this->tpl->set_var("TableBlock", "error xmlDoc"); } else { $personRecords = new PersonRecords(); $personRecords->parseDomDocument($domDoc); $list = $personRecords->getArrayList(); $this->tpl->set_block("rptsTemplate", "PersonList", "PersonListBlock"); foreach ($list as $key => $value) { $this->tpl->set_var("personID", $value->getPersonID()); if (!($pname = $value->getFullName())) { $pname = "none"; } $this->tpl->set_var("fullName", $pname); $this->tpl->set_var("tin", $value->getTin()); $this->tpl->set_var("telephone", $value->getTelephone()); $this->tpl->set_var("mobileNumber", $value->getMobileNumber()); $this->tpl->parse("PersonListBlock", "PersonList", true); } } } $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); }
function Main() { $RPUEncode = new SoapObject(NCCBIZ . "RPUEncode.php", "urn:Object"); //if($RPUEncode->isRPUOkForCancellation($this->formArray["odID"])){ $RPUEncode->cancelRPU($this->formArray["odID"], $this->formArray["uid"], "CA"); //} //else{ // header("location: ODDetails.php".$this->sess->url("")."&odID=".$this->formArray["odID"]."&transactionCode=&formAction=cancelError"); // exit; //} header("location: ODDetails.php" . $this->sess->url("") . "&odID=" . $this->formArray["odID"] . "&transactionCode=" . $this->formArray["transactionCode"]); exit; }
function Main() { $fp = fopen("batchCalculate.log", "w") or die("Couldn't create new file"); $rptopID = isset($_POST['rptopID']) ? $_POST['rptopID'] : $_GET['rptopID']; if (is_array($rptopID)) { foreach ($rptopID as $key => $id) { $RPTOPDetails = new SoapObject(NCCBIZ . "RPTOPDetails.php", "urn:Object"); if (!($xmlStr = $RPTOPDetails->getRPTOP($id))) { exit("xml failed"); } else { fwrite($fp, "\r\nrptopid: " . $id . "\r\n"); if (!($domDoc = domxml_open_mem($xmlStr))) { echo "error xmlDoc"; } else { $rptop = new RPTOP(); $td = new TD(); $rptop->parseDomDocument($domDoc); foreach ($rptop as $key => $rvalue) { if ($key == "tdArray") { $tdCtr = 0; if (count($rvalue)) { foreach ($rvalue as $tkey => $tvalue) { $td->selectRecord($tvalue->getTdID()); $assessedValue = number_format($td->getAssessedValue(), 2, ".", ""); $taxDue = new Dues($tvalue->getTdID(), $rptop->getTaxableYear()); $taxDue->setBasic($assessedValue); $taxDue->setSEF($assessedValue); $taxDue->setIdleStatus($idleStatus); if ($taxDue->getIdleStatus()) { $taxDue->setIdle($assessedValue); } else { $taxDue->setIdle(0); } $taxDue->store(); echo $id; echo "=>"; echo $tvalue->getTdID(); echo "<br>"; fwrite($fp, "TD: " . $tvalue->getTdID() . "...PROCESSED COMPLETE\r\n"); $tdCtr++; } } } } } } } header("Location: batchCalculateDone.php" . $this->sess->url("")); exit; } }
function getAFSDetails($odID) { $AFSEncode = new SoapObject(NCCBIZ . "AFSEncode.php", "urn:Object"); $this->formArray["afsID"] = $AFSEncode->getAFSID($odID); if ($this->formArray["afsID"]) { $afs = new AFS(); if ($afs->selectRecord($this->formArray["afsID"])) { return $afs; } else { return false; } } else { return false; } }
protected function getAttributeType($attributeName) { switch ($attributeName) { default: return parent::getAttributeType($attributeName); } }
function Main() { $RPUEncode = new SoapObject(NCCBIZ . "RPUEncode.php", "urn:Object"); if (!($newOdID = $RPUEncode->CreateNewRPU_AFS_TD($this->formArray["odID"]))) { echo $this->formArray["odID"] . "<br>"; exit("create failed"); } else { $this->formArray["odID"] = $newOdID; header("location: ODDetails.php" . $this->sess->url("") . $this->sess->add_query(array("odID" => $this->formArray["odID"]))); } $this->setForm(); $this->tpl->set_var("Session", $this->sess->url("") . $this->sess->add_query(array("odID" => $this->formArray["odID"], "ownerID" => $this->formArray["ownerID"]))); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); }
function Main() { switch ($this->formArray["formAction"]) { case "run": $RPUEncode = new SoapObject(NCCBIZ . "RPUEncode.php", "urn:Object"); $ODList = new SoapObject(NCCBIZ . "ODList.php", "urn:Object"); $oldOdIDList = $ODList->getLatestActiveODList(); if (count($oldOdIDList) > 0) { foreach ($oldOdIDList as $key => $odID) { $newOdIDList[] = $RPUEncode->RunGeneralRevision($odID, $this->userID, "GR"); } $totalArchived = count($oldOdIDList); $totalCreated = count($newOdIDList); $url = "GeneralRevision.php" . $this->sess->url("") . "&formAction=done&totalArchived=" . $totalArchived . "&totalCreated=" . $totalCreated; header("Location: " . $url); exit; } else { $message = "Error. No RPUs to run General Revision."; $this->tpl->set_var("message", $message); } break; case "done": $this->tpl->set_block("rptsTemplate", "FormButton", "FormButtonBlock"); $this->tpl->set_var("FormButtonBlock", ""); $message = "General Revision successfully completed.<br><br>"; $message .= "<br>RPUs Archived: " . $this->formArray["totalArchived"]; $message .= "<br>RPUs Created: " . $this->formArray["totalCreated"]; $this->tpl->set_var("message", $message); break; default: $ODList = new SoapObject(NCCBIZ . "ODList.php", "urn:Object"); $oldOdIDList = $ODList->getLatestActiveODList(); $message = "Latest Active RPUs :" . count($oldOdIDList); $message .= "<br>"; $messaeg = ""; $this->tpl->set_var("message", $message); //print_r($oldOdIDList); //echo "google!"; break; } $this->tpl->set_var("Session", $this->sess->url("")); $this->tpl->set_var("uname", $this->user["uname"]); $this->tpl->set_var("today", date("F j, Y")); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); }
function setLguDetails() { $eRPTSSettingsDetails = new SoapObject(NCCBIZ . "eRPTSSettingsDetails.php", "urn:Object"); if (!($xmlStr = $eRPTSSettingsDetails->getERPTSSettingsDetails(1))) { $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 { $erptsSettings = new eRPTSSettings(); $erptsSettings->parseDomDocument($domDoc); $this->formArray["lguName"] = strtoupper($erptsSettings->getLguName()); $this->formArray["lguType"] = strtoupper($erptsSettings->getLguType()); } } }
function Main() { switch ($this->formArray["formAction"]) { case "purge": $ReceiptList = new SoapObject(NCCBIZ . "ReceiptList.php", "urn:Object"); if (!($totalPurgedReceipts = $ReceiptList->purgeReceiptList())) { $this->tpl->set_var("totalPurgedReceipts", 0); } else { $this->tpl->set_var("totalPurgedReceipts", $totalPurgedReceipts); } $this->tpl->set_block("rptsTemplate", "Default", "DefaultBlock"); $this->tpl->set_var("DefaultBlock", ""); break; default: $ReceiptList = new SoapObject(NCCBIZ . "ReceiptList.php", "urn:Object"); if (!($totalReceipts = $ReceiptList->getReceiptCount("WHERE status=''"))) { $this->tpl->set_var("totalReceipts", 0); } else { $this->tpl->set_var("totalReceipts", $totalReceipts); } if (!($countReceiptsForPurging = $ReceiptList->countPurgeReceiptList())) { $this->tpl->set_var("countReceiptsForPurging", 0); } else { $this->tpl->set_var("countReceiptsForPurging", $countReceiptsForPurging); } $this->tpl->set_block("rptsTemplate", "Results", "ResultsBlock"); $this->tpl->set_var("ResultsBlock", ""); } $this->setForm(); $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"); }
function Main() { $LandDetails = new SoapObject(NCCBIZ . "LandDetails.php", "urn:Object"); if (!($xmlStr = $LandDetails->getLand($this->formArray["propertyID"]))) { echo "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 { $land = new Land(); $land->parseDomDocument($domDoc); foreach ($land as $key => $value) { switch ($key) { case "propertyAdministrator": if (is_a($value, Person)) { list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value->getBirthday()); $this->formArray["personID"] = $value->getPersonID(); $this->formArray["lastName"] = $value->getLastName(); $this->formArray["firstName"] = $value->getFirstName(); $this->formArray["middleName"] = $value->getMiddleName(); $this->formArray["gender"] = $value->getGender(); $this->formArray["birth_year"] = removePreZero($dateArr["year"]); $this->formArray["birth_month"] = removePreZero($dateArr["month"]); $this->formArray["birth_day"] = removePreZero($dateArr["day"]); $this->formArray["maritalStatus"] = $value->getMaritalStatus(); $this->formArray["tin"] = $value->getTin(); $this->formArray["addressID"] = $value->addressArray[0]->getAddressID(); $this->formArray["number"] = $value->addressArray[0]->getNumber(); $this->formArray["street"] = $value->addressArray[0]->getStreet(); $this->formArray["barangay"] = $value->addressArray[0]->getBarangay(); $this->formArray["district"] = $value->addressArray[0]->getDistrict(); $this->formArray["municipalityCity"] = $value->addressArray[0]->getMunicipalityCity(); $this->formArray["province"] = $value->addressArray[0]->getProvince(); $this->formArray["telephone"] = $value->getTelephone(); $this->formArray["mobileNumber"] = $value->getMobileNumber(); $this->formArray["email"] = $value->getEmail(); } else { $this->formArray[$key] = ""; } break; case "verifiedBy": if (is_a($value, Assessor)) { $this->formArray["verifiedByID"] = $value->getAssessorID(); $this->formArray["verifiedByName"] = $value->getFullName(); } else { $this->formArray[$key] = ""; } break; case "plottingsBy": if (is_a($value, Assessor)) { $this->formArray["plottingsByID"] = $value->getAssessorID(); $this->formArray["plottingsByName"] = $value->getFullName(); } else { $this->formArray[$key] = ""; } break; case "notedBy": if (is_a($value, Assessor)) { $this->formArray["notedByID"] = $value->getAssessorID(); $this->formArray["notedByName"] = $value->getFullName(); } else { $this->formArray[$key] = ""; } break; case "appraisedBy": if (is_a($value, Assessor)) { $this->formArray["appraisedByID"] = $value->getAssessorID(); $this->formArray["appraisedByName"] = $value->getFullName(); } else { $this->formArray[$key] = ""; } break; case "appraisedByDate": if (true) { list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value); $this->formArray["as_year"] = removePreZero($dateArr["year"]); $this->formArray["as_month"] = removePreZero($dateArr["month"]); $this->formArray["as_day"] = removePreZero($dateArr["day"]); } else { $this->formArray[$key] = ""; } break; case "recommendingApproval": if (is_a($value, Assessor)) { $this->formArray["recommendingApprovalID"] = $value->getAssessorID(); $this->formArray["recommendingApprovalName"] = $value->getFullName(); } else { $this->formArray[$key] = ""; } break; case "recommendingApprovalDate": if (true) { list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value); $this->formArray["re_year"] = removePreZero($dateArr["year"]); $this->formArray["re_month"] = removePreZero($dateArr["month"]); $this->formArray["re_day"] = removePreZero($dateArr["day"]); } else { $this->formArray[$key] = ""; } case "approvedBy": if (is_a($value, Assessor)) { $this->formArray["approvedByID"] = $value->getAssessorID(); $this->formArray["approvedByName"] = $value->getFullName(); } else { $this->formArray[$key] = ""; } break; case "approvedByDate": if (true) { list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value); $this->formArray["av_year"] = removePreZero($dateArr["year"]); $this->formArray["av_month"] = removePreZero($dateArr["month"]); $this->formArray["av_day"] = removePreZero($dateArr["day"]); } else { $this->formArray[$key] = ""; } break; default: $this->formArray[$key] = $value; } } } } $this->setForm(); $this->tpl->set_var("Session", $this->sess->url("") . $this->sess->add_query(array("odID" => $this->formArray["odID"], "ownerID" => $this->formArray["ownerID"]))); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); }
function Main() { switch ($this->formArray["formAction"]) { case "delete": if (count($this->formArray["districtID"]) > 0) { $DistrictList = new SoapObject(NCCBIZ . "DistrictList.php", "urn:Object"); if (!($deletedRows = $DistrictList->deleteDistrict($this->formArray["districtID"]))) { $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 "activate": $DistrictList = new SoapObject(NCCBIZ . "DistrictList.php", "urn:Object"); if (!($activeRows = $DistrictList->updateStatus($this->formArray["status"]))) { $this->tpl->set_var("msg", "All records have status made <i>inactive</i>"); } else { $this->tpl->set_var("msg", $activeRows . " records have status made <i>active</i>"); } break; case "cancel": header("location: DistrictList.php?" . $this->sess->name . "=" . $this->sess->id); exit; break; default: $this->tpl->set_var("msg", ""); } $DistrictList = new SoapObject(NCCBIZ . "DistrictList.php", "urn:Object"); $condition = $this->showHideInactive(); $condition .= $this->sortBlocks(); if (!($xmlStr = $DistrictList->getDistrictList(0, $condition))) { $this->tpl->set_block("rptsTemplate", "Table", "TableBlock"); $this->tpl->set_var("TableBlock", "database is empty"); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { $this->tpl->set_block("rptsTemplate", "Table", "TableBlock"); $this->tpl->set_var("TableBlock", "error xmlDoc"); } else { $districtRecords = new DistrictRecords(); $districtRecords->parseDomDocument($domDoc); $list = $districtRecords->getArrayList(); $this->tpl->set_block("rptsTemplate", "DistrictList", "DistrictListBlock"); foreach ($list as $key => $value) { $this->tpl->set_var("districtID", $value->getDistrictID()); $this->tpl->set_var("code", $value->getCode()); $this->tpl->set_var("municipalityCity", $this->getMunicipalityCity($value->getMunicipalityCityID())); $this->tpl->set_var("description", $value->getDescription()); $this->tpl->set_var("status", $value->getStatus()); $this->tpl->set_var("statusCheck", $this->getStatusCheck($value->getStatus())); $this->tpl->parse("DistrictListBlock", "DistrictList", true); } } } $this->setForm(); $this->tpl->set_var("uname", $this->user["uname"]); $this->tpl->set_var("today", date("F j, Y")); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); }
function Main() { switch ($this->formArray["formAction"]) { case "remove": //echo "removeOwnerRPTOP(".$this->formArray["rptopID"].",".$this->formArray["ownerID"].",".$this->formArray["personID"].",".$this->formArray["companyID"].")"; $OwnerList = new SoapObject(NCCBIZ . "OwnerList.php", "urn:Object"); if (count($this->formArray["personID"]) || count($this->formArray["companyID"])) { if (!($deletedRows = $OwnerList->removeOwnerRPTOP($this->formArray["rptopID"], $this->formArray["ownerID"], $this->formArray["personID"], $this->formArray["companyID"]))) { $this->tpl->set_var("msg", "SOAP failed"); //echo "SOAP failed"; } else { $this->tpl->set_var("msg", $deletedRows . " records deleted"); } } else { $this->tpl->set_var("msg", "0 records deleted"); } header("location: RPTOPDetails.php" . $this->sess->url("") . $this->sess->add_query(array("rptopID" => $this->formArray["rptopID"]))); exit; break; default: $this->tpl->set_var("msg", ""); } //select $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); 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_numeric($value)) { $cityAssessor = new Person(); $cityAssessor->selectRecord($value); $this->tpl->set_var("cityAssessorID", $cityAssessor->getPersonID()); $this->tpl->set_var("cityAssessorName", $cityAssessor->getFullName()); $this->formArray["cityAssessorName"] = $cityAssessor->getFullName(); } else { $cityAssessor = $value; $this->tpl->set_var("cityAssessorID", $cityAssessor); $this->tpl->set_var("cityAssessorName", $cityAssessor); $this->formArray["cityAssessorName"] = $cityAssessor; } break; case "cityTreasurer": if (is_numeric($value)) { $cityTreasurer = new Person(); $cityTreasurer->selectRecord($value); $this->tpl->set_var("cityTreasurerID", $cityTreasurer->getPersonID()); $this->tpl->set_var("cityTreasurerName", $cityTreasurer->getFullName()); $this->formArray["cityTreasurerName"] = $cityTreasurer->getFullName(); } else { $cityTreasurer = $value; $this->tpl->set_var("cityTreasurerID", $cityTreasurer); $this->tpl->set_var("cityTreasurerName", $cityTreasurer); $this->formArray["cityTreasurerName"] = $cityTreasurer; } break; case "tdArray": //$this->tpl->set_block("rptsTemplate", "defaultTDList", "defaultTDListBlock"); //$this->tpl->set_block("rptsTemplate", "toggleTDList", "toggleTDListBlock"); //$this->tpl->set_block("rptsTemplate", "TDList", "TDListBlock"); //$this->tpl->set_block("TDList", "BacktaxesList", "BacktaxesListBlock"); $tdCtr = 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) { //foreach($tvalue as $column => $val){ // $this->tpl->set_var($column,$val); //} /* $this->tpl->set_var("tdID",$tvalue->getTDID()); $this->tpl->set_var("taxDeclarationNumber",$tvalue->getTaxDeclarationNumber()); $this->tpl->set_var("afsID",$tvalue->getAfsID()); $this->tpl->set_var("cancelsTDNumber",$tvalue->getCancelsTDNumber()); $this->tpl->set_var("canceledByTDNumber",$tvalue->getCanceledByTDNumber()); $this->tpl->set_var("taxBeginsWithTheYear",$tvalue->getTaxBeginsWithTheYear()); $this->tpl->set_var("ceasesWithTheYear",$tvalue->getCeasesWithTheYear()); $this->tpl->set_var("enteredInRPARForBy",$tvalue->getEnteredInRPARForBy()); $this->tpl->set_var("enteredInRPARForYear",$tvalue->getEnteredInRPARForYear()); $this->tpl->set_var("previousOwner",$tvalue->getPreviousOwner()); $this->tpl->set_var("previousAssessedValue",$tvalue->getPreviousAssessedValue()); list($dateArr["year"],$dateArr["month"],$dateArr["day"]) = explode("-",$tvalue->getProvincialAssessorDate()); $this->tpl->set_var("pa_yearValue",removePreZero($dateArr["year"])); $this->tpl->set_var("pa_month",removePreZero($dateArr["month"])); $this->tpl->set_var("pa_dayValue",removePreZero($dateArr["day"])); list($dateArr["year"],$dateArr["month"],$dateArr["day"]) = explode("-",$tvalue->getCityMunicipalAssessorDate()); $this->tpl->set_var("cm_yearValue",removePreZero($dateArr["year"])); $this->tpl->set_var("cm_month",removePreZero($dateArr["month"])); $this->tpl->set_var("cm_dayValue",removePreZero($dateArr["day"])); $this->tpl->set_var("provincialAssessorName",$tvalue->provincialAssessor); $this->tpl->set_var("cityMunicipalAssessorName",$tvalue->cityMunicipalAssessor); //$this->tpl->set_var("assessedValue",$tvalue->getAssessedValue()); $this->tpl->set_var("propertyType",$tvalue->getPropertyType()); $this->tpl->set_var("basicTax",""); $this->tpl->set_var("sefTax", ""); $this->tpl->set_var("total", ""); //$this->tpl->set_var("basicTax",$tvalue->getBasicTax()); //$this->tpl->set_var("sefTax",$tvalue->getSefTax()); //$this->tpl->set_var("total",$tvalue->getTotal()); */ $this->tdRecord["arpNumber"] = $tvalue->getTaxDeclarationNumber(); $AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object"); if (!($xmlStr = $AFSDetails->getAFS($tvalue->getAfsID()))) { //$this->tpl->set_block("rptsTemplate", "AFSTable", "AFSTableBlock"); //$this->tpl->set_var("AFSTableBlock", "afs not found"); } else { //echo $xmlStr; if (!($domDoc = domxml_open_mem($xmlStr))) { //$this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock"); //$this->tpl->set_var("OwnerListTableBlock", "error xmlDoc"); } else { $afs = new AFS(); $afs->parseDomDocument($domDoc); $odID = $afs->getOdID(); $od = new OD(); $od->selectRecord($odID); if (is_object($od->locationAddress)) { $locationAddress = $od->getLocationAddress(); $this->tdRecord["location"] = $locationAddress->getBarangay() . ", " . $locationAddress->getMunicipalityCity(); } switch ($tvalue->getPropertyType()) { case "ImprovementsBuildings": if (is_array($afs->getImprovementsBuildingsArray())) { $improvementsBuildings = $afs->improvementsBuildingsArray[0]; $actualUse = $improvementsBuildings->getActualUse(); if (is_numeric($actualUse)) { $improvementsBuildingsActualUses = new ImprovementsBuildingsActualUses(); $improvementsBuildingsActualUses->selectRecord($actualUse); $actualUse = $improvementsBuildingsActualUses->getCode(); //$actualUse = $improvementsBuildingsActualUses->getDescription(); } $this->tdRecord["class"] = $actualUse; } break; case "Machineries": if (is_array($afs->getMachineriesArray())) { $machineries = $afs->machineriesArray[0]; $actualUse = $machineries->getActualUse(); if (is_numeric($actualUse)) { $machineriesActualUses = new MachineriesActualUses(); $machineriesActualUses->selectRecord($actualUse); $actualUse = $machineriesActualUses->getCode(); //$actualUse = $machineriesActualUses->getDescription(); } $this->tdRecord["class"] = $actualUse; } break; case "Land": default: if (is_array($afs->getLandArray())) { $land = $afs->landArray[0]; $actualUse = $land->getActualUse(); if (is_numeric($actualUse)) { $landActualUses = new LandActualUses(); $landActualUses->selectRecord($actualUse); $actualUse = $landActualUses->getCode(); //$actualUse = $landActualUses->getDescription(); } $this->tdRecord["class"] = $actualUse; } else { if (is_array($afs->getPlantsTreesArray())) { if (is_numeric($actualUse)) { $plantsTreesActualUses = new PlantsTreesActualUses(); $plantsTreesActualUses->selectRecord($actualUse); $actualUse = $plantsTreesActualUses->getCode(); //$actualUse = $plantsTreesActualUses->getDescription(); } $this->tdRecord["class"] = $actualUse; } } } $this->formArray["landTotalMarketValue"] += $afs->getLandTotalMarketValue(); $this->formArray["landTotalAssessedValue"] += $afs->getLandTotalAssessedValue(); $this->formArray["plantTotalMarketValue"] += $afs->getPlantTotalMarketValue(); $this->formArray["plantTotalAssessedValue"] += $afs->getPlantTotalAssessedValue(); $this->formArray["bldgTotalMarketValue"] += $afs->getBldgTotalMarketValue(); $this->formArray["bldgTotalAssessedValue"] += $afs->getBldgTotalAssessedValue(); $this->formArray["machTotalMarketValue"] += $afs->getMachTotalMarketValue(); $this->formArray["machTotalAssessedValue"] += $afs->getMachTotalAssessedValue(); $this->formArray["totalMarketValue"] += $afs->getTotalMarketValue(); $this->formArray["totalAssessedValue"] += $afs->getTotalAssessedValue(); $this->tpl->set_var("marketValue", number_format($afs->getTotalMarketValue(), 2, '.', ',')); $this->tpl->set_var("assessedValue", number_format($afs->getTotalAssessedValue(), 2, '.', ',')); $this->tpl->set_var("taxability", $afs->getTaxability()); $this->tpl->set_var("effectivity", $afs->getEffectivity()); $this->formArray["idle"] = "No"; if ($tvalue->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"; } $this->tpl->set_var("idle", $this->formArray["idle"]); } } // grab DueRecords from tdID $DueList = new SoapObject(NCCBIZ . "DueList.php", "urn:Object"); $dueArrayList = array("Annual" => "", "Q1" => "", "Q2" => "", "Q3" => "", "Q4" => ""); if (!($xmlStr = $DueList->getDueList($tvalue->getTdID(), $rptop->getTaxableYear()))) { if ($this->formArray["rptopID"] != "") { $redirectMessage = "Dues are uncalculated. <a href='CalculateRPTOPDetails.php" . $this->sess->url("") . "&rptopID=" . $this->formArray["rptopID"] . "'>Click here</a> to go to calculation page or <a href='SOA.php" . $this->sess->url("") . "'>return to list</a>."; } else { $redirectMessage = "Dues are uncalculated. <a href='SOA.php" . $this->sess->url("") . "'>Click here</a> to return to list."; } exit($redirectMessage); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { if ($this->formArray["rptopID"] != "") { $redirectMessage = "Dues are uncalculated. <a href='CalculateRPTOPDetails.php" . $this->sess->url("") . "&rptopID=" . $this->formArray["rptopID"] . "'>Click here</a> to go to calculation page or <a href='SOA.php" . $this->sess->url("") . "'>return to list</a>."; } else { $redirectMessage = "Dues are uncalculated. <a href='SOA.php" . $this->sess->url("") . "'>Click here</a> to return to list."; } exit($redirectMessage); } else { $dueRecords = new DueRecords(); $dueRecords->parseDomDocument($domDoc); foreach ($dueRecords->getArrayList() as $due) { foreach ($due as $dueKey => $dueValue) { switch ($dueKey) { case "dueType": if ($dueValue == "Annual") { $this->formArray["totalTaxDue"] += $due->getTaxDue(); } $dueArrayList[$dueValue] = $due; $this->tpl->set_var("basicTax[" . $dueValue . "]", formatCurrency($due->getBasicTax())); $this->tpl->set_var("sefTax[" . $dueValue . "]", formatCurrency($due->getSEFTax())); $this->tpl->set_var("idleTax[" . $dueValue . "]", formatCurrency($due->getIdleTax())); $this->tpl->set_var("taxDue[" . $dueValue . "]", formatCurrency($due->getTaxDue())); $this->tpl->set_var("dueDate[" . $dueValue . "]", date("M. d, Y", strtotime($due->getDueDate()))); $dueDateYear = date("Y", strtotime($due->getDueDate())); $this->tdRecord["year"] = $dueDateYear; break; } } } $treasurySettings = new TreasurySettings(); $treasurySettings->selectRecord(); // initialize discountPeriod and discountPercentage for earlyPaymentDiscount $this->tpl->set_var("discountPercentage", $treasurySettings->getDiscountPercentage() . "%"); $this->tpl->set_var("discountPeriod", "January 01, " . $dueDateYear . " - " . date("F d, Y", strtotime($dueDateYear . "-" . $treasurySettings->getDiscountPeriod()))); $this->formArray["discountPercentage"] = $treasurySettings->getDiscountPercentage(); $this->formArray["discountPeriod"] = $treasurySettings->getDiscountPeriod(); $this->formArray["discountPeriod_End"] = strtotime($dueDateYear . "-" . $this->formArray["discountPeriod"]); $this->formArray["discountPeriod_Start"] = strtotime($dueDateYear . "-01-01"); // initialize advancedDiscountPercentage for advancedPayment $this->tpl->set_var("advancedDiscountPercentage", $treasurySettings->getAdvancedDiscountPercentage() . "%"); $this->formArray["advancedDiscountPercentage"] = $treasurySettings->getAdvancedDiscountPercentage(); $this->tpl->set_var("q1AdvancedDiscountPercentage", $treasurySettings->getQ1AdvancedDiscountPercentage() . "%"); $this->formArray["q1AdvancedDiscountPercentage"] = $treasurySettings->getQ1AdvancedDiscountPercentage(); // initialize penaltyLUTArray $penaltyLUTArray = $treasurySettings->getPenaltyLUT(); $this->penaltyLUTArray = $treasurySettings->getPenaltyLUT(); foreach ($dueArrayList as $dKey => $due) { $dueArrayList[$dKey]->setEarlyPaymentDiscountPeriod($this->formArray["discountPeriod"]); $dueArrayList[$dKey]->setEarlyPaymentDiscountPercentage($this->formArray["discountPercentage"]); // compute earlyPaymentDiscount as of today // check if today is within the discountPeriod and compute Discount // AND if today is BEFORE annual dueDate $dueArrayList[$dKey]->setEarlyPaymentDiscount(0.0); if ($due->getDueType() == "Annual") { if (strtotime($this->now) >= $this->formArray["discountPeriod_Start"] && strtotime($this->now) <= $this->formArray["discountPeriod_End"]) { if (strtotime($this->now) <= strtotime($dueArrayList[$dKey]->getDueDate())) { $dueArrayList[$dKey]->setEarlyPaymentDiscount($dueArrayList[$dKey]->getTaxDue() * ($this->formArray["discountPercentage"] / 100)); } } } else { // if today is BEFORE dueDate if (strtotime($this->now) <= strtotime($due->getDueDate()) && strtotime($this->now) >= $this->formArray["discountPeriod_Start"]) { $dueArrayList[$dKey]->setEarlyPaymentDiscount($dueArrayList[$dKey]->getTaxDue() * ($this->formArray["discountPercentage"] / 100)); } // commented out Febuary 08, 2005 : Provide Quarterly Discounts // earlyPaymentDiscount aren't given to Quarterly Dues except for Quarter 1 /* if($due->getDueType()=="Q1"){ if(strtotime($this->now) >= $this->formArray["discountPeriod_Start"] && strtotime($this->now) <= $this->formArray["discountPeriod_End"]){ if(strtotime($this->now) <= strtotime($dueArrayList[$dKey]->getDueDate())){ $dueArrayList[$dKey]->setEarlyPaymentDiscount($dueArrayList[$dKey]->getTaxDue() * ($this->formArray["discountPercentage"]/100)); } } } */ } // compute advancedPaymentDiscount as of today // check if today is BEFORE January 1 of the year of the annual dueDate $dueArrayList[$dKey]->setAdvancedPaymentDiscount(0.0); if (strtotime($this->now) < strtotime(date("Y", strtotime($dueArrayList[$dKey]->getDueDate())) . "-01-01")) { // for advanced payments, give 20% discount to annual dues [advanced discount] // give 10% discount to quarterly dues [early discount] if ($due->getDueType() == "Annual") { $dueArrayList[$dKey]->setAdvancedPaymentDiscount($dueArrayList[$dKey]->getTaxDue() * ($this->formArray["advancedDiscountPercentage"] / 100)); } else { if ($due->getDueType() == "Q1") { $dueArrayList[$dKey]->setAdvancedPaymentDiscount($dueArrayList[$dKey]->getTaxDue() * ($this->formArray["q1AdvancedDiscountPercentage"] / 100)); } else { $dueArrayList[$dKey]->setAdvancedPaymentDiscount($dueArrayList[$dKey]->getTaxDue() * ($this->formArray["discountPercentage"] / 100)); } // commented out: February 08, 2005 // advancedPaymentDiscount aren't given to Quarterly Dues except for Quarter 1 /* if($due->getDueType()=="Q1"){ $dueArrayList[$dKey]->setAdvancedPaymentDiscount($dueArrayList[$dKey]->getTaxDue() * ($this->formArray["q1AdvancedDiscountPercentage"]/100)); } */ } } $latestPaymentDate[$dKey] = $this->getLatestPaymentDateForDue($dueArrayList[$dKey]); $amountPaidForDue = $this->getAmountPaidForDue($dueArrayList); $latestPaymentDueType = $this->getLatestPaymentDueType($dueArrayList); $amnestyStatus[$dKey] = $this->getAmnestyStatusForDue($dueArrayList[$dKey]); $totalEarlyPaymentDiscount = $this->getTotalEarlyPaymentDiscountForDue($dueArrayList); $totalAdvancedPaymentDiscount = $this->getTotalAdvancedPaymentDiscountForDue($dueArrayList); if ($totalEarlyPaymentDiscount > 0) { $earlyPaymentDiscountForDueType = $this->getTotalEarlyPaymentDiscountForDueType($dueArrayList[$dKey]); if ($earlyPaymentDiscountForDueType > 0) { $dueArrayList[$dKey]->setEarlyPaymentDiscount($earlyPaymentDiscountForDueType); } } if ($totalAdvancedPaymentDiscount > 0) { $advancedPaymentDiscountForDueType = $this->getTotalAdvancedPaymentDiscountForDueType($dueArrayList[$dKey]); if ($advancedPaymentDiscountForDueType > 0) { $dueArrayList[$dKey]->setAdvancedPaymentDiscount($advancedPaymentDiscountForDueType); } } // calculate Penalties verses either today or verses the last paymentDate if ($latestPaymentDate[$dKey] != "" || $latestPaymentDate[$dKey] != "now") { $dueArrayList[$dKey] = $this->computePenalty($latestPaymentDate[$dKey], $dueArrayList[$dKey]); // if balance is 0 leave penalty as is, otherwise calculatePenalty according to date now $balance = round($dueArrayList[$dKey]->getInitialNetDue() - $amountPaidForDue, 4); // 0.1 is used instead of 0 because a lot of balances may end up as 0.002 or so... if ($balance > 0.1) { $dueArrayList[$dKey] = $this->computePenalty($this->now, $dueArrayList[$dKey]); } } else { $dueArrayList[$dKey] = $this->computePenalty($this->now, $dueArrayList[$dKey]); } //print_r($dueArrayList[$dKey]); //echo "<hr>"; $this->tpl->set_var("advancedPaymentDiscount[" . $dKey . "]", formatCurrency($dueArrayList[$dKey]->getAdvancedPaymentDiscount())); $this->tpl->set_var("earlyPaymentDiscount[" . $dKey . "]", formatCurrency($dueArrayList[$dKey]->getEarlyPaymentDiscount())); $this->tpl->set_var("monthsOverDue[" . $dKey . "]", $dueArrayList[$dKey]->getMonthsOverDue()); $this->tpl->set_var("penaltyPercentage[" . $dKey . "]", $dueArrayList[$dKey]->getPenaltyPercentage() * 100); $this->tpl->set_var("penalty[" . $dKey . "]", formatCurrency($dueArrayList[$dKey]->getPenalty())); $this->initialNetDue[$dKey] = $dueArrayList[$dKey]->getInitialNetDue(); if ($amnestyStatus[$dKey]) { $this->initialNetDue[$dKey] -= $dueArrayList[$dKey]->getPenalty(); $this->tpl->set_var("amnesty[" . $dKey . "]", "Yes"); } else { $this->tpl->set_var("amnesty[" . $dKey . "]", "No"); } $this->tpl->set_var("initialNetDue[" . $dKey . "]", formatCurrency($this->initialNetDue[$dKey])); } // out of the loop, // verify balances to make disable penalties and discounts for Annual if ALL QUARTERS have been paid // and to disable penalties and discounts for Quarters if ALL of ANNUAL has been paid // example: Q1, Q2, Q3 and Q4 have been fully paid. Annual should not show any payables. // Likewise if Annual has been fully paid, Q1, Q2, Q3 and Q4 should not show any payables. $totalQuarterlyNetDue = 0; $totalQuarterlyNetDue += $dueArrayList["Q1"]->getBasicTax() + $dueArrayList["Q1"]->getSefTax() + $dueArrayList["Q1"]->getIdleTax(); $totalQuarterlyNetDue -= $dueArrayList["Q1"]->getEarlyPaymentDiscount() + $dueArrayList["Q1"]->getAdvancedPaymentDiscount(); if (!$amnestyStatus["Q1"]) { $totalQuarterlyNetDue += $dueArrayList["Q1"]->getPenalty(); } $totalQuarterlyNetDue += $dueArrayList["Q2"]->getBasicTax() + $dueArrayList["Q2"]->getSefTax() + $dueArrayList["Q2"]->getIdleTax(); $totalQuarterlyNetDue -= $dueArrayList["Q2"]->getEarlyPaymentDiscount() + $dueArrayList["Q2"]->getAdvancedPaymentDiscount(); if (!$amnestyStatus["Q2"]) { $totalQuarterlyNetDue += $dueArrayList["Q2"]->getPenalty(); } $totalQuarterlyNetDue += $dueArrayList["Q3"]->getBasicTax() + $dueArrayList["Q3"]->getSefTax() + $dueArrayList["Q3"]->getIdleTax(); $totalQuarterlyNetDue -= $dueArrayList["Q3"]->getEarlyPaymentDiscount() + $dueArrayList["Q3"]->getAdvancedPaymentDiscount(); if (!$amnestyStatus["Q3"]) { $totalQuarterlyNetDue += $dueArrayList["Q3"]->getPenalty(); } $totalQuarterlyNetDue += $dueArrayList["Q4"]->getBasicTax() + $dueArrayList["Q4"]->getSefTax() + $dueArrayList["Q4"]->getIdleTax(); $totalQuarterlyNetDue -= $dueArrayList["Q4"]->getEarlyPaymentDiscount() + $dueArrayList["Q4"]->getAdvancedPaymentDiscount(); if (!$amnestyStatus["Q4"]) { $totalQuarterlyNetDue += $dueArrayList["Q4"]->getPenalty(); } $totalAnnualNetDue = 0; $totalAnnualNetDue += $dueArrayList["Annual"]->getBasicTax() + $dueArrayList["Annual"]->getSefTax() + $dueArrayList["Annual"]->getIdleTax(); $totalAnnualNetDue -= $dueArrayList["Annual"]->getEarlyPaymentDiscount() + $dueArrayList["Annual"]->getAdvancedPaymentDiscount(); if (!$amnestyStatus["Annual"]) { $totalAnnualNetDue += $dueArrayList["Annual"]->getPenalty(); } if ($latestPaymentDueType != "Annual" && $totalQuarterlyNetDue - $amountPaidForDue <= 0) { // all QUARTERLY DUES have been paid, modify Annual Due values $dueArrayList["Annual"]->setAdvancedPaymentDiscount(0); $dueArrayList["Annual"]->setEarlyPaymentDiscount(0); $dueArrayList["Annual"]->setMonthsOverDue(0); $dueArrayList["Annual"]->setPenaltyPercentage(0); $dueArrayList["Annual"]->setPenalty(0); $this->initialNetDue["Annual"] = $dueArrayList["Annual"]->getInitialNetDue(); $this->tpl->set_var("advancedPaymentDiscount[Annual]", formatCurrency($dueArrayList["Annual"]->getAdvancedPaymentDiscount())); $this->tpl->set_var("earlyPaymentDiscount[Annual]", formatCurrency($dueArrayList["Annual"]->getEarlyPaymentDiscount())); $this->tpl->set_var("monthsOverDue[Annual]", $dueArrayList["Annual"]->getMonthsOverDue()); $this->tpl->set_var("penaltyPercentage[Annual]", $dueArrayList["Annual"]->getPenaltyPercentage() * 100); $this->tpl->set_var("penalty[Annual]", formatCurrency($dueArrayList["Annual"]->getPenalty())); $this->tpl->set_var("amnesty[Annual]", "No"); $this->tpl->set_var("initialNetDue[Annual]", formatCurrency($this->initialNetDue["Annual"])); } else { if ($latestPaymentDueType == "Annual" && $totalAnnualNetDue - $amountPaidForDue <= 0) { // all of ANNUAL Due has been fully paid, modify Quarterly Due values $quarterlyDueKeys = array("Q1", "Q2", "Q3", "Q4"); foreach ($quarterlyDueKeys as $dKey) { $dueArrayList[$dKey]->setAdvancedPaymentDiscount(0); $dueArrayList[$dKey]->setEarlyPaymentDiscount(0); $dueArrayList[$dKey]->setMonthsOverDue(0); $dueArrayList[$dKey]->setPenaltyPercentage(0); $dueArrayList[$dKey]->setPenalty(0); $this->initialNetDue[$dKey] = $dueArrayList[$dKey]->getInitialNetDue(); $this->tpl->set_var("advancedPaymentDiscount[" . $dKey . "]", formatCurrency($dueArrayList[$dKey]->getAdvancedPaymentDiscount())); $this->tpl->set_var("earlyPaymentDiscount[" . $dKey . "]", formatCurrency($dueArrayList[$dKey]->getEarlyPaymentDiscount())); $this->tpl->set_var("monthsOverDue[" . $dKey . "]", $dueArrayList[$dKey]->getMonthsOverDue()); $this->tpl->set_var("penaltyPercentage[" . $dKey . "]", $dueArrayList[$dKey]->getPenaltyPercentage() * 100); $this->tpl->set_var("penalty[" . $dKey . "]", formatCurrency($dueArrayList[$dKey]->getPenalty())); $this->tpl->set_var("amnesty[" . $dKey . "]", "No"); $this->tpl->set_var("initialNetDue[" . $dKey . "]", formatCurrency($this->initialNetDue[$dKey])); } } } } } // display Backtaxes and previousTD Backtaxes $this->formArray["totalBacktaxesBalance"] = 0; $this->displayBacktaxTD($tvalue->getTdID()); $precedingTDArray = $this->getPrecedingTDArray($tvalue); if (is_array($precedingTDArray)) { foreach ($precedingTDArray as $precedingTD) { $this->displayBacktaxTD($precedingTD->getTdID()); } } $this->tpl->set_var("total", number_format($this->formArray["totalBacktaxesDue"], 2)); $this->tpl->set_var("totalBacktaxesBalance", number_format($this->formArray["totalBacktaxesBalance"], 2)); // grab dueID's and backtaxTDID's to run through payments // create $dueIDArray foreach ($dueArrayList as $due) { $this->dueIDArray[] = $due->getDueID(); } $this->displayTotalPaid(); $this->displayNetDue(); $this->tdArrayList[$this->tdRecord["year"] . $this->tdArrayListCounter] = $this->tdRecord; $this->tdArrayListCounter++; unset($this->tdRecord); $this->tpl->set_var("ctr", $tdCtr); //$this->tpl->parse("defaultTDListBlock", "defaultTDList", true); //$this->tpl->parse("toggleTDListBlock", "toggleTDList", true); //$this->tpl->parse("TDListBlock", "TDList", true); //$this->tpl->set_var("BacktaxesListBlock", ""); /* $this->tpl->set_var("LandBlock", ""); $this->tpl->set_var("PlantsTreesBlock", ""); $this->tpl->set_var("ImprovementsBuildingsBlock", ""); $this->tpl->set_var("MachineriesBlock", ""); */ $tdCtr++; } } else { $this->tpl->set_var("defaultTDListBlock", "//no default"); $this->tpl->set_var("toggleTDListBlock", "//no Toggle"); $this->tpl->set_var("TDListBlock", ""); } $this->tpl->set_var("tdCtr", $tdCtr); break; case "landTotalMarketValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "landTotalAssessedValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "plantTotalMarketValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "plantTotalAssessedValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "bldgTotalMarketValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "bldgTotalAssessedValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "machTotalMarketValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "machTotalAssessedValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "totalMarketValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "totalAssessedValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; default: $this->formArray[$key] = $value; } } $this->formArray["totalMarketValue"] = $this->formArray["landTotalMarketValue"] + $this->formArray["plantTotalMarketValue"] + $this->formArray["bldgTotalMarketValue"] + $this->formArray["machTotalMarketValue"]; $this->formArray["totalAssessedValue"] = $this->formArray["landTotalAssessedValue"] + $this->formArray["plantTotalAssessedValue"] + $this->formArray["bldgTotalAssessedValue"] + $this->formArray["machTotalAssessedValue"]; unset($rptop); $AFSEncode = new SoapObject(NCCBIZ . "AFSEncode.php", "urn:Object"); $rptop = new RPTOP(); $rptop->setRptopID($this->formArray["rptopID"]); $rptop->setLandTotalMarketValue($this->formArray["landTotalMarketValue"]); $rptop->setLandTotalAssessedValue($this->formArray["landTotalAssessedValue"]); $rptop->setPlantTotalMarketValue($this->formArray["plantTotalMarketValue"]); $rptop->setPlantTotalPlantAssessedValue($this->formArray["plantTotalAssessedValue"]); $rptop->setBldgTotalMarketValue($this->formArray["bldgTotalMarketValue"]); $rptop->setBldgTotalAssessedValue($this->formArray["bldgTotalAssessedValue"]); $rptop->setMachTotalMarketValue($this->formArray["machTotalMarketValue"]); $rptop->setMachTotalAssessedValue($this->formArray["machTotalAssessedValue"]); $rptop->setTotalMarketValue($this->formArray["totalMarketValue"]); $rptop->setTotalAssessedValue($this->formArray["totalAssessedValue"]); $rptop->setCreatedBy($this->userID); $rptop->setModifiedBy($this->userID); $rptop->setDomDocument(); $RPTOPEncode = new SoapObject(NCCBIZ . "RPTOPEncode.php", "urn:Object"); $rptop->setDomDocument(); $doc = $rptop->getDomDocument(); $xmlStr = $doc->dump_mem(true); //echo $xmlStr; if (!($ret = $RPTOPEncode->updateRPTOPtotals($xmlStr))) { echo "ret=" . $ret; } //echo $ret; } } if (is_array($this->tdArrayList)) { ksort($this->tdArrayList); reset($this->tdArrayList); // $this->tpl->set_block("rptsTemplate", "TDList", "TDListBlock"); $this->tpl->set_block("rptsTemplate", "Page", "PageBlock"); $this->tpl->set_block("Page", "TDList", "TDListBlock"); $this->tpl->set_block("Page", "TotalDue", "TotalDueBlock"); $this->formArray["totalTaxDue"] = 0; $maxRows = 20; $numRows = count($this->tdArrayList); $numPages = ceil($numRows / $maxRows); $rowStr = ""; $j = 0; $page = 0; foreach ($this->tdArrayList as $tdRecord) { ++$j; if ($j > $maxRows) { $this->formArray["tdYPosValue"] = "564"; $this->tpl->set_var("TDListBlock", $rowStr); $this->tpl->set_var("PageNumber", ++$page); if ($page == $numPages) { $this->tpl->set_var("TotalDueBlock", $this->tpl->subst("TotalDue")); } else { $this->tpl->set_var("TotalDueBlock", ""); } $this->tpl->parse("PageBlock", "Page", true); $rowStr = ""; $j = 1; } $this->tpl->set_var("arpNumber", $tdRecord["arpNumber"]); $this->tpl->set_var("class", $tdRecord["class"]); $this->tpl->set_var("location", $tdRecord["location"]); $this->tpl->set_var("year", $tdRecord["year"]); $this->tpl->set_var("taxDue", formatCurrency($tdRecord["taxDue"])); $this->tpl->set_var("tdYPos", $this->formArray["tdYPosValue"]); $this->formArray["tdYPosValue"] -= 15; $this->formArray["totalTaxDue"] += $tdRecord["taxDue"]; $rowStr .= $this->tpl->subst("TDList"); } $this->tpl->set_var("TDListBlock", $rowStr); $this->tpl->set_var("PageNumber", ++$page); if ($page == $numPages) { $this->tpl->set_var("TotalDueBlock", $this->tpl->subst("TotalDue")); } else { $this->tpl->set_var("TotalDueBlock", ""); } $this->tpl->parse("PageBlock", "Page", true); // echo $this->tpl->subst("Page"); /* $maxRows = 5; $numRows = count($this->tdArrayList); $numPages = ceil($numRows/$maxRows); $tdRecord = current($this->tdArrayList); for ($page=0; $page<$numPages; ++$page) { $rowStr = ""; $this->formArray["tdYPosValue"] = "564"; for ($currRow=0; $currRow<$maxRows; ++$currRow) { // $tdRecord = $this->tdArrayList[($page*$maxRows)+$currRow]; $this->tpl->set_var("arpNumber", $tdRecord["arpNumber"]); $this->tpl->set_var("class", $tdRecord["class"]); $this->tpl->set_var("location", $tdRecord["location"]); $this->tpl->set_var("year", $tdRecord["year"]); $this->tpl->set_var("taxDue", formatCurrency($tdRecord["taxDue"])); $this->tpl->set_var("tdYPos", $this->formArray["tdYPosValue"]); $this->formArray["tdYPosValue"]-=15; $rowStr .= $this->tpl->subst("TDList"); $this->formArray["totalTaxDue"] += $tdRecord["taxDue"]; $tdRecord = next($this->tdArrayList); } echo $rowStr; $this->tpl->set_var("TDListBlock", $rowStr); $this->tpl->set_var("PageNum", $page+1); $this->tpl->parse("PageBlock", "Page", true); } foreach($this->tdArrayList as $tdRecord){ $this->tpl->set_var("arpNumber", $tdRecord["arpNumber"]); $this->tpl->set_var("class", $tdRecord["class"]); $this->tpl->set_var("location", $tdRecord["location"]); $this->tpl->set_var("year", $tdRecord["year"]); $this->tpl->set_var("taxDue", formatCurrency($tdRecord["taxDue"])); $this->tpl->set_var("tdYPos", $this->formArray["tdYPosValue"]); $this->formArray["totalTaxDue"] += $tdRecord["taxDue"]; $this->tpl->parse("TDListBlock", "TDList", true); $this->formArray["tdYPosValue"]-=15; } */ } $this->setForm(); /* $this->setPageDetailPerms(); $this->tpl->set_var("uname", $this->user["uname"]); $this->tpl->set_var("today", date("F j, Y",strtotime($this->now))); $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"); */ $this->tpl->set_var("today", date("F j, Y", strtotime($this->now))); $this->setLguDetails(); $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); } // header("location: ".$testpdf->pdfPath); exit; }
function Main() { $AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object"); if (!($xmlStr = $AFSDetails->getAFS($this->formArray["afsID"]))) { exit("afs not found"); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { exit("error xmlDoc"); } else { $afs = new AFS(); $afs->parseDomDocument($domDoc); $this->formArray["arpNumber"] = $afs->arpNumber; $this->formArray["propertyIndexNumber"] = $afs->propertyIndexNumber; $this->formArray["taxability"] = $afs->taxability; $this->formArray["effectivity"] = $afs->effectivity; $this->displayODAFS($this->formArray["afsID"]); $this->displayTD($this->formArray["afsID"]); $landList = $afs->getLandArray(); if (count($landList)) { $this->displayLandList($landList); } $plantsTreesList = $afs->getPlantsTreesArray(); if (count($plantsTreesList)) { $this->displayPlantsTreesList($plantsTreesList); } $fp = fopen("/home/site/log/faasland1.xml", "w"); fwrite($fp, "---landitems---\r\n"); fwrite($fp, $this->formArray["landitems"] . "\r\n"); fwrite($fp, "---plantitems---\r\n"); fwrite($fp, $this->formArray["plantitems"] . "\r\n"); fwrite($fp, "---adjitems---\r\n"); fwrite($fp, $this->formArray["adjitems"] . "\r\n"); fwrite($fp, "---summtems---\r\n"); fwrite($fp, $this->formArray["summitems"] . "\r\n"); fclose($fp); } } $this->setForm(); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); // $this->tpl->p("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); } //header("location: ".$testpdf->pdfPath); exit; }
function Main() { switch ($this->formArray["formAction"]) { case "remove": //echo "removeOwnerRPTOP(".$this->formArray["rptopID"].",".$this->formArray["ownerID"].",".$this->formArray["personID"].",".$this->formArray["companyID"].")"; $OwnerList = new SoapObject(NCCBIZ . "OwnerList.php", "urn:Object"); if (count($this->formArray["personID"]) || count($this->formArray["companyID"])) { if (!($deletedRows = $OwnerList->removeOwnerRPTOP($this->formArray["rptopID"], $this->formArray["ownerID"], $this->formArray["personID"], $this->formArray["companyID"]))) { $this->tpl->set_var("msg", "SOAP failed"); //echo "SOAP failed"; } else { $this->tpl->set_var("msg", $deletedRows . " records deleted"); } } else { $this->tpl->set_var("msg", "0 records deleted"); } header("location: RPTOPDetails.php" . $this->sess->url("") . $this->sess->add_query(array("rptopID" => $this->formArray["rptopID"]))); exit; break; default: $this->tpl->set_var("msg", ""); } //select $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); 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_numeric($value)) { $cityAssessor = new Person(); $cityAssessor->selectRecord($value); $this->tpl->set_var("cityAssessorID", $cityAssessor->getPersonID()); $this->tpl->set_var("cityAssessorName", $cityAssessor->getFullName()); $this->formArray["cityAssessorName"] = $cityAssessor->getFullName(); } else { $cityAssessor = $value; $this->tpl->set_var("cityAssessorID", $cityAssessor); $this->tpl->set_var("cityAssessorName", $cityAssessor); $this->formArray["cityAssessorName"] = $cityAssessor; } break; case "cityTreasurer": if (is_numeric($value)) { $cityTreasurer = new Person(); $cityTreasurer->selectRecord($value); $this->tpl->set_var("cityTreasurerID", $cityTreasurer->getPersonID()); $this->tpl->set_var("cityTreasurerName", $cityTreasurer->getFullName()); $this->formArray["cityTreasurerName"] = $cityTreasurer->getFullName(); } else { $cityTreasurer = $value; $this->tpl->set_var("cityTreasurerID", $cityTreasurer); $this->tpl->set_var("cityTreasurerName", $cityTreasurer); $this->formArray["cityTreasurerName"] = $cityTreasurer; } 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; 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) { //foreach($tvalue as $column => $val){ // $this->tpl->set_var($column,$val); //} $this->tpl->set_var("taxDeclarationNumber", $tvalue->getTaxDeclarationNumber()); $this->tpl->set_var("afsID", $tvalue->getAfsID()); $this->tpl->set_var("cancelsTDNumber", $tvalue->getCancelsTDNumber()); $this->tpl->set_var("canceledByTDNumber", $tvalue->getCanceledByTDNumber()); $this->tpl->set_var("taxBeginsWithTheYear", $tvalue->getTaxBeginsWithTheYear()); $this->tpl->set_var("ceasesWithTheYear", $tvalue->getCeasesWithTheYear()); $this->tpl->set_var("enteredInRPARForBy", $tvalue->getEnteredInRPARForBy()); $this->tpl->set_var("enteredInRPARForYear", $tvalue->getEnteredInRPARForYear()); $this->tpl->set_var("previousOwner", $tvalue->getPreviousOwner()); $this->tpl->set_var("previousAssessedValue", $tvalue->getPreviousAssessedValue()); list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $tvalue->getProvincialAssessorDate()); $this->tpl->set_var("pa_yearValue", removePreZero($dateArr["year"])); $this->tpl->set_var("pa_month", removePreZero($dateArr["month"])); $this->tpl->set_var("pa_dayValue", removePreZero($dateArr["day"])); list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $tvalue->getCityMunicipalAssessorDate()); $this->tpl->set_var("cm_yearValue", removePreZero($dateArr["year"])); $this->tpl->set_var("cm_month", removePreZero($dateArr["month"])); $this->tpl->set_var("cm_dayValue", removePreZero($dateArr["day"])); $this->tpl->set_var("provincialAssessorName", $tvalue->provincialAssessor); $this->tpl->set_var("cityMunicipalAssessorName", $tvalue->cityMunicipalAssessor); //$this->tpl->set_var("assessedValue",$tvalue->getAssessedValue()); $this->tpl->set_var("basicTax", ""); $this->tpl->set_var("sefTax", ""); $this->tpl->set_var("total", ""); //$this->tpl->set_var("basicTax",$tvalue->getBasicTax()); //$this->tpl->set_var("sefTax",$tvalue->getSefTax()); //$this->tpl->set_var("total",$tvalue->getTotal()); $AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object"); if (!($xmlStr = $AFSDetails->getAFSForList($tvalue->getAfsID()))) { //$this->tpl->set_block("rptsTemplate", "AFSTable", "AFSTableBlock"); //$this->tpl->set_var("AFSTableBlock", "afs not found"); } else { //echo $xmlStr; if (!($domDoc = domxml_open_mem($xmlStr))) { //$this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock"); //$this->tpl->set_var("OwnerListTableBlock", "error xmlDoc"); } else { $afs = new AFS(); $afs->parseDomDocument($domDoc); $this->formArray["landTotalMarketValue"] += $afs->getLandTotalMarketValue(); $this->formArray["landTotalAssessedValue"] += $afs->getLandTotalAssessedValue(); $this->formArray["plantTotalMarketValue"] += $afs->getPlantTotalMarketValue(); $this->formArray["plantTotalAssessedValue"] += $afs->getPlantTotalAssessedValue(); $this->formArray["bldgTotalMarketValue"] += $afs->getBldgTotalMarketValue(); $this->formArray["bldgTotalAssessedValue"] += $afs->getBldgTotalAssessedValue(); $this->formArray["machTotalMarketValue"] += $afs->getMachTotalMarketValue(); $this->formArray["machTotalAssessedValue"] += $afs->getMachTotalAssessedValue(); $this->formArray["totalMarketValue"] += $afs->getTotalMarketValue(); $this->formArray["totalAssessedValue"] += $afs->getTotalAssessedValue(); $this->tpl->set_var("marketValue", number_format($afs->getTotalMarketValue(), 2, '.', ',')); $this->tpl->set_var("assessedValue", number_format($afs->getTotalAssessedValue(), 2, '.', ',')); } } $this->tpl->set_var("ctr", $tdCtr); $this->tpl->parse("defaultTDListBlock", "defaultTDList", true); $this->tpl->parse("toggleTDListBlock", "toggleTDList", true); $this->tpl->parse("TDListBlock", "TDList", true); /* $this->tpl->set_var("LandBlock", ""); $this->tpl->set_var("PlantsTreesBlock", ""); $this->tpl->set_var("ImprovementsBuildingsBlock", ""); $this->tpl->set_var("MachineriesBlock", ""); */ $tdCtr++; } } else { $this->tpl->set_var("defaultTDListBlock", "//no default"); $this->tpl->set_var("toggleTDListBlock", "//no Toggle"); $this->tpl->set_var("TDListBlock", ""); } $this->tpl->set_var("tdCtr", $tdCtr); break; case "landTotalMarketValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "landTotalAssessedValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "plantTotalMarketValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "plantTotalAssessedValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "bldgTotalMarketValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "bldgTotalAssessedValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "machTotalMarketValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "machTotalAssessedValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "totalMarketValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "totalAssessedValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; default: $this->formArray[$key] = $value; } } $this->formArray["totalMarketValue"] = $this->formArray["landTotalMarketValue"] + $this->formArray["plantTotalMarketValue"] + $this->formArray["bldgTotalMarketValue"] + $this->formArray["machTotalMarketValue"]; $this->formArray["totalAssessedValue"] = $this->formArray["landTotalAssessedValue"] + $this->formArray["plantTotalAssessedValue"] + $this->formArray["bldgTotalAssessedValue"] + $this->formArray["machTotalAssessedValue"]; unset($rptop); $AFSEncode = new SoapObject(NCCBIZ . "AFSEncode.php", "urn:Object"); $rptop = new RPTOP(); $rptop->setRptopID($this->formArray["rptopID"]); $rptop->setLandTotalMarketValue($this->formArray["landTotalMarketValue"]); $rptop->setLandTotalAssessedValue($this->formArray["landTotalAssessedValue"]); $rptop->setPlantTotalMarketValue($this->formArray["plantTotalMarketValue"]); $rptop->setPlantTotalPlantAssessedValue($this->formArray["plantTotalAssessedValue"]); $rptop->setBldgTotalMarketValue($this->formArray["bldgTotalMarketValue"]); $rptop->setBldgTotalAssessedValue($this->formArray["bldgTotalAssessedValue"]); $rptop->setMachTotalMarketValue($this->formArray["machTotalMarketValue"]); $rptop->setMachTotalAssessedValue($this->formArray["machTotalAssessedValue"]); $rptop->setTotalMarketValue($this->formArray["totalMarketValue"]); $rptop->setTotalAssessedValue($this->formArray["totalAssessedValue"]); $rptop->setCreatedBy($this->userID); $rptop->setModifiedBy($this->userID); $rptop->setDomDocument(); $RPTOPEncode = new SoapObject(NCCBIZ . "RPTOPEncode.php", "urn:Object"); $rptop->setDomDocument(); $doc = $rptop->getDomDocument(); $xmlStr = $doc->dump_mem(true); //echo $xmlStr; if (!($ret = $RPTOPEncode->updateRPTOPtotals($xmlStr))) { echo "ret=" . $ret; } //echo $ret; } } $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->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 getFilteredPaymentRecords() { $paymentEndingDate = date("Y-m-d", strtotime($this->formArray["quarterEndingDate"] . " " . $this->formArray["year"])); $paymentBeginningDate = date("Y-m-d", strtotime($this->formArray["quarterBeginningDate"] . " " . $this->formArray["year"])); $condition = "WHERE " . PAYMENT_TABLE . ".status!='cancelled' AND (" . PAYMENT_TABLE . ".paymentDate >= '" . $paymentBeginningDate . "' AND " . PAYMENT_TABLE . ".paymentDate <= '" . $paymentEndingDate . "')"; $condition .= " AND (" . PAYMENT_TABLE . ".municipalityCity LIKE '" . $this->formArray["municipalityCity"] . "' OR " . PAYMENT_TABLE . ".municipalityCity LIKE '" . $this->formArray["municipalityCityID"] . "') "; $condition .= " AND " . PAYMENT_TABLE . ".propertyType IS NOT NULL"; $PaymentList = new SoapObject(NCCBIZ . "PaymentList.php", "urn:Object"); if (!($xmlStr = $PaymentList->getPaymentList($condition))) { return false; } else { if (!($domDoc = domxml_open_mem($xmlStr))) { return false; } else { $paymentRecords = new PaymentRecords(); $paymentRecords->parseDomDocument($domDoc); return $paymentRecords; } } }
function Main() { $AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object"); if (!($xmlStr = $AFSDetails->getAFS($this->formArray["afsID"]))) { exit("afs not found"); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { exit("error xmlDoc"); } else { $afs = new AFS(); $afs->parseDomDocument($domDoc); $this->displayODAFS($this->formArray["afsID"]); $this->formArray["propertyIndexNumber"] = $afs->propertyIndexNumber; //inserted this code for arpNumber - renonj $this->formArray["arpNumber"] = $afs->getArpNumber(); $this->formArray["taxability"] = $afs->getTaxability(); //Inserted by CHT 07292008 if ($afs->getTaxability() == "Taxable") { $this->formArray["isTaxable"] = "X"; $this->formArray["isExempt"] = " "; } else { if ($afs->getTaxability() == "Exempt") { $this->formArray["isExempt"] = "X"; $this->formArray["isTaxable"] = " "; } } //End //land $landList = $afs->getLandArray(); if (count($landList)) { $this->displayLandList($landList); } //plantsTrees $plantsTreesList = $afs->getPlantsTreesArray(); if (count($plantsTreesList)) { $this->displayPlantsTreesList($plantsTreesList); } //improvementsBuildings $improvementsBuildingsList = $afs->getImprovementsBuildingsArray(); if (count($improvementsBuildingsList)) { $this->displayImprovementsBuildingsList($improvementsBuildingsList); } //machineries $machineriesList = $afs->getMachineriesArray(); if (count($machineriesList)) { $this->displayMachineriesList($machineriesList); } $this->displayAssessedValues($landList, $plantsTreesList, $improvementsBuildingsList, $machineriesList); $this->displayLGUInfo(); } } $this->setForm(); $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("TDSummary.pdf"); //,$this->formArray["print"]); } else { $testpdf->writePDF("TDSummary.pdf"); } // header("location: ".$testpdf->pdfPath); exit; }
function Main() { switch ($this->formArray["formAction"]) { case "delete": //print_r($this->formArray); if (count($this->formArray["odID"]) > 0) { $ODList = new SoapObject(NCCBIZ . "ODList.php", "urn:Object"); if (!($deletedRows = $ODList->deleteOD($this->formArray["odID"]))) { $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 "filterBarangay": $ODList = new SoapObject(NCCBIZ . "ODList.php", "urn:Object"); $this->tpl->set_block("rptsTemplate", "Pages", "PagesBlock"); $this->tpl->set_block("rptsTemplate", "PagesList", "PagesListBlock"); $condition = $this->filterArchives(); if (!($count = $ODList->filterByBarangayCount($this->formArray["barangay"], $condition))) { $this->tpl->set_var("PagesBlock", ""); $this->tpl->set_var("PagesListBlock", ""); $this->tpl->set_block("rptsTemplate", "PageNavigator", "PageNavigatorBlock"); $this->tpl->set_var("PageNavigatorBlock", ""); $numOfPages = 1; } 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=filterBarangay&barangay=" . urlencode($this->formArray["barangay"])); $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=filterBarangay&barangay=" . urlencode($this->formArray["barangay"])); $this->tpl->set_var("paged", "selected"); } else { $this->tpl->set_var("pages", $i); $this->tpl->set_var("pagesUrl", $i . "&formAction=filterBarangay&barangay=" . urlencode($this->formArray["barangay"])); $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=filterBarangay&barangay=" . urlencode($this->formArray["barangay"])); $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=filterBarangay&barangay=" . urlencode($this->formArray["barangay"])); $this->tpl->set_var("previousTxt", "previous"); } $condition = $this->filterArchives(); $condition .= $this->sortBlocks(); $this->tpl->set_var("pageOf", $this->formArray["page"] . " of " . $numOfPages); if (!($xmlStr = $ODList->filterByBarangay($this->formArray["page"], $this->formArray["barangay"], $condition))) { $this->tpl->set_var("pageOf", ""); $this->tpl->set_block("rptsTemplate", "ODTable", "ODTableBlock"); $this->tpl->set_var("ODTableBlock", ""); $this->tpl->set_block("rptsTemplate", "ODDBEmpty", "ODDBEmptyBlock"); $this->tpl->set_var("ODDBEmptyBlock", ""); $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", "ODListTable", "ODListTableBlock"); $this->tpl->set_var("ODListTableBlock", "error xmlDoc"); } else { $this->tpl->set_block("rptsTemplate", "NotFound", "NotFoundBlock"); $this->tpl->set_var("NotFoundBlock", ""); $odRecords = new ODRecords(); $odRecords->parseDomDocument($domDoc); $list = $odRecords->getArrayList(); if (count($list)) { $this->tpl->set_block("rptsTemplate", "ODDBEmpty", "ODDBEmptyBlock"); $this->tpl->set_var("ODDBEmptyBlock", ""); $this->tpl->set_block("rptsTemplate", "ODList", "ODListBlock"); $this->tpl->set_block("ODList", "PersonList", "PersonListBlock"); $this->tpl->set_block("ODList", "CompanyList", "CompanyListBlock"); foreach ($list as $key => $value) { $this->tpl->set_var("odID", $value->getOdID()); // added propertyType column : October 20, 2005: $propertyType = $this->getPropertyTypeFromOD($value); $this->tpl->set_var("propertyType", $propertyType); $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"); } //*/ //echo method_exists($value->location,getFullAddress); $this->tpl->set_var("locationAddress", $value->locationAddress->getFullAddress()); $this->tpl->set_var("landArea", number_format($value->getLandArea(), 4, '.', ',')); // $this->tpl->set_var("landArea", formatCurrency1($value->getLandArea())); $this->setODListBlockPerms(); $this->tpl->parse("ODListBlock", "ODList", true); $this->tpl->set_var("PersonListBlock", ""); $this->tpl->set_var("CompanyListBlock", ""); } } else { $this->tpl->set_block("rptsTemplate", "ODList", "ODListBlock"); $this->tpl->set_var("ODListBlock", "huh"); } } } break; case "search": $ODList = new SoapObject(NCCBIZ . "ODList.php", "urn:Object"); $this->tpl->set_block("rptsTemplate", "Pages", "PagesBlock"); $this->tpl->set_block("rptsTemplate", "PagesList", "PagesListBlock"); $condition = $this->filterArchives(); if (!($count = $ODList->getSearchCount($this->formArray["searchKey"], $condition))) { $this->tpl->set_var("PagesBlock", ""); $this->tpl->set_var("PagesListBlock", ""); $this->tpl->set_block("rptsTemplate", "PageNavigator", "PageNavigatorBlock"); $this->tpl->set_var("PageNavigatorBlock", ""); $numOfPages = 1; } 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"); } $condition = $this->filterArchives(); $condition .= $this->sortBlocks(); $this->tpl->set_var("pageOf", $this->formArray["page"] . " of " . $numOfPages); if (!($xmlStr = $ODList->searchOD($this->formArray["page"], $this->formArray["searchKey"], $condition))) { $this->tpl->set_var("pageOf", ""); $this->tpl->set_block("rptsTemplate", "ODTable", "ODTableBlock"); $this->tpl->set_var("ODTableBlock", ""); $this->tpl->set_block("rptsTemplate", "ODDBEmpty", "ODDBEmptyBlock"); $this->tpl->set_var("ODDBEmptyBlock", ""); $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", "ODListTable", "ODListTableBlock"); $this->tpl->set_var("ODListTableBlock", "error xmlDoc"); } else { $this->tpl->set_block("rptsTemplate", "NotFound", "NotFoundBlock"); $this->tpl->set_var("NotFoundBlock", ""); $odRecords = new ODRecords(); $odRecords->parseDomDocument($domDoc); $list = $odRecords->getArrayList(); if (count($list)) { $this->tpl->set_block("rptsTemplate", "ODDBEmpty", "ODDBEmptyBlock"); $this->tpl->set_var("ODDBEmptyBlock", ""); $this->tpl->set_block("rptsTemplate", "ODList", "ODListBlock"); $this->tpl->set_block("ODList", "PersonList", "PersonListBlock"); $this->tpl->set_block("ODList", "CompanyList", "CompanyListBlock"); foreach ($list as $key => $value) { $this->tpl->set_var("odID", $value->getOdID()); // added propertyType column : October 20, 2005: $propertyType = $this->getPropertyTypeFromOD($value); $this->tpl->set_var("propertyType", $propertyType); $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"); } //*/ //echo method_exists($value->location,getFullAddress); $this->tpl->set_var("locationAddress", $value->locationAddress->getFullAddress()); $this->tpl->set_var("landArea", number_format($value->getLandArea(), 4, '.', ',')); //$this->tpl->set_var("landArea", formatCurrency1($value->getLandArea())); $this->setODListBlockPerms(); $this->tpl->parse("ODListBlock", "ODList", true); $this->tpl->set_var("PersonListBlock", ""); $this->tpl->set_var("CompanyListBlock", ""); } } else { $this->tpl->set_block("rptsTemplate", "ODList", "ODListBlock"); $this->tpl->set_var("ODListBlock", "huh"); } } } break; case "cancel": header("location: ODList.php"); exit; break; default: $this->tpl->set_var("msg", ""); $ODList = new SoapObject(NCCBIZ . "ODList.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", ""); $condition = $this->filterArchives(); if (!($count = $ODList->getODCount($condition))) { $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"] || $numOfPages == "") { $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->filterArchives(); $condition .= $this->sortBlocks(); if (!($xmlStr = $ODList->getODList($this->formArray["page"], $condition))) { $this->tpl->set_block("rptsTemplate", "ODTable", "ODTableBlock"); $this->tpl->set_var("ODTableBlock", ""); } else { //echo $xmlStr; if (!($domDoc = domxml_open_mem($xmlStr))) { $this->tpl->set_block("rptsTemplate", "ODListTable", "ODListTableBlock"); $this->tpl->set_var("ODListTableBlock", ""); } else { $odRecords = new ODRecords(); $odRecords->parseDomDocument($domDoc); $list = $odRecords->getArrayList(); if (count($list)) { $this->tpl->set_block("rptsTemplate", "ODDBEmpty", "ODDBEmptyBlock"); $this->tpl->set_var("ODDBEmptyBlock", ""); $this->tpl->set_block("rptsTemplate", "ODList", "ODListBlock"); $this->tpl->set_block("ODList", "PersonList", "PersonListBlock"); $this->tpl->set_block("ODList", "CompanyList", "CompanyListBlock"); foreach ($list as $key => $value) { //print_r($value); //echo "<br>"; $this->tpl->set_var("odID", $value->getOdID()); // added propertyType column : October 20, 2005: $propertyType = $this->getPropertyTypeFromOD($value); $this->tpl->set_var("propertyType", $propertyType); $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"); } //*/ //if (method_exists($value->locationAddress,$value->locationAddress->getFullAddress())) if ($value->locationAddress != "") { $this->tpl->set_var("locationAddress", $value->locationAddress->getFullAddress()); } $this->tpl->set_var("landArea", number_format($value->getLandArea(), 4, '.', ',')); //$this->tpl->set_var("landArea", formatCurrency1($value->getLandArea())); $this->setODListBlockPerms(); $this->tpl->parse("ODListBlock", "ODList", true); $this->tpl->set_var("PersonListBlock", ""); $this->tpl->set_var("CompanyListBlock", ""); } } else { $this->tpl->set_block("rptsTemplate", "ODList", "ODListBlock"); $this->tpl->set_var("ODListBlock", "huh"); } } } } $this->initBarangayList(); $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"); }
function Main() { switch ($this->formArray["formAction"]) { case "remove": if (count($this->formArray["landID"])) { //print_r($this->formArray["landID"]); $LandList = new SoapObject(NCCBIZ . "LandList.php", "urn:Object"); if (!($deletedRows = $LandList->removeLand($this->formArray["landID"]))) { $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"); } if (count($this->formArray["plantsTreesID"])) { //print_r($this->formArray["plantsTreesID"]); $PlantsTreesList = new SoapObject(NCCBIZ . "PlantsTreesList.php", "urn:Object"); if (!($deletedRows = $PlantsTreesList->removePlantsTrees($this->formArray["plantsTreesID"]))) { $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"); } if (count($this->formArray["machineriesID"])) { //print_r($this->formArray["machineriesID"]); $MachineriesList = new SoapObject(NCCBIZ . "MachineriesList.php", "urn:Object"); if (!($deletedRows = $MachineriesList->removeMachineries($this->formArray["machineriesID"]))) { $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"); } if (count($this->formArray["improvementsBuildingsID"])) { //print_r($this->formArray["improvementsBuildingsID"]); $ImprovementsBuildingsList = new SoapObject(NCCBIZ . "ImprovementsBuildingsList.php", "urn:Object"); if (!($deletedRows = $ImprovementsBuildingsList->removeImprovementsBuildings($this->formArray["improvementsBuildingsID"]))) { $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"); } if (count($this->formArray["storeyID"])) { //print_r($this->formArray["storeyID"]); $StoreyList = new SoapObject(NCCBIZ . "StoreyList.php", "urn:Object"); if (!($deletedRows = $StoreyList->removeStorey($this->formArray["storeyID"]))) { $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"); } header("location: AFSDetails.php" . $this->sess->url("") . $this->sess->add_query(array("afsID" => $this->formArray["afsID"]))); exit; break; default: $this->tpl->set_var("msg", ""); } $AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object"); if (!($xmlStr = $AFSDetails->getAFS($this->formArray["afsID"]))) { $this->tpl->set_block("rptsTemplate", "AFSTable", "AFSTableBlock"); $this->tpl->set_var("AFSTableBlock", "afs not found"); } else { //echo $xmlStr; if (!($domDoc = domxml_open_mem($xmlStr))) { $this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock"); $this->tpl->set_var("OwnerListTableBlock", "error xmlDoc"); } else { $afs = new AFS(); $afs->parseDomDocument($domDoc); //print_r($afs); foreach ($afs as $key => $value) { $this->formArray[$key] = $value; $this->formArray["totalMarketValue"] = 0; $this->formArray["totalAssessedValue"] = 0; } // RPU Identification Numbers $this->displayRPUIdentification($afs); $landList = $afs->getLandArray(); $plantsTreesList = $afs->getPlantsTreesArray(); $improvementsBuildingsList = $afs->getImprovementsBuildingsArray(); $machineriesList = $afs->getMachineriesArray(); if (count($landList)) { $hideTD = false; $this->formArray["propertyType"] = "Land"; $this->displayLandPlantsTrees($landList, $plantsTreesList); $this->hideProperty('ImprovementsBuildings', 'improvementsBuildings'); $this->hideProperty('Machineries', 'machineries'); } else { if (count($plantsTreesList)) { $hideTD = false; $this->formArray["propertyType"] = "Land"; $this->displayLandPlantsTrees($landList, $plantsTreesList); $this->hideProperty('ImprovementsBuildings', 'improvementsBuildings'); $this->hideProperty('Machineries', 'machineries'); } else { if (count($improvementsBuildingsList)) { $hideTD = false; $this->formArray["propertyType"] = "ImprovementsBuildings"; $this->displayImprovementsBuildings($improvementsBuildingsList); $this->hideProperty('Land', 'land'); $this->hideProperty('PlantsTrees', 'plantsTrees'); $this->hideProperty('Machineries', 'machineries'); } else { if (count($machineriesList)) { $hideTD = false; $this->formArray["propertyType"] = "Machineries"; $this->displayMachineries($machineriesList); $this->hideProperty('Land', 'land'); $this->hideProperty('PlantsTrees', 'plantsTrees'); $this->hideProperty('ImprovementsBuildings', 'improvementsBuildings'); } else { $hideTD = true; $this->displayLandPlantsTrees($landList, $plantsTreesList); $this->displayImprovementsBuildingsMachineries($improvementsBuildingsList, $machineriesList); $this->formArray["landTotalMarketValue"] = 0; $this->formArray["landTotalAssessedValue"] = 0; $this->formArray["plantTotalMarketValue"] = 0; $this->formArray["plantTotalAssessedValue"] = 0; $this->formArray["bldgTotalMarketValue"] = 0; $this->formArray["bldgTotalAssessedValue"] = 0; $this->formArray["machTotalMarketValue"] = 0; $this->formArray["machTotalAssessedValue"] = 0; } } } } if ($hideTD == false) { // Display TD $this->displayTD($afs->afsID); } else { // Hide TD $this->tpl->set_block("rptsTemplate", "DeclarationOfProperty", "DeclarationOfPropertyBlock"); $this->tpl->set_var("DeclarationOfPropertyBlock", ""); } $ODDetails = new SoapObject(NCCBIZ . "ODDetails.php", "urn:Object"); if (!($xmlStr = $ODDetails->getOD($this->formArray["odID"]))) { 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 { $od = new OD(); $od->parseDomDocument($domDoc); foreach ($od as $key => $value) { if ($key == "locationAddress" && is_object($value)) { foreach ($value as $lkey => $lvalue) { $this->formArray[$lkey] = $lvalue; } } else { $this->formArray[$key] = $value; } } $ODEncode = new SoapObject(NCCBIZ . "ODEncode.php", "urn:Object"); $this->formArray["ownerID"] = $ODEncode->getOwnerID($this->formArray["odID"]); $OwnerList = new SoapObject(NCCBIZ . "OwnerList.php", "urn:Object"); if (!($xmlStr = $OwnerList->getOwnerList($this->formArray["ownerID"]))) { //exit(print_r($OwnerList)); $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); } } } } } } $AFSEncode = new SoapObject(NCCBIZ . "AFSEncode.php", "urn:Object"); $afs = new AFS(); $afs->selectRecord($this->formArray["afsID"]); $afs->setAfsID($this->formArray["afsID"]); $afs->setLandTotalMarketValue($this->formArray["landTotalMarketValue"]); $afs->setLandTotalAssessedValue($this->formArray["landTotalAssessedValue"]); $afs->setPlantTotalMarketValue($this->formArray["plantTotalMarketValue"]); $afs->setPlantTotalPlantAssessedValue($this->formArray["plantTotalAssessedValue"]); $afs->setBldgTotalMarketValue($this->formArray["bldgTotalMarketValue"]); $afs->setBldgTotalAssessedValue($this->formArray["bldgTotalAssessedValue"]); $afs->setMachTotalMarketValue($this->formArray["machTotalMarketValue"]); $afs->setMachTotalAssessedValue($this->formArray["machTotalAssessedValue"]); $afs->setTotalMarketValue($this->formArray["totalMarketValue"]); $afs->setTotalAssessedValue($this->formArray["totalAssessedValue"]); $afs->setDomDocument(); $doc = $afs->getDomDocument(); $xmlStr = $doc->dump_mem(true); //print_r($AFSEncode); //echo $xmlStr; if (!($ret = $AFSEncode->updateAFS($xmlStr))) { echo "ret=" . $ret; } //echo $ret; $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->sess->add_query(array("afsID" => $this->formArray["afsID"]))); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); }
function Main() { switch ($this->formArray["formAction"]) { case "edit": $this->tpl->set_var("MessageBlock", ""); $ImprovementsBuildingsClassesDetails = new SoapObject(NCCBIZ . "ImprovementsBuildingsClassesDetails.php", "urn:Object"); if (!($xmlStr = $ImprovementsBuildingsClassesDetails->getImprovementsBuildingsClassesDetails($this->formArray["improvementsBuildingsClassesID"]))) { $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 { $improvementsBuildingsClasses = new ImprovementsBuildingsClasses(); $improvementsBuildingsClasses->parseDomDocument($domDoc); $this->formArray["improvementsBuildingsClassesID"] = $improvementsBuildingsClasses->getImprovementsBuildingsClassesID(); $this->formArray["code"] = $improvementsBuildingsClasses->getCode(); $this->formArray["description"] = $improvementsBuildingsClasses->getDescription(); $this->formArray["rangeLowerBound"] = $improvementsBuildingsClasses->getRangeLowerBound(); $this->formArray["rangeUpperBound"] = $improvementsBuildingsClasses->getRangeUpperBound(); $this->formArray["value"] = $improvementsBuildingsClasses->getValue(); $this->formArray["type"] = $improvementsBuildingsClasses->getType(); $this->formArray["status"] = $improvementsBuildingsClasses->getStatus(); } } break; case "save": if ($this->codeAlreadyExists() == true) { $this->message = "Error. Cannot Save. Code already exists."; $this->tpl->set_var("message", $this->message); $this->tpl->parse("MessageBlock", "Message", true); break; } else { $this->tpl->set_var("MessageBlock", ""); } $ImprovementsBuildingsClassesEncode = new SoapObject(NCCBIZ . "ImprovementsBuildingsClassesEncode.php", "urn:Object"); if ($this->formArray["improvementsBuildingsClassesID"] != "") { $ImprovementsBuildingsClassesDetails = new SoapObject(NCCBIZ . "ImprovementsBuildingsClassesDetails.php", "urn:Object"); if (!($xmlStr = $ImprovementsBuildingsClassesDetails->getImprovementsBuildingsClassesDetails($this->formArray["improvementsBuildingsClassesID"]))) { exit("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 { $improvementsBuildingsClasses = new ImprovementsBuildingsClasses(); $improvementsBuildingsClasses->parseDomDocument($domDoc); $improvementsBuildingsClasses->setImprovementsBuildingsClassesID($this->formArray["improvementsBuildingsClassesID"]); $improvementsBuildingsClasses->setCode($this->formArray["code"]); $improvementsBuildingsClasses->setDescription($this->formArray["description"]); $improvementsBuildingsClasses->setRangeLowerBound($this->formArray["rangeLowerBound"]); $improvementsBuildingsClasses->setRangeUpperBound($this->formArray["rangeUpperBound"]); $improvementsBuildingsClasses->setValue($this->formArray["value"]); $improvementsBuildingsClasses->setType($this->formArray["type"]); $improvementsBuildingsClasses->setStatus($this->formArray["status"]); $improvementsBuildingsClasses->setDomDocument(); $doc = $improvementsBuildingsClasses->getDomDocument(); $xmlStr = $doc->dump_mem(true); if (!($ret = $ImprovementsBuildingsClassesEncode->updateImprovementsBuildingsClasses($xmlStr))) { exit("error update"); } } } } else { $improvementsBuildingsClasses = new ImprovementsBuildingsClasses(); $improvementsBuildingsClasses->setImprovementsBuildingsClassesID($this->formArray["improvementsBuildingsClassesID"]); $improvementsBuildingsClasses->setCode($this->formArray["code"]); $improvementsBuildingsClasses->setDescription($this->formArray["description"]); $improvementsBuildingsClasses->setRangeLowerBound($this->formArray["rangeLowerBound"]); $improvementsBuildingsClasses->setRangeUpperBound($this->formArray["rangeUpperBound"]); $improvementsBuildingsClasses->setValue($this->formArray["value"]); $improvementsBuildingsClasses->setType($this->formArray["type"]); $improvementsBuildingsClasses->setStatus($this->formArray["status"]); $improvementsBuildingsClasses->setDomDocument(); $doc = $improvementsBuildingsClasses->getDomDocument(); $xmlStr = $doc->dump_mem(true); if (!($ret = $ImprovementsBuildingsClassesEncode->saveImprovementsBuildingsClasses($xmlStr))) { exit("error save"); } } $this->formArray["improvementsBuildingsClassesID"] = $ret; header("location: ImprovementsBuildingsClassesClose.php" . $this->sess->url("") . $this->sess->add_query(array("improvementsBuildingsClassesID" => $ret))); //header("location: ImprovementsBuildingsClassesEncode.php"); exit; break; case "cancel": header("location: ImprovementsBuildingsClassesClose.php" . $this->sess->url("") . $this->sess->add_query(array("improvementsBuildingsClassesID" => $ret))); //header("location: ImprovementsBuildingsClassesList.php"); exit; break; default: $this->tpl->set_block("rptsTemplate", "ImprovementsBuildingsClassesID", "ImprovementsBuildingsClassesIDBlock"); $this->tpl->set_var("ImprovementsBuildingsClassesIDBlock", ""); $this->tpl->set_block("rptsTemplate", "ACK", "ACKBlock"); $this->tpl->set_var("ACKBlock", ""); $this->tpl->set_var("MessageBlock", ""); } $this->setForm(); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); }
function Main() { //echo $this->formArray["formAction"]; switch ($this->formArray["formAction"]) { case "delete": if (count($this->formArray["personID"]) > 0) { $PersonList = new SoapObject(NCCBIZ . "PersonList.php", "urn:Object"); if (!($deletedRows = $PersonList->deleteRecord($this->formArray["personID"]))) { $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"); } if (count($this->formArray["companyID"]) > 0) { $CompanyList = new SoapObject(NCCBIZ . "CompanyList.php", "urn:Object"); if (!($deletedRows = $CompanyList->deleteRecord($this->formArray["companyID"]))) { $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"); } header("location: ChangeOfOwnershipODDetails.php" . $this->sess->url("") . $this->sess->add_query(array("odID" => $this->formArray["odID"]))); exit; break; case "remove": if (count($this->formArray["personID"])) { $OwnerList = new SoapObject(NCCBIZ . "OwnerList.php", "urn:Object"); if (!($deletedRows = $OwnerList->removeOwnerPerson($this->formArray["ownerID"], $this->formArray["personID"]))) { $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"); } if (count($this->formArray["companyID"]) > 0) { $OwnerList = new SoapObject(NCCBIZ . "OwnerList.php", "urn:Object"); if (!($deletedRows = $OwnerList->removeOwnerCompany($this->formArray["ownerID"], $this->formArray["companyID"]))) { $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"); } header("location: ChangeOfOwnershipODDetails.php" . $this->sess->url("") . $this->sess->add_query(array("odID" => $this->formArray["odID"]))); exit; break; default: $this->tpl->set_var("msg", ""); } $ODDetails = new SoapObject(NCCBIZ . "ODDetails.php", "urn:Object"); if (!($xmlStr = $ODDetails->getOD($this->formArray["odID"]))) { exit("xml failed"); } else { //exit($xmlStr); if (!($domDoc = domxml_open_mem($xmlStr))) { $this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock"); $this->tpl->set_var("OwnerListTableBlock", "error xmlDoc"); } else { $od = new OD(); $od->parseDomDocument($domDoc); foreach ($od as $key => $value) { if ($key == "locationAddress" && is_object($value)) { foreach ($value as $lkey => $lvalue) { $this->formArray[$lkey] = $lvalue; } } else { $this->formArray[$key] = $value; } } $this->formArray["landArea"] = number_format($od->getLandArea(), 4, '.', ','); $ODEncode = new SoapObject(NCCBIZ . "ODEncode.php", "urn:Object"); $this->formArray["ownerID"] = $ODEncode->getOwnerID($this->formArray["odID"]); //$OwnerList = new SoapObject(NCCBIZ."OwnerList.php", "urn:Object"); $xmlStr = $od->owner->domDocument->dump_mem(true); if (!$xmlStr) { //exit(print_r($OwnerList)); $this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock"); $this->tpl->set_var("OwnerListTableBlock", ""); } else { //echo $xmlStr; if (!($domDoc = domxml_open_mem($xmlStr))) { $this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock"); $this->tpl->set_var("OwnerListTableBlock", "error xmlDoc"); } else { $this->displayOwnerList($domDoc); } } } } $AFSEncode = new SoapObject(NCCBIZ . "AFSEncode.php", "urn:Object"); if (!($afsID = $AFSEncode->getAfsID($this->formArray["odID"]))) { //$this->tpl->set_block("rptsTemplate", "AFSDetails", "AFSDetailsBlock"); //$this->tpl->set_var("AFSDetailsBlock", ""); //echo "1afsID=".$afsID."=>".$this->formArray["odID"]; $afs = new AFS(); $afs->setOdID($this->formArray["odID"]); $afs->setDomDocument(); $doc = $afs->getDomDocument(); $xmlStr = $doc->dump_mem(true); //echo $xmlStr; if (!($afsID = $AFSEncode->saveAFS($xmlStr))) { echo "ret=" . $afsID; } //echo "<br>afsID=".$afsID; } else { //echo "2afsID=".$afsID."=>".$this->formArray["odID"]; //$this->tpl->set_block("rptsTemplate", "AFSEncode", "AFSEncodeBlock"); //$this->tpl->set_var("AFSEncodeBlock", ""); } $this->formArray["afsID"] = $afsID; $this->setForm(); $this->tpl->set_var("Session", $this->sess->url("") . $this->sess->add_query(array("odID" => $this->formArray["odID"], "ownerID" => $this->formArray["ownerID"]))); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); }
function Main() { switch ($this->formArray["formAction"]) { case "delete": if (count($this->formArray["improvementsBuildingsDepreciationID"]) > 0) { $ImprovementsBuildingsDepreciationList = new SoapObject(NCCBIZ . "ImprovementsBuildingsDepreciationList.php", "urn:Object"); if (!($deletedRows = $ImprovementsBuildingsDepreciationList->deleteImprovementsBuildingsDepreciation($this->formArray["improvementsBuildingsDepreciationID"]))) { $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 "activate": $ImprovementsBuildingsDepreciationList = new SoapObject(NCCBIZ . "ImprovementsBuildingsDepreciationList.php", "urn:Object"); if (!($activeRows = $ImprovementsBuildingsDepreciationList->updateStatus($this->formArray["status"]))) { $this->tpl->set_var("msg", "All records have status made <i>inactive</i>"); } else { $this->tpl->set_var("msg", $activeRows . " records have status made <i>active</i>"); } break; case "cancel": header("location: ImprovementsBuildingsDepreciationList.php"); exit; break; default: $this->tpl->set_var("msg", ""); } $ImprovementsBuildingsDepreciationList = new SoapObject(NCCBIZ . "ImprovementsBuildingsDepreciationList.php", "urn:Object"); $condition = $this->showHideInactive(); $condition .= $this->sortBlocks(); if (!($xmlStr = $ImprovementsBuildingsDepreciationList->getImprovementsBuildingsDepreciationList(0, $condition))) { $this->tpl->set_block("rptsTemplate", "Table", "TableBlock"); $this->tpl->set_var("TableBlock", "database is empty"); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { $this->tpl->set_block("rptsTemplate", "Table", "TableBlock"); $this->tpl->set_var("TableBlock", "error xmlDoc"); } else { $improvementsBuildingsDepreciationRecords = new ImprovementsBuildingsDepreciationRecords(); $improvementsBuildingsDepreciationRecords->parseDomDocument($domDoc); $list = $improvementsBuildingsDepreciationRecords->getArrayList(); $this->tpl->set_block("rptsTemplate", "ImprovementsBuildingsDepreciationList", "ImprovementsBuildingsDepreciationListBlock"); foreach ($list as $key => $listValue) { $this->tpl->set_var("improvementsBuildingsDepreciationID", $listValue->getImprovementsBuildingsDepreciationID()); $this->tpl->set_var("code", $listValue->getCode()); $this->tpl->set_var("reportCode", $listValue->getReportCode()); $this->tpl->set_var("description", $listValue->getDescription()); $this->tpl->set_var("rangeLowerBound", $listValue->getRangeLowerBound()); $this->tpl->set_var("rangeUpperBound", $listValue->getRangeUpperBound()); $this->tpl->set_var("value", $listValue->getValue()); $this->tpl->set_var("status", $listValue->getStatus()); $this->tpl->set_var("statusCheck", $this->getStatusCheck($listValue->getStatus())); $this->tpl->parse("ImprovementsBuildingsDepreciationListBlock", "ImprovementsBuildingsDepreciationList", true); } } } $this->setForm(); $this->tpl->set_var("uname", $this->user["uname"]); $this->tpl->set_var("today", date("F j, Y")); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); }
function Main() { switch ($this->formArray["formAction"]) { default: $this->tpl->set_var("msg", ""); } $eRPTSSettingsDetails = new SoapObject(NCCBIZ . "eRPTSSettingsDetails.php", "urn:Object"); if (!($xmlStr = $eRPTSSettingsDetails->getERPTSSettingsDetails(1))) { $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 { $erptsSettings = new eRPTSSettings(); $erptsSettings->parseDomDocument($domDoc); $this->formArray["eRPTSSettingsID"] = $erptsSettings->getERPTSSettingsID(); $this->formArray["lguName"] = $erptsSettings->getLguName(); $this->formArray["lguType"] = $erptsSettings->getLguType(); $this->formArray["chiefExecutiveDesignation"] = $erptsSettings->getChiefExecutiveDesignation(); $this->formArray["chiefExecutiveFirstName"] = $erptsSettings->getChiefExecutiveFirstName(); $this->formArray["chiefExecutiveMiddleName"] = $erptsSettings->getChiefExecutiveMiddleName(); $this->formArray["chiefExecutiveLastName"] = $erptsSettings->getChiefExecutiveLastName(); $this->formArray["assessorDesignation"] = $erptsSettings->getAssessorDesignation(); $this->formArray["assessorFirstName"] = $erptsSettings->getAssessorFirstName(); $this->formArray["assessorMiddleName"] = $erptsSettings->getAssessorMiddleName(); $this->formArray["assessorLastName"] = $erptsSettings->getAssessorLastName(); $this->formArray["treasurerDesignation"] = $erptsSettings->getTreasurerDesignation(); $this->formArray["treasurerFirstName"] = $erptsSettings->getTreasurerFirstName(); $this->formArray["treasurerMiddleName"] = $erptsSettings->getTreasurerMiddleName(); $this->formArray["treasurerLastName"] = $erptsSettings->getTreasurerLastName(); } } $LandSubclassesList = new SoapObject(NCCBIZ . "LandSubclassesList.php", "urn:Object"); $condition = " WHERE status='active' "; $condition .= $this->sortBlocks(); $this->tpl->set_var("activeInactive", "(active ONLY)"); if (!($xmlStr = $LandSubclassesList->getLandSubclassesList(0, $condition))) { $this->tpl->set_block("rptsTemplate", "Table", "TableBlock"); $this->tpl->set_var("TableBlock", "database is empty"); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { $this->tpl->set_block("rptsTemplate", "Table", "TableBlock"); $this->tpl->set_var("TableBlock", "error xmlDoc"); } else { $landSubclassesRecords = new LandSubclassesRecords(); $landSubclassesRecords->parseDomDocument($domDoc); $list = $landSubclassesRecords->getArrayList(); $this->tpl->set_var("totalRecords", count($list)); $this->tpl->set_block("rptsTemplate", "LandSubclassesList", "LandSubclassesListBlock"); foreach ($list as $key => $listValue) { $this->tpl->set_var("landSubclassesID", $listValue->getLandSubclassesID()); $this->tpl->set_var("code", $listValue->getCode()); $this->tpl->set_var("description", $listValue->getDescription()); $this->tpl->set_var("value", $listValue->getValue()); $this->tpl->set_var("status", $listValue->getStatus()); $this->tpl->set_var("statusCheck", $this->getStatusCheck($listValue->getStatus())); $this->tpl->parse("LandSubclassesListBlock", "LandSubclassesList", true); } } } $this->setForm(); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); }
function Main() { $this->setForm(); $this->tpl->set_block("rptsTemplate", "ReceiptPage", "ReceiptPageBlock"); $pageNumber = 1; $ReceiptDetails = new SoapObject(NCCBIZ . "ReceiptDetails.php", "urn:Object"); $CollectionList = new SoapObject(NCCBIZ . "CollectionList.php", "urn:Object"); $PaymentDetails = new SoapObject(NCCBIZ . "PaymentDetails.php", "urn:Object"); foreach ($this->formArray["receiptIDArray"] as $receiptID) { $this->tpl->set_var("pageNumber", $pageNumber); $totalAmountPaid = 0; $eRPTSSettings = $this->getERPTSSettingsDetails(); if ($eRPTSSettings->getLguType() == "City") { $this->setvar("city", $eRPTSSettings->getLguName()); $this->setvar("province", ""); } else { $this->setvar("city", ""); $this->setvar("province", $eRPTSSettings->getLguName()); } if (!($xmlStr = $ReceiptDetails->getReceipt($receiptID))) { //exit("xml failed."); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { //exit("error domDoc"); } else { $receipt = new Receipt(); $receipt->parseDomDocument($domDoc); $this->setvar("prevORNum", $receipt->getPreviousReceiptNumber()); $porMonth = ""; $porDay = ""; $porYear = ""; if ($receipt->getPreviousReceiptDate() != "0000-00-00") { $porMonth = date("F", strtotime($receipt->getPreviousReceiptDate())); $porDay = date("d", strtotime($receipt->getPreviousReceiptDate())); $porYear = date("Y", strtotime($receipt->getPreviousReceiptDate())); } $this->setvar("porMonth", $porMonth); $this->setvar("porDay", $porDay); $this->setvar("porYear", $porYear); $this->setvar("orNum", $receipt->getReceiptNumber()); $orDate = ""; if ($receipt->getReceiptDate() != "0000-00-00") { $orDate = date("F d, Y", strtotime($receipt->getReceiptDate())); } $this->setvar("orDate", $orDate); $this->setvar("receivedFrom", $this->getReceivedFromName($receipt->getReceivedFrom())); $this->setvar("paymentMode", $receipt->getPaymentMode()); if ($receipt->getPaymentMode() == "check") { $this->setvar("checkNumber", "using Check Number : " . $receipt->getCheckNumber()); $this->setvar("dateOfCheck", " dated " . date("F d, Y", strtotime($receipt->getDateOfCheck()))); $this->setvar("draweeBank", "(" . $receipt->getDraweeBank() . ")"); } $this->setvar("cityTreasurer", $this->getPersonName($receipt->getCityTreasurer())); $this->setvar("deputyTreasurer", $this->getPersonName($receipt->getDeputyTreasurer())); if (!($collectionXmlStr = $CollectionList->getCollectionListFromReceiptID($receiptID))) { // xml failed } else { if (!($collectionDomDoc = domxml_open_mem($collectionXmlStr))) { // error domDoc } else { $collectionRecords = new CollectionRecords(); $collectionRecords->parseDomDocument($collectionDomDoc); $collectionArrayList = $collectionRecords->getArrayList(); $i = 0; foreach ($collectionArrayList as $collection) { $i++; if ($i <= 1) { if ($collection->getTaxType() == "basic") { $this->setvar("receiptType", "[ X ] BASIC TAX [ ] SPECIAL EDUCATION FUND"); } else { if ($collection->getTaxType() == "sef") { $this->setvar("receiptType", "[ ] BASIC TAX [ X ] SPECIAL EDUCATION FUND"); } else { if ($collection->getTaxType() == "idle") { $this->setvar("receiptType", "[ ] BASIC TAX [ ] SPECIAL EDUCATION FUND [ X ] IDLE TAX"); } } } } $paymentID = $collection->getPaymentID(); if (!($paymentXmlStr = $PaymentDetails->getPayment($paymentID))) { // xml failed } else { if (!($paymentDomDoc = domxml_open_mem($paymentXmlStr))) { // error domDoc } else { $payment = new Payment(); $payment->parseDomDocument($paymentDomDoc); $assessedValue = 0; // added "orYear" for fix of Feb 08, 2005 $this->formArray["orYear"] = substr($payment->dueDate, 0, 4); $this->setvar("orYear", $this->formArray["orYear"], false); if ($i <= 6) { $this->setvar("ownerName" . $i, $this->getReceivedFromName($receipt->getReceivedFrom())); if ($payment->getDueID() != "" && $payment->getDueID() != "0") { // due payment $due = $this->getDue($payment->getDueID()); $td = $this->getTD($due->getTdID()); $afs = $this->getAFS($td->getAfsID()); $tdNum = $td->getTaxDeclarationNumber(); if ($td->getPropertyType() == "Land") { $this->setvar("assessedValueLand" . $i, $afs->getTotalAssessedValue(), true); } else { $this->setvar("assessedValueOthers" . $i, $afs->getTotalAssessedValue(), true); } $assessedValue = $afs->getTotalAssessedValue(); if ($payment->getDueType() == "Annual") { // commented out: February 08, 2005 // "fullPmt" must be total paid less penalties... (tax due) //$this->setvar("fullPmt".$i,$collection->getBalanceDue(),true); $this->setvar("fullPmt" . $i, $collection->getTaxDue(), true); } else { $this->setvar("num" . $i, $payment->getDueType()); // commented out: February 08, 2005 // $this->setvar("partialPmt".$i,$collection->getBalanceDue(),true); $this->setvar("partialPmt" . $i, $collection->getTaxDue(), true); } } else { if ($payment->getBacktaxTDID() != "" && $payment->getBacktaxTDID() != "0") { // backtaxtd payment $backtaxTD = $this->getBacktaxTD($payment->getBacktaxTDID()); $parentTD = $this->getTD($backtaxTD->getTdID()); $afs = $this->getAFS($parentTD->getAfsID()); $tdNum = $backtaxTD->getTDNumber(); $assessedValue = $backtaxTD->getAssessedValue(); if ($payment->getDueType() == "Annual") { // commented out: February 08, 2005 // $this->setvar("fullPmt".$i,$collection->getBalanceDue(),true); $this->setvar("fullPmt" . $i, $collection->getTaxDue(), true); } else { $this->setvar("num" . $i, $payment->getDueType()); // commented out: February 08, 2005 // $this->setvar("partialPmt".$i,$collection->getBalanceDue(),true); $this->setvar("partialPmt" . $i, $collection->getTaxDue(), true); } } } $od = $this->getOD($afs->getOdID()); $this->setvar("lotAddress" . $i, $od->locationAddress->getStreet() . ", " . $od->locationAddress->getBarangay()); $this->setvar("blockNumber" . $i, $od->getLotNumber() . ", " . $od->getBlockNumber()); $this->setvar("landClass" . $i, $payment->getPropertyClassification()); $this->setvar("tdNum" . $i, $tdNum); $this->setvar("dueDate" . $i, "(" . substr($payment->getDueDate(), 0, 4) . ")"); $this->setvar("assessedValue" . $i, $assessedValue, true); $this->setvar("subTotal" . $i, $collection->getTaxDue(), true); if ($collection->getPenalty() > 0) { if ($collection->getAmnesty() == "true") { // $this->setvar("penalty".$i,round((($collection->getPenalty()/$collection->getTaxDue())*100)) . " % (amnesty)",true); $this->setvar("penalty" . $i, $collection->getPenalty()); } else { // $this->setvar("penalty".$i,round((($collection->getPenalty()/$collection->getTaxDue())*100)) . " %",true); $this->setvar("penalty" . $i, $collection->getPenalty()); } } $this->setvar("grandTotal" . $i, $collection->getAmountPaid(), true); $totalAmountPaid += $collection->getAmountPaid(); //Inserted by cht 07282008 $sefTotal = $total; $netAmountPaid = $totalAmountPaid * 2; //End } } } } } // ORIG //$this->setvar("total",$totalAmountPaid,true); //$this->setvar("amountPaid",$totalAmountPaid,true); //$totalInWords = makewords($totalAmountPaid); $this->setvar("sefTotal", $totalAmountPaid, true); $this->setvar("total", $totalAmountPaid, true); $this->setvar("amountPaid", $netAmountPaid, true); $totalInWords = makewords($netAmountPaid); // $totalInWords = "One Hundred Thousand Two Hundred Thirty Four Pesos And Fifty Seven Centavos Only"; if (strlen($totalInWords) < 62) { $this->setvar("y1TotalInWords", "254"); } else { $this->setvar("y1TotalInWords", "263"); } $this->setvar("totalInWords", $totalInWords); } } } $this->tpl->parse("ReceiptPageBlock", "ReceiptPage", true); $pageNumber++; $this->clearLine(); } //exit; $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); } }