function getUpdate($sqlDataArray = array())
{
if (isset($sqlDataArray['info_update_id'])) {
$this->sql = 'SELECT info_update_title,
info_update_id,
info_update_content,
info_update_date
FROM info_update
WHERE info_update_id = :info_update_id';
} else {
$this->sql = 'SELECT info_update_title,
info_update_id,
info_update_date
FROM info_update';
}
$this->results = $this->db->select($this->sql, $sqlDataArray);
$this->resultsQuantity = count($this->results);
foreach ($this->results as $key => $footerData) {
$this->results[$key]['info_update_title_url'] = Helpers::filterUrl($this->results[$key]['info_update_title']);
$this->results[$key]['info_update_date'] = Dates::convertDate($this->results[$key]['info_update_date']);
}
if ($this->resultsQuantity > 0) {
return $this->results;
} else {
FlashMessages::setFlashMessage('noresult', '<b>Not Found!</b><br />Update information you are looking for does not exist.');
}
}
/**
* footerSystemUpdate
*
* Retrieve updates of the system itens from database and send to content variables
*
* @return function Send the variables about the update to the content variables
*/
public function footerSystemUpdate()
{
$this->sql = 'SELECT info_update_id,
info_update_title
FROM info_update
LIMIT 6';
$this->results = $this->db->select($this->sql);
foreach ($this->results as $key => $footerData) {
$this->results[$key]['info_update_title_url'] = Helpers::filterUrl($this->results[$key]['info_update_title']);
}
View::setContentVars('footerSystemUpdate', $this->results);
}
