public function adiarCompromissos() { $this->load->model('agenda/agendaModel'); $this->load->dao('agendas/agendaDao'); $id_agenda = isset($_POST['id_agenda']) ? filter_var(trim($_POST['id_agenda'])) : ''; $data = isset($_POST['data']) ? filter_var(trim($_POST['data'])) : ''; $agendaModel = new agendaModel(); $agendaModel->setId($id_agenda); $agendaModel->setData($data); $agendaDao = new agendaDao(); echo $agendaDao->adiarCompromissos($agendaModel); // $this->load->library('dataValidator', null, true); // $this->load->dataValidator->set('Data', $data, 'data')->is_required(); }
public function adiarCompromissos(agendaModel $agendaModel) { try { $this->db->clear(); $this->db->setTabela('fornecedores_agenda'); $this->db->setCondicao("id_fornecedor_agenda = ?"); $this->db->setParameter(1, $agendaModel->getId()); if ($this->db->update(array('data_agenda' => $agendaModel->getData()))) { //selecionando o email do fornecedor $this->db->clear(); $this->db->setTabela('fornecedores as A, fornecedores_agenda as B, emails_fornecedores as C, emails as D'); $this->db->setCondicao("B.id_fornecedor_agenda = ? AND B.id_fornecedor = A.id_fornecedor AND A.id_fornecedor = C.id_fornecedor AND C.id_email = D.id_email"); $this->db->setParameter(1, $agendaModel->getId()); if ($this->db->select()) { $res = $this->db->resultAll(); foreach ($res as $e) { $this->sendMail($e['endereco_email'], $agendaModel->getData()); } } return true; } else { return $this->db->getError(); } } catch (Exception $e) { return $e->getMessageError(); } }