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 ('F225101118241','kasir','1',' MED1 5K LG','TOKO','SMBK-D','D1E-YJXF-99-T','LT MODEL PLAT DOLLAR LG 8K ','OL ','0.510','1','100.00','498000','0','0','15000','520000','0','5000','0','525000','RHM','T0073997','D1E','0','0','-','0','1010000');
UPDATE tm_barang SET tgl_last_jual='2025-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YJXF-99-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='2025-10-10' AND kode_barang='D1E-YJXF-99-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 ('F225101118241','2025-10-10','0.510','2025-10-10','11:18:24','PLG0073515','520000','520000','5000','525000','0','kasir','2025-10-10 11:18:24','F22510111824');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-10','F225101118241','2025-10-10','11:18:24','RHM','525000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251010-0001','2025-10-10','2025-10-10 11:18:24','PENJUALAN : F225101118241','63763864363863','BCA','525000','525000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251010-0002','D','2025-10-10','11:18:24','BCA','PENJUALAN','F225101118241','4050337888','525000','4050862888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('63763864363863','HHH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='525000' WHERE no_faktur_jual='F225101118241' LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251010-0001','1','E1D-YJXA-69-T','1','1.050','1.050','TOKO','SMBK-E','TOKO','BK-E');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='BK-E' WHERE kode_barang='E1D-YJXA-69-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-E';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-10','TOKO','BK-E','E1D','E1D-YJXA-69-T','100.00','1','1.050','1.050','1','1.050','1.050');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.050',berat_out_asli=berat_out_asli+'1.050',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-10' AND kode_barang='E1D-YJXA-69-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251010-0001','2025-10-10','2025-10-10','11:20','1.05','admin','2025-10-10 11:22:14');
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 ('F225101141541','kasir','1',' MEE2 HTM 1','TOKO','SMBK-E','E2E-YJXF-28-T','CC PIPA MODEL HATI MATA HTM 19 8K ','OL HK','0.600','1','100.00','586000','0','0','15000','607000','0','10000','0','617000','TIN','T0073926','E2E','0','0','-','0','1010000');
UPDATE tm_barang SET tgl_last_jual='2025-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXF-28-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='2025-10-10' AND kode_barang='E2E-YJXF-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 ('F225101141541','2025-10-10','0.600','2025-10-10','11:41:55','PLG0073516','607000','607000','10000','617000','617000','kasir','2025-10-10 11:41:54','F22510114154');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-10','F225101141541','2025-10-10','11:41:55','TIN','617000','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-251010-0002','D','2025-10-10','11:41:55','kasir','PENJUALAN','F225101141541','1284079000','617000','1284696000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='617000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101141541' 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 ('F225101141542','kasir',' 1',' MDE2 X CM ','TOKO','SMBK-E','E2D-YIAC-326-0','CC X MODEL MATA CM 20 8K ','OL HK','1.040','1','100.00','946000','0','0','15000','1051000','0','10000','0','1061000','TIN','00369410','E2D','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIAC-326-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.040',berat_jual_asli=berat_jual_asli+'1.040',stock_jual='1',berat_akhir=berat_akhir-'1.040',berat_akhir_asli=berat_akhir_asli-'1.040',stock_akhir='0' WHERE tanggal='2025-10-10' AND kode_barang='E2D-YIAC-326-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 ('F225101141542','2025-10-10','1.040','2025-10-10','11:41:55','PLG0073517','1051000','1051000','10000','1061000','1061000','kasir','2025-10-10 11:41:54','F22510114154');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-10','F225101141542','2025-10-10','11:41:55','TIN','1061000','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-251010-0003','D','2025-10-10','11:41:55','kasir','PENJUALAN','F225101141542','1284696000','1061000','1285757000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1061000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101141542' 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 ('F225101141543','kasir',' 1',' MEH1 UB ','TOKO','SMBK-H','H1E-YICX-1-T','KL SANTA MODEL MATA VAR UB 8K ','OL HK','2.140','1','100.00','2029000','0','0','15000','2162000','0','21000','0','2183000','TIN','T0073413','H1E','0','0','-','0','1010000');
UPDATE tm_barang SET tgl_last_jual='2025-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YICX-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.140',berat_jual_asli=berat_jual_asli+'2.140',stock_jual='1',berat_akhir=berat_akhir-'2.140',berat_akhir_asli=berat_akhir_asli-'2.140',stock_akhir='0' WHERE tanggal='2025-10-10' AND kode_barang='H1E-YICX-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 ('F225101141543','2025-10-10','2.140','2025-10-10','11:41:55','PLG0073518','2162000','2162000','21000','2183000','2183000','kasir','2025-10-10 11:41:54','F22510114154');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-10','F225101141543','2025-10-10','11:41:55','TIN','2183000','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-251010-0004','D','2025-10-10','11:41:55','kasir','PENJUALAN','F225101141543','1285757000','2183000','1287940000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2183000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225101141543' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101118241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101118241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101118241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101141541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101141541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101141541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101141542' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101141542' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101141542';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225101141543' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225101141543' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225101141543';
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 ('F225100112441','kasir','1',' MEB1 LG PE','TOKO','SMBK-B','B1E-YJXD-71-T','GW TUSUK MODEL MATA VAR LG PE 8K ','OL','0.600','1','100.00','585000','0','0','15000','609000','0','5000','0','614000','TIN','T0073885','B1E','0','0','-','0','1010000');
UPDATE tm_barang SET tgl_last_jual='2025-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJXD-71-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='2025-10-10' AND kode_barang='B1E-YJXD-71-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 ('F225100112441','2025-10-10','0.600','2025-10-10','13:12:44','PLG0073519','609000','609000','5000','614000','614000','kasir','2025-10-10 13:12:44','F22510011244');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-10','F225100112441','2025-10-10','13:12:44','TIN','614000','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-251010-0005','D','2025-10-10','13:12:44','kasir','PENJUALAN','F225100112441','1287940000','614000','1288554000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='614000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225100112441' 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 ('F225100112442','kasir',' 1',' MEB1 X LG ','TOKO','SMBK-B','B1E-YHXB-114-0','GW X MODEL MATA LG PE 8K ','OL','0.680','1','100.00','630000','0','0','15000','690000','0','5000','0','695000','TIN','00363524','B1E','0','0','-','0','1010000');
UPDATE tm_barang SET tgl_last_jual='2025-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YHXB-114-0' 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='2025-10-10' AND kode_barang='B1E-YHXB-114-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 ('F225100112442','2025-10-10','0.680','2025-10-10','13:12:44','PLG0073520','690000','690000','5000','695000','695000','kasir','2025-10-10 13:12:44','F22510011244');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-10','F225100112442','2025-10-10','13:12:44','TIN','695000','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-251010-0006','D','2025-10-10','13:12:44','kasir','PENJUALAN','F225100112442','1288554000','695000','1289249000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='695000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225100112442' 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 ('F225100141131','kasir','1',' MDE1 X LG ','TOKO','SMBK-E','E1D-YIAC-38-0','CC X MODEL SLEP LG 20 8K ','','2.700','1','100.00','2457000','0','0','15000','2660000','0','0','0','2660000','TJ','00369122','E1D','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YIAC-38-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.700',berat_jual_asli=berat_jual_asli+'2.700',stock_jual='1',berat_akhir=berat_akhir-'2.700',berat_akhir_asli=berat_akhir_asli-'2.700',stock_akhir='0' WHERE tanggal='2025-10-10' AND kode_barang='E1D-YIAC-38-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 ('F225100141131','2025-10-10','2.700','2025-10-10','13:41:14','PLG0073521','2660000','2660000','0','2660000','2660000','kasir','2025-10-10 13:41:13','F22510014113');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-10','F225100141131','2025-10-10','13:41:14','TJ','2660000','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-251010-0007','D','2025-10-10','13:41:14','kasir','PENJUALAN','F225100141131','1289249000','2660000','1291909000');
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 ('F225100207571','kasir','1',' MEE2 CM 14','TOKO','SMBK-E','E2E-YJXD-51-T','CC MODEL MATA VAR CM 14 8K ','OL','0.630','1','100.00','614000','0','0','15000','643000','0','5000','0','648000','TJ','T0073865','E2E','0','0','-','0','1010000');
UPDATE tm_barang SET tgl_last_jual='2025-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXD-51-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.630',berat_jual_asli=berat_jual_asli+'0.630',stock_jual='1',berat_akhir=berat_akhir-'0.630',berat_akhir_asli=berat_akhir_asli-'0.630',stock_akhir='0' WHERE tanggal='2025-10-10' AND kode_barang='E2E-YJXD-51-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 ('F225100207571','2025-10-10','0.630','2025-10-10','14:07:58','PLG0073522','643000','643000','5000','648000','648000','kasir','2025-10-10 14:07:57','F22510020757');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-10','F225100207571','2025-10-10','14:07:58','TJ','648000','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-251010-0008','D','2025-10-10','14:07:58','kasir','PENJUALAN','F225100207571','1291909000','648000','1292557000');
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-00004730','X-00004730','CC MODEL DAUN VAR CM 22 8K','GR','---','E1D','BELI','BELI001','1125000','2025-10-10','1.160','1','kasir','2025-10-10 14:37:11');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00004730','X-00004730');
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-251010-0001','F225090159551','RHM','1','BELI','BELI001','E1D', 'X-00004730', 'CC MODEL DAUN VAR CM 22 8K','1.160','1.160','100.00','1150000','1125000','969828','960000','1','1125000','1125000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.160',berat_beli_asli=berat_beli_asli+'1.160',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.160',berat_akhir_asli=berat_akhir_asli+'1.160',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-10' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251010-0001','2025-10-10','2025-10-10','14:37:11','RHM','---','1.160','1125000','1125000','1125000','1125000','1125000','kasir','2025-10-10 14:37:11','FB-251010-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251010-0001','B SURYATI','GAJAH 1/2 MLARAK','','','085259806025','kasir','2025-10-10 14:37:11');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-10' 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-251010-0009','K','2025-10-10','14:37:11','kasir','PEMBELIAN UMUM','FB-251010-0001','1292557000','1125000','1291432000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100112441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100112441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100112441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100112442' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100112442' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100112442';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100141131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100141131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100141131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100207571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100207571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100207571';
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 ('F225100307141','kasir','1',' TFH1 HW 39','TOKO','TBK-H','H1TF-YFAA-57-T','KL ITALY HW 39CM 17K ','','2.330','1','100.00','3861000','0','0','15000','4194000','0','0','0','4194000','TJ','T0069908','H1TF','0','0','-','0','1657000');
UPDATE tm_barang SET tgl_last_jual='2025-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TF-YFAA-57-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.330',berat_jual_asli=berat_jual_asli+'2.330',stock_jual='1',berat_akhir=berat_akhir-'2.330',berat_akhir_asli=berat_akhir_asli-'2.330',stock_akhir='0' WHERE tanggal='2025-10-10' AND kode_barang='H1TF-YFAA-57-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225100307141','2025-10-10','2.330','2025-10-10','15:07:14','PLG0073523','4194000','4194000','0','4194000','4194000','kasir','2025-10-10 15:07:14','F22510030714');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-10','F225100307141','2025-10-10','15:07:14','TJ','4194000','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-251010-0010','D','2025-10-10','15:07:14','kasir','PENJUALAN','F225100307141','1291432000','4194000','1295626000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4194000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225100307141' 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 ('F225100307142','kasir',' 1',' TDD2 LG D ','TOKO','TBK-D','D2TD-YJXC-47-T','LT MODEL HURUF MATA LG D 17K ','','1.000','1','100.00','1623000','0','0','15000','1760000','0','0','0','1760000','TJ','T0073768','D2TD','0','0','-','0','1623000');
UPDATE tm_barang SET tgl_last_jual='2025-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2TD-YJXC-47-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='2025-10-10' AND kode_barang='D2TD-YJXC-47-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 ('F225100307142','2025-10-10','1.000','2025-10-10','15:07:14','PLG0073524','1760000','1760000','0','1760000','1760000','kasir','2025-10-10 15:07:14','F22510030714');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-10','F225100307142','2025-10-10','15:07:14','TJ','1760000','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-251010-0011','D','2025-10-10','15:07:14','kasir','PENJUALAN','F225100307142','1295626000','1760000','1297386000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1760000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225100307142' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100307141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100307141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100307141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100307142' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100307142' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100307142';
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 ('F225100326521','kasir','1',' MGF3 UB ','TOKO','SMBK-F','F3G-YJXF-61-T','GL BORSALINO UB 8K ','','0.350','1','100.00','356000','0','0','15000','366000','0','0','0','366000','RTA','T0073959','F3G','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3G-YJXF-61-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='2025-10-10' AND kode_barang='F3G-YJXF-61-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 ('F225100326521','2025-10-10','0.350','2025-10-10','15:26:53','PLG0073525','366000','366000','0','366000','0','kasir','2025-10-10 15:26:52','F22510032652');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-10','F225100326521','2025-10-10','15:26:53','RTA','366000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251010-0002','2025-10-10','2025-10-10 15:26:52','PENJUALAN : F225100326521','89876766555','BCA','366000','366000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251010-0003','D','2025-10-10','15:26:53','BCA','PENJUALAN','F225100326521','4050862888','366000','4051228888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('89876766555','EVA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='366000' WHERE no_faktur_jual='F225100326521' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100326521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100326521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100326521';
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 ('F225100330111','kasir','1',' MFD1 BW ','TOKO','SMBK-D','D1F-YJXF-95-T','LT MODEL LETTERA PLAT BW 8K ','OL','0.410','1','100.00','409000','0','0','15000','426000','0','5000','0','431000','TJ','T0073993','D1F','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YJXF-95-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.410',berat_jual_asli=berat_jual_asli+'0.410',stock_jual='1',berat_akhir=berat_akhir-'0.410',berat_akhir_asli=berat_akhir_asli-'0.410',stock_akhir='0' WHERE tanggal='2025-10-10' AND kode_barang='D1F-YJXF-95-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 ('F225100330111','2025-10-10','0.410','2025-10-10','15:30:12','PLG0073526','426000','426000','5000','431000','431000','kasir','2025-10-10 15:30:11','F22510033011');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-10','F225100330111','2025-10-10','15:30:12','TJ','431000','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-251010-0012','D','2025-10-10','15:30:12','kasir','PENJUALAN','F225100330111','1297386000','431000','1297817000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225100330111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225100330111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225100330111';
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-00004731','X-00004731','CC MODEL MATA VAR YT 16 8K','GR','---','E2D','BELI','BELI001','735000','2025-10-10','1.050','1','kasir','2025-10-10 15:40:44');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00004731','X-00004731');
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-251010-0002','F225070128431','RHM','1','BELI','BELI001','E2D', 'X-00004731', 'CC MODEL MATA VAR YT 16 8K','1.110','1.050','100.00','725000','735000','700000','960000','1','735000','735000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.050',berat_beli_asli=berat_beli_asli+'1.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.050',berat_akhir_asli=berat_akhir_asli+'1.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-10' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251010-0002','2025-10-10','2025-10-10','15:40:43','RHM','---','1.050','735000','735000','735000','735000','735000','kasir','2025-10-10 15:40:44','FB-251010-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251010-0002','HENI','JL LAWU 66B NOLOGATEN','','','','kasir','2025-10-10 15:40:44');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-10' 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-251010-0013','K','2025-10-10','15:40:43','kasir','PEMBELIAN UMUM','FB-251010-0002','1297817000','735000','1297082000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251010-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251010-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251010-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251010-0002';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-11','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-10';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-10';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-10';
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='2025-10-10' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-10';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-10';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-10';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-10';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202509 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
UPDATE tt_barang_saldo SET tanggal= '2025-10-11' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-10' 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-251011-0001','D','2025-10-11','16:03:24','SYSTEM','SALDO AWAL','SALDO AWAL','0','1297082000','1297082000');
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-251011-0001','D','2025-10-11','16:03:24','BCA','SALDO AWAL','SALDO AWAL','0','4051228888','4051228888');
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-251011-0001','D','2025-10-11','16:03:24','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251011-0001','D','2025-10-11','16:03:24','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251011-0001','D','2025-10-11','16:03:24','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251011-0001','D','2025-10-11','16:03:24','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2025-10-11';