public function circularAction()
{
//Conectamos a BBDD
$sid = new Container('base');
$db_name = $sid->offsetGet('dbNombre');
$this->dbAdapter = $this->getServiceLocator()->get($db_name);
//Instancias
$dpto = new UnidadTable($this->dbAdapter);
$form = new NotificacionForm("form");
//Obtenemos combo dptos
$dptos = $dpto->getDatosActivos();
//Cargamos dptos en formulario
$form->get('id_unidad')->setAttribute('options', $dptos);
$this->layout('layout/comite');
return new ViewModel(array('form' => $form));
}
public function indexAction()
{
$this->layout('layout/conserje');
$sid = new Container('base');
$db_name = $sid->offsetGet('dbNombre');
$this->dbAdapter = $this->getServiceLocator()->get($db_name);
$dpto = new UnidadTable($this->dbAdapter);
$lista = $dpto->getDatosActivos();
$sDpto = "<select name='id_unidad' id='id_unidad' class='form-control'>";
foreach ($lista as $key => $value) {
$sDpto = $sDpto . "<option value='" . $key . "'>" . $value . "</option>";
}
$sDpto = $sDpto . "</select>";
//$sid->offsetSet('sDpto',$sDpto);
$sid->offsetSet('dpto', $sDpto);
return new ViewModel(array('rsptaOK' => SysFnc::rspOK(), 'imgView' => SysFnc::cargarVistaImagen()));
}
public function indexAction()
{
//Conectamos a BBDD
$sid = new Container('base');
$db_name = $sid->offsetGet('dbNombre');
$this->dbAdapter = $this->getServiceLocator()->get($db_name);
//Instancias
$dpto = new UnidadTable($this->dbAdapter);
$form = new NotificacionForm("form");
//Obtenemos combo dptos
$dptos = $dpto->getDatosActivos();
//Cargamos dptos en formulario
$form->get('id_unidad')->setAttribute('options', $dptos);
$this->layout('layout/conserje');
$result = new ViewModel(array('rsptaOK' => SysFnc::rspOK(), 'form' => $form));
//$result->setTerminal(true);
return $result;
}
public function nuevoAction()
{
$sid = new Container('base');
$db_name = $sid->offsetGet('dbNombre');
$this->dbAdapter = $this->getServiceLocator()->get($db_name);
$id = (int) $this->params()->fromRoute('id', 0);
if ($this->getRequest()->isPost()) {
$lista = $this->request->getPost();
$encomienda->nuevaEncomienda($lista);
} else {
$form = new EncomiendaForm("form");
$dpto = new UnidadTable($this->dbAdapter);
$lista = $dpto->getDatosActivos();
$form->get('id_dpto')->setAttribute('options', $lista);
$this->layout('layout/conserje');
$valores = array('form' => $form, 'rsptaOK' => SysFnc::rspOK(), 'nuevaPersona' => SysFnc::nuevaPersona());
return new ViewModel($valores);
}
}
public function registrarAction()
{
$sid = new Container('base');
$db_name = $sid->offsetGet('dbNombre');
$id_db = $sid->offsetGet('id_db');
$this->dbAdapter = $this->getServiceLocator()->get($db_name);
$this->layout('layout/conserje');
$time = time();
$fechaCompleta = date("d-m-Y H:i:s", $time);
setlocale(LC_TIME, 'spanish') . ': ';
$mostrarFechaEst = ucfirst(iconv('ISO-8859-1', 'UTF-8', strftime('%A %d de %B del %Y', time())));
$form = new VisitaForm("form");
$unidad = new UnidadTable($this->dbAdapter);
$motivo = new MotivoVisitaTable($this->dbAdapter);
$form->get('id_unidad')->setAttribute('options', $unidad->getDatosActivos());
$form->get('id_motivo')->setAttribute('options', $motivo->getDatosActivos());
$form->get('fechaHoraV')->setAttribute('value', $fechaCompleta);
$e = new EstacionamientoTable($this->dbAdapter);
$mapa = $e->getEstVist($this->dbAdapter);
return new ViewModel(array("form" => $form, "mapa" => $mapa, "mostrarFechaEst" => $mostrarFechaEst, 'rsptaOK' => SysFnc::rspOK(), 'nuevaPersona' => SysFnc::nuevaPersona()));
}
public function combounidadAction()
{
//conectamos a BBDD
$sid = new Container('base');
$db_name = $sid->offsetGet('dbNombre');
$this->dbAdapter = $this->getServiceLocator()->get($db_name);
//Instancias
$unid = new UnidadTable($this->dbAdapter);
$esta = new EstacionamientoTable($this->dbAdapter);
$bode = new BodegaTable($this->dbAdapter);
//Traemos data de combos
$combo1 = $unid->getDatosActivos();
$combo2 = $esta->getDatosActivos();
$combo3 = $bode->getDatosActivos();
//Retornamos a la vista
$result = new JsonModel(array('status' => 'ok', 'combo1' => $combo1, 'combo2' => $combo2, 'combo3' => $combo3));
return $result;
}
public function notificarAction()
{
//Conectamos a BBDD
$sid = new Container('base');
$db_name = $sid->offsetGet('dbNombre');
$remitente = "Comit�";
$this->dbAdapter = $this->getServiceLocator()->get($db_name);
//Obtenemos datos POST
$post = $this->request->getPost();
if (isset($post['destino'])) {
//Validamos si es mensaje directo a Dpto
if (isset($post['dpto'])) {
//Consultamos datos del dpto
$dptoMail = new UnidadTable($this->dbAdapter);
$lista = $dptoMail->getVerResidentesActivos($this->dbAdapter, $post['id_unidad']);
$htmlMarkup = \HtmlCorreo::htmlMensajeDirecto($lista[0]['nombre'], $remitente, $post['textbody']);
$html = new MimePart($htmlMarkup);
$html->type = "text/html";
$body = new MimeMessage();
$body->setParts(array($html));
$message = new Message();
$message->addTo($lista[0]['correo'])->addFrom('*****@*****.**', 'Notificacion becheck')->setSubject($post['asunto'])->setBody($body);
$transport = new SendmailTransport();
$transport->send($message);
//Retornamos a la vista
$result = new JsonModel(array('status' => 'ok', 'descripcion' => 'Se ha enviado correctamente un correo'));
//$result->setTerminal(true);
return $result;
}
$result = new JsonModel(array('status' => 'ok', 'descripcion' => $post));
$result->setTerminal(true);
return $result;
}
//Instancias
$dpto = new UnidadTable($this->dbAdapter);
$form = new NotificacionForm("form");
//Obtenemos combo dptos
$dptos = $dpto->getDatosActivos();
//Cargamos dptos en formulario
$form->get('id_unidad')->setAttribute('options', $dptos);
$this->layout('layout/comite');
return new ViewModel(array('form' => $form));
}