Answered step by step
Verified Expert Solution
Question
1 Approved Answer
generate predicate logic statement for the following code public function getAddress(int $address_id): array { $address_query = $this->db->query(SELECT DISTINCT * FROM ` . DB_PREFIX . address`
generate predicate logic statement for the following code public function getAddress(int $address_id): array { |
$address_query = $this->db->query("SELECT DISTINCT * FROM `" . DB_PREFIX . "address` WHERE `address_id` = '" . (int)$address_id . "' AND `customer_id` = '" . (int)$this->customer->getId() . "'"); |
if ($address_query->num_rows) { |
$this->load->model('localisation/country'); |
$country_info = $this->model_localisation_country->getCountry($address_query->row['country_id']); |
if ($country_info) { |
$country = $country_info['name']; |
$iso_code_2 = $country_info['iso_code_2']; |
$iso_code_3 = $country_info['iso_code_3']; |
$address_format = $country_info['address_format']; |
} else { |
$country = ''; |
$iso_code_2 = ''; |
$iso_code_3 = ''; |
$address_format = ''; |
} |
$this->load->model('localisation/zone'); |
$zone_info = $this->model_localisation_zone->getZone($address_query->row['zone_id']); |
if ($zone_info) { |
$zone = $zone_info['name']; |
$zone_code = $zone_info['code']; |
} else { |
$zone = ''; |
$zone_code = ''; |
} |
return [ |
'address_id' => $address_query->row['address_id'], |
'firstname' => $address_query->row['firstname'], |
'lastname' => $address_query->row['lastname'], |
'company' => $address_query->row['company'], |
'address_1' => $address_query->row['address_1'], |
'address_2' => $address_query->row['address_2'], |
'postcode' => $address_query->row['postcode'], |
'city' => $address_query->row['city'], |
'zone_id' => $address_query->row['zone_id'], |
'zone' => $zone, |
'zone_code' => $zone_code, |
'country_id' => $address_query->row['country_id'], |
'country' => $country, |
'iso_code_2' => $iso_code_2, |
'iso_code_3' => $iso_code_3, |
'address_format' => $address_format, |
'custom_field' => json_decode($address_query->row['custom_field'], true), |
'default' => $address_query->row['default'] |
]; |
} else { |
return []; |
} |
}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started