function searchImprovementsBuildingsDepreciation($searchKey, $page = 0)
 {
     if ($page > 0) {
         $page = ($page - 1) * PAGE_BY;
         $limit = "LIMIT {$page}," . PAGE_BY;
     }
     $fields = array("code", "description", "status", "value");
     $improvementsBuildingsDepreciationRecords = new ImprovementsBuildingsDepreciationRecords();
     if ($improvementsBuildingsDepreciationRecords->searchRecords($searchKey, $fields, $limit)) {
         if (!($domDoc = $improvementsBuildingsDepreciationRecords->getDomDocument())) {
             return false;
         } else {
             $xmlStr = $domDoc->dump_mem(true);
             return $xmlStr;
         }
     } else {
         return false;
     }
 }
 function codeAlreadyExists()
 {
     $ImprovementsBuildingsDepreciationList = new SoapObject(NCCBIZ . "ImprovementsBuildingsDepreciationList.php", "urn:Object");
     if (!($xmlStr = $ImprovementsBuildingsDepreciationList->getImprovementsBuildingsDepreciationList())) {
         return false;
     } else {
         if (!($domDoc = domxml_open_mem($xmlStr))) {
             return false;
         } else {
             $improvementsBuildingsDepreciationRecords = new ImprovementsBuildingsDepreciationRecords();
             $improvementsBuildingsDepreciationRecords->parseDomDocument($domDoc);
             $list = $improvementsBuildingsDepreciationRecords->getArrayList();
             foreach ($list as $key => $improvementsBuildingsDepreciation) {
                 if (strtoupper($this->formArray["code"]) == strtoupper($improvementsBuildingsDepreciation->getCode())) {
                     if ($this->formArray["improvementsBuildingsDepreciationID"] != $improvementsBuildingsDepreciation->getImprovementsBuildingsDepreciationID()) {
                         return true;
                     }
                 }
             }
         }
     }
 }
 function Main()
 {
     switch ($this->formArray["formAction"]) {
         case "delete":
             if (count($this->formArray["improvementsBuildingsDepreciationID"]) > 0) {
                 $ImprovementsBuildingsDepreciationList = new SoapObject(NCCBIZ . "ImprovementsBuildingsDepreciationList.php", "urn:Object");
                 if (!($deletedRows = $ImprovementsBuildingsDepreciationList->deleteImprovementsBuildingsDepreciation($this->formArray["improvementsBuildingsDepreciationID"]))) {
                     $this->tpl->set_var("msg", "SOAP failed");
                 } else {
                     $this->tpl->set_var("msg", $deletedRows . " records deleted");
                 }
             } else {
                 $this->tpl->set_var("msg", "0 records deleted");
             }
             break;
         case "activate":
             $ImprovementsBuildingsDepreciationList = new SoapObject(NCCBIZ . "ImprovementsBuildingsDepreciationList.php", "urn:Object");
             if (!($activeRows = $ImprovementsBuildingsDepreciationList->updateStatus($this->formArray["status"]))) {
                 $this->tpl->set_var("msg", "All records have status made <i>inactive</i>");
             } else {
                 $this->tpl->set_var("msg", $activeRows . " records have status made <i>active</i>");
             }
             break;
         case "cancel":
             header("location: ImprovementsBuildingsDepreciationList.php");
             exit;
             break;
         default:
             $this->tpl->set_var("msg", "");
     }
     $ImprovementsBuildingsDepreciationList = new SoapObject(NCCBIZ . "ImprovementsBuildingsDepreciationList.php", "urn:Object");
     $condition = $this->showHideInactive();
     $condition .= $this->sortBlocks();
     if (!($xmlStr = $ImprovementsBuildingsDepreciationList->getImprovementsBuildingsDepreciationList(0, $condition))) {
         $this->tpl->set_block("rptsTemplate", "Table", "TableBlock");
         $this->tpl->set_var("TableBlock", "database is empty");
     } else {
         if (!($domDoc = domxml_open_mem($xmlStr))) {
             $this->tpl->set_block("rptsTemplate", "Table", "TableBlock");
             $this->tpl->set_var("TableBlock", "error xmlDoc");
         } else {
             $improvementsBuildingsDepreciationRecords = new ImprovementsBuildingsDepreciationRecords();
             $improvementsBuildingsDepreciationRecords->parseDomDocument($domDoc);
             $list = $improvementsBuildingsDepreciationRecords->getArrayList();
             $this->tpl->set_block("rptsTemplate", "ImprovementsBuildingsDepreciationList", "ImprovementsBuildingsDepreciationListBlock");
             foreach ($list as $key => $listValue) {
                 $this->tpl->set_var("improvementsBuildingsDepreciationID", $listValue->getImprovementsBuildingsDepreciationID());
                 $this->tpl->set_var("code", $listValue->getCode());
                 $this->tpl->set_var("reportCode", $listValue->getReportCode());
                 $this->tpl->set_var("description", $listValue->getDescription());
                 $this->tpl->set_var("rangeLowerBound", $listValue->getRangeLowerBound());
                 $this->tpl->set_var("rangeUpperBound", $listValue->getRangeUpperBound());
                 $this->tpl->set_var("value", $listValue->getValue());
                 $this->tpl->set_var("status", $listValue->getStatus());
                 $this->tpl->set_var("statusCheck", $this->getStatusCheck($listValue->getStatus()));
                 $this->tpl->parse("ImprovementsBuildingsDepreciationListBlock", "ImprovementsBuildingsDepreciationList", true);
             }
         }
     }
     $this->setForm();
     $this->tpl->set_var("uname", $this->user["uname"]);
     $this->tpl->set_var("today", date("F j, Y"));
     $this->tpl->parse("templatePage", "rptsTemplate");
     $this->tpl->finish("templatePage");
     $this->tpl->p("templatePage");
 }
 function Main()
 {
     switch ($this->formArray["formAction"]) {
         default:
             $this->tpl->set_var("msg", "");
     }
     $eRPTSSettingsDetails = new SoapObject(NCCBIZ . "eRPTSSettingsDetails.php", "urn:Object");
     if (!($xmlStr = $eRPTSSettingsDetails->getERPTSSettingsDetails(1))) {
         $this->tpl->set_block("rptsTemplate", "Table", "TableBlock");
         $this->tpl->set_var("TableBlock", "record not found");
     } else {
         if (!($domDoc = domxml_open_mem($xmlStr))) {
             $this->tpl->set_block("rptsTemplate", "Table", "TableBlock");
             $this->tpl->set_var("TableBlock", "error xmlDoc");
         } else {
             $erptsSettings = new eRPTSSettings();
             $erptsSettings->parseDomDocument($domDoc);
             $this->formArray["eRPTSSettingsID"] = $erptsSettings->getERPTSSettingsID();
             $this->formArray["lguName"] = $erptsSettings->getLguName();
             $this->formArray["lguType"] = $erptsSettings->getLguType();
             $this->formArray["chiefExecutiveDesignation"] = $erptsSettings->getChiefExecutiveDesignation();
             $this->formArray["chiefExecutiveFirstName"] = $erptsSettings->getChiefExecutiveFirstName();
             $this->formArray["chiefExecutiveMiddleName"] = $erptsSettings->getChiefExecutiveMiddleName();
             $this->formArray["chiefExecutiveLastName"] = $erptsSettings->getChiefExecutiveLastName();
             $this->formArray["assessorDesignation"] = $erptsSettings->getAssessorDesignation();
             $this->formArray["assessorFirstName"] = $erptsSettings->getAssessorFirstName();
             $this->formArray["assessorMiddleName"] = $erptsSettings->getAssessorMiddleName();
             $this->formArray["assessorLastName"] = $erptsSettings->getAssessorLastName();
             $this->formArray["treasurerDesignation"] = $erptsSettings->getTreasurerDesignation();
             $this->formArray["treasurerFirstName"] = $erptsSettings->getTreasurerFirstName();
             $this->formArray["treasurerMiddleName"] = $erptsSettings->getTreasurerMiddleName();
             $this->formArray["treasurerLastName"] = $erptsSettings->getTreasurerLastName();
         }
     }
     $ImprovementsBuildingsDepreciationList = new SoapObject(NCCBIZ . "ImprovementsBuildingsDepreciationList.php", "urn:Object");
     $condition = " WHERE status='active' ";
     $condition .= $this->sortBlocks();
     $this->tpl->set_var("activeInactive", "(active ONLY)");
     if (!($xmlStr = $ImprovementsBuildingsDepreciationList->getImprovementsBuildingsDepreciationList(0, $condition))) {
         $this->tpl->set_block("rptsTemplate", "Table", "TableBlock");
         $this->tpl->set_var("TableBlock", "database is empty");
     } else {
         if (!($domDoc = domxml_open_mem($xmlStr))) {
             $this->tpl->set_block("rptsTemplate", "Table", "TableBlock");
             $this->tpl->set_var("TableBlock", "error xmlDoc");
         } else {
             $improvementsBuildingsDepreciationRecords = new ImprovementsBuildingsDepreciationRecords();
             $improvementsBuildingsDepreciationRecords->parseDomDocument($domDoc);
             $list = $improvementsBuildingsDepreciationRecords->getArrayList();
             $this->tpl->set_var("totalRecords", count($list));
             $this->tpl->set_block("rptsTemplate", "ImprovementsBuildingsDepreciationList", "ImprovementsBuildingsDepreciationListBlock");
             foreach ($list as $key => $listValue) {
                 $this->tpl->set_var("improvementsBuildingsDepreciationID", $listValue->getImprovementsBuildingsDepreciationID());
                 $this->tpl->set_var("code", $listValue->getCode());
                 $this->tpl->set_var("description", $listValue->getDescription());
                 $this->tpl->set_var("rangeLowerBound", $listValue->getRangeLowerBound());
                 $this->tpl->set_var("rangeUpperBound", $listValue->getRangeUpperBound());
                 $this->tpl->set_var("value", $listValue->getValue());
                 $this->tpl->set_var("status", $listValue->getStatus());
                 $this->tpl->set_var("statusCheck", $this->getStatusCheck($listValue->getStatus()));
                 $this->tpl->parse("ImprovementsBuildingsDepreciationListBlock", "ImprovementsBuildingsDepreciationList", true);
             }
         }
     }
     $this->setForm();
     $this->tpl->parse("templatePage", "rptsTemplate");
     $this->tpl->finish("templatePage");
     $this->tpl->p("templatePage");
 }