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>