Find this useful? Enter your email to receive occasional updates for securing PHP code.

Signing you up...

Thank you for signing up!

PHP Decode

<?php namespace App\Controllers; use App\Libraries\GroceryCrud; use CodeIgniter\Database..

Decoded Output download

<?php 
 namespace App\Controllers; use App\Libraries\GroceryCrud; use CodeIgniter\Database\RawSql; use CodeIgniter\Shield\Entities\User; use CodeIgniter\I18n\Time; class Home extends BaseController { public function index() { $output = (object) array(); $output->titulo = "Resumen"; $db = \Config\Database::connect(); $salones = $this->datosSalones(); $output->salones = $salones->totalSalones; $output->mostrarCaja = true; $output->mostrarOcupacion = true; $output->mostrarInvitaciones = true; $output->mostrarAverias = true; $output->mostrarCargas = true; $output->mostrarCambios = true; $output->mostrarMantenimiento = true; $output->mostrarPedidos = true; $user = auth()->user(); if ($user->inGroup("tecnico")) { unset($output->mostrarCaja); unset($output->mostrarOcupacion); unset($output->mostrarInvitaciones); unset($output->mostrarCambios); unset($output->mostrarMantenimiento); unset($output->mostrarPedidos); } if ($user->inGroup("central")) { unset($output->mostrarCaja); unset($output->mostrarOcupacion); unset($output->mostrarInvitaciones); unset($output->mostrarCargas); } $output->titulo = "Usuario: " . auth()->user()->getEmail(); $this->borraDatosViejos(); $this->borraMensajesViejos(); return view("resumen.php", (array) $output); } private function borraDatosViejos() { $db = \Config\Database::connect(); $builder = $db->table("caja"); $todo = $builder->get(); foreach ($todo->getResult() as $row) { $fecha1 = Time::parse($row->fecha); $fecha2 = Time::now(); $diferencia = $fecha1->difference($fecha2); $totalDiferencia = $diferencia->getDays(); if ($totalDiferencia >= 30) { $builder->where("iCaja", $row->iCaja); $builder->delete(); } } $builder = $db->table("cargas"); $todo = $builder->get(); foreach ($todo->getResult() as $row) { $fecha1 = Time::parse($row->fecha); $fecha2 = Time::now(); $diferencia = $fecha1->difference($fecha2); $totalDiferencia = $diferencia->getDays(); if ($totalDiferencia >= 90) { $builder->where("iCarga", $row->iCarga); $builder->delete(); } } $builder = $db->table("invitaciones"); $todo = $builder->get(); foreach ($todo->getResult() as $row) { $fecha1 = Time::parse($row->fecha); $fecha2 = Time::now(); $diferencia = $fecha1->difference($fecha2); $totalDiferencia = $diferencia->getDays(); if ($totalDiferencia >= 30) { $builder->where("idInvitaciones", $row->idInvitaciones); $builder->delete(); } } $builder = $db->table("ocupacion"); $todo = $builder->get(); foreach ($todo->getResult() as $row) { $fecha1 = Time::parse($row->fecha); $fecha2 = Time::now(); $diferencia = $fecha1->difference($fecha2); $totalDiferencia = $diferencia->getDays(); if ($totalDiferencia >= 90) { $builder->where("iOcupacion", $row->iOcupacion); $builder->delete(); } } $builder = $db->table("averias"); $builder->where("estado", 0); $todo = $builder->get(); foreach ($todo->getResult() as $row) { $fecha1 = Time::parse($row->fechaFin); $fecha2 = Time::now(); $diferencia = $fecha1->difference($fecha2); $totalDiferencia = $diferencia->getDays(); if ($totalDiferencia >= 30) { if ($row->firmaEmpleado != '') { if (file_exists($row->firmaEmpleado)) { unlink($row->firmaEmpleado); } } if ($row->firmaTecnico != '') { if (file_exists($row->firmaTecnico)) { unlink($row->firmaTecnico); } } $builder->where("iAveria", $row->iAveria); $builder->delete(); } } $builder = $db->table("cambios"); $builder->where("estado", 0); $todo = $builder->get(); foreach ($todo->getResult() as $row) { $fecha1 = Time::parse($row->fechaFin); $fecha2 = Time::now(); $diferencia = $fecha1->difference($fecha2); $totalDiferencia = $diferencia->getDays(); if ($totalDiferencia >= 90) { if ($row->firmaEmpleado != '') { if (file_exists($row->firmaEmpleado)) { unlink($row->firmaEmpleado); } } if ($row->firmaTecnico != '') { if (file_exists($row->firmaTecnico)) { unlink($row->firmaTecnico); } } $builder->where("iCambios", $row->iCambios); $builder->delete(); } } $builder = $db->table("mantenimiento"); $builder->where("estado", 0); $todo = $builder->get(); foreach ($todo->getResult() as $row) { $fecha1 = Time::parse($row->fechaFin); $fecha2 = Time::now(); $diferencia = $fecha1->difference($fecha2); $totalDiferencia = $diferencia->getDays(); if ($totalDiferencia >= 90) { if ($row->firmaEmpleado != '') { if (file_exists($row->firmaEmpleado)) { unlink($row->firmaEmpleado); } } if ($row->firmaTecnico != '') { if (file_exists($row->firmaTecnico)) { unlink($row->firmaTecnico); } } $builder->where("iMantenimiento", $row->iMantenimiento); $builder->delete(); } } $builder = $db->table("pedidos"); $builder->where("estado", 0); $todo = $builder->get(); foreach ($todo->getResult() as $row) { $fecha1 = Time::parse($row->fechaFin); $fecha2 = Time::now(); $diferencia = $fecha1->difference($fecha2); $totalDiferencia = $diferencia->getDays(); if ($totalDiferencia >= 30) { if ($row->firmaEmpleado != '') { if (file_exists($row->firmaEmpleado)) { unlink($row->firmaEmpleado); } } $builder->where("iPedido", $row->iPedido); $builder->delete(); } } } private function borraMensajesViejos() { $db = \Config\Database::connect(); $builder = $db->table("messages"); $todo = $builder->get(); foreach ($todo->getResult() as $row) { $fecha1 = Time::parse($row->createdAt); $fecha2 = Time::now(); $diferencia = $fecha1->difference($fecha2); $totalDiferencia = $diferencia->getDays(); if ($totalDiferencia >= 60) { if ($row->audio != '') { $f = $row->audio; $fichero = substr($f, strlen(base_url()), strlen($f)); if (file_exists($fichero)) { unlink($fichero); } } if ($row->video != '') { $f = $row->video; $fichero = substr($f, strlen(base_url()), strlen($f)); if (file_exists($fichero)) { unlink($fichero); } } if ($row->image != '') { $f = $row->image; $fichero = substr($f, strlen(base_url()), strlen($f)); if (file_exists($fichero)) { unlink($fichero); } } $builder->where("_id", $row->_id); $builder->delete(); } } } private function datosSalones() : object { $db = \Config\Database::connect(); $builder = $db->table("salones"); $builder->orderBy("nSalon"); $salones = $builder->get(); $salones = $salones->getResult(); $cajas = $this->datosCaja()->totalCajaSalones; $ocupacion = $this->datosOcupacion()->totalOcupacionSalones; $invitaciones = $this->datosInvitaciones()->totalInvitacionesSalones; $averias = $this->datosAverias(); $averiasPromedio = $averias->averiasPromedio; $averias = $averias->totalAveriasSalones; $cargas = $this->datosCargas()->totalCargasSalones; $cambios = $this->datosCambios()->totalCambiosSalones; $mantenimiento = $this->datosMantenimiento()->totalMantenimientoSalones; $pedidos = $this->datosPedidos()->totalPedidosSalones; $tmp = array(); foreach ($salones as $row) { if (!isset($row->totalCaja)) { $row->totalCaja = 0; } if (isset($cajas[$row->iSalon])) { $row->totalCaja += $cajas[$row->iSalon]; } if (!isset($row->totalOcupacion)) { $row->totalOcupacion = 0; } if (isset($ocupacion[$row->iSalon])) { $row->totalOcupacion += $ocupacion[$row->iSalon]; } if (!isset($row->totalInvitacionesHoy)) { $row->totalInvitacionesHoy = 0; } if (!isset($row->totalInvitacionesMes)) { $row->totalInvitacionesMes = 0; } if (isset($invitaciones[$row->iSalon]["hoy"])) { $row->totalInvitacionesHoy += number_format($invitaciones[$row->iSalon]["hoy"], 2); } if (isset($invitaciones[$row->iSalon]["mes"])) { $row->totalInvitacionesMes += number_format($invitaciones[$row->iSalon]["mes"], 2); } if (!isset($row->totalAverias)) { $row->totalAverias = 0; } if (isset($averias[$row->iSalon])) { $row->totalAverias = $averias[$row->iSalon]; } if (!isset($row->totalCargas)) { $row->totalCargas = 0; } if (isset($cargas[$row->iSalon])) { $row->totalCargas += $cargas[$row->iSalon]; } if (!isset($row->totalCambios)) { $row->totalCambios = 0; } if (isset($cambios[$row->iSalon])) { $row->totalCambios += $cambios[$row->iSalon]; } if (!isset($row->totalMantenimiento)) { $row->totalMantenimiento = 0; } if (isset($mantenimiento[$row->iSalon])) { $row->totalMantenimiento = $mantenimiento[$row->iSalon]; } if (!isset($row->totalPedidos)) { $row->totalPedidos = 0; } if (isset($pedidos[$row->iSalon])) { $row->totalPedidos = $pedidos[$row->iSalon]; } array_push($tmp, $row); } $retorno = (object) array(); $retorno->totalSalones = $tmp; return $retorno; } private function datosCaja() : object { $db = \Config\Database::connect(); $builder = $db->table("caja"); $builder->where("fecha >", new RawSql("CURDATE()")); $builder->orderBy("iSalon"); $total = $builder->get(); $salon = 0; $salones = array(); foreach ($total->getResult() as $row) { $salones[$row->iSalon] = 0; } foreach ($total->getResult() as $row) { $salones[$row->iSalon] += $row->totalCaja; } $retorno = (object) array(); $retorno->totalCajaSalones = $salones; return $retorno; } private function datosOcupacion() : object { $db = \Config\Database::connect(); $builder = $db->table("ocupacion"); $builder->where("fecha >", new RawSql("CURDATE()")); $builder->orderBy("iSalon"); $total = $builder->get(); $salones = array(); foreach ($total->getResult() as $row) { $salones[$row->iSalon] = 0; } foreach ($total->getResult() as $row) { $salones[$row->iSalon] += $row->totalHora; } $retorno = (object) array(); $retorno->totalOcupacionSalones = $salones; return $retorno; } private function datosInvitaciones() : object { $db = \Config\Database::connect(); $builder = $db->table("invitaciones"); $builder->where("fecha >=", new RawSql("DATE_SUB(CURRENT_DATE(), INTERVAL 32 DAY)")); $builder->orderBy("iSalon"); $total = $builder->get(); $salones = array(); foreach ($total->getResult() as $row) { $salones[$row->iSalon] = array("mes" => 0, "hoy" => 0); } $fecha1 = Time::createFromDate(null, null, null, "Europe/London", "es_ES"); foreach ($total->getResult() as $row) { $fecha2 = Time::parse($row->fecha, "Europe/London", "es_ES"); $fecha2 = Time::createFromDate($fecha2->getYear(), $fecha2->getMonth(), $fecha2->getDay(), "Europe/London", "es_ES"); $diferencia = $fecha1->difference($fecha2); if ($fecha1->getMonth() == $fecha2->getMonth()) { if ($diferencia->getDays() == 0) { $salones[$row->iSalon]["hoy"] += $row->coste; } else { $salones[$row->iSalon]["mes"] += $row->coste; } } } $retorno = (object) array(); $retorno->totalInvitacionesSalones = $salones; return $retorno; } private function datosAverias() : object { $db = \Config\Database::connect(); $builder = $db->table("averias"); $builder->where("estado", 1); $builder->orderBy("iSalon"); $total = $builder->get(); $salones = array(); foreach ($total->getResult() as $row) { $salones[$row->iSalon] = 0; } foreach ($total->getResult() as $row) { $salones[$row->iSalon]++; } $retorno = (object) array(); $retorno->totalAveriasSalones = $salones; $builder->where("estado", 0); $builder->where("fecha >=", new RawSql("DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)")); $terminadas = $builder->get(); $totalDiferencia = 0; foreach ($terminadas->getResult() as $row) { $fecha1 = Time::parse($row->fecha); $fecha2 = Time::parse($row->fechaFin); $diferencia = $fecha1->difference($fecha2); $totalDiferencia += $diferencia->getMinutes(); } $promedio = 0; if ($terminadas->getNumRows() > 0) { $promedio = $totalDiferencia / $terminadas->getNumRows(); if ($promedio > 60) { $promedio = strval(round($promedio / 60, 2)) . " h"; } else { $promedio = strval(round($promedio, 2)) . " m"; } } $retorno->averiasPromedio = $promedio; return $retorno; } private function datosCargas() : object { $db = \Config\Database::connect(); $builder = $db->table("cargas"); $builder->where("fecha >", new RawSql("CURDATE()")); $builder->orderBy("iSalon"); $total = $builder->get(); $salones = array(); foreach ($total->getResult() as $row) { $salones[$row->iSalon] = 0; } foreach ($total->getResult() as $row) { $salones[$row->iSalon]++; } $retorno = (object) array(); $retorno->totalCargasSalones = $salones; return $retorno; } private function datosCambios() : object { $db = \Config\Database::connect(); $builder = $db->table("cambios"); $builder->where("estado", 1); $builder->orderBy("iSalon"); $total = $builder->get(); $salones = array(); foreach ($total->getResult() as $row) { $salones[$row->iSalon] = 0; } foreach ($total->getResult() as $row) { $salones[$row->iSalon]++; } $retorno = (object) array(); $retorno->totalCambiosSalones = $salones; return $retorno; } private function datosMantenimiento() : object { $db = \Config\Database::connect(); $builder = $db->table("mantenimiento"); $builder->where("estado", 1); $builder->orderBy("iSalon"); $total = $builder->get(); $salones = array(); foreach ($total->getResult() as $row) { $salones[$row->iSalon] = 0; } foreach ($total->getResult() as $row) { $salones[$row->iSalon]++; } $retorno = (object) array(); $retorno->totalMantenimientoSalones = $salones; return $retorno; } private function datosPedidos() : object { $db = \Config\Database::connect(); $builder = $db->table("pedidos"); $builder->where("estado", 1); $builder->orderBy("pedido"); $total = $builder->get(); $salones = array(); foreach ($total->getResult() as $row) { $salones[$row->iSalon] = 0; } $pedidoActual = 0; foreach ($total->getResult() as $row) { if ($pedidoActual != $row->pedido) { $pedidoActual = $row->pedido; $salones[$row->iSalon]++; } } $retorno = (object) array(); $retorno->totalPedidosSalones = $salones; return $retorno; } public function logout() { auth()->logout(); return redirect()->to("/"); } private function _crud_output($output = null) { return view("crud_admin_v.php", (array) $output); } public function averias() : string { $user = auth()->user(); if (!$user->inGroup("jefes", "consulta", "tecnico", "central")) { header("Location: " . base_url()); die; } $crud = new GroceryCrud(); $crud->setTable("averias")->setSubject("Averia", "Averias")->columns(array("fecha", "fechaFin", "iSalon", "iMaquina", "id", "nombreTecnico", "firmaTecnico", "iEmpleado", "firmaEmpleado", "observaciones", "estado"))->setRelation("iEmpleado", "empleados", "{nEmpleado}  {aEmpleado}")->setRelation("iMaquina", "datos_maquinas", "nMaquina")->setRelation("iSalon", "salones", "nSalon")->setRelation("id", "datos_averias", "nombre")->displayAs("iSalon", "Sal\xc3\263n")->displayAs("iEmpleado", "NombreEmpleado")->displayAs("iMaquina", "M\303\xa1quina")->displayAs("id", "Tipo aver\303\xada")->callbackColumn("firmaEmpleado", function ($value, $row) { if ($value != '') { return "<img src='" . base_url($value) . "' class='img-fluid' width=100></a>"; } else { return "<div></div>"; } })->callbackColumn("firmaTecnico", function ($value, $row) { if ($value != '') { return "<img src='" . base_url($value) . "' class='img-fluid' width=100></a>"; } else { return "<div></div>"; } })->unsetEditFields(array("firmaEmpleado", "firmaTecnico"))->unsetReadFields(array("firmaEmpleado", "firmaTecnico"))->unsetDelete()->unsetPrint(); $user = auth()->user(); if ($user->inGroup("jefes")) { $crud->setRead(); $crud->setDelete(); $crud->setEdit(); } else { $crud->unsetEdit(); $crud->unsetAdd(); $crud->setRead(); } $output = $crud->render(); $output->titulo = "Aver\xc3\xadas"; return $this->_crud_output($output); } public function caja() : string { $user = auth()->user(); if (!$user->inGroup("jefes", "consulta")) { header("Location: " . base_url()); die; } $crud = new GroceryCrud(); $crud->setTable("caja")->setRead()->setRelation("iEmpleado", "empleados", "{nEmpleado}  {aEmpleado}")->setRelation("iSalon", "salones", "nSalon")->displayAs("iEmpleado", "Empleado")->displayAs("iSalon", "Sal\303\xb3n")->displayAs("b500", "Billetes 500")->displayAs("b200", "Billetes 200")->displayAs("b100", "Billetes 100")->displayAs("b50", "Billetes 50")->displayAs("b20", "Billetes 20")->displayAs("b10", "Billetes 10")->displayAs("b5", "Billetes 5")->displayAs("m2", "Monedas 2")->displayAs("m1", "Monedas 1")->displayAs("m050", "Monedas 0,50")->displayAs("m020", "Monedas 0,20")->displayAs("m010", "Monedas 0,10")->displayAs("m005", "Monedas 0,05")->displayAs("m002", "Monedas 0,02")->displayAs("m001", "Monedas 0,01")->displayAs("pdatafono", "Dat\xc3\241fono")->displayAs("phandpaid", "Handpaid")->displayAs("pfacturas", "Facturas")->displayAs("pinvitaciones", "Invitaciones")->displayAs("pringo", "Ringo")->displayAs("pvarios", "Varios")->unsetDelete()->unsetPrint(); $user = auth()->user(); if ($user->inGroup("jefes")) { $crud->setRead(); $crud->setDelete(); } else { $crud->unsetEdit(); $crud->unsetAdd(); $crud->setRead(); } $output = $crud->render(); $output->titulo = "Caja"; return $this->_crud_output($output); } public function cambios() : string { $user = auth()->user(); if (!$user->inGroup("jefes", "consulta", "central")) { header("Location: " . base_url()); die; } $crud = new GroceryCrud(); $crud->setTable("cambios")->setRead()->setRelation("iEmpleado", "empleados", "{nEmpleado}  {aEmpleado}")->setRelation("iSalon", "salones", "nSalon")->displayAs("iEmpleado", "Empleado")->displayAs("iSalon", "Sal\303\xb3n")->displayAs("b500", "Billetes 500")->displayAs("b200", "Billetes 200")->displayAs("b100", "Billetes 100")->displayAs("b50", "Billetes 50")->displayAs("b20", "Billetes 20")->displayAs("b10", "Billetes 10")->displayAs("b5", "Billetes 5")->displayAs("m2", "Monedas 2")->displayAs("m1", "Monedas 1")->displayAs("m050", "Monedas 0,50")->displayAs("m020", "Monedas 0,20")->displayAs("m010", "Monedas 0,10")->displayAs("m005", "Monedas 0,05")->displayAs("m002", "Monedas 0,02")->displayAs("m001", "Monedas 0,01")->callbackColumn("firmaEmpleado", function ($value, $row) { if ($value != '') { return "<img src='" . base_url($value) . "' class='img-fluid' width=100></a>"; } else { return "<div></div>"; } })->callbackColumn("firmaTecnico", function ($value, $row) { if ($value != '') { return "<img src='" . base_url($value) . "' class='img-fluid' width=100></a>"; } else { return "<div></div>"; } })->unsetEditFields(array("firmaEmpleado", "firmaTecnico"))->unsetReadFields(array("firmaEmpleado", "firmaTecnico"))->unsetDelete()->unsetPrint(); $user = auth()->user(); if ($user->inGroup("jefes")) { $crud->setRead(); $crud->setDelete(); } else { $crud->unsetEdit(); $crud->unsetAdd(); $crud->setRead(); } $output = $crud->render(); $output->titulo = "Cambios"; return $this->_crud_output($output); } public function cargas() : string { $user = auth()->user(); if (!$user->inGroup("jefes", "consulta", "tecnico")) { header("Location: " . base_url()); die; } $crud = new GroceryCrud(); $crud->setTable("cargas")->columns(array("fecha", "iSalon", "iMaquina", "observaciones", "nombreTecnico", "firmaTecnico", "nombreEmpleado", "firmaEmpleado", "importe"))->setRead()->setSubject("Carga", "Cargas")->setRelation("iMaquina", "datos_maquinas", "nMaquina")->setRelation("iSalon", "salones", "nSalon")->displayAs("iSalon", "Sal\303\263n")->displayAs("iMaquina", "M\xc3\241quina")->callbackColumn("firmaEmpleado", function ($value, $row) { if ($value != '') { return "<img src='" . base_url($value) . "' class='img-fluid' width=100></a>"; } else { return "<div></div>"; } })->callbackColumn("firmaTecnico", function ($value, $row) { if ($value != '') { return "<img src='" . base_url($value) . "' class='img-fluid' width=100></a>"; } else { return "<div></div>"; } })->unsetEditFields(array("firmaEmpleado", "firmaTecnico"))->unsetReadFields(array("firmaEmpleado", "firmaTecnico"))->unsetDelete()->unsetPrint(); $user = auth()->user(); if ($user->inGroup("jefes")) { $crud->setRead(); $crud->setDelete(); } else { $crud->unsetEdit(); $crud->unsetAdd(); $crud->setRead(); } $output = $crud->render(); $output->titulo = "Cargas"; return $this->_crud_output($output); } public function empleados() : string { $user = auth()->user(); if (!$user->inGroup("jefes", "consulta")) { header("Location: " . base_url()); die; } $crud = new GroceryCrud(); $crud->setTable("empleados")->setSubject("Empleado", "Empleados")->setRead()->displayAs("nEmpleado", "Nombre")->displayAs("aEmpleado", "Apellidos")->displayAs("iEmpleado", "Clave")->unsetDelete()->unsetPrint(); $user = auth()->user(); if ($user->inGroup("jefes")) { $crud->setRead(); $crud->setDelete(); } else { $crud->unsetEdit(); $crud->unsetAdd(); $crud->setRead(); } $output = $crud->render(); $output->titulo = "Empleados"; return $this->_crud_output($output); } public function invitaciones() : string { $user = auth()->user(); if (!$user->inGroup("jefes", "consulta")) { header("Location: " . base_url()); die; } $crud = new GroceryCrud(); $crud->setTable("invitaciones")->setSubject("Invitaci\303\263n", "Invitaciones")->setRead()->setRelation("iEmpleado", "empleados", "{nEmpleado}  {aEmpleado}")->setRelation("iSalon", "salones", "nSalon")->setRelation("iMaquina", "datos_maquinas", "nMaquina")->setRelation("iProducto", "datos_invitaciones", "nProducto")->displayAs("iEmpleado", "Empleado")->displayAs("iSalon", "Sal\xc3\xb3n")->displayAs("iMaquina", "M\303\241quina")->displayAs("iProducto", "Producto")->unsetDelete()->unsetPrint(); $user = auth()->user(); if ($user->inGroup("jefes")) { $crud->setRead(); $crud->setDelete(); } else { $crud->unsetEdit(); $crud->unsetAdd(); $crud->setRead(); } $output = $crud->render(); $output->titulo = "Invitaciones"; return $this->_crud_output($output); } public function mantenimientos() : string { $user = auth()->user(); if (!$user->inGroup("jefes", "consulta", "central")) { header("Location: " . base_url()); die; } $crud = new GroceryCrud(); $crud->setTable("mantenimiento")->setRead()->setSubject("Mantenimiento", "Mantenimientos")->setRelation("iEmpleado", "empleados", "{nEmpleado}  {aEmpleado}")->setRelation("iSalon", "salones", "nSalon")->setRelation("id", "datos_mantenimiento", "nombre")->setRelation("iZona", "datos_zonas", "nZona")->displayAs("iEmpleado", "Empleado")->displayAs("iSalon", "Sal\303\xb3n")->displayAs("id", "Tipo mantenimiento")->displayAs("iZona", "Zona")->callbackColumn("firmaEmpleado", function ($value, $row) { if ($value != '') { return "<img src='" . base_url($value) . "' class='img-fluid' width=100></a>"; } else { return "<div></div>"; } })->callbackColumn("firmaTecnico", function ($value, $row) { if ($value != '') { return "<img src='" . base_url($value) . "' class='img-fluid' width=100></a>"; } else { return "<div></div>"; } })->unsetEditFields(array("firmaEmpleado", "firmaTecnico"))->unsetReadFields(array("firmaEmpleado", "firmaTecnico"))->unsetDelete()->unsetPrint(); $user = auth()->user(); if ($user->inGroup("jefes")) { $crud->setRead(); $crud->setDelete(); } else { $crud->unsetEdit(); $crud->unsetAdd(); $crud->setRead(); } $output = $crud->render(); $output->titulo = "Mantenimientos"; return $this->_crud_output($output); } public function maquinas() : string { $user = auth()->user(); if (!$user->inGroup("jefes", "consulta")) { header("Location: " . base_url()); die; } $crud = new GroceryCrud(); $crud->setTable("datos_maquinas")->setSubject("M\xc3\xa1quina", "M\303\xa1quinas")->setRead()->columns(array("iMaquina", "nMaquina"))->displayAs("iMaquina", "Codigo")->displayAs("nMaquina", "Nombre")->unsetAddFields(array("iMaquina"))->unsetEditFields(array("iMaquina"))->unsetDelete()->unsetPrint(); $user = auth()->user(); if ($user->inGroup("jefes")) { $crud->setRead(); $crud->setDelete(); } else { $crud->unsetEdit(); $crud->unsetAdd(); $crud->setRead(); } $output = $crud->render(); $output->titulo = "M\xc3\xa1quinas"; return $this->_crud_output($output); } public function ocupacion() : string { $user = auth()->user(); if (!$user->inGroup("jefes", "consulta")) { header("Location: " . base_url()); die; } $crud = new GroceryCrud(); $crud->setTable("ocupacion")->setRead()->setRelation("iEmpleado", "empleados", "{nEmpleado}  {aEmpleado}")->setRelation("iSalon", "salones", "nSalon")->displayAs("iEmpleado", "Empleado")->displayAs("iSalon", "Sal\303\xb3n")->displayAs("ruletaH", "Ruleta hombres")->displayAs("ruletaM", "Ruleta mujeres")->displayAs("zonabH", "Zona B hombres")->displayAs("zonabM", "Zona A mujeres")->displayAs("apuestasH", "Apuestas hombres")->displayAs("apuestasM", "Apuestas mujeres")->displayAs("ringoH", "Ringo hombres")->displayAs("ringoM", "Ringo mujeres")->unsetDelete()->unsetPrint(); $user = auth()->user(); if ($user->inGroup("jefes")) { $crud->setRead(); $crud->setDelete(); } else { $crud->unsetEdit(); $crud->unsetAdd(); $crud->setRead(); } $output = $crud->render(); $output->titulo = "Ocupaci\303\xb3n"; return $this->_crud_output($output); } public function pedidos() : string { $user = auth()->user(); if (!$user->inGroup("jefes", "consulta", "central")) { header("Location: " . base_url()); die; } $crud = new GroceryCrud(); $crud->setTable("pedidos")->setRead()->columns(array("fecha", "fechaFin", "pedido", "iSalon", "iEmpleado", "id", "cantidad", "texto", "nombreTecnico", "firmaTecnico", "nombreEmpleado", "firmaEmpleado", "observaciones", "estado"))->setRelation("iEmpleado", "empleados", "{nEmpleado}  {aEmpleado}")->setRelation("iSalon", "salones", "nSalon")->setRelation("id", "datos_pedidos", "nombre")->displayAs("id", "Producto")->displayAs("iEmpleado", "Pedido por")->displayAs("iSalon", "Sal\xc3\263n")->callbackColumn("firmaEmpleado", function ($value, $row) { if ($value != '') { return "<img src='" . base_url($value) . "' class='img-fluid' width=100></a>"; } else { return "<div></div>"; } })->callbackColumn("firmaTecnico", function ($value, $row) { if ($value != '') { return "<img src='" . base_url($value) . "' class='img-fluid' width=100></a>"; } else { return "<div></div>"; } })->unsetEditFields(array("firmaEmpleado", "firmaTecnico"))->unsetReadFields(array("firmaEmpleado", "firmaTecnico"))->unsetDelete()->unsetPrint(); $user = auth()->user(); if ($user->inGroup("jefes")) { $crud->setRead(); $crud->setDelete(); } else { $crud->unsetEdit(); $crud->unsetAdd(); $crud->setRead(); } $output = $crud->render(); $output->titulo = "Pedidos"; return $this->_crud_output($output); } public function salones() : string { $user = auth()->user(); if (!$user->inGroup("jefes", "consulta")) { header("Location: " . base_url()); die; } $crud = new GroceryCrud(); $crud->setTable("salones")->setSubject("Sal\xc3\263n", "Salones")->where("salones.iSalon > 90")->columns(array("iSalon", "nSalon", "usuario", "clave", "fondo"))->displayAs("iSalon", "Codigo")->displayAs("nSalon", "Nombre")->displayAs("usuario", "Alias")->displayAs("clave", "Clave")->displayAs("fondo", "Fondo caja")->unsetAddFields(array("token", "iSalon"))->unsetEditFields(array("token", "iSalon"))->unsetReadFields(array("token"))->unsetDelete()->unsetPrint(); $user = auth()->user(); if ($user->inGroup("jefes")) { $crud->setRead(); } else { $crud->unsetEdit(); $crud->unsetAdd(); $crud->setRead(); } $output = $crud->render(); $output->titulo = "Salones"; return $this->_crud_output($output); } public function taverias() : string { $user = auth()->user(); if (!$user->inGroup("jefes", "consulta")) { header("Location: " . base_url()); die; } $crud = new GroceryCrud(); $crud->setTable("datos_averias")->setRead()->setSubject("Tipo aver\xc3\255a")->columns(array("id", "nombre"))->displayAs("nombre", "Tipo")->displayAs("id", "C\xc3\263digo")->unsetDelete()->unsetPrint(); $user = auth()->user(); if ($user->inGroup("jefes")) { $crud->setRead(); $crud->setDelete(); } else { $crud->unsetEdit(); $crud->unsetAdd(); $crud->setRead(); } $output = $crud->render(); $output->titulo = "Tipos aver\xc3\255a"; return $this->_crud_output($output); } public function tinvitaciones() : string { $user = auth()->user(); if (!$user->inGroup("jefes", "consulta")) { header("Location: " . base_url()); die; } $crud = new GroceryCrud(); $crud->setTable("datos_invitaciones")->setRead()->setSubject("Tipo invitaci\303\xb3n")->columns(array("iProducto", "nProducto", "cProducto"))->displayAs("iProducto", "C\303\263digo")->displayAs("nProducto", "Producto")->displayAs("cProducto", "Coste")->unsetDelete()->unsetPrint(); $user = auth()->user(); if ($user->inGroup("jefes")) { $crud->setRead(); $crud->setDelete(); } else { $crud->unsetEdit(); $crud->unsetAdd(); $crud->setRead(); } $output = $crud->render(); $output->titulo = "Tipos invitaci\xc3\xb3n"; return $this->_crud_output($output); } public function tmantenimientos() : string { $user = auth()->user(); if (!$user->inGroup("jefes", "consulta")) { header("Location: " . base_url()); die; } $crud = new GroceryCrud(); $crud->setTable("datos_mantenimiento")->setRead()->setSubject("Tipo mantenimiento")->columns(array("id", "nombre"))->displayAs("nombre", "Tipo")->displayAs("id", "C\xc3\xb3digo")->unsetDelete()->unsetPrint(); $user = auth()->user(); if ($user->inGroup("jefes")) { $crud->setRead(); $crud->setDelete(); } else { $crud->unsetEdit(); $crud->unsetAdd(); $crud->setRead(); } $output = $crud->render(); $output->titulo = "Tipos mantenimientos"; return $this->_crud_output($output); } public function tzonas() : string { $user = auth()->user(); if (!$user->inGroup("jefes", "consulta")) { header("Location: " . base_url()); die; } $crud = new GroceryCrud(); $crud->setTable("datos_zonas")->setRead()->setSubject("Tipo zonas")->columns(array("iZona", "nZona"))->displayAs("nZona", "Tipo")->displayAs("iZona", "C\303\263digo")->unsetDelete()->unsetPrint(); $user = auth()->user(); if ($user->inGroup("jefes")) { $crud->setRead(); $crud->setDelete(); } else { $crud->unsetEdit(); $crud->unsetAdd(); $crud->setRead(); } $output = $crud->render(); $output->titulo = "Tipos zonas"; return $this->_crud_output($output); } } ?>

