Example #1
0
 function searchOD($page = 0, $condition, $searchKey)
 {
     if ($page > 0) {
         $page = ($page - 1) * PAGE_BY;
         $condition = "LIMIT {$page}," . PAGE_BY;
     }
     $fields = array(COMPANY_TABLE . ".companyName", PERSON_TABLE . ".lastName", PERSON_TABLE . ".middleName", PERSON_TABLE . ".firstName", LOCATIONADDRESS_TABLE . ".number", LOCATIONADDRESS_TABLE . ".street", BARANGAY_TABLE . ".code", LOCATIONADDRESS_TABLE . ".district", LOCATIONADDRESS_TABLE . ".municipalityCity", LOCATIONADDRESS_TABLE . ".province");
     $odRecords = new ODRecords();
     if ($odRecords->searchRecords($searchKey, $fields, $condition)) {
         if (!($domDoc = $odRecords->getDomDocument())) {
             return false;
         } else {
             $xmlStr = $domDoc->dump_mem(true);
             return $xmlStr;
         }
     } else {
         return false;
     }
 }
Example #2
0
 function Main()
 {
     switch ($this->formArray["formAction"]) {
         case "delete":
             //print_r($this->formArray);
             if (count($this->formArray["odID"]) > 0) {
                 $ODList = new SoapObject(NCCBIZ . "ODList.php", "urn:Object");
                 if (!($deletedRows = $ODList->deleteOD($this->formArray["odID"]))) {
                     $this->tpl->set_var("msg", "SOAP failed");
                 } else {
                     $this->tpl->set_var("msg", $deletedRows . " records deleted");
                 }
             } else {
                 $this->tpl->set_var("msg", "0 records deleted");
             }
             break;
         case "filterBarangay":
             $ODList = new SoapObject(NCCBIZ . "ODList.php", "urn:Object");
             $this->tpl->set_block("rptsTemplate", "Pages", "PagesBlock");
             $this->tpl->set_block("rptsTemplate", "PagesList", "PagesListBlock");
             $condition = $this->filterArchives();
             if (!($count = $ODList->filterByBarangayCount($this->formArray["barangay"], $condition))) {
                 $this->tpl->set_var("PagesBlock", "");
                 $this->tpl->set_var("PagesListBlock", "");
                 $this->tpl->set_block("rptsTemplate", "PageNavigator", "PageNavigatorBlock");
                 $this->tpl->set_var("PageNavigatorBlock", "");
                 $numOfPages = 1;
             } else {
                 $numOfPages = ceil($count / PAGE_BY);
                 // page list nav
                 $this->formArray["pageLinksInLine"] = 7;
                 if ($this->formArray["page"] < round($this->formArray["pageLinksInLine"] / 2)) {
                     $startPageLinks = 1;
                 } else {
                     $startPageLinks = $this->formArray["page"] - round($this->formArray["pageLinksInLine"] / 2);
                     if ($startPageLinks < 1) {
                         $startPageLinks = 1;
                     }
                 }
                 $endPageLinks = $startPageLinks + ($this->formArray["pageLinksInLine"] - 1);
                 if ($endPageLinks > $numOfPages) {
                     $endPageLinks = $numOfPages;
                 }
                 for ($i = $startPageLinks; $i <= $endPageLinks; $i++) {
                     if ($i == $this->formArray["page"]) {
                         $this->tpl->set_var("pageListPages", "");
                         $this->tpl->set_var("pageListPagesUrl", "");
                         $this->tpl->set_var("pageListPaged", $i);
                     } else {
                         $this->tpl->set_var("pageListPages", $i);
                         $this->tpl->set_var("pageListPagesUrl", $i . "&formAction=filterBarangay&barangay=" . urlencode($this->formArray["barangay"]));
                         $this->tpl->set_var("pageListPaged", "");
                     }
                     $this->tpl->parse("PagesListBlock", "PagesList", true);
                 }
                 // drop down nav
                 for ($i = 1; $i <= $numOfPages; $i++) {
                     if ($i == $this->formArray["page"]) {
                         $this->tpl->set_var("pages", $i);
                         $this->tpl->set_var("pagesUrl", $i . "&formAction=filterBarangay&barangay=" . urlencode($this->formArray["barangay"]));
                         $this->tpl->set_var("paged", "selected");
                     } else {
                         $this->tpl->set_var("pages", $i);
                         $this->tpl->set_var("pagesUrl", $i . "&formAction=filterBarangay&barangay=" . urlencode($this->formArray["barangay"]));
                         $this->tpl->set_var("paged", "");
                     }
                     $this->tpl->parse("PagesBlock", "Pages", true);
                 }
             }
             if ($numOfPages == $this->formArray["page"]) {
                 $this->tpl->set_var("nextTxt", "");
             } else {
                 $this->tpl->set_var("next", $this->formArray["page"] + 1 . "&formAction=filterBarangay&barangay=" . urlencode($this->formArray["barangay"]));
                 $this->tpl->set_var("nextTxt", "next");
             }
             if ($this->formArray["page"] == 1) {
                 $this->tpl->set_var("previousTxt", "");
             } else {
                 $this->tpl->set_var("previous", $this->formArray["page"] - 1 . "&formAction=filterBarangay&barangay=" . urlencode($this->formArray["barangay"]));
                 $this->tpl->set_var("previousTxt", "previous");
             }
             $condition = $this->filterArchives();
             $condition .= $this->sortBlocks();
             $this->tpl->set_var("pageOf", $this->formArray["page"] . " of " . $numOfPages);
             if (!($xmlStr = $ODList->filterByBarangay($this->formArray["page"], $this->formArray["barangay"], $condition))) {
                 $this->tpl->set_var("pageOf", "");
                 $this->tpl->set_block("rptsTemplate", "ODTable", "ODTableBlock");
                 $this->tpl->set_var("ODTableBlock", "");
                 $this->tpl->set_block("rptsTemplate", "ODDBEmpty", "ODDBEmptyBlock");
                 $this->tpl->set_var("ODDBEmptyBlock", "");
                 $this->tpl->set_block("rptsTemplate", "Pages", "PagesBlock");
                 $this->tpl->set_var("PagesBlock", "");
                 $this->tpl->set_var("PagesListBlock", "");
                 $this->tpl->set_var("previousTxt", "");
                 $this->tpl->set_var("nextTxt", "");
             } else {
                 if (!($domDoc = domxml_open_mem($xmlStr))) {
                     $this->tpl->set_block("rptsTemplate", "ODListTable", "ODListTableBlock");
                     $this->tpl->set_var("ODListTableBlock", "error xmlDoc");
                 } else {
                     $this->tpl->set_block("rptsTemplate", "NotFound", "NotFoundBlock");
                     $this->tpl->set_var("NotFoundBlock", "");
                     $odRecords = new ODRecords();
                     $odRecords->parseDomDocument($domDoc);
                     $list = $odRecords->getArrayList();
                     if (count($list)) {
                         $this->tpl->set_block("rptsTemplate", "ODDBEmpty", "ODDBEmptyBlock");
                         $this->tpl->set_var("ODDBEmptyBlock", "");
                         $this->tpl->set_block("rptsTemplate", "ODList", "ODListBlock");
                         $this->tpl->set_block("ODList", "PersonList", "PersonListBlock");
                         $this->tpl->set_block("ODList", "CompanyList", "CompanyListBlock");
                         foreach ($list as $key => $value) {
                             $this->tpl->set_var("odID", $value->getOdID());
                             // added propertyType column : October 20, 2005:
                             $propertyType = $this->getPropertyTypeFromOD($value);
                             $this->tpl->set_var("propertyType", $propertyType);
                             $oValue = $value->owner;
                             $pOwnerStr = "";
                             if (count($oValue->personArray)) {
                                 foreach ($oValue->personArray as $pKey => $pValue) {
                                     $this->tpl->set_var("personID", $pValue->getPersonID());
                                     $this->tpl->set_var("OwnerPerson", $pValue->getFullName());
                                     $this->tpl->parse("PersonListBlock", "PersonList", true);
                                 }
                             }
                             if (count($oValue->companyArray)) {
                                 foreach ($oValue->companyArray as $cKey => $cValue) {
                                     $this->tpl->set_var("companyID", $cValue->getCompanyID());
                                     $this->tpl->set_var("OwnerCompany", $cValue->getCompanyName());
                                     $this->tpl->parse("CompanyListBlock", "CompanyList", true);
                                 }
                             }
                             if (count($oValue->personArray) || count($oValue->companyArray)) {
                                 $this->tpl->set_var("none", "");
                             } else {
                                 $this->tpl->set_var("none", "none");
                             }
                             //*/
                             //echo method_exists($value->location,getFullAddress);
                             $this->tpl->set_var("locationAddress", $value->locationAddress->getFullAddress());
                             $this->tpl->set_var("landArea", number_format($value->getLandArea(), 4, '.', ','));
                             // $this->tpl->set_var("landArea", formatCurrency1($value->getLandArea()));
                             $this->setODListBlockPerms();
                             $this->tpl->parse("ODListBlock", "ODList", true);
                             $this->tpl->set_var("PersonListBlock", "");
                             $this->tpl->set_var("CompanyListBlock", "");
                         }
                     } else {
                         $this->tpl->set_block("rptsTemplate", "ODList", "ODListBlock");
                         $this->tpl->set_var("ODListBlock", "huh");
                     }
                 }
             }
             break;
         case "search":
             $ODList = new SoapObject(NCCBIZ . "ODList.php", "urn:Object");
             $this->tpl->set_block("rptsTemplate", "Pages", "PagesBlock");
             $this->tpl->set_block("rptsTemplate", "PagesList", "PagesListBlock");
             $condition = $this->filterArchives();
             if (!($count = $ODList->getSearchCount($this->formArray["searchKey"], $condition))) {
                 $this->tpl->set_var("PagesBlock", "");
                 $this->tpl->set_var("PagesListBlock", "");
                 $this->tpl->set_block("rptsTemplate", "PageNavigator", "PageNavigatorBlock");
                 $this->tpl->set_var("PageNavigatorBlock", "");
                 $numOfPages = 1;
             } else {
                 $numOfPages = ceil($count / PAGE_BY);
                 // page list nav
                 $this->formArray["pageLinksInLine"] = 7;
                 if ($this->formArray["page"] < round($this->formArray["pageLinksInLine"] / 2)) {
                     $startPageLinks = 1;
                 } else {
                     $startPageLinks = $this->formArray["page"] - round($this->formArray["pageLinksInLine"] / 2);
                     if ($startPageLinks < 1) {
                         $startPageLinks = 1;
                     }
                 }
                 $endPageLinks = $startPageLinks + ($this->formArray["pageLinksInLine"] - 1);
                 if ($endPageLinks > $numOfPages) {
                     $endPageLinks = $numOfPages;
                 }
                 for ($i = $startPageLinks; $i <= $endPageLinks; $i++) {
                     if ($i == $this->formArray["page"]) {
                         $this->tpl->set_var("pageListPages", "");
                         $this->tpl->set_var("pageListPagesUrl", "");
                         $this->tpl->set_var("pageListPaged", $i);
                     } else {
                         $this->tpl->set_var("pageListPages", $i);
                         $this->tpl->set_var("pageListPagesUrl", $i . "&formAction=search&searchKey=" . urlencode($this->formArray["searchKey"]));
                         $this->tpl->set_var("pageListPaged", "");
                     }
                     $this->tpl->parse("PagesListBlock", "PagesList", true);
                 }
                 // drop down nav
                 for ($i = 1; $i <= $numOfPages; $i++) {
                     if ($i == $this->formArray["page"]) {
                         $this->tpl->set_var("pages", $i);
                         $this->tpl->set_var("pagesUrl", $i . "&formAction=search&searchKey=" . urlencode($this->formArray["searchKey"]));
                         $this->tpl->set_var("paged", "selected");
                     } else {
                         $this->tpl->set_var("pages", $i);
                         $this->tpl->set_var("pagesUrl", $i . "&formAction=search&searchKey=" . urlencode($this->formArray["searchKey"]));
                         $this->tpl->set_var("paged", "");
                     }
                     $this->tpl->parse("PagesBlock", "Pages", true);
                 }
             }
             if ($numOfPages == $this->formArray["page"]) {
                 $this->tpl->set_var("nextTxt", "");
             } else {
                 $this->tpl->set_var("next", $this->formArray["page"] + 1 . "&formAction=search&searchKey=" . urlencode($this->formArray["searchKey"]));
                 $this->tpl->set_var("nextTxt", "next");
             }
             if ($this->formArray["page"] == 1) {
                 $this->tpl->set_var("previousTxt", "");
             } else {
                 $this->tpl->set_var("previous", $this->formArray["page"] - 1 . "&formAction=search&searchKey=" . urlencode($this->formArray["searchKey"]));
                 $this->tpl->set_var("previousTxt", "previous");
             }
             $condition = $this->filterArchives();
             $condition .= $this->sortBlocks();
             $this->tpl->set_var("pageOf", $this->formArray["page"] . " of " . $numOfPages);
             if (!($xmlStr = $ODList->searchOD($this->formArray["page"], $this->formArray["searchKey"], $condition))) {
                 $this->tpl->set_var("pageOf", "");
                 $this->tpl->set_block("rptsTemplate", "ODTable", "ODTableBlock");
                 $this->tpl->set_var("ODTableBlock", "");
                 $this->tpl->set_block("rptsTemplate", "ODDBEmpty", "ODDBEmptyBlock");
                 $this->tpl->set_var("ODDBEmptyBlock", "");
                 $this->tpl->set_block("rptsTemplate", "Pages", "PagesBlock");
                 $this->tpl->set_var("PagesBlock", "");
                 $this->tpl->set_var("PagesListBlock", "");
                 $this->tpl->set_var("previousTxt", "");
                 $this->tpl->set_var("nextTxt", "");
             } else {
                 if (!($domDoc = domxml_open_mem($xmlStr))) {
                     $this->tpl->set_block("rptsTemplate", "ODListTable", "ODListTableBlock");
                     $this->tpl->set_var("ODListTableBlock", "error xmlDoc");
                 } else {
                     $this->tpl->set_block("rptsTemplate", "NotFound", "NotFoundBlock");
                     $this->tpl->set_var("NotFoundBlock", "");
                     $odRecords = new ODRecords();
                     $odRecords->parseDomDocument($domDoc);
                     $list = $odRecords->getArrayList();
                     if (count($list)) {
                         $this->tpl->set_block("rptsTemplate", "ODDBEmpty", "ODDBEmptyBlock");
                         $this->tpl->set_var("ODDBEmptyBlock", "");
                         $this->tpl->set_block("rptsTemplate", "ODList", "ODListBlock");
                         $this->tpl->set_block("ODList", "PersonList", "PersonListBlock");
                         $this->tpl->set_block("ODList", "CompanyList", "CompanyListBlock");
                         foreach ($list as $key => $value) {
                             $this->tpl->set_var("odID", $value->getOdID());
                             // added propertyType column : October 20, 2005:
                             $propertyType = $this->getPropertyTypeFromOD($value);
                             $this->tpl->set_var("propertyType", $propertyType);
                             $oValue = $value->owner;
                             $pOwnerStr = "";
                             if (count($oValue->personArray)) {
                                 foreach ($oValue->personArray as $pKey => $pValue) {
                                     $this->tpl->set_var("personID", $pValue->getPersonID());
                                     $this->tpl->set_var("OwnerPerson", $pValue->getFullName());
                                     $this->tpl->parse("PersonListBlock", "PersonList", true);
                                 }
                             }
                             if (count($oValue->companyArray)) {
                                 foreach ($oValue->companyArray as $cKey => $cValue) {
                                     $this->tpl->set_var("companyID", $cValue->getCompanyID());
                                     $this->tpl->set_var("OwnerCompany", $cValue->getCompanyName());
                                     $this->tpl->parse("CompanyListBlock", "CompanyList", true);
                                 }
                             }
                             if (count($oValue->personArray) || count($oValue->companyArray)) {
                                 $this->tpl->set_var("none", "");
                             } else {
                                 $this->tpl->set_var("none", "none");
                             }
                             //*/
                             //echo method_exists($value->location,getFullAddress);
                             $this->tpl->set_var("locationAddress", $value->locationAddress->getFullAddress());
                             $this->tpl->set_var("landArea", number_format($value->getLandArea(), 4, '.', ','));
                             //$this->tpl->set_var("landArea", formatCurrency1($value->getLandArea()));
                             $this->setODListBlockPerms();
                             $this->tpl->parse("ODListBlock", "ODList", true);
                             $this->tpl->set_var("PersonListBlock", "");
                             $this->tpl->set_var("CompanyListBlock", "");
                         }
                     } else {
                         $this->tpl->set_block("rptsTemplate", "ODList", "ODListBlock");
                         $this->tpl->set_var("ODListBlock", "huh");
                     }
                 }
             }
             break;
         case "cancel":
             header("location: ODList.php");
             exit;
             break;
         default:
             $this->tpl->set_var("msg", "");
             $ODList = new SoapObject(NCCBIZ . "ODList.php", "urn:Object");
             $this->tpl->set_block("rptsTemplate", "Pages", "PagesBlock");
             $this->tpl->set_block("rptsTemplate", "PagesList", "PagesListBlock");
             $this->tpl->set_block("rptsTemplate", "NotFound", "NotFoundBlock");
             $this->tpl->set_var("NotFoundBlock", "");
             $condition = $this->filterArchives();
             if (!($count = $ODList->getODCount($condition))) {
                 $this->tpl->set_var("PagesBlock", "");
                 $this->tpl->set_var("PagesListBlock", "");
                 $this->tpl->set_block("rptsTemplate", "PageNavigator", "PageNavigatorBlock");
                 $this->tpl->set_var("PageNavigatorBlock", "");
             } else {
                 $numOfPages = ceil($count / PAGE_BY);
                 // page list nav
                 $this->formArray["pageLinksInLine"] = 7;
                 if ($this->formArray["page"] < round($this->formArray["pageLinksInLine"] / 2)) {
                     $startPageLinks = 1;
                 } else {
                     $startPageLinks = $this->formArray["page"] - round($this->formArray["pageLinksInLine"] / 2);
                     if ($startPageLinks < 1) {
                         $startPageLinks = 1;
                     }
                 }
                 $endPageLinks = $startPageLinks + ($this->formArray["pageLinksInLine"] - 1);
                 if ($endPageLinks > $numOfPages) {
                     $endPageLinks = $numOfPages;
                 }
                 for ($i = $startPageLinks; $i <= $endPageLinks; $i++) {
                     if ($i == $this->formArray["page"]) {
                         $this->tpl->set_var("pageListPages", "");
                         $this->tpl->set_var("pageListPagesUrl", "");
                         $this->tpl->set_var("pageListPaged", $i);
                     } else {
                         $this->tpl->set_var("pageListPages", $i);
                         $this->tpl->set_var("pageListPagesUrl", $i);
                         $this->tpl->set_var("pageListPaged", "");
                     }
                     $this->tpl->parse("PagesListBlock", "PagesList", true);
                 }
                 // drop down nav
                 for ($i = 1; $i <= $numOfPages; $i++) {
                     if ($i == $this->formArray["page"]) {
                         $this->tpl->set_var("pages", $i);
                         $this->tpl->set_var("pagesUrl", $i);
                         $this->tpl->set_var("paged", "selected");
                     } else {
                         $this->tpl->set_var("pages", $i);
                         $this->tpl->set_var("pagesUrl", $i);
                         $this->tpl->set_var("paged", "");
                     }
                     $this->tpl->parse("PagesBlock", "Pages", true);
                 }
             }
             if ($numOfPages == $this->formArray["page"] || $numOfPages == "") {
                 $this->tpl->set_var("nextTxt", "");
             } else {
                 $this->tpl->set_var("next", $this->formArray["page"] + 1);
                 $this->tpl->set_var("nextTxt", "next");
             }
             if ($this->formArray["page"] == 1) {
                 $this->tpl->set_var("previousTxt", "");
             } else {
                 $this->tpl->set_var("previous", $this->formArray["page"] - 1);
                 $this->tpl->set_var("previousTxt", "previous");
             }
             if ($numOfPages == "") {
                 $this->tpl->set_var("pageOf", "");
             } else {
                 $this->tpl->set_var("pageOf", $this->formArray["page"] . " of " . $numOfPages);
             }
             $condition = $this->filterArchives();
             $condition .= $this->sortBlocks();
             if (!($xmlStr = $ODList->getODList($this->formArray["page"], $condition))) {
                 $this->tpl->set_block("rptsTemplate", "ODTable", "ODTableBlock");
                 $this->tpl->set_var("ODTableBlock", "");
             } else {
                 //echo $xmlStr;
                 if (!($domDoc = domxml_open_mem($xmlStr))) {
                     $this->tpl->set_block("rptsTemplate", "ODListTable", "ODListTableBlock");
                     $this->tpl->set_var("ODListTableBlock", "");
                 } else {
                     $odRecords = new ODRecords();
                     $odRecords->parseDomDocument($domDoc);
                     $list = $odRecords->getArrayList();
                     if (count($list)) {
                         $this->tpl->set_block("rptsTemplate", "ODDBEmpty", "ODDBEmptyBlock");
                         $this->tpl->set_var("ODDBEmptyBlock", "");
                         $this->tpl->set_block("rptsTemplate", "ODList", "ODListBlock");
                         $this->tpl->set_block("ODList", "PersonList", "PersonListBlock");
                         $this->tpl->set_block("ODList", "CompanyList", "CompanyListBlock");
                         foreach ($list as $key => $value) {
                             //print_r($value);
                             //echo "<br>";
                             $this->tpl->set_var("odID", $value->getOdID());
                             // added propertyType column : October 20, 2005:
                             $propertyType = $this->getPropertyTypeFromOD($value);
                             $this->tpl->set_var("propertyType", $propertyType);
                             $oValue = $value->owner;
                             $pOwnerStr = "";
                             if (count($oValue->personArray)) {
                                 foreach ($oValue->personArray as $pKey => $pValue) {
                                     $this->tpl->set_var("personID", $pValue->getPersonID());
                                     $this->tpl->set_var("OwnerPerson", $pValue->getFullName());
                                     $this->tpl->parse("PersonListBlock", "PersonList", true);
                                 }
                             }
                             if (count($oValue->companyArray)) {
                                 foreach ($oValue->companyArray as $cKey => $cValue) {
                                     $this->tpl->set_var("companyID", $cValue->getCompanyID());
                                     $this->tpl->set_var("OwnerCompany", $cValue->getCompanyName());
                                     $this->tpl->parse("CompanyListBlock", "CompanyList", true);
                                 }
                             }
                             if (count($oValue->personArray) || count($oValue->companyArray)) {
                                 $this->tpl->set_var("none", "");
                             } else {
                                 $this->tpl->set_var("none", "none");
                             }
                             //*/
                             //if (method_exists($value->locationAddress,$value->locationAddress->getFullAddress()))
                             if ($value->locationAddress != "") {
                                 $this->tpl->set_var("locationAddress", $value->locationAddress->getFullAddress());
                             }
                             $this->tpl->set_var("landArea", number_format($value->getLandArea(), 4, '.', ','));
                             //$this->tpl->set_var("landArea", formatCurrency1($value->getLandArea()));
                             $this->setODListBlockPerms();
                             $this->tpl->parse("ODListBlock", "ODList", true);
                             $this->tpl->set_var("PersonListBlock", "");
                             $this->tpl->set_var("CompanyListBlock", "");
                         }
                     } else {
                         $this->tpl->set_block("rptsTemplate", "ODList", "ODListBlock");
                         $this->tpl->set_var("ODListBlock", "huh");
                     }
                 }
             }
     }
     $this->initBarangayList();
     $this->setForm();
     $this->setPageDetailPerms();
     $this->tpl->set_var("uname", $this->user["uname"]);
     $this->tpl->set_var("today", date("F j, Y"));
     $this->tpl->set_var("Session", $this->sess->url(""));
     $this->tpl->parse("templatePage", "rptsTemplate");
     $this->tpl->finish("templatePage");
     $this->tpl->p("templatePage");
 }
