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 ('F226140850361','kasir','1',' MEF3 UB ','TOKO','SMBK-F','F3E-YLBC-17-T','GL MODEL GUCCI VAR UB 8K ','OL','1.330','1','100.00','1523000','0','0','15000','1536000','0','7000','0','1543000','NS','T0076079','F3E','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLBC-17-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.330',berat_jual_asli=berat_jual_asli+'1.330',stock_jual='1',berat_akhir=berat_akhir-'1.330',berat_akhir_asli=berat_akhir_asli-'1.330',stock_akhir='0' WHERE tanggal='2026-01-14' AND kode_barang='F3E-YLBC-17-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 ('F226140850361','2026-01-14','1.330','2026-01-14','08:50:37','PLG0076471','1536000','1536000','7000','1543000','1543000','kasir','2026-01-14 08:50:36','F22614085036');
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-01-14','F226140850361','2026-01-14','08:50:37','NS','1543000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260114-0002','D','2026-01-14','08:50:37','kasir','PENJUALAN','F226140850361','4878380000','1543000','4879923000');
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 ('F226140850591','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-YLXH-169-0','CC X MODEL MATA CM 14 8K ','OL','0.820','1','100.00','922000','0','0','15000','935000','0','5000','0','940000','NS','00380291','E2D','0','0','-','0','1125000');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YLXH-169-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.820',berat_jual_asli=berat_jual_asli+'0.820',stock_jual='1',berat_akhir=berat_akhir-'0.820',berat_akhir_asli=berat_akhir_asli-'0.820',stock_akhir='0' WHERE tanggal='2026-01-14' AND kode_barang='E2D-YLXH-169-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 ('F226140850591','2026-01-14','0.820','2026-01-14','08:50:59','PLG0076472','935000','935000','5000','940000','940000','kasir','2026-01-14 08:50:59','F22614085059');
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-01-14','F226140850591','2026-01-14','08:50:59','NS','940000','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-260114-0003','D','2026-01-14','08:50:59','kasir','PENJUALAN','F226140850591','4879923000','940000','4880863000');
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 ('F226140851411','kasir','1',' MEB1 5K CM','TOKO','SMBK-B','B1E-ZAXI-29-T','GW TUSUK BUNGA PASIR 3C CM PE 8K ','OL','0.720','1','100.00','824000','0','0','15000','832000','0','5000','0','837000','NS','T0076504','B1E','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZAXI-29-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-01-14' AND kode_barang='B1E-ZAXI-29-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 ('F226140851411','2026-01-14','0.720','2026-01-14','08:51:42','PLG0076473','832000','832000','5000','837000','837000','kasir','2026-01-14 08:51:41','F22614085141');
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-01-14','F226140851411','2026-01-14','08:51:42','NS','837000','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-260114-0004','D','2026-01-14','08:51:42','kasir','PENJUALAN','F226140851411','4880863000','837000','4881700000');
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 ('F226140852501','kasir','1',' MEF3E UB ','TOKO','SMBK-F','F3E-ZAXI-60-0','GL BUBBLE GUMS SLEP UB 8K ','OL','2.300','1','100.00','2633000','0','0','15000','2645000','0','12000','0','2657000','NS','00384437','F3E','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZAXI-60-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.300',berat_jual_asli=berat_jual_asli+'2.300',stock_jual='1',berat_akhir=berat_akhir-'2.300',berat_akhir_asli=berat_akhir_asli-'2.300',stock_akhir='0' WHERE tanggal='2026-01-14' AND kode_barang='F3E-ZAXI-60-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 ('F226140852501','2026-01-14','2.300','2026-01-14','08:52:50','PLG0076474','2645000','2645000','12000','2657000','2657000','kasir','2026-01-14 08:52:50','F22614085250');
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-01-14','F226140852501','2026-01-14','08:52:50','NS','2657000','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-260114-0005','D','2026-01-14','08:52:50','kasir','PENJUALAN','F226140852501','4881700000','2657000','4884357000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2657000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140852501' 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 ('F226140852502','kasir',' 1',' MEB1 X LG ','TOKO','SMBK-B','B1E-YJAC-41-0','GW X MODEL DAISY MATA LG PE 8K ','OL','0.520','1','100.00','595000','0','0','15000','601000','0','5000','0','606000','NS','00372771','B1E','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJAC-41-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-01-14' AND kode_barang='B1E-YJAC-41-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226140852502','2026-01-14','0.520','2026-01-14','08:52:50','PLG0076475','601000','601000','5000','606000','606000','kasir','2026-01-14 08:52:50','F22614085250');
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-01-14','F226140852502','2026-01-14','08:52:50','NS','606000','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-260114-0006','D','2026-01-14','08:52:50','kasir','PENJUALAN','F226140852502','4884357000','606000','4884963000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='606000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140852502' 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 ('F226140854211','kasir','1',' MEF1 UB D5','TOKO','SMBK-F','F1E-ZAAC-9-T','GL OVAL MODEL C UB D56 8K ','OL','2.260','1','100.00','2588000','0','0','15000','2611000','0','11000','0','2622000','NS','T0076531','F1E','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZAAC-9-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.260',berat_jual_asli=berat_jual_asli+'2.260',stock_jual='1',berat_akhir=berat_akhir-'2.260',berat_akhir_asli=berat_akhir_asli-'2.260',stock_akhir='0' WHERE tanggal='2026-01-14' AND kode_barang='F1E-ZAAC-9-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 ('F226140854211','2026-01-14','2.260','2026-01-14','08:54:21','PLG0076476','2611000','2611000','11000','2622000','2622000','kasir','2026-01-14 08:54:21','F22614085421');
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-01-14','F226140854211','2026-01-14','08:54:21','NS','2622000','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-260114-0007','D','2026-01-14','08:54:21','kasir','PENJUALAN','F226140854211','4884963000','2622000','4887585000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2622000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140854211' 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 ('F226140854212','kasir',' 1',' MEF1 UB D5','TOKO','SMBK-F','F1E-ZAXH-33-T','GL OVAL MODEL C UB D58 8K','OL','2.360','1','100.00','2702000','0','0','15000','2726000','0','12000','0','2738000','NS','T0076356','F1E','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZAXH-33-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.360',berat_jual_asli=berat_jual_asli+'2.360',stock_jual='1',berat_akhir=berat_akhir-'2.360',berat_akhir_asli=berat_akhir_asli-'2.360',stock_akhir='0' WHERE tanggal='2026-01-14' AND kode_barang='F1E-ZAXH-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 ('F226140854212','2026-01-14','2.360','2026-01-14','08:54:21','PLG0076477','2726000','2726000','12000','2738000','2738000','kasir','2026-01-14 08:54:21','F22614085421');
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-01-14','F226140854212','2026-01-14','08:54:21','NS','2738000','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-260114-0008','D','2026-01-14','08:54:21','kasir','PENJUALAN','F226140854212','4887585000','2738000','4890323000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2738000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140854212' 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 ('F226140854213','kasir',' 1',' MEF1 UB D5','TOKO','SMBK-F','F1E-ZAAC-8-T','GL OVAL MODEL C UB D56 8K ','OL','2.230','1','100.00','2553000','0','0','15000','2576000','0','11000','0','2587000','NS','T0076530','F1E','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZAAC-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.230',berat_jual_asli=berat_jual_asli+'2.230',stock_jual='1',berat_akhir=berat_akhir-'2.230',berat_akhir_asli=berat_akhir_asli-'2.230',stock_akhir='0' WHERE tanggal='2026-01-14' AND kode_barang='F1E-ZAAC-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 ('F226140854213','2026-01-14','2.230','2026-01-14','08:54:21','PLG0076478','2576000','2576000','11000','2587000','2587000','kasir','2026-01-14 08:54:21','F22614085421');
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-01-14','F226140854213','2026-01-14','08:54:21','NS','2587000','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-260114-0009','D','2026-01-14','08:54:21','kasir','PENJUALAN','F226140854213','4890323000','2587000','4892910000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2587000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140854213' 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 ('F226140854214','kasir',' 1',' MEF1 UB D5','TOKO','SMBK-F','F1E-ZAAC-10-T','GL OVAL MODEL C UB D56 8K ','OL','2.250','1','100.00','2576000','0','0','15000','2599000','0','11000','0','2610000','NS','T0076532','F1E','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZAAC-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.250',berat_jual_asli=berat_jual_asli+'2.250',stock_jual='1',berat_akhir=berat_akhir-'2.250',berat_akhir_asli=berat_akhir_asli-'2.250',stock_akhir='0' WHERE tanggal='2026-01-14' AND kode_barang='F1E-ZAAC-10-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226140854214','2026-01-14','2.250','2026-01-14','08:54:21','PLG0076479','2599000','2599000','11000','2610000','2610000','kasir','2026-01-14 08:54:21','F22614085421');
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-01-14','F226140854214','2026-01-14','08:54:21','NS','2610000','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-260114-0010','D','2026-01-14','08:54:21','kasir','PENJUALAN','F226140854214','4892910000','2610000','4895520000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2610000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140854214' 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 ('F226140856091','kasir','1',' MDE2 CM 20','TOKO','SMBK-E','E2D-ZAXH-78-T','CC MODEL MATA VAR CM 20 8K ','OL','1.080','1','100.00','1215000','0','0','15000','1226000','0','5000','0','1231000','NS','T0076401','E2D','0','0','-','0','1125000');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZAXH-78-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-01-14' AND kode_barang='E2D-ZAXH-78-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226140856091','2026-01-14','1.080','2026-01-14','08:56:10','PLG0076480','1226000','1226000','5000','1231000','1231000','kasir','2026-01-14 08:56:09','F22614085609');
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-01-14','F226140856091','2026-01-14','08:56:10','NS','1231000','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-260114-0011','D','2026-01-14','08:56:10','kasir','PENJUALAN','F226140856091','4895520000','1231000','4896751000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1231000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140856091' 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 ('F226140856092','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZAXI-35-T','GL MODEL FLIK VAR HW 8K ','OL','1.830','1','100.00','2095000','0','0','15000','2114000','0','9000','0','2123000','NS','T0076510','F3E','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZAXI-35-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.830',berat_jual_asli=berat_jual_asli+'1.830',stock_jual='1',berat_akhir=berat_akhir-'1.830',berat_akhir_asli=berat_akhir_asli-'1.830',stock_akhir='0' WHERE tanggal='2026-01-14' AND kode_barang='F3E-ZAXI-35-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226140856092','2026-01-14','1.830','2026-01-14','08:56:10','PLG0076481','2114000','2114000','9000','2123000','2123000','kasir','2026-01-14 08:56:09','F22614085609');
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-01-14','F226140856092','2026-01-14','08:56:10','NS','2123000','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-260114-0012','D','2026-01-14','08:56:10','kasir','PENJUALAN','F226140856092','4896751000','2123000','4898874000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2123000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140856092' 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 ('F226140856093','kasir',' 1',' MEE2 CM 16','TOKO','SMBK-E','E2E-YLAH-31-T','CC COR MODEL MATA 16 CM 8K ','OL','0.600','1','100.00','687000','0','0','15000','696000','0','5000','0','701000','NS','T0075960','E2E','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YLAH-31-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-01-14' AND kode_barang='E2E-YLAH-31-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226140856093','2026-01-14','0.600','2026-01-14','08:56:10','PLG0076482','696000','696000','5000','701000','701000','kasir','2026-01-14 08:56:09','F22614085609');
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-01-14','F226140856093','2026-01-14','08:56:10','NS','701000','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-260114-0013','D','2026-01-14','08:56:10','kasir','PENJUALAN','F226140856093','4898874000','701000','4899575000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='701000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140856093' 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 ('F226140856094','kasir',' 1',' MDE1 CM 12','TOKO','SMBK-E','E1D-ZAXH-54-T','CC MODEL DAUN CM 12 8K ','OL','0.920','1','100.00','1035000','0','0','15000','1049000','0','5000','0','1054000','NS','T0076377','E1D','0','0','-','0','1125000');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZAXH-54-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.920',berat_jual_asli=berat_jual_asli+'0.920',stock_jual='1',berat_akhir=berat_akhir-'0.920',berat_akhir_asli=berat_akhir_asli-'0.920',stock_akhir='0' WHERE tanggal='2026-01-14' AND kode_barang='E1D-ZAXH-54-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226140856094','2026-01-14','0.920','2026-01-14','08:56:10','PLG0076483','1049000','1049000','5000','1054000','1054000','kasir','2026-01-14 08:56:09','F22614085609');
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-01-14','F226140856094','2026-01-14','08:56:10','NS','1054000','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-260114-0014','D','2026-01-14','08:56:10','kasir','PENJUALAN','F226140856094','4899575000','1054000','4900629000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1054000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140856094' 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 ('F226140856095','kasir',' 1',' MDE1 CM 16','TOKO','SMBK-E','E1D-ZAXH-67-T','CC POLOS CM 16 8K ','OL','1.060','1','100.00','1192000','0','0','15000','1203000','0','5000','0','1208000','NS','T0076390','E1D','0','0','-','0','1125000');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZAXH-67-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-01-14' AND kode_barang='E1D-ZAXH-67-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 ('F226140856095','2026-01-14','1.060','2026-01-14','08:56:10','PLG0076484','1203000','1203000','5000','1208000','1208000','kasir','2026-01-14 08:56:09','F22614085609');
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-01-14','F226140856095','2026-01-14','08:56:10','NS','1208000','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-260114-0015','D','2026-01-14','08:56:10','kasir','PENJUALAN','F226140856095','4900629000','1208000','4901837000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1208000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140856095' 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 ('F226140908051','kasir','1',' MFB1 X HK ','TOKO','SMBK-B','B1F-YIBD-116-0','GW X MODEL TAUGE MATA HK 8K ','OL','0.400','1','100.00','466000','0','0','15000','470000','0','5000','0','475000','RTA','00370537','B1F','0','0','-','0','1165000');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-YIBD-116-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-01-14' AND kode_barang='B1F-YIBD-116-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226140908051','2026-01-14','0.400','2026-01-14','09:08:06','PLG0076485','470000','470000','5000','475000','475000','kasir','2026-01-14 09:08:05','F22614090805');
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-01-14','F226140908051','2026-01-14','09:08:06','RTA','475000','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-260114-0016','D','2026-01-14','09:08:06','kasir','PENJUALAN','F226140908051','4901837000','475000','4902312000');
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 ('F226140948471','kasir','1',' MEH1 KH 44','TOKO','SMBK-H','H1E-YHAI-84-T','KL RANTAI HOLLOW KH 44CM 8K ','OL','4.110','1','100.00','4706000','0','0','15000','4747000','0','21000','0','4768000','RTA','T0072424','H1E','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YHAI-84-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.110',berat_jual_asli=berat_jual_asli+'4.110',stock_jual='1',berat_akhir=berat_akhir-'4.110',berat_akhir_asli=berat_akhir_asli-'4.110',stock_akhir='0' WHERE tanggal='2026-01-14' AND kode_barang='H1E-YHAI-84-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 ('F226140948471','2026-01-14','4.110','2026-01-14','09:48:47','PLG0076486','4747000','4747000','21000','4768000','4768000','kasir','2026-01-14 09:48:47','F22614094847');
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-01-14','F226140948471','2026-01-14','09:48:47','RTA','4768000','21000');
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-260114-0017','D','2026-01-14','09:48:47','kasir','PENJUALAN','F226140948471','4902312000','4768000','4907080000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4768000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140948471' 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 ('F226140948472','kasir',' 1',' MHB1 CM ','TOKO','SMBK-B','B1H-ZAAC-39-T','GW TUSUK DAISY MATA CM 8K ','OL','0.270','1','100.00','325000','0','0','15000','329000','0','5000','0','334000','RTA','T0076561','B1H','0','0','-','0','1205000');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-ZAAC-39-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-01-14' AND kode_barang='B1H-ZAAC-39-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 ('F226140948472','2026-01-14','0.270','2026-01-14','09:48:47','PLG0076487','329000','329000','5000','334000','334000','kasir','2026-01-14 09:48:47','F22614094847');
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-01-14','F226140948472','2026-01-14','09:48:47','RTA','334000','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-260114-0018','D','2026-01-14','09:48:47','kasir','PENJUALAN','F226140948472','4907080000','334000','4907414000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='334000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140948472' 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 ('F226140948473','kasir',' 1',' MHB1 CM ','TOKO','SMBK-B','B1H-ZAAC-38-T','GW TUSUK DAISY MATA CM 8K ','OL','0.270','1','100.00','325000','0','0','15000','329000','0','5000','0','334000','RTA','T0076560','B1H','0','0','-','0','1205000');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-ZAAC-38-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-01-14' AND kode_barang='B1H-ZAAC-38-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 ('F226140948473','2026-01-14','0.270','2026-01-14','09:48:47','PLG0076488','329000','329000','5000','334000','334000','kasir','2026-01-14 09:48:47','F22614094847');
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-01-14','F226140948473','2026-01-14','09:48:47','RTA','334000','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-260114-0019','D','2026-01-14','09:48:47','kasir','PENJUALAN','F226140948473','4907414000','334000','4907748000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='334000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140948473' 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 ('F226140948474','kasir',' 1',' MEB1E BM ','TOKO','SMBK-B','B1E-YLBX-61-T','GW MODEL SLEP BM 8K ','OL','0.750','1','100.00','859000','0','0','15000','870000','0','5000','0','875000','RTA','T0076046','B1E','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YLBX-61-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-01-14' AND kode_barang='B1E-YLBX-61-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 ('F226140948474','2026-01-14','0.750','2026-01-14','09:48:47','PLG0076489','870000','870000','5000','875000','875000','kasir','2026-01-14 09:48:47','F22614094847');
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-01-14','F226140948474','2026-01-14','09:48:47','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-260114-0020','D','2026-01-14','09:48:47','kasir','PENJUALAN','F226140948474','4907748000','875000','4908623000','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='F226140948474' 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 ('F226140948475','kasir',' 1',' MDE2 X UB ','TOKO','SMBK-E','E2D-YAXD-245-0','CC X MODEL HURUF MATA UB N 14 8K ','OL','0.860','1','100.00','967000','0','0','15000','980000','0','5000','0','985000','RTA','00332484','E2D','0','0','-','0','1125000');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YAXD-245-0' 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-01-14' AND kode_barang='E2D-YAXD-245-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 ('F226140948475','2026-01-14','0.860','2026-01-14','09:48:47','PLG0076490','980000','980000','5000','985000','985000','kasir','2026-01-14 09:48:47','F22614094847');
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-01-14','F226140948475','2026-01-14','09:48:47','RTA','985000','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-260114-0021','D','2026-01-14','09:48:47','kasir','PENJUALAN','F226140948475','4908623000','985000','4909608000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='985000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140948475' 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 ('F226140948476','kasir',' 1',' MDE2 HW 17','TOKO','SMBK-E','E2D-ZAAC-14-T','CC SPIRAL MODEL MATA VAR HW 17 8K ','OL','0.910','1','100.00','1024000','0','0','15000','1037000','0','5000','0','1042000','RTA','T0076536','E2D','0','0','-','0','1125000');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZAAC-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.910',berat_jual_asli=berat_jual_asli+'0.910',stock_jual='1',berat_akhir=berat_akhir-'0.910',berat_akhir_asli=berat_akhir_asli-'0.910',stock_akhir='0' WHERE tanggal='2026-01-14' AND kode_barang='E2D-ZAAC-14-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226140948476','2026-01-14','0.910','2026-01-14','09:48:47','PLG0076491','1037000','1037000','5000','1042000','1042000','kasir','2026-01-14 09:48:47','F22614094847');
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-01-14','F226140948476','2026-01-14','09:48:47','RTA','1042000','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-260114-0022','D','2026-01-14','09:48:47','kasir','PENJUALAN','F226140948476','4909608000','1042000','4910650000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1042000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140948476' 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 ('F226141056581','kasir','1',' TED1 LG ','TOKO','TBK-D','D1TE-YJXF-125-T','LT MODEL DAUN VAR LG 17K ','','0.460','1','100.00','950000','0','0','15000','950000','0','0','0','950000','RHM','T0074023','D1TE','0','0','-','0','2065000');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1TE-YJXF-125-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-01-14' AND kode_barang='D1TE-YJXF-125-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226141056581','2026-01-14','0.460','2026-01-14','10:56:59','PLG0076492','950000','950000','0','950000','950000','kasir','2026-01-14 10:56:58','F22614105658');
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-01-14','F226141056581','2026-01-14','10:56:59','RHM','950000','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-260114-0023','D','2026-01-14','10:56:59','kasir','PENJUALAN','F226141056581','4910650000','950000','4911600000');
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 ('F226141158521','kasir','1',' MDE1 CM 14','TOKO','SMBK-E','E1D-YKBH-122-T','CC MODEL DAUN SLEP VAR CM 14 8K ','','0.810','1','100.00','911000','0','0','15000','915000','0','0','0','915000','NS','T0075354','E1D','0','0','-','0','1125000');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YKBH-122-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.810',berat_jual_asli=berat_jual_asli+'0.810',stock_jual='1',berat_akhir=berat_akhir-'0.810',berat_akhir_asli=berat_akhir_asli-'0.810',stock_akhir='0' WHERE tanggal='2026-01-14' AND kode_barang='E1D-YKBH-122-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 ('F226141158521','2026-01-14','0.810','2026-01-14','11:58:53','PLG0076493','915000','915000','0','915000','915000','kasir','2026-01-14 11:58:52','F22614115852');
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-01-14','F226141158521','2026-01-14','11:58:53','NS','915000','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-260114-0024','D','2026-01-14','11:58:53','kasir','PENJUALAN','F226141158521','4911600000','915000','4912515000');
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 ('F226141215171','kasir','1',' MDE1 X UB ','TOKO','SMBK-E','E1D-YLCX-142-0','CC X MODEL SLEP UB 14 8K ','','0.850','1','100.00','956000','0','0','15000','960000','0','0','0','960000','RHM','00383547','E1D','0','0','-','0','1125000');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YLCX-142-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.850',berat_jual_asli=berat_jual_asli+'0.850',stock_jual='1',berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850',stock_akhir='0' WHERE tanggal='2026-01-14' AND kode_barang='E1D-YLCX-142-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 ('F226141215171','2026-01-14','0.850','2026-01-14','12:15:17','PLG0076494','960000','960000','0','960000','960000','kasir','2026-01-14 12:15:17','F22614121517');
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-01-14','F226141215171','2026-01-14','12:15:17','RHM','960000','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-260114-0025','D','2026-01-14','12:15:17','kasir','PENJUALAN','F226141215171','4912515000','960000','4913475000');
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 ('F226140244571','kasir','1',' TED1 X UB ','TOKO','TBK-D','D1TE-YLAA-24-T','LT X COR MODEL ARESO UB 17K','','0.660','1','100.00','1363000','0','0','15000','1373000','0','0','0','1373000','NS','T0075682','D1TE','0','0','-','0','2065000');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1TE-YLAA-24-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.660',berat_jual_asli=berat_jual_asli+'0.660',stock_jual='1',berat_akhir=berat_akhir-'0.660',berat_akhir_asli=berat_akhir_asli-'0.660',stock_akhir='0' WHERE tanggal='2026-01-14' AND kode_barang='D1TE-YLAA-24-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226140244571','2026-01-14','0.660','2026-01-14','14:44:57','PLG0076495','1373000','1373000','0','1373000','1373000','kasir','2026-01-14 14:44:57','F22614024457');
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-01-14','F226140244571','2026-01-14','14:44:57','NS','1373000','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-260114-0026','D','2026-01-14','14:44:57','kasir','PENJUALAN','F226140244571','4913475000','1373000','4914848000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140244571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140244571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140244571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140850361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140850361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140850361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140850591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140850591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140850591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140851411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140851411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140851411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140852501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140852501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140852501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140852502' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140852502' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140852502';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140854211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140854211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140854211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140854212' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140854212' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140854212';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140854213' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140854213' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140854213';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140854214' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140854214' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140854214';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140856091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140856091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140856091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140856092' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140856092' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140856092';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140856093' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140856093' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140856093';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140856094' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140856094' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140856094';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140856095' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140856095' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140856095';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140908051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140908051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140908051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140948471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140948471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140948471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140948472' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140948472' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140948472';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140948473' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140948473' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140948473';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140948474' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140948474' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140948474';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140948475' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140948475' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140948475';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140948476' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140948476' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140948476';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141056581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141056581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141056581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141158521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141158521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141158521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226141215171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226141215171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226141215171';
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-00005014','X-00005014','CC MODEL MATA VAR CM 14 8K','GR','---','E2E','BELI','BELI001','485000','2026-01-14','0.600','1','admin','2026-01-14 15:27:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00005014','X-00005014');
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-260114-0001','F224180236521','RTA','1','BELI','BELI001','E2E', 'X-00005014', 'CC MODEL MATA VAR CM 14 8K','0.750','0.600','100.00','446000','485000','808333','1145000','1','485000','485000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.600',berat_beli_asli=berat_beli_asli+'0.600',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.600',berat_akhir_asli=berat_akhir_asli+'0.600',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260114-0001','2026-01-14','2026-01-14','15:27:47','RTA','---','0.600','485000','485000','485000','485000','485000','admin','2026-01-14 15:27:48','FB-260114-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260114-0001','MEY','JL BATANG HARI 2/3 KADIPATEN','','','085648671525','admin','2026-01-14 15:27:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-14' 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-260114-0027','K','2026-01-14','15:27:47','admin','PEMBELIAN UMUM','FB-260114-0001','4914848000','485000','4914363000');
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 ('F226140338211','kasir','1',' MED1E X HW','TOKO','SMBK-D','D1E-YKBB-151-0','LT X MODEL COIN DOLAR HW 8K ','OLS4AUE4','0.500','1','100.00','572000','0','0','15000','583000','0','82000','0','665000','TIN','00378300','D1E','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YKBB-151-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-01-14' AND kode_barang='D1E-YKBB-151-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226140338211','2026-01-14','0.500','2026-01-14','15:38:22','PLG0076496','583000','583000','82000','665000','665000','kasir','2026-01-14 15:38:21','F22614033821');
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-01-14','F226140338211','2026-01-14','15:38:22','TIN','665000','82000');
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-260114-0028','D','2026-01-14','15:38:22','kasir','PENJUALAN','F226140338211','4914363000','665000','4915028000');
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 ('F226140408111','kasir','1',' MEF3 YT ','TOKO','SMBK-F','F3E-YLCX-2-T','GL FLIK MODEL BOLA ARESO YT 8K ','','2.500','1','100.00','2862000','0','0','15000','2875000','0','0','0','2875000','RTA','T0076243','F3E','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLCX-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.500',berat_jual_asli=berat_jual_asli+'2.500',stock_jual='1',berat_akhir=berat_akhir-'2.500',berat_akhir_asli=berat_akhir_asli-'2.500',stock_akhir='0' WHERE tanggal='2026-01-14' AND kode_barang='F3E-YLCX-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 ('F226140408111','2026-01-14','2.500','2026-01-14','16:08:11','PLG0076497','2875000','2875000','0','2875000','2875000','kasir','2026-01-14 16:08:11','F22614040811');
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-01-14','F226140408111','2026-01-14','16:08:11','RTA','2875000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260114-0029','D','2026-01-14','16:08:11','kasir','PENJUALAN','F226140408111','4915028000','2875000','4917903000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2875000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140408111' 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 ('F226140408112','kasir',' 1',' MEH1 HW 42','TOKO','SMBK-H','H1E-YLCA-1-T','KL SANTA ARESO VAR 42 HW 8K ','','1.880','1','100.00','2153000','0','0','15000','2162000','0','0','0','2162000','RTA','T0076283','H1E','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-01-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLCA-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.880',berat_jual_asli=berat_jual_asli+'1.880',stock_jual='1',berat_akhir=berat_akhir-'1.880',berat_akhir_asli=berat_akhir_asli-'1.880',stock_akhir='0' WHERE tanggal='2026-01-14' AND kode_barang='H1E-YLCA-1-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 ('F226140408112','2026-01-14','1.880','2026-01-14','16:08:11','PLG0076498','2162000','2162000','0','2162000','2162000','kasir','2026-01-14 16:08:11','F22614040811');
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-01-14','F226140408112','2026-01-14','16:08:11','RTA','2162000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260114-0030','D','2026-01-14','16:08:11','kasir','PENJUALAN','F226140408112','4917903000','2162000','4920065000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2162000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226140408112' LIMIT 1;
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-00005015','X-00005015','CC MODEL GELOMBANG VAR UB 12 8K','GR','---','E1F','BELI','BELI001','635000','2026-01-14','0.670','1','admin','2026-01-14 16:11:03');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1F','X-00005015','X-00005015');
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-260114-0002','F225091247322','RTA','1','BELI','BELI001','E1F', 'X-00005015', 'CC MODEL GELOMBANG VAR UB 12 8K','0.670','0.670','100.00','706000','635000','947761','1165000','1','635000','635000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.670',berat_beli_asli=berat_beli_asli+'0.670',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.670',berat_akhir_asli=berat_akhir_asli+'0.670',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1F' 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-260114-0002','2026-01-14','2026-01-14','16:11:02','RTA','---','0.670','635000','635000','635000','635000','635000','admin','2026-01-14 16:11:03','FB-260114-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260114-0002','ERLIKA','NGLEWAN SAMBIT','','','0856556661599','admin','2026-01-14 16:11:03');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-14' 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-260114-0031','K','2026-01-14','16:11:02','admin','PEMBELIAN UMUM','FB-260114-0002','4920065000','635000','4919430000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140338211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140338211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140338211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140408111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140408111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140408111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226140408112' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226140408112' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226140408112';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260114-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260114-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260114-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260114-0002';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-15','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-15';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-14';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-14';
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-01-14' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-14';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-14';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-14';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-14';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202600 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
UPDATE tt_barang_saldo SET tanggal= '2026-01-15' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-14' 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-260115-0001','D','2026-01-15','16:21:44','SYSTEM','SALDO AWAL','SALDO AWAL','0','4919430000','4919430000');
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-260115-0001','D','2026-01-15','16:21:44','BCA','SALDO AWAL','SALDO AWAL','0','4233045888','4233045888');
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-260115-0001','D','2026-01-15','16:21:44','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-260115-0001','D','2026-01-15','16:21:44','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-260115-0001','D','2026-01-15','16:21:44','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-260115-0001','D','2026-01-15','16:21:44','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2026-01-15';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260115-0001','1','E1D-ZAXI-176-0','1','0.900','0.900','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZAXI-176-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZAXI-176-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-01-15 16:59:41' WHERE kode_barang='E1D-ZAXI-176-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZAXI-176-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-15 16:59:41','TOKO','SMBK-E','E1D','E1D-ZAXI-176-0','1','0.900','0.900','1','0.900','0.900','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZAXI-176-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZAXI-176-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260115-0001','1','E1D-ZAXI-177-0','1','1.170','1.170','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZAXI-177-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZAXI-177-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-01-15 16:59:41' WHERE kode_barang='E1D-ZAXI-177-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZAXI-177-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-15 16:59:41','TOKO','SMBK-E','E1D','E1D-ZAXI-177-0','1','1.170','1.170','1','1.170','1.170','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZAXI-177-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZAXI-177-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260115-0001','2026-01-15','16:59','2.070','input','2026-01-14 16:59:41');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260115-0001','1','F3E-YLBX-230-0','1','3.030','3.030','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YLBX-230-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YLBX-230-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-01-15 16:59:57' WHERE kode_barang='F3E-YLBX-230-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YLBX-230-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-15 16:59:57','TOKO','SMBK-F','F3E','F3E-YLBX-230-0','1','3.030','3.030','1','3.030','3.030','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-YLBX-230-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YLBX-230-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260115-0001','2026-01-15','16:59','3.030','input','2026-01-14 16:59:57');