0) ? " - ".fastQuery("SELECT UPPER(Nama_Grup) Nama FROM inv_produk_grup WHERE Grup_InvID=".$grup, "") : "";
$tglheader = "Periode : ".$tgldata;
$tgldata = tgl_sql2str($tgldata);
$tsql = ($rekap<>"X") ? " AND Rekap=".intval($rekap) : "";
$tsql2 = ($id_grup>0) ? " WHERE P.Grup_InvID=".$id_grup : "";
$db->Query("SELECT D.No_Ref,D.Promo,D.Harga_Jual,P.Nama_Produk,S.Nama_Satuan,R.Nama_Rasa,SUM(-D.Qty) Qty1,SUM(-D.Qty*D.Harga_Jual) Sub_Total,J.No_Faktur,O.Nama_Outlet,O.Alamat_Outlet,L.Nama_Pegawai Nama_Sales,J.Total_Jual,J.Total_Diskon FROM (SELECT * FROM inv_detail WHERE No_Ref IN (SELECT No_Jual FROM inv_jual WHERE Data_Jual=1 AND Tgl_Jual='".$tgldata."'".$tsql.")) D LEFT JOIN (SELECT * FROM inv_jual WHERE Data_Jual=1 AND Tgl_Jual='".$tgldata."'".$tsql.") J ON (J.No_Jual=D.No_Ref) LEFT JOIN para_outlet O ON (O.OutletID=J.OutletID) LEFT JOIN para_pegawai L ON (L.PegID=J.SalesID) LEFT JOIN inv_produk P ON (P.InvID=D.InvID) LEFT JOIN para_satuan S ON (D.SatuanID=S.SatuanID) LEFT JOIN para_rasa R ON (R.RasaID=D.RasaID)".$tsql2." GROUP BY D.No_Ref, D.InvID, D.RasaID, D.SatuanID, D.Harga_Jual ORDER BY D.No_Ref, D.Promo, P.Pajak DESC, P.Nama_Produk");
}
if ( $data == "print" ) {
Report_Header("LAPORAN PENJUALAN DETAIL HARIAN", $tglheader);
$pre = new PrintHTML();
$pre->set_css("garis");
$pre->add_field("NO.", 40, "C", "uang");
$pre->add_field("NAMA PRODUK", 320);
$pre->add_field("QTY", 60, "R");
$pre->add_field("SATUAN", 80);
$pre->add_field("HARGA @", 90, "R", "uang");
$pre->add_field("TOTAL", 90, "R", "uang");
$nomor = 1; $no_ref = ""; $sub = $dis = 0;
while ($db->Next()) {
if ($no_ref <> $db->Row("No_Ref")) {
if ($no_ref <> "") {
$pre->add_span(array("Sub. Total Rp.",4,"R,B"),array($sub,2,"R,B","uang"));
$pre->add_span(array("Diskon Rp.",4,"R,B"),array($dis,2,"R,B","uang"));
$pre->add_span(array("Total Rp.",4,"R,B"),array($sub-$dis,2,"R,B","uang"));
$pre->add_span(array(" ",6,"L,NB"));
$sub = $dis = 0;
$nomor = 1;
}
$pre->add_span(array('