/** * @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; }