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 ('F226180910371','kasir','1',' MEE1 5K LG','TOKO','SMBK-E','E1E-ZHXD-20-T','CC MODEL DURIAN SLEP LG 12 8K ','OL','0.510','1','100.00','557000','0','0','15000','562000','0','5000','0','567000','LUS','T0081858','E1E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2026-08-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHXD-20-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-08-18' AND kode_barang='E1E-ZHXD-20-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226180910371','2026-08-18','0.510','2026-08-18','09:10:37','PLG0083630','562000','562000','5000','567000','567000','kasir','2026-08-18 09:10:37','F22618091037');
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-08-18','F226180910371','2026-08-18','09:10:37','LUS','567000','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-260818-0002','D','2026-08-18','09:10:37','kasir','PENJUALAN','F226180910371','13693728000','567000','13694295000');
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 ('F226180911131','kasir','1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZGAA-11-T','CC MODEL DAUN SLEP LG 12 8K ','OL','0.480','1','100.00','524000','0','0','15000','529000','0','5000','0','534000','LUS','T0081022','E1E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2026-08-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGAA-11-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-08-18' AND kode_barang='E1E-ZGAA-11-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 ('F226180911131','2026-08-18','0.480','2026-08-18','09:11:14','PLG0083631','529000','529000','5000','534000','534000','kasir','2026-08-18 09:11:13','F22618091113');
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-08-18','F226180911131','2026-08-18','09:11:14','LUS','534000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260818-0003','D','2026-08-18','09:11:14','kasir','PENJUALAN','F226180911131','13694295000','534000','13694829000');
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 ('F226180957271','kasir','1',' TDE2X 10K ','TOKO','TBK-E','E2TD-YGBD-74-T','CC X WEDDING MATA CM 15 17K ','','2.050','1','100.00','4059000','0','0','15000','4059000','0','10000','0','4069000','DIN','T0071502','E2TD','0','0','-','0','1980000');
UPDATE tm_barang SET tgl_last_jual='2026-08-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-YGBD-74-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2026-08-18' AND kode_barang='E2TD-YGBD-74-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226180957271','2026-08-18','2.050','2026-08-18','09:57:27','PLG0083632','4059000','4059000','10000','4069000','4069000','kasir','2026-08-18 09:57:27','F22618095727');
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-08-18','F226180957271','2026-08-18','09:57:27','DIN','4069000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260818-0004','D','2026-08-18','09:57:27','kasir','PENJUALAN','F226180957271','13694829000','4069000','13698898000');
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 ('F226181040241','kasir','1',' MFD1F X BG','TOKO','SMBK-D','D1F-ZHXG-72-0','LT X MODEL HATI SLEP BG 8K ','','0.820','1','100.00','912000','0','0','15000','912000','0','0','0','912000','RHM','00417491','D1F','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-08-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZHXG-72-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-08-18' AND kode_barang='D1F-ZHXG-72-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 ('F226181040241','2026-08-18','0.820','2026-08-18','10:40:24','PLG0083633','912000','912000','0','912000','0','kasir','2026-08-18 10:40:24','F22618104024');
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-08-18','F226181040241','2026-08-18','10:40:24','RHM','912000','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-260818-0001','2026-08-18','2026-08-18 10:40:24','PENJUALAN : F226181040241','75438653863636365365','BCA','912000','912000','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-260818-0002','D','2026-08-18','10:40:24','BCA','PENJUALAN','F226181040241','4727791888','912000','4728703888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('75438653863636365365','HHHH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='912000' WHERE no_faktur_jual='F226181040241' 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 ('F226181043341','kasir','1',' MDE2 X UB ','TOKO','SMBK-E','E2D-ZHXA-321-0','CC X MODEL MATA UB 14 8K ','OL','1.010','1','100.00','1083000','0','0','15000','1093000','0','5000','0','1098000','LUS','00416619','E2D','0','0','-','0','1072000');
UPDATE tm_barang SET tgl_last_jual='2026-08-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZHXA-321-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-08-18' AND kode_barang='E2D-ZHXA-321-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 ('F226181043341','2026-08-18','1.010','2026-08-18','10:43:35','PLG0083634','1093000','1093000','5000','1098000','1098000','kasir','2026-08-18 10:43:34','F22618104334');
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-08-18','F226181043341','2026-08-18','10:43:35','LUS','1098000','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-260818-0005','D','2026-08-18','10:43:35','kasir','PENJUALAN','F226181043341','13698898000','1098000','13699996000');
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 ('F226181059291','kasir','1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZHAA-53-T','LT SLOBOK HURUF R BG 8K ','','0.560','1','100.00','623000','0','0','15000','623000','0','5000','0','628000','NOV','T0082193','D1F','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-08-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZHAA-53-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-08-18' AND kode_barang='D1F-ZHAA-53-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 ('F226181059291','2026-08-18','0.560','2026-08-18','10:59:29','PLG0083635','623000','623000','5000','628000','0','kasir','2026-08-18 10:59:29','F22618105929');
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-08-18','F226181059291','2026-08-18','10:59:29','NOV','628000','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-260818-0002','2026-08-18','2026-08-18 10:59:29','PENJUALAN : F226181059291','343445656787','BCA','628000','628000','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-260818-0003','D','2026-08-18','10:59:29','BCA','PENJUALAN','F226181059291','4728703888','628000','4729331888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('343445656787','RATNA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='628000' WHERE no_faktur_jual='F226181059291' 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 ('F226181100401','kasir','1',' MEH1E UB 3','TOKO','SMBK-H','H1E-ZGBA-57-T','KL TIFF SPECTRA VAR SLEP UB 39 8K ','OL','2.800','1','100.00','3058000','0','0','15000','3072000','0','14000','0','3086000','DIN','T0081427','H1E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2026-08-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGBA-57-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.800',berat_jual_asli=berat_jual_asli+'2.800',stock_jual='1',berat_akhir=berat_akhir-'2.800',berat_akhir_asli=berat_akhir_asli-'2.800',stock_akhir='0' WHERE tanggal='2026-08-18' AND kode_barang='H1E-ZGBA-57-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 ('F226181100401','2026-08-18','2.800','2026-08-18','11:00:41','PLG0083636','3072000','3072000','14000','3086000','3086000','kasir','2026-08-18 11:00:40','F22618110040');
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-08-18','F226181100401','2026-08-18','11:00:41','DIN','3086000','14000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260818-0006','D','2026-08-18','11:00:41','kasir','PENJUALAN','F226181100401','13699996000','3086000','13703082000');
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 ('F226181116291','kasir','1',' MEE1 X LG ','TOKO','SMBK-E','E1E-ZHAE-200-0','CC X MODEL ISYANA SLEP LG 10 8K ','OL','0.520','1','100.00','568000','0','0','15000','573000','0','5000','0','578000','TIN','00419221','E1E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2026-08-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHAE-200-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-08-18' AND kode_barang='E1E-ZHAE-200-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 ('F226181116291','2026-08-18','0.520','2026-08-18','11:16:30','PLG0083637','573000','573000','5000','578000','578000','kasir','2026-08-18 11:16:29','F22618111629');
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-08-18','F226181116291','2026-08-18','11:16:30','TIN','578000','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-260818-0007','D','2026-08-18','11:16:30','kasir','PENJUALAN','F226181116291','13703082000','578000','13703660000');
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 ('F226181136241','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZHXH-335-0','CC X MODEL MATA CM 12 8K ','OL','0.910','1','100.00','976000','0','0','15000','985000','0','5000','0','990000','TIN','00418064','E2D','0','0','-','0','1072000');
UPDATE tm_barang SET tgl_last_jual='2026-08-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZHXH-335-0' 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-08-18' AND kode_barang='E2D-ZHXH-335-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 ('F226181136241','2026-08-18','0.910','2026-08-18','11:36:25','PLG0083638','985000','985000','5000','990000','990000','kasir','2026-08-18 11:36:24','F22618113624');
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-08-18','F226181136241','2026-08-18','11:36:25','TIN','990000','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-260818-0008','D','2026-08-18','11:36:25','kasir','PENJUALAN','F226181136241','13703660000','990000','13704650000');
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 ('F226181225471','kasir','1',' MDE2 X PM ','TOKO','SMBK-E','E2D-ZCCX-494-0','CC X MODEL MATA PM 14 8K ','OL','0.980','1','100.00','1051000','0','0','15000','1060000','0','5000','0','1065000','TIN','00397148','E2D','0','0','-','0','1072000');
UPDATE tm_barang SET tgl_last_jual='2026-08-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCCX-494-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2026-08-18' AND kode_barang='E2D-ZCCX-494-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 ('F226181225471','2026-08-18','0.980','2026-08-18','12:25:48','PLG0083639','1060000','1060000','5000','1065000','1065000','kasir','2026-08-18 12:25:47','F22618122547');
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-08-18','F226181225471','2026-08-18','12:25:48','TIN','1065000','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-260818-0009','D','2026-08-18','12:25:48','kasir','PENJUALAN','F226181225471','13704650000','1065000','13705715000');
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 ('F226181247221','kasir','1',' MEB1 LG PE','TOKO','SMBK-B','B1E-ZHAA-20-T','GW MODEL DAISY MATA LG 8K PE ','OL','0.500','1','100.00','546000','0','0','15000','551000','0','5000','0','556000','DIN','T0082160','B1E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2026-08-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZHAA-20-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-08-18' AND kode_barang='B1E-ZHAA-20-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 ('F226181247221','2026-08-18','0.500','2026-08-18','12:47:23','PLG0083640','551000','551000','5000','556000','556000','kasir','2026-08-18 12:47:22','F22618124722');
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-08-18','F226181247221','2026-08-18','12:47:23','DIN','556000','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-260818-0010','D','2026-08-18','12:47:23','kasir','PENJUALAN','F226181247221','13705715000','556000','13706271000');
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 ('F226180110121','kasir','1',' TGPE CM 20','TOKO','TBK-P','PETG-YBXD-68-T','CC WG POLOS CM 20 17K ','','1.880','1','100.00','3835000','0','0','15000','3835000','0','0','0','3835000','LUS','T0066570','PETG','0','0','-','0','2040000');
UPDATE tm_barang SET tgl_last_jual='2026-08-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PETG-YBXD-68-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-08-18' AND kode_barang='PETG-YBXD-68-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-P' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226180110121','2026-08-18','1.880','2026-08-18','13:10:12','PLG0083641','3835000','3835000','0','3835000','3835000','kasir','2026-08-18 13:10:12','F22618011012');
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-08-18','F226180110121','2026-08-18','13:10:12','LUS','3835000','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-260818-0011','D','2026-08-18','13:10:12','kasir','PENJUALAN','F226180110121','13706271000','3835000','13710106000');
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 ('F226180135551','kasir','1',' MEF1E TD 5','TOKO','SMBK-F','F1E-ZFXD-57-T','GL BANGKOK C SLEP TD 58 8K ','','4.950','1','100.00','5405000','0','0','15000','5405000','0','0','0','5405000','NOV','T0080222','F1E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2026-08-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZFXD-57-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.950',berat_jual_asli=berat_jual_asli+'4.950',stock_jual='1',berat_akhir=berat_akhir-'4.950',berat_akhir_asli=berat_akhir_asli-'4.950',stock_akhir='0' WHERE tanggal='2026-08-18' AND kode_barang='F1E-ZFXD-57-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 ('F226180135551','2026-08-18','4.950','2026-08-18','13:35:56','PLG0083642','5405000','5405000','0','5405000','5405000','kasir','2026-08-18 13:35:55','F22618013555');
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-08-18','F226180135551','2026-08-18','13:35:56','NOV','5405000','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-260818-0012','D','2026-08-18','13:35:56','kasir','PENJUALAN','F226180135551','13710106000','5405000','13715511000');
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 ('F226180204231','kasir','1',' MEA1E X BW','TOKO','SMBK-A','A1E-ZHXG-20-0','AT X ITALY SLEP VAR BW 8K ','OL','0.530','1','100.00','579000','0','0','15000','584000','0','5000','0','589000','TIN','00417439','A1E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2026-08-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZHXG-20-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-08-18' AND kode_barang='A1E-ZHXG-20-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226180204231','2026-08-18','0.530','2026-08-18','14:04:24','PLG0083643','584000','584000','5000','589000','589000','kasir','2026-08-18 14:04:23','F22618020423');
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-08-18','F226180204231','2026-08-18','14:04:24','TIN','589000','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-260818-0013','D','2026-08-18','14:04:24','kasir','PENJUALAN','F226180204231','13715511000','589000','13716100000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='589000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226180204231' 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 ('F226180204232','kasir',' 1',' MFD1 5K LG','TOKO','SMBK-D','D1F-ZHAA-74-T','LT FG SLEP LG 8K ','OL','0.520','1','100.00','578000','0','0','15000','573000','0','5000','0','578000','TIN','T0082214','D1F','0','0','-','1','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-08-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZHAA-74-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-08-18' AND kode_barang='D1F-ZHAA-74-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 ('F226180204232','2026-08-18','0.520','2026-08-18','14:04:24','PLG0083644','573000','573000','5000','578000','578000','kasir','2026-08-18 14:04:23','F22618020423');
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-08-18','F226180204232','2026-08-18','14:04:24','TIN','578000','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-260818-0014','D','2026-08-18','14:04:24','kasir','PENJUALAN','F226180204232','13716100000','578000','13716678000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='578000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226180204232' 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 ('F226180204233','kasir',' 1',' MGE1G HW 1','TOKO','SMBK-E','E1G-ZHXC-71-T','CC MODEL GELOMBANG SLEP HW 13 8K ','OL','0.280','1','100.00','317000','0','0','15000','320000','0','5000','0','325000','TIN','T0081800','E1G','0','0','-','0','1132000');
UPDATE tm_barang SET tgl_last_jual='2026-08-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1G-ZHXC-71-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.280',berat_jual_asli=berat_jual_asli+'0.280',stock_jual='1',berat_akhir=berat_akhir-'0.280',berat_akhir_asli=berat_akhir_asli-'0.280',stock_akhir='0' WHERE tanggal='2026-08-18' AND kode_barang='E1G-ZHXC-71-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 ('F226180204233','2026-08-18','0.280','2026-08-18','14:04:24','PLG0083645','320000','320000','5000','325000','325000','kasir','2026-08-18 14:04:23','F22618020423');
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-08-18','F226180204233','2026-08-18','14:04:24','TIN','325000','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-260818-0015','D','2026-08-18','14:04:24','kasir','PENJUALAN','F226180204233','13716678000','325000','13717003000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='325000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226180204233' 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 ('F226180204234','kasir',' 1',' MEE1E HT 1','TOKO','SMBK-E','E1F-ZHXC-74-T','CC MODEL GELOMBANG SLEP HT 10 8K','OL','0.360','1','100.00','400000','0','0','15000','397000','0','5000','0','402000','TIN','T0081803','E1F','0','0','-','1','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-08-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZHXC-74-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.360',berat_jual_asli=berat_jual_asli+'0.360',stock_jual='1',berat_akhir=berat_akhir-'0.360',berat_akhir_asli=berat_akhir_asli-'0.360',stock_akhir='0' WHERE tanggal='2026-08-18' AND kode_barang='E1F-ZHXC-74-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 ('F226180204234','2026-08-18','0.360','2026-08-18','14:04:24','PLG0083646','397000','397000','5000','402000','402000','kasir','2026-08-18 14:04:23','F22618020423');
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-08-18','F226180204234','2026-08-18','14:04:24','TIN','402000','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-260818-0016','D','2026-08-18','14:04:24','kasir','PENJUALAN','F226180204234','13717003000','402000','13717405000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='402000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226180204234' 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 ('F226180225181','kasir','1',' MDA1 X UB','TOKO','SMBK-A','A1D-ZGBX-217-0','AT X MODEL ITALY SLEP UB 8K','OL','1.000','1','100.00','1072000','0','0','15000','1077000','0','5000','0','1082000','LUS','00414418','A1D','0','0','-','0','1072000');
UPDATE tm_barang SET tgl_last_jual='2026-08-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZGBX-217-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-08-18' AND kode_barang='A1D-ZGBX-217-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226180225181','2026-08-18','1.000','2026-08-18','14:25:19','PLG0083647','1077000','1077000','5000','1082000','1082000','kasir','2026-08-18 14:25:18','F22618022518');
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-08-18','F226180225181','2026-08-18','14:25:19','LUS','1082000','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-260818-0017','D','2026-08-18','14:25:19','kasir','PENJUALAN','F226180225181','13717405000','1082000','13718487000');
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-00005638','X-00005638','KL RANTAI HOLLOW KH 42CM','GR','---','H1E','BELI','BELI001','1453000','2026-08-18','1.900','1','admin','2026-08-18 14:55:25');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00005638','X-00005638');
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-260818-0001','F223190244218','LUS','1','BELI','BELI001','H1E', 'X-00005638', 'KL RANTAI HOLLOW KH 42CM','2.030','1.900','100.00','916000','1453000','764737','1092000','1','1453000','1453000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.900',berat_beli_asli=berat_beli_asli+'1.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.900',berat_akhir_asli=berat_akhir_asli+'1.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260818-0001','2026-08-18','2026-08-18','14:55:25','LUS','---','1.900','1453000','1453000','1453000','1453000','1453000','admin','2026-08-18 14:55:25','FB-260818-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260818-0001','VANY','HONGKONG','','','','admin','2026-08-18 14:55:25');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-18' 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-260818-0018','K','2026-08-18','14:55:25','admin','PEMBELIAN UMUM','FB-260818-0001','13718487000','1453000','13717034000');
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-00005639','X-00005639','GL CASTELA SLEP VAR HW 8K','GR','---','F3E','BELI','BELI001','1550000','2026-08-18','1.580','1','admin','2026-08-18 14:55:25');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00005639','X-00005639');
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-260818-0002','F226210312341','LUS','2','BELI','BELI001','F3E', 'X-00005639', 'GL CASTELA SLEP VAR HW 8K','1.580','1.580','100.00','1850000','1550000','981013','1092000','1','1550000','1550000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.580',berat_beli_asli=berat_beli_asli+'1.580',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.580',berat_akhir_asli=berat_akhir_asli+'1.580',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260818-0002','2026-08-18','2026-08-18','14:55:25','LUS','---','1.580','1550000','1550000','1550000','1550000','1550000','admin','2026-08-18 14:55:25','FB-260818-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260818-0002','DEWI PUSPITASARI','KETRO SAWO','','','081330699057','admin','2026-08-18 14:55:25');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-18' 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-260818-0019','K','2026-08-18','14:55:25','admin','PEMBELIAN UMUM','FB-260818-0002','13717034000','1550000','13715484000');
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-00005640','X-00005640','AT GYPSY POLOS LG 8K','GR','---','A1D','BELI','BELI001','915000','2026-08-18','0.950','1','admin','2026-08-18 14:55:54');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00005640','X-00005640');
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-260818-0003','F226291038111','RHM','1','BELI','BELI001','A1D', 'X-00005640', 'AT GYPSY POLOS LG 8K','0.950','0.950','100.00','1287000','915000','963158','1072000','1','915000','915000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.950',berat_beli_asli=berat_beli_asli+'0.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.950',berat_akhir_asli=berat_akhir_asli+'0.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260818-0003','2026-08-18','2026-08-18','14:55:54','RHM','---','0.950','915000','915000','915000','915000','915000','admin','2026-08-18 14:55:54','FB-260818-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260818-0003','HARIYANI','JL LETJEND SUTOYO KERTOSARI','','','','admin','2026-08-18 14:55:54');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-18' 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-260818-0020','K','2026-08-18','14:55:54','admin','PEMBELIAN UMUM','FB-260818-0003','13715484000','915000','13714569000');
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-00005641','X-00005641','GL X TIFF SPECTRA HITAM YT 8K','GR','---','F3E','BELI','BELI001','1045000','2026-08-18','1.040','1','admin','2026-08-18 14:55:54');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00005641','X-00005641');
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-260818-0004','F226051237281','RHM','2','BELI','BELI001','F3E', 'X-00005641', 'GL X TIFF SPECTRA HITAM YT 8K','1.040','1.040','100.00','1180000','1045000','1004808','1092000','1','1045000','1045000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.040',berat_beli_asli=berat_beli_asli+'1.040',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.040',berat_akhir_asli=berat_akhir_asli+'1.040',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260818-0004','2026-08-18','2026-08-18','14:55:54','RHM','---','1.040','1045000','1045000','1045000','1045000','1045000','admin','2026-08-18 14:55:54','FB-260818-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260818-0004','VIA','PUH IJO SAMPUNG','','','082223449142','admin','2026-08-18 14:55:54');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-18' 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-260818-0021','K','2026-08-18','14:55:54','admin','PEMBELIAN UMUM','FB-260818-0004','13714569000','1045000','13713524000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180110121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180110121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180110121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180135551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180135551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180135551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180204231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180204231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180204231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180204232' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180204232' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180204232';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180204233' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180204233' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180204233';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180204234' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180204234' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180204234';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180225181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180225181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180225181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180910371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180910371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180910371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180911131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180911131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180911131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180957271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180957271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180957271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181040241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181040241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181040241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181043341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181043341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181043341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181059291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181059291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181059291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181100401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181100401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181100401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181116291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181116291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181116291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181136241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181136241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181136241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181225471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181225471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181225471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181247221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181247221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181247221';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260818-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260818-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260818-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260818-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260818-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260818-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260818-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260818-0004';
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-00005642','X-00005642','KL X SANTA KH 44 9K','GR','---','H2I','BELI','BELI001','3190000','2026-08-18','2.960','1','admin','2026-08-18 15:37:59');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2I';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2I','X-00005642','X-00005642');
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-260818-0005','F226100307381','LUS','1','BELI','BELI001','H2I', 'X-00005642', 'KL X SANTA KH 44 9K','2.960','2.960','100.00','3478000','3190000','1077703','1172000','1','3190000','3190000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.960',berat_beli_asli=berat_beli_asli+'2.960',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.960',berat_akhir_asli=berat_akhir_asli+'2.960',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2I' 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-260818-0005','2026-08-18','2026-08-18','15:37:58','LUS','---','2.960','3190000','3190000','3190000','3190000','3190000','admin','2026-08-18 15:37:59','FB-260818-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260818-0005','SITI KURNIAWATI','SUKOSARI 1/1 DANYANG','','','085731114196','admin','2026-08-18 15:37:59');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-18' 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-260818-0022','K','2026-08-18','15:37:58','admin','PEMBELIAN UMUM','FB-260818-0005','13713524000','3190000','13710334000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260818-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260818-0005';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-08-19','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-07-19';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-08-18';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-08-18';
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-08-18' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-08-18';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-08-18';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-08-18';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-08-18';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202607 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
UPDATE tt_barang_saldo SET tanggal= '2026-08-19' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-08-18' 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-260819-0001','D','2026-08-19','16:02:00','SYSTEM','SALDO AWAL','SALDO AWAL','0','13710334000','13710334000');
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-260819-0001','D','2026-08-19','16:02:00','BCA','SALDO AWAL','SALDO AWAL','0','4729331888','4729331888');
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-260819-0001','D','2026-08-19','16:02:00','','SALDO AWAL','SALDO AWAL','0','3346000','3346000');
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-260819-0001','D','2026-08-19','16:02:00','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-260819-0001','D','2026-08-19','16:02:00','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-260819-0001','D','2026-08-19','16:02:00','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-08-19';