/**
* 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);
}
}
public function indexAction()
{
$this->persistent->parameters = null;
$condominio = Condominio::findFirstByidcondominio('1');
print_r($condominio->usuario->acceso);
}
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);
}
/**
* Deletes a condominio
*
* @param string $idcondominio
*/
public function deleteAction($idcondominio)
{
$condominio = Condominio::findFirstByidcondominio($idcondominio);
if (!$condominio) {
$this->flash->error("condominio was not found");
return $this->dispatcher->forward(array("controller" => "condominio", "action" => "index"));
}
if (!$condominio->delete()) {
foreach ($condominio->getMessages() as $message) {
$this->flash->error($message);
}
return $this->dispatcher->forward(array("controller" => "condominio", "action" => "search"));
}
$this->flash->success("condominio was deleted successfully");
return $this->dispatcher->forward(array("controller" => "condominio", "action" => "index"));
}
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer the ID of the model to be loaded
*/
public function loadModel($id)
{
$model = Condominio::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
