MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */ require_once '../../include/phprechnung.inc.php'; define('FPDF_FONTPATH', '../../include/font/'); define('EUR', chr(128)); require_once 'mc_table.php'; $pdf = new PDF_MC_Table(); $pdf->Open(); $pdf->AddPage(); $pdf->AliasNbPages(); $pdf->SetY(45); $pdf->SetFont($PDFFont, '', $PDFFontsize1); require_once 'pos_pdf.inc.php'; $pdf->Ln(); $pdf->SetFont($PDFFont, '', $PDFFontsize2); $pdf->SetWidths(array(50, 30)); $pdf->SetAligns(array('L', 'R')); // Total amount // if (isset($CompanyCurrency) && $CompanyCurrency == 'EUR') { $Currency = EUR; } else { $Currency = $CompanyCurrency; } if (isset($Type) && $Type == 'Booking_Details' or $Type == 'Customer_Booking_Details') { $pdf->SetFont($PDFFont, 'BU');
$pdf->SetX(7.25); $qcb = mysql_query("select id, gudang from gl_gudang where area = '{$idarea}' order by gudang asc") or die(mysql_error()); $jqcb = mysql_num_rows($qcb); if ($jqcb == '0') { $pdf->Cell(1, 1, "", 1, 0, 'C'); } else { while (list($idgudang, $namagudang) = mysql_fetch_row($qcb)) { $pdf->Cell(1, 1, "CORP", 1, 0, 'C'); $pdf->Cell(1, 1, "RTL", 1, 0, 'C'); $pdf->Cell(1, 1, "TK", 1, 0, 'C'); $pdf->Cell(1, 1, "UGC", 1, 0, 'C'); } } } $h = 0; $pdf->SetY(7.3); $pdf->SetFont('Arial', '', 9); //ISI TABEL $str = "select distinct a.merk, b.merk, a.tipekendaraan, c.tipekendaraan, a.jeniskendaraan, d.jeniskendaraan from gl_masterkendaraan as a left join gl_merkkendaraan as b on (a.merk=b.id) left join gl_tipekendaraan as c on (a.tipekendaraan=c.id) inner join gl_jeniskendaraan as d on (a.jeniskendaraan=d.id) "; //echo $str; if ($area != '') { $str .= " where a.area='{$area}'"; } $str .= " order by a.merk asc "; //echo $str; $query = mysql_query($str) or die(mysql_error()); //print_r($str); $no = 1; while (list($idmerk, $merk, $idtipe, $tipe, $idjenis, $jenis) = mysql_fetch_array($query)) { $pdf->SetX(0.25); /*$pdf->SetWidths(array(1,2,2,2));
$getquerykorporate = str_replace("+", " ", $_GET[query_korporate]); //instansiasi fpdf $pdf = new PDF_MC_Table('L', 'cm', 'A4'); $pdf->AliasNbPages(); $pdf->AddPage(); $pdf->SetMargins(0.7, 0.7, 0.7, 0.7); #tampilkan judul laporan $pdf->SetFont('Arial', 'B', '16'); $pdf->Cell(0, 0, "CIPAGANTI RENTAL CAR & TRAVEL", '0', 1, 'C'); $pdf->Cell(0, 2, "HASIL SEWA KENDARAAN", '0', 1, 'C'); $pdf->SetFont('Arial', 'B', '12'); $pdf->Cell(3, 3, "CABANG : " . $gudang, 0, 0, 'L'); $pdf->Cell(25.2, 3, "PERIODE : " . DateToIndo($mulai) . " - " . DateToIndo($akhir), 0, 0, 'R'); //membuat kop tabel $y = $pdf->GetY(); $pdf->SetY($y + 2.5); $pdf->SetFont('Arial', 'B', 11); $pdf->SetWidths(array(2.3, 2.5, 2.5, 2.5, 3.7, 2.2, 2.2, 2.6, 2.6, 2.6, 2.6)); $pdf->SetHeight(0.1); $pdf->SetAligns(array('C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C')); $pdf->Row(array("CSO", "Berangkat", "No. Order", "No. Kendaraan", "Merk Kendaraan", "Periode Awal", "Periode Akhir", "Customer", "T.Sewa", "T.Bayar", "Piutang")); $pdf->SetFont('Arial', 'B', 9); $pdf->SetWidths(array(28.3)); $pdf->Row(array("SEWA KENDARAAN RETAIL")); //ISI TABEL $pdf->SetFont('Arial', '', 9); $pdf->SetWidths(array(2.3, 2.5, 2.5, 2.5, 3.7, 2.2, 2.2, 2.6, 2.6, 2.6, 2.6)); $pdf->SetHeight(0.1); $pdf->SetAligns(array('C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C')); $query_data = $getquery; $query = mysql_query($query_data) or die("Query gagal");
You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */ require_once 'phprechnung.inc.php'; define('FPDF_FONTPATH', 'font/'); define('EUR', chr(128)); require_once 'mc_table.php'; $pdf = new PDF_MC_Table(); $pdf->Open(); $pdf->AddPage(); $pdf->AliasNbPages(); if (isset($METHOD_OF_PAY_DATE) && $METHOD_OF_PAY_DATE != 0) { if ($Type != 'DeliveryNote') { $pdf->SetY(140); } else { $pdf->SetY(135); } } else { $pdf->SetY(135); } $pdf->SetFont($PDFFont, '', $PDFFontsize1); require_once 'pos_pdf.inc.php'; $pdf->Ln(5); $pdf->SetFont($PDFFont, '', $PDFFontsize2); $pdf->SetWidths(array(170, 25)); $pdf->SetAligns(array('R', 'R')); // See if the company currency is set to EUR end print the Euro char // if ($CompanyCurrency == 'EUR') {