require FPDF_PDF_RUTA . 'lib/pdftable.inc.php'; $p = new PDFTable('P'); $p->SetMargins(3, 43, 0); if ($_POST['modo_resumen']) { $p->AddPage('L'); $p->SetMargins(3, 10, 0); $p->titulo(5, $titulo); $p->setfont('Arial', '', 8); $p->SetTitle(date("d-m-Y") . "_informe"); $p->SetFillColor(255, 255, 255); $p->SetTextColor(0, 0, 0); $p->SetDrawColor(0, 0, 0); $filtrostab = "<table>"; $filtrostab .= $l_filtros; $filtrostab .= "</table>"; $p->HTMLtable($filtrostab); $p->ln(5); $tabla_cantidad = "<table>\n\t\t\t\t<tr><td>Cantidad total de Acciones Correctivas: " . count($acpm) . "</td></tr>\t\n\t\t\t</table>"; $p->HTMLtable($tabla_cantidad); $p->ln(5); $color1 = 'A6A6A6'; $color2 = 'FFFFFF'; $tit = "bgcolor=#{$color1} color=#{$color2} align=center valign=middle style=bold height=8"; $nor = "align=center height=5 valign=middle"; if (!$_POST['ag_tipo']) { $tabla = "<table border=1>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td {$tit} width=20>Num NC</td>\n\t\t\t\t\t\t<td {$tit} width=23>Fecha apertura</td>\n\t\t\t\t\t\t<td {$tit} width=140>Causa probable</td>\n\t\t\t\t\t\t<td {$tit} width=54>" . html_entity_decode("Tipo acción") . "</td>\n\t\t\t\t\t\t<td {$tit} width=15>Coste</td>\n\t\t\t\t\t\t<td {$tit} width=19>Fecha cierre</td>\n\t\t\t\t\t\t<td {$tit} width=19>Cierre eficaz</td>\n\t\t\t\t\t</tr>"; } } if ($acpm) { foreach ($acpm as $key => $valor) { if (!$_POST['modo_resumen']) {
if ($_POST['pdf']) { require FPDF_PDF_RUTA . 'lib/pdftable.inc.php'; $p = new PDFTable('L'); $p->SetMargins(3, 43, 0); $p->AddPage('L'); $p->SetMargins(3, 10, 0); $p->titulo(5, $titulo); $p->setfont('Arial', '', 8); $p->SetTitle(date("d-m-Y") . "_informe"); $p->SetFillColor(255, 255, 255); $p->SetTextColor(0, 0, 0); $p->SetDrawColor(0, 0, 0); $filtrostab = "<table>"; $filtrostab .= $l_filtros; $filtrostab .= "</table>"; $p->HTMLtable($filtrostab); $p->ln(5); $color1 = 'A6A6A6'; $color2 = 'FFFFFF'; $tit = "bgcolor=#{$color1} color=#{$color2} align=center valign=middle style=bold height=8"; $nor = "align=center height=5 valign=middle"; if ($cursos) { $tabla = "<table width=260 border=1>\n\t\t\t<tr>\n\t\t\t\t<td {$tit} width=9>" . html_entity_decode("Año") . "</td>\n\t\t\t\t<td {$tit} width=16>Finalizado</td>\n\t\t\t\t<td {$tit} width=60>Accion formativa</td>\n\t\t\t\t<td {$tit} width=22>Fecha prevista</td>\n\t\t\t\t<td {$tit} width=24>Fecha comienzo</td>\n\t\t\t\t<td {$tit} width=17>Fecha final</td>\n\t\t\t\t<td {$tit} width=50>Impartido por</td>\n\t\t\t\t<td {$tit} width=42>Proceso relacionado</td>\n\t\t\t\t<td {$tit} width=50>Responsable seguimiento</td>\n\t\t\t</tr>"; foreach ($cursos as $key => $valor) { $tabla .= "<tr>\n\t\t\t\t\t<td {$nor}>" . $valor['ano'] . "</td>\n\t\t\t\t\t<td {$nor}>" . $valor['accionfinalizada'] . "</td>\n\t\t\t\t\t<td {$nor}>" . $valor['accionformativa'] . "</td>\t\n\t\t\t\t\t<td {$nor}>" . $valor['fechaprevista'] . "</td>\n\t\t\t\t\t<td {$nor}>" . $valor['fechacomienzo'] . "</td>\t\n\t\t\t\t\t<td {$nor}>" . $valor['fechafinal'] . "</td>\n\t\t\t\t\t<td {$nor}>" . $valor['impartidopor'] . "</td>\n\t\t\t\t\t<td {$nor}>" . $valor['procesorelacionado'] . "</td>\n\t\t\t\t\t<td {$nor}>" . $valor['responsableseguimiento'] . "</td>\t\n\t\t\t\t</tr>"; } $tabla .= "</table>"; } else { echo "<script>alert('No se puede mostrar el informe. No hay cursos.');</script>"; echo "<script>window.close();</script>"; }
$p->SetTitle(date("d-m-Y") . "_revision_direccion"); $p->SetFillColor(255, 255, 255); $p->SetTextColor(0, 0, 0); $p->SetDrawColor(0, 0, 0); $reunion = select_normal("Select * from kz_tec_dir_reuniones where id = " . $_POST['reunion'] . ""); $reunion = $reunion[0]; $p->AddPage('P'); $p->SetMargins(3, 10, 0); $p->titulo(5, $titulo); $p->setfont('Arial', '', 8); $color1 = 'A6A6A6'; $color2 = 'FFFFFF'; $tit = "bgcolor=#{$color1} color=#{$color2} align=center valign=middle style=bold height=8"; $nor = "align=center height=5 valign=middle"; $tabla .= "<table border=1>\n\t\t<tr>\n\t\t\t<td {$tit} width=40>Fecha: </td>\n\t\t\t<td {$nor} width=100>" . $reunion['fecha'] . "</td>\n\t\t</tr>\n\t\t<tr>\n\t\t\t<td {$tit}>Asistentes: </td>\n\t\t\t<td {$nor}> " . $reunion['asistentes'] . "</td>\n\t\t</tr>\n\t\t<tr>\n\t\t\t<td {$tit}>" . html_entity_decode("Objeto de la reunión") . ": </td>\n\t\t\t<td {$nor}>" . $reunion['objeto'] . "</td>\n\t\t</tr>\n\t\t<tr>\n\t\t\t<td {$tit}>" . html_entity_decode("Fecha siguiente reunión") . ": </td>\n\t\t\t<td {$nor}>" . $reunion['fechasig'] . ", " . $reunion['horasig'] . "</td>\n\t\t</tr>\n\t\t<tr>\n\t\t\t<td {$tit}>Departamento: </td><td {$nor}>" . $reunion['departamento'] . "</td>\n\t\t</tr>\n\t</table>"; $p->HTMLtable($tabla); $p->Ln(5); $temas_tratados = select_normal("Select * from kz_tec_dir_temasreunion where idreunion = " . $reunion['id'] . ""); $tabla = "<table border=1>\n\t\t<tr>\n\t\t\t<td {$tit} width=191>" . html_entity_decode("Órden del día") . "</td>\n\t\t\t<td {$tit} width=13>Cerrado</td>\n\t\t</tr>"; if ($temas_tratados) { foreach ($temas_tratados as $key => $valor) { $tema = select_normal("Select * from kz_tec_dir_temas where id=" . $valor['idtema'] . ""); $tema = $tema[0]; $tabla .= "<tr>\n\t\t\t\t<td {$nor}>" . $tema['tema'] . "</td>\n\t\t\t\t<td {$nor}>" . siono($valor['cerrado']) . "</td>\n\t\t\t</tr>"; } } $tabla .= "</table>"; $p->HTMLtable($tabla); $p->ln(5); $dec = select_normal("Select * from kz_tec_dir_decisionesreunion a, kz_tec_dir_decisiones b where idreunion=" . $reunion['id'] . " and a.iddecision=b.id"); $tabla = "<table border=1>\n\t\t<tr>\n\t\t\t<td {$tit} width=132>" . html_entity_decode("Decisión adoptada") . "</td>\n\t\t\t<td {$tit} width=55>Responsable</td>\n\t\t\t<td {$tit} width=17>Plazo</td>\n\t\t</tr>";
$p->AddPage('L'); $p->SetMargins(3, 10, 0); $p->titulo(5, $titulo); $p->setfont('Arial', '', 8); $p->SetTitle(date("d-m-Y") . "_informe"); $p->SetFillColor(255, 255, 255); $p->SetTextColor(0, 0, 0); $p->SetDrawColor(0, 0, 0); $color1 = 'A6A6A6'; $color2 = 'FFFFFF'; $tit = "bgcolor=#{$color1} color=#{$color2} align=center valign=middle style=bold height=8"; $nor = "align=center height=5 valign=middle"; $filtrostab = "<table>"; $filtrostab .= $l_filtros; $filtrostab .= "</table>"; $p->HTMLtable($filtrostab); $p->ln(5); $p->Cell(0, 3, "Cantidad total de NC: " . count($nc), 0, 1); $p->Ln(5); $tabla = "<table border=1>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td {$tit} width=25>CNC</td>\n\t\t\t\t\t\t<td {$tit} width=20>Fecha detec.</td>\n\t\t\t\t\t\t<td {$tit} width=25>Origen de la NC</td>\n\t\t\t\t\t\t<td {$tit} width=32>Especific. de origen</td>\n\t\t\t\t\t\t<td {$tit} width=27>Clasific. de origen</td>\n\t\t\t\t\t\t<td {$tit} width=30>Detectada por</td>\n\t\t\t\t\t\t<td {$tit} width=75>" . html_entity_decode("Resumen descripción") . "</td>\n\t\t\t\t\t\t<td {$tit} width=10>Coste</td>\n\t\t\t\t\t\t<td {$tit} width=10>Unid.</td>\n\t\t\t\t\t\t<td {$tit} width=19>Fecha cierre</td>\n\t\t\t\t\t\t<td {$tit} width=17>Cierre efic.</td>\n\t\t\t\t\t</tr>"; } if ($nc) { foreach ($nc as $key => $valor) { if (!$_POST['modo_resumen']) { $p->AddPage('P'); $p->SetMargins(3, 10, 0); $p->titulo(5, $titulo); $p->setfont('Arial', '', 8); $p->SetTitle(date("d-m-Y") . "_informe"); $p->SetFillColor(255, 255, 255); $p->SetTextColor(0, 0, 0);