function getTDNumber($tdID, $backtaxTDID) { if ($tdID != "") { $td = new TD(); $td->selectRecord($tdID); $tdNumber = $td->getTaxDeclarationNumber(); } else { if ($backtaxTDID != "") { $backtaxTD = new BacktaxTD(); $backtaxTD->selectRecord("", $backtaxTDID); $tdNumber = $backtaxTD->getTDNumber(); } } return $tdNumber; }
function displayDetails($value) { foreach ($value as $lkey => $lvalue) { switch ($lkey) { case "propertyAdministrator": if (is_a($lvalue, Person)) { list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $lvalue->getBirthday()); $this->tpl->set_var("personID", $lvalue->getPersonID()); $this->tpl->set_var("lastName", $lvalue->getLastName()); $this->tpl->set_var("firstName", $lvalue->getFirstName()); $this->tpl->set_var("middleName", $lvalue->getMiddleName()); $this->tpl->set_var("gender", $lvalue->getGender()); $this->tpl->set_var("birth_year", removePreZero($dateArr["year"])); $this->tpl->set_var("birth_month", removePreZero($dateArr["month"])); $this->tpl->set_var("birth_day", removePreZero($dateArr["day"])); $this->tpl->set_var("maritalStatus", $lvalue->getMaritalStatus()); $this->tpl->set_var("tin", $lvalue->getTin()); $this->tpl->set_var("addressID", $lvalue->addressArray[0]->getAddressID()); $this->tpl->set_var("number", $lvalue->addressArray[0]->getNumber()); $this->tpl->set_var("street", $lvalue->addressArray[0]->getStreet()); $this->tpl->set_var("barangay", $lvalue->addressArray[0]->getBarangay()); $this->tpl->set_var("district", $lvalue->addressArray[0]->getDistrict()); $this->tpl->set_var("municipalityCity", $lvalue->addressArray[0]->getMunicipalityCity()); $this->tpl->set_var("province", $lvalue->addressArray[0]->getProvince()); $this->tpl->set_var("telephone", $lvalue->getTelephone()); $this->tpl->set_var("mobileNumber", $lvalue->getMobileNumber()); $this->tpl->set_var("email", $lvalue->getEmail()); } else { $this->tpl->set_var($lkey, ""); } break; case "verifiedBy": if (is_a($lvalue, Assessor)) { $this->tpl->set_var("verifiedByID", $lvalue->getAssessorID()); $this->tpl->set_var("verifiedByName", $lvalue->getFullName()); } else { $this->tpl->set_var($lkey, ""); } break; case "plottingsBy": if (is_a($lvalue, Assessor)) { $this->tpl->set_var("plottingsByID", $lvalue->getAssessorID()); $this->tpl->set_var("plottingsByName", $lvalue->getFullName()); } else { $this->tpl->set_var($lkey, ""); } break; case "notedBy": if (is_a($lvalue, Assessor)) { $this->tpl->set_var("notedByID", $lvalue->getAssessorID()); $this->tpl->set_var("notedByName", $lvalue->getFullName()); } else { $this->tpl->set_var($lkey, ""); } break; case "appraisedBy": if (is_a($lvalue, Assessor)) { $this->tpl->set_var("appraisedByID", $lvalue->getAssessorID()); $this->tpl->set_var("appraisedByName", $lvalue->getFullName()); } else { $this->tpl->set_var($lkey, ""); } break; case "appraisedByDate": if (true) { list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $lvalue); $this->tpl->set_var("as_yearValue", removePreZero($dateArr["year"])); eval(MONTH_ARRAY); //$monthArray $this->tpl->set_var("as_month", $monthArray[removePreZero($dateArr["month"])]); $this->tpl->set_var("as_dayValue", removePreZero($dateArr["day"])); } else { $this->tpl->set_var($lkey, ""); } break; case "recommendingApproval": if (is_a($lvalue, Assessor)) { $this->tpl->set_var("recommendingApprovalID", $lvalue->getAssessorID()); $this->tpl->set_var("recommendingApprovalName", $lvalue->getFullName()); } else { $this->tpl->set_var($lkey, ""); } break; case "recommendingApprovalDate": if (true) { list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $lvalue); $this->tpl->set_var("re_yearValue", removePreZero($dateArr["year"])); eval(MONTH_ARRAY); //$monthArray $this->tpl->set_var("re_month", $monthArray[removePreZero($dateArr["month"])]); $this->tpl->set_var("re_dayValue", removePreZero($dateArr["day"])); } else { $this->tpl->set_var($lkey, ""); } case "approvedBy": if (is_a($lvalue, Assessor)) { $this->tpl->set_var("approvedByID", $lvalue->getAssessorID()); $this->tpl->set_var("approvedByName", $lvalue->getFullName()); } else { $this->tpl->set_var($lkey, ""); } break; case "approvedByDate": if (true) { list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $lvalue); $this->tpl->set_var("av_yearValue", removePreZero($dateArr["year"])); eval(MONTH_ARRAY); //$monthArray $this->tpl->set_var("av_month", $monthArray[removePreZero($dateArr["month"])]); $this->tpl->set_var("av_dayValue", removePreZero($dateArr["day"])); } else { $this->tpl->set_var($lkey, ""); } break; case "dateConstructed": if (true) { list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $lvalue); $this->tpl->set_var("dc_yearValue", removePreZero($dateArr["year"])); eval(MONTH_ARRAY); //$monthArray $this->tpl->set_var("dc_month", $monthArray[removePreZero($dateArr["month"])]); $this->tpl->set_var("dc_dayValue", removePreZero($dateArr["day"])); } else { $this->formArray[$key] = ""; } break; case "dateOccupied": if (true) { list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $lvalue); $this->tpl->set_var("do_yearValue", removePreZero($dateArr["year"])); eval(MONTH_ARRAY); //$monthArray $this->tpl->set_var("do_month", $monthArray[removePreZero($dateArr["month"])]); $this->tpl->set_var("do_dayValue", removePreZero($dateArr["day"])); } else { $this->formArray[$key] = ""; } break; case "dateCompleted": if (true) { list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $lvalue); $this->tpl->set_var("dm_yearValue", removePreZero($dateArr["year"])); eval(MONTH_ARRAY); //$monthArray $this->tpl->set_var("dm_month", $monthArray[removePreZero($dateArr["month"])]); $this->tpl->set_var("dm_dayValue", removePreZero($dateArr["day"])); } else { $this->formArray[$key] = ""; } break; case "dateAcquired": if (true) { list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $lvalue); $this->tpl->set_var("da_yearValue", removePreZero($dateArr["year"])); eval(MONTH_ARRAY); //$monthArray $this->tpl->set_var("da_month", $monthArray[removePreZero($dateArr["month"])]); $this->tpl->set_var("da_dayValue", removePreZero($dateArr["day"])); } else { $this->formArray[$key] = ""; } break; case "dateOfInstallation": if (true) { list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $lvalue); $this->tpl->set_var("di_yearValue", removePreZero($dateArr["year"])); eval(MONTH_ARRAY); //$monthArray $this->tpl->set_var("di_month", $monthArray[removePreZero($dateArr["month"])]); $this->tpl->set_var("di_dayValue", removePreZero($dateArr["day"])); } else { $this->formArray[$key] = ""; } break; case "dateOfOperation": if (true) { list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $lvalue); $this->tpl->set_var("do_yearValue", removePreZero($dateArr["year"])); eval(MONTH_ARRAY); //$monthArray $this->tpl->set_var("do_month", $monthArray[removePreZero($dateArr["month"])]); $this->tpl->set_var("do_dayValue", removePreZero($dateArr["day"])); } else { $this->formArray[$key] = ""; } break; case "propertyID": if (true) { switch (get_class($value)) { case "land": $propertyType = "Land"; break; case "improvementsbuildings": $propertyType = "ImprovementsBuildings"; break; case "plantstrees": $propertyType = "PlantsTrees"; break; case "machineries": $propertyType = "Machineries"; break; } $this->tpl->set_var($lkey, $lvalue); $TDDetails = new SoapObject(NCCBIZ . "TDDetails.php", "urn:Object"); if (!($xmlStr = $TDDetails->getTD("", $lvalue, $propertyType))) { $this->tpl->set_var("tdNumber", "enter TD"); $this->tpl->set_var("tdID", ""); $this->tpl->set_var("propertyType", $propertyType); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { $this->tpl->set_var("tdNumber", "enter TD"); $this->tpl->set_var("tdID", ""); $this->tpl->set_var("propertyType", $propertyType); } else { $td = new TD(); $td->parseDomDocument($domDoc); $this->tpl->set_var("tdNumber", $td->getTaxDeclarationNumber()); foreach ($td as $tdkey => $tdvalue) { switch ($tdkey) { case "provincialAssessor": if (is_a($tdvalue, Assessor)) { $this->tpl->set_var("provincialAssessorID", $tdvalue->getAssessorID()); $this->tpl->set_var("provincialAssessorName", $tdvalue->getFullName()); } else { $this->tpl->set_var($tdkey, ""); } break; case "provincialAssessorDate": if (true) { list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $tdvalue); $this->tpl->set_var("pa_yearValue", removePreZero($dateArr["year"])); eval(MONTH_ARRAY); //$monthArray $this->tpl->set_var("pa_month", $monthArray[removePreZero($dateArr["month"])]); $this->tpl->set_var("pa_dayValue", removePreZero($dateArr["day"])); } else { $this->tpl->set_var($tdkey, ""); } break; case "cityMunicipalAssessor": if (is_a($tdvalue, Assessor)) { $this->tpl->set_var("cityMunicipalAssessorID", $tdvalue->getAssessorID()); $this->tpl->set_var("cityMunicipalAssessorName", $tdvalue->getFullName()); } else { $this->tpl->set_var($tdkey, ""); } break; case "cityMunicipalAssessorDate": if (true) { list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $tdvalue); $this->tpl->set_var("cm_yearValue", removePreZero($dateArr["year"])); eval(MONTH_ARRAY); //$monthArray $this->tpl->set_var("cm_month", $monthArray[removePreZero($dateArr["month"])]); $this->tpl->set_var("cm_dayValue", removePreZero($dateArr["day"])); } else { $this->tpl->set_var($tdkey, ""); } break; case "enteredInRPARForBy": if (is_a($tdvalue, Assessor)) { $this->tpl->set_var("enteredInRPARForByID", $tdvalue->getAssessorID()); $this->tpl->set_var("enteredInRPARForByName", $tdvalue->getFullName()); } else { $this->tpl->set_var($tdkey, ""); } break; default: $this->tpl->set_var($tdkey, $tdvalue); } } } } } else { $this->formArray[$key] = ""; } break; default: $this->tpl->set_var($lkey, $lvalue); } } }
function displayTDDetails($propertyType) { $afsID = $this->formArray["afsID"]; $propertyID = $this->formArray["propertyID"]; $TDDetails = new SoapObject(NCCBIZ . "TDDetails.php", "urn:Object"); if (!($xmlStr = $TDDetails->getTD("", $afsID, $propertyID, $propertyType))) { $this->formArray["tdNumber"] = ""; $this->formArray["tdID"] = ""; $this->formArray["propertyType"] = $propertyType; } else { if (!($domDoc = domxml_open_mem($xmlStr))) { $this->formArray["tdNumber"] = ""; $this->formArray["tdID"] = ""; $this->formArray["propertyType"] = $propertyType; } else { $td = new TD(); $td->parseDomDocument($domDoc); $this->formArray["tdNumber"] = $td->getTaxDeclarationNumber(); foreach ($td as $tdkey => $tdvalue) { switch ($tdkey) { case "provincialAssessor": if (is_a($tdvalue, Assessor)) { $this->formArray["provincialAssessorID"] = $tdvalue->getAssessorID(); $this->formArray["provincialAssessorName"] = $tdvalue->getFullName(); } else { $this->formArray[$tdkey] = ""; } break; case "provincialAssessorDate": if (true) { list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $tdvalue); $this->formArray["pa_yearValue"] = removePreZero($dateArr["year"]); eval(MONTH_ARRAY); //$monthArray $this->formArray["pa_month"] = $monthArray[removePreZero($dateArr["month"])]; $this->formArray["pa_dayValue"] = removePreZero($dateArr["day"]); } else { $this->formArray[$tdkey] = ""; } break; case "cityMunicipalAssessor": if (is_a($tdvalue, Assessor)) { $this->formArray["cityMunicipalAssessorID"] = $tdvalue->getAssessorID(); $this->formArray["cityMunicipalAssessorName"] = $tdvalue->getFullName(); } else { $this->formArray[$tdkey] = ""; } break; case "cityMunicipalAssessorDate": if (true) { list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $tdvalue); $this->formArray["cm_yearValue"] = removePreZero($dateArr["year"]); eval(MONTH_ARRAY); //$monthArray $this->formArray["cm_month"] = $monthArray[removePreZero($dateArr["month"])]; $this->formArray["cm_dayValue"] = removePreZero($dateArr["day"]); } else { $this->formArray[$tdkey] = ""; } break; case "enteredInRPARForBy": if (is_a($tdvalue, Assessor)) { $this->formArray["enteredInRPARForByID"] = $tdvalue->getAssessorID(); $this->formArray["enteredInRPARForByName"] = $tdvalue->getFullName(); } else { $this->formArray[$tdkey] = ""; } break; default: $this->formArray[$tdkey] = $tdvalue; } } } } }
function displayTDDetails() { $afsID = $this->formArray["afsID"]; $TDDetails = new SoapObject(NCCBIZ . "TDDetails.php", "urn:Object"); if (!($xmlStr = $TDDetails->getTD("", $afsID, "", ""))) { // error xml } else { if (!($domDoc = domxml_open_mem($xmlStr))) { // error domDoc } else { $td = new TD(); $td->parseDomDocument($domDoc); $this->formArray["taxDeclarationNumber"] = $td->getTaxDeclarationNumber(); $this->formArray["memoranda"] = $td->getMemoranda(); $this->formArray["cancelsTDNumber"] = $td->getCancelsTDNumber(); //cityMunicipalAssessor if (is_numeric($td->getCityMunicipalAssessor())) { $cityMunicipalAssessor = new Person(); $cityMunicipalAssessor->selectRecord($td->cityMunicipalAssessor); $this->formArray["cityAssessor"] = $cityMunicipalAssessor->getFullName(); } else { $this->formArray["cityAssessor"] = $td->getCityMunicipalAssessor; } $this->formArray["propertyType"] = $td->getPropertyType(); } } }
function displayRecords() { $this->selectRecords(); $this->tpl->set_block("rptsTemplate", "OwnerPersonList", "OwnerPersonListBlock"); $this->tpl->set_block("OwnerPersonList", "ODList", "ODListBlock"); foreach ($this->arrayList as $person) { $this->tpl->set_var("personID", $person->getPersonID()); $this->tpl->set_var("lastName", $person->getLastName()); $this->tpl->set_var("firstName", $person->getFirstName()); $this->tpl->set_var("middleName", $person->getMiddleName()); $this->tpl->set_var("gender", $person->getGender()); $this->tpl->set_var("birthday", $person->getBirthday()); $this->tpl->set_var("maritalStatus", $person->getMaritalStatus()); $this->tpl->set_var("tin", $person->getTin()); $this->tpl->set_var("telephone", $person->getTelephone()); $this->tpl->set_var("mobileNumber", $person->getMobileNumber()); $this->tpl->set_var("email", $person->getEmail()); if (is_array($person->addressArray)) { $address = $person->addressArray[0]; $this->tpl->set_var("address", $address->getFullAddress()); } // capture OD, AFS, and TD info $this->setDB(); $sql = sprintf("SELECT DISTINCT(Owner.odID) as odID" . " FROM Owner,OwnerPerson " . " WHERE " . " Owner.ownerID = OwnerPerson.ownerID AND " . " OwnerPerson.personID = '%s' ", $person->getPersonID()); $this->db->query($sql); while ($this->db->next_record()) { $od = new OD(); if ($od->selectRecord($this->db->f("odID"))) { $this->ODArray[] = $od; $this->tpl->set_var("odID", $od->getOdID()); if (is_object($od->locationAddress)) { $this->tpl->set_var("locationAddress", $od->locationAddress->getFullAddress()); } else { $this->tpl->set_var("locationAddress", ""); } $afs = new AFS(); if ($afs->selectRecord("", "", $od->getOdID(), "")) { $this->tpl->set_var("afsID", $afs->getAfsID()); $this->tpl->set_var("propertyIndexNumber", $afs->getPropertyIndexNumber()); $this->tpl->set_var("arpNumber", $afs->getArpNumber()); if (is_array($afs->landArray)) { $this->displayLandList($afs->landArray); } if (is_array($afs->plantsTreesArray)) { $this->displayPlantsTreesList($afs->plantsTreesArray); } if (is_array($afs->improvementsBuildingsArray)) { $this->displayImprovementsBuildingsList($afs->improvementsBuildingsArray); } if (is_array($afs->machineriesArray)) { $this->displayMachineriesList($afs->machineriesArray); } $td = new TD(); if ($td->selectRecord("", $afs->getAfsID(), "", "", "")) { $this->tpl->set_var("tdID", $td->getTdID()); $this->tpl->set_var("taxDeclarationNumber", $td->getTaxDeclarationNumber()); $this->tpl->set_var("propertyType", $td->getPropertyType()); } } unset($td); unset($afs); unset($od); $this->tpl->parse("ODListBlock", "ODList", true); } } $this->tpl->parse("OwnerPersonListBlock", "OwnerPersonList", true); $this->tpl->set_var("ODListBlock", ""); $this->clearPropertyElements(); unset($this->ODArray); unset($this->AFSArray); unset($this->TDArray); unset($this->db); } }
function setDetails() { global $sess; # set the RPTOP to get the owner's object and information # get it from POST if possible, otherwise from GET $rptopID = isset($_POST['rptopID']) ? $_POST['rptopID'] : $_GET['rptopID']; //$rptopID = 14; $rptop = new RPTOP(); $rptop->selectRecord($rptopID); $amountPaid = str_replace(",", "", $_POST['amountPaid']); $dateDue = $rptop->getTaxableYear(); # must be a usable format $formValues['datePaid'] = date("F j, Y"); $pORDate = $_POST['prevORDate']; if ($pORDate) { list($pmonth, $pday, $pyear) = explode("-", $pORDate); $formValues['porMonth'] = date("F", mktime(0, 0, 0, $pmonth + 1, 0, 0)); $formValues['porYear'] = $pyear; $formValues['porDay'] = $pday; } else { $formValues['porMonth'] = ""; $formValues['porYear'] = ""; $formValues['porDay'] = ""; } $formValues['orYear'] = substr($rptop->getTaxableYear(), 2); $formValues['orMonth'] = date("F"); $formValues['orDay'] = date("j"); $formValues['taxableYear'] = $rptop->getTaxableYear(); $formValues['rptopNum'] = $rptop->getRptopNumber(); $formValues['prevORNum'] = $_POST['prevORNum']; $formValues['orNum'] = $_POST['receiptNo']; $formValues['kindOfPayment'] = $_POST['kindOfPayment']; $formValues['checkNumber'] = $_POST['checkNum']; $formValues['checkDate'] = $_POST['checkDate']; # set the specific TD (although this is in the RPTOP), hard to search for it. # get the tdID from POST or GET to initialize the TD $tdID = isset($_POST['tdID']) ? $_POST['tdID'] : $_GET['tdID']; //$tdID = array(2,1); //$ownerID=5; $td = new TD(); $ctr = 0; # $this->tpl->set_block('step3','PrintTDID','PrintTDIDs'); //$this->tpl->set_block('step3','TDID','TDIDs'); $this->tpl->set_block('receipt', 'Property', 'Properties'); $this->tpl->set_block('Property', 'Owner', 'Owners'); $n = 165; if (is_array($tdID)) { foreach ($tdID as $key => $id) { # set/pass tdIDs to form $this->tpl->set_var(tdID, $id); $this->tpl->parse('TDIDs', 'TDID', 'true'); $td->selectRecord($id); $tdNum = $td->getTaxDeclarationNumber(); $afs = new AFS(); $formValues['tdNum'] = $tdNum; $afs->selectRecord($td->getAfsID()); $od = new OD(); $od->selectRecord($afs->getOdID()); $addr = $od->getLocationAddress(); # get municipality/province and city(same for all tds) //$lotAddress = new LocationAddress; //$lotAddress->selectRecordFromTdID($id); //$formValues['province'] = $lotAddress->getProvince(); //$formValues['city'] = $lotAddress->getMunicipalityCity(); $formValues['city'] = $addr->getMunicipalityCity(); $formValues['province'] = $addr->getProvince(); $formValues['municipalityCityID'] = $addr->getMunicipalityCityID(); # get location/ block and lot number OR Barangay #$formValues['lotAddress'] = $lotAddress->getFullAddress(); $formValues['lotAddress'] = $addr->getNumber . " " . $addr->getStreet(); if ($formValues['lotAddress'] == "") { $formValues['lotAddress'] = $addr->getBarangay(); } $propertyType = $td->getPropertyType(); $propertyID = $td->getPropertyID(); $assessedValue = number_format($td->getAssessedValue(), 2, ".", ""); $formAssessedValue = number_format($td->getAssessedValue(), 2); # separate assessed value of land and others(plantsTrees, improvementsBuildings, machineries) if ($propertyType == "Land") { $formValues['assessedValueLand'] = $formAssessedValue; $formValues['assessedValueOthers'] = ""; } else { $formValues['assessedValueLand'] = ""; $formValues['assessedValueOthers'] = $formAssessedValue; } $formValues['assessedValue'] = $formAssessedValue; $formValues['propertyType'] = $propertyType; # set the owner's List # we define the owner from the RPTOP $ownerSwitch = true; if ($ctr > 0) { $ownerValues['ownerName'] = ""; $ownerValues['ownerAddress'] = ""; $this->tpl->set_var($ownerValues); $this->tpl->parse(Owners, Owner, false); } else { $owner = $rptop->getOwner(); $personArray = $owner->getPersonArray(); if (is_array($personArray)) { foreach ($personArray as $person) { $ownerValues['ownerKey'] = "personID"; $ownerValues['ownerScript'] = "PersonDetails.php"; $ownerValues['ownerID'] = $person->getPersonID(); $ownerValues['ownerName'] = $person->getLastName() . ", " . $person->getFirstName() . " " . $person->getMiddleName(); /*$addressArray = $person->getAddressArray(); $address = $addressArray[0]; $ownerValues['ownerAddress'] = $address->getNumber()." ". $address->getStreet()."<br>". $address->getBarangay().", ". $address->getMunicipalityCity()."<br>". $address->getProvince();*/ $this->tpl->set_var($ownerValues); $this->tpl->parse('Owners', 'Owner', 'true'); } } $companyArray = $owner->getCompanyArray(); if (is_array($companyArray)) { foreach ($companyArray as $company) { $ownerValues['cownerKey'] = "companyID"; $ownerValues['cownerScript'] = "CompanyDetails.php"; $ownerValues['cownerID'] = $company->getCompanyID(); $ownerValues['cownerName'] = $company->getCompanyName(); /*$addressArray = $company->getAddressArray(); $address = $addressArray[0]; $ownerValues['ownerAddress'] = $address->getNumber()." ". $address->getStreet()."<br>". $address->getBarangay().", ". $address->getMunicipalityCity()."<br> ". $address->getProvince(); */ $this->tpl->set_var($ownerValues); $this->tpl->parse('Owners', 'Owner', 'true'); } } if (is_array($personArray)) { if (count($personArray) > 1) { $receivedFrom = $personArray[0]->getFirstName() . " " . $personArray[0]->getMiddleName() . " " . $personArray[0]->getLastName() . " et al."; } else { $receivedFrom = $personArray[0]->getFirstName() . " " . $personArray[0]->getMiddleName() . " " . $personArray[0]->getLastName(); } } else { if (is_array($companyArray)) { if (count($companyArray) > 1) { $receivedFrom = $companyArray[0]->getCompanyName() . " et al."; } else { $receivedFrom = $companyArray[0]->getCompanyName(); } } } $formValues['receivedFrom'] = $receivedFrom; } //end if ($ctr > 0) # tax dues are defined from TDNumber and taxableYear # compute for taxes; to create dues obj pass tdID and due date (where due date is beginning of taxable year) -- 14 Aug 2003 // $taxDue = new Dues($id,$dateDue,$assessedValue); $taxDue = new Dues(); /* if(!$taxDue->create($id,$dateDue)){ $taxDue->setBasic($assessedValue); $taxDue->setSEF($assessedValue); # check if land is idle, if yes, set assessed value if($taxDue->getIdleStatus() == 1){ $taxDue->setIdle($assessedValue); $idleStatus = 1; }else{ $taxDue->setIdle(0); $idleStatus = 0; } } */ $dateDue = $td->getTaxBeginsWithTheYear(); $taxDue = new Dues($id, $dateDue); if (!$taxDue->create($id, $dateDue)) { $taxDue->setBasic($assessedValue); $taxDue->setSEF($assessedValue); $taxDue->setIsDiscount(0); # check if land is idle, if yes, set assessed value # getIdleStatus -- temporary function if ($taxDue->getIdleStatus() == 1) { #echo("idle<br>"); $taxDue->setIdle($assessedValue); } } else { $taxDue->setIsDiscount($dateDue == date("Y") && date("n") <= $taxDue->discountPeriod && $taxDue->getPaymentMode() == "Annual"); } $paymentPeriod = $_POST['paymentPeriod']; # set amnesty to object //$amnesty = $_POST['amnesty']; //$taxDue->setAmnesty($amnesty=="Yes"); // $taxDue->store(); $totalTaxDue = $taxDue->getTotalDue($paymentPeriod); $totalAmount = $taxDue->getTotalDue($paymentPeriod); // $paymentPeriod= "Annual"; /* if(isset($_POST['paymentPeriod'])){ $paymentPeriod = $_POST['paymentPeriod']; }*/ $formValues['paymentPeriod'] = $paymentPeriod; $this->tpl->set_var($formValues); ## Compute taxes and set the page values //$totalTaxDue = $taxDue->getTotalDue($paymentPeriod); $interest = $taxDue->getPctPenalty(); if ($interest > 0 && $paymentPeriod != "Annual") { $paymentPeriod = "Annual"; } $basic = $taxDue->getBalanceBasic($paymentPeriod); $sef = $taxDue->getBalanceSEF($paymentPeriod); $idle = $taxDue->getBalanceIdle($paymentPeriod); $discount = $taxDue->getDiscount($basic + $sef); $penalty = $taxDue->getBalancePenalty($paymentPeriod); $taxValues['idleStatus'] = $idleStatus == 0 ? "" : "(I)"; $taxValues['basic'] = number_format($basic, 2); $taxValues['sef'] = number_format($sef, 2); $taxValues['pd1185'] = number_format(0.0, 2); $taxValues['subTotal'] = number_format($totalTaxDue, 2); $taxValues['periodTotal'] = number_format($basic + $sef + $idle, 2); $taxValues['interest'] = number_format($interest * 100.0, 1) . "%"; $taxValues['penalty'] = number_format($interest * 100, 0); $taxValues['discount'] = number_format($discount * 100.0, 1) . "%"; $taxValues['totBasic'] = number_format($basic * (1 + $interest), 2); $taxValues['totSEF'] = number_format($sef * (1 + $interest), 2); $taxValues['totPD1185'] = number_format(0, 2); $taxValues['totSubTotal'] = number_format(round($totalTaxDue, 2), 2); $taxValues['grandTotal'] = number_format($totalTaxDue, 2); # further breakdown of basic tax for RPT Receipt $taxValues['gf'] = number_format($basic * 0.7, 2); // 70% of basic $taxValues['ib'] = number_format($basic * 0.15, 2); // 15% of basic $taxValues['cb'] = number_format($basic * 0.15, 2); // 15% of basic for a total if 100% $taxValues['totGF'] = number_format($basic * 0.7 * (1 + $interest), 2); $taxValues['totIB'] = number_format($basic * 0.15 * (1 + $interest), 2); $taxValues['totCB'] = number_format($basic * 0.15 * (1 + $interest), 2); if ($paymentPeriod == "Annual") { $this->tpl->set_var("fullPmt", $taxValues['subTotal']); $this->tpl->set_var("partialPmt", ""); # get full payment total $fullPmtTotal += str_replace(",", "", $taxValues['subTotal']); $this->tpl->set_var("fullPmtTotal", number_format($fullPmtTotal, 2)); } else { $this->tpl->set_var("partialPmt", $taxValues['subTotal']); $this->tpl->set_var("num", ceil(date("n") / 3)); $this->tpl->set_var("fullPmt", ""); # get partial payment total $partialPmtTotal += str_replace(",", "", $taxValues['subTotal']); $this->tpl->set_var("partialPmtTotal", number_format($partialPmtTotal, 2)); } $this->tpl->set_var($taxValues); $this->tpl->parse('Properties', 'Property', 'true'); $ctr++; # get totals for penalty and grand total # $penaltyTotal += ($basic*$interest); -- removed bec penalty in percent $total += $totalTaxDue; # $this->tpl->set_var("penaltyTotal", number_format($penaltyTotal,2)); } } # end foreach if ($total > $totalTaxDue) { $totalTaxDue = $total; } // if backtaxTDCheckbox is checked if ($_POST['backtaxTDCheckbox'] && $_POST['backtaxTDCheckbox'] != "") { $totalTaxDue += $this->displayBacktaxTD($ownerSwitch); $fullPmtTotal = $totalTaxDue; $this->tpl->set_var("fullPmtTotal", number_format($fullPmtTotal, 2)); } # if amnesty checked/unchecked form will submit, set kind of payment and other details /*switch($formValues['kindOfPayment']){ case 'check': $this->tpl->set_var("selectedCheck","selected"); $this->tpl->set_var("disabledOn",""); $this->tpl->set_var("checkNum",$formValues['checkNum']); $this->tpl->set_var("checkDate",$formValues['checkDate']); break; case 'treasury note': $this->tpl->set_var("selectedTNote","selected"); $this->tpl->set_var("disabledOn","disabled"); $this->tpl->set_var("checkNum",""); $this->tpl->set_var("checkDate",""); break; case 'cash': default: $this->tpl->set_var("selectedCash","selected"); $this->tpl->set_var("disabledOn","disabled"); $this->tpl->set_var("checkNum",""); $this->tpl->set_var("checkDate",""); break; }*/ # get totals in words $amountPaid = $amountPaid ? number_format($amountPaid, 2) : number_format($total, 2); $this->tpl->set_var("total", number_format($total, 2)); $this->tpl->set_var("amountPaid", $amountPaid); $this->tpl->set_var("balance", $total - $amountPaid); $numToWords = new NumbersToWords(); $totalInWords = $numToWords->num_to_string(number_format(str_replace(",", "", $amountPaid), 2)); $this->tpl->set_var("totalInWords", $totalInWords); //$this->tpl->set_var("amnestyChecked", ($formValues['amnesty']=="Yes") ? " checked" : ""); //if(!isset($_POST['printReceipt_x'])) // $this->tpl->set_var("Session", $sess->url("")); }
function Main() { switch ($this->formArray["formAction"]) { case "save": $DueEncode = new SoapObject(NCCBIZ . "DueEncode.php", "urn:Object"); if ($this->formArray["dueID"] != "") { $DueDetails = new SoapObject(NCCBIZ . "DueDetails.php", "urn:Object"); if (!($xmlStr = $DueDetails->getDue($this->formArray["dueID"]))) { $this->tpl->set_block("rptsTemplate", "Table", "TableBlock"); $this->tpl->set_var("TableBlock", "record not found"); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { $this->tpl->set_block("rptsTemplate", "Table", "TableBlock"); $this->tpl->set_var("TableBlock", "error xmlDoc"); } else { $dueArray = $this->setDues(); foreach ($dueArray as $due) { $doc = $due->getDomDocument(); $xmlStr = $doc->dump_mem(true); if (!($ret = $DueEncode->updateDue($xmlStr))) { exit("error update"); } unset($doc); unset($xmlStr); } } } } else { $dueArray = $this->setDues(); foreach ($dueArray as $due) { $doc = $due->getDomDocument(); $xmlStr = $doc->dump_mem(true); if (!($ret = $DueEncode->saveDue($xmlStr))) { exit("error saving"); } unset($doc); unset($xmlStr); } } $this->formArray["dueID"] = $ret; header("location: DueClose.php" . $this->sess->url("") . $this->sess->add_query(array("rptopID" => $this->formArray["rptopID"]))); exit($ret); break; default: // grab current tax rates from TreasurySettings $treasurySettings = new TreasurySettings(); $treasurySettings->selectRecord(); $this->formArray["masterBasicTaxRate"] = $treasurySettings->getPctRPTax(); $this->formArray["masterSEFTaxRate"] = $treasurySettings->getPctSEF(); $this->formArray["masterIdleTaxRate"] = $treasurySettings->getPctIdle(); $this->formArray["discountPeriod"] = $treasurySettings->getDiscountPeriod(); $TDDetails = new SoapObject(NCCBIZ . "TDDetails.php", "urn:Object"); if (!($xmlStr = $TDDetails->getTD($this->formArray["tdID"]))) { // xml failed } else { if (!($domDoc = domxml_open_mem($xmlStr))) { // domDoc empty } else { $td = new TD(); $td->parseDomDocument($domDoc); $this->formArray["afsID"] = $td->getAfsID(); $this->formArray["taxDeclarationNumber"] = $td->getTaxDeclarationNumber(); $this->formArray["taxBeginsWithTheYear"] = $td->getTaxBeginsWithTheYear(); } } unset($xmlStr); unset($domDoc); $AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object"); if (!($xmlStr = $AFSDetails->getAFS($this->formArray["afsID"]))) { // xml failed } else { if (!($domDoc = domxml_open_mem($xmlStr))) { // domDoc empty } else { $afs = new AFS(); $afs->parseDomDocument($domDoc); $this->formArray["assessedValue"] = $afs->getTotalAssessedValue(); $this->formArray["taxability"] = $afs->getTaxability(); $this->formArray["effectivity"] = $afs->getEffectivity(); $this->formArray["propertyType"] = $td->getPropertyType(); $this->formArray["idle"] = "No"; if ($td->getPropertyType() == "Land") { if (is_array($afs->landArray)) { // if land is stripped if (count($afs->landArray) > 1) { foreach ($afs->landArray as $land) { if ($land->getIdle() == "Yes") { $this->formArray["idle"] = "Yes"; break; } } } else { $this->formArray["idle"] = $afs->landArray[0]->getIdle(); } } } if ($this->formArray["idle"] == "") { $this->formArray["idle"] = "No"; } } } if ($this->formArray["dueID"] != "") { $DueDetails = new SoapObject(NCCBIZ . "DueDetails.php", "urn:Object"); if (!($xmlStr = $DueDetails->getDue($this->formArray["dueID"]))) { echo "xml failed"; } else { //echo $xmlStr; if (!($domDoc = domxml_open_mem($xmlStr))) { echo "error xmlDoc"; } else { $due = new Due(); $due->parseDomDocument($domDoc); foreach ($due as $key => $value) { switch ($key) { default: $this->formArray[$key] = $value; } } $this->formArray["dueDate_str"] = date("F d, Y", strtotime($this->formArray["dueDate"])); $this->formArray["taxDue"] = $due->getTaxDue(); } } } else { // select RPTOP taxable year from rptopID $RPTOPDetails = new SoapObject(NCCBIZ . "RPTOPDetails.php", "urn:Object"); if (!($xmlStr = $RPTOPDetails->getRPTOP($this->formArray["rptopID"]))) { exit("xml failed"); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { exit("error domDoc"); } else { $rptop = new RPTOP(); $rptop->parseDomDocument($domDoc); $this->formArray["taxableYear"] = $rptop->getTaxableYear(); } } // display default Due details $this->formArray["dueDate"] = date("Y-n-d", strtotime($this->formArray["taxableYear"] . "-" . $treasurySettings->getAnnualDueDate())); $this->formArray["dueDate_str"] = date("F d, Y", strtotime($this->formArray["dueDate"])); $this->formArray["basicTaxRate"] = $this->formArray["masterBasicTaxRate"]; $this->formArray["sefTaxRate"] = $this->formArray["masterSEFTaxRate"]; $this->formArray["idleTaxRate"] = $this->formArray["masterIdleTaxRate"]; $this->formArray["basicTax"] = un_number_format($this->formArray["assessedValue"]) * $this->formArray["basicTaxRate"]; $this->formArray["sefTax"] = un_number_format($this->formArray["assessedValue"]) * $this->formArray["sefTaxRate"]; // if land->idle is "Yes", compute idleTax, otherwise set idleTax to zero if ($this->formArray["propertyType"] == "Land") { if ($this->formArray["idle"] == "Yes") { $this->formArray["idleTax"] = un_number_format($this->formArray["assessedValue"]) * $this->formArray["idleTaxRate"]; } else { $this->formArray["idleTax"] = "0.00"; } } // if afs->taxability is "Exempt", reset computations to zero. if ($this->formArray["taxability"] == "Exempt") { $this->formArray["basicTax"] = 0.0; $this->formArray["sefTax"] = 0.0; $this->formArray["idleTax"] = 0.0; } $this->formArray["taxDue"] = $this->formArray["basicTax"] + $this->formArray["sefTax"] + $this->formArray["idleTax"]; } } $this->setForm(); $this->tpl->set_var("Session", $this->sess->url("") . $this->sess->add_query(array("dueID" => $this->formArray["dueID"], "tdID" => $this->formArray["tdID"], "rptopID" => $this->formArray["rptopID"]))); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); }
foreach ($td2 as $key => $value) { echo "{$key} = {$value}<br>\n"; } $propertyType = $td1->propertyType; $property1 = new Land(); $property1->selectRecord($td1->propertyID); echo "property1 values<br>\n"; foreach ($property1 as $key => $value) { echo "{$key} = {$value}<br>\n"; } $afsID = $property1->getAfsID(); $afs = new AFS(); $afs->selectRecord($afsID); echo "AFS values<br>\n"; foreach ($afs as $key => $value) { echo "{$key} = {$value}<br>\n"; } $tdNum = $td1->getTaxDeclarationNumber(); $taxDue = new Dues(); $taxDue->create($tdNum, "2002-01-01"); echo "taxDue values<br>\n"; foreach ($taxDue as $key => $value) { echo "{$key} = {$value}<br>\n"; } $dueDate = $taxDue->getDueDate(); $dueTime = strtotime($dueDate); echo "TaxDue date {$dueDate} and time {$dueTime} <br>\n"; echo "End test <br>\n"; ?>
function Main() { switch ($this->formArray["formAction"]) { case "view": $ODList = new SoapObject(NCCBIZ . "ODList.php", "urn:Object"); // paging $condition = " WHERE "; $condition .= " " . OD_TABLE . ".odID=" . AFS_TABLE . ".odID "; $condition .= " AND " . AFS_TABLE . ".taxability='Taxable' "; $condition .= $this->filterArchives(); $sqlCount = "SELECT COUNT(" . OD_TABLE . ".odID) as count FROM "; $sqlCount .= OD_TABLE . ", "; $sqlCount .= AFS_TABLE . " "; $sqlCount .= $condition; $dbCount = new DB_RPTS(); $dbCount->query($sqlCount); if ($dbCount->next_record()) { $count = $dbCount->f("count"); $numOfPages = ceil($count / PAGE_BY); $this->tpl->set_var("currentPage", $this->formArray["page"]); $this->tpl->set_var("numOfPages", $numOfPages); $this->tpl->set_block("rptsTemplate", "PageListOne", "PageListOneBlock"); for ($p = 1; $p <= $numOfPages; $p++) { $this->tpl->set_var("page", $p); $this->initSelected("page", $p); $this->tpl->parse("PageListOneBlock", "PageListOne", true); } } else { $this->tpl->set_block("rptsTemplate", "PageNavigationOne", "PageNavigationOneBlock"); $this->tpl->set_var("PageNavigationOneBlock", ""); $count = 0; } // listing $sql = "SELECT " . OD_TABLE . ".odID as odID, "; $sql .= AFS_TABLE . ".afsID as afsID FROM "; $sql .= OD_TABLE . ", "; $sql .= AFS_TABLE . " "; if ($this->formArray["page"] > 0) { $initialLimit = ($this->formArray["page"] - 1) * PAGE_BY; $condition .= " LIMIT " . $initialLimit . "," . PAGE_BY; } $sql = $sql . $condition; $db = new DB_RPTS(); $db->query($sql); $odRecords = new ODRecords(); while ($db->next_record()) { $od = new OD(); $od->selectRecord($db->f("odID")); $odRecords->arrayList[] = $od; } if (!is_array($odRecords->getArrayList())) { $this->tpl->set_block("rptsTemplate", "NotFound", "NotFoundBlock"); $this->tpl->set_var("message", "properties not found"); $this->tpl->parse("NotFoundBlock", "NotFound", true); $this->tpl->set_block("rptsTemplate", "Report", "ReportBlock"); $this->tpl->set_var("ReportBlock", ""); } else { $list = $odRecords->getArrayList(); if (count($list)) { $this->tpl->set_block("rptsTemplate", "NotFound", "NotFoundBlock"); $this->tpl->set_var("NotFoundBlock", ""); $this->tpl->set_block("rptsTemplate", "ReportList", "ReportListBlock"); foreach ($list as $key => $value) { $afs = $this->getAFSDetails($value->getOdID()); if (is_object($afs)) { $this->tpl->set_var("taxability", $afs->getTaxability()); if ($afs->getTaxability() == "Taxable") { //$this->formArray["odID"] = $value->getOdID(); //$this->formArray["afsID"] = $afs->getAfsID(); $td = new TD(); if ($td->selectRecord("", $this->formArray["afsID"])) { $this->tpl->set_var("taxDeclarationNumber", $td->getTaxDeclarationNumber()); } else { $this->tpl->set_var("taxDeclarationNumber", ""); } $locationAddress = $value->locationAddress->getFullAddress(); $this->tpl->set_var("locationAddress", $locationAddress); $this->tpl->set_var("area", $value->getLandArea()); $this->tpl->set_var("propertyIndexNumber", $afs->getPropertyIndexNumber()); $this->tpl->set_var("marketValue", number_format($afs->getTotalMarketValue())); $this->tpl->set_var("assessedValue", number_format($afs->getTotalAssessedValue(), 2, '.', ',')); $landList = $afs->getLandArray(); $plantsTreesList = $afs->getPlantsTreesArray(); $improvementsBuildingsList = $afs->getImprovementsBuildingsArray(); $machineriesList = $afs->getMachineriesArray(); $kind = ""; $class = ""; $remarks = ""; if (count($landList)) { $kind = "Land"; $land = $landList[0]; $class = $land->getClassification(); $landClasses = new LandClasses(); $landClasses->selectRecord($class); $class = $landClasses->getDescription(); $remarks = $land->getMemoranda(); } else { if (count($plantsTreesList)) { $kind = "Land"; $plantsTrees = $plantsTreesList[0]; $class = $plantsTrees->getProductClass(); $plantsTreesClasses = new PlantsTreesClasses(); $plantsTreesClasses->selectRecord($class); $class = $plantsTreesClasses->getDescription(); $remarks = $plantsTrees->getMemoranda(); } else { if (count($improvementsBuildingsList)) { $kind = "Improvements/Buildings"; $improvementsBuildings = $improvementsBuildingsList[0]; $class = $improvementsBuildings->getBuildingClassification(); $improvementsBuildingsClasses = new ImprovementsBuildingsClasses(); $improvementsBuildingsClasses->selectRecord($class); $class = $improvementsBuildingsClasses->getDescription(); $remarks = $improvementsBuildings->getMemoranda(); } else { if (count($machineriesList)) { $kind = "Machineries"; $machineries = $machineriesList[0]; $class = $machineries->getKind(); $remarks = $machineries->getMemoranda(); } } } } $this->tpl->set_var("kind", $kind); $this->tpl->set_var("classification", $class); $this->tpl->set_var("remarks", $remarks); $oValue = $value->owner; if (count($oValue->personArray)) { $firstOwner = $oValue->personArray[0]->getLastName(); $firstOwner .= ", "; $firstOwner .= $oValue->personArray[0]->getFirstName(); $firstOwner .= " "; $firstOwner .= substr($oValue->personArray[0]->getMiddleName(), 0, 1) . "."; $pAddress = $oValue->personArray[0]->addressArray ? $oValue->personArray[0]->addressArray[0]->getFullAddress() : "no address"; $firstOwnerAddress = $pAddress; $firstOwnerTelephone = $oValue->personArray[0]->getTelephone(); $this->tpl->set_var("firstOwner", $firstOwner); $this->tpl->set_var("firstOwnerAddress", $firstOwnerAddress); //$this->tpl->set_var("firstOwnerTelephone", $firstOwnerTelephone); } if (count($oValue->companyArray)) { if ($firstOwner == "") { $firstOwner = $oValue->companyArray[0]->getCompanyName(); $cAddress = $oValue->companyArray[0]->addressArray ? $oValue->companyArray[0]->addressArray[0]->getFullAddress() : "no \taddress"; $firstOwnerAddress = $cAddress; $firstOwnerTelephone = $oValue->companyArray[0]->getTelephone(); $this->tpl->set_var("firstOwner", $firstOwner); $this->tpl->set_var("firstOwnerAddress", $firstOwnerAddress); //$this->tpl->set_var("firstOwnerTelephone", $firstOwnerTelephone); } } if ($firstOwner != "") { $this->tpl->set_var("none", ""); if (count($oValue->personArray) + count($oValue->companyArray) > 1) { $this->tpl->set_var("andOthers", "(and others)"); } else { $this->tpl->set_var("andOthers", ""); } } else { $this->tpl->set_var("none", "none"); $this->tpl->set_var("firstOwner", ""); $this->tpl->set_var("andOthers", ""); $this->tpl->set_var("firstOwnerAddress", ""); $this->tpl->set_var("firstOwnerTelephone", ""); } $this->tpl->parse("ReportListBlock", "ReportList", true); } } } } } break; default: $this->tpl->set_block("rptsTemplate", "NotFound", "NotFoundBlock"); $this->tpl->set_var("message", "select a location to view report"); $this->tpl->parse("NotFoundBlock", "NotFound", true); $this->tpl->set_block("rptsTemplate", "Report", "ReportBlock"); $this->tpl->set_var("ReportBlock", ""); break; } $this->setForm(); $this->tpl->set_var("Session", $this->sess->url("")); $this->tpl->set_var("rpts_Session", $this->sess->id); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); }
function Main() { switch ($this->formArray["formAction"]) { case "view": $ODList = new SoapObject(NCCBIZ . "ODList.php", "urn:Object"); $condition = ""; if ($this->formArray["filterByLocation"] == "true") { if ($condition == "") { $condition = " WHERE "; } $condition .= $this->filterLocationAddress(); } else { $this->tpl->set_block("rptsTemplate", "FilterLocationDetails", "FilterLocationDetailsBlock"); $this->tpl->set_var("FilterLocationDetailsBlock", ""); } if ($this->formArray["filterByDate"] == "true") { if ($condition == "") { $condition = " WHERE "; } else { $condition .= " AND "; } $condition .= $this->filterDate(); } else { $this->tpl->set_block("rptsTemplate", "FilterDateDetails", "FilterDateDetailsBlock"); $this->tpl->set_var("FilterDateDetailsBlock", ""); } $condition .= $this->filterArchives(); $odRecords = new ODRecords(); if ($this->formArray["filterByClassification"] == "true") { $odIDArray = $this->filterByClassification($condition); if (is_array($odIDArray)) { $count = count($odIDArray); $numOfPages = ceil($count / PAGE_BY); $pLowerLimit = ($this->formArray["page"] - 1) * PAGE_BY; $pUpperLimit = $pLowerLimit + PAGE_BY; $this->tpl->set_var("currentPage", $this->formArray["page"]); $this->tpl->set_var("numOfPages", $numOfPages); $this->tpl->set_block("rptsTemplate", "PageListOne", "PageListOneBlock"); for ($p = 1; $p <= $numOfPages; $p++) { $this->tpl->set_var("page", $p); $this->initSelected("page", $p); $this->tpl->parse("PageListOneBlock", "PageListOne", true); } for ($p = $pLowerLimit; $p < $pUpperLimit; $p++) { if ($p < count($odIDArray)) { $od = new OD(); $od->selectRecord($odIDArray[$p]); $odRecords->arrayList[] = $od; } } } else { $this->tpl->set_block("rptsTemplate", "PageNavigationOne", "PageNavigationOneBlock"); $this->tpl->set_var("PageNavigationOneBlock", ""); } } else { if (!($count = $odRecords->countRecords($condition))) { $this->tpl->set_block("rptsTemplate", "PageNavigationOne", "PageNavigationOneBlock"); $this->tpl->set_var("PageNavigationOneBlock", ""); } else { $numOfPages = ceil($count / PAGE_BY); $this->tpl->set_var("currentPage", $this->formArray["page"]); $this->tpl->set_var("numOfPages", $numOfPages); $this->tpl->set_block("rptsTemplate", "PageListOne", "PageListOneBlock"); for ($p = 1; $p <= $numOfPages; $p++) { $this->tpl->set_var("page", $p); $this->initSelected("page", $p); $this->tpl->parse("PageListOneBlock", "PageListOne", true); } } $condition .= " LIMIT 0, 10"; $odRecords->selectRecords($condition); } if (!is_array($odRecords->getArrayList())) { $this->tpl->set_block("rptsTemplate", "NotFound", "NotFoundBlock"); $this->tpl->set_var("message", "properties not found"); $this->tpl->parse("NotFoundBlock", "NotFound", true); $this->tpl->set_block("rptsTemplate", "Report", "ReportBlock"); $this->tpl->set_var("ReportBlock", ""); } else { $list = $odRecords->getArrayList(); $count = 0; if (count($list)) { $this->tpl->set_block("rptsTemplate", "ReportList", "ReportListBlock"); $noneFound = true; foreach ($list as $key => $value) { $afs = $this->getAFSDetails($value->getOdID()); if (is_object($afs)) { $landList = $afs->getLandArray(); $plantsTreesList = $afs->getPlantsTreesArray(); $improvementsBuildingsList = $afs->getImprovementsBuildingsArray(); $machineriesList = $afs->getMachineriesArray(); $kind = ""; $class = ""; $remarks = ""; $actualUse = ""; $actualUseReportCode = ""; if (is_array($landList)) { $kind = "Land"; $land = $landList[0]; $actualUse = $land->getActualUse(); $landActualUses = new LandActualUses(); $landActualUses->selectRecord($actualUse); $actualUse = $landActualUses->getDescription(); $actualUseReportCode = $landActualUses->getReportCode(); $remarks = $land->getMemoranda(); } else { if (is_array($plantsTreesList)) { $kind = "Land"; $plantsTrees = $plantsTreesList[0]; $actualUse = $plantsTrees->getActualUse(); $plantsTreesActualUses = new PlantsTreesActualUses(); $plantsTreesActualUses->selectRecord($actualUse); $actualUse = $plantsTreesActualUses->getDescription(); $actualUseReportCode = $plantsTreesActualUses->getReportCode(); $remarks = $plantsTrees->getMemoranda(); } else { if (is_array($improvementsBuildingsList)) { $kind = "Improvements/Buildings"; $improvementsBuildings = $improvementsBuildingsList[0]; $actualUse = $improvementsBuildings->getActualUse(); $improvementsBuildingsActualUses = new ImprovementsBuildingsActualUses(); $improvementsBuildingsActualUses->selectRecord($actualUse); $actualUse = $improvementsBuildingsActualUses->getDescription(); $actualUseReportCode = $improvementsBuildingsActualUses->getReportCode(); $remarks = $improvementsBuildings->getMemoranda(); } else { if (is_array($machineriesList)) { $kind = "Machineries"; $machineries = $machineriesList[0]; $actualUse = $machineries->getActualUse(); $machineriesActualUses = new MachineriesActualUses(); $machineriesActualUses->selectRecord($actualUse); $actualUse = $machineriesActualUses->getDescription(); $actualUseReportCode = $machineriesActualUses->getReportCode(); $remarks = $machineries->getMemoranda(); } } } } $this->tpl->set_var("kind", $kind); $this->tpl->set_var("actualUse", $actualUse); $this->tpl->set_var("actualUseReportCode", $actualUseReportCode); $this->tpl->set_var("remarks", $remarks); $this->tpl->set_var("taxability", $afs->getTaxability()); $this->formArray["odID"] = $value->getOdID(); $this->formArray["afsID"] = $afs->getAfsID(); $td = new TD(); if ($td->selectRecord("", $this->formArray["afsID"])) { $this->tpl->set_var("taxDeclarationNumber", $td->getTaxDeclarationNumber()); } else { $this->tpl->set_var("taxDeclarationNumber", ""); } $this->tpl->set_var("area", $value->getLandArea()); $this->tpl->set_var("propertyIndexNumber", $afs->getPropertyIndexNumber()); $this->tpl->set_var("marketValue", number_format($afs->getTotalMarketValue())); $this->tpl->set_var("assessedValue", number_format($afs->getTotalAssessedValue(), 2, '.', ',')); $oValue = $value->owner; if (count($oValue->personArray)) { $firstOwner = $oValue->personArray[0]->getLastName(); $firstOwner .= ", "; $firstOwner .= $oValue->personArray[0]->getFirstName(); $firstOwner .= " "; $firstOwner .= substr($oValue->personArray[0]->getMiddleName(), 0, 1) . "."; $pAddress = $oValue->personArray[0]->addressArray ? $oValue->personArray[0]->addressArray[0]->getFullAddress() : "no address"; $firstOwnerAddress = $pAddress; $firstOwnerTelephone = $oValue->personArray[0]->getTelephone(); $this->tpl->set_var("firstOwner", $firstOwner); $this->tpl->set_var("firstOwnerAddress", $firstOwnerAddress); } if (count($oValue->companyArray)) { if ($firstOwner == "") { $firstOwner = $oValue->companyArray[0]->getCompanyName(); $cAddress = $oValue->companyArray[0]->addressArray ? $oValue->companyArray[0]->addressArray[0]->getFullAddress() : "no \taddress"; $firstOwnerAddress = $cAddress; $firstOwnerTelephone = $oValue->companyArray[0]->getTelephone(); $this->tpl->set_var("firstOwner", $firstOwner); $this->tpl->set_var("firstOwnerAddress", $firstOwnerAddress); } } if ($firstOwner != "") { $this->tpl->set_var("none", ""); if (count($oValue->personArray) + count($oValue->companyArray) > 1) { $this->tpl->set_var("andOthers", "(and others)"); } else { $this->tpl->set_var("andOthers", ""); } } else { $this->tpl->set_var("none", "none"); $this->tpl->set_var("firstOwner", ""); $this->tpl->set_var("andOthers", ""); $this->tpl->set_var("firstOwnerAddress", ""); $this->tpl->set_var("firstOwnerTelephone", ""); } if (is_array($oValue->personArray)) { foreach ($oValue->personArray as $person) { $ownerNamesArray[] = $person->getFullName(); } } if (is_array($oValue->companyArray)) { foreach ($oValue->companyArray as $company) { $ownerNamesArray[] = $company->getCompanyName(); } } if (is_array($ownerNamesArray)) { $this->tpl->set_var("ownerNames", implode(",<br>", $ownerNamesArray)); } else { $this->tpl->set_var("ownerNames", ""); } unset($ownerNamesArray); $locationAddress = $value->locationAddress->getFullAddress(); $this->tpl->set_var("location", $locationAddress); $this->tpl->set_var("transactionCode", $value->getTransactionCode()); $this->tpl->set_var("assessorsLotNo", $value->getLotNumber()); $this->tpl->set_var("dateCreated", date('F j, Y, g:i a', $value->getDateCreated())); if ($this->formArray["filterByClassification"] == "true") { $count++; if ($this->checkActualUseReportCode($landList, $plantsTreesList, $improvementsBuildingsList, $machineriesList)) { $noneFound = false; $this->tpl->parse("ReportListBlock", "ReportList", true); } } else { $noneFound = false; $this->tpl->set_block("rptsTemplate", "FilterClassificationDetails", "FilterClassificationDetailsBlock"); $this->tpl->set_var("FilterClassificationDetailsBlock", ""); $this->tpl->parse("ReportListBlock", "ReportList", true); } } } if ($noneFound == true) { $this->tpl->set_block("rptsTemplate", "NotFound", "NotFoundBlock"); $this->tpl->parse("NotFoundBlock", "NotFound", true); $this->tpl->set_block("rptsTemplate", "Report", "ReportBlock"); $this->tpl->set_var("ReportBlock", ""); } else { $this->tpl->set_block("rptsTemplate", "NotFound", "NotFoundBlock"); $this->tpl->set_var("NotFoundBlock", ""); } } } break; default: $this->tpl->set_block("rptsTemplate", "NotFound", "NotFoundBlock"); $this->tpl->set_var("message", "select a location to view report"); $this->tpl->parse("NotFoundBlock", "NotFound", true); $this->tpl->set_block("rptsTemplate", "Report", "ReportBlock"); $this->tpl->set_var("ReportBlock", ""); break; } $this->setForm(); $this->tpl->set_var("Session", $this->sess->url("")); $this->tpl->set_var("rpts_Session", $this->sess->id); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); }
function Main() { $this->formArray['currentDate'] = date("F d, Y"); $MunicipalityCityDetails = new SoapObject(NCCBIZ . "MunicipalityCityDetails.php", "urn:Object"); #test values //$this->formArray['municipalityCityID']=1; if (!($xmlStr = $MunicipalityCityDetails->getMunicipalityCityDetails($this->formArray['municipalityCityID']))) { #echo($xmlStr); //exit("xml failed for municipality"); header("Location: " . $this->sess->url("ViewSOA.php") . "&status=2"); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { echo "error xmlDoc"; } else { $MunicipalityCity = new MunicipalityCity(); $MunicipalityCity->parseDomDocument($domDoc); $this->formArray['municipality'] = $MunicipalityCity->getDescription(); } } #test values //$this->formArray['ownerID']=5; #echo("ownerID=".$this->formArray['ownerID']."<br>"); // $this->displayOwnerList($this->formArray['ownerID']); #test values //$this->formArray["rptopID"]=15; if ($this->formArray['personID'] != "") { $person = new Person(); $person->selectRecord($this->formArray['personID']); $this->tpl->set_var(ownerName, $person->getFullName()); $this->tpl->set_var(ownerNo, $person->getTin()); $address = $person->addressArray[0]; $this->tpl->set_var(ownerAddress, $address->getNumber() . " " . $address->getStreet() . " " . $address->getBarangay() . " " . $address->getDistrict() . " " . $address->getMunicipalitycity() . " " . $address->getProvince()); $db = new DB_RPTS(); $sql = "SELECT rptopID FROM Owner inner join OwnerPerson on Owner.ownerID=OwnerPerson.ownerID WHERE Owner.rptopID <> '' AND OwnerPerson.personID=" . $this->formArray['personID']; $db->query($sql); } else { $company = new Company(); $company->selectRecord($this->formArray['companyID']); $this->tpl->set_var(ownerName, $company->getCompanyName()); $this->tpl->set_var(ownerNo, $company->getCompanyID()); $address = $company->addressArray[0]; $this->tpl->set_var(ownerAddress, $address->getNumber() . " " . $address->getStreet() . " " . $address->getBarangay() . " " . $address->getDistrict() . " " . $address->getMunicipalitycity() . " " . $address->getProvince()); $db = new DB_RPTS(); $sql = "SELECT rptopID FROM Owner inner join OwnerPerson on Owner.ownerID=OwnerPerson.ownerID WHERE Owner.rptopID <> '' AND OwnerPerson.personID=" . $this->formArray['companyID']; $db->query($sql); } /*$person = new Person(); $person->selectRecord($this->formArray['personID']); $this->tpl->set_var(ownerName,$person->getFullName()); $this->tpl->set_var(ownerNo,$person->getTin()); $address = $person->addressArray[0]; $this->tpl->set_var(ownerAddress,$address->getNumber() ." ".$address->getStreet()." ".$address->getBarangay()." ".$address->getDistrict()." ".$address->getMunicipalitycity()." ".$address->getProvince()); $db = new DB_RPTS(); $sql = "SELECT rptopID FROM Owner inner join OwnerPerson on Owner.ownerID=OwnerPerson.ownerID WHERE Owner.rptopID <> '' AND OwnerPerson.personID=".$this->formArray['personID']; $db->query($sql);*/ $this->tpl->set_block("rptsTemplate", "ROW", "RowBlk"); for ($i = 0; $db->next_record(); $i++) { $rptopID = $db->f("rptopID"); $RPTOPDetails = new SoapObject(NCCBIZ . "RPTOPDetails.php", "urn:Object"); if (!($xmlStr = $RPTOPDetails->getRPTOP($rptopID))) { // exit("xml failed for RPTOP"); header("Location: " . $this->sess->url("ViewSOA.php") . "&status=1"); } 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(); $td = new TD(); $rptop->parseDomDocument($domDoc); foreach ($rptop as $key => $value) { $this->formArray['payableYear'] = $rptop->getTaxableYear(); $rptopID = $rptop->getRptopID(); if ($key == "tdArray") { $tdCtr = 0; if (count($value)) { foreach ($value as $tkey => $tvalue) { $td->selectRecord($tvalue->getTdID()); $assessedValue = number_format($td->getAssessedValue(), 2, ".", ""); $propertyType = $td->getPropertyType(); $TaxDeclarationNumber = $td->getTaxDeclarationNumber(); // $this->tpl->set_var(kind,$propertyType); // $this->tpl->set_var(currentTDNo,$TaxDeclarationNumber); /* $dues = new Dues(); $dues->create($td->getTdID(), "","","","2003"); $this->tpl->set_var(basic,$dues->getBasic()); $totBasic += $dues->getBasic(); $this->tpl->set_var(sef,$dues->getSEF()); $totSEF += $dues->getSEF(); $this->tpl->set_var(total,$dues->getSEF()+$dues->getBasic()); $totTaxDue += $dues->getSEF()+$dues->getBasic();*/ $afsID = $td->getAfsID(); $afs = new AFS(); $afs->selectRecord($afsID); $od = new OD(); $od->selectRecord($afs->getOdID()); $addr = $od->getLocationAddress(); if (count($addr)) { $location = $addr->getFullAddress(); // $this->tpl->set_var(location,$addr->getFullAddress()); $munCityID = $addr->getMunicipalityCityID(); // if($munCityID == $this->formArray['municipalityCityID']) // $this->tpl->set_var(municipality,$addr->getMunicipalityCity()); } if (count($afs->landArray)) { foreach ($afs->landArray as $afsKey => $afsValue) { $actualUse = $afsValue->getActualUse(); $landActualUses = new LandActualUses(); $landActualUses->selectRecord($actualUse); //$this->tpl->set_var("class",$landActualUses->getCode()); $Code = $landActualUses->getCode(); } } if (count($afs->improvementsBuildingsArray)) { foreach ($afs->improvementsBuildingsArray as $afsKey => $afsValue) { $actualUse = $afsValue->getActualUse(); $improvementsBuildingsActualUses = new improvementsBuildingsActualUses(); $improvementsBuildingsActualUses->selectRecord($actualUse); //$this->tpl->set_var("class",$improvementsBuildingsActualUses->getCode()); $Code = $improvementsBuildingsActualUses->getCode(); } } //echo $afs->get // echo $munCityID ."==". $this->formArray['municipalityCityID']."<br>"; if ($munCityID == $this->formArray['municipalityCityID']) { $this->tpl->set_var(location, $location); $this->tpl->set_var("class", $Code); $this->tpl->set_var(kind, $propertyType); $this->tpl->set_var(currentTDNo, $TaxDeclarationNumber); $this->tpl->set_var(municipality, $addr->getMunicipalityCity()); $dues = new Dues(); $dues->create($td->getTdID(), "", "", "", "2003"); $totTaxDue += $dues->getSEF() + $dues->getBasic(); $basic = number_format($dues->getBasic(), "2", ".", ""); $this->tpl->set_var(basic, $basic); $totBasic += $basic; $sef = number_format($dues->getSEF(), "2", ".", ""); $this->tpl->set_var(sef, $sef); $totSEF += number_format($sef, "2", ".", ""); $this->tpl->set_var(total, number_format($sef + $basic, "2", ".", "")); $this->tpl->set_var(marketValue, number_format($afs->getTotalMarketValue(), 2)); $totMarketValue += $afs->getTotalMarketValue(); $this->tpl->set_var(assessedValue, number_format($afs->getTotalAssessedValue(), 2)); $totAssessedValue += $afs->getTotalAssessedValue(); $pIndexNo = $afs->getPropertyIndexNumber(); if ($pIndexNo == "") { $pIndexNo = "No value specified"; } $this->tpl->set_var(pin, $pIndexNo); //echo $afs->getTotalMarketValue(); /* if(count($afs->landArray)){ foreach($afs->landArray as $afsKey => $afsValue){ $this->tpl->set_var(pin,$afsValue->getPropertyIndexNumber()); } } */ $this->tpl->parse("RowBlk", "ROW", true); } //else{ // $this->tpl->set_var("RowBlk",""); // } } #end foreach($value) } #end if coun value $this->tpl->set_var(totalMarketValue, number_format($totMarketValue, 2)); $this->tpl->set_var(totalAssessedValue, number_format($totAssessedValue, 2)); $this->tpl->set_var(totalBasic, number_format($totBasic, 2)); $this->tpl->set_var(totalSEF, number_format($totSEF, 2)); $this->tpl->set_var(totalTaxDue, number_format($totTaxDue, 2)); } } } // $this->tpl->parse("RowBlk","ROW",true); } } // $owner /* $RPTOPDetails = new SoapObject(NCCBIZ."RPTOPDetails.php", "urn:Object"); if (!$xmlStr = $RPTOPDetails->getRPTOP($this->formArray["rptopID"])){ //exit("xml failed for RPTOP"); header("Location: ".$this->sess->url("ViewSOA.php")."&status=1"); } 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; $td = new TD(); $rptop->parseDomDocument($domDoc); $status_report = ""; foreach($rptop as $key => $value){ $this->formArray['payableYear'] = $rptop->getTaxableYear(); $rptopID = $rptop->getRptopID(); if($key=="tdArray"){ $tdCtr = 0; if (count($value)){ $this->tpl->set_block("rptsTemplate","ROW","RowBlk"); foreach($value as $tkey => $tvalue){ $td->selectRecord($tvalue->getTdID()); $assessedValue = number_format($td->getAssessedValue(),2,".",""); $propertyType = $td->getPropertyType(); $TaxDeclarationNumber = $td->getTaxDeclarationNumber(); //$tdCtr++; $this->tpl->set_var(kind,$propertyType); $this->tpl->set_var(currentTDNo,$TaxDeclarationNumber); /* $dues = new Dues(); $dues->create($td->getTdID(), "","","","2003"); $this->tpl->set_var(basic,$dues->getBasic()); $totBasic += $dues->getBasic(); $this->tpl->set_var(sef,$dues->getSEF()); $totSEF += $dues->getSEF(); $this->tpl->set_var(total,$dues->getSEF()+$dues->getBasic()); $totTaxDue += $dues->getSEF()+$dues->getBasic();*/ /* $afsID = $td->getAfsID(); $afs = new AFS(); $afs->selectRecord($afsID); $od = new OD(); $od->selectRecord($afs->getOdID()); $addr = $od->getLocationAddress(); if(count($addr)){ $this->tpl->set_var(location,$addr->getFullAddress()); $munCityID = $addr->getMunicipalityCityID(); if($munCityID == $this->formArray['municipalityCityID']) $this->tpl->set_var(municipality,$addr->getMunicipalityCity()); } if(count($afs->landArray)){ foreach($afs->landArray as $afsKey => $afsValue){ $actualUse = $afsValue->getActualUse(); $landActualUses = new LandActualUses(); $landActualUses->selectRecord($actualUse); $this->tpl->set_var("class",$landActualUses->getCode()); } } if(count($afs->improvementsBuildingsArray)){ foreach($afs->improvementsBuildingsArray as $afsKey => $afsValue){ $actualUse = $afsValue->getActualUse(); $improvementsBuildingsActualUses = new improvementsBuildingsActualUses(); $improvementsBuildingsActualUses->selectRecord($actualUse); $this->tpl->set_var("class",$improvementsBuildingsActualUses->getCode()); } } //echo $afs->get if($munCityID == $this->formArray['municipalityCityID']){ $dues = new Dues(); $dues->create($td->getTdID(), "","","","2003"); $this->tpl->set_var(basic,number_format($dues->getBasic(),"2",".","")); $totBasic += $dues->getBasic(); $this->tpl->set_var(sef,number_format($dues->getSEF(),"2",".","")); $totSEF += $dues->getSEF(); $this->tpl->set_var(total,number_format($dues->getSEF()+$dues->getBasic(),"2",".","")); $pIndexNo = $afs->getPropertyIndexNumber(); if($pIndexNo==""){ $pIndexNo = "No value specified"; } $this->tpl->set_var(pin,$pIndexNo); $this->tpl->set_var(marketValue,$afs->getTotalMarketValue()); $totMarketValue += $afs->getTotalMarketValue(); $this->tpl->set_var(assessedValue,$afs->getTotalAssessedValue()); $totAssessedValue += $afs->getTotalAssessedValue(); //echo $afs->getTotalMarketValue(); /* if(count($afs->landArray)){ foreach($afs->landArray as $afsKey => $afsValue){ $this->tpl->set_var(pin,$afsValue->getPropertyIndexNumber()); } } */ /* $this->tpl->parse("RowBlk","ROW",true); }else{ $this->tpl->set_var("RowBlk",""); } }#end foreach($value) }#end if coun value // $this->tpl->set_block("rptsTemplate","STAT",sBlk); // $this->tpl->set_var(status_report,$status_report); // $this->tpl->parse(sBlk,"STAT",true); $this->tpl->set_var(totalMarketValue,$totMarketValue); $this->tpl->set_var(totalAssessedValue,$totAssessedValue); $this->tpl->set_var(totalBasic,$totBasic); $this->tpl->set_var(totalSEF,$totSEF); $this->tpl->set_var(totalTaxDue,$totTaxDue); } } } }*/ $this->setForm(); $this->tpl->set_var("Session", $this->sess->url("")); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); }
function Main() { $this->formArray['currentDate'] = date("F d, Y"); $MunicipalityCityDetails = new SoapObject(NCCBIZ . "MunicipalityCityDetails.php", "urn:Object"); #test values //$this->formArray['municipalityCityID']=1; if (!($xmlStr = $MunicipalityCityDetails->getMunicipalityCityDetails($this->formArray['municipalityCityID']))) { #echo($xmlStr); exit("xml failed for municipality"); //header("Location: ".$this->sess->url("ViewSOA.php")."&status=2"); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { echo "error xmlDoc"; } else { $MunicipalityCity = new MunicipalityCity(); $MunicipalityCity->parseDomDocument($domDoc); $this->formArray['municipality'] = $MunicipalityCity->getDescription(); } } if ($this->formArray['personID'] != "") { $person = new Person(); $person->selectRecord($this->formArray['personID']); $this->tpl->set_var(ownerName, $person->getFullName()); $this->tpl->set_var(ownerNo, $person->getTin()); $address = $person->addressArray[0]; if (is_object($address)) { $this->tpl->set_var(ownerAddress, $address->getNumber() . " " . $address->getStreet() . " " . $address->getBarangay() . " " . $address->getDistrict() . " " . $address->getMunicipalitycity() . " " . $address->getProvince()); } else { $this->tpl->set_var(ownerAddress, ""); } $db = new DB_RPTS(); $sql = "SELECT rptopID FROM Owner inner join OwnerPerson on Owner.ownerID=OwnerPerson.ownerID WHERE Owner.rptopID <> '' AND OwnerPerson.personID=" . $this->formArray['personID']; $db->query($sql); } else { $company = new Company(); $company->selectRecord($this->formArray['companyID']); $this->tpl->set_var(ownerName, $company->getCompanyName()); $this->tpl->set_var(ownerNo, $company->getCompanyID()); $address = $company->addressArray[0]; $this->tpl->set_var(ownerAddress, $address->getNumber() . " " . $address->getStreet() . " " . $address->getBarangay() . " " . $address->getDistrict() . " " . $address->getMunicipalitycity() . " " . $address->getProvince()); $db = new DB_RPTS(); $sql = "SELECT rptopID FROM Owner inner join OwnerPerson on Owner.ownerID=OwnerPerson.ownerID WHERE Owner.rptopID <> '' AND OwnerPerson.personID=" . $this->formArray['companyID']; $db->query($sql); } $ypos = 325; $this->tpl->set_block("rptsTemplate", "ROW", "RowBlk"); for ($i = 0; $db->next_record(); $i++) { $rptopID = $db->f("rptopID"); $RPTOPDetails = new SoapObject(NCCBIZ . "RPTOPDetails.php", "urn:Object"); if (!($xmlStr = $RPTOPDetails->getRPTOP($rptopID))) { // exit("xml failed for RPTOP"); header("Location: " . $this->sess->url("ViewSOA.php") . "&status=1"); } 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(); $td = new TD(); $rptop->parseDomDocument($domDoc); foreach ($rptop as $key => $value) { $this->formArray['payableYear'] = $rptop->getTaxableYear(); $rptopID = $rptop->getRptopID(); if ($key == "tdArray") { $tdCtr = 0; if (count($value)) { foreach ($value as $tkey => $tvalue) { $td->selectRecord($tvalue->getTdID()); $assessedValue = number_format($td->getAssessedValue(), 2, ".", ""); $propertyType = $td->getPropertyType(); $TaxDeclarationNumber = $td->getTaxDeclarationNumber(); $afsID = $td->getAfsID(); $afs = new AFS(); $afs->selectRecord($afsID); $od = new OD(); $od->selectRecord($afs->getOdID()); $addr = $od->getLocationAddress(); if (count($addr)) { $location = strtoupper($addr->getNumber() . " " . substr($addr->getBarangay(), 0, 4) . " " . substr($addr->getMunicipalityCity(), 0, 3) . " " . substr($addr->getProvince(), 0, 3)); $munCityID = $addr->getMunicipalityCityID(); } if (count($afs->landArray)) { foreach ($afs->landArray as $afsKey => $afsValue) { $actualUse = $afsValue->getActualUse(); $landActualUses = new LandActualUses(); $landActualUses->selectRecord($actualUse); $Code = $landActualUses->getCode(); } } if (count($afs->improvementsBuildingsArray)) { foreach ($afs->improvementsBuildingsArray as $afsKey => $afsValue) { $actualUse = $afsValue->getActualUse(); $improvementsBuildingsActualUses = new improvementsBuildingsActualUses(); $improvementsBuildingsActualUses->selectRecord($actualUse); $Code = $improvementsBuildingsActualUses->getCode(); } } if ($munCityID == $this->formArray['municipalityCityID']) { $this->tpl->set_var(location, $location); $this->tpl->set_var("class", $Code); $this->tpl->set_var(kind, strtoupper(substr($propertyType, 0, 4))); $this->tpl->set_var(currentTDNo, $TaxDeclarationNumber); $this->tpl->set_var(municipality, $addr->getMunicipalityCity()); //$dues = new Dues(); //$dues->create($td->getTdID(),"2003"); //$totTaxDue += $dues->getSEF()+$dues->getBasic(); $dues = new Dues($tvalue->getTdID(), $rptop->getTaxableYear(), $assessedValue); $paymentPeriod = $dues->getPaymentMode(); $totalTaxDue = $dues->getPaidBasic($paymentPeriod) + $dues->getPaidSEF($paymentPeriod) + $dues->getPaidIdle($paymentPeriod); if ($dues->getAmnesty()) { $dues->setPctPenalty(0.0); } else { $totalTaxDue += $dues->getPenalty($paymentPeriod); } if ($dues->getIsDiscount()) { $taxDue->setDiscount($totalTaxDue); $totalTaxDue -= $dues->getDiscount(); } $interest = $dues->getPctPenalty(); if ($interest > 0 && $paymentPeriod != "Annual") { $paymentPeriod = "Annual"; } $basic = number_format($dues->getPaidBasic(), "2", ".", ""); $this->tpl->set_var(basic, $basic); $totBasic += $basic; $sef = number_format($dues->getPaidSEF(), "2", ".", ""); $this->tpl->set_var(sef, $sef); $totSEF += number_format($sef, "2", ".", ""); $this->tpl->set_var(total, number_format($sef + $basic, "2", ".", "")); $this->tpl->set_var(marketValue, number_format($afs->getTotalMarketValue(), 2)); $totMarketValue += $afs->getTotalMarketValue(); $this->tpl->set_var(assessedValue, number_format($afs->getTotalAssessedValue(), 2)); $totAssessedValue += $afs->getTotalAssessedValue(); $pIndexNo = $afs->getPropertyIndexNumber(); if ($pIndexNo == "") { $pIndexNo = "No value specified"; } $ypos = $ypos - 10; $this->tpl->set_var(ypos, $ypos); $this->tpl->set_var(pin, $pIndexNo); $this->tpl->parse("RowBlk", "ROW", true); } } #end foreach($value) } #end if coun value $this->tpl->set_var(totalMarketValue, number_format($totMarketValue, 2)); $this->tpl->set_var(totalAssessedValue, number_format($totAssessedValue, 2)); $this->tpl->set_var(totalBasic, number_format($totBasic, 2)); $this->tpl->set_var(totalSEF, number_format($totSEF, 2)); $this->tpl->set_var(totalTaxDue, number_format($totalTaxDue, 2)); } } } } } $this->setForm(); $this->tpl->set_var("Session", $this->sess->url("")); /* $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); */ $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $rptrpdf = new PDFWriter(); $rptrpdf->setOutputXML($this->tpl->get('templatePage'), "string"); $rptrpdf->writePDF("viewSOA.pdf"); }
function Main() { switch ($this->formArray["formAction"]) { case "view": $ODList = new SoapObject(NCCBIZ . "ODList.php", "urn:Object"); $condition = ""; if ($this->formArray["filterByLocation"] == "true") { if ($condition == "") { $condition = " WHERE "; } $condition .= $this->filterLocationAddress(); } else { $this->tpl->set_block("rptsTemplate", "FilterLocationDetails", "FilterLocationDetailsBlock"); $this->tpl->set_var("FilterLocationDetailsBlock", ""); } if ($this->formArray["filterByDate"] == "true") { if ($condition == "") { $condition = " WHERE "; } else { $condition .= " AND "; } $condition .= $this->filterDate(); } else { $this->tpl->set_block("rptsTemplate", "FilterDateDetails", "FilterDateDetailsBlock"); $this->tpl->set_var("FilterDateDetailsBlock", ""); } $condition .= $this->filterArchives(); $odRecords = new ODRecords(); // paging if (!($count = $odRecords->countRecords($condition))) { $this->tpl->set_block("rptsTemplate", "PageNavigationOne", "PageNavigationOneBlock"); $this->tpl->set_var("PageNavigationOneBlock", ""); } else { $numOfPages = ceil($count / PAGE_BY); $this->tpl->set_var("currentPage", $this->formArray["page"]); $this->tpl->set_var("numOfPages", $numOfPages); $this->tpl->set_block("rptsTemplate", "PageListOne", "PageListOneBlock"); for ($p = 1; $p <= $numOfPages; $p++) { $this->tpl->set_var("page", $p); $this->initSelected("page", $p); $this->tpl->parse("PageListOneBlock", "PageListOne", true); } } if ($this->formArray["page"] > 0) { $initialLimit = ($this->formArray["page"] - 1) * PAGE_BY; $condition .= " LIMIT " . $initialLimit . "," . PAGE_BY; } // listing if (!$odRecords->selectRecords($condition)) { $this->tpl->set_block("rptsTemplate", "NotFound", "NotFoundBlock"); $this->tpl->set_var("message", "properties not found"); $this->tpl->parse("NotFoundBlock", "NotFound", true); $this->tpl->set_block("rptsTemplate", "Report", "ReportBlock"); $this->tpl->set_var("ReportBlock", ""); } else { $list = $odRecords->getArrayList(); if (count($list)) { $this->tpl->set_block("rptsTemplate", "NotFound", "NotFoundBlock"); $this->tpl->set_var("NotFoundBlock", ""); $this->tpl->set_block("rptsTemplate", "ReportList", "ReportListBlock"); foreach ($list as $key => $value) { $this->formArray["odID"] = $value->getOdID(); $this->tpl->set_var("odID", $value->getOdID()); $afs = $this->getAFSDetails($value->getOdID()); if (is_object($afs)) { $this->tpl->set_var("propertyIndexNumber", $afs->getPropertyIndexNumber()); $this->tpl->set_var("arpNumber", $afs->getArpNumber()); $this->formArray["odID"] = $value->getOdID(); $this->formArray["afsID"] = $afs->getAfsID(); //$od = $this->getODDetails($value->getOdID()); $this->tpl->set_var("transactionCode", $value->getTransactionCode()); $td = new TD(); if ($td->selectRecord("", $this->formArray["afsID"])) { $this->tpl->set_var("taxDeclarationNumber", $td->getTaxDeclarationNumber()); } else { $this->tpl->set_var("taxDeclarationNumber", ""); } $this->tpl->set_var("area", $value->getLandArea()); $this->tpl->set_var("marketValue", number_format($afs->getTotalMarketValue())); $this->tpl->set_var("assessedValue", number_format($afs->getTotalAssessedValue(), 2, '.', ',')); $this->tpl->set_var("cancelsTDNumber", $td->getCancelsTDNumber()); $this->tpl->set_var("previousAssessedValue", $td->getPreviousAssessedValue()); $this->tpl->set_var("previousOwner", $td->getPreviousOwner()); $this->tpl->set_var("canceledByTDNumber", $td->getCanceledByTDNumber()); $landList = $afs->getLandArray(); $plantsTreesList = $afs->getPlantsTreesArray(); $improvementsBuildingsList = $afs->getImprovementsBuildingsArray(); $machineriesList = $afs->getMachineriesArray(); $this->tpl->set_var("taxability", $afs->getTaxability()); $this->tpl->set_var("effectivity", $afs->getEffectivity()); $kind = ""; $class = ""; if (count($landList)) { $kind = "Land"; $land = $landList[0]; $class = $land->getClassification(); $landClasses = new LandClasses(); $landClasses->selectRecord($class); $class = $landClasses->getDescription(); } else { if (count($plantsTreesList)) { $kind = "Land"; $plantsTrees = $plantsTreesList[0]; $class = $plantsTrees->getProductClass(); $plantsTreesClasses = new PlantsTreesClasses(); $plantsTreesClasses->selectRecord($class); $class = $plantsTreesClasses->getDescription(); } else { if (count($improvementsBuildingsList)) { $kind = "Improvements/Buildings"; $improvementsBuildings = $improvementsBuildingsList[0]; $class = $improvementsBuildings->getBuildingClassification(); $improvementsBuildingsClasses = new ImprovementsBuildingsClasses(); $improvementsBuildingsClasses->selectRecord($class); $class = $improvementsBuildingsClasses->getDescription(); } else { if (count($machineriesList)) { $kind = "Machineries"; $machineries = $machineriesList[0]; $class = $machineries->getKind(); } } } } $this->tpl->set_var("kind", $kind); $this->tpl->set_var("class", $class); $oValue = $value->owner; if (is_array($oValue->personArray)) { foreach ($oValue->personArray as $person) { $ownerNamesArray[] = $person->getName(); } } if (is_array($oValue->companyArray)) { foreach ($oValue->companyArray as $company) { $ownerNamesArray[] = $company->getCompanyName(); } } if (is_array($ownerNamesArray)) { $this->tpl->set_var("ownerNames", implode(",<br>", $ownerNamesArray)); } else { $this->tpl->set_var("ownerNames", ""); } unset($ownerNamesArray); if (count($oValue->personArray)) { $firstOwner = $oValue->personArray[0]->getLastName(); $firstOwner .= ", "; $firstOwner .= $oValue->personArray[0]->getFirstName(); $firstOwner .= " "; $firstOwner .= substr($oValue->personArray[0]->getMiddleName(), 0, 1) . "."; $pAddress = $oValue->personArray[0]->addressArray ? $oValue->personArray[0]->addressArray[0]->getFullAddress() : "no address"; $firstOwnerAddress = $pAddress; $firstOwnerTelephone = $oValue->personArray[0]->getTelephone(); $this->tpl->set_var("firstOwner", $firstOwner); $this->tpl->set_var("firstOwnerAddress", $firstOwnerAddress); $this->tpl->set_var("firstOwnerTelephone", $firstOwnerTelephone); } if (count($oValue->companyArray)) { if ($firstOwner == "") { $firstOwner = $oValue->companyArray[0]->getCompanyName(); $cAddress = $oValue->companyArray[0]->addressArray ? $oValue->companyArray[0]->addressArray[0]->getFullAddress() : "no address"; $firstOwnerAddress = $cAddress; $firstOwnerTelephone = $oValue->companyArray[0]->getTelephone(); $this->tpl->set_var("firstOwner", $firstOwner); $this->tpl->set_var("firstOwnerAddress", $firstOwnerAddress); $this->tpl->set_var("firstOwnerTelephone", $firstOwnerTelephone); } } if ($firstOwner != "") { $this->tpl->set_var("none", ""); if (count($oValue->personArray) + count($oValue->companyArray) > 1) { $this->tpl->set_var("andOthers", "(and others)"); } else { $this->tpl->set_var("andOthers", ""); } } else { $this->tpl->set_var("none", "none"); $this->tpl->set_var("firstOwner", ""); $this->tpl->set_var("andOthers", ""); $this->tpl->set_var("firstOwnerAddress", ""); $this->tpl->set_var("firstOwnerTelephone", ""); } $locationAddress = $value->locationAddress->getFullAddress(); $this->tpl->set_var("locationAddress", $locationAddress); $this->displayPrecedingOD(); $this->displaySucceedingOD(); //$this->tpl->set_var("transactionCode", $value->getTransactionCode()); $this->tpl->parse("ReportListBlock", "ReportList", true); } } } } break; default: $this->tpl->set_block("rptsTemplate", "NotFound", "NotFoundBlock"); $this->tpl->set_var("message", "select a location to view report"); $this->tpl->parse("NotFoundBlock", "NotFound", true); $this->tpl->set_block("rptsTemplate", "Report", "ReportBlock"); $this->tpl->set_var("ReportBlock", ""); break; } $this->setForm(); $this->tpl->set_var("Session", $this->sess->url("")); $this->tpl->set_var("rpts_Session", $this->sess->id); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); }
function displayTDDetails($propertyType) { $afsID = $this->formArray["afsID"]; $propertyID = $this->formArray["propertyID"]; $TDDetails = new SoapObject(NCCBIZ . "TDDetails.php", "urn:Object"); if (!($xmlStr = $TDDetails->getTD("", $afsID, $propertyID, $propertyType))) { $this->formArray["tdNumber"] = ""; $this->formArray["tdID"] = ""; $this->formArray["propertyType"] = $propertyType; } else { if (!($domDoc = domxml_open_mem($xmlStr))) { $this->formArray["tdNumber"] = ""; $this->formArray["tdID"] = ""; $this->formArray["propertyType"] = $propertyType; } else { $td = new TD(); $td->parseDomDocument($domDoc); $this->formArray["tdNumber"] = $td->getTaxDeclarationNumber(); //$this->formArray["effectivity"] = $td->taxBeginsWithTheYear(); foreach ($td as $tdkey => $tdvalue) { switch ($tdkey) { case "provincialAssessor": if (is_a($tdvalue, Assessor)) { $this->formArray["provincialAssessorID"] = $tdvalue->getAssessorID(); $this->formArray["provincialAssessorName"] = $tdvalue->getFullName(); } else { $this->formArray[$tdkey] = ""; } break; case "provincialAssessorDate": if (true) { list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $tdvalue); $this->formArray["pa_yearValue"] = removePreZero($dateArr["year"]); eval(MONTH_ARRAY); //$monthArray $this->formArray["pa_month"] = $monthArray[removePreZero($dateArr["month"])]; $this->formArray["pa_dayValue"] = removePreZero($dateArr["day"]); } else { $this->formArray[$tdkey] = ""; } $this->formArray[$tdkey] = $tdvalue; //RC 20091007 break; case "cityMunicipalAssessor": if (is_a($tdvalue, Assessor)) { $this->formArray["cityMunicipalAssessorID"] = $tdvalue->getAssessorID(); $this->formArray["cityMunicipalAssessorName"] = $tdvalue->getFullName(); } else { $this->formArray[$tdkey] = ""; } break; case "cityMunicipalAssessorDate": if (true) { list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $tdvalue); $this->formArray["cm_yearValue"] = removePreZero($dateArr["year"]); eval(MONTH_ARRAY); //$monthArray $this->formArray["cm_month"] = $monthArray[removePreZero($dateArr["month"])]; $this->formArray["cm_dayValue"] = removePreZero($dateArr["day"]); } else { $this->formArray[$tdkey] = ""; } $this->formArray[$tdkey] = $tdvalue; //RC 20091007 break; case "enteredInRPARForBy": if (is_a($tdvalue, Assessor)) { $this->formArray["enteredInRPARForByID"] = $tdvalue->getAssessorID(); $this->formArray["enteredInRPARForByName"] = $tdvalue->getFullName(); } else { $this->formArray[$tdkey] = ""; } break; case "previousOwner": // RC 20091006 This case allows for extra info $posSlash = strpos($tdvalue, "/"); if ($posSlash !== false) { $this->formArray[$tdkey] = substr($tdvalue, 0, $posSlash); $this->formArray["previousOwnerExtra"] = substr($tdvalue, $posSlash + 1); } else { $this->formArray[$tdkey] = $tdvalue; } break; case "cancelsTDNumber": // RC 20091006 allow for extra info $posSlash = strpos($tdvalue, "/"); if ($posSlash !== false) { $this->formArray[$tdkey] = substr($tdvalue, 0, $posSlash); $this->formArray["cancelsTDNumberExtra"] = substr($tdvalue, $posSlash + 1); } else { $this->formArray[$tdkey] = $tdvalue; } break; default: $this->formArray[$tdkey] = $tdvalue; } } } } }
function displayTD($afsID) { $TDDetails = new SoapObject(NCCBIZ . "TDDetails.php", "urn:Object"); if (!($xmlStr = $TDDetails->getTDFromAfsID($this->formArray["afsID"]))) { // xml failed } else { if (!($domDoc = domxml_open_mem($xmlStr))) { // error domDoc } else { $td = new TD(); $td->parseDomDocument($domDoc); $this->formArray["memoranda"] = $td->getMemoranda(); $this->formArray["taxDeclarationNumber"] = $td->getTaxDeclarationNumber(); $this->formArray["cancelsTDNumber"] = $td->getCancelsTDNumber(); $this->formArray["previousOwner"] = $td->getPreviousOwner(); $this->formArray["previousAssessedValue"] = $td->getPreviousAssessedValue(); } } }
function setDetails() { global $sess; $this->tpl->set_var($_GET); $this->tpl->set_var($_POST); # set the RPTOP to get the owner's object and information # get it from POST if possible, otherwise from GET $rptopID = isset($_POST['rptopID']) ? $_POST['rptopID'] : $_GET['rptopID']; $rptop = new RPTOP(); $rptop->selectRecord($rptopID); $dateDue = $rptop->getTaxableYear() . "-01-01"; # must be a usable format $formValues['taxableYear'] = $rptop->getTaxableYear(); $formValues['rptopNum'] = $rptop->getRptopNumber(); # set the specific TD (although this is in the RPTOP), hard to search for it. # get the tdID from POST or GET to initialize the TD $tdID = isset($_POST['tdID']) ? $_POST['tdID'] : $_GET['tdID']; $td = new TD(); $td->selectRecord($tdID); $tdNum = $td->getTaxDeclarationNumber(); $formValues['tdNum'] = $tdNum; # we define the property from the TD $propertyType = $td->getPropertyType(); $propertyID = $td->getPropertyID(); switch ($propertyType) { case "Land": $property = new Land(); break; case "PlantsTrees": $property = new PlantsTrees(); break; case "ImprovementsBuildings": $property = new ImprovementsBuildings(); break; case "Machineries": $property = new Machineries(); break; default: echo "cannot be! {$propertyType}"; break; } if (is_object($property)) { $property->selectRecord($propertyID); $assessedValue = number_format($property->getAssessedValue(), 2, ".", ""); $formValues['assessedValue'] = number_format($property->getAssessedValue(), 2); } $formValues['propertyType'] = $propertyType; # set the owner's List # we define the owner from the RPTOP $this->tpl->set_block('step3', 'Owner', 'Owners'); $owner = $rptop->getOwner(); $personArray = $owner->getPersonArray(); if (is_array($personArray)) { foreach ($personArray as $person) { $ownerValues['ownerName'] = $person->getLastName() . ", " . $person->getFirstName() . " " . $person->getMiddleName(); $addressArray = $person->getAddressArray(); $address = $addressArray[0]; $ownerValues['ownerAddress'] = $address->getNumber() . " " . $address->getStreet() . "<br>" . $address->getBarangay() . ", " . $address->getMunicipalityCity() . "<br>" . $address->getProvince(); $this->tpl->set_var($ownerValues); $this->tpl->parse('Owners', 'Owner', 'true'); } } $companyArray = $owner->getCompanyArray(); if (is_array($companyArray)) { foreach ($companyArray as $company) { $ownerValues['ownerName'] = $company->getCompanyName(); $addressArray = $company->getAddressArray(); $address = $addressArray[0]; $ownerValues['ownerAddress'] = $address->getNumber() . " " . $address->getStreet() . "<br>" . $address->getBarangay() . ", " . $address->getMunicipalityCity() . "<br> " . $address->getProvince(); $this->tpl->set_var($ownerValues); $this->tpl->parse('Owners', 'Owner', 'true'); } } # tax dues are defined from TDNumber and taxableYear # compute for taxes $taxDue = new Dues(); if ($taxDue->create($tdNum, $dateDue) == false) { $taxDue->setBasic($assessedValue); $taxDue->setSEF($assessedValue); $taxDue->setDueDate($dateDue); $taxDue->setUpdateDate(); } $paymentPeriod = "Annual"; if (isset($_POST['paymentPeriod'])) { $paymentPeriod = $_POST['paymentPeriod']; } switch ($paymentPeriod) { case 'Annual': $this->tpl->set_var("checkedAnnual", "checked"); break; case 'Q1': $this->tpl->set_var("checkedQ1", "checked"); break; case 'Q2': $this->tpl->set_var("checkedQ2", "checked"); break; case 'Q3': $this->tpl->set_var("checkedQ3", "checked"); break; case 'Q4': $this->tpl->set_var("checkedQ4", "checked"); break; default: break; } $this->tpl->set_var($formValues); ## Compute taxes and set the page values $basic = $taxDue->getBalanceBasic($paymentPeriod); $sef = $taxDue->getBalanceSEF($paymentPeriod); $interest = $taxDue->computePenalty($paymentPeriod); $taxValues['basic'] = number_format($basic, 2); $taxValues['sef'] = number_format($sef, 2); $taxValues['pd1185'] = number_format(0.0, 2); $taxValues['subTotal'] = number_format($basic + $sef, 2); $taxValues['periodTotal'] = number_format($basic + $sef, 2); $taxValues['discount'] = "0.0%"; $taxValues['interest'] = number_format($interest * 100.0, 1) . "%"; $taxValues['totBasic'] = number_format($basic * (1 + $interest), 2); $taxValues['totSEF'] = number_format($sef * (1 + $interest), 2); $taxValues['totPD1185'] = number_format(0, 2); $taxValues['totSubTotal'] = number_format(($basic + $sef) * (1 + $interest), 2); $taxValues['grandTotal'] = number_format(($basic + $sef) * (1 + $interest), 2); # further breakdown of basic tax for RPT Receipt $taxValues['gf'] = number_format($basic * 0.7, 2); // 70% of basic $taxValues['ib'] = number_format($basic * 0.15, 2); // 15% of basic $taxValues['cb'] = number_format($basic * 0.15, 2); // 15% of basic for a total if 100% $taxValues['totGF'] = number_format($basic * 0.7 * (1 + $interest), 2); $taxValues['totIB'] = number_format($basic * 0.15 * (1 + $interest), 2); $taxValues['totCB'] = number_format($basic * 0.15 * (1 + $interest), 2); $this->tpl->set_var($taxValues); if (!isset($_POST['printReceipt_x'])) { $this->tpl->set_var("Session", $sess->url("")); } }
function recordReceipt($varValues) { # create receipt object $collections = new Collections(); # set the details of the receipt $collections->setOldReceiptNum($varValues['prevORNum']); $collections->setRPTOPNum($varValues['rptopNum']); $tdID = $varValues['tdID']; $amountPaid = $varValues['amountPaid']; $isAmnesty = isset($varValues['amnesty']) ? "Yes" : "No"; $proceed = true; // insert backtaxTD record as a payment // and FLAG backtaxTD as PAID!!! ;) if ($_POST["backtaxTDCheckbox"]) { $backtaxTDID = $_POST['backtaxTDCheckbox']; $backtaxTD = new BacktaxTD(); $backtaxTD->selectRecord("", $backtaxTDID); $assessedValue = $backtaxTD->getTotalAssessedValue(); $paymentPeriod = $_POST['paymentPeriod']; $application = $paymentPeriod; $penalty = $backtaxTD->getTotalPenalties(); $totalTaxDue = $backtaxTD->getTotalTaxDue(); $totalTaxes = $backtaxTD->getTotalTaxes(); $amountPaid = str_replace(",", "", $amountPaid); if ($totalTaxDue > $amountPaid) { // payment is partial $totalPaid = $backtaxTD->getTotalPaid() + $amountPaid; $backtaxTD->setTotalPaid($totalPaid); $backtaxTD->updateRecord(); // FLAG paidStatus as "" (NOT YET FULLY PAID) for backtaxTDRecord $backtaxTD->updatePaidStatus(""); $amountPaid = 0; } else { if ($totalTaxDue <= $amountPaid) { // payment is full or exceeding full to payoff successive TD's // FLAG paidStatus as PAID for backtaxTDRecord $backtaxTD->updatePaidStatus("PAID"); $backtaxTD->setTotalPaid($totalTaxes); $backtaxTD->updateRecord(); $amountPaid = $amountPaid - $totalTaxDue; } } //Partial payment handler?? $basic = $backtaxTD->getTotalBasicTax(); $sef = $backtaxTD->getTotalSEFTax(); $idle = $backtaxTD->getTotalIdleTax(); $discount = 0; # record the payments for each receipt # recomputed instead of getting values from $_POST # used createRecord $payments[0] = new Payment("sef"); $payments[0]->setApplication($application); $payments[0]->createRecord("000"); $payments[0]->setAmount($sef); $payments[0]->setDiscount("0"); $payments[0]->setPenalty("0"); $payments[0]->setDueID("000"); $payments[0]->setDueType("backtaxTDID-sef,backtaxTDID=" . $backtaxTD->getBacktaxTDID()); $payments[0]->setReceiptNum($varValues['receiptNo']); $payments[0]->storeRecord(); $collections->addPayment($payments[0]); $payments[1] = new Payment("basic"); $payments[1]->setApplication($application); $payments[1]->createRecord("000"); $payments[1]->setAmount($basic); $payments[1]->setDiscount("0"); $payments[1]->setPenalty("0"); $payments[1]->setDueID("000"); $payments[1]->setDueType("backtaxTD-basic,backtaxTDID=" . $backtaxTD->getBacktaxTDID()); $payments[1]->setReceiptNum($varValues['receiptNo']); $payments[1]->storeRecord(); $collections->addPayment($payments[1]); $payments[2] = new Payment("idle"); $payments[2]->setApplication($application); $payments[2]->createRecord("000"); $payments[2]->setAmount($idle); $payments[2]->setDiscount("0"); $payments[2]->setPenalty("0"); $payments[2]->setDueID("000"); $payments[2]->setDueType("backtaxTD-idle,backtaxTDID=" . $backtaxTD->getBacktaxTDID()); $payments[2]->setReceiptNum($varValues['receiptNo']); $payments[2]->storeRecord(); $collections->addPayment($payments[2]); $payments[3] = new Payment("penalty"); $payments[3]->setApplication($application); $payments[3]->createRecord("0"); $payments[3]->setAmount($penalty); $payments[3]->setDiscount("0"); $payments[3]->setPenalty("0"); $payments[3]->setDueID("000"); $payments[3]->setDueType("backtaxTD-penalty,backtaxTDID=" . $backtaxTD->getBacktaxTDID()); $payments[3]->setReceiptNum($varValues['receiptNo']); $payments[3]->storeRecord(); $collections->addPayment($payments[3]); $payments[4] = new Payment("pd1185"); $payments[4]->setApplication($application); $payments[4]->createRecord("000"); $payments[4]->setAmount("0"); $payments[4]->setDiscount("0"); $payments[4]->setPenalty("0"); $payments[4]->setDueID("000"); $payments[4]->setDueType("backtaxTD-pd1185,backtaxTDID=" . $backtaxTD->getBacktaxTDID()); $payments[4]->setReceiptNum($varValues['receiptNo']); $payments[4]->storeRecord(); $collections->addPayment($payments[4]); //$taxDue->reapplyPayments(); //$taxDue->store(); //print_r($payments); if (!$proceed) { break; } } if (is_array($tdID)) { foreach ($tdID as $key => $id) { $td = new TD(); $td->selectRecord($id); # get assessed value and use it to compute taxes -- 07 Aug 2003 $propertyType = $td->getPropertyType(); $propertyID = $td->getPropertyID(); $assessedValue = number_format($td->getAssessedValue(), 2, ".", ""); $tdNum = $td->getTaxDeclarationNumber(); $collections->setTDNum($tdNum); # get the specific due by using the tdNum and the date on the RPTOP $rptop = new RPTOP(); # changed to taxableYear & selected record using rptopID instead of rptopNum if ($rptop->selectRecord($varValues['rptopID'])) { $dueDate = $rptop->getTaxableYear(); } else { # did not find due date in POST // if there is no valid RPTOP provided, then just use the dueDate $dueDate = $varValues['dueDate']; } $dueDate = $td->getTaxBeginsWithTheYear(); $taxDue = new Dues($id, $dueDate); /*$taxDue = new Dues();*/ if (!$taxDue->create($id, $dueDate)) { $taxDue->setBasic($assessedValue); $taxDue->setSEF($assessedValue); # check if land is idle, if yes, set assessed value if ($taxDue->getIdleStatus() == 1) { $taxDue->setIdle($assessedValue); $idleStatus = 1; } else { $taxDue->setIdle(0); $idleStatus = 0; } } $paymentPeriod = $taxDue->getPaymentMode(); if ($taxDue->getPctPenalty() > 0 && $paymentPeriod != "Annual") { $paymentPeriod = "Annual"; } $application = $paymentPeriod; if ($application == "Quarter") { $application = "Q" . ceil(date("n") / 3); $taxDue->setPaidQuarters(ceil(date("n") / 3)); } #echo("b=$basic<br>s=$sef<br>i=$idle"); # if amnesty declared, no interest on late payments, set penalty to 0 if (isset($varValues['amnesty']) || $taxDue->getIsDiscount()) { $taxDue->setAmnesty("Yes"); $taxDue->resetPenalty(); $interest = 0; } else { $taxDue->setAmnesty("No"); $interest = $taxDue->getPctPenalty(); } $penalty = $taxDue->getBalancePenalty($paymentPeriod); $totalTaxDue = $taxDue->getTotalDue($paymentPeriod); //Partial payment handler $basic = $taxDue->getBalanceBasic($paymentPeriod); $sef = $taxDue->getBalanceSEF($paymentPeriod); $idle = $taxDue->getBalanceIdle($paymentPeriod); $discount = $taxDue->getDiscount(); $discountSEF = $taxDue->getIsDiscount() ? $sef * $taxDue->getDiscountPercentage() / 100 : 0; $discountBasic = $taxDue->getIsDiscount() ? $basic * $taxDue->getDiscountPercentage() / 100 : 0; if (str_replace(",", "", $amountPaid) < $totalTaxDue) { $basic = round(str_replace(",", "", $amountPaid) * (($basic - $discountBasic) / $totalTaxDue), 2); $sef = round(str_replace(",", "", $amountPaid) * (($sef - $discountSEF) / $totalTaxDue), 2); $idle = round(str_replace(",", "", $amountPaid) * ($idle / $totalTaxDue), 2); $penalty = round(str_replace(",", "", $amountPaid) * ($penalty / $totalTaxDue), 2); $proceed = false; } # record the payments for each receipt # recomputed instead of getting values from $_POST # used createRecord $payments[0] = new Payment("sef"); $payments[0]->setApplication($application); $payments[0]->createRecord($taxDue->getDueID()); $payments[0]->setAmount($sef); $payments[0]->setDiscount($discountSEF); $payments[0]->setPenalty($sef * $interest); $payments[0]->setDueID($taxDue->getDueID()); $payments[0]->setDueType("sef"); $payments[0]->setReceiptNum($varValues['receiptNo']); $payments[0]->storeRecord(); $collections->addPayment($payments[0]); # $gfTotal = ($basic*0.7)*(1+interest); # $ibTotal = ($basic*0.15)*(1+interest); # $cbTotal = ($basic*0.15)*(1+interest); $payments[1] = new Payment("basic"); $payments[1]->setApplication($application); $payments[1]->createRecord($taxDue->getDueID()); $payments[1]->setAmount($basic); $payments[1]->setDiscount($discountBasic); $payments[1]->setPenalty($basic * $interest); $payments[1]->setDueID($taxDue->getDueID()); $payments[1]->setDueType("basic"); $payments[1]->setReceiptNum($varValues['receiptNo']); $payments[1]->storeRecord(); $collections->addPayment($payments[1]); $payments[2] = new Payment("idle"); $payments[2]->setApplication($application); $payments[2]->createRecord($taxDue->getDueID()); $payments[2]->setAmount($idle); $payments[2]->setDiscount(0); $payments[2]->setPenalty($idle * $interest); $payments[2]->setDueID($taxDue->getDueID()); $payments[2]->setDueType("idle"); $payments[2]->setReceiptNum($varValues['receiptNo']); $payments[2]->storeRecord(); $collections->addPayment($payments[2]); $payments[3] = new Payment("penalty"); $payments[3]->setApplication($application); $payments[3]->createRecord($taxDue->getDueID()); $payments[3]->setAmount($penalty); $payments[3]->setDiscount(0); $payments[3]->setPenalty(0); $payments[3]->setDueID($taxDue->getDueID()); $payments[3]->setDueType("penalty"); $payments[3]->setReceiptNum($varValues['receiptNo']); $payments[3]->storeRecord(); $collections->addPayment($payments[3]); $payments[4] = new Payment("pd1185"); $payments[4]->setApplication($application); $payments[4]->createRecord($taxDue->getDueID()); $payments[4]->setAmount(round(0, 2)); $payments[4]->setDiscount(0); $payments[4]->setPenalty(0); $payments[4]->setDueID($taxDue->getDueID()); $payments[4]->setDueType("pd1185"); $payments[4]->setReceiptNum($varValues['receiptNo']); # print_r($payments); $payments[4]->storeRecord(); $collections->addPayment($payments[4]); $taxDue->reapplyPayments(); $taxDue->store(); if (!$proceed) { break; } } } # end foreach //* // get parent TD //$tdID = $backtaxTD->getTDID(); //*/ # set collection details and save to db; no receipt number yet # format date to db date YYYY-MM-DD list($month, $day, $year) = explode("-", $varValues['checkDate']); list($oldReceiptMonth, $oldReceiptDay, $oldReceiptYear) = explode("-", $varValues['prevORDate']); $collections->setCollectionDate(date("Y-m-d")); $collections->setCollectionSum($varValues['collectionSum']); $collections->setReceivedFrom($varValues['receivedFrom']); $collections->setKindOfPayment($varValues['kindOfPayment']); $collections->setCheckNum($varValues['checkNum']); $collections->setCheckDate($year . "-" . $month . "-" . $day); $collections->setOldReceiptNum($varValues['prevORNum']); $collections->setOldReceiptDate($oldReceiptYear . "-" . $oldReceiptMonth . "-" . $oldReceiptDay); $collections->setMunicipality($varValues['municipalityCityID']); $collections->setAmnesty($isAmnesty); $collections->createRecord(); $collections->storeRecord(); # get collection id and use it to close receipt $collectionID = $collections->getCollectionID(); $_POST['collectionID'] = $collectionID; }