public static function loadById($globalData, $object_id)
{
if (!tools_verify_int($object_id)) {
return NULL;
}
$db = $globalData->takeConnection();
$select = $db->select();
$select->from('r_e_object');
$select->joinLeft('settlement', 'r_e_object.settlement_id=settlement.obj_id', array('settlement_name' => 'obj_name'));
$select->joinLeft('settlement_part', 'r_e_object.settl_area_id=settlement_part.obj_id', array('settlement_part_name' => 'obj_name'));
$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'));
$where = $db->quoteInto('r_e_object.obj_id = ?', $object_id);
$select->where($where);
$stmt = $db->query($select);
$result = $stmt->fetchAll();
$row = current($result);
if ($row) {
$new_object = new RealEstateAgency_Object_RealEstateObject();
$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_RealEstateObject();
$object->setGlobalData($globalData);
$object->completeFillByArray($hash);
$result[] = $object;
}
return $result;
}
