INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-04','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-03';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-03';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-03';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-05-03' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-03';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-03';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-03';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-03';
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-04' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-03' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260504-0001','D','2026-05-04','08:19:12','SYSTEM','SALDO AWAL','SALDO AWAL','0','9189558000','9189558000');
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-260504-0001','D','2026-05-04','08:19: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-260504-0001','D','2026-05-04','08:19: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-260504-0001','D','2026-05-04','08:19: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-260504-0001','D','2026-05-04','08:19: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-260504-0001','D','2026-05-04','08:19:12','BCA','SALDO AWAL','SALDO AWAL','0','4399825888','4399825888');
UPDATE tp_system SET tgl_system='2026-05-04';
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 ('F226040823021','kasir','1',' MEA1 BM ','TOKO','SMBK-A','A1E-YLXD-9-T','AT COR MODEL ITALY BM 8K ','OLS 6N5N7','0.520','1','100.00','582000','0','0','15000','590000','0','81000','0','671000','RHM','T0075477','A1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YLXD-9-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-04' AND kode_barang='A1E-YLXD-9-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 ('F226040823021','2026-05-04','0.520','2026-05-04','08:23:03','PLG0079649','590000','590000','81000','671000','671000','kasir','2026-05-04 08:23:02','F22604082302');
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-04','F226040823021','2026-05-04','08:23:03','RHM','671000','81000');
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-260504-0002','D','2026-05-04','08:23:03','kasir','PENJUALAN','F226040823021','9189558000','671000','9190229000');
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 ('F226040908121','kasir','1',' MEF1 TD 52','TOKO','SMBK-F','F1E-ZDBH-29-0','GL OVAL C GELOMBANG TD 52 8K ','OL','2.720','1','100.00','3033000','0','0','15000','3046000','0','14000','0','3060000','TIN','00401600','F1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZDBH-29-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.720',berat_jual_asli=berat_jual_asli+'2.720',stock_jual='1',berat_akhir=berat_akhir-'2.720',berat_akhir_asli=berat_akhir_asli-'2.720',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='F1E-ZDBH-29-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226040908121','2026-05-04','2.720','2026-05-04','09:08:12','PLG0079650','3046000','3046000','14000','3060000','3060000','kasir','2026-05-04 09:08:12','F22604090812');
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-04','F226040908121','2026-05-04','09:08:12','TIN','3060000','14000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260504-0003','D','2026-05-04','09:08:12','kasir','PENJUALAN','F226040908121','9190229000','3060000','9193289000');
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 ('F226040929181','kasir','1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZDBH-7-T','CC MODEL PITA PASIR VAR CM 10 8K ','OL','0.770','1','100.00','862000','0','0','15000','870000','0','5000','0','875000','RTA','T0079028','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBH-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.770',berat_jual_asli=berat_jual_asli+'0.770',stock_jual='1',berat_akhir=berat_akhir-'0.770',berat_akhir_asli=berat_akhir_asli-'0.770',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='E1E-ZDBH-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 ('F226040929181','2026-05-04','0.770','2026-05-04','09:29:19','PLG0079651','870000','870000','5000','875000','875000','kasir','2026-05-04 09:29:18','F22604092918');
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-04','F226040929181','2026-05-04','09:29:19','RTA','875000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260504-0004','D','2026-05-04','09:29:19','kasir','PENJUALAN','F226040929181','9193289000','875000','9194164000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='875000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226040929181' 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 ('F226040929182','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZDBH-10-T','CC MODEL PITA PASIR VAR CM 10 8K ','OL','0.800','1','100.00','896000','0','0','15000','905000','0','5000','0','910000','RTA','T0079031','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBH-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='E1E-ZDBH-10-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 ('F226040929182','2026-05-04','0.800','2026-05-04','09:29:19','PLG0079652','905000','905000','5000','910000','910000','kasir','2026-05-04 09:29:18','F22604092918');
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-04','F226040929182','2026-05-04','09:29:19','RTA','910000','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-260504-0005','D','2026-05-04','09:29:19','kasir','PENJUALAN','F226040929182','9194164000','910000','9195074000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='910000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226040929182' 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 ('F226041030381','kasir','1',' MEB1 LG PE','TOKO','SMBK-B','B1E-ZDBC-81-T','GW TUSUK DEASY MATA LG PE 8K ','OL ','0.570','1','100.00','638000','0','0','15000','644000','0','5000','0','649000','RHM','T0078962','B1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZDBC-81-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-04' AND kode_barang='B1E-ZDBC-81-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 ('F226041030381','2026-05-04','0.570','2026-05-04','10:30:38','PLG0079653','644000','644000','5000','649000','649000','kasir','2026-05-04 10:30:38','F22604103038');
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-04','F226041030381','2026-05-04','10:30:38','RHM','649000','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-260504-0006','D','2026-05-04','10:30:38','kasir','PENJUALAN','F226041030381','9195074000','649000','9195723000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='649000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041030381' 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 ('F226041030382','kasir',' 1',' MGD1 LG ','TOKO','SMBK-D','D1G-ZEXA-25-T','LT SLOBOK KUPU ARESO VAR LG 8K ','OL ','0.250','1','100.00','290000','0','0','15000','293000','0','5000','0','298000','RHM','T0079137','D1G','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZEXA-25-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-04' AND kode_barang='D1G-ZEXA-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 ('F226041030382','2026-05-04','0.250','2026-05-04','10:30:38','PLG0079654','293000','293000','5000','298000','298000','kasir','2026-05-04 10:30:38','F22604103038');
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-04','F226041030382','2026-05-04','10:30:38','RHM','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,status_valid) VALUES ('KM-260504-0007','D','2026-05-04','10:30:38','kasir','PENJUALAN','F226041030382','9195723000','298000','9196021000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='298000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041030382' 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 ('F226041030383','kasir',' 1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YLCX-31-T','LT SLOBOK BOLA KRAWANG BG 8K ','OL ','0.330','1','100.00','383000','0','0','15000','386000','0','5000','0','391000','RHM','T0076272','D1G','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YLCX-31-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.330',berat_jual_asli=berat_jual_asli+'0.330',stock_jual='1',berat_akhir=berat_akhir-'0.330',berat_akhir_asli=berat_akhir_asli-'0.330',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='D1G-YLCX-31-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 ('F226041030383','2026-05-04','0.330','2026-05-04','10:30:38','PLG0079655','386000','386000','5000','391000','391000','kasir','2026-05-04 10:30:38','F22604103038');
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-04','F226041030383','2026-05-04','10:30:38','RHM','391000','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-260504-0008','D','2026-05-04','10:30:38','kasir','PENJUALAN','F226041030383','9196021000','391000','9196412000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='391000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041030383' 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 ('F226041030384','kasir',' 1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YKXC-28-T','LT SLOBOK BOLA KRAWANG BG 8K ','OL ','0.350','1','100.00','406000','0','0','15000','410000','0','5000','0','415000','RHM','T0074941','D1G','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YKXC-28-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='D1G-YKXC-28-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 ('F226041030384','2026-05-04','0.350','2026-05-04','10:30:38','PLG0079656','410000','410000','5000','415000','415000','kasir','2026-05-04 10:30:38','F22604103038');
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-04','F226041030384','2026-05-04','10:30:38','RHM','415000','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-260504-0009','D','2026-05-04','10:30:38','kasir','PENJUALAN','F226041030384','9196412000','415000','9196827000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='415000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041030384' 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 ('F226041030385','kasir',' 1',' MGD1 5K BG','TOKO','SMBK-D','D1G-ZCXB-36-T','LT SLOBOK BOLA KRAWANG VAR BG 8K ','OL ','0.360','1','100.00','418000','0','0','15000','421000','0','5000','0','426000','RHM','T0077670','D1G','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZCXB-36-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.360',berat_jual_asli=berat_jual_asli+'0.360',stock_jual='1',berat_akhir=berat_akhir-'0.360',berat_akhir_asli=berat_akhir_asli-'0.360',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='D1G-ZCXB-36-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226041030385','2026-05-04','0.360','2026-05-04','10:30:38','PLG0079657','421000','421000','5000','426000','426000','kasir','2026-05-04 10:30:38','F22604103038');
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-04','F226041030385','2026-05-04','10:30:38','RHM','426000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260504-0010','D','2026-05-04','10:30:38','kasir','PENJUALAN','F226041030385','9196827000','426000','9197253000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='426000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041030385' 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 ('F226041030386','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZDBB-33-T','GL MODEL FANCY VAR HW 8K ','OL ','0.740','1','100.00','829000','0','0','15000','836000','0','5000','0','841000','RHM','T0078823','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDBB-33-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.740',berat_jual_asli=berat_jual_asli+'0.740',stock_jual='1',berat_akhir=berat_akhir-'0.740',berat_akhir_asli=berat_akhir_asli-'0.740',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='F3E-ZDBB-33-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 ('F226041030386','2026-05-04','0.740','2026-05-04','10:30:38','PLG0079658','836000','836000','5000','841000','841000','kasir','2026-05-04 10:30:38','F22604103038');
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-04','F226041030386','2026-05-04','10:30:38','RHM','841000','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-260504-0011','D','2026-05-04','10:30:38','kasir','PENJUALAN','F226041030386','9197253000','841000','9198094000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='841000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041030386' 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 ('F226041030387','kasir',' 1',' MEH1 KH 42','TOKO','SMBK-H','H1E-ZDAC-36-T','KL SANTA KH 42CM 8K ','OL ','1.550','1','100.00','1736000','0','0','15000','1744000','0','8000','0','1752000','RHM','T0078655','H1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDAC-36-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='H1E-ZDAC-36-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 ('F226041030387','2026-05-04','1.550','2026-05-04','10:30:38','PLG0079659','1744000','1744000','8000','1752000','1752000','kasir','2026-05-04 10:30:38','F22604103038');
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-04','F226041030387','2026-05-04','10:30:38','RHM','1752000','8000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260504-0012','D','2026-05-04','10:30:38','kasir','PENJUALAN','F226041030387','9198094000','1752000','9199846000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1752000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041030387' 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 ('F226041032361','kasir','1',' MEE1 HTM 1','TOKO','SMBK-E','E1E-ZEXA-6-T','CC PIPA MODEL DAUN VAR HTM 18 8K ','OL ','0.450','1','100.00','504000','0','0','15000','509000','0','5000','0','514000','RHM','T0079118','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXA-6-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-04' AND kode_barang='E1E-ZEXA-6-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 ('F226041032361','2026-05-04','0.450','2026-05-04','10:32:37','PLG0079660','509000','509000','5000','514000','514000','kasir','2026-05-04 10:32:36','F22604103236');
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-04','F226041032361','2026-05-04','10:32:37','RHM','514000','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-260504-0013','D','2026-05-04','10:32:37','kasir','PENJUALAN','F226041032361','9199846000','514000','9200360000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='514000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041032361' 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 ('F226041032362','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZDBH-18-T','CC MODEL PITA PASIR VAR CM 12 8K ','OL ','0.570','1','100.00','638000','0','0','15000','644000','0','5000','0','649000','RHM','T0079039','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBH-18-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-04' AND kode_barang='E1E-ZDBH-18-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226041032362','2026-05-04','0.570','2026-05-04','10:32:37','PLG0079661','644000','644000','5000','649000','649000','kasir','2026-05-04 10:32:36','F22604103236');
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-04','F226041032362','2026-05-04','10:32:37','RHM','649000','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-260504-0014','D','2026-05-04','10:32:37','kasir','PENJUALAN','F226041032362','9200360000','649000','9201009000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='649000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041032362' 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 ('F226041032363','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZDBH-20-T','CC MODEL PITA PASIR VAR CM 12 8K ','OL ','0.570','1','100.00','638000','0','0','15000','644000','0','5000','0','649000','RHM','T0079041','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBH-20-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-04' AND kode_barang='E1E-ZDBH-20-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 ('F226041032363','2026-05-04','0.570','2026-05-04','10:32:37','PLG0079662','644000','644000','5000','649000','649000','kasir','2026-05-04 10:32:36','F22604103236');
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-04','F226041032363','2026-05-04','10:32:37','RHM','649000','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-260504-0015','D','2026-05-04','10:32:37','kasir','PENJUALAN','F226041032363','9201009000','649000','9201658000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='649000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041032363' 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 ('F226041032364','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZDBH-8-T','CC MODEL PITA PASIR VAR CM 10 8K ','OL ','0.670','1','100.00','750000','0','0','15000','757000','0','5000','0','762000','RHM','T0079029','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBH-8-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-04' AND kode_barang='E1E-ZDBH-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 ('F226041032364','2026-05-04','0.670','2026-05-04','10:32:37','PLG0079663','757000','757000','5000','762000','762000','kasir','2026-05-04 10:32:36','F22604103236');
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-04','F226041032364','2026-05-04','10:32:37','RHM','762000','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-260504-0016','D','2026-05-04','10:32:37','kasir','PENJUALAN','F226041032364','9201658000','762000','9202420000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='762000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041032364' 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 ('F226041032365','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZDBH-15-T','CC MODEL PITA PASIR VAR CM 10 8K ','OL ','0.700','1','100.00','784000','0','0','15000','791000','0','5000','0','796000','RHM','T0079036','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBH-15-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-04' AND kode_barang='E1E-ZDBH-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 ('F226041032365','2026-05-04','0.700','2026-05-04','10:32:37','PLG0079664','791000','791000','5000','796000','796000','kasir','2026-05-04 10:32:36','F22604103236');
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-04','F226041032365','2026-05-04','10:32:37','RHM','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,status_valid) VALUES ('KM-260504-0017','D','2026-05-04','10:32:37','kasir','PENJUALAN','F226041032365','9202420000','796000','9203216000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='796000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041032365' 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 ('F226041032366','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZDBH-30-T','CC MODEL PITA PASIR VAR CM 14 8K ','OL ','0.750','1','100.00','840000','0','0','15000','848000','0','5000','0','853000','RHM','T0079051','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBH-30-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='E1E-ZDBH-30-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 ('F226041032366','2026-05-04','0.750','2026-05-04','10:32:37','PLG0079665','848000','848000','5000','853000','853000','kasir','2026-05-04 10:32:36','F22604103236');
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-04','F226041032366','2026-05-04','10:32:37','RHM','853000','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-260504-0018','D','2026-05-04','10:32:37','kasir','PENJUALAN','F226041032366','9203216000','853000','9204069000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='853000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041032366' 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 ('F226041032367','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZDBH-42-T','CC MODEL PITA PASIR VAR CM 14 8K ','OL ','0.750','1','100.00','840000','0','0','15000','848000','0','5000','0','853000','RHM','T0079063','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBH-42-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='E1E-ZDBH-42-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 ('F226041032367','2026-05-04','0.750','2026-05-04','10:32:37','PLG0079666','848000','848000','5000','853000','853000','kasir','2026-05-04 10:32:36','F22604103236');
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-04','F226041032367','2026-05-04','10:32:37','RHM','853000','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-260504-0019','D','2026-05-04','10:32:37','kasir','PENJUALAN','F226041032367','9204069000','853000','9204922000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='853000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041032367' 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 ('F226041040081','kasir','1',' MEA1E X LG','TOKO','SMBK-A','A1E-ZDBX-222-0','AT X GYPSY HATI VAR ANAK LG 8K ','OL ','0.550','1','100.00','616000','0','0','15000','619000','0','5000','0','624000','RHM','00400159','A1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZDBX-222-0' 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-04' AND kode_barang='A1E-ZDBX-222-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226041040081','2026-05-04','0.550','2026-05-04','10:40:08','PLG0079667','619000','619000','5000','624000','624000','kasir','2026-05-04 10:40:08','F22604104008');
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-04','F226041040081','2026-05-04','10:40:08','RHM','624000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260504-0020','D','2026-05-04','10:40:08','kasir','PENJUALAN','F226041040081','9204922000','624000','9205546000');
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 ('F226041044361','kasir','1',' MGA1 LG ','TOKO','SMBK-A','A1G-ZEXA-16-T','AT TINDIK BABY MRICAN LG 8K ','OL ','0.310','1','100.00','360000','0','0','15000','363000','0','5000','0','368000','RHM','T0079128','A1G','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1G-ZEXA-16-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.310',berat_jual_asli=berat_jual_asli+'0.310',stock_jual='1',berat_akhir=berat_akhir-'0.310',berat_akhir_asli=berat_akhir_asli-'0.310',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='A1G-ZEXA-16-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 ('F226041044361','2026-05-04','0.310','2026-05-04','10:44:36','PLG0079668','363000','363000','5000','368000','368000','kasir','2026-05-04 10:44:36','F22604104436');
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-04','F226041044361','2026-05-04','10:44:36','RHM','368000','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-260504-0021','D','2026-05-04','10:44:36','kasir','PENJUALAN','F226041044361','9205546000','368000','9205914000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='368000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041044361' 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 ('F226041044362','kasir',' 1',' MDD1 5K LG','TOKO','SMBK-D','D1D-ZDBB-9-T','LT MODEL FINE GOLD VAR LG 8K ','OL ','1.020','1','100.00','1122000','0','0','15000','1127000','0','5000','0','1132000','RHM','T0078799','D1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1D-ZDBB-9-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='D1D-ZDBB-9-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 ('F226041044362','2026-05-04','1.020','2026-05-04','10:44:36','PLG0079669','1127000','1127000','5000','1132000','1132000','kasir','2026-05-04 10:44:36','F22604104436');
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-04','F226041044362','2026-05-04','10:44:36','RHM','1132000','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-260504-0022','D','2026-05-04','10:44:36','kasir','PENJUALAN','F226041044362','9205914000','1132000','9207046000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1132000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041044362' 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 ('F226041044363','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZDBX-30-T','GL MODEL FANCY VAR HW 8K','OL ','0.830','1','100.00','930000','0','0','15000','938000','0','5000','0','943000','RHM','T0078765','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDBX-30-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.830',berat_jual_asli=berat_jual_asli+'0.830',stock_jual='1',berat_akhir=berat_akhir-'0.830',berat_akhir_asli=berat_akhir_asli-'0.830',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='F3E-ZDBX-30-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 ('F226041044363','2026-05-04','0.830','2026-05-04','10:44:36','PLG0079670','938000','938000','5000','943000','943000','kasir','2026-05-04 10:44:36','F22604104436');
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-04','F226041044363','2026-05-04','10:44:36','RHM','943000','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-260504-0023','D','2026-05-04','10:44:36','kasir','PENJUALAN','F226041044363','9207046000','943000','9207989000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='943000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041044363' 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 ('F226041044364','kasir',' 1',' MEF3 KH ','TOKO','SMBK-F','F3E-ZCAB-19-T','GL KAKI MODEL FANCY VAR KH 8K ','OL ','2.050','1','100.00','2296000','0','0','15000','2307000','0','10000','0','2317000','RHM','T0078090','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCAB-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='F3E-ZCAB-19-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 ('F226041044364','2026-05-04','2.050','2026-05-04','10:44:36','PLG0079671','2307000','2307000','10000','2317000','2317000','kasir','2026-05-04 10:44:36','F22604104436');
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-04','F226041044364','2026-05-04','10:44:36','RHM','2317000','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-260504-0024','D','2026-05-04','10:44:36','kasir','PENJUALAN','F226041044364','9207989000','2317000','9210306000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2317000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041044364' 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 ('F226041100201','kasir','1',' MEF1 PM D4','TOKO','SMBK-F','F1E-YKBH-21-T','GL PIPA ANAK MODEL DAUN VAR PM D40 8K ','OL ','2.120','1','100.00','2374000','0','0','15000','2385000','0','11000','0','2396000','RHM','T0075253','F1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YKBH-21-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.120',berat_jual_asli=berat_jual_asli+'2.120',stock_jual='1',berat_akhir=berat_akhir-'2.120',berat_akhir_asli=berat_akhir_asli-'2.120',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='F1E-YKBH-21-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 ('F226041100201','2026-05-04','2.120','2026-05-04','11:00:21','PLG0079672','2385000','2385000','11000','2396000','2396000','kasir','2026-05-04 11:00:20','F22604110020');
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-04','F226041100201','2026-05-04','11:00:21','RHM','2396000','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-260504-0025','D','2026-05-04','11:00:21','kasir','PENJUALAN','F226041100201','9210306000','2396000','9212702000');
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 ('F226041103201','kasir','1',' MHA1 CM ','TOKO','SMBK-A','A1H-ZDXG-42-T','AT TINDIK BABY CM 8K ','OL ','0.250','1','100.00','295000','0','0','15000','298000','0','5000','0','303000','RHM','T0078582','A1H','0','0','-','0','1180000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1H-ZDXG-42-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-04' AND kode_barang='A1H-ZDXG-42-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 ('F226041103201','2026-05-04','0.250','2026-05-04','11:03:21','PLG0079673','298000','298000','5000','303000','303000','kasir','2026-05-04 11:03:20','F22604110320');
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-04','F226041103201','2026-05-04','11:03:21','RHM','303000','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-260504-0026','D','2026-05-04','11:03:21','kasir','PENJUALAN','F226041103201','9212702000','303000','9213005000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='303000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041103201' 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 ('F226041103202','kasir',' 1',' MEA1 UB ','TOKO','SMBK-A','A1E-ZDBB-44-T','AT KLIP ARESO UB 8K ','OL ','0.710','1','100.00','795000','0','0','15000','802000','0','5000','0','807000','RHM','T0078834','A1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZDBB-44-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.710',berat_jual_asli=berat_jual_asli+'0.710',stock_jual='1',berat_akhir=berat_akhir-'0.710',berat_akhir_asli=berat_akhir_asli-'0.710',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='A1E-ZDBB-44-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 ('F226041103202','2026-05-04','0.710','2026-05-04','11:03:21','PLG0079674','802000','802000','5000','807000','807000','kasir','2026-05-04 11:03:20','F22604110320');
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-04','F226041103202','2026-05-04','11:03:21','RHM','807000','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-260504-0027','D','2026-05-04','11:03:21','kasir','PENJUALAN','F226041103202','9213005000','807000','9213812000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='807000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041103202' 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 ('F226041103203','kasir',' 1',' MGD1 5K BG','TOKO','SMBK-D','D1G-ZEXB-4-T','LT SLOBOK BOLA KRAWANG VAR BG 8K ','OL ','0.380','1','100.00','441000','0','0','15000','445000','0','5000','0','450000','RHM','T0079156','D1G','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZEXB-4-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='D1G-ZEXB-4-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 ('F226041103203','2026-05-04','0.380','2026-05-04','11:03:21','PLG0079675','445000','445000','5000','450000','450000','kasir','2026-05-04 11:03:20','F22604110320');
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-04','F226041103203','2026-05-04','11:03:21','RHM','450000','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-260504-0028','D','2026-05-04','11:03:21','kasir','PENJUALAN','F226041103203','9213812000','450000','9214262000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='450000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041103203' 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 ('F226041103204','kasir',' 1',' MFH1 X BG ','TOKO','SMBK-H','H1F-ZDBI-188-0','KL X TIFF BUNGA VAR BG 8K ','OL ','2.550','1','100.00','2907000','0','0','15000','2920000','0','13000','0','2933000','RHM','00401834','H1F','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-ZDBI-188-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.550',berat_jual_asli=berat_jual_asli+'2.550',stock_jual='1',berat_akhir=berat_akhir-'2.550',berat_akhir_asli=berat_akhir_asli-'2.550',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='H1F-ZDBI-188-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 ('F226041103204','2026-05-04','2.550','2026-05-04','11:03:21','PLG0079676','2920000','2920000','13000','2933000','2933000','kasir','2026-05-04 11:03:20','F22604110320');
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-04','F226041103204','2026-05-04','11:03:21','RHM','2933000','13000');
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-260504-0029','D','2026-05-04','11:03:21','kasir','PENJUALAN','F226041103204','9214262000','2933000','9217195000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2933000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041103204' 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 ('F226041104501','kasir','1',' MGD1 5K BG','TOKO','SMBK-D','D1G-ZEXB-1-T','LT SLOBOK BOLA KRAWANG VAR BG 8K ','OL ','0.350','1','100.00','406000','0','0','15000','410000','0','5000','0','415000','RHM','T0079153','D1G','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZEXB-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='D1G-ZEXB-1-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 ('F226041104501','2026-05-04','0.350','2026-05-04','11:04:51','PLG0079677','410000','410000','5000','415000','415000','kasir','2026-05-04 11:04:50','F22604110450');
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-04','F226041104501','2026-05-04','11:04:51','RHM','415000','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-260504-0030','D','2026-05-04','11:04:51','kasir','PENJUALAN','F226041104501','9217195000','415000','9217610000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='415000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041104501' 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 ('F226041104502','kasir',' 1',' MGD1 5K BG','TOKO','SMBK-D','D1G-ZEXB-2-T','LT SLOBOK BOLA KRAWANG VAR BG 8K ','OL ','0.350','1','100.00','406000','0','0','15000','410000','0','5000','0','415000','RHM','T0079154','D1G','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZEXB-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='D1G-ZEXB-2-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 ('F226041104502','2026-05-04','0.350','2026-05-04','11:04:51','PLG0079678','410000','410000','5000','415000','415000','kasir','2026-05-04 11:04:50','F22604110450');
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-04','F226041104502','2026-05-04','11:04:51','RHM','415000','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-260504-0031','D','2026-05-04','11:04:51','kasir','PENJUALAN','F226041104502','9217610000','415000','9218025000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='415000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041104502' 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 ('F226041104503','kasir',' 1',' MGD1 5K BG','TOKO','SMBK-D','D1G-ZEXB-5-T','LT SLOBOK BOLA KRAWANG VAR BG 8K ','OL ','0.350','1','100.00','406000','0','0','15000','410000','0','5000','0','415000','RHM','T0079157','D1G','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZEXB-5-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='D1G-ZEXB-5-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 ('F226041104503','2026-05-04','0.350','2026-05-04','11:04:51','PLG0079679','410000','410000','5000','415000','415000','kasir','2026-05-04 11:04:50','F22604110450');
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-04','F226041104503','2026-05-04','11:04:51','RHM','415000','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-260504-0032','D','2026-05-04','11:04:51','kasir','PENJUALAN','F226041104503','9218025000','415000','9218440000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='415000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041104503' 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 ('F226041104504','kasir',' 1',' MGD1 5K BG','TOKO','SMBK-D','D1G-ZEXB-6-T','LT SLOBOK BOLA KRAWANG VAR BG 8K ','OL ','0.350','1','100.00','406000','0','0','15000','410000','0','5000','0','415000','RHM','T0079158','D1G','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZEXB-6-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='D1G-ZEXB-6-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 ('F226041104504','2026-05-04','0.350','2026-05-04','11:04:51','PLG0079680','410000','410000','5000','415000','415000','kasir','2026-05-04 11:04:50','F22604110450');
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-04','F226041104504','2026-05-04','11:04:51','RHM','415000','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-260504-0033','D','2026-05-04','11:04:51','kasir','PENJUALAN','F226041104504','9218440000','415000','9218855000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='415000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041104504' 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 ('F226041114411','kasir','1',' MED1 5K LG','TOKO','SMBK-D','D1E-ZDAF-38-T','LT MODEL FINE GOLD PLAT LG 8K ','OL','0.510','1','100.00','571000','0','0','15000','576000','0','5000','0','581000','RTA','T0078704','D1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZDAF-38-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-04' AND kode_barang='D1E-ZDAF-38-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 ('F226041114411','2026-05-04','0.510','2026-05-04','11:14:42','PLG0079681','576000','576000','5000','581000','581000','kasir','2026-05-04 11:14:41','F22604111441');
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-04','F226041114411','2026-05-04','11:14:42','RTA','581000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260504-0034','D','2026-05-04','11:14:42','kasir','PENJUALAN','F226041114411','9218855000','581000','9219436000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='581000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041114411' 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 ('F226041114412','kasir',' 1',' MEE1 X LG ','TOKO','SMBK-E','E1E-ZDBG-310-0','CC X MODEL DAUN SLEP LG 12 8K ','OL','0.410','1','100.00','459000','0','0','15000','463000','0','5000','0','468000','RTA','00401553','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBG-310-0' 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-04' AND kode_barang='E1E-ZDBG-310-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 ('F226041114412','2026-05-04','0.410','2026-05-04','11:14:42','PLG0079682','463000','463000','5000','468000','468000','kasir','2026-05-04 11:14:41','F22604111441');
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-04','F226041114412','2026-05-04','11:14:42','RTA','468000','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-260504-0035','D','2026-05-04','11:14:42','kasir','PENJUALAN','F226041114412','9219436000','468000','9219904000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='468000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041114412' 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 ('F226041114413','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZDBE-28-T','CC PIPA KUKU MACAN SLEP CM 12 8K ','OL','0.570','1','100.00','638000','0','0','15000','644000','0','5000','0','649000','RTA','T0078997','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBE-28-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-04' AND kode_barang='E1E-ZDBE-28-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 ('F226041114413','2026-05-04','0.570','2026-05-04','11:14:42','PLG0079683','644000','644000','5000','649000','649000','kasir','2026-05-04 11:14:41','F22604111441');
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-04','F226041114413','2026-05-04','11:14:42','RTA','649000','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-260504-0036','D','2026-05-04','11:14:42','kasir','PENJUALAN','F226041114413','9219904000','649000','9220553000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='649000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041114413' 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 ('F226041114414','kasir',' 1',' MEF3 KH ','TOKO','SMBK-F','F1E-ZDAF-18-T','GL RANTAI HOLLOW VAR KH 8K ','OL','1.560','1','100.00','1747000','0','0','15000','1755000','0','8000','0','1763000','RTA','T0078684','F1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZDAF-18-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.560',berat_jual_asli=berat_jual_asli+'1.560',stock_jual='1',berat_akhir=berat_akhir-'1.560',berat_akhir_asli=berat_akhir_asli-'1.560',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='F1E-ZDAF-18-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 ('F226041114414','2026-05-04','1.560','2026-05-04','11:14:42','PLG0079684','1755000','1755000','8000','1763000','1763000','kasir','2026-05-04 11:14:41','F22604111441');
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-04','F226041114414','2026-05-04','11:14:42','RTA','1763000','8000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260504-0037','D','2026-05-04','11:14:42','kasir','PENJUALAN','F226041114414','9220553000','1763000','9222316000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1763000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041114414' 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 ('F226041114415','kasir',' 1',' MEF3E X HW','TOKO','SMBK-F','F3E-ZDBG-137-0','GL X CASTELI ARESO VAR HW 8K ','OL','3.260','1','100.00','3651000','0','0','15000','3668000','0','16000','0','3684000','RTA','00401380','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDBG-137-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.260',berat_jual_asli=berat_jual_asli+'3.260',stock_jual='1',berat_akhir=berat_akhir-'3.260',berat_akhir_asli=berat_akhir_asli-'3.260',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='F3E-ZDBG-137-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226041114415','2026-05-04','3.260','2026-05-04','11:14:42','PLG0079685','3668000','3668000','16000','3684000','3684000','kasir','2026-05-04 11:14:41','F22604111441');
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-04','F226041114415','2026-05-04','11:14:42','RTA','3684000','16000');
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-260504-0038','D','2026-05-04','11:14:42','kasir','PENJUALAN','F226041114415','9222316000','3684000','9226000000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3684000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041114415' 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 ('F226041115361','kasir','1',' MEB1 5K BW','TOKO','SMBK-B','B1E-ZDCX-23-T','GW TUSUK KUPU PASIR BW 8K ','OL','0.460','1','100.00','515000','0','0','15000','520000','0','5000','0','525000','RTA','T0079092','B1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZDCX-23-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-04' AND kode_barang='B1E-ZDCX-23-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 ('F226041115361','2026-05-04','0.460','2026-05-04','11:15:36','PLG0079686','520000','520000','5000','525000','525000','kasir','2026-05-04 11:15:36','F22604111536');
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-04','F226041115361','2026-05-04','11:15:36','RTA','525000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260504-0039','D','2026-05-04','11:15:36','kasir','PENJUALAN','F226041115361','9226000000','525000','9226525000');
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 ('F226041116591','kasir','1',' MEE1 HTM 1','TOKO','SMBK-E','E1E-ZEXA-7-T','CC PIPA MODEL DAUN MATA HTM 12 8K ','OL','0.680','1','100.00','762000','0','0','15000','768000','0','5000','0','773000','RTA','T0079119','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXA-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.680',berat_jual_asli=berat_jual_asli+'0.680',stock_jual='1',berat_akhir=berat_akhir-'0.680',berat_akhir_asli=berat_akhir_asli-'0.680',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='E1E-ZEXA-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 ('F226041116591','2026-05-04','0.680','2026-05-04','11:16:59','PLG0079687','768000','768000','5000','773000','773000','kasir','2026-05-04 11:16:59','F22604111659');
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-04','F226041116591','2026-05-04','11:16:59','RTA','773000','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-260504-0040','D','2026-05-04','11:16:59','kasir','PENJUALAN','F226041116591','9226525000','773000','9227298000');
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 ('F226041117311','kasir','1',' MEE1 CM 14','TOKO','SMBK-E','E1E-ZDXG-4-T','CC MODEL DAUN SLEP VAR CM 14 8K ','OL','0.770','1','100.00','862000','0','0','15000','870000','0','5000','0','875000','RTA','T0078544','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDXG-4-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.770',berat_jual_asli=berat_jual_asli+'0.770',stock_jual='1',berat_akhir=berat_akhir-'0.770',berat_akhir_asli=berat_akhir_asli-'0.770',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='E1E-ZDXG-4-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 ('F226041117311','2026-05-04','0.770','2026-05-04','11:17:32','PLG0079688','870000','870000','5000','875000','875000','kasir','2026-05-04 11:17:31','F22604111731');
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-04','F226041117311','2026-05-04','11:17:32','RTA','875000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260504-0041','D','2026-05-04','11:17:32','kasir','PENJUALAN','F226041117311','9227298000','875000','9228173000');
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 ('F226041125481','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E1D-ZDBI-131-0','CC X MODEL MATA CM 18 8K ','','0.950','1','100.00','1045000','0','0','15000','1040000','0','0','0','1040000','RTA','00401777','E1D','0','0','-','1','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDBI-131-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='E1D-ZDBI-131-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 ('F226041125481','2026-05-04','0.950','2026-05-04','11:25:48','PLG0079689','1040000','1040000','0','1040000','1040000','kasir','2026-05-04 11:25:48','F22604112548');
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-04','F226041125481','2026-05-04','11:25:48','RTA','1040000','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-260504-0042','D','2026-05-04','11:25:48','kasir','PENJUALAN','F226041125481','9228173000','1040000','9229213000');
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 ('F226041140191','kasir','1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZDBH-3-T','CC MODEL PITA PASIR VAR CM 10 8K ','','0.720','1','100.00','806000','0','0','15000','803000','0','5000','0','808000','RHM','T0079024','E1E','0','0','-','1','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBH-3-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-04' AND kode_barang='E1E-ZDBH-3-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 ('F226041140191','2026-05-04','0.720','2026-05-04','11:40:20','PLG0079690','803000','803000','5000','808000','808000','kasir','2026-05-04 11:40:19','F22604114019');
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-04','F226041140191','2026-05-04','11:40:20','RHM','808000','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-260504-0043','D','2026-05-04','11:40:20','kasir','PENJUALAN','F226041140191','9229213000','808000','9230021000');
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 ('F226041143241','kasir','1',' MDE1 CM 12','TOKO','SMBK-E','E1D-ZAXH-68-T','CC POLOS CM 12 8K ','OL','1.010','1','100.00','1111000','0','0','15000','1116000','0','5000','0','1121000','RTA','T0076391','E1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZAXH-68-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='E1D-ZAXH-68-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 ('F226041143241','2026-05-04','1.010','2026-05-04','11:43:24','PLG0079691','1116000','1116000','5000','1121000','1121000','kasir','2026-05-04 11:43:24','F22604114324');
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-04','F226041143241','2026-05-04','11:43:24','RTA','1121000','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-260504-0044','D','2026-05-04','11:43:24','kasir','PENJUALAN','F226041143241','9230021000','1121000','9231142000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1121000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041143241' 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 ('F226041143242','kasir',' 1',' MDE1 CM 14','TOKO','SMBK-E','E1D-ZDBC-35-T','CC MODEL C CM 14 8K ','OL','1.060','1','100.00','1166000','0','0','15000','1172000','0','5000','0','1177000','RTA','T0078916','E1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDBC-35-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='E1D-ZDBC-35-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226041143242','2026-05-04','1.060','2026-05-04','11:43:24','PLG0079692','1172000','1172000','5000','1177000','1177000','kasir','2026-05-04 11:43:24','F22604114324');
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-04','F226041143242','2026-05-04','11:43:24','RTA','1177000','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-260504-0045','D','2026-05-04','11:43:24','kasir','PENJUALAN','F226041143242','9231142000','1177000','9232319000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1177000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041143242' 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 ('F226041146201','kasir','1',' MDA1 LG ','TOKO','SMBK-A','A1D-ZCXG-17-T','AT KLIP MODEL DAUN MATA VAR LG 8K ','OL ','1.000','1','100.00','1100000','0','0','15000','1100000','0','5000','0','1105000','RHM','T0077888','A1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZCXG-17-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-04' AND kode_barang='A1D-ZCXG-17-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 ('F226041146201','2026-05-04','1.000','2026-05-04','11:46:21','PLG0079693','1100000','1100000','5000','1105000','1105000','kasir','2026-05-04 11:46:20','F22604114620');
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-04','F226041146201','2026-05-04','11:46:21','RHM','1105000','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-260504-0046','D','2026-05-04','11:46:21','kasir','PENJUALAN','F226041146201','9232319000','1105000','9233424000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1105000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041146201' 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 ('F226041146202','kasir',' 1',' MDA1 LG ','TOKO','SMBK-A','A1D-ZEXA-14-T','AT JERSY SLEP LG 8K ','OL ','1.020','1','100.00','1122000','0','0','15000','1122000','0','5000','0','1127000','RHM','T0079126','A1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZEXA-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='A1D-ZEXA-14-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226041146202','2026-05-04','1.020','2026-05-04','11:46:21','PLG0079694','1122000','1122000','5000','1127000','1127000','kasir','2026-05-04 11:46:20','F22604114620');
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-04','F226041146202','2026-05-04','11:46:21','RHM','1127000','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-260504-0047','D','2026-05-04','11:46:21','kasir','PENJUALAN','F226041146202','9233424000','1127000','9234551000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1127000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041146202' 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 ('F226041146203','kasir',' 1',' MDA1 UB ','TOKO','SMBK-A','A1D-ZEXA-10-T','AT KLIP MODEL C UB 8K ','OL ','1.080','1','100.00','1188000','0','0','15000','1188000','0','5000','0','1193000','RHM','T0079122','A1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZEXA-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='A1D-ZEXA-10-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 ('F226041146203','2026-05-04','1.080','2026-05-04','11:46:21','PLG0079695','1188000','1188000','5000','1193000','1193000','kasir','2026-05-04 11:46:20','F22604114620');
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-04','F226041146203','2026-05-04','11:46:21','RHM','1193000','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-260504-0048','D','2026-05-04','11:46:21','kasir','PENJUALAN','F226041146203','9234551000','1193000','9235744000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1193000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041146203' 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 ('F226041148481','kasir','1',' MEF3E X UB','TOKO','SMBK-F','F3E-ZDBI-164-0','GL X GHENIA SLEP UB 8K ','OL ','0.470','1','100.00','526000','0','0','15000','529000','0','5000','0','534000','RHM','00401810','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDBI-164-0' 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-04' AND kode_barang='F3E-ZDBI-164-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226041148481','2026-05-04','0.470','2026-05-04','11:48:48','PLG0079696','529000','529000','5000','534000','534000','kasir','2026-05-04 11:48:48','F22604114848');
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-04','F226041148481','2026-05-04','11:48:48','RHM','534000','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-260504-0049','D','2026-05-04','11:48:48','kasir','PENJUALAN','F226041148481','9235744000','534000','9236278000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='534000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041148481' 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 ('F226041148482','kasir',' 1',' MEF3E X UB','TOKO','SMBK-F','F3E-ZDBI-163-0','GL X GHENIA SLEP UB 8K ','OL ','0.480','1','100.00','538000','0','0','15000','540000','0','5000','0','545000','RHM','00401809','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDBI-163-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='F3E-ZDBI-163-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226041148482','2026-05-04','0.480','2026-05-04','11:48:48','PLG0079697','540000','540000','5000','545000','545000','kasir','2026-05-04 11:48:48','F22604114848');
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-04','F226041148482','2026-05-04','11:48:48','RHM','545000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260504-0050','D','2026-05-04','11:48:48','kasir','PENJUALAN','F226041148482','9236278000','545000','9236823000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='545000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041148482' 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 ('F226041148483','kasir',' 1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZDCX-11-T','GL KOREA UB 8K ','OL ','0.860','1','100.00','963000','0','0','15000','968000','0','5000','0','973000','RHM','T0079080','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDCX-11-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.860',berat_jual_asli=berat_jual_asli+'0.860',stock_jual='1',berat_akhir=berat_akhir-'0.860',berat_akhir_asli=berat_akhir_asli-'0.860',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='F3E-ZDCX-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 ('F226041148483','2026-05-04','0.860','2026-05-04','11:48:48','PLG0079698','968000','968000','5000','973000','973000','kasir','2026-05-04 11:48:48','F22604114848');
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-04','F226041148483','2026-05-04','11:48:48','RHM','973000','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-260504-0051','D','2026-05-04','11:48:48','kasir','PENJUALAN','F226041148483','9236823000','973000','9237796000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='973000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041148483' 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 ('F226041148484','kasir',' 1',' MEF3 8K HW','TOKO','SMBK-F','F3E-YLAH-19-T','GL SANTA ARESO PASIR VAR HW 8K ','OL ','1.440','1','100.00','1613000','0','0','15000','1613000','0','7000','0','1620000','RHM','T0075948','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLAH-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.440',berat_jual_asli=berat_jual_asli+'1.440',stock_jual='1',berat_akhir=berat_akhir-'1.440',berat_akhir_asli=berat_akhir_asli-'1.440',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='F3E-YLAH-19-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 ('F226041148484','2026-05-04','1.440','2026-05-04','11:48:48','PLG0079699','1613000','1613000','7000','1620000','1620000','kasir','2026-05-04 11:48:48','F22604114848');
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-04','F226041148484','2026-05-04','11:48:48','RHM','1620000','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-260504-0052','D','2026-05-04','11:48:48','kasir','PENJUALAN','F226041148484','9237796000','1620000','9239416000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1620000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041148484' 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 ('F226041148485','kasir',' 1',' MEF3E X YT','TOKO','SMBK-F','F3E-ZEXB-74-0','GL X TIFF SPECTRA VAR YT 8K ','OL ','1.800','1','100.00','2007000','0','0','15000','2016000','0','9000','0','2025000','RHM','00402090','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXB-74-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.800',berat_jual_asli=berat_jual_asli+'1.800',stock_jual='1',berat_akhir=berat_akhir-'1.800',berat_akhir_asli=berat_akhir_asli-'1.800',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='F3E-ZEXB-74-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226041148485','2026-05-04','1.800','2026-05-04','11:48:48','PLG0079700','2016000','2016000','9000','2025000','2025000','kasir','2026-05-04 11:48:48','F22604114848');
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-04','F226041148485','2026-05-04','11:48:48','RHM','2025000','9000');
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-260504-0053','D','2026-05-04','11:48:48','kasir','PENJUALAN','F226041148485','9239416000','2025000','9241441000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2025000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041148485' 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 ('F226041148486','kasir',' 1',' MEF3 10K U','TOKO','SMBK-F','F3E-ZDBH-2-T','GL RANTAI HOLLOW P4 SLEP UB 8K ','OL ','2.010','1','100.00','2251000','0','0','15000','2251000','0','10000','0','2261000','RHM','T0079023','F3E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDBH-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.010',berat_jual_asli=berat_jual_asli+'2.010',stock_jual='1',berat_akhir=berat_akhir-'2.010',berat_akhir_asli=berat_akhir_asli-'2.010',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='F3E-ZDBH-2-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226041148486','2026-05-04','2.010','2026-05-04','11:48:48','PLG0079701','2251000','2251000','10000','2261000','2261000','kasir','2026-05-04 11:48:48','F22604114848');
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-04','F226041148486','2026-05-04','11:48:48','RHM','2261000','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-260504-0054','D','2026-05-04','11:48:48','kasir','PENJUALAN','F226041148486','9241441000','2261000','9243702000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2261000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041148486' 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 ('F226041148487','kasir',' 1',' MEF1 X UB ','TOKO','SMBK-F','F1E-ZDBG-86-0','GL X OVAL PAKU MATA UB 58 8K ','OL ','2.440','1','100.00','2733000','0','0','15000','2733000','0','12000','0','2745000','RHM','00401329','F1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZDBG-86-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.440',berat_jual_asli=berat_jual_asli+'2.440',stock_jual='1',berat_akhir=berat_akhir-'2.440',berat_akhir_asli=berat_akhir_asli-'2.440',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='F1E-ZDBG-86-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226041148487','2026-05-04','2.440','2026-05-04','11:48:48','PLG0079702','2733000','2733000','12000','2745000','2745000','kasir','2026-05-04 11:48:48','F22604114848');
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-04','F226041148487','2026-05-04','11:48:48','RHM','2745000','12000');
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-260504-0055','D','2026-05-04','11:48:48','kasir','PENJUALAN','F226041148487','9243702000','2745000','9246447000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2745000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041148487' 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 ('F226041203421','kasir','1',' MEH1 UB 40','TOKO','SMBK-H','H1E-ZCXE-143-T','KL MILANO UB 40CM 8K ','OL','2.150','1','100.00','2408000','0','0','15000','2408000','0','11000','0','2419000','NS','T0077819','H1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZCXE-143-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-04' AND kode_barang='H1E-ZCXE-143-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 ('F226041203421','2026-05-04','2.150','2026-05-04','12:03:42','PLG0079703','2408000','2408000','11000','2419000','2419000','kasir','2026-05-04 12:03:42','F22604120342');
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-04','F226041203421','2026-05-04','12:03:42','NS','2419000','11000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260504-0056','D','2026-05-04','12:03:42','kasir','PENJUALAN','F226041203421','9246447000','2419000','9248866000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2419000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041203421' 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 ('F226041203422','kasir',' 1',' MED1 LG ','TOKO','SMBK-D','D1E-ZDBX-14-T','LT MODEL HATI POLOS LG 8K ','OL','0.530','1','100.00','594000','0','0','15000','596000','0','5000','0','601000','NS','T0078749','D1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZDBX-14-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-04' AND kode_barang='D1E-ZDBX-14-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 ('F226041203422','2026-05-04','0.530','2026-05-04','12:03:42','PLG0079704','596000','596000','5000','601000','601000','kasir','2026-05-04 12:03:42','F22604120342');
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-04','F226041203422','2026-05-04','12:03:42','NS','601000','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-260504-0057','D','2026-05-04','12:03:42','kasir','PENJUALAN','F226041203422','9248866000','601000','9249467000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='601000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041203422' 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 ('F226041204011','kasir','1',' MED1 5K LG','TOKO','SMBK-D','D1E-ZDBB-5-T','LT MODEL APEL CAT VAR LG 8K ','OL','0.510','1','100.00','571000','0','0','15000','576000','0','5000','0','581000','NS','T0078795','D1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZDBB-5-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-04' AND kode_barang='D1E-ZDBB-5-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 ('F226041204011','2026-05-04','0.510','2026-05-04','12:04:02','PLG0079705','576000','576000','5000','581000','581000','kasir','2026-05-04 12:04:01','F22604120401');
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-04','F226041204011','2026-05-04','12:04:02','NS','581000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260504-0058','D','2026-05-04','12:04:02','kasir','PENJUALAN','F226041204011','9249467000','581000','9250048000');
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 ('F226041220211','kasir','1',' MDE2X 10K ','TOKO','SMBK-E','E2D-ZDBA-12-T','CC X WEDDING MATA CM 20 8K ','','1.960','1','100.00','2156000','0','0','15000','2146000','0','10000','0','2156000','TJ','T0078783','E2D','0','0','-','1','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZDBA-12-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-04' AND kode_barang='E2D-ZDBA-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 ('F226041220211','2026-05-04','1.960','2026-05-04','12:20:21','PLG0079706','2146000','2146000','10000','2156000','2156000','kasir','2026-05-04 12:20:21','F22604122021');
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-04','F226041220211','2026-05-04','12:20:21','TJ','2156000','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-260504-0059','D','2026-05-04','12:20:21','kasir','PENJUALAN','F226041220211','9250048000','2156000','9252204000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2156000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041220211' 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 ('F226041220212','kasir',' 1',' MDE2X 10K ','TOKO','SMBK-E','E2D-ZDBA-9-T','CC X WEDDING MATA CM 15 8K ','','1.530','1','100.00','1683000','0','0','15000','1675000','0','10000','0','1685000','TJ','T0078780','E2D','0','0','-','1','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZDBA-9-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.530',berat_jual_asli=berat_jual_asli+'1.530',stock_jual='1',berat_akhir=berat_akhir-'1.530',berat_akhir_asli=berat_akhir_asli-'1.530',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='E2D-ZDBA-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 ('F226041220212','2026-05-04','1.530','2026-05-04','12:20:21','PLG0079707','1675000','1675000','10000','1685000','1685000','kasir','2026-05-04 12:20:21','F22604122021');
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-04','F226041220212','2026-05-04','12:20:21','TJ','1685000','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-260504-0060','D','2026-05-04','12:20:21','kasir','PENJUALAN','F226041220212','9252204000','1685000','9253889000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1685000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041220212' 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 ('F226041223051','kasir','1',' MHB1 CM ','TOKO','SMBK-B','B1H-ZDBE-14-T','GW TUSUK DAISY MATA CM 8K ','OL ','0.270','1','100.00','319000','0','0','15000','321000','0','5000','0','326000','RHM','T0078983','B1H','0','0','-','0','1180000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-ZDBE-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.270',berat_jual_asli=berat_jual_asli+'0.270',stock_jual='1',berat_akhir=berat_akhir-'0.270',berat_akhir_asli=berat_akhir_asli-'0.270',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='B1H-ZDBE-14-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 ('F226041223051','2026-05-04','0.270','2026-05-04','12:23:06','PLG0079708','321000','321000','5000','326000','326000','kasir','2026-05-04 12:23:05','F22604122305');
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-04','F226041223051','2026-05-04','12:23:06','RHM','326000','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-260504-0061','D','2026-05-04','12:23:06','kasir','PENJUALAN','F226041223051','9253889000','326000','9254215000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='326000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041223051' 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 ('F226041223052','kasir',' 1',' MDD1 5K LG','TOKO','SMBK-D','D1D-ZDBB-8-T','LT MODEL FINE GOLD VAR LG 8K ','OL ','1.000','1','100.00','1100000','0','0','15000','1105000','0','5000','0','1110000','RHM','T0078798','D1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1D-ZDBB-8-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-04' AND kode_barang='D1D-ZDBB-8-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226041223052','2026-05-04','1.000','2026-05-04','12:23:06','PLG0079709','1105000','1105000','5000','1110000','1110000','kasir','2026-05-04 12:23:05','F22604122305');
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-04','F226041223052','2026-05-04','12:23:06','RHM','1110000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260504-0062','D','2026-05-04','12:23:06','kasir','PENJUALAN','F226041223052','9254215000','1110000','9255325000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1110000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041223052' 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 ('F226041223053','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZDBH-29-T','CC MODEL PITA PASIR VAR CM 12 8K ','OL ','0.560','1','100.00','627000','0','0','15000','633000','0','5000','0','638000','RHM','T0079050','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBH-29-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='E1E-ZDBH-29-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 ('F226041223053','2026-05-04','0.560','2026-05-04','12:23:06','PLG0079710','633000','633000','5000','638000','638000','kasir','2026-05-04 12:23:05','F22604122305');
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-04','F226041223053','2026-05-04','12:23:06','RHM','638000','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-260504-0063','D','2026-05-04','12:23:06','kasir','PENJUALAN','F226041223053','9255325000','638000','9255963000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='638000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041223053' 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 ('F226041223054','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZDBH-21-T','CC MODEL PITA PASIR VAR CM 12 8K ','OL ','0.580','1','100.00','650000','0','0','15000','656000','0','5000','0','661000','RHM','T0079042','E1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBH-21-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-04' AND kode_barang='E1E-ZDBH-21-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226041223054','2026-05-04','0.580','2026-05-04','12:23:06','PLG0079711','656000','656000','5000','661000','661000','kasir','2026-05-04 12:23:05','F22604122305');
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-04','F226041223054','2026-05-04','12:23:06','RHM','661000','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-260504-0064','D','2026-05-04','12:23:06','kasir','PENJUALAN','F226041223054','9255963000','661000','9256624000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='661000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041223054' 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 ('F226041231401','kasir','1',' MEE2 X CM ','TOKO','SMBK-E','E2E-ZDBG-308-0','CC X LISTERING MATA CM 14 8K ','OL','0.730','1','100.00','818000','0','0','15000','821000','0','5000','0','826000','RTA','00401551','E2E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZDBG-308-0' 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-04' AND kode_barang='E2E-ZDBG-308-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 ('F226041231401','2026-05-04','0.730','2026-05-04','12:31:41','PLG0079712','821000','821000','5000','826000','826000','kasir','2026-05-04 12:31:40','F22604123140');
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-04','F226041231401','2026-05-04','12:31:41','RTA','826000','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-260504-0065','D','2026-05-04','12:31:41','kasir','PENJUALAN','F226041231401','9256624000','826000','9257450000');
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 ('F226040156521','kasir','1',' MEF1 TD D6','TOKO','SMBK-F','F1E-ZCAB-8-T','GL OVAL MODEL C TD D60 8K ','OL','5.040','1','100.00','5645000','0','0','15000','5645000','0','25000','0','5670000','NS','T0078079','F1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZCAB-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.040',berat_jual_asli=berat_jual_asli+'5.040',stock_jual='1',berat_akhir=berat_akhir-'5.040',berat_akhir_asli=berat_akhir_asli-'5.040',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='F1E-ZCAB-8-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 ('F226040156521','2026-05-04','5.040','2026-05-04','13:56:52','PLG0079713','5645000','5645000','25000','5670000','5670000','kasir','2026-05-04 13:56:52','F22604015652');
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-04','F226040156521','2026-05-04','13:56:52','NS','5670000','25000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260504-0066','D','2026-05-04','13:56:52','kasir','PENJUALAN','F226040156521','9257450000','5670000','9263120000');
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-00005319','X-00005319','GL RANTAI HOLLOW P3 SLEP LT 17K','GR','---','F3TE','BELI','BELI001','3312000','2026-05-04','2.060','1','kasir','2026-05-04 14:06:06');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3TE','X-00005319','X-00005319');
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-260504-0001','F226071246501','NS','1','BELI','BELI001','F3TE', 'X-00005319', 'GL RANTAI HOLLOW P3 SLEP LT 17K','2.060','2.060','100.00','4141000','3312000','1607767','2030000','1','3312000','3312000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.060',berat_beli_asli=berat_beli_asli+'2.060',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.060',berat_akhir_asli=berat_akhir_asli+'2.060',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-04' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3TE' 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-260504-0001','2026-05-04','2026-05-04','14:06:06','NS','---','2.060','3312000','3312000','3312000','3312000','3312000','kasir','2026-05-04 14:06:06','FB-260504-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260504-0001','LILIK','SETUTUO JIMBE JENANGAN','','','085815058260','kasir','2026-05-04 14:06:06');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-04' 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-260504-0067','K','2026-05-04','14:06:06','kasir','PEMBELIAN UMUM','FB-260504-0001','9263120000','3312000','9259808000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040156521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040156521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040156521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040823021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040823021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040823021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040908121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040908121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040908121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040929181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040929181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040929181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040929182' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040929182' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040929182';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041030381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041030381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041030381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041030382' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041030382' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041030382';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041030383' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041030383' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041030383';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041030384' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041030384' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041030384';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041030385' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041030385' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041030385';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041030386' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041030386' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041030386';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041030387' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041030387' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041030387';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041032361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041032361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041032361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041032362' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041032362' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041032362';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041032363' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041032363' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041032363';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041032364' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041032364' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041032364';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041032365' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041032365' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041032365';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041032366' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041032366' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041032366';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041032367' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041032367' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041032367';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041040081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041040081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041040081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041044361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041044361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041044361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041044362' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041044362' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041044362';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041044363' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041044363' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041044363';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041044364' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041044364' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041044364';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041100201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041100201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041100201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041103201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041103201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041103201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041103202' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041103202' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041103202';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041103203' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041103203' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041103203';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041103204' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041103204' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041103204';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041104501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041104501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041104501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041104502' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041104502' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041104502';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041104503' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041104503' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041104503';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041104504' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041104504' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041104504';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041114411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041114411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041114411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041114412' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041114412' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041114412';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041114413' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041114413' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041114413';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041114414' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041114414' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041114414';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041114415' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041114415' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041114415';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041115361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041115361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041115361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041116591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041116591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041116591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041117311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041117311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041117311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041125481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041125481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041125481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041140191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041140191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041140191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041143241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041143241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041143241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041143242' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041143242' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041143242';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041146201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041146201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041146201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041146202' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041146202' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041146202';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041146203' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041146203' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041146203';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041148481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041148481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041148481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041148482' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041148482' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041148482';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041148483' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041148483' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041148483';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041148484' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041148484' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041148484';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041148485' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041148485' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041148485';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041148486' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041148486' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041148486';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041148487' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041148487' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041148487';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041203421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041203421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041203421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041203422' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041203422' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041203422';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041204011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041204011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041204011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041220211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041220211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041220211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041220212' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041220212' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041220212';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041223051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041223051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041223051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041223052' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041223052' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041223052';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041223053' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041223053' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041223053';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041223054' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041223054' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041223054';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041231401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041231401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041231401';
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-00005320','X-00005320','KL TRIXIE SERUT MODEL KUPU MATA UB 8K','GR','---','H1E','BELI','BELI001','1717000','2026-05-04','1.750','1','kasir','2026-05-04 15:01:11');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00005320','X-00005320');
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-260504-0002','F225211157413','NS','1','BELI','BELI001','H1E', 'X-00005320', 'KL TRIXIE SERUT MODEL KUPU MATA UB 8K','1.750','1.750','100.00','1908000','1717000','981143','1115000','1','1717000','1717000','CUCI');
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-04' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' 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-260504-0002','2026-05-04','2026-05-04','15:01:10','NS','---','1.750','1717000','1717000','1717000','1717000','1717000','kasir','2026-05-04 15:01:11','FB-260504-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260504-0002','MEGA','JENANGAN. SAMPUNG','','','089603111493','kasir','2026-05-04 15:01:11');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-04' 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-260504-0068','K','2026-05-04','15:01:10','kasir','PEMBELIAN UMUM','FB-260504-0002','9259808000','1717000','9258091000');
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-00005321','X-00005321','GL TRIXIE SERUT BUNGA CLOVER VAR YT 8K','GR','---','F3E','BELI','BELI001','1088000','2026-05-04','1.110','1','kasir','2026-05-04 15:01:11');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00005321','X-00005321');
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-260504-0003','F225211157412','NS','2','BELI','BELI001','F3E', 'X-00005321', 'GL TRIXIE SERUT BUNGA CLOVER VAR YT 8K','1.110','1.110','100.00','1210000','1088000','980180','1115000','1','1088000','1088000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.110',berat_beli_asli=berat_beli_asli+'1.110',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.110',berat_akhir_asli=berat_akhir_asli+'1.110',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-04' 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-260504-0003','2026-05-04','2026-05-04','15:01:10','NS','---','1.110','1088000','1088000','1088000','1088000','1088000','kasir','2026-05-04 15:01:11','FB-260504-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260504-0003','MEGA','JENANGAN. SAMPUNG','','','089603111493','kasir','2026-05-04 15:01:11');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-04' 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-260504-0069','K','2026-05-04','15:01:10','kasir','PEMBELIAN UMUM','FB-260504-0003','9258091000','1088000','9257003000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260504-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260504-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260504-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260504-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260504-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260504-0003';
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 ('F226040313161','kasir','1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZDCX-14-T','GL GENIA UB 8K ','','1.150','1','100.00','1288000','0','0','15000','1282000','0','0','0','1282000','RTA','T0079083','F3E','0','0','-','1','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDCX-14-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-04' AND kode_barang='F3E-ZDCX-14-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226040313161','2026-05-04','1.150','2026-05-04','15:13:17','PLG0079714','1282000','1282000','0','1282000','1282000','kasir','2026-05-04 15:13:16','F22604031316');
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-04','F226040313161','2026-05-04','15:13:17','RTA','1282000','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-260504-0070','D','2026-05-04','15:13:17','kasir','PENJUALAN','F226040313161','9257003000','1282000','9258285000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040313161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040313161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040313161';
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 ('F226040343341','kasir','1',' MGD1 LG ','TOKO','SMBK-D','D1G-ZEXA-24-T','LT SLOBOK KUPU ARESO VAR LG 8K ','','0.300','1','100.00','348000','0','0','15000','347000','0','0','0','347000','NS','T0079136','D1G','0','0','-','1','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-05-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZEXA-24-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.300',berat_jual_asli=berat_jual_asli+'0.300',stock_jual='1',berat_akhir=berat_akhir-'0.300',berat_akhir_asli=berat_akhir_asli-'0.300',stock_akhir='0' WHERE tanggal='2026-05-04' AND kode_barang='D1G-ZEXA-24-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226040343341','2026-05-04','0.300','2026-05-04','15:43:35','PLG0079715','347000','347000','0','347000','347000','kasir','2026-05-04 15:43:34','F22604034334');
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-04','F226040343341','2026-05-04','15:43:35','NS','347000','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-260504-0071','D','2026-05-04','15:43:35','kasir','PENJUALAN','F226040343341','9258285000','347000','9258632000');
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-00005322','X-00005322','CC PIPA MODEL DAUN VAR HTM 18 8K','GR','---','E1E','BELI','BELI001','460000','2026-05-04','0.450','1','kasir','2026-05-04 15:51:14');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00005322','X-00005322');
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-260504-0004','F226020337491','NS','1','BELI','BELI001','E1E', 'X-00005322', 'CC PIPA MODEL DAUN VAR HTM 18 8K','0.450','0.450','100.00','502000','460000','1022222','1115000','1','460000','460000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.450',berat_beli_asli=berat_beli_asli+'0.450',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.450',berat_akhir_asli=berat_akhir_asli+'0.450',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-04' 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-260504-0004','2026-05-04','2026-05-04','15:51:14','NS','---','0.450','460000','460000','460000','460000','460000','kasir','2026-05-04 15:51:14','FB-260504-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260504-0004','ANA','SIMAN','','','','kasir','2026-05-04 15:51:14');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-04' 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-260504-0072','K','2026-05-04','15:51:14','kasir','PEMBELIAN UMUM','FB-260504-0004','9258632000','460000','9258172000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040343341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040343341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040343341';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260504-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260504-0004';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-05','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-04';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-04';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-04';
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-04' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-04';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-04';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-04';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-04';
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-05' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-04' 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-260505-0001','D','2026-05-05','16:16:14','SYSTEM','SALDO AWAL','SALDO AWAL','0','9258172000','9258172000');
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-260505-0001','D','2026-05-05','16:16:14','BCA','SALDO AWAL','SALDO AWAL','0','4399825888','4399825888');
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-260505-0001','D','2026-05-05','16:16:14','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-260505-0001','D','2026-05-05','16:16:14','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-260505-0001','D','2026-05-05','16:16:14','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-260505-0001','D','2026-05-05','16:16:14','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2026-05-05';