/** * 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; }