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 ('F226030914051','kasir','1',' TDE2 X MJ1','TOKO','TBK-E','E2TD-ZEBB-47-T','CC X MODEL MATA MJ 14 17K ','','1.960','1','100.00','3920000','0','0','15000','3920000','0','0','0','3920000','TIN','T0079810','E2TD','0','0','-','0','2000000');
UPDATE tm_barang SET tgl_last_jual='2026-06-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-ZEBB-47-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.960',berat_jual_asli=berat_jual_asli+'1.960',stock_jual='1',berat_akhir=berat_akhir-'1.960',berat_akhir_asli=berat_akhir_asli-'1.960',stock_akhir='0' WHERE tanggal='2026-06-03' AND kode_barang='E2TD-ZEBB-47-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 ('F226030914051','2026-06-03','1.960','2026-06-03','09:14:06','PLG0080672','3920000','3920000','0','3920000','3920000','kasir','2026-06-03 09:14:05','F22603091405');
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-03','F226030914051','2026-06-03','09:14:06','TIN','3920000','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-260603-0002','D','2026-06-03','09:14:06','kasir','PENJUALAN','F226030914051','10390836000','3920000','10394756000');
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 ('F226030937341','kasir','1',' TIPH X HW ','TOKO','TBK-P','PHTI-ZCBC-38-T','KL X WG SANTA HW 40CM 17K ','','3.080','1','100.00','6468000','0','0','15000','6468000','0','0','0','6468000','LUS','T0078273','PHTI','0','0','-','0','2100000');
UPDATE tm_barang SET tgl_last_jual='2026-06-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PHTI-ZCBC-38-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.080',berat_jual_asli=berat_jual_asli+'3.080',stock_jual='1',berat_akhir=berat_akhir-'3.080',berat_akhir_asli=berat_akhir_asli-'3.080',stock_akhir='0' WHERE tanggal='2026-06-03' AND kode_barang='PHTI-ZCBC-38-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-P' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226030937341','2026-06-03','3.080','2026-06-03','09:37:35','PLG0080673','6468000','6468000','0','6468000','6468000','kasir','2026-06-03 09:37:34','F22603093734');
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-03','F226030937341','2026-06-03','09:37:35','LUS','6468000','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-260603-0003','D','2026-06-03','09:37:35','kasir','PENJUALAN','F226030937341','10394756000','6468000','10401224000');
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 ('F226031011011','kasir','1',' MIH2 X UB ','TOKO','SMBK-H','H2I-YCBD-91-0','KL X KOREA SLEP UB 44 8K','OL','5.050','1','100.00','6035000','0','0','15000','6086000','0','25000','0','6111000','LUS','00344884','H2I','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-06-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-YCBD-91-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.050',berat_jual_asli=berat_jual_asli+'5.050',stock_jual='1',berat_akhir=berat_akhir-'5.050',berat_akhir_asli=berat_akhir_asli-'5.050',stock_akhir='0' WHERE tanggal='2026-06-03' AND kode_barang='H2I-YCBD-91-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 ('F226031011011','2026-06-03','5.050','2026-06-03','10:11:01','PLG0080674','6086000','6086000','25000','6111000','6111000','kasir','2026-06-03 10:11:01','F22603101101');
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-03','F226031011011','2026-06-03','10:11:01','LUS','6111000','25000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260603-0004','D','2026-06-03','10:11:01','kasir','PENJUALAN','F226031011011','10401224000','6111000','10407335000');
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 ('F226031031151','kasir','1',' MIH2 X UB ','TOKO','SMBK-H','H2I-YCBD-91-0','KL X KOREA SLEP UB 44 9K','OL','5.050','1','100.00','6035000','0','0','15000','6086000','0','25000','0','6111000','LUS','00344884','H2I','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-06-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-YCBD-91-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.050',berat_jual_asli=berat_jual_asli+'5.050',stock_jual='1',berat_akhir=berat_akhir-'5.050',berat_akhir_asli=berat_akhir_asli-'5.050',stock_akhir='0' WHERE tanggal='2026-06-03' AND kode_barang='H2I-YCBD-91-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 ('F226031031151','2026-06-03','5.050','2026-06-03','10:31:16','PLG0080675','6086000','6086000','25000','6111000','6111000','kasir','2026-06-03 10:31:15','F22603103115');
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-03','F226031031151','2026-06-03','10:31:16','LUS','6111000','25000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260603-0006','D','2026-06-03','10:31:16','kasir','PENJUALAN','F226031031151','10401224000','6111000','10407335000');
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 ('F226031051091','kasir','1',' MGSIG LG ','TOKO','SMBK-S','S1G-ZEBX-54-T','AS EXTENSION LG 8K ','OLS RSA40','0.200','1','100.00','231000','0','0','15000','234000','0','52000','0','286000','TJ','T0079645','S1G','0','0','-','0','1155000');
UPDATE tm_barang SET tgl_last_jual='2026-06-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZEBX-54-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-03' AND kode_barang='S1G-ZEBX-54-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 ('F226031051091','2026-06-03','0.200','2026-06-03','10:51:10','PLG0080676','234000','234000','52000','286000','286000','kasir','2026-06-03 10:51:09','F22603105109');
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-03','F226031051091','2026-06-03','10:51:10','TJ','286000','52000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260603-0007','D','2026-06-03','10:51:10','kasir','PENJUALAN','F226031051091','10407335000','286000','10407621000');
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 ('F226031124561','kasir','1',' MDE2 10K C','TOKO','SMBK-E','E2D-ZEBF-39-T','CC WEDDING MATA SLEP CM 12 8K ','','1.610','1','100.00','1763000','0','0','15000','1763000','0','10000','0','1773000','TIN','T0079922','E2D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEBF-39-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.610',berat_jual_asli=berat_jual_asli+'1.610',stock_jual='1',berat_akhir=berat_akhir-'1.610',berat_akhir_asli=berat_akhir_asli-'1.610',stock_akhir='0' WHERE tanggal='2026-06-03' AND kode_barang='E2D-ZEBF-39-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 ('F226031124561','2026-06-03','1.610','2026-06-03','11:24:56','PLG0080677','1763000','1763000','10000','1773000','1773000','kasir','2026-06-03 11:24:56','F22603112456');
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-03','F226031124561','2026-06-03','11:24:56','TIN','1773000','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-260603-0008','D','2026-06-03','11:24:56','kasir','PENJUALAN','F226031124561','10407621000','1773000','10409394000');
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 ('F226031134211','kasir','1',' MEB1E HW ','TOKO','SMBK-B','B1E-ZEBF-6-T','GW ITALY PANJANG MATA VAR HW 8K ','','0.520','1','100.00','580000','0','0','15000','580000','0','0','0','580000','TJ','T0079889','B1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEBF-6-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-06-03' AND kode_barang='B1E-ZEBF-6-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 ('F226031134211','2026-06-03','0.520','2026-06-03','11:34:21','PLG0080678','580000','580000','0','580000','0','kasir','2026-06-03 11:34:21','F22603113421');
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-03','F226031134211','2026-06-03','11:34:21','TJ','580000','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-260603-0001','2026-06-03','2026-06-03 11:34:21','PENJUALAN : F226031134211','0987654321','BCA','580000','580000','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-260603-0002','D','2026-06-03','11:34:21','BCA','PENJUALAN','F226031134211','4460121888','580000','4460701888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0987654321','FIRDA AYU');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031134211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031134211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031134211';
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 ('F226031139371','kasir','1',' MEF3E X YT','TOKO','SMBK-F','F3E-ZBAD-203-0','GL X SANTA HATI VAR SERUT YT 8K ','OL','1.740','1','100.00','1940000','0','0','15000','1948000','0','10000','0','1958000','TIN','00389809','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBAD-203-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.740',berat_jual_asli=berat_jual_asli+'1.740',stock_jual='1',berat_akhir=berat_akhir-'1.740',berat_akhir_asli=berat_akhir_asli-'1.740',stock_akhir='0' WHERE tanggal='2026-06-03' AND kode_barang='F3E-ZBAD-203-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 ('F226031139371','2026-06-03','1.740','2026-06-03','11:39:38','PLG0080679','1948000','1948000','10000','1958000','1958000','kasir','2026-06-03 11:39:37','F22603113937');
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-03','F226031139371','2026-06-03','11:39:38','TIN','1958000','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-260603-0009','D','2026-06-03','11:39:38','kasir','PENJUALAN','F226031139371','10409394000','1958000','10411352000');
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 ('F226031235571','kasir','1',' MDA1D X LG','TOKO','SMBK-A','A1D-ZABC-19-0','AT X HUGGIES APELL KLIP CAT VAR LG 8K ','OL','0.980','1','100.00','1073000','0','0','15000','1083000','0','5000','0','1088000','LUS','00386649','A1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZABC-19-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2026-06-03' AND kode_barang='A1D-ZABC-19-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 ('F226031235571','2026-06-03','0.980','2026-06-03','12:35:58','PLG0080680','1083000','1083000','5000','1088000','0','kasir','2026-06-03 12:35:57','F22603123557');
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-03','F226031235571','2026-06-03','12:35:58','LUS','1088000','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-260603-0002','2026-06-03','2026-06-03 12:35:57','PENJUALAN : F226031235571','87643346789764356','BCA','1088000','1088000','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-260603-0003','D','2026-06-03','12:35:58','BCA','PENJUALAN','F226031235571','4460701888','1088000','4461789888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('87643346789764356','AZIZAH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1088000' WHERE no_faktur_jual='F226031235571' 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 ('F226030119551','kasir','1',' MEE2 X YT ','TOKO','SMBK-E','E2E-ZEBH-391-0','CC X MODEL MATA YT 18 8K ','OL','0.600','1','100.00','669000','0','0','15000','899000','0','5000','0','904000','LUS','00405609','E2E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZEBH-391-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-03' AND kode_barang='E2E-ZEBH-391-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 ('F226030119551','2026-06-03','0.600','2026-06-03','13:19:55','PLG0080681','899000','899000','5000','904000','904000','kasir','2026-06-03 13:19:55','F22603011955');
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-03','F226030119551','2026-06-03','13:19:55','LUS','904000','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-260603-0010','D','2026-06-03','13:19:55','kasir','PENJUALAN','F226030119551','10411352000','904000','10412256000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='904000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030119551' 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 ('F226030119552','kasir',' 1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZEBH-396-0','CC X MODEL MATA CM 18 8K ','OL','0.810','1','100.00','887000','0','0','15000','678000','0','5000','0','683000','LUS','00405614','E2D','0','0','-','1','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEBH-396-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.810',berat_jual_asli=berat_jual_asli+'0.810',stock_jual='1',berat_akhir=berat_akhir-'0.810',berat_akhir_asli=berat_akhir_asli-'0.810',stock_akhir='0' WHERE tanggal='2026-06-03' AND kode_barang='E2D-ZEBH-396-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 ('F226030119552','2026-06-03','0.810','2026-06-03','13:19:55','PLG0080682','678000','678000','5000','683000','683000','kasir','2026-06-03 13:19:55','F22603011955');
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-03','F226030119552','2026-06-03','13:19:55','LUS','683000','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-260603-0011','D','2026-06-03','13:19:55','kasir','PENJUALAN','F226030119552','10412256000','683000','10412939000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='683000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030119552' 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 ('F226030214211','kasir','1',' MDE2D BM 2','TOKO','SMBK-E','E2D-ZFXB-18-T','CC MODEL MATA SLEP BM 22 8K ','OL','1.640','1','100.00','1796000','0','0','15000','1821000','0','8000','0','1829000','TJ','T0080163','E2D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFXB-18-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.640',berat_jual_asli=berat_jual_asli+'1.640',stock_jual='1',berat_akhir=berat_akhir-'1.640',berat_akhir_asli=berat_akhir_asli-'1.640',stock_akhir='0' WHERE tanggal='2026-06-03' AND kode_barang='E2D-ZFXB-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 ('F226030214211','2026-06-03','1.640','2026-06-03','14:14:21','PLG0080683','1821000','1821000','8000','1829000','1829000','kasir','2026-06-03 14:14:21','F22603021421');
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-03','F226030214211','2026-06-03','14:14:21','TJ','1829000','8000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260603-0012','D','2026-06-03','14:14:21','kasir','PENJUALAN','F226030214211','10412939000','1829000','10414768000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1829000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030214211' 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 ('F226030214212','kasir',' 1',' MEF1 X PM ','TOKO','SMBK-F','F1E-ZDAH-79-0','GL X BANGKOK KACA SLEP PM 58 8K ','OL','5.160','1','100.00','5753000','0','0','15000','5831000','0','26000','0','5857000','TJ','00399780','F1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZDAH-79-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.160',berat_jual_asli=berat_jual_asli+'5.160',stock_jual='1',berat_akhir=berat_akhir-'5.160',berat_akhir_asli=berat_akhir_asli-'5.160',stock_akhir='0' WHERE tanggal='2026-06-03' AND kode_barang='F1E-ZDAH-79-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 ('F226030214212','2026-06-03','5.160','2026-06-03','14:14:21','PLG0080684','5831000','5831000','26000','5857000','5857000','kasir','2026-06-03 14:14:21','F22603021421');
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-03','F226030214212','2026-06-03','14:14:21','TJ','5857000','26000');
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-260603-0013','D','2026-06-03','14:14:21','kasir','PENJUALAN','F226030214212','10414768000','5857000','10420625000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5857000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030214212' 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 ('F226030221121','kasir','1',' MGD1G X BG','TOKO','SMBK-D','D1G-ZFXA-75-0','LT X SLOBOK BOLA SLEP BG 8K','OL','0.230','1','100.00','266000','0','0','15000','270000','0','5000','0','275000','TIN','00406243','D1G','0','0','-','0','1155000');
UPDATE tm_barang SET tgl_last_jual='2026-06-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZFXA-75-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.230',berat_jual_asli=berat_jual_asli+'0.230',stock_jual='1',berat_akhir=berat_akhir-'0.230',berat_akhir_asli=berat_akhir_asli-'0.230',stock_akhir='0' WHERE tanggal='2026-06-03' AND kode_barang='D1G-ZFXA-75-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 ('F226030221121','2026-06-03','0.230','2026-06-03','14:21:13','PLG0080685','270000','270000','5000','275000','275000','kasir','2026-06-03 14:21:12','F22603022112');
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-03','F226030221121','2026-06-03','14:21:13','TIN','275000','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-260603-0014','D','2026-06-03','14:21:13','kasir','PENJUALAN','F226030221121','10420625000','275000','10420900000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='275000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030221121' 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 ('F226030221122','kasir',' 1',' MGD1G X BG','TOKO','SMBK-D','D1G-ZFXA-76-0','LT X SLOBOK BOLA SLEP BG 8K ','OL','0.260','1','100.00','300000','0','0','15000','306000','0','5000','0','311000','TIN','00406244','D1G','0','0','-','0','1155000');
UPDATE tm_barang SET tgl_last_jual='2026-06-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZFXA-76-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-03' AND kode_barang='D1G-ZFXA-76-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 ('F226030221122','2026-06-03','0.260','2026-06-03','14:21:13','PLG0080686','306000','306000','5000','311000','311000','kasir','2026-06-03 14:21:12','F22603022112');
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-03','F226030221122','2026-06-03','14:21:13','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,status_valid) VALUES ('KM-260603-0015','D','2026-06-03','14:21:13','kasir','PENJUALAN','F226030221122','10420900000','311000','10421211000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='311000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030221122' 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 ('F226030221123','kasir',' 1',' MGD1G X BG','TOKO','SMBK-D','D1G-ZFXA-77-0','LT X SLOBOK BOLA SLEP BG 8K ','OL','0.270','1','100.00','312000','0','0','15000','317000','0','5000','0','322000','TIN','00406245','D1G','0','0','-','0','1155000');
UPDATE tm_barang SET tgl_last_jual='2026-06-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZFXA-77-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.270',berat_jual_asli=berat_jual_asli+'0.270',stock_jual='1',berat_akhir=berat_akhir-'0.270',berat_akhir_asli=berat_akhir_asli-'0.270',stock_akhir='0' WHERE tanggal='2026-06-03' AND kode_barang='D1G-ZFXA-77-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 ('F226030221123','2026-06-03','0.270','2026-06-03','14:21:13','PLG0080687','317000','317000','5000','322000','322000','kasir','2026-06-03 14:21:12','F22603022112');
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-03','F226030221123','2026-06-03','14:21:13','TIN','322000','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-260603-0016','D','2026-06-03','14:21:13','kasir','PENJUALAN','F226030221123','10421211000','322000','10421533000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='322000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030221123' 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 ('F226030221124','kasir',' 1',' MDE1D LG 1','TOKO','SMBK-E','E1D-ZEBH-54-T','CC MODEL ISYANA SLEP LG 14 8K ','OL','0.980','1','100.00','1073000','0','0','15000','1088000','0','5000','0','1093000','TIN','T0079995','E1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZEBH-54-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2026-06-03' AND kode_barang='E1D-ZEBH-54-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 ('F226030221124','2026-06-03','0.980','2026-06-03','14:21:13','PLG0080688','1088000','1088000','5000','1093000','1093000','kasir','2026-06-03 14:21:12','F22603022112');
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-03','F226030221124','2026-06-03','14:21:13','TIN','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,status_valid) VALUES ('KM-260603-0017','D','2026-06-03','14:21:13','kasir','PENJUALAN','F226030221124','10421533000','1093000','10422626000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1093000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030221124' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030119551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030119551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030119551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030119552' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030119552' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030119552';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030214211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030214211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030214211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030214212' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030214212' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030214212';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030221121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030221121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030221121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030221122' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030221122' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030221122';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030221123' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030221123' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030221123';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030221124' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030221124' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030221124';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030914051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030914051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030914051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030937341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030937341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030937341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031031151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031031151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031031151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031051091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031051091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031051091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031124561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031124561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031124561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031139371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031139371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031139371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031235571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031235571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031235571';
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 ('F226030231031','kasir','1',' MGA1G CM ','TOKO','SMBK-A','A1G-ZEBH-2-T','AT TINDIK BABY CM 8K ','OL','0.270','1','100.00','312000','0','0','15000','316000','0','5000','0','321000','TJ','T0079943','A1G','0','0','-','0','1155000');
UPDATE tm_barang SET tgl_last_jual='2026-06-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1G-ZEBH-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.270',berat_jual_asli=berat_jual_asli+'0.270',stock_jual='1',berat_akhir=berat_akhir-'0.270',berat_akhir_asli=berat_akhir_asli-'0.270',stock_akhir='0' WHERE tanggal='2026-06-03' AND kode_barang='A1G-ZEBH-2-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 ('F226030231031','2026-06-03','0.270','2026-06-03','14:31:03','PLG0080689','316000','316000','5000','321000','321000','kasir','2026-06-03 14:31:03','F22603023103');
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-03','F226030231031','2026-06-03','14:31:03','TJ','321000','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-260603-0018','D','2026-06-03','14:31:03','kasir','PENJUALAN','F226030231031','10422626000','321000','10422947000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='321000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030231031' 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 ('F226030231032','kasir',' 1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZECX-19-T','CC MODEL ISYANA SLEP LG 14 8K ','OL','0.500','1','100.00','550000','0','0','15000','565000','0','5000','0','570000','TJ','T0080085','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZECX-19-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-03' AND kode_barang='E1E-ZECX-19-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226030231032','2026-06-03','0.500','2026-06-03','14:31:03','PLG0080690','565000','565000','5000','570000','570000','kasir','2026-06-03 14:31:03','F22603023103');
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-03','F226030231032','2026-06-03','14:31:03','TJ','570000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260603-0019','D','2026-06-03','14:31:03','kasir','PENJUALAN','F226030231032','10422947000','570000','10423517000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='570000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030231032' 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 ('F226030231033','kasir',' 1',' MEB1 5K HW','TOKO','SMBK-B','B1E-ZECX-52-T','GW TIFF PANJANG CAT VAR SLEP HW 8K ','OL','0.550','1','100.00','605000','0','0','15000','622000','0','5000','0','627000','TJ','T0080118','B1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZECX-52-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-03' AND kode_barang='B1E-ZECX-52-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226030231033','2026-06-03','0.550','2026-06-03','14:31:03','PLG0080691','622000','622000','5000','627000','627000','kasir','2026-06-03 14:31:03','F22603023103');
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-03','F226030231033','2026-06-03','14:31:03','TJ','627000','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-260603-0020','D','2026-06-03','14:31:03','kasir','PENJUALAN','F226030231033','10423517000','627000','10424144000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='627000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030231033' 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 ('F226030231034','kasir',' 1',' MHD1 LG ','TOKO','SMBK-D','D1H-ZEAC-8-T','LT MODEL DAUN VAR LG 8K ','OL','0.180','1','100.00','211000','0','0','15000','214000','0','5000','0','219000','TJ','T0079413','D1H','0','0','-','0','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-06-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1H-ZEAC-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.180',berat_jual_asli=berat_jual_asli+'0.180',stock_jual='1',berat_akhir=berat_akhir-'0.180',berat_akhir_asli=berat_akhir_asli-'0.180',stock_akhir='0' WHERE tanggal='2026-06-03' AND kode_barang='D1H-ZEAC-8-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226030231034','2026-06-03','0.180','2026-06-03','14:31:03','PLG0080692','214000','214000','5000','219000','219000','kasir','2026-06-03 14:31:03','F22603023103');
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-03','F226030231034','2026-06-03','14:31:03','TJ','219000','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-260603-0021','D','2026-06-03','14:31:03','kasir','PENJUALAN','F226030231034','10424144000','219000','10424363000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='219000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030231034' 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 ('F226030231035','kasir',' 1',' MEA1E BM ','TOKO','SMBK-A','A1E-ZEBA-28-T','AT ITALY VAR SLEP BM 8K ','OL','0.550','1','100.00','613000','0','0','15000','622000','0','5000','0','627000','TJ','T0079735','A1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZEBA-28-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-03' AND kode_barang='A1E-ZEBA-28-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 ('F226030231035','2026-06-03','0.550','2026-06-03','14:31:03','PLG0080693','622000','622000','5000','627000','627000','kasir','2026-06-03 14:31:03','F22603023103');
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-03','F226030231035','2026-06-03','14:31:03','TJ','627000','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-260603-0022','D','2026-06-03','14:31:03','kasir','PENJUALAN','F226030231035','10424363000','627000','10424990000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='627000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030231035' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030231033' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030231033' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030231033';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030231031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030231031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030231031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030231032' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030231032' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030231032';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030231034' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030231034' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030231034';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030231035' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030231035' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030231035';
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 ('F226030353051','admin','1',' MDE2 10K C','TOKO','SMBK-E','E2D-ZEBF-34-T','CC WEDDING MATA SLEP CM 14 8K','OL','1.610','1','100.00','1763000','0','0','15000','1785000','0','10000','0','1795000','TIN','T0079917','E2D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEBF-34-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.610',berat_jual_asli=berat_jual_asli+'1.610',stock_jual='1',berat_akhir=berat_akhir-'1.610',berat_akhir_asli=berat_akhir_asli-'1.610',stock_akhir='0' WHERE tanggal='2026-06-03' AND kode_barang='E2D-ZEBF-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 ('F226030353051','2026-06-03','1.610','2026-06-03','15:53:05','PLG0080694','1785000','1785000','10000','1795000','1795000','admin','2026-06-03 15:53:05','F22603035305');
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-03','F226030353051','2026-06-03','15:53:05','TIN','1795000','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-260603-0023','D','2026-06-03','15:53:05','admin','PENJUALAN','F226030353051','10424990000','1795000','10426785000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030353051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030353051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030353051';
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-00005416','X-00005416','KL WG CASANO HW 42CM','GR','---','PHTI','BELI','BELI001','2457000','2026-06-03','1.450','1','admin','2026-06-03 16:02:19');
DELETE FROM tp_barang WHERE kode_dept = 'X-PHTI';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-PHTI','X-00005416','X-00005416');
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-260603-0001','F222061219501','LUS','1','BELI','BELI001','PHTI', 'X-00005416', 'KL WG CASANO HW 42CM','1.520','1.450','100.00','1185000','2457000','1694483','2100000','1','2457000','2457000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.450',berat_beli_asli=berat_beli_asli+'1.450',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.450',berat_akhir_asli=berat_akhir_asli+'1.450',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-03' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='PHTI' 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-260603-0001','2026-06-03','2026-06-03','16:02:18','LUS','---','1.450','2457000','2457000','2457000','2457000','2457000','admin','2026-06-03 16:02:19','FB-260603-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260603-0001','ANITA','MAGETAN','','','','admin','2026-06-03 16:02:19');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-03' 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-260603-0024','K','2026-06-03','16:02:18','admin','PEMBELIAN UMUM','FB-260603-0001','10426785000','2457000','10424328000');
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-00005417','X-00005417','AT X COR MODEL HATI VAR UB 17K','GR','---','A1TE','BELI','BELI001','1170000','2026-06-03','0.660','1','admin','2026-06-03 16:02:19');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1TE','X-00005417','X-00005417');
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-260603-0002','F226050852401','LUS','2','BELI','BELI001','A1TE', 'X-00005417', 'AT X COR MODEL HATI VAR UB 17K','0.660','0.660','100.00','1300000','1170000','1772727','2020000','1','1170000','1170000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.660',berat_beli_asli=berat_beli_asli+'0.660',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.660',berat_akhir_asli=berat_akhir_asli+'0.660',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-03' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1TE' 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-260603-0002','2026-06-03','2026-06-03','16:02:18','LUS','---','0.660','1170000','1170000','1170000','1170000','1170000','admin','2026-06-03 16:02:19','FB-260603-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260603-0002','ANITA','PARANG MAGETAN','','','085736876442','admin','2026-06-03 16:02:19');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-03' 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-260603-0025','K','2026-06-03','16:02:18','admin','PEMBELIAN UMUM','FB-260603-0002','10424328000','1170000','10423158000');
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-00005418','X-00005418','GL X MODEL FILIGREE UB','GR','---','F3TF','BELI','BELI001','2075000','2026-06-03','1.250','1','admin','2026-06-03 16:02:19');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3TF';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3TF','X-00005418','X-00005418');
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-260603-0003','F224221225371','LUS','3','BELI','BELI001','F3TF', 'X-00005418', 'GL X MODEL FILIGREE UB','1.310','1.250','100.00','1516000','2075000','1660000','2040000','1','2075000','2075000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.250',berat_beli_asli=berat_beli_asli+'1.250',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.250',berat_akhir_asli=berat_akhir_asli+'1.250',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-03' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3TF' 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-260603-0003','2026-06-03','2026-06-03','16:02:18','LUS','---','1.250','2075000','2075000','2075000','2075000','2075000','admin','2026-06-03 16:02:19','FB-260603-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260603-0003','ANITA MUJIANTO','MAGETAN','','','','admin','2026-06-03 16:02:19');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-03' 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-260603-0026','K','2026-06-03','16:02:18','admin','PEMBELIAN UMUM','FB-260603-0003','10423158000','2075000','10421083000');
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-00005419','X-00005419','CC X MODEL PIPA MATA HT 20 8K','GR','---','E2E','BELI','BELI001','343000','2026-06-03','0.400','1','admin','2026-06-03 16:02:19');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00005419','X-00005419');
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-260603-0004','F225290934481','LUS','4','BELI','BELI001','E2E', 'X-00005419', 'CC X MODEL PIPA MATA HT 20 8K','0.460','0.400','100.00','465000','343000','857500','1115000','1','343000','343000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.400',berat_beli_asli=berat_beli_asli+'0.400',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.400',berat_akhir_asli=berat_akhir_asli+'0.400',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-03' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' 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-260603-0004','2026-06-03','2026-06-03','16:02:18','LUS','---','0.400','343000','343000','343000','343000','343000','admin','2026-06-03 16:02:19','FB-260603-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260603-0004','SUMIATI','MBRAHU SIMAN 1/2','','','087726973295','admin','2026-06-03 16:02:19');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-03' 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-260603-0027','K','2026-06-03','16:02:18','admin','PEMBELIAN UMUM','FB-260603-0004','10421083000','343000','10420740000');
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-00005420','X-00005420','LT MODEL HURUF MATA LG L 8K','GR','---','D2E','BELI','BELI001','530000','2026-06-03','0.530','1','admin','2026-06-03 16:02:41');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2E','X-00005420','X-00005420');
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-260603-0005','F226120144292','RHM','1','BELI','BELI001','D2E', 'X-00005420', 'LT MODEL HURUF MATA LG L 8K','0.530','0.530','100.00','605000','530000','1000000','1115000','1','530000','530000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.530',berat_beli_asli=berat_beli_asli+'0.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.530',berat_akhir_asli=berat_akhir_asli+'0.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-03' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2E' 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-260603-0005','2026-06-03','2026-06-03','16:02:41','RHM','---','0.530','530000','530000','530000','530000','530000','admin','2026-06-03 16:02:41','FB-260603-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260603-0005','LINDA','PONDOK BABADAN','','','089696627496','admin','2026-06-03 16:02:41');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-03' 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-260603-0028','K','2026-06-03','16:02:41','admin','PEMBELIAN UMUM','FB-260603-0005','10420740000','530000','10420210000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260603-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260603-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260603-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260603-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260603-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260603-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260603-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260603-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260603-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260603-0005';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-04','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-04';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-03';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-03';
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-03' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-03';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-03';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-03';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-03';
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-04' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-03' 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-260604-0001','D','2026-06-04','16:39:36','SYSTEM','SALDO AWAL','SALDO AWAL','0','10420210000','10420210000');
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-260604-0001','D','2026-06-04','16:39:36','BCA','SALDO AWAL','SALDO AWAL','0','4461789888','4461789888');
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-260604-0001','D','2026-06-04','16:39:36','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-260604-0001','D','2026-06-04','16:39:36','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-260604-0001','D','2026-06-04','16:39:36','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-260604-0001','D','2026-06-04','16:39:36','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2026-06-04';