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 ('F226230910521','kasir','1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZBAH-54-T','LT SLOBOK BALOK HURUF BG S 8K ','OL','0.600','1','100.00','639000','0','0','15000','645000','0','5000','0','650000','TIN','T0077499','D1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZBAH-54-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='D1F-ZBAH-54-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226230910521','2026-07-23','0.600','2026-07-23','09:10:52','PLG0082473','645000','645000','5000','650000','650000','kasir','2026-07-23 09:10:52','F22623091052');
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-07-23','F226230910521','2026-07-23','09:10:52','TIN','650000','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-260723-0002','D','2026-07-23','09:10:52','kasir','PENJUALAN','F226230910521','12424017000','650000','12424667000');
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 ('F226230918121','kasir','1',' MIF4 KH ','TOKO','SMBK-F','F4I-YGBI-67-T','GL RANTAI HOLLOW KH 9K ','OL','6.020','1','100.00','6773000','0','0','15000','6803000','0','30000','0','6833000','LUS','T0071600','F4I','0','0','-','0','1125000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F4I-YGBI-67-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.020',berat_jual_asli=berat_jual_asli+'6.020',stock_jual='1',berat_akhir=berat_akhir-'6.020',berat_akhir_asli=berat_akhir_asli-'6.020',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='F4I-YGBI-67-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 ('F226230918121','2026-07-23','6.020','2026-07-23','09:18:13','PLG0082474','6803000','6803000','30000','6833000','6833000','kasir','2026-07-23 09:18:12','F22623091812');
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-07-23','F226230918121','2026-07-23','09:18:13','LUS','6833000','30000');
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-260723-0003','D','2026-07-23','09:18:13','kasir','PENJUALAN','F226230918121','12424667000','6833000','12431500000');
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 ('F226230919301','kasir','1',' MEF1E TD 5','TOKO','SMBK-F','F1E-ZGAH-65-T','GL OVAL C SLEP TD 52 8K ','OL','2.900','1','100.00','3030000','0','0','15000','3059000','0','15000','0','3074000','LUS','T0081370','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZGAH-65-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.900',berat_jual_asli=berat_jual_asli+'2.900',stock_jual='1',berat_akhir=berat_akhir-'2.900',berat_akhir_asli=berat_akhir_asli-'2.900',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='F1E-ZGAH-65-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 ('F226230919301','2026-07-23','2.900','2026-07-23','09:19:30','PLG0082475','3059000','3059000','15000','3074000','3074000','kasir','2026-07-23 09:19:30','F22623091930');
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-07-23','F226230919301','2026-07-23','09:19:30','LUS','3074000','15000');
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-260723-0004','D','2026-07-23','09:19:30','kasir','PENJUALAN','F226230919301','12431500000','3074000','12434574000');
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 ('F226230920191','kasir','1',' MFE1F KH 1','TOKO','SMBK-E','E1F-ZGBA-18-T','CC MODEL PAKU SLEP KH 12 8K ','OL','0.380','1','100.00','405000','0','0','15000','410000','0','5000','0','415000','LUS','T0081388','E1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGBA-18-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='E1F-ZGBA-18-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226230920191','2026-07-23','0.380','2026-07-23','09:20:20','PLG0082476','410000','410000','5000','415000','415000','kasir','2026-07-23 09:20:19','F22623092019');
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-07-23','F226230920191','2026-07-23','09:20:20','LUS','415000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260723-0005','D','2026-07-23','09:20:20','kasir','PENJUALAN','F226230920191','12434574000','415000','12434989000');
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 ('F226230920551','kasir','1',' MEH1E UB 4','TOKO','SMBK-H','H1E-ZGAA-34-T','KL MILANO UB 40 8K ','OL','2.070','1','100.00','2163000','0','0','15000','2174000','0','10000','0','2184000','LUS','T0081045','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGAA-34-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='H1E-ZGAA-34-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 ('F226230920551','2026-07-23','2.070','2026-07-23','09:20:55','PLG0082477','2174000','2174000','10000','2184000','2184000','kasir','2026-07-23 09:20:55','F22623092055');
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-07-23','F226230920551','2026-07-23','09:20:55','LUS','2184000','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-260723-0006','D','2026-07-23','09:20:55','kasir','PENJUALAN','F226230920551','12434989000','2184000','12437173000');
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 ('F226230924481','kasir','1',' MEE1 X CM ','TOKO','SMBK-E','E1E-ZGBA-240-0','CC X MODEL SLEP CM 14 8K ','OL','0.420','1','100.00','439000','0','0','15000','445000','0','5000','0','450000','DIN','00414722','E1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGBA-240-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.420',berat_jual_asli=berat_jual_asli+'0.420',stock_jual='1',berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='E1E-ZGBA-240-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 ('F226230924481','2026-07-23','0.420','2026-07-23','09:24:48','PLG0082478','445000','445000','5000','450000','450000','kasir','2026-07-23 09:24:48','F22623092448');
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-07-23','F226230924481','2026-07-23','09:24:48','DIN','450000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260723-0007','D','2026-07-23','09:24:48','kasir','PENJUALAN','F226230924481','12437173000','450000','12437623000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='450000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230924481' 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 ('F226230924482','kasir',' 1',' MDE1D LG 1','TOKO','SMBK-E','E1D-ZGAH-34-T','CC MODEL ISYANA SLEP LG 18 8K ','OL','1.080','1','100.00','1107000','0','0','15000','1118000','0','5000','0','1123000','DIN','T0081339','E1D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZGAH-34-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='E1D-ZGAH-34-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 ('F226230924482','2026-07-23','1.080','2026-07-23','09:24:48','PLG0082479','1118000','1118000','5000','1123000','1123000','kasir','2026-07-23 09:24:48','F22623092448');
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-07-23','F226230924482','2026-07-23','09:24:48','DIN','1123000','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-260723-0008','D','2026-07-23','09:24:48','kasir','PENJUALAN','F226230924482','12437623000','1123000','12438746000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1123000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230924482' 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 ('F226230924483','kasir',' 1',' MEA1E PM ','TOKO','SMBK-A','A1E-ZFAF-15-T','AT ITALY VAR SLEP PM 8K','OL','0.530','1','100.00','554000','0','0','15000','562000','0','5000','0','567000','DIN','T0080450','A1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZFAF-15-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='A1E-ZFAF-15-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226230924483','2026-07-23','0.530','2026-07-23','09:24:48','PLG0082480','562000','562000','5000','567000','567000','kasir','2026-07-23 09:24:48','F22623092448');
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-07-23','F226230924483','2026-07-23','09:24:48','DIN','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,status_valid) VALUES ('KM-260723-0009','D','2026-07-23','09:24:48','kasir','PENJUALAN','F226230924483','12438746000','567000','12439313000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='567000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230924483' 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 ('F226230924484','kasir',' 1',' MEF3E X UB','TOKO','SMBK-F','F3E-ZGBA-60-0','GL X GHENIA SLEP UB 8K ','OL','0.550','1','100.00','575000','0','0','15000','583000','0','5000','0','588000','DIN','00414542','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGBA-60-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='F3E-ZGBA-60-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226230924484','2026-07-23','0.550','2026-07-23','09:24:48','PLG0082481','583000','583000','5000','588000','588000','kasir','2026-07-23 09:24:48','F22623092448');
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-07-23','F226230924484','2026-07-23','09:24:48','DIN','588000','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-260723-0010','D','2026-07-23','09:24:48','kasir','PENJUALAN','F226230924484','12439313000','588000','12439901000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='588000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230924484' 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 ('F226230948151','kasir','1',' MEA1E X CM','TOKO','SMBK-A','A1E-ZGAG-22-0','AT X GYPSY SLEP CM 8K ','OL','0.500','1','100.00','522000','0','0','15000','530000','0','5000','0','535000','LUS','00413858','A1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZGAG-22-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='A1E-ZGAG-22-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 ('F226230948151','2026-07-23','0.500','2026-07-23','09:48:16','PLG0082482','530000','530000','5000','535000','535000','kasir','2026-07-23 09:48:15','F22623094815');
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-07-23','F226230948151','2026-07-23','09:48:16','LUS','535000','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-260723-0011','D','2026-07-23','09:48:16','kasir','PENJUALAN','F226230948151','12439901000','535000','12440436000');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260723-0001','1','D2E-ZGAG-76-0','1','0.600','0.600','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D2E-ZGAG-76-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-ZGAG-76-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-07-23 10:06:32' WHERE kode_barang='D2E-ZGAG-76-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-ZGAG-76-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-23 10:06:32','TOKO','SMBK-D','D2E','D2E-ZGAG-76-0','1','0.600','0.600','1','0.600','0.600','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D2E-ZGAG-76-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2E-ZGAG-76-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260723-0001','2026-07-23','10:06','0.600','input','2026-07-23 10:06:31');
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 ('F226231009281','kasir','1',' MED2E X LG','TOKO','SMBK-D','D2E-ZGAG-76-0','LT X MODEL HURUF MATA LG A 8K ','OLS 9VYE5','0.600','1','100.00','627000','0','0','15000','666000','0','102000','0','768000','DIN','00413912','D2E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZGAG-76-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='D2E-ZGAG-76-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 ('F226231009281','2026-07-23','0.600','2026-07-23','10:09:28','PLG0082483','666000','666000','102000','768000','768000','kasir','2026-07-23 10:09:28','F22623100928');
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-07-23','F226231009281','2026-07-23','10:09:28','DIN','768000','102000');
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-260723-0012','D','2026-07-23','10:09:28','kasir','PENJUALAN','F226231009281','12440436000','768000','12441204000');
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 ('F226231013241','kasir','1',' MEF3E X HW','TOKO','SMBK-F','F3E-YLAG-91-0','GL X SANTA MATA VAR HW 8K ','OL','1.850','1','100.00','1933000','0','0','15000','1943000','0','9000','0','1952000','TIN','00381445','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLAG-91-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.850',berat_jual_asli=berat_jual_asli+'1.850',stock_jual='1',berat_akhir=berat_akhir-'1.850',berat_akhir_asli=berat_akhir_asli-'1.850',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='F3E-YLAG-91-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226231013241','2026-07-23','1.850','2026-07-23','10:13:25','PLG0082484','1943000','1943000','9000','1952000','1952000','kasir','2026-07-23 10:13:24','F22623101324');
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-07-23','F226231013241','2026-07-23','10:13:25','TIN','1952000','9000');
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-260723-0013','D','2026-07-23','10:13:25','kasir','PENJUALAN','F226231013241','12441204000','1952000','12443156000');
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 ('F226231014551','kasir','1',' MEF3E UB ','TOKO','SMBK-F','F3E-ZGAG-70-T','GL LONGLING SLEP UB 8K ','OL','1.000','1','100.00','1045000','0','0','15000','1050000','0','5000','0','1055000','LUS','T0081293','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGAG-70-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='F3E-ZGAG-70-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 ('F226231014551','2026-07-23','1.000','2026-07-23','10:14:55','PLG0082485','1050000','1050000','5000','1055000','1055000','kasir','2026-07-23 10:14:55','F22623101455');
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-07-23','F226231014551','2026-07-23','10:14:55','LUS','1055000','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-260723-0014','D','2026-07-23','10:14:55','kasir','PENJUALAN','F226231014551','12443156000','1055000','12444211000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1055000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226231014551' 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 ('F226231014552','kasir',' 1',' MFD1F X BG','TOKO','SMBK-D','D1F-YHBB-26-0','LT X SLOBOK BALOK HURUF BG F 8K ','OL','0.540','1','100.00','575000','0','0','15000','581000','0','5000','0','586000','LUS','00366639','D1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YHBB-26-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.540',berat_jual_asli=berat_jual_asli+'0.540',stock_jual='1',berat_akhir=berat_akhir-'0.540',berat_akhir_asli=berat_akhir_asli-'0.540',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='D1F-YHBB-26-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 ('F226231014552','2026-07-23','0.540','2026-07-23','10:14:55','PLG0082486','581000','581000','5000','586000','586000','kasir','2026-07-23 10:14:55','F22623101455');
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-07-23','F226231014552','2026-07-23','10:14:55','LUS','586000','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-260723-0015','D','2026-07-23','10:14:55','kasir','PENJUALAN','F226231014552','12444211000','586000','12444797000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='586000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226231014552' 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 ('F226231035381','kasir','1',' MFB1F X LG','TOKO','SMBK-B','B1F-ZGBX-250-0','GW X TUSUK MRICAN SLEP LG 8K ','OL','0.320','1','100.00','341000','0','0','15000','345000','0','5000','0','350000','LUS','00414451','B1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-ZGBX-250-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.320',berat_jual_asli=berat_jual_asli+'0.320',stock_jual='1',berat_akhir=berat_akhir-'0.320',berat_akhir_asli=berat_akhir_asli-'0.320',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='B1F-ZGBX-250-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 ('F226231035381','2026-07-23','0.320','2026-07-23','10:35:39','PLG0082487','345000','345000','5000','350000','350000','kasir','2026-07-23 10:35:38','F22623103538');
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-07-23','F226231035381','2026-07-23','10:35:39','LUS','350000','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-260723-0016','D','2026-07-23','10:35:39','kasir','PENJUALAN','F226231035381','12444797000','350000','12445147000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='350000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226231035381' 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 ('F226231035382','kasir',' 1',' MEF3E X LG','TOKO','SMBK-F','F3E-ZFCX-217-0','GL X TIFF DAUN VAR SERUT LG 8K ','OL','2.060','1','100.00','2153000','0','0','15000','2163000','0','10000','0','2173000','LUS','00411424','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFCX-217-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.060',berat_jual_asli=berat_jual_asli+'2.060',stock_jual='1',berat_akhir=berat_akhir-'2.060',berat_akhir_asli=berat_akhir_asli-'2.060',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='F3E-ZFCX-217-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226231035382','2026-07-23','2.060','2026-07-23','10:35:39','PLG0082488','2163000','2163000','10000','2173000','2173000','kasir','2026-07-23 10:35:38','F22623103538');
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-07-23','F226231035382','2026-07-23','10:35:39','LUS','2173000','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-260723-0017','D','2026-07-23','10:35:39','kasir','PENJUALAN','F226231035382','12445147000','2173000','12447320000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2173000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226231035382' 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 ('F226231039311','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZFAH-182-0','CC X MODEL MATA CM 14 8K','OL','0.940','1','100.00','963000','0','0','15000','978000','0','5000','0','983000','LUS','00409189','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFAH-182-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.940',berat_jual_asli=berat_jual_asli+'0.940',stock_jual='1',berat_akhir=berat_akhir-'0.940',berat_akhir_asli=berat_akhir_asli-'0.940',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='E2D-ZFAH-182-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 ('F226231039311','2026-07-23','0.940','2026-07-23','10:39:32','PLG0082489','978000','978000','5000','983000','983000','kasir','2026-07-23 10:39:31','F22623103931');
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-07-23','F226231039311','2026-07-23','10:39:32','LUS','983000','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-260723-0018','D','2026-07-23','10:39:32','kasir','PENJUALAN','F226231039311','12447320000','983000','12448303000');
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 ('F226231121371','kasir','1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZGXB-63-T','CC MDOEL ISYANA SLEP LG 14 8K ','OL','0.530','1','100.00','554000','0','0','15000','559000','0','5000','0','564000','DIN','T0080891','E1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGXB-63-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='E1E-ZGXB-63-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 ('F226231121371','2026-07-23','0.530','2026-07-23','11:21:37','PLG0082490','559000','559000','5000','564000','564000','kasir','2026-07-23 11:21:37','F22623112137');
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-07-23','F226231121371','2026-07-23','11:21:37','DIN','564000','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-260723-0019','D','2026-07-23','11:21:37','kasir','PENJUALAN','F226231121371','12448303000','564000','12448867000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='564000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226231121371' 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 ('F226231121372','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZGAH-23-T','CC MODEL PITA PASIR SLEP CM 12 8K ','OL','0.700','1','100.00','731000','0','0','15000','739000','0','5000','0','744000','DIN','T0081328','E1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGAH-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.700',berat_jual_asli=berat_jual_asli+'0.700',stock_jual='1',berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='E1E-ZGAH-23-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226231121372','2026-07-23','0.700','2026-07-23','11:21:37','PLG0082491','739000','739000','5000','744000','744000','kasir','2026-07-23 11:21:37','F22623112137');
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-07-23','F226231121372','2026-07-23','11:21:37','DIN','744000','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-260723-0020','D','2026-07-23','11:21:37','kasir','PENJUALAN','F226231121372','12448867000','744000','12449611000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='744000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226231121372' 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 ('F226231121373','kasir',' 1',' MDE1 5K CM','TOKO','SMBK-E','E1D-ZGAH-25-T','CC MODEL PITA PASIR SLEP CM 16 8K ','OL','0.820','1','100.00','840000','0','0','15000','849000','0','5000','0','854000','DIN','T0081330','E1D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZGAH-25-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.820',berat_jual_asli=berat_jual_asli+'0.820',stock_jual='1',berat_akhir=berat_akhir-'0.820',berat_akhir_asli=berat_akhir_asli-'0.820',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='E1D-ZGAH-25-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 ('F226231121373','2026-07-23','0.820','2026-07-23','11:21:37','PLG0082492','849000','849000','5000','854000','854000','kasir','2026-07-23 11:21:37','F22623112137');
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-07-23','F226231121373','2026-07-23','11:21:37','DIN','854000','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-260723-0021','D','2026-07-23','11:21:37','kasir','PENJUALAN','F226231121373','12449611000','854000','12450465000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='854000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226231121373' 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 ('F226231142521','kasir','1',' MEF3E X HW','TOKO','SMBK-F','F3E-ZGXI-121-0','GL X CASTELI SPECTRA VAR SLEP HW 8K ','','2.270','1','100.00','2372000','0','0','15000','2372000','0','0','0','2372000','LUS','00412840','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGXI-121-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.270',berat_jual_asli=berat_jual_asli+'2.270',stock_jual='1',berat_akhir=berat_akhir-'2.270',berat_akhir_asli=berat_akhir_asli-'2.270',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='F3E-ZGXI-121-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226231142521','2026-07-23','2.270','2026-07-23','11:42:52','PLG0082493','2372000','2372000','0','2372000','2372000','kasir','2026-07-23 11:42:52','F22623114252');
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-07-23','F226231142521','2026-07-23','11:42:52','LUS','2372000','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-260723-0022','D','2026-07-23','11:42:52','kasir','PENJUALAN','F226231142521','12450465000','2372000','12452837000');
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 ('F226231149391','kasir','1',' MEF3 13K L','TOKO','SMBK-F','F3E-ZGAD-31-T','GL MODEL PAJERO SLEP LG 8K ','OL','2.510','1','100.00','2623000','0','0','15000','2635000','0','13000','0','2648000','DIN','T0081108','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGAD-31-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.510',berat_jual_asli=berat_jual_asli+'2.510',stock_jual='1',berat_akhir=berat_akhir-'2.510',berat_akhir_asli=berat_akhir_asli-'2.510',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='F3E-ZGAD-31-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 ('F226231149391','2026-07-23','2.510','2026-07-23','11:49:40','PLG0082494','2635000','2635000','13000','2648000','2648000','kasir','2026-07-23 11:49:39','F22623114939');
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-07-23','F226231149391','2026-07-23','11:49:40','DIN','2648000','13000');
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-260723-0023','D','2026-07-23','11:49:40','kasir','PENJUALAN','F226231149391','12452837000','2648000','12455485000');
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 ('F226231215361','kasir','1',' MEA1E X LG','TOKO','SMBK-A','A1E-ZGBX-224-0','AT X DAISY LG 8K ','OL','0.500','1','100.00','522000','0','0','15000','528000','0','5000','0','533000','LUS','00414425','A1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZGBX-224-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='A1E-ZGBX-224-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 ('F226231215361','2026-07-23','0.500','2026-07-23','12:15:37','PLG0082495','528000','528000','5000','533000','533000','kasir','2026-07-23 12:15:36','F22623121536');
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-07-23','F226231215361','2026-07-23','12:15:37','LUS','533000','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-260723-0024','D','2026-07-23','12:15:37','kasir','PENJUALAN','F226231215361','12455485000','533000','12456018000');
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 ('F226231216231','kasir','1',' MEA1E X PM','TOKO','SMBK-A','A1E-ZFXH-38-0','AT X ITALY SLEP VAR PM 8K ','OL','0.530','1','100.00','554000','0','0','15000','560000','0','5000','0','565000','LUS','00407899','A1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZFXH-38-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-07-23' AND kode_barang='A1E-ZFXH-38-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 ('F226231216231','2026-07-23','0.530','2026-07-23','12:16:24','PLG0082496','560000','560000','5000','565000','565000','kasir','2026-07-23 12:16:23','F22623121623');
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-07-23','F226231216231','2026-07-23','12:16:24','LUS','565000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260723-0025','D','2026-07-23','12:16:24','kasir','PENJUALAN','F226231216231','12456018000','565000','12456583000');
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 ('F226230100181','kasir','1',' TDE2 X CM ','TOKO','TBK-E','E2TD-ZDXD-142-T','CC X MODEL SOLITAIRE MATA CM 16 17K','OL','2.160','1','100.00','4082000','0','0','15000','4121000','0','15000','0','4136000','DIN','T0078429','E2TD','0','0','-','0','1890000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-ZDXD-142-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.160',berat_jual_asli=berat_jual_asli+'2.160',stock_jual='1',berat_akhir=berat_akhir-'2.160',berat_akhir_asli=berat_akhir_asli-'2.160',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='E2TD-ZDXD-142-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 ('F226230100181','2026-07-23','2.160','2026-07-23','13:00:18','PLG0082497','4121000','4121000','15000','4136000','4136000','kasir','2026-07-23 13:00:18','F22623010018');
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-07-23','F226230100181','2026-07-23','13:00:18','DIN','4136000','15000');
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-260723-0026','D','2026-07-23','13:00:18','kasir','PENJUALAN','F226230100181','12456583000','4136000','12460719000');
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 ('F226230105561','kasir','1',' MFE1F KH 1','TOKO','SMBK-E','E1F-ZGBA-13-T','CC MODEL PAKU SLEP KH 10 8K ','OL','0.380','1','100.00','405000','0','0','15000','410000','0','5000','0','415000','DIN','T0081383','E1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGBA-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='E1F-ZGBA-13-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 ('F226230105561','2026-07-23','0.380','2026-07-23','13:05:56','PLG0082498','410000','410000','5000','415000','415000','kasir','2026-07-23 13:05:56','F22623010556');
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-07-23','F226230105561','2026-07-23','13:05:56','DIN','415000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260723-0027','D','2026-07-23','13:05:56','kasir','PENJUALAN','F226230105561','12460719000','415000','12461134000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='415000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230105561' 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 ('F226230105562','kasir',' 1',' MFE1F KH 1','TOKO','SMBK-E','E1F-ZGBA-23-T','CC MODEL PAKU SLEP KH 14 8K ','OL','0.400','1','100.00','426000','0','0','15000','432000','0','5000','0','437000','DIN','T0081393','E1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGBA-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='E1F-ZGBA-23-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226230105562','2026-07-23','0.400','2026-07-23','13:05:56','PLG0082499','432000','432000','5000','437000','437000','kasir','2026-07-23 13:05:56','F22623010556');
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-07-23','F226230105562','2026-07-23','13:05:56','DIN','437000','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-260723-0028','D','2026-07-23','13:05:56','kasir','PENJUALAN','F226230105562','12461134000','437000','12461571000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='437000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230105562' 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 ('F226230105563','kasir',' 1',' MEE1E KH 1','TOKO','SMBK-E','E1E-ZGBA-24-T','CC MODEL PAKU SLEP KH 14 8K ','OL','0.420','1','100.00','439000','0','0','15000','445000','0','5000','0','450000','DIN','T0081394','E1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGBA-24-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.420',berat_jual_asli=berat_jual_asli+'0.420',stock_jual='1',berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='E1E-ZGBA-24-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 ('F226230105563','2026-07-23','0.420','2026-07-23','13:05:56','PLG0082500','445000','445000','5000','450000','450000','kasir','2026-07-23 13:05:56','F22623010556');
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-07-23','F226230105563','2026-07-23','13:05:56','DIN','450000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260723-0029','D','2026-07-23','13:05:56','kasir','PENJUALAN','F226230105563','12461571000','450000','12462021000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='450000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230105563' 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 ('F226230105564','kasir',' 1',' MEE2 X HW ','TOKO','SMBK-E','E2E-ZGBA-231-0','CC X MODEL MATA HW 13 8K ','OL','0.430','1','100.00','449000','0','0','15000','456000','0','5000','0','461000','DIN','00414713','E2E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZGBA-231-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.430',berat_jual_asli=berat_jual_asli+'0.430',stock_jual='1',berat_akhir=berat_akhir-'0.430',berat_akhir_asli=berat_akhir_asli-'0.430',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='E2E-ZGBA-231-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 ('F226230105564','2026-07-23','0.430','2026-07-23','13:05:56','PLG0082501','456000','456000','5000','461000','461000','kasir','2026-07-23 13:05:56','F22623010556');
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-07-23','F226230105564','2026-07-23','13:05:56','DIN','461000','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-260723-0030','D','2026-07-23','13:05:56','kasir','PENJUALAN','F226230105564','12462021000','461000','12462482000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='461000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230105564' 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 ('F226230105565','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZGAH-20-T','CC MODEL PITA PASIR SLEP CM 14 8K ','OL','0.630','1','100.00','658000','0','0','15000','668000','0','5000','0','673000','DIN','T0081325','E1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGAH-20-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='2026-07-23' AND kode_barang='E1E-ZGAH-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 ('F226230105565','2026-07-23','0.630','2026-07-23','13:05:56','PLG0082502','668000','668000','5000','673000','673000','kasir','2026-07-23 13:05:56','F22623010556');
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-07-23','F226230105565','2026-07-23','13:05:56','DIN','673000','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-260723-0031','D','2026-07-23','13:05:56','kasir','PENJUALAN','F226230105565','12462482000','673000','12463155000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='673000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230105565' 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 ('F226230105566','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZGAH-22-T','CC MODEL PITA PASIR SLEP CM 12 8K ','OL','0.720','1','100.00','752000','0','0','15000','763000','0','5000','0','768000','DIN','T0081327','E1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGAH-22-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.720',berat_jual_asli=berat_jual_asli+'0.720',stock_jual='1',berat_akhir=berat_akhir-'0.720',berat_akhir_asli=berat_akhir_asli-'0.720',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='E1E-ZGAH-22-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 ('F226230105566','2026-07-23','0.720','2026-07-23','13:05:56','PLG0082503','763000','763000','5000','768000','768000','kasir','2026-07-23 13:05:56','F22623010556');
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-07-23','F226230105566','2026-07-23','13:05:56','DIN','768000','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-260723-0032','D','2026-07-23','13:05:56','kasir','PENJUALAN','F226230105566','12463155000','768000','12463923000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='768000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230105566' 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 ('F226230105567','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZGAH-21-T','CC MODEL PITA PASIR SLEP CM 12 8K ','OL','0.750','1','100.00','784000','0','0','15000','795000','0','5000','0','800000','DIN','T0081326','E1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGAH-21-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='E1E-ZGAH-21-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226230105567','2026-07-23','0.750','2026-07-23','13:05:56','PLG0082504','795000','795000','5000','800000','800000','kasir','2026-07-23 13:05:56','F22623010556');
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-07-23','F226230105567','2026-07-23','13:05:56','DIN','800000','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-260723-0033','D','2026-07-23','13:05:56','kasir','PENJUALAN','F226230105567','12463923000','800000','12464723000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='800000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230105567' 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 ('F226230105568','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZGAH-19-T','CC MODEL PITA PASIR SLEP CM 14 8K ','OL','0.770','1','100.00','805000','0','0','15000','816000','0','5000','0','821000','DIN','T0081324','E1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGAH-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.770',berat_jual_asli=berat_jual_asli+'0.770',stock_jual='1',berat_akhir=berat_akhir-'0.770',berat_akhir_asli=berat_akhir_asli-'0.770',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='E1E-ZGAH-19-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 ('F226230105568','2026-07-23','0.770','2026-07-23','13:05:56','PLG0082505','816000','816000','5000','821000','821000','kasir','2026-07-23 13:05:56','F22623010556');
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-07-23','F226230105568','2026-07-23','13:05:56','DIN','821000','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-260723-0034','D','2026-07-23','13:05:56','kasir','PENJUALAN','F226230105568','12464723000','821000','12465544000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='821000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230105568' 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 ('F226230109341','kasir','1',' MEH1E UB 4','TOKO','SMBK-H','H1E-ZGAX-39-0','KL KOREA UB 46 8K ','OL','1.000','1','100.00','1045000','0','0','15000','1055000','0','5000','0','1060000','DIN','00413115','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGAX-39-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-07-23' AND kode_barang='H1E-ZGAX-39-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226230109341','2026-07-23','1.000','2026-07-23','13:09:34','PLG0082506','1055000','1055000','5000','1060000','1060000','kasir','2026-07-23 13:09:34','F22623010934');
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-07-23','F226230109341','2026-07-23','13:09:34','DIN','1060000','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-260723-0035','D','2026-07-23','13:09:34','kasir','PENJUALAN','F226230109341','12465544000','1060000','12466604000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1060000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230109341' 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 ('F226230109342','kasir',' 1',' MEH1E UB 4','TOKO','SMBK-H','H1E-ZGXB-114-T','KL NORI UB 46 8K ','OL','0.970','1','100.00','1014000','0','0','15000','1028000','0','5000','0','1033000','DIN','T0080942','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGXB-114-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='H1E-ZGXB-114-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 ('F226230109342','2026-07-23','0.970','2026-07-23','13:09:34','PLG0082507','1028000','1028000','5000','1033000','1033000','kasir','2026-07-23 13:09:34','F22623010934');
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-07-23','F226230109342','2026-07-23','13:09:34','DIN','1033000','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-260723-0036','D','2026-07-23','13:09:34','kasir','PENJUALAN','F226230109342','12466604000','1033000','12467637000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1033000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230109342' 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 ('F226230109343','kasir',' 1',' MEH1E KH 4','TOKO','SMBK-H','H1E-ZGBA-42-T','KL RANTAI HOLLOW VAR KH 42 8K ','OL','1.850','1','100.00','1933000','0','0','15000','1952000','0','9000','0','1961000','DIN','T0081412','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGBA-42-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.850',berat_jual_asli=berat_jual_asli+'1.850',stock_jual='1',berat_akhir=berat_akhir-'1.850',berat_akhir_asli=berat_akhir_asli-'1.850',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='H1E-ZGBA-42-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 ('F226230109343','2026-07-23','1.850','2026-07-23','13:09:34','PLG0082508','1952000','1952000','9000','1961000','1961000','kasir','2026-07-23 13:09:34','F22623010934');
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-07-23','F226230109343','2026-07-23','13:09:34','DIN','1961000','9000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260723-0037','D','2026-07-23','13:09:34','kasir','PENJUALAN','F226230109343','12467637000','1961000','12469598000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1961000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230109343' 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 ('F226230109344','kasir',' 1',' MEF1 X TD ','TOKO','SMBK-F','F1E-ZGAG-161-0','GL X BANGKOK C ANAK TD 42 8K ','OL','2.050','1','100.00','2142000','0','0','15000','2163000','0','10000','0','2173000','DIN','00413997','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZGAG-161-0' 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-07-23' AND kode_barang='F1E-ZGAG-161-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226230109344','2026-07-23','2.050','2026-07-23','13:09:34','PLG0082509','2163000','2163000','10000','2173000','2173000','kasir','2026-07-23 13:09:34','F22623010934');
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-07-23','F226230109344','2026-07-23','13:09:34','DIN','2173000','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-260723-0038','D','2026-07-23','13:09:34','kasir','PENJUALAN','F226230109344','12469598000','2173000','12471771000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2173000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230109344' 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 ('F226230109345','kasir',' 1',' MEF1E UB 6','TOKO','SMBK-F','F1E-ZGAH-63-T','GL OVAL C SLEP UB 60 8K ','OL','2.630','1','100.00','2748000','0','0','15000','2775000','0','13000','0','2788000','DIN','T0081368','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZGAH-63-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.630',berat_jual_asli=berat_jual_asli+'2.630',stock_jual='1',berat_akhir=berat_akhir-'2.630',berat_akhir_asli=berat_akhir_asli-'2.630',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='F1E-ZGAH-63-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 ('F226230109345','2026-07-23','2.630','2026-07-23','13:09:34','PLG0082510','2775000','2775000','13000','2788000','2788000','kasir','2026-07-23 13:09:34','F22623010934');
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-07-23','F226230109345','2026-07-23','13:09:34','DIN','2788000','13000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260723-0039','D','2026-07-23','13:09:34','kasir','PENJUALAN','F226230109345','12471771000','2788000','12474559000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2788000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230109345' 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 ('F226230109346','kasir',' 1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZGAH-51-T','LT SLOBOK BULAT HURUF BG H 8K ','OL','0.450','1','100.00','479000','0','0','15000','486000','0','5000','0','491000','DIN','T0081356','D1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZGAH-51-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='D1F-ZGAH-51-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226230109346','2026-07-23','0.450','2026-07-23','13:09:34','PLG0082511','486000','486000','5000','491000','491000','kasir','2026-07-23 13:09:34','F22623010934');
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-07-23','F226230109346','2026-07-23','13:09:34','DIN','491000','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-260723-0040','D','2026-07-23','13:09:34','kasir','PENJUALAN','F226230109346','12474559000','491000','12475050000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='491000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230109346' 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 ('F226230109347','kasir',' 1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZGAE-23-T','LT SLOBOK BALOK HURUF BG S 8K ','OL','0.630','1','100.00','671000','0','0','15000','680000','0','5000','0','685000','DIN','T0081168','D1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZGAE-23-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='2026-07-23' AND kode_barang='D1F-ZGAE-23-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 ('F226230109347','2026-07-23','0.630','2026-07-23','13:09:34','PLG0082512','680000','680000','5000','685000','685000','kasir','2026-07-23 13:09:34','F22623010934');
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-07-23','F226230109347','2026-07-23','13:09:34','DIN','685000','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-260723-0041','D','2026-07-23','13:09:34','kasir','PENJUALAN','F226230109347','12475050000','685000','12475735000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='685000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230109347' 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 ('F226230109348','kasir',' 1',' MED1E 5K L','TOKO','SMBK-D','D1E-ZFBE-82-T','LT MODEL APEL CAT HITAM SLEP LG 8K ','OL','0.560','1','100.00','585000','0','0','15000','594000','0','5000','0','599000','DIN','T0080824','D1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZFBE-82-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-07-23' AND kode_barang='D1E-ZFBE-82-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 ('F226230109348','2026-07-23','0.560','2026-07-23','13:09:34','PLG0082513','594000','594000','5000','599000','599000','kasir','2026-07-23 13:09:34','F22623010934');
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-07-23','F226230109348','2026-07-23','13:09:34','DIN','599000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260723-0042','D','2026-07-23','13:09:34','kasir','PENJUALAN','F226230109348','12475735000','599000','12476334000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='599000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230109348' 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 ('F226230149271','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZGXA-115-0','CC X SOLITAIRE MATA CM 12 8K ','OL','0.930','1','100.00','953000','0','0','15000','963000','0','5000','0','968000','LUS','00411639','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGXA-115-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.930',berat_jual_asli=berat_jual_asli+'0.930',stock_jual='1',berat_akhir=berat_akhir-'0.930',berat_akhir_asli=berat_akhir_asli-'0.930',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='E2D-ZGXA-115-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 ('F226230149271','2026-07-23','0.930','2026-07-23','13:49:28','PLG0082514','963000','963000','5000','968000','968000','kasir','2026-07-23 13:49:27','F22623014927');
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-07-23','F226230149271','2026-07-23','13:49:28','LUS','968000','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-260723-0043','D','2026-07-23','13:49:28','kasir','PENJUALAN','F226230149271','12476334000','968000','12477302000');
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 ('F226230154431','kasir','1',' MEB1E CM P','TOKO','SMBK-B','B1E-ZGBA-2-T','GW MODEL SLEP CM PE 8K ','OL','0.520','1','100.00','543000','0','0','15000','549000','0','5000','0','554000','TIN','T0081372','B1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZGBA-2-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-07-23' AND kode_barang='B1E-ZGBA-2-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 ('F226230154431','2026-07-23','0.520','2026-07-23','13:54:44','PLG0082515','549000','549000','5000','554000','554000','kasir','2026-07-23 13:54:43','F22623015443');
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-07-23','F226230154431','2026-07-23','13:54:44','TIN','554000','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-260723-0044','D','2026-07-23','13:54:44','kasir','PENJUALAN','F226230154431','12477302000','554000','12477856000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='554000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230154431' 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 ('F226230154432','kasir',' 1',' MEB1E CM P','TOKO','SMBK-B','B1E-ZGBA-1-T','GW MODEL SLEP CM PE 8K ','OL','0.520','1','100.00','543000','0','0','15000','549000','0','5000','0','554000','TIN','T0081371','B1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZGBA-1-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-07-23' AND kode_barang='B1E-ZGBA-1-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 ('F226230154432','2026-07-23','0.520','2026-07-23','13:54:44','PLG0082516','549000','549000','5000','554000','554000','kasir','2026-07-23 13:54:43','F22623015443');
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-07-23','F226230154432','2026-07-23','13:54:44','TIN','554000','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-260723-0045','D','2026-07-23','13:54:44','kasir','PENJUALAN','F226230154432','12477856000','554000','12478410000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='554000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230154432' 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 ('F226230154433','kasir',' 1',' MEB1 X CM ','TOKO','SMBK-B','B1E-ZGBX-247-0','GW X MODEL SLEP CM 8K PE ','OL','0.600','1','100.00','627000','0','0','15000','633000','0','5000','0','638000','TIN','00414448','B1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZGBX-247-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='B1E-ZGBX-247-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 ('F226230154433','2026-07-23','0.600','2026-07-23','13:54:44','PLG0082517','633000','633000','5000','638000','638000','kasir','2026-07-23 13:54:43','F22623015443');
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-07-23','F226230154433','2026-07-23','13:54:44','TIN','638000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260723-0046','D','2026-07-23','13:54:44','kasir','PENJUALAN','F226230154433','12478410000','638000','12479048000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='638000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230154433' 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 ('F226230154434','kasir',' 1',' MDB1 X HW ','TOKO','SMBK-B','B1D-ZGBX-246-0','GW X MODEL SLEP HW 8K ','OL','1.060','1','100.00','1086000','0','0','15000','1092000','0','5000','0','1097000','TIN','00414447','B1D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-ZGBX-246-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='B1D-ZGBX-246-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 ('F226230154434','2026-07-23','1.060','2026-07-23','13:54:44','PLG0082518','1092000','1092000','5000','1097000','1097000','kasir','2026-07-23 13:54:43','F22623015443');
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-07-23','F226230154434','2026-07-23','13:54:44','TIN','1097000','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-260723-0047','D','2026-07-23','13:54:44','kasir','PENJUALAN','F226230154434','12479048000','1097000','12480145000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1097000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230154434' 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 ('F226230154435','kasir',' 1',' MFD1F 5K B','TOKO','SMBK-D','D1F-ZGBA-5-T','LT CHARM BULAN BINTANG SLEP BG 8K ','OL','0.500','1','100.00','532000','0','0','15000','538000','0','5000','0','543000','TIN','T0081375','D1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZGBA-5-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-07-23' AND kode_barang='D1F-ZGBA-5-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226230154435','2026-07-23','0.500','2026-07-23','13:54:44','PLG0082519','538000','538000','5000','543000','543000','kasir','2026-07-23 13:54:43','F22623015443');
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-07-23','F226230154435','2026-07-23','13:54:44','TIN','543000','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-260723-0048','D','2026-07-23','13:54:44','kasir','PENJUALAN','F226230154435','12480145000','543000','12480688000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='543000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230154435' 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 ('F226230154436','kasir',' 1',' MFD1F 5K B','TOKO','SMBK-D','D1F-ZGBA-6-T','LT CHARM BULAN BINTANG SLEP BG 8K ','OL','0.510','1','100.00','543000','0','0','15000','548000','0','5000','0','553000','TIN','T0081376','D1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZGBA-6-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-07-23' AND kode_barang='D1F-ZGBA-6-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226230154436','2026-07-23','0.510','2026-07-23','13:54:44','PLG0082520','548000','548000','5000','553000','553000','kasir','2026-07-23 13:54:43','F22623015443');
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-07-23','F226230154436','2026-07-23','13:54:44','TIN','553000','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-260723-0049','D','2026-07-23','13:54:44','kasir','PENJUALAN','F226230154436','12480688000','553000','12481241000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='553000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230154436' 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 ('F226230154437','kasir',' 1',' MEE2 X CM ','TOKO','SMBK-E','E2D-ZGBA-228-0','CC X MODEL MATA CM 12 8K','OL','0.660','1','100.00','676000','0','0','15000','696000','0','5000','0','701000','TIN','00414710','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGBA-228-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.660',berat_jual_asli=berat_jual_asli+'0.660',stock_jual='1',berat_akhir=berat_akhir-'0.660',berat_akhir_asli=berat_akhir_asli-'0.660',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='E2D-ZGBA-228-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 ('F226230154437','2026-07-23','0.660','2026-07-23','13:54:44','PLG0082521','696000','696000','5000','701000','701000','kasir','2026-07-23 13:54:43','F22623015443');
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-07-23','F226230154437','2026-07-23','13:54:44','TIN','701000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260723-0050','D','2026-07-23','13:54:44','kasir','PENJUALAN','F226230154437','12481241000','701000','12481942000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='701000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230154437' 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 ('F226230154438','kasir',' 1',' MEH1 X KH ','TOKO','SMBK-H','H1E-ZGXG-186-0','KL X SIEM COBRA KH 44 8K ','OL','1.230','1','100.00','1285000','0','0','15000','1292000','0','6000','0','1298000','TIN','00412587','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGXG-186-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.230',berat_jual_asli=berat_jual_asli+'1.230',stock_jual='1',berat_akhir=berat_akhir-'1.230',berat_akhir_asli=berat_akhir_asli-'1.230',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='H1E-ZGXG-186-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226230154438','2026-07-23','1.230','2026-07-23','13:54:44','PLG0082522','1292000','1292000','6000','1298000','1298000','kasir','2026-07-23 13:54:43','F22623015443');
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-07-23','F226230154438','2026-07-23','13:54:44','TIN','1298000','6000');
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-260723-0051','D','2026-07-23','13:54:44','kasir','PENJUALAN','F226230154438','12481942000','1298000','12483240000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1298000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230154438' 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 ('F226230155261','kasir','1',' MEA1E CM ','TOKO','SMBK-A','A1E-ZFBC-7-T','AT MODEL SLEP CM 8K ','OL','0.630','1','100.00','658000','0','0','15000','665000','0','5000','0','670000','TIN','T0080616','A1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZFBC-7-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='2026-07-23' AND kode_barang='A1E-ZFBC-7-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226230155261','2026-07-23','0.630','2026-07-23','13:55:26','PLG0082523','665000','665000','5000','670000','670000','kasir','2026-07-23 13:55:26','F22623015526');
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-07-23','F226230155261','2026-07-23','13:55:26','TIN','670000','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-260723-0052','D','2026-07-23','13:55:26','kasir','PENJUALAN','F226230155261','12483240000','670000','12483910000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='670000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230155261' 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 ('F226230155262','kasir',' 1',' MDA1D LG ','TOKO','SMBK-A','A1D-ZGAD-39-T','AT HUGGIES VAR SLEP LG 8K ','OL','1.070','1','100.00','1097000','0','0','15000','1102000','0','5000','0','1107000','TIN','T0081116','A1D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZGAD-39-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='A1D-ZGAD-39-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226230155262','2026-07-23','1.070','2026-07-23','13:55:26','PLG0082524','1102000','1102000','5000','1107000','1107000','kasir','2026-07-23 13:55:26','F22623015526');
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-07-23','F226230155262','2026-07-23','13:55:26','TIN','1107000','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-260723-0053','D','2026-07-23','13:55:26','kasir','PENJUALAN','F226230155262','12483910000','1107000','12485017000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1107000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230155262' 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 ('F226230221311','kasir','1',' MEA1E X PM','TOKO','SMBK-A','A1E-ZGXI-65-0','AT X ITALY SLEP VAR PM 8K ','','0.530','1','100.00','554000','0','0','15000','554000','0','0','0','554000','NOV','00412784','A1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZGXI-65-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-07-23' AND kode_barang='A1E-ZGXI-65-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 ('F226230221311','2026-07-23','0.530','2026-07-23','14:21:31','PLG0082525','554000','554000','0','554000','554000','kasir','2026-07-23 14:21:31','F22623022131');
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-07-23','F226230221311','2026-07-23','14:21:31','NOV','554000','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-260723-0054','D','2026-07-23','14:21:31','kasir','PENJUALAN','F226230221311','12485017000','554000','12485571000');
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 ('F226230230371','kasir','1',' MEF3E X KH','TOKO','SMBK-F','F3E-ZABH-108-0','GL X RANTAI HOLLOW P4 SLEP KH 8K ','','2.940','1','100.00','3072000','0','0','15000','3072000','0','0','0','3072000','LUS','00386966','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZABH-108-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.940',berat_jual_asli=berat_jual_asli+'2.940',stock_jual='1',berat_akhir=berat_akhir-'2.940',berat_akhir_asli=berat_akhir_asli-'2.940',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='F3E-ZABH-108-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226230230371','2026-07-23','2.940','2026-07-23','14:30:38','PLG0082526','3072000','3072000','0','3072000','3072000','kasir','2026-07-23 14:30:37','F22623023037');
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-07-23','F226230230371','2026-07-23','14:30:38','LUS','3072000','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-260723-0055','D','2026-07-23','14:30:38','kasir','PENJUALAN','F226230230371','12485571000','3072000','12488643000');
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 ('F226230256141','kasir','1',' MEF3E X UB','TOKO','SMBK-F','F3E-ZFBI-164-0','GL X TIFF PIRAMID SLEP UB 8K','OL','1.070','1','100.00','1118000','0','0','15000','1124000','0','5000','0','1129000','DIN','00411156','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFBI-164-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='F3E-ZFBI-164-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226230256141','2026-07-23','1.070','2026-07-23','14:56:14','PLG0082527','1124000','1124000','5000','1129000','1129000','kasir','2026-07-23 14:56:14','F22623025614');
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-07-23','F226230256141','2026-07-23','14:56:14','DIN','1129000','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-260723-0056','D','2026-07-23','14:56:14','kasir','PENJUALAN','F226230256141','12488643000','1129000','12489772000');
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 ('F226230303171','kasir','1',' MEF3E X KH','TOKO','SMBK-F','F3E-ZCXB-323-0','GL X JEDAR KH 8K ','OL','1.000','1','100.00','1045000','0','0','15000','1050000','0','5000','0','1055000','TIN','00391746','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCXB-323-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-07-23' AND kode_barang='F3E-ZCXB-323-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226230303171','2026-07-23','1.000','2026-07-23','15:03:17','PLG0082528','1050000','1050000','5000','1055000','1055000','kasir','2026-07-23 15:03:17','F22623030317');
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-07-23','F226230303171','2026-07-23','15:03:17','TIN','1055000','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-260723-0057','D','2026-07-23','15:03:17','kasir','PENJUALAN','F226230303171','12489772000','1055000','12490827000');
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 ('F226230304451','kasir','1',' MEF1E UB 5','TOKO','SMBK-F','F1E-ZGAX-38-T','GL MODEL C SLEP UB 56 8K ','','2.090','1','100.00','2184000','0','0','15000','2195000','0','10000','0','2205000','TIN','T0080998','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZGAX-38-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.090',berat_jual_asli=berat_jual_asli+'2.090',stock_jual='1',berat_akhir=berat_akhir-'2.090',berat_akhir_asli=berat_akhir_asli-'2.090',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='F1E-ZGAX-38-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 ('F226230304451','2026-07-23','2.090','2026-07-23','15:04:45','PLG0082529','2195000','2195000','10000','2205000','2205000','kasir','2026-07-23 15:04:45','F22623030445');
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-07-23','F226230304451','2026-07-23','15:04:45','TIN','2205000','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-260723-0058','D','2026-07-23','15:04:45','kasir','PENJUALAN','F226230304451','12490827000','2205000','12493032000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2205000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230304451' 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 ('F226230304452','kasir',' 1',' MEF1E YT 5','TOKO','SMBK-F','F1E-ZGAE-74-T','GL OVAL C SLEP YT 58 8K ','','2.250','1','100.00','2351000','0','0','15000','2363000','0','11000','0','2374000','TIN','T0081219','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZGAE-74-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.250',berat_jual_asli=berat_jual_asli+'2.250',stock_jual='1',berat_akhir=berat_akhir-'2.250',berat_akhir_asli=berat_akhir_asli-'2.250',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='F1E-ZGAE-74-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 ('F226230304452','2026-07-23','2.250','2026-07-23','15:04:45','PLG0082530','2363000','2363000','11000','2374000','2374000','kasir','2026-07-23 15:04:45','F22623030445');
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-07-23','F226230304452','2026-07-23','15:04:45','TIN','2374000','11000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260723-0059','D','2026-07-23','15:04:45','kasir','PENJUALAN','F226230304452','12493032000','2374000','12495406000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2374000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226230304452' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230100181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230100181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230100181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230105561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230105561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230105561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230105562' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230105562' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230105562';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230105563' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230105563' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230105563';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230105564' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230105564' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230105564';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230105565' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230105565' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230105565';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230105566' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230105566' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230105566';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230105567' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230105567' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230105567';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230105568' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230105568' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230105568';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230109341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230109341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230109341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230109342' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230109342' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230109342';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230109343' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230109343' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230109343';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230109344' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230109344' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230109344';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230109345' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230109345' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230109345';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230109346' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230109346' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230109346';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230109347' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230109347' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230109347';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230109348' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230109348' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230109348';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230149271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230149271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230149271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230154431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230154431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230154431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230154432' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230154432' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230154432';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230154433' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230154433' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230154433';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230154434' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230154434' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230154434';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230154435' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230154435' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230154435';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230154436' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230154436' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230154436';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230154437' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230154437' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230154437';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230154438' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230154438' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230154438';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230155261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230155261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230155261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230155262' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230155262' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230155262';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230221311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230221311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230221311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230230371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230230371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230230371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230256141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230256141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230256141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230303171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230303171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230303171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230304451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230304451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230304451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230304452' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230304452' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230304452';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230910521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230910521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230910521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230918121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230918121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230918121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230919301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230919301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230919301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230920191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230920191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230920191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230920551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230920551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230920551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230924481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230924481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230924481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230924482' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230924482' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230924482';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230924483' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230924483' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230924483';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230924484' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230924484' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230924484';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230948151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230948151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230948151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226231009281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226231009281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226231009281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226231013241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226231013241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226231013241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226231014551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226231014551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226231014551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226231014552' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226231014552' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226231014552';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226231035381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226231035381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226231035381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226231035382' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226231035382' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226231035382';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226231039311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226231039311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226231039311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226231121371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226231121371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226231121371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226231121372' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226231121372' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226231121372';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226231121373' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226231121373' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226231121373';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226231142521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226231142521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226231142521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226231149391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226231149391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226231149391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226231215361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226231215361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226231215361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226231216231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226231216231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226231216231';
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 ('F226230334061','kasir','1',' MEF1E TD 5','TOKO','SMBK-F','F1E-ZGAH-65-T','GL OVAL C SLEP TD 52 8K ','OL','2.900','1','100.00','3030000','0','0','15000','3060000','0','15000','0','3075000','LUS','T0081370','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZGAH-65-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.900',berat_jual_asli=berat_jual_asli+'2.900',stock_jual='1',berat_akhir=berat_akhir-'2.900',berat_akhir_asli=berat_akhir_asli-'2.900',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='F1E-ZGAH-65-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 ('F226230334061','2026-07-23','2.900','2026-07-23','15:34:07','PLG0082531','3060000','3060000','15000','3075000','3075000','kasir','2026-07-23 15:34:06','F22623033406');
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-07-23','F226230334061','2026-07-23','15:34:07','LUS','3075000','15000');
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-260723-0061','D','2026-07-23','15:34:07','kasir','PENJUALAN','F226230334061','12492332000','3075000','12495407000');
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-00005556','X-00005556','CC PIPA MODEL DAUN VAR HTM 18 8K','GR','---','E1E','BELI','BELI001','404000','2026-07-23','0.430','1','kasir','2026-07-23 15:35:41');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00005556','X-00005556');
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-260723-0001','F226090819331','DIN','1','BELI','BELI001','E1E', 'X-00005556', 'CC PIPA MODEL DAUN VAR HTM 18 8K','0.430','0.430','100.00','486000','404000','939535','1045000','1','404000','404000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.430',berat_beli_asli=berat_beli_asli+'0.430',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.430',berat_akhir_asli=berat_akhir_asli+'0.430',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-23' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260723-0001','2026-07-23','2026-07-23','15:35:41','DIN','---','0.430','404000','404000','404000','404000','404000','kasir','2026-07-23 15:35:41','FB-260723-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260723-0001','PURWANINGSIH','JL PRAHASTO 28A','','','081216477054','kasir','2026-07-23 15:35:41');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-23' 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-260723-0062','K','2026-07-23','15:35:41','kasir','PEMBELIAN UMUM','FB-260723-0001','12495407000','404000','12495003000');
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-00005557','X-00005557','CC X MODEL MATA UB 16 8K','GR','---','E2D','BELI','BELI001','830000','2026-07-23','0.880','1','kasir','2026-07-23 15:36:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00005557','X-00005557');
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-260723-0002','F226081049151','NOV','1','BELI','BELI001','E2D', 'X-00005557', 'CC X MODEL MATA UB 16 8K','0.880','0.880','100.00','975000','830000','943182','1025000','1','830000','830000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.880',berat_beli_asli=berat_beli_asli+'0.880',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.880',berat_akhir_asli=berat_akhir_asli+'0.880',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-23' 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-260723-0002','2026-07-23','2026-07-23','15:36:23','NOV','---','0.880','830000','830000','830000','830000','830000','kasir','2026-07-23 15:36:23','FB-260723-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260723-0002','SRI RAHAYU','JL RAMA WIJAYA 04/02 SURODIKRAMAN','','','0859191765996','kasir','2026-07-23 15:36:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-23' 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-260723-0063','K','2026-07-23','15:36:23','kasir','PEMBELIAN UMUM','FB-260723-0002','12495003000','830000','12494173000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260723-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260723-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260723-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260723-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226230334061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226230334061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226230334061';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-24','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-23';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-23';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-23';
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-07-23' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-23';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-23';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-23';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-23';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-24' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-23' 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-260724-0001','D','2026-07-24','16:01:45','SYSTEM','SALDO AWAL','SALDO AWAL','0','12494173000','12494173000');
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-260724-0001','D','2026-07-24','16:01:45','','SALDO AWAL','SALDO AWAL','0','2260000','2260000');
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-260724-0001','D','2026-07-24','16:01:45','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-260724-0001','D','2026-07-24','16:01:45','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-260724-0001','D','2026-07-24','16:01:45','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-260724-0001','D','2026-07-24','16:01:45','BCA','SALDO AWAL','SALDO AWAL','0','4638644888','4638644888');
UPDATE tp_system SET tgl_system='2026-07-24';