public function loadById($globalData, $object_id)
{
$validatorChain = new Zend_Validate();
$validatorChain->addValidator(new Zend_Validate_Int());
if (!$validatorChain->isValid($object_id)) {
return NULL;
}
$db = $globalData->takeConnection();
$select = $db->select();
$select->from('settlement');
$select->joinLeft('district', 'settlement.district=district.obj_id', array('district_name' => 'obj_name'));
$select->joinLeft('area', 'district.area=area.obj_id', array('area_name' => 'obj_name', 'area_id' => 'obj_id'));
$where = $db->quoteInto('settlement.obj_id = ?', $object_id);
$select->where($where);
// echo $select;
$stmt = $db->query($select);
$result = $stmt->fetchAll();
$row = current($result);
if ($row) {
$new_object = new RealEstateAgency_Object_Settlement();
$new_object->setGlobalData($globalData);
$new_object->completeFillByArray($row);
return $new_object;
} else {
return NULL;
}
}
private function completeFillByArray($array)
{
$result = array();
$globalData = $this->getGlobalData();
$objectsOfDistrict = $this->districts;
foreach ($array as $index => $hash) {
$object = new RealEstateAgency_Object_Settlement();
$object->setGlobalData($globalData);
$object->completeFillByArray($hash);
$result[] = $object;
}
return $result;
}
