function things()
{
echo "write statement\r\n";
sqlWriteStatement('');
echo "mes\r\n";
echo mes('This is a thing');
}
function fechaATexto($fecha, $formato = 'c')
{
// Validamos que la cadena satisfaga el formato deseado y almacenamos las partes
if (ereg("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2})", $fecha, $partes)) {
// $partes[0] contiene la cadena original
// $partes[1] contiene el año
// $partes[2] contiene el número de mes
// $partes[3] contiene el número del día
$mes = ' de ' . mes($partes[2]);
// Corregido!
if ($formato == 'u') {
$mes = strtoupper($mes);
} elseif ($formato == 'l') {
$mes = strtolower($mes);
}
if ($formato == 'M') {
return $partes[3] . $mes;
} else {
return $partes[3] . $mes . ' de ' . $partes[1];
}
} else {
// Si hubo problemas en la validación, devolvemos false
return false;
}
}
function stSep()
{
include '../../../../includes/db_connect.php';
$maestro = $_SESSION['username'];
$password = $_SESSION['password'];
$seleccion = "SELECT * FROM teacher T, user U \n WHERE T.iduser = U.id_user AND\n U.category = 'maestro' AND\n U.username = '******' AND\n U.password = '******' ;";
$do = mysqli_query($db_connect, $seleccion) or die(mysqli_error());
if ($do) {
while ($pointer = mysqli_fetch_array($do)) {
$idTeacher = $pointer['id_teacher'];
}
}
//-- <-------------------------- ******************************* ------------------------------->
#-- Consulta para obtener la lista de alumnos.
$query = "SELECT * FROM student S, academic_info A, sep R, classes C, naatik_course N, groups_nc G\n WHERE S.id_student = A.id_student AND\n A.reg_sep = R.id_sep AND\n A.id_classes = C.id_class AND\n C.id_course = N.id_course AND\n C.id_group = G.id_group AND\n C.teacher = '{$idTeacher}' AND \n R.issep = 'si';";
$result = mysqli_query($db_connect, $query) or die(mysqli_error());
$id = 1;
$info_sep = "";
$showAdd = "";
//-- <-------------------------- ******************************* ------------------------------->
#-- Obtener y mostrar los resultados de la consulta.
while ($row = mysqli_fetch_array($result)) {
if ($id % 2 == 0) {
$div = "<div class='clearfix'></div>";
} else {
$div = '';
}
$showAdd = "\n <div class='row'><div class='col-md-10'></div>\n <div class='col-md-2'>\n <a href='#' onclick='showDataSep(" . $row['id_student'] . ");' data-toggle='modal' data-target='.bs-example-modal-editor' class='btn btn-fab btn-raised mdi-content-create sepIcons'></a>\n </div>\n </div>";
$info_sep = "<hr clss='hr'>\n <label>Número de Registro: </label>" . " " . $row['regis_num'] . "<br>\n <label>Fecha de Registro: </label>" . " " . $row['date_incorporate'] . "<br>\n <label>Calificación: </label>" . " " . $row['calification_sep'] . "<br>";
//-- <-------------------------- ++++++++++ ------------------------------->
$nacimiento = mes($row['birthday']);
$edad = calcular($row['birthday']);
#-- Calcular la edad del alumno con su fecha de nacimiento.
#-- Filtrar unicamente a los alumnos que tengan 15 o mas años.
if ($edad >= 15) {
echo "<div class='col-sm-12 col-sm-12 col-md-6 col-lg-6'>";
echo "<div class='panel-group' id='accordion' role='tablist' aria-multiselectable='true'>\n <div class='panel panel-default'>\n " . $showAdd . "\n <div class='panel-heading' role='tab' id='heading" . $row['id_student'] . "'>\n <div class='row-picture'>\n <img class='circle' src='img/fotos/student/" . $row['photo_s'] . "' alt='icon'>\n </div>\n <h4 class='panel-title'>\n <a data-toggle='collapse' data-parent='#accordion' href='#" . $row['id_student'] . "' aria-expanded='false' aria-controls='" . $row['id_student'] . "'>\n " . $row['name_s'] . " " . $row['surname1_s'] . "</a>\n </h4>\n </div>\n <div style='padding-left:55px;padding-top:20px;'> \n <div id='" . $row['id_student'] . "' class='panel-collapse collapse' role='tabpanel' aria-labelledby='heading" . $row['id_student'] . "' aria-expanded='false'> \n <div class='panel-body'>\n <label>Nombre: </label> " . " " . $row['name_s'] . " " . $row['surname1_s'] . " " . $row['surname2_s'] . " <br>\n <label>Edad: </label> " . " " . $edad . "<br>\n <label>Fecha Nac.: </label>" . " " . $nacimiento . "<br>\n <label>Sexo: </label>" . " " . $row['sexo'] . "<br>\n <label>Tel. Celular: </label>" . " " . $row['cellphone'] . "\n " . $info_sep . "\n </div>\n </div>\n </div>\n </div>\n </div>\n <div class='list-group-separator'></div></div>" . $div . "";
$id++;
}
#-- Fin del if edad.
}
#-- Fin de while.
}
function stSep($isSep)
{
include '../../../includes/db_connect.php';
//-- <-------------------------- ******************************* ------------------------------->
#-- Consulta para obtener la lista de alumnos.
$query = "SELECT * FROM student S, academic_info I, sep R \n WHERE S.id_student=I.id_student AND\n I.reg_sep=R.id_sep AND \n R.issep='" . $isSep . "';";
$result = mysqli_query($db_connect, $query);
$id = 1;
$info_sep = "";
$showAdd = "";
//-- <-------------------------- ******************************* ------------------------------->
#-- Obtener y mostrar los resultados de la consulta.
while ($row = mysqli_fetch_array($result)) {
if ($id % 2 == 0) {
$div = "<div class='clearfix'></div>";
} else {
$div = '';
}
if ($isSep == 'no') {
$showAdd = "\n <div class='row'><div class='col-md-10'></div>\n <div class='col-md-2'>\n <a href='#' onclick='setID(" . $row['id_student'] . ");' data-toggle='modal' data-target='.bs-example-modal-register' class='btn btn-fab btn-raised mdi-content-create sepIcons'></a>\n </div>\n </div>";
$info_sep = "no hay datos de Registro";
} else {
$showAdd = "\n <div class='row'><div class='col-md-10'></div>\n <div class='col-md-2'>\n <a href='#' onclick='showDataSep(" . $row['id_student'] . ");' data-toggle='modal' data-target='.bs-example-modal-editor' class='btn btn-fab btn-raised mdi-content-create sepIcons'></a>\n </div>\n </div>";
$info_sep = "<hr clss='hr'>\n <label>Número de Registro: </label>" . " " . $row['regis_num'] . "<br>\n <label>Fecha de Registro: </label>" . " " . $row['date_incorporate'] . "<br>\n <label>Calificación: </label>" . " " . $row['calification_sep'] . "<br>\n ";
}
//-- <-------------------------- ++++++++++ ------------------------------->
$nacimiento = mes($row['birthday']);
$edad = calcular($row['birthday']);
#-- Calcular la edad del alumno con su fecha de nacimiento.
#-- Filtrar unicamente a los alumnos que tengan 15 o mas años.
if ($edad >= 15) {
echo "<div class='col-sm-12 col-sm-12 col-md-6 col-lg-6'>";
echo "<div class='panel-group' id='accordion' role='tablist' aria-multiselectable='true'>\n <div class='panel panel-default'>\n " . $showAdd . "\n <div class='panel-heading' role='tab' id='heading" . $row['id_student'] . "'>\n <div class='row-picture'>\n <img class='circle' src='img/fotos/student/" . $row['photo_s'] . "' alt='icon'>\n </div>\n <h4 class='panel-title'>\n <a data-toggle='collapse' data-parent='#accordion' href='#" . $row['id_student'] . "' aria-expanded='false' aria-controls='" . $row['id_student'] . "'>\n " . $row['name_s'] . " " . $row['surname1_s'] . "</a>\n </h4>\n </div>\n <div style='padding-left:55px;padding-top:20px;'> \n <div id='" . $row['id_student'] . "' class='panel-collapse collapse' role='tabpanel' aria-labelledby='heading" . $row['id_student'] . "' aria-expanded='false'> \n <div class='panel-body'>\n <label>Nombre: </label> " . " " . $row['name_s'] . " " . $row['surname1_s'] . " " . $row['surname2_s'] . " <br>\n <label>Edad: </label> " . " " . $edad . "<br>\n <label>Fecha Nac.: </label>" . " " . $nacimiento . "<br>\n <label>Sexo: </label>" . " " . $row['sexo'] . "<br>\n <label>Tel. Celular: </label>" . " " . $row['cellphone'] . "\n " . $info_sep . "\n </div>\n </div>\n </div>\n </div>\n </div>\n <div class='list-group-separator'></div></div>" . $div . "";
$id++;
}
#-- Fin del if edad.
}
#-- Fin de while.
echo "<div class='row'>\n <div class='col-xs-0 col-sm-2 col-md-3'></div>\n <div class='col-xs-12 col-sm-8 col-md-6'>\n <a id='' href='?menu_ad=registrosep' class='btn btn-sm btn-primary btn-raised'>REGISTRO</a>\n </div>\n <div class='col-xs-0 col-sm-2 col-md-3'></div>\n </div>";
}
function stScholar($request, $togrant)
{
$fecha_beca = "";
include 'includes/db_connect.php';
$result = mysqli_query($db_connect, query($request, $togrant)) or die(mysqli_error());
$i = 1;
//-- <-------------------------- **************************** ------------------------------->
#-- Obtener y mostrar resultados de la consulta.
echo "<div class='panel-group' id='accordion' role='tablist' aria-multiselectable='true'>";
while ($row = mysqli_fetch_array($result)) {
#-- Botón flotante para reasignar becas en la pestaña becados. Boton flotante para asignacion de beca a solicitantes
if ($togrant == 'no') {
$sponsorInfo = "";
$btnA = "<a href='app/profiles/transactions/reassignScholar.php?idStudent=" . $row['id_student'] . "'\n class='btn btn-default btn-fab btn-raised mdi-action-star-rate' id='becadosIcons' \n data-toggle='tooltip' data-placement='left' title='Asignar Beca'></a>";
$fecha_beca = "No Aplica";
} else {
$btnA = "<a href='#' data-toggle='modal' data-target='.bs-example-modal-rs' \n class='btn btn-default btn-fab btn-raised' id='becadosIcons' onclick='changeScholar(" . $row['id_student'] . ");'>\n <i class='mdi-action-cached' data-toggle='tooltip' data-placement='top' title='Reasignar Beca'></i></a>";
$fecha_beca = mes($row['date_scholar']);
$consulta = "SELECT * FROM sponsor S WHERE S.id_scholar = '" . $row['id_grant'] . "';";
$do = mysqli_query($db_connect, $consulta);
$count = $do->num_rows;
while ($i = mysqli_fetch_array($do)) {
if ($count == 1) {
$sponsorInfo = "<label>Padrino(s):</label>" . " " . $i['name_sp'] . " " . $i['surname_sp'] . "<br>";
} elseif ($count > 1) {
$sponsorInfo = "<label>Padrino(s):</label>" . " " . $i['name_sp'] . " " . $i['surname_sp'] . " " . "\n <a href='#' id='" . $row['id_scholar'] . "' title='sp' data-toggle='modal' \n data-target='.bs-example-modal-sp' onclick='moreSponsor(this.id)' \n class='label label-info'>+" . ($count - 1) . " ver todos</a><br>";
}
}
}
$edad = calcular($row['birthday']);
$fecha_nac = mes($row['birthday']);
echo "<div class='col-sm-12 col-sm-12 col-md-6 col-lg-6'>";
echo "<br>\n <div class='panel'>\n " . $btnA . "\n <div class='panel-heading' role='tab' id='heading" . $row['id_student'] . "'>\n <div class='row-picture'>\n <img class='circle' src='img/fotos/student/" . $row['photo_s'] . "' alt='icon'>\n </div>\n <h4 class='panel-title'>\n <a data-toggle='collapse' data-parent='#accordion' href='#" . $row['id_student'] . "' \n aria-expanded='false' aria-controls='" . $row['id_student'] . "'>\n " . $row['name_s'] . " " . $row['surname1_s'] . " " . $row['surname2_s'] . "\n </a>\n </h4>\n </div>\n <div style='padding-left:45px;padding-top:20px;'> \n <div id='" . $row['id_student'] . "' class='panel-collapse collapse' role='tabpanel' aria-labelledby='heading" . $row['id_student'] . "'>\n <div class='panel-body'>\n\t\t\t\t\t\t\t\t\t <label>Alumno:</label>" . " " . $row['name_s'] . " " . $row['surname1_s'] . " " . $row['surname2_s'] . "<br>\n <label>Grupo: </label> " . " " . $row['course'] . "<br>\n <label>Edad: </label> " . " " . $edad . "<br>\n <label>Fecha de Nacimiento: </label>" . " " . $fecha_nac . "<br>\n <label>Sexo: </label>" . " " . $row['sexo'] . "<br>\n <label>Tel. Celular: </label>" . " " . $row['cellphone'] . "<br>\n " . $sponsorInfo . "\n <label>Fecha de inicio de beca: </label>" . " " . $fecha_beca . "<br>\n <label>Tutor: </label>" . " " . $row['name_t'] . " " . $row['surname1_t'] . "<br>\n </div>\n </div>\n </div>\n </div>\n <div class='list-group-separator'></div>";
echo "</div>";
$i++;
}
#-- Fin del while
echo "</div>";
}
<?php
include_once '../../includes/db_connect.php';
include_once 'calcularEdad.php';
$idCurso = $_GET['x'];
list($grupo, $clase, $alumno, $curso) = explode("-", $idCurso);
$query = "SELECT * FROM classes C, naatik_course N, schedule S \n WHERE N.id_course = '" . $curso . "' AND C.id_course='" . $curso . "' AND C.id_group = '" . $grupo . "' AND S.id_schedule = C.id_schedule;";
$echo = mysqli_query($db_connect, $query);
while ($row = mysqli_fetch_array($echo)) {
$fecha_inicio = mes($row['date_init']);
echo "\n <div class='form-group'>\n <label for='inputname' class='col-sm-3 control-label'>Fecha de inicio: </label>\n <div class='col-sm-9'>\n <input type='text' class='form-control' disabled id='fecha_init' name='fecha_init' value='" . $fecha_inicio . "'>\n </div>\n </div>\n <div class='form-group'>\n <label for='inputname' class='col-sm-3 control-label'>Dias: </label>\n <div class='col-sm-9'>\n <input type='text' class='form-control' disabled id='fecha_init' name='days' value='" . $row['days'] . "'>\n </div>\n </div>\n <div class='form-group'>\n <label for='inputname' class='col-sm-3 control-label'>Horario: </label>\n <div class='col-sm-9'>\n <input type='text' class='form-control' disabled id='fecha_init' name='hours' value='" . $row['hour_init'] . " " . $row['hour_end'] . "'>\n </div>\n </div>\n ";
}
function ver_reuniones($id_cons)
{
include "conexion.php";
?>
<!DOCTYPE html>
<html lang="es">
<?php
all_head();
?>
<body>
<div id="wrapper">
<!-- Navigation -->
<?php
navegacion($_SESSION['id_usua'], $_SESSION['tipo_usuario']);
$query = "call cabecera_cuestionario('" . $id_cons . "')";
$result = $conexion->query($query);
$cabecera = array();
while ($row = mysqli_fetch_row($result)) {
$cabecera = $row;
}
mysqli_free_result($result);
$conexion->next_result();
$query = "call ver_individual_reuniones('" . $id_cons . "')";
$result = $conexion->query($query);
$reunioni = array();
while ($row = mysqli_fetch_row($result)) {
$reunioni[] = $row;
}
mysqli_free_result($result);
$conexion->next_result();
$query = "call ver_grupal_reuniones('" . $id_cons . "')";
$result = $conexion->query($query);
$reuniong = array();
while ($row = mysqli_fetch_row($result)) {
$reuniong[] = $row;
}
mysqli_free_result($result);
$conexion->next_result();
?>
<div id="page-wrapper">
<div class="container-fluid">
<!-- Page Heading -->
<div class="container">
<br>
<form id='volver' action="consejeria.php" method="POST">
<input type="hidden" name='accion' value='ver_consejeria' >
<input type="hidden" name='id_cons' <?php
echo "value='" . $id_cons . "'";
?>
>
</form>
<div class="row">
<div class="col-lg-12">
<h1 class="page-header"><a href='#' onclick='volver.submit(); return false'><i class="fa fa-chevron-circle-left "></i></a> Registro de Reuniones <small>Sistema de tutoría</small>
</h1>
</div>
</div>
<div class="row">
<div class="modal-content">
<div class="close-modal" data-dismiss="modal">
<div class="lr">
<div class="rl">
</div>
</div>
</div>
<div class="row text-center">
<div class="col-lg-10 col-lg-offset-1">
<h3>Registro de la Consejería - Tutoría Académica</h3>
<hr class="small">
</div>
</div>
<div class="col-sm-6" >
<div class="form-group">
<label for="fecha">Facultad:</label>
Ingeniería
</div>
<div class="form-group">
<label for="fecha">Estudiante:</label>
<?php
echo $cabecera[2];
?>
</div>
<div class="form-group">
<label for="fecha">Docente:</label>
<?php
echo $cabecera[4];
?>
</div>
</div>
<div class="col-sm-6" >
<div class="form-group">
<label for="fecha">Escuela:</label>
Ingeniería en Informática y Sistemas
</div>
<div class="form-group">
<label for="fecha">Código:</label>
<?php
echo $cabecera[3];
?>
</div>
<div class="form-group">
<label for="fecha">Semestre:</label>
<?php
echo $cabecera[5];
?>
</div>
</div>
<div class="container">
<form <?php
echo "id='crear_reunion_individual'";
?>
action="reunion.php" method="POST">
<input type="hidden" name='accion' value='crear_reunion' >
<input type="hidden" name='id_cons' <?php
echo "value='" . $id_cons . "'";
?>
>
<input type="hidden" name='modalidad' value='I' >
</form>
<form <?php
echo "id='crear_reunion_grupal'";
?>
action="reunion.php" method="POST">
<input type="hidden" name='accion' value='crear_reunion' >
<input type="hidden" name='id_cons' <?php
echo "value='" . $id_cons . "'";
?>
>
<input type="hidden" name='modalidad' value='G' >
</form>
<div class="row" id="collapse_asistidos_2">
<div class='col-sm-12'>
<div class='panel panel-info'>
<div class="panel-heading">
<h1 class="panel-title"><a data-toggle="collapse" data-target='#collapse_reunion_individual' href='#collapse_asistidos_2'>Reuniones Individuales</a></h1>
</div>
<div id='collapse_reunion_individual' class="panel-collapse collapse in"> <!-- in -->
<div class="panel-body">
<?php
if ($_SESSION['tipo_usuario'] == 'docente') {
?>
<a href='#' onclick='crear_reunion_individual.submit(); return false'><i class="fa fa-plus"></i> Crear Reunión Individual</a>
<?php
}
?>
<br>
<?php
if (count($reunioni) > 0) {
?>
<br>
<table class="responsive table table-striped table-bordered table-hover table-condensed">
<tr class="info">
<th>Fecha y Hora</th>
<th>Motivo</th>
<th>Asunto</th>
<?php
if ($_SESSION['tipo_usuario'] == 'docente') {
?>
<th>Acciones</th>
<?php
}
?>
</tr>
<?php
for ($i = 0; $i < count($reunioni); $i++) {
?>
<?php
if ($_SESSION['tipo_usuario'] == 'docente') {
?>
<form <?php
echo "id='editar_reunioni_" . $reunioni[$i][0] . "'";
?>
action="reunion.php" method="POST">
<input type="hidden" name='accion' value='editar_reunion' >
<input type="hidden" name='id_reun' <?php
echo "value='" . $reunioni[$i][0] . "'";
?>
>
<input type="hidden" name='id_cons' <?php
echo "value='" . $id_cons . "'";
?>
>
</form>
<form <?php
echo "id='delete_reunioni_" . $reunioni[$i][0] . "'";
?>
action="reunion.php" method="POST">
<input type="hidden" name='accion' value='delete_reunion' >
<input type="hidden" name='id_reun' <?php
echo "value='" . $reunioni[$i][0] . "'";
?>
>
<input type="hidden" name='id_cons' <?php
echo "value='" . $id_cons . "'";
?>
>
</form>
<?php
}
?>
<tr class='success'>
<td><?php
echo $reunioni[$i][1];
?>
</td>
<td><?php
echo $reunioni[$i][2];
?>
</td>
<td><?php
echo $reunioni[$i][3];
?>
</td>
<?php
if ($_SESSION['tipo_usuario'] == 'docente') {
?>
<td>
<a href='#' <?php
echo "onclick='editar_reunioni_" . $reunioni[$i][0] . ".submit(); return false'";
?>
><i class="fa fa-pencil"></i> Editar</a>
<a href='#' <?php
echo "onclick='delete_reunioni_" . $reunioni[$i][0] . ".submit(); return false'";
?>
><i class="fa fa-eraser"></i> Eliminar</a>
</td>
<?php
}
?>
</tr>
<?php
}
?>
</table>
<?php
}
?>
</div>
</div>
</div>
</div>
</div>
<div class="row" id="collapse_asistidos_4">
<div class='col-sm-12'>
<div class='panel panel-info'>
<div class="panel-heading">
<h1 class="panel-title"><a data-toggle="collapse" data-target='#collapse_reunion_grupal' href='#collapse_asistidos_4'>Reuniones Grupales</a></h1>
</div>
<div id='collapse_reunion_grupal' class="panel-collapse collapse in"> <!-- in -->
<div class="panel-body">
<?php
if ($_SESSION['tipo_usuario'] == 'docente') {
?>
<a href='#' onclick='crear_reunion_grupal.submit(); return false'><i class="fa fa-plus"></i> Crear Reunión Grupal</a>
<?php
}
?>
<br>
<?php
if (count($reuniong) > 0) {
?>
<br>
<table class="responsive table table-striped table-bordered table-hover table-condensed">
<tr class="info">
<th>Fecha y Hora</th>
<th>Motivo</th>
<th>Asunto</th>
<?php
if ($_SESSION['tipo_usuario'] == 'docente') {
?>
<th>Acciones</th>
<?php
}
?>
</tr>
<?php
for ($i = 0; $i < count($reuniong); $i++) {
?>
<?php
if ($_SESSION['tipo_usuario'] == 'docente') {
?>
<form <?php
echo "id='editar_reuniong_" . $reuniong[$i][0] . "'";
?>
action="reunion.php" method="POST">
<input type="hidden" name='accion' value='editar_reunion' >
<input type="hidden" name='id_reun' <?php
echo "value='" . $reuniong[$i][0] . "'";
?>
>
<input type="hidden" name='id_cons' <?php
echo "value='" . $id_cons . "'";
?>
>
</form>
<form <?php
echo "id='delete_reuniong_" . $reuniong[$i][0] . "'";
?>
action="reunion.php" method="POST">
<input type="hidden" name='accion' value='delete_reunion' >
<input type="hidden" name='id_reun' <?php
echo "value='" . $reuniong[$i][0] . "'";
?>
>
<input type="hidden" name='id_cons' <?php
echo "value='" . $id_cons . "'";
?>
>
</form>
<?php
}
?>
<tr class='warning'>
<td><?php
echo $reuniong[$i][1];
?>
</td>
<td><?php
echo $reuniong[$i][2];
?>
</td>
<td><?php
echo $reuniong[$i][3];
?>
</td>
<?php
if ($_SESSION['tipo_usuario'] == 'docente') {
?>
<td>
<a href='#' <?php
echo "onclick='editar_reuniong_" . $reuniong[$i][0] . ".submit(); return false'";
?>
><i class="fa fa-pencil"></i> Editar</a>
<a href='#' <?php
echo "onclick='delete_reuniong_" . $reuniong[$i][0] . ".submit(); return false'";
?>
><i class="fa fa-eraser"></i> Eliminar</a>
</td>
<?php
}
?>
</tr>
<?php
}
?>
</table>
<?php
}
?>
</div>
</div>
</div>
</div>
</div>
<div class="text-right">
<p>Tacna, <?php
echo date('d');
?>
de <?php
mes(date('F'));
?>
de <?php
echo date('Y');
?>
</p>
</div>
<br>
<!-- </form> -->
<div class="row text-center">
<div class="col-lg-4">
</div>
<div class="col-lg-4">
<div class="service-box text-center">
<input name="Imprimir" class="btn btn-primary btn-block btn-md text-center" id="imprimir" onclick="DescargarPDF('page-wrapper','registro')" value="Descargar PDF">
</div>
</div>
<div class="col-lg-4">
</div>
</div>
<br><br>
</div>
</div>
</div>
</div>
</div>
<!-- /.container-fluid -->
</div>
<!-- /#page-wrapper -->
</div>
<!-- /#wrapper -->
<!-- jQuery -->
<script src="js/jquery.js"></script>
<script src="js/jspdf.debug.js"></script>
<script>
function DescargarPDF(ContenidoID,nombre){
var pdf = new jsPDF('p','pt','letter');
html = $('#'+ContenidoID).html();
specialElementHandlers = {};
margins = {top: 10, bottom: 20, left: 20, width:522};
pdf.fromHTML(html, margins.left, margins.top, {'width': margins.width},function(dispose) {pdf.save(nombre+'.pdf')},margins);
}
</script>
<!-- Bootstrap Core JavaScript -->
<script src="js/bootstrap.min.js"></script>
<!-- Morris Charts JavaScript -->
<script src="js/plugins/morris/raphael.min.js"></script>
<script src="js/plugins/morris/morris.min.js"></script>
<script src="js/plugins/morris/morris-data.js"></script>
</body>
</html>
<?php
}
/**
* @author Dmytro Navrotskyy <*****@*****.**>
*
* Diese Funktion wird zusammen mit array_walk verwendet um alle Werte in einem
* array zu escapen.
*/
function mes_walk(&$value, $key)
{
if (is_string($value)) {
$value = mes($value);
}
}
function ver_cuestionario($accion, $id_cons, $id_cues)
{
include "conexion.php";
?>
<!DOCTYPE html>
<html lang="es">
<?php
all_head();
?>
<body>
<div id="wrapper">
<!-- Navigation -->
<?php
navegacion($_SESSION['id_usua'], $_SESSION['tipo_usuario']);
$query = "call ver_cuestionario('" . $id_cues . "')";
$result = $conexion->query($query);
$cuestionario = array();
while ($row = mysqli_fetch_row($result)) {
$cuestionario = $row;
}
mysqli_free_result($result);
$conexion->next_result();
$query = "call cabecera_cuestionario('" . $id_cons . "')";
$result = $conexion->query($query);
$cabecera = array();
while ($row = mysqli_fetch_row($result)) {
$cabecera = $row;
}
mysqli_free_result($result);
$conexion->next_result();
?>
<div id="page-wrapper">
<div class="container-fluid">
<!-- Page Heading -->
<div class="container">
<div class="row">
<div class="col-lg-12">
<form id='volver' action="consejeria.php" method="POST">
<input type="hidden" name='accion' value='ver_consejeria' >
<input type="hidden" name='id_cons' <?php
echo "value='" . $id_cons . "'";
?>
>
</form>
<h1 class="page-header"><a href='#' onclick='volver.submit(); return false'><i class="fa fa-chevron-circle-left "></i></a> Formatos <small>Sistema de tutoría</small></h1>
</div>
</div>
<br>
<div class="row">
<div class=" modal-content">
<div class="close-modal" data-dismiss="modal">
<div class="lr">
<div class="rl">
</div>
</div>
</div>
<div class="row text-center">
<div class="col-lg-10 col-lg-offset-1">
<h3><?php
echo $cuestionario[0];
?>
</h3>
<hr class="small">
</div>
</div>
<div class="col-sm-6" >
<div class="form-group">
<label for="fecha">Facultad:</label>
<!--<div class="input-group">
<span class="input-group-addon"><span class=""></span></span>
<input class="form-control" type="text" value='Ingeniería' readonly>
</div>-->
Ingeniería
</div>
<div class="form-group">
<label for="fecha">Estudiante:</label>
<?php
echo $cabecera[2];
?>
</div>
<div class="form-group">
<label for="fecha">Docente:</label>
<?php
echo $cabecera[4];
?>
</div>
</div>
<div class="col-sm-6" >
<div class="form-group">
<label for="fecha">Escuela:</label>
Ingeniería en Informática y Sistemas
</div>
<div class="form-group">
<label for="fecha">Código:</label>
<?php
echo $cabecera[3];
?>
</div>
<div class="form-group">
<label for="fecha">Semestre:</label>
<?php
echo $cabecera[5];
?>
</div>
</div>
<?php
echo $cuestionario[1];
?>
<div class="container">
<!--formulario simple-->
<form action='consejeria.php' method='post' id='editar'>
<?php
$query = "call ver_secciones('" . $id_cues . "')";
$result = $conexion->query($query);
$secciones = array();
while ($row = mysqli_fetch_row($result)) {
$secciones[] = $row;
}
mysqli_free_result($result);
$conexion->next_result();
for ($i = 0; $i < count($secciones); $i++) {
?>
<!--textos largos-->
<div class="row">
<div class="col-sm-12">
<div class="panel panel-info">
<div class="panel-heading">
<h3 class="panel-title"><?php
echo $secciones[$i][1];
?>
</h3>
</div>
<div class="panel-body">
<?php
$query = "call ver_items('" . $id_cons . "','" . $secciones[$i][0] . "')";
$result = $conexion->query($query);
$items = array();
while ($row = mysqli_fetch_row($result)) {
$items[] = $row;
}
mysqli_free_result($result);
$conexion->next_result();
?>
<div class="col-sm-6" >
<?php
for ($j = 0; $j < count($items); $j = $j + 2) {
?>
<div class="form-group">
<label for="fecha"> <?php
echo $items[$j][1];
?>
:</label>
<?php
switch ($accion) {
case 'ver_cuestionario':
echo $items[$j][3];
break;
case 'editar_cuestionario':
item($items[$j][0], $items[$j][2], $items[$j][3]);
break;
default:
# code...
break;
}
?>
</div>
<?php
}
?>
</div>
<div class="col-sm-6" >
<?php
for ($j = 1; $j < count($items); $j = $j + 2) {
?>
<div class="form-group">
<label for="fecha"> <?php
echo $items[$j][1];
?>
:</label>
<?php
switch ($accion) {
case 'ver_cuestionario':
echo $items[$j][3];
?>
<!--<div class="input-group">
<span class="input-group-addon"><span class=""></span></span>
<input class="form-control" type="text" value='' readonly>
</div>-->
<?php
break;
case 'editar_cuestionario':
item($items[$j][0], $items[$j][2], $items[$j][3]);
break;
default:
# code...
break;
}
?>
</div>
<?php
}
?>
</div>
</div>
</div>
</div>
</div>
<?php
}
$conexion->close();
?>
<div class="text-right">
<p>Tacna, <?php
echo date('d');
?>
de <?php
mes(date('F'));
?>
de <?php
echo date('Y');
?>
</p>
</div>
<div class="row text-center">
<?php
switch ($accion) {
case 'editar_cuestionario':
?>
<input type="hidden" name='id_cons' value=<?php
echo $id_cons;
?>
>
<input type="hidden" name='accion' value='update_cuestionario' >
<div class="col-lg-4">
</div>
<div class="col-lg-4">
<div class="service-box text-center">
<input type="submit" class="btn btn-primary btn-block btn-md text-center" role="button">
</div>
</div>
<div class="col-lg-4">
</div>
<?php
break;
case 'ver_cuestionario':
?>
<div class="col-lg-4">
</div>
<div class="col-lg-4">
<div class="service-box text-center">
<input name="Imprimir" class="btn btn-primary btn-block btn-md text-center" id="imprimir" onclick="DescargarPDF('page-wrapper','cuestionario')" value="DescargarPDF">
</div>
</div>
<div class="col-lg-4">
</div>
<?php
break;
default:
# code...
break;
}
?>
</div>
<br>
</form>
</div>
</div>
</div>
</div>
</div>
<!-- /.container-fluid -->
</div>
<!-- /#page-wrapper -->
</div>
<!-- /#wrapper -->
<!-- <script src="js/jquery-2.1.4.min.js" ></script> -->
<script src="js/jspdf.debug.js"></script>
<script>
function DescargarPDF(ContenidoID,nombre){
var pdf = new jsPDF('p','pt','letter');
html = $('#'+ContenidoID).html();
specialElementHandlers = {};
margins = {top: 10, bottom: 20, left: 20, width:522};
pdf.fromHTML(html, margins.left, margins.top, {'width': margins.width},function(dispose) {pdf.save(nombre+'.pdf')},margins);
}
</script>
<!-- jQuery -->
<script src="js/jquery.js"></script>
<!-- Bootstrap Core JavaScript -->
<script src="js/bootstrap.min.js"></script>
<!-- Morris Charts JavaScript -->
<script src="js/plugins/morris/raphael.min.js"></script>
<script src="js/plugins/morris/morris.min.js"></script>
<script src="js/plugins/morris/morris-data.js"></script>
</body>
</html>
<?php
}
*
* @return void
*/
public function move_selected_scripts()
{
// if( $scripts = get_option( 'mes_front_end_scripts_excluded' ) ) {
// foreach( $scripts as $key => $val ) {
// if($key == 'jquery') {
// wp_deregister_script( $key );
// wp_register_script( 'jquery', home_url().'/wp-includes/js/jquery/jquery.js', '', '', true );
// } else {
// wp_deregister_script( $key );
// wp_register_script( $key, $val, '', '', true );
// }
// }
// }
}
}
function mes()
{
global $mes;
if (!isset($mes)) {
$mes = new MoveEnqueuedScripts();
}
return $mes;
}
// Initialize
// if( is_admin() ) {
mes();
// }
}
}
return $lista_dados;
/*
<div class="leftx" style="width:8%">1</div>
<div class="leftx" style="width:58%">2fgfgn</div>
<div class="leftx" style="width:14%">3</div>
<div class="leftx" style="width:20%">4</div>
*/
}
$tipoval = "";
if ($obj['tipo_salario'] == 1) {
$tipoval = " MENSAL";
} else {
$tipoval = " HORA/AULA";
}
$valhtml = " <!doctype html>\n<html>\n<head>\n<meta content='text/html'; charset=UTF-8'>\n<title></title>\n\n<style type='text/css'>\nbody{\n\tfont-family: 'DejaVu Sans', Arial, Helvetica, sans-serif;\n\tmargin-top:0px;\t\n\tfont-size: 9px;\n\t}\n\t.fonte{\n\tfont-family: 'DejaVu Sans', Arial, Helvetica, sans-serif;\n\tfont-size: 10px;\n\tfont-weight: bold;\n\tfloat:right;\t\n\t}\n a {text-decoration: none}\n\t.leftx{\n\tfloat:left;\n\tmargin-top:0px;\n\t\n\tcolor: #000000;\n\t\n\tmargin-top:1px;\n\tmargin-bottom:2px;\t\n\t\t}\n\t.titulo{\n\t\n\tcolor: #000000;\n\tline-height: 1.2207031;\n\tfont-weight: bold;\n\tmargin-left:3px;\n\tfont-size:10px;\n\t\n\t}\n\t.tabletopo{\n\t\n\theight:20px;\n\t\n\t}\n\t.textual{\n\t\n\tcolor: #000000;\n\tfont-weight: bold;\n\t\n\t}\n\t.textotal{\n\t\n\tcolor: #000000;\n\tfont-weight: bold;\n\t\n\t\n\t}\n\t.vintq{\n\twidth:32%;\n\tfloat:left;\n\tdisplay: block;\n\tfont-weight: bold;\n\tmargin-left:10px;\t\n\t\t}\n\t.trinq{\n\twidth:16%;\n\tfloat:left;\n\tdisplay: block;\n\tfont-weight: bold;\t\n\tmargin-top:10px;\n\tmargin-left:5px;\n\t\t}\t\n\t\t\n\t.vint15{\n\twidth:15%;\n\tfloat:left;\n\tdisplay: block;\n\tfont-weight: bold;\t\n\t\t}\t\n\t\t\n\t.cinq{\n\twidth:48%;\n\tfloat:left;\t\n\t\n\tfont-weight: bold;\n\tmargin-top:10px;\n\tmargin-left:5px;\n\t\t}\n\t\t.cinx{\n\twidth:49%;\n\tfloat:left;\t\n\t\n\tfont-weight: bold;\n\t\n\t\t}\n\t\t\n\t.quar{\n\twidth:40%;\n\tfloat:left;\t\n\tfont-weight: bold;\n\t/*margin-top:12px;*/\n\theight:20px;\n\tmargin-left:10%;\n\t\t}\n\t.dez{\n\twidth:10%;\n\tfloat:left;\t\n\t\n\tfont-weight: bold;\n\t/*margin-top:12px;*/\n\theight:20px;\n\t}\n\t.container{\n\talignment-adjust:auto;\n\twidth:90%;\n\tmargin-left:10%;\n\t\t\n\t\t}\n\t\tdiv{ \nborder:1px #333 solid; \n} \t\n\t.table2{\n\t\theight:10px;\n\t\t}\n.divbord{\n\tborder-radius: 2mm;\n\tborder:1px solid black;\n}\n.tablex{\n\tborder-radius: 2mm;\n\tborder:1px solid black;\n}\t\n\t\t\n </style>\n</head>\n\n<body>\n\n<table width='100%' class='tablex'>\n <tr>\n <td width='21%' align='center'>\n\t<img width='75px' height='75px' src='" . substr($logo_cheque, 3, 55) . "'>\n\t\n\t</td>\n <td width='79%'>\n <p align='right' style='font-size:7px; margin-right:10px' >DEMONSTRATIVO DE PAGAMENTO DE SALÁRIO (CONTRA-CHEQUE)</p>\n <p class='titulo'>" . $obj['razao_ug'] . "</p>\n <p class='titulo'>" . $obj['ender_ug'] . "Nº " . $obj['num_ug'] . ", " . $obj['bairro_ug'] . "</p>\n <!--p class='titulo'>" . $obj['ender_cidade'] . " - CEP:" . $obj['ender_cep'] . " - " . $obj['ender_uf'] . "</p--><br>\n\n<p class='titulo' align='left' style='float:left; width:75%'>\n CNPJ:" . mask($obj['cnpj_ug'], '##.###.###/####-##') . "\n \n\t \n\t \n\t\n\t" . mes(substr($ano_mes, 4, 2)) . "/" . substr($ano_mes, 0, 4) . "</p>\n\t\n\n\t\n </td>\n </tr>\n</table>\n\n<p> </p>\n\n<div class='divbord'> \n<br>\n<table width='100%' >\n <tr>\n <td width='16%'>Mátricula<br>\n " . $obj['id_servidor'] . "\n </td>\n <td width='33%'>Nome do Servidor<br>\n " . $obj['nome'] . "\n </td>\n <td width='20%'>Admissão<br>\n " . dateFormat($obj['dt_admissao']) . "\n </td>\n <td width='31%'>Cargo/Função<br>\n " . $obj['descr_cargo'] . "\n </td>\n </tr>\n</table>\n<table width='100%' border='0'>\n <tr>\n <td width='49%'>Sub-Unida. Orçamentária (Centro de Custos) <br>\n " . $obj['id_sub_und_orcam'] . ' - ' . $obj['descr_sub_unid_orcan'] . "\n </td>\n <td width='51%'>Unida. de Lotacao (Local de Trabalho )<br>\n " . $obj['descr_unid_lotac'] . "\n </td>\n </tr>\n</table>\n\n<table width='100%' border='0'>\n <tr>\n <td width='49%'>\n " . $obj['descr_situac_tcm'] . "\n <br>\n " . $obj['descr_est_funcional'] . "\n </td>\n <td width='16%'>C.P.F.<br>\n " . mask($obj['cpf'], '###.###.###-##') . "\n </td>\n <td width='17%'>identidade<br>\n " . $obj['rg'] . "\n </td>\n <td width='18%'>PIS/PASEP<br>\n " . mask($obj['pis_pasep'], '###.#####.##-#') . "\n </td>\n </tr>\n</table>\n<p> </p>\n</div> <!--fim da divborder-->\n\n\n<p> </p>\n\n<div>\n\n<table width='100%' border='0' align='center' style='border-collapse: collapse;' >\n <tr align='center'>\n <td>VENCIMENTOS / PROVENTOS</td>\n <td>DESCONTOS</td>\n </tr>\n</table>\n<hr>\n<table width='100%' style='font-size:8px;' border='0' style='border-collapse:collapse; border:1px solid #000000;'>\n <tr>\n <td width='4%'>Cód</td>\n <td width='28%'> </td>\n <td width='7%'>Quant.</td>\n <td width='10%'>Valor(R\$)</td>\n <td width='3%' bordercolor='#FFFFFF'> </td>\n <td width='4%'>Cód</td>\n <td width='27%'> </td>\n <td width='7%'>Quant.</td>\n <td width='10%'>Valor(R\$)</td>\n </tr>\n</table>\n\n</table>\n<table width='100%' border='1' style='border-collapse: collapse;'>\n <tr>\n <td width='49%'>\n\t<table width='100%' border='0'>\n " . vencimento('V', $cli_id, $ano_mes, $parcela, $id_servidor) . "\n\t <p> </p>\n\t <p> </p>\n\t \n </table>\n\t</td>\n <td width='3%'><!--div style='height:80px; width:1px; margin-top:-20px; margin-left:4px'></div--></td>\n <td width='48%'>\n\t<table width='100%' border='0' >\n " . vencimento('D', $cli_id, $ano_mes, $parcela, $id_servidor) . "\n\t <p> </p>\n\t <p> </p>\n\t \n\t \n </table></td>\n </tr>\n</table>\n\n<hr>\n\n<table width='100%'>\n <tr>\n <td width='38%' align='right'><span class='textotal'>T O T A L > > ></span></td>\n <td width='11%' bgcolor='#CCCCCC' bordercolor='#000000' align='right'><span class='textotal'>" . valorM($obj['tot_venctos']) . "\n </span></td>\n\t\n <td width='3%'> <div style='height:18px; width:1px; margin-top:-5px; margin-left:8px'></div> </td>\n\t\n <td width='35%' align='right'><span class='textotal'>T O T A L > > ></span></td>\n <td width='13%' bgcolor='#CCCCCC' bordercolor='#000000' align='right'><span class='textotal'>\n " . valorM($obj['tot_descontos']) . "\n </span></td>\n </tr>\n\n</table>\n\n<hr>\n\n<table width='100%'> \n <tr>\n <td align='right' width='35%'><span class='textotal'>S A L Á R I O L I Q U I D O > > ></span></td>\n <td bgcolor='#CCCCCC' bordercolor='#000000' align='right' width='14%'><span class='textotal'>" . valorM($obj['sal_liquido']) . "</span></td>\n\t\n <td width='2%'><div style='height:18px; width:1px; margin-top:-5px; margin-left:8px'></div></td>\n\t\n <td width='30%'> </td>\n <td width='19%'> </td>\n </tr>\n</table>\n\n</div>\n\n\n<br>\n<br>\n\n<table width='100%' class='tablex'>\n <tr>\n <td><table width='100%' border='0'>\n <tr>\n <td width='25%'>Vencto Base<br>\n " . valorM(substr($obj['vencto_base_cargo'], 0, -2)) . $tipoval . " </td>\n <td width='25%'>Base Calc. Previd. <br>\n " . valorM($obj['bc_previd']) . "</td>\n <td width='18%'>Base Calc. IRRF <br>\n " . valorM($obj['bc_irrf']) . "</td>\n <td width='16%'>Depend.<br>\n " . valorM($obj['qtd_depend_irrf']) . "</td>\n <td width='16%'>Deduções<br>\n " . valorM($obj['tot_deduc_depend']) . "</td>\n </tr>\n </table></td>\n </tr>\n</table>\n\n<br><br>\n\n<table width='100%' align='center' class='tablex'>\n <tr>\n <td>\n \n <p> </p>\n <p align='center'>" . $obj['pagto_quitacao'] . "</p>\n <p> </p>\n \n </td>\n </tr>\n</table>\n\n\n\n\n\n</body>\n</html> ";
//Aqui nós chamamos a class do dompdf
require_once 'dompdf/dompdf_config.inc.php';
//É fundamental definir o TIMEZONE de nossa região para que não tenhamos problemas com a geração.
date_default_timezone_set('America/Sao_Paulo');
//Aqui eu estou decodificando o tipo de charset do documento, para evitar erros nos acentos das letras e etc.
$valhtml = utf8_decode($valhtml);
//Instanciamos a class do dompdf para o processo
$dompdf = new DOMPDF();
//Aqui nós damos um LOAD (carregamos) todos os nossos dados e formatações para geração do PDF
$dompdf->load_html($valhtml);
//string $orientation: 'portrait' or 'landscape'
//$dompdf->set_paper('legal','portrait');
$dompdf->set_paper('legal', 'A4');
//$dompdf->set_paper(array(0,0,750,1030));
//Aqui nós damos início ao processo de exportação (renderizar)
function FormatFechaText_2($fecha)
{
if (preg_match("/([0-9]{4})-([0-9]{1,2})-([0-9]{1,2})/", $fecha, $partes)) {
$mes = 'de ' . mes($partes[2]) . ' del ';
return $partes[3] . " " . $mes . $partes[1];
} else {
// Si hubo problemas en la validación, devolvemos false
return false;
}
}
// [sal_liquido] => 777.36
// [68] => 63.04
// [tot_descontos] => 63.04
// [69] => 840.40
// [tot_venctos] => 840.40
// [70] => 788.00
// [bc_sal_fam] => 788.00
// [71] => 724.96
// [bc_irrf] => 724.96
// [72] => 788.00
// [bc_previd] => 788.00
// [73] => PAGAMENTO/QUITAÇÃO NÃO INFORMADO
// [pagto_quitacao] => PAGAMENTO/QUITAÇÃO NÃO INFORMADO
$obj['cnpj_ug'] = mask($obj['cnpj_ug'], '##.###.###/####-##');
$strAnoMes = $obj['ano_mes'];
$obj['ano_mes'] = mes(substr($ano_mes, 4, 2)) . "/" . substr($ano_mes, 0, 4);
$obj['dt_admissao'] = dateFormat($obj['dt_admissao']);
$obj['cpf'] = mask($obj['cpf'], '###.###.###-##');
$obj['pis_pasep'] = mask($obj['pis_pasep'], '###.#####.##-#');
$obj['tot_venctos'] = valorM($obj['tot_venctos']);
$obj['sal_liquido'] = valorM($obj['sal_liquido']);
$obj['tot_descontos'] = valorM($obj['tot_descontos']);
$obj['vencto_base_cargo'] = valorM(substr($obj['vencto_base_cargo'], 0, -2));
$obj['tipo_salario'] = $obj['tipo_salario'] == 1 ? " MENSAL" : " HORA/AULA";
$obj['bc_previd'] = valorM($obj['bc_previd']);
$obj['bc_irrf'] = valorM($obj['bc_irrf']);
$obj['qtd_depend_irrf'] = valorM($obj['qtd_depend_irrf']);
$obj['tot_deduc_depend'] = valorM($obj['tot_deduc_depend']);
$obj['sal_liquido'] = valorM($obj['sal_liquido']);
$obj['vencimentoV'] = vencimento("V", $cli_id, $strAnoMes, 0, $id_servidor);
$obj['vencimentoD'] = vencimento("D", $cli_id, $strAnoMes, 0, $id_servidor);
<?php
include_once '../../../includes/db_connect.php';
include '../../php/calcularEdad.php';
$idAlumno = $_GET['s'];
$idClass = $_GET['c'];
$query = "SELECT * \n\t\t\t\tFROM student S, academic_info A, sep R, classes C, \n\t\t\t\t\t\tnaatik_course N, groups_nc G, schedule H, scholar B\n\t\t\t\t\tWHERE S.id_student ='{$idAlumno}' AND\n\t\t\t\t\t\tS.id_student = A.id_student AND\n\t\t\t\t\t\tA.reg_sep = R.id_sep AND\n\t\t\t\t\t\tA.id_classes = '{$idClass}' AND\n\t\t\t\t\t\tA.id_classes = C.id_class AND\n\t\t\t\t\t\tC.id_course = N.id_course AND\n\t\t\t\t\t\tC.id_group = G.id_group AND\n\t\t\t\t\t\tC.id_schedule = H.id_schedule AND\n\t\t\t\t\t\tS.id_student = B.id_student\n\t\t\t\t\t\tLIMIT 1;";
$res = mysqli_query($db_connect, $query) or die(mysqli_error());
if ($res) {
while ($row = mysqli_fetch_array($res)) {
$fecha_nac = mes($row['birthday']);
$dateInit_cuorse = mes($row['date_init']);
$dateInit_std = mes($row['date_init_s']);
$fecha_nac = mes($row['birthday']);
$photo = $row['photo_s'];
if ($row['togrant'] == 'si') {
$colorIcon = "btn btn-sm btn-info mdi-action-grade";
$toolInfo = "Becado";
$request = "Becado";
} elseif ($row['request'] == 'si' and $row['togrant'] == 'no') {
$colorIcon = "btn btn-sm btn-success mdi-action-grade";
$toolInfo = "Solicitante";
$request = "Quitar solicitud de beca";
} else {
$colorIcon = "btn btn-sm btn-default mdi-action-grade";
$toolInfo = "No becado";
$request = "Solicitar beca";
}
?>
<a id="edit" href='?menu_ad=viewUpdateSt&idStudent=<?php
echo $row['id_student'];
function dumpRecords($opts = false)
{
if (is_array($opts)) {
extract($opts);
}
if ($header) {
?>
<textarea cols="160" rows="200"><?php
}
// dump the master record.
foreach ($this->tbl as $f) {
$sets[] = " {$f['field']} = '" . mes($this->{$f}[field]) . "'";
}
$out = " INSERT INTO {$this->_table} SET " . implode(",", $sets);
echo $out;
// dump dependent records
echo "\r\r\r\r";
$this->getRelated();
$tables_used = array($this->_table);
foreach ($this->_related as $rel) {
// get relations
if ($rel['table'] != $this->_table) {
$sql = "SELECT * FROM " . $rel['table'] . " WHERE {$this->indexField} = {$this->id} ";
$result = acquery($sql, $rel['db']);
while ($row = mysql_fetch_array($result)) {
extract($row);
$link = new DBOS($rel['table'], $row[0], $rel['db']);
$link->dumpRecords();
$tables_used[] = $rel['table'];
}
}
}
if ($header) {
?>
</textarea><?php
}
}
<body>
<div id="wrapper">
<div id="header">
<div class="logo">Chile Atiende</div>
<div class="logo-ChA">Chile Atiende</div>
<div class="tools">
<ul class="menu">
<li class="usuario"><a href="<?php
echo site_url('backend/cuenta/index');
?>
"><?php
echo UsuarioBackendSesion::usuario()->nombres . ' ' . UsuarioBackendSesion::usuario()->apellidos;
?>
</a></li>
<li><?php
echo dia(strftime("%u")) . strftime(", %d de ") . mes(intval(strftime("%m"))) . strftime(" de %Y");
?>
</li>
<li class="home"><a href="<?php
echo site_url('/');
?>
" target="_blank">Ver Portada</a></li>
<li class="salir"><a href="<?php
echo site_url('backend/autenticacion/logout');
?>
">Salir</a></li>
</ul>
</div>
</div>
<div id="main">
function fechalarga()
{
if (!isset($_GET['arg1'])) {
$idioma = "es";
} else {
$idioma = $_GET['arg1'];
}
if ($idioma == "es") {
return dia() . ", " . date("j") . " de " . mes() . " de " . date("Y");
}
if ($idioma == "eus") {
return dia() . ", " . date("Y") . ".-eko " . mes() . "k " . date("j");
}
}
function echo_r($var)
{
if (func_num_args() > 1) {
$var = func_get_args();
$var = implode(' ', $var);
}
if (is_string($var)) {
echo nl2br("\n\"" . mes($var) . "\"\n");
} else {
echo nl2br("\n" . rprint_r($var) . "\n");
}
return $var;
}
function qsafe($qs)
{
$s = '';
$nexttype = 0;
$frag = false;
if (!is_array($qs)) {
$qs = func_get_args();
}
if (is_array($qs)) {
foreach ($qs as $k => $v) {
$frag = !$frag;
if ($frag) {
$nexttype = 0;
$nt = mb_substr($v, mb_strlen($v) - 1, 1);
$bad = false;
for ($x = 0; $x < mb_strlen($v); $x++) {
$ch = mb_substr($v, $x, 1);
if ($ch == '"' || $ch == "'" || $ch >= '0' && $ch <= '9') {
$bad = true;
}
}
if ($bad) {
echo 'Malformed query..';
die;
}
if ($nt == '$') {
$nexttype = 1;
} elseif ($nt == '#') {
$nexttype = 2;
} else {
$nt = '';
}
$s .= mb_substr($v, 0, mb_strlen($v) - strlen($nt));
} else {
if ($nexttype == 1) {
$s .= '"' . mes($v) . '"';
} elseif ($nexttype == 2) {
$s .= 0 + @$v;
} else {
echo 'Malformed query.';
die;
}
}
}
}
return $s;
}
############################################################################################### /*
$db2 = conect2();
$sql_db2 = "insert into tb_registro (refeicao, ml, data, horas)values (:r, :m, :d, :h)";
$stmt = $db2->prepare($sql_db2);
$stmt->bindValue(":r", "MAMADEIRA");
$stmt->bindValue(":m", 100);
$stmt->bindValue(":d", "2014-11-14");
$stmt->bindValue(":h", "18:22");
$stmt->execute();
*/
$pdo2 = conecta2();
//$listar = $pdo->query("SELECT SUM(ml)AS ml_total FROM tb_registro WHERE data= '$data_atual' ");
// $listar = $pdo->query("SELECT * FROM tb_registro WHERE data= '$data_atual' ");
$listar = $pdo2->query("SELECT SUM(ml) total FROM tb_registro where data ='11'");
$listar->fetchAll(PDO::FETCH_OBJ);
function mes($listar)
{
}
if (mes()) {
$dados_mes = mes();
foreach ($dados_mes as $dms) {
echo $dms->total;
}
} else {
}
?>
function FechaTextoE($fecha, $titulo)
{
$segmentosFechaHora = explode(" ", $fecha);
$segmenFecha = explode("-", $segmentosFechaHora[0]);
$year = $segmenFecha[0];
$mes = $segmenFecha[1];
$mes = mes($mes);
$day = $segmenFecha[2];
$dia = date("w", strtotime($fecha));
switch ($dia) {
case 0:
$DiaText = "Domingo";
break;
case 1:
$DiaText = "Lunes";
break;
case 2:
$DiaText = "Martes";
break;
case 3:
$DiaText = "Miercoles";
break;
case 4:
$DiaText = "Jueves";
break;
case 5:
$DiaText = "Viernes";
break;
case 6:
$DiaText = "Sábado";
}
$date = new DateTime($fecha);
$hora = $date->format('g:i a');
$diaHoy = date('y-m-d');
$segmentosDiaHoy = explode("-", $diaHoy);
$segmMesHoy = $segmentosDiaHoy[1];
$segmDiaHoy = $segmentosDiaHoy[2];
$sieteDiasAtras = $segmentosDiaHoy[2] - 7;
$tresDiasAtras = $segmentosDiaHoy[2] - 3;
$fechaB = new DateTime($diaHoy);
$fechaB->sub(new DateInterval('P7D'));
$fechMenosSieteDias = $fechaB->format('Y-m-d');
if ($titulo == '') {
if ($fecha > $fechMenosSieteDias) {
if ($segmDiaHoy == $day) {
$valor = "Hoy a la(s) " . $hora;
} elseif ($segmDiaHoy - 1 == $day) {
$valor = "Ayer a la(s)" . $hora;
} elseif ($day >= $sieteDiasAtras && $day <= $tresDiasAtras) {
$valor = $DiaText . " a la(s)" . $hora;
} else {
$valor = $day . " de " . $mes . " del " . $year . " a la(s) " . $hora;
}
} else {
$valor = $day . " de " . $mes . " del " . $year . " a la(s) " . $hora;
}
} else {
$valor = $DiaText . " " . $day . " de " . $mes . " del " . $year . " a la(s) " . $hora;
}
return $valor;
}
public function chamado_mail2()
{
function mes($mes)
{
switch ($mes) {
case 'Jan':
$mes = '01';
break;
case 'Fev':
$mes = '02';
break;
case 'Mar':
$mes = '03';
break;
case 'Apr':
$mes = '04';
break;
case 'May':
$mes = '05';
break;
case 'Jun':
$mes = '06';
break;
case 'Jul':
$mes = '07';
break;
case 'Aug':
$mes = '08';
break;
case 'Sep':
$mes = '09';
break;
case 'Oct':
$mes = '10';
break;
case 'Nov':
$mes = '11';
break;
case 'Dec':
$mes = '12';
break;
}
return $mes;
}
$servidor = "mail.cartoriopostal.com.br";
$usuario = "*****@*****.**";
$senha = "a123d321";
@ini_set('display_errors', '0');
$mbox = imap_open("{" . $servidor . ":143/novalidate-cert}INBOX", $usuario, $senha);
$erro[] = imap_last_error();
if ($erro[0] == "") {
for ($i = 1; $i <= imap_num_msg($mbox); $i++) {
# **************************************************************
date_default_timezone_set('America/Sao_Paulo');
$headers = imap_header($mbox, $i);
$email = $headers->from[0]->mailbox . '@' . $headers->from[0]->host;
if (substr_count($email, 'cartoriopostal') > 0 || substr_count($email, 'softfox') > 0) {
#***************************************************************
$data = str_replace(' ', ',', $headers->date);
$data = explode(',', $data);
$mes = mes($data[3]);
$dia = $data[2] < 10 ? '0' . $data[2] : $data[2];
$data = $data[4] . ':' . $mes . ':' . $dia . ' ' . $data[5];
# **************************************************************
$usuario = $headers->from[0]->mailbox . '@' . $headers->from[0]->host;
$usuario = $this->f_usuario($usuario);
$usuario = count($usuario) == 0 ? 1 : $usuario[1];
# **************************************************************
$empresa = $headers->to[0]->mailbox . '@' . $headers->to[0]->host;
$empresa = $this->f_usuario($empresa);
$empresa = $empresa[0];
# **************************************************************
$h = "<b>De: </b>" . $headers->fromaddress . " [" . $headers->from[0]->mailbox . '@' . $headers->from[0]->host . "]<br />\n";
$h .= "<b>Para: </b>" . $headers->to[0]->personal . " [" . $headers->to[0]->mailbox . '@' . $headers->to[0]->host . "]<br />\n";
$h .= "<b>Enviada em: </b>" . $headers->date . "<br />\n";
$h .= "<b>Assunto: </b>" . $headers->subject . "<br /><br />\n\n";
$msg = imap_qprint(imap_body($mbox, $i));
$msg = strip_tags($msg);
if (substr_count($msg, 'Content-ID') > 0) {
$msg = explode("Content-ID", $msg);
$msg = explode("\n", $msg[0]);
} else {
$msg = explode("\n", $msg);
}
$mensagem = '';
for ($k = 0; $k < count($msg); $k++) {
$msg[$k] = str_replace(' ', ' ', $msg[$k]);
$msg[$k] = trim($msg[$k]);
if (strlen(trim($msg[$k])) > 0) {
$cont = $this->LimparLinha($msg[$k]);
if ($cont == 0 && strlen(trim($msg[$k])) > 0) {
if (substr_count($msg[$k], 'De: ') > 0) {
if (substr_count($msg[$k], '@cartoriopostal.com.br') > 0) {
$k = count($msg);
} else {
$mensagem .= $msg[$k] . "<br /><br />\n\n";
}
} else {
$mensagem .= $msg[$k] . "<br /><br />\n\n";
}
}
}
}
# **************************************************************
if (strlen($mensagem) > 0) {
$mensagem = $h . $mensagem;
$this->sql = "SELECT c.id_chamado FROM vsites_chamado AS c WHERE \n\t\t\t\t\t\t\tc.pergunta = ? AND c.data_atualizacao = ?";
$this->values = array($headers->subject, $data);
$dt = $this->fetch();
if (count($dt) == 0) {
$headers->subject = utf8_encode($headers->subject);
${$mensagem} = utf8_encode($mensagem);
$this->fields = array('id_pedido', 'ordem', 'id_empresa', 'id_usuario', 'status', 'pergunta', 'resposta', 'data_cadastro', 'data_atualizacao', 'forma_atend');
$this->values = array('id_pedido' => 0, 'ordem' => 0, 'id_empresa' => $empresa, 'id_usuario' => $usuario, 'status' => 1, 'pergunta' => $headers->subject, 'resposta' => $mensagem, 'data_cadastro' => $data, 'data_atualizacao' => $data, 'forma_atend' => 2);
return $this->insert();
}
}
#echo $mensagem."\n\n\n";
}
}
}
}
$userid = intval($_POST['userid']);
if (empty($_POST['password_form']) || empty($_POST['password_form1'])) {
$tool_content .= mes($langFieldsMissing, '', 'warning');
draw($tool_content, 3);
exit;
}
if ($_POST['password_form1'] !== $_POST['password_form']) {
$tool_content .= mes($langPassTwo, '', 'warning');
draw($tool_content, 3);
exit;
}
// All checks ok. Change password!
$hasher = new PasswordHash(8, false);
$new_pass = $hasher->HashPassword($_POST['password_form']);
Database::get()->query("UPDATE `user` SET `password` = ?s WHERE `id` = ?d", $new_pass, $userid);
$tool_content .= mes($langPassChanged, $langHome, 'info');
draw($tool_content, 3);
exit;
}
draw($tool_content, 3, null, $head_content);
/**
* @brief display message
* @param type $message
* @param type $urlText
* @param type $type
* @return type
*/
function mes($message, $urlText, $type)
{
$str = "<div class='alert alert-{$type}'>{$message}</div>";
return $str;
/**
* Transforma data formato aaaa-mm-dd para dd/mm/aaaa ou dd de mm de aaaa
*
* @param string $data (aaaa-mm-dd)
* @param bool $tipo (if true, exibe dd/mm/aaaa, else print dd de mm de aaaa) //valor default
* @return string (dd/mm/aaaa)
*/
function data($data, $tipo = 0)
{
if ($tipo == 0) {
$data = explode("-", $data);
$data = $data[2] . "/" . $data[1] . "/" . $data[0];
} elseif ($tipo == 1) {
$data = explode("-", $data);
$data = $data[2] . " de " . mes($data[1]) . " de " . $data[0];
} else {
$data = explode("/", $data);
$data = $data[2] . "-" . $data[1] . "-" . $data[0];
}
return $data;
}
function dataPorExtenso($cidade) {
$texto .= $cidade . ", " . date("d") . " de " . mes(date("m")) . " de " . date("Y");
return $texto;
}
function ver_informe($accion, $id_tuto, $id_cons)
{
include "conexion.php";
?>
<!DOCTYPE html>
<html lang="es">
<?php
all_head();
?>
<body>
<div id="wrapper">
<!-- Navigation -->
<?php
navegacion($_SESSION['id_usua'], $_SESSION['tipo_usuario']);
$query = "call cabecera_informe('" . $id_tuto . "')";
$result = $conexion->query($query);
$cabecera = array();
while ($row = mysqli_fetch_row($result)) {
$cabecera = $row;
}
mysqli_free_result($result);
$conexion->next_result();
$query = "call ver_asistidos_informe('" . $id_tuto . "')";
$result = $conexion->query($query);
$asistidos = array();
while ($row = mysqli_fetch_row($result)) {
$asistidos[] = $row;
}
mysqli_free_result($result);
$conexion->next_result();
?>
<div id="page-wrapper">
<div class="container-fluid">
<!-- Page Heading -->
<div class="container">
<div class="row">
<div class="col-lg-12">
<form id='volver' action="consejeria.php" method="POST">
<input type="hidden" name='accion' value='ver_consejeria' >
<input type="hidden" name='id_cons' <?php
echo "value='" . $id_cons . "'";
?>
>
</form>
<h1 class="page-header"><a href='#' onclick='volver.submit(); return false'><i class="fa fa-chevron-circle-left "></i></a> Informe Semestral <small>Sistema de tutoría</small>
</h1>
</div>
</div>
<div class="row">
<div class="modal-content">
<div class="close-modal" data-dismiss="modal">
<div class="lr">
<div class="rl">
</div>
</div>
</div>
<div class="row text-center">
<div class="col-lg-10 col-lg-offset-1">
<h3>Informe Semestral de Labor de Consejería - Tutoría Académica</h3>
<hr class="small">
</div>
</div>
<div class="col-sm-6" >
<div class="form-group">
<label for="fecha">Facultad:</label>
Ingeniería
</div>
<div class="form-group">
<label for="fecha">Docente:</label>
<?php
echo $cabecera[0];
?>
</div>
</div>
<div class="col-sm-6" >
<div class="form-group">
<label for="fecha">Escuela:</label>
Ingeniería en Informática y Sistemas
</div>
<div class="form-group">
<label for="fecha">Semestre:</label>
<?php
echo $cabecera[1];
?>
</div>
</div>
<div class="container">
<?php
if ($_SESSION['tipo_usuario'] == 'docente' and $accion == 'editar_informe') {
?>
<form id='editar_asistidos' action="consejeria.php" method="POST">
<input type="hidden" name='consejeria' value=<?php
echo $id_cons;
?>
>
<?php
}
?>
<div class="row" id="collapse_asistidos_2">
<div class='col-sm-12'>
<div class='panel panel-info'>
<div class="panel-heading">
<h1 class="panel-title"><a data-toggle="collapse" data-target='#collapse_asistidos' href='#collapse_asistidos_2'>Estudiantes Asistidos</a></h1>
</div>
<div id='collapse_asistidos' class="panel-collapse collapse in"> <!-- in -->
<div class="panel-body">
<br>
<table class="responsive table table-striped table-bordered table-hover table-condensed">
<tr class="info">
<th>Código</th>
<th>Nombre del Estudiante</th>
<th>Tema</th>
<th>Situación Académica</th>
</tr>
<?php
for ($i = 0; $i < count($asistidos); $i++) {
?>
<?php
if ($_SESSION['tipo_usuario'] == 'docente' and $accion == 'editar_informe') {
?>
<input type="hidden" name= <?php
echo "id_cons[] ";
?>
value=<?php
echo $asistidos[$i][0];
?>
>
<?php
}
?>
<tr>
<td><?php
echo $asistidos[$i][2];
?>
</td>
<td><?php
echo $asistidos[$i][3];
?>
</td>
<td>
<?php
if ($_SESSION['tipo_usuario'] == 'docente' and $accion == 'editar_informe') {
?>
<input class="form-control" type="text" <?php
echo "name='tema[" . $asistidos[$i][0] . "]'";
?>
<?php
echo "value='" . $asistidos[$i][4] . "'";
?>
>
<?php
} else {
?>
<?php
echo $asistidos[$i][4];
?>
<?php
}
?>
</td>
<td>
<?php
if ($_SESSION['tipo_usuario'] == 'docente' and $accion == 'editar_informe') {
?>
<input class="form-control" type="text" <?php
echo "name='situacion[" . $asistidos[$i][0] . "]'";
?>
<?php
echo "value='" . $asistidos[$i][5] . "'";
?>
>
<?php
} else {
?>
<?php
echo $asistidos[$i][5];
?>
<?php
}
?>
</td>
</tr>
<?php
}
?>
</table>
</div>
</div>
</div>
</div>
</div>
<div class="row" id="collapse_asistidos_4">
<div class='col-sm-12'>
<div class='panel panel-info'>
<div class="panel-heading">
<h1 class="panel-title"><a data-toggle="collapse" data-target='#collapse_asistidos_3' href='#collapse_asistidos_4'>Estudiantes Asistidos</a></h1>
</div>
<div id='collapse_asistidos_3' class="panel-collapse collapse in"> <!-- in -->
<div class="panel-body">
<br>
<?php
$modificable = 'readonly';
if ($_SESSION['tipo_usuario'] == 'docente' and $accion == 'editar_informe') {
$modificable = '';
}
?>
<div class="col-sm-6" >
<div class="form-group">
<label for="fecha">Motivos comunes de visita al Docente Consejero - Tutor:</label>
<div class="input-group">
<span class="input-group-addon"><span class=""></span></span>
<input class="form-control" name='motivos' type="text" <?php
echo "value='" . $cabecera[2] . "'";
?>
<?php
echo $modificable;
?>
>
</div>
</div>
<div class="form-group">
<label for="fecha">Los estudiantes tutorados fueron derivados mayormente a:</label>
<div class="input-group">
<span class="input-group-addon"><span class=""></span></span>
<textarea class="form-control" name='derivados' <?php
echo $modificable;
?>
><?php
echo $cabecera[4];
?>
</textarea>
</div>
</div>
</div>
<div class="col-sm-6" >
<div class="form-group">
<label for="fecha">Principales obstáculos encontrados para orientar adecuadamente:</label>
<div class="input-group">
<span class="input-group-addon"><span class=""></span></span>
<input class="form-control" name='obstaculos' type="text" <?php
echo "value='" . $cabecera[3] . "'";
?>
<?php
echo $modificable;
?>
>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="text-right">
<p>Tacna, <?php
echo date('d');
?>
de <?php
mes(date('F'));
?>
de <?php
echo date('Y');
?>
</p>
</div>
<div class="row text-center">
<?php
switch ($accion) {
case 'editar_informe':
?>
<div class="col-lg-4">
</div>
<div class="col-lg-4">
<div class="service-box text-center">
<input type="submit" class="btn btn-primary btn-block btn-md text-center" role="button">
</div>
</div>
<div class="col-lg-4">
</div>
<?php
break;
case 'ver_informe':
?>
<div class="col-lg-4">
</div>
<div class="col-lg-4">
<div class="service-box text-center">
<input name="Imprimir" class="btn btn-primary btn-block btn-md text-center" id="imprimir" onclick="DescargarPDF('page-wrapper','informe')" value="DescargarPDF">
</div>
</div>
<div class="col-lg-4">
</div>
<?php
default:
# code...
break;
}
?>
</div>
<br>
<?php
if ($_SESSION['tipo_usuario'] == 'docente' and $accion == 'editar_informe') {
?>
<input type="hidden" name='accion' value='update_informe' >
<input type="hidden" name='id_tuto' <?php
echo "value='" . $id_tuto . "'";
?>
>
</form>
<?php
}
?>
<!-- </form> -->
</div>
</div>
</div>
</div>
</div>
<!-- /.container-fluid -->
</div>
<!-- /#page-wrapper -->
</div>
<!-- /#wrapper -->
<!-- jQuery -->
<script src="js/jquery.js"></script>
<script src="js/jspdf.debug.js"></script>
<script>
function DescargarPDF(ContenidoID,nombre){
var pdf = new jsPDF('p','pt','letter');
html = $('#'+ContenidoID).html();
specialElementHandlers = {};
margins = {top: 10, bottom: 20, left: 20, width:522};
pdf.fromHTML(html, margins.left, margins.top, {'width': margins.width},function(dispose) {pdf.save(nombre+'.pdf')},margins);
}
</script>
<!-- Bootstrap Core JavaScript -->
<script src="js/bootstrap.min.js"></script>
<!-- Morris Charts JavaScript -->
<script src="js/plugins/morris/raphael.min.js"></script>
<script src="js/plugins/morris/morris.min.js"></script>
<script src="js/plugins/morris/morris-data.js"></script>
</body>
</html>
<?php
}
public function getTrendCell($date, $field = false, $view = "weekly", $opts = false)
{
$debug = false;
if (is_array($opts)) {
extract($opts);
}
if (is_numeric($date)) {
// The date is an interval, 0 is now, 1 is yesterday or last week, etc.
$interval = $date;
/*
* Currently the system will not work across years. We should be converting the
* 'weeks since today' format, into the week of the year, then into a date range
* with a start date and an end date. JB 9/5/08 2:31 PM
*/
$date_range = $this->rowToDateRange($interval, $view);
if ($debug) {
echo "<br> Date range is: ";
da($date_range);
}
if ($debug) {
echo "<br> The view is: {$view} <br>";
}
switch ($view) {
case "weekly":
$where .= " AND WEEK({$this->_table}.{$this->_dateField}) = (WEEK(NOW()) - {$date}) AND YEAR({$this->_table}.{$this->_dateField}) = (YEAR(NOW()) - 0) ";
break;
default:
case "monthly":
$where .= " AND {$this->_table}.{$this->_dateField} > '" . mes($date_range['sql_starting']) . "' AND {$this->_table}.{$this->_dateField} <= '{$date_range[sql_ending]}' ";
break;
}
} else {
// I'm not sure why this would be, if it's not numeric, we might as well error and die. JB 11/20/08 6:17 PM
// $where .= " AND WEEK({$this->_table}.{$this->_dateField}) = WEEK('".mes($date)."') ";
}
$sqlopts = array("where" => $this->_where . $where, "field" => $field, "join" => $join, "view" => $view, "having" => $having);
$this->sql = $this->getTrendSql($sqlopts);
if ($_REQUEST['debug_dbos']) {
da($this->sql);
}
$res = $this->getRes($this->sql);
if ($num = mysql_num_rows($res)) {
$row = mysql_fetch_assoc($res);
return $row['count'];
} else {
return 0;
}
}
// Conexión a base de datos
$conexion = dba::getInstance();
$fecha_menor = date_format(date_create(@$_POST['from']), 'Y-m-d');
$fecha_mayor = date_format(date_create(@$_POST['to']), 'Y-m-d');
$consulta = "SELECT ticket.tn as Numero_ticket,ticket.title as Nombre, ticket.create_time as fecha, DATE_ADD(ticket.create_time, INTERVAL 40 DAY) as fecha_vencimiento, service.name as Conectividad, IF(NOW() <= DATE_ADD(ticket.create_time, INTERVAL 40 DAY), 'no_vencido', 'vencido') as Estado, DATEDIFF(NOW(),DATE_ADD(ticket.create_time, INTERVAL 40 DAY)) as dias_mora\r\nFROM ticket_type, ticket, service, service_sla\r\nWHERE ticket_type.id = ticket.type_id AND ticket.service_id = service.id AND service.id = service_sla.service_id AND NOW()>= DATE_ADD(ticket.create_time, INTERVAL 40 DAY) AND service_sla.sla_id = 15 AND ticket.create_time BETWEEN '" . $fecha_menor . "' AND '" . $fecha_mayor . "'\r\nORDER BY fecha, Conectividad";
//var_dump($consulta);
$rows = $conexion->consulta($consulta);
$nombre_archivo = "Informe_otrs_" . date('m-d-Y');
$csv_sep = ",";
//$banderas;
if ($rows != NULL) {
if (mysql_num_rows($rows) > 0) {
$j = 0;
while ($row[] = mysql_fetch_array($rows)) {
//$banderas[$j] = array('fecha_vencimiento'=>$row[$j]['fecha_vencimiento'], 'dias_mora'=>$row[$j]['dias_mora'],);
$row[$j]['fecha_rango'] = mes($row[$j]);
$j++;
}
//var_dump($row);
}
}
/*foreach($row as $clave => $valor){
$valor['prueba'] = mes($valor);
}*/
?>
<HTML lang = "es">
<HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Informe de otrs</title>
<LINK REL=StyleSheet HREF="css/estilo.css" TYPE="text/css" MEDIA=screen>
include "../funciones/fechas.php";
include "Numbers/Words.php";
$pdf = new PDF();
$pdf->Open();
$pdf->AddPage();
if ($fondofac == "SI") {
$pdf->Header($imagenfac, 0, 0, 205, 295);
}
$codfactura = $_REQUEST["codfactura"];
$consulta = "Select * from facturas,clientes where facturas.codfactura='{$codfactura}' and facturas.codcliente=clientes.codcliente";
$resultado = mysql_query($consulta, $conexion);
$lafila = mysql_fetch_array($resultado);
$fecha = implota($lafila["fecha"]);
$dia1 = substr($fecha, 0, 2);
$mes1 = substr($fecha, 3, 2);
$mes1 = mes($mes1);
$ano1 = substr($fecha, 6, 4);
$pdf->SetFillColor(255, 255, 255);
$pdf->SetTextColor(18, 18, 239);
$pdf->SetDrawColor(0, 0, 0);
$pdf->SetLineWidth(0.2);
$pdf->SetFont('Arial', 'B', 11);
$pdf->Ln(31);
$pdf->Cell(115);
$pdf->Cell(10, 4, $codfactura, 0, 0, 'L', 0);
$pdf->Ln(22);
$pdf->Cell(60);
$pdf->Cell(42, 4, $CiudadActual, 0, 0, 'L', 0);
$pdf->Cell(20, 4, $dia1, 0, 0, 'L', 0);
$pdf->Cell(55, 4, $mes1, 0, 0, 'L', 0);
$pdf->Cell(10, 4, $ano1, 0, 0, 'L', 0);
</p>
<p class="titulo"><?php
echo $obj['ender_ug'] . ", " . $obj['num_ug'] . ", " . $obj['bairro_ug'];
?>
</p>
<p class="titulo"><!--?=$obj['ender_cidade']." - CEP:".$obj['ender_cep']." - ".$obj['ender_uf']
?--></p>
<div class="titulo" align="left" style="float:left; width:40%">
CNPJ: <?php
echo mask($obj['cnpj_ug'], '##.###.###/####-##');
?>
</div>
<div class="fonte" align="right" style="width:40%; float:right; margin-right:5px;">
<?php
echo mes(substr($ano_mes, 4, 2)) . "/" . substr($ano_mes, 0, 4);
?>
</div>
</td>
</tr>
</table>
<br>
<table width="100%" >
<tr>
<td>
<div style="margin-top:10px; width:100%;"></div>
<div class="vint15" style="margin-left:5px;">Mátricula<br><?php
echo $obj['id_servidor'];
?>
</div>
