public static function getResident($where) { $dado = Database::ReadOne("resident r, person p", "r.*, p.*", "WHERE p.id_person = r.id_person {$where}"); if (!$dado) { return ''; } $resident = new Resident(); $resident->setId($dado['ID_PERSON']); $resident->setName($dado['NAME_PERSON']); $resident->setEmail($dado['EMAIL']); $resident->setAge($dado['AGE']); $resident->setSex($dado['SEX']); $resident->setPhone($dado['PHONE']); $resident->setOperator($dado['OPERATOR']); $resident->setMaritalStatus($dado['MARITAL_STATUS']); $resident->setChildren($dado['CHILDREN']); $resident->setDateInsert($dado['INSERT_DATE']); $resident->setNumberResident($dado['NUMBER_RESIDENT_HOUSE']); $resident->setHouseFather($dado['HOUSEFATHER']); $resident->setCognateAdventista($dado['COGNATE_ADVENTISTA']); $religion = Religion::getReligion("WHERE id_religion = " . $dado['ID_RELIGION']); $resident->setReligion($religion); $address = Address::getAddress("AND id_address = " . $dado['ID_ADDRESS']); $resident->setAddress($address); $research = Research::getResearch('WHERE id_resident = ' . $dado['ID_PERSON']); $resident->setResearch($research); return $resident; }