160 lines
7.8 KiB
PHP
160 lines
7.8 KiB
PHP
<?php
|
|
|
|
/*******************************************************************
|
|
|
|
App. Name : Inventory Advanced Systems
|
|
Module : /apps/php/repo/jual_harian.php
|
|
Desc. : PHP - Laporan Penjualan Harian
|
|
Created By : Siau Pheng ([email protected]).
|
|
Created Date : June 6th, 2011.
|
|
Last Modified : November 18th, 2023.
|
|
|
|
(c) 2011 - 2023, 3FONIA Software; WWW.3FONIA.COM.
|
|
|
|
*******************************************************************/
|
|
|
|
require_once(__DIR__."/../../../../../vendor/autoload.php");
|
|
require_once(__DIR__."/../func/ias.php");
|
|
require_once(__DIR__."/../func/report.php");
|
|
|
|
use siaupheng\fonia3\DB\MySQL;
|
|
use siaupheng\fonia3\DB\SQL;
|
|
use siaupheng\fonia3\Web\Param;
|
|
use siaupheng\fonia3\Web\Table;
|
|
use siaupheng\fonia3\Web\Form;
|
|
use siaupheng\fonia3\Printer\PrintHTML;
|
|
use siaupheng\fonia3\Data\SimpleXLS;
|
|
|
|
$db = (is_resource($db)) ? $db : new MySQL();
|
|
$ajson = [];
|
|
$data = Param::Get("data");
|
|
|
|
if ( $data == "print" || $data == "export" ) {
|
|
$rekap = Param::Get("Rekap"); // X, 1, 0
|
|
$id_grup = Param::Get("Grup_InvID", 0);
|
|
$tgldata = Param::Get("Tgl_Data");
|
|
|
|
// generate report header
|
|
//$grupheader = ($grup>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('<table width="100%" class="pnormal"><tr><td class="nb" width="10%">Outlet</td><td class="nb" width="40%">: '.$db->Row("Nama_Outlet").'</td><td class="nb" width="10%">No. Nota</td><td class="nb" width="40%">: '.$db->Row("No_Ref").($db->Row("No_Faktur")?" / ".$db->Row("No_Faktur"):"").'</td></tr><tr><td class="nb">Alamat</td><td class="nb">: '.$db->Row("Alamat_Outlet").'</td><td class="nb">Sales</td><td class="nb">: '.$db->Row("Nama_Sales").'</td></tr></table>',6,"L"));
|
|
$pre->show_fields();
|
|
}
|
|
$pre->add_value( $nomor++, $db->Row("Nama_Produk").(($db->Row("Nama_Rasa"))?" (".$db->Row("Nama_Rasa").")":"").(($db->Row("Promo")>0)?" ***":""), uang($db->Row("Qty1"),2), $db->Row("Nama_Satuan"), $db->Row("Harga_Jual"), $db->Row("Sub_Total") );
|
|
$no_ref = $db->Row("No_Ref");
|
|
$sub = $db->Row("Total_Jual");
|
|
$dis = $db->Row("Total_Diskon");
|
|
}
|
|
if ($nomor > 1) {
|
|
$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_stamp(1, true);
|
|
$pre->show();
|
|
|
|
} else if ( $data == "export" ) {
|
|
$xls = new SimpleXLS([
|
|
'title'=>"Laporan Penjualan Detail Harian",
|
|
'subject'=>"PT.PMS",
|
|
'desc'=>"Export Data dari IAS"
|
|
]);
|
|
$xls->add_header("<b>".strtoupper($_SESSION['__WEB_APP']['REG_NAME'])."</b>");
|
|
$xls->add_header("<b>LAPORAN PENJUALAN DETAIL HARIAN</b>");
|
|
$xls->add_header($tglheader);
|
|
|
|
$xls->add_field("NO", 8, "C");
|
|
$xls->add_field("NAMA PRODUK", 50, "L");
|
|
$xls->add_field("QTY", 8, "R,N");
|
|
$xls->add_field("SATUAN", 13, "L");
|
|
$xls->add_field("HARGA @", 13, "R,N0");
|
|
$xls->add_field("TOTAL", 13, "R,N0");
|
|
$xls->add_sheet("PENJ.DET-HARIAN", false);
|
|
|
|
$nomor = 1; $no_ref = ""; $sub = 0; $dis = 0;
|
|
while ($db->Next()) {
|
|
if ($no_ref <> $db->Row("No_Ref")) {
|
|
if ($no_ref <> "") {
|
|
if ($dis > 0) {
|
|
$xls->add_span(array("Sub. Total Rp.",4,"R,B"),array($sub,2,"R,B,N0"));
|
|
$xls->add_span(array("Diskon Rp.",4,"R,B"),array($dis,2,"R,B,N0"));
|
|
}
|
|
$xls->add_span(array("TOTAL Rp.",4,"R,B"),array($sub-$dis,2,"R,B,N0"));
|
|
$xls->add_empty_row();
|
|
$sub = $dis = 0;
|
|
$nomor = 1;
|
|
}
|
|
$xls->add_span(array("Outlet",1,"L"),array($db->Row("Nama_Outlet"),2,"L"),array("No. Nota",1,"L"),array($db->Row("No_Ref"),1,"L"),array($db->Row("No_Faktur"),1,"L"));
|
|
$xls->add_span(array("Alamat",1,"L"),array($db->Row("Alamat_Outlet"),2,"L"),array("Sales",1,"L"),array($db->Row("Nama_Sales"),1,"L"),array("",1,"L"));
|
|
$xls->show_headers();
|
|
}
|
|
$xls->add_value($nomor++, $db->Row("Nama_Produk").(($db->Row("Nama_Rasa"))?" (".$db->Row("Nama_Rasa").")":"").(($db->Row("Promo")>0)?" ***":""), $db->Row("Qty1"), $db->Row("Nama_Satuan"), $db->Row("Harga_Jual"), $db->Row("Sub_Total"));
|
|
$no_ref = $db->Row("No_Ref");
|
|
$sub += $db->Row("Sub_Total");
|
|
$dis = $db->Row("Total_Diskon");
|
|
}
|
|
if ($nomor > 1) {
|
|
if ($dis > 0) {
|
|
$xls->add_span(array("Sub. Total Rp.",4,"R,B"),array($sub,2,"R,B,N0"));
|
|
$xls->add_span(array("Diskon Rp.",4,"R,B"),array($dis,2,"R,B,N0"));
|
|
}
|
|
$xls->add_span(array("TOTAL Rp.",4,"R,B"),array($sub-$dis,2,"R,B,N0"));
|
|
}
|
|
|
|
$xls->send("Laporan Penjualan Detail Harian.xlsx");
|
|
unset($xls);
|
|
|
|
} else if ( $data == "default") {
|
|
$form = new Form($db);
|
|
$trekap = $form->radio("_", "Rekap", "X", true, false, ["1"=>"Antar","0"=>"Belum Antar","X"=>"Semua"]);
|
|
$tgrup = $form->option_db("_", "Grup_InvID", 0, true, false, "inv_produk_grup", ["Grup_InvID","Nama_Grup"], "TRUE ORDER BY Nama_Grup", [0,"SEMUA GRUP"]);
|
|
$ttgldata = $form->datebox("_", "Tgl_Data", tgl_ymd(), true, false);
|
|
echo '
|
|
<div class="row mb-1">
|
|
<label class="col-sm-5 col-lg-3 col-form-label" for="Rekap">Status Order</label>
|
|
<div class="col">'.$trekap.'</div>
|
|
</div>
|
|
<div class="row mb-1">
|
|
<label class="col-sm-5 col-lg-3 col-form-label" for="Grup_InvID">Grup Produk</label>
|
|
<div class="col">'.$tgrup.'</div>
|
|
</div>
|
|
<div class="row mb-1"><div class="col"><hr class="my-1"></div></div>
|
|
<div class="row mb-1">
|
|
<label class="col-sm-5 col-lg-3 col-form-label" for="Tgl_Data">Tanggal Faktur</label>
|
|
<div class="col">'.$ttgldata.'</div>
|
|
</div>';
|
|
|
|
}
|
|
|
|
?>
|