/**
* Displays the creation form
*/
public function newAction()
{
$condominio = Phalcon\Tag::select(array("idcondominio", Condominio::find(), "using" => array("idcondominio", "nombre"), "class" => "form-control"));
$this->view->setVar("condominio", $condominio);
$date = new DateTime();
$this->view->setVar("date", $date);
}
/**
* Edits a usuario
*
* @param string $idusuario
*/
public function editAction($idusuario)
{
if (!$this->request->isPost()) {
$usuario = Usuario::findFirstByidusuario($idusuario);
if (!$usuario) {
$this->flash->error("usuario was not found");
return $this->dispatcher->forward(array("controller" => "usuario", "action" => "index"));
}
$condominio = Phalcon\Tag::select(array("idcondominio", Condominio::find(), "using" => array("idcondominio", "nombre"), "class" => "form-control"));
$this->view->setVar("condominio", $condominio);
$tipousuario = Phalcon\Tag::select(array("idtipos_usuario", TiposUsuario::find(), "using" => array("idtipos_usuario", "tipo"), "class" => "form-control"));
$this->view->setVar("tipousuario", $tipousuario);
$vehiculo = Phalcon\Tag::select(array("idvehiculo", Vehiculo::find(), "using" => array("idvehiculo", "placa"), "class" => "form-control"));
$this->view->setVar("vehiculo", $vehiculo);
$this->view->idusuario = $usuario->idusuario;
$this->tag->setDefault("idusuario", $usuario->idusuario);
$this->tag->setDefault("nombre", $usuario->nombre);
$this->tag->setDefault("apellido", $usuario->apellido);
$this->tag->setDefault("dpi", $usuario->dpi);
$this->tag->setDefault("idcondominio", $usuario->idcondominio);
$this->tag->setDefault("puesto", $usuario->puesto);
$this->tag->setDefault("idtipos_usuario", $usuario->idtipos_usuario);
$this->tag->setDefault("idvehiculo", $usuario->idvehiculo);
$this->tag->setDefault("fotografia", $usuario->fotografia);
}
}
/**
* Searches for condominio
*/
public function searchAction()
{
$numberPage = 1;
if ($this->request->isPost()) {
$query = Criteria::fromInput($this->di, "Condominio", $_POST);
$this->persistent->parameters = $query->getParams();
} else {
$numberPage = $this->request->getQuery("page", "int");
}
$parameters = $this->persistent->parameters;
if (!is_array($parameters)) {
$parameters = array();
}
$parameters["order"] = "idcondominio";
$condominio = Condominio::find($parameters);
if (count($condominio) == 0) {
$this->flash->notice("The search did not find any condominio");
return $this->dispatcher->forward(array("controller" => "condominio", "action" => "index"));
}
$paginator = new Paginator(array("data" => $condominio, "limit" => 10, "page" => $numberPage));
$this->view->page = $paginator->getPaginate();
}
public function resumenAction()
{
$desde = $this->request->getPost("desde");
$time_desde = new DateTime($desde);
$time_desde = $time_desde->format('Y-m-d H:i:s');
$hasta = $this->request->getPost("hasta");
$time_hasta = new DateTime($hasta);
$time_hasta = $time_hasta->format('Y-m-d H:i:s');
$idcondominio = $this->request->getPost("idcondominio");
$acceso = new Acceso();
$condominios = Condominio::find();
$tipos_v = TiposVehiculo::find();
echo '<h1>Resumen de Accesos</h1>';
echo "Del: {$desde} Al: {$hasta}";
if ($condominios->count() > 0) {
foreach ($condominios as $condominio) {
echo "<hr/>\n <h4>" . $condominio->nombre . '</h4>
<hr/>
<table class="table table-striped">
<tr>
<td>Tipo de Vehiculo</td>
<td> Total de Entradas y Salidas</td>
</tr>
';
$total = 0;
foreach ($tipos_v as $tipo) {
$resumen = $acceso->resumen($condominio->idcondominio, $time_desde, $time_hasta, $tipo->idtipos_vehiculo);
if ($resumen->count() > 0) {
$totaltipo = round($resumen->count() / 2);
echo '<tr>
<td>' . $tipo->tipo . '</td>
<td>' . $totaltipo . '</td>
</tr>';
$total = $total + $totaltipo;
}
}
echo ' </table> ';
echo '<div class="well">Total de Entradas/Saldias: ' . $total . '</div>';
}
}
echo "\n <script>\n \$('.side-nav').remove();\n \$('#wrapper').css('padding-left','0px');\n </script>\n ";
header("Content-Type: application/vnd.ms-excel; charset=utf-8");
header("Content-Disposition: attachment; filename=accesos.xlsx");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Cache-Control: private", false);
}
