function generateTDHistory($tdID) { $td = new TD(); $td->selectRecord($tdID); $afsID = $td->getAfsID(); // echo("afsID=$afsID<br>"); $afs = new AFS(); $afs->selectRecord($afsID); $odID = $afs->getOdID(); // echo("odID=$odID<br>"); $condition = sprintf(" WHERE presentODID='%s' ", fixQuotes($odID)); $odHistoryRecords = new ODHistoryRecords(); $odHistoryRecords->selectRecords($condition); if (count($odHistoryRecords->arrayList) > 0) { // echo("count>0<br>"); foreach ($odHistoryRecords->arrayList as $key => $odHistory) { $previousODID = $odHistory->getPreviousODID(); $presentODID = $odHistory->getPresentODID(); $previousAFS = new AFS(); $previousAFS->selectRecord($afsID = "", $limit = "", $previousODID); $previousAFSID = $previousAFS->getAfsID(); $previousTD = new TD(); $previousTD->selectRecord($tdID = "", $previousAFSID); $previousTDID = $previousTD->getTdID(); $this->tdHistory[] = $previousTD; $this->generateTDHistory($previousTDID); } } else { //echo("count==0<br>"); return false; } }
function displayRecords() { $this->selectRecords(); $this->tpl->set_block("rptsTemplate", "OwnerPersonList", "OwnerPersonListBlock"); $this->tpl->set_block("OwnerPersonList", "ODList", "ODListBlock"); foreach ($this->arrayList as $person) { $this->tpl->set_var("personID", $person->getPersonID()); $this->tpl->set_var("lastName", $person->getLastName()); $this->tpl->set_var("firstName", $person->getFirstName()); $this->tpl->set_var("middleName", $person->getMiddleName()); $this->tpl->set_var("gender", $person->getGender()); $this->tpl->set_var("birthday", $person->getBirthday()); $this->tpl->set_var("maritalStatus", $person->getMaritalStatus()); $this->tpl->set_var("tin", $person->getTin()); $this->tpl->set_var("telephone", $person->getTelephone()); $this->tpl->set_var("mobileNumber", $person->getMobileNumber()); $this->tpl->set_var("email", $person->getEmail()); if (is_array($person->addressArray)) { $address = $person->addressArray[0]; $this->tpl->set_var("address", $address->getFullAddress()); } // capture OD, AFS, and TD info $this->setDB(); $sql = sprintf("SELECT DISTINCT(Owner.odID) as odID" . " FROM Owner,OwnerPerson " . " WHERE " . " Owner.ownerID = OwnerPerson.ownerID AND " . " OwnerPerson.personID = '%s' ", $person->getPersonID()); $this->db->query($sql); while ($this->db->next_record()) { $od = new OD(); if ($od->selectRecord($this->db->f("odID"))) { $this->ODArray[] = $od; $this->tpl->set_var("odID", $od->getOdID()); if (is_object($od->locationAddress)) { $this->tpl->set_var("locationAddress", $od->locationAddress->getFullAddress()); } else { $this->tpl->set_var("locationAddress", ""); } $afs = new AFS(); if ($afs->selectRecord("", "", $od->getOdID(), "")) { $this->tpl->set_var("afsID", $afs->getAfsID()); $this->tpl->set_var("propertyIndexNumber", $afs->getPropertyIndexNumber()); $this->tpl->set_var("arpNumber", $afs->getArpNumber()); if (is_array($afs->landArray)) { $this->displayLandList($afs->landArray); } if (is_array($afs->plantsTreesArray)) { $this->displayPlantsTreesList($afs->plantsTreesArray); } if (is_array($afs->improvementsBuildingsArray)) { $this->displayImprovementsBuildingsList($afs->improvementsBuildingsArray); } if (is_array($afs->machineriesArray)) { $this->displayMachineriesList($afs->machineriesArray); } $td = new TD(); if ($td->selectRecord("", $afs->getAfsID(), "", "", "")) { $this->tpl->set_var("tdID", $td->getTdID()); $this->tpl->set_var("taxDeclarationNumber", $td->getTaxDeclarationNumber()); $this->tpl->set_var("propertyType", $td->getPropertyType()); } } unset($td); unset($afs); unset($od); $this->tpl->parse("ODListBlock", "ODList", true); } } $this->tpl->parse("OwnerPersonListBlock", "OwnerPersonList", true); $this->tpl->set_var("ODListBlock", ""); $this->clearPropertyElements(); unset($this->ODArray); unset($this->AFSArray); unset($this->TDArray); unset($this->db); } }
function getTDArrayFromCompany($companyID) { $this->setDB(); $sql = sprintf("SELECT DISTINCT(Owner.odID) as odID" . " FROM Owner,OwnerCompany " . " WHERE " . " Owner.ownerID = OwnerCompany.ownerID AND " . " OwnerCompany.companyID = '%s' ", $companyID); $this->db->query($sql); while ($this->db->next_record()) { $od = new OD(); if ($od->selectRecord($this->db->f("odID"))) { $this->ODArray[] = $od; $afs = new AFS(); if ($afs->selectRecord("", "", $od->getOdID(), "")) { $td = new TD(); if ($td->selectRecord("", $afs->getAfsID(), "", "", "")) { $tdArray[] = $td; } } } } if (!is_array($tdArray)) { $tdArray = false; } return $tdArray; }
function getTDIDArrayFromParentTDID($presentTDID) { $presentTD = new TD(); $presentTD->selectRecord($presentTDID); $presentAfsID = $presentTD->getAfsID(); $presentAFS = new AFS(); $presentAFS->selectRecord($presentAFSID); $presentODID = $presentAFS->getOdID(); $odHistoryRecords = new ODHistoryRecords(); $odHistoryRecords->selectPrecOD($presentODID); if (is_array($odHistoryRecords->arrayList)) { foreach ($odHistoryRecords as $odID) { $afs = new AFS(); $afs->selectRecord("", "", $odID); $afsID = $afs->getAfsID(); $td = new TD(); $td->selectRecord("", $afsID); $tdID = $td->getTdID(); $tdIDArray[] = $tdID; } if (is_array($tdIDArray)) { return $tdIDArray; } } return false; }
function Main() { switch ($this->formArray["formAction"]) { case "save": $AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object"); if (!($xmlStr = $AFSDetails->getAFS($this->formArray["afsID"]))) { exit("error xml"); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { exit("error domDoc"); } else { $AFSEncode = new SoapObject(NCCBIZ . "AFSEncode.php", "urn:Object"); $afs = new AFS(); $afs->parseDomDocument($domDoc); $afs->setArpNumber($this->formArray["arpNumber"]); $afs->setPropertyIndexNumber($this->formArray["propertyIndexNumber"]); $afs->setTaxability($this->formArray["taxability"]); $afs->setEffectivity($this->formArray["effectivity"]); $afs->setDomDocument(); $doc = $afs->getDomDocument(); $xmlStr = $doc->dump_mem(true); if (!($ret = $AFSEncode->updateAFS($xmlStr))) { exit("error update"); } } } header("location: RPUIdentificationClose.php" . $this->sess->url("") . $this->sess->add_query(array("afsID" => $this->formArray["afsID"]))); exit; break; default: $AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object"); $AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object"); if (!($xmlStr = $AFSDetails->getAFS($this->formArray["afsID"]))) { exit("error xml"); } else { //echo $xmlStr; if (!($domDoc = domxml_open_mem($xmlStr))) { exit("error domDoc"); } else { $afs = new AFS(); $afs->parseDomDocument($domDoc); $this->formArray["afsID"] = $afs->getAfsID(); $this->formArray["arpNumber"] = $afs->getArpNumber(); $this->formArray["taxability"] = $afs->getTaxability(); $this->formArray["effectivity"] = $afs->getEffectivity(); $this->formArray["propertyIndexNumber"] = $afs->getPropertyIndexNumber(); } } break; } $this->setForm(); $this->tpl->set_var("Session", $this->sess->url("") . $this->sess->add_query(array("afsID" => $this->formArray["afsID"]))); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); }
function Main() { switch ($this->formArray["formAction"]) { case "save": $AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object"); if (!($xmlStr = $AFSDetails->getAFS($this->formArray["afsID"]))) { exit("error xml"); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { exit("error domDoc"); } else { $AFSEncode = new SoapObject(NCCBIZ . "AFSEncode.php", "urn:Object"); $afs = new AFS(); $afs->parseDomDocument($domDoc); $afs->setArpNumber($this->formArray["arpNumber"]); $afs->setCadastralLotNumber($this->formArray["cadastralLotNumber"]); // convert $pointsArray to $gisTechnicalDescription string // separate each point with "-" and each pointRecord with "," $pointsArray = $this->formArray["pointsArray"]; $pointID = 1; if (is_array($pointsArray)) { for ($pointID = 1; $pointID <= count($pointsArray); $pointID++) { $pointArray = array($pointID, $pointsArray[$pointID]["pointType"], $pointsArray[$pointID]["quadrant"], $pointsArray[$pointID]["bearingDeg"], $pointsArray[$pointID]["bearingMin"], $pointsArray[$pointID]["distance"]); $pointString = implode("-", $pointArray); $gisTechDescArray[$pointID] = $pointString; } $gisTechnicalDescription = implode(",", $gisTechDescArray); $this->formArray["gisTechnicalDescription"] = $gisTechnicalDescription; } $afs->setGISTechnicalDescription($this->formArray["gisTechnicalDescription"]); $afs->setDomDocument(); $doc = $afs->getDomDocument(); $xmlStr = $doc->dump_mem(true); if (!($ret = $AFSEncode->updateAFS($xmlStr))) { exit("error update"); } } } header("location: GISTechnicalDescriptionClose.php" . $this->sess->url("") . $this->sess->add_query(array("afsID" => $this->formArray["afsID"]))); exit; break; case "del": // temporarily del points $delPointsArray = $this->formArray["pointsArray"]; $pointID = 1; if (is_array($delPointsArray)) { for ($delPointID = 1; $delPointID <= count($delPointsArray); $delPointID++) { if ($delPointID != $this->formArray["delPointID"]) { $pointsArray[$pointID]["pointType"] = $delPointsArray[$delPointID]["pointType"]; $pointsArray[$pointID]["quadrant"] = $delPointsArray[$delPointID]["quadrant"]; $pointsArray[$pointID]["bearingDeg"] = $delPointsArray[$delPointID]["bearingDeg"]; $pointsArray[$pointID]["bearingMin"] = $delPointsArray[$delPointID]["bearingMin"]; $pointsArray[$pointID]["distance"] = $delPointsArray[$delPointID]["distance"]; $pointID++; } } if (is_array($pointsArray)) { $this->tpl->set_block("rptsTemplate", "PointsList", "PointsListBlock"); for ($pointID = 1; $pointID <= count($pointsArray); $pointID++) { $this->tpl->set_var("pointID", $pointID); $this->tpl->set_var("pointType", $pointsArray[$pointID]["pointType"]); $this->tpl->set_var("quadrant", $pointsArray[$pointID]["quadrant"]); $this->tpl->set_var("bearingDeg", $pointsArray[$pointID]["bearingDeg"]); $this->tpl->set_var("bearingMin", $pointsArray[$pointID]["bearingMin"]); $this->tpl->set_var("distance", $pointsArray[$pointID]["distance"]); $this->tpl->parse("PointsListBlock", "PointsList", true); } $this->formArray["pointsExist"] = "true"; } else { $this->formArray["pointsExist"] = "false"; $this->hideBlock("PointsList"); } } break; case "add": // temporarily add points $pointsArray = $this->formArray["pointsArray"]; $pointID = 1; if (is_array($pointsArray)) { $this->tpl->set_block("rptsTemplate", "PointsList", "PointsListBlock"); for ($pointID = 1; $pointID <= count($pointsArray); $pointID++) { $this->tpl->set_var("pointID", $pointID); $this->tpl->set_var("pointType", $pointsArray[$pointID]["pointType"]); $this->tpl->set_var("quadrant", $pointsArray[$pointID]["quadrant"]); $this->tpl->set_var("bearingDeg", $pointsArray[$pointID]["bearingDeg"]); $this->tpl->set_var("bearingMin", $pointsArray[$pointID]["bearingMin"]); $this->tpl->set_var("distance", $pointsArray[$pointID]["distance"]); $this->tpl->parse("PointsListBlock", "PointsList", true); } $pointsArray[$pointID]["pointType"] = $this->formArray["pointType"]; $pointsArray[$pointID]["quadrant"] = $this->formArray["quadrant"]; $pointsArray[$pointID]["bearingDeg"] = $this->formArray["bearingDeg"]; $pointsArray[$pointID]["bearingMin"] = $this->formArray["bearingMin"]; $pointsArray[$pointID]["distance"] = $this->formArray["distance"]; $this->tpl->set_var("pointID", $pointID); $this->tpl->set_var("pointType", $pointsArray[$pointID]["pointType"]); $this->tpl->set_var("quadrant", $pointsArray[$pointID]["quadrant"]); $this->tpl->set_var("bearingDeg", $pointsArray[$pointID]["bearingDeg"]); $this->tpl->set_var("bearingMin", $pointsArray[$pointID]["bearingMin"]); $this->tpl->set_var("distance", $pointsArray[$pointID]["distance"]); $this->tpl->parse("PointsListBlock", "PointsList", true); } else { $pointsArray[$pointID]["pointType"] = $this->formArray["pointType"]; $pointsArray[$pointID]["quadrant"] = $this->formArray["quadrant"]; $pointsArray[$pointID]["bearingDeg"] = $this->formArray["bearingDeg"]; $pointsArray[$pointID]["bearingMin"] = $this->formArray["bearingMin"]; $pointsArray[$pointID]["distance"] = $this->formArray["distance"]; $this->tpl->set_block("rptsTemplate", "PointsList", "PointsListBlock"); $this->tpl->set_var("pointID", $pointID); $this->tpl->set_var("pointType", $pointsArray[$pointID]["pointType"]); $this->tpl->set_var("quadrant", $pointsArray[$pointID]["quadrant"]); $this->tpl->set_var("bearingDeg", $pointsArray[$pointID]["bearingDeg"]); $this->tpl->set_var("bearingMin", $pointsArray[$pointID]["bearingMin"]); $this->tpl->set_var("distance", $pointsArray[$pointID]["distance"]); $this->tpl->parse("PointsListBlock", "PointsList", true); } $this->formArray["pointsExist"] = "true"; break; default: $AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object"); $AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object"); if (!($xmlStr = $AFSDetails->getAFS($this->formArray["afsID"]))) { exit("error xml"); } else { //echo $xmlStr; if (!($domDoc = domxml_open_mem($xmlStr))) { exit("error domDoc"); } else { $afs = new AFS(); $afs->parseDomDocument($domDoc); $this->formArray["afsID"] = $afs->getAfsID(); $this->formArray["cadastralLotNumber"] = $afs->getCadastralLotNumber(); $this->formArray["gisTechnicalDescription"] = $afs->getGISTechnicalDescription(); if ($this->formArray["gisTechnicalDescription"] == "") { $this->formArray["pointsExist"] = "false"; $this->hideBlock("PointsList"); } else { $this->formArray["pointsExist"] = "true"; // parse gisTechnicalDescription into $pointsArray // separate each pointRecord at "," and each point at "-" $gisTechDescArray = explode(",", $this->formArray["gisTechnicalDescription"]); foreach ($gisTechDescArray as $pointString) { $pointArray = explode("-", $pointString); $pointID = $pointArray[0]; $pointsArray[$pointID]["pointType"] = $pointArray[1]; $pointsArray[$pointID]["quadrant"] = $pointArray[2]; $pointsArray[$pointID]["bearingDeg"] = $pointArray[3]; $pointsArray[$pointID]["bearingMin"] = $pointArray[4]; $pointsArray[$pointID]["distance"] = $pointArray[5]; } if (is_array($pointsArray)) { $this->tpl->set_block("rptsTemplate", "PointsList", "PointsListBlock"); for ($pointID = 1; $pointID <= count($pointsArray); $pointID++) { $this->tpl->set_var("pointID", $pointID); $this->tpl->set_var("pointType", $pointsArray[$pointID]["pointType"]); $this->tpl->set_var("quadrant", $pointsArray[$pointID]["quadrant"]); $this->tpl->set_var("bearingDeg", $pointsArray[$pointID]["bearingDeg"]); $this->tpl->set_var("bearingMin", $pointsArray[$pointID]["bearingMin"]); $this->tpl->set_var("distance", $pointsArray[$pointID]["distance"]); $this->tpl->parse("PointsListBlock", "PointsList", true); } } } } } break; } $this->setForm(); $this->tpl->set_var("Session", $this->sess->url("") . $this->sess->add_query(array("afsID" => $this->formArray["afsID"]))); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); }