Example #3
0
 function Main()
 {
     switch ($this->formArray["formAction"]) {
         case "search":
             $this->tpl->set_var("msg", "");
             $AFSList = new SoapObject(NCCBIZ . "AFSList.php", "urn:Object");
             $this->tpl->set_block("rptsTemplate", "Pages", "PagesBlock");
             $this->tpl->set_block("rptsTemplate", "PagesList", "PagesListBlock");
             $condition = $this->filterArchives();
             if (!($count = $AFSList->getSearchCount($this->formArray["searchKey"], $condition))) {
                 $this->tpl->set_var("PagesBlock", "");
                 $this->tpl->set_var("PagesListBlock", "");
                 $this->tpl->set_block("rptsTemplate", "PageNavigator", "PageNavigatorBlock");
                 $this->tpl->set_var("PageNavigatorBlock", "");
             } else {
                 $numOfPages = ceil($count / PAGE_BY);
                 // page list nav
                 $this->formArray["pageLinksInLine"] = 7;
                 if ($this->formArray["page"] < round($this->formArray["pageLinksInLine"] / 2)) {
                     $startPageLinks = 1;
                 } else {
                     $startPageLinks = $this->formArray["page"] - round($this->formArray["pageLinksInLine"] / 2);
                     if ($startPageLinks < 1) {
                         $startPageLinks = 1;
                     }
                 }
                 $endPageLinks = $startPageLinks + ($this->formArray["pageLinksInLine"] - 1);
                 if ($endPageLinks > $numOfPages) {
                     $endPageLinks = $numOfPages;
                 }
                 for ($i = $startPageLinks; $i <= $endPageLinks; $i++) {
                     if ($i == $this->formArray["page"]) {
                         $this->tpl->set_var("pageListPages", "");
                         $this->tpl->set_var("pageListPagesUrl", "");
                         $this->tpl->set_var("pageListPaged", $i);
                     } else {
                         $this->tpl->set_var("pageListPages", $i);
                         $this->tpl->set_var("pageListPagesUrl", $i . "&formAction=search&searchKey=" . urlencode($this->formArray["searchKey"]));
                         $this->tpl->set_var("pageListPaged", "");
                     }
                     $this->tpl->parse("PagesListBlock", "PagesList", true);
                 }
                 // drop down nav
                 for ($i = 1; $i <= $numOfPages; $i++) {
                     if ($i == $this->formArray["page"]) {
                         $this->tpl->set_var("pages", $i);
                         $this->tpl->set_var("pagesUrl", $i . "&formAction=search&searchKey=" . urlencode($this->formArray["searchKey"]));
                         $this->tpl->set_var("paged", "selected");
                     } else {
                         $this->tpl->set_var("pages", $i);
                         $this->tpl->set_var("pagesUrl", $i . "&formAction=search&searchKey=" . urlencode($this->formArray["searchKey"]));
                         $this->tpl->set_var("paged", "");
                     }
                     $this->tpl->parse("PagesBlock", "Pages", true);
                 }
             }
             if ($numOfPages == $this->formArray["page"]) {
                 $this->tpl->set_var("nextTxt", "");
             } else {
                 $this->tpl->set_var("next", $this->formArray["page"] + 1 . "&formAction=search&searchKey=" . urlencode($this->formArray["searchKey"]));
                 $this->tpl->set_var("nextTxt", "next");
             }
             if ($this->formArray["page"] == 1) {
                 $this->tpl->set_var("previousTxt", "");
             } else {
                 $this->tpl->set_var("previous", $this->formArray["page"] - 1 . "&formAction=search&searchKey=" . urlencode($this->formArray["searchKey"]));
                 $this->tpl->set_var("previousTxt", "previous");
             }
             $this->tpl->set_var("pageOf", $this->formArray["page"] . " of " . $numOfPages);
             $condition = $this->filterArchives();
             $condition .= $this->sortBlocks();
             if (!($xmlStr = $AFSList->searchAFS($this->formArray["page"], $this->formArray["searchKey"], $condition))) {
                 $this->tpl->set_var("pageOf", "");
                 $this->tpl->set_block("rptsTemplate", "AFSTable", "AFSTableBlock");
                 $this->tpl->set_var("AFSTableBlock", "");
                 $this->tpl->set_block("rptsTemplate", "AFSDBEmpty", "AFSDBEmptyBlock");
                 $this->tpl->set_var("AFSDBEmptyBlock", "");
                 $this->tpl->set_block("rptsTemplate", "Pages", "PagesBlock");
                 $this->tpl->set_var("PagesBlock", "");
                 $this->tpl->set_var("PagesListBlock", "");
                 $this->tpl->set_var("previousTxt", "");
                 $this->tpl->set_var("nextTxt", "");
             } else {
                 //echo $xmlStr;
                 if (!($domDoc = domxml_open_mem($xmlStr))) {
                     $this->tpl->set_block("rptsTemplate", "AFSListTable", "AFSListTableBlock");
                     $this->tpl->set_var("AFSListTableBlock", "error xmlDoc");
                 } else {
                     $this->tpl->set_block("rptsTemplate", "NotFound", "NotFoundBlock");
                     $this->tpl->set_var("NotFoundBlock", "");
                     $odRecords = new ODRecords();
                     $odRecords->parseDomDocument($domDoc);
                     $list = $odRecords->getArrayList();
                     if (count($list)) {
                         $this->tpl->set_block("rptsTemplate", "AFSDBEmpty", "AFSDBEmptyBlock");
                         $this->tpl->set_var("AFSDBEmptyBlock", "");
                         $this->tpl->set_block("rptsTemplate", "AFSList", "AFSListBlock");
                         $this->tpl->set_block("AFSList", "PersonList", "PersonListBlock");
                         $this->tpl->set_block("AFSList", "CompanyList", "CompanyListBlock");
                         //echo hello;
                         foreach ($list as $key => $value) {
                             $AFSEncode = new SoapObject(NCCBIZ . "AFSEncode.php", "urn:Object");
                             $this->afsID = $AFSEncode->getAFSID($value->getOdID());
                             if (!($xmlStr = $AFSEncode->getAFSForList($this->afsID))) {
                                 echo "error domdoc";
                             } else {
                                 //echo $xmlStr."<br><br><br>";
                                 if (!($domDoc = domxml_open_mem($xmlStr))) {
                                     echo "hello";
                                     $this->tpl->set_var("totalMarketValue", "");
                                     $this->tpl->set_var("totalAssessedValue", "");
                                     //$this->tpl->set_block("rptsTemplate", "AFSListTable", "AFSListTableBlock");
                                     //$this->tpl->set_var("AFSListTableBlock", "error xmlDoc");
                                 } else {
                                     $afs = new AFS();
                                     $afs->parseDomDocument($domDoc);
                                     $this->tpl->set_var("totalMarketValue", number_format($afs->getTotalMarketValue(), 2, '.', ','));
                                     $this->tpl->set_var("totalAssessedValue", number_format($afs->getTotalAssessedValue(), 2, '.', ','));
                                 }
                             }
                             $this->tpl->set_var("odID", $value->getOdID());
                             $this->tpl->set_var("afsID", $this->afsID);
                             $oValue = $value->owner;
                             $this->tpl->set_var("ownerID", $oValue->getOwnerID());
                             $pOwnerStr = "";
                             if (count($oValue->personArray)) {
                                 foreach ($oValue->personArray as $pKey => $pValue) {
                                     $this->tpl->set_var("personID", $pValue->getPersonID());
                                     $this->tpl->set_var("OwnerPerson", $pValue->getFullName());
                                     $this->tpl->parse("PersonListBlock", "PersonList", true);
                                 }
                             }
                             if (count($oValue->companyArray)) {
                                 foreach ($oValue->companyArray as $cKey => $cValue) {
                                     $this->tpl->set_var("companyID", $cValue->getCompanyID());
                                     $this->tpl->set_var("OwnerCompany", $cValue->getCompanyName());
                                     $this->tpl->parse("CompanyListBlock", "CompanyList", true);
                                 }
                             }
                             if (count($oValue->personArray) || count($oValue->companyArray)) {
                                 $this->tpl->set_var("none", "");
                             } else {
                                 $this->tpl->set_var("none", "none");
                             }
                             //*/
                             //echo method_exists($value->location,getFullAddress);
                             $this->tpl->set_var("locationAddress", $value->locationAddress->getFullAddress());
                             $this->tpl->set_var("landArea", $value->getLandArea());
                             $this->setAFSListBlockPerms();
                             $this->tpl->parse("AFSListBlock", "AFSList", true);
                             $this->tpl->set_var("PersonListBlock", "");
                             $this->tpl->set_var("CompanyListBlock", "");
                         }
                     } else {
                         $this->tpl->set_block("rptsTemplate", "AFSList", "AFSListBlock");
                         $this->tpl->set_var("AFSListBlock", "huh");
                     }
                 }
             }
             break;
         default:
             $this->tpl->set_var("msg", "");
             $AFSList = new SoapObject(NCCBIZ . "AFSList.php", "urn:Object");
             $this->tpl->set_block("rptsTemplate", "Pages", "PagesBlock");
             $this->tpl->set_block("rptsTemplate", "PagesList", "PagesListBlock");
             $this->tpl->set_block("rptsTemplate", "NotFound", "NotFoundBlock");
             $this->tpl->set_var("NotFoundBlock", "");
             $condition = $this->filterArchives();
             if (!($count = $AFSList->getAFSCount($condition))) {
                 $this->tpl->set_var("PagesBlock", "");
                 $this->tpl->set_var("PagesListBlock", "");
                 $this->tpl->set_block("rptsTemplate", "PageNavigator", "PageNavigatorBlock");
                 $this->tpl->set_var("PageNavigatorBlock", "");
             } else {
                 $numOfPages = ceil($count / PAGE_BY);
                 // page list nav
                 $this->formArray["pageLinksInLine"] = 7;
                 if ($this->formArray["page"] < round($this->formArray["pageLinksInLine"] / 2)) {
                     $startPageLinks = 1;
                 } else {
                     $startPageLinks = $this->formArray["page"] - round($this->formArray["pageLinksInLine"] / 2);
                     if ($startPageLinks < 1) {
                         $startPageLinks = 1;
                     }
                 }
                 $endPageLinks = $startPageLinks + ($this->formArray["pageLinksInLine"] - 1);
                 if ($endPageLinks > $numOfPages) {
                     $endPageLinks = $numOfPages;
                 }
                 for ($i = $startPageLinks; $i <= $endPageLinks; $i++) {
                     if ($i == $this->formArray["page"]) {
                         $this->tpl->set_var("pageListPages", "");
                         $this->tpl->set_var("pageListPagesUrl", "");
                         $this->tpl->set_var("pageListPaged", $i);
                     } else {
                         $this->tpl->set_var("pageListPages", $i);
                         $this->tpl->set_var("pageListPagesUrl", $i);
                         $this->tpl->set_var("pageListPaged", "");
                     }
                     $this->tpl->parse("PagesListBlock", "PagesList", true);
                 }
                 // drop down nav
                 for ($i = 1; $i <= $numOfPages; $i++) {
                     if ($i == $this->formArray["page"]) {
                         $this->tpl->set_var("pages", $i);
                         $this->tpl->set_var("pagesUrl", $i);
                         $this->tpl->set_var("paged", "selected");
                     } else {
                         $this->tpl->set_var("pages", $i);
                         $this->tpl->set_var("pagesUrl", $i);
                         $this->tpl->set_var("paged", "");
                     }
                     $this->tpl->parse("PagesBlock", "Pages", true);
                 }
             }
             if ($numOfPages == $this->formArray["page"]) {
                 $this->tpl->set_var("nextTxt", "");
             } else {
                 $this->tpl->set_var("next", $this->formArray["page"] + 1);
                 $this->tpl->set_var("nextTxt", "next");
             }
             if ($this->formArray["page"] == 1) {
                 $this->tpl->set_var("previousTxt", "");
             } else {
                 $this->tpl->set_var("previous", $this->formArray["page"] - 1);
                 $this->tpl->set_var("previousTxt", "previous");
             }
             if ($numOfPages == "") {
                 $this->tpl->set_var("pageOf", "");
             } else {
                 $this->tpl->set_var("pageOf", $this->formArray["page"] . " of " . $numOfPages);
             }
             $condition = $this->filterArchives();
             $condition .= $this->sortBlocks();
             if (!($xmlStr = $AFSList->getAFSList($this->formArray["page"], $condition))) {
                 $this->tpl->set_block("rptsTemplate", "AFSTable", "AFSTableBlock");
                 $this->tpl->set_var("AFSTableBlock", "");
             } else {
                 if (!($domDoc = domxml_open_mem($xmlStr))) {
                     $this->tpl->set_block("rptsTemplate", "AFSTable", "AFSTableBlock");
                     $this->tpl->set_var("AFSTableBlock", "");
                 } else {
                     $odRecords = new ODRecords();
                     $odRecords->parseDomDocument($domDoc);
                     $list = $odRecords->getArrayList();
                     if (count($list)) {
                         $this->tpl->set_block("rptsTemplate", "AFSDBEmpty", "AFSDBEmptyBlock");
                         $this->tpl->set_var("AFSDBEmptyBlock", "");
                         $this->tpl->set_block("rptsTemplate", "AFSList", "AFSListBlock");
                         $this->tpl->set_block("AFSList", "PersonList", "PersonListBlock");
                         $this->tpl->set_block("AFSList", "CompanyList", "CompanyListBlock");
                         foreach ($list as $key => $value) {
                             $AFSEncode = new SoapObject(NCCBIZ . "AFSEncode.php", "urn:Object");
                             $this->afsID = $AFSEncode->getAFSID($value->getOdID());
                             if (!($xmlStr = $AFSEncode->getAFSForList($this->afsID))) {
                                 echo "error domdoc";
                             } else {
                                 if (!($domDoc = domxml_open_mem($xmlStr))) {
                                     $this->tpl->set_var("totalMarketValue", "");
                                     $this->tpl->set_var("totalAssessedValue", "");
                                     //$this->tpl->set_block("rptsTemplate", "AFSListTable", "AFSListTableBlock");
                                     //$this->tpl->set_var("AFSListTableBlock", "error xmlDoc");
                                 } else {
                                     $afs = new AFS();
                                     $afs->parseDomDocument($domDoc);
                                     $this->tpl->set_var("totalMarketValue", number_format($afs->getTotalMarketValue(), 2, '.', ','));
                                     $this->tpl->set_var("totalAssessedValue", number_format($afs->getTotalAssessedValue(), 2, '.', ','));
                                 }
                             }
                             $this->tpl->set_var("odID", $value->getOdID());
                             $this->tpl->set_var("afsID", $this->afsID);
                             $oValue = $value->owner;
                             $this->tpl->set_var("ownerID", $oValue->getOwnerID());
                             $pOwnerStr = "";
                             if (count($oValue->personArray)) {
                                 foreach ($oValue->personArray as $pKey => $pValue) {
                                     $this->tpl->set_var("personID", $pValue->getPersonID());
                                     $this->tpl->set_var("OwnerPerson", $pValue->getFullName());
                                     $this->tpl->parse("PersonListBlock", "PersonList", true);
                                 }
                             }
                             if (count($oValue->companyArray)) {
                                 foreach ($oValue->companyArray as $cKey => $cValue) {
                                     $this->tpl->set_var("companyID", $cValue->getCompanyID());
                                     $this->tpl->set_var("OwnerCompany", $cValue->getCompanyName());
                                     $this->tpl->parse("CompanyListBlock", "CompanyList", true);
                                 }
                             }
                             if (count($oValue->personArray) || count($oValue->companyArray)) {
                                 $this->tpl->set_var("none", "");
                             } else {
                                 $this->tpl->set_var("none", "none");
                             }
                             //*/
                             //echo method_exists($value->location,getFullAddress);
                             $this->tpl->set_var("locationAddress", $value->locationAddress->getFullAddress());
                             $this->tpl->set_var("landArea", $value->getLandArea());
                             $this->setAFSListBlockPerms();
                             $this->tpl->parse("AFSListBlock", "AFSList", true);
                             $this->tpl->set_var("PersonListBlock", "");
                             $this->tpl->set_var("CompanyListBlock", "");
                         }
                     } else {
                         $this->tpl->set_block("rptsTemplate", "AFSList", "AFSListBlock");
                         $this->tpl->set_var("AFSListBlock", "huh");
                     }
                 }
             }
     }
     $this->setForm();
     $this->setPageDetailPerms();
     $this->tpl->set_var("uname", $this->user["uname"]);
     $this->tpl->set_var("today", date("F j, Y"));
     $this->tpl->set_var("Session", $this->sess->url(""));
     $this->tpl->parse("templatePage", "rptsTemplate");
     $this->tpl->finish("templatePage");
     $this->tpl->p("templatePage");
 }
 function Main()
 {
     switch ($this->formArray["formAction"]) {
         case "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->tpl->set_var("assessedValue", number_format($afs->getTotalAssessedValue(), 2, '.', ','));
                             $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->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 = $this->filterArchives();
             $odRecords = new ODRecords();
             if ($odIDArray = $this->selectODRecords($condition)) {
                 $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", "");
             }
             if (!is_array($odRecords->arrayList)) {
                 $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();
                 $noneFound = true;
                 if (count($list)) {
                     $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("effectivity", $afs->getEffectivity());
                             $this->tpl->set_var("propertyIndexNumber", $afs->getPropertyIndexNumber());
                             $landList = $afs->getLandArray();
                             $plantsTreesList = $afs->getPlantsTreesArray();
                             $machineriesList = $afs->getMachineriesArray();
                             $kind = "";
                             $class = "";
                             $remarks = "";
                             $actualUse = "";
                             $actualUseReportCode = "";
                             if (!is_array($improvementsBuildingsList)) {
                                 $this->tpl->set_var("marketValue", number_format($afs->getTotalMarketValue()));
                             } else {
                                 $kind = "Improvements/Buildings";
                                 $improvementsBuildings = $improvementsBuildingsList[0];
                                 $actualUse = $improvementsBuildings->getActualUse();
                                 $improvementsBuildingsActualUses = new ImprovementsBuildingsActualUses();
                                 $improvementsBuildingsActualUses->selectRecord($actualUse);
                                 $actualUse = $improvementsBuildingsActualUses->getDescription();
                                 $actualUseReportCode = $improvementsBuildingsActualUses->getReportCode();
                                 $remarks = $improvementsBuildings->getMemoranda();
                                 $marketValue = 0;
                                 foreach ($improvementsBuildingsList as $impBldg) {
                                     $marketValue += $impBldg->getAdjustedMarketValue();
                                 }
                                 $this->tpl->set_var("marketValue", number_format($marketValue));
                             }
                             $this->tpl->set_var("kind", $kind);
                             $this->tpl->set_var("actualUse", $actualUse);
                             $this->tpl->set_var("actualUseReportCode", $actualUseReportCode);
                             $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", "");
                         }
                         if (is_array($oValue->personArray)) {
                             foreach ($oValue->personArray as $person) {
                                 $ownersArrayList[] = $person->getFullName();
                             }
                         }
                         if (is_array($oValue->companyArray)) {
                             foreach ($oValue->companyArray as $company) {
                                 $ownersArrayList[] = $company->getCompanyName();
                             }
                         }
                         if (is_array($ownersArrayList)) {
                             $this->tpl->set_var("ownerNames", implode(",<br>", $ownersArrayList));
                         } else {
                             $this->tpl->set_var("ownerNames", "");
                         }
                         unset($ownersArrayList);
                         $locationAddress = $value->locationAddress->getFullAddress();
                         $this->tpl->set_var("location", $locationAddress);
                         $noneFound = false;
                         $this->tpl->parse("ReportListBlock", "ReportList", true);
                     }
                 }
                 if ($noneFound == true) {
                     $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 {
                     $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");
 }
Example #6
0
 function Main()
 {
     $this->mergeBasketMain();
     switch ($this->formArray["formAction"]) {
         case "delete":
             //print_r($this->formArray);
             if (count($this->formArray["odID"]) > 0) {
                 $ODList = new SoapObject(NCCBIZ . "ODList.php", "urn:Object");
                 if (!($deletedRows = $ODList->deleteOD($this->formArray["odID"]))) {
                     $this->tpl->set_var("msg", "SOAP failed");
                 } else {
                     $this->tpl->set_var("msg", $deletedRows . " records deleted");
                 }
             } else {
                 $this->tpl->set_var("msg", "0 records deleted");
             }
             break;
         case "consolidate":
             $odIDArray = $this->formArray["mergeBasketArray"];
             $RPUEncode = new SoapObject(NCCBIZ . "RPUEncode.php", "urn:Object");
             $newOdID = $RPUEncode->ConsolidateRPU($odIDArray, $this->formArray["transactionCode"]);
             $ODList = new SoapObject(NCCBIZ . "ODList.php", "urn:Object");
             $archiveValue = "true";
             $userID = $this->formArray["uid"];
             if (!($archiveRows = $ODList->archiveOD($odIDArray, $archiveValue, $userID))) {
                 // archive failed
             } else {
                 // archive succeeded
             }
             $sess = $this->sess->name . "=" . $this->sess->id;
             header("Location: ODDetails.php?" . $sess . "&odID=" . $newOdID);
             exit;
             break;
         case "archive":
             $ODList = new SoapObject(NCCBIZ . "ODList.php", "urn:Object");
             $odIDArray = $this->formArray["odIDArray"];
             $archiveValue = $this->formArray["archiveValue"];
             $userID = $this->formArray["uid"];
             if (!($archiveRows = $ODList->archiveOD($odIDArray, $archiveValue, $userID))) {
                 $this->tpl->set_var("msg", "SOAP failed");
             } else {
                 $sess = $this->sess->name . "=" . $this->sess->id;
                 header("Location: ODList.php?" . $sess . "&viewArchives=" . $this->formArray["viewArchives"]);
                 exit;
             }
             break;
         case "filterBarangay":
             $ODList = new SoapObject(NCCBIZ . "ODList.php", "urn:Object");
             $this->tpl->set_block("rptsTemplate", "Pages", "PagesBlock");
             $this->tpl->set_block("rptsTemplate", "PagesList", "PagesListBlock");
             $condition = $this->filterArchives();
             if (!($count = $ODList->filterByBarangayCount($this->formArray["barangay"], $condition))) {
                 $this->tpl->set_var("PagesBlock", "");
                 $this->tpl->set_var("PagesListBlock", "");
                 $this->tpl->set_block("rptsTemplate", "PageNavigator", "PageNavigatorBlock");
                 $this->tpl->set_var("PageNavigatorBlock", "");
                 $numOfPages = 1;
             } else {
                 $numOfPages = ceil($count / PAGE_BY);
                 // page list nav
                 $this->formArray["pageLinksInLine"] = 7;
                 if ($this->formArray["page"] < round($this->formArray["pageLinksInLine"] / 2)) {
                     $startPageLinks = 1;
                 } else {
                     $startPageLinks = $this->formArray["page"] - round($this->formArray["pageLinksInLine"] / 2);
                     if ($startPageLinks < 1) {
                         $startPageLinks = 1;
                     }
                 }
                 $endPageLinks = $startPageLinks + ($this->formArray["pageLinksInLine"] - 1);
                 if ($endPageLinks > $numOfPages) {
                     $endPageLinks = $numOfPages;
                 }
                 for ($i = $startPageLinks; $i <= $endPageLinks; $i++) {
                     if ($i == $this->formArray["page"]) {
                         $this->tpl->set_var("pageListPages", "");
                         $this->tpl->set_var("pageListPagesUrl", "");
                         $this->tpl->set_var("pageListPaged", $i);
                     } else {
                         $this->tpl->set_var("pageListPages", $i);
                         $this->tpl->set_var("pageListPagesUrl", $i . "&formAction=filterBarangay&barangay=" . urlencode($this->formArray["barangay"]));
                         $this->tpl->set_var("pageListPaged", "");
                     }
                     $this->tpl->parse("PagesListBlock", "PagesList", true);
                 }
                 // drop down nav
                 for ($i = 1; $i <= $numOfPages; $i++) {
                     if ($i == $this->formArray["page"]) {
                         $this->tpl->set_var("pages", $i);
                         $this->tpl->set_var("pagesUrl", $i . "&formAction=filterBarangay&barangay=" . urlencode($this->formArray["barangay"]));
                         $this->tpl->set_var("paged", "selected");
                     } else {
                         $this->tpl->set_var("pages", $i);
                         $this->tpl->set_var("pagesUrl", $i . "&formAction=filterBarangay&barangay=" . urlencode($this->formArray["barangay"]));
                         $this->tpl->set_var("paged", "");
                     }
                     $this->tpl->parse("PagesBlock", "Pages", true);
                 }
             }
             if ($numOfPages == $this->formArray["page"]) {
                 $this->tpl->set_var("nextTxt", "");
             } else {
                 $this->tpl->set_var("next", $this->formArray["page"] + 1 . "&formAction=filterBarangay&barangay=" . urlencode($this->formArray["barangay"]));
                 $this->tpl->set_var("nextTxt", "next");
             }
             if ($this->formArray["page"] == 1) {
                 $this->tpl->set_var("previousTxt", "");
             } else {
                 $this->tpl->set_var("previous", $this->formArray["page"] - 1 . "&formAction=filterBarangay&barangay=" . urlencode($this->formArray["barangay"]));
                 $this->tpl->set_var("previousTxt", "previous");
             }
             $condition = $this->filterArchives();
             $condition .= $this->sortBlocks();
             $this->tpl->set_var("pageOf", $this->formArray["page"] . " of " . $numOfPages);
             if (!($xmlStr = $ODList->filterByBarangay($this->formArray["page"], $this->formArray["barangay"], $condition))) {
                 $this->tpl->set_var("pageOf", "");
                 $this->tpl->set_block("rptsTemplate", "ODTable", "ODTableBlock");
                 $this->tpl->set_var("ODTableBlock", "");
                 $this->tpl->set_block("rptsTemplate", "ODDBEmpty", "ODDBEmptyBlock");
                 $this->tpl->set_var("ODDBEmptyBlock", "");
                 $this->tpl->set_block("rptsTemplate", "Pages", "PagesBlock");
                 $this->tpl->set_var("PagesBlock", "");
                 $this->tpl->set_var("PagesListBlock", "");
                 $this->tpl->set_var("previousTxt", "");
                 $this->tpl->set_var("nextTxt", "");
             } else {
                 if (!($domDoc = domxml_open_mem($xmlStr))) {
                     $this->tpl->set_block("rptsTemplate", "ODListTable", "ODListTableBlock");
                     $this->tpl->set_var("ODListTableBlock", "error xmlDoc");
                 } else {
                     $this->tpl->set_block("rptsTemplate", "NotFound", "NotFoundBlock");
                     $this->tpl->set_var("NotFoundBlock", "");
                     $odRecords = new ODRecords();
                     $odRecords->parseDomDocument($domDoc);
                     $list = $odRecords->getArrayList();
                     if (count($list)) {
                         $this->tpl->set_block("rptsTemplate", "ODDBEmpty", "ODDBEmptyBlock");
                         $this->tpl->set_var("ODDBEmptyBlock", "");
                         $this->tpl->set_block("rptsTemplate", "ODList", "ODListBlock");
                         $this->tpl->set_block("ODList", "PersonList", "PersonListBlock");
                         $this->tpl->set_block("ODList", "CompanyList", "CompanyListBlock");
                         foreach ($list as $key => $value) {
                             $this->tpl->set_var("odID", $value->getOdID());
                             $propertyType = $this->getPropertyTypeFromOD($value);
                             if ($propertyType != "Land") {
                                 $this->tpl->set_var("checkbox_status", "disabled");
                                 $this->tpl->set_var("checkbox_style", "style='display:none;'");
                             } else {
                                 $this->tpl->set_var("checkbox_status", "");
                                 $this->tpl->set_var("checkbox_style", "");
                                 if (is_array($this->formArray["mergeBasketArray"])) {
                                     if (in_array($value->getOdID(), $this->formArray["mergeBasketArray"])) {
                                         $this->tpl->set_var("checkbox_status", "checked disabled");
                                     }
                                 }
                             }
                             switch ($propertyType) {
                                 case "Land":
                                     $this->tpl->set_var("propertyType", "L/P");
                                     break;
                                 case "ImprovementsBuildings":
                                     $this->tpl->set_var("propertyType", "I/B");
                                     break;
                                 case "Machineries":
                                     $this->tpl->set_var("propertyType", "M");
                                     break;
                                 default:
                                     $this->tpl->set_var("propertyType", "-");
                                     break;
                             }
                             $oValue = $value->owner;
                             $pOwnerStr = "";
                             if (count($oValue->personArray)) {
                                 foreach ($oValue->personArray as $pKey => $pValue) {
                                     $this->tpl->set_var("personID", $pValue->getPersonID());
                                     $this->tpl->set_var("OwnerPerson", $pValue->getFullName());
                                     $this->tpl->parse("PersonListBlock", "PersonList", true);
                                 }
                             }
                             if (count($oValue->companyArray)) {
                                 foreach ($oValue->companyArray as $cKey => $cValue) {
                                     $this->tpl->set_var("companyID", $cValue->getCompanyID());
                                     $this->tpl->set_var("OwnerCompany", $cValue->getCompanyName());
                                     $this->tpl->parse("CompanyListBlock", "CompanyList", true);
                                 }
                             }
                             if (count($oValue->personArray) || count($oValue->companyArray)) {
                                 $this->tpl->set_var("none", "");
                             } else {
                                 $this->tpl->set_var("none", "none");
                             }
                             //*/
                             //echo method_exists($value->location,getFullAddress);
                             $this->tpl->set_var("locationAddress", $value->locationAddress->getFullAddress());
                             $this->tpl->set_var("landArea", number_format($value->getLandArea(), 2, '.', ','));
                             $this->tpl->parse("ODListBlock", "ODList", true);
                             $this->tpl->set_var("PersonListBlock", "");
                             $this->tpl->set_var("CompanyListBlock", "");
                         }
                     } else {
                         $this->tpl->set_block("rptsTemplate", "ODList", "ODListBlock");
                         $this->tpl->set_var("ODListBlock", "huh");
                     }
                 }
             }
             break;
         case "search":
             $ODList = new SoapObject(NCCBIZ . "ODList.php", "urn:Object");
             $this->tpl->set_block("rptsTemplate", "Pages", "PagesBlock");
             $this->tpl->set_block("rptsTemplate", "PagesList", "PagesListBlock");
             $condition = $this->filterArchives();
             if (!($count = $ODList->getSearchCount($this->formArray["searchKey"], $condition))) {
                 $this->tpl->set_var("PagesBlock", "");
                 $this->tpl->set_var("PagesListBlock", "");
                 $this->tpl->set_block("rptsTemplate", "PageNavigator", "PageNavigatorBlock");
                 $this->tpl->set_var("PageNavigatorBlock", "");
                 $numOfPages = 1;
             } else {
                 $numOfPages = ceil($count / PAGE_BY);
                 // page list nav
                 $this->formArray["pageLinksInLine"] = 7;
                 if ($this->formArray["page"] < round($this->formArray["pageLinksInLine"] / 2)) {
                     $startPageLinks = 1;
                 } else {
                     $startPageLinks = $this->formArray["page"] - round($this->formArray["pageLinksInLine"] / 2);
                     if ($startPageLinks < 1) {
                         $startPageLinks = 1;
                     }
                 }
                 $endPageLinks = $startPageLinks + ($this->formArray["pageLinksInLine"] - 1);
                 if ($endPageLinks > $numOfPages) {
                     $endPageLinks = $numOfPages;
                 }
                 for ($i = $startPageLinks; $i <= $endPageLinks; $i++) {
                     if ($i == $this->formArray["page"]) {
                         $this->tpl->set_var("pageListPages", "");
                         $this->tpl->set_var("pageListPagesUrl", "");
                         $this->tpl->set_var("pageListPaged", $i);
                     } else {
                         $this->tpl->set_var("pageListPages", $i);
                         $this->tpl->set_var("pageListPagesUrl", $i . "&formAction=search&searchKey=" . urlencode($this->formArray["searchKey"]));
                         $this->tpl->set_var("pageListPaged", "");
                     }
                     $this->tpl->parse("PagesListBlock", "PagesList", true);
                 }
                 // drop down nav
                 for ($i = 1; $i <= $numOfPages; $i++) {
                     if ($i == $this->formArray["page"]) {
                         $this->tpl->set_var("pages", $i);
                         $this->tpl->set_var("pagesUrl", $i . "&formAction=search&searchKey=" . urlencode($this->formArray["searchKey"]));
                         $this->tpl->set_var("paged", "selected");
                     } else {
                         $this->tpl->set_var("pages", $i);
                         $this->tpl->set_var("pagesUrl", $i . "&formAction=search&searchKey=" . urlencode($this->formArray["searchKey"]));
                         $this->tpl->set_var("paged", "");
                     }
                     $this->tpl->parse("PagesBlock", "Pages", true);
                 }
             }
             if ($numOfPages == $this->formArray["page"]) {
                 $this->tpl->set_var("nextTxt", "");
             } else {
                 $this->tpl->set_var("next", $this->formArray["page"] + 1 . "&formAction=search&searchKey=" . urlencode($this->formArray["searchKey"]));
                 $this->tpl->set_var("nextTxt", "next");
             }
             if ($this->formArray["page"] == 1) {
                 $this->tpl->set_var("previousTxt", "");
             } else {
                 $this->tpl->set_var("previous", $this->formArray["page"] - 1 . "&formAction=search&searchKey=" . urlencode($this->formArray["searchKey"]));
                 $this->tpl->set_var("previousTxt", "previous");
             }
             $condition = $this->filterArchives();
             $condition .= $this->sortBlocks();
             $this->tpl->set_var("pageOf", $this->formArray["page"] . " of " . $numOfPages);
             if (!($xmlStr = $ODList->searchOD($this->formArray["page"], $this->formArray["searchKey"], $condition))) {
                 $this->tpl->set_var("pageOf", "");
                 $this->tpl->set_block("rptsTemplate", "ODTable", "ODTableBlock");
                 $this->tpl->set_var("ODTableBlock", "");
                 $this->tpl->set_block("rptsTemplate", "ODDBEmpty", "ODDBEmptyBlock");
                 $this->tpl->set_var("ODDBEmptyBlock", "");
                 $this->tpl->set_block("rptsTemplate", "Pages", "PagesBlock");
                 $this->tpl->set_var("PagesBlock", "");
                 $this->tpl->set_var("PagesListBlock", "");
                 $this->tpl->set_var("previousTxt", "");
                 $this->tpl->set_var("nextTxt", "");
                 $this->tpl->set_block("rptsTemplate", "ArchiveButton", "ArchiveButtonBlock");
                 $this->tpl->set_var("ArchiveButtonBlock", "");
                 $this->tpl->set_block("rptsTemplate", "UnArchiveButton", "UnArchiveButtonBlock");
                 $this->tpl->set_var("UnArchiveButtonBlock", "");
             } else {
                 if (!($domDoc = domxml_open_mem($xmlStr))) {
                     $this->tpl->set_block("rptsTemplate", "ODListTable", "ODListTableBlock");
                     $this->tpl->set_var("ODListTableBlock", "error xmlDoc");
                 } else {
                     $this->tpl->set_block("rptsTemplate", "NotFound", "NotFoundBlock");
                     $this->tpl->set_var("NotFoundBlock", "");
                     $odRecords = new ODRecords();
                     $odRecords->parseDomDocument($domDoc);
                     $list = $odRecords->getArrayList();
                     if (count($list)) {
                         $this->tpl->set_block("rptsTemplate", "ODDBEmpty", "ODDBEmptyBlock");
                         $this->tpl->set_var("ODDBEmptyBlock", "");
                         $this->tpl->set_block("rptsTemplate", "ODList", "ODListBlock");
                         $this->tpl->set_block("ODList", "PersonList", "PersonListBlock");
                         $this->tpl->set_block("ODList", "CompanyList", "CompanyListBlock");
                         foreach ($list as $key => $value) {
                             $this->tpl->set_var("odID", $value->getOdID());
                             $propertyType = $this->getPropertyTypeFromOD($value);
                             if ($propertyType != "Land") {
                                 $this->tpl->set_var("checkbox_status", "disabled");
                                 $this->tpl->set_var("checkbox_style", "style='display:none;'");
                             } else {
                                 $this->tpl->set_var("checkbox_status", "");
                                 $this->tpl->set_var("checkbox_style", "");
                                 if (is_array($this->formArray["mergeBasketArray"])) {
                                     if (in_array($value->getOdID(), $this->formArray["mergeBasketArray"])) {
                                         $this->tpl->set_var("checkbox_status", "checked disabled");
                                     }
                                 }
                             }
                             switch ($propertyType) {
                                 case "Land":
                                     $this->tpl->set_var("propertyType", "L/P");
                                     break;
                                 case "ImprovementsBuildings":
                                     $this->tpl->set_var("propertyType", "I/B");
                                     break;
                                 case "Machineries":
                                     $this->tpl->set_var("propertyType", "M");
                                     break;
                                 default:
                                     $this->tpl->set_var("propertyType", "-");
                                     break;
                             }
                             $oValue = $value->owner;
                             $pOwnerStr = "";
                             if (count($oValue->personArray)) {
                                 foreach ($oValue->personArray as $pKey => $pValue) {
                                     $this->tpl->set_var("personID", $pValue->getPersonID());
                                     $this->tpl->set_var("OwnerPerson", $pValue->getFullName());
                                     $this->tpl->parse("PersonListBlock", "PersonList", true);
                                 }
                             }
                             if (count($oValue->companyArray)) {
                                 foreach ($oValue->companyArray as $cKey => $cValue) {
                                     $this->tpl->set_var("companyID", $cValue->getCompanyID());
                                     $this->tpl->set_var("OwnerCompany", $cValue->getCompanyName());
                                     $this->tpl->parse("CompanyListBlock", "CompanyList", true);
                                 }
                             }
                             if (count($oValue->personArray) || count($oValue->companyArray)) {
                                 $this->tpl->set_var("none", "");
                             } else {
                                 $this->tpl->set_var("none", "none");
                             }
                             //*/
                             //echo method_exists($value->location,getFullAddress);
                             $this->tpl->set_var("locationAddress", $value->locationAddress->getFullAddress());
                             $this->tpl->set_var("landArea", number_format($value->getLandArea(), 2, '.', ','));
                             $this->tpl->parse("ODListBlock", "ODList", true);
                             $this->tpl->set_var("PersonListBlock", "");
                             $this->tpl->set_var("CompanyListBlock", "");
                         }
                     } else {
                         $this->tpl->set_block("rptsTemplate", "ODList", "ODListBlock");
                         $this->tpl->set_var("ODListBlock", "huh");
                     }
                 }
             }
             break;
         case "cancel":
             header("location: ODList.php");
             exit;
             break;
         default:
             $this->tpl->set_var("msg", "");
             $ODList = new SoapObject(NCCBIZ . "ODList.php", "urn:Object");
             $this->tpl->set_block("rptsTemplate", "Pages", "PagesBlock");
             $this->tpl->set_block("rptsTemplate", "PagesList", "PagesListBlock");
             $this->tpl->set_block("rptsTemplate", "NotFound", "NotFoundBlock");
             $this->tpl->set_var("NotFoundBlock", "");
             $condition = $this->filterArchives();
             if (!($count = $ODList->getODCount($condition))) {
                 $this->tpl->set_var("PagesBlock", "");
                 $this->tpl->set_var("PagesListBlock", "");
                 $this->tpl->set_block("rptsTemplate", "PageNavigator", "PageNavigatorBlock");
                 $this->tpl->set_var("PageNavigatorBlock", "");
             } else {
                 $numOfPages = ceil($count / PAGE_BY);
                 // page list nav
                 $this->formArray["pageLinksInLine"] = 7;
                 if ($this->formArray["page"] < round($this->formArray["pageLinksInLine"] / 2)) {
                     $startPageLinks = 1;
                 } else {
                     $startPageLinks = $this->formArray["page"] - round($this->formArray["pageLinksInLine"] / 2);
                     if ($startPageLinks < 1) {
                         $startPageLinks = 1;
                     }
                 }
                 $endPageLinks = $startPageLinks + ($this->formArray["pageLinksInLine"] - 1);
                 if ($endPageLinks > $numOfPages) {
                     $endPageLinks = $numOfPages;
                 }
                 for ($i = $startPageLinks; $i <= $endPageLinks; $i++) {
                     if ($i == $this->formArray["page"]) {
                         $this->tpl->set_var("pageListPages", "");
                         $this->tpl->set_var("pageListPagesUrl", "");
                         $this->tpl->set_var("pageListPaged", $i);
                     } else {
                         $this->tpl->set_var("pageListPages", $i);
                         $this->tpl->set_var("pageListPagesUrl", $i);
                         $this->tpl->set_var("pageListPaged", "");
                     }
                     $this->tpl->parse("PagesListBlock", "PagesList", true);
                 }
                 // drop down nav
                 for ($i = 1; $i <= $numOfPages; $i++) {
                     if ($i == $this->formArray["page"]) {
                         $this->tpl->set_var("pages", $i);
                         $this->tpl->set_var("pagesUrl", $i);
                         $this->tpl->set_var("paged", "selected");
                     } else {
                         $this->tpl->set_var("pages", $i);
                         $this->tpl->set_var("pagesUrl", $i);
                         $this->tpl->set_var("paged", "");
                     }
                     $this->tpl->parse("PagesBlock", "Pages", true);
                 }
             }
             if ($numOfPages == $this->formArray["page"] || $numOfPages == "") {
                 $this->tpl->set_var("nextTxt", "");
             } else {
                 $this->tpl->set_var("next", $this->formArray["page"] + 1);
                 $this->tpl->set_var("nextTxt", "next");
             }
             if ($this->formArray["page"] == 1) {
                 $this->tpl->set_var("previousTxt", "");
             } else {
                 $this->tpl->set_var("previous", $this->formArray["page"] - 1);
                 $this->tpl->set_var("previousTxt", "previous");
             }
             if ($numOfPages == "") {
                 $this->tpl->set_var("pageOf", "");
             } else {
                 $this->tpl->set_var("pageOf", $this->formArray["page"] . " of " . $numOfPages);
             }
             $condition = $this->filterArchives();
             $condition .= $this->sortBlocks();
             if (!($xmlStr = $ODList->getODList($this->formArray["page"], $condition))) {
                 $this->tpl->set_block("rptsTemplate", "ODTable", "ODTableBlock");
                 $this->tpl->set_var("ODTableBlock", "");
                 $this->tpl->set_var("PagesBlock", "");
                 $this->tpl->set_var("PagesListBlock", "");
                 $this->tpl->set_block("rptsTemplate", "PageNavigator", "PageNavigatorBlock");
                 $this->tpl->set_var("PageNavigatorBlock", "");
                 $this->tpl->set_block("rptsTemplate", "ArchiveButton", "ArchiveButtonBlock");
                 $this->tpl->set_var("ArchiveButtonBlock", "");
                 $this->tpl->set_block("rptsTemplate", "UnArchiveButton", "UnArchiveButtonBlock");
                 $this->tpl->set_var("UnArchiveButtonBlock", "");
             } else {
                 //echo $xmlStr;
                 if (!($domDoc = domxml_open_mem($xmlStr))) {
                     $this->tpl->set_block("rptsTemplate", "ODListTable", "ODListTableBlock");
                     $this->tpl->set_var("ODListTableBlock", "");
                     $this->tpl->set_var("PagesBlock", "");
                     $this->tpl->set_var("PagesListBlock", "");
                     $this->tpl->set_block("rptsTemplate", "PageNavigator", "PageNavigatorBlock");
                     $this->tpl->set_var("PageNavigatorBlock", "");
                     $this->tpl->set_block("rptsTemplate", "ArchiveButton", "ArchiveButtonBlock");
                     $this->tpl->set_var("ArchiveButtonBlock", "");
                     $this->tpl->set_block("rptsTemplate", "UnArchiveButton", "UnArchiveButtonBlock");
                     $this->tpl->set_var("UnArchiveButtonBlock", "");
                 } else {
                     $odRecords = new ODRecords();
                     $odRecords->parseDomDocument($domDoc);
                     $list = $odRecords->getArrayList();
                     if (count($list)) {
                         $this->tpl->set_block("rptsTemplate", "ODDBEmpty", "ODDBEmptyBlock");
                         $this->tpl->set_var("ODDBEmptyBlock", "");
                         $this->tpl->set_block("rptsTemplate", "ODList", "ODListBlock");
                         $this->tpl->set_block("ODList", "PersonList", "PersonListBlock");
                         $this->tpl->set_block("ODList", "CompanyList", "CompanyListBlock");
                         foreach ($list as $key => $value) {
                             //print_r($value);
                             //echo "<br>";
                             $this->tpl->set_var("odID", $value->getOdID());
                             $propertyType = $this->getPropertyTypeFromOD($value);
                             if ($propertyType != "Land") {
                                 $this->tpl->set_var("checkbox_status", "disabled");
                                 $this->tpl->set_var("checkbox_style", "style='display:none;'");
                             } else {
                                 $this->tpl->set_var("checkbox_status", "");
                                 $this->tpl->set_var("checkbox_style", "");
                                 if (is_array($this->formArray["mergeBasketArray"])) {
                                     if (in_array($value->getOdID(), $this->formArray["mergeBasketArray"])) {
                                         $this->tpl->set_var("checkbox_status", "checked disabled");
                                     }
                                 }
                             }
                             switch ($propertyType) {
                                 case "Land":
                                     $this->tpl->set_var("propertyType", "L/P");
                                     break;
                                 case "ImprovementsBuildings":
                                     $this->tpl->set_var("propertyType", "I/B");
                                     break;
                                 case "Machineries":
                                     $this->tpl->set_var("propertyType", "M");
                                     break;
                                 default:
                                     $this->tpl->set_var("propertyType", "-");
                                     break;
                             }
                             $propertyType = $this->getPropertyTypeFromOD($value);
                             if ($propertyType != "Land") {
                                 $this->tpl->set_var("checkbox_status", "disabled");
                                 $this->tpl->set_var("checkbox_style", "style='display:none;'");
                             } else {
                                 $this->tpl->set_var("checkbox_status", "");
                                 $this->tpl->set_var("checkbox_style", "");
                                 if (is_array($this->formArray["mergeBasketArray"])) {
                                     if (in_array($value->getOdID(), $this->formArray["mergeBasketArray"])) {
                                         $this->tpl->set_var("checkbox_status", "checked disabled");
                                     }
                                 }
                             }
                             $oValue = $value->owner;
                             $pOwnerStr = "";
                             if (count($oValue->personArray)) {
                                 foreach ($oValue->personArray as $pKey => $pValue) {
                                     $this->tpl->set_var("personID", $pValue->getPersonID());
                                     $this->tpl->set_var("OwnerPerson", $pValue->getFullName());
                                     $this->tpl->parse("PersonListBlock", "PersonList", true);
                                 }
                             }
                             if (count($oValue->companyArray)) {
                                 foreach ($oValue->companyArray as $cKey => $cValue) {
                                     $this->tpl->set_var("companyID", $cValue->getCompanyID());
                                     $this->tpl->set_var("OwnerCompany", $cValue->getCompanyName());
                                     $this->tpl->parse("CompanyListBlock", "CompanyList", true);
                                 }
                             }
                             if (count($oValue->personArray) || count($oValue->companyArray)) {
                                 $this->tpl->set_var("none", "");
                             } else {
                                 $this->tpl->set_var("none", "none");
                             }
                             //*/
                             //if (method_exists($value->locationAddress,$value->locationAddress->getFullAddress()))
                             if ($value->locationAddress != "") {
                                 $this->tpl->set_var("locationAddress", $value->locationAddress->getFullAddress());
                             }
                             //Begin Edited, Decimal 2 was change to 4 ****************
                             $this->tpl->set_var("landArea", number_format($value->getLandArea(), 4, '.', ','));
                             //End
                             $this->tpl->parse("ODListBlock", "ODList", true);
                             $this->tpl->set_var("PersonListBlock", "");
                             $this->tpl->set_var("CompanyListBlock", "");
                         }
                     } else {
                         $this->tpl->set_block("rptsTemplate", "ODList", "ODListBlock");
                         $this->tpl->set_var("ODListBlock", "huh");
                     }
                 }
             }
     }
     $this->initBarangayList();
     $this->setForm();
     $this->tpl->set_var("uname", $this->user["uname"]);
     $this->tpl->set_var("today", date("F j, Y"));
     $this->tpl->set_var("Session", $this->sess->url(""));
     $this->tpl->parse("templatePage", "rptsTemplate");
     $this->tpl->finish("templatePage");
     $this->tpl->p("templatePage");
 }
 function Main()
 {
     switch ($this->formArray["formAction"]) {
         case "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");
 }
Example #8
0
 function Main()
 {
     switch ($this->formArray["formAction"]) {
         case "cancel":
             header("location: ODList.php");
             exit;
             break;
         default:
             $this->tpl->set_var("msg", "");
             $ODList = new SoapObject(NCCBIZ . "ODList.php", "urn:Object");
             $this->tpl->set_block("rptsTemplate", "Pages", "PagesBlock");
             $this->tpl->set_block("rptsTemplate", "NotFound", "NotFoundBlock");
             $this->tpl->set_var("NotFoundBlock", "");
             if (!($count = $ODList->getODCount($condition))) {
                 $this->tpl->set_var("PagesBlock", "");
                 $this->tpl->set_block("rptsTemplate", "PageNavigator", "PageNavigatorBlock");
                 $this->tpl->set_var("PageNavigatorBlock", "");
             } else {
                 $numOfPages = ceil($count / PAGE_BY);
                 for ($i = 1; $i <= $numOfPages; $i++) {
                     if ($i == $this->formArray["page"]) {
                         $this->tpl->set_var("pages", "");
                         $this->tpl->set_var("pagesUrl", "");
                         $this->tpl->set_var("paged", $i);
                     } else {
                         $this->tpl->set_var("pages", $i);
                         $this->tpl->set_var("pagesUrl", $i);
                         $this->tpl->set_var("paged", "");
                     }
                     $this->tpl->parse("PagesBlock", "Pages", true);
                 }
             }
             if ($numOfPages == $this->formArray["page"] || $numOfPages == "") {
                 $this->tpl->set_var("nextTxt", "");
             } else {
                 $this->tpl->set_var("next", $this->formArray["page"] + 1);
                 $this->tpl->set_var("nextTxt", "next");
             }
             if ($this->formArray["page"] == 1) {
                 $this->tpl->set_var("previousTxt", "");
             } else {
                 $this->tpl->set_var("previous", $this->formArray["page"] - 1);
                 $this->tpl->set_var("previousTxt", "previous");
             }
             if ($numOfPages == "") {
                 $this->tpl->set_var("pageOf", "");
             } else {
                 $this->tpl->set_var("pageOf", $this->formArray["page"] . " of " . $numOfPages);
             }
             if (!($xmlStr = $ODList->getODList(0, $condition))) {
                 $this->tpl->set_block("rptsTemplate", "ODTable", "ODTableBlock");
                 $this->tpl->set_var("ODTableBlock", "");
                 $this->tpl->set_var("PagesBlock", "");
                 $this->tpl->set_block("rptsTemplate", "PageNavigator", "PageNavigatorBlock");
                 $this->tpl->set_var("PageNavigatorBlock", "");
                 $this->tpl->set_block("rptsTemplate", "ArchiveButton", "ArchiveButtonBlock");
                 $this->tpl->set_var("ArchiveButtonBlock", "");
                 $this->tpl->set_block("rptsTemplate", "UnArchiveButton", "UnArchiveButtonBlock");
                 $this->tpl->set_var("UnArchiveButtonBlock", "");
             } else {
                 echo $xmlStr;
                 exit;
                 if (!($domDoc = domxml_open_mem($xmlStr))) {
                     $this->tpl->set_block("rptsTemplate", "ODListTable", "ODListTableBlock");
                     $this->tpl->set_var("ODListTableBlock", "");
                     $this->tpl->set_var("PagesBlock", "");
                     $this->tpl->set_block("rptsTemplate", "PageNavigator", "PageNavigatorBlock");
                     $this->tpl->set_var("PageNavigatorBlock", "");
                     $this->tpl->set_block("rptsTemplate", "ArchiveButton", "ArchiveButtonBlock");
                     $this->tpl->set_var("ArchiveButtonBlock", "");
                     $this->tpl->set_block("rptsTemplate", "UnArchiveButton", "UnArchiveButtonBlock");
                     $this->tpl->set_var("UnArchiveButtonBlock", "");
                 } else {
                     $odRecords = new ODRecords();
                     $odRecords->parseDomDocument($domDoc);
                     $list = $odRecords->getArrayList();
                     if (count($list)) {
                         $this->tpl->set_block("rptsTemplate", "ODDBEmpty", "ODDBEmptyBlock");
                         $this->tpl->set_var("ODDBEmptyBlock", "");
                         $this->tpl->set_block("rptsTemplate", "ODList", "ODListBlock");
                         $this->tpl->set_block("ODList", "PersonList", "PersonListBlock");
                         $this->tpl->set_block("ODList", "CompanyList", "CompanyListBlock");
                         foreach ($list as $key => $value) {
                             //print_r($value);
                             //echo "<br>";
                             $this->tpl->set_var("odID", $value->getOdID());
                             $oValue = $value->owner;
                             $pOwnerStr = "";
                             if (count($oValue->personArray)) {
                                 foreach ($oValue->personArray as $pKey => $pValue) {
                                     $this->tpl->set_var("personID", $pValue->getPersonID());
                                     $this->tpl->set_var("OwnerPerson", $pValue->getFullName());
                                     $this->tpl->parse("PersonListBlock", "PersonList", true);
                                 }
                             }
                             if (count($oValue->companyArray)) {
                                 foreach ($oValue->companyArray as $cKey => $cValue) {
                                     $this->tpl->set_var("companyID", $cValue->getCompanyID());
                                     $this->tpl->set_var("OwnerCompany", $cValue->getCompanyName());
                                     $this->tpl->parse("CompanyListBlock", "CompanyList", true);
                                 }
                             }
                             if (count($oValue->personArray) || count($oValue->companyArray)) {
                                 $this->tpl->set_var("none", "");
                             } else {
                                 $this->tpl->set_var("none", "none");
                             }
                             //*/
                             //if (method_exists($value->locationAddress,$value->locationAddress->getFullAddress()))
                             if ($value->locationAddress != "") {
                                 $this->tpl->set_var("locationAddress", $value->locationAddress->getFullAddress());
                             }
                             $this->tpl->set_var("landArea", number_format($value->getLandArea(), 2, '.', ','));
                             $this->tpl->parse("ODListBlock", "ODList", true);
                             $this->tpl->set_var("PersonListBlock", "");
                             $this->tpl->set_var("CompanyListBlock", "");
                         }
                     } else {
                         $this->tpl->set_block("rptsTemplate", "ODList", "ODListBlock");
                         $this->tpl->set_var("ODListBlock", "huh");
                     }
                 }
             }
     }
     $this->setForm();
     $this->tpl->set_var("Session", $this->sess->url(""));
     $this->tpl->parse("templatePage", "rptsTemplate");
     $this->tpl->finish("templatePage");
     $this->tpl->p("templatePage");
 }
Example #9
0
 function searchOD($page = 0, $searchKey, $condition = "")
 {
     if ($page > 0) {
         $page = ($page - 1) * PAGE_BY;
         $condition .= " LIMIT {$page}," . PAGE_BY;
     }
     $fields = array(COMPANY_TABLE . ".companyName", PERSON_TABLE . ".lastName", PERSON_TABLE . ".middleName", PERSON_TABLE . ".firstName", LOCATIONADDRESS_TABLE . ".number", LOCATIONADDRESS_TABLE . ".street", BARANGAY_TABLE . ".description", DISTRICT_TABLE . ".description", MUNICIPALITYCITY_TABLE . ".description", PROVINCE_TABLE . ".description");
     $odRecords = new ODRecords();
     if ($odRecords->searchRecords($searchKey, $fields, $condition)) {
         if (!($domDoc = $odRecords->getDomDocument())) {
             return false;
         } else {
             $xmlStr = $domDoc->dump_mem(true);
             return $xmlStr;
         }
     } else {
         return false;
     }
 }
Example #10
0
 function Main()
 {
     switch ($this->formArray["formAction"]) {
         case "view":
             $ODList = new SoapObject(NCCBIZ . "ODList.php", "urn:Object");
             $condition = $this->filterLocationAddress();
             $condition .= $this->filterArchives();
             if (!($xmlStr = $ODList->getODList(0, $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 {
                 if (!($domDoc = domxml_open_mem($xmlStr))) {
                     $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 {
                     $odRecords = new ODRecords();
                     $odRecords->parseDomDocument($domDoc);
                     $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->tpl->set_var("odID", $value->getOdID());
                             $afs = $this->getAFSDetails($value->getOdID());
                             $this->tpl->set_var("propertyIndexNumber", $afs->getPropertyIndexNumber());
                             $this->tpl->set_var("arpNumber", $afs->getArpNumber());
                             $this->tpl->set_var("assessedValue", number_format($afs->getTotalAssessedValue(), 2, '.', ','));
                             $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 (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->getNumber();
                             $locationAddress .= " ";
                             $locationAddress .= $value->locationAddress->getStreet();
                             $this->tpl->set_var("locationAddress", $locationAddress);
                             $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");
 }