Compartilhar variáveis entre dois métodos
Basicamente, o que eu tenho em uma classe são dois métodos.
- getEstablishment($establishmentId) que pega todos os dados de um determinado estabelecimento baseado no id passado.
- getAllEstablishments() que me da um array com todos os dados de todos os estabelecimentos que tenho no meu banco
Se repararem no código, vão ver que repete muitas variaveis, existe alguma forma de eu compartilha-lhas entre esses métodos?
function getEstablishment($establishmentId)
{
$query = "SELECT *
FROM establishment
WHERE establishment_id='{$establishmentId}'
LIMIT 0,1";
$result = mysqli_query($this->connection, $query);
$establishmentArray = mysqli_fetch_assoc($result);
$docNumber = $establishmentArray['doc_number'];
$legalName = $establishmentArray['legal_name'];
$socialName = $establishmentArray['social_name'];
$type = $establishmentArray['type_id'];
$email = $establishmentArray['email'];
$website = $establishmentArray['website'];
$plan = $establishmentArray['plan_id'];
$agreeTerm = $establishmentArray['agree_term'];
$address = $establishmentArray['address'];
$district = $establishmentArray['district'];
$city = $establishmentArray['city_id'];
$zipCode = $establishmentArray['postal_code'];
$phone = $establishmentArray['phone'];
$created = $establishmentArray['created'];
$lastUpdate = $establishmentArray['last_update'];
$establishment = new Establishment($docNumber, $legalName, $socialName, $type, $email, $website, $plan, $agreeTerm, $address, $district, $city, $zipCode, $phone, $created, $lastUpdate);
return $establishment;
}
function getAllEstablishments()
{
$establishments = array();
$query = "SELECT *
FROM establishment
ORDER BY establishment_id DESC";
$result = mysqli_query($this->connection, $query);
while ($establishmentArray = mysqli_fetch_assoc($result)) {
$establishmentId = $establishmentArray['establishment_id'];
$docNumber = $establishmentArray['doc_number'];
$legalName = $establishmentArray['legal_name'];
$socialName = $establishmentArray['social_name'];
$type = $establishmentArray['type_id'];
$email = $establishmentArray['email'];
$website = $establishmentArray['website'];
$plan = $establishmentArray['plan_id'];
$agreeTerm = $establishmentArray['agree_term'];
$address = $establishmentArray['address'];
$district = $establishmentArray['district'];
$city = $establishmentArray['city_id'];
$zipCode = $establishmentArray['postal_code'];
$phone = $establishmentArray['phone'];
$created = $establishmentArray['created'];
$lastUpdate = $establishmentArray['last_update'];
$establishment = new Establishment($docNumber, $legalName, $socialName, $type, $email, $website, $plan, $agreeTerm, $address, $district, $city, $zipCode, $phone, $created, $lastUpdate);
$establishment->setId($establishmentId);
array_push($establishments, $establishment);
}
return $establishments;
}Discussão (3)
Carregando comentários...