INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-25','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-24';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-24';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-24';
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-05-24' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-24';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-24';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-24';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-24';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202604 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
UPDATE tt_barang_saldo SET tanggal= '2026-05-25' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-24' 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-260525-0001','D','2026-05-25','07:45:12','SYSTEM','SALDO AWAL','SALDO AWAL','0','10016546000','10016546000');
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-260525-0001','D','2026-05-25','07:45:12','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-260525-0001','D','2026-05-25','07:45: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-260525-0001','D','2026-05-25','07:45: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-260525-0001','D','2026-05-25','07:45: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-260525-0001','D','2026-05-25','07:45:12','BCA','SALDO AWAL','SALDO AWAL','0','4457376888','4457376888');
UPDATE tp_system SET tgl_system='2026-05-25';
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 ('F226250833591','kasir','1',' TDB1 X CM ','TOKO','TBK-B','B1TD-ZDXD-122-T','GW X TUSUK PITA MATA VAR CM 17K ','OL','1.150','1','100.00','2288000','0','0','15000','2315000','0','8000','0','2323000','TJ','T0078409','B1TD','0','0','-','0','1990000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1TD-ZDXD-122-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.150',berat_jual_asli=berat_jual_asli+'1.150',stock_jual='1',berat_akhir=berat_akhir-'1.150',berat_akhir_asli=berat_akhir_asli-'1.150',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='B1TD-ZDXD-122-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226250833591','2026-05-25','1.150','2026-05-25','08:34:00','PLG0080344','2315000','2315000','8000','2323000','2323000','kasir','2026-05-25 08:33:59','F22625083359');
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-05-25','F226250833591','2026-05-25','08:34:00','TJ','2323000','8000');
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-260525-0002','D','2026-05-25','08:34:00','kasir','PENJUALAN','F226250833591','10016546000','2323000','10018869000');
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 ('F226250917131','kasir','1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZBAH-51-T','LT SLOBOK BALOK HURUF BG D 8K ','OLS W2WT4','0.550','1','100.00','619000','0','0','15000','635000','0','72000','0','707000','TJ','T0077496','D1F','0','0','-','0','1125000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZBAH-51-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-05-25' AND kode_barang='D1F-ZBAH-51-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 ('F226250917131','2026-05-25','0.550','2026-05-25','09:17:14','PLG0080345','635000','635000','72000','707000','707000','kasir','2026-05-25 09:17:13','F22625091713');
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-05-25','F226250917131','2026-05-25','09:17:14','TJ','707000','72000');
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-260525-0003','D','2026-05-25','09:17:14','kasir','PENJUALAN','F226250917131','10018869000','707000','10019576000');
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 ('F226250919101','kasir','1',' MEE1 X AY ','TOKO','SMBK-E','E1E-XIXE-337-0','CC X MODEL SLEP HURUF AY 14 8K ','OLS 9SPWR','0.530','1','100.00','586000','0','0','15000','602000','0','79000','0','681000','TJ','00316214','E1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-XIXE-337-0' 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-05-25' AND kode_barang='E1E-XIXE-337-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 ('F226250919101','2026-05-25','0.530','2026-05-25','09:19:11','PLG0080346','602000','602000','79000','681000','681000','kasir','2026-05-25 09:19:10','F22625091910');
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-05-25','F226250919101','2026-05-25','09:19:11','TJ','681000','79000');
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-260525-0004','D','2026-05-25','09:19:11','kasir','PENJUALAN','F226250919101','10019576000','681000','10020257000');
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 ('F226250920411','kasir','1',' MEF1 TD D4','TOKO','SMBK-F','F1E-ZDAF-11-T','GL ANAK BANGKOK MODEL C TD D42 8K ','OLS V86ED','1.980','1','100.00','2188000','0','0','15000','2217000','0','153000','0','2370000','TJ','T0078677','F1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZDAF-11-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.980',berat_jual_asli=berat_jual_asli+'1.980',stock_jual='1',berat_akhir=berat_akhir-'1.980',berat_akhir_asli=berat_akhir_asli-'1.980',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='F1E-ZDAF-11-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 ('F226250920411','2026-05-25','1.980','2026-05-25','09:20:42','PLG0080347','2217000','2217000','153000','2370000','2370000','kasir','2026-05-25 09:20:41','F22625092041');
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-05-25','F226250920411','2026-05-25','09:20:42','TJ','2370000','153000');
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-260525-0005','D','2026-05-25','09:20:42','kasir','PENJUALAN','F226250920411','10020257000','2370000','10022627000');
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 ('F226250922211','kasir','1',' MGSIG LG ','TOKO','SMBK-S','S1G-ZEBX-62-T','AS EXTENSION LG 8K ','OLS Q25PA','0.200','1','100.00','229000','0','0','15000','235000','0','51000','0','286000','TJ','T0079653','S1G','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZEBX-62-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-05-25' AND kode_barang='S1G-ZEBX-62-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 ('F226250922211','2026-05-25','0.200','2026-05-25','09:22:22','PLG0080348','235000','235000','51000','286000','286000','kasir','2026-05-25 09:22:21','F22625092221');
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-05-25','F226250922211','2026-05-25','09:22:22','TJ','286000','51000');
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-260525-0006','D','2026-05-25','09:22:22','kasir','PENJUALAN','F226250922211','10022627000','286000','10022913000');
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 ('F226251029491','kasir','1',' MEE2 5K CM','TOKO','SMBK-E','E2E-ZDBB-76-T','CC MODEL MATA VAR CM 14 8K ','','0.730','1','100.00','807000','0','0','15000','818000','0','5000','0','823000','TJ','T0078866','E2E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZDBB-76-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.730',berat_jual_asli=berat_jual_asli+'0.730',stock_jual='1',berat_akhir=berat_akhir-'0.730',berat_akhir_asli=berat_akhir_asli-'0.730',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='E2E-ZDBB-76-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 ('F226251029491','2026-05-25','0.730','2026-05-25','10:29:50','PLG0080349','818000','818000','5000','823000','823000','kasir','2026-05-25 10:29:49','F22625102949');
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-05-25','F226251029491','2026-05-25','10:29:50','TJ','823000','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-260525-0007','D','2026-05-25','10:29:50','kasir','PENJUALAN','F226251029491','10022913000','823000','10023736000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='823000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251029491' 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 ('F226251029492','kasir',' 1',' MEF1E TD 5','TOKO','SMBK-F','F1E-ZEBX-51-T','GL OVAL C SLEP TD 52 8K ','','3.090','1','100.00','3414000','0','0','15000','3461000','0','0','0','3461000','TJ','T0079642','F1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZEBX-51-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.090',berat_jual_asli=berat_jual_asli+'3.090',stock_jual='1',berat_akhir=berat_akhir-'3.090',berat_akhir_asli=berat_akhir_asli-'3.090',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='F1E-ZEBX-51-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 ('F226251029492','2026-05-25','3.090','2026-05-25','10:29:50','PLG0080350','3461000','3461000','0','3461000','3461000','kasir','2026-05-25 10:29:49','F22625102949');
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-05-25','F226251029492','2026-05-25','10:29:50','TJ','3461000','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-260525-0008','D','2026-05-25','10:29:50','kasir','PENJUALAN','F226251029492','10023736000','3461000','10027197000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3461000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251029492' 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 ('F226251029493','kasir',' 1',' MEE2 CM 14','TOKO','SMBK-E','E2E-ZEAH-16-T','CC MODEL KUPU MATA VAR CM 14 8K ','','0.730','1','100.00','807000','0','0','15000','818000','0','0','0','818000','TJ','T0079578','E2E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZEAH-16-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.730',berat_jual_asli=berat_jual_asli+'0.730',stock_jual='1',berat_akhir=berat_akhir-'0.730',berat_akhir_asli=berat_akhir_asli-'0.730',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='E2E-ZEAH-16-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 ('F226251029493','2026-05-25','0.730','2026-05-25','10:29:50','PLG0080351','818000','818000','0','818000','818000','kasir','2026-05-25 10:29:49','F22625102949');
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-05-25','F226251029493','2026-05-25','10:29:50','TJ','818000','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-260525-0009','D','2026-05-25','10:29:50','kasir','PENJUALAN','F226251029493','10027197000','818000','10028015000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='818000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251029493' 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 ('F226251033151','kasir','1',' MEE2 CM 12','TOKO','SMBK-E','E2E-ZEAH-15-T','CC MODEL KUPU MATA VAR CM 12 8K ','OL','0.760','1','100.00','840000','0','0','15000','860000','0','5000','0','865000','LUS','T0079577','E2E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZEAH-15-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.760',berat_jual_asli=berat_jual_asli+'0.760',stock_jual='1',berat_akhir=berat_akhir-'0.760',berat_akhir_asli=berat_akhir_asli-'0.760',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='E2E-ZEAH-15-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226251033151','2026-05-25','0.760','2026-05-25','10:33:16','PLG0080352','860000','860000','5000','865000','865000','kasir','2026-05-25 10:33:15','F22625103315');
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-05-25','F226251033151','2026-05-25','10:33:16','LUS','865000','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-260525-0010','D','2026-05-25','10:33:16','kasir','PENJUALAN','F226251033151','10028015000','865000','10028880000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='865000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251033151' 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 ('F226251033152','kasir',' 1',' MEF3 YT ','TOKO','SMBK-F','F3E-ZEXA-34-T','GL TRIXIE BUNGA CLOVER SLEP YT 8K ','OL','1.300','1','100.00','1436000','0','0','15000','1463000','0','7000','0','1470000','LUS','T0079146','F3E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXA-34-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.300',berat_jual_asli=berat_jual_asli+'1.300',stock_jual='1',berat_akhir=berat_akhir-'1.300',berat_akhir_asli=berat_akhir_asli-'1.300',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='F3E-ZEXA-34-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 ('F226251033152','2026-05-25','1.300','2026-05-25','10:33:16','PLG0080353','1463000','1463000','7000','1470000','1470000','kasir','2026-05-25 10:33:15','F22625103315');
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-05-25','F226251033152','2026-05-25','10:33:16','LUS','1470000','7000');
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-260525-0011','D','2026-05-25','10:33:16','kasir','PENJUALAN','F226251033152','10028880000','1470000','10030350000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1470000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251033152' 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 ('F226251034551','kasir','1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZEBX-105-T','CC MODEL DAUN SLEP LG 14 8K ','','0.510','1','100.00','564000','0','0','15000','571000','0','0','0','571000','LUS','T0079696','E1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBX-105-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='E1E-ZEBX-105-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 ('F226251034551','2026-05-25','0.510','2026-05-25','10:34:55','PLG0080354','571000','571000','0','571000','571000','kasir','2026-05-25 10:34:55','F22625103455');
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-05-25','F226251034551','2026-05-25','10:34:55','LUS','571000','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-260525-0012','D','2026-05-25','10:34:55','kasir','PENJUALAN','F226251034551','10030350000','571000','10030921000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='571000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251034551' 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 ('F226251034552','kasir',' 1',' MDA1 HW ','TOKO','SMBK-A','A1D-ZEAE-86-T','AT MODEL BUNGA CLOVER SLEP HW 8K ','','0.900','1','100.00','976000','0','0','15000','990000','0','0','0','990000','LUS','T0079512','A1D','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZEAE-86-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-05-25' AND kode_barang='A1D-ZEAE-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 ('F226251034552','2026-05-25','0.900','2026-05-25','10:34:55','PLG0080355','990000','990000','0','990000','990000','kasir','2026-05-25 10:34:55','F22625103455');
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-05-25','F226251034552','2026-05-25','10:34:55','LUS','990000','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-260525-0013','D','2026-05-25','10:34:55','kasir','PENJUALAN','F226251034552','10030921000','990000','10031911000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='990000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251034552' 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 ('F226251048401','kasir','1',' TFD1 7K BG','TOKO','TBK-D','D1TF-ZDXF-9-T','LT SLOBOK BULAT HURUF BG A 17K ','','0.670','1','100.00','1360000','0','0','15000','1374000','0','7000','0','1381000','TIN','T0078471','D1TF','0','0','-','0','2030000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1TF-ZDXF-9-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.670',berat_jual_asli=berat_jual_asli+'0.670',stock_jual='1',berat_akhir=berat_akhir-'0.670',berat_akhir_asli=berat_akhir_asli-'0.670',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='D1TF-ZDXF-9-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226251048401','2026-05-25','0.670','2026-05-25','10:48:40','PLG0080356','1374000','1374000','7000','1381000','1381000','kasir','2026-05-25 10:48:40','F22625104840');
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-05-25','F226251048401','2026-05-25','10:48:40','TIN','1381000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260525-0014','D','2026-05-25','10:48:40','kasir','PENJUALAN','F226251048401','10031911000','1381000','10033292000');
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 ('F226251057231','kasir','1',' MED1 5K LG','TOKO','SMBK-D','D1E-ZEXH-61-0','LT MODEL APEL CAT HITAM LG 8K ','','0.530','1','100.00','586000','0','0','15000','594000','0','5000','0','599000','TIN','00402778','D1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZEXH-61-0' 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-05-25' AND kode_barang='D1E-ZEXH-61-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 ('F226251057231','2026-05-25','0.530','2026-05-25','10:57:24','PLG0080357','594000','594000','5000','599000','599000','kasir','2026-05-25 10:57:23','F22625105723');
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-05-25','F226251057231','2026-05-25','10:57:24','TIN','599000','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-260525-0015','D','2026-05-25','10:57:24','kasir','PENJUALAN','F226251057231','10033292000','599000','10033891000');
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 ('F226251144131','kasir','1',' MEB1 LG PE','TOKO','SMBK-B','B1E-ZDBC-83-T','GW TUSUK MODEL PITA LG PE 8K ','OL','0.500','1','100.00','552000','0','0','15000','568000','0','5000','0','573000','LUS','T0078964','B1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZDBC-83-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-05-25' AND kode_barang='B1E-ZDBC-83-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 ('F226251144131','2026-05-25','0.500','2026-05-25','11:44:14','PLG0080358','568000','568000','5000','573000','573000','kasir','2026-05-25 11:44:13','F22625114413');
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-05-25','F226251144131','2026-05-25','11:44:14','LUS','573000','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-260525-0016','D','2026-05-25','11:44:14','kasir','PENJUALAN','F226251144131','10033891000','573000','10034464000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='573000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251144131' 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 ('F226251144132','kasir',' 1',' MEB1 LG PE','TOKO','SMBK-B','B1E-ZDBC-87-T','GW TUSUK MODEL PITA LG PE 8K ','OL','0.500','1','100.00','552000','0','0','15000','568000','0','5000','0','573000','LUS','T0078968','B1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZDBC-87-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-05-25' AND kode_barang='B1E-ZDBC-87-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 ('F226251144132','2026-05-25','0.500','2026-05-25','11:44:14','PLG0080359','568000','568000','5000','573000','573000','kasir','2026-05-25 11:44:13','F22625114413');
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-05-25','F226251144132','2026-05-25','11:44:14','LUS','573000','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-260525-0017','D','2026-05-25','11:44:14','kasir','PENJUALAN','F226251144132','10034464000','573000','10035037000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='573000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251144132' 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 ('F226251144133','kasir',' 1',' MEB1 5K CM','TOKO','SMBK-B','B1E-ZDBE-51-T','GW TUSUK BUNGA CLOVER CAT CM PE 8K ','OL','0.520','1','100.00','575000','0','0','15000','590000','0','5000','0','595000','LUS','T0079020','B1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZDBE-51-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='B1E-ZDBE-51-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226251144133','2026-05-25','0.520','2026-05-25','11:44:14','PLG0080360','590000','590000','5000','595000','595000','kasir','2026-05-25 11:44:13','F22625114413');
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-05-25','F226251144133','2026-05-25','11:44:14','LUS','595000','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-260525-0018','D','2026-05-25','11:44:14','kasir','PENJUALAN','F226251144133','10035037000','595000','10035632000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='595000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251144133' 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 ('F226251144134','kasir',' 1',' MEE1 5K HW','TOKO','SMBK-E','E1E-ZEBX-107-T','CC BANGKOK VAR SLEP HW 13 8K ','OL','0.410','1','100.00','453000','0','0','15000','465000','0','5000','0','470000','LUS','T0079698','E1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBX-107-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.410',berat_jual_asli=berat_jual_asli+'0.410',stock_jual='1',berat_akhir=berat_akhir-'0.410',berat_akhir_asli=berat_akhir_asli-'0.410',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='E1E-ZEBX-107-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 ('F226251144134','2026-05-25','0.410','2026-05-25','11:44:14','PLG0080361','465000','465000','5000','470000','470000','kasir','2026-05-25 11:44:13','F22625114413');
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-05-25','F226251144134','2026-05-25','11:44:14','LUS','470000','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-260525-0019','D','2026-05-25','11:44:14','kasir','PENJUALAN','F226251144134','10035632000','470000','10036102000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='470000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251144134' 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 ('F226251144135','kasir',' 1',' MEE1 5K HW','TOKO','SMBK-E','E1E-ZEBX-110-T','CC BANGKOK VAR SLEP HW 15 8K ','OL','0.430','1','100.00','475000','0','0','15000','488000','0','5000','0','493000','LUS','T0079701','E1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBX-110-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-05-25' AND kode_barang='E1E-ZEBX-110-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 ('F226251144135','2026-05-25','0.430','2026-05-25','11:44:14','PLG0080362','488000','488000','5000','493000','493000','kasir','2026-05-25 11:44:13','F22625114413');
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-05-25','F226251144135','2026-05-25','11:44:14','LUS','493000','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-260525-0020','D','2026-05-25','11:44:14','kasir','PENJUALAN','F226251144135','10036102000','493000','10036595000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='493000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251144135' 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 ('F226251144136','kasir',' 1',' MEE1 X CM ','TOKO','SMBK-E','E1E-ZEXI-284-0','CC X MODEL SLEP CM 12 8K ','OL','0.460','1','100.00','508000','0','0','15000','522000','0','5000','0','527000','LUS','00403105','E1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXI-284-0' 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-05-25' AND kode_barang='E1E-ZEXI-284-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 ('F226251144136','2026-05-25','0.460','2026-05-25','11:44:14','PLG0080363','522000','522000','5000','527000','527000','kasir','2026-05-25 11:44:13','F22625114413');
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-05-25','F226251144136','2026-05-25','11:44:14','LUS','527000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260525-0021','D','2026-05-25','11:44:14','kasir','PENJUALAN','F226251144136','10036595000','527000','10037122000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='527000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251144136' 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 ('F226251144137','kasir',' 1',' MEE1 CM 14','TOKO','SMBK-E','E1E-ZEAH-12-T','CC BUNGA CLOVER SLEP CM 14 8K ','OL','0.460','1','100.00','508000','0','0','15000','522000','0','5000','0','527000','LUS','T0079574','E1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEAH-12-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-05-25' AND kode_barang='E1E-ZEAH-12-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226251144137','2026-05-25','0.460','2026-05-25','11:44:14','PLG0080364','522000','522000','5000','527000','527000','kasir','2026-05-25 11:44:13','F22625114413');
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-05-25','F226251144137','2026-05-25','11:44:14','LUS','527000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260525-0022','D','2026-05-25','11:44:14','kasir','PENJUALAN','F226251144137','10037122000','527000','10037649000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='527000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251144137' 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 ('F226251144138','kasir',' 1',' MEE1 LG 12','TOKO','SMBK-E','E1E-ZEAE-8-T','CINCIN MODEL LINEA LG 12 8K ','OL','0.470','1','100.00','519000','0','0','15000','533000','0','5000','0','538000','LUS','T0079434','E1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEAE-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='E1E-ZEAE-8-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 ('F226251144138','2026-05-25','0.470','2026-05-25','11:44:14','PLG0080365','533000','533000','5000','538000','538000','kasir','2026-05-25 11:44:13','F22625114413');
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-05-25','F226251144138','2026-05-25','11:44:14','LUS','538000','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-260525-0023','D','2026-05-25','11:44:14','kasir','PENJUALAN','F226251144138','10037649000','538000','10038187000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='538000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251144138' 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 ('F226251144139','kasir',' 1',' MEE1 LG 12','TOKO','SMBK-E','E1E-ZEAE-7-T','CINCIN MODEL LINEA LG 12 8K ','OL','0.500','1','100.00','552000','0','0','15000','568000','0','5000','0','573000','LUS','T0079433','E1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEAE-7-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-05-25' AND kode_barang='E1E-ZEAE-7-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 ('F226251144139','2026-05-25','0.500','2026-05-25','11:44:14','PLG0080366','568000','568000','5000','573000','573000','kasir','2026-05-25 11:44:13','F22625114413');
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-05-25','F226251144139','2026-05-25','11:44:14','LUS','573000','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-260525-0024','D','2026-05-25','11:44:14','kasir','PENJUALAN','F226251144139','10038187000','573000','10038760000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='573000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251144139' 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 ('F226251145101','kasir','1',' MEE1 LG 14','TOKO','SMBK-E','E1E-ZEAE-9-T','CINCIN MODEL LINEA LG 14 8K ','OL','0.500','1','100.00','552000','0','0','15000','568000','0','5000','0','573000','LUS','T0079435','E1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEAE-9-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-05-25' AND kode_barang='E1E-ZEAE-9-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 ('F226251145101','2026-05-25','0.500','2026-05-25','11:45:10','PLG0080367','568000','568000','5000','573000','573000','kasir','2026-05-25 11:45:10','F22625114510');
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-05-25','F226251145101','2026-05-25','11:45:10','LUS','573000','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-260525-0025','D','2026-05-25','11:45:10','kasir','PENJUALAN','F226251145101','10038760000','573000','10039333000');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260525-0001','1','H1E-ZEAD-4-0','1','2.080','2.080','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZEAD-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZEAD-4-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-05-25 11:47:54' WHERE kode_barang='H1E-ZEAD-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZEAD-4-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-25 11:47:54','TOKO','SMBK-H','H1E','H1E-ZEAD-4-0','1','2.080','2.080','1','2.080','2.080','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZEAD-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZEAD-4-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260525-0001','2026-05-25','11:47','2.080','input','2026-05-25 11:47:53');
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 ('F226251150221','kasir','1',' MGA1 CM ','TOKO','SMBK-A','A1G-ZEXF-39-T','AT TINDIK BABY CM 8K ','OL','0.250','1','100.00','286000','0','0','15000','295000','0','5000','0','300000','LUS','T0079200','A1G','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1G-ZEXF-39-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='A1G-ZEXF-39-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 ('F226251150221','2026-05-25','0.250','2026-05-25','11:50:23','PLG0080368','295000','295000','5000','300000','300000','kasir','2026-05-25 11:50:22','F22625115022');
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-05-25','F226251150221','2026-05-25','11:50:23','LUS','300000','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-260525-0026','D','2026-05-25','11:50:23','kasir','PENJUALAN','F226251150221','10039333000','300000','10039633000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='300000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251150221' 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 ('F226251150222','kasir',' 1',' MEA1 LG ','TOKO','SMBK-A','A1E-ZEXA-21-T','AT MODEL DEASY MATA LG 8K ','OL','0.500','1','100.00','552000','0','0','15000','568000','0','5000','0','573000','LUS','T0079133','A1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZEXA-21-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-05-25' AND kode_barang='A1E-ZEXA-21-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 ('F226251150222','2026-05-25','0.500','2026-05-25','11:50:23','PLG0080369','568000','568000','5000','573000','573000','kasir','2026-05-25 11:50:22','F22625115022');
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-05-25','F226251150222','2026-05-25','11:50:23','LUS','573000','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-260525-0027','D','2026-05-25','11:50:23','kasir','PENJUALAN','F226251150222','10039633000','573000','10040206000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='573000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251150222' 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 ('F226251150223','kasir',' 1',' MEB1 HW ','TOKO','SMBK-B','B1E-ZEAE-92-T','GW TRIXIE PANJANG KUPU MATA VAR HW 8K ','OL','0.490','1','100.00','541000','0','0','15000','556000','0','5000','0','561000','LUS','T0079518','B1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEAE-92-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.490',berat_jual_asli=berat_jual_asli+'0.490',stock_jual='1',berat_akhir=berat_akhir-'0.490',berat_akhir_asli=berat_akhir_asli-'0.490',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='B1E-ZEAE-92-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 ('F226251150223','2026-05-25','0.490','2026-05-25','11:50:23','PLG0080370','556000','556000','5000','561000','561000','kasir','2026-05-25 11:50:22','F22625115022');
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-05-25','F226251150223','2026-05-25','11:50:23','LUS','561000','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-260525-0028','D','2026-05-25','11:50:23','kasir','PENJUALAN','F226251150223','10040206000','561000','10040767000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='561000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251150223' 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 ('F226251150224','kasir',' 1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZEBX-106-T','CC MODEL DAUN SLEP LG 12 8K ','OL','0.450','1','100.00','497000','0','0','15000','511000','0','5000','0','516000','LUS','T0079697','E1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBX-106-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-05-25' AND kode_barang='E1E-ZEBX-106-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 ('F226251150224','2026-05-25','0.450','2026-05-25','11:50:23','PLG0080371','511000','511000','5000','516000','516000','kasir','2026-05-25 11:50:22','F22625115022');
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-05-25','F226251150224','2026-05-25','11:50:23','LUS','516000','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-260525-0029','D','2026-05-25','11:50:23','kasir','PENJUALAN','F226251150224','10040767000','516000','10041283000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='516000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251150224' 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 ('F226251150225','kasir',' 1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZEBX-102-T','CC MODEL DAUN SLEP LG 11 8K ','OL','0.460','1','100.00','508000','0','0','15000','522000','0','5000','0','527000','LUS','T0079693','E1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBX-102-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-05-25' AND kode_barang='E1E-ZEBX-102-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 ('F226251150225','2026-05-25','0.460','2026-05-25','11:50:23','PLG0080372','522000','522000','5000','527000','527000','kasir','2026-05-25 11:50:22','F22625115022');
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-05-25','F226251150225','2026-05-25','11:50:23','LUS','527000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260525-0030','D','2026-05-25','11:50:23','kasir','PENJUALAN','F226251150225','10041283000','527000','10041810000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='527000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251150225' 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 ('F226251153121','kasir','1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZEBX-103-T','CC MODEL DAUN SLEP LG 14 8K ','OL','0.500','1','100.00','552000','0','0','15000','568000','0','5000','0','573000','LUS','T0079694','E1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBX-103-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-05-25' AND kode_barang='E1E-ZEBX-103-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 ('F226251153121','2026-05-25','0.500','2026-05-25','11:53:12','PLG0080373','568000','568000','5000','573000','573000','kasir','2026-05-25 11:53:12','F22625115312');
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-05-25','F226251153121','2026-05-25','11:53:12','LUS','573000','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-260525-0031','D','2026-05-25','11:53:12','kasir','PENJUALAN','F226251153121','10041810000','573000','10042383000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='573000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251153121' 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 ('F226251153122','kasir',' 1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZDXA-1-T','GL GUCCI UB 8K ','OL','0.580','1','100.00','641000','0','0','15000','658000','0','5000','0','663000','LUS','T0078382','F3E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDXA-1-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-05-25' AND kode_barang='F3E-ZDXA-1-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226251153122','2026-05-25','0.580','2026-05-25','11:53:12','PLG0080374','658000','658000','5000','663000','663000','kasir','2026-05-25 11:53:12','F22625115312');
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-05-25','F226251153122','2026-05-25','11:53:12','LUS','663000','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-260525-0032','D','2026-05-25','11:53:12','kasir','PENJUALAN','F226251153122','10042383000','663000','10043046000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='663000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251153122' 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 ('F226251153123','kasir',' 1',' MEF3 5K UB','TOKO','SMBK-F','F3E-ZDXF-76-T','GL RANTAI HOLLOW P3 SLEP UB 8K ','OL','1.000','1','100.00','1105000','0','0','15000','1130000','0','5000','0','1135000','LUS','T0078538','F3E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDXF-76-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='F3E-ZDXF-76-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 ('F226251153123','2026-05-25','1.000','2026-05-25','11:53:12','PLG0080375','1130000','1130000','5000','1135000','1135000','kasir','2026-05-25 11:53:12','F22625115312');
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-05-25','F226251153123','2026-05-25','11:53:12','LUS','1135000','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-260525-0033','D','2026-05-25','11:53:12','kasir','PENJUALAN','F226251153123','10043046000','1135000','10044181000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1135000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251153123' 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 ('F226251153124','kasir',' 1',' MEF3E HW ','TOKO','SMBK-F','F3E-ZEBA-41-T','GL TIFF VAR SLEP HW 8K ','OL','0.730','1','100.00','807000','0','0','15000','829000','0','5000','0','834000','LUS','T0079748','F3E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEBA-41-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.730',berat_jual_asli=berat_jual_asli+'0.730',stock_jual='1',berat_akhir=berat_akhir-'0.730',berat_akhir_asli=berat_akhir_asli-'0.730',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='F3E-ZEBA-41-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 ('F226251153124','2026-05-25','0.730','2026-05-25','11:53:12','PLG0080376','829000','829000','5000','834000','834000','kasir','2026-05-25 11:53:12','F22625115312');
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-05-25','F226251153124','2026-05-25','11:53:12','LUS','834000','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-260525-0034','D','2026-05-25','11:53:12','kasir','PENJUALAN','F226251153124','10044181000','834000','10045015000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='834000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251153124' 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 ('F226251153125','kasir',' 1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZEAB-13-T','GL KOREA UB 8K ','OL','0.910','1','100.00','1006000','0','0','15000','1033000','0','5000','0','1038000','LUS','T0079371','F3E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEAB-13-T' 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-05-25' AND kode_barang='F3E-ZEAB-13-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 ('F226251153125','2026-05-25','0.910','2026-05-25','11:53:12','PLG0080377','1033000','1033000','5000','1038000','1038000','kasir','2026-05-25 11:53:12','F22625115312');
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-05-25','F226251153125','2026-05-25','11:53:12','LUS','1038000','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-260525-0035','D','2026-05-25','11:53:12','kasir','PENJUALAN','F226251153125','10045015000','1038000','10046053000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1038000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251153125' 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 ('F226251153126','kasir',' 1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZEXF-24-T','GL LONG LING UB 8K ','OL','1.050','1','100.00','1160000','0','0','15000','1187000','0','5000','0','1192000','LUS','T0079185','F3E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXF-24-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='F3E-ZEXF-24-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226251153126','2026-05-25','1.050','2026-05-25','11:53:12','PLG0080378','1187000','1187000','5000','1192000','1192000','kasir','2026-05-25 11:53:12','F22625115312');
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-05-25','F226251153126','2026-05-25','11:53:12','LUS','1192000','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-260525-0036','D','2026-05-25','11:53:12','kasir','PENJUALAN','F226251153126','10046053000','1192000','10047245000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1192000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251153126' 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 ('F226251155421','kasir','1',' MEF3E KH ','TOKO','SMBK-F','F3E-ZEBX-80-T','GL KOREA VAR SLEP KH 8K ','OL','2.200','1','100.00','2431000','0','0','15000','2475000','0','11000','0','2486000','TJ','T0079671','F3E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEBX-80-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.200',berat_jual_asli=berat_jual_asli+'2.200',stock_jual='1',berat_akhir=berat_akhir-'2.200',berat_akhir_asli=berat_akhir_asli-'2.200',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='F3E-ZEBX-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 ('F226251155421','2026-05-25','2.200','2026-05-25','11:55:43','PLG0080379','2475000','2475000','11000','2486000','2486000','kasir','2026-05-25 11:55:42','F22625115542');
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-05-25','F226251155421','2026-05-25','11:55:43','TJ','2486000','11000');
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-260525-0037','D','2026-05-25','11:55:43','kasir','PENJUALAN','F226251155421','10047245000','2486000','10049731000');
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 ('F226251216001','kasir','1',' MEB1 5K CM','TOKO','SMBK-B','B1E-ZDBC-48-T','GW TUSUK BUNGA CLOVER CAT CM PE 8K ','','0.520','1','100.00','575000','0','0','15000','582000','0','0','0','582000','LUS','T0078929','B1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZDBC-48-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-05-25' AND kode_barang='B1E-ZDBC-48-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 ('F226251216001','2026-05-25','0.520','2026-05-25','12:16:00','PLG0080380','582000','582000','0','582000','582000','kasir','2026-05-25 12:16:00','F22625121600');
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-05-25','F226251216001','2026-05-25','12:16:00','LUS','582000','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-260525-0038','D','2026-05-25','12:16:00','kasir','PENJUALAN','F226251216001','10049731000','582000','10050313000');
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 ('F226251218081','kasir','1',' MEH1 KH 42','TOKO','SMBK-H','H1E-ZEAD-4-0','KL SANTA KH 42 8K ','OLS AE2X5','2.080','1','100.00','2330000','0','0','15000','2330000','0','146000','0','2476000','TJ','00403476','H1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEAD-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.080',berat_jual_asli=berat_jual_asli+'2.080',stock_jual='1',berat_akhir=berat_akhir-'2.080',berat_akhir_asli=berat_akhir_asli-'2.080',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='H1E-ZEAD-4-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 ('F226251218081','2026-05-25','2.080','2026-05-25','12:18:09','PLG0080381','2330000','2330000','146000','2476000','2476000','kasir','2026-05-25 12:18:08','F22625121808');
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-05-25','F226251218081','2026-05-25','12:18:09','TJ','2476000','146000');
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-260525-0039','D','2026-05-25','12:18:09','kasir','PENJUALAN','F226251218081','10050313000','2476000','10052789000');
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 ('F226251220061','kasir','1',' MEE2 CM 10','TOKO','SMBK-E','E2E-ZEAH-14-T','CC MODEL KUPU MATA VAR CM 10 8K ','OL','0.700','1','100.00','773000','0','0','15000','791000','0','5000','0','796000','TIN','T0079576','E2E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZEAH-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.700',berat_jual_asli=berat_jual_asli+'0.700',stock_jual='1',berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='E2E-ZEAH-14-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 ('F226251220061','2026-05-25','0.700','2026-05-25','12:20:07','PLG0080382','791000','791000','5000','796000','796000','kasir','2026-05-25 12:20:06','F22625122006');
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-05-25','F226251220061','2026-05-25','12:20:07','TIN','796000','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-260525-0040','D','2026-05-25','12:20:07','kasir','PENJUALAN','F226251220061','10052789000','796000','10053585000');
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 ('F226251220331','kasir','1',' MDE2 CM 16','TOKO','SMBK-E','E2D-YJXA-49-T','CC MODEL MATA VAR CM 16 8K ','OL','1.100','1','100.00','1193000','0','0','15000','1215000','0','6000','0','1221000','TIN','T0073541','E2D','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJXA-49-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-05-25' AND kode_barang='E2D-YJXA-49-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 ('F226251220331','2026-05-25','1.100','2026-05-25','12:20:33','PLG0080383','1215000','1215000','6000','1221000','1221000','kasir','2026-05-25 12:20:33','F22625122033');
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-05-25','F226251220331','2026-05-25','12:20:33','TIN','1221000','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-260525-0041','D','2026-05-25','12:20:33','kasir','PENJUALAN','F226251220331','10053585000','1221000','10054806000');
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 ('F226250134051','kasir','1',' MDE1 10K C','TOKO','SMBK-E','E1D-ZEBX-43-T','CC WEDDING MATA SLEP CM 20 8K ','','1.540','1','100.00','1671000','0','0','15000','1694000','0','10000','0','1704000','LUS','T0079634','E1D','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZEBX-43-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.540',berat_jual_asli=berat_jual_asli+'1.540',stock_jual='1',berat_akhir=berat_akhir-'1.540',berat_akhir_asli=berat_akhir_asli-'1.540',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='E1D-ZEBX-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 ('F226250134051','2026-05-25','1.540','2026-05-25','13:34:05','PLG0080384','1694000','1694000','10000','1704000','1704000','kasir','2026-05-25 13:34:05','F22625013405');
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-05-25','F226250134051','2026-05-25','13:34:05','LUS','1704000','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-260525-0042','D','2026-05-25','13:34:05','kasir','PENJUALAN','F226250134051','10054806000','1704000','10056510000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1704000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250134051' 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 ('F226250134052','kasir',' 1',' MED2 CM ','TOKO','SMBK-D','D2E-ZBAX-54-T','LT MODEL KUPU MATA VAR CM 8K ','','0.720','1','100.00','796000','0','0','15000','806000','0','0','0','806000','LUS','T0077169','D2E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZBAX-54-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-05-25' AND kode_barang='D2E-ZBAX-54-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 ('F226250134052','2026-05-25','0.720','2026-05-25','13:34:05','PLG0080385','806000','806000','0','806000','806000','kasir','2026-05-25 13:34:05','F22625013405');
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-05-25','F226250134052','2026-05-25','13:34:05','LUS','806000','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-260525-0043','D','2026-05-25','13:34:05','kasir','PENJUALAN','F226250134052','10056510000','806000','10057316000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='806000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250134052' 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 ('F226250135151','kasir','1',' TEH1 X UB4','TOKO','TBK-H','H1TE-ZEBB-82-T','KL X MILANO UB 42 17K ','','2.020','1','100.00','4060000','0','0','15000','4101000','0','0','0','4101000','LUS','T0079845','H1TE','0','0','-','0','2010000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TE-ZEBB-82-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='H1TE-ZEBB-82-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226250135151','2026-05-25','2.020','2026-05-25','13:35:16','PLG0080386','4101000','4101000','0','4101000','4101000','kasir','2026-05-25 13:35:15','F22625013515');
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-05-25','F226250135151','2026-05-25','13:35:16','LUS','4101000','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-260525-0044','D','2026-05-25','13:35:16','kasir','PENJUALAN','F226250135151','10057316000','4101000','10061417000');
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 ('F226250209151','kasir','1',' TEF1 UB D5','TOKO','TBK-F','F1TE-ZDXF-1-T','GL OVAL MODEL C UB D56 17K ','OL','3.130','1','100.00','6291000','0','0','15000','6363000','0','22000','0','6385000','LUS','T0078463','F1TE','0','0','-','0','2010000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1TE-ZDXF-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.130',berat_jual_asli=berat_jual_asli+'3.130',stock_jual='1',berat_akhir=berat_akhir-'3.130',berat_akhir_asli=berat_akhir_asli-'3.130',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='F1TE-ZDXF-1-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 ('F226250209151','2026-05-25','3.130','2026-05-25','14:09:16','PLG0080387','6363000','6363000','22000','6385000','6385000','kasir','2026-05-25 14:09:15','F22625020915');
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-05-25','F226250209151','2026-05-25','14:09:16','LUS','6385000','22000');
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-260525-0045','D','2026-05-25','14:09:16','kasir','PENJUALAN','F226250209151','10061417000','6385000','10067802000');
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 ('F226250210121','kasir','1',' MEB1 5K LG','TOKO','SMBK-B','B1E-ZEAE-50-T','GW TUSUK APEL CAT VAR LG PE 8K ','OL','0.470','1','100.00','519000','0','0','15000','533000','0','5000','0','538000','LUS','T0079476','B1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEAE-50-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='B1E-ZEAE-50-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226250210121','2026-05-25','0.470','2026-05-25','14:10:12','PLG0080388','533000','533000','5000','538000','538000','kasir','2026-05-25 14:10:12','F22625021012');
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-05-25','F226250210121','2026-05-25','14:10:12','LUS','538000','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-260525-0046','D','2026-05-25','14:10:12','kasir','PENJUALAN','F226250210121','10067802000','538000','10068340000');
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 ('F226250239161','kasir','1',' MEE2 5K LG','TOKO','SMBK-E','E2E-ZDBX-23-T','CC ANAK OSROT BONEKA CAT MATA LG 8K ','','0.500','1','100.00','552000','0','0','15000','560000','0','5000','0','565000','TIN','T0078758','E2E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZDBX-23-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-05-25' AND kode_barang='E2E-ZDBX-23-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 ('F226250239161','2026-05-25','0.500','2026-05-25','14:39:16','PLG0080389','560000','560000','5000','565000','565000','kasir','2026-05-25 14:39:16','F22625023916');
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-05-25','F226250239161','2026-05-25','14:39:16','TIN','565000','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-260525-0047','D','2026-05-25','14:39:16','kasir','PENJUALAN','F226250239161','10068340000','565000','10068905000');
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 ('F226250249271','kasir','1',' MEA1 CM ','TOKO','SMBK-A','A1E-ZDBC-8-T','AT JERSY POLOS CM 8K ','','0.550','1','100.00','608000','0','0','15000','616000','0','0','0','616000','TIN','T0078889','A1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZDBC-8-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-05-25' AND kode_barang='A1E-ZDBC-8-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 ('F226250249271','2026-05-25','0.550','2026-05-25','14:49:27','PLG0080390','616000','616000','0','616000','616000','kasir','2026-05-25 14:49:27','F22625024927');
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-05-25','F226250249271','2026-05-25','14:49:27','TIN','616000','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-260525-0048','D','2026-05-25','14:49:27','kasir','PENJUALAN','F226250249271','10068905000','616000','10069521000');
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 ('F226250329101','kasir','1',' MEB1 HW ','TOKO','SMBK-B','B1E-ZEAE-91-T','GW TRIXIE PANJANG KUPU MATA VAR HW 8K ','OL','0.490','1','100.00','541000','0','0','15000','556000','0','5000','0','561000','TIN','T0079517','B1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEAE-91-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.490',berat_jual_asli=berat_jual_asli+'0.490',stock_jual='1',berat_akhir=berat_akhir-'0.490',berat_akhir_asli=berat_akhir_asli-'0.490',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='B1E-ZEAE-91-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 ('F226250329101','2026-05-25','0.490','2026-05-25','15:29:11','PLG0080391','556000','556000','5000','561000','561000','kasir','2026-05-25 15:29:10','F22625032910');
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-05-25','F226250329101','2026-05-25','15:29:11','TIN','561000','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-260525-0049','D','2026-05-25','15:29:11','kasir','PENJUALAN','F226250329101','10069521000','561000','10070082000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='561000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250329101' 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 ('F226250329102','kasir',' 1',' MEB1 5K HW','TOKO','SMBK-B','B1E-ZEAF-19-T','GW TRIXIE PANJANG HATI CAT VAR HW 8K ','OL','0.570','1','100.00','630000','0','0','15000','647000','0','5000','0','652000','TIN','T0079541','B1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEAF-19-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-05-25' AND kode_barang='B1E-ZEAF-19-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 ('F226250329102','2026-05-25','0.570','2026-05-25','15:29:11','PLG0080392','647000','647000','5000','652000','652000','kasir','2026-05-25 15:29:10','F22625032910');
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-05-25','F226250329102','2026-05-25','15:29:11','TIN','652000','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-260525-0050','D','2026-05-25','15:29:11','kasir','PENJUALAN','F226250329102','10070082000','652000','10070734000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='652000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250329102' 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 ('F226250329103','kasir',' 1',' MEB1 5K HW','TOKO','SMBK-B','B1E-ZEAF-17-T','GW TRIXIE PANJANG HATI CAT VAR HW 8K ','OL','0.570','1','100.00','630000','0','0','15000','647000','0','5000','0','652000','TIN','T0079539','B1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEAF-17-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-05-25' AND kode_barang='B1E-ZEAF-17-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 ('F226250329103','2026-05-25','0.570','2026-05-25','15:29:11','PLG0080393','647000','647000','5000','652000','652000','kasir','2026-05-25 15:29:10','F22625032910');
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-05-25','F226250329103','2026-05-25','15:29:11','TIN','652000','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-260525-0051','D','2026-05-25','15:29:11','kasir','PENJUALAN','F226250329103','10070734000','652000','10071386000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='652000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250329103' 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 ('F226250329104','kasir',' 1',' MEB1E HW ','TOKO','SMBK-B','B1E-ZEBX-25-T','GW MODEL PANJANG KUPU MATA SLEP HW 8K ','OL','0.640','1','100.00','707000','0','0','15000','726000','0','5000','0','731000','TIN','T0079616','B1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEBX-25-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.640',berat_jual_asli=berat_jual_asli+'0.640',stock_jual='1',berat_akhir=berat_akhir-'0.640',berat_akhir_asli=berat_akhir_asli-'0.640',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='B1E-ZEBX-25-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 ('F226250329104','2026-05-25','0.640','2026-05-25','15:29:11','PLG0080394','726000','726000','5000','731000','731000','kasir','2026-05-25 15:29:10','F22625032910');
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-05-25','F226250329104','2026-05-25','15:29:11','TIN','731000','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-260525-0052','D','2026-05-25','15:29:11','kasir','PENJUALAN','F226250329104','10071386000','731000','10072117000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='731000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250329104' 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 ('F226250329105','kasir',' 1',' MEB1 HW ','TOKO','SMBK-B','B1E-ZEAF-11-T','GW TRIXIE PANJANG KUPU MATA HW 8K ','OL','0.640','1','100.00','707000','0','0','15000','726000','0','5000','0','731000','TIN','T0079533','B1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEAF-11-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.640',berat_jual_asli=berat_jual_asli+'0.640',stock_jual='1',berat_akhir=berat_akhir-'0.640',berat_akhir_asli=berat_akhir_asli-'0.640',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='B1E-ZEAF-11-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 ('F226250329105','2026-05-25','0.640','2026-05-25','15:29:11','PLG0080395','726000','726000','5000','731000','731000','kasir','2026-05-25 15:29:10','F22625032910');
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-05-25','F226250329105','2026-05-25','15:29:11','TIN','731000','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-260525-0053','D','2026-05-25','15:29:11','kasir','PENJUALAN','F226250329105','10072117000','731000','10072848000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='731000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250329105' 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 ('F226250329106','kasir',' 1',' MEB1E HW ','TOKO','SMBK-B','B1E-ZEBX-24-T','GW MODEL PANJANG KUPU MATA SLEP HW 8K ','OL','0.650','1','100.00','718000','0','0','15000','738000','0','5000','0','743000','TIN','T0079615','B1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEBX-24-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='B1E-ZEBX-24-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 ('F226250329106','2026-05-25','0.650','2026-05-25','15:29:11','PLG0080396','738000','738000','5000','743000','743000','kasir','2026-05-25 15:29:10','F22625032910');
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-05-25','F226250329106','2026-05-25','15:29:11','TIN','743000','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-260525-0054','D','2026-05-25','15:29:11','kasir','PENJUALAN','F226250329106','10072848000','743000','10073591000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='743000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250329106' 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 ('F226250329107','kasir',' 1',' MEB1E HW ','TOKO','SMBK-B','B1E-ZEBX-26-T','GW MODEL PANJANG KUPU MATA SLEP HW 8K ','OL','0.650','1','100.00','718000','0','0','15000','738000','0','5000','0','743000','TIN','T0079617','B1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEBX-26-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='B1E-ZEBX-26-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 ('F226250329107','2026-05-25','0.650','2026-05-25','15:29:11','PLG0080397','738000','738000','5000','743000','743000','kasir','2026-05-25 15:29:10','F22625032910');
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-05-25','F226250329107','2026-05-25','15:29:11','TIN','743000','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-260525-0055','D','2026-05-25','15:29:11','kasir','PENJUALAN','F226250329107','10073591000','743000','10074334000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='743000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250329107' 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 ('F226250329108','kasir',' 1',' MED1 5K YT','TOKO','SMBK-D','D1E-ZEAH-25-T','LT MODEL BUNGA CLOVER HITAM YT 8K ','OL','0.500','1','100.00','552000','0','0','15000','568000','0','5000','0','573000','TIN','T0079587','D1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZEAH-25-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-05-25' AND kode_barang='D1E-ZEAH-25-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 ('F226250329108','2026-05-25','0.500','2026-05-25','15:29:11','PLG0080398','568000','568000','5000','573000','573000','kasir','2026-05-25 15:29:10','F22625032910');
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-05-25','F226250329108','2026-05-25','15:29:11','TIN','573000','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-260525-0056','D','2026-05-25','15:29:11','kasir','PENJUALAN','F226250329108','10074334000','573000','10074907000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='573000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250329108' 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 ('F226250330041','kasir','1',' MED1 5K YT','TOKO','SMBK-D','D1E-ZEAH-26-T','LT MODEL BUNGA CLOVER HITAM YT 8K ','OL','0.530','1','100.00','586000','0','0','15000','602000','0','5000','0','607000','TIN','T0079588','D1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZEAH-26-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-05-25' AND kode_barang='D1E-ZEAH-26-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 ('F226250330041','2026-05-25','0.530','2026-05-25','15:30:05','PLG0080399','602000','602000','5000','607000','607000','kasir','2026-05-25 15:30:04','F22625033004');
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-05-25','F226250330041','2026-05-25','15:30:05','TIN','607000','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-260525-0057','D','2026-05-25','15:30:05','kasir','PENJUALAN','F226250330041','10074907000','607000','10075514000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='607000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250330041' 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 ('F226250330042','kasir',' 1',' MFD1 10K B','TOKO','SMBK-D','D1F-ZEAH-18-T','LT MODEL IKAN PASIR VAR BG 8K ','OL','1.960','1','100.00','2205000','0','0','15000','2254000','0','10000','0','2264000','TIN','T0079580','D1F','0','0','-','0','1125000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZEAH-18-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-05-25' AND kode_barang='D1F-ZEAH-18-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 ('F226250330042','2026-05-25','1.960','2026-05-25','15:30:05','PLG0080400','2254000','2254000','10000','2264000','2264000','kasir','2026-05-25 15:30:04','F22625033004');
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-05-25','F226250330042','2026-05-25','15:30:05','TIN','2264000','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-260525-0058','D','2026-05-25','15:30:05','kasir','PENJUALAN','F226250330042','10075514000','2264000','10077778000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2264000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250330042' 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 ('F226250330361','kasir','1',' MDB1 HW ','TOKO','SMBK-B','B1D-ZEAF-13-T','GW ITALY PANJANG PITA VAR HW 8K ','OL','0.820','1','100.00','890000','0','0','15000','910000','0','5000','0','915000','TIN','T0079535','B1D','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-ZEAF-13-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-05-25' AND kode_barang='B1D-ZEAF-13-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 ('F226250330361','2026-05-25','0.820','2026-05-25','15:30:36','PLG0080401','910000','910000','5000','915000','915000','kasir','2026-05-25 15:30:36','F22625033036');
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-05-25','F226250330361','2026-05-25','15:30:36','TIN','915000','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-260525-0059','D','2026-05-25','15:30:36','kasir','PENJUALAN','F226250330361','10077778000','915000','10078693000');
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 ('F226250333301','kasir','1',' MDD2 HW R ','TOKO','SMBK-D','D2D-ZCAX-54-T','LT MODEL HURUF MATA HW R 8K','','0.980','1','100.00','1063000','0','0','15000','1078000','0','0','0','1078000','LUS','T0077995','D2D','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-ZCAX-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-05-25' AND kode_barang='D2D-ZCAX-54-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 ('F226250333301','2026-05-25','0.980','2026-05-25','15:33:30','PLG0080402','1078000','1078000','0','1078000','1078000','kasir','2026-05-25 15:33:30','F22625033330');
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-05-25','F226250333301','2026-05-25','15:33:30','LUS','1078000','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-260525-0060','D','2026-05-25','15:33:30','kasir','PENJUALAN','F226250333301','10078693000','1078000','10079771000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1078000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250333301' 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 ('F226250333302','kasir',' 1',' MEH1E UB 4','TOKO','SMBK-H','H1E-ZEBX-86-T','KL MILANO UB 42 8K ','','2.150','1','100.00','2376000','0','0','15000','2408000','0','0','0','2408000','LUS','T0079677','H1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEBX-86-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.150',berat_jual_asli=berat_jual_asli+'2.150',stock_jual='1',berat_akhir=berat_akhir-'2.150',berat_akhir_asli=berat_akhir_asli-'2.150',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='H1E-ZEBX-86-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 ('F226250333302','2026-05-25','2.150','2026-05-25','15:33:30','PLG0080403','2408000','2408000','0','2408000','2408000','kasir','2026-05-25 15:33:30','F22625033330');
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-05-25','F226250333302','2026-05-25','15:33:30','LUS','2408000','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-260525-0061','D','2026-05-25','15:33:30','kasir','PENJUALAN','F226250333302','10079771000','2408000','10082179000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2408000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250333302' 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 ('F226250334171','kasir','1',' MGA1 CM ','TOKO','SMBK-A','A1G-ZEAE-75-T','AT TINDIK BABY CM 8K ','OL','0.250','1','100.00','286000','0','0','15000','293000','0','5000','0','298000','LUS','T0079501','A1G','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-05-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1G-ZEAE-75-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2026-05-25' AND kode_barang='A1G-ZEAE-75-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 ('F226250334171','2026-05-25','0.250','2026-05-25','15:34:18','PLG0080404','293000','293000','5000','298000','298000','kasir','2026-05-25 15:34:17','F22625033417');
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-05-25','F226250334171','2026-05-25','15:34:18','LUS','298000','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-260525-0062','D','2026-05-25','15:34:18','kasir','PENJUALAN','F226250334171','10082179000','298000','10082477000');
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-00005382','X-00005382','AT JERSY SLEP LG 8K','GR','---','A1D','BELI','BELI001','990000','2026-05-25','1.000','1','kasir','2026-05-25 16:13:09');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00005382','X-00005382');
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-260525-0001','F226210233151','TIN','1','BELI','BELI001','A1D', 'X-00005382', 'AT JERSY SLEP LG 8K','1.000','1.000','100.00','1150000','990000','990000','1085000','1','990000','990000','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-05-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1D' 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-260525-0001','2026-05-25','2026-05-25','16:13:09','TIN','---','1.000','990000','990000','990000','990000','990000','kasir','2026-05-25 16:13:09','FB-260525-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260525-0001','MENIK','GEMAHARJO PACITAN','','','087739456638','kasir','2026-05-25 16:13:09');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-25' 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-260525-0063','K','2026-05-25','16:13:09','kasir','PEMBELIAN UMUM','FB-260525-0001','10082477000','990000','10081487000');
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-00005383','X-00005383','GL ANAK BANGKOK HOLLOW LASER PM D34 8K','GR','---','F1E','BELI','BELI001','2035000','2026-05-25','2.020','1','kasir','2026-05-25 16:13:36');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00005383','X-00005383');
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-260525-0002','F226191105201','LUS','1','BELI','BELI001','F1E', 'X-00005383', 'GL ANAK BANGKOK HOLLOW LASER PM D34 8K','2.020','2.020','100.00','2525000','2035000','1007426','1120000','1','2035000','2035000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.020',berat_beli_asli=berat_beli_asli+'2.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.020',berat_akhir_asli=berat_akhir_asli+'2.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' 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-260525-0002','2026-05-25','2026-05-25','16:13:36','LUS','---','2.020','2035000','2035000','2035000','2035000','2035000','kasir','2026-05-25 16:13:36','FB-260525-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260525-0002','KARMILA','SUKOREJO','','','082333482700','kasir','2026-05-25 16:13:36');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-25' 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-260525-0064','K','2026-05-25','16:13:36','kasir','PEMBELIAN UMUM','FB-260525-0002','10081487000','2035000','10079452000');
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-00005384','X-00005384','LT MODEL APEL CAT VAR LG 17K','GR','---','D1TE','BELI','BELI001','704000','2026-05-25','0.440','1','kasir','2026-05-25 16:14:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1TE','X-00005384','X-00005384');
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-260525-0003','F224020806261','TIN','1','BELI','BELI001','D1TE', 'X-00005384', 'LT MODEL APEL CAT VAR LG 17K','0.550','0.440','100.00','603000','704000','1600000','2010000','1','704000','704000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.440',berat_beli_asli=berat_beli_asli+'0.440',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.440',berat_akhir_asli=berat_akhir_asli+'0.440',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1TE' 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-260525-0003','2026-05-25','2026-05-25','16:14:30','TIN','---','0.440','704000','704000','704000','704000','704000','kasir','2026-05-25 16:14:30','FB-260525-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260525-0003','HANDRIANA','KRAJAN SUKOREJO','','','081330800087','kasir','2026-05-25 16:14:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-25' 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-260525-0065','K','2026-05-25','16:14:30','kasir','PEMBELIAN UMUM','FB-260525-0003','10079452000','704000','10078748000');
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-00005385','X-00005385','GL TRIXIE SERUT BUNGA CLOVER MATA VAR YT 17K','GR','---','F3TF','BELI','BELI001','2800000','2026-05-25','1.750','1','kasir','2026-05-25 16:15:01');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3TF';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3TF','X-00005385','X-00005385');
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-260525-0004','F224100403491','LUS','1','BELI','BELI001','F3TF', 'X-00005385', 'GL TRIXIE SERUT BUNGA CLOVER MATA VAR YT 17K','2.320','1.750','100.00','2471000','2800000','1600000','2030000','1','2800000','2800000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.750',berat_beli_asli=berat_beli_asli+'1.750',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.750',berat_akhir_asli=berat_akhir_asli+'1.750',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-25' 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-260525-0004','2026-05-25','2026-05-25','16:15:00','LUS','---','1.750','2800000','2800000','2800000','2800000','2800000','kasir','2026-05-25 16:15:01','FB-260525-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260525-0004','ANGELA','SUKOREJO','','','081330800087','kasir','2026-05-25 16:15:01');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-25' 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-260525-0066','K','2026-05-25','16:15:00','kasir','PEMBELIAN UMUM','FB-260525-0004','10078748000','2800000','10075948000');
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-00005386','X-00005386','CC MODEL SLEP VAR HW 13 8K','GR','---','E1E','BELI','BELI001','653000','2026-05-25','0.660','1','kasir','2026-05-25 16:15:39');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00005386','X-00005386');
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-260525-0005','F226070259271','TIN','1','BELI','BELI001','E1E', 'X-00005386', 'CC MODEL SLEP VAR HW 13 8K','0.660','0.660','100.00','752000','653000','989394','1120000','1','653000','653000','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-05-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260525-0005','2026-05-25','2026-05-25','16:15:38','TIN','---','0.660','653000','653000','653000','653000','653000','kasir','2026-05-25 16:15:39','FB-260525-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260525-0005','RICHA','JL SEKAR GAYAM 27E','','','','kasir','2026-05-25 16:15:39');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-25' 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-260525-0067','K','2026-05-25','16:15:38','kasir','PEMBELIAN UMUM','FB-260525-0005','10075948000','653000','10075295000');
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-00005387','X-00005387','LT SLOBOK BOLA ARESO LG 8K','GR','---','D1E','BELI','BELI001','423000','2026-05-25','0.420','1','kasir','2026-05-25 16:15:39');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1E','X-00005387','X-00005387');
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-260525-0006','F226200219581','TIN','2','BELI','BELI001','D1E', 'X-00005387', 'LT SLOBOK BOLA ARESO LG 8K','0.420','0.420','100.00','490000','423000','1007143','1120000','1','423000','423000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.420',berat_beli_asli=berat_beli_asli+'0.420',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.420',berat_akhir_asli=berat_akhir_asli+'0.420',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1E' 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-260525-0006','2026-05-25','2026-05-25','16:15:38','TIN','---','0.420','423000','423000','423000','423000','423000','kasir','2026-05-25 16:15:39','FB-260525-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260525-0006','RICHA','JL. SEKAR GAYAM 27E TONATAN','','','085124247246','kasir','2026-05-25 16:15:39');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-25' 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-260525-0068','K','2026-05-25','16:15:38','kasir','PEMBELIAN UMUM','FB-260525-0006','10075295000','423000','10074872000');
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-00005388','X-00005388','CC ANAK BONEKA CAT MATA LG 8K','GR','---','E2E','BELI','BELI001','463000','2026-05-25','0.460','1','kasir','2026-05-25 16:16:08');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00005388','X-00005388');
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-260525-0007','F226131226471','TIN','1','BELI','BELI001','E2E', 'X-00005388', 'CC ANAK BONEKA CAT MATA LG 8K','0.460','0.460','100.00','536000','463000','1006522','1120000','1','463000','463000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.460',berat_beli_asli=berat_beli_asli+'0.460',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.460',berat_akhir_asli=berat_akhir_asli+'0.460',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-25' 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-260525-0007','2026-05-25','2026-05-25','16:16:08','TIN','---','0.460','463000','463000','463000','463000','463000','kasir','2026-05-25 16:16:08','FB-260525-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260525-0007','ORLIN','KEMIRI JENANGAN','','','081231646275','kasir','2026-05-25 16:16:08');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-25' 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-260525-0069','K','2026-05-25','16:16:08','kasir','PEMBELIAN UMUM','FB-260525-0007','10074872000','463000','10074409000');
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-00005389','X-00005389','GL COR T 17K','GR','---','F1TE','BELI','BELI001','8070000','2026-05-25','4.950','1','kasir','2026-05-25 16:17:56');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1TE','X-00005389','X-00005389');
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-260525-0008','MEGA','RHM','1','BELI','BELI001','F1TE', 'X-00005389', 'GL COR T 17K','5.110','4.950','100.00','3516000','8070000','1630303','2010000','1','8070000','8070000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.950',berat_beli_asli=berat_beli_asli+'4.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.950',berat_akhir_asli=berat_akhir_asli+'4.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1TE' 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-260525-0008','2026-05-25','2026-05-25','16:17:55','RHM','---','4.950','8070000','8070000','8070000','8070000','8070000','kasir','2026-05-25 16:17:56','FB-260525-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260525-0008','JL PARANG BARIS','-','','','','kasir','2026-05-25 16:17:56');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-25' 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-260525-0070','K','2026-05-25','16:17:55','kasir','PEMBELIAN UMUM','FB-260525-0008','10074409000','8070000','10066339000');
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-00005390','X-00005390','GL MODEL FLIK VAR HW 8K','GR','---','F3E','BELI','BELI001','1440000','2026-05-25','1.650','1','kasir','2026-05-25 16:18:38');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00005390','X-00005390');
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-260525-0009','F226110134421','TJ','1','BELI','BELI001','F3E', 'X-00005390', 'GL MODEL FLIK VAR HW 8K','1.650','1.650','100.00','2005000','1440000','872727','1120000','1','1440000','1440000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.650',berat_beli_asli=berat_beli_asli+'1.650',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.650',berat_akhir_asli=berat_akhir_asli+'1.650',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260525-0009','2026-05-25','2026-05-25','16:18:37','TJ','---','1.650','1440000','1440000','1440000','1440000','1440000','kasir','2026-05-25 16:18:38','FB-260525-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260525-0009','TIARA','JL WONOSALAM KADIPATEN','','','','kasir','2026-05-25 16:18:38');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-25' 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-260525-0071','K','2026-05-25','16:18:37','kasir','PEMBELIAN UMUM','FB-260525-0009','10066339000','1440000','10064899000');
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-00005391','X-00005391','CC X MODEL MATA CM 12 8K','GR','---','E2D','BELI','BELI001','860000','2026-05-25','0.850','1','kasir','2026-05-25 16:18:38');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00005391','X-00005391');
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-260525-0010','F226110134422','TJ','2','BELI','BELI001','E2D', 'X-00005391', 'CC X MODEL MATA CM 12 8K','0.850','0.850','100.00','1015000','860000','1011765','1085000','1','860000','860000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.850',berat_beli_asli=berat_beli_asli+'0.850',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.850',berat_akhir_asli=berat_akhir_asli+'0.850',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' 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-260525-0010','2026-05-25','2026-05-25','16:18:37','TJ','---','0.850','860000','860000','860000','860000','860000','kasir','2026-05-25 16:18:38','FB-260525-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260525-0010','TIARA','JL WONOSALAM KADIPATEN','','','','kasir','2026-05-25 16:18:38');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-25' 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-260525-0072','K','2026-05-25','16:18:37','kasir','PEMBELIAN UMUM','FB-260525-0010','10064899000','860000','10064039000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250134051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250134051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250134051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250134052' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250134052' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250134052';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250135151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250135151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250135151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250209151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250209151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250209151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250210121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250210121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250210121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250239161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250239161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250239161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250249271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250249271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250249271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250329101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250329101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250329101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250329102' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250329102' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250329102';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250329103' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250329103' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250329103';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250329104' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250329104' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250329104';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250329105' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250329105' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250329105';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250329106' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250329106' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250329106';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250329107' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250329107' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250329107';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250329108' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250329108' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250329108';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250330041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250330041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250330041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250330042' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250330042' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250330042';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250330361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250330361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250330361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250333301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250333301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250333301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250333302' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250333302' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250333302';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250334171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250334171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250334171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250833591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250833591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250833591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250917131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250917131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250917131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250919101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250919101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250919101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250920411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250920411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250920411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250922211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250922211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250922211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251029491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251029491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251029491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251029492' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251029492' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251029492';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251029493' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251029493' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251029493';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251033151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251033151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251033151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251033152' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251033152' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251033152';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251034551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251034551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251034551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251034552' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251034552' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251034552';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251048401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251048401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251048401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251057231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251057231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251057231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251144131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251144131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251144131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251144132' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251144132' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251144132';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251144133' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251144133' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251144133';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251144134' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251144134' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251144134';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251144135' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251144135' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251144135';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251144136' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251144136' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251144136';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251144137' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251144137' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251144137';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251144138' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251144138' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251144138';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251144139' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251144139' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251144139';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251145101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251145101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251145101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251150221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251150221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251150221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251150222' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251150222' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251150222';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251150223' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251150223' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251150223';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251150224' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251150224' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251150224';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251150225' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251150225' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251150225';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251153121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251153121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251153121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251153122' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251153122' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251153122';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251153123' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251153123' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251153123';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251153124' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251153124' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251153124';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251153125' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251153125' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251153125';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251153126' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251153126' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251153126';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251155421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251155421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251155421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251216001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251216001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251216001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251218081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251218081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251218081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251220061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251220061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251220061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251220331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251220331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251220331';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260525-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260525-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260525-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260525-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260525-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260525-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260525-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260525-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260525-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260525-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260525-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260525-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260525-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260525-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260525-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260525-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260525-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260525-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260525-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260525-0010';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-26','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-25';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-25';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-25';
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-05-25' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-25';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-25';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-25';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-25';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202604 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
UPDATE tt_barang_saldo SET tanggal= '2026-05-26' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-25' 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-260526-0001','D','2026-05-26','16:57:30','SYSTEM','SALDO AWAL','SALDO AWAL','0','10064039000','10064039000');
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-260526-0001','D','2026-05-26','16:57:30','BCA','SALDO AWAL','SALDO AWAL','0','4457376888','4457376888');
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-260526-0001','D','2026-05-26','16:57:30','','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-260526-0001','D','2026-05-26','16:57:30','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-260526-0001','D','2026-05-26','16:57:30','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-260526-0001','D','2026-05-26','16:57:30','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2026-05-26';