function get_options_fincas() { $con = new con(); $msg = new messages(); $rt = new route(); $con->connect(); //consultamos fincas desde la matriz ica if (isset($_SESSION["ses_id"])) { $qry = 'SELECT DISTINCT codfinca, municipio, depto FROM tbl_matriz_ica ORDER BY codfinca ASC'; $res = mysql_query($qry); $item = " "; $script = "<script>\$(document).ready(function(){"; while ($row_res = mysql_fetch_assoc($res)) { $item .= ' <option value="' . $row_res["codfinca"] . '">' . $row_res["codfinca"] . ' (' . $row_res["municipio"] . ' - ' . $row_res["depto"] . ')</option> '; $script .= ''; } $script .= '});</script>'; } else { $rt->routing($rt->path("login")); } $html = ' <select class="form-control valued" id="cod"> ' . $item . ' </select> '; $con->disconnect(); return $script . $html; }
function get_reports() { $con = new con(); $msg = new messages(); $rt = new route(); $con->connect(); //consultamos fincas if (isset($_SESSION["ses_id"])) { $qry = 'SELECT * FROM tbl_reporte_consecutivo ORDER BY rp_consecutivo DESC '; $res = mysql_query($qry); $item = " "; $script = "<script>\$(document).ready(function(){"; while ($row_res = mysql_fetch_assoc($res)) { $item .= ' <tr> <td>' . $row_res["rp_timestamp"] . '</td> <td>' . $row_res["rp_consecutivo"] . '</td> <td>' . $row_res["rp_causa"] . '</td> </tr> '; $script .= ''; } $script .= '});</script>'; } else { $rt->routing($rt->path("login")); } $html = ' <table class="table table-striped table-hover "> <thead> <tr> <th>Fecha reporte</th> <th>Consecutivo</th> <th>Causa</th> </tr> </thead> <tbody> ' . $item . ' </tbody> </table> '; $con->disconnect(); return $script . $html; }
function build_menu_aside() { $con = new con(); $msg = new messages(); $rt = new route(); $con->connect(); //consultamos sesión del usuario if (isset($_SESSION["ses_id"])) { $qry = 'SELECT * FROM tbl_modulos AS M INNER JOIN tbl_usuarios AS U INNER JOIN tbl_permisos AS P INNER JOIN tbl_per_x_usu AS PxU INNER JOIN tbl_permisos_x_modulo AS PxM WHERE M.mo_id = PxM.pxm_mo_id AND PxM.pxm_pe_id = P.pe_id AND P.pe_id = PxU.pxu_pe_id AND PxU.pxu_us_id = U.us_id AND U.us_id = ' . $_SESSION["ses_id"] . ' LIMIT 1'; $res = mysql_query($qry); $menuitem = " "; $script = "<script>\$(document).ready(function(){"; while ($row_res = mysql_fetch_assoc($res)) { $cargo = $row_res['pe_descripcion']; $nombre = $row_res['us_nombre']; //si es superadmin, le habilitamos el menú de gestión de usuarios y permisos switch ($row_res['pe_permiso']) { case 1: //superAdmin $script .= '$("#usuarios").on("click", function(){$(location).attr("href","../users/users.php"); });'; $script .= '$("#reportar").on("click", function(){$(location).attr("href","../reportar/reportar.php"); });'; $menuitem .= '<li><a href="#" id="usuarios" class=""><i class="md md-user"></i>Usuarios</a></li>'; $menuitem .= '<li><a href="#" id="reportar" class=""><i class="md md-user"></i>Reportar Consecutivo</a></li>'; $icon = '<a href="#" class="btn btn-floating-mini btn-warning" title="' . $row_res['pe_descripcion'] . '" data-ripple-centered=""><i class="md md-account-circle"></i></a>'; break; case 2: //Jefeop $icon = '<a href="#" class="btn btn-floating-mini btn-primary" title="' . $row_res['pe_descripcion'] . '" data-ripple-centered=""><i class="md md-account-circle"></i></a>'; break; case 3: //Digit $icon = '<a href="#" class="btn btn-floating-mini btn-success" title="' . $row_res['pe_descripcion'] . '" data-ripple-centered=""><i class="md md-account-circle"></i></a>'; break; case 4: //Gerente $icon = '<a href="#" class="btn btn-floating-mini btn-warning" title="' . $row_res['pe_descripcion'] . '" data-ripple-centered=""><i class="md md-account-circle"></i></a>'; break; default: $menuitem = ""; break; } /*$tipo_us = $row_res['pxu_pe_id']; //$menuitem.='<li><a href="'.$row_res['mo_ruta'].'" class="">'.$row_res['mo_nombre'].'</a></li>'; $menuitem.='<li><a href="#" id="'.$row_res['mo_nombre'].'" class="">'.$row_res['mo_descripcion'].'</a></li>'; $script.='$("#'.$row_res['mo_nombre'].'").on("click", function(){$(location).attr("href","'.$row_res['mo_ruta'].'"); });'; */ } $script .= '});</script>'; } else { $rt->routing($rt->path("login")); } $html = ' <nav class="navbar-panel"> <div class="header container-fluid mtr-cyan-900"> <div class="row"> <div class="col-xs-12"> <h1 style="text-align:center; padding-top:6px; margin-bottom: 6px;">' . $icon . '</h1> <h4 style="margin-top: 1px;"><b>' . $nombre . '</b> <br> <span style="font-style:italic; font-size:13px;">' . $cargo . '<span></h4> <h4></h4> </div> </div> </div> <div class="content mtr-grey-100"> <ul class="nav"> ' . $menuitem . ' <li><a href="#" id="btn_logout">Salir</a></li> </ul> </div> </nav> '; $con->disconnect(); return $script . $html; }
function get_fincas_list() { $con = new con(); $msg = new messages(); $rt = new route(); $con->connect(); //consultamos fincas desde la tabla de fincas if (isset($_SESSION["ses_id"])) { $qry = 'SELECT * FROM tbl_fincas WHERE fi_estado=1 ORDER BY fi_id ASC'; $res = mysql_query($qry); $item = " "; $script = "<script>\$(document).ready(function(){"; while ($row_res = mysql_fetch_assoc($res)) { $item .= ' <option value="' . $row_res["fi_id"] . '">' . $row_res["fi_codigo"] . '</option> '; $script .= ''; } $script .= '});</script>'; } else { $rt->routing($rt->path("login")); } $html = ' <select class="form-control valued" id="cod"> <option>Seleccione</option> ' . $item . ' </select> '; $con->disconnect(); return $script . $html; }
<?php session_start(); session_unset(); //borro todas las variables de session session_destroy(); //destruyo la sesion include "../mods/route.php"; $e = new route(); $response = new StdClass(); $response->res = true; $response->mes = $e->path("login"); echo json_encode($response); ?>
function get_options_vehiculos($id = 'cod_prop') { $con = new con(); $msg = new messages(); $rt = new route(); $con->connect(); //consultamos fincas desde la matriz ica if (isset($_SESSION["ses_id"])) { $qry = 'SELECT DISTINCT ve_id, ve_placa, ve_capacidad_m3 FROM tbl_vehiculos WHERE ve_estado=1 ORDER BY ve_placa ASC'; $res = mysql_query($qry); $item = " "; $script = "<script>\$(document).ready(function(){"; while ($row_res = mysql_fetch_assoc($res)) { $item .= ' <option value="' . $row_res["ve_id"] . '">' . $row_res["ve_placa"] . ' (Capacidad: ' . $row_res["ve_capacidad_m3"] . ' m<sup>3</sup>)</option> '; $script .= ''; } $script .= '});</script>'; } else { $rt->routing($rt->path("login")); } $html = ' <select class="form-control valued" id="' . $id . '"> ' . $item . ' </select> '; $con->disconnect(); return $script . $html; }
function build_menu() { $con = new con(); $msg = new messages(); $rt = new route(); $con->connect(); //consultamos sesión del usuario if (isset($_SESSION["ses_id"])) { $qry = 'SELECT * FROM tbl_modulos AS M INNER JOIN tbl_usuarios AS U INNER JOIN tbl_permisos AS P INNER JOIN tbl_per_x_usu AS PxU INNER JOIN tbl_permisos_x_modulo AS PxM WHERE M.mo_id = PxM.pxm_mo_id AND PxM.pxm_pe_id = P.pe_id AND P.pe_id = PxU.pxu_pe_id AND PxU.pxu_us_id = U.us_id AND U.us_id = ' . $_SESSION["ses_id"]; $res = mysql_query($qry); $menuitem = " "; $script = "<script>\$(document).ready(function(){"; while ($row_res = mysql_fetch_assoc($res)) { $tipo_us = $row_res['pxu_pe_id']; //$menuitem.='<li><a href="'.$row_res['mo_ruta'].'" class="">'.$row_res['mo_nombre'].'</a></li>'; $menuitem .= '<li><a href="#" id="' . $row_res['mo_nombre'] . '" class="">' . $row_res['mo_descripcion'] . '</a></li>'; $script .= '$("#' . $row_res['mo_nombre'] . '").on("click", function(){$(location).attr("href","' . $row_res['mo_ruta'] . '"); });'; } $script .= '});</script>'; } else { $rt->routing($rt->path("login")); } //generamos menú tipo dropdown para el usuario gerente if ($tipo_us == 1) { $dropdown = '<li class="dropdown"> <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-expanded="false">Gestionar <span class="caret"></span></a> <ul class="dropdown-menu" role="menu"> ' . $menuitem . ' </ul> </li> <li class="dropdown"> <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-expanded="false">Reportes <span class="caret"></span></a> <ul class="dropdown-menu" role="menu"> <li><a onclick="reporte(1)" target="_blank" id="" class="">Reporte de Consecutivos ICA generados</a></li> <li><a onclick="reporte(2)" target="_blank" id="" class="">Reporte de Despachos Generados</a></li> </ul> </li> <li class="dropdown"> <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-expanded="false">Programación (Cronjobs) <span class="caret"></span></a> <ul class="dropdown-menu" role="menu"> <li><a onclick="go_cj_r()" target="">Despachos</a></li> <li><a onclick="go_cj_i()" target="">Consecutivos ICA</a></li> </ul> </li>'; $menuitem = $dropdown; } $html = ' <nav class="navbar navbar-inverse"> <div class="container-fluid"> <div class="navbar-header"> <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-2"> <span class="sr-only">Toggle navigation</span> <span class="icon-bar"></span> <span class="icon-bar"></span> <span class="icon-bar"></span> </button> </div> <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-2"> <ul class="nav navbar-nav"> ' . $menuitem . ' </ul> <ul class="nav navbar-nav navbar-right"> <li><a href="#" id="reloj">fecha / hora</a></li> </ul> </div> </div> </nav> '; $con->disconnect(); return $script . $html; }
function get_rfisicas() { $con = new con(); $msg = new messages(); $rt = new route(); $con->connect(); //consultamos fincas if (isset($_SESSION["ses_id"])) { $qry = 'SELECT * FROM tbl_remisiones_fisicas ORDER BY rf_estado DESC '; $res = mysql_query($qry); $item = " "; $script = "<script>\$(document).ready(function(){"; while ($row_res = mysql_fetch_assoc($res)) { $denominador = $row_res["rf_dig_fin"] - $row_res["rf_dig_ini"]; //calculamos porcentaje de uso if ($denominador > 0) { $porcentaje = $row_res["rf_cant_usados"] * 100 / $denominador; } else { $porcentaje = 0; } //echo "datos: <br> -usados: ".$row_res["rf_cant_usados"]."<br>-fin: ".$row_res["rf_dig_fin"]."<br>-ini: ".$row_res["rf_dig_ini"]; //boton de activacion/desactivación if ($row_res["rf_estado"] == 1) { $btn = '<div id="act-button" style="display:" onclick="change(1, ' . $row_res['rf_id'] . ')" class="btn btn-floating-mini btn-success" title="Activar Paquete"><i class="md md-done"></i></div> <div id="des-button" style="display:none" onclick="change(2, ' . $row_res['rf_id'] . ')" class="btn btn-floating-mini btn-warning" title="Desactivar Paquete"><i class="md md-close"></i></div>'; } else { $btn = '<div id="act-button" style="display:none" onclick="change(1, ' . $row_res['rf_id'] . ')" class="btn btn-floating-mini btn-success" title="Activar Paquete"><i class="md md-done"></i></div> <div id="des-button" style="display:" onclick="change(2, ' . $row_res['rf_id'] . ')" class="btn btn-floating-mini btn-warning" title="Desactivar Paquete"><i class="md md-close"></i></div>'; } $btn_edt = '<div id="act-button" onclick="load_row(' . $row_res['rf_id'] . ')" class="btn btn-floating-mini btn-info" title="Modificar Paquete"><i class="md md-edit"></i></div>'; //-- $item .= ' <tr> <td>' . $row_res["rf_timestamp"] . '</td> <td>' . $row_res["rf_persona_entrega"] . '</td> <td>' . $row_res["rf_interventor"] . '</td> <td>' . $row_res["rf_dig_ini"] . '</td> <td>' . $row_res["rf_dig_fin"] . '</td> <td><div class="progress progress-striped active"> <div class="progress-bar" title="' . $row_res["rf_cant_usados"] . ' (' . $porcentaje . '%)" style="width: ' . $porcentaje . '%; height:10px;"></div> </div> </td> <td> ' . $btn_edt . $btn . ' </td> </tr> '; $script .= ''; } $script .= '});</script>'; } else { $rt->routing($rt->path("login")); } $html = ' <table class="table table-striped table-hover "> <thead> <tr> <th>Fecha Registro</th> <th>Recibido</th> <th>Interventor</th> <th>Inicia</th> <th>Termina</th> <th>Usados</th> <th>Acciones</th> </tr> </thead> <tbody> ' . $item . ' </tbody> </table> '; $con->disconnect(); return $script . $html; }
function get_personas() { $con = new con(); $msg = new messages(); $rt = new route(); $con->connect(); //consultamos Inventarios if (isset($_SESSION["ses_id"])) { $qry = 'SELECT * FROM tbl_personas WHERE pe_estado BETWEEN 1 AND 2 ORDER BY pe_nombre ASC'; $res = mysql_query($qry); $item = " "; $script = "<script>\$(document).ready(function(){"; while ($row_res = mysql_fetch_assoc($res)) { if ($row_res["pe_tipo"] == 1) { $lic = ''; } else { $lic = $row_res["pe_licencia"] . ' - (' . $row_res["pe_licencia_vigencia"] . ')'; } $btn_des = "des_persona('" . $row_res["pe_id"] . "',this)"; $btn_act = "act_persona('" . $row_res["pe_id"] . "',this)"; $btn_del = "del_persona('" . $row_res["pe_id"] . "',this)"; if ($row_res["pe_estado"] == 1 && $row_res["pe_tipo"] != 1) { $btn_set = '<div id="edt-button" style="display:none;" onclick="" class="btn btn-floating-mini btn-success" title="Modificar"><i class="md md-edit"></i></div> <div id="des-button" onclick="' . $btn_des . '" class="btn btn-floating-mini btn-warning" title="Deshabilitar"><i class="md md-visibility-off"></i></div> <div id="del-button" onclick="' . $btn_del . '" class="btn btn-floating-mini btn-danger" title="Borrar"><i class="md md-delete"></i></div>'; } elseif ($row_res["pe_estado"] == 2 && $row_res["pe_tipo"] != 1) { $btn_set = '<div id="edt-button" style="display:none;" onclick="" class="btn btn-floating-mini btn-success" title="Modificar"><i class="md md-edit"></i></div> <div id="act-button" onclick="' . $btn_act . '" class="btn btn-floating-mini btn-warning" title="Habilitar"><i class="md md-visibility"></i></div> <div id="del-button" onclick="' . $btn_del . '" class="btn btn-floating-mini btn-danger" title="Borrar"><i class="md md-delete"></i></div>'; } else { $btn_set = '<div id="edt-button" style="display:none;" onclick="" class="btn btn-floating-mini btn-success" title="Modificar"><i class="md md-edit"></i></div> <div id="del-button" onclick="' . $btn_del . '" class="btn btn-floating-mini btn-danger" title="Borrar"><i class="md md-delete"></i></div>'; } $item .= ' <tr id="' . $row_res["pe_cedula"] . '"> <td>' . $row_res["pe_cedula"] . '</td> <td>' . $row_res["pe_nombre"] . '</td> <td>' . $row_res["pe_tel"] . ' - ' . $row_res["pe_cel"] . '</td> <td>' . $row_res["pe_dir"] . '</td> <td>' . $lic . '</td> <td> ' . $btn_set . ' </td> </tr> '; switch ($row_res["pe_estado"]) { case 2: $script .= '$("#' . $row_res["pe_cedula"] . '").addClass("danger");'; break; } $script .= '$("#' . $row_res["pe_cedula"] . '").addClass();'; } $script .= '});</script>'; } else { $rt->routing($rt->path("login")); } $html = ' <table class="table table-striped table-hover "> <thead> <tr> <th>Cédula</th> <th>Nombre</th> <th>Tel - Cel</th> <th>Domicilio</th> <th>Licencia</th> <th>Acciones</th> </tr> </thead> <tbody> ' . $item . ' </tbody> </table> '; $con->disconnect(); return $script . $html; }