function searchImprovementsBuildingsActualUses($searchKey, $page = 0) { if ($page > 0) { $page = ($page - 1) * PAGE_BY; $limit = "LIMIT {$page}," . PAGE_BY; } $fields = array("code", "description", "status", "value"); $improvementsBuildingsActualUsesRecords = new ImprovementsBuildingsActualUsesRecords(); if ($improvementsBuildingsActualUsesRecords->searchRecords($searchKey, $fields, $limit)) { if (!($domDoc = $improvementsBuildingsActualUsesRecords->getDomDocument())) { return false; } else { $xmlStr = $domDoc->dump_mem(true); return $xmlStr; } } else { return false; } }
function codeAlreadyExists() { $ImprovementsBuildingsActualUsesList = new SoapObject(NCCBIZ . "ImprovementsBuildingsActualUsesList.php", "urn:Object"); if (!($xmlStr = $ImprovementsBuildingsActualUsesList->getImprovementsBuildingsActualUsesList())) { return false; } else { if (!($domDoc = domxml_open_mem($xmlStr))) { return false; } else { $improvementsBuildingsActualUsesRecords = new ImprovementsBuildingsActualUsesRecords(); $improvementsBuildingsActualUsesRecords->parseDomDocument($domDoc); $list = $improvementsBuildingsActualUsesRecords->getArrayList(); foreach ($list as $key => $improvementsBuildingsActualUses) { if (strtoupper($this->formArray["code"]) == strtoupper($improvementsBuildingsActualUses->getCode())) { if ($this->formArray["improvementsBuildingsActualUsesID"] != $improvementsBuildingsActualUses->getImprovementsBuildingsActualUsesID()) { return true; } } } } } }
function initMasterPropertyList($TempVar, $tempVar) { $getList = "get" . $TempVar . "List"; $getID = "get" . $TempVar . "ID"; $this->tpl->set_block("rptsTemplate", $TempVar . "List", $TempVar . "ListBlock"); $TempVarList = new SoapObject(NCCBIZ . $TempVar . "List.php", "urn:Object"); $condition = "WHERE status='active' ORDER BY description"; if (!($xmlStr = $TempVarList->{$getList}(0, $condition))) { // empty list } else { if (!($domDoc = domxml_open_mem($xmlStr))) { // empty list } else { switch ($tempVar) { case "improvementsBuildingsClasses": $tempVarRecords = new ImprovementsBuildingsClassesRecords(); $tempVarID = "getImprovementsBuildingsClassesID"; $this->tpl->set_block("rptsTemplate", "JS" . $TempVar . "List", "JS" . $TempVar . "ListBlock"); break; case "improvementsBuildingsActualUses": $tempVarRecords = new ImprovementsBuildingsActualUsesRecords(); $tempVarID = "getImprovementsBuildingsActualUsesID"; $this->tpl->set_block("rptsTemplate", "JS" . $TempVar . "List", "JS" . $TempVar . "ListBlock"); break; } $tempVarRecords->parseDomDocument($domDoc); $list = $tempVarRecords->getArrayList(); $i = 0; foreach ($list as $key => $value) { $this->tpl->set_var($tempVar . "ID", $value->{$tempVarID}()); $this->tpl->set_var($tempVar, $value->getDescription()); $this->initSelected($tempVar, $value->{$tempVarID}()); $this->tpl->parse($TempVar . "ListBlock", $TempVar . "List", true); switch ($tempVar) { case "improvementsBuildingsClasses": $this->tpl->set_var("i", $i); $this->tpl->set_var("improvementsBuildingsClassesID", $value->getImprovementsBuildingsClassesID()); $this->tpl->set_var("code", addslashes($value->getCode())); $this->tpl->set_var("description", addslashes($value->getDescription())); $this->tpl->set_var("value", addslashes($value->getValue())); $this->tpl->set_var("type", addslashes($value->getType())); $this->initSelected($tempVar, $value->{$tempVarID}()); $this->tpl->parse("JS" . $TempVar . "ListBlock", "JS" . $TempVar . "List", true); $i++; if ($improvementsBuildingsClasses_selected == "") { if ($this->formArray["improvementsBuildingsClasses"] == $value->{$tempVarID}()) { $recommendedUnitValue = $value->getValue(); $improvementsBuildingsClasses = $value->getDescription(); $improvementsBuildingsClasses_selected = true; } $this->tpl->set_var("recommendedUnitValue", addslashes($recommendedUnitValue)); $this->tpl->set_var("improvementsBuildingsUnitValue", addslashes($improvementsBuildingsUnitValue)); } else { $this->tpl->set_var("recommendedUnitValue", addslashes($recommendedUnitValue)); $this->tpl->set_var("improvementsBuildingsUnitValue", addslashes($improvementsBuildingsUnitValue)); } break; case "improvementsBuildingsActualUses": $this->tpl->set_var("i", $i); $this->tpl->set_var("improvementsBuildingsActualUsesID", $value->getImprovementsBuildingsActualUsesID()); $this->tpl->set_var("code", addslashes($value->getCode())); $this->tpl->set_var("description", addslashes($value->getDescription())); $this->tpl->set_var("value", addslashes($value->getValue())); $this->initSelected($tempVar, $value->{$tempVarID}()); $this->tpl->parse("JS" . $TempVar . "ListBlock", "JS" . $TempVar . "List", true); $i++; if ($improvementsBuildingsActualUses_selected == "") { if ($this->formArray["improvementsBuildingsActualUses"] == $value->{$tempVarID}()) { $recommendedAssessmentLevel = $value->getValue(); $improvementsBuildingsActualUses = $value->getDescription(); $improvementsBuildingsActualUses_selected = true; } $this->tpl->set_var("recommendedAssessmentLevel", addslashes($recommendedAssessmentLevel)); $this->tpl->set_var("improvementsBuildingsActualUses", addslashes($improvementsBuildingsActualUses)); } else { $this->tpl->set_var("recommendedAssessmentLevel", addslashes($recommendedAssessmentLevel)); $this->tpl->set_var("improvementsBuildingsActualUses", addslashes($improvementsBuildingsActualUses)); } break; } } } } }
function Main() { switch ($this->formArray["formAction"]) { case "delete": if (count($this->formArray["improvementsBuildingsActualUsesID"]) > 0) { $ImprovementsBuildingsActualUsesList = new SoapObject(NCCBIZ . "ImprovementsBuildingsActualUsesList.php", "urn:Object"); if (!($deletedRows = $ImprovementsBuildingsActualUsesList->deleteImprovementsBuildingsActualUses($this->formArray["improvementsBuildingsActualUsesID"]))) { $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": $ImprovementsBuildingsActualUsesList = new SoapObject(NCCBIZ . "ImprovementsBuildingsActualUsesList.php", "urn:Object"); if (!($activeRows = $ImprovementsBuildingsActualUsesList->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: ImprovementsBuildingsActualUsesList.php"); exit; break; default: $this->tpl->set_var("msg", ""); } $ImprovementsBuildingsActualUsesList = new SoapObject(NCCBIZ . "ImprovementsBuildingsActualUsesList.php", "urn:Object"); $condition = $this->showHideInactive(); $condition .= $this->sortBlocks(); if (!($xmlStr = $ImprovementsBuildingsActualUsesList->getImprovementsBuildingsActualUsesList(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 { $improvementsBuildingsActualUsesRecords = new ImprovementsBuildingsActualUsesRecords(); $improvementsBuildingsActualUsesRecords->parseDomDocument($domDoc); $list = $improvementsBuildingsActualUsesRecords->getArrayList(); $this->tpl->set_block("rptsTemplate", "ImprovementsBuildingsActualUsesList", "ImprovementsBuildingsActualUsesListBlock"); foreach ($list as $key => $listValue) { $this->tpl->set_var("improvementsBuildingsActualUsesID", $listValue->getImprovementsBuildingsActualUsesID()); $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("ImprovementsBuildingsActualUsesListBlock", "ImprovementsBuildingsActualUsesList", 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(); } } $ImprovementsBuildingsActualUsesList = new SoapObject(NCCBIZ . "ImprovementsBuildingsActualUsesList.php", "urn:Object"); $condition = " WHERE status='active' "; $condition .= $this->sortBlocks(); $this->tpl->set_var("activeInactive", "(active ONLY)"); if (!($xmlStr = $ImprovementsBuildingsActualUsesList->getImprovementsBuildingsActualUsesList(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 { $improvementsBuildingsActualUsesRecords = new ImprovementsBuildingsActualUsesRecords(); $improvementsBuildingsActualUsesRecords->parseDomDocument($domDoc); $list = $improvementsBuildingsActualUsesRecords->getArrayList(); $this->tpl->set_var("totalRecords", count($list)); $this->tpl->set_block("rptsTemplate", "ImprovementsBuildingsActualUsesList", "ImprovementsBuildingsActualUsesListBlock"); foreach ($list as $key => $listValue) { $this->tpl->set_var("improvementsBuildingsActualUsesID", $listValue->getImprovementsBuildingsActualUsesID()); $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("ImprovementsBuildingsActualUsesListBlock", "ImprovementsBuildingsActualUsesList", true); } } } $this->setForm(); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); }