function searchPlantsTreesActualUses($searchKey, $page = 0) { if ($page > 0) { $page = ($page - 1) * PAGE_BY; $limit = "LIMIT {$page}," . PAGE_BY; } $fields = array("code", "reportCode", "description", "status", "value"); $plantsTreesActualUsesRecords = new PlantsTreesActualUsesRecords(); if ($plantsTreesActualUsesRecords->searchRecords($searchKey, $fields, $limit)) { if (!($domDoc = $plantsTreesActualUsesRecords->getDomDocument())) { return false; } else { $xmlStr = $domDoc->dump_mem(true); return $xmlStr; } } else { return false; } }
function codeAlreadyExists() { $PlantsTreesActualUsesList = new SoapObject(NCCBIZ . "PlantsTreesActualUsesList.php", "urn:Object"); if (!($xmlStr = $PlantsTreesActualUsesList->getPlantsTreesActualUsesList())) { return false; } else { if (!($domDoc = domxml_open_mem($xmlStr))) { return false; } else { $plantsTreesActualUsesRecords = new PlantsTreesActualUsesRecords(); $plantsTreesActualUsesRecords->parseDomDocument($domDoc); $list = $plantsTreesActualUsesRecords->getArrayList(); foreach ($list as $key => $plantsTreesActualUses) { if (strtoupper($this->formArray["code"]) == strtoupper($plantsTreesActualUses->getCode())) { if ($this->formArray["plantsTreesActualUsesID"] != $plantsTreesActualUses->getPlantsTreesActualUsesID()) { 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"); if (!($xmlStr = $TempVarList->{$getList}(0, "WHERE status='active' ORDER BY description"))) { // empty list } else { if (!($domDoc = domxml_open_mem($xmlStr))) { // empty list } else { switch ($tempVar) { case "plantsTreesClasses": $tempVarRecords = new PlantsTreesClassesRecords(); $tempVarID = "getPlantsTreesClassesID"; $this->tpl->set_block("rptsTemplate", "JS" . $TempVar . "List", "JS" . $TempVar . "ListBlock"); break; case "plantsTreesActualUses": $tempVarRecords = new PlantsTreesActualUsesRecords(); $tempVarID = "getPlantsTreesActualUsesID"; $this->tpl->set_block("rptsTemplate", "JS" . $TempVar . "List", "JS" . $TempVar . "ListBlock"); break; } $tempVarRecords->parseDomDocument($domDoc); $list = $tempVarRecords->getArrayList(); $i = 0; $j = 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 "plantsTreesClasses": $this->tpl->set_var("i", $i); $this->tpl->set_var("plantsTreesClassesID", $value->getPlantsTreesClassesID()); $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->parse("JS" . $TempVar . "ListBlock", "JS" . $TempVar . "List", true); $i++; if ($plantsTreesClasses_selected == "") { if ($this->formArray["plantsTreesClasses"] == $value->{$tempVarID}()) { $recommendedUnitPrice = $value->getValue(); $plantsTreesClasses = $value->getDescription(); $plantsTreesClasses_selected = true; } } $this->tpl->set_var("recommendedUnitPrice", addslashes($recommendedUnitPrice)); $this->tpl->set_var("plantsTreesClasses", addslashes($plantsTreesClasses)); break; case "plantsTreesActualUses": $this->tpl->set_var("i", $j); $this->tpl->set_var("plantsTreesActualUsesID", $value->getPlantsTreesActualUsesID()); $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->parse("JS" . $TempVar . "ListBlock", "JS" . $TempVar . "List", true); $j++; if ($plantsTreesActualUses_selected == "") { if ($this->formArray["plantsTreesActualUses"] == $value->{$tempVarID}()) { $recommendedAssessmentLevel = $value->getValue(); $plantsTreesActualUses = $value->getDescription(); $plantsTreesActualUses_selected = true; } } $this->tpl->set_var("recommendedAssessmentLevel", addslashes($recommendedAssessmentLevel)); $this->tpl->set_var("plantsTreesActualUses", addslashes($plantsTreesActualUses)); break; } } } } }
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(); } } $PlantsTreesActualUsesList = new SoapObject(NCCBIZ . "PlantsTreesActualUsesList.php", "urn:Object"); $condition = " WHERE status='active' "; $condition .= $this->sortBlocks(); $this->tpl->set_var("activeInactive", "(active ONLY)"); if (!($xmlStr = $PlantsTreesActualUsesList->getPlantsTreesActualUsesList(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 { $plantsTreesActualUsesRecords = new PlantsTreesActualUsesRecords(); $plantsTreesActualUsesRecords->parseDomDocument($domDoc); $list = $plantsTreesActualUsesRecords->getArrayList(); $this->tpl->set_var("totalRecords", count($list)); $this->tpl->set_block("rptsTemplate", "PlantsTreesActualUsesList", "PlantsTreesActualUsesListBlock"); foreach ($list as $key => $listValue) { $this->tpl->set_var("plantsTreesActualUsesID", $listValue->getPlantsTreesActualUsesID()); $this->tpl->set_var("code", $listValue->getCode()); $this->tpl->set_var("description", $listValue->getDescription()); $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("PlantsTreesActualUsesListBlock", "PlantsTreesActualUsesList", true); } } } $this->setForm(); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); }
function Main() { switch ($this->formArray["formAction"]) { case "delete": if (count($this->formArray["plantsTreesActualUsesID"]) > 0) { $PlantsTreesActualUsesList = new SoapObject(NCCBIZ . "PlantsTreesActualUsesList.php", "urn:Object"); if (!($deletedRows = $PlantsTreesActualUsesList->deletePlantsTreesActualUses($this->formArray["plantsTreesActualUsesID"]))) { $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": $PlantsTreesActualUsesList = new SoapObject(NCCBIZ . "PlantsTreesActualUsesList.php", "urn:Object"); if (!($activeRows = $PlantsTreesActualUsesList->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: PlantsTreesActualUsesList.php"); exit; break; default: $this->tpl->set_var("msg", ""); } $PlantsTreesActualUsesList = new SoapObject(NCCBIZ . "PlantsTreesActualUsesList.php", "urn:Object"); $condition = $this->showHideInactive(); $condition .= $this->sortBlocks(); if (!($xmlStr = $PlantsTreesActualUsesList->getPlantsTreesActualUsesList(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 { $plantsTreesActualUsesRecords = new PlantsTreesActualUsesRecords(); $plantsTreesActualUsesRecords->parseDomDocument($domDoc); $list = $plantsTreesActualUsesRecords->getArrayList(); $this->tpl->set_block("rptsTemplate", "PlantsTreesActualUsesList", "PlantsTreesActualUsesListBlock"); foreach ($list as $key => $listValue) { $this->tpl->set_var("plantsTreesActualUsesID", $listValue->getPlantsTreesActualUsesID()); $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("value", $listValue->getValue()); $this->tpl->set_var("status", $listValue->getStatus()); $this->tpl->set_var("statusCheck", $this->getStatusCheck($listValue->getStatus())); $this->tpl->parse("PlantsTreesActualUsesListBlock", "PlantsTreesActualUsesList", 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"); }