INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20250910-0001','1','B1D-YIXF-178-0','1','0.800','0.800','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1D-YIXF-178-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1D-YIXF-178-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2025-09-10 07:50:56' WHERE kode_barang='B1D-YIXF-178-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1D-YIXF-178-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-09-10 07:50:56','TOKO','SMBK-B','B1D','B1D-YIXF-178-0','1','0.800','0.800','1','0.800','0.800','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1D-YIXF-178-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1D-YIXF-178-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250910-0001','2025-09-10','07:50','0.800','input','2025-09-10 07:50:56');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20250910-0001','1','E1D-YFBA-86-0','1','2.590','2.590','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-YFBA-86-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-YFBA-86-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-09-10 07:51:15' WHERE kode_barang='E1D-YFBA-86-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-YFBA-86-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-09-10 07:51:15','TOKO','SMBK-E','E1D','E1D-YFBA-86-0','1','2.590','2.590','1','2.590','2.590','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-YFBA-86-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-YFBA-86-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250910-0001','2025-09-10','07:51','2.590','input','2025-09-10 07:51:15');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20250910-0001','1','F3E-YIXA-44-0','1','1.060','1.060','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YIXA-44-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YIXA-44-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2025-09-10 07:51:35' WHERE kode_barang='F3E-YIXA-44-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YIXA-44-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-09-10 07:51:35','TOKO','SMBK-F','F3E','F3E-YIXA-44-0','1','1.060','1.060','1','1.060','1.060','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-YIXA-44-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YIXA-44-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250910-0001','2025-09-10','07:51','1.060','input','2025-09-10 07:51:34');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20250910-0001','1','PDG-XHBH-99-0','1','0.760','0.760','TOKO','SSBK-P','TOKO','SMBK-P');
DELETE FROM tm_barang WHERE kode_barang='PDG-XHBH-99-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PDG-XHBH-99-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-P',tgl_last_beli='2025-09-10 07:52:00' WHERE kode_barang='PDG-XHBH-99-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PDG-XHBH-99-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-09-10 07:52:00','TOKO','SMBK-P','PDG','PDG-XHBH-99-0','1','0.760','0.760','1','0.760','0.760','100.00');
DELETE FROM tm_dept WHERE kode_dept='PDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PDG-XHBH-99-0';
DELETE FROM tm_barang_export WHERE kode_barang='PDG-XHBH-99-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250910-0001','2025-09-10','07:51','0.760','input','2025-09-10 07:52:00');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20250910-0001','1','H3J-YEXA-120-0','1','3.010','3.010','TOKO','SBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H3J-YEXA-120-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H3J-YEXA-120-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2025-09-10 07:54:37' WHERE kode_barang='H3J-YEXA-120-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H3J-YEXA-120-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-09-10 07:54:37','TOKO','SMBK-H','H3J','H3J-YEXA-120-0','1','3.010','3.010','1','3.010','3.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='H3J' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H3J' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MJ' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MJ' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H3J-YEXA-120-0';
DELETE FROM tm_barang_export WHERE kode_barang='H3J-YEXA-120-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250910-0001','2025-09-10','07:54','3.010','input','2025-09-10 07:54:36');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225100838321','kasir','1',' MEF3 UB ','TOKO','SMBK-F','F3E-YIXD-4-T','GL TRIXIE SERUT MODEL DAUN VAR UB 8K ','OL H','1.440','1','100.00','1296000','0','0','15000','1304000','0','14000','0','1318000','NS','T0072856','F3E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YIXD-4-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.440',berat_jual_asli=berat_jual_asli+'1.440',stock_jual='1',berat_akhir=berat_akhir-'1.440',berat_akhir_asli=berat_akhir_asli-'1.440',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='F3E-YIXD-4-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225100838321','2025-09-10','1.440','2025-09-10','08:38:33','PLG0072465','1304000','1304000','14000','1318000','1318000','kasir','2025-09-10 08:38:32','F22510083832');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225100838321','2025-09-10','08:38:33','NS','1318000','14000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0002','D','2025-09-10','08:38:33','kasir','PENJUALAN','F225100838321','109227000','1318000','110545000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1318000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225100838321' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225100838322','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-YIXH-10-T','GL FLIK MODEL ARESO VAR HW 8K ','OL H','2.520','1','100.00','2268000','0','0','15000','2281000','0','25000','0','2306000','NS','T0073019','F3E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YIXH-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.520',berat_jual_asli=berat_jual_asli+'2.520',stock_jual='1',berat_akhir=berat_akhir-'2.520',berat_akhir_asli=berat_akhir_asli-'2.520',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='F3E-YIXH-10-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225100838322','2025-09-10','2.520','2025-09-10','08:38:33','PLG0072466','2281000','2281000','25000','2306000','2306000','kasir','2025-09-10 08:38:32','F22510083832');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225100838322','2025-09-10','08:38:33','NS','2306000','25000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0003','D','2025-09-10','08:38:33','kasir','PENJUALAN','F225100838322','110545000','2306000','112851000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2306000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225100838322' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225100838323','kasir',' 1',' MEE1 6K CM','TOKO','SMBK-E','E1E-YIXC-36-T','CC MODEL PITA PASIR VAR CM 15 8K ','OL H','0.810','1','100.00','729000','0','0','15000','736000','0','10000','0','746000','NS','T0072851','E1E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YIXC-36-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.810',berat_jual_asli=berat_jual_asli+'0.810',stock_jual='1',berat_akhir=berat_akhir-'0.810',berat_akhir_asli=berat_akhir_asli-'0.810',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='E1E-YIXC-36-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225100838323','2025-09-10','0.810','2025-09-10','08:38:33','PLG0072467','736000','736000','10000','746000','746000','kasir','2025-09-10 08:38:32','F22510083832');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225100838323','2025-09-10','08:38:33','NS','746000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0004','D','2025-09-10','08:38:33','kasir','PENJUALAN','F225100838323','112851000','746000','113597000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='746000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225100838323' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225100838324','kasir',' 1',' MEE1 6K CM','TOKO','SMBK-E','E1E-YIXC-37-T','CC MODEL PITA PASIR VAR CM 15 8K ','OL H','0.800','1','100.00','720000','0','0','15000','727000','0','10000','0','737000','NS','T0072852','E1E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YIXC-37-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='E1E-YIXC-37-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225100838324','2025-09-10','0.800','2025-09-10','08:38:33','PLG0072468','727000','727000','10000','737000','737000','kasir','2025-09-10 08:38:32','F22510083832');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225100838324','2025-09-10','08:38:33','NS','737000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0005','D','2025-09-10','08:38:33','kasir','PENJUALAN','F225100838324','113597000','737000','114334000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='737000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225100838324' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225100838325','kasir',' 1',' MEE2 CM 16','TOKO','SMBK-E','E2E-YIXC-27-T','CC MODEL HATI MATA VAR CM 16 8K ','OL H','0.800','1','100.00','720000','0','0','15000','727000','0','10000','0','737000','NS','T0072842','E2E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YIXC-27-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='E2E-YIXC-27-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225100838325','2025-09-10','0.800','2025-09-10','08:38:33','PLG0072469','727000','727000','10000','737000','737000','kasir','2025-09-10 08:38:32','F22510083832');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225100838325','2025-09-10','08:38:33','NS','737000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0006','D','2025-09-10','08:38:33','kasir','PENJUALAN','F225100838325','114334000','737000','115071000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='737000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225100838325' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225100838326','kasir',' 1',' MEE1 6K CM','TOKO','SMBK-E','E2E-YIXB-60-T','CC MODEL PITA PASIR VAR CM 11 8K ','OL H','0.770','1','100.00','693000','0','0','15000','700000','0','10000','0','710000','NS','T0072804','E2E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YIXB-60-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.770',berat_jual_asli=berat_jual_asli+'0.770',stock_jual='1',berat_akhir=berat_akhir-'0.770',berat_akhir_asli=berat_akhir_asli-'0.770',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='E2E-YIXB-60-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225100838326','2025-09-10','0.770','2025-09-10','08:38:33','PLG0072470','700000','700000','10000','710000','710000','kasir','2025-09-10 08:38:32','F22510083832');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225100838326','2025-09-10','08:38:33','NS','710000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0007','D','2025-09-10','08:38:33','kasir','PENJUALAN','F225100838326','115071000','710000','115781000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='710000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225100838326' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225100838327','kasir',' 1',' MEE2 CM 12','TOKO','SMBK-E','E2E-YIXB-53-T','CC MODEL HATI MATA VAR CM 12 8K ','OL H','0.700','1','100.00','630000','0','0','15000','636000','0','10000','0','646000','NS','T0072797','E2E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YIXB-53-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.700',berat_jual_asli=berat_jual_asli+'0.700',stock_jual='1',berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='E2E-YIXB-53-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225100838327','2025-09-10','0.700','2025-09-10','08:38:33','PLG0072471','636000','636000','10000','646000','646000','kasir','2025-09-10 08:38:32','F22510083832');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225100838327','2025-09-10','08:38:33','NS','646000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0008','D','2025-09-10','08:38:33','kasir','PENJUALAN','F225100838327','115781000','646000','116427000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='646000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225100838327' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225100838328','kasir',' 1',' MEE2 CM 10','TOKO','SMBK-E','E2E-YIXC-26-T','CC MODEL HATI MATA VAR CM 10 8K ','OL H','0.630','1','100.00','567000','0','0','15000','571000','0','10000','0','581000','NS','T0072841','E2E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YIXC-26-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.630',berat_jual_asli=berat_jual_asli+'0.630',stock_jual='1',berat_akhir=berat_akhir-'0.630',berat_akhir_asli=berat_akhir_asli-'0.630',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='E2E-YIXC-26-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225100838328','2025-09-10','0.630','2025-09-10','08:38:33','PLG0072472','571000','571000','10000','581000','581000','kasir','2025-09-10 08:38:32','F22510083832');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225100838328','2025-09-10','08:38:33','NS','581000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0009','D','2025-09-10','08:38:33','kasir','PENJUALAN','F225100838328','116427000','581000','117008000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='581000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225100838328' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225100838329','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E2E-YIXB-57-T','CC MODEL PASIR SLEP VAR CM 14 8K ','OL H','0.550','1','100.00','495000','0','0','15000','498000','0','10000','0','508000','NS','T0072801','E2E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YIXB-57-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='E2E-YIXB-57-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225100838329','2025-09-10','0.550','2025-09-10','08:38:33','PLG0072473','498000','498000','10000','508000','508000','kasir','2025-09-10 08:38:32','F22510083832');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225100838329','2025-09-10','08:38:33','NS','508000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0010','D','2025-09-10','08:38:33','kasir','PENJUALAN','F225100838329','117008000','508000','117516000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='508000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225100838329' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225100840281','kasir','1',' MEE2 LG 8 ','TOKO','SMBK-E','E2E-YGCX-58-T','CC MODEL MATA VAR LG 8 8K ','OL H','0.550','1','100.00','495000','0','0','15000','498000','0','10000','0','508000','NS','T0071723','E2E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YGCX-58-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='E2E-YGCX-58-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225100840281','2025-09-10','0.550','2025-09-10','08:40:29','PLG0072474','498000','498000','10000','508000','508000','kasir','2025-09-10 08:40:28','F22510084028');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225100840281','2025-09-10','08:40:29','NS','508000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250910-0011','D','2025-09-10','08:40:29','kasir','PENJUALAN','F225100840281','117516000','508000','118024000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225100903091','kasir','1',' MDE2 LG 12','TOKO','SMBK-E','E2D-YIXH-48-T','CC MODEL DAUN MATA VAR LG 12 8K ','OL','0.950','1','100.00','839000','0','0','15000','870000','0','5000','0','875000','NS','T0073057','E2D','0','0','-','0','883000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIXH-48-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='E2D-YIXH-48-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225100903091','2025-09-10','0.950','2025-09-10','09:03:10','PLG0072475','870000','870000','5000','875000','875000','kasir','2025-09-10 09:03:09','F22510090309');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225100903091','2025-09-10','09:03:10','NS','875000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0012','D','2025-09-10','09:03:10','kasir','PENJUALAN','F225100903091','118024000','875000','118899000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='875000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225100903091' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225100903092','kasir',' 1',' MEE1 LG 11','TOKO','SMBK-E','E1E-YIXH-32-T','CC MODEL HATI SLEP VAR LG 11 8K ','OL','0.530','1','100.00','477000','0','0','15000','485000','0','5000','0','490000','NS','T0073041','E1E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YIXH-32-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='E1E-YIXH-32-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225100903092','2025-09-10','0.530','2025-09-10','09:03:10','PLG0072476','485000','485000','5000','490000','490000','kasir','2025-09-10 09:03:09','F22510090309');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225100903092','2025-09-10','09:03:10','NS','490000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0013','D','2025-09-10','09:03:10','kasir','PENJUALAN','F225100903092','118899000','490000','119389000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='490000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225100903092' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101020021','kasir','1',' TFD1 X BG ','TOKO','TBK-D','D1TF-WCBI-74-T','LT X SLOBOK BULAT HURUF BG F ','','0.720','1','100.00','1161000','0','0','15000','1168000','0','0','0','1168000','TIN','T0043044','D1TF','0','0','-','0','1612000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1TF-WCBI-74-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.720',berat_jual_asli=berat_jual_asli+'0.720',stock_jual='1',berat_akhir=berat_akhir-'0.720',berat_akhir_asli=berat_akhir_asli-'0.720',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='D1TF-WCBI-74-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101020021','2025-09-10','0.720','2025-09-10','10:20:03','PLG0072477','1168000','1168000','0','1168000','1168000','kasir','2025-09-10 10:20:02','F22510102002');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101020021','2025-09-10','10:20:03','TIN','1168000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0014','D','2025-09-10','10:20:03','kasir','PENJUALAN','F225101020021','119389000','1168000','120557000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1168000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101020021' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101020022','kasir',' 1',' TFD1 X BG ','TOKO','TBK-D','D1TF-WJBE-8-T','LT X SLOBOK BULAT HURUF BG S ','','0.850','1','100.00','1370000','0','0','15000','1379000','0','0','0','1379000','TIN','T0049974','D1TF','0','0','-','0','1612000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1TF-WJBE-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.850',berat_jual_asli=berat_jual_asli+'0.850',stock_jual='1',berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='D1TF-WJBE-8-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101020022','2025-09-10','0.850','2025-09-10','10:20:03','PLG0072478','1379000','1379000','0','1379000','1379000','kasir','2025-09-10 10:20:02','F22510102002');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101020022','2025-09-10','10:20:03','TIN','1379000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0015','D','2025-09-10','10:20:03','kasir','PENJUALAN','F225101020022','120557000','1379000','121936000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1379000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101020022' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101025231','kasir','1',' MFF3 UB ','TOKO','SMBK-F','F3F-YHXH-71-T','GL KOREA UB 8K ','','0.450','1','100.00','413000','0','0','15000','413000','0','0','0','413000','RHM','T0072171','F3F','0','0','-','0','917000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YHXH-71-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='F3F-YHXH-71-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101025231','2025-09-10','0.450','2025-09-10','10:25:23','PLG0072479','413000','413000','0','413000','413000','kasir','2025-09-10 10:25:23','F22510102523');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101025231','2025-09-10','10:25:23','RHM','413000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250910-0016','D','2025-09-10','10:25:23','kasir','PENJUALAN','F225101025231','121936000','413000','122349000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101030471','kasir','1',' MEE2 HW 17','TOKO','SMBK-E','E2E-YHXG-93-T','CC MODEL MATA VAR HW 17 8K ','OL','0.460','1','100.00','414000','0','0','15000','421000','0','5000','0','426000','TJ','T0072080','E2E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YHXG-93-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='E2E-YHXG-93-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101030471','2025-09-10','0.460','2025-09-10','10:30:48','PLG0072480','421000','421000','5000','426000','426000','kasir','2025-09-10 10:30:47','F22510103047');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101030471','2025-09-10','10:30:48','TJ','426000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0017','D','2025-09-10','10:30:48','kasir','PENJUALAN','F225101030471','122349000','426000','122775000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='426000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101030471' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101030472','kasir',' 1',' MEE2 LG 11','TOKO','SMBK-E','E2E-YIXH-37-T','CC MODEL MATA VAR LG 11 8K ','OL','0.550','1','100.00','495000','0','0','15000','503000','0','5000','0','508000','TJ','T0073046','E2E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YIXH-37-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='E2E-YIXH-37-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101030472','2025-09-10','0.550','2025-09-10','10:30:48','PLG0072481','503000','503000','5000','508000','508000','kasir','2025-09-10 10:30:47','F22510103047');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101030472','2025-09-10','10:30:48','TJ','508000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0018','D','2025-09-10','10:30:48','kasir','PENJUALAN','F225101030472','122775000','508000','123283000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='508000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101030472' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101030473','kasir',' 1',' MEH1 UB 45','TOKO','SMBK-H','H1E-YHXF-56-T','KL RANTAI HOLLOW UB 45CM 8K ','OL','0.860','1','100.00','774000','0','0','15000','787000','0','5000','0','792000','TJ','T0071948','H1E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YHXF-56-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.860',berat_jual_asli=berat_jual_asli+'0.860',stock_jual='1',berat_akhir=berat_akhir-'0.860',berat_akhir_asli=berat_akhir_asli-'0.860',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='H1E-YHXF-56-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101030473','2025-09-10','0.860','2025-09-10','10:30:48','PLG0072482','787000','787000','5000','792000','792000','kasir','2025-09-10 10:30:47','F22510103047');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101030473','2025-09-10','10:30:48','TJ','792000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0019','D','2025-09-10','10:30:48','kasir','PENJUALAN','F225101030473','123283000','792000','124075000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='792000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101030473' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101030474','kasir',' 1',' MEH1 UB 45','TOKO','SMBK-H','H1E-YHXF-50-T','KL RANTAI HOLLOW UB 45CM 8K ','OL','0.860','1','100.00','774000','0','0','15000','787000','0','5000','0','792000','TJ','T0071942','H1E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YHXF-50-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.860',berat_jual_asli=berat_jual_asli+'0.860',stock_jual='1',berat_akhir=berat_akhir-'0.860',berat_akhir_asli=berat_akhir_asli-'0.860',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='H1E-YHXF-50-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101030474','2025-09-10','0.860','2025-09-10','10:30:48','PLG0072483','787000','787000','5000','792000','792000','kasir','2025-09-10 10:30:47','F22510103047');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101030474','2025-09-10','10:30:48','TJ','792000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0020','D','2025-09-10','10:30:48','kasir','PENJUALAN','F225101030474','124075000','792000','124867000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='792000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101030474' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101050211','kasir','1',' MEF3E X HW','TOKO','SMBK-F','F3E-YFBH-90-0','GL X KAKI SANTA CAT HITAM HW 8K ','OL ','2.550','1','100.00','2295000','0','0','15000','2320000','0','13000','0','2333000','RHM','00358798','F3E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YFBH-90-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.550',berat_jual_asli=berat_jual_asli+'2.550',stock_jual='1',berat_akhir=berat_akhir-'2.550',berat_akhir_asli=berat_akhir_asli-'2.550',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='F3E-YFBH-90-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101050211','2025-09-10','2.550','2025-09-10','10:50:22','PLG0072484','2320000','2320000','13000','2333000','2333000','kasir','2025-09-10 10:50:21','F22510105021');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101050211','2025-09-10','10:50:22','RHM','2333000','13000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250910-0021','D','2025-09-10','10:50:22','kasir','PENJUALAN','F225101050211','124867000','2333000','127200000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101050551','kasir','1',' MEB1 LG PE','TOKO','SMBK-B','B1E-YIXH-77-T','GW TUSUK MODEL MATA VAR LG PE 8K ','OL ','0.570','1','100.00','513000','0','0','15000','522000','0','5000','0','527000','RHM','T0073086','B1E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YIXH-77-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='B1E-YIXH-77-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101050551','2025-09-10','0.570','2025-09-10','10:50:56','PLG0072485','522000','522000','5000','527000','527000','kasir','2025-09-10 10:50:55','F22510105055');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101050551','2025-09-10','10:50:56','RHM','527000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250910-0022','D','2025-09-10','10:50:56','kasir','PENJUALAN','F225101050551','127200000','527000','127727000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101051551','kasir','1',' TEB1 X CM ','TOKO','TBK-B','B1TE-WFBX-13-T','GW X TUSUK MODEL DOLPHIN CM PE ','OL ','1.020','1','100.00','1627000','0','0','15000','1645000','0','7000','0','1652000','RHM','T0045359','B1TE','0','0','-','0','1595000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1TE-WFBX-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='B1TE-WFBX-13-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101051551','2025-09-10','1.020','2025-09-10','10:51:55','PLG0072486','1645000','1645000','7000','1652000','1652000','kasir','2025-09-10 10:51:55','F22510105155');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101051551','2025-09-10','10:51:55','RHM','1652000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250910-0023','D','2025-09-10','10:51:55','kasir','PENJUALAN','F225101051551','127727000','1652000','129379000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101052261','kasir','1',' TEF3 X 20K','TOKO','TBK-F','F3TE-YIXD-87-T','GL X FLIK BUNGA CLOVER VAR YT 17K ','OL ','2.860','1','100.00','4562000','0','0','15000','4613000','0','20000','0','4633000','RHM','T0072939','F3TE','0','0','-','0','1595000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-YIXD-87-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.860',berat_jual_asli=berat_jual_asli+'2.860',stock_jual='1',berat_akhir=berat_akhir-'2.860',berat_akhir_asli=berat_akhir_asli-'2.860',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='F3TE-YIXD-87-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101052261','2025-09-10','2.860','2025-09-10','10:52:26','PLG0072487','4613000','4613000','20000','4633000','4633000','kasir','2025-09-10 10:52:26','F22510105226');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101052261','2025-09-10','10:52:26','RHM','4633000','20000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250910-0024','D','2025-09-10','10:52:26','kasir','PENJUALAN','F225101052261','129379000','4633000','134012000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101054041','kasir','1',' TGF3 HW ','TOKO','TBK-F','F3TG-YAAA-114-T','GL MODEL SANTA VAR HW 17K ','OL','2.170','1','100.00','3535000','0','0','15000','3575000','0','15000','0','3590000','NS','T0065934','F3TG','0','0','-','0','1629000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TG-YAAA-114-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.170',berat_jual_asli=berat_jual_asli+'2.170',stock_jual='1',berat_akhir=berat_akhir-'2.170',berat_akhir_asli=berat_akhir_asli-'2.170',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='F3TG-YAAA-114-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101054041','2025-09-10','2.170','2025-09-10','10:54:05','PLG0072488','3575000','3575000','15000','3590000','3590000','kasir','2025-09-10 10:54:04','F22510105404');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101054041','2025-09-10','10:54:05','NS','3590000','15000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250910-0025','D','2025-09-10','10:54:05','kasir','PENJUALAN','F225101054041','134012000','3590000','137602000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101055031','kasir','1',' MFH1 UB ','TOKO','SMBK-H','H1F-YHXF-18-T','KL TRIXIE MODEL BOTEGA VAR UB 8K ','OL','1.070','1','100.00','981000','0','0','15000','992000','0','5000','0','997000','NS','T0071910','H1F','0','0','-','0','917000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YHXF-18-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='H1F-YHXF-18-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101055031','2025-09-10','1.070','2025-09-10','10:55:04','PLG0072489','992000','992000','5000','997000','997000','kasir','2025-09-10 10:55:03','F22510105503');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101055031','2025-09-10','10:55:04','NS','997000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0026','D','2025-09-10','10:55:04','kasir','PENJUALAN','F225101055031','137602000','997000','138599000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='997000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101055031' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101055032','kasir',' 1',' MFH1 UB ','TOKO','SMBK-H','H1F-YHXF-21-T','KL TRIXIE MODEL BOTEGA VAR UB 8K ','OL','1.110','1','100.00','1018000','0','0','15000','1029000','0','6000','0','1035000','NS','T0071913','H1F','0','0','-','0','917000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YHXF-21-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.110',berat_jual_asli=berat_jual_asli+'1.110',stock_jual='1',berat_akhir=berat_akhir-'1.110',berat_akhir_asli=berat_akhir_asli-'1.110',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='H1F-YHXF-21-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101055032','2025-09-10','1.110','2025-09-10','10:55:04','PLG0072490','1029000','1029000','6000','1035000','1035000','kasir','2025-09-10 10:55:03','F22510105503');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101055032','2025-09-10','10:55:04','NS','1035000','6000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0027','D','2025-09-10','10:55:04','kasir','PENJUALAN','F225101055032','138599000','1035000','139634000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1035000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101055032' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101055341','kasir','1',' MEF3 LT ','TOKO','SMBK-F','F3E-YIXB-23-T','GL MODEL VERONA VAR LT 8K ','OL','1.030','1','100.00','927000','0','0','15000','937000','0','5000','0','942000','NS','T0072767','F3E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YIXB-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='F3E-YIXB-23-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101055341','2025-09-10','1.030','2025-09-10','10:55:34','PLG0072491','937000','937000','5000','942000','942000','kasir','2025-09-10 10:55:34','F22510105534');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101055341','2025-09-10','10:55:34','NS','942000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250910-0028','D','2025-09-10','10:55:34','kasir','PENJUALAN','F225101055341','139634000','942000','140576000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101056021','kasir','1',' MEE1 X UB ','TOKO','SMBK-E','E1E-YHBI-119-0','CC X MODEL SLEP UB 14 8K ','OL','0.840','1','100.00','756000','0','0','15000','769000','0','5000','0','774000','NS','00367360','E1E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YHBI-119-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.840',berat_jual_asli=berat_jual_asli+'0.840',stock_jual='1',berat_akhir=berat_akhir-'0.840',berat_akhir_asli=berat_akhir_asli-'0.840',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='E1E-YHBI-119-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101056021','2025-09-10','0.840','2025-09-10','10:56:02','PLG0072492','769000','769000','5000','774000','774000','kasir','2025-09-10 10:56:02','F22510105602');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101056021','2025-09-10','10:56:02','NS','774000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250910-0029','D','2025-09-10','10:56:02','kasir','PENJUALAN','F225101056021','140576000','774000','141350000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101056291','kasir','1',' MEE1 5K CM','TOKO','SMBK-E','E2E-YIXB-59-T','CC MODEL PASIR SLEP VAR CM 12 8K ','OL','0.530','1','100.00','477000','0','0','15000','485000','0','5000','0','490000','NS','T0072803','E2E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YIXB-59-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='E2E-YIXB-59-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101056291','2025-09-10','0.530','2025-09-10','10:56:30','PLG0072493','485000','485000','5000','490000','490000','kasir','2025-09-10 10:56:29','F22510105629');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101056291','2025-09-10','10:56:30','NS','490000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250910-0030','D','2025-09-10','10:56:30','kasir','PENJUALAN','F225101056291','141350000','490000','141840000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101056541','kasir','1',' MFA1 BW ','TOKO','SMBK-A','A1F-YIXC-14-T','AT MODEL ITALY PANJANG SLEP VAR BW 8K ','OL','0.550','1','100.00','504000','0','0','15000','513000','0','5000','0','518000','NS','T0072829','A1F','0','0','-','0','917000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1F-YIXC-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='A1F-YIXC-14-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101056541','2025-09-10','0.550','2025-09-10','10:56:55','PLG0072494','513000','513000','5000','518000','518000','kasir','2025-09-10 10:56:54','F22510105654');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101056541','2025-09-10','10:56:55','NS','518000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250910-0031','D','2025-09-10','10:56:55','kasir','PENJUALAN','F225101056541','141840000','518000','142358000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101059161','kasir','1',' MFB1 LG ','TOKO','SMBK-B','B1F-YIXH-15-T','GW TRIXIE PANJANG PITA MATA VAR LG 8K ','OL','0.550','1','100.00','504000','0','0','15000','513000','0','5000','0','518000','NS','T0073024','B1F','0','0','-','0','917000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-YIXH-15-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='B1F-YIXH-15-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101059161','2025-09-10','0.550','2025-09-10','10:59:17','PLG0072495','513000','513000','5000','518000','518000','kasir','2025-09-10 10:59:16','F22510105916');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101059161','2025-09-10','10:59:17','NS','518000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0032','D','2025-09-10','10:59:17','kasir','PENJUALAN','F225101059161','142358000','518000','142876000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='518000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101059161' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101059162','kasir',' 1',' MEE1 AY 15','TOKO','SMBK-E','E1E-YHXG-19-T','CC MODEL PITA VAR AY 15 8K ','OL','0.630','1','100.00','567000','0','0','15000','576000','0','5000','0','581000','NS','T0072006','E1E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YHXG-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.630',berat_jual_asli=berat_jual_asli+'0.630',stock_jual='1',berat_akhir=berat_akhir-'0.630',berat_akhir_asli=berat_akhir_asli-'0.630',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='E1E-YHXG-19-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101059162','2025-09-10','0.630','2025-09-10','10:59:17','PLG0072496','576000','576000','5000','581000','581000','kasir','2025-09-10 10:59:16','F22510105916');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101059162','2025-09-10','10:59:17','NS','581000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0033','D','2025-09-10','10:59:17','kasir','PENJUALAN','F225101059162','142876000','581000','143457000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='581000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101059162' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101059163','kasir',' 1',' MDE2 X HW ','TOKO','SMBK-E','E2D-YHBI-109-0','CC X MODEL MATA HW 17 8K ','OL','0.800','1','100.00','706000','0','0','15000','732000','0','5000','0','737000','NS','00367350','E2D','0','0','-','0','883000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YHBI-109-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='E2D-YHBI-109-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101059163','2025-09-10','0.800','2025-09-10','10:59:17','PLG0072497','732000','732000','5000','737000','737000','kasir','2025-09-10 10:59:16','F22510105916');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101059163','2025-09-10','10:59:17','NS','737000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0034','D','2025-09-10','10:59:17','kasir','PENJUALAN','F225101059163','143457000','737000','144194000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='737000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101059163' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101059164','kasir',' 1',' MEE1 6K CM','TOKO','SMBK-E','E1E-YIXC-33-T','CC MODEL PITA PASIR VAR CM 13 8K ','OL','0.800','1','100.00','720000','0','0','15000','731000','0','6000','0','737000','NS','T0072848','E1E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YIXC-33-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='E1E-YIXC-33-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101059164','2025-09-10','0.800','2025-09-10','10:59:17','PLG0072498','731000','731000','6000','737000','737000','kasir','2025-09-10 10:59:16','F22510105916');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101059164','2025-09-10','10:59:17','NS','737000','6000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0035','D','2025-09-10','10:59:17','kasir','PENJUALAN','F225101059164','144194000','737000','144931000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='737000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101059164' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101059165','kasir',' 1',' MEF3 5K LT','TOKO','SMBK-F','F3E-YHBF-14-T','GL RANTAI HOLLOW P3 SLEP LT 8K ','OL','1.060','1','100.00','954000','0','0','15000','965000','0','5000','0','970000','NS','T0072577','F3E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YHBF-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='F3E-YHBF-14-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101059165','2025-09-10','1.060','2025-09-10','10:59:17','PLG0072499','965000','965000','5000','970000','970000','kasir','2025-09-10 10:59:16','F22510105916');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101059165','2025-09-10','10:59:17','NS','970000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0036','D','2025-09-10','10:59:17','kasir','PENJUALAN','F225101059165','144931000','970000','145901000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='970000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101059165' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101059166','kasir',' 1',' MEF3E X LT','TOKO','SMBK-F','F3E-YHBI-276-0','GL X TIFF HATI SLEP LT 8K ','OL','1.220','1','100.00','1098000','0','0','15000','1110000','0','6000','0','1116000','NS','00367517','F3E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YHBI-276-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.220',berat_jual_asli=berat_jual_asli+'1.220',stock_jual='1',berat_akhir=berat_akhir-'1.220',berat_akhir_asli=berat_akhir_asli-'1.220',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='F3E-YHBI-276-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101059166','2025-09-10','1.220','2025-09-10','10:59:17','PLG0072500','1110000','1110000','6000','1116000','1116000','kasir','2025-09-10 10:59:16','F22510105916');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101059166','2025-09-10','10:59:17','NS','1116000','6000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0037','D','2025-09-10','10:59:17','kasir','PENJUALAN','F225101059166','145901000','1116000','147017000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1116000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101059166' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101059167','kasir',' 1',' MGPDG 5K L','TOKO','SMBK-P','PDG-XHBH-99-0','LT WG MODEL SALIB MATA LG 8K ','OL','0.760','1','100.00','710000','0','0','15000','721000','0','5000','0','726000','NS','00314205','PDG','0','0','-','0','934000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PDG-XHBH-99-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.760',berat_jual_asli=berat_jual_asli+'0.760',stock_jual='1',berat_akhir=berat_akhir-'0.760',berat_akhir_asli=berat_akhir_asli-'0.760',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='PDG-XHBH-99-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-P' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101059167','2025-09-10','0.760','2025-09-10','10:59:17','PLG0072501','721000','721000','5000','726000','726000','kasir','2025-09-10 10:59:16','F22510105916');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101059167','2025-09-10','10:59:17','NS','726000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0038','D','2025-09-10','10:59:17','kasir','PENJUALAN','F225101059167','147017000','726000','147743000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='726000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101059167' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101103351','kasir','1',' MGF3 UB ','TOKO','SMBK-F','F3G-YHCX-24-T','GL BORSALINO UB 8K ','OL','0.360','1','100.00','336000','0','0','15000','342000','0','5000','0','347000','NS','T0072735','F3G','0','0','-','0','934000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3G-YHCX-24-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.360',berat_jual_asli=berat_jual_asli+'0.360',stock_jual='1',berat_akhir=berat_akhir-'0.360',berat_akhir_asli=berat_akhir_asli-'0.360',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='F3G-YHCX-24-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101103351','2025-09-10','0.360','2025-09-10','11:03:36','PLG0072502','342000','342000','5000','347000','347000','kasir','2025-09-10 11:03:35','F22510110335');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101103351','2025-09-10','11:03:36','NS','347000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0039','D','2025-09-10','11:03:36','kasir','PENJUALAN','F225101103351','147743000','347000','148090000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='347000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101103351' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101103352','kasir',' 1',' MGF3 UB ','TOKO','SMBK-F','F3G-YHCX-31-T','GL BORSALINO UB 8K ','OL','0.360','1','100.00','336000','0','0','15000','342000','0','5000','0','347000','NS','T0072742','F3G','0','0','-','0','934000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3G-YHCX-31-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.360',berat_jual_asli=berat_jual_asli+'0.360',stock_jual='1',berat_akhir=berat_akhir-'0.360',berat_akhir_asli=berat_akhir_asli-'0.360',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='F3G-YHCX-31-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101103352','2025-09-10','0.360','2025-09-10','11:03:36','PLG0072503','342000','342000','5000','347000','347000','kasir','2025-09-10 11:03:35','F22510110335');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101103352','2025-09-10','11:03:36','NS','347000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0040','D','2025-09-10','11:03:36','kasir','PENJUALAN','F225101103352','148090000','347000','148437000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='347000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101103352' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101109411','kasir','1',' MGPH KH 42','TOKO','SMBK-P','PHG-YHBE-27-T','KL WG SANTA KH 42CM 8K ','','3.010','1','100.00','2811000','0','0','15000','2811000','0','0','0','2811000','TJ','T0072512','PHG','0','0','-','0','934000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PHG-YHBE-27-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.010',berat_jual_asli=berat_jual_asli+'3.010',stock_jual='1',berat_akhir=berat_akhir-'3.010',berat_akhir_asli=berat_akhir_asli-'3.010',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='PHG-YHBE-27-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-P' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101109411','2025-09-10','3.010','2025-09-10','11:09:41','PLG0072504','2811000','2811000','0','2811000','2811000','kasir','2025-09-10 11:09:41','F22510110941');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101109411','2025-09-10','11:09:41','TJ','2811000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0041','D','2025-09-10','11:09:41','kasir','PENJUALAN','F225101109411','148437000','2811000','151248000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2811000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101109411' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101109412','kasir',' 1',' MGPDG X LG','TOKO','SMBK-P','PDG-YHBI-186-0','LT X WG BOLA MATA LG 8K ','','1.120','1','100.00','1046000','0','0','15000','1046000','0','10000','0','1056000','TJ','00367427','PDG','0','0','-','0','934000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PDG-YHBI-186-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.120',berat_jual_asli=berat_jual_asli+'1.120',stock_jual='1',berat_akhir=berat_akhir-'1.120',berat_akhir_asli=berat_akhir_asli-'1.120',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='PDG-YHBI-186-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-P' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101109412','2025-09-10','1.120','2025-09-10','11:09:41','PLG0072505','1046000','1046000','10000','1056000','1056000','kasir','2025-09-10 11:09:41','F22510110941');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101109412','2025-09-10','11:09:41','TJ','1056000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0042','D','2025-09-10','11:09:41','kasir','PENJUALAN','F225101109412','151248000','1056000','152304000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1056000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101109412' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101138591','kasir','1',' MHB1 CM ','TOKO','SMBK-B','B1H-YGXD-28-T','GW TUSUK DAISY MATA CM 8K ','','0.260','1','100.00','247000','0','0','15000','250000','0','5000','0','255000','RTA','T0070778','B1H','0','0','-','0','951000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-YGXD-28-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='B1H-YGXD-28-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101138591','2025-09-10','0.260','2025-09-10','11:38:59','PLG0072506','250000','250000','5000','255000','255000','kasir','2025-09-10 11:38:59','F22510113859');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101138591','2025-09-10','11:38:59','RTA','255000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250910-0043','D','2025-09-10','11:38:59','kasir','PENJUALAN','F225101138591','152304000','255000','152559000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101150301','kasir','1',' MJH3 X 10K','TOKO','SMBK-H','H3J-YEXA-120-0','KL X SANTA MODEL HATI MATA VAR UB 9K ','OL S 70TG','3.010','1','100.00','2950000','0','0','15000','3040000','0','142000','0','3182000','RHM','00351713','H3J','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H3J-YEXA-120-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.010',berat_jual_asli=berat_jual_asli+'3.010',stock_jual='1',berat_akhir=berat_akhir-'3.010',berat_akhir_asli=berat_akhir_asli-'3.010',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='H3J-YEXA-120-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101150301','2025-09-10','3.010','2025-09-10','11:50:31','PLG0072507','3040000','3040000','142000','3182000','3182000','kasir','2025-09-10 11:50:30','F22510115030');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101150301','2025-09-10','11:50:31','RHM','3182000','142000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250910-0044','D','2025-09-10','11:50:31','kasir','PENJUALAN','F225101150301','152559000','3182000','155741000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101151201','kasir','1',' MDA1 CM ','TOKO','SMBK-A','A1D-YGBB-36-T','AT KLIP MODEL MATA VAR CM 8K ','','1.200','1','100.00','1060000','0','0','15000','1060000','0','0','0','1060000','TIN','T0071308','A1D','0','0','-','0','883000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YGBB-36-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.200',berat_jual_asli=berat_jual_asli+'1.200',stock_jual='1',berat_akhir=berat_akhir-'1.200',berat_akhir_asli=berat_akhir_asli-'1.200',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='A1D-YGBB-36-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101151201','2025-09-10','1.200','2025-09-10','11:51:20','PLG0072508','1060000','1060000','0','1060000','1060000','kasir','2025-09-10 11:51:20','F22510115120');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101151201','2025-09-10','11:51:20','TIN','1060000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250910-0045','D','2025-09-10','11:51:20','kasir','PENJUALAN','F225101151201','155741000','1060000','156801000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101204021','kasir','1',' MEF3 5K LT','TOKO','SMBK-F','F3E-YHBF-16-T','GL RANTAI HOLLOW P3 SLEP LT 8K ','OL','1.050','1','100.00','945000','0','0','15000','956000','0','5000','0','961000','NS','T0072579','F3E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YHBF-16-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='F3E-YHBF-16-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101204021','2025-09-10','1.050','2025-09-10','12:04:02','PLG0072509','956000','956000','5000','961000','961000','kasir','2025-09-10 12:04:02','F22510120402');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101204021','2025-09-10','12:04:02','NS','961000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0046','D','2025-09-10','12:04:02','kasir','PENJUALAN','F225101204021','156801000','961000','157762000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='961000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101204021' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101204022','kasir',' 1',' MEF3 5K LT','TOKO','SMBK-F','F3E-YHBF-12-T','GL RANTAI HOLLOW P3 SLEP LT 8K ','OL','1.050','1','100.00','945000','0','0','15000','956000','0','5000','0','961000','NS','T0072575','F3E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YHBF-12-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='F3E-YHBF-12-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101204022','2025-09-10','1.050','2025-09-10','12:04:02','PLG0072510','956000','956000','5000','961000','961000','kasir','2025-09-10 12:04:02','F22510120402');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101204022','2025-09-10','12:04:02','NS','961000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0047','D','2025-09-10','12:04:02','kasir','PENJUALAN','F225101204022','157762000','961000','158723000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='961000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101204022' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101223171','kasir','1',' TDE2 X CM ','TOKO','TBK-E','E2TD-YIXD-66-T','CC X MODEL MATA VAR CM 14 17K ','OL','1.460','1','100.00','2304000','0','0','15000','2348000','0','10000','0','2358000','RTA','T0072918','E2TD','0','0','-','0','1578000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-YIXD-66-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.460',berat_jual_asli=berat_jual_asli+'1.460',stock_jual='1',berat_akhir=berat_akhir-'1.460',berat_akhir_asli=berat_akhir_asli-'1.460',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='E2TD-YIXD-66-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101223171','2025-09-10','1.460','2025-09-10','12:23:17','PLG0072511','2348000','2348000','10000','2358000','0','kasir','2025-09-10 12:23:17','F22510122317');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101223171','2025-09-10','12:23:17','RTA','2358000','10000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250910-0001','2025-09-10','2025-09-10 12:23:17','PENJUALAN : F225101223171','907655440000','BCA','2358000','2358000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250910-0002','D','2025-09-10','12:23:17','BCA','PENJUALAN','F225101223171','3973857888','2358000','3976215888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('907655440000','FERDHA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2358000' WHERE no_faktur_jual='F225101223171' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101240461','kasir','1',' MEH1 X HW ','TOKO','SMBK-H','H1E-YHBI-301-0','KL X SANTA HATI PASIR VAR HW 42 8K ','OL','2.150','1','100.00','1935000','0','0','15000','1952000','0','15000','0','1967000','RTA','00367542','H1E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YHBI-301-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.150',berat_jual_asli=berat_jual_asli+'2.150',stock_jual='1',berat_akhir=berat_akhir-'2.150',berat_akhir_asli=berat_akhir_asli-'2.150',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='H1E-YHBI-301-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101240461','2025-09-10','2.150','2025-09-10','12:40:47','PLG0072512','1952000','1952000','15000','1967000','1967000','kasir','2025-09-10 12:40:46','F22510124046');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101240461','2025-09-10','12:40:47','RTA','1967000','15000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0048','D','2025-09-10','12:40:47','kasir','PENJUALAN','F225101240461','158723000','1967000','160690000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1967000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101240461' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101240462','kasir',' 1',' MEH1 15K H','TOKO','SMBK-H','H1E-YHBA-3-T','KL SANTA MODEL HATI PASIR HW 8K ','OL','2.070','1','100.00','1863000','0','0','15000','1880000','0','15000','0','1895000','RTA','T0072433','H1E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YHBA-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='H1E-YHBA-3-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101240462','2025-09-10','2.070','2025-09-10','12:40:47','PLG0072513','1880000','1880000','15000','1895000','1895000','kasir','2025-09-10 12:40:46','F22510124046');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101240462','2025-09-10','12:40:47','RTA','1895000','15000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0049','D','2025-09-10','12:40:47','kasir','PENJUALAN','F225101240462','160690000','1895000','162585000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1895000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101240462' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101240463','kasir',' 1',' MGPF X KH ','TOKO','SMBK-P','PFG-YHCX-7-T','GL X WG RANTAI HOLLOW DOUBLE VAR KH 8K ','OL','2.080','1','100.00','1943000','0','0','15000','1964000','0','10000','0','1974000','RTA','T0072718','PFG','0','0','-','0','934000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PFG-YHCX-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.080',berat_jual_asli=berat_jual_asli+'2.080',stock_jual='1',berat_akhir=berat_akhir-'2.080',berat_akhir_asli=berat_akhir_asli-'2.080',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='PFG-YHCX-7-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-P' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101240463','2025-09-10','2.080','2025-09-10','12:40:47','PLG0072514','1964000','1964000','10000','1974000','1974000','kasir','2025-09-10 12:40:46','F22510124046');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101240463','2025-09-10','12:40:47','RTA','1974000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0050','D','2025-09-10','12:40:47','kasir','PENJUALAN','F225101240463','162585000','1974000','164559000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1974000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101240463' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101240464','kasir',' 1',' MFF3 UB ','TOKO','SMBK-F','F3F-YHCX-16-T','GL KAKI RANTAI HOLLOW UB 8K ','OL','0.510','1','100.00','468000','0','0','15000','475000','0','5000','0','480000','RTA','T0072727','F3F','0','0','-','0','917000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YHCX-16-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='F3F-YHCX-16-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101240464','2025-09-10','0.510','2025-09-10','12:40:47','PLG0072515','475000','475000','5000','480000','480000','kasir','2025-09-10 12:40:46','F22510124046');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101240464','2025-09-10','12:40:47','RTA','480000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0051','D','2025-09-10','12:40:47','kasir','PENJUALAN','F225101240464','164559000','480000','165039000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='480000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101240464' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101240465','kasir',' 1',' MEE2 X CM ','TOKO','SMBK-E','E2E-YHXB-281-0','CC X MODEL MATA CM 18 8K ','OL','0.590','1','100.00','531000','0','0','15000','540000','0','5000','0','545000','RTA','00363691','E2E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YHXB-281-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.590',berat_jual_asli=berat_jual_asli+'0.590',stock_jual='1',berat_akhir=berat_akhir-'0.590',berat_akhir_asli=berat_akhir_asli-'0.590',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='E2E-YHXB-281-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101240465','2025-09-10','0.590','2025-09-10','12:40:47','PLG0072516','540000','540000','5000','545000','545000','kasir','2025-09-10 12:40:46','F22510124046');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101240465','2025-09-10','12:40:47','RTA','545000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0052','D','2025-09-10','12:40:47','kasir','PENJUALAN','F225101240465','165039000','545000','165584000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='545000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101240465' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101240466','kasir',' 1',' MEE1 AY 18','TOKO','SMBK-E','E1E-YHXF-90-T','CC MODEL PITA VAR AY 18 8K ','OL','0.560','1','100.00','504000','0','0','15000','512000','0','5000','0','517000','RTA','T0071982','E1E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YHXF-90-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='E1E-YHXF-90-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101240466','2025-09-10','0.560','2025-09-10','12:40:47','PLG0072517','512000','512000','5000','517000','517000','kasir','2025-09-10 12:40:46','F22510124046');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101240466','2025-09-10','12:40:47','RTA','517000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0053','D','2025-09-10','12:40:47','kasir','PENJUALAN','F225101240466','165584000','517000','166101000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='517000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101240466' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101240467','kasir',' 1',' MEE2 LG 13','TOKO','SMBK-E','E2E-YGCX-55-T','CC MODEL MATA VAR LG 13 8K','OL','0.500','1','100.00','450000','0','0','15000','458000','0','5000','0','463000','RTA','T0071720','E2E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YGCX-55-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='E2E-YGCX-55-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101240467','2025-09-10','0.500','2025-09-10','12:40:47','PLG0072518','458000','458000','5000','463000','463000','kasir','2025-09-10 12:40:46','F22510124046');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101240467','2025-09-10','12:40:47','RTA','463000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0054','D','2025-09-10','12:40:47','kasir','PENJUALAN','F225101240467','166101000','463000','166564000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='463000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101240467' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225101245271','kasir','1',' MEF1 TD D5','TOKO','SMBK-F','F1E-YIXB-24-T','GL OVAL MODEL C TD D58 8K ','','3.100','1','100.00','2790000','0','0','15000','2790000','0','0','0','2790000','NS','T0072768','F1E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YIXB-24-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.100',berat_jual_asli=berat_jual_asli+'3.100',stock_jual='1',berat_akhir=berat_akhir-'3.100',berat_akhir_asli=berat_akhir_asli-'3.100',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='F1E-YIXB-24-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225101245271','2025-09-10','3.100','2025-09-10','12:45:28','PLG0072519','2790000','2790000','0','2790000','2790000','kasir','2025-09-10 12:45:27','F22510124527');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225101245271','2025-09-10','12:45:28','NS','2790000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250910-0055','D','2025-09-10','12:45:28','kasir','PENJUALAN','F225101245271','166564000','2790000','169354000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225100139351','kasir','1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YHBE-39-T','LT SLOBOK BULAT HURUF BG K 8K ','','0.550','1','100.00','514000','0','0','15000','514000','0','5000','0','519000','TIN','T0072524','D1G','0','0','-','0','934000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YHBE-39-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='D1G-YHBE-39-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225100139351','2025-09-10','0.550','2025-09-10','13:39:36','PLG0072520','514000','514000','5000','519000','519000','kasir','2025-09-10 13:39:35','F22510013935');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225100139351','2025-09-10','13:39:36','TIN','519000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0056','D','2025-09-10','13:39:36','kasir','PENJUALAN','F225100139351','169354000','519000','169873000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='519000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225100139351' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225100139352','kasir',' 1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YGAB-41-T','LT SLOBOK BULAT HURUF BG E 8K ','','0.550','1','100.00','514000','0','0','15000','514000','0','5000','0','519000','TIN','T0070924','D1G','0','0','-','0','934000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YGAB-41-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='D1G-YGAB-41-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225100139352','2025-09-10','0.550','2025-09-10','13:39:36','PLG0072521','514000','514000','5000','519000','519000','kasir','2025-09-10 13:39:35','F22510013935');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225100139352','2025-09-10','13:39:36','TIN','519000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0057','D','2025-09-10','13:39:36','kasir','PENJUALAN','F225100139352','169873000','519000','170392000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='519000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225100139352' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225100140071','kasir','1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YHBA-24-T','LT SLOBOK BALOK HURUF BG K 8K ','','0.520','1','100.00','486000','0','0','15000','486000','0','5000','0','491000','TIN','T0072454','D1G','0','0','-','0','934000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YHBA-24-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='D1G-YHBA-24-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225100140071','2025-09-10','0.520','2025-09-10','13:40:08','PLG0072522','486000','486000','5000','491000','491000','kasir','2025-09-10 13:40:07','F22510014007');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225100140071','2025-09-10','13:40:08','TIN','491000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250910-0058','D','2025-09-10','13:40:08','kasir','PENJUALAN','F225100140071','170392000','491000','170883000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225100142211','kasir','1',' TEA1 X UB ','TOKO','TBK-A','A1TE-YIXD-45-T','AT X KLIP ARESO UB 17K ','OLH','0.900','1','100.00','1435000','0','0','15000','1456000','0','10000','0','1466000','TJ','T0072897','A1TE','0','0','-','0','1595000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TE-YIXD-45-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.900',berat_jual_asli=berat_jual_asli+'0.900',stock_jual='1',berat_akhir=berat_akhir-'0.900',berat_akhir_asli=berat_akhir_asli-'0.900',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='A1TE-YIXD-45-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225100142211','2025-09-10','0.900','2025-09-10','13:42:21','PLG0072523','1456000','1456000','10000','1466000','1466000','kasir','2025-09-10 13:42:21','F22510014221');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225100142211','2025-09-10','13:42:21','TJ','1466000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250910-0059','D','2025-09-10','13:42:21','kasir','PENJUALAN','F225100142211','170883000','1466000','172349000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225100143481','kasir','1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YHBH-200-T','LT SLOBOK BALOK HURUF BG L 8K ','OLH','0.400','1','100.00','374000','0','0','15000','380000','0','8000','0','388000','TJ','T0072696','D1G','0','0','-','0','934000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YHBH-200-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='D1G-YHBH-200-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225100143481','2025-09-10','0.400','2025-09-10','13:43:48','PLG0072524','380000','380000','8000','388000','388000','kasir','2025-09-10 13:43:48','F22510014348');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225100143481','2025-09-10','13:43:48','TJ','388000','8000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0060','D','2025-09-10','13:43:48','kasir','PENJUALAN','F225100143481','172349000','388000','172737000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='388000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225100143481' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225100143482','kasir',' 1',' MFA1F X UB','TOKO','SMBK-A','A1F-YCBD-109-0','AT X HUGGIES SLEP UB 8K ','OLH','0.690','1','100.00','633000','0','0','15000','643000','0','8000','0','651000','TJ','00344902','A1F','0','0','-','0','917000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1F-YCBD-109-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.690',berat_jual_asli=berat_jual_asli+'0.690',stock_jual='1',berat_akhir=berat_akhir-'0.690',berat_akhir_asli=berat_akhir_asli-'0.690',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='A1F-YCBD-109-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225100143482','2025-09-10','0.690','2025-09-10','13:43:48','PLG0072525','643000','643000','8000','651000','651000','kasir','2025-09-10 13:43:48','F22510014348');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225100143482','2025-09-10','13:43:48','TJ','651000','8000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0061','D','2025-09-10','13:43:48','kasir','PENJUALAN','F225100143482','172737000','651000','173388000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='651000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225100143482' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225100143483','kasir',' 1',' MFH1 UB 44','TOKO','SMBK-H','H1F-YIXH-71-T','KL KOREA UB 44CM 8K ','OLH','1.050','1','100.00','963000','0','0','15000','968000','0','11000','0','979000','TJ','T0073080','H1F','0','0','-','0','917000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YIXH-71-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='H1F-YIXH-71-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225100143483','2025-09-10','1.050','2025-09-10','13:43:48','PLG0072526','968000','968000','11000','979000','979000','kasir','2025-09-10 13:43:48','F22510014348');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225100143483','2025-09-10','13:43:48','TJ','979000','11000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0062','D','2025-09-10','13:43:48','kasir','PENJUALAN','F225100143483','173388000','979000','174367000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='979000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225100143483' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225100143484','kasir',' 1',' MEE1 6K CM','TOKO','SMBK-E','E1E-YIXC-35-T','CC MODEL PITA PASIR VAR CM 15 8K ','OLH','0.800','1','100.00','720000','0','0','15000','732000','0','8000','0','740000','TJ','T0072850','E1E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YIXC-35-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='E1E-YIXC-35-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225100143484','2025-09-10','0.800','2025-09-10','13:43:48','PLG0072527','732000','732000','8000','740000','740000','kasir','2025-09-10 13:43:48','F22510014348');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225100143484','2025-09-10','13:43:48','TJ','740000','8000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0063','D','2025-09-10','13:43:48','kasir','PENJUALAN','F225100143484','174367000','740000','175107000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='740000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225100143484' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225100143485','kasir',' 1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YIXB-8-T','LT SLOBOK BALOK HURUF BG A 8K ','OLH','0.420','1','100.00','392000','0','0','15000','399000','0','8000','0','407000','TJ','T0072752','D1G','0','0','-','0','934000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YIXB-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.420',berat_jual_asli=berat_jual_asli+'0.420',stock_jual='1',berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='D1G-YIXB-8-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225100143485','2025-09-10','0.420','2025-09-10','13:43:48','PLG0072528','399000','399000','8000','407000','407000','kasir','2025-09-10 13:43:48','F22510014348');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225100143485','2025-09-10','13:43:48','TJ','407000','8000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0064','D','2025-09-10','13:43:48','kasir','PENJUALAN','F225100143485','175107000','407000','175514000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='407000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225100143485' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225100215361','kasir','1',' MFF3 UB ','TOKO','SMBK-F','F3F-YIXC-1-T','GL PREMIER BOLA ARESO VAR UB 8K ','OL','2.740','1','100.00','2513000','0','0','15000','2541000','0','14000','0','2555000','RTA','T0072816','F3F','0','0','-','0','917000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YIXC-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.740',berat_jual_asli=berat_jual_asli+'2.740',stock_jual='1',berat_akhir=berat_akhir-'2.740',berat_akhir_asli=berat_akhir_asli-'2.740',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='F3F-YIXC-1-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225100215361','2025-09-10','2.740','2025-09-10','14:15:37','PLG0072529','2541000','2541000','14000','2555000','2555000','kasir','2025-09-10 14:15:36','F22510021536');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225100215361','2025-09-10','14:15:37','RTA','2555000','14000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250910-0065','D','2025-09-10','14:15:37','kasir','PENJUALAN','F225100215361','175514000','2555000','178069000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225100233171','kasir','1',' MEF1 20K K','TOKO','SMBK-F','F1E-YAAG-24-0','GL BANGKOK HOLLOW LASER KH 58 8K ','','6.030','1','100.00','5427000','0','0','15000','5427000','0','20000','0','5447000','NS','00334591','F1E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YAAG-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.030',berat_jual_asli=berat_jual_asli+'6.030',stock_jual='1',berat_akhir=berat_akhir-'6.030',berat_akhir_asli=berat_akhir_asli-'6.030',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='F1E-YAAG-24-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225100233171','2025-09-10','6.030','2025-09-10','14:33:18','PLG0072530','5427000','5427000','20000','5447000','5447000','kasir','2025-09-10 14:33:17','F22510023317');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225100233171','2025-09-10','14:33:18','NS','5447000','20000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250910-0066','D','2025-09-10','14:33:18','kasir','PENJUALAN','F225100233171','178069000','5447000','183516000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225100239091','kasir','1',' MDE1 CM 24','TOKO','SMBK-E','E1D-YHBE-12-T','CC VELG POLOS CM 24 8K ','OL','1.480','1','100.00','1307000','0','0','15000','1340000','0','7000','0','1347000','TJ','T0072497','E1D','0','0','-','0','883000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YHBE-12-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.480',berat_jual_asli=berat_jual_asli+'1.480',stock_jual='1',berat_akhir=berat_akhir-'1.480',berat_akhir_asli=berat_akhir_asli-'1.480',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='E1D-YHBE-12-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225100239091','2025-09-10','1.480','2025-09-10','14:39:10','PLG0072531','1340000','1340000','7000','1347000','0','kasir','2025-09-10 14:39:09','F22510023909');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225100239091','2025-09-10','14:39:10','TJ','1347000','7000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250910-0002','2025-09-10','2025-09-10 14:39:09','PENJUALAN : F225100239091','72498247094280429','BCA','1347000','1347000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250910-0003','D','2025-09-10','14:39:10','BCA','PENJUALAN','F225100239091','3976215888','1347000','3977562888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('72498247094280429','MARIA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1347000' WHERE no_faktur_jual='F225100239091' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225100257531','kasir','1',' TDE2 X UB ','TOKO','TBK-E','E2TD-YIXD-72-T','CC X MODEL MATA VAR UB 12 17K ','','1.420','1','100.00','2241000','0','0','15000','2255000','0','0','0','2255000','RHM','T0072924','E2TD','0','0','-','0','1578000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-YIXD-72-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.420',berat_jual_asli=berat_jual_asli+'1.420',stock_jual='1',berat_akhir=berat_akhir-'1.420',berat_akhir_asli=berat_akhir_asli-'1.420',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='E2TD-YIXD-72-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225100257531','2025-09-10','1.420','2025-09-10','14:57:53','PLG0072532','2255000','2255000','0','2255000','2255000','kasir','2025-09-10 14:57:53','F22510025753');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225100257531','2025-09-10','14:57:53','RHM','2255000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250910-0067','D','2025-09-10','14:57:53','kasir','PENJUALAN','F225100257531','183516000','2255000','185771000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100139351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100139351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100139351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100139352' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100139352' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100139352';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100140071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100140071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100140071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100142211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100142211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100142211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100143481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100143481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100143481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100143482' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100143482' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100143482';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100143483' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100143483' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100143483';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100143484' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100143484' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100143484';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100143485' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100143485' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100143485';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100215361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100215361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100215361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100233171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100233171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100233171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100239091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100239091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100239091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100257531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100257531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100257531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100838321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100838321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100838321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100838322' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100838322' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100838322';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100838323' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100838323' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100838323';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100838324' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100838324' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100838324';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100838325' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100838325' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100838325';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100838326' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100838326' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100838326';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100838327' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100838327' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100838327';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100838328' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100838328' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100838328';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100838329' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100838329' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100838329';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100840281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100840281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100840281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100903091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100903091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100903091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100903092' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100903092' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100903092';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101020021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101020021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101020021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101020022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101020022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101020022';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101025231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101025231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101025231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101030471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101030471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101030471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101030472' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101030472' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101030472';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101030473' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101030473' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101030473';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101030474' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101030474' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101030474';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101050211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101050211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101050211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101050551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101050551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101050551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101051551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101051551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101051551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101052261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101052261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101052261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101054041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101054041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101054041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101055031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101055031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101055031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101055032' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101055032' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101055032';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101055341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101055341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101055341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101056021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101056021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101056021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101056291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101056291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101056291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101056541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101056541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101056541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101059161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101059161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101059161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101059162' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101059162' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101059162';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101059163' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101059163' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101059163';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101059164' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101059164' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101059164';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101059165' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101059165' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101059165';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101059166' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101059166' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101059166';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101059167' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101059167' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101059167';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101103351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101103351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101103351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101103352' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101103352' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101103352';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101109411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101109411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101109411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101109412' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101109412' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101109412';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101138591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101138591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101138591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101150301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101150301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101150301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101151201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101151201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101151201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101204021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101204021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101204021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101204022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101204022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101204022';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101223171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101223171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101223171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101240461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101240461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101240461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101240462' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101240462' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101240462';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101240463' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101240463' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101240463';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101240464' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101240464' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101240464';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101240465' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101240465' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101240465';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101240466' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101240466' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101240466';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101240467' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101240467' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101240467';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101245271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101245271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101245271';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225100307091','kasir','1',' MEA1 LG ','TOKO','SMBK-A','A1E-YIXH-20-T','AT JERSY MRICAN VAR LG 8K ','OL','0.550','1','100.00','495000','0','0','15000','503000','0','5000','0','508000','NS','T0073029','A1E','0','0','-','0','900000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YIXH-20-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='A1E-YIXH-20-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225100307091','2025-09-10','0.550','2025-09-10','15:07:09','PLG0072533','503000','503000','5000','508000','508000','kasir','2025-09-10 15:07:09','F22510030709');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225100307091','2025-09-10','15:07:09','NS','508000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0068','D','2025-09-10','15:07:09','kasir','PENJUALAN','F225100307091','185771000','508000','186279000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='508000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225100307091' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225100307092','kasir',' 1',' MFD1F BG 8','TOKO','SMBK-D','D1F-YDCX-122-0','LT SLOBOK BAMBU BG 8K ','OL','0.740','1','100.00','679000','0','0','15000','690000','0','5000','0','695000','NS','00351374','D1F','0','0','-','0','917000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YDCX-122-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.740',berat_jual_asli=berat_jual_asli+'0.740',stock_jual='1',berat_akhir=berat_akhir-'0.740',berat_akhir_asli=berat_akhir_asli-'0.740',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='D1F-YDCX-122-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225100307092','2025-09-10','0.740','2025-09-10','15:07:09','PLG0072534','690000','690000','5000','695000','695000','kasir','2025-09-10 15:07:09','F22510030709');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225100307092','2025-09-10','15:07:09','NS','695000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250910-0069','D','2025-09-10','15:07:09','kasir','PENJUALAN','F225100307092','186279000','695000','186974000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='695000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225100307092' LIMIT 1;
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00004606','X-00004606','KL JEDAR SEMI KH 50CM 9K','GR','---','H2J','BELI','BELI001','1100000','2025-09-10','1.350','1','kasir','2025-09-10 15:13:16');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2J';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2J','X-00004606','X-00004606');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250910-0001','F225110921281','NS','1','BELI','BELI001','H2J', 'X-00004606', 'KL JEDAR SEMI KH 50CM 9K','1.350','1.350','100.00','1222000','1100000','814815','980000','1','1100000','1100000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.350',berat_beli_asli=berat_beli_asli+'1.350',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.350',berat_akhir_asli=berat_akhir_asli+'1.350',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-10' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2J' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-250910-0001','2025-09-10','2025-09-10','15:13:15','NS','---','1.350','1100000','1100000','1100000','1100000','1100000','kasir','2025-09-10 15:13:16','FB-250910-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250910-0001','RISNA','JL SENTOT PRAWIRODIRJO KAUMAN','','','0881026226583','kasir','2025-09-10 15:13:16');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-10' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-250910-0070','K','2025-09-10','15:13:15','kasir','PEMBELIAN UMUM','FB-250910-0001','186974000','1100000','185874000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00004607','X-00004607','CC MODEL CAT VAR HW 17 8K','GR','---','E1E','BELI','BELI001','450000','2025-09-10','0.730','1','kasir','2025-09-10 15:13:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00004607','X-00004607');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250910-0002','F225090905101','NS','1','BELI','BELI001','E1E', 'X-00004607', 'CC MODEL CAT VAR HW 17 8K','0.730','0.730','100.00','491000','450000','616438','900000','1','450000','450000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.730',berat_beli_asli=berat_beli_asli+'0.730',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.730',berat_akhir_asli=berat_akhir_asli+'0.730',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-10' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-250910-0002','2025-09-10','2025-09-10','15:13:29','NS','---','0.730','450000','450000','450000','450000','450000','kasir','2025-09-10 15:13:30','FB-250910-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250910-0002','CANDRA','PO','','','','kasir','2025-09-10 15:13:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-10' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-250910-0071','K','2025-09-10','15:13:29','kasir','PEMBELIAN UMUM','FB-250910-0002','185874000','450000','185424000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00004608','X-00004608','LT SLOBOK BALOK HURUF BG K 8K','GR','---','D1G','BELI','BELI001','448000','2025-09-10','0.580','1','kasir','2025-09-10 15:14:02');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1G','X-00004608','X-00004608');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250910-0003','F225191144331','TIN','1','BELI','BELI001','D1G', 'X-00004608', 'LT SLOBOK BALOK HURUF BG K 8K','0.580','0.580','100.00','498000','448000','772414','934000','1','448000','448000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.580',berat_beli_asli=berat_beli_asli+'0.580',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.580',berat_akhir_asli=berat_akhir_asli+'0.580',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-10' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1G' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-250910-0003','2025-09-10','2025-09-10','15:14:02','TIN','---','0.580','448000','448000','448000','448000','448000','kasir','2025-09-10 15:14:02','FB-250910-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250910-0003','ENDANG','BANARAN PULUNG','','','082326034836','kasir','2025-09-10 15:14:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-10' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-250910-0072','K','2025-09-10','15:14:02','kasir','PEMBELIAN UMUM','FB-250910-0003','185424000','448000','184976000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00004609','X-00004609','LT SLOBOK BALOK HURUF BG E 8K','GR','---','D1G','BELI','BELI001','342000','2025-09-10','0.420','1','kasir','2025-09-10 15:14:02');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1G','X-00004609','X-00004609');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250910-0004','F225020340101','TIN','2','BELI','BELI001','D1G', 'X-00004609', 'LT SLOBOK BALOK HURUF BG E 8K','0.420','0.420','100.00','381000','342000','814286','934000','1','342000','342000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.420',berat_beli_asli=berat_beli_asli+'0.420',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.420',berat_akhir_asli=berat_akhir_asli+'0.420',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-10' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1G' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-250910-0004','2025-09-10','2025-09-10','15:14:02','TIN','---','0.420','342000','342000','342000','342000','342000','kasir','2025-09-10 15:14:02','FB-250910-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250910-0004','ENDANG','BANARAN PULUNG 2/2','','','082326034836','kasir','2025-09-10 15:14:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-10' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-250910-0073','K','2025-09-10','15:14:02','kasir','PEMBELIAN UMUM','FB-250910-0004','184976000','342000','184634000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00004610','X-00004610','GL FANCY POLOS LT 8K','GR','---','F3E','BELI','BELI001','432000','2025-09-10','0.580','1','kasir','2025-09-10 15:14:17');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00004610','X-00004610');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250910-0005','F225050844281','TJ','1','BELI','BELI001','F3E', 'X-00004610', 'GL FANCY POLOS LT 8K','0.580','0.580','100.00','480000','432000','744828','900000','1','432000','432000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.580',berat_beli_asli=berat_beli_asli+'0.580',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.580',berat_akhir_asli=berat_akhir_asli+'0.580',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-10' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-250910-0005','2025-09-10','2025-09-10','15:14:17','TJ','---','0.580','432000','432000','432000','432000','432000','kasir','2025-09-10 15:14:17','FB-250910-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250910-0005','DIAN','TEMON NGRAYUN','','','081234938634','kasir','2025-09-10 15:14:17');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-10' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-250910-0074','K','2025-09-10','15:14:17','kasir','PEMBELIAN UMUM','FB-250910-0005','184634000','432000','184202000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100307091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100307091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100307091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100307092' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100307092' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100307092';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250910-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250910-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250910-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250910-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250910-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250910-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250910-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250910-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250910-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250910-0005';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F225100331361','kasir','1',' MJH2 KH 42','TOKO','SMBK-H','H2J-YHXH-3-T','KL BORSALINO KH 42CM 9K ','','1.120','1','100.00','1103000','0','0','15000','1103000','0','0','0','1103000','RTA','T0072103','H2J','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-09-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-YHXH-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.120',berat_jual_asli=berat_jual_asli+'1.120',stock_jual='1',berat_akhir=berat_akhir-'1.120',berat_akhir_asli=berat_akhir_asli-'1.120',stock_akhir='0' WHERE tanggal='2025-09-10' AND kode_barang='H2J-YHXH-3-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225100331361','2025-09-10','1.120','2025-09-10','15:31:37','PLG0072535','1103000','1103000','0','1103000','1103000','kasir','2025-09-10 15:31:36','F22510033136');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-10','F225100331361','2025-09-10','15:31:37','RTA','1103000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250910-0075','D','2025-09-10','15:31:37','kasir','PENJUALAN','F225100331361','184202000','1103000','185305000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100331361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100331361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100331361';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-09-11','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-08-11';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-09-10';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-09-10';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-09-10' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-09-10';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-09-10';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-09-10';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-09-10';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202508 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
UPDATE tt_barang_saldo SET tanggal= '2025-09-11' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-09-10' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250911-0001','D','2025-09-11','16:11:00','SYSTEM','SALDO AWAL','SALDO AWAL','0','185305000','185305000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250911-0001','D','2025-09-11','16:11:00','BCA','SALDO AWAL','SALDO AWAL','0','3977562888','3977562888');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250911-0001','D','2025-09-11','16:11:00','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250911-0001','D','2025-09-11','16:11:00','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250911-0001','D','2025-09-11','16:11:00','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250911-0001','D','2025-09-11','16:11:00','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2025-09-11';