/**
* @brief Function get
* seleciona todos os campos do Banco de dados e retorna os valores das colunas ja descriptografado.
* @param void
* @return object
*/
public function get()
{
$i = 0;
$result = Dbcommand::select('tb_servicos', array('ALL'), 'ORDER BY SER_ID DESC');
while ($results = Dbcommand::arrays($result)) {
$this->service[$i] = new Service();
$this->service[$i]->setId($results['SER_ID']);
$this->service[$i]->setId_adm($results['SER_ID_ADM']);
foreach ($results as $key => $value) {
$results[$key] = Criptography::BASE64($value, 0);
}
$this->service[$i]->log = $results['SER_LOG'];
$this->service[$i]->date_in = $results['SER_DATA'];
$this->service[$i]->name = $results['SER_NOME'];
$this->service[$i]->about = str_replace('\\r\\n', ' ', $results['SER_SOBRE']);
$this->service[$i]->key = $results['SER_CHAVE'];
$i++;
}
$this->size = $i;
return $this;
}
/**
* @brief Function get
* seleciona todos os campos do Banco de dados e retorna os valores das colunas ja descriptografado.
* @param void
* @return void
*/
public function get()
{
$i = 0;
$result = Dbcommand::select('tb_emails', array('ALL'), 'ORDER BY EM_ID DESC');
while ($results = Dbcommand::arrays($result)) {
$this->mail[$i] = new Mail();
$this->mail[$i]->setId($results['EM_ID']);
$this->mail[$i]->status = $results['EM_STATUS'];
foreach ($results as $key => $value) {
$results[$key] = Criptography::BASE64($value, 0);
}
$this->mail[$i]->date_in = $results['EM_DATA'];
$this->mail[$i]->name = $results['EM_NOME'];
$this->mail[$i]->mail_job = $results['EM_EMAIL'];
$this->mail[$i]->title = $results['EM_ASSUNTO'];
$this->mail[$i]->message = str_replace('\\r\\n', ' ', $results['EM_MENSAGEM']);
$this->mail[$i]->phone = $results['EM_TEL'];
$i++;
}
$this->size = $i;
return $this;
}
/**
* @brief Function get
* seleciona todos os campos do Banco de dados e retorna os valores das colunas ja descriptografado.
* @param void
* @return object
*/
public function get()
{
$i = 0;
$name = Criptography::BASE64($this->name, 1);
$result = Dbcommand::select('tb_fotos', array('FOTO_NOME_ALBUM' => $name), 'ORDER BY FOTO_ID DESC');
while ($results = Dbcommand::arrays($result)) {
$this->photo[$i] = new Photo();
$this->photo[$i]->setId($results['FOTO_ID']);
$this->photo[$i]->setId_adm($results['FOTO_ID_ADM']);
foreach ($results as $key => $value) {
$results[$key] = Criptography::BASE64($value, 0);
}
$this->photo[$i]->log = $results['FOTO_LOG'];
$this->photo[$i]->date_in = $results['FOTO_DATA'];
$this->photo[$i]->name = $results['FOTO_NOME'];
$this->photo[$i]->albumName = $results['FOTO_NOME_ALBUM'];
$this->photo[$i]->url = $results['FOTO_URL'];
$i++;
}
$this->size = $i;
return $this;
}
