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();
}
}
