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-20260602-0001','1','A1E-ZFXA-39-0','1','0.500','0.500','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZFXA-39-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZFXA-39-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-06-02 07:58:35' WHERE kode_barang='A1E-ZFXA-39-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZFXA-39-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 ('2026-06-02 07:58:35','TOKO','SMBK-A','A1E','A1E-ZFXA-39-0','1','0.500','0.500','1','0.500','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' 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='A1E-ZFXA-39-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZFXA-39-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260602-0001','2026-06-02','07:58','0.500','input','2026-06-02 07:58: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-20260602-0001','1','B1D-ZFXA-43-0','1','0.920','0.920','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1D-ZFXA-43-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1D-ZFXA-43-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-06-02 07:58:50' WHERE kode_barang='B1D-ZFXA-43-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1D-ZFXA-43-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 ('2026-06-02 07:58:50','TOKO','SMBK-B','B1D','B1D-ZFXA-43-0','1','0.920','0.920','1','0.920','0.920','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-ZFXA-43-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1D-ZFXA-43-0';
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-20260602-0001','1','B0C-ZFXA-44-0','1','1.010','1.010','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B0C-ZFXA-44-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B0C-ZFXA-44-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-06-02 07:58:50' WHERE kode_barang='B0C-ZFXA-44-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B0C-ZFXA-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 ('2026-06-02 07:58:50','TOKO','SMBK-B','B0C','B0C-ZFXA-44-0','1','1.010','1.010','1','1.010','1.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='B0C' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B0C' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MC' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MC' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B0C-ZFXA-44-0';
DELETE FROM tm_barang_export WHERE kode_barang='B0C-ZFXA-44-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260602-0001','2026-06-02','07:58','1.930','input','2026-06-02 07:58:50');
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-20260602-0001','1','D1E-ZFXA-74-0','1','0.650','0.650','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1E-ZFXA-74-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-ZFXA-74-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-06-02 07:59:05' WHERE kode_barang='D1E-ZFXA-74-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-ZFXA-74-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 ('2026-06-02 07:59:05','TOKO','SMBK-D','D1E','D1E-ZFXA-74-0','1','0.650','0.650','1','0.650','0.650','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1E' 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='D1E-ZFXA-74-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1E-ZFXA-74-0';
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-20260602-0001','1','D1G-ZFXA-75-0','1','0.230','0.230','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1G-ZFXA-75-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1G-ZFXA-75-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-06-02 07:59:05' WHERE kode_barang='D1G-ZFXA-75-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1G-ZFXA-75-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 ('2026-06-02 07:59:05','TOKO','SMBK-D','D1G','D1G-ZFXA-75-0','1','0.230','0.230','1','0.230','0.230','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1G' 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='D1G-ZFXA-75-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1G-ZFXA-75-0';
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-20260602-0001','1','D1G-ZFXA-76-0','1','0.260','0.260','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1G-ZFXA-76-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1G-ZFXA-76-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-06-02 07:59:05' WHERE kode_barang='D1G-ZFXA-76-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1G-ZFXA-76-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 ('2026-06-02 07:59:05','TOKO','SMBK-D','D1G','D1G-ZFXA-76-0','1','0.260','0.260','1','0.260','0.260','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1G' 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='D1G-ZFXA-76-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1G-ZFXA-76-0';
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-20260602-0001','1','D1G-ZFXA-77-0','1','0.270','0.270','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1G-ZFXA-77-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1G-ZFXA-77-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-06-02 07:59:05' WHERE kode_barang='D1G-ZFXA-77-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1G-ZFXA-77-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 ('2026-06-02 07:59:05','TOKO','SMBK-D','D1G','D1G-ZFXA-77-0','1','0.270','0.270','1','0.270','0.270','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1G' 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='D1G-ZFXA-77-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1G-ZFXA-77-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260602-0001','2026-06-02','07:58','1.410','input','2026-06-02 07:59:05');
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-20260602-0001','1','F3E-ZFXA-10-0','1','4.640','4.640','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZFXA-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZFXA-10-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-06-02 07:59:23' WHERE kode_barang='F3E-ZFXA-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZFXA-10-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 ('2026-06-02 07:59:23','TOKO','SMBK-F','F3E','F3E-ZFXA-10-0','1','4.640','4.640','1','4.640','4.640','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-ZFXA-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZFXA-10-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260602-0001','2026-06-02','07:59','4.640','input','2026-06-02 07:59:22');
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 ('F226020844181','kasir','1',' MFD1F LG ','TOKO','SMBK-D','D1F-ZEBH-101-T','LT CHARM SLOBOK BULAT SLEP LG 8K ','OL','0.310','1','100.00','352000','0','0','15000','358000','0','5000','0','363000','TJ','T0080042','D1F','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZEBH-101-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.310',berat_jual_asli=berat_jual_asli+'0.310',stock_jual='1',berat_akhir=berat_akhir-'0.310',berat_akhir_asli=berat_akhir_asli-'0.310',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='D1F-ZEBH-101-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 ('F226020844181','2026-06-02','0.310','2026-06-02','08:44:19','PLG0080637','358000','358000','5000','363000','363000','kasir','2026-06-02 08:44:18','F22602084418');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226020844181','2026-06-02','08:44:19','TJ','363000','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-260602-0002','D','2026-06-02','08:44:19','kasir','PENJUALAN','F226020844181','10350055000','363000','10350418000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='363000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020844181' 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 ('F226020844182','kasir',' 1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZEBF-15-T','CC MODEL ISYANA SLEP LG 12 8K ','OL','0.480','1','100.00','535000','0','0','15000','545000','0','5000','0','550000','TJ','T0079898','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBF-15-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='E1E-ZEBF-15-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 ('F226020844182','2026-06-02','0.480','2026-06-02','08:44:19','PLG0080638','545000','545000','5000','550000','550000','kasir','2026-06-02 08:44:18','F22602084418');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226020844182','2026-06-02','08:44:19','TJ','550000','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-260602-0003','D','2026-06-02','08:44:19','kasir','PENJUALAN','F226020844182','10350418000','550000','10350968000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='550000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020844182' 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 ('F226020844183','kasir',' 1',' MDE1D PM 1','TOKO','SMBK-E','E1D-ZEBH-96-T','CC MODEL DAUN SLEP PM 16 8K ','OL','1.000','1','100.00','1095000','0','0','15000','1110000','0','5000','0','1115000','TJ','T0080037','E1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZEBH-96-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='E1D-ZEBH-96-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 ('F226020844183','2026-06-02','1.000','2026-06-02','08:44:19','PLG0080639','1110000','1110000','5000','1115000','1115000','kasir','2026-06-02 08:44:18','F22602084418');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226020844183','2026-06-02','08:44:19','TJ','1115000','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-260602-0004','D','2026-06-02','08:44:19','kasir','PENJUALAN','F226020844183','10350968000','1115000','10352083000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1115000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020844183' 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 ('F226020844184','kasir',' 1',' MDE2 10K C','TOKO','SMBK-E','E2D-ZDBC-31-T','CC WEDDING MATA CM 18 8K ','OL','1.550','1','100.00','1697000','0','0','15000','1720000','0','8000','0','1728000','TJ','T0078912','E2D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZDBC-31-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='E2D-ZDBC-31-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 ('F226020844184','2026-06-02','1.550','2026-06-02','08:44:19','PLG0080640','1720000','1720000','8000','1728000','1728000','kasir','2026-06-02 08:44:18','F22602084418');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226020844184','2026-06-02','08:44:19','TJ','1728000','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-260602-0005','D','2026-06-02','08:44:19','kasir','PENJUALAN','F226020844184','10352083000','1728000','10353811000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1728000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020844184' 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 ('F226020855121','kasir','1',' MEE2 X LG ','TOKO','SMBK-E','E2E-ZEBH-409-0','CC X MODEL MATA LG 14 8K ','OL','0.480','1','100.00','535000','0','0','15000','543000','0','5000','0','548000','TJ','00405627','E2E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZEBH-409-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='E2E-ZEBH-409-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 ('F226020855121','2026-06-02','0.480','2026-06-02','08:55:13','PLG0080641','543000','543000','5000','548000','548000','kasir','2026-06-02 08:55:12','F22602085512');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226020855121','2026-06-02','08:55:13','TJ','548000','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-260602-0006','D','2026-06-02','08:55:13','kasir','PENJUALAN','F226020855121','10353811000','548000','10354359000');
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 ('F226020925071','kasir','1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZEBH-68-T','LT CHARM HURUF L BG 8K ','OL','0.620','1','100.00','704000','0','0','15000','713000','0','5000','0','718000','TIN','T0080009','D1F','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZEBH-68-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.620',berat_jual_asli=berat_jual_asli+'0.620',stock_jual='1',berat_akhir=berat_akhir-'0.620',berat_akhir_asli=berat_akhir_asli-'0.620',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='D1F-ZEBH-68-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 ('F226020925071','2026-06-02','0.620','2026-06-02','09:25:08','PLG0080642','713000','713000','5000','718000','718000','kasir','2026-06-02 09:25:07','F22602092507');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226020925071','2026-06-02','09:25:08','TIN','718000','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-260602-0007','D','2026-06-02','09:25:08','kasir','PENJUALAN','F226020925071','10354359000','718000','10355077000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020925071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020925071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020925071';
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 ('F226020958551','kasir','1',' MEB1 5K LG','TOKO','SMBK-B','B1E-ZEAE-53-T','GW TUSUK APEL CAT VAR LG PE 8K ','OL','0.480','1','100.00','535000','0','0','15000','543000','0','5000','0','548000','TJ','T0079479','B1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEAE-53-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='B1E-ZEAE-53-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 ('F226020958551','2026-06-02','0.480','2026-06-02','09:58:55','PLG0080643','543000','543000','5000','548000','548000','kasir','2026-06-02 09:58:55','F22602095855');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226020958551','2026-06-02','09:58:55','TJ','548000','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-260602-0008','D','2026-06-02','09:58:55','kasir','PENJUALAN','F226020958551','10355077000','548000','10355625000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='548000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020958551' 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 ('F226020958552','kasir',' 1',' MDE1D PM 1','TOKO','SMBK-E','E1D-ZEBH-94-T','CC MODEL DAUN SLEP PM 12 8K ','OL','0.950','1','100.00','1040000','0','0','15000','1055000','0','5000','0','1060000','TJ','T0080035','E1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZEBH-94-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='2026-06-02' AND kode_barang='E1D-ZEBH-94-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 ('F226020958552','2026-06-02','0.950','2026-06-02','09:58:55','PLG0080644','1055000','1055000','5000','1060000','1060000','kasir','2026-06-02 09:58:55','F22602095855');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226020958552','2026-06-02','09:58:55','TJ','1060000','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-260602-0009','D','2026-06-02','09:58:55','kasir','PENJUALAN','F226020958552','10355625000','1060000','10356685000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1060000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020958552' 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 ('F226021006591','kasir','1',' MEH1 KH 44','TOKO','SMBK-H','H1E-YBAC-50-0','KL NORY KH 44 8K ','','5.130','1','100.00','5720000','0','0','15000','5720000','0','0','0','5720000','RHM','00338880','H1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YBAC-50-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.130',berat_jual_asli=berat_jual_asli+'5.130',stock_jual='1',berat_akhir=berat_akhir-'5.130',berat_akhir_asli=berat_akhir_asli-'5.130',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='H1E-YBAC-50-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 ('F226021006591','2026-06-02','5.130','2026-06-02','10:06:59','PLG0080645','5720000','5720000','0','5720000','5720000','kasir','2026-06-02 10:06:59','F22602100659');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226021006591','2026-06-02','10:06:59','RHM','5720000','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-260602-0010','D','2026-06-02','10:06:59','kasir','PENJUALAN','F226021006591','10356685000','5720000','10362405000');
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 ('F226021017531','kasir','1',' MDE1 CM 18','TOKO','SMBK-E','E1D-ZACX-63-T','CC VELG POLOS CM 18 8K ','OL','0.950','1','100.00','1040000','0','0','15000','1055000','0','5000','0','1060000','TIN','T0076977','E1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZACX-63-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='2026-06-02' AND kode_barang='E1D-ZACX-63-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 ('F226021017531','2026-06-02','0.950','2026-06-02','10:17:54','PLG0080646','1055000','1055000','5000','1060000','1060000','kasir','2026-06-02 10:17:53','F22602101753');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226021017531','2026-06-02','10:17:54','TIN','1060000','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-260602-0011','D','2026-06-02','10:17:54','kasir','PENJUALAN','F226021017531','10362405000','1060000','10363465000');
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 ('F226021030321','kasir','1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZECX-18-T','CC MODEL ISYANA SLEP LG 16 8K ','OL','0.560','1','100.00','616000','0','0','15000','633000','0','0','0','633000','TJ','T0080084','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZECX-18-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='2026-06-02' AND kode_barang='E1E-ZECX-18-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 ('F226021030321','2026-06-02','0.560','2026-06-02','10:30:33','PLG0080647','633000','633000','0','633000','633000','kasir','2026-06-02 10:30:32','F22602103032');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226021030321','2026-06-02','10:30:33','TJ','633000','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-260602-0012','D','2026-06-02','10:30:33','kasir','PENJUALAN','F226021030321','10363465000','633000','10364098000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='633000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021030321' 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 ('F226021030322','kasir',' 1',' MHB1 CM ','TOKO','SMBK-B','B1H-ZDBE-12-T','GW TUSUK DAISY MATA CM 8K ','OL','0.260','1','100.00','305000','0','0','15000','309000','0','5000','0','314000','TJ','T0078981','B1H','0','0','-','0','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-ZDBE-12-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='2026-06-02' AND kode_barang='B1H-ZDBE-12-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 ('F226021030322','2026-06-02','0.260','2026-06-02','10:30:33','PLG0080648','309000','309000','5000','314000','314000','kasir','2026-06-02 10:30:32','F22602103032');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226021030322','2026-06-02','10:30:33','TJ','314000','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-260602-0013','D','2026-06-02','10:30:33','kasir','PENJUALAN','F226021030322','10364098000','314000','10364412000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='314000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021030322' 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 ('F226021039141','kasir','1',' TDE1 X CM ','TOKO','TBK-E','E1TD-YIXD-62-T','CC X MODEL SLEP CM 17 17K ','OL','0.930','1','100.00','1860000','0','0','15000','1869000','0','7000','0','1876000','TJ','T0072914','E1TD','0','0','-','0','2000000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-YIXD-62-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.930',berat_jual_asli=berat_jual_asli+'0.930',stock_jual='1',berat_akhir=berat_akhir-'0.930',berat_akhir_asli=berat_akhir_asli-'0.930',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='E1TD-YIXD-62-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 ('F226021039141','2026-06-02','0.930','2026-06-02','10:39:14','PLG0080649','1869000','1869000','7000','1876000','1876000','kasir','2026-06-02 10:39:14','F22602103914');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226021039141','2026-06-02','10:39:14','TJ','1876000','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-260602-0014','D','2026-06-02','10:39:14','kasir','PENJUALAN','F226021039141','10364412000','1876000','10366288000');
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 ('F226021053561','kasir','1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZEAH-1-T','GL MODEL FLIK BINTANG VAR HW 8K ','','1.580','1','100.00','1762000','0','0','15000','1762000','0','0','0','1762000','LUS','T0079563','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEAH-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.580',berat_jual_asli=berat_jual_asli+'1.580',stock_jual='1',berat_akhir=berat_akhir-'1.580',berat_akhir_asli=berat_akhir_asli-'1.580',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='F3E-ZEAH-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 ('F226021053561','2026-06-02','1.580','2026-06-02','10:53:56','PLG0080650','1762000','1762000','0','1762000','1762000','kasir','2026-06-02 10:53:56','F22602105356');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226021053561','2026-06-02','10:53:56','LUS','1762000','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-260602-0015','D','2026-06-02','10:53:56','kasir','PENJUALAN','F226021053561','10366288000','1762000','10368050000');
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 ('F226021113061','kasir','1',' MEF3 13K L','TOKO','SMBK-F','F3E-ZEAH-10-T','GL MODEL MEDAN PASIR LG 8K ','OL','2.750','1','100.00','3066000','0','0','15000','3094000','0','14000','0','3108000','LUS','T0079572','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEAH-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.750',berat_jual_asli=berat_jual_asli+'2.750',stock_jual='1',berat_akhir=berat_akhir-'2.750',berat_akhir_asli=berat_akhir_asli-'2.750',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='F3E-ZEAH-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 ('F226021113061','2026-06-02','2.750','2026-06-02','11:13:07','PLG0080651','3094000','3094000','14000','3108000','3108000','kasir','2026-06-02 11:13:06','F22602111306');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226021113061','2026-06-02','11:13:07','LUS','3108000','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-260602-0016','D','2026-06-02','11:13:07','kasir','PENJUALAN','F226021113061','10368050000','3108000','10371158000');
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 ('F226021114301','kasir','1',' MEB1 5K HW','TOKO','SMBK-B','B1E-ZEAF-20-T','GW TRIXIE PANJANG BUNGA CAT VAR HW 8K ','OL','0.520','1','100.00','580000','0','0','15000','588000','0','5000','0','593000','LUS','T0079542','B1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEAF-20-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='2026-06-02' AND kode_barang='B1E-ZEAF-20-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 ('F226021114301','2026-06-02','0.520','2026-06-02','11:14:30','PLG0080652','588000','588000','5000','593000','593000','kasir','2026-06-02 11:14:30','F22602111430');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226021114301','2026-06-02','11:14:30','LUS','593000','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-260602-0017','D','2026-06-02','11:14:30','kasir','PENJUALAN','F226021114301','10371158000','593000','10371751000');
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 ('F226021115211','kasir','1',' MEF3E HW ','TOKO','SMBK-F','F3E-ZEBF-24-T','GL MODEL CAPELA SLEP HW 8K ','OL','1.380','1','100.00','1539000','0','0','15000','1553000','0','7000','0','1560000','LUS','T0079907','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEBF-24-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.380',berat_jual_asli=berat_jual_asli+'1.380',stock_jual='1',berat_akhir=berat_akhir-'1.380',berat_akhir_asli=berat_akhir_asli-'1.380',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='F3E-ZEBF-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 ('F226021115211','2026-06-02','1.380','2026-06-02','11:15:22','PLG0080653','1553000','1553000','7000','1560000','1560000','kasir','2026-06-02 11:15:21','F22602111521');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226021115211','2026-06-02','11:15:22','LUS','1560000','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-260602-0018','D','2026-06-02','11:15:22','kasir','PENJUALAN','F226021115211','10371751000','1560000','10373311000');
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 ('F226021208061','kasir','1',' MEF3E HW ','TOKO','SMBK-F','F3E-ZEBF-23-T','GL MODEL FANCY VAR HW 8K ','','1.520','1','100.00','1695000','0','0','15000','1695000','0','0','0','1695000','TIN','T0079906','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEBF-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.520',berat_jual_asli=berat_jual_asli+'1.520',stock_jual='1',berat_akhir=berat_akhir-'1.520',berat_akhir_asli=berat_akhir_asli-'1.520',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='F3E-ZEBF-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 ('F226021208061','2026-06-02','1.520','2026-06-02','12:08:07','PLG0080654','1695000','1695000','0','1695000','1695000','kasir','2026-06-02 12:08:06','F22602120806');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226021208061','2026-06-02','12:08:07','TIN','1695000','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-260602-0019','D','2026-06-02','12:08:07','kasir','PENJUALAN','F226021208061','10373311000','1695000','10375006000');
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 ('F226021222081','kasir','1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZECX-21-T','CC MODEL ISYANA SLEP LG 12 8K ','OL','0.480','1','100.00','528000','0','0','15000','540000','0','5000','0','545000','TIN','T0080087','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZECX-21-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='E1E-ZECX-21-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 ('F226021222081','2026-06-02','0.480','2026-06-02','12:22:09','PLG0080655','540000','540000','5000','545000','545000','kasir','2026-06-02 12:22:08','F22602122208');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226021222081','2026-06-02','12:22:09','TIN','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) VALUES ('KM-260602-0020','D','2026-06-02','12:22:09','kasir','PENJUALAN','F226021222081','10375006000','545000','10375551000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021222081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021222081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021222081';
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 ('F226021227501','kasir','1',' MEF3E UB ','TOKO','SMBK-F','F3E-ZEBA-35-T','GL LONG LING SLEP UB 8K ','OL','1.000','1','100.00','1115000','0','0','15000','1120000','0','5000','0','1125000','TIN','T0079742','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEBA-35-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='F3E-ZEBA-35-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 ('F226021227501','2026-06-02','1.000','2026-06-02','12:27:50','PLG0080656','1120000','1120000','5000','1125000','1125000','kasir','2026-06-02 12:27:50','F22602122750');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226021227501','2026-06-02','12:27:50','TIN','1125000','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-260602-0021','D','2026-06-02','12:27:50','kasir','PENJUALAN','F226021227501','10375551000','1125000','10376676000');
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 ('F226021244541','kasir','1',' MED1E CM ','TOKO','SMBK-D','D1E-ZEBH-106-T','LT LETTERA PLAT SLEP CM 8K ','OL','0.550','1','100.00','613000','0','0','15000','619000','0','5000','0','624000','TIN','T0080047','D1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZEBH-106-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='2026-06-02' AND kode_barang='D1E-ZEBH-106-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 ('F226021244541','2026-06-02','0.550','2026-06-02','12:44:55','PLG0080657','619000','619000','5000','624000','624000','kasir','2026-06-02 12:44:54','F22602124454');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226021244541','2026-06-02','12:44:55','TIN','624000','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-260602-0022','D','2026-06-02','12:44:55','kasir','PENJUALAN','F226021244541','10376676000','624000','10377300000');
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 ('F226021247501','kasir','1',' TEE1 X BM ','TOKO','TBK-E','E1TE-XBBD-21-T','CC X VELG KACA BM 12 ','','1.070','1','100.00','2161000','0','0','15000','2183000','0','0','0','2183000','LUS','T0054257','E1TE','0','0','-','0','2020000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TE-XBBD-21-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='2026-06-02' AND kode_barang='E1TE-XBBD-21-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 ('F226021247501','2026-06-02','1.070','2026-06-02','12:47:50','PLG0080658','2183000','2183000','0','2183000','2183000','kasir','2026-06-02 12:47:50','F22602124750');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226021247501','2026-06-02','12:47:50','LUS','2183000','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-260602-0023','D','2026-06-02','12:47:50','kasir','PENJUALAN','F226021247501','10377300000','2183000','10379483000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2183000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021247501' 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 ('F226021247502','kasir',' 1',' TDE2 X CM ','TOKO','TBK-E','E2TD-YFBF-93-T','CC X WEDDING MATA CM 16 17K ','','2.500','1','100.00','5000000','0','0','15000','5050000','0','0','0','5050000','LUS','T0070460','E2TD','0','0','-','0','2000000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-YFBF-93-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.500',berat_jual_asli=berat_jual_asli+'2.500',stock_jual='1',berat_akhir=berat_akhir-'2.500',berat_akhir_asli=berat_akhir_asli-'2.500',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='E2TD-YFBF-93-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 ('F226021247502','2026-06-02','2.500','2026-06-02','12:47:50','PLG0080659','5050000','5050000','0','5050000','5050000','kasir','2026-06-02 12:47:50','F22602124750');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226021247502','2026-06-02','12:47:50','LUS','5050000','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-260602-0024','D','2026-06-02','12:47:50','kasir','PENJUALAN','F226021247502','10379483000','5050000','10384533000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5050000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021247502' 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 ('F226021251481','kasir','1',' MEF1 UB D6','TOKO','SMBK-F','F1E-ZEAE-2-T','GL OVAL MODEL C UB D65 8K ','OLS MS55V','2.540','1','100.00','2832000','0','0','15000','2832000','0','195000','0','3027000','TJ','T0079428','F1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZEAE-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.540',berat_jual_asli=berat_jual_asli+'2.540',stock_jual='1',berat_akhir=berat_akhir-'2.540',berat_akhir_asli=berat_akhir_asli-'2.540',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='F1E-ZEAE-2-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 ('F226021251481','2026-06-02','2.540','2026-06-02','12:51:49','PLG0080660','2832000','2832000','195000','3027000','3027000','kasir','2026-06-02 12:51:48','F22602125148');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226021251481','2026-06-02','12:51:49','TJ','3027000','195000');
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-260602-0025','D','2026-06-02','12:51:49','kasir','PENJUALAN','F226021251481','10384533000','3027000','10387560000');
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 ('F226021257121','kasir','1',' MEB1 5K BW','TOKO','SMBK-B','B1E-ZDCX-18-T','GW TUSUK KUPU PASIR BW 8K ','OL','0.460','1','100.00','513000','0','0','15000','520000','0','5000','0','525000','LUS','T0079087','B1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZDCX-18-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='2026-06-02' AND kode_barang='B1E-ZDCX-18-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 ('F226021257121','2026-06-02','0.460','2026-06-02','12:57:12','PLG0080661','520000','520000','5000','525000','525000','kasir','2026-06-02 12:57:12','F22602125712');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226021257121','2026-06-02','12:57:12','LUS','525000','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-260602-0026','D','2026-06-02','12:57:12','kasir','PENJUALAN','F226021257121','10387560000','525000','10388085000');
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 ('F226021258041','kasir','1',' MEB1 5K LG','TOKO','SMBK-B','B1E-ZEAE-52-T','GW TUSUK APEL CAT VAR LG PE 8K ','OL','0.470','1','100.00','524000','0','0','15000','531000','0','5000','0','536000','LUS','T0079478','B1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEAE-52-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='B1E-ZEAE-52-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 ('F226021258041','2026-06-02','0.470','2026-06-02','12:58:04','PLG0080662','531000','531000','5000','536000','536000','kasir','2026-06-02 12:58:04','F22602125804');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226021258041','2026-06-02','12:58:04','LUS','536000','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-260602-0027','D','2026-06-02','12:58:04','kasir','PENJUALAN','F226021258041','10388085000','536000','10388621000');
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 ('F226021258461','kasir','1',' MEE1 X LG ','TOKO','SMBK-E','E1E-ZEBH-415-0','CC X MODEL SLEP LG 18 8K ','OL','0.500','1','100.00','557000','0','0','15000','565000','0','5000','0','570000','LUS','00405633','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBH-415-0' 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='2026-06-02' AND kode_barang='E1E-ZEBH-415-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 ('F226021258461','2026-06-02','0.500','2026-06-02','12:58:47','PLG0080663','565000','565000','5000','570000','570000','kasir','2026-06-02 12:58:46','F22602125846');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226021258461','2026-06-02','12:58:47','LUS','570000','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-260602-0028','D','2026-06-02','12:58:47','kasir','PENJUALAN','F226021258461','10388621000','570000','10389191000');
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 ('F226020104501','kasir','1',' MEF3E UB ','TOKO','SMBK-F','F3E-ZEBX-77-T','GL KOREA POLOS UB 8K ','OL','0.570','1','100.00','636000','0','0','15000','645000','0','5000','0','650000','LUS','T0079668','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEBX-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='2026-06-02' AND kode_barang='F3E-ZEBX-77-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 ('F226020104501','2026-06-02','0.570','2026-06-02','13:04:51','PLG0080664','645000','645000','5000','650000','650000','kasir','2026-06-02 13:04:50','F22602010450');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226020104501','2026-06-02','13:04:51','LUS','650000','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-260602-0029','D','2026-06-02','13:04:51','kasir','PENJUALAN','F226020104501','10389191000','650000','10389841000');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-ZFXB-1-T','T0080146','MEH1 10K LG34 ','KL TIFF ANAK BONEKA MATA CAT SLEP LG 34 8K ','','GR','---','ME','H1E','TOKO','01-SEM','1929000','2026-06-02','1929000','1.730','100.00','8','0','1115000.00','1','0.04', 'input','2026-06-02 13:57:50','1.730','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-ZFXB-1-T','T0080146');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-02','H1E-ZFXB-1-T','H1E','TOKO','01-SEM','100.00','1.730','1.730','1','1.730','1.730','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-ZFXB-2-T','T0080147','MEH1E UB 40 ','KL TIFF BOTEGA SLEP UB 40 8K ','','GR','---','ME','H1E','TOKO','01-SEM','1305000','2026-06-02','1305000','1.170','100.00','8','0','1115000.00','1','0.04', 'input','2026-06-02 13:59:32','1.170','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-ZFXB-2-T','T0080147');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-02','H1E-ZFXB-2-T','H1E','TOKO','01-SEM','100.00','1.170','1.170','1','1.170','1.170','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-ZFXB-3-T','T0080148','MEH1E HW42 ','KL SANTA PITA MATA SLEP HW 42 8K ','','GR','---','ME','H1E','TOKO','01-SEM','2654000','2026-06-02','2654000','2.380','100.00','8','0','1115000.00','1','0.04', 'input','2026-06-02 14:01:06','2.380','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-ZFXB-3-T','T0080148');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-02','H1E-ZFXB-3-T','H1E','TOKO','01-SEM','100.00','2.380','2.380','1','2.380','2.380','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260602-0001','1','H1E-ZFXB-1-T','1','1.73','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-ZFXB-1-T' AND kode_lokasi_toko = '01-SEM';
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 ('2026-06-02','TOKO','SMBK-H','H1E','H1E-ZFXB-1-T' , '1','1.73','1.73', '1','1.73','1.73','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.73',berat_out_asli=berat_out_asli+'1.73',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-ZFXB-1-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260602-0001','2','H1E-ZFXB-2-T','1','1.17','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-ZFXB-2-T' AND kode_lokasi_toko = '01-SEM';
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 ('2026-06-02','TOKO','SMBK-H','H1E','H1E-ZFXB-2-T' , '1','1.17','1.17', '1','1.17','1.17','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.17',berat_out_asli=berat_out_asli+'1.17',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-ZFXB-2-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260602-0001','3','H1E-ZFXB-3-T','1','2.38','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-ZFXB-3-T' AND kode_lokasi_toko = '01-SEM';
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 ('2026-06-02','TOKO','SMBK-H','H1E','H1E-ZFXB-3-T' , '1','2.38','2.38', '1','2.38','2.38','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.38',berat_out_asli=berat_out_asli+'2.38',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-ZFXB-3-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('PB-260602-0001','2026-06-02','2026-06-02','14:01','5.28','input','2026-06-02 14:01:35');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('D1D-ZFXB-4-T','T0080149','MDD1 7K UB ','LT MODEL BUNGA KARAWANG SLEP UB 8K ','','GR','---','MD','D1D','TOKO','01-SEM','1391000','2026-06-02','1391000','1.270','100.00','8','0','1095000.00','1','0.04', 'input','2026-06-02 14:04:19','1.270','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1D','D1D-ZFXB-4-T','T0080149');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-02','D1D-ZFXB-4-T','D1D','TOKO','01-SEM','100.00','1.270','1.270','1','1.270','1.270','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260602-0002','1','D1D-ZFXB-4-T','1','1.27','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1D-ZFXB-4-T' AND kode_lokasi_toko = '01-SEM';
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 ('2026-06-02','TOKO','SMBK-D','D1D','D1D-ZFXB-4-T' , '1','1.27','1.27', '1','1.27','1.27','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.27',berat_out_asli=berat_out_asli+'1.27',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1D-ZFXB-4-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('PB-260602-0002','2026-06-02','2026-06-02','14:04','1.27','input','2026-06-02 14:04:49');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('B1E-ZFXB-5-T','T0080150','MEB1E LG ','GW PANJANG TIFF KUPU MATA SLEP LG 8K ','','GR','---','ME','B1E','TOKO','01-SEM','658000','2026-06-02','658000','0.590','100.00','8','0','1115000.00','1','0.04', 'input','2026-06-02 14:07:56','0.590','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'B1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('B1E','B1E-ZFXB-5-T','T0080150');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-02','B1E-ZFXB-5-T','B1E','TOKO','01-SEM','100.00','0.590','0.590','1','0.590','0.590','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('B1E-ZFXB-6-T','T0080151','MEB1E LG ','GW PANJANG TIFF KUPU MATA SLEP LG 8K ','','GR','---','ME','B1E','TOKO','01-SEM','691500','2026-06-02','691500','0.620','100.00','8','0','1115000.00','1','0.04', 'input','2026-06-02 14:08:22','0.620','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'B1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('B1E','B1E-ZFXB-6-T','T0080151');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-02','B1E-ZFXB-6-T','B1E','TOKO','01-SEM','100.00','0.620','0.620','1','0.620','0.620','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('B1E-ZFXB-7-T','T0080152','MEB1E LG ','GW PANJANG TIFF KUPU MATA SLEP LG 8K ','','GR','---','ME','B1E','TOKO','01-SEM','658000','2026-06-02','658000','0.590','100.00','8','0','1115000.00','1','0.04', 'input','2026-06-02 14:08:52','0.590','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'B1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('B1E','B1E-ZFXB-7-T','T0080152');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-02','B1E-ZFXB-7-T','B1E','TOKO','01-SEM','100.00','0.590','0.590','1','0.590','0.590','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('B1E-ZFXB-8-T','T0080153','MEB1E LG ','GW PANJANG TIFF KUPU MATA SLEP LG 8K ','','GR','---','ME','B1E','TOKO','01-SEM','680500','2026-06-02','680500','0.610','100.00','8','0','1115000.00','1','0.04', 'input','2026-06-02 14:09:19','0.610','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'B1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('B1E','B1E-ZFXB-8-T','T0080153');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-02','B1E-ZFXB-8-T','B1E','TOKO','01-SEM','100.00','0.610','0.610','1','0.610','0.610','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('B1D-ZFXB-9-T','T0080154','MDB1D HW ','GW ITALY PANJANG KUPU SLEP HW 8K ','','GR','---','MD','B1D','TOKO','01-SEM','920000','2026-06-02','920000','0.840','100.00','8','0','1095000.00','1','0.04', 'input','2026-06-02 14:11:21','0.840','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'B1D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('B1D','B1D-ZFXB-9-T','T0080154');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-02','B1D-ZFXB-9-T','B1D','TOKO','01-SEM','100.00','0.840','0.840','1','0.840','0.840','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('B1D-ZFXB-10-T','T0080155','MDB1D HW ','GW ITALY PANJANG KUPU SLEP HW 8K ','','GR','---','MD','B1D','TOKO','01-SEM','920000','2026-06-02','920000','0.840','100.00','8','0','1095000.00','1','0.04', 'input','2026-06-02 14:11:41','0.840','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'B1D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('B1D','B1D-ZFXB-10-T','T0080155');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-02','B1D-ZFXB-10-T','B1D','TOKO','01-SEM','100.00','0.840','0.840','1','0.840','0.840','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260602-0003','1','B1D-ZFXB-10-T','1','0.84','0','TOKO','01-SEM','TOKO','SMBK-B');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-B' WHERE kode_barang = 'B1D-ZFXB-10-T' AND kode_lokasi_toko = '01-SEM';
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 ('2026-06-02','TOKO','SMBK-B','B1D','B1D-ZFXB-10-T' , '1','0.84','0.84', '1','0.84','0.84','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.84',berat_out_asli=berat_out_asli+'0.84',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='B1D-ZFXB-10-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260602-0003','2','B1D-ZFXB-9-T','1','0.84','0','TOKO','01-SEM','TOKO','SMBK-B');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-B' WHERE kode_barang = 'B1D-ZFXB-9-T' AND kode_lokasi_toko = '01-SEM';
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 ('2026-06-02','TOKO','SMBK-B','B1D','B1D-ZFXB-9-T' , '1','0.84','0.84', '1','0.84','0.84','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.84',berat_out_asli=berat_out_asli+'0.84',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='B1D-ZFXB-9-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260602-0003','3','B1E-ZFXB-5-T','1','0.59','0','TOKO','01-SEM','TOKO','SMBK-B');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-B' WHERE kode_barang = 'B1E-ZFXB-5-T' AND kode_lokasi_toko = '01-SEM';
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 ('2026-06-02','TOKO','SMBK-B','B1E','B1E-ZFXB-5-T' , '1','0.59','0.59', '1','0.59','0.59','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.59',berat_out_asli=berat_out_asli+'0.59',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='B1E-ZFXB-5-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260602-0003','4','B1E-ZFXB-6-T','1','0.62','0','TOKO','01-SEM','TOKO','SMBK-B');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-B' WHERE kode_barang = 'B1E-ZFXB-6-T' AND kode_lokasi_toko = '01-SEM';
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 ('2026-06-02','TOKO','SMBK-B','B1E','B1E-ZFXB-6-T' , '1','0.62','0.62', '1','0.62','0.62','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.62',berat_out_asli=berat_out_asli+'0.62',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='B1E-ZFXB-6-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260602-0003','5','B1E-ZFXB-7-T','1','0.59','0','TOKO','01-SEM','TOKO','SMBK-B');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-B' WHERE kode_barang = 'B1E-ZFXB-7-T' AND kode_lokasi_toko = '01-SEM';
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 ('2026-06-02','TOKO','SMBK-B','B1E','B1E-ZFXB-7-T' , '1','0.59','0.59', '1','0.59','0.59','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.59',berat_out_asli=berat_out_asli+'0.59',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='B1E-ZFXB-7-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260602-0003','6','B1E-ZFXB-8-T','1','0.61','0','TOKO','01-SEM','TOKO','SMBK-B');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-B' WHERE kode_barang = 'B1E-ZFXB-8-T' AND kode_lokasi_toko = '01-SEM';
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 ('2026-06-02','TOKO','SMBK-B','B1E','B1E-ZFXB-8-T' , '1','0.61','0.61', '1','0.61','0.61','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.61',berat_out_asli=berat_out_asli+'0.61',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='B1E-ZFXB-8-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('PB-260602-0003','2026-06-02','2026-06-02','14:12','4.09','input','2026-06-02 14:12:18');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('A1D-ZFXB-11-T','T0080156','MDA1D HW ','AT KLIP PITA MATA SLEP HW 8K ','','GR','---','MD','A1D','TOKO','01-SEM','1051500','2026-06-02','1051500','0.960','100.00','8','0','1095000.00','1','0.04', 'input','2026-06-02 14:15:34','0.960','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'A1D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('A1D','A1D-ZFXB-11-T','T0080156');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-02','A1D-ZFXB-11-T','A1D','TOKO','01-SEM','100.00','0.960','0.960','1','0.960','0.960','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('A1E-ZFXB-12-T','T0080157','MEA1E HW ','AT MODEL HATI ARESO SLEP HW 8K ','','GR','---','ME','A1E','TOKO','01-SEM','859000','2026-06-02','859000','0.770','100.00','8','0','1115000.00','1','0.04', 'input','2026-06-02 14:17:18','0.770','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'A1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('A1E','A1E-ZFXB-12-T','T0080157');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-02','A1E-ZFXB-12-T','A1E','TOKO','01-SEM','100.00','0.770','0.770','1','0.770','0.770','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260602-0004','1','A1D-ZFXB-11-T','1','0.96','0','TOKO','01-SEM','TOKO','SMBK-A');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-A' WHERE kode_barang = 'A1D-ZFXB-11-T' AND kode_lokasi_toko = '01-SEM';
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 ('2026-06-02','TOKO','SMBK-A','A1D','A1D-ZFXB-11-T' , '1','0.96','0.96', '1','0.96','0.96','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.96',berat_out_asli=berat_out_asli+'0.96',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='A1D-ZFXB-11-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260602-0004','2','A1E-ZFXB-12-T','1','0.77','0','TOKO','01-SEM','TOKO','SMBK-A');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-A' WHERE kode_barang = 'A1E-ZFXB-12-T' AND kode_lokasi_toko = '01-SEM';
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 ('2026-06-02','TOKO','SMBK-A','A1E','A1E-ZFXB-12-T' , '1','0.77','0.77', '1','0.77','0.77','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.77',berat_out_asli=berat_out_asli+'0.77',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='A1E-ZFXB-12-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('PB-260602-0004','2026-06-02','2026-06-02','14:17','1.73','input','2026-06-02 14:17:45');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2D-ZFXB-13-T','T0080158','MDE2D CM 18 ','CC MODEL MATA SLEP CM 18 8K ','','GR','---','MD','E2D','TOKO','01-SEM','1347000','2026-06-02','1347000','1.230','100.00','8','0','1095000.00','1','0.04', 'input','2026-06-02 14:19:50','1.230','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2D','E2D-ZFXB-13-T','T0080158');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-02','E2D-ZFXB-13-T','E2D','TOKO','01-SEM','100.00','1.230','1.230','1','1.230','1.230','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2D-ZFXB-14-T','T0080159','MDE2D CM 16 ','CC MODEL MATA SLEP CM 16 8K ','','GR','---','MD','E2D','TOKO','01-SEM','1391000','2026-06-02','1391000','1.270','100.00','8','0','1095000.00','1','0.04', 'input','2026-06-02 14:20:21','1.270','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2D','E2D-ZFXB-14-T','T0080159');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-02','E2D-ZFXB-14-T','E2D','TOKO','01-SEM','100.00','1.270','1.270','1','1.270','1.270','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2D-ZFXB-15-T','T0080160','MDE2D CM 18 ','CC MODEL MATA SLEP CM 18 8K ','','GR','---','MD','E2D','TOKO','01-SEM','2332500','2026-06-02','2332500','2.130','100.00','8','0','1095000.00','1','0.04', 'input','2026-06-02 14:21:26','2.130','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2D','E2D-ZFXB-15-T','T0080160');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-02','E2D-ZFXB-15-T','E2D','TOKO','01-SEM','100.00','2.130','2.130','1','2.130','2.130','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2D-ZFXB-16-T','T0080161','MDE2D CM 24 ','CC MODEL MATA SLEP CM 24 8K ','','GR','---','MD','E2D','TOKO','01-SEM','1960500','2026-06-02','1960500','1.790','100.00','8','0','1095000.00','1','0.04', 'input','2026-06-02 14:22:06','1.790','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2D','E2D-ZFXB-16-T','T0080161');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-02','E2D-ZFXB-16-T','E2D','TOKO','01-SEM','100.00','1.790','1.790','1','1.790','1.790','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2D-ZFXB-17-T','T0080162','MDE2D BM 16 ','CC MODEL MATA SLEP BM 16 8K ','','GR','---','MD','E2D','TOKO','01-SEM','1719500','2026-06-02','1719500','1.570','100.00','8','0','1095000.00','1','0.04', 'input','2026-06-02 14:23:01','1.570','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2D','E2D-ZFXB-17-T','T0080162');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-02','E2D-ZFXB-17-T','E2D','TOKO','01-SEM','100.00','1.570','1.570','1','1.570','1.570','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2D-ZFXB-18-T','T0080163','MDE2D BM 22 ','CC MODEL MATA SLEP BM 22 8K ','','GR','---','MD','E2D','TOKO','01-SEM','1796000','2026-06-02','1796000','1.640','100.00','8','0','1095000.00','1','0.04', 'input','2026-06-02 14:23:30','1.640','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2D','E2D-ZFXB-18-T','T0080163');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-02','E2D-ZFXB-18-T','E2D','TOKO','01-SEM','100.00','1.640','1.640','1','1.640','1.640','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1D-ZFXB-19-T','T0080164','MDE1D CM 16 ','CC MODEL SLEP CM 16 8K ','','GR','---','MD','E1D','TOKO','01-SEM','1489500','2026-06-02','1489500','1.360','100.00','8','0','1095000.00','1','0.04', 'input','2026-06-02 14:24:20','1.360','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1D','E1D-ZFXB-19-T','T0080164');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-02','E1D-ZFXB-19-T','E1D','TOKO','01-SEM','100.00','1.360','1.360','1','1.360','1.360','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1D-ZFXB-20-T','T0080165','MDE1D CM 22 ','CC MODEL SLEP CM 22 8K ','','GR','---','MD','E1D','TOKO','01-SEM','1653500','2026-06-02','1653500','1.510','100.00','8','0','1095000.00','1','0.04', 'input','2026-06-02 14:24:40','1.510','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1D','E1D-ZFXB-20-T','T0080165');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-02','E1D-ZFXB-20-T','E1D','TOKO','01-SEM','100.00','1.510','1.510','1','1.510','1.510','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260602-0005','1','E1D-ZFXB-19-T','1','1.36','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1D-ZFXB-19-T' AND kode_lokasi_toko = '01-SEM';
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 ('2026-06-02','TOKO','SMBK-E','E1D','E1D-ZFXB-19-T' , '1','1.36','1.36', '1','1.36','1.36','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.36',berat_out_asli=berat_out_asli+'1.36',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1D-ZFXB-19-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260602-0005','2','E1D-ZFXB-20-T','1','1.51','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1D-ZFXB-20-T' AND kode_lokasi_toko = '01-SEM';
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 ('2026-06-02','TOKO','SMBK-E','E1D','E1D-ZFXB-20-T' , '1','1.51','1.51', '1','1.51','1.51','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.51',berat_out_asli=berat_out_asli+'1.51',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1D-ZFXB-20-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260602-0005','3','E2D-ZFXB-13-T','1','1.23','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2D-ZFXB-13-T' AND kode_lokasi_toko = '01-SEM';
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 ('2026-06-02','TOKO','SMBK-E','E2D','E2D-ZFXB-13-T' , '1','1.23','1.23', '1','1.23','1.23','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.23',berat_out_asli=berat_out_asli+'1.23',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2D-ZFXB-13-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260602-0005','4','E2D-ZFXB-14-T','1','1.27','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2D-ZFXB-14-T' AND kode_lokasi_toko = '01-SEM';
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 ('2026-06-02','TOKO','SMBK-E','E2D','E2D-ZFXB-14-T' , '1','1.27','1.27', '1','1.27','1.27','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.27',berat_out_asli=berat_out_asli+'1.27',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2D-ZFXB-14-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260602-0005','5','E2D-ZFXB-15-T','1','2.13','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2D-ZFXB-15-T' AND kode_lokasi_toko = '01-SEM';
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 ('2026-06-02','TOKO','SMBK-E','E2D','E2D-ZFXB-15-T' , '1','2.13','2.13', '1','2.13','2.13','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.13',berat_out_asli=berat_out_asli+'2.13',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2D-ZFXB-15-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260602-0005','6','E2D-ZFXB-16-T','1','1.79','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2D-ZFXB-16-T' AND kode_lokasi_toko = '01-SEM';
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 ('2026-06-02','TOKO','SMBK-E','E2D','E2D-ZFXB-16-T' , '1','1.79','1.79', '1','1.79','1.79','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.79',berat_out_asli=berat_out_asli+'1.79',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2D-ZFXB-16-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260602-0005','7','E2D-ZFXB-17-T','1','1.57','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2D-ZFXB-17-T' AND kode_lokasi_toko = '01-SEM';
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 ('2026-06-02','TOKO','SMBK-E','E2D','E2D-ZFXB-17-T' , '1','1.57','1.57', '1','1.57','1.57','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.57',berat_out_asli=berat_out_asli+'1.57',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2D-ZFXB-17-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260602-0005','8','E2D-ZFXB-18-T','1','1.64','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E2D-ZFXB-18-T' AND kode_lokasi_toko = '01-SEM';
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 ('2026-06-02','TOKO','SMBK-E','E2D','E2D-ZFXB-18-T' , '1','1.64','1.64', '1','1.64','1.64','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.64',berat_out_asli=berat_out_asli+'1.64',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2D-ZFXB-18-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('PB-260602-0005','2026-06-02','2026-06-02','14:25','12.5','input','2026-06-02 14:25:10');
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 ('F226020244171','kasir','1',' MDA1D X CM','TOKO','SMBK-A','A1D-ZEBE-50-0','AT X HUGGIES DAUN KLIP SLEP CM 8K ','OL','1.000','1','100.00','1095000','0','0','15000','1105000','0','5000','0','1110000','TJ','00404749','A1D','0','0','-','1','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZEBE-50-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='A1D-ZEBE-50-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 ('F226020244171','2026-06-02','1.000','2026-06-02','14:44:18','PLG0080665','1105000','1105000','5000','1110000','1110000','kasir','2026-06-02 14:44:17','F22602024417');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226020244171','2026-06-02','14:44:18','TJ','1110000','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-260602-0030','D','2026-06-02','14:44:18','kasir','PENJUALAN','F226020244171','10389841000','1110000','10390951000');
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 ('F226020248271','kasir','1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZBAI-1-T','GL RANTAI HOLLOW PLAT UB 8K ','OL','4.070','1','100.00','4538000','0','0','15000','4559000','0','20000','0','4579000','TIN','T0077533','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBAI-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.070',berat_jual_asli=berat_jual_asli+'4.070',stock_jual='1',berat_akhir=berat_akhir-'4.070',berat_akhir_asli=berat_akhir_asli-'4.070',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='F3E-ZBAI-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 ('F226020248271','2026-06-02','4.070','2026-06-02','14:48:28','PLG0080666','4559000','4559000','20000','4579000','4579000','kasir','2026-06-02 14:48:27','F22602024827');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226020248271','2026-06-02','14:48:28','TIN','4579000','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-260602-0031','D','2026-06-02','14:48:28','kasir','PENJUALAN','F226020248271','10390951000','4579000','10395530000');
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 ('F226020324521','kasir','1',' MEF3E HW ','TOKO','SMBK-F','F3E-ZEBF-22-T','GL MODEL FANCY VAR HW 8K ','','1.530','1','100.00','1706000','0','0','15000','1706000','0','0','0','1706000','TJ','T0079905','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEBF-22-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.530',berat_jual_asli=berat_jual_asli+'1.530',stock_jual='1',berat_akhir=berat_akhir-'1.530',berat_akhir_asli=berat_akhir_asli-'1.530',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='F3E-ZEBF-22-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 ('F226020324521','2026-06-02','1.530','2026-06-02','15:24:53','PLG0080667','1706000','1706000','0','1706000','1706000','kasir','2026-06-02 15:24:52','F22602032452');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226020324521','2026-06-02','15:24:53','TJ','1706000','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-260602-0032','D','2026-06-02','15:24:53','kasir','PENJUALAN','F226020324521','10395530000','1706000','10397236000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020104501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020104501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020104501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020244171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020244171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020244171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020248271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020248271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020248271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020324521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020324521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020324521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020844181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020844181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020844181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020844182' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020844182' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020844182';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020844183' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020844183' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020844183';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020844184' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020844184' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020844184';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020855121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020855121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020855121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020958551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020958551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020958551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020958552' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020958552' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020958552';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021006591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021006591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021006591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021017531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021017531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021017531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021030321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021030321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021030321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021030322' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021030322' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021030322';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021039141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021039141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021039141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021053561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021053561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021053561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021113061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021113061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021113061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021114301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021114301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021114301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021115211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021115211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021115211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021208061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021208061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021208061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021227501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021227501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021227501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021244541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021244541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021244541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021247501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021247501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021247501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021247502' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021247502' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021247502';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021251481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021251481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021251481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021257121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021257121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021257121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021258041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021258041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021258041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021258461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021258461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021258461';
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 ('F226020345521','kasir','1',' MEE1E CM 1','TOKO','SMBK-E','E1E-ZEBH-47-T','CC MODEL MATA SLEP CM 12 8K ','OL','0.630','1','100.00','702000','0','0','15000','709000','0','5000','0','714000','TIN','T0079988','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBH-47-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='2026-06-02' AND kode_barang='E1E-ZEBH-47-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 ('F226020345521','2026-06-02','0.630','2026-06-02','15:45:52','PLG0080668','709000','709000','5000','714000','714000','kasir','2026-06-02 15:45:52','F22602034552');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226020345521','2026-06-02','15:45:52','TIN','714000','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-260602-0033','D','2026-06-02','15:45:52','kasir','PENJUALAN','F226020345521','10397236000','714000','10397950000');
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 ('F226020346141','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZEBH-381-0','CC X MODEL MATA CM 20 8K ','OL','1.770','1','100.00','1938000','0','0','15000','1947000','0','9000','0','1956000','TIN','00405599','E2D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEBH-381-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.770',berat_jual_asli=berat_jual_asli+'1.770',stock_jual='1',berat_akhir=berat_akhir-'1.770',berat_akhir_asli=berat_akhir_asli-'1.770',stock_akhir='0' WHERE tanggal='2026-06-02' AND kode_barang='E2D-ZEBH-381-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 ('F226020346141','2026-06-02','1.770','2026-06-02','15:46:14','PLG0080669','1947000','1947000','9000','1956000','1956000','kasir','2026-06-02 15:46:14','F22602034614');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226020346141','2026-06-02','15:46:14','TIN','1956000','9000');
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-260602-0034','D','2026-06-02','15:46:14','kasir','PENJUALAN','F226020346141','10397950000','1956000','10399906000');
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 ('F226020347451','kasir','1',' MEB1 5K HW','TOKO','SMBK-B','B1E-ZECX-50-T','GW TIFF PANJANG CAT VAR SLEP HW 8K ','OL','0.510','1','100.00','561000','0','0','15000','576000','0','5000','0','581000','TJ','T0080116','B1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZECX-50-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='2026-06-02' AND kode_barang='B1E-ZECX-50-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 ('F226020347451','2026-06-02','0.510','2026-06-02','15:47:46','PLG0080670','576000','576000','5000','581000','581000','kasir','2026-06-02 15:47:45','F22602034745');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226020347451','2026-06-02','15:47:46','TJ','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-260602-0035','D','2026-06-02','15:47:46','kasir','PENJUALAN','F226020347451','10399906000','581000','10400487000','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='F226020347451' 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 ('F226020347452','kasir',' 1',' MEB1 5K HW','TOKO','SMBK-B','B1E-ZECX-51-T','GW TIFF PANJANG CAT VAR SLEP HW 8K ','OL','0.520','1','100.00','572000','0','0','15000','588000','0','5000','0','593000','TJ','T0080117','B1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZECX-51-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='2026-06-02' AND kode_barang='B1E-ZECX-51-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 ('F226020347452','2026-06-02','0.520','2026-06-02','15:47:46','PLG0080671','588000','588000','5000','593000','593000','kasir','2026-06-02 15:47:45','F22602034745');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-02','F226020347452','2026-06-02','15:47:46','TJ','593000','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-260602-0036','D','2026-06-02','15:47:46','kasir','PENJUALAN','F226020347452','10400487000','593000','10401080000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='593000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020347452' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020345521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020345521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020345521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020346141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020346141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020346141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020347451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020347451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020347451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020347452' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020347452' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020347452';
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-00005410','X-00005410','LT MODEL DAUN SLEP VAR LG 8K','GR','---','D1F','BELI','BELI001','350000','2026-06-02','0.350','1','kasir','2026-06-02 16:31:01');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1F','X-00005410','X-00005410');
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-260602-0001','F226091254021','LUS','1','BELI','BELI001','D1F', 'X-00005410', 'LT MODEL DAUN SLEP VAR LG 8K','0.350','0.350','100.00','403000','350000','1000000','1135000','1','350000','350000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.350',berat_beli_asli=berat_beli_asli+'0.350',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.350',berat_akhir_asli=berat_akhir_asli+'0.350',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1F' 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-260602-0001','2026-06-02','2026-06-02','16:31:00','LUS','---','0.350','350000','350000','350000','350000','350000','kasir','2026-06-02 16:31:01','FB-260602-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260602-0001','AMEL','JL BARONG 5 KERTOSARI','','','085334077788','kasir','2026-06-02 16:31:01');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-02' 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-260602-0037','K','2026-06-02','16:31:00','kasir','PEMBELIAN UMUM','FB-260602-0001','10401080000','350000','10400730000');
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-00005411','X-00005411','AT GYPSY SLEP MODEL BINTANG VAR UB 8K','GR','---','A1F','BELI','BELI001','500000','2026-06-02','0.620','1','kasir','2026-06-02 16:32:54');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1F','X-00005411','X-00005411');
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-260602-0002','F224031210061','LUS','1','BELI','BELI001','A1F', 'X-00005411', 'AT GYPSY SLEP MODEL BINTANG VAR UB 8K','0.670','0.620','100.00','431000','500000','806452','1135000','1','500000','500000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.620',berat_beli_asli=berat_beli_asli+'0.620',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.620',berat_akhir_asli=berat_akhir_asli+'0.620',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1F' 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-260602-0002','2026-06-02','2026-06-02','16:32:54','LUS','---','0.620','500000','500000','500000','500000','500000','kasir','2026-06-02 16:32:54','FB-260602-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260602-0002','KRISNAWATI','JL BATOROKATONG128','','','','kasir','2026-06-02 16:32:54');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-02' 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-260602-0038','K','2026-06-02','16:32:54','kasir','PEMBELIAN UMUM','FB-260602-0002','10400730000','500000','10400230000');
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-00005412','X-00005412','','GR','---','A0A','BELI','BELI001','2639000','2026-06-02','2.900','1','kasir','2026-06-02 16:35:14');
DELETE FROM tp_barang WHERE kode_dept = 'X-A0A';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A0A','X-00005412','X-00005412');
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-260602-0003','F223181138151','LUS','1','BELI','BELI001','A0A', 'X-00005412', '','0.000','2.900','100.00','','2639000','910000','100000','1','2639000','2639000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.900',berat_beli_asli=berat_beli_asli+'2.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.900',berat_akhir_asli=berat_akhir_asli+'2.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A0A' 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-260602-0003','2026-06-02','2026-06-02','16:35:14','LUS','---','2.900','2639000','2639000','2639000','2639000','2639000','kasir','2026-06-02 16:35:14','FB-260602-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260602-0003','ARIF','KLEPU SOOKO','','','085856231191','kasir','2026-06-02 16:35:14');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-02' 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-260602-0039','K','2026-06-02','16:35:14','kasir','PEMBELIAN UMUM','FB-260602-0003','10400230000','2639000','10397591000');
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-00005413','X-00005413','GL SANTA SERUT MODEL DAUN VAR YT 8K','GR','---','F3E','BELI','BELI001','1818000','2026-06-02','1.960','1','kasir','2026-06-02 16:35:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00005413','X-00005413');
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-260602-0004','F225211117511','LUS','1','BELI','BELI001','F3E', 'X-00005413', 'GL SANTA SERUT MODEL DAUN VAR YT 8K','1.960','1.960','100.00','2020000','1818000','927551','1115000','1','1818000','1818000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.960',berat_beli_asli=berat_beli_asli+'1.960',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.960',berat_akhir_asli=berat_akhir_asli+'1.960',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-02' 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-260602-0004','2026-06-02','2026-06-02','16:35:47','LUS','---','1.960','1818000','1818000','1818000','1818000','1818000','kasir','2026-06-02 16:35:48','FB-260602-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260602-0004','WINDI','','','','','kasir','2026-06-02 16:35:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-02' 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-260602-0040','K','2026-06-02','16:35:47','kasir','PEMBELIAN UMUM','FB-260602-0004','10397591000','1818000','10395773000');
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-00005414','X-00005414','KL MILANO UB 42 8K','GR','---','H1F','BELI','BELI001','4057000','2026-06-02','3.970','1','kasir','2026-06-02 16:37:09');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1F','X-00005414','X-00005414');
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-260602-0005','F226110952101','RHM','1','BELI','BELI001','H1F', 'X-00005414', 'KL MILANO UB 42 8K','4.020','3.970','100.00','4965000','4057000','1021914','1135000','1','4057000','4057000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.970',berat_beli_asli=berat_beli_asli+'3.970',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.970',berat_akhir_asli=berat_akhir_asli+'3.970',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1F' 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-260602-0005','2026-06-02','2026-06-02','16:37:09','RHM','---','3.970','4057000','4057000','4057000','4057000','4057000','kasir','2026-06-02 16:37:09','FB-260602-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260602-0005','LUSIANA DEWI','KARANGJOHO BADEGAN','','','082139462989','kasir','2026-06-02 16:37:09');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-02' 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-260602-0041','K','2026-06-02','16:37:09','kasir','PEMBELIAN UMUM','FB-260602-0005','10395773000','4057000','10391716000');
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-00005415','X-00005415','','GR','---','A0A','BELI','BELI001','880000','2026-06-02','0.540','1','kasir','2026-06-02 16:39:43');
DELETE FROM tp_barang WHERE kode_dept = 'X-A0A';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A0A','X-00005415','X-00005415');
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-260602-0006','F223061201451','LUS','1','BELI','BELI001','A0A', 'X-00005415', '','','0.540','100.00','','880000','1629630','100000','1','880000','880000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.540',berat_beli_asli=berat_beli_asli+'0.540',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.540',berat_akhir_asli=berat_akhir_asli+'0.540',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A0A' 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-260602-0006','2026-06-02','2026-06-02','16:39:42','LUS','---','0.540','880000','880000','880000','880000','880000','kasir','2026-06-02 16:39:43','FB-260602-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260602-0006','ZANITA','NGRANDU KAUMAN','','','081331443349','kasir','2026-06-02 16:39:43');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-02' 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-260602-0042','K','2026-06-02','16:39:42','kasir','PEMBELIAN UMUM','FB-260602-0006','10391716000','880000','10390836000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260602-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260602-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260602-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260602-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260602-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260602-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260602-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260602-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260602-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260602-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260602-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260602-0006';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-03','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-03';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-02';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-02';
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='2026-06-02' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-02';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-02';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-02';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-02';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202605 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
UPDATE tt_barang_saldo SET tanggal= '2026-06-03' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-02' 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-260603-0001','D','2026-06-03','17:14:07','SYSTEM','SALDO AWAL','SALDO AWAL','0','10390836000','10390836000');
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-260603-0001','D','2026-06-03','17:14:07','BCA','SALDO AWAL','SALDO AWAL','0','4460121888','4460121888');
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-260603-0001','D','2026-06-03','17:14:07','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
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-260603-0001','D','2026-06-03','17:14:07','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-260603-0001','D','2026-06-03','17:14:07','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-260603-0001','D','2026-06-03','17:14:07','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2026-06-03';