function generateTDHistory($tdID)
{
$td = new TD();
$td->selectRecord($tdID);
$afsID = $td->getAfsID();
// echo("afsID=$afsID<br>");
$afs = new AFS();
$afs->selectRecord($afsID);
$odID = $afs->getOdID();
// echo("odID=$odID<br>");
$condition = sprintf(" WHERE presentODID='%s' ", fixQuotes($odID));
$odHistoryRecords = new ODHistoryRecords();
$odHistoryRecords->selectRecords($condition);
if (count($odHistoryRecords->arrayList) > 0) {
// echo("count>0<br>");
foreach ($odHistoryRecords->arrayList as $key => $odHistory) {
$previousODID = $odHistory->getPreviousODID();
$presentODID = $odHistory->getPresentODID();
$previousAFS = new AFS();
$previousAFS->selectRecord($afsID = "", $limit = "", $previousODID);
$previousAFSID = $previousAFS->getAfsID();
$previousTD = new TD();
$previousTD->selectRecord($tdID = "", $previousAFSID);
$previousTDID = $previousTD->getTdID();
$this->tdHistory[] = $previousTD;
$this->generateTDHistory($previousTDID);
}
} else {
//echo("count==0<br>");
return false;
}
}
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 getTDListOf($id, $type, $year)
{
$owner = new Owner();
//echo("\$ownerIDArray = \$owner->selectOwner".$type."(".$id.");");
eval("\$ownerIDArray = \$owner->selectOwner" . $type . "(" . $id . ");");
if ($ownerIDArray) {
$odArray = "";
foreach ($ownerIDArray as $key => $value) {
eval("\$odID = \$owner->selectOD" . $type . "({$value});");
if ($odID) {
$odArray[] = $odID;
}
}
unset($owner);
if ($odArray) {
$afsArray = "";
foreach ($odArray as $key => $value) {
$afs = new AFS();
$afsIDArray[] = $afs->checkAfsID($value);
}
unset($afs);
if ($afsIDArray) {
$tdRecords = new TDRecords();
$tdIDArray = "";
foreach ($afsIDArray as $tkey => $tvalue) {
$td = new TD();
if ($td->selectRecord("", $tvalue, "", "", $year)) {
$tdIDArray[] = $td->getTdID();
}
unset($td);
/*
$afs = new AFS;
$afs->selectRecord($tvalue);
//print_r($afs);
//echo "<br>";
$landArray = $afs->getLandArray();
$plantsTreesArray = $afs->getPlantsTreesArray();
$improvementsBuildingsArray = $afs->getImprovementsBuildingsArray();
$machineriesArray = $afs->getMachineriesArray();
unset($afs);
if ($landArray){
foreach($landArray as $lkey => $lvalue){
//echo($lvalue->getPropertyID()."<br>");
$td = new TD;
if ($td->selectRecord("",$lvalue->getPropertyID(),"Land",$year)){
$tdRecords->setArrayList($td);
$tdIDArray[] = $td->getTdID();
}
unset($td);
}
}
if ($plantsTreesArray){
foreach($plantsTreesArray as $lkey => $lvalue){
//echo($lvalue->getPropertyID()."<br>");
$td = new TD;
if ($td->selectRecord("",$lvalue->getPropertyID(),"PlantsTrees",$year)){
$tdRecords->setArrayList($td);
$tdIDArray[] = $td->getTdID();
}
unset($td);
}
}
if ($improvementsBuildingsArray){
foreach($improvementsBuildingsArray as $lkey => $lvalue){
//echo($lvalue->getPropertyID()."<br>");
$td = new TD;
if ($td->selectRecord("",$lvalue->getPropertyID(),"ImprovementsBuildings",$year)){
$tdRecords->setArrayList($td);
$tdIDArray[] = $td->getTdID();
}
unset($td);
}
}
if ($machineriesArray){
foreach($machineriesArray as $lkey => $lvalue){
//echo($lvalue->getPropertyID()."<br>");
$td = new TD;
if ($td->selectRecord("",$lvalue->getPropertyID(),"Machineries",$year)){
$tdRecords->setArrayList($td);
$tdIDArray[] = $td->getTdID();
}
unset($td);
}
}*/
}
$ret = $tdIDArray;
//print_r($tdRecords->getArrayList());
/*if ($tdRecords->getArrayList()){
$tdRecords->setDomDocument();
if(!$domDoc = $tdRecords->getDomDocument()){
return $ret = false;
}
else {
$xmlStr = $domDoc->dump_mem(true);
return $ret = $xmlStr;
}
}
else $ret = false;*/
} else {
$ret = false;
}
} else {
$ret = false;
}
} else {
$ret = false;
}
return $ret;
}
function refreshTDHistory($td)
{
$ODDetails = new SoapObject(NCCBIZ . "ODDetails.php", "urn:Object");
if ($this->formArray["odID"] = $ODDetails->getOdIDFromTdID($td->getTdID())) {
$ODHistoryList = new SoapObject(NCCBIZ . "ODHistoryList.php", "urn:Object");
$ODHistoryRecords = new ODHistoryRecords();
if (!($xmlStr = $ODHistoryList->getPrecedingODList($this->formArray["odID"]))) {
// do nothing. no preceding OD
return false;
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
// no nothing. no preceding OD
} else {
$ODHistoryRecords->parseDomDocument($domDoc);
$precedingODList = $ODHistoryRecords->arrayList;
$AFSEncode = new SoapObject(NCCBIZ . "AFSEncode.php", "urn:Object");
$AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object");
$TDDetails = new SoapObject(NCCBIZ . "TDDetails.php", "urn:Object");
foreach ($precedingODList as $key => $odHistory) {
$previousODID = $odHistory->getPreviousODID();
$previousAFSID = $AFSEncode->getAfsID($previousODID);
$previousAFSxml = $AFSDetails->getAfs($previousAFSID);
$previousAFSdomDoc = domxml_open_mem($previousAFSxml);
$previousAFS = new AFS();
$previousAFS->parseDomDocument($previousAFSdomDoc);
$precedingTDxml = $TDDetails->getTDFromAfsID($previousAFSID);
$precedingTDdomDoc = domxml_open_mem($precedingTDxml);
$precedingTD = new TD();
$precedingTD->parseDomDocument($precedingTDdomDoc);
// capture DUES of precedingTD
$DueList = new SoapObject(NCCBIZ . "DueList.php", "urn:Object");
if (!($xmlStr = $DueList->getDueList($precedingTD->getTdID(), $this->formArray["taxableYear"] - 1))) {
// no Dues for precedingTD
//echo "no dues";
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
// no Dues for precedingTD
//echo "no dues";
} else {
$dueRecords = new DueRecords();
$dueRecords->parseDomDocument($domDoc);
foreach ($dueRecords->getArrayList() as $due) {
foreach ($due as $dueKey => $dueValue) {
switch ($dueKey) {
case "dueType":
$dueArray[$dueValue] = $due;
break;
}
}
}
$BacktaxTDDetails = new SoapObject(NCCBIZ . "BacktaxTDDetails.php", "urn:Object");
$BacktaxTDEncode = new SoapObject(NCCBIZ . "BacktaxTDEncode.php", "urn:Object");
if (!($xmlStr = $BacktaxTDDetails->getBacktaxTD($td->getTdID(), $this->formArray["taxableYear"] - 1))) {
// backtax for Due does not exist, create backtax record
$backtaxTD = $this->setBacktaxTDFromDueArray($td->getTdID(), "", $dueArray, $precedingTD, $previousAFS);
$backtaxTD->setDomDocument();
$backtaxTDDoc = $backtaxTD->getDomDocument();
$backtaxTDXmlStr = $backtaxTDDoc->dump_mem(true);
if (!($backtaxTDID = $BacktaxTDEncode->saveBacktaxTD($backtaxTDXmlStr))) {
echo "Error saving BacktaxTD";
}
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
// backtax for Due does not exist, create backtax
$backtaxTD = $this->setBacktaxTDFromDueArray($td->getTdID(), "", $dueArray, $precedingTD, $previousAFS);
$backtaxTD->setDomDocument();
$backtaxTDDoc = $backtaxTD->getDomDocument();
$backtaxTDXmlStr = $backtaxTDDoc->dump_mem(true);
if (!($backtaxTDID = $BacktaxTDEncode->saveBacktaxTD($backtaxTDXmlStr))) {
echo "Error saving BacktaxTD";
}
} else {
// update backtax record from Due
$backtaxTD = new BacktaxTD();
$backtaxTD->parseDomDocument($domDoc);
$backtaxTD = $this->setBacktaxTDFromDueArray($td->getTdID(), $backtaxTD->getBacktaxTDID(), $dueArray, $precedingTD, $previousAFS);
$backtaxTD->setDomDocument();
$backtaxTDDoc = $backtaxTD->getDomDocument();
$backtaxTDXmlStr = $backtaxTDDoc->dump_mem(true);
if (!($backtaxTDID = $BacktaxTDEncode->updateBacktaxTD($backtaxTDXmlStr))) {
echo "Error updating BacktaxTD";
}
}
}
}
}
}
}
}
}
}
function getTDIDArrayFromParentTDID($presentTDID)
{
$presentTD = new TD();
$presentTD->selectRecord($presentTDID);
$presentAfsID = $presentTD->getAfsID();
$presentAFS = new AFS();
$presentAFS->selectRecord($presentAFSID);
$presentODID = $presentAFS->getOdID();
$odHistoryRecords = new ODHistoryRecords();
$odHistoryRecords->selectPrecOD($presentODID);
if (is_array($odHistoryRecords->arrayList)) {
foreach ($odHistoryRecords as $odID) {
$afs = new AFS();
$afs->selectRecord("", "", $odID);
$afsID = $afs->getAfsID();
$td = new TD();
$td->selectRecord("", $afsID);
$tdID = $td->getTdID();
$tdIDArray[] = $tdID;
}
if (is_array($tdIDArray)) {
return $tdIDArray;
}
}
return false;
}
function getTDListOf($id, $type, $year)
{
$owner = new Owner();
eval("\$ownerIDArray = \$owner->selectOwner" . $type . "(" . $id . ");");
if ($ownerIDArray) {
$odArray = "";
foreach ($ownerIDArray as $key => $value) {
eval("\$odID = \$owner->selectOD" . $type . "({$value});");
if ($odID) {
$odArray[] = $odID;
}
}
unset($owner);
if ($odArray) {
$afsArray = "";
foreach ($odArray as $key => $value) {
$afs = new AFS();
$odHistoryRecords = new OdHistoryRecords();
$afsID = $afs->checkAFSYear($value, $year);
$odHistoryArr = $odHistoryRecords->selectSuccOD($value, $year);
if ($odHistoryArr) {
$latestAfs = true;
foreach ($odHistoryArr as $k => $v) {
if ($afs->checkAFSYear($v, $year)) {
$latestAfs = false;
}
}
if ($latestAfs) {
$afsIDArray[] = $afsID;
}
} else {
if ($afsID != "") {
$afsIDArray[] = $afsID;
}
}
}
unset($afs);
if ($afsIDArray) {
$tdRecords = new TDRecords();
$tdIDArray = "";
foreach ($afsIDArray as $tkey => $tvalue) {
$td = new TD();
if ($td->selectRecord("", $tvalue)) {
// added the following if($td->getArchive()!="true") line on September 10, 2005 to..
// ..omit 'cancelled' TDs and other TDs that went through a transaction in..
// ..creating new RPTOPs.
if ($td->getArchive() != "true") {
$tdIDArray[] = $td->getTdID();
}
}
unset($td);
}
$ret = $tdIDArray;
} else {
$ret = false;
}
} else {
$ret = false;
}
} else {
$ret = false;
}
return $ret;
}
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 getTDListOf($id, $type, $year)
{
echo "<br><br>" . $year . "-" . $id;
$owner = new Owner();
//echo("\$ownerIDArray = \$owner->selectOwner".$type."(".$id.");");
eval("\$ownerIDArray = \$owner->selectOwner" . $type . "(" . $id . ");");
echo "<br>ownerIDArray - ";
print_r($ownerIDArray);
if ($ownerIDArray) {
$odArray = "";
foreach ($ownerIDArray as $key => $value) {
eval("\$odID = \$owner->selectOD" . $type . "({$value});");
if ($odID) {
$odArray[] = $odID;
}
}
echo "<br>odArray - ";
print_r($odArray);
unset($owner);
if ($odArray) {
$afsArray = "";
foreach ($odArray as $key => $value) {
$afs = new AFS();
$odHistoryRecords = new OdHistoryRecords();
$afsID = $afs->checkAFSYear($value, $year);
$afs->selectRecord("", "", $value);
//print_r($value);
$odHistoryArr = $odHistoryRecords->selectSuccOD($value, $year);
if ($odHistoryArr) {
$latestAfs = true;
foreach ($odHistoryArr as $k => $v) {
if ($afs->checkAFSYear($v, $year)) {
$latestAfs = false;
}
echo "<br>latestAfs = " . $latestAfs . "<br>odID = " . $v . "<br>year" . $year . " - " . $afs->getEffectivity();
}
if ($latestAfs) {
$afsIDArray[] = $afsID;
}
} else {
if ($afsID != "") {
$afsIDArray[] = $afsID;
}
}
//if ($latesAfs) $afsIDArray[] = $afsID;
}
echo "<br>afsIDArray - ";
print_r($afsIDArray);
unset($afs);
if ($afsIDArray) {
$tdRecords = new TDRecords();
$tdIDArray = "";
foreach ($afsIDArray as $tkey => $tvalue) {
$td = new TD();
//echo $tvalue;
if ($td->selectRecord("", $tvalue)) {
//echo $td->getTdID();
$tdIDArray[] = $td->getTdID();
}
unset($td);
/*
$afs = new AFS;
$afs->selectRecord($tvalue);
//print_r($afs);
//echo "<br>";
$landArray = $afs->getLandArray();
$plantsTreesArray = $afs->getPlantsTreesArray();
$improvementsBuildingsArray = $afs->getImprovementsBuildingsArray();
$machineriesArray = $afs->getMachineriesArray();
unset($afs);
if ($landArray){
foreach($landArray as $lkey => $lvalue){
//echo($lvalue->getPropertyID()."<br>");
$td = new TD;
if ($td->selectRecord("",$lvalue->getPropertyID(),"Land",$year)){
$tdRecords->setArrayList($td);
$tdIDArray[] = $td->getTdID();
}
unset($td);
}
}
if ($plantsTreesArray){
foreach($plantsTreesArray as $lkey => $lvalue){
//echo($lvalue->getPropertyID()."<br>");
$td = new TD;
if ($td->selectRecord("",$lvalue->getPropertyID(),"PlantsTrees",$year)){
$tdRecords->setArrayList($td);
$tdIDArray[] = $td->getTdID();
}
unset($td);
}
}
if ($improvementsBuildingsArray){
foreach($improvementsBuildingsArray as $lkey => $lvalue){
//echo($lvalue->getPropertyID()."<br>");
$td = new TD;
if ($td->selectRecord("",$lvalue->getPropertyID(),"ImprovementsBuildings",$year)){
$tdRecords->setArrayList($td);
$tdIDArray[] = $td->getTdID();
}
unset($td);
}
}
if ($machineriesArray){
foreach($machineriesArray as $lkey => $lvalue){
//echo($lvalue->getPropertyID()."<br>");
$td = new TD;
if ($td->selectRecord("",$lvalue->getPropertyID(),"Machineries",$year)){
$tdRecords->setArrayList($td);
$tdIDArray[] = $td->getTdID();
}
unset($td);
}
}*/
}
//print_r($tdIDArray);
$ret = $tdIDArray;
//print_r($tdRecords->getArrayList());
/*if ($tdRecords->getArrayList()){
$tdRecords->setDomDocument();
if(!$domDoc = $tdRecords->getDomDocument()){
return $ret = false;
}
else {
$xmlStr = $domDoc->dump_mem(true);
return $ret = $xmlStr;
}
}
else $ret = false;*/
} else {
$ret = false;
}
} else {
$ret = false;
}
} else {
$ret = false;
}
return $ret;
}
