INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-08','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-08';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-07';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-07';
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-07' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-07';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-07';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-07';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-07';
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-08' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-07' 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-260608-0001','D','2026-06-08','07:56:24','SYSTEM','SALDO AWAL','SALDO AWAL','0','10544594000','10544594000');
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-260608-0001','D','2026-06-08','07:56:24','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260608-0001','D','2026-06-08','07:56:24','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-260608-0001','D','2026-06-08','07:56:24','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-260608-0001','D','2026-06-08','07:56:24','','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-260608-0001','D','2026-06-08','07:56:24','BCA','SALDO AWAL','SALDO AWAL','0','4479782888','4479782888');
UPDATE tp_system SET tgl_system='2026-06-08';
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 ('F226080904471','kasir','1',' MEA1E BM ','TOKO','SMBK-A','A1E-ZEBA-24-T','AT ITALY VAR SLEP BM 8K ','OL','0.580','1','100.00','647000','0','0','15000','662000','0','5000','0','667000','LUS','T0079731','A1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZEBA-24-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='A1E-ZEBA-24-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226080904471','2026-06-08','0.580','2026-06-08','09:04:48','PLG0080810','662000','662000','5000','667000','667000','kasir','2026-06-08 09:04:47','F22608090447');
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-08','F226080904471','2026-06-08','09:04:48','LUS','667000','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-260608-0002','D','2026-06-08','09:04:48','kasir','PENJUALAN','F226080904471','10544594000','667000','10545261000');
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 ('F226080928061','kasir','1',' MED2 LG M ','TOKO','SMBK-D','D2E-ZDAG-17-T','LT MODEL HURUF MATA LG M 8K ','OL','0.550','1','100.00','613000','0','0','15000','625000','0','5000','0','630000','TIN','T0078729','D2E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZDAG-17-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-08' AND kode_barang='D2E-ZDAG-17-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 ('F226080928061','2026-06-08','0.550','2026-06-08','09:28:06','PLG0080811','625000','625000','5000','630000','630000','kasir','2026-06-08 09:28:06','F22608092806');
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-08','F226080928061','2026-06-08','09:28:06','TIN','630000','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-260608-0003','D','2026-06-08','09:28:06','kasir','PENJUALAN','F226080928061','10545261000','630000','10545891000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='630000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226080928061' 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 ('F226080928062','kasir',' 1',' MED2E LG F','TOKO','SMBK-D','D2E-ZEBH-63-T','LT MODEL HURUF MATA F LG 8K ','OL','0.560','1','100.00','624000','0','0','15000','637000','0','5000','0','642000','TIN','T0080004','D2E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZEBH-63-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-08' AND kode_barang='D2E-ZEBH-63-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 ('F226080928062','2026-06-08','0.560','2026-06-08','09:28:06','PLG0080812','637000','637000','5000','642000','642000','kasir','2026-06-08 09:28:06','F22608092806');
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-08','F226080928062','2026-06-08','09:28:06','TIN','642000','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-260608-0004','D','2026-06-08','09:28:06','kasir','PENJUALAN','F226080928062','10545891000','642000','10546533000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='642000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226080928062' 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 ('F226080928063','kasir',' 1',' MEE1E CM 1','TOKO','SMBK-E','E1E-ZEBH-21-T','CC MODEL SLEP CM 15 8K ','OL','0.550','1','100.00','613000','0','0','15000','625000','0','5000','0','630000','TIN','T0079962','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBH-21-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-08' AND kode_barang='E1E-ZEBH-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 ('F226080928063','2026-06-08','0.550','2026-06-08','09:28:06','PLG0080813','625000','625000','5000','630000','630000','kasir','2026-06-08 09:28:06','F22608092806');
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-08','F226080928063','2026-06-08','09:28:06','TIN','630000','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-260608-0005','D','2026-06-08','09:28:06','kasir','PENJUALAN','F226080928063','10546533000','630000','10547163000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='630000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226080928063' 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 ('F226080928064','kasir',' 1',' MEE1E CM 1','TOKO','SMBK-E','E1E-ZEBH-18-T','CC MODEL SLEP CM 13 8K ','OL','0.600','1','100.00','669000','0','0','15000','682000','0','5000','0','687000','TIN','T0079959','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBH-18-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='E1E-ZEBH-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 ('F226080928064','2026-06-08','0.600','2026-06-08','09:28:06','PLG0080814','682000','682000','5000','687000','687000','kasir','2026-06-08 09:28:06','F22608092806');
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-08','F226080928064','2026-06-08','09:28:06','TIN','687000','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-260608-0006','D','2026-06-08','09:28:06','kasir','PENJUALAN','F226080928064','10547163000','687000','10547850000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='687000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226080928064' 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 ('F226080928361','kasir','1',' MDB1 X LG ','TOKO','SMBK-B','B1D-ZCCX-465-0','GW X DAISY MATA LG PE 8K ','OL','0.960','1','100.00','1051000','0','0','15000','1067000','0','10000','0','1077000','TIN','00397119','B1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-ZCCX-465-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.960',berat_jual_asli=berat_jual_asli+'0.960',stock_jual='1',berat_akhir=berat_akhir-'0.960',berat_akhir_asli=berat_akhir_asli-'0.960',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='B1D-ZCCX-465-0' 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 ('F226080928361','2026-06-08','0.960','2026-06-08','09:28:37','PLG0080815','1067000','1067000','10000','1077000','1077000','kasir','2026-06-08 09:28:36','F22608092836');
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-08','F226080928361','2026-06-08','09:28:37','TIN','1077000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260608-0007','D','2026-06-08','09:28:37','kasir','PENJUALAN','F226080928361','10547850000','1077000','10548927000');
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 ('F226080929121','kasir','1',' MEB1 5K HW','TOKO','SMBK-B','B1E-ZECX-53-T','GW TIFF PANJANG CAT VAR SLEP HW 8K ','OL','0.580','1','100.00','647000','0','0','15000','659000','0','5000','0','664000','TIN','T0080119','B1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZECX-53-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='B1E-ZECX-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 ('F226080929121','2026-06-08','0.580','2026-06-08','09:29:13','PLG0080816','659000','659000','5000','664000','664000','kasir','2026-06-08 09:29:12','F22608092912');
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-08','F226080929121','2026-06-08','09:29:13','TIN','664000','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-260608-0008','D','2026-06-08','09:29:13','kasir','PENJUALAN','F226080929121','10548927000','664000','10549591000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='664000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226080929121' 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 ('F226080929122','kasir',' 1',' MEB1 5K HW','TOKO','SMBK-B','B1E-ZECX-54-T','GW TIFF PANJANG CAT VAR SLEP HW 8K ','OL','0.580','1','100.00','647000','0','0','15000','659000','0','5000','0','664000','TIN','T0080120','B1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZECX-54-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='B1E-ZECX-54-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 ('F226080929122','2026-06-08','0.580','2026-06-08','09:29:13','PLG0080817','659000','659000','5000','664000','664000','kasir','2026-06-08 09:29:12','F22608092912');
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-08','F226080929122','2026-06-08','09:29:13','TIN','664000','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-260608-0009','D','2026-06-08','09:29:13','kasir','PENJUALAN','F226080929122','10549591000','664000','10550255000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='664000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226080929122' 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 ('F226080934111','kasir','1',' MDA1D X UB','TOKO','SMBK-A','A1D-ZEBG-207-0','AT X MODEL ARESO PASIR UB 8K ','OL','0.970','1','100.00','1062000','0','0','15000','1088000','0','5000','0','1093000','LUS','00405206','A1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZEBG-207-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='A1D-ZEBG-207-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 ('F226080934111','2026-06-08','0.970','2026-06-08','09:34:12','PLG0080818','1088000','1088000','5000','1093000','1093000','kasir','2026-06-08 09:34:11','F22608093411');
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-08','F226080934111','2026-06-08','09:34:12','LUS','1093000','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-260608-0010','D','2026-06-08','09:34:12','kasir','PENJUALAN','F226080934111','10550255000','1093000','10551348000');
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 ('F226080939241','kasir','1',' MDA1D X LT','TOKO','SMBK-A','A1D-ZEBG-202-0','AT X ITALY SPECTRA HITAM VAR LT 8K ','OL','1.160','1','100.00','1270000','0','0','15000','1296000','0','6000','0','1302000','LUS','00405201','A1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZEBG-202-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.160',berat_jual_asli=berat_jual_asli+'1.160',stock_jual='1',berat_akhir=berat_akhir-'1.160',berat_akhir_asli=berat_akhir_asli-'1.160',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='A1D-ZEBG-202-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 ('F226080939241','2026-06-08','1.160','2026-06-08','09:39:25','PLG0080819','1296000','1296000','6000','1302000','1302000','kasir','2026-06-08 09:39:24','F22608093924');
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-08','F226080939241','2026-06-08','09:39:25','LUS','1302000','6000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260608-0011','D','2026-06-08','09:39:25','kasir','PENJUALAN','F226080939241','10551348000','1302000','10552650000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1302000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226080939241' 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 ('F226080939242','kasir',' 1',' MEB1 X CM ','TOKO','SMBK-B','B1E-ZEBE-11-0','GW X MODEL CAT HITAM CM PE 8K ','OL','0.520','1','100.00','580000','0','0','15000','595000','0','5000','0','600000','LUS','00404710','B1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEBE-11-0' 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-08' AND kode_barang='B1E-ZEBE-11-0' 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 ('F226080939242','2026-06-08','0.520','2026-06-08','09:39:25','PLG0080820','595000','595000','5000','600000','600000','kasir','2026-06-08 09:39:24','F22608093924');
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-08','F226080939242','2026-06-08','09:39:25','LUS','600000','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-260608-0012','D','2026-06-08','09:39:25','kasir','PENJUALAN','F226080939242','10552650000','600000','10553250000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='600000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226080939242' 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 ('F226080939243','kasir',' 1',' MEB1 5K HW','TOKO','SMBK-B','B1E-ZEAH-83-0','GW TIFF SPECTRA CAT HITAM HW 8K','OL','0.510','1','100.00','569000','0','0','15000','582000','0','5000','0','587000','LUS','00403989','B1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEAH-83-0' 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-08' AND kode_barang='B1E-ZEAH-83-0' 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 ('F226080939243','2026-06-08','0.510','2026-06-08','09:39:25','PLG0080821','582000','582000','5000','587000','587000','kasir','2026-06-08 09:39:24','F22608093924');
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-08','F226080939243','2026-06-08','09:39:25','LUS','587000','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-260608-0013','D','2026-06-08','09:39:25','kasir','PENJUALAN','F226080939243','10553250000','587000','10553837000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='587000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226080939243' 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 ('F226080939244','kasir',' 1',' MEF3E HW ','TOKO','SMBK-F','F3E-ZEBA-40-T','GL TIFF VAR SLEP HW 8K ','OL','0.720','1','100.00','803000','0','0','15000','822000','0','5000','0','827000','LUS','T0079747','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEBA-40-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.720',berat_jual_asli=berat_jual_asli+'0.720',stock_jual='1',berat_akhir=berat_akhir-'0.720',berat_akhir_asli=berat_akhir_asli-'0.720',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='F3E-ZEBA-40-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 ('F226080939244','2026-06-08','0.720','2026-06-08','09:39:25','PLG0080822','822000','822000','5000','827000','827000','kasir','2026-06-08 09:39:24','F22608093924');
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-08','F226080939244','2026-06-08','09:39:25','LUS','827000','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-260608-0014','D','2026-06-08','09:39:25','kasir','PENJUALAN','F226080939244','10553837000','827000','10554664000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='827000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226080939244' 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 ('F226080939245','kasir',' 1',' MEF3E UB ','TOKO','SMBK-F','F3E-ZEBH-80-T','GL GUCCI SLEP UB 8K ','OL','0.570','1','100.00','636000','0','0','15000','651000','0','5000','0','656000','LUS','T0080021','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEBH-80-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-08' AND kode_barang='F3E-ZEBH-80-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 ('F226080939245','2026-06-08','0.570','2026-06-08','09:39:25','PLG0080823','651000','651000','5000','656000','656000','kasir','2026-06-08 09:39:24','F22608093924');
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-08','F226080939245','2026-06-08','09:39:25','LUS','656000','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-260608-0015','D','2026-06-08','09:39:25','kasir','PENJUALAN','F226080939245','10554664000','656000','10555320000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='656000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226080939245' 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 ('F226080939246','kasir',' 1',' MEE1 X CM ','TOKO','SMBK-E','E1E-ZEBE-102-0','CC X MODEL KUKU MACAN SLEP CM 16 8K ','OL','0.600','1','100.00','669000','0','0','15000','685000','0','5000','0','690000','LUS','00404801','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBE-102-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='E1E-ZEBE-102-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 ('F226080939246','2026-06-08','0.600','2026-06-08','09:39:25','PLG0080824','685000','685000','5000','690000','690000','kasir','2026-06-08 09:39:24','F22608093924');
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-08','F226080939246','2026-06-08','09:39:25','LUS','690000','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-260608-0016','D','2026-06-08','09:39:25','kasir','PENJUALAN','F226080939246','10555320000','690000','10556010000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='690000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226080939246' 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 ('F226080939247','kasir',' 1',' MDE1 X HW ','TOKO','SMBK-E','E2D-ZEBE-76-0','CC X SPIRAL CAT MATA HW 13 8K ','OL','1.050','1','100.00','1150000','0','0','15000','1173000','0','5000','0','1178000','LUS','00404775','E2D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEBE-76-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='E2D-ZEBE-76-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 ('F226080939247','2026-06-08','1.050','2026-06-08','09:39:25','PLG0080825','1173000','1173000','5000','1178000','1178000','kasir','2026-06-08 09:39:24','F22608093924');
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-08','F226080939247','2026-06-08','09:39:25','LUS','1178000','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-260608-0017','D','2026-06-08','09:39:25','kasir','PENJUALAN','F226080939247','10556010000','1178000','10557188000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1178000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226080939247' 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 ('F226081023031','kasir','1',' TEF3 X HW ','TOKO','TBK-F','F3TE-ZCBC-21-T','GL X RANTAI HOLLOW CAPELA 3C VAR HW 17K ','','2.270','1','100.00','4631000','0','0','15000','4676000','0','0','0','4676000','LUS','T0078256','F3TE','0','0','-','0','2040000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-ZCBC-21-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.270',berat_jual_asli=berat_jual_asli+'2.270',stock_jual='1',berat_akhir=berat_akhir-'2.270',berat_akhir_asli=berat_akhir_asli-'2.270',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='F3TE-ZCBC-21-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226081023031','2026-06-08','2.270','2026-06-08','10:23:04','PLG0080826','4676000','4676000','0','4676000','4676000','kasir','2026-06-08 10:23:03','F22608102303');
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-08','F226081023031','2026-06-08','10:23:04','LUS','4676000','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-260608-0018','D','2026-06-08','10:23:04','kasir','PENJUALAN','F226081023031','10557188000','4676000','10561864000');
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 ('F226081024161','kasir','1',' TEF3 LT ','TOKO','TBK-F','F3TE-ZDXD-154-T','GL X MODEL FANCY VAR LT 17K ','','2.030','1','100.00','4141000','0','0','15000','4182000','0','0','0','4182000','LUS','T0078441','F3TE','0','0','-','0','2040000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-ZDXD-154-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='F3TE-ZDXD-154-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226081024161','2026-06-08','2.030','2026-06-08','10:24:17','PLG0080827','4182000','4182000','0','4182000','4182000','kasir','2026-06-08 10:24:16','F22608102416');
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-08','F226081024161','2026-06-08','10:24:17','LUS','4182000','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-260608-0019','D','2026-06-08','10:24:17','kasir','PENJUALAN','F226081024161','10561864000','4182000','10566046000');
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 ('F226081038361','kasir','1',' TAE0 X DW ','TOKO','TBK-E','E0TA-VJAX-8-T','CC X TEBU DW 13 ','','3.950','1','100.00','7663000','0','0','15000','7742000','0','0','0','7742000','TJ','T0038725','E0TA','0','0','-','0','1940000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E0TA-VJAX-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.950',berat_jual_asli=berat_jual_asli+'3.950',stock_jual='1',berat_akhir=berat_akhir-'3.950',berat_akhir_asli=berat_akhir_asli-'3.950',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='E0TA-VJAX-8-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 ('F226081038361','2026-06-08','3.950','2026-06-08','10:38:37','PLG0080828','7742000','7742000','0','7742000','7742000','kasir','2026-06-08 10:38:36','F22608103836');
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-08','F226081038361','2026-06-08','10:38:37','TJ','7742000','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-260608-0020','D','2026-06-08','10:38:37','kasir','PENJUALAN','F226081038361','10566046000','7742000','10573788000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='7742000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226081038361' 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 ('F226081038362','kasir',' 1',' TAE0 X DW ','TOKO','TBK-E','E0TA-WHCA-83-T','CC X WARU DW 12 ','','1.010','1','100.00','1959000','0','0','15000','1980000','0','0','0','1980000','TJ','T0048337','E0TA','0','0','-','0','1940000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E0TA-WHCA-83-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='E0TA-WHCA-83-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 ('F226081038362','2026-06-08','1.010','2026-06-08','10:38:37','PLG0080829','1980000','1980000','0','1980000','1980000','kasir','2026-06-08 10:38:36','F22608103836');
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-08','F226081038362','2026-06-08','10:38:37','TJ','1980000','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-260608-0021','D','2026-06-08','10:38:37','kasir','PENJUALAN','F226081038362','10573788000','1980000','10575768000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1980000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226081038362' 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 ('F226081049151','kasir','1',' MDE2 X UB ','TOKO','SMBK-E','E2D-ZEBH-393-0','CC X MODEL MATA UB 16 8K ','','0.880','1','100.00','964000','0','0','15000','975000','0','0','0','975000','LUS','00405611','E2D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEBH-393-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.880',berat_jual_asli=berat_jual_asli+'0.880',stock_jual='1',berat_akhir=berat_akhir-'0.880',berat_akhir_asli=berat_akhir_asli-'0.880',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='E2D-ZEBH-393-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 ('F226081049151','2026-06-08','0.880','2026-06-08','10:49:15','PLG0080830','975000','975000','0','975000','975000','kasir','2026-06-08 10:49:15','F22608104915');
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-08','F226081049151','2026-06-08','10:49:15','LUS','975000','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-260608-0022','D','2026-06-08','10:49:15','kasir','PENJUALAN','F226081049151','10575768000','975000','10576743000');
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 ('F226081051261','kasir','1',' MGSIG LG ','TOKO','SMBK-S','S1G-ZEBX-75-T','AS EXTENSION LG 8K ','OLS UF8TV','0.200','1','100.00','231000','0','0','15000','238000','0','48000','0','286000','TJ','T0079666','S1G','0','0','-','0','1155000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZEBX-75-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='S1G-ZEBX-75-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F226081051261','2026-06-08','0.200','2026-06-08','10:51:26','PLG0080831','238000','238000','48000','286000','286000','kasir','2026-06-08 10:51:26','F22608105126');
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-08','F226081051261','2026-06-08','10:51:26','TJ','286000','48000');
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-260608-0023','D','2026-06-08','10:51:26','kasir','PENJUALAN','F226081051261','10576743000','286000','10577029000');
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 ('F226081052281','kasir','1',' MEH1 X UB ','TOKO','SMBK-H','H1E-ZEBE-213-0','KL X TIFF SLEP VAR UB 42 8K ','OLS PYDJY','1.060','1','100.00','1182000','0','0','15000','1205000','0','152000','0','1357000','TJ','00404912','H1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEBE-213-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='H1E-ZEBE-213-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 ('F226081052281','2026-06-08','1.060','2026-06-08','10:52:28','PLG0080832','1205000','1205000','152000','1357000','1357000','kasir','2026-06-08 10:52:28','F22608105228');
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-08','F226081052281','2026-06-08','10:52:28','TJ','1357000','152000');
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-260608-0024','D','2026-06-08','10:52:28','kasir','PENJUALAN','F226081052281','10577029000','1357000','10578386000');
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 ('F226081150371','kasir','1',' MGB1 LG ','TOKO','SMBK-B','B1G-ZEAE-70-T','GW TUSUK DAISY MATA LG 8K ','','0.280','1','100.00','323000','0','0','15000','327000','0','0','0','327000','LUS','T0079496','B1G','0','0','-','0','1155000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZEAE-70-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.280',berat_jual_asli=berat_jual_asli+'0.280',stock_jual='1',berat_akhir=berat_akhir-'0.280',berat_akhir_asli=berat_akhir_asli-'0.280',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='B1G-ZEAE-70-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 ('F226081150371','2026-06-08','0.280','2026-06-08','11:50:37','PLG0080833','327000','327000','0','327000','327000','kasir','2026-06-08 11:50:37','F22608115037');
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-08','F226081150371','2026-06-08','11:50:37','LUS','327000','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-260608-0025','D','2026-06-08','11:50:37','kasir','PENJUALAN','F226081150371','10578386000','327000','10578713000');
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 ('F226081156361','kasir','1',' MDE1D LG 1','TOKO','SMBK-E','E1D-ZFXE-34-T','CC MODEL ISYANA SLEP LG 18 8K ','OL','1.100','1','100.00','1204000','0','0','15000','1224000','0','6000','0','1230000','LUS','T0080336','E1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZFXE-34-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='E1D-ZFXE-34-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 ('F226081156361','2026-06-08','1.100','2026-06-08','11:56:37','PLG0080834','1224000','1224000','6000','1230000','1230000','kasir','2026-06-08 11:56:36','F22608115636');
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-08','F226081156361','2026-06-08','11:56:37','LUS','1230000','6000');
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-260608-0026','D','2026-06-08','11:56:37','kasir','PENJUALAN','F226081156361','10578713000','1230000','10579943000');
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 ('F226081200411','kasir','1',' MGA1G CM ','TOKO','SMBK-A','A1G-ZEBH-5-T','AT TINDIK BABY CM 8K ','OL','0.260','1','100.00','300000','0','0','15000','307000','0','5000','0','312000','LUS','T0079946','A1G','0','0','-','0','1155000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1G-ZEBH-5-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-08' AND kode_barang='A1G-ZEBH-5-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226081200411','2026-06-08','0.260','2026-06-08','12:00:41','PLG0080835','307000','307000','5000','312000','312000','kasir','2026-06-08 12:00:41','F22608120041');
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-08','F226081200411','2026-06-08','12:00:41','LUS','312000','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-260608-0027','D','2026-06-08','12:00:41','kasir','PENJUALAN','F226081200411','10579943000','312000','10580255000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='312000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226081200411' 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 ('F226081200412','kasir',' 1',' MDA1D X LG','TOKO','SMBK-A','A1D-ZEBG-201-0','AT X MODEL MATA VAR LG 8K ','OL','0.910','1','100.00','996000','0','0','15000','1021000','0','5000','0','1026000','LUS','00405200','A1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZEBG-201-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.910',berat_jual_asli=berat_jual_asli+'0.910',stock_jual='1',berat_akhir=berat_akhir-'0.910',berat_akhir_asli=berat_akhir_asli-'0.910',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='A1D-ZEBG-201-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 ('F226081200412','2026-06-08','0.910','2026-06-08','12:00:41','PLG0080836','1021000','1021000','5000','1026000','1026000','kasir','2026-06-08 12:00:41','F22608120041');
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-08','F226081200412','2026-06-08','12:00:41','LUS','1026000','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-260608-0028','D','2026-06-08','12:00:41','kasir','PENJUALAN','F226081200412','10580255000','1026000','10581281000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1026000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226081200412' 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 ('F226081200413','kasir',' 1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZEBH-33-T','CC MODEL ISYANA SLEP LG 12 8K ','OL','0.460','1','100.00','513000','0','0','15000','525000','0','5000','0','530000','LUS','T0079974','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBH-33-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-08' AND kode_barang='E1E-ZEBH-33-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226081200413','2026-06-08','0.460','2026-06-08','12:00:41','PLG0080837','525000','525000','5000','530000','530000','kasir','2026-06-08 12:00:41','F22608120041');
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-08','F226081200413','2026-06-08','12:00:41','LUS','530000','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-260608-0029','D','2026-06-08','12:00:41','kasir','PENJUALAN','F226081200413','10581281000','530000','10581811000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='530000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226081200413' 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 ('F226081200414','kasir',' 1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZEBH-32-T','CC MODEL ISYANA SLEP LG 12 8K ','OL','0.480','1','100.00','535000','0','0','15000','548000','0','5000','0','553000','LUS','T0079973','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBH-32-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-08' AND kode_barang='E1E-ZEBH-32-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226081200414','2026-06-08','0.480','2026-06-08','12:00:41','PLG0080838','548000','548000','5000','553000','553000','kasir','2026-06-08 12:00:41','F22608120041');
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-08','F226081200414','2026-06-08','12:00:41','LUS','553000','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-260608-0030','D','2026-06-08','12:00:41','kasir','PENJUALAN','F226081200414','10581811000','553000','10582364000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='553000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226081200414' 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 ('F226081200415','kasir',' 1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZEBH-397-0','CC X MODEL MATA CAT CM 12 8K ','OL','0.850','1','100.00','931000','0','0','15000','955000','0','5000','0','960000','LUS','00405615','E2D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEBH-397-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.850',berat_jual_asli=berat_jual_asli+'0.850',stock_jual='1',berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='E2D-ZEBH-397-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 ('F226081200415','2026-06-08','0.850','2026-06-08','12:00:41','PLG0080839','955000','955000','5000','960000','960000','kasir','2026-06-08 12:00:41','F22608120041');
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-08','F226081200415','2026-06-08','12:00:41','LUS','960000','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-260608-0031','D','2026-06-08','12:00:41','kasir','PENJUALAN','F226081200415','10582364000','960000','10583324000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='960000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226081200415' 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 ('F226081200416','kasir',' 1',' MDE1D LG 1','TOKO','SMBK-E','E1D-ZEBF-18-T','CC MODEL ISYANA SLEP LG 14 8K','OL','1.070','1','100.00','1172000','0','0','15000','1196000','0','5000','0','1201000','LUS','T0079901','E1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZEBF-18-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='E1D-ZEBF-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 ('F226081200416','2026-06-08','1.070','2026-06-08','12:00:41','PLG0080840','1196000','1196000','5000','1201000','1201000','kasir','2026-06-08 12:00:41','F22608120041');
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-08','F226081200416','2026-06-08','12:00:41','LUS','1201000','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-260608-0032','D','2026-06-08','12:00:41','kasir','PENJUALAN','F226081200416','10583324000','1201000','10584525000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1201000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226081200416' 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 ('F226081200417','kasir',' 1',' MEF3E HW ','TOKO','SMBK-F','F3E-ZEBF-57-T','GL XASTELI SPECTRA SLEP HW 8K ','OL','2.250','1','100.00','2509000','0','0','15000','2559000','0','11000','0','2570000','LUS','T0079940','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEBF-57-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.250',berat_jual_asli=berat_jual_asli+'2.250',stock_jual='1',berat_akhir=berat_akhir-'2.250',berat_akhir_asli=berat_akhir_asli-'2.250',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='F3E-ZEBF-57-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 ('F226081200417','2026-06-08','2.250','2026-06-08','12:00:41','PLG0080841','2559000','2559000','11000','2570000','2570000','kasir','2026-06-08 12:00:41','F22608120041');
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-08','F226081200417','2026-06-08','12:00:41','LUS','2570000','11000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260608-0033','D','2026-06-08','12:00:41','kasir','PENJUALAN','F226081200417','10584525000','2570000','10587095000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2570000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226081200417' 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 ('F226081227401','kasir','1',' MEF1 TD D5','TOKO','SMBK-F','F1E-ZEXG-4-T','GL BANGKOK MODEL C TD D56 8K ','','2.870','1','100.00','3200000','0','0','15000','3234000','0','0','0','3234000','RHM','T0079269','F1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZEXG-4-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.870',berat_jual_asli=berat_jual_asli+'2.870',stock_jual='1',berat_akhir=berat_akhir-'2.870',berat_akhir_asli=berat_akhir_asli-'2.870',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='F1E-ZEXG-4-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226081227401','2026-06-08','2.870','2026-06-08','12:27:41','PLG0080842','3234000','3234000','0','3234000','3234000','kasir','2026-06-08 12:27:40','F22608122740');
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-08','F226081227401','2026-06-08','12:27:41','RHM','3234000','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-260608-0034','D','2026-06-08','12:27:41','kasir','PENJUALAN','F226081227401','10587095000','3234000','10590329000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3234000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226081227401' 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 ('F226081227402','kasir',' 1',' MEF3E X YT','TOKO','SMBK-F','F3E-ZFXC-189-0','GL X TIFF SPECTRA VAR YT 8K ','','1.500','1','100.00','1672000','0','0','15000','1691000','0','0','0','1691000','RHM','00406732','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFXC-189-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='F3E-ZFXC-189-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226081227402','2026-06-08','1.500','2026-06-08','12:27:41','PLG0080843','1691000','1691000','0','1691000','1691000','kasir','2026-06-08 12:27:40','F22608122740');
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-08','F226081227402','2026-06-08','12:27:41','RHM','1691000','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-260608-0035','D','2026-06-08','12:27:41','kasir','PENJUALAN','F226081227402','10590329000','1691000','10592020000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1691000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226081227402' 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 ('F226081227403','kasir',' 1',' MDE1 5K CM','TOKO','SMBK-E','E1D-ZFXE-44-T','CC MODEL PITA SLEP CM 14 8K ','','0.820','1','100.00','898000','0','0','15000','908000','0','5000','0','913000','RHM','T0080346','E1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZFXE-44-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.820',berat_jual_asli=berat_jual_asli+'0.820',stock_jual='1',berat_akhir=berat_akhir-'0.820',berat_akhir_asli=berat_akhir_asli-'0.820',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='E1D-ZFXE-44-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 ('F226081227403','2026-06-08','0.820','2026-06-08','12:27:41','PLG0080844','908000','908000','5000','913000','913000','kasir','2026-06-08 12:27:40','F22608122740');
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-08','F226081227403','2026-06-08','12:27:41','RHM','913000','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-260608-0036','D','2026-06-08','12:27:41','kasir','PENJUALAN','F226081227403','10592020000','913000','10592933000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='913000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226081227403' 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 ('F226081228341','kasir','1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZFXD-78-T','CC MODEL ISYANA SLEP LG 10 8K ','OL ','0.450','1','100.00','502000','0','0','15000','512000','0','5000','0','517000','TIN','T0080243','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFXD-78-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='E1E-ZFXD-78-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 ('F226081228341','2026-06-08','0.450','2026-06-08','12:28:35','PLG0080845','512000','512000','5000','517000','0','kasir','2026-06-08 12:28:34','F22608122834');
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-08','F226081228341','2026-06-08','12:28:35','TIN','517000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260608-0001','2026-06-08','2026-06-08 12:28:34','PENJUALAN : F226081228341','653653863563653','BCA','517000','517000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260608-0002','D','2026-06-08','12:28:35','BCA','PENJUALAN','F226081228341','4479782888','517000','4480299888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('653653863563653','HHHH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='517000' WHERE no_faktur_jual='F226081228341' 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 ('F226081255521','kasir','1',' MEF3 10K Y','TOKO','SMBK-F','F3E-ZFXD-123-T','GL TIFF SPECTRA KUPU CAT MERAH SLEP YT 8K','OL','1.020','1','100.00','1137000','0','0','15000','1155000','0','10000','0','1165000','TJ','T0080288','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFXD-123-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='F3E-ZFXD-123-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 ('F226081255521','2026-06-08','1.020','2026-06-08','12:55:52','PLG0080846','1155000','1155000','10000','1165000','1165000','kasir','2026-06-08 12:55:52','F22608125552');
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-08','F226081255521','2026-06-08','12:55:52','TJ','1165000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260608-0037','D','2026-06-08','12:55:52','kasir','PENJUALAN','F226081255521','10592933000','1165000','10594098000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1165000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226081255521' 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 ('F226081255522','kasir',' 1',' MEF3 10K Y','TOKO','SMBK-F','F3E-ZFXD-124-T','GL TIFF SPECTRA KUPU CAT HITAM SLEP YT 8K','OL','1.120','1','100.00','1249000','0','0','15000','1270000','0','10000','0','1280000','TJ','T0080289','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFXD-124-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.120',berat_jual_asli=berat_jual_asli+'1.120',stock_jual='1',berat_akhir=berat_akhir-'1.120',berat_akhir_asli=berat_akhir_asli-'1.120',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='F3E-ZFXD-124-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 ('F226081255522','2026-06-08','1.120','2026-06-08','12:55:52','PLG0080847','1270000','1270000','10000','1280000','1280000','kasir','2026-06-08 12:55:52','F22608125552');
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-08','F226081255522','2026-06-08','12:55:52','TJ','1280000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260608-0038','D','2026-06-08','12:55:52','kasir','PENJUALAN','F226081255522','10594098000','1280000','10595378000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1280000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226081255522' 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 ('F226081255523','kasir',' 1',' MED1E BM ','TOKO','SMBK-D','D1E-ZFXD-20-T','LT MODEL SPECTRA SLEP BM 8K ','OL','0.430','1','100.00','479000','0','0','15000','491000','0','5000','0','496000','TJ','T0080185','D1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZFXD-20-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.430',berat_jual_asli=berat_jual_asli+'0.430',stock_jual='1',berat_akhir=berat_akhir-'0.430',berat_akhir_asli=berat_akhir_asli-'0.430',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='D1E-ZFXD-20-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 ('F226081255523','2026-06-08','0.430','2026-06-08','12:55:52','PLG0080848','491000','491000','5000','496000','496000','kasir','2026-06-08 12:55:52','F22608125552');
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-08','F226081255523','2026-06-08','12:55:52','TJ','496000','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-260608-0039','D','2026-06-08','12:55:52','kasir','PENJUALAN','F226081255523','10595378000','496000','10595874000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='496000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226081255523' 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 ('F226081255524','kasir',' 1',' MEF3E UB ','TOKO','SMBK-F','F3E-ZFXD-49-T','GL KOREA SLEP UB 8K ','OL','0.900','1','100.00','1003000','0','0','15000','1030000','0','5000','0','1035000','TJ','T0080214','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFXD-49-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.900',berat_jual_asli=berat_jual_asli+'0.900',stock_jual='1',berat_akhir=berat_akhir-'0.900',berat_akhir_asli=berat_akhir_asli-'0.900',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='F3E-ZFXD-49-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 ('F226081255524','2026-06-08','0.900','2026-06-08','12:55:52','PLG0080849','1030000','1030000','5000','1035000','1035000','kasir','2026-06-08 12:55:52','F22608125552');
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-08','F226081255524','2026-06-08','12:55:52','TJ','1035000','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-260608-0040','D','2026-06-08','12:55:52','kasir','PENJUALAN','F226081255524','10595874000','1035000','10596909000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1035000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226081255524' 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 ('F226081255525','kasir',' 1',' MED2 LG B ','TOKO','SMBK-D','D2E-ZCCA-59-T','LT MODEL HURUF MATA LG B 8K ','OL','0.570','1','100.00','636000','0','0','15000','651000','0','5000','0','656000','TJ','T0078355','D2E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZCCA-59-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-08' AND kode_barang='D2E-ZCCA-59-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 ('F226081255525','2026-06-08','0.570','2026-06-08','12:55:52','PLG0080850','651000','651000','5000','656000','656000','kasir','2026-06-08 12:55:52','F22608125552');
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-08','F226081255525','2026-06-08','12:55:52','TJ','656000','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-260608-0041','D','2026-06-08','12:55:52','kasir','PENJUALAN','F226081255525','10596909000','656000','10597565000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='656000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226081255525' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226081255524' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226081255524' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226081255524';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226081255522' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226081255522' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226081255522';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226081255523' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226081255523' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226081255523';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226081255521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226081255521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226081255521';
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 ('F226080115091','kasir','1',' MED2 LG R ','TOKO','SMBK-D','D2E-ZDBX-36-T','LT MODEL HURUF MATA LG R 8K','OL','0.620','1','100.00','691000','0','0','15000','708000','0','5000','0','713000','TJ','T0078771','D2E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZDBX-36-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-08' AND kode_barang='D2E-ZDBX-36-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 ('F226080115091','2026-06-08','0.620','2026-06-08','13:15:09','PLG0080851','708000','708000','5000','713000','713000','kasir','2026-06-08 13:15:09','F22608011509');
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-08','F226080115091','2026-06-08','13:15:09','TJ','713000','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-260608-0042','D','2026-06-08','13:15:09','kasir','PENJUALAN','F226080115091','10597565000','713000','10598278000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='713000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226080115091' 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 ('F226080115092','kasir',' 1',' MEH1E UB 4','TOKO','SMBK-H','H1E-ZEBX-87-T','KL MILANO UB 42 8K ','OL','2.130','1','100.00','2375000','0','0','15000','2421000','0','11000','0','2432000','TJ','T0079678','H1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEBX-87-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.130',berat_jual_asli=berat_jual_asli+'2.130',stock_jual='1',berat_akhir=berat_akhir-'2.130',berat_akhir_asli=berat_akhir_asli-'2.130',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='H1E-ZEBX-87-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226080115092','2026-06-08','2.130','2026-06-08','13:15:09','PLG0080852','2421000','2421000','11000','2432000','2432000','kasir','2026-06-08 13:15:09','F22608011509');
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-08','F226080115092','2026-06-08','13:15:09','TJ','2432000','11000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260608-0043','D','2026-06-08','13:15:09','kasir','PENJUALAN','F226080115092','10598278000','2432000','10600710000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2432000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226080115092' 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 ('F226080115093','kasir',' 1',' MDA1D LG ','TOKO','SMBK-A','A1D-ZFXE-86-T','AT DAISY MATA SLEP LG 8K ','OL','1.030','1','100.00','1128000','0','0','15000','1151000','0','5000','0','1156000','TJ','T0080388','A1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZFXE-86-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='A1D-ZFXE-86-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226080115093','2026-06-08','1.030','2026-06-08','13:15:09','PLG0080853','1151000','1151000','5000','1156000','1156000','kasir','2026-06-08 13:15:09','F22608011509');
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-08','F226080115093','2026-06-08','13:15:09','TJ','1156000','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-260608-0044','D','2026-06-08','13:15:09','kasir','PENJUALAN','F226080115093','10600710000','1156000','10601866000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1156000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226080115093' 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 ('F226080115094','kasir',' 1',' MEE1E CM 1','TOKO','SMBK-E','E1E-ZEBH-17-T','CC MODEL SLEP CM 13 8K ','OL','0.620','1','100.00','691000','0','0','15000','708000','0','5000','0','713000','TJ','T0079958','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBH-17-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-08' AND kode_barang='E1E-ZEBH-17-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 ('F226080115094','2026-06-08','0.620','2026-06-08','13:15:09','PLG0080854','708000','708000','5000','713000','713000','kasir','2026-06-08 13:15:09','F22608011509');
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-08','F226080115094','2026-06-08','13:15:09','TJ','713000','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-260608-0045','D','2026-06-08','13:15:09','kasir','PENJUALAN','F226080115094','10601866000','713000','10602579000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='713000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226080115094' 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 ('F226080115095','kasir',' 1',' MEE1E CM 1','TOKO','SMBK-E','E1E-ZEBF-43-T','CC MODEL SLEP CM 15 8K ','OL','0.550','1','100.00','613000','0','0','15000','628000','0','5000','0','633000','TJ','T0079926','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBF-43-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-08' AND kode_barang='E1E-ZEBF-43-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 ('F226080115095','2026-06-08','0.550','2026-06-08','13:15:09','PLG0080855','628000','628000','5000','633000','633000','kasir','2026-06-08 13:15:09','F22608011509');
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-08','F226080115095','2026-06-08','13:15:09','TJ','633000','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-260608-0046','D','2026-06-08','13:15:09','kasir','PENJUALAN','F226080115095','10602579000','633000','10603212000','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='F226080115095' 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 ('F226080116091','kasir','1',' MGB1G X AV','TOKO','SMBK-B','B1G-ZFXC-78-0','GW X MRICAN SLEP AV 8K ','OL','0.260','1','100.00','300000','0','0','15000','306000','0','5000','0','311000','TIN','00406621','B1G','0','0','-','0','1155000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZFXC-78-0' 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-08' AND kode_barang='B1G-ZFXC-78-0' 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 ('F226080116091','2026-06-08','0.260','2026-06-08','13:16:10','PLG0080856','306000','306000','5000','311000','311000','kasir','2026-06-08 13:16:09','F22608011609');
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-08','F226080116091','2026-06-08','13:16:10','TIN','311000','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-260608-0047','D','2026-06-08','13:16:10','kasir','PENJUALAN','F226080116091','10603212000','311000','10603523000');
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 ('F226080116581','kasir','1',' MDE2 CM 10','TOKO','SMBK-E','E2D-ZFXF-1-T','CC WEDDING MATA 10 CM 8K ','OL','0.900','1','100.00','985000','0','0','15000','1005000','0','5000','0','1010000','TIN','T0080424','E2D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFXF-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.900',berat_jual_asli=berat_jual_asli+'0.900',stock_jual='1',berat_akhir=berat_akhir-'0.900',berat_akhir_asli=berat_akhir_asli-'0.900',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='E2D-ZFXF-1-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 ('F226080116581','2026-06-08','0.900','2026-06-08','13:16:58','PLG0080857','1005000','1005000','5000','1010000','1010000','kasir','2026-06-08 13:16:58','F22608011658');
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-08','F226080116581','2026-06-08','13:16:58','TIN','1010000','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-260608-0048','D','2026-06-08','13:16:58','kasir','PENJUALAN','F226080116581','10603523000','1010000','10604533000');
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 ('F226080119371','kasir','1',' MFD1F X BG','TOKO','SMBK-D','D1F-YFAF-27-0','LT X SLOBOK HURUF BALOK BG F 8K ','OLS AP168','0.500','1','100.00','567000','0','0','15000','586000','0','67000','0','653000','TJ','00357669','D1F','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YFAF-27-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-08' AND kode_barang='D1F-YFAF-27-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226080119371','2026-06-08','0.500','2026-06-08','13:19:38','PLG0080858','586000','586000','67000','653000','653000','kasir','2026-06-08 13:19:37','F22608011937');
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-08','F226080119371','2026-06-08','13:19:38','TJ','653000','67000');
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-260608-0049','D','2026-06-08','13:19:38','kasir','PENJUALAN','F226080119371','10604533000','653000','10605186000');
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 ('F226080121201','kasir','1',' MEH1 X UB ','TOKO','SMBK-H','H1E-ZAAC-166-0','KL X GUCCI UB 42 8K ','OLS MD48N','1.100','1','100.00','1226000','0','0','15000','1250000','0','111000','0','1361000','TJ','00385073','H1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZAAC-166-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='H1E-ZAAC-166-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 ('F226080121201','2026-06-08','1.100','2026-06-08','13:21:20','PLG0080859','1250000','1250000','111000','1361000','1361000','kasir','2026-06-08 13:21:20','F22608012120');
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-08','F226080121201','2026-06-08','13:21:20','TJ','1361000','111000');
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-260608-0050','D','2026-06-08','13:21:20','kasir','PENJUALAN','F226080121201','10605186000','1361000','10606547000');
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 ('F226080129231','kasir','1',' MEA1 LG ','TOKO','SMBK-A','A1E-ZDBB-46-T','AT MODEL PITA MATA VAR LG 8K ','','0.500','1','100.00','557000','0','0','15000','564000','0','0','0','564000','TIN','T0078836','A1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZDBB-46-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='A1E-ZDBB-46-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226080129231','2026-06-08','0.500','2026-06-08','13:29:23','PLG0080860','564000','564000','0','564000','0','kasir','2026-06-08 13:29:23','F22608012923');
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-08','F226080129231','2026-06-08','13:29:23','TIN','564000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260608-0002','2026-06-08','2026-06-08 13:29:23','PENJUALAN : F226080129231','74657674657','BCA','564000','564000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260608-0003','D','2026-06-08','13:29:23','BCA','PENJUALAN','F226080129231','4480299888','564000','4480863888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('74657674657','FIDIA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='564000' WHERE no_faktur_jual='F226080129231' 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 ('F226080129431','kasir','1',' MFF3F X UB','TOKO','SMBK-F','F3F-ZEXE-120-0','GL X RANTAI HOLLOW UB 8K ','','0.370','1','100.00','420000','0','0','15000','424000','0','0','0','424000','TIN','00402293','F3F','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-ZEXE-120-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.370',berat_jual_asli=berat_jual_asli+'0.370',stock_jual='1',berat_akhir=berat_akhir-'0.370',berat_akhir_asli=berat_akhir_asli-'0.370',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='F3F-ZEXE-120-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226080129431','2026-06-08','0.370','2026-06-08','13:29:44','PLG0080861','424000','424000','0','424000','0','kasir','2026-06-08 13:29:43','F22608012943');
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-08','F226080129431','2026-06-08','13:29:44','TIN','424000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260608-0003','2026-06-08','2026-06-08 13:29:43','PENJUALAN : F226080129431','74657467697','BCA','424000','424000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260608-0004','D','2026-06-08','13:29:44','BCA','PENJUALAN','F226080129431','4480863888','424000','4481287888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('74657467697','FIDIA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='424000' WHERE no_faktur_jual='F226080129431' 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 ('F226080200481','kasir','1',' MED2 LG D ','TOKO','SMBK-D','D2E-YJBI-126-T','LT MODEL HURUF MATA LG D 8K ','OL','0.600','1','100.00','669000','0','0','15000','682000','0','5000','0','687000','TIN','T0074686','D2E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-YJBI-126-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='D2E-YJBI-126-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 ('F226080200481','2026-06-08','0.600','2026-06-08','14:00:48','PLG0080862','682000','682000','5000','687000','687000','kasir','2026-06-08 14:00:48','F22608020048');
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-08','F226080200481','2026-06-08','14:00:48','TIN','687000','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-260608-0051','D','2026-06-08','14:00:48','kasir','PENJUALAN','F226080200481','10606547000','687000','10607234000');
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 ('F226080205051','kasir','1',' MDA1 LG ','TOKO','SMBK-A','A1D-ZCAC-5-T','AT KLIP MODEL MATA VAR LG 8K ','OL','1.010','1','100.00','1106000','0','0','15000','1123000','0','5000','0','1128000','LUS','T0078118','A1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZCAC-5-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='A1D-ZCAC-5-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226080205051','2026-06-08','1.010','2026-06-08','14:05:05','PLG0080863','1123000','1123000','5000','1128000','1128000','kasir','2026-06-08 14:05:05','F22608020505');
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-08','F226080205051','2026-06-08','14:05:05','LUS','1128000','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-260608-0052','D','2026-06-08','14:05:05','kasir','PENJUALAN','F226080205051','10607234000','1128000','10608362000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080115091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080115091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080115091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080115092' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080115092' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080115092';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080115093' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080115093' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080115093';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080115094' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080115094' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080115094';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080115095' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080115095' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080115095';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080116091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080116091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080116091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080116581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080116581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080116581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080119371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080119371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080119371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080121201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080121201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080121201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080129231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080129231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080129231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080129431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080129431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080129431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080200481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080200481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080200481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080205051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080205051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080205051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080904471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080904471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080904471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080928061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080928061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080928061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080928062' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080928062' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080928062';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080928063' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080928063' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080928063';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080928064' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080928064' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080928064';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080928361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080928361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080928361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080929121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080929121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080929121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080929122' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080929122' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080929122';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080934111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080934111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080934111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080939241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080939241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080939241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080939242' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080939242' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080939242';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080939243' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080939243' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080939243';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080939244' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080939244' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080939244';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080939245' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080939245' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080939245';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080939246' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080939246' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080939246';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080939247' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080939247' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080939247';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226081023031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226081023031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226081023031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226081024161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226081024161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226081024161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226081038361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226081038361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226081038361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226081038362' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226081038362' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226081038362';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226081049151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226081049151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226081049151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226081051261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226081051261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226081051261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226081052281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226081052281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226081052281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226081150371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226081150371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226081150371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226081156361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226081156361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226081156361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226081200411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226081200411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226081200411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226081200412' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226081200412' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226081200412';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226081200413' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226081200413' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226081200413';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226081200414' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226081200414' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226081200414';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226081200415' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226081200415' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226081200415';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226081200416' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226081200416' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226081200416';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226081200417' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226081200417' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226081200417';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226081227401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226081227401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226081227401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226081227402' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226081227402' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226081227402';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226081227403' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226081227403' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226081227403';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226081228341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226081228341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226081228341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226081255525' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226081255525' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226081255525';
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-00005439','X-00005439','CC X WEDDING POLOS CM 16 8K','GR','---','E1D','BELI','BELI001','1012000','2026-06-08','1.000','1','admin','2026-06-08 15:22:34');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00005439','X-00005439');
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-260608-0001','F226301156381','TIN','1','BELI','BELI001','E1D', 'X-00005439', 'CC X WEDDING POLOS CM 16 8K','1.000','1.000','100.00','1100000','1012000','1012000','1095000','1','1012000','1012000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.000',berat_beli_asli=berat_beli_asli+'1.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.000',berat_akhir_asli=berat_akhir_asli+'1.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' 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-260608-0001','2026-06-08','2026-06-08','15:22:33','TIN','---','1.000','1012000','1012000','1012000','1012000','1012000','admin','2026-06-08 15:22:34','FB-260608-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260608-0001','TEGUH','KALIPUCUNG KEDUNGBANTENG','','','082231152536','admin','2026-06-08 15:22:34');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-08' 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-260608-0053','K','2026-06-08','15:22:33','admin','PEMBELIAN UMUM','FB-260608-0001','10608362000','1012000','10607350000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260608-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260608-0001';
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 ('F226080328321','kasir','1',' MEH1 KH 42','TOKO','SMBK-H','H1E-ZDXF-70-T','KL SANTA KH 42CM 8K ','OL','3.040','1','100.00','3390000','0','0','15000','3441000','0','15000','0','3456000','TIN','T0078532','H1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDXF-70-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.040',berat_jual_asli=berat_jual_asli+'3.040',stock_jual='1',berat_akhir=berat_akhir-'3.040',berat_akhir_asli=berat_akhir_asli-'3.040',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='H1E-ZDXF-70-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226080328321','2026-06-08','3.040','2026-06-08','15:28:32','PLG0080864','3441000','3441000','15000','3456000','3456000','kasir','2026-06-08 15:28:32','F22608032832');
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-08','F226080328321','2026-06-08','15:28:32','TIN','3456000','15000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260608-0054','D','2026-06-08','15:28:32','kasir','PENJUALAN','F226080328321','10607350000','3456000','10610806000');
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 ('F226080331421','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZDAH-205-0','CC X MODEL MATA CM 10 8K ','','0.970','1','100.00','1062000','0','0','15000','1074000','0','0','0','1074000','TJ','00399906','E2D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZDAH-205-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='E2D-ZDAH-205-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 ('F226080331421','2026-06-08','0.970','2026-06-08','15:31:42','PLG0080865','1074000','1074000','0','1074000','0','kasir','2026-06-08 15:31:42','F22608033142');
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-08','F226080331421','2026-06-08','15:31:42','TJ','1074000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260608-0004','2026-06-08','2026-06-08 15:31:42','PENJUALAN : F226080331421','0987654321','BCA','1074000','1074000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260608-0005','D','2026-06-08','15:31:42','BCA','PENJUALAN','F226080331421','4481287888','1074000','4482361888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0987654321','PRAYITNO');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080331421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080331421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080331421';
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 ('F226080334171','kasir','1',' MEE2E CM10','TOKO','SMBK-E','E2E-ZECX-26-T','CC MODEL SOLITAIRE MATA CM 10 8K ','','0.710','1','100.00','792000','0','0','15000','800000','0','0','0','800000','TJ','T0080092','E2E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZECX-26-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.710',berat_jual_asli=berat_jual_asli+'0.710',stock_jual='1',berat_akhir=berat_akhir-'0.710',berat_akhir_asli=berat_akhir_asli-'0.710',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='E2E-ZECX-26-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226080334171','2026-06-08','0.710','2026-06-08','15:34:18','PLG0080866','800000','800000','0','800000','0','kasir','2026-06-08 15:34:17','F22608033417');
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-08','F226080334171','2026-06-08','15:34:18','TJ','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260608-0005','2026-06-08','2026-06-08 15:34:17','PENJUALAN : F226080334171','0987654321','BCA','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260608-0006','D','2026-06-08','15:34:18','BCA','PENJUALAN','F226080334171','4482361888','800000','4483161888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0987654321','PRAYITNO');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080334171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080334171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080334171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080328321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080328321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080328321';
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 ('F226080342301','admin','1',' MEB1 5K HW','TOKO','SMBK-B','B1E-ZFXE-3-T','GW TIFF PANJANG CAT SLEP HW 8K ','OL','0.530','1','100.00','591000','0','0','15000','603000','0','5000','0','608000','TJ','T0080305','B1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZFXE-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-06-08' AND kode_barang='B1E-ZFXE-3-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 ('F226080342301','2026-06-08','0.530','2026-06-08','15:42:30','PLG0080867','603000','603000','5000','608000','608000','admin','2026-06-08 15:42:30','F22608034230');
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-08','F226080342301','2026-06-08','15:42:30','TJ','608000','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-260608-0055','D','2026-06-08','15:42:30','admin','PENJUALAN','F226080342301','10610806000','608000','10611414000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226080342301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226080342301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226080342301';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-09','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-09';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-08';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-08';
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-08' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-08';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-08';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-08';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-08';
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-09' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-08' 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-260609-0001','D','2026-06-09','16:21:12','SYSTEM','SALDO AWAL','SALDO AWAL','0','10611414000','10611414000');
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-260609-0001','D','2026-06-09','16:21:12','BCA','SALDO AWAL','SALDO AWAL','0','4483161888','4483161888');
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-260609-0001','D','2026-06-09','16:21:12','','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-260609-0001','D','2026-06-09','16:21:12','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-260609-0001','D','2026-06-09','16:21:12','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-260609-0001','D','2026-06-09','16:21:12','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2026-06-09';