function insertarExcel($array) { $uploadOk = 1; $time = time(); $fecha = date("Y-m-d", $time); $target_dir = "../documents/"; $target_file = $target_dir . basename($_FILES["archivoExcel"]["name"]); move_uploaded_file($array["archivoExcel"]["tmp_name"], $target_file); set_include_path(get_include_path() . PATH_SEPARATOR . '../complements/PHPExcel-1.8/Classes/'); $inputFileType = 'Excel2007'; include 'PHPExcel/IOFactory.php'; $inputFileName = $target_file; $objReader = PHPExcel_IOFactory::createReader($inputFileType); $objReader->setReadDataOnly(true); $objPHPExcel = $objReader->load($inputFileName); $sheetData = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true); require_once "../db/conexiones.php"; $consulta = new Conexion(); foreach ($sheetData as $datos) { $nombreSinAcentos = sanear_string($datos['B']); $nombre = strtoupper(trim($nombreSinAcentos)); $datosEmpleado = $consulta->Conectar("postgres", "SELECT * FROM userinfo WHERE UPPER(name)='" . $nombre . "'"); if ($datosEmpleado) { $sqlInsert = $this->invoco->Conectar("postgres", "INSERT INTO horario_personal (user_id, banda_id, fecha) VALUES (" . $datosEmpleado[0]['userid'] . "," . $datos['C'] . ", '" . $fecha . "')"); } } return "Se insertaron los datos Exitosamente!"; }
public static function getAllLaboratorios() { $conector = new Conexion("localhost", "DATABASE"); try { $con = $conector->Conectar(); $con->exec('SET CHARACTER SET utf8'); $con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $consulta = $con->query("SELECT laboratorio FROM Laboratorio;"); $conector = null; $con = null; return $consulta; } catch (Exception $e) { $conector = null; $con = null; throw $e; } }
public static function getCalendarioByNow($laboratorio) { $conector = new Conexion("localhost", "DATABASE"); try { $con = $conector->Conectar(); $con->exec('SET CHARACTER SET utf8'); $con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $consulta = $con->prepare("SELECT CalendarioLaboratorio.laboratorio, CalendarioLaboratorio.asignatura, Calendario.horaInicio, Calendario.horaFin FROM CalendarioLaboratorio, Calendario WHERE Calendario.dia = dayofweek(now()) AND time(subtime(now(), '01:00:00')) >= Calendario.horaInicio AND time(subtime(now(), '01:00:00')) <= Calendario.horaFin AND CalendarioLaboratorio.calencario = Calendario.id AND CalendarioLaboratorio.laboratorio = :laboratorio;"); $consulta->bindParam(':laboratorio', $laboratorio); $dato = array('laboratorio' => $laboratorio); $consulta->execute(); $conector = null; $con = null; return $consulta; } catch (Exception $e) { $conector = null; $con = null; throw $e; } }
public static function insertIdea($nombre, $idea, $fecha) { $conector = new Conexion("server", "database"); try { $con = $conector->Conectar(); $con->exec('SET CHARACTER SET utf8'); $con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $consulta = $con->prepare("INSERT INTO Idea (nombre, idea, fecha) VALUES (:nombre, :idea, :fecha);"); $consulta->bindParam(':nombre', $nombre, PDO::PARAM_STR); $consulta->bindParam(':idea', $idea, PDO::PARAM_STR); $consulta->bindParam(':fecha', $idea, PDO::PARAM_STR, 40); $datos = array('nombre' => $nombre, 'idea' => $idea, 'fecha' => $fecha); $consulta->execute($datos); $conector = null; $con = null; return $consulta; } catch (Exception $e) { $conector = null; $con = null; throw $e; } }
public function GetSlider() { $Conexion = new Conexion(); $cmd = $Conexion->Conectar(); try { $arrayName = array(); $cmd->beginTransaction(); foreach ($cmd->query('SELECT * FROM principal') as $row) { $ubicacion = ''; switch ($row['location']) { case 'a': //Superior Izquierda $ubicacion = "met_thumbnail_slider_1_effects met_thumbnail_slider_1_effects_left met_thumbnail_slider_1_top"; break; case 'b': //Superior Derecha $ubicacion = "met_thumbnail_slider_1_effects met_thumbnail_slider_1_effects_right met_thumbnail_slider_1_top"; break; case 'c': //Inferior Izquierda $ubicacion = "met_thumbnail_slider_1_effects met_thumbnail_slider_1_effects_left met_thumbnail_slider_1_bottom"; break; case 'd': //Inferior Derecha $ubicacion = "met_thumbnail_slider_1_effects met_thumbnail_slider_1_effects_right met_thumbnail_slider_1_bottom"; break; default: $ubicacion = "met_thumbnail_slider_1_effects met_thumbnail_slider_1_effects_left met_thumbnail_slider_1_top"; break; } $arrayName[$row['id']] = array('imagen' => $row['slider'], 'titulo' => $row['titulo'], 'subtitulo' => $row['subtitulo'], 'location' => $row['location'], 'ubicacion' => $ubicacion); } $Conexion->CerrarConexion(); return $arrayName; } catch (Exception $e) { } return $arrayName; }
<script type="text/javascript"> function administrativo(id){ var answer = confirm("¿Deseas modificar éste departamento?") if (answer){ var admin = document.getElementById("administrativo"+id).checked; cargaContent('configurarAdministrativo.php?id='+id+'&admin='+admin,'','contenido'); } else{ alert("No se ha modificado el Departamento!") } } </script> <?php require_once "../db/conexiones.php"; $consulta = new Conexion(); $datosDepartamentos = $consulta->Conectar("postgres", "SELECT * FROM dept ORDER BY deptid ASC"); $ultimoRefresh = $consulta->Conectar("postgres", "SELECT * FROM refrescamiento WHERE tabla='dept' ORDER BY fecha DESC LIMIT 1"); ?> <div class="row"> <div class="col-lg-12"> <h1 class="page-header">Departamentos</h1> </div> <!-- /.col-lg-12 --> </div> <!-- /.row --> <div class="row"> <div class="col-lg-12"> <div class="panel panel-default"> <div class="panel-heading"> Listado de Departamentos </div>
<?php require_once "../db/conexiones.php"; $consulta = new Conexion(); $sql = $consulta->Conectar("postgres", "UPDATE dept SET administrativo=" . $_GET['admin'] . " WHERE deptid=" . $_GET['id'] . ""); require_once "administrarDepartamentos.php"; ?> <script type="text/javascript"> alert("El departamento se modificó exitosamente!"); </script>
"sLast": "Último", "sNext": "Siguiente", "sPrevious": "Anterior" }, "oAria": { "sSortAscending": ": Activar para ordenar la columna de manera ascendente", "sSortDescending": ": Activar para ordenar la columna de manera descendente" } } }); }); </script> <?php require_once "../db/conexiones.php"; $consulta = new Conexion(); $datosEmpleados = $consulta->Conectar("postgres", "SELECT userinfo.*, dept.deptname FROM userinfo INNER JOIN dept ON userinfo.deptid=dept.deptid ORDER BY userinfo.userid ASC"); $ultimoRefresh = $consulta->Conectar("postgres", "SELECT * FROM refrescamiento WHERE tabla='userinfo' ORDER BY fecha DESC LIMIT 1"); ?> <div class="row"> <div class="col-lg-12"> <h1 class="page-header">Empleados</h1> </div> <!-- /.col-lg-12 --> </div> <!-- /.row --> <div class="row"> <div class="col-lg-12"> <div class="panel panel-default"> <div class="panel-heading"> Listado de Empleados </div>
public function GetOneSlider($id) { $Conexion = new Conexion(); $con = $Conexion->Conectar(); try { $cmd = $con->prepare("SELECT * FROM principal WHERE id=:id"); $stmt->execute(array(":id" => $id)); $editRow = $stmt->fetch(PDO::FETCH_ASSOC); return $editRow; } catch (Exception $e) { } }
success: function(data){ alert(data); setTimeout( function(){ $('#contenido').load("opcionesHorarioPorPersonal.php"); }, 1000); } }); } }); }); </script> <?php error_reporting(0); require_once "../db/conexiones.php"; $consulta = new Conexion(); $empleado = $consulta->Conectar("postgres", "SELECT * FROM userinfo WHERE userid=" . $_REQUEST['id']); $datosBanda = $consulta->Conectar("postgres", "SELECT banda.*, tipo_horario.nombre FROM banda INNER JOIN tipo_horario ON banda.tipo_horario_id=tipo_horario.id ORDER BY banda.id"); $horarioPersonal = $consulta->Conectar("postgres", "SELECT horario_Personal.*, userinfo.name FROM horario_Personal INNER JOIN userinfo ON horario_Personal.user_id=userinfo.userid WHERE horario_Personal.user_id=" . $_REQUEST['id'] . " ORDER BY horario_Personal.id DESC LIMIT 1"); ?> <div class="row"> <div class="col-lg-12"> <h1 class="page-header">Horario por Personal</h1> </div> <!-- /.col-lg-12 --> </div> <div class="row"> <div class="col-lg-12"> <div class="panel panel-default"> <div class="panel-heading"> Horario del Empleado </div>
"sLast": "Último", "sNext": "Siguiente", "sPrevious": "Anterior" }, "oAria": { "sSortAscending": ": Activar para ordenar la columna de manera ascendente", "sSortDescending": ": Activar para ordenar la columna de manera descendente" } } }); }); </script> <?php require_once "../db/conexiones.php"; $consulta = new Conexion(); $datosBanda = $consulta->Conectar("postgres", "SELECT banda.*, tipo_horario.nombre FROM banda INNER JOIN tipo_horario ON banda.tipo_horario_id=tipo_horario.id ORDER BY banda.id ASC"); ?> <div class="row"> <div class="col-lg-12"> <h1 class="page-header">Bandas de Horario</h1> </div> <!-- /.col-lg-12 --> </div> <!-- /.row --> <div class="row"> <div class="col-lg-12"> <div class="panel panel-default"> <div class="panel-heading"> Listado de Bandas de Horario </div> <!-- /.panel-heading -->
}, onUnSelect: function(dt){ this.p.my_end_cal.set_date_on_available({}); var st_dt = this.get_start_date().clone(); this.p.my_end_cal.set_start_date(st_dt); } } }); }); }); </script> <?php require_once "../db/conexiones.php"; $consulta = new Conexion(); $departamentos = $consulta->Conectar("postgres", "SELECT * FROM dept ORDER BY deptid DESC"); $empleados = $consulta->Conectar("postgres", "SELECT * FROM userinfo ORDER BY userid DESC"); ?> <div class="row"> <div class="col-lg-12"> <h1 class="page-header">Reporte de Horas Trabajadas</h1> </div> <!-- /.col-lg-12 --> </div> <!-- /.row --> <div class="row"> <div class="col-lg-12"> <div class="panel panel-default"> <div class="panel-heading"> Generar Reporte </div>
<script> $('#divSincronizar').show(); </script> <?php ini_set('max_execute_time', 0); set_time_limit(600); require_once "../db/conexiones.php"; $consulta = new Conexion(); $datosDepartamentos = $consulta->Conectar("access", "SELECT * FROM Dept ORDER BY Deptid ASC"); $datosDepartamentosPostgres = $consulta->Conectar("postgres", "SELECT deptid FROM dept ORDER BY deptid ASC"); $update = 0; if (!$datosDepartamentos) { exit("Error en la actualizacion de los Dept."); } else { foreach ($datosDepartamentos as $key => $departamento) { $nombre_dept = $departamento['DeptName']; $deptid = $departamento['Deptid']; $supDeptid = $departamento['SupDeptid']; if (!array_key_exists($key, $datosDepartamentosPostgres)) { $sqlInsert = $consulta->Conectar("postgres", "INSERT INTO dept VALUES (" . $deptid . ", '" . utf8_encode(trim($nombre_dept)) . "', " . $supDeptid . ")"); } else { $sqlUpdate = $consulta->Conectar("postgres", "UPDATE dept SET deptname='" . utf8_encode(trim($nombre_dept)) . "', supdeptid=" . $supDeptid . " WHERE deptid=" . $deptid . ""); } } $time = time(); $fecha = date("Y-m-d H:i:s", $time); $tabla = "dept"; $sqlInsertRefresh = $consulta->Conectar("postgres", "INSERT INTO refrescamiento (fecha, tabla) VALUES ('" . $fecha . "','" . $tabla . "')"); $update = 1; } ?>
"sLast": "Último", "sNext": "Siguiente", "sPrevious": "Anterior" }, "oAria": { "sSortAscending": ": Activar para ordenar la columna de manera ascendente", "sSortDescending": ": Activar para ordenar la columna de manera descendente" } } }); }); </script> <?php require_once "../db/conexiones.php"; $consulta = new Conexion(); $ultimoMarcaje = $consulta->Conectar("postgres", "SELECT * FROM refrescamiento WHERE tabla='checkinout' ORDER BY fecha DESC LIMIT 1"); $ultimosMarcajes = $consulta->Conectar("postgres", "SELECT * FROM checkinout ORDER BY logid DESC LIMIT 1"); $ultimaFechaMarcaje = strtotime($ultimosMarcajes[0]['checktime']); $ultimaFechaMarcaje = date("Y-m-j", $ultimaFechaMarcaje); $datosMarcajes = $consulta->Conectar("postgres", "SELECT checkinout.logid, checkinout.checktime, userinfo.name FROM checkinout INNER JOIN userinfo ON checkinout.userid=userinfo.userid WHERE checkinout.checktime BETWEEN '" . $ultimaFechaMarcaje . " 00:00:00' AND '" . $ultimaFechaMarcaje . " 23:59:59' ORDER BY checkinout.checktime ASC"); ?> <div class="row"> <div class="col-lg-12"> <h1 class="page-header">Marcajes</h1> </div> <!-- /.col-lg-12 --> </div> <!-- /.row --> <div class="row"> <div class="col-lg-12"> <div class="panel panel-default">
<?php ini_set('max_execute_time', 0); set_time_limit(600); require_once "../db/conexiones.php"; $consulta = new Conexion(); $update = 0; $ultimoMarcaje = $consulta->Conectar("postgres", "SELECT * FROM checkinout ORDER BY logid DESC LIMIT 1"); $datosMarcaje = $consulta->Conectar("access", "SELECT Checkinout.Logid, Checkinout.Userid, Checkinout.CheckTime, Checkinout.CheckType FROM Checkinout WHERE Checkinout.Logid > " . $ultimoMarcaje[0]['logid'] . " ORDER BY Checkinout.Logid ASC"); if (!$datosMarcaje) { exit("No existen marcajes para actualizar. Por favor Intente más tarde."); } else { foreach ($datosMarcaje as $key => $marcaje) { $logid = $marcaje['Logid']; $userid = $marcaje['Userid']; $checktime = $marcaje['CheckTime']; $checktype = $marcaje['CheckType']; $sqlInsert = $consulta->Conectar("postgres", "INSERT INTO checkinout VALUES (" . $logid . ", " . $userid . ", '" . $checktime . "', '" . $checktype . "')"); } $time = time(); $fecha = date("Y-m-d H:i:s", $time); $tabla = "checkinout"; $sqlInsertRefresh = $consulta->Conectar("postgres", "INSERT INTO refrescamiento (fecha, tabla) VALUES ('" . $fecha . "','" . $tabla . "')"); $update = 1; } ?> <script> $('#divSincronizar').hide(); $('.well').show(); </script> <?php
}); } }); }); </script> <script type="text/javascript"> $('.timepickr').timepickr({ convention: 24, format: '{h}:{m}', hoverIntent: false }); </script> <?php require_once "../db/conexiones.php"; $consulta = new Conexion(); $tipoHorario = $consulta->Conectar("postgres", "SELECT * FROM tipo_horario ORDER BY id ASC"); if ($_GET['id'] !== 0) { $banda = $consulta->Conectar("postgres", "SELECT * FROM banda WHERE id=" . $_GET['id']); } ?> <div class="row"> <div class="col-lg-12"> <h1 class="page-header">Banda de Horario</h1> </div> <!-- /.col-lg-12 --> </div> <div class="row"> <div class="col-lg-12"> <div class="panel panel-default"> <div class="panel-heading"> Nueva Banda
<?php require_once "../db/conexiones.php"; $consulta = new Conexion(); $sqlDelete = $consulta->Conectar("postgres", "DELETE FROM feriado WHERE id=" . $_GET['id']); require_once "administrarDiasFeriados.php"; ?> <script type="text/javascript"> alert("El día feriado se eliminó exitosamente!"); </script>
messages: { 'nombre': { required: "El Nombre es requerido.", } }, submitHandler: function(form){ var id = $("#nombre").val(); $('#contenido').load("crearHorarioPersonal.php?id="+id); } }); }); </script> <?php require_once "../db/conexiones.php"; $consulta = new Conexion(); $datosEmpleados = $consulta->Conectar("postgres", "SELECT * FROM userinfo ORDER BY userid ASC"); ?> <div class="row"> <div class="col-lg-12"> <h1 class="page-header">Horario por Personal</h1> </div> <!-- /.col-lg-12 --> </div> <div class="row"> <div class="col-lg-12"> <div class="panel panel-default"> <div class="panel-heading"> Datos del Empleado </div> <div class="panel-body"> <div class="row">
}); } }); }); </script> <script type="text/javascript"> $('.timepickr').timepickr({ convention: 24, format: '{h}:{m}', hoverIntent: false }); </script> <?php require_once "../db/conexiones.php"; $consulta = new Conexion(); $datosBanda = $consulta->Conectar("postgres", "SELECT banda.*, tipo_horario.nombre FROM banda INNER JOIN tipo_horario ON banda.tipo_horario_id=tipo_horario.id WHERE banda.id=" . $_GET['id']); $tipoHora = $consulta->Conectar("postgres", "SELECT * FROM tipo_hora ORDER BY id ASC"); $rangoB = $consulta->Conectar("postgres", "SELECT * FROM rango_banda WHERE banda_id=" . $_GET['id'] . " ORDER BY id DESC LIMIT 1"); if ($rangoB) { $horaD = $rangoB[0]['hora_hasta']; } else { $horaD = $datosBanda[0]['hora_entrada']; } if ($_GET['idRango'] != 0) { $rangoBanda = $consulta->Conectar("postgres", "SELECT * FROM rango_banda WHERE id=" . $_GET['idRango']); $horaD = $rangoBanda[0]['hora_desde']; } ?> <div class="row"> <div class="col-lg-12"> <h1 class="page-header">Rango de Banda</h1>
<?php ini_set('max_execute_time', 0); set_time_limit(600); require_once "../db/conexiones.php"; $consulta = new Conexion(); $datosEmpleados = $consulta->Conectar("access", "SELECT * FROM Userinfo ORDER BY Userid ASC"); $datosEmpleadosPostgres = $consulta->Conectar("postgres", "SELECT userid FROM userinfo ORDER BY userid ASC"); $update = 0; if (!$datosEmpleados) { exit("Error en la actualizacion de los Empleados."); } else { foreach ($datosEmpleados as $key => $empleados) { $name = $empleados['Name']; $userid = $empleados['Userid']; $deptid = $empleados['Deptid']; $employdate = $empleados['EmployDate']; $duty = $empleados['Duty']; if (!array_key_exists($key, $datosEmpleadosPostgres)) { $sqlInsert = $consulta->Conectar("postgres", "INSERT INTO userinfo VALUES (" . $userid . ", '" . utf8_encode(trim($name)) . "', " . $deptid . ", '" . $employdate . "', '" . utf8_encode(trim($duty)) . "')"); } else { $sqlUpdate = $consulta->Conectar("postgres", "UPDATE userinfo SET name='" . utf8_encode(trim($name)) . "', deptid=" . $deptid . ", employdate='" . $employdate . "', duty='" . utf8_encode(trim($duty)) . "' WHERE userid=" . $userid . ""); } } $time = time(); $fecha = date("Y-m-d H:i:s", $time); $tabla = "userinfo"; $sqlInsertRefresh = $consulta->Conectar("postgres", "INSERT INTO refrescamiento (fecha, tabla) VALUES ('" . $fecha . "','" . $tabla . "')"); $update = 1; } ?>
</script> <script type="text/javascript"> function eliminarDF(id){ var answer = confirm("¿Deseas Eliminar este día feriado?") if (answer){ cargaContent('eliminarDiaFeriado.php?id='+id,'','contenido'); } else{ alert("No se ha eliminado el día feriado!") } } </script> <?php require_once "../db/conexiones.php"; $consulta = new Conexion(); $diasFeriados = $consulta->Conectar("postgres", "SELECT * FROM feriado ORDER BY feriado.id ASC"); ?> <div class="row"> <div class="col-lg-12"> <h1 class="page-header">Días Feriados</h1> </div> <!-- /.col-lg-12 --> </div> <!-- /.row --> <div class="row"> <div class="col-lg-12"> <div class="panel panel-default"> <div class="panel-heading"> Listado de Días Feriados </div> <!-- /.panel-heading -->
background-color: #fff; background-image: none; border: 1px solid #ccc; border-radius: 4px; -webkit-box-shadow: inset 0 1px 1px rgba(0,0,0,.075); box-shadow: inset 0 1px 1px rgba(0,0,0,.075); -webkit-transition: border-color ease-in-out .15s,-webkit-box-shadow ease-in-out .15s; -o-transition: border-color ease-in-out .15s,box-shadow ease-in-out .15s; transition: border-color ease-in-out .15s,box-shadow ease-in-out .15s; } </style> <?php require_once "../db/conexiones.php"; $consulta = new Conexion(); if ($_GET['id'] !== 0) { $feriado = $consulta->Conectar("postgres", "SELECT * FROM feriado WHERE id=" . $_GET['id']); } ?> <div class="row"> <div class="col-lg-12"> <h1 class="page-header">Días Feriados</h1> </div> <!-- /.col-lg-12 --> </div> <div class="row"> <div class="col-lg-12"> <div class="panel panel-default"> <div class="panel-heading"> Nuevos Días Feriados </div> <div class="panel-body">