foreach ($data as $row) { $this->Cell($w[0], 6, $row[0], 'LR', 0, 'C', $fill); $this->Cell($w[1], 6, iconv('UTF-8', 'ISO-8859-1', $row[1]), 'LR', 0, 'C', $fill); $this->Cell($w[2], 6, iconv('UTF-8', 'ISO-8859-1', $row[2]), 'LR', 0, 'C', $fill); $this->Cell($w[3], 6, $row[3], 'LR', 0, 'C', $fill); $this->Cell($w[4], 6, iconv('UTF-8', 'ISO-8859-1', $row[4]), 'LR', 0, 'C', $fill); $this->Ln(); $fill = !$fill; } //Closure line $this->Cell(array_sum($w), 0, '', 'T'); } } $header = array('id', 'Nome', 'Email', 'Contacto', iconv('UTF-8', 'ISO-8859-1', 'Comentário')); $gl = new Guestlist(); $guests = $gl->ListGuests(' 1 ORDER BY NAME ASC'); $data = array(); $i = 0; foreach ($guests as $guest) { $data[$i][0] = $guest['id']; $data[$i][1] = $guest['name']; $data[$i][2] = $guest['email']; $data[$i][3] = $guest['phone']; $data[$i][4] = $guest['comment']; $i++; } $pdf = new PDF(); $pdf->SetFont('Arial', '', 8); $pdf->AddPage(); $pdf->ImprovedTable($header, $data); $pdf->Output();
}else{ $vlImp = $drPoliza[Abono]; } $vlCadena .= $vlImp." "."0"." 0.0"; $vlConceptoM = $drPoliza[ConceptoM]; if(strlen($vlConceptoM) > 30){ $vlCadena .= substr($vlConceptoM,0, 30); }else{ $vlCadena .= $vlConceptoM; } } //$detallado; $pdf = new PDF('P','mm','letter'); $pdf->AliasNbPages(); //Ttulos de las columnas $header1 = array('FECHA','TIPO','NUMERO','CONCEPTO','CLASE DIARIO'); $header2 = array('NO REF','CUENTA','','NOMBRE','DIARIO','CARGO','ABONOS'); //Carga de datos $pdf->SetFont('Courier','B',10); $pdf->addPage(); $pdf->ImprovedTable($header1,$header2,$detallado); $pdf->Output(); ?>
} $tmp_name_array = $_FILES['file']['tmp_name']; $typ_pliku = $_FILES['file']['name']; $typ_pliku = explode(".", $typ_pliku); $fragmenty = sizeof($typ_pliku); $typ_pliku = $typ_pliku[$fragmenty - 1]; $file_name .= "." . $typ_pliku; if ($_FILES['file']['size'] > 0) { if (is_uploaded_file($tmp_name_array)) { move_uploaded_file($tmp_name_array, "../specyfikacja/listy_przewozowe/" . $file_name . ""); } $adres_skanu = "specyfikacja/listy_przewozowe/" . $file_name; } else { $adres_skanu = ''; } } $to = array(" ", "ę", "ł"); $na_to = array("", "e", "l"); $name_pos = str_replace($to, $na_to, $_SESSION['salon']); $_POST['InputList'] = str_replace(" ", "", $_POST['InputList']); mysql_query("INSERT INTO historia_dokumentow (salon, data_wydruku, godzina_generacji, numer_listu, adres_pliku, adres_skanu)\n VALUES ('" . $_SESSION['salon'] . "', '" . date('Y-m-d') . "', '" . date('Y-m-d H:i') . "', '" . addslashes($_POST['InputList']) . "', 'specyfikacja/" . $name_pos . "/" . date('Y-m-d') . "_" . $_POST['InputList'] . ".pdf', '" . $adres_skanu . "');"); if (!file_exists("../specyfikacja/" . $name_pos)) { mkdir("../specyfikacja/" . $name_pos); } $pdf->ImprovedTable($data); $pdf->Output("../specyfikacja/" . $name_pos . "/" . date('Y-m-d') . "_" . $_POST['InputList'] . ".pdf", "F"); } } $pdf->ImprovedTable($data); $pdf->Output(); mysql_query("INSERT INTO history(data, godzina, login, salon, what_do, gdzie)\n VALUES ('" . date('Y-m-d') . "',\n '" . date('H:i:s') . "',\n '" . $_SESSION['login_name'] . "',\n '" . $_SESSION['salon'] . "',\n 'Wygenerowano specyfikację pracownika',\n ' '\n );");
} function addFirma($mode,$p1,$p2,$titulo,$linea){ $r1 = $p1; $r2 = $r1 + $linea; $y1 = $p2; $y2 = $y1+10; $mid = $y1 + (($y2-$y1) / 2); //$this->RoundedRect($r1, $y1, ($r2 - $r1), ($y2-$y1), 2.5, 'D'); $this->Line($r1, $mid, $r2, $mid); $this->SetXY($r1 + ($r2-$r1)/2 -3 , ($y1 + 1) -5 ); $this->SetFont('Courier', "B", 6); $this->Cell(10,5, utf8_decode($titulo), 0, 0, "C"); $this->SetXY($r1 + ($r2-$r1)/2 -5 , $y1 + 5 ); $this->SetFont( 'Courier', "", 6); $this->Cell(10,5, utf8_decode($mode), 0, 0, "C"); } } $pdf = new PDF('P','mm','letter'); $pdf->AliasNbPages(); //Ttulos de las columnas $header = array('GUIA','DESTINATARIO','DESC./CONT.','PESO','PAGADO','COBRAR','EMB','INC'); //Carga de datos $pdf->SetFont('Courier','B',12); //$pdf->AddPage(); $pdf->ImprovedTable($header,$_GET[destino],$fechaseleccionada); $pdf->Output(); ?>
foreach ($tmp_attendees as $tmp_attendee) { $sub_total = $tmp_attendee["final_price"] * $tmp_attendee["quantity"]; $orig_total = $tmp_attendee["orig_price"] * $tmp_attendee["quantity"]; $attendees[] = $pdf->LoadData(array(pdftext($tmp_attendee["event_name"] . "[" . date('m-d-Y', strtotime($tmp_attendee['start_date'])) . "]") . ' >> ' . pdftext(html_entity_decode($tmp_attendee["fname"], ENT_QUOTES, "UTF-8") . " " . html_entity_decode($tmp_attendee["lname"], ENT_QUOTES, "UTF-8")) . ';' . pdftext($tmp_attendee["quantity"]) . ';' . doubleval($tmp_attendee["final_price"]) . ';' . doubleval($sub_total))); $total_cost += $sub_total; $total_orig_cost += $orig_total; $total_amount_pd += $tmp_attendee["amount_pd"]; $event_identifier = $tmp_attendee["event_identifier"]; } } $header = array(__('Event & Attendee', 'event_espresso'), __('Quantity', 'event_espresso'), __('Per Unit', 'event_espresso'), __('Sub total', 'event_espresso')); $w = array(100, 25, 30, 30); $alling = array('L', 'L', 'C', 'C', 'C'); $left = 100 + 25 + 30; $right = 30; $pdf->ImprovedTable($header, $attendees, $w, $alling); $pdf->Ln(); //if ( $total_amount_pd != $total_cost ) { $pdf->InvoiceTotals(__('Total:', 'event_espresso'), $total_cost, $left, $right); $text = __('Amount Paid:', 'event_espresso'); $pdf->InvoiceTotals($text, $total_amount_pd, $left, $right); // $discount = $total_orig_cost - $total_cost; // if ($discount > 0) { // $text = __('Discount:', 'event_espresso'); // } else { // $text = __('Discount:', 'event_espresso'); // $pdf->InvoiceTotals($text, $discount, $left, $right); // } //} $total_owing = $total_cost - $total_amount_pd; $text = __("Total due:", 'event_espresso');
$total += $itemx->q * $item->price; $this->setY(95 + $starty); $this->setX(65); $starty += 5; } } $starty += 5; ///////////////////////////////////////////////////////////// Total $this->SetFont('Arial', '', 12); $this->setY(125 + $starty); $this->setX(20); $this->Cell(0, 10, "SubTotal: " . utf8_decode($coin) . " " . number_format($total * (1 - $iva / 100), 2, ".", ",")); $starty += 5; $this->setY(125 + $starty); $this->setX(20); $this->Cell(0, 10, "{$iva_txt}: " . utf8_decode($coin) . " " . number_format($total * ($iva / 100), 2, ".", ",")); $starty += 5; $this->setY(125 + $starty); $this->setX(20); $this->Cell(0, 10, "Total: " . utf8_decode($coin) . " " . number_format($total, 2, ".", ",")); ///////////////////////////////////////////////////////////// //////////////////////////////////////////////////// } } $pdf = new PDF(); $pdf->AddPage(); // $pdf->Header(); $pdf->ImprovedTable("hola"); //echo $name; $pdf->Output(); //print "<script>window.location=\"".$name."\";</script>";
} function addFirma($mode,$p1,$p2,$titulo,$linea){ $r1 = $p1; $r2 = $r1 + $linea; $y1 = $p2; $y2 = $y1+10; $mid = $y1 + (($y2-$y1) / 2); //$this->RoundedRect($r1, $y1, ($r2 - $r1), ($y2-$y1), 2.5, 'D'); $this->Line($r1, $mid, $r2, $mid); $this->SetXY($r1 + ($r2-$r1)/2 -3 , ($y1 + 1) -5 ); $this->SetFont('Courier', "B", 6); $this->Cell(10,5, utf8_decode($titulo), 0, 0, "C"); $this->SetXY($r1 + ($r2-$r1)/2 -5 , $y1 + 5 ); $this->SetFont( 'Courier', "", 6); $this->Cell(10,5, utf8_decode($mode), 0, 0, "C"); } } $pdf = new PDF('P','mm','letter'); $pdf->AliasNbPages(); //Ttulos de las columnas $header = array('GUIA','DESTINATARIO','DESC./CONT.','PESO','PAGADO','COBRAR','EMB','INC'); //Carga de datos $pdf->SetFont('Courier','B',10); //$pdf->AddPage(); $pdf->ImprovedTable($header,$_GET[destino]); $pdf->Output(); ?>
} function printcell1($tempreg) { global $pdf, $height, $width; $pdf->myCell($width[3], $height[1], $tempreg, 'LR'); $pdf->Ln(); } if ($session == 'FNAN') { $cursession = 'FN'; } $pdf = new PDF(); //$pdf->SetAutoPageBreak('off'); $pdf->AliasNbPages(); $pdf->SetFont('Arial', '', 14); $pdf->AddPage(); $pdf->ImprovedTable($header, $width, $height); for ($i = 0; $i < count($header); $i++) { $pdf->myCell($width[$i], $height[2], '', 'TLR'); } $pdf->Ln(); if (isset($SESSION['edited']) && $SESSION['edited'] != 'FN' && $SESSION['edited'] != 'AN') { if ($session == 'FNAN') { $cursession = 'AN'; mainarranger('FN'); $ttli = counting('i'); $ttlt = counting('t'); arrange(); //$session = $session2; //$cursession = $cursession2; $allhalls = $allhalls2; mainarranger('AN');
} $pdf->SetFont('Arial', 'B', 10); $pdf->Write(5, $value); $pdf->Ln(); } } $temp = array(); foreach ($pdfdata['address'] as $key => $value) { $temp['key'][] = array(utf8_decode($key), utf8_decode($value)); } $pdf->Ln(10); // top left area eof // top right area $pdf->SetY(45); $pdf->SetLeftMargin(120); $pdf->ImprovedTable('', $temp['key']); $pdf->SetLeftMargin(15); // top right area eof // invoice number $pdf->Ln(10); $pdf->SetFont('Arial', 'B', 10); $pdf->Cell(0, 0, utf8_decode($this->pi_getLL('admin_invoice_number') . ': ' . $invoice['invoice_id']), 0, 1, 'L'); $pdf->Ln(5); // invoice number eof // data table $temp = array(); switch ($this->LLkey) { case "de": $pdf->SetWidths(array(10, 37, 68, 17, 26, 22)); break; case "nl":
/** Datum errechnen */ function sendBill($db, $userData, $billNumber, $billMonth = false, $billYear = false) { $bill = new PDF(); $bill->AliasNbPages(); $bill->AddPage(); $data = [[utf8_decode($userData['contact_name']), 'E-Mail:'], [utf8_decode($userData['contact_street']), '*****@*****.**'], [$userData['contact_zip'] . ' ' . utf8_decode($userData['contact_city']), 'Steuernummer:'], [$userData['contact_phone'], '15/231/24307'], ['', ''], ['', '']]; $bill->SimpleTable($data); // font-size for title / title $bill->SetFont('Arial', 'B', 16); $bill->Cell(0, 15, 'Rechnung', 0, 1); // bill number // change font-size $bill->SetFont('Arial', '', 12); $bill->Cell(130, 8, 'Rechnungsnummer: ' . $billNumber, 0, 0); $bill->Cell(0, 8, '(Bei Zahlung bitte angeben)', 0, 1, 'R'); // bill date $bill->Cell(0, 8, 'Rechnungsdatum: ' . date('d.m.Y'), 0, 1); // bill date range if (isset($billMonth) && $billMonth != false && isset($billYear) && $billYear != false) { $bill->Cell(0, 8, 'Abrechnungzeitraum: ' . $billMonth . '.' . $billYear, 0, 1); } else { $bill->Cell(0, 8, 'Abrechnungzeitraum: ' . date('m.Y'), 0, 1); } // Line break $bill->Ln(16); $header = ['Pos.', 'Anzahl', 'Bezeichnung', 'EUR/Gesamt']; $price = $userData['package_price']; $tax = $price * 0.19; $data = [['1', '1', 'Paket ' . $userData['package_name'] . utf8_decode(' (Größe: ' . $userData['package_size'] . ' Anzeigen)'), number_format($price, 2, ',', '.')], ['', '', utf8_decode('zzgl. 19% Mehrwertsteuer'), number_format($tax, 2, ',', '.')]]; $bill->ImprovedTable($header, $data); // Line break $bill->Ln(16); $bill->SetFont('Arial', 'B', 12); $total = $price + $tax; $bill->Cell(0, 8, 'Gesamtpreis inklusive Mehrwertsteuer in EUR: ' . number_format($total, 2, ',', '.'), 1, 1, 'R'); // Line break $bill->Ln(16); $bill->SetFont('Arial', '', 12); $bill->Cell(0, 8, utf8_decode('Bitte überweisen Sie den Rechnungsbetrag unter Angabe der Rechnungsnummer innerhalb von 7 Tagen'), 0, 1, 'L'); $bill->Cell(0, 8, 'auf folgendes Konto:', 0, 1, 'L'); $bill->SetFont('Arial', 'B', 12); $bill->Cell(0, 8, 'Kontoinhaber: Rehm Jochens GbR | IBAN: DE71 2004 0000 0744 2213 00 | BIC: COBADEFFXXX', 0, 1, 'C'); $path = APP_PATH . 'bills/' . $billNumber . '.pdf'; $bill->Output('F', $path, true); // message $message = ''; $message = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">'; $message .= '<html lang="de">' . "\r\n"; $message .= '<head>' . "\r\n"; $message .= '<title>Möbel Mafia - Ihre Rechnung für Ihr gebuchtes Paket bei Möbel Mafia.</title>' . "\r\n"; $message .= '<style type="text/css">' . "\r\n"; $message .= 'a {color: #fff;}' . "\r\n"; $message .= 'a.content-link {color: #000;}' . "\r\n"; $message .= 'a:hover {color: #AC1A23;}' . "\r\n"; $message .= '</style></head>' . "\r\n"; $message .= '<body style="font-family:Arial,Helvetica,sans-serif; font-size:12px; background:#FFFFFF; padding:0px; margin:0px; padding-bottom:40px; color:#000000;">' . "\r\n"; $message .= '<div style="width:700px; font-family:arial,helvetica,sans-serif; padding:10px 0 0 15px;">' . "\r\n"; $message .= '<table width="700" border="0" cellspacing="0" cellpadding="0">' . "\r\n"; $message .= '<tr><td align="left"><a href="http://www.moebel-mafia.com"><img src="http://www.moebel-mafia.com/img/moebel-mafia-mail-logo.png" width="150" height="70" border="0" alt="Möbel Mafia logo" /></a></td></tr>' . "\r\n"; $message .= '<tr><td colspan="2" align="right" height="30" style="font-weight:800;color:#fff;padding:15px;background:#000;border-bottom:5px solid #AC1A23;">' . "\r\n"; // TOP TEXT $message .= 'Ihre Rechnung für Ihr gebuchtes Paket bei Möbel Mafia.' . "\r\n"; $message .= '</td></tr></table></div>' . "\r\n"; $message .= '<div style="margin-top:15px; width:725px;">' . "\r\n"; $message .= '<div style="margin-left: 15px;">' . "\r\n"; $message .= 'Vielen Dank für Ihre Paketbuchung bei Möbel Mafia.<br /><br />'; $message .= 'Im Anhang finden Sie Ihre persönliche Rechnung.<br /><br />'; $message .= 'Wir wünschen Ihnen viel Freude mit Möbel Mafia!<br />'; $message .= 'Ihr Möbel Mafia-Team<br /><br />'; $message .= '<p style="text-align:center;color:#fff;padding:25px;background:#000;border-top:5px solid #AC1A23;">© Möbel Mafia <a href="http://www.moebel-mafia.com/impressum" target="_blank">Impressum</a></p><br /><br /><br />'; $message .= '</div></div></body></html>'; $mail = new PHPMailer(); $mail->From = '*****@*****.**'; $mail->FromName = utf8_decode('Möbel Mafia'); $mail->Subject = utf8_decode('Ihre Rechnung für die Paketbuchung bei Möbel Mafia.'); $mail->Body = $message; $mail->IsHTML(true); $mail->AddAddress($userData['user_mail']); $mail->AddAttachment($path, 'Ihre_Rechnung.pdf'); return $mail->Send(); }