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">
