function AddPage($orientation = '', $size = '')
{
parent::AddPage($orientation, $size);
$this->addText(10, 13, "Trianik Cleaners Ltd Starter Form", 12, 4, 'B');
$this->Image("images/logomain2.png", 178.6, 1);
$this->addText(40, 288, "Trianik Cleaners Ltd - Starter Forms revised August 2015 - Mrs N M Saunders - Managing Director TCL", 8, 4, '');
$this->Rect(5, 21, 200, 259);
$this->Line(48, 21, 48, 279.9);
}
function AddPage($orientation = '', $size = '')
{
parent::AddPage($orientation, $size);
$this->Image("images/logomain2.png", 173.6, 1);
$size = $this->addText(10, 13, "Hours Worked - Monthly", 12, 4, 'B') + 5;
$this->SetFont('Arial', '', 8);
$cols = array("Customer" => 155, "Hours Worked" => 35);
$this->addCols($size, $cols);
$cols = array("Customer" => "L", "Hours Worked" => "R");
$this->addLineFormat($cols);
$this->SetY(29);
}
function AddPage($orientation = '', $size = '')
{
parent::AddPage($orientation, $size);
$this->Image("images/logomain2.png", 173.6, 1);
$size = $this->addText(10, 13, "Hours - Staff", 12, 4, 'B') + 5;
$this->SetFont('Arial', '', 8);
$cols = array("Staff Member" => 115, "Holidays" => 25, "Absences" => 25, "Hours Worked" => 25);
$this->addCols($size, $cols);
$cols = array("Staff Member" => "L", "Holidays" => "R", "Absences" => "R", "Hours Worked" => "R");
$this->addLineFormat($cols);
$this->SetY(29);
}
function AddPage($orientation = '', $size = '')
{
parent::AddPage($orientation, $size);
$this->Image("images/logo_under12.png", 175.6, 1);
$size = $this->addText(10, 13, "Results summary - HYFL", 12, 4, 'B') + 5;
$this->SetFont('Arial', '', 8);
$cols = array("Age Group" => 40, "Division" => 30, "Home Team" => 45, "Score" => 15, "Away Team" => 45, " Score " => 15);
$this->addCols($size, $cols);
$cols = array("Age Group" => "L", "Division" => "L", "Home Team" => "L", "Score" => "C", "Away Team" => "L", " Score " => "C");
$this->addLineFormat($cols);
$this->SetY(30);
}
function AddPage($orientation = '', $size = '')
{
parent::AddPage($orientation, $size);
$this->Image("images/logomain2.png", 132.6, 1);
$size = $this->addText(10, 5, "Report Daily Takings", 12, 4, 'B');
$size = $this->addText(10, 14, "Date : " . $this->dateFrom, 10, 4, 'B') + 5;
$this->SetFont('Arial', '', 12);
$cols = array("Event" => 106, "Takings" => 42, "Expected" => 42);
$this->addCols($size + 2, $cols);
$cols = array("Event" => "L", "Takings" => "R", "Expected" => "R");
$this->addLineFormat($cols);
$this->SetY(32);
}
function AddPage($orientation = '', $size = '')
{
parent::AddPage($orientation, $size);
$this->Image("images/logomain2.png", 132.6, 1);
$size = $this->addText(10, 5, "Report Summary Site", 12, 4, 'B');
$size = $this->addText(10, 14, "Event : " . GetEventName($_POST['eventid']), 10, 4, 'B') + 5;
$size = $this->addText(10, 19, "Between : " . date("d-M-Y", strtotime($this->fromdate)) . " and " . date("d-M-Y", strtotime($this->todate)), 10, 4, 'B') + 5;
$this->SetFont('Arial', '', 9);
$cols = array(GetEventName($_POST['eventid']) => 40, "SOLD" => 30, "BROKEN" => 30, "DEMO" => 30, "BALANCE" => 30, "SALES" => 30);
$this->addCols($size, $cols);
$cols = array(GetEventName($_POST['eventid']) => "L", "SOLD" => "R", "BROKEN" => "R", "DEMO" => "R", "BALANCE" => "R", "SALES" => "R");
$this->addLineFormat($cols);
$this->SetY(36);
}
function AddPage($orientation = '', $size = '')
{
parent::AddPage($orientation, $size);
$this->Image("images/logomain2.png", 132.6, 1);
$size = $this->addText(10, 5, "Report Sales", 12, 4, 'B');
if ($_POST['eventid'] == "0") {
$size = $this->addText(10, 14, "Event : All", 10, 4, 'B') + 5;
} else {
$size = $this->addText(10, 14, "Event : " . $this->GetEventName($_POST['eventid']), 10, 4, 'B') + 5;
}
$size = $this->addText(10, 19, "Between : " . $_POST['datefrom'] . " and " . $_POST['dateto'], 10, 4, 'B') + 5;
$this->SetFont('Arial', '', 6);
$cols = array("Product" => 102, "Sold" => 22, "Broken" => 22, "Demo" => 22, "Cost" => 22);
$this->addCols($size, $cols);
$cols = array("Product" => "L", "Sold" => "R", "Broken" => "R", "Demo" => "R", "Cost" => "R");
$this->addLineFormat($cols);
$this->SetY(36);
}
function AddPage($orientation = '', $size = '')
{
parent::AddPage($orientation, $size);
$this->Image("images/logomain2.png", 132.6, 1);
$size = $this->addText(10, 5, "Report Sold Units By Site", 12, 4, 'B');
$size = $this->addText(10, 14, "Event : " . GetEventName($_POST['eventid']), 10, 4, 'B') + 5;
$size = $this->addText(10, 19, "Between : " . date("d-M-Y", strtotime($this->fromdate)) . " and " . date("d-M-Y", strtotime($this->todate)), 10, 4, 'B') + 5;
$this->SetFont('Arial', '', 9);
$this->dates = array();
$date = $this->fromdate;
while (strtotime($date) <= strtotime($this->todate)) {
array_push($this->dates, date("d-M-Y", strtotime($date)));
$date = date("Y-m-d", strtotime("+1 day", strtotime($date)));
}
$cols = array(GetEventName($_POST['eventid']) => 43, $this->dates[0] => 21, $this->dates[1] => 21, $this->dates[2] => 21, $this->dates[3] => 21, $this->dates[4] => 21, $this->dates[5] => 21, $this->dates[6] => 21);
$this->addCols($size, $cols);
$cols = array(GetEventName($_POST['eventid']) => "L", $this->dates[0] => "R", $this->dates[1] => "R", $this->dates[2] => "R", $this->dates[3] => "R", $this->dates[4] => "R", $this->dates[5] => "R", $this->dates[6] => "R");
$this->addLineFormat($cols);
$this->SetY(36);
}
$pdf->SetSubject("REPORTE WEB LEGALES");
$sql = ObtenerSQL_DatosdelaEmpresa();
$params[":siniestro"] = $_SESSION["ReportesSiniestros"]["ID"];
$params[":orden"] = $_SESSION["ReportesSiniestros"]["ORDEN"];
$stmt = DBExecSql($conn, $sql, $params);
//-----------------------------------------------------------------------
if (DBGetRecordCount($stmt) == 0) {
echo "La consulta no devolviò datos.";
exit;
}
$rowCabecera = DBGetQuery($stmt, 1, false);
//-----------------------------------------------------------------------
// $pdf->setSourceFile($_SERVER["DOCUMENT_ROOT"]."/modules/varios/templates/ListadoJuiciosVerticalBlanco.pdf");
$stmt = DBExecSql($conn, $sql, $params);
$pdf->SetAutoPageBreak(true, 20);
$pdf->AddPage('P', 'Legal');
while ($row = DBGetQuery($stmt, 1, false)) {
$pdf->SetX($pdf->margenDerecho);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFontAlignGeneral();
$Newrow = array_values($row);
$pdf->Row($Newrow);
$pdf->LineaSepara();
}
unset($_SESSION['ReportesSiniestros']["ReporteDatosdelaEmpresa"]);
// enviamos cabezales http para no tener problemas
header('Content-Type: text/html; charset=UTF-8');
//header('Content-Type: text/html; charset=iso-8859-1');
header("Content-Transfer-Encoding", "binary");
//header('Cache-Control: maxage=3600');
header('Cache-Control: private, max-age=0, must-revalidate');
function AddPage($orientation = '', $size = '')
{
parent::AddPage($orientation, $size);
$this->newPage();
}
$row = Obtener_ID_TABLA($pdf->idrelev, $annoACTUAL);
if (BuscaSubStr($row["TABLA"], 'SINRIESGO')) {
$pdf->TieneExpuestos = 'SINEXPUESTO';
}
if (BuscaSubStr($row["TABLA"], 'CABECERANOMINA')) {
$pdf->TieneExpuestos = 'CONEXPUESTO';
}
$params[":IDCABECERA"] = $pdf->idrelev;
$sql = $pdf->ListadoPersonalExpAnnoAntSQL($annoACTUAL);
$pdf->BuscaDatorGeneralReporte($annoACTUAL, $idEstablecimiento);
} else {
if (isset($_SESSION['ListadoPersonalExpuesto']['tiponomina']) and $_SESSION['ListadoPersonalExpuesto']['tiponomina'] == 'S') {
$pdf->TieneExpuestos = 'CONEXPUESTO';
$sql = $pdf->ListadoPersonalExpSQL($idEstablecimiento);
} else {
$pdf->TieneExpuestos = 'SINEXPUESTO';
$idEWEstableci = $_SESSION['ListadoPersonalExpuesto']['empresaESTABLECI'];
$idEWCUIT = $_SESSION['ListadoPersonalExpuesto']['empresaCUITSINGUION'];
}
$params[":IDCABECERANOMINA"] = $idEstablecimiento;
$pdf->BuscaDatorGeneralReporte($annoACTUAL, $idEstablecimiento);
}
} catch (Exception $e) {
DBRollback($conn);
SalvarErrorTxt(__FILE__, __FUNCTION__, __LINE__, $e->getMessage());
echo 'ERROR: ' . $e->getMessage();
}
$pdf->AddPage();
$pdf->SetFont('Arial', 'B', 16);
$pdf->Cell(140, 10, 'Pritn screen !' . $UsuarioNombre);
$pdf->Output();
} else {
if (isset($_SESSION['ListadoPersonalExpuesto']['tiponomina']) and $_SESSION['ListadoPersonalExpuesto']['tiponomina'] == 'S') {
$pdf->TieneExpuestos = 'CONEXPUESTO';
$sql = $pdf->ListadoPersonalExpSQL($idEstablecimiento);
} else {
$pdf->TieneExpuestos = 'SINEXPUESTO';
$idEWEstableci = $_SESSION['ListadoPersonalExpuesto']['empresaESTABLECI'];
$idEWCUIT = $_SESSION['ListadoPersonalExpuesto']['empresaCUITSINGUION'];
}
$params[":IDCABECERANOMINA"] = $idEstablecimiento;
$pdf->BuscaDatorGeneralReporte($annoACTUAL, $idEstablecimiento);
}
if ($pdf->TieneExpuestos == 'SINEXPUESTO') {
$pdf->setSourceFile($_SERVER["DOCUMENT_ROOT"] . "/modules/varios/templates/ListadoJuiciosVerticalBlanco.pdf");
$pdf->SetAutoPageBreak(true, 50);
$pdf->AddPage('L', 'Legal');
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFontAlignGeneral();
$Newrow = array("0" => '', "1" => '', "2" => '', "3" => '', "4" => '', "5" => '', "6" => '');
$pdf->Row($Newrow);
}
if ($pdf->TieneExpuestos == 'CONEXPUESTO') {
$stmt = DBExecSql($conn, $sql, $params);
//-----------------------------------------------------------------------
if (DBGetRecordCount($stmt) == 0) {
echo utf8_decode("La consulta no devolvio datos.");
exit;
}
//-----------------------------------------------------------------------
$pdf->setSourceFile($_SERVER["DOCUMENT_ROOT"] . "/modules/varios/templates/ListadoJuiciosVerticalBlanco.pdf");
$pdf->SetAutoPageBreak(true, 50);
$pdf->SetTitle('ReporteEvolutivodeSiniestro');
$pdf->SetAuthor("JLovatto");
$pdf->SetCreator('ReporteEvolutivodeSiniestro');
$pdf->SetSubject("REPORTE WEB LEGALES");
$params[":siniestro"] = $_SESSION["ReportesSiniestros"]["ID"];
$params[":orden"] = $_SESSION["ReportesSiniestros"]["ORDEN"];
$pdf->datosEncabezado = Encabezado_ReporteEvolutivodeSiniestro($_SESSION["ReportesSiniestros"]["ID"], $_SESSION["ReportesSiniestros"]["ORDEN"]);
$sql = $pdf->Listado_ReporteEvolutivodeSiniestro();
$stmt = DBExecSql($conn, $sql, $params);
//-----------------------------------------------------------------------
if (DBGetRecordCount($stmt) == 0) {
echo utf8_decode("La consulta no devolvio datos.");
exit;
}
//-----------------------------------------------------------------------
$pdf->AddPage('L', 'legal');
$pdf->SetTitle('ReporteEvolutivodeSiniestro');
// $pdf->SetXY(5,30);
$rowLines = array();
$currentHead = '';
while ($row = DBGetQuery($stmt, 1, false)) {
if ($currentHead != $row['EV_DOCU']) {
if ($pdf->muestraImporte) {
$rowLines[] = $pdf->ArmarLineas($row, 3);
$pdf->sumaImporte = 0;
}
$rowLines[] = $pdf->ArmarLineas($row, 0);
$currentHead = $row['EV_DOCU'];
}
if ($pdf->muestraImporte) {
$rowLines[] = $pdf->ArmarLineas($row, 1);
}
$UsuarioNombre = $_SESSION["usuario"];
if (!isset($_SESSION['ReportesSiniestros']["ReporteFichaTrabajador"])) {
header("Location: /JuiciosParteDemandada");
// CIERRA LA PAGINA
// echo "<script languaje='javascript' type='text/javascript'>window.close();</script>";
exit;
}
//-------------------------------------------
$pdf = new PDFReport();
$pdf->SetTitle("ReporteFichaTrabajador");
$pdf->SetAuthor("JLovatto");
$pdf->SetCreator("ReporteFichaTrabajador");
$pdf->SetSubject("REPORTE WEB LEGALES");
$pdf->SetAutoPageBreak(true, 20);
$pdf->AddPage('P', 'A4');
$pdf->SetTitle('ReporteFichaTrabajador');
$pdf->HistoricoLaboral();
unset($_SESSION['ReportesSiniestros']["ReporteFichaTrabajador"]);
//enviamos cabezales http para no tener problemas
header('Content-Type: text/html; charset=UTF-8');
//header('Content-Type: text/html; charset=iso-8859-1');
header("Content-Transfer-Encoding", "binary");
//header('Cache-Control: maxage=3600');
header('Cache-Control: private, max-age=0, must-revalidate');
header('Pragma: public');
$pdf->Output();
// DBCommit($conn);
} catch (Exception $e) {
DBRollback($conn);
EscribirLogTxt1("ReporteFichaTrabajador.php", $e->getMessage());
