/**
* @param SimpleXMLElement $xml
* @return Person
* @throws InvalidGPXException
*/
public static function fromXML(SimpleXMLElement $xml)
{
$person = new Person();
if (!empty($xml->name)) {
$person->setName((string) $xml->name[0]);
}
if (!empty($xml->email)) {
$person->setEmail(Email::fromXML($xml->email[0]));
}
if (!empty($xml->link)) {
$person->setLink(Link::fromXML($xml->link[0]));
}
return $person;
}
public function save_register()
{
$newPerson = new Person();
$toRepository = new Administration();
$newPerson->setTitle(Input::get('userTitle'));
$newPerson->setName(Input::get('txtName'));
$newPerson->setSurname(Input::get('txtSurName'));
$newPerson->setPosition_ID(Input::get('userPosition'));
$newPerson->setBirthday(Input::get('txtBirthday'));
$newPerson->setNational_ID(Input::get('txtIdent'));
$newPerson->setType_ID(Input::get('userType'));
$newPerson->setDepartment_ID(Input::get('userDepart'));
$newPerson->setDivision_ID(Input::get('userDivision'));
$newPerson->setEmail(Input::get('txtEmail'));
$newPerson->setTelphone(Input::get('txtTel'));
$returnValue = $toRepository->addPerson($newPerson);
if ($returnValue == 1) {
return View::make('alert/person/alertRegister');
} else {
return View::make('alert/person/alertRegister2');
}
}
function Main()
{
switch ($this->formArray["formAction"]) {
case "edit":
$ImprovementsBuildingsDetails = new SoapObject(NCCBIZ . "ImprovementsBuildingsDetails.php", "urn:Object");
if (!($xmlStr = $ImprovementsBuildingsDetails->getImprovementsBuildings($this->formArray["propertyID"]))) {
echo "xml failed";
} else {
//echo $xmlStr;
if (!($domDoc = domxml_open_mem($xmlStr))) {
$this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock");
$this->tpl->set_var("OwnerListTableBlock", "error xmlDoc");
} else {
$improvementsBuildings = new ImprovementsBuildings();
$improvementsBuildings->parseDomDocument($domDoc);
foreach ($improvementsBuildings as $key => $value) {
switch ($key) {
case "propertyAdministrator":
if (is_a($value, Person)) {
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value->getBirthday());
$this->formArray["personID"] = $value->getPersonID();
$this->formArray["lastName"] = $value->getLastName();
$this->formArray["firstName"] = $value->getFirstName();
$this->formArray["middleName"] = $value->getMiddleName();
$this->formArray["gender"] = $value->getGender();
$this->formArray["birth_year"] = removePreZero($dateArr["year"]);
$this->formArray["birth_month"] = removePreZero($dateArr["month"]);
$this->formArray["birth_day"] = removePreZero($dateArr["day"]);
$this->formArray["maritalStatus"] = $value->getMaritalStatus();
$this->formArray["tin"] = $value->getTin();
if (is_array($value->addressArray)) {
$this->formArray["addressID"] = $value->addressArray[0]->getAddressID();
$this->formArray["number"] = $value->addressArray[0]->getNumber();
$this->formArray["street"] = $value->addressArray[0]->getStreet();
$this->formArray["barangay"] = $value->addressArray[0]->getBarangay();
$this->formArray["district"] = $value->addressArray[0]->getDistrict();
$this->formArray["municipalityCity"] = $value->addressArray[0]->getMunicipalityCity();
$this->formArray["province"] = $value->addressArray[0]->getProvince();
}
$this->formArray["telephone"] = $value->getTelephone();
$this->formArray["mobileNumber"] = $value->getMobileNumber();
$this->formArray["email"] = $value->getEmail();
} else {
$this->formArray[$key] = "";
}
break;
case "appraisedByDate":
if (true) {
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value);
$this->formArray["as_year"] = removePreZero($dateArr["year"]);
$this->formArray["as_month"] = removePreZero($dateArr["month"]);
$this->formArray["as_day"] = removePreZero($dateArr["day"]);
} else {
$this->formArray[$key] = "";
}
break;
case "recommendingApprovalDate":
if (true) {
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value);
$this->formArray["re_year"] = removePreZero($dateArr["year"]);
$this->formArray["re_month"] = removePreZero($dateArr["month"]);
$this->formArray["re_day"] = removePreZero($dateArr["day"]);
} else {
$this->formArray[$key] = "";
}
break;
case "approvedByDate":
if (true) {
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value);
$this->formArray["av_year"] = removePreZero($dateArr["year"]);
$this->formArray["av_month"] = removePreZero($dateArr["month"]);
$this->formArray["av_day"] = removePreZero($dateArr["day"]);
} else {
$this->formArray[$key] = "";
}
break;
case "dateConstructed":
if (true) {
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value);
$this->formArray["dc_year"] = removePreZero($dateArr["year"]);
$this->formArray["dc_month"] = removePreZero($dateArr["month"]);
$this->formArray["dc_day"] = removePreZero($dateArr["day"]);
} else {
$this->formArray[$key] = "";
}
break;
case "dateOccupied":
if (true) {
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value);
$this->formArray["do_year"] = removePreZero($dateArr["year"]);
$this->formArray["do_month"] = removePreZero($dateArr["month"]);
$this->formArray["do_day"] = removePreZero($dateArr["day"]);
} else {
$this->formArray[$key] = "";
}
break;
case "dateCompleted":
if (true) {
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value);
$this->formArray["dm_year"] = removePreZero($dateArr["year"]);
$this->formArray["dm_month"] = removePreZero($dateArr["month"]);
$this->formArray["dm_day"] = removePreZero($dateArr["day"]);
} else {
$this->formArray[$key] = "";
}
break;
default:
$this->formArray[$key] = $value;
}
}
}
}
break;
case "save":
if ($this->formArray["verifiedByID"] != "" && $this->formArray["verifiedByID"] != "xx" && $this->formArray["propertyID"] != "") {
$this->saveVerified($this->formArray["afsID"], $this->formArray["verifiedByID"], $this->formArray["propertyID"]);
}
$ImprovementsBuildingsEncode = new SoapObject(NCCBIZ . "ImprovementsBuildingsEncode.php", "urn:Object");
if ($this->formArray["propertyID"] != "") {
$ImprovementsBuildingsDetails = new SoapObject(NCCBIZ . "ImprovementsBuildingsDetails.php", "urn:Object");
if (!($xmlStr = $ImprovementsBuildingsDetails->getImprovementsBuildings($this->formArray["propertyID"]))) {
$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 {
$address = new Address();
$address->setAddressID($this->formArray["addressID"]);
$address->setNumber($this->formArray["number"]);
$address->setStreet($this->formArray["street"]);
$address->setBarangay($this->formArray["barangay"]);
$address->setDistrict($this->formArray["district"]);
$address->setMunicipalityCity($this->formArray["municipalityCity"]);
$address->setProvince($this->formArray["province"]);
$address->setDomDocument();
$propertyAdministrator = new Person();
$propertyAdministrator->setPersonID($this->formArray["personID"]);
$propertyAdministrator->setLastName($this->formArray["lastName"]);
$propertyAdministrator->setFirstName($this->formArray["firstName"]);
$propertyAdministrator->setMiddleName($this->formArray["middleName"]);
//$propertyAdministrator->setGender($this->formArray["gender"]);
//$propertyAdministrator->setBirthday($this->birthdate);
//$propertyAdministrator->setMaritalStatus($this->formArray["maritalStatus"]);
//$propertyAdministrator->setTin($this->formArray["tin"]);
$propertyAdministrator->setAddressArray($address);
$propertyAdministrator->setTelephone($this->formArray["telephone"]);
//$propertyAdministrator->setMobileNumber($this->formArray["mobileNumber"]);
$propertyAdministrator->setEmail($this->formArray["email"]);
$propertyAdministrator->setDomDocument();
$improvementsBuildings = new ImprovementsBuildings();
$improvementsBuildings->parseDomDocument($domDoc);
$improvementsBuildings->setPropertyID($this->formArray["propertyID"]);
$improvementsBuildings->setAfsID($this->formArray["afsID"]);
$improvementsBuildings->setArpNumber($this->formArray["arpNumber"]);
$improvementsBuildings->setPropertyIndexNumber($this->formArray["propertyIndexNumber"]);
$improvementsBuildings->setPropertyAdministrator($propertyAdministrator);
$improvementsBuildings->setVerifiedBy($this->formArray["verifiedByID"]);
$improvementsBuildings->setPlottingsBy($this->formArray["plottingsByID"]);
$improvementsBuildings->setNotedBy($this->formArray["notedByID"]);
$improvementsBuildings->setMarketValue($this->formArray["marketValue"]);
$improvementsBuildings->setKind($this->formArray["kind"]);
$improvementsBuildings->setActualUse($this->formArray["actualUse"]);
$improvementsBuildings->setAdjustedMarketValue($this->formArray["adjustedMarketValue"]);
$improvementsBuildings->setAssessmentLevel($this->formArray["assessmentLevel"]);
$improvementsBuildings->setAssessedValue($this->formArray["assessedValue"]);
$improvementsBuildings->setPreviousOwner($this->formArray["previousOwner"]);
$improvementsBuildings->setPreviousAssessedValue($this->formArray["previousAssessedValue"]);
$improvementsBuildings->setTaxability($this->formArray["taxability"]);
$improvementsBuildings->setEffectivity($this->formArray["effectivity"]);
$improvementsBuildings->setAppraisedBy($this->formArray["appraisedByID"]);
$improvementsBuildings->setAppraisedByDate($this->formArray["appraisedByDate"]);
$improvementsBuildings->setRecommendingApproval($this->formArray["recommendingApprovalID"]);
$improvementsBuildings->setRecommendingApprovalDate($this->formArray["recommendingApprovalDate"]);
$improvementsBuildings->setApprovedBy($this->formArray["approvedByID"]);
$improvementsBuildings->setApprovedByDate($this->formArray["approvedByDate"]);
$improvementsBuildings->setMemoranda($this->formArray["memoranda"]);
$improvementsBuildings->setPostingDate($this->formArray["postingDate"]);
$improvementsBuildings->setLandPin($this->formArray["landPin"]);
$improvementsBuildings->setFoundation($this->formArray["foundation"]);
$improvementsBuildings->setColumnsBldg($this->formArray["columnsBldg"]);
$improvementsBuildings->setBeams($this->formArray["beams"]);
$improvementsBuildings->setTrussFraming($this->formArray["trussFraming"]);
$improvementsBuildings->setRoof($this->formArray["roof"]);
$improvementsBuildings->setExteriorWalls($this->formArray["exteriorWalls"]);
$improvementsBuildings->setFlooring($this->formArray["flooring"]);
$improvementsBuildings->setDoors($this->formArray["doors"]);
$improvementsBuildings->setCeiling($this->formArray["ceiling"]);
$improvementsBuildings->setStructuralTypes($this->formArray["structuralTypes"]);
$improvementsBuildings->setBuildingClassification($this->formArray["buildingClassification"]);
$improvementsBuildings->setBuildingPermit($this->formArray["buildingPermit"]);
$improvementsBuildings->setBuildingAge($this->formArray["buildingAge"]);
$improvementsBuildings->setCctNumber($this->formArray["cctNumber"]);
$improvementsBuildings->setNumberOfStoreys($this->formArray["numberOfStoreys"]);
$improvementsBuildings->setWindows($this->formArray["windows"]);
$improvementsBuildings->setStairs($this->formArray["stairs"]);
$improvementsBuildings->setPartition($this->formArray["partition"]);
$improvementsBuildings->setWallFinish($this->formArray["wallFinish"]);
$improvementsBuildings->setElectrical($this->formArray["electrical"]);
$improvementsBuildings->setToiletAndBath($this->formArray["toiletAndBath"]);
$improvementsBuildings->setPlumbingSewer($this->formArray["plumbingSewer"]);
$improvementsBuildings->setFixtures($this->formArray["fixtures"]);
$improvementsBuildings->setDateConstructed($this->formArray["dateConstructed"]);
$improvementsBuildings->setDateOccupied($this->formArray["dateOccupied"]);
$improvementsBuildings->setDateCompleted($this->formArray["dateCompleted"]);
$improvementsBuildings->setAreaOfGroundFloor($this->formArray["areaOfGroundFloor"]);
$improvementsBuildings->setTotalBuildingArea($this->formArray["totalBuildingArea"]);
$improvementsBuildings->setUnitValue($this->formArray["unitValue"]);
$improvementsBuildings->setBuildingCoreAndAdditionalItems($this->formArray["buildingCoreAndAdditionalItems"]);
$improvementsBuildings->setAddItems($this->formArray["addItems"]);
$improvementsBuildings->setDepreciationRate($this->formArray["depreciationRate"]);
$improvementsBuildings->setAccumulatedDepreciation($this->formArray["accumulatedDepreciation"]);
$improvementsBuildings->setDepreciatedMarketValue($this->formArray["depreciatedMarketValue"]);
$improvementsBuildings->setCreatedBy($this->userID);
$improvementsBuildings->setModifiedBy($this->userID);
$improvementsBuildings->setDomDocument();
$doc = $improvementsBuildings->getDomDocument();
$xmlStr = $doc->dump_mem(true);
//echo $xmlStr;
$ret = $ImprovementsBuildingsEncode->updateImprovementsBuildings($xmlStr);
if (!($ret = $ImprovementsBuildingsEncode->updateImprovementsBuildings($xmlStr))) {
exit("error update" . $ret);
}
}
}
} else {
$address = new Address();
//$address->setAddressID($this->formArray["addressID"]);
$address->setNumber($this->formArray["number"]);
$address->setStreet($this->formArray["street"]);
$address->setBarangay($this->formArray["barangay"]);
$address->setDistrict($this->formArray["district"]);
$address->setMunicipalityCity($this->formArray["municipalityCity"]);
$address->setProvince($this->formArray["province"]);
$address->setDomDocument();
$propertyAdministrator = new Person();
//$propertyAdministrator->setPersonID($this->formArray["personID"]);
$propertyAdministrator->setLastName($this->formArray["lastName"]);
$propertyAdministrator->setFirstName($this->formArray["firstName"]);
$propertyAdministrator->setMiddleName($this->formArray["middleName"]);
//$propertyAdministrator->setGender($this->formArray["gender"]);
//$propertyAdministrator->setBirthday($this->birthdate);
//$propertyAdministrator->setMaritalStatus($this->formArray["maritalStatus"]);
//$propertyAdministrator->setTin($this->formArray["tin"]);
$propertyAdministrator->setAddressArray($address);
$propertyAdministrator->setTelephone($this->formArray["telephone"]);
//$propertyAdministrator->setMobileNumber($this->formArray["mobileNumber"]);
$propertyAdministrator->setEmail($this->formArray["email"]);
$propertyAdministrator->setDomDocument();
$improvementsBuildings = new ImprovementsBuildings();
$improvementsBuildings->parseDomDocument($domDoc);
//$improvementsBuildings->setPropertyID($this->formArray["propertyID"]);
$improvementsBuildings->setAfsID($this->formArray["afsID"]);
$improvementsBuildings->setArpNumber($this->formArray["arpNumber"]);
$improvementsBuildings->setPropertyIndexNumber($this->formArray["propertyIndexNumber"]);
$improvementsBuildings->setPropertyAdministrator($propertyAdministrator);
$improvementsBuildings->setVerifiedBy($this->formArray["verifiedByID"]);
$improvementsBuildings->setPlottingsBy($this->formArray["plottingsByID"]);
$improvementsBuildings->setNotedBy($this->formArray["notedByID"]);
$improvementsBuildings->setMarketValue($this->formArray["marketValue"]);
$improvementsBuildings->setKind($this->formArray["kind"]);
$improvementsBuildings->setActualUse($this->formArray["actualUse"]);
$improvementsBuildings->setAdjustedMarketValue($this->formArray["adjustedMarketValue"]);
$improvementsBuildings->setAssessmentLevel($this->formArray["assessmentLevel"]);
$improvementsBuildings->setAssessedValue($this->formArray["assessedValue"]);
$improvementsBuildings->setPreviousOwner($this->formArray["previousOwner"]);
$improvementsBuildings->setPreviousAssessedValue($this->formArray["previousAssessedValue"]);
$improvementsBuildings->setTaxability($this->formArray["taxability"]);
$improvementsBuildings->setEffectivity($this->formArray["effectivity"]);
$improvementsBuildings->setAppraisedBy($this->formArray["appraisedByID"]);
$improvementsBuildings->setAppraisedByDate($this->formArray["appraisedByDate"]);
$improvementsBuildings->setRecommendingApproval($this->formArray["recommendingApprovalID"]);
$improvementsBuildings->setRecommendingApprovalDate($this->formArray["recommendingApprovalDate"]);
$improvementsBuildings->setApprovedBy($this->formArray["approvedByID"]);
$improvementsBuildings->setApprovedByDate($this->formArray["approvedByDate"]);
$improvementsBuildings->setMemoranda($this->formArray["memoranda"]);
$improvementsBuildings->setPostingDate($this->formArray["postingDate"]);
$improvementsBuildings->setLandPin($this->formArray["landPin"]);
$improvementsBuildings->setFoundation($this->formArray["foundation"]);
$improvementsBuildings->setColumnsBldg($this->formArray["columnsBldg"]);
$improvementsBuildings->setBeams($this->formArray["beams"]);
$improvementsBuildings->setTrussFraming($this->formArray["trussFraming"]);
$improvementsBuildings->setRoof($this->formArray["roof"]);
$improvementsBuildings->setExteriorWalls($this->formArray["exteriorWalls"]);
$improvementsBuildings->setFlooring($this->formArray["flooring"]);
$improvementsBuildings->setDoors($this->formArray["doors"]);
$improvementsBuildings->setCeiling($this->formArray["ceiling"]);
$improvementsBuildings->setStructuralTypes($this->formArray["structuralTypes"]);
$improvementsBuildings->setBuildingClassification($this->formArray["buildingClassification"]);
$improvementsBuildings->setBuildingPermit($this->formArray["buildingPermit"]);
$improvementsBuildings->setBuildingAge($this->formArray["buildingAge"]);
$improvementsBuildings->setCctNumber($this->formArray["cctNumber"]);
$improvementsBuildings->setNumberOfStoreys($this->formArray["numberOfStoreys"]);
$improvementsBuildings->setWindows($this->formArray["windows"]);
$improvementsBuildings->setStairs($this->formArray["stairs"]);
$improvementsBuildings->setPartition($this->formArray["partition"]);
$improvementsBuildings->setWallFinish($this->formArray["wallFinish"]);
$improvementsBuildings->setElectrical($this->formArray["electrical"]);
$improvementsBuildings->setToiletAndBath($this->formArray["toiletAndBath"]);
$improvementsBuildings->setPlumbingSewer($this->formArray["plumbingSewer"]);
$improvementsBuildings->setFixtures($this->formArray["fixtures"]);
$improvementsBuildings->setDateConstructed($this->formArray["dateConstructed"]);
$improvementsBuildings->setDateOccupied($this->formArray["dateOccupied"]);
$improvementsBuildings->setDateCompleted($this->formArray["dateCompleted"]);
$improvementsBuildings->setAreaOfGroundFloor($this->formArray["areaOfGroundFloor"]);
$improvementsBuildings->setTotalBuildingArea($this->formArray["totalBuildingArea"]);
$improvementsBuildings->setUnitValue($this->formArray["unitValue"]);
$improvementsBuildings->setBuildingCoreAndAdditionalItems($this->formArray["buildingCoreAndAdditionalItems"]);
$improvementsBuildings->setAddItems($this->formArray["addItems"]);
$improvementsBuildings->setDepreciationRate($this->formArray["depreciationRate"]);
$improvementsBuildings->setAccumulatedDepreciation($this->formArray["accumulatedDepreciation"]);
$improvementsBuildings->setDepreciatedMarketValue($this->formArray["depreciatedMarketValue"]);
$improvementsBuildings->setCreatedBy($this->userID);
$improvementsBuildings->setModifiedBy($this->userID);
$improvementsBuildings->setDomDocument();
$doc = $improvementsBuildings->getDomDocument();
$xmlStr = $doc->dump_mem(true);
//echo $xmlStr;
$xmlStr = $doc->dump_mem(true);
if (!($ret = $ImprovementsBuildingsEncode->saveImprovementsBuildings($xmlStr))) {
echo "ret=" . $ret;
}
}
$this->formArray["propertyID"] = $ret;
header("location: ImprovementsBuildingsClose.php" . $this->sess->url("") . $this->sess->add_query(array("afsID" => $this->formArray["afsID"])));
exit;
break;
case "cancel":
header("location: ImprovementsBuildingsList.php");
exit;
break;
default:
if (!($firstPropertyID = $this->getFirstPropertyID())) {
$this->tpl->set_block("rptsTemplate", "odID", "odIDBlock");
$this->tpl->set_var("odIDBlock", "");
$this->tpl->set_block("rptsTemplate", "ACK", "ACKBlock");
$this->tpl->set_var("ACKBlock", "");
} else {
$ImprovementsBuildingsDetails = new SoapObject(NCCBIZ . "ImprovementsBuildingsDetails.php", "urn:Object");
if (!($xmlStr = $ImprovementsBuildingsDetails->getImprovementsBuildings($firstPropertyID))) {
echo "xml failed";
} else {
//echo $xmlStr;
if (!($domDoc = domxml_open_mem($xmlStr))) {
$this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock");
$this->tpl->set_var("OwnerListTableBlock", "error xmlDoc");
} else {
$improvementsBuildings = new ImprovementsBuildings();
$improvementsBuildings->parseDomDocument($domDoc);
foreach ($improvementsBuildings as $key => $value) {
switch ($key) {
case "propertyID":
$this->formArray["propertyID"] = "";
break;
case "propertyAdministrator":
if (is_a($value, Person)) {
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value->getBirthday());
$this->formArray["personID"] = $value->getPersonID();
$this->formArray["lastName"] = $value->getLastName();
$this->formArray["firstName"] = $value->getFirstName();
$this->formArray["middleName"] = $value->getMiddleName();
$this->formArray["gender"] = $value->getGender();
$this->formArray["birth_year"] = removePreZero($dateArr["year"]);
$this->formArray["birth_month"] = removePreZero($dateArr["month"]);
$this->formArray["birth_day"] = removePreZero($dateArr["day"]);
$this->formArray["maritalStatus"] = $value->getMaritalStatus();
$this->formArray["tin"] = $value->getTin();
$this->formArray["addressID"] = $value->addressArray[0]->getAddressID();
$this->formArray["number"] = $value->addressArray[0]->getNumber();
$this->formArray["street"] = $value->addressArray[0]->getStreet();
$this->formArray["barangay"] = $value->addressArray[0]->getBarangay();
$this->formArray["district"] = $value->addressArray[0]->getDistrict();
$this->formArray["municipalityCity"] = $value->addressArray[0]->getMunicipalityCity();
$this->formArray["province"] = $value->addressArray[0]->getProvince();
$this->formArray["telephone"] = $value->getTelephone();
$this->formArray["mobileNumber"] = $value->getMobileNumber();
$this->formArray["email"] = $value->getEmail();
} else {
$this->formArray[$key] = "";
}
break;
case "appraisedByDate":
if (true) {
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value);
$this->formArray["as_year"] = removePreZero($dateArr["year"]);
$this->formArray["as_month"] = removePreZero($dateArr["month"]);
$this->formArray["as_day"] = removePreZero($dateArr["day"]);
} else {
$this->formArray[$key] = "";
}
break;
case "recommendingApprovalDate":
if (true) {
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value);
$this->formArray["re_year"] = removePreZero($dateArr["year"]);
$this->formArray["re_month"] = removePreZero($dateArr["month"]);
$this->formArray["re_day"] = removePreZero($dateArr["day"]);
} else {
$this->formArray[$key] = "";
}
break;
case "approvedByDate":
if (true) {
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value);
$this->formArray["av_year"] = removePreZero($dateArr["year"]);
$this->formArray["av_month"] = removePreZero($dateArr["month"]);
$this->formArray["av_day"] = removePreZero($dateArr["day"]);
} else {
$this->formArray[$key] = "";
}
break;
case "dateConstructed":
if (true) {
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value);
$this->formArray["dc_year"] = removePreZero($dateArr["year"]);
$this->formArray["dc_month"] = removePreZero($dateArr["month"]);
$this->formArray["dc_day"] = removePreZero($dateArr["day"]);
} else {
$this->formArray[$key] = "";
}
break;
case "dateOccupied":
if (true) {
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value);
$this->formArray["do_year"] = removePreZero($dateArr["year"]);
$this->formArray["do_month"] = removePreZero($dateArr["month"]);
$this->formArray["do_day"] = removePreZero($dateArr["day"]);
} else {
$this->formArray[$key] = "";
}
break;
case "dateCompleted":
if (true) {
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value);
$this->formArray["dm_year"] = removePreZero($dateArr["year"]);
$this->formArray["dm_month"] = removePreZero($dateArr["month"]);
$this->formArray["dm_day"] = removePreZero($dateArr["day"]);
} else {
$this->formArray[$key] = "";
}
break;
case "arpNumber":
case "propertyIndexNumber":
case "propertyAdministrator":
case "personID":
case "lastName":
case "firstName":
case "middleName":
case "gender":
case "birth_month":
case "birth_day":
case "birth_year":
case "maritalStatus":
case "tin":
case "addressID":
case "number":
case "street":
case "barangay":
case "district":
case "municipalityCity":
case "province":
case "telephone":
case "mobileNumber":
case "email":
case "verifiedByID":
case "verifiedBy":
case "verifiedByName":
case "plottingsByID":
case "plottingsBy":
case "plottingsByName":
case "notedByID":
case "notedBy":
case "notedByName":
case "marketValue":
case "kind":
case "actualUse":
case "adjustedMarketValue":
case "assessmentLevel":
case "assessedValue":
case "previousOwner":
case "previousAssessedValue":
case "taxability":
case "effectivity":
case "appraisedByID":
case "appraisedBy":
case "appraisedByName":
case "appraisedByDate":
case "recommendingApprovalID":
case "recommendingApproval":
case "recommendingApprovalName":
case "recommendingApprovalDate":
case "approvedByID":
case "approvedBy":
case "approvedByName":
case "approvedByDate":
case "memoranda":
case "postingDate":
case "landPin":
case "foundation":
case "columnsBldg":
case "beams":
case "trussFraming":
case "roof":
case "exteriorWalls":
case "flooring":
case "doors":
case "ceiling":
case "structuralTypes":
case "buildingClassification":
case "buildingPermit":
case "buildingAge":
case "cctNumber":
case "numberOfStoreys":
case "windows":
case "stairs":
case "partition":
case "wallFinish":
case "electrical":
case "toiletAndBath":
case "plumbingSewer":
case "fixtures":
case "dateConstructed":
case "dateOccupied":
case "dateCompleted":
case "areaOfGroundFloor":
case "totalBuildingArea":
case "unitValue":
case "buildingCoreAndAdditionalItems":
case "addItems":
case "depreciationRate":
case "accumulatedDepreciation":
case "depreciatedMarketValue":
case "as_month":
case "as_day":
case "as_year":
case "re_month":
case "re_day":
case "re_year":
case "av_month":
case "av_day":
case "av_year":
case "dc_month":
case "dc_day":
case "dc_year":
case "do_month":
case "do_day":
case "do_year":
case "dm_month":
case "dm_day":
case "dm_year":
$this->formArray[$key] = $value;
break;
}
}
}
}
}
}
$this->setForm();
$this->tpl->set_var("Session", $this->sess->url("") . $this->sess->add_query(array("odID" => $this->formArray["odID"], "ownerID" => $this->formArray["ownerID"])));
$this->tpl->parse("templatePage", "rptsTemplate");
$this->tpl->finish("templatePage");
$this->tpl->p("templatePage");
}
public function executeConfirmStudent(sfWebRequest $request)
{
sfContext::getInstance()->set("user", new FakeUser());
//tomo las intancias de las librerias.
$i_identification_type = BaseCustomOptionsHolder::getInstance('IdentificationType');
$i_sex_type = BaseCustomOptionsHolder::getInstance('SexType');
$i_nationality = BaseCustomOptionsHolder::getInstance('Nationality');
$s_lastname = $this->getRequestParameter('apellido');
// Es obligatorio
$s_firstname = $this->getRequestParameter('nombres');
// Es obligatorio
$s_identification_type = $i_identification_type->getIdentificationType($this->getRequestParameter('tipo_documento_id'));
$s_identification_number = $this->getRequestParameter('nro_documento');
$s_sex = $i_sex_type->getSexType($this->getRequestParameter('sexo'));
//Es obligatorio
$s_phone = $this->getRequestParameter('telefono_fijo');
$s_birthdate = $this->getRequestParameter('fecha_nacimiento');
$s_birth_city = $this->getRequestParameter('ciudad_nacimiento_id');
$s_health_coverage_id = $this->getRequestParameter('obra_social_id');
$s_origin_school_id = $request->getParameter('escuela_procedencia_numero');
//domicilio
$s_city = $this->getRequestParameter('domicilio_ciudad_id');
$s_street = $this->getRequestParameter('domicilio_calle');
$s_number = $this->getRequestParameter('domicilio_numero');
$s_floor = $this->getRequestParameter('domicilio_piso');
$s_flat = $this->getRequestParameter('domicilio_departamento');
//Chequeo tutor (madre)
$m_identification_type = $i_identification_type->getIdentificationType($this->getRequestParameter('madre_tipo_documento_id'));
$m_identification_number = $this->getRequestParameter('madre_nro_documento');
$m_firstname = $this->getRequestParameter('madre_nombres');
$m_lastname = $this->getRequestParameter('madre_apellido');
$m_occupation = $this->getRequestParameter('madre_actividad_id');
$m_occupation_category = $this->getRequestParameter('madre_ocupacion_id');
$m_study = $this->getRequestParameter('madre_estudios_id');
$m_email = $this->getRequestParameter('madre_email');
$m_phone = $this->getRequestParameter('madre_telefono_celular');
$m_birthdate = $this->getRequestParameter('madre_fecha_nacimiento');
$m_birth_city = $this->getRequestParameter('madre_ciudad_nacimiento_id');
$m_nationality = $i_nationality->getNationality($this->getRequestParameter('madre_nacionalidad_id'));
$m_is_alive = $this->getRequestParameter('madre_vive');
//chequeo is_alive
if ($m_is_alive == 'S') {
$m_is_alive = true;
} elseif ($m_is_alive == 'N') {
$m_is_alive = false;
}
//domicilio
$m_city = $this->getRequestParameter('madre_domicilio_ciudad_id');
$m_street = $this->getRequestParameter('madre_domicilio_calle');
$m_number = $this->getRequestParameter('madre_domicilio_numero');
$m_floor = $this->getRequestParameter('madre_domicilio_piso');
$m_flat = $this->getRequestParameter('madre_domicilio_departamento');
//Chequeo tutor (padre)
$p_identification_type = $i_identification_type->getIdentificationType($this->getRequestParameter('padre_tipo_documento_id'));
$p_identification_number = $this->getRequestParameter('padre_nro_documento');
$p_firstname = $this->getRequestParameter('padre_nombres');
$p_lastname = $this->getRequestParameter('padre_apellido');
$p_occupation = $this->getRequestParameter('padre_actividad_id');
$p_occupation_category = $this->getRequestParameter('padre_ocupacion_id');
$p_study = $this->getRequestParameter('padre_estudios_id');
$p_email = $this->getRequestParameter('padre_email');
$p_phone = $this->getRequestParameter('padre_telefono_celular');
$p_birthdate = $this->getRequestParameter('padre_fecha_nacimiento');
$p_birth_city = $this->getRequestParameter('padre_ciudad_nacimiento_id');
$p_nationality = $i_nationality->getNationality($this->getRequestParameter('padre_nacionalidad_id'));
$p_is_alive = $this->getRequestParameter('padre_vive');
//chequeo is_alive
if ($p_is_alive == 'S') {
$p_is_alive = true;
} elseif ($p_is_alive == 'N') {
$p_is_alive = false;
}
//domicilio
$p_city = $this->getRequestParameter('padre_domicilio_ciudad_id');
$p_street = $this->getRequestParameter('padre_domicilio_calle');
$p_number = $this->getRequestParameter('padre_domicilio_numero');
$p_floor = $this->getRequestParameter('padre_domicilio_piso');
$p_flat = $this->getRequestParameter('padre_domicilio_departamento');
$data = array();
//chequeo campos obligatorios
if (is_null($s_identification_type) || is_null($s_identification_number) || is_null($s_lastname) || trim($s_lastname) == "" || is_null($s_firstname) || trim($s_firstname) == "" || is_null($s_sex)) {
throw new Exception('Missing data');
} else {
$con = Propel::getConnection();
try {
//chequeo que el alumno no haya sido ingresado en un año anterior (por lista de espera)
$student = StudentPeer::retrieveByDocumentTypeAndNumber($s_identification_type, $s_identification_number);
$con->beginTransaction();
if (is_null($student)) {
//el alumno no existe. Creo la persona y el alumno
$s_person = new Person();
$s_person->setLastname($s_lastname);
$s_person->setFirstname($s_firstname);
$s_person->setSex($s_sex);
$s_person->setIdentificationType($s_identification_type);
$s_person->setIdentificationNumber($s_identification_number);
$s_person->setPhone($s_phone);
$s_person->setBirthdate($s_birthdate);
$s_person->setIsActive(true);
$s_person->setBirthCity($s_birth_city);
$s_person->save(Propel::getConnection());
$student = new Student();
$student->setPerson($s_person);
$student->setGlobalFileNumber('888888');
//Nro de legajo??
$student->setOriginSchoolId($s_origin_school_id);
$student->setHealthCoverageId($s_health_coverage_id);
$student->save(Propel::getConnection());
/* Recupero department, state ,country*/
if (!is_null($s_birth_city)) {
$city = CityPeer::retrieveByPk($s_birth_city);
$student->getPerson()->setBirthCountry($city->getDepartment()->getState()->getCountry()->getId());
$student->getPerson()->setBirthState($city->getDepartment()->getState()->getId());
$student->getPerson()->setBirthDepartment($city->getDepartment()->getId());
}
//chequeo domicilio
if (!is_null($s_city) || !is_null($s_street) || !is_null($s_number) || !is_null($s_floor) || is_null($s_flat)) {
$a = new Address();
$a->setCityId($s_city);
$a->setStreet($s_street);
$a->setNumber($s_number);
$a->setFloor($s_floor);
$a->setFlat($s_flat);
$student->getPerson()->setAddress($a);
$student->getPerson()->save(Propel::getConnection());
$data['message'] = "El alumno ha sido confirmado.";
}
} else {
//seteo isActive
$student->getPerson()->setIsActive(true);
$student->save(Propel::getConnection());
$data['message'] = "El alumno fue actualizado correctamente.";
}
//chequeo campos obligatorios
if (!is_null($m_identification_type) && !is_null($m_identification_number) && !is_null($m_lastname) && trim($m_lastname) != "" && !is_null($m_firstname) && trim($m_firstname) != "") {
//busco si ya existe.
$m_tutor = TutorPeer::findByDocumentTypeAndNumber($m_identification_type, $m_identification_number);
if (is_null($m_tutor)) {
//el tutor no existe. Lo creo
$m_person = new Person();
$m_person->setLastname($m_lastname);
$m_person->setFirstname($m_firstname);
$m_person->setIdentificationType($m_identification_type);
$m_person->setIdentificationNumber($m_identification_number);
$m_person->setSex(SexType::FEMALE);
$m_person->setPhone($m_phone);
$m_person->setEmail($m_email);
$m_person->setBirthdate($m_birthdate);
$m_person->setIsActive(true);
$m_person->setBirthCity($m_birth_city);
$m_person->save(Propel::getConnection());
$m_tutor = new Tutor();
$m_tutor->setPerson($m_person);
$m_tutor->setOccupationId($m_occupation);
$m_tutor->setOccupationCategoryId($m_occupation_category);
$m_tutor->setStudyId($m_study);
//coincide con la tabla sga_tipos_est_cur
$m_tutor->setNationality($m_nationality);
$m_tutor->setIsAlive($m_is_alive);
$m_tutor->save(Propel::getConnection());
/* Recupero department, state ,country*/
if (!is_null($m_birth_city)) {
$m_city = CityPeer::retrieveByPk($m_birth_city);
$m_tutor->getPerson()->setBirthCountry($m_city->getDepartment()->getState()->getCountry()->getId());
$m_tutor->getPerson()->setBirthState($m_city->getDepartment()->getState()->getId());
$m_tutor->getPerson()->setBirthDepartment($m_city->getDepartment()->getId());
}
//chequeo domicilio
if (!is_null($m_city) || !is_null($m_street) || !is_null($m_number) || !is_null($m_floor) || is_null($m_flat)) {
$a = new Address();
$a->setCityId($m_birth_city);
$a->setStreet($m_street);
$a->setNumber($m_number);
$a->setFloor($m_floor);
$a->setFlat($m_flat);
$m_tutor->getPerson()->setAddress($a);
$m_tutor->getPerson()->save(Propel::getConnection());
}
} else {
$data['info'] = "El tutor con " . $i_identification_type->getStringFor($m_identification_type) . " " . $m_identification_number;
}
$st = StudentTutorPeer::retrieveByStudentAndTutor($student, $m_tutor);
if (is_null($st)) {
//datos de tutor(madre)
$student_tutor = new StudentTutor();
$student_tutor->setStudent($student);
$student_tutor->setTutor($m_tutor);
$student_tutor->save(Propel::getConnection());
$m_tutor->addStudentTutor($student_tutor);
$m_tutor->save(Propel::getConnection());
}
}
//chequeo campos obligatorios
if (!is_null($p_identification_type) && !is_null($p_identification_number) && !is_null($p_lastname) && trim($p_lastname) != "" && !is_null($p_firstname) && trim($p_firstname) != "") {
//busco si ya existe.
$tutor = TutorPeer::findByDocumentTypeAndNumber($p_identification_type, $p_identification_number);
if (is_null($tutor)) {
//el tutor no existe. Lo creo
$p_person = new Person();
$p_person->setLastname($p_lastname);
$p_person->setFirstname($p_firstname);
$p_person->setIdentificationType($p_identification_type);
$p_person->setIdentificationNumber($p_identification_number);
$p_person->setSex(SexType::MALE);
$p_person->setPhone($p_phone);
$p_person->setEmail($p_email);
$p_person->setBirthdate($p_birthdate);
$p_person->setIsActive(true);
$p_person->setBirthCity($p_birth_city);
$p_person->save(Propel::getConnection());
$tutor = new Tutor();
$tutor->setPerson($p_person);
$tutor->setOccupationId($p_occupation);
$tutor->setOccupationCategoryId($p_occupation_category);
$tutor->setStudyId($p_study);
//coincide con la tabla sga_tipos_est_cur
$tutor->setNationality($p_nationality);
$tutor->save(Propel::getConnection());
/* Recupero department, state ,country*/
if (!is_null($p_birth_city)) {
$p_city = CityPeer::retrieveByPk($p_birth_city);
$tutor->getPerson()->setBirthCountry($p_city->getDepartment()->getState()->getCountry()->getId());
$tutor->getPerson()->setBirthState($p_city->getDepartment()->getState()->getId());
$tutor->getPerson()->setBirthDepartment($p_city->getDepartment()->getId());
}
//chequeo domicilio
if (!is_null($p_city) || !is_null($p_street) || !is_null($p_number) || !is_null($p_floor) || is_null($p_flat)) {
$a = new Address();
$a->setCityId($p_birth_city);
$a->setStreet($p_street);
$a->setNumber($p_number);
$a->setFloor($p_floor);
$a->setFlat($p_flat);
$tutor->getPerson()->setAddress($a);
$tutor->getPerson()->save(Propel::getConnection());
}
if (!is_null($data['info'])) {
$data['info'] = $data['info'] . " ya existe en el sistema. Por favor actualice los datos.";
}
} else {
if (!is_null($data['info'])) {
$data['info'] = "Los tutores con " . $i_identification_type->getStringFor($m_identification_type) . " " . $m_identification_number . " y " . $i_identification_type->getStringFor($p_identification_type) . " " . $p_identification_number . " ya existen en el sistema. Por favor actualice los datos.";
} else {
$data['info'] = "El tutor con " . $i_identification_type->getStringFor($p_identification_type) . " " . $p_identification_number . " ya existe en el sistema. Por favor actualice los datos.";
}
}
//datos de tutor(padre)
$st = StudentTutorPeer::retrieveByStudentAndTutor($student, $tutor);
if (is_null($st)) {
$student_tutor = new StudentTutor();
$student_tutor->setStudent($student);
$student_tutor->setTutor($tutor);
$student_tutor->save(Propel::getConnection());
$tutor->addStudentTutor($student_tutor);
$tutor->save(Propel::getConnection());
}
}
$con->commit();
} catch (PropelException $e) {
$con->rollBack();
throw $e;
}
}
$this->data = $data;
$this->getResponse()->setHttpHeader('Content-type', 'application/json');
$this->getResponse()->setContent(json_encode($data));
$this->setLayout(false);
}
$zip = array_key_exists("zip", $_REQUEST) ? $_REQUEST["zip"] : "";
$country = array_key_exists("country", $_REQUEST) ? $_REQUEST["country"] : "";
$url = array_key_exists("url", $_REQUEST) ? $_REQUEST["url"] : "";
$biography = array_key_exists("biography", $_REQUEST) ? $_REQUEST["biography"] : "";
$isPublic = array_key_exists("ispublic", $_REQUEST) ? $_REQUEST["ispublic"] : "";
$newPerson = new Person();
$newPerson->setUid($userId);
$newPerson->setFirstName($firstname);
$newPerson->setLastName($lastname);
$newPerson->setTitle($title);
$newPerson->setInstitution($institution);
$newPerson->setCity($city);
$newPerson->setState($state);
$newPerson->setZip($zip);
$newPerson->setCountry($country);
$newPerson->setEmail($email);
$newPerson->setUrl($url);
$newPerson->setBiography($biography);
$newPerson->setIsPublic($isPublic);
if (!$pHandler->updateProfile($newPerson)) {
$statusStr = "Profile update failed!";
}
$person = $pHandler->getPerson();
if ($person->getIsTaxonomyEditor()) {
$tabIndex = 3;
} else {
$tabIndex = 2;
}
} elseif ($action == "Change Password") {
$newPwd = $_REQUEST["newpwd"];
$updateStatus = false;
public static function getPersons()
{
$dados = Database::ReadAll("person", "*");
if (!$dados) {
return '';
}
foreach ($dados as $dado) {
$person = new Person();
$person->setId($dado['ID_PERSON']);
$person->setName($dado['NAME_PERSON']);
$person->setEmail($dado['EMAIL']);
$person->setAge($dado['AGE']);
$person->setSex($dado['SEX']);
$person->setPhone($dado['PHONE']);
$person->setOperator($dado['OPERATOR']);
$person->setMaritalStatus($dado['MARITAL_STATUS']);
$person->setChildren($dado['CHILDREN']);
$religion = Religion::getReligion("WHERE id_religion = " . $dado['ID_RELIGION']);
$person->setReligion($religion);
$address = Address::getAddress("AND id_address = " . $dado['ID_ADDRESS']);
$person->setAddress($address);
$login = Login::getLogin($dado['ID_PERSON']);
$person->setLogin($login);
$persons[] = $person;
}
return $persons;
}
$address1->setNumber("unit 2415 Megaplaza Building");
$address1->setStreet("ADB Avenue corner Garnett Street");
$address1->setBarangay("Barangay San Antonio");
$address1->setDistrict("Ortigas Center");
$address1->setMunicipalityCity("Pasig City");
$address1->setProvince("Metro Manila");
$address1->setDomDocument();
$person = new Person();
//$person->setPersonID(126);
$person->setFirstName("Nelson Juan");
$person->setMiddleName("Miranda");
$person->setLastName(date("H:i:s"));
$person->setGender("male");
$person->setBirthday("1977/07/09");
$person->setMaritalStatus("single");
$person->setTin("1234567890");
$person->setTelephone("026584746");
$person->setMobileNumber("09175302791");
$person->setEmail("*****@*****.**");
$person->setAddressArray($address);
$person->setAddressArray($address1);
$person->setDomDocument();
$domDoc = $person->getDomDocument();
$xmlStr = $domDoc->dump_mem(true);
$obj = new PersonEncode();
//echo "hello<br>";
echo $xmlStr;
//echo $obj->updatePerson($xmlStr);
echo $obj->savePerson($xmlStr);
//echo $obj->getPersonDetails(1);
//*/
public function register($postArr)
{
$status = false;
$firstName = $postArr['firstname'];
$lastName = $postArr['lastname'];
if ($postArr['institution'] && !trim(strpos($postArr['institution'], ' ')) && preg_match('/[a-z]+[A-Z]+[a-z]+[A-Z]+/', $postArr['institution'])) {
if ($postArr['title'] && !trim(strpos($postArr['title'], ' ')) && preg_match('/[a-z]+[A-Z]+[a-z]+[A-Z]+/', $postArr['title'])) {
return false;
}
}
$person = new Person();
$person->setPassword($postArr['pwd']);
$person->setUserName($this->userName);
$person->setFirstName($firstName);
$person->setLastName($lastName);
$person->setTitle($postArr['title']);
$person->setInstitution($postArr['institution']);
$person->setCity($postArr['city']);
$person->setState($postArr['state']);
$person->setZip($postArr['zip']);
$person->setCountry($postArr['country']);
$person->setEmail($postArr['emailaddr']);
$person->setUrl($postArr['url']);
$person->setBiography($postArr['biography']);
$person->setIsPublic(isset($postArr['ispublic']) ? 1 : 0);
//Add to users table
$fields = 'INSERT INTO users (';
$values = 'VALUES (';
$fields .= 'firstname ';
$values .= '"' . $this->cleanInStr($person->getFirstName()) . '"';
$fields .= ', lastname';
$values .= ', "' . $this->cleanInStr($person->getLastName()) . '"';
if ($person->getTitle()) {
$fields .= ', title';
$values .= ', "' . $this->cleanInStr($person->getTitle()) . '"';
}
if ($person->getInstitution()) {
$fields .= ', institution';
$values .= ', "' . $this->cleanInStr($person->getInstitution()) . '"';
}
if ($person->getDepartment()) {
$fields .= ', department';
$values .= ', "' . $this->cleanInStr($person->getDepartment()) . '"';
}
if ($person->getAddress()) {
$fields .= ', address';
$values .= ', "' . $this->cleanInStr($person->getAddress()) . '"';
}
if ($person->getCity()) {
$fields .= ', city';
$values .= ', "' . $this->cleanInStr($person->getCity()) . '"';
}
$fields .= ', state';
$values .= ', "' . $this->cleanInStr($person->getState()) . '"';
$fields .= ', country';
$values .= ', "' . $this->cleanInStr($person->getCountry()) . '"';
if ($person->getZip()) {
$fields .= ', zip';
$values .= ', "' . $this->cleanInStr($person->getZip()) . '"';
}
if ($person->getPhone()) {
$fields .= ', phone';
$values .= ', "' . $this->cleanInStr($person->getPhone()) . '"';
}
if ($person->getEmail()) {
$fields .= ', email';
$values .= ', "' . $this->cleanInStr($person->getEmail()) . '"';
}
if ($person->getUrl()) {
$fields .= ', url';
$values .= ', "' . $person->getUrl() . '"';
}
if ($person->getBiography()) {
$fields .= ', biography';
$values .= ', "' . $this->cleanInStr($person->getBiography()) . '"';
}
if ($person->getIsPublic()) {
$fields .= ', ispublic';
$values .= ', ' . $person->getIsPublic();
}
$sql = $fields . ') ' . $values . ')';
//echo "SQL: ".$sql;
$editCon = $this->getConnection('write');
if ($editCon->query($sql)) {
$person->setUid($editCon->insert_id);
$this->uid = $person->getUid();
//Add userlogin
$sql = 'INSERT INTO userlogin (uid, username, password) ' . 'VALUES (' . $person->getUid() . ', "' . $this->cleanInStr($person->getUserName()) . '", PASSWORD("' . $this->cleanInStr($person->getPassword()) . '"))';
if ($editCon->query($sql)) {
$status = true;
//authenicate
$this->userName = $person->getUserName();
$this->displayName = $person->getFirstName();
$this->reset();
$this->setCookies();
} else {
$this->errorStr = 'FAILED: Unable to create user.<div style="margin-left:55px;">Please contact system administrator for assistance.</div>';
}
}
$editCon->close();
return $status;
}
public function executeStepSave(sfWebRequest $request)
{
$passenger_session_step5 = $this->getUser()->getAttribute('passangers_step5');
if (!$passenger_session_step5) {
return $this->forward('passanger', 'step5_4');
}
//save Person data
$person = new Person();
$person->setTitle($passenger_session_step5['title']);
$person->setFirstName($passenger_session_step5['firstname']);
$person->setLastName($passenger_session_step5['lastname']);
$person->setAddress1($passenger_session_step5['address1']);
$person->setAddress2($passenger_session_step5['address2']);
$person->setCity($passenger_session_step5['city']);
$person->setCounty($passenger_session_step5['county']);
$person->setState($passenger_session_step5['state']);
$person->setCountry($passenger_session_step5['country']);
$person->setZipcode($passenger_session_step5['zipcode']);
$person->setDayPhone($passenger_session_step5['day_phone']);
$person->setDayComment($passenger_session_step5['day_comment']);
$person->setEveningPhone($passenger_session_step5['eve_phone']);
$person->setEveningComment($passenger_session_step5['eve_comment']);
$person->setMobilePhone($passenger_session_step5['mobile_phone']);
$person->setMobileComment($passenger_session_step5['mobile_comment']);
$person->setPagerPhone($passenger_session_step5['pager_phone']);
$person->setPagerComment($passenger_session_step5['pager_comment']);
$person->setOtherPhone($passenger_session_step5['other_comment']);
$person->setOtherComment($passenger_session_step5['other_comment']);
$person->setFaxPhone1($passenger_session_step5['fax_phone1']);
$person->setFaxComment1($passenger_session_step5['fax_comment1']);
$person->setAutoFax($passenger_session_step5['auto_fax']);
$person->setFaxPhone2($passenger_session_step5['fax_phone2']);
$person->setFaxComment2($passenger_session_step5['fax_comment2']);
$person->setEmail($passenger_session_step5['email']);
$person->setEmailTextOnly($passenger_session_step5['textonly']);
$person->setEmailBlocked($passenger_session_step5['emailblocked']);
$person->setComment($passenger_session_step5['comment']);
$person->setBlockMailings($passenger_session_step5['blockmailings']);
$person->setNewsletter($passenger_session_step5['newsletter']);
$person->setGender($passenger_session_step5['gender']);
$person->setDeceased($passenger_session_step5['deceased']);
$person->setDeceasedComment($passenger_session_step5['deceased_comment']);
$person->setSecondaryEmail($passenger_session_step5['secemail']);
$person->setDeceasedDate($passenger_session_step5['deceased_date']);
$person->setMiddleName($passenger_session_step5['middlename']);
$person->setSuffix($passenger_session_step5['suffix']);
$person->setNickname($passenger_session_step5['nickname']);
$person->setVeteran($passenger_session_step5['military']);
$person->save();
//save Passenger data
$passenger = new Passenger();
$passenger->setPersonId($person->getId());
if ($passenger_session_step5['passenger_type_id'] == 0) {
$passenger->setPassengerTypeId(null);
} else {
$passenger->setPassengerTypeId($passenger_session_step5['passenger_type_id']);
}
$passenger->setParent($passenger_session_step5['parent']);
$passenger->setDateOfBirth($passenger_session_step5['date_of_birth']);
$passenger->setWeight($passenger_session_step5['weight']);
$passenger->setIllness($passenger_session_step5['illness']);
$passenger->setPassengerIllnessCategoryId($passenger_session_step5['passenger_illness_category_id']);
$passenger->setLanguageSpoken($passenger_session_step5['language_spoken']);
$passenger->setBestContactMethod($passenger_session_step5['best_contact_method']);
$passenger->setFinancial($passenger_session_step5['facility_name']);
$passenger->setPublicConsiderations($passenger_session_step5['public_considerations']);
$passenger->setPrivateConsiderations($passenger_session_step5['private_considerations']);
$passenger->setGroundTransportationComment($passenger_session_step5['ground_transportation_comment']);
$passenger->setTravelHistoryNotes($passenger_session_step5['travel_history_notes']);
$passenger->setReleasingPhysician($passenger_session_step5['releasing_physician']);
$passenger->setReleasingPhone($passenger_session_step5['releasing_phone']);
$passenger->setReleasingFax1($passenger_session_step5['releasing_fax1']);
$passenger->setReleasingFax1Comment($passenger_session_step5['releasing_fax1_comment']);
$passenger->setReleasingEmail($passenger_session_step5['releasing_email']);
$passenger->setNeedMedicalRelease($passenger_session_step5['need_medical_release']);
$passenger->setMedicalReleaseRequested($passenger_session_step5['medical_release_requested']);
$passenger->setMedicalReleaseReceived($passenger_session_step5['medical_release_received']);
$passenger->setTreatingPhysician($passenger_session_step5['treating_physician']);
$passenger->setTreatingPhone($passenger_session_step5['treating_phone']);
$passenger->setTreatingFax1($passenger_session_step5['treating_fax1']);
$passenger->setTreatingFax1Comment($passenger_session_step5['treating_fax1_comment']);
$passenger->setTreatingEmail($passenger_session_step5['treating_email']);
$passenger->setLanguageSpoken($passenger_session_step5['language_spoken']);
$passenger->setLodgingPhone($passenger_session_step5['lodging_phone']);
$passenger->setLodgingPhoneComment($passenger_session_step5['lodging_phone_comment']);
$passenger->setFacilityName($passenger_session_step5['facility_name']);
$passenger->setFacilityPhone($passenger_session_step5['facility_phone']);
$passenger->setFacilityPhoneComment($passenger_session_step5['facility_phone_comment']);
$passenger->setEmergencyContactName($passenger_session_step5['emergency_contact_name']);
$passenger->setEmergencyContactPrimaryPhone($passenger_session_step5['emergency_contact_primary_phone']);
$passenger->setEmergencyContactPrimaryComment($passenger_session_step5['emergency_contact_primary_comment']);
$passenger->setEmergencyContactSecondaryPhone($passenger_session_step5['emergency_contact_secondary_phone']);
$passenger->setEmergencyContactSecondaryComment($passenger_session_step5['emergency_contact_secondary_comment']);
$passenger->save();
$key = $passenger_session_step5['key'];
$this->getUser()->setFlash('success', 'Passenger information has been successfully created!');
$this->redirect('@passenger');
//removing used session like passenger data
unset($passenger_session_step5p[$key]);
$this->getUser()->setAttribute('passanger_step5', $passenger_session_step5);
}
/**
* @copyright 2011 City of Bloomington, Indiana
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.txt
* @author Cliff Ingham <*****@*****.**>
*/
include '../../../configuration.inc';
include './migrationConfig.inc';
$pdo = new PDO(MIGRATION_DSN, MIGRATION_USER, MIGRATION_PASS);
$sql = "select distinct\r\n\t\tfirstname,lastname,email,phone,address,city,state,zip\t\t\r\n\t\tfrom contacts";
$result = $pdo->query($sql);
foreach ($result->fetchAll(PDO::FETCH_ASSOC) as $row) {
$person = new Person();
$person->setFirstname(ucwords(strtolower($row['firstname'])));
$person->setPhone($row['phone']);
$person->setLastname(ucwords(strtolower($row['lastname'])));
$person->setEmail($row['email']);
if ($row['address'] && strtolower($row['city']) == 'bloomington') {
$row['address'] = preg_replace('/[^a-zA-Z0-9\\-\\&\\s\'\\/]/', '', $row['address']);
$url = new URL(ADDRESS_SERVICE . '/addresses/parse.php');
$url->format = 'xml';
$url->address = $row['address'];
$parsed = new SimpleXMLElement($url, null, true);
if ($parsed->street_number && $parsed->street_name) {
// Look up their address in Master Address
$url = new URL(ADDRESS_SERVICE . '/home.php');
$url->queryType = 'address';
$url->format = 'xml';
$url->query = $row['address'];
echo $url->query . " ==> ";
$xml = new SimpleXMLElement($url, null, true);
if (count($xml) == 1) {
$c = new City();
$c->setName('San Francisco');
$c->save();
$s = new Student();
$s->setCity($c);
$s->setEmail('*****@*****.**');
$s->setName('Mateus Fornari');
$s->setNumber('123456');
var_dump($s->save());
$course = new Course();
$course->setDescription('PHP Programming');
$course->save();
$s->addCourses($course);
$p = new Person();
$p->setCity($c);
$p->setEmail('*****@*****.**');
$p->setName('Other Person');
$p->save();
$b = new Book();
$b->setAuthor($p);
$b->setTitle('PHP Book');
$b->save();
Hypersistence::commit();
//LOAD
$p = new Person();
$p->setId(1);
$p->load();
echo $p->getName() . "\n";
$books = $p->getBooks()->execute();
foreach ($books as $b) {
echo $b->getTitle() . "\n";
$history->setActionDate($row['insp_date']);
$history->setNotes("{$row['action_taken']}\n{$row['next_action']}");
if ($row['username']) {
try {
$person = new Person($row['username']);
$history->setEnteredByPerson($person);
$history->setActionPerson($person);
} catch (Exception $e) {
$person = new Person();
$person->setUsername($row['username']);
$person->setAuthenticationMethod('LDAP');
try {
$ldap = new LDAPEntry($person->getUsername());
$person->setFirstname($ldap->getFirstname());
$person->setLastname($ldap->getLastname());
$person->setEmail($ldap->getEmail());
$person->save();
} catch (Exception $e) {
$person = new Person();
$person->setFirstname(strtolower($row['username']));
$person->save();
}
$history->setEnteredByPerson($person);
$history->setActionPerson($person);
}
} elseif ($row['needed'] || $row['existing']) {
$name = $row['needed'] ? $row['needed'] : $row['existing'];
list($firstname, $lastname) = explode(' ', $name);
$list = new PersonList(array('firstname' => ucwords(strtolower($firstname)), 'lastname' => ucwords(strtolower($lastname))));
if (count($list)) {
$list->next();
$peopleInfoXML = file_get_contents($baseURL . $searchURL, false, $context) or die("The mospace server might failed\n");
//echo $baseURL.$searchURL;
$peopleInfoXMLObject = simplexml_load_string($peopleInfoXML, null, LIBXML_NOCDATA);
if ($peopleInfoXMLObject['found'] == 0 || $peopleInfoXMLObject['found'] >= 49) {
continue;
}
//echo "<pre>";
///print_r($peopleInfoXMLObject->Person);
//echo "</pre>";
$personObject = new Person();
$personObject->setLastName($parser->getLast());
$personObject->setFirstName($parser->getFirst());
//For test purpose only
//echo $personObject->getLastName().", ".$personObject->getFirstName()."; ";
$personObject->setDepartment($peopleInfoXMLObject->Person->Department);
$personObject->setTitle($peopleInfoXMLObject->Person->Title);
//$personObject->setImageURL("http://freelanceme.net/Images/default%20profile%20picture.png");
if ($peopleInfoXMLObject->Person->Phone != null) {
$personObject->setPhone($peopleInfoXMLObject->Person->Phone);
}
$personObject->setEmail($peopleInfoXMLObject->Person->{'E-mail'});
$personObject->insertToDatabase();
}
echo "\n";
//For testing purpose only
//if($i++ > 10){
//break;
//}
}
}
}
/**
* missionRequests save all data into corresponding tables
* CODE:mission_request_create
*/
public function executeSave(sfWebRequest $request)
{
# security
if (!$this->getUser()->hasCredential(array('Administrator', 'Staff', 'Coordinator'), false)) {
$this->getUser()->setFlash("warning", 'You don\'t have permission to access this url ' . $request->getReferer());
$this->redirect('dashboard/index');
}
$miss_req_session = $this->getUser()->getAttribute('miss_req');
if (!$miss_req_session) {
return $this->forward('passenger', 'step3');
}
//set Requester Person
$req_person = new Person();
$req_person->setFirstName($miss_req_session->getReqFirstname());
$req_person->setLastName($miss_req_session->getReqLastname());
$req_person->setAddress1($miss_req_session->getReqAddress1());
$req_person->setAddress2($miss_req_session->getReqAddress2());
$req_person->setCity($miss_req_session->getReqCity());
$req_person->setCounty($miss_req_session->getReqCounty());
$req_person->setState($miss_req_session->getReqState());
$req_person->setCountry($miss_req_session->getReqCountry());
$req_person->setZipcode($miss_req_session->getReqZipcode());
$req_person->setEmail($miss_req_session->getReqEmail());
$req_person->setSecondaryEmail($miss_req_session->getReqSecondaryEmail());
$req_person->setPagerEmail($miss_req_session->getReqPagerEmail());
$req_person->setDayPhone($miss_req_session->getReqDayPhone());
$req_person->setDayComment($miss_req_session->getReqDayComment());
$req_person->setEveningPhone($miss_req_session->getReqEvePhone());
$req_person->setEveningComment($miss_req_session->getReqEveComment());
$req_person->setMobilePhone($miss_req_session->getReqMobilePhone());
$req_person->setMobileComment($miss_req_session->getReqMobileComment());
$req_person->setPagerPhone($miss_req_session->getReqPagerPhone());
$req_person->setPagerComment($miss_req_session->getReqPagerComment());
$req_person->setOtherPhone($miss_req_session->getReqOtherPhone());
$req_person->setOtherComment($miss_req_session->getReqOtherComment());
$req_person->save();
//end of Requester Person
// set Requester Agency
$agency = AgencyPeer::getByNamePhone(trim($miss_req_session->getAgencyName()));
if ($agency) {
# nothing
} else {
$agency = new Agency();
$agency->setName(trim($miss_req_session->getAgencyName()));
$agency->save();
}
//set Requester
$requester = new Requester();
$requester->setPersonId($req_person->getId());
$requester->setAgencyId($agency->getId());
//$requester->setDischarge($miss_req_session->getReqDischarge());
$requester->save();
if (isset($miss_req_session->passenger_id)) {
$passenger = PassengerPeer::retrieveByPK($miss_req_session->passenger_id);
if (!$passenger instanceof Passenger) {
$passenger = new Passenger();
}
} else {
$passenger = new Passenger();
}
if ($passenger->isNew()) {
$person = new Person();
} else {
$person = $passenger->getPerson();
}
//set Person to Passenger
$person->setTitle($miss_req_session->getPassTitle());
$person->setFirstName($miss_req_session->getPassFirstName());
$person->setLastName($miss_req_session->getPassLastName());
$person->setGender($miss_req_session->getPassGender());
$person->setAddress1($miss_req_session->getPassAddress1());
$person->setAddress2($miss_req_session->getPassAddress2());
$person->setCity($miss_req_session->getPassCity());
$person->setState($miss_req_session->getPassState());
$person->setZipcode($miss_req_session->getPassZipcode());
$person->setCountry($miss_req_session->getPassCountry());
$person->setEmail($miss_req_session->getPassEmail());
$person->setDayPhone($miss_req_session->getPassDayPhone());
$person->setDayComment($miss_req_session->getPassDayComment());
$person->setEveningPhone($miss_req_session->getPassEvePhone());
$person->setEveningComment($miss_req_session->getPassEveComment());
$person->setMobilePhone($miss_req_session->getPassMobilePhone());
$person->setMobileComment($miss_req_session->getPassMobileComment());
$person->setPagerPhone($miss_req_session->getPassPagerPhone());
$person->setPagerComment($miss_req_session->getPassPagerComment());
$person->setOtherPhone($miss_req_session->getPassOtherPhone());
$person->setOtherComment($miss_req_session->getPassOtherComment());
$person->save();
//set Passenger
$passenger->setPersonId($person->getId());
$passenger->setPassengerTypeId($miss_req_session->getPassType());
$passenger->setDateOfBirth($miss_req_session->getPassDateOfBirth());
$passenger->setIllness($miss_req_session->getIllness());
$passenger->setFinancial($miss_req_session->getFinancial());
$passenger->setPublicConsiderations($miss_req_session->getPassPublicCons());
$passenger->setPrivateConsiderations($miss_req_session->getPassPrivateCons());
$passenger->setReleasingPhysician($miss_req_session->getReleasingPhysician());
$passenger->setReleasingPhone($miss_req_session->getReleasePhone());
$passenger->setReleasingFax1($miss_req_session->getReleaseFax());
$passenger->setReleasingFax1Comment($miss_req_session->getReleaseFaxComment());
$passenger->setLodgingName($miss_req_session->getLodgingName());
$passenger->setLodgingPhone($miss_req_session->getLodgingPhone());
$passenger->setLodgingPhoneComment($miss_req_session->getLodgingPhoneComment());
$passenger->setFacilityName($miss_req_session->getFacilityName());
$passenger->setFacilityPhone($miss_req_session->getFacilityPhone());
$passenger->setFacilityPhoneComment($miss_req_session->getFacilityPhoneComment());
$passenger->setReleasingEmail($miss_req_session->getReleaseEmail());
$passenger->setTreatingPhysician($miss_req_session->getTreatingPhysician());
$passenger->setTreatingPhone($miss_req_session->getTreatingPhone());
$passenger->setTreatingFax1($miss_req_session->getTreatingFax());
$passenger->setTreatingFax1Comment($miss_req_session->getTreatingFaxComment());
$passenger->setTreatingEmail($miss_req_session->getTreatingEmail());
$passenger->setLanguageSpoken($miss_req_session->getPassLanguage());
$passenger->setBestContactMethod($miss_req_session->getBestContact());
$passenger->setEmergencyContactName($miss_req_session->getEmergencyName());
$passenger->setEmergencyContactPrimaryPhone($miss_req_session->getEmergencyPhone1());
$passenger->setEmergencyContactPrimaryComment($miss_req_session->getEmergencyPhone1Comment());
$passenger->setEmergencyContactSecondaryPhone($miss_req_session->getEmergencyPhone2());
$passenger->setEmergencyContactSecondaryComment($miss_req_session->getEmergencyPhone2Comment());
$passenger->setNeedMedicalRelease($miss_req_session->getPassMedical());
$passenger->save();
//set Companions
if ($passenger && $miss_req_session->getCom1Name()) {
$person = new Person();
$names[] = split(" ", $miss_req_session->getCom1Name());
//echo var_dump($names); die();
$person->setFirstName($names[0][0]);
$person->setLastName($names[0][1]);
$person->setDayPhone($miss_req_session->getCom1Phone());
$person->setDayComment($miss_req_session->getCom1Comment());
$person->save();
$companion = new Companion();
$companion->setPassengerId($passenger->getId());
$companion->setName($miss_req_session->getCom1Name());
$companion->setRelationship($miss_req_session->getCom1Relationship());
$companion->setDateOfBirth($miss_req_session->getCom1DateOfBirth());
$companion->setWeight($miss_req_session->getCom1Weigth());
$companion->setCompanionPhone($miss_req_session->getCom1Phone());
$companion->setCompanionPhoneComment($miss_req_session->getCom1Comment());
$companion->setPersonId($person->getId());
$companion->save();
}
if ($passenger && $miss_req_session->getCom2Name()) {
$person = new Person();
$names[] = split(" ", $miss_req_session->getCom2Name());
//echo var_dump($names); die();
$person->setFirstName($names[0][0]);
$person->setLastName($names[0][1]);
$person->setDayPhone($miss_req_session->getCom2Phone());
$person->setDayComment($miss_req_session->getCom2Comment());
$person->save();
$companion = new Companion();
$companion->setPassengerId($passenger->getId());
$companion->setName($miss_req_session->getCom2Name());
$companion->setRelationship($miss_req_session->getCom2Relationship());
$companion->setDateOfBirth($miss_req_session->getCom2DateOfBirth());
$companion->setWeight($miss_req_session->getCom2Weigth());
$companion->setCompanionPhone($miss_req_session->getCom2Phone());
$companion->setCompanionPhoneComment($miss_req_session->getCom2Comment());
$companion->setPersonId($person->getId());
$companion->save();
}
if ($passenger && $miss_req_session->getCom3Name()) {
$person = new Person();
$names[] = split(" ", $miss_req_session->getCom3Name());
//echo var_dump($names); die();
$person->setFirstName($names[0][0]);
$person->setLastName($names[0][1]);
$person->setDayPhone($miss_req_session->getCom3Phone());
$person->setDayComment($miss_req_session->getCom3Comment());
$person->save();
$companion = new Companion();
$companion->setPassengerId($passenger->getId());
$companion->setName($miss_req_session->getCom3Name());
$companion->setRelationship($miss_req_session->getCom3Relationship());
$companion->setDateOfBirth($miss_req_session->getCom3DateOfBirth());
$companion->setWeight($miss_req_session->getCom3Weigth());
$companion->setCompanionPhone($miss_req_session->getCom3Phone());
$companion->setCompanionPhoneComment($miss_req_session->getCom3Comment());
$companion->setPersonId($person->getId());
$companion->save();
}
if ($passenger && $miss_req_session->getCom4Name()) {
$person = new Person();
$names[] = split(" ", $miss_req_session->getCom4Name());
//echo var_dump($names); die();
$person->setFirstName($names[0][0]);
$person->setLastName($names[0][1]);
$person->setDayPhone($miss_req_session->getCom4Phone());
$person->setDayComment($miss_req_session->getCom4Comment());
$person->save();
$companion = new Companion();
$companion->setPassengerId($passenger->getId());
$companion->setName($miss_req_session->getCom4Name());
$companion->setRelationship($miss_req_session->getCom4Relationship());
$companion->setDateOfBirth($miss_req_session->getCom4DateOfBirth());
$companion->setWeight($miss_req_session->getCom4Weigth());
$companion->setCompanionPhone($miss_req_session->getCom4Phone());
$companion->setCompanionPhoneComment($miss_req_session->getCom4Comment());
$companion->setPersonId($person->getId());
$companion->save();
}
if ($passenger && $miss_req_session->getCom5Name()) {
$person = new Person();
$names[] = split(" ", $miss_req_session->getCom5Name());
//echo var_dump($names); die();
$person->setFirstName($names[0][0]);
$person->setLastName($names[0][1]);
$person->setDayPhone($miss_req_session->getCom5Phone());
$person->setDayComment($miss_req_session->getCom5Comment());
$person->save();
$companion = new Companion();
$companion->setPassengerId($passenger->getId());
$companion->setName($miss_req_session->getCom5Name());
$companion->setRelationship($miss_req_session->getCom5Relationship());
$companion->setDateOfBirth($miss_req_session->getCom5DateOfBirth());
$companion->setWeight($miss_req_session->getCom5Weigth());
$companion->setCompanionPhone($miss_req_session->getCom5Phone());
$companion->setCompanionPhoneComment($miss_req_session->getCom5Comment());
$companion->setPersonId($person->getId());
$companion->save();
}
//set Itinerary
$itinerary = ItineraryPeer::getByMissReqId($miss_req_session->getId());
if (!$itinerary) {
$new_itinerary = new Itinerary();
$new_itinerary->setDateRequested(date('m/d/Y'));
$new_itinerary->setMissionRequestId($miss_req_session->getId());
$new_itinerary->setMissionTypeId($miss_req_session->getMissionRequestTypeId());
$new_itinerary->setApointTime($miss_req_session->getApptDate());
$new_itinerary->setPassengerId($passenger->getId());
$new_itinerary->setRequesterId($requester->getId());
$new_itinerary->setFacility($miss_req_session->getFacilityName());
$new_itinerary->setLodging($miss_req_session->getLodgingName());
$new_itinerary->setOrginCity($miss_req_session->getOrginCity());
$new_itinerary->setOrginState($miss_req_session->getOrginState());
$new_itinerary->setDestCity($miss_req_session->getDestCity());
$new_itinerary->setDestState($miss_req_session->getDestState());
$new_itinerary->setWaiverNeed(0);
$new_itinerary->setNeedMedicalRelease($miss_req_session->getPassMedical());
$new_itinerary->setComment($miss_req_session->getComment());
$new_itinerary->setAgencyId($agency->getId());
$new_itinerary->save();
}
//set default Mission to Mission table
//get Passenger
//$passenger = PassengerPeer::getByPersonId($person->getId());
$misson = new Mission();
$misson->setRequestId($miss_req_session->getId());
$misson->setItineraryId($new_itinerary->getId());
$misson->setMissionTypeId($miss_req_session->getMissionRequestTypeId());
$misson->setDateRequested($miss_req_session->getRequesterDate());
if ($passenger) {
$misson->setPassengerId($passenger->getId());
}
if ($requester) {
$misson->setRequesterId($requester->getId());
}
if ($agency) {
$misson->setAgencyId($agency->getId());
}
// Farazi Mission 1 externa ID
$c = new Criteria();
$c->add(MissionPeer::EXTERNAL_ID, NULL, Criteria::ISNOTNULL);
$c->addDescendingOrderByColumn(MissionPeer::ID);
$external_mission = MissionPeer::doSelectOne($c);
$external_id = $external_mission->getExternalId();
$currentExternalId = $external_id + 1;
$misson->setExternalId($currentExternalId);
$misson->setApptDate($miss_req_session->getApptDate());
$misson->setFlightTime($miss_req_session->getFlightTime());
$misson->setMissionDate($miss_req_session->getMissionDate());
$misson->setMissionCount(1);
$misson->save();
$missLeg = new MissionLeg();
$missLeg->setMissionId($misson->getId());
$missLeg->setLegNumber(1);
if ($miss_req_session->getOrginState() && $miss_req_session->getOrginZipcode()) {
//echo $miss_req_session->getOrginState().'-'.$miss_req_session->getOrginZipcode();die();
$fromairport = AirportPeer::getAirportByStateAndZipcode($miss_req_session->getOrginState(), $miss_req_session->getOrginZipcode());
if ($fromairport) {
$missLeg->setFromAirportId($fromairport->getId());
}
}
if ($miss_req_session->getDestState() && $miss_req_session->getDestZipcode()) {
//echo $miss_req_session->getDestState().'--'.$miss_req_session->getDestZipcode();die();
$toairport = AirportPeer::getAirportByStateAndZipcode($miss_req_session->getDestState(), $miss_req_session->getDestZipcode());
if ($toairport) {
$missLeg->setToAirportId($toairport->getId());
}
}
//echo "oder";die();
$missLeg->setPassOnBoard(0);
$missLeg->setWebCoordinated(0);
$missLeg->setTransportation('air_mission');
$missLeg->save();
//end set Mission
$this->getUser()->setFlash('success', 'New mission has successfully created!');
$miss_req_session->setProcessedDate(time());
$miss_req_session->save();
$this->getUser()->setAttribute('miss_req', null);
//$this->redirect('miss_req');
//$this->getUser()->setFlash('success',$success);
//$request->getParameter('back')
$this->redirect('/itinerary/detail/' . $new_itinerary->getId());
}
// Skip people who are already in the system
if ($row['e_mail_address']) {
$list = new PersonList(array('email' => $row['e_mail_address']));
if (count($list)) {
continue;
}
}
$list = new PersonList(array('firstname' => $row['first_name'], 'lastname' => $row['last_name']));
if (count($list)) {
continue;
}
$person = new Person();
$person->setFirstname(ucwords(strtolower($row['first_name'])));
$person->setMiddlename(ucwords(strtolower($row['middle_initial'])));
$person->setLastname(ucwords(strtolower($row['last_name'])));
$person->setEmail(strtolower($row['e_mail_address']));
$person->setPhone($row['home_phone'] ? $row['home_phone'] : $row['bus_phone']);
if ($row['address']) {
$row['address'] = preg_replace('/[^a-zA-Z0-9\\-\\&\\s\'\\/]/', '', $row['address']);
$url = new URL(ADDRESS_SERVICE . '/addresses/parse.php');
$url->format = 'xml';
$url->address = $row['address'];
$parsed = new SimpleXMLElement($url, null, true);
if ($parsed->street_number && $parsed->street_name) {
// Look up their address in Master Address
$url = new URL(ADDRESS_SERVICE . '/home.php');
$url->queryType = 'address';
$url->format = 'xml';
$url->query = $row['address'];
echo $url->query . " ==> ";
$xml = new SimpleXMLElement($url, null, true);
$result = $pdo->query('select username,authenticationMethod,firstname,lastname from users u,people p where p.id=u.person_id');
foreach ($result->fetchAll(PDO::FETCH_ASSOC) as $row) {
try {
$person = new Person($row['username']);
} catch (Exception $e) {
// print_r($e);
$person = new Person();
$person->setUsername($row['username']);
$person->setAuthenticationMethod($row['authenticationMethod']);
$person->addRole('Staff');
if ($row['authenticationMethod'] == 'LDAP') {
try {
$ldap = new LDAPEntry($person->getUsername());
$person->setFirstname($ldap->getFirstname());
$person->setLastname($ldap->getLastname());
$person->setEmail($ldap->getEmail());
// $person->setDepartment($ldap->getDepartment());
} catch (Exception $e) {
// print_r($e);
$person->setEmail($row['username'] . '@bloomington.in.gov');
}
} else {
$person->setFirstname($row['firstname']);
$person->setLastname($row['lastname']);
}
try {
$person->save();
} catch (Exception $e) {
print_r($e);
print_r($person);
exit;
function Main()
{
switch ($this->formArray["formAction"]) {
case "edit":
$UserDetails = new SoapObject(NCCBIZ . "UserDetails.php", "urn:Object");
if (!($xmlStr = $UserDetails->getUserDetails($this->formArray["userID"]))) {
$this->tpl->set_block("rptsTemplate", "Table", "TableBlock");
$this->tpl->set_var("TableBlock", "User 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 {
$user = new User();
$user->parseDomDocument($domDoc);
$this->formArray["userID"] = $user->getUserID();
$this->formArray["userType"] = $user->getUserType();
$this->formArray["username"] = $user->getUsername();
$this->formArray["password"] = $user->getPassword();
$this->formArray["personID"] = $user->getPersonID();
$this->formArray["status"] = $user->getStatus();
}
}
$PersonDetails = new SoapObject(NCCBIZ . "PersonDetails.php", "urn:Object");
if (!($xmlStr = $PersonDetails->getPersonDetails($this->formArray["personID"]))) {
$this->tpl->set_block("rptsTemplate", "Table", "TableBlock");
$this->tpl->set_var("TableBlock", "Person 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 {
$person = new Person();
$person->parseDomDocument($domDoc);
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $person->getBirthday());
$this->formArray["personID"] = $person->getPersonID();
$this->formArray["lastName"] = $person->getLastName();
$this->formArray["firstName"] = $person->getFirstName();
$this->formArray["middleName"] = $person->getMiddleName();
$this->formArray["gender"] = $person->getGender();
$this->formArray["birth_year"] = removePreZero($dateArr["year"]);
$this->formArray["birth_month"] = removePreZero($dateArr["month"]);
$this->formArray["birth_day"] = removePreZero($dateArr["day"]);
$this->formArray["maritalStatus"] = $person->getMaritalStatus();
$this->formArray["tin"] = $person->getTin();
$address = $person->addressArray[0];
if (is_a($address, Address)) {
$this->formArray["addressID"] = $address->getAddressID();
$this->formArray["number"] = $address->getNumber();
$this->formArray["street"] = $address->getStreet();
$this->formArray["barangay"] = $address->getBarangay();
$this->formArray["district"] = $address->getDistrict();
$this->formArray["municipalityCity"] = $address->getMunicipalitycity();
$this->formArray["province"] = $address->getProvince();
}
$this->formArray["telephone"] = $person->getTelephone();
$this->formArray["mobileNumber"] = $person->getMobileNumber();
$this->formArray["email"] = $person->getEmail();
}
}
$this->tpl->set_block("rptsTemplate", "NewUserPassword", "NewUserPasswordBlock");
$this->tpl->set_var("NewUserPasswordBlock", "");
$this->tpl->set_block("rptsTemplate", "OldUserPassword", "OldUserPasswordBlock");
$this->tpl->set_var("oldNewUserRowspan", 5);
//$this->tpl->set_var("oldNewUserRowspan", 3);
$this->tpl->parse("OldUserPasswordBlock", "OldUserPassword", true);
break;
case "save":
/*
if($this->isOldPasswordCorrect()==false){
$this->message = "Error. Cannot Save. Old password incorrect to create new password.";
$this->tpl->set_var("message", $this->message);
$this->tpl->parse("MessageBlock", "Message", true);
$this->tpl->set_block("rptsTemplate", "NewUserPassword", "NewUserPasswordBlock");
$this->tpl->set_var("NewUserPasswordBlock", "");
$this->tpl->set_block("rptsTemplate", "OldUserPassword", "OldUserPasswordBlock");
$this->tpl->set_var("oldNewUserRowspan", 3);
$this->tpl->parse("OldUserPasswordBlock", "OldUserPassword", true);
break;
}
*/
if ($this->formArray["newPassword"] != "" && $this->formArray["newPassword"] != "null") {
$this->formArray["password"] = md5($this->formArray["newPassword"]);
}
if ($this->usernameAlreadyExists() == true) {
$this->message = "Error. Cannot Save. Username already exists.";
$this->tpl->set_var("message", $this->message);
$this->tpl->parse("MessageBlock", "Message", true);
$this->tpl->set_block("rptsTemplate", "NewUserPassword", "NewUserPasswordBlock");
$this->tpl->set_block("rptsTemplate", "OldUserPassword", "OldUserPasswordBlock");
if ($this->formArray["personID"] != "") {
$this->tpl->set_var("NewUserPasswordBlock", "");
$this->tpl->set_var("oldNewUserRowspan", 3);
$this->tpl->parse("OldUserPasswordBlock", "OldUserPassword", true);
} else {
$this->tpl->set_var("oldNewUserRowspan", 2);
$this->tpl->parse("NewUserPasswordBlock", "NewUserPassword", true);
$this->tpl->set_var("OldUserPasswordBlock", "");
}
break;
}
$PersonEncode = new SoapObject(NCCBIZ . "PersonEncode.php", "urn:Object");
if ($this->formArray["personID"] != "") {
$PersonDetails = new SoapObject(NCCBIZ . "PersonDetails.php", "urn:Object");
if (!($xmlStr = $PersonDetails->getPersonDetails($this->formArray["personID"]))) {
$this->tpl->set_block("rptsTemplate", "Table", "TableBlock");
$this->tpl->set_var("TableBlock", "Person 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 {
$person = new Person();
$person->parseDomDocument($domDoc);
$address = $person->addressArray[0];
if (is_a($address, Address)) {
$address->setAddressID($this->formArray["addressID"]);
$address->setNumber($this->formArray["number"]);
$address->setStreet($this->formArray["street"]);
$address->setBarangay($this->formArray["barangay"]);
$address->setDistrict($this->formArray["district"]);
$address->setMunicipalityCity($this->formArray["municipalityCity"]);
$address->setProvince($this->formArray["province"]);
$address->setDomDocument();
}
$person->setPersonID($this->formArray["personID"]);
$person->setPersonType("adminUser");
$person->setLastName($this->formArray["lastName"]);
$person->setFirstName($this->formArray["firstName"]);
$person->setMiddleName($this->formArray["middleName"]);
$person->setGender($this->formArray["gender"]);
$person->setBirthday($this->birthdate);
$person->setMaritalStatus($this->formArray["maritalStatus"]);
$person->setTin($this->formArray["tin"]);
$person->setAddressArray($address);
$person->setTelephone($this->formArray["telephone"]);
$person->setMobileNumber($this->formArray["mobileNumber"]);
$person->setEmail($this->formArray["email"]);
$person->setDomDocument();
$doc = $person->getDomDocument();
//echo $doc->html_dump_mem();
$xmlStr = $doc->dump_mem(true);
if (!($ret = $PersonEncode->updatePerson($xmlStr))) {
exit("error update");
}
}
}
} else {
$address = new Address();
$address->setNumber($this->formArray["number"]);
$address->setStreet($this->formArray["street"]);
$address->setBarangay($this->formArray["barangay"]);
$address->setDistrict($this->formArray["district"]);
$address->setMunicipalityCity($this->formArray["municipalityCity"]);
$address->setProvince($this->formArray["province"]);
$address->setDomDocument();
$person = new Person();
$person->setPersonID($this->formArray["personID"]);
$person->setPersonType("adminUser");
$person->setLastName($this->formArray["lastName"]);
$person->setFirstName($this->formArray["firstName"]);
$person->setMiddleName($this->formArray["middleName"]);
$person->setGender($this->formArray["gender"]);
$person->setBirthday($this->birthdate);
$person->setMaritalStatus($this->formArray["maritalStatus"]);
$person->setTin($this->formArray["tin"]);
$person->setAddressArray($address);
$person->setTelephone($this->formArray["telephone"]);
$person->setMobileNumber($this->formArray["mobileNumber"]);
$person->setEmail($this->formArray["email"]);
$person->setDomDocument();
$doc = $person->getDomDocument();
$xmlStr = $doc->dump_mem(true);
//echo $this->formArray["ownerID"].$xmlStr;
if (!($ret = $PersonEncode->savePerson($xmlStr, $this->formArray["ownerID"]))) {
exit("error save");
}
}
$this->formArray["personID"] = $ret;
$UserEncode = new SoapObject(NCCBIZ . "UserEncode.php", "urn:Object");
if ($this->formArray["userID"] != "") {
$UserDetails = new SoapObject(NCCBIZ . "UserDetails.php", "urn:Object");
if (!($xmlStr = $UserDetails->getUserDetails($this->formArray["userID"]))) {
exit("User 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 {
$user = new User();
$user->parseDomDocument($domDoc);
$user->setUserID($this->formArray["userID"]);
$user->setUserType($this->formArray["userType"]);
$user->setUsername($this->formArray["username"]);
$user->setPassword($this->formArray["password"]);
$user->setPersonID($this->formArray["personID"]);
$user->setStatus($this->formArray["status"]);
$user->setDomDocument();
$doc = $user->getDomDocument();
$xmlStr = $doc->dump_mem(true);
if (!($ret = $UserEncode->updateUser($xmlStr))) {
exit("error update");
}
}
}
} else {
$user = new User();
//$user->setUserID($this->formArray["userID"]);
$user->setUserType($this->formArray["userType"]);
$user->setUsername($this->formArray["username"]);
$user->setPassword(md5($this->formArray["password"]));
$user->setPersonID($this->formArray["personID"]);
$user->setStatus($this->formArray["status"]);
$user->setDomDocument();
$doc = $user->getDomDocument();
$xmlStr = $doc->dump_mem(true);
if (!($ret = $UserEncode->saveUser($xmlStr))) {
exit("error save");
}
}
header("location: UserClose.php" . $this->sess->url(""));
exit;
break;
case "cancel":
header("location: UserClose.php" . $this->sess->url(""));
exit;
break;
default:
$this->tpl->set_block("rptsTemplate", "UserID", "UserIDBlock");
$this->tpl->set_var("UserIDBlock", "");
$this->tpl->set_block("rptsTemplate", "ACK", "ACKBlock");
$this->tpl->set_var("ACKBlock", "");
$this->tpl->set_block("rptsTemplate", "NewUserPassword", "NewUserPasswordBlock");
$this->tpl->set_var("oldNewUserRowspan", 2);
$this->tpl->parse("NewUserPasswordBlock", "NewUserPassword", true);
$this->tpl->set_block("rptsTemplate", "OldUserPassword", "OldUserPasswordBlock");
$this->tpl->set_var("OldUserPasswordBlock", "");
}
$this->setForm();
if ($this->message == "") {
$this->tpl->set_var("MessageBlock", "");
}
$this->tpl->parse("templatePage", "rptsTemplate");
$this->tpl->finish("templatePage");
$this->tpl->p("templatePage");
}
function Main()
{
switch ($this->formArray["formAction"]) {
case "edit":
$PersonDetails = new SoapObject(NCCBIZ . "PersonDetails.php", "urn:Object");
if (!($xmlStr = $PersonDetails->getPersonDetails($this->formArray["personID"]))) {
$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 {
$person = new Person();
$person->parseDomDocument($domDoc);
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $person->getBirthday());
$this->formArray["personID"] = $person->getPersonID();
$this->formArray["lastName"] = $person->getLastName();
$this->formArray["firstName"] = $person->getFirstName();
$this->formArray["middleName"] = $person->getMiddleName();
$this->formArray["gender"] = $person->getGender();
$this->formArray["birth_year"] = removePreZero($dateArr["year"]);
$this->formArray["birth_month"] = removePreZero($dateArr["month"]);
$this->formArray["birth_day"] = removePreZero($dateArr["day"]);
$this->formArray["maritalStatus"] = $person->getMaritalStatus();
$this->formArray["tin"] = $person->getTin();
$address = $person->addressArray[0];
if (is_a($address, Address)) {
$this->formArray["addressID"] = $address->getAddressID();
$this->formArray["number"] = $address->getNumber();
$this->formArray["street"] = $address->getStreet();
$this->formArray["barangay"] = $address->getBarangay();
$this->formArray["district"] = $address->getDistrict();
$this->formArray["municipalityCity"] = $address->getMunicipalitycity();
$this->formArray["province"] = $address->getProvince();
}
$this->formArray["telephone"] = $person->getTelephone();
$this->formArray["mobileNumber"] = $person->getMobileNumber();
$this->formArray["email"] = $person->getEmail();
}
}
break;
case "save":
$PersonEncode = new SoapObject(NCCBIZ . "PersonEncode.php", "urn:Object");
if ($this->formArray["personID"] != "") {
$PersonDetails = new SoapObject(NCCBIZ . "PersonDetails.php", "urn:Object");
if (!($xmlStr = $PersonDetails->getPersonDetails($this->formArray["personID"]))) {
$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 {
$person = new Person();
$person->parseDomDocument($domDoc);
$address = $person->addressArray[0];
if (is_a($address, Address)) {
$address->setAddressID($this->formArray["addressID"]);
$address->setNumber($this->formArray["number"]);
$address->setStreet($this->formArray["street"]);
$address->setBarangay($this->formArray["barangay"]);
$address->setDistrict($this->formArray["district"]);
$address->setMunicipalityCity($this->formArray["municipalityCity"]);
$address->setProvince($this->formArray["province"]);
$address->setDomDocument();
}
$person->setPersonID($this->formArray["personID"]);
$person->setLastName($this->formArray["lastName"]);
$person->setFirstName($this->formArray["firstName"]);
$person->setMiddleName($this->formArray["middleName"]);
$person->setGender($this->formArray["gender"]);
$person->setBirthday($this->birthdate);
$person->setMaritalStatus($this->formArray["maritalStatus"]);
$person->setTin($this->formArray["tin"]);
$person->setAddressArray($address);
$person->setTelephone($this->formArray["telephone"]);
$person->setMobileNumber($this->formArray["mobileNumber"]);
$person->setEmail($this->formArray["email"]);
$person->setDomDocument();
$doc = $person->getDomDocument();
$xmlStr = $doc->dump_mem(true);
if (!($ret = $PersonEncode->updatePerson($xmlStr))) {
exit("error update");
}
}
}
} else {
$address = new Address();
$address->setNumber($this->formArray["number"]);
$address->setStreet($this->formArray["street"]);
$address->setBarangay($this->formArray["barangay"]);
$address->setDistrict($this->formArray["district"]);
$address->setMunicipalityCity($this->formArray["municipalityCity"]);
$address->setProvince($this->formArray["province"]);
$address->setDomDocument();
$person = new Person();
$person->setPersonID($this->formArray["personID"]);
$person->setLastName($this->formArray["lastName"]);
$person->setFirstName($this->formArray["firstName"]);
$person->setMiddleName($this->formArray["middleName"]);
$person->setGender($this->formArray["gender"]);
$person->setBirthday($this->birthdate);
$person->setMaritalStatus($this->formArray["maritalStatus"]);
$person->setTin($this->formArray["tin"]);
$person->setAddressArray($address);
$person->setTelephone($this->formArray["telephone"]);
$person->setMobileNumber($this->formArray["mobileNumber"]);
$person->setEmail($this->formArray["email"]);
$person->setDomDocument();
$doc = $person->getDomDocument();
$xmlStr = $doc->dump_mem(true);
//echo $this->formArray["ownerID"].$xmlStr;
if (!($ret = $PersonEncode->savePerson($xmlStr, $this->formArray["ownerID"]))) {
exit("error save");
}
}
$this->formArray["personID"] = $ret;
header("location: ChangeOfOwnershipPropertyInfoClose.php" . $this->sess->url("") . $this->sess->add_query(array("odID" => $this->formArray["odID"], "personID" => $ret, "formAction" => "view")));
exit;
break;
case "cancel":
header("location: PersonList.php");
exit;
break;
default:
if ($this->formArray["locID"]) {
$ODDetails = new SoapObject(NCCBIZ . "ODDetails.php", "urn:Object");
if (!($xmlStr = $ODDetails->getLocation($this->formArray["locID"]))) {
exit("xml failed");
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
} else {
$loc = new LocationAddress();
$loc->parseDomDocument($domDoc);
foreach ($loc as $key => $value) {
$this->formArray[$key] = $value;
}
}
}
}
$this->tpl->set_block("rptsTemplate", "personID", "personIDBlock");
$this->tpl->set_var("personIDBlock", "");
$this->tpl->set_block("rptsTemplate", "ACK", "ACKBlock");
$this->tpl->set_var("ACKBlock", "");
}
$this->setForm();
$this->tpl->parse("templatePage", "rptsTemplate");
$this->tpl->finish("templatePage");
$this->tpl->p("templatePage");
}
function Main()
{
switch ($this->formArray["formAction"]) {
case "edit":
$PlantsTreesDetails = new SoapObject(NCCBIZ . "PlantsTreesDetails.php", "urn:Object");
if (!($xmlStr = $PlantsTreesDetails->getPlantsTrees($this->formArray["propertyID"]))) {
echo "xml failed";
} else {
//echo $xmlStr;
if (!($domDoc = domxml_open_mem($xmlStr))) {
$this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock");
$this->tpl->set_var("OwnerListTableBlock", "error xmlDoc");
} else {
$plantsTrees = new PlantsTrees();
$plantsTrees->parseDomDocument($domDoc);
foreach ($plantsTrees as $key => $value) {
switch ($key) {
case "propertyAdministrator":
if (is_a($value, Person)) {
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value->getBirthday());
$this->formArray["personID"] = $value->getPersonID();
$this->formArray["lastName"] = $value->getLastName();
$this->formArray["firstName"] = $value->getFirstName();
$this->formArray["middleName"] = $value->getMiddleName();
$this->formArray["gender"] = $value->getGender();
$this->formArray["birth_year"] = removePreZero($dateArr["year"]);
$this->formArray["birth_month"] = removePreZero($dateArr["month"]);
$this->formArray["birth_day"] = removePreZero($dateArr["day"]);
$this->formArray["maritalStatus"] = $value->getMaritalStatus();
$this->formArray["tin"] = $value->getTin();
$this->formArray["addressID"] = $value->addressArray[0]->getAddressID();
$this->formArray["number"] = $value->addressArray[0]->getNumber();
$this->formArray["street"] = $value->addressArray[0]->getStreet();
$this->formArray["barangay"] = $value->addressArray[0]->getBarangay();
$this->formArray["district"] = $value->addressArray[0]->getDistrict();
$this->formArray["municipalityCity"] = $value->addressArray[0]->getMunicipalityCity();
$this->formArray["province"] = $value->addressArray[0]->getProvince();
$this->formArray["telephone"] = $value->getTelephone();
$this->formArray["mobileNumber"] = $value->getMobileNumber();
$this->formArray["email"] = $value->getEmail();
} else {
$this->formArray[$key] = "";
}
break;
case "appraisedByDate":
if (true) {
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value);
$this->formArray["as_year"] = removePreZero($dateArr["year"]);
$this->formArray["as_month"] = removePreZero($dateArr["month"]);
$this->formArray["as_day"] = removePreZero($dateArr["day"]);
} else {
$this->formArray[$key] = "";
}
break;
case "recommendingApprovalDate":
if (true) {
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value);
$this->formArray["re_year"] = removePreZero($dateArr["year"]);
$this->formArray["re_month"] = removePreZero($dateArr["month"]);
$this->formArray["re_day"] = removePreZero($dateArr["day"]);
} else {
$this->formArray[$key] = "";
}
case "approvedByDate":
if (true) {
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value);
$this->formArray["av_year"] = removePreZero($dateArr["year"]);
$this->formArray["av_month"] = removePreZero($dateArr["month"]);
$this->formArray["av_day"] = removePreZero($dateArr["day"]);
} else {
$this->formArray[$key] = "";
}
break;
case "dateAcquired":
if (true) {
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value);
$this->formArray["da_year"] = removePreZero($dateArr["year"]);
$this->formArray["da_month"] = removePreZero($dateArr["month"]);
$this->formArray["da_day"] = removePreZero($dateArr["day"]);
} else {
$this->formArray[$key] = "";
}
break;
case "dateOfInstallation":
if (true) {
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value);
$this->formArray["di_year"] = removePreZero($dateArr["year"]);
$this->formArray["di_month"] = removePreZero($dateArr["month"]);
$this->formArray["di_day"] = removePreZero($dateArr["day"]);
} else {
$this->formArray[$key] = "";
}
break;
case "dateOfOperation":
if (true) {
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value);
$this->formArray["do_year"] = removePreZero($dateArr["year"]);
$this->formArray["do_month"] = removePreZero($dateArr["month"]);
$this->formArray["do_day"] = removePreZero($dateArr["day"]);
} else {
$this->formArray[$key] = "";
}
break;
default:
$this->formArray[$key] = $value;
}
}
}
}
break;
case "save":
if ($this->formArray["verifiedByID"] != "" && $this->formArray["verifiedByID"] != "xx" && $this->formArray["propertyID"] != "") {
$this->saveVerified($this->formArray["afsID"], $this->formArray["verifiedByID"], $this->formArray["propertyID"]);
}
$PlantsTreesEncode = new SoapObject(NCCBIZ . "PlantsTreesEncode.php", "urn:Object");
if ($this->formArray["propertyID"] != "") {
$PlantsTreesDetails = new SoapObject(NCCBIZ . "PlantsTreesDetails.php", "urn:Object");
if (!($xmlStr = $PlantsTreesDetails->getPlantsTrees($this->formArray["propertyID"]))) {
$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 {
$address = new Address();
$address->setAddressID($this->formArray["addressID"]);
$address->setNumber($this->formArray["number"]);
$address->setStreet($this->formArray["street"]);
$address->setBarangay($this->formArray["barangay"]);
$address->setDistrict($this->formArray["district"]);
$address->setMunicipalityCity($this->formArray["municipalityCity"]);
$address->setProvince($this->formArray["province"]);
$address->setDomDocument();
$propertyAdministrator = new Person();
$propertyAdministrator->setPersonID($this->formArray["personID"]);
$propertyAdministrator->setLastName($this->formArray["lastName"]);
$propertyAdministrator->setFirstName($this->formArray["firstName"]);
$propertyAdministrator->setMiddleName($this->formArray["middleName"]);
//$propertyAdministrator->setGender($this->formArray["gender"]);
//$propertyAdministrator->setBirthday($this->birthdate);
//$propertyAdministrator->setMaritalStatus($this->formArray["maritalStatus"]);
//$propertyAdministrator->setTin($this->formArray["tin"]);
$propertyAdministrator->setAddressArray($address);
$propertyAdministrator->setTelephone($this->formArray["telephone"]);
//$propertyAdministrator->setMobileNumber($this->formArray["mobileNumber"]);
$propertyAdministrator->setEmail($this->formArray["email"]);
$propertyAdministrator->setDomDocument();
$plantsTrees = new PlantsTrees();
$plantsTrees->parseDomDocument($domDoc);
$plantsTrees->setPropertyID($this->formArray["propertyID"]);
$plantsTrees->setAfsID($this->formArray["afsID"]);
$plantsTrees->setArpNumber($this->formArray["arpNumber"]);
$plantsTrees->setPropertyIndexNumber($this->formArray["propertyIndexNumber"]);
$plantsTrees->setPropertyAdministrator($propertyAdministrator);
$plantsTrees->setVerifiedBy($this->formArray["verifiedByID"]);
$plantsTrees->setPlottingsBy($this->formArray["plottingsByID"]);
$plantsTrees->setNotedBy($this->formArray["notedByID"]);
$plantsTrees->setMarketValue($this->formArray["marketValue"]);
$plantsTrees->setKind($this->formArray["kind"]);
$plantsTrees->setActualUse($this->formArray["actualUse"]);
$plantsTrees->setAdjustedMarketValue($this->formArray["adjustedMarketValue"]);
$plantsTrees->setAssessmentLevel($this->formArray["assessmentLevel"]);
$plantsTrees->setAssessedValue($this->formArray["assessedValue"]);
$plantsTrees->setPreviousOwner($this->formArray["previousOwner"]);
$plantsTrees->setPreviousAssessedValue($this->formArray["previousAssessedValue"]);
$plantsTrees->setTaxability($this->formArray["taxability"]);
$plantsTrees->setEffectivity($this->formArray["effectivity"]);
$plantsTrees->setAppraisedBy($this->formArray["appraisedByID"]);
$plantsTrees->setAppraisedByDate($this->formArray["appraisedByDate"]);
$plantsTrees->setRecommendingApproval($this->formArray["recommendingApprovalID"]);
$plantsTrees->setRecommendingApprovalDate($this->formArray["recommendingApprovalDate"]);
$plantsTrees->setApprovedBy($this->formArray["approvedByID"]);
$plantsTrees->setApprovedByDate($this->formArray["approvedByDate"]);
$plantsTrees->setMemoranda($this->formArray["memoranda"]);
$plantsTrees->setPostingDate($this->formArray["postingDate"]);
$plantsTrees->setLandPin($this->formArray["landPin"]);
$plantsTrees->setSurveyNumber($this->formArray["surveyNumber"]);
$plantsTrees->setProductClass($this->formArray["productClass"]);
$plantsTrees->setAreaPlanted($this->formArray["areaPlanted"]);
$plantsTrees->setTotalNumber($this->formArray["totalNumber"]);
$plantsTrees->setNonFruitBearing($this->formArray["nonFruitBearing"]);
$plantsTrees->setFruitBearing($this->formArray["fruitBearing"]);
$plantsTrees->setAge($this->formArray["age"]);
$plantsTrees->setUnitPrice($this->formArray["unitPrice"]);
$plantsTrees->setAdjustmentFactor($this->formArray["adjustmentFactor"]);
$plantsTrees->setPercentAdjustment($this->formArray["percentAdjustment"]);
$plantsTrees->setValueAdjustment($this->formArray["valueAdjustment"]);
$plantsTrees->setCreatedBy($this->userID);
$plantsTrees->setModifiedBy($this->userID);
$plantsTrees->setDomDocument();
$doc = $plantsTrees->getDomDocument();
$xmlStr = $doc->dump_mem(true);
//echo $xmlStr;
if (!($ret = $PlantsTreesEncode->updatePlantsTrees($xmlStr))) {
exit("error update");
}
}
}
} else {
$address = new Address();
//$address->setAddressID($this->formArray["addressID"]);
$address->setNumber($this->formArray["number"]);
$address->setStreet($this->formArray["street"]);
$address->setBarangay($this->formArray["barangay"]);
$address->setDistrict($this->formArray["district"]);
$address->setMunicipalityCity($this->formArray["municipalityCity"]);
$address->setProvince($this->formArray["province"]);
$address->setDomDocument();
$propertyAdministrator = new Person();
//$propertyAdministrator->setPersonID($this->formArray["personID"]);
$propertyAdministrator->setLastName($this->formArray["lastName"]);
$propertyAdministrator->setFirstName($this->formArray["firstName"]);
$propertyAdministrator->setMiddleName($this->formArray["middleName"]);
//$propertyAdministrator->setGender($this->formArray["gender"]);
//$propertyAdministrator->setBirthday($this->birthdate);
//$propertyAdministrator->setMaritalStatus($this->formArray["maritalStatus"]);
//$propertyAdministrator->setTin($this->formArray["tin"]);
$propertyAdministrator->setAddressArray($address);
$propertyAdministrator->setTelephone($this->formArray["telephone"]);
//$propertyAdministrator->setMobileNumber($this->formArray["mobileNumber"]);
$propertyAdministrator->setEmail($this->formArray["email"]);
$propertyAdministrator->setDomDocument();
$plantsTrees = new PlantsTrees();
$plantsTrees->parseDomDocument($domDoc);
//$plantsTrees->setPropertyID($this->formArray["propertyID"]);
$plantsTrees->setAfsID($this->formArray["afsID"]);
$plantsTrees->setArpNumber($this->formArray["arpNumber"]);
$plantsTrees->setPropertyIndexNumber($this->formArray["propertyIndexNumber"]);
$plantsTrees->setPropertyAdministrator($propertyAdministrator);
$plantsTrees->setVerifiedBy($this->formArray["verifiedByID"]);
$plantsTrees->setPlottingsBy($this->formArray["plottingsByID"]);
$plantsTrees->setNotedBy($this->formArray["notedByID"]);
$plantsTrees->setMarketValue($this->formArray["marketValue"]);
$plantsTrees->setKind($this->formArray["kind"]);
$plantsTrees->setActualUse($this->formArray["actualUse"]);
$plantsTrees->setAdjustedMarketValue($this->formArray["adjustedMarketValue"]);
$plantsTrees->setAssessmentLevel($this->formArray["assessmentLevel"]);
$plantsTrees->setAssessedValue($this->formArray["assessedValue"]);
$plantsTrees->setPreviousOwner($this->formArray["previousOwner"]);
$plantsTrees->setPreviousAssessedValue($this->formArray["previousAssessedValue"]);
$plantsTrees->setTaxability($this->formArray["taxability"]);
$plantsTrees->setEffectivity($this->formArray["effectivity"]);
$plantsTrees->setAppraisedBy($this->formArray["appraisedByID"]);
$plantsTrees->setAppraisedByDate($this->formArray["appraisedByDate"]);
$plantsTrees->setRecommendingApproval($this->formArray["recommendingApprovalID"]);
$plantsTrees->setRecommendingApprovalDate($this->formArray["recommendingApprovalDate"]);
$plantsTrees->setApprovedBy($this->formArray["approvedByID"]);
$plantsTrees->setApprovedByDate($this->formArray["approvedByDate"]);
$plantsTrees->setMemoranda($this->formArray["memoranda"]);
$plantsTrees->setPostingDate($this->formArray["postingDate"]);
$plantsTrees->setLandPin($this->formArray["landPin"]);
$plantsTrees->setSurveyNumber($this->formArray["surveyNumber"]);
$plantsTrees->setProductClass($this->formArray["productClass"]);
$plantsTrees->setAreaPlanted($this->formArray["areaPlanted"]);
$plantsTrees->setTotalNumber($this->formArray["totalNumber"]);
$plantsTrees->setNonFruitBearing($this->formArray["nonFruitBearing"]);
$plantsTrees->setFruitBearing($this->formArray["fruitBearing"]);
$plantsTrees->setAge($this->formArray["age"]);
$plantsTrees->setUnitPrice($this->formArray["unitPrice"]);
$plantsTrees->setAdjustmentFactor($this->formArray["adjustmentFactor"]);
$plantsTrees->setPercentAdjustment($this->formArray["percentAdjustment"]);
$plantsTrees->setValueAdjustment($this->formArray["valueAdjustment"]);
$plantsTrees->setCreatedBy($this->userID);
$plantsTrees->setModifiedBy($this->userID);
$plantsTrees->setDomDocument();
$doc = $plantsTrees->getDomDocument();
$xmlStr = $doc->dump_mem(true);
//exit($xmlStr);
if (!($ret = $PlantsTreesEncode->savePlantsTrees($xmlStr))) {
echo "ret=" . $ret;
}
}
$this->formArray["propertyID"] = $ret;
header("location: PlantsTreesClose.php" . $this->sess->url("") . $this->sess->add_query(array("afsID" => $this->formArray["afsID"])));
exit;
break;
case "cancel":
header("location: PlantsTreesList.php");
exit;
break;
default:
if (!($firstPropertyID = $this->getFirstPropertyID())) {
$this->tpl->set_block("rptsTemplate", "odID", "odIDBlock");
$this->tpl->set_var("odIDBlock", "");
$this->tpl->set_block("rptsTemplate", "ACK", "ACKBlock");
$this->tpl->set_var("ACKBlock", "");
} else {
$PlantsTreesDetails = new SoapObject(NCCBIZ . "PlantsTreesDetails.php", "urn:Object");
if (!($xmlStr = $PlantsTreesDetails->getPlantsTrees($firstPropertyID))) {
echo "xml failed";
} else {
//echo $xmlStr;
if (!($domDoc = domxml_open_mem($xmlStr))) {
$this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock");
$this->tpl->set_var("OwnerListTableBlock", "error xmlDoc");
} else {
$plantsTrees = new PlantsTrees();
$plantsTrees->parseDomDocument($domDoc);
foreach ($plantsTrees as $key => $value) {
switch ($key) {
case "propertyID":
$this->formArray["propertyID"] = "";
break;
case "propertyAdministrator":
if (is_a($value, Person)) {
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value->getBirthday());
$this->formArray["personID"] = $value->getPersonID();
$this->formArray["lastName"] = $value->getLastName();
$this->formArray["firstName"] = $value->getFirstName();
$this->formArray["middleName"] = $value->getMiddleName();
$this->formArray["gender"] = $value->getGender();
$this->formArray["birth_year"] = removePreZero($dateArr["year"]);
$this->formArray["birth_month"] = removePreZero($dateArr["month"]);
$this->formArray["birth_day"] = removePreZero($dateArr["day"]);
$this->formArray["maritalStatus"] = $value->getMaritalStatus();
$this->formArray["tin"] = $value->getTin();
$this->formArray["addressID"] = $value->addressArray[0]->getAddressID();
$this->formArray["number"] = $value->addressArray[0]->getNumber();
$this->formArray["street"] = $value->addressArray[0]->getStreet();
$this->formArray["barangay"] = $value->addressArray[0]->getBarangay();
$this->formArray["district"] = $value->addressArray[0]->getDistrict();
$this->formArray["municipalityCity"] = $value->addressArray[0]->getMunicipalityCity();
$this->formArray["province"] = $value->addressArray[0]->getProvince();
$this->formArray["telephone"] = $value->getTelephone();
$this->formArray["mobileNumber"] = $value->getMobileNumber();
$this->formArray["email"] = $value->getEmail();
} else {
$this->formArray[$key] = "";
}
break;
case "appraisedByDate":
if (true) {
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value);
$this->formArray["as_year"] = removePreZero($dateArr["year"]);
$this->formArray["as_month"] = removePreZero($dateArr["month"]);
$this->formArray["as_day"] = removePreZero($dateArr["day"]);
} else {
$this->formArray[$key] = "";
}
break;
case "recommendingApprovalDate":
if (true) {
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value);
$this->formArray["re_year"] = removePreZero($dateArr["year"]);
$this->formArray["re_month"] = removePreZero($dateArr["month"]);
$this->formArray["re_day"] = removePreZero($dateArr["day"]);
} else {
$this->formArray[$key] = "";
}
case "approvedByDate":
if (true) {
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value);
$this->formArray["av_year"] = removePreZero($dateArr["year"]);
$this->formArray["av_month"] = removePreZero($dateArr["month"]);
$this->formArray["av_day"] = removePreZero($dateArr["day"]);
} else {
$this->formArray[$key] = "";
}
break;
case "dateAcquired":
if (true) {
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value);
$this->formArray["da_year"] = removePreZero($dateArr["year"]);
$this->formArray["da_month"] = removePreZero($dateArr["month"]);
$this->formArray["da_day"] = removePreZero($dateArr["day"]);
} else {
$this->formArray[$key] = "";
}
break;
case "dateOfInstallation":
if (true) {
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value);
$this->formArray["di_year"] = removePreZero($dateArr["year"]);
$this->formArray["di_month"] = removePreZero($dateArr["month"]);
$this->formArray["di_day"] = removePreZero($dateArr["day"]);
} else {
$this->formArray[$key] = "";
}
break;
case "dateOfOperation":
if (true) {
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $value);
$this->formArray["do_year"] = removePreZero($dateArr["year"]);
$this->formArray["do_month"] = removePreZero($dateArr["month"]);
$this->formArray["do_day"] = removePreZero($dateArr["day"]);
} else {
$this->formArray[$key] = "";
}
break;
case "arpNumber":
case "propertyIndexNumber":
case "verifiedByID":
case "verifiedBy":
case "verifiedByName":
case "plottingsByID":
case "plottingsBy":
case "plottingsByName":
case "notedByID":
case "notedBy":
case "notedByName":
case "marketValue":
case "kind":
case "actualUse":
case "adjustedMarketValue":
case "assessmentLevel":
case "assessedValue":
case "previousOwner":
case "previousAssessedValue":
case "taxability":
case "effectivity":
case "appraisedByID":
case "appraisedBy":
case "appraisedByName":
case "appraisedByDate":
case "recommendingApprovalID":
case "recommendingApproval":
case "recommendingApprovalName":
case "recommendingApprovalDate":
case "approvedByID":
case "approvedBy":
case "approvedByName":
case "approvedByDate":
case "memoranda":
case "postingDate":
case "landPin":
case "surveyNumber":
case "productClass":
case "areaPlanted":
case "totalNumber":
case "nonFruitBearing":
case "fruitBearing":
case "age":
case "unitPrice":
case "adjustmentFactor":
case "percentAdjustment":
case "valueAdjustment":
case "as_month":
case "as_day":
case "as_year":
case "re_month":
case "re_day":
case "re_year":
case "av_month":
case "av_day":
case "av_year":
$this->formArray[$key] = $value;
break;
}
}
}
}
}
}
$this->setForm();
$this->tpl->set_var("Session", $this->sess->url("") . $this->sess->add_query(array("odID" => $this->formArray["odID"], "ownerID" => $this->formArray["ownerID"])));
$this->tpl->parse("templatePage", "rptsTemplate");
$this->tpl->finish("templatePage");
$this->tpl->p("templatePage");
}
public static function addCommit($sCommit, $sAuthor)
{
// Get author info seperated first
// Bradley T. Hughes <*****@*****.**>
$aAuthorBits = array();
if (!preg_match("/(.+) \\<(.+)(?:@| at )([^. ]*)[ .]?.*\\>/", $sAuthor, $aAuthorBits)) {
die("couldn't get author info for author " . $sAuthor . "\n");
}
// matches are:
// string 0
// real name 1
// email (from bit) 2
// email (domain bit, first word only to avoid TLD madness) 3
//
// first, try find the Organisation this Person belongs to
$oOrganisation = self::findOrganisation($aAuthorBits[3]);
if (!$oOrganisation) {
// create one
$oOrganisation = new Organisation();
$oOrganisation->setName($aAuthorBits[3]);
// add under both name and email thingy
self::$aOrganisations[strtolower($aAuthorBits[3])] = $oOrganisation;
}
// let's try find a Person
$oPerson = self::findPerson($aAuthorBits[1]);
if (!$oPerson) {
// try again
$oPerson = self::findPerson($aAuthorBits[2]);
}
if (!$oPerson) {
// Person record doesn't exist, let's create one
$oPerson = new Person();
$oPerson->setName($aAuthorBits[1]);
$oPerson->setEmail($sAuthor);
// add under both name and email thingy
self::$aPersons[strtolower($aAuthorBits[1])] = $oPerson;
self::$aPersons[strtolower($aAuthorBits[2])] = $oPerson;
}
// always set their organisation, as people may move from one org to
// another and keep contributing.
$oPerson->setOrganisation($oOrganisation);
// simple bookkeeping first
$oPerson->setCommitCount($oPerson->commitCount() + 1);
$oPerson->organisation()->setCommitCount($oPerson->organisation()->commitCount() + 1);
$oPerson->appendToCommitQueue($sCommit);
}
/**
* createAdminPerson() Create a person-object based on the certificate
* credentials passed via the client certificate.
*
* Ideally, this should be done via Confusa_Auth, however, since we do not have
* a live Feide-session, but are basing the authetnication on an X.509
* certificate, the case is a corner, thus we do it here.
*
* @return Person|NULL the decorated person or NULL if the creation failed.
*/
function createAdminPerson()
{
global $log_error_code;
/*
* Try to find the certificate in the robot_certs-table. If we have a
* match, we have a legit user and create a proxy-admin.
*
* If the query fails for some reason, we jumb out, returning null
*/
$fingerprint = openssl_x509_fingerprint($_SERVER['SSL_CLIENT_CERT'], true);
if (is_null($fingerprint)) {
return null;
}
try {
$cert_res = MDB2Wrapper::execute("SELECT * FROM robot_certs WHERE fingerprint = ?", array('text'), array(trim($fingerprint)));
} catch (DBStatementException $dbse) {
Logger::log_event(LOG_NOTICE, "[RI] ({$log_error_code}) (line: " . __LINE__ . ")Error with syntax for robot_certs-query.(" . $dbse->getMessage() . ")");
return null;
} catch (DBQueryException $dbqe) {
Logger::log_event(LOG_NOTICE, "[RI] ({$log_error_code}) Error with params (line (" . __LINE__ . ") in robot_certs-query.(" . $dbqe->getMessage() . ")");
return null;
}
switch (count($cert_res)) {
case 0:
Logger::log_event(LOG_NOTICE, "[RI] ({$log_error_code}): Unauthenticated client connected. Refusing to establish connection. " . $_SERVER['SSL_CLIENT_I_DN']);
echo "[{$log_error_code}] You are not authorized to use this API. This incident has been logged.\n";
return null;
case 1:
/*
* We have to do the compare in a rather awkward way to ensure
* that differences in spaces, newlines, tabs and whatnot are
* removed.
*/
openssl_x509_export(openssl_x509_read($_SERVER['SSL_CLIENT_CERT']), $stored_admin_dump);
openssl_x509_export(openssl_x509_read($cert_res[0]['cert']), $stored_client_dump);
if ($stored_admin_dump != $stored_client_dump) {
Logger::log_event(LOG_NOTICE, "[RI] ({$log_error_code}) Got matching fingerprint ({$fingerprint}) " . "but actual certificates differ! Aborting");
echo "[{$code}] There were issues with your certificate. Cannot continue using this cert.\n";
echo "Please use another certificate for the time being.\n";
echo "This event has been logged.\n";
return null;
}
break;
default:
Logger::log_event(LOG_ALERT, "[RI] ({$log_error_code}) Several certs (" . count($cert_res) . ") in DB matching fingerprint ({$fingerprint}), cannot auth client.");
return null;
}
/*
* Get the details for the owner of the certificate, use this as a
* basis for authenticating the person.
*
* It does not really matter which IdP-map we use, as long as we get one
* that points to the correct NREN. This is probably not the 'correct'
* way of using the idp_map, but atm, this is the only 'correct' way of
* decorating the NREN-object.
*/
try {
/* get admin */
$ares = MDB2Wrapper::execute("SELECT * FROM admins WHERE admin_id=?", array('text'), array($cert_res[0]['uploaded_by']));
if (count($ares) != 1) {
/* no admin found. This should not be possible, but be
* safe and test nevertheless */
return null;
}
/* get Subscriber */
$sres = MDB2Wrapper::execute("SELECT * FROM subscribers WHERE subscriber_id=?", array('text'), array($cert_res[0]['subscriber_id']));
if (count($sres) != 1) {
/* No subscriber found */
return null;
}
/* get NREN */
$nres = MDB2Wrapper::execute("SELECT n.*,im.idp_url FROM nrens n LEFT JOIN idp_map im ON im.nren_id = n.nren_id WHERE n.nren_id=?", array('text'), array($sres[0]['nren_id']));
if (count($nres) < 1) {
/* No nrens found at all, which means that the
* subscriber is bogus. Since this is a foreign-key
* constraint, we've run into a corrupt db. Let's hope
* this'll never happen :-) */
Logger::log_event(LOG_EMERG, "Found subscriber (" . $sres[0]['subscriber_id'] . ":" . $sres[0]['name'] . ") without a corresponding NREN (" . $sres[0]['nren_id'] . "), you have a corrupt database");
}
} catch (DBStatementException $dbse) {
$msg = "[{$log_error_code}] Problem executing query. Is the database-schema outdated?. ";
Logger::log_event(LOG_INFO, $msg . " Server said: " . $dbse->getMessage());
echo $msg . "<br />\nServer said: " . htmlentities($dbse->getMessage()) . "<br />\n";
return null;
} catch (DBQueryException $dbqe) {
/* FIXME */
$msg = "Could not find owner-details for certificate, probably issues with supplied data. ";
$msg .= "Admin_id: " . htmlentities($cert_res[0]['uploaded_by']);
Logger::log_event(LOG_INFO, $msg . " Server said: " . $dbqe->getMessage());
echo $msg . "<br />\nServer said: " . htmlentities($dbqe->getMessage()) . "<br />\n";
return null;
}
/*
* Decorate person.
*/
$person = new Person();
if (isset($ares[0]['admin_name']) && $ares[0]['admin_name'] != "") {
$person->setName($ares[0]['admin_name']);
} else {
$person->setName($ares[0]['admin']);
}
try {
$person->setEPPN($ares[0]['admin']);
} catch (CGE_CriticalAttributeException $cae) {
echo "[{$log_error_code}] Problems with setting the unique identifier for robot-admin.<br />\n";
echo "Check the data in admins (admin_id: " . htmlentities($cert_res[0]['uploaded_by']) . ")<br />\n";
Logger::log_event(LOG_NOTICE, "[RI] ({$log_error_code}) Internal error? Suddenly provided admin-uid is not available.");
return null;
}
$person->setAuth(true);
$person->setNREN(new NREN($nres[0]['idp_url']));
$person->setSubscriber(new Subscriber($sres[0]['name'], $person->getNREN()));
$person->setName($ares[0]['admin_name']);
$person->setEmail($ares[0]['admin_email']);
/* Robot authenticated, we can return the person and live happily ever
* after */
Logger::log_event(LOG_NOTICE, "[RI]: Authenticated robot-client via cert {$fingerprint} belonging to " . $person->getEPPN());
return $person;
}
// Example of using __toString to format the output of a print statement.
<?php
class Person
{
protected $name;
protected $email;
public function setName($name)
{
$this->name = $name;
}
public function setEmail($email)
{
$this->email = $email;
}
public function __toString()
{
return "{$this->name} <{$this->email}>";
}
}
// Example
$rasmus = new Person();
$rasmus->setName('Rasmus Lerdorf');
$rasmus->setEmail('*****@*****.**');
print $rasmus;
