<?php
session_start();
$nobuk = trim(substr($_GET['id'],0,13));
$yuser = substr($_GET['id'],13);

//$dbase='dbplb';
//if ($yuser=='04') $dbase='dbbta';  
//if ($yuser=='08') $dbase='dbbta';   
//if ($yuser=='09') $dbase='dblht';  
//if ($yuser=='13') $dbase='dbbta';   
//if ($yuser=='24') $dbase='dblht';   
//if ($yuser=='35') $dbase='dbbta';   
//if ($yuser=='38') $dbase='dblht';   
//if ($yuser=='41') $dbase='dbbtg';   
//if ($yuser=='45') $dbase='dbbtg';   
//if ($yuser=='47') $dbase='dbbta';   
//if ($yuser=='fadilbta') $dbase='dbbta';   
//if ($yuser=='fadilbtg') $dbase='dbbtg';   
//if ($yuser=='fadillht') $dbase='dblht';   
//if ($yuser=='S05') $dbase='dbbta';   
//if ($yuser=='syamsul') $dbase='dbbta';   
//if ($yuser=='syamsul2') $dbase='dbbta';   
$_SESSION['yuser']=$yuser;
include "connect.php";	

$_SESSION['dbase1']=$dbase;

//include_once "connect2.php";	

//echo 'inilah-'.$nobuk.'-'.$yuser.'-'.$dbase;
// $_POST['idtransaksi'];
$q20 = "SELECT a.nobukti,a.tgl,(a.tgl+INTERVAL d.hari DAY) as jtgl,a.custno,concat(b.custname,' (',a.custno,')') as nama,b.alamat1,a.kdslm,concat(c.nmslm,'(',a.kdslm,')') as nmslm,
a.netto,a.tbruto,a.disc,a.ppn,a.nppn from somobileheader a
left join customer b on a.custno=b.custno
left join salesman c on a.kdslm=c.kdslm
left join termcustomer d on a.kdterm=d.kdterm
WHERE a.nobukti like '$nobuk' ;";


$hasil20 = mysqli_query($con,$q20);
$data20  = mysqli_fetch_array($hasil20);


$kbukti =$nobuk;
$pteks = explode("," ,$nobuk);
$kata =str_word_count($nobuk,1);
$baris = wordwrap($nobuk, 10, "\r\n", false);

$txtjudul1 ="PT.DISTRINDO MULTIJAYA";
$txtjudul2 ="Jl.Kolonel H.Barlian KM.7 No.233/234 Palembang";
$txtjudul3 ="NPWP :01.780.378.4-307.000";
$txtjudul4 ="Faktur : " . $nobuk . "   Tgl  : " . $data20['tgl'];
$txtjudul5 ="Cust   : " . $data20['nama'];
$txtjudul6 ="Alamat : " . $data20['alamat1'];
$txtjudul7 ="Sales  : " . $data20['nmslm']."   J.Tgl: " . $data20['jtgl'];
$txtjudul8 ="Tgl  : " . $data20['tgl'];
$txtjudul9 ="J.Tgl: " . $data20['jtgl'];
$txtjudul10 ="------------------------------------------------";
$txttutup1="          Total : Rp. ";
$txttutup2="          Disc  : Rp. ";
$txttutup3="          PPN   : Rp. ";
$txttutup4="          NETTO : Rp. ";
$namafile  = $nobuk . ".txt";

header("Content-type: text/plain");
header("Content-Disposition: attachment; filename=$namafile");
echo $txtjudul1 . "\r\n";
echo $txtjudul2 . "\r\n";
echo $txtjudul3 . "\r\n";
echo "\r\n";
echo $txtjudul4 . "\r\n";
echo $txtjudul5 . "\r\n";
echo $txtjudul6 . "\r\n";
echo $txtjudul7 . "\r\n";
echo $txtjudul10 . "\r\n";

// $berkas =fopen($namafile,"w");
$no = 1; // Untuk penomoran tabel, di awal set dengan 1
$q21="select a.kdbrg,b.namabrg1,b.isi1,b.isi2,b.isi3,a.qty,a.hs,(a.qty*a.hs) as bruto,(a.ndisc1+a.ndisc2+a.ndisc3) as ndisc,((a.qty*a.hs)-(a.ndisc1+a.ndisc2+ndisc3)) as netto,

IF(MOD(a.qty,b.isi3)=0,ROUND(a.qty/b.isi3),IF(MOD(a.qty,b.isi2)=0,ROUND(a.qty/b.isi2),ROUND(a.qty))) AS qtyjual,
IF(MOD(a.qty,b.isi3)=0,b.stn1,IF(MOD(a.qty,b.isi2)=0,b.`Stn2`,b.stn3)) AS stnjual,
IF(MOD(a.qty,b.isi3)=0,b.isi3,IF(MOD(a.qty,b.isi2)=0,isi2,isi1)) AS isijual

from somobiledetail a
left join barang b on a.kdbrg=b.kdbrg 
where a.nobukti like '$nobuk';";
$hasil21 = mysqli_query($con,$q21);

	
while($data = mysqli_fetch_array($hasil21)){
	
	echo $data['namabrg1']."\r\n";
	echo $data['qtyjual'].' '.$data['stnjual'].' X '.number_format($data['hs']*$data['isijual']).' = '.number_format($data['bruto']).'-'.number_format($data['ndisc']).' = '.number_format($data['netto'])."\r\n";
	$no++;
}
echo $txtjudul10."\r\n";	

echo "\t".$txttutup1.number_format($data20['tbruto'])."\r\n";	
echo "\t".$txttutup2.number_format($data20['disc'])."\r\n";	
echo "\t".$txttutup3.number_format($data20['nppn'])."\r\n";	
echo "\t".$txttutup4.number_format($data20['netto'])."\r\n";	
echo "\r\n";
echo 'Terima Kasih'. "\r\n";
echo "\r\n";
echo "\r\n";
echo "\r\n";
echo "\r\n";
//fclose($berkas);
?>