Did this file decode correctly?

Original Code

<?php
 namespace App\Controllers; use App\Libraries\GroceryCrud; use CodeIgniter\Database\RawSql; use CodeIgniter\Shield\Entities\User; use CodeIgniter\I18n\Time; class Home extends BaseController { public function index() { $output = (object) array(); $output->titulo = "\122\145\163\165\155\x65\x6e"; $db = \Config\Database::connect(); $salones = $this->datosSalones(); $output->salones = $salones->totalSalones; $output->mostrarCaja = true; $output->mostrarOcupacion = true; $output->mostrarInvitaciones = true; $output->mostrarAverias = true; $output->mostrarCargas = true; $output->mostrarCambios = true; $output->mostrarMantenimiento = true; $output->mostrarPedidos = true; $user = auth()->user(); if ($user->inGroup("\164\x65\x63\156\151\x63\x6f")) { unset($output->mostrarCaja); unset($output->mostrarOcupacion); unset($output->mostrarInvitaciones); unset($output->mostrarCambios); unset($output->mostrarMantenimiento); unset($output->mostrarPedidos); } if ($user->inGroup("\x63\145\x6e\164\x72\x61\154")) { unset($output->mostrarCaja); unset($output->mostrarOcupacion); unset($output->mostrarInvitaciones); unset($output->mostrarCargas); } $output->titulo = "\x55\163\x75\141\162\151\x6f\x3a\x20" . auth()->user()->getEmail(); $this->borraDatosViejos(); $this->borraMensajesViejos(); return view("\x72\145\163\165\x6d\x65\x6e\56\x70\x68\160", (array) $output); } private function borraDatosViejos() { $db = \Config\Database::connect(); $builder = $db->table("\x63\141\152\x61"); $todo = $builder->get(); foreach ($todo->getResult() as $row) { $fecha1 = Time::parse($row->fecha); $fecha2 = Time::now(); $diferencia = $fecha1->difference($fecha2); $totalDiferencia = $diferencia->getDays(); if ($totalDiferencia >= 30) { $builder->where("\151\x43\141\x6a\141", $row->iCaja); $builder->delete(); } } $builder = $db->table("\x63\141\x72\x67\x61\163"); $todo = $builder->get(); foreach ($todo->getResult() as $row) { $fecha1 = Time::parse($row->fecha); $fecha2 = Time::now(); $diferencia = $fecha1->difference($fecha2); $totalDiferencia = $diferencia->getDays(); if ($totalDiferencia >= 90) { $builder->where("\x69\103\141\162\x67\141", $row->iCarga); $builder->delete(); } } $builder = $db->table("\x69\x6e\166\151\x74\x61\x63\x69\x6f\156\145\x73"); $todo = $builder->get(); foreach ($todo->getResult() as $row) { $fecha1 = Time::parse($row->fecha); $fecha2 = Time::now(); $diferencia = $fecha1->difference($fecha2); $totalDiferencia = $diferencia->getDays(); if ($totalDiferencia >= 30) { $builder->where("\x69\144\111\156\166\x69\x74\141\x63\x69\157\x6e\145\x73", $row->idInvitaciones); $builder->delete(); } } $builder = $db->table("\157\143\165\x70\141\x63\x69\x6f\156"); $todo = $builder->get(); foreach ($todo->getResult() as $row) { $fecha1 = Time::parse($row->fecha); $fecha2 = Time::now(); $diferencia = $fecha1->difference($fecha2); $totalDiferencia = $diferencia->getDays(); if ($totalDiferencia >= 90) { $builder->where("\x69\x4f\x63\165\160\141\x63\151\157\156", $row->iOcupacion); $builder->delete(); } } $builder = $db->table("\141\166\145\162\x69\x61\x73"); $builder->where("\x65\163\x74\141\x64\157", 0); $todo = $builder->get(); foreach ($todo->getResult() as $row) { $fecha1 = Time::parse($row->fechaFin); $fecha2 = Time::now(); $diferencia = $fecha1->difference($fecha2); $totalDiferencia = $diferencia->getDays(); if ($totalDiferencia >= 30) { if ($row->firmaEmpleado != '') { if (file_exists($row->firmaEmpleado)) { unlink($row->firmaEmpleado); } } if ($row->firmaTecnico != '') { if (file_exists($row->firmaTecnico)) { unlink($row->firmaTecnico); } } $builder->where("\151\x41\x76\x65\x72\x69\141", $row->iAveria); $builder->delete(); } } $builder = $db->table("\x63\x61\155\142\x69\157\163"); $builder->where("\x65\163\x74\141\144\157", 0); $todo = $builder->get(); foreach ($todo->getResult() as $row) { $fecha1 = Time::parse($row->fechaFin); $fecha2 = Time::now(); $diferencia = $fecha1->difference($fecha2); $totalDiferencia = $diferencia->getDays(); if ($totalDiferencia >= 90) { if ($row->firmaEmpleado != '') { if (file_exists($row->firmaEmpleado)) { unlink($row->firmaEmpleado); } } if ($row->firmaTecnico != '') { if (file_exists($row->firmaTecnico)) { unlink($row->firmaTecnico); } } $builder->where("\151\103\x61\x6d\142\151\157\x73", $row->iCambios); $builder->delete(); } } $builder = $db->table("\155\141\x6e\x74\145\156\151\155\151\145\x6e\164\157"); $builder->where("\145\x73\164\x61\x64\x6f", 0); $todo = $builder->get(); foreach ($todo->getResult() as $row) { $fecha1 = Time::parse($row->fechaFin); $fecha2 = Time::now(); $diferencia = $fecha1->difference($fecha2); $totalDiferencia = $diferencia->getDays(); if ($totalDiferencia >= 90) { if ($row->firmaEmpleado != '') { if (file_exists($row->firmaEmpleado)) { unlink($row->firmaEmpleado); } } if ($row->firmaTecnico != '') { if (file_exists($row->firmaTecnico)) { unlink($row->firmaTecnico); } } $builder->where("\151\x4d\x61\x6e\x74\145\156\151\x6d\151\145\156\x74\157", $row->iMantenimiento); $builder->delete(); } } $builder = $db->table("\160\145\x64\151\x64\x6f\x73"); $builder->where("\145\163\164\141\x64\157", 0); $todo = $builder->get(); foreach ($todo->getResult() as $row) { $fecha1 = Time::parse($row->fechaFin); $fecha2 = Time::now(); $diferencia = $fecha1->difference($fecha2); $totalDiferencia = $diferencia->getDays(); if ($totalDiferencia >= 30) { if ($row->firmaEmpleado != '') { if (file_exists($row->firmaEmpleado)) { unlink($row->firmaEmpleado); } } $builder->where("\151\120\145\144\x69\x64\x6f", $row->iPedido); $builder->delete(); } } } private function borraMensajesViejos() { $db = \Config\Database::connect(); $builder = $db->table("\155\145\163\x73\141\x67\x65\x73"); $todo = $builder->get(); foreach ($todo->getResult() as $row) { $fecha1 = Time::parse($row->createdAt); $fecha2 = Time::now(); $diferencia = $fecha1->difference($fecha2); $totalDiferencia = $diferencia->getDays(); if ($totalDiferencia >= 60) { if ($row->audio != '') { $f = $row->audio; $fichero = substr($f, strlen(base_url()), strlen($f)); if (file_exists($fichero)) { unlink($fichero); } } if ($row->video != '') { $f = $row->video; $fichero = substr($f, strlen(base_url()), strlen($f)); if (file_exists($fichero)) { unlink($fichero); } } if ($row->image != '') { $f = $row->image; $fichero = substr($f, strlen(base_url()), strlen($f)); if (file_exists($fichero)) { unlink($fichero); } } $builder->where("\137\151\x64", $row->_id); $builder->delete(); } } } private function datosSalones() : object { $db = \Config\Database::connect(); $builder = $db->table("\x73\141\x6c\x6f\156\x65\163"); $builder->orderBy("\x6e\x53\x61\154\157\x6e"); $salones = $builder->get(); $salones = $salones->getResult(); $cajas = $this->datosCaja()->totalCajaSalones; $ocupacion = $this->datosOcupacion()->totalOcupacionSalones; $invitaciones = $this->datosInvitaciones()->totalInvitacionesSalones; $averias = $this->datosAverias(); $averiasPromedio = $averias->averiasPromedio; $averias = $averias->totalAveriasSalones; $cargas = $this->datosCargas()->totalCargasSalones; $cambios = $this->datosCambios()->totalCambiosSalones; $mantenimiento = $this->datosMantenimiento()->totalMantenimientoSalones; $pedidos = $this->datosPedidos()->totalPedidosSalones; $tmp = array(); foreach ($salones as $row) { if (!isset($row->totalCaja)) { $row->totalCaja = 0; } if (isset($cajas[$row->iSalon])) { $row->totalCaja += $cajas[$row->iSalon]; } if (!isset($row->totalOcupacion)) { $row->totalOcupacion = 0; } if (isset($ocupacion[$row->iSalon])) { $row->totalOcupacion += $ocupacion[$row->iSalon]; } if (!isset($row->totalInvitacionesHoy)) { $row->totalInvitacionesHoy = 0; } if (!isset($row->totalInvitacionesMes)) { $row->totalInvitacionesMes = 0; } if (isset($invitaciones[$row->iSalon]["\150\157\171"])) { $row->totalInvitacionesHoy += number_format($invitaciones[$row->iSalon]["\x68\x6f\171"], 2); } if (isset($invitaciones[$row->iSalon]["\155\x65\x73"])) { $row->totalInvitacionesMes += number_format($invitaciones[$row->iSalon]["\155\x65\x73"], 2); } if (!isset($row->totalAverias)) { $row->totalAverias = 0; } if (isset($averias[$row->iSalon])) { $row->totalAverias = $averias[$row->iSalon]; } if (!isset($row->totalCargas)) { $row->totalCargas = 0; } if (isset($cargas[$row->iSalon])) { $row->totalCargas += $cargas[$row->iSalon]; } if (!isset($row->totalCambios)) { $row->totalCambios = 0; } if (isset($cambios[$row->iSalon])) { $row->totalCambios += $cambios[$row->iSalon]; } if (!isset($row->totalMantenimiento)) { $row->totalMantenimiento = 0; } if (isset($mantenimiento[$row->iSalon])) { $row->totalMantenimiento = $mantenimiento[$row->iSalon]; } if (!isset($row->totalPedidos)) { $row->totalPedidos = 0; } if (isset($pedidos[$row->iSalon])) { $row->totalPedidos = $pedidos[$row->iSalon]; } array_push($tmp, $row); } $retorno = (object) array(); $retorno->totalSalones = $tmp; return $retorno; } private function datosCaja() : object { $db = \Config\Database::connect(); $builder = $db->table("\x63\141\x6a\x61"); $builder->where("\146\145\x63\150\x61\x20\76", new RawSql("\x43\125\122\104\x41\124\105\50\x29")); $builder->orderBy("\x69\123\x61\x6c\x6f\x6e"); $total = $builder->get(); $salon = 0; $salones = array(); foreach ($total->getResult() as $row) { $salones[$row->iSalon] = 0; } foreach ($total->getResult() as $row) { $salones[$row->iSalon] += $row->totalCaja; } $retorno = (object) array(); $retorno->totalCajaSalones = $salones; return $retorno; } private function datosOcupacion() : object { $db = \Config\Database::connect(); $builder = $db->table("\157\x63\165\160\141\x63\x69\157\156"); $builder->where("\x66\x65\143\150\141\x20\76", new RawSql("\x43\125\x52\104\101\124\105\x28\51")); $builder->orderBy("\151\123\x61\x6c\x6f\156"); $total = $builder->get(); $salones = array(); foreach ($total->getResult() as $row) { $salones[$row->iSalon] = 0; } foreach ($total->getResult() as $row) { $salones[$row->iSalon] += $row->totalHora; } $retorno = (object) array(); $retorno->totalOcupacionSalones = $salones; return $retorno; } private function datosInvitaciones() : object { $db = \Config\Database::connect(); $builder = $db->table("\x69\156\166\x69\x74\x61\143\x69\157\x6e\145\163"); $builder->where("\x66\x65\x63\x68\141\40\76\75", new RawSql("\104\x41\124\x45\x5f\123\125\102\50\x43\x55\x52\122\x45\116\x54\x5f\x44\101\x54\105\50\51\x2c\x20\x49\116\x54\105\122\126\101\114\x20\63\x32\x20\x44\x41\x59\x29")); $builder->orderBy("\x69\123\141\x6c\157\x6e"); $total = $builder->get(); $salones = array(); foreach ($total->getResult() as $row) { $salones[$row->iSalon] = array("\x6d\145\163" => 0, "\x68\157\171" => 0); } $fecha1 = Time::createFromDate(null, null, null, "\105\x75\x72\x6f\160\x65\x2f\x4c\157\156\144\157\156", "\145\x73\137\105\x53"); foreach ($total->getResult() as $row) { $fecha2 = Time::parse($row->fecha, "\105\x75\162\157\x70\x65\57\114\x6f\156\x64\x6f\156", "\145\x73\137\x45\x53"); $fecha2 = Time::createFromDate($fecha2->getYear(), $fecha2->getMonth(), $fecha2->getDay(), "\105\165\x72\157\x70\x65\57\x4c\157\156\x64\157\x6e", "\x65\x73\137\105\123"); $diferencia = $fecha1->difference($fecha2); if ($fecha1->getMonth() == $fecha2->getMonth()) { if ($diferencia->getDays() == 0) { $salones[$row->iSalon]["\150\157\x79"] += $row->coste; } else { $salones[$row->iSalon]["\155\145\163"] += $row->coste; } } } $retorno = (object) array(); $retorno->totalInvitacionesSalones = $salones; return $retorno; } private function datosAverias() : object { $db = \Config\Database::connect(); $builder = $db->table("\x61\166\x65\162\151\141\163"); $builder->where("\145\163\x74\141\144\157", 1); $builder->orderBy("\x69\123\141\x6c\x6f\156"); $total = $builder->get(); $salones = array(); foreach ($total->getResult() as $row) { $salones[$row->iSalon] = 0; } foreach ($total->getResult() as $row) { $salones[$row->iSalon]++; } $retorno = (object) array(); $retorno->totalAveriasSalones = $salones; $builder->where("\145\163\x74\141\x64\x6f", 0); $builder->where("\146\145\x63\x68\x61\x20\76\x3d", new RawSql("\x44\x41\124\x45\x5f\x53\125\x42\x28\x43\x55\x52\122\x45\116\x54\137\x44\x41\x54\105\50\51\x2c\x20\x49\x4e\x54\x45\122\126\x41\x4c\x20\x33\x30\40\104\x41\x59\51")); $terminadas = $builder->get(); $totalDiferencia = 0; foreach ($terminadas->getResult() as $row) { $fecha1 = Time::parse($row->fecha); $fecha2 = Time::parse($row->fechaFin); $diferencia = $fecha1->difference($fecha2); $totalDiferencia += $diferencia->getMinutes(); } $promedio = 0; if ($terminadas->getNumRows() > 0) { $promedio = $totalDiferencia / $terminadas->getNumRows(); if ($promedio > 60) { $promedio = strval(round($promedio / 60, 2)) . "\40\x68"; } else { $promedio = strval(round($promedio, 2)) . "\40\x6d"; } } $retorno->averiasPromedio = $promedio; return $retorno; } private function datosCargas() : object { $db = \Config\Database::connect(); $builder = $db->table("\143\x61\162\147\x61\163"); $builder->where("\146\145\x63\150\141\40\x3e", new RawSql("\x43\x55\x52\104\x41\124\105\50\x29")); $builder->orderBy("\x69\123\x61\154\157\156"); $total = $builder->get(); $salones = array(); foreach ($total->getResult() as $row) { $salones[$row->iSalon] = 0; } foreach ($total->getResult() as $row) { $salones[$row->iSalon]++; } $retorno = (object) array(); $retorno->totalCargasSalones = $salones; return $retorno; } private function datosCambios() : object { $db = \Config\Database::connect(); $builder = $db->table("\x63\141\155\142\151\x6f\163"); $builder->where("\145\x73\164\141\144\157", 1); $builder->orderBy("\x69\x53\x61\x6c\157\156"); $total = $builder->get(); $salones = array(); foreach ($total->getResult() as $row) { $salones[$row->iSalon] = 0; } foreach ($total->getResult() as $row) { $salones[$row->iSalon]++; } $retorno = (object) array(); $retorno->totalCambiosSalones = $salones; return $retorno; } private function datosMantenimiento() : object { $db = \Config\Database::connect(); $builder = $db->table("\155\141\x6e\x74\x65\156\x69\x6d\151\145\156\x74\157"); $builder->where("\145\x73\164\x61\x64\157", 1); $builder->orderBy("\x69\x53\x61\154\157\156"); $total = $builder->get(); $salones = array(); foreach ($total->getResult() as $row) { $salones[$row->iSalon] = 0; } foreach ($total->getResult() as $row) { $salones[$row->iSalon]++; } $retorno = (object) array(); $retorno->totalMantenimientoSalones = $salones; return $retorno; } private function datosPedidos() : object { $db = \Config\Database::connect(); $builder = $db->table("\160\145\144\x69\x64\x6f\x73"); $builder->where("\x65\163\x74\x61\144\157", 1); $builder->orderBy("\x70\x65\x64\x69\x64\157"); $total = $builder->get(); $salones = array(); foreach ($total->getResult() as $row) { $salones[$row->iSalon] = 0; } $pedidoActual = 0; foreach ($total->getResult() as $row) { if ($pedidoActual != $row->pedido) { $pedidoActual = $row->pedido; $salones[$row->iSalon]++; } } $retorno = (object) array(); $retorno->totalPedidosSalones = $salones; return $retorno; } public function logout() { auth()->logout(); return redirect()->to("\x2f"); } private function _crud_output($output = null) { return view("\143\x72\x75\x64\x5f\141\x64\x6d\x69\156\137\x76\56\160\150\x70", (array) $output); } public function averias() : string { $user = auth()->user(); if (!$user->inGroup("\152\145\x66\x65\163", "\143\157\x6e\163\x75\154\164\x61", "\164\x65\x63\156\x69\143\x6f", "\143\x65\x6e\x74\162\x61\154")) { header("\x4c\157\x63\x61\164\x69\x6f\156\72\40" . base_url()); die; } $crud = new GroceryCrud(); $crud->setTable("\x61\x76\145\x72\x69\141\163")->setSubject("\x41\x76\145\x72\x69\x61", "\x41\x76\x65\162\151\x61\x73")->columns(array("\146\145\143\x68\141", "\x66\145\x63\150\x61\x46\x69\x6e", "\151\x53\141\x6c\x6f\156", "\151\x4d\x61\161\165\x69\x6e\141", "\x69\x64", "\x6e\x6f\155\142\x72\x65\x54\x65\143\x6e\x69\x63\x6f", "\x66\151\x72\x6d\141\x54\x65\143\x6e\x69\143\157", "\151\105\x6d\x70\154\145\141\144\x6f", "\146\151\x72\x6d\141\105\155\x70\x6c\145\x61\x64\x6f", "\x6f\142\x73\x65\x72\166\x61\143\151\157\156\x65\x73", "\145\163\x74\141\144\157"))->setRelation("\x69\105\x6d\x70\154\x65\x61\144\x6f", "\145\x6d\x70\x6c\145\141\x64\157\163", "\x7b\x6e\x45\155\x70\x6c\145\x61\144\x6f\175\x20\x20\173\141\105\155\x70\x6c\x65\x61\144\x6f\175")->setRelation("\x69\115\x61\161\x75\151\x6e\141", "\144\x61\164\157\x73\x5f\155\141\161\165\x69\x6e\141\x73", "\x6e\115\x61\161\x75\151\156\141")->setRelation("\151\123\x61\x6c\x6f\156", "\163\x61\x6c\x6f\x6e\x65\163", "\x6e\123\141\154\x6f\156")->setRelation("\151\x64", "\x64\141\164\x6f\163\x5f\141\166\145\162\x69\141\x73", "\x6e\x6f\155\x62\162\x65")->displayAs("\x69\x53\141\154\157\156", "\x53\x61\x6c\xc3\263\156")->displayAs("\x69\x45\155\160\x6c\x65\x61\x64\157", "\116\157\155\142\162\145\x45\155\160\x6c\x65\x61\144\x6f")->displayAs("\151\x4d\x61\161\165\x69\x6e\x61", "\115\303\xa1\161\x75\x69\156\141")->displayAs("\x69\x64", "\124\151\x70\x6f\40\x61\x76\145\x72\303\xad\x61")->callbackColumn("\x66\x69\x72\155\x61\105\x6d\160\x6c\145\x61\x64\157", function ($value, $row) { if ($value != '') { return "\74\151\155\x67\x20\163\162\x63\75\x27" . base_url($value) . "\x27\40\143\x6c\x61\163\x73\x3d\47\x69\155\x67\55\x66\154\x75\x69\x64\x27\x20\167\x69\x64\x74\150\x3d\x31\x30\x30\x3e\x3c\57\x61\76"; } else { return "\x3c\144\151\166\x3e\74\x2f\144\151\166\x3e"; } })->callbackColumn("\146\151\x72\x6d\x61\x54\145\x63\156\x69\x63\x6f", function ($value, $row) { if ($value != '') { return "\x3c\151\x6d\147\x20\163\x72\143\75\47" . base_url($value) . "\x27\x20\143\154\141\x73\x73\75\47\x69\155\147\55\146\x6c\165\x69\144\x27\40\167\151\x64\x74\150\75\x31\x30\x30\76\74\57\141\76"; } else { return "\74\x64\x69\x76\76\74\x2f\x64\x69\166\x3e"; } })->unsetEditFields(array("\146\151\162\x6d\141\x45\155\x70\154\x65\x61\x64\x6f", "\146\x69\162\155\x61\x54\145\x63\x6e\151\143\x6f"))->unsetReadFields(array("\x66\x69\162\155\x61\x45\x6d\x70\x6c\x65\141\144\157", "\146\151\x72\155\141\x54\x65\143\156\x69\143\157"))->unsetDelete()->unsetPrint(); $user = auth()->user(); if ($user->inGroup("\x6a\x65\146\x65\x73")) { $crud->setRead(); $crud->setDelete(); $crud->setEdit(); } else { $crud->unsetEdit(); $crud->unsetAdd(); $crud->setRead(); } $output = $crud->render(); $output->titulo = "\x41\x76\x65\x72\xc3\xad\141\x73"; return $this->_crud_output($output); } public function caja() : string { $user = auth()->user(); if (!$user->inGroup("\152\145\x66\145\x73", "\143\157\156\163\x75\x6c\164\x61")) { header("\114\157\x63\141\164\x69\157\156\72\40" . base_url()); die; } $crud = new GroceryCrud(); $crud->setTable("\x63\x61\x6a\141")->setRead()->setRelation("\x69\x45\155\160\154\x65\141\x64\157", "\x65\155\x70\x6c\x65\x61\144\157\x73", "\x7b\156\105\155\x70\154\x65\141\144\157\175\x20\40\x7b\141\105\x6d\x70\154\x65\141\x64\x6f\175")->setRelation("\x69\123\141\154\x6f\x6e", "\163\x61\x6c\x6f\x6e\x65\163", "\156\x53\141\x6c\157\x6e")->displayAs("\x69\105\155\160\154\x65\x61\x64\x6f", "\105\155\160\x6c\x65\x61\144\157")->displayAs("\x69\123\x61\154\x6f\x6e", "\x53\141\x6c\303\xb3\156")->displayAs("\142\65\x30\x30", "\x42\x69\154\x6c\x65\164\145\x73\x20\65\x30\x30")->displayAs("\x62\62\x30\60", "\x42\151\x6c\154\x65\164\145\163\x20\x32\60\60")->displayAs("\142\61\x30\60", "\102\151\154\154\145\x74\x65\163\x20\x31\x30\x30")->displayAs("\142\65\x30", "\x42\151\x6c\x6c\x65\x74\145\163\x20\x35\x30")->displayAs("\x62\62\x30", "\102\x69\154\x6c\x65\164\x65\x73\40\62\x30")->displayAs("\142\61\x30", "\102\151\154\154\145\164\145\x73\x20\61\60")->displayAs("\x62\65", "\102\x69\154\154\x65\x74\x65\x73\x20\65")->displayAs("\155\62", "\115\157\156\145\144\x61\x73\40\x32")->displayAs("\155\x31", "\115\x6f\x6e\145\x64\141\x73\x20\x31")->displayAs("\155\x30\65\x30", "\x4d\x6f\x6e\145\x64\141\163\40\60\54\65\60")->displayAs("\155\60\62\60", "\x4d\157\156\x65\144\x61\163\x20\x30\x2c\x32\60")->displayAs("\x6d\x30\61\60", "\x4d\x6f\x6e\x65\144\x61\163\x20\x30\54\61\60")->displayAs("\155\x30\60\x35", "\x4d\x6f\x6e\145\x64\141\163\40\60\54\60\x35")->displayAs("\x6d\x30\60\62", "\115\x6f\x6e\x65\x64\141\163\x20\60\x2c\x30\x32")->displayAs("\155\x30\60\x31", "\x4d\x6f\x6e\x65\144\x61\x73\40\x30\x2c\x30\61")->displayAs("\x70\144\141\x74\x61\146\x6f\x6e\157", "\104\x61\164\xc3\241\x66\157\156\157")->displayAs("\x70\x68\x61\x6e\144\x70\x61\151\x64", "\110\141\156\x64\160\141\x69\x64")->displayAs("\x70\146\141\x63\x74\165\x72\141\x73", "\106\141\x63\164\165\162\x61\163")->displayAs("\160\151\x6e\166\151\164\141\143\151\x6f\156\145\163", "\x49\x6e\x76\x69\x74\x61\143\x69\157\x6e\x65\163")->displayAs("\160\162\151\156\x67\157", "\x52\x69\x6e\147\157")->displayAs("\160\x76\x61\x72\x69\x6f\163", "\126\141\162\151\x6f\163")->unsetDelete()->unsetPrint(); $user = auth()->user(); if ($user->inGroup("\152\x65\146\145\163")) { $crud->setRead(); $crud->setDelete(); } else { $crud->unsetEdit(); $crud->unsetAdd(); $crud->setRead(); } $output = $crud->render(); $output->titulo = "\103\x61\152\x61"; return $this->_crud_output($output); } public function cambios() : string { $user = auth()->user(); if (!$user->inGroup("\x6a\145\x66\x65\x73", "\143\x6f\x6e\163\x75\154\x74\x61", "\143\145\x6e\x74\162\x61\x6c")) { header("\x4c\x6f\x63\x61\164\x69\157\x6e\72\40" . base_url()); die; } $crud = new GroceryCrud(); $crud->setTable("\x63\141\155\x62\151\157\x73")->setRead()->setRelation("\151\x45\155\x70\154\145\141\144\x6f", "\x65\x6d\x70\x6c\x65\x61\x64\x6f\163", "\x7b\156\105\155\x70\154\x65\141\144\x6f\x7d\40\x20\173\141\105\x6d\x70\154\145\x61\144\157\x7d")->setRelation("\151\123\141\154\157\156", "\x73\x61\x6c\x6f\x6e\x65\163", "\x6e\x53\x61\x6c\157\x6e")->displayAs("\x69\x45\155\x70\x6c\145\x61\144\157", "\105\155\x70\154\x65\x61\144\x6f")->displayAs("\151\123\141\x6c\x6f\x6e", "\123\141\154\303\xb3\156")->displayAs("\142\x35\x30\60", "\x42\x69\x6c\154\145\164\x65\163\40\x35\x30\x30")->displayAs("\x62\x32\60\x30", "\102\151\x6c\154\x65\x74\x65\x73\x20\x32\60\x30")->displayAs("\142\x31\x30\x30", "\x42\151\x6c\154\x65\164\145\163\40\x31\60\x30")->displayAs("\142\65\x30", "\102\x69\x6c\x6c\x65\164\145\x73\40\x35\60")->displayAs("\x62\x32\x30", "\102\x69\x6c\x6c\x65\x74\145\163\x20\x32\x30")->displayAs("\x62\61\60", "\x42\x69\x6c\154\145\x74\145\x73\40\x31\60")->displayAs("\x62\x35", "\102\x69\x6c\x6c\145\164\145\x73\40\x35")->displayAs("\x6d\x32", "\115\157\156\145\x64\141\x73\x20\62")->displayAs("\x6d\61", "\x4d\157\156\145\144\141\163\40\61")->displayAs("\x6d\x30\x35\60", "\115\x6f\x6e\145\x64\141\163\x20\60\54\x35\60")->displayAs("\x6d\60\62\x30", "\115\x6f\156\145\144\141\163\x20\60\54\x32\60")->displayAs("\x6d\x30\x31\60", "\115\157\x6e\145\x64\141\x73\x20\60\x2c\x31\x30")->displayAs("\155\x30\x30\65", "\x4d\x6f\156\145\x64\x61\x73\40\x30\x2c\x30\x35")->displayAs("\x6d\60\x30\62", "\115\157\156\145\x64\x61\163\x20\x30\x2c\x30\x32")->displayAs("\x6d\x30\x30\x31", "\115\x6f\x6e\x65\144\x61\x73\40\x30\54\x30\61")->callbackColumn("\x66\x69\x72\155\141\105\x6d\160\154\x65\141\x64\157", function ($value, $row) { if ($value != '') { return "\x3c\x69\155\147\x20\x73\x72\x63\x3d\47" . base_url($value) . "\47\40\143\x6c\141\163\163\x3d\x27\x69\155\147\x2d\146\x6c\x75\151\x64\x27\40\x77\x69\x64\164\150\x3d\x31\60\60\76\74\57\141\x3e"; } else { return "\74\144\x69\x76\76\x3c\57\144\151\x76\x3e"; } })->callbackColumn("\x66\151\x72\155\x61\124\x65\x63\156\151\x63\x6f", function ($value, $row) { if ($value != '') { return "\74\151\155\x67\x20\163\x72\x63\x3d\x27" . base_url($value) . "\x27\x20\143\154\141\x73\163\x3d\47\151\155\x67\55\x66\154\x75\151\144\x27\40\x77\151\144\x74\x68\75\x31\x30\x30\76\74\x2f\141\x3e"; } else { return "\74\x64\151\x76\76\74\57\144\151\x76\x3e"; } })->unsetEditFields(array("\x66\x69\x72\x6d\x61\x45\x6d\160\x6c\145\141\144\x6f", "\x66\151\162\x6d\141\x54\x65\143\x6e\x69\143\x6f"))->unsetReadFields(array("\146\x69\x72\x6d\141\105\155\160\154\x65\x61\144\x6f", "\146\151\162\155\x61\124\145\143\x6e\151\143\157"))->unsetDelete()->unsetPrint(); $user = auth()->user(); if ($user->inGroup("\152\x65\x66\145\163")) { $crud->setRead(); $crud->setDelete(); } else { $crud->unsetEdit(); $crud->unsetAdd(); $crud->setRead(); } $output = $crud->render(); $output->titulo = "\x43\x61\155\142\x69\x6f\163"; return $this->_crud_output($output); } public function cargas() : string { $user = auth()->user(); if (!$user->inGroup("\x6a\x65\146\145\163", "\x63\x6f\x6e\x73\x75\x6c\x74\141", "\164\x65\x63\156\151\x63\157")) { header("\x4c\x6f\143\141\x74\x69\x6f\156\72\40" . base_url()); die; } $crud = new GroceryCrud(); $crud->setTable("\143\x61\162\147\x61\x73")->columns(array("\146\x65\x63\x68\x61", "\151\123\141\x6c\x6f\x6e", "\151\x4d\141\161\165\151\156\141", "\157\x62\x73\145\162\x76\141\143\x69\x6f\156\145\163", "\x6e\157\155\x62\x72\x65\x54\145\143\x6e\x69\x63\x6f", "\146\x69\x72\x6d\x61\124\145\143\x6e\151\x63\x6f", "\156\x6f\155\x62\162\145\x45\x6d\160\x6c\145\141\144\157", "\x66\151\x72\x6d\x61\105\155\x70\x6c\x65\x61\144\x6f", "\151\155\x70\x6f\x72\x74\145"))->setRead()->setSubject("\103\x61\162\x67\x61", "\103\x61\x72\147\141\163")->setRelation("\151\x4d\141\x71\x75\x69\x6e\x61", "\x64\141\x74\x6f\x73\137\155\x61\161\x75\x69\156\141\x73", "\x6e\x4d\141\161\165\151\156\141")->setRelation("\151\123\141\154\x6f\x6e", "\x73\141\154\157\x6e\145\163", "\x6e\123\x61\x6c\x6f\156")->displayAs("\x69\123\141\154\157\x6e", "\x53\141\x6c\303\263\x6e")->displayAs("\x69\115\141\161\165\x69\x6e\x61", "\115\xc3\241\161\165\151\156\x61")->callbackColumn("\146\151\x72\155\x61\105\x6d\160\154\x65\x61\144\157", function ($value, $row) { if ($value != '') { return "\x3c\x69\155\147\40\163\162\x63\75\47" . base_url($value) . "\x27\40\143\154\141\163\x73\x3d\x27\x69\x6d\x67\55\x66\154\165\x69\x64\47\40\167\151\144\x74\x68\x3d\61\x30\x30\76\x3c\57\141\x3e"; } else { return "\x3c\144\x69\x76\x3e\x3c\x2f\x64\x69\x76\76"; } })->callbackColumn("\146\x69\162\155\x61\x54\145\143\x6e\x69\143\x6f", function ($value, $row) { if ($value != '') { return "\74\151\x6d\147\x20\x73\162\143\75\47" . base_url($value) . "\x27\40\x63\154\x61\163\163\x3d\47\151\x6d\147\55\x66\154\165\x69\x64\x27\x20\x77\151\x64\x74\x68\75\61\x30\x30\x3e\74\x2f\141\x3e"; } else { return "\x3c\144\151\x76\x3e\x3c\57\144\x69\166\76"; } })->unsetEditFields(array("\146\x69\162\155\141\105\x6d\x70\x6c\x65\x61\144\x6f", "\146\x69\162\x6d\141\124\145\143\156\151\143\157"))->unsetReadFields(array("\x66\x69\x72\x6d\x61\x45\x6d\160\154\145\x61\144\x6f", "\x66\151\162\155\141\124\x65\x63\x6e\x69\x63\x6f"))->unsetDelete()->unsetPrint(); $user = auth()->user(); if ($user->inGroup("\152\x65\146\x65\x73")) { $crud->setRead(); $crud->setDelete(); } else { $crud->unsetEdit(); $crud->unsetAdd(); $crud->setRead(); } $output = $crud->render(); $output->titulo = "\x43\x61\x72\147\141\163"; return $this->_crud_output($output); } public function empleados() : string { $user = auth()->user(); if (!$user->inGroup("\152\145\x66\145\x73", "\143\x6f\156\163\165\154\x74\141")) { header("\114\157\143\x61\164\x69\x6f\156\x3a\40" . base_url()); die; } $crud = new GroceryCrud(); $crud->setTable("\x65\155\x70\x6c\x65\141\144\157\163")->setSubject("\105\x6d\x70\x6c\x65\x61\144\x6f", "\105\155\x70\154\x65\141\x64\157\163")->setRead()->displayAs("\156\105\155\160\154\x65\x61\144\157", "\116\x6f\x6d\142\x72\x65")->displayAs("\x61\x45\155\160\x6c\x65\x61\x64\157", "\x41\160\145\154\154\151\144\x6f\163")->displayAs("\151\x45\155\160\x6c\x65\x61\x64\x6f", "\103\x6c\x61\166\x65")->unsetDelete()->unsetPrint(); $user = auth()->user(); if ($user->inGroup("\x6a\x65\x66\x65\x73")) { $crud->setRead(); $crud->setDelete(); } else { $crud->unsetEdit(); $crud->unsetAdd(); $crud->setRead(); } $output = $crud->render(); $output->titulo = "\x45\x6d\x70\x6c\x65\x61\144\x6f\x73"; return $this->_crud_output($output); } public function invitaciones() : string { $user = auth()->user(); if (!$user->inGroup("\152\145\146\x65\x73", "\143\x6f\156\163\x75\154\164\141")) { header("\x4c\x6f\x63\x61\x74\151\157\156\x3a\40" . base_url()); die; } $crud = new GroceryCrud(); $crud->setTable("\x69\156\166\x69\x74\141\143\151\157\x6e\145\163")->setSubject("\x49\156\x76\151\x74\141\x63\151\303\263\x6e", "\111\x6e\166\151\164\141\x63\151\x6f\x6e\x65\x73")->setRead()->setRelation("\x69\x45\155\160\x6c\x65\x61\144\x6f", "\145\x6d\160\154\145\x61\x64\157\x73", "\x7b\x6e\105\x6d\x70\154\145\141\x64\x6f\x7d\x20\x20\173\141\105\155\x70\x6c\x65\141\144\157\x7d")->setRelation("\151\x53\141\154\x6f\156", "\x73\141\x6c\x6f\156\x65\163", "\x6e\x53\x61\154\x6f\x6e")->setRelation("\x69\115\141\x71\x75\151\156\141", "\144\141\164\157\163\137\155\x61\x71\x75\x69\156\141\163", "\156\x4d\x61\161\165\x69\x6e\141")->setRelation("\151\x50\x72\x6f\144\x75\x63\164\157", "\x64\141\x74\157\163\x5f\151\x6e\x76\x69\x74\x61\x63\151\157\156\145\163", "\156\120\x72\x6f\x64\x75\143\x74\157")->displayAs("\151\x45\155\160\x6c\x65\141\144\157", "\105\155\160\154\145\x61\x64\x6f")->displayAs("\151\123\x61\154\157\156", "\123\x61\x6c\xc3\xb3\x6e")->displayAs("\151\x4d\141\x71\x75\151\x6e\x61", "\x4d\303\241\161\x75\151\x6e\141")->displayAs("\x69\x50\162\x6f\x64\x75\x63\164\157", "\x50\x72\x6f\x64\x75\143\x74\157")->unsetDelete()->unsetPrint(); $user = auth()->user(); if ($user->inGroup("\152\145\146\x65\163")) { $crud->setRead(); $crud->setDelete(); } else { $crud->unsetEdit(); $crud->unsetAdd(); $crud->setRead(); } $output = $crud->render(); $output->titulo = "\x49\156\166\x69\164\x61\x63\151\x6f\156\x65\163"; return $this->_crud_output($output); } public function mantenimientos() : string { $user = auth()->user(); if (!$user->inGroup("\152\x65\x66\x65\x73", "\143\157\156\x73\165\x6c\x74\x61", "\x63\x65\156\164\x72\x61\x6c")) { header("\x4c\157\x63\x61\164\x69\x6f\156\72\x20" . base_url()); die; } $crud = new GroceryCrud(); $crud->setTable("\155\141\156\x74\145\x6e\x69\155\x69\x65\156\x74\157")->setRead()->setSubject("\x4d\x61\156\164\x65\156\x69\x6d\151\145\x6e\164\157", "\115\x61\x6e\x74\x65\156\x69\x6d\x69\145\156\x74\x6f\x73")->setRelation("\x69\x45\x6d\x70\154\x65\x61\144\157", "\145\x6d\160\154\145\x61\x64\x6f\163", "\x7b\156\x45\x6d\160\x6c\x65\x61\x64\x6f\175\x20\40\173\141\105\x6d\x70\154\x65\141\144\x6f\175")->setRelation("\x69\123\x61\x6c\x6f\x6e", "\x73\x61\x6c\157\156\x65\163", "\x6e\123\141\x6c\x6f\156")->setRelation("\151\x64", "\x64\141\x74\x6f\163\x5f\x6d\x61\x6e\164\x65\x6e\x69\155\151\x65\x6e\164\x6f", "\156\157\155\142\162\x65")->setRelation("\151\x5a\157\156\x61", "\x64\141\164\x6f\x73\137\x7a\157\x6e\x61\x73", "\156\132\x6f\x6e\141")->displayAs("\x69\105\x6d\x70\x6c\145\141\x64\157", "\x45\155\x70\154\145\x61\x64\157")->displayAs("\151\123\x61\x6c\157\x6e", "\x53\x61\x6c\303\xb3\x6e")->displayAs("\151\144", "\x54\x69\x70\157\40\x6d\x61\156\164\145\156\151\155\151\145\x6e\164\x6f")->displayAs("\x69\132\x6f\156\x61", "\x5a\x6f\x6e\141")->callbackColumn("\x66\x69\162\155\x61\105\155\x70\x6c\x65\141\x64\x6f", function ($value, $row) { if ($value != '') { return "\x3c\151\x6d\x67\40\163\x72\143\75\47" . base_url($value) . "\47\40\143\154\141\x73\x73\x3d\x27\x69\x6d\147\x2d\x66\x6c\x75\151\x64\x27\40\x77\151\x64\x74\x68\75\x31\60\x30\76\74\x2f\x61\76"; } else { return "\x3c\x64\x69\166\76\x3c\57\x64\x69\166\76"; } })->callbackColumn("\x66\x69\162\155\x61\124\145\x63\x6e\x69\x63\x6f", function ($value, $row) { if ($value != '') { return "\74\151\x6d\147\40\x73\x72\143\x3d\x27" . base_url($value) . "\x27\40\x63\x6c\x61\163\x73\75\47\151\155\x67\x2d\146\x6c\165\x69\x64\x27\x20\167\151\x64\164\150\75\61\x30\x30\x3e\74\57\141\76"; } else { return "\74\x64\151\166\x3e\74\x2f\x64\x69\x76\76"; } })->unsetEditFields(array("\146\151\x72\155\x61\105\155\160\154\x65\141\144\x6f", "\x66\x69\162\x6d\141\x54\145\x63\x6e\x69\x63\x6f"))->unsetReadFields(array("\x66\151\162\x6d\141\x45\155\x70\154\x65\x61\x64\157", "\x66\151\162\155\x61\124\x65\143\x6e\151\x63\157"))->unsetDelete()->unsetPrint(); $user = auth()->user(); if ($user->inGroup("\152\145\x66\145\163")) { $crud->setRead(); $crud->setDelete(); } else { $crud->unsetEdit(); $crud->unsetAdd(); $crud->setRead(); } $output = $crud->render(); $output->titulo = "\x4d\141\156\164\145\x6e\151\x6d\151\145\156\x74\x6f\x73"; return $this->_crud_output($output); } public function maquinas() : string { $user = auth()->user(); if (!$user->inGroup("\x6a\x65\146\x65\163", "\143\x6f\156\x73\x75\154\164\x61")) { header("\x4c\x6f\143\141\164\151\x6f\x6e\x3a\x20" . base_url()); die; } $crud = new GroceryCrud(); $crud->setTable("\x64\141\164\157\x73\137\x6d\x61\x71\x75\x69\156\x61\x73")->setSubject("\115\xc3\xa1\x71\x75\x69\x6e\141", "\115\303\xa1\161\x75\151\x6e\141\163")->setRead()->columns(array("\151\115\x61\x71\x75\151\x6e\141", "\x6e\115\141\x71\x75\151\156\141"))->displayAs("\151\115\141\161\165\151\x6e\x61", "\103\x6f\144\151\147\x6f")->displayAs("\x6e\115\x61\x71\x75\151\x6e\x61", "\116\x6f\155\142\x72\x65")->unsetAddFields(array("\151\115\x61\161\165\151\156\141"))->unsetEditFields(array("\x69\x4d\141\x71\165\x69\x6e\x61"))->unsetDelete()->unsetPrint(); $user = auth()->user(); if ($user->inGroup("\152\145\146\145\x73")) { $crud->setRead(); $crud->setDelete(); } else { $crud->unsetEdit(); $crud->unsetAdd(); $crud->setRead(); } $output = $crud->render(); $output->titulo = "\x4d\xc3\xa1\x71\x75\151\x6e\x61\x73"; return $this->_crud_output($output); } public function ocupacion() : string { $user = auth()->user(); if (!$user->inGroup("\152\x65\x66\145\163", "\143\x6f\x6e\163\165\154\x74\x61")) { header("\x4c\157\143\141\164\x69\x6f\156\x3a\40" . base_url()); die; } $crud = new GroceryCrud(); $crud->setTable("\157\143\x75\160\x61\143\151\157\156")->setRead()->setRelation("\151\105\x6d\160\154\x65\x61\x64\x6f", "\145\x6d\160\x6c\x65\141\x64\157\x73", "\173\x6e\x45\155\160\154\145\141\x64\157\175\x20\x20\x7b\x61\x45\x6d\160\x6c\x65\141\144\x6f\x7d")->setRelation("\x69\123\141\x6c\157\x6e", "\163\141\x6c\x6f\156\145\x73", "\156\123\x61\x6c\157\x6e")->displayAs("\151\x45\x6d\x70\154\x65\141\x64\x6f", "\105\x6d\x70\x6c\x65\141\x64\x6f")->displayAs("\151\x53\141\x6c\157\x6e", "\x53\x61\x6c\303\xb3\156")->displayAs("\x72\165\x6c\145\x74\141\110", "\122\x75\154\x65\164\141\x20\x68\x6f\x6d\142\162\x65\163")->displayAs("\162\165\154\x65\x74\141\115", "\122\x75\154\145\x74\x61\x20\155\x75\152\x65\x72\145\163")->displayAs("\172\x6f\156\141\x62\x48", "\132\x6f\156\x61\x20\x42\x20\150\157\155\x62\162\x65\x73")->displayAs("\172\157\x6e\x61\x62\x4d", "\132\157\x6e\x61\x20\101\x20\x6d\165\x6a\145\162\145\163")->displayAs("\x61\160\165\x65\163\164\141\x73\x48", "\x41\x70\165\x65\x73\x74\141\163\40\x68\157\155\x62\x72\145\x73")->displayAs("\x61\160\165\x65\163\x74\141\163\115", "\101\x70\165\145\163\x74\x61\x73\40\155\165\152\145\162\145\x73")->displayAs("\162\x69\x6e\147\x6f\110", "\x52\x69\156\x67\157\40\x68\x6f\155\142\162\145\163")->displayAs("\162\151\156\x67\x6f\115", "\122\151\156\x67\x6f\40\155\165\152\x65\162\145\x73")->unsetDelete()->unsetPrint(); $user = auth()->user(); if ($user->inGroup("\x6a\x65\146\x65\x73")) { $crud->setRead(); $crud->setDelete(); } else { $crud->unsetEdit(); $crud->unsetAdd(); $crud->setRead(); } $output = $crud->render(); $output->titulo = "\117\x63\x75\x70\x61\143\x69\303\xb3\156"; return $this->_crud_output($output); } public function pedidos() : string { $user = auth()->user(); if (!$user->inGroup("\x6a\145\146\x65\163", "\143\157\156\x73\165\154\164\x61", "\143\145\156\x74\162\x61\154")) { header("\x4c\x6f\143\x61\x74\x69\x6f\x6e\x3a\x20" . base_url()); die; } $crud = new GroceryCrud(); $crud->setTable("\160\145\x64\151\144\x6f\163")->setRead()->columns(array("\146\145\x63\x68\x61", "\x66\x65\143\150\x61\x46\x69\156", "\160\145\144\x69\x64\x6f", "\x69\123\141\154\157\x6e", "\151\x45\155\160\x6c\145\x61\x64\x6f", "\x69\144", "\143\141\x6e\164\x69\144\x61\x64", "\164\x65\x78\x74\157", "\156\x6f\x6d\142\x72\x65\124\145\x63\x6e\x69\x63\x6f", "\146\151\162\155\141\x54\145\143\x6e\x69\x63\157", "\156\x6f\x6d\142\162\145\x45\155\160\154\145\141\144\157", "\x66\151\162\155\141\105\x6d\160\x6c\x65\141\144\x6f", "\x6f\x62\x73\145\162\166\x61\143\x69\x6f\x6e\x65\163", "\x65\163\x74\141\144\157"))->setRelation("\x69\105\155\160\x6c\145\x61\x64\157", "\x65\x6d\x70\154\x65\141\144\x6f\x73", "\173\156\x45\155\160\x6c\x65\x61\x64\157\x7d\40\40\x7b\x61\x45\x6d\160\x6c\x65\x61\x64\x6f\175")->setRelation("\x69\x53\141\x6c\157\156", "\x73\141\x6c\157\156\145\163", "\156\123\141\x6c\157\156")->setRelation("\x69\x64", "\x64\141\164\157\x73\x5f\x70\x65\x64\x69\144\x6f\163", "\x6e\157\155\142\162\x65")->displayAs("\151\x64", "\x50\x72\x6f\144\x75\143\x74\x6f")->displayAs("\151\x45\155\x70\x6c\145\x61\144\x6f", "\120\145\x64\151\x64\157\x20\x70\157\x72")->displayAs("\151\123\141\x6c\x6f\156", "\123\141\154\xc3\263\156")->callbackColumn("\x66\151\x72\155\141\105\155\160\154\x65\x61\x64\157", function ($value, $row) { if ($value != '') { return "\x3c\x69\155\147\x20\x73\162\143\75\x27" . base_url($value) . "\47\40\x63\154\141\x73\163\75\47\151\155\147\x2d\146\154\165\x69\144\47\x20\x77\x69\144\164\x68\75\61\x30\60\76\74\57\141\x3e"; } else { return "\74\144\151\166\x3e\x3c\x2f\144\151\x76\76"; } })->callbackColumn("\146\151\162\155\141\x54\145\143\x6e\x69\x63\x6f", function ($value, $row) { if ($value != '') { return "\x3c\151\155\147\x20\163\x72\x63\x3d\x27" . base_url($value) . "\x27\x20\x63\154\141\163\x73\75\47\x69\x6d\x67\55\146\x6c\165\151\144\47\x20\x77\x69\x64\x74\x68\75\61\60\x30\76\x3c\57\x61\x3e"; } else { return "\74\144\151\166\76\x3c\57\x64\151\x76\76"; } })->unsetEditFields(array("\x66\151\162\x6d\x61\x45\155\x70\x6c\x65\141\144\157", "\146\x69\x72\155\141\x54\145\143\156\151\143\157"))->unsetReadFields(array("\146\151\162\155\141\x45\x6d\x70\154\145\141\x64\157", "\146\151\x72\x6d\x61\124\145\x63\x6e\x69\x63\157"))->unsetDelete()->unsetPrint(); $user = auth()->user(); if ($user->inGroup("\152\x65\x66\145\x73")) { $crud->setRead(); $crud->setDelete(); } else { $crud->unsetEdit(); $crud->unsetAdd(); $crud->setRead(); } $output = $crud->render(); $output->titulo = "\x50\x65\x64\151\144\157\x73"; return $this->_crud_output($output); } public function salones() : string { $user = auth()->user(); if (!$user->inGroup("\x6a\x65\x66\145\163", "\x63\157\156\x73\165\154\x74\141")) { header("\x4c\157\x63\141\x74\x69\x6f\x6e\x3a\40" . base_url()); die; } $crud = new GroceryCrud(); $crud->setTable("\163\141\154\157\156\x65\x73")->setSubject("\x53\x61\x6c\xc3\263\156", "\123\x61\154\x6f\x6e\145\163")->where("\x73\x61\154\x6f\156\145\x73\x2e\151\x53\x61\x6c\x6f\156\40\x3e\40\71\x30")->columns(array("\x69\x53\141\154\x6f\156", "\156\x53\x61\154\x6f\156", "\165\x73\165\141\x72\x69\x6f", "\143\154\x61\x76\145", "\146\x6f\156\x64\x6f"))->displayAs("\x69\123\x61\x6c\x6f\x6e", "\103\157\x64\x69\147\x6f")->displayAs("\156\123\x61\154\x6f\x6e", "\116\157\x6d\x62\x72\x65")->displayAs("\165\163\165\141\162\151\x6f", "\x41\x6c\151\141\x73")->displayAs("\x63\154\141\x76\x65", "\103\154\x61\166\145")->displayAs("\x66\157\x6e\144\x6f", "\x46\157\x6e\x64\x6f\x20\143\141\152\141")->unsetAddFields(array("\x74\157\x6b\145\156", "\x69\x53\141\154\x6f\x6e"))->unsetEditFields(array("\164\157\153\x65\x6e", "\151\x53\x61\x6c\x6f\x6e"))->unsetReadFields(array("\164\x6f\153\x65\x6e"))->unsetDelete()->unsetPrint(); $user = auth()->user(); if ($user->inGroup("\152\145\x66\x65\x73")) { $crud->setRead(); } else { $crud->unsetEdit(); $crud->unsetAdd(); $crud->setRead(); } $output = $crud->render(); $output->titulo = "\x53\x61\154\x6f\156\145\x73"; return $this->_crud_output($output); } public function taverias() : string { $user = auth()->user(); if (!$user->inGroup("\x6a\145\146\145\163", "\x63\x6f\x6e\x73\x75\x6c\x74\141")) { header("\114\x6f\x63\x61\164\151\x6f\x6e\x3a\x20" . base_url()); die; } $crud = new GroceryCrud(); $crud->setTable("\x64\141\x74\157\x73\137\x61\x76\x65\x72\x69\x61\163")->setRead()->setSubject("\x54\151\x70\157\x20\141\166\x65\x72\xc3\255\141")->columns(array("\151\x64", "\156\157\x6d\x62\162\x65"))->displayAs("\156\x6f\155\142\x72\145", "\x54\151\160\x6f")->displayAs("\x69\144", "\x43\xc3\263\x64\x69\147\x6f")->unsetDelete()->unsetPrint(); $user = auth()->user(); if ($user->inGroup("\x6a\145\x66\145\163")) { $crud->setRead(); $crud->setDelete(); } else { $crud->unsetEdit(); $crud->unsetAdd(); $crud->setRead(); } $output = $crud->render(); $output->titulo = "\x54\x69\160\x6f\x73\x20\x61\x76\145\162\xc3\255\x61"; return $this->_crud_output($output); } public function tinvitaciones() : string { $user = auth()->user(); if (!$user->inGroup("\152\x65\146\145\x73", "\x63\157\156\x73\x75\x6c\x74\141")) { header("\114\157\x63\x61\x74\151\157\156\x3a\x20" . base_url()); die; } $crud = new GroceryCrud(); $crud->setTable("\144\141\164\x6f\x73\137\x69\156\166\151\164\141\x63\151\157\x6e\x65\163")->setRead()->setSubject("\124\x69\160\157\x20\151\x6e\x76\x69\164\141\143\x69\303\xb3\x6e")->columns(array("\x69\x50\162\x6f\x64\x75\143\x74\157", "\x6e\x50\x72\157\x64\x75\x63\x74\x6f", "\x63\120\x72\x6f\144\x75\143\164\157"))->displayAs("\151\x50\162\x6f\x64\x75\143\164\x6f", "\103\303\263\x64\x69\x67\x6f")->displayAs("\156\120\x72\157\x64\165\143\164\x6f", "\x50\162\x6f\x64\165\x63\x74\x6f")->displayAs("\x63\120\x72\x6f\x64\165\x63\x74\x6f", "\x43\x6f\x73\x74\145")->unsetDelete()->unsetPrint(); $user = auth()->user(); if ($user->inGroup("\152\x65\146\145\x73")) { $crud->setRead(); $crud->setDelete(); } else { $crud->unsetEdit(); $crud->unsetAdd(); $crud->setRead(); } $output = $crud->render(); $output->titulo = "\124\x69\x70\157\163\x20\151\x6e\x76\151\x74\x61\143\151\xc3\xb3\x6e"; return $this->_crud_output($output); } public function tmantenimientos() : string { $user = auth()->user(); if (!$user->inGroup("\152\145\x66\x65\x73", "\x63\157\156\x73\x75\x6c\164\141")) { header("\x4c\157\x63\x61\x74\151\x6f\156\72\40" . base_url()); die; } $crud = new GroceryCrud(); $crud->setTable("\144\141\164\x6f\163\x5f\x6d\141\x6e\164\145\156\x69\x6d\x69\x65\x6e\x74\157")->setRead()->setSubject("\x54\x69\160\x6f\x20\155\x61\x6e\x74\145\x6e\151\155\151\x65\156\x74\x6f")->columns(array("\151\x64", "\x6e\157\155\x62\x72\x65"))->displayAs("\156\x6f\x6d\x62\162\x65", "\124\x69\160\157")->displayAs("\151\x64", "\x43\xc3\xb3\144\151\147\x6f")->unsetDelete()->unsetPrint(); $user = auth()->user(); if ($user->inGroup("\x6a\145\x66\x65\163")) { $crud->setRead(); $crud->setDelete(); } else { $crud->unsetEdit(); $crud->unsetAdd(); $crud->setRead(); } $output = $crud->render(); $output->titulo = "\x54\151\x70\157\x73\40\x6d\x61\156\x74\x65\x6e\151\155\151\x65\x6e\164\157\163"; return $this->_crud_output($output); } public function tzonas() : string { $user = auth()->user(); if (!$user->inGroup("\152\x65\x66\145\x73", "\x63\157\156\x73\x75\154\164\x61")) { header("\114\x6f\x63\x61\164\x69\x6f\156\x3a\x20" . base_url()); die; } $crud = new GroceryCrud(); $crud->setTable("\144\141\x74\157\163\x5f\172\x6f\156\141\x73")->setRead()->setSubject("\x54\151\x70\x6f\40\x7a\x6f\156\x61\x73")->columns(array("\151\132\157\156\141", "\156\x5a\157\156\141"))->displayAs("\156\132\x6f\156\141", "\124\151\160\157")->displayAs("\151\x5a\157\x6e\x61", "\103\303\263\144\x69\147\x6f")->unsetDelete()->unsetPrint(); $user = auth()->user(); if ($user->inGroup("\x6a\x65\x66\145\x73")) { $crud->setRead(); $crud->setDelete(); } else { $crud->unsetEdit(); $crud->unsetAdd(); $crud->setRead(); } $output = $crud->render(); $output->titulo = "\124\151\160\x6f\x73\x20\x7a\157\156\x61\x73"; return $this->_crud_output($output); } }

Function Calls

None

Variables

None

Stats

MD5 41dc262e1a5652d62fa65bbe469b994b
Eval Count 0
Decode Time 87 ms