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; }