INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260725-0001','1','H1E-ZGAX-41-0','1','1.000','TOKO','BK-H');
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZGAX-41-0' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='H1E-ZGAX-41-0' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_group_export WHERE kode_group='ME' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='ME' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BK-H';
INSERT INTO db_nagagold_dewigold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BK-H';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='H1E-ZGAX-41-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.000',berat_out_asli='1.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.000',berat_akhir_asli =berat_akhir_asli-'1.000' WHERE kode_barang='H1E-ZGAX-41-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-260725-0001','2026-07-25','2026-07-25','07:37','1.000','input','260725');
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 ('F226250853231','kasir','1',' MGE1G HW 1','TOKO','SMBK-E','E1G-ZGBD-20-T','CC MODEL GELOMBANG SLEP HW 15 8K ','OL','0.280','1','100.00','304000','0','0','15000','307000','0','5000','0','312000','TIN','T0081447','E1G','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1G-ZGBD-20-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.280',berat_jual_asli=berat_jual_asli+'0.280',stock_jual='1',berat_akhir=berat_akhir-'0.280',berat_akhir_asli=berat_akhir_asli-'0.280',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='E1G-ZGBD-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 ('F226250853231','2026-07-25','0.280','2026-07-25','08:53:24','PLG0082587','307000','307000','5000','312000','312000','kasir','2026-07-25 08:53:23','F22625085323');
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-25','F226250853231','2026-07-25','08:53:24','TIN','312000','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-260725-0002','D','2026-07-25','08:53:24','kasir','PENJUALAN','F226250853231','12533691000','312000','12534003000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='312000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250853231' 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 ('F226250853232','kasir',' 1',' MFE1F HW 1','TOKO','SMBK-E','E1G-ZGBD-22-T','CC MODEL GELOMBANG SLEP HW 15 8K','OL','0.310','1','100.00','336000','0','0','15000','333000','0','5000','0','338000','TIN','T0081449','E1G','0','0','-','1','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1G-ZGBD-22-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.310',berat_jual_asli=berat_jual_asli+'0.310',stock_jual='1',berat_akhir=berat_akhir-'0.310',berat_akhir_asli=berat_akhir_asli-'0.310',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='E1G-ZGBD-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 ('F226250853232','2026-07-25','0.310','2026-07-25','08:53:24','PLG0082588','333000','333000','5000','338000','338000','kasir','2026-07-25 08:53:23','F22625085323');
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-25','F226250853232','2026-07-25','08:53:24','TIN','338000','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-260725-0003','D','2026-07-25','08:53:24','kasir','PENJUALAN','F226250853232','12534003000','338000','12534341000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='338000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250853232' 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 ('F226250853233','kasir',' 1',' MFE1F HW 1','TOKO','SMBK-E','E1F-ZGBD-19-T','CC MODEL GELOMBANG SLEP HW 15 8K ','OL','0.310','1','100.00','330000','0','0','15000','333000','0','5000','0','338000','TIN','T0081446','E1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGBD-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.310',berat_jual_asli=berat_jual_asli+'0.310',stock_jual='1',berat_akhir=berat_akhir-'0.310',berat_akhir_asli=berat_akhir_asli-'0.310',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='E1F-ZGBD-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 ('F226250853233','2026-07-25','0.310','2026-07-25','08:53:24','PLG0082589','333000','333000','5000','338000','338000','kasir','2026-07-25 08:53:23','F22625085323');
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-25','F226250853233','2026-07-25','08:53:24','TIN','338000','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-260725-0004','D','2026-07-25','08:53:24','kasir','PENJUALAN','F226250853233','12534341000','338000','12534679000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='338000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250853233' 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 ('F226250853234','kasir',' 1',' MFE1F HW 1','TOKO','SMBK-E','E1G-ZGBD-21-T','CC MODEL GELOMBANG SLEP HW 15 8K','OL','0.350','1','100.00','380000','0','0','15000','377000','0','5000','0','382000','TIN','T0081448','E1G','0','0','-','1','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1G-ZGBD-21-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='E1G-ZGBD-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 ('F226250853234','2026-07-25','0.350','2026-07-25','08:53:24','PLG0082590','377000','377000','5000','382000','382000','kasir','2026-07-25 08:53:23','F22625085323');
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-25','F226250853234','2026-07-25','08:53:24','TIN','382000','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-260725-0005','D','2026-07-25','08:53:24','kasir','PENJUALAN','F226250853234','12534679000','382000','12535061000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='382000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250853234' 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 ('F226250853235','kasir',' 1',' MEF3 X KH ','TOKO','SMBK-F','F3E-YLAG-85-0','GL X MEDAN SLEP KH 8K ','OL','1.450','1','100.00','1515000','0','0','15000','1523000','0','7000','0','1530000','TIN','00381439','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLAG-85-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.450',berat_jual_asli=berat_jual_asli+'1.450',stock_jual='1',berat_akhir=berat_akhir-'1.450',berat_akhir_asli=berat_akhir_asli-'1.450',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='F3E-YLAG-85-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 ('F226250853235','2026-07-25','1.450','2026-07-25','08:53:24','PLG0082591','1523000','1523000','7000','1530000','1530000','kasir','2026-07-25 08:53:23','F22625085323');
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-25','F226250853235','2026-07-25','08:53:24','TIN','1530000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260725-0006','D','2026-07-25','08:53:24','kasir','PENJUALAN','F226250853235','12535061000','1530000','12536591000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1530000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250853235' 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 ('F226251000481','kasir','1',' MGB1G LG ','TOKO','SMBK-B','B1G-ZGBD-78-T','GW TINDIK MRICAN SLEP LG 8K ','OL','0.250','1','100.00','271000','0','0','15000','275000','0','5000','0','280000','DIN','T0081505','B1G','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZGBD-78-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='B1G-ZGBD-78-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 ('F226251000481','2026-07-25','0.250','2026-07-25','10:00:49','PLG0082592','275000','275000','5000','280000','280000','kasir','2026-07-25 10:00:48','F22625100048');
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-25','F226251000481','2026-07-25','10:00:49','DIN','280000','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-260725-0007','D','2026-07-25','10:00:49','kasir','PENJUALAN','F226251000481','12536591000','280000','12536871000');
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 ('F226251001211','kasir','1',' MED1E 5K L','TOKO','SMBK-D','D1E-ZGBD-89-T','LT MODEL FG SLEP LG 8K ','OL','0.510','1','100.00','533000','0','0','15000','538000','0','5000','0','543000','DIN','T0081516','D1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZGBD-89-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-25' AND kode_barang='D1E-ZGBD-89-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 ('F226251001211','2026-07-25','0.510','2026-07-25','10:01:22','PLG0082593','538000','538000','5000','543000','543000','kasir','2026-07-25 10:01:21','F22625100121');
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-25','F226251001211','2026-07-25','10:01:22','DIN','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) VALUES ('KM-260725-0008','D','2026-07-25','10:01:22','kasir','PENJUALAN','F226251001211','12536871000','543000','12537414000');
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 ('F226251003151','kasir','1',' MEF3F HW ','TOKO','SMBK-F','F3E-ZGBD-148-T','GL CASATELI VERONA SLEP HW 8K ','OL','1.720','1','100.00','1797000','0','0','15000','1806000','0','9000','0','1815000','LUS','T0081575','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGBD-148-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.720',berat_jual_asli=berat_jual_asli+'1.720',stock_jual='1',berat_akhir=berat_akhir-'1.720',berat_akhir_asli=berat_akhir_asli-'1.720',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='F3E-ZGBD-148-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 ('F226251003151','2026-07-25','1.720','2026-07-25','10:03:15','PLG0082594','1806000','1806000','9000','1815000','1815000','kasir','2026-07-25 10:03:15','F22625100315');
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-25','F226251003151','2026-07-25','10:03:15','LUS','1815000','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-260725-0009','D','2026-07-25','10:03:15','kasir','PENJUALAN','F226251003151','12537414000','1815000','12539229000');
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 ('F226251004511','kasir','1',' MED1E HW ','TOKO','SMBK-D','D2E-ZGBD-94-T','LT HATI MATA SLEP HW 8K ','OL','0.600','1','100.00','627000','0','0','15000','633000','0','5000','0','638000','LUS','T0081521','D2E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZGBD-94-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-25' AND kode_barang='D2E-ZGBD-94-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 ('F226251004511','2026-07-25','0.600','2026-07-25','10:04:52','PLG0082595','633000','633000','5000','638000','638000','kasir','2026-07-25 10:04:51','F22625100451');
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-25','F226251004511','2026-07-25','10:04:52','LUS','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-260725-0010','D','2026-07-25','10:04:52','kasir','PENJUALAN','F226251004511','12539229000','638000','12539867000','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='F226251004511' 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 ('F226251004512','kasir',' 1',' MEF1E YT 5','TOKO','SMBK-F','F1E-ZGBD-138-T','GL OVAL C SLEP YT 58 8K ','OL','2.300','1','100.00','2403000','0','0','15000','2415000','0','12000','0','2427000','LUS','T0081565','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZGBD-138-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.300',berat_jual_asli=berat_jual_asli+'2.300',stock_jual='1',berat_akhir=berat_akhir-'2.300',berat_akhir_asli=berat_akhir_asli-'2.300',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='F1E-ZGBD-138-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 ('F226251004512','2026-07-25','2.300','2026-07-25','10:04:52','PLG0082596','2415000','2415000','12000','2427000','2427000','kasir','2026-07-25 10:04:51','F22625100451');
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-25','F226251004512','2026-07-25','10:04:52','LUS','2427000','12000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260725-0011','D','2026-07-25','10:04:52','kasir','PENJUALAN','F226251004512','12539867000','2427000','12542294000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2427000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251004512' 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 ('F226251004513','kasir',' 1',' MJH2 X UB ','TOKO','SMBK-H','H2J-YKAA-148-0','KL X GUCCI UB 40 9K ','OL','1.510','1','100.00','1729000','0','0','15000','1737000','0','8000','0','1745000','LUS','00377114','H2J','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-YKAA-148-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.510',berat_jual_asli=berat_jual_asli+'1.510',stock_jual='1',berat_akhir=berat_akhir-'1.510',berat_akhir_asli=berat_akhir_asli-'1.510',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='H2J-YKAA-148-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 ('F226251004513','2026-07-25','1.510','2026-07-25','10:04:52','PLG0082597','1737000','1737000','8000','1745000','1745000','kasir','2026-07-25 10:04:51','F22625100451');
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-25','F226251004513','2026-07-25','10:04:52','LUS','1745000','8000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260725-0012','D','2026-07-25','10:04:52','kasir','PENJUALAN','F226251004513','12542294000','1745000','12544039000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1745000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251004513' 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 ('F226251006431','kasir','1',' MFD1F 5K B','TOKO','SMBK-D','D1F-ZGAH-54-T','LT CHARM BUNGA SLEP BG 8K ','OL','0.470','1','100.00','501000','0','0','15000','508000','0','5000','0','513000','LUS','T0081359','D1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZGAH-54-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='D1F-ZGAH-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 ('F226251006431','2026-07-25','0.470','2026-07-25','10:06:44','PLG0082598','508000','508000','5000','513000','513000','kasir','2026-07-25 10:06:43','F22625100643');
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-25','F226251006431','2026-07-25','10:06:44','LUS','513000','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-260725-0013','D','2026-07-25','10:06:44','kasir','PENJUALAN','F226251006431','12544039000','513000','12544552000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='513000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251006431' 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 ('F226251006432','kasir',' 1',' MED1E 5K L','TOKO','SMBK-D','D1E-ZGBD-95-T','LT MODEL NEKO CAT SLEP LG 8K ','OL','0.550','1','100.00','575000','0','0','15000','583000','0','5000','0','588000','LUS','T0081522','D1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZGBD-95-T' 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-25' AND kode_barang='D1E-ZGBD-95-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226251006432','2026-07-25','0.550','2026-07-25','10:06:44','PLG0082599','583000','583000','5000','588000','588000','kasir','2026-07-25 10:06:43','F22625100643');
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-25','F226251006432','2026-07-25','10:06:44','LUS','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-260725-0014','D','2026-07-25','10:06:44','kasir','PENJUALAN','F226251006432','12544552000','588000','12545140000','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='F226251006432' 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 ('F226251006433','kasir',' 1',' MFD1F 5K B','TOKO','SMBK-D','D1F-ZGAE-36-T','LT CHARM PPITA SLEP BG 8K ','OL','0.660','1','100.00','703000','0','0','15000','713000','0','5000','0','718000','LUS','T0081181','D1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZGAE-36-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.660',berat_jual_asli=berat_jual_asli+'0.660',stock_jual='1',berat_akhir=berat_akhir-'0.660',berat_akhir_asli=berat_akhir_asli-'0.660',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='D1F-ZGAE-36-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226251006433','2026-07-25','0.660','2026-07-25','10:06:44','PLG0082600','713000','713000','5000','718000','718000','kasir','2026-07-25 10:06:43','F22625100643');
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-25','F226251006433','2026-07-25','10:06:44','LUS','718000','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-260725-0015','D','2026-07-25','10:06:44','kasir','PENJUALAN','F226251006433','12545140000','718000','12545858000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='718000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251006433' 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 ('F226251006434','kasir',' 1',' MEH1 X UB ','TOKO','SMBK-H','H1E-YLBI-245-0','KL X CARENDELANO HURUF UB E 8K ','OL','2.040','1','100.00','2132000','0','0','15000','2152000','0','10000','0','2162000','LUS','00383397','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLBI-245-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.040',berat_jual_asli=berat_jual_asli+'2.040',stock_jual='1',berat_akhir=berat_akhir-'2.040',berat_akhir_asli=berat_akhir_asli-'2.040',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='H1E-YLBI-245-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 ('F226251006434','2026-07-25','2.040','2026-07-25','10:06:44','PLG0082601','2152000','2152000','10000','2162000','2162000','kasir','2026-07-25 10:06:43','F22625100643');
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-25','F226251006434','2026-07-25','10:06:44','LUS','2162000','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-260725-0016','D','2026-07-25','10:06:44','kasir','PENJUALAN','F226251006434','12545858000','2162000','12548020000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2162000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251006434' 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 ('F226251013341','kasir','1',' MDE1 X UB ','TOKO','SMBK-E','E1D-ZFXI-140-0','CC X MODEL SLEP UB 10 8K ','','0.650','1','100.00','666000','0','0','15000','666000','0','0','0','666000','NOV','00408207','E1D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZFXI-140-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='E1D-ZFXI-140-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 ('F226251013341','2026-07-25','0.650','2026-07-25','10:13:34','PLG0082602','666000','666000','0','666000','0','kasir','2026-07-25 10:13:34','F22625101334');
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-25','F226251013341','2026-07-25','10:13:34','NOV','666000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260725-0001','2026-07-25','2026-07-25 10:13:34','PENJUALAN : F226251013341','253456788099','BCA','666000','666000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260725-0002','D','2026-07-25','10:13:34','BCA','PENJUALAN','F226251013341','4640068888','666000','4640734888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('253456788099','ENI AGUSTINA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='666000' WHERE no_faktur_jual='F226251013341' 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 ('F226251020371','kasir','1',' TEF1 UB 65','TOKO','TBK-F','F1TE-ZGAG-30-T','GL OVAL C SLEP UB 65 17K ','','3.500','1','100.00','6685000','0','0','15000','6650000','0','0','0','6650000','DIN','T0081253','F1TE','0','0','-','1','1910000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1TE-ZGAG-30-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.500',berat_jual_asli=berat_jual_asli+'3.500',stock_jual='1',berat_akhir=berat_akhir-'3.500',berat_akhir_asli=berat_akhir_asli-'3.500',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='F1TE-ZGAG-30-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226251020371','2026-07-25','3.500','2026-07-25','10:20:37','PLG0082603','6650000','6650000','0','6650000','6650000','kasir','2026-07-25 10:20:37','F22625102037');
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-25','F226251020371','2026-07-25','10:20:37','DIN','6650000','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-260725-0017','D','2026-07-25','10:20:37','kasir','PENJUALAN','F226251020371','12548020000','6650000','12554670000');
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 ('F226251021481','kasir','1',' MEF3 10K Y','TOKO','SMBK-F','F3E-ZGAG-77-T','GL TIFF SPECTRA CAT MERAH VAR SLEP YT 8K ','','1.400','1','100.00','1463000','0','0','15000','1463000','0','10000','0','1473000','DIN','T0081300','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGAG-77-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.400',berat_jual_asli=berat_jual_asli+'1.400',stock_jual='1',berat_akhir=berat_akhir-'1.400',berat_akhir_asli=berat_akhir_asli-'1.400',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='F3E-ZGAG-77-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 ('F226251021481','2026-07-25','1.400','2026-07-25','10:21:48','PLG0082604','1463000','1463000','10000','1473000','1473000','kasir','2026-07-25 10:21:48','F22625102148');
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-25','F226251021481','2026-07-25','10:21:48','DIN','1473000','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-260725-0018','D','2026-07-25','10:21:48','kasir','PENJUALAN','F226251021481','12554670000','1473000','12556143000');
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 ('F226251041531','kasir','1',' MEA1E LG ','TOKO','SMBK-A','A1E-ZGAG-4-T','AT KLIP BANGKOK SLEP LG 8K ','OL','0.600','1','100.00','627000','0','0','15000','636000','0','5000','0','641000','DIN','T0081227','A1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZGAG-4-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-25' AND kode_barang='A1E-ZGAG-4-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 ('F226251041531','2026-07-25','0.600','2026-07-25','10:41:53','PLG0082605','636000','636000','5000','641000','641000','kasir','2026-07-25 10:41:53','F22625104153');
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-25','F226251041531','2026-07-25','10:41:53','DIN','641000','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-260725-0019','D','2026-07-25','10:41:53','kasir','PENJUALAN','F226251041531','12556143000','641000','12556784000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='641000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251041531' 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 ('F226251041532','kasir',' 1',' MEB1E CM P','TOKO','SMBK-B','B1E-ZGBA-4-T','GW MODEL SLEP CM PE 8K ','OL','0.500','1','100.00','522000','0','0','15000','530000','0','5000','0','535000','DIN','T0081374','B1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZGBA-4-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-25' AND kode_barang='B1E-ZGBA-4-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 ('F226251041532','2026-07-25','0.500','2026-07-25','10:41:53','PLG0082606','530000','530000','5000','535000','535000','kasir','2026-07-25 10:41:53','F22625104153');
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-25','F226251041532','2026-07-25','10:41:53','DIN','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,status_valid) VALUES ('KM-260725-0020','D','2026-07-25','10:41:53','kasir','PENJUALAN','F226251041532','12556784000','535000','12557319000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='535000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251041532' 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 ('F226251041533','kasir',' 1',' MEB1 5K BM','TOKO','SMBK-B','B1E-ZGBA-54-T','GW MODEL CAT HITAM SLEP BM PE 8K ','OL','0.520','1','100.00','543000','0','0','15000','551000','0','5000','0','556000','DIN','T0081424','B1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZGBA-54-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-25' AND kode_barang='B1E-ZGBA-54-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 ('F226251041533','2026-07-25','0.520','2026-07-25','10:41:53','PLG0082607','551000','551000','5000','556000','556000','kasir','2026-07-25 10:41:53','F22625104153');
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-25','F226251041533','2026-07-25','10:41:53','DIN','556000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260725-0021','D','2026-07-25','10:41:53','kasir','PENJUALAN','F226251041533','12557319000','556000','12557875000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='556000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251041533' 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 ('F226251041534','kasir',' 1',' MEB1E LG ','TOKO','SMBK-B','B1E-ZGBD-86-T','GW TIFF PITA SLEP LG 8K ','OL','0.590','1','100.00','617000','0','0','15000','625000','0','5000','0','630000','DIN','T0081513','B1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZGBD-86-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.590',berat_jual_asli=berat_jual_asli+'0.590',stock_jual='1',berat_akhir=berat_akhir-'0.590',berat_akhir_asli=berat_akhir_asli-'0.590',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='B1E-ZGBD-86-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 ('F226251041534','2026-07-25','0.590','2026-07-25','10:41:53','PLG0082608','625000','625000','5000','630000','630000','kasir','2026-07-25 10:41:53','F22625104153');
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-25','F226251041534','2026-07-25','10:41:53','DIN','630000','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-260725-0022','D','2026-07-25','10:41:53','kasir','PENJUALAN','F226251041534','12557875000','630000','12558505000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='630000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251041534' 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 ('F226251102461','kasir','1',' MDA1D PM ','TOKO','SMBK-A','A1D-ZFAF-24-T','AT ITALY VAR SLEP PM 8K ','OL','1.010','1','100.00','1035000','0','0','15000','1040000','0','5000','0','1045000','TIN','T0080459','A1D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZFAF-24-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='A1D-ZFAF-24-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 ('F226251102461','2026-07-25','1.010','2026-07-25','11:02:46','PLG0082609','1040000','1040000','5000','1045000','1045000','kasir','2026-07-25 11:02:46','F22625110246');
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-25','F226251102461','2026-07-25','11:02:46','TIN','1045000','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-260725-0023','D','2026-07-25','11:02:46','kasir','PENJUALAN','F226251102461','12558505000','1045000','12559550000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1045000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251102461' 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 ('F226251102462','kasir',' 1',' MDD1D 10K ','TOKO','SMBK-D','D1D-ZGAE-42-T','LT MODEL BUNGA SLEP UB 8K ','OL','1.680','1','100.00','1722000','0','0','15000','1729000','0','10000','0','1739000','TIN','T0081187','D1D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1D-ZGAE-42-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.680',berat_jual_asli=berat_jual_asli+'1.680',stock_jual='1',berat_akhir=berat_akhir-'1.680',berat_akhir_asli=berat_akhir_asli-'1.680',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='D1D-ZGAE-42-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 ('F226251102462','2026-07-25','1.680','2026-07-25','11:02:46','PLG0082610','1729000','1729000','10000','1739000','1739000','kasir','2026-07-25 11:02:46','F22625110246');
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-25','F226251102462','2026-07-25','11:02:46','TIN','1739000','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-260725-0024','D','2026-07-25','11:02:46','kasir','PENJUALAN','F226251102462','12559550000','1739000','12561289000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1739000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251102462' 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 ('F226251122441','kasir','1',' MEF3E UB ','TOKO','SMBK-F','F3E-ZGAG-71-T','GL LONGLING SLEP UB 8K ','','1.020','1','100.00','1066000','0','0','15000','1066000','0','0','0','1066000','DIN','T0081294','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGAG-71-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='F3E-ZGAG-71-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 ('F226251122441','2026-07-25','1.020','2026-07-25','11:22:45','PLG0082611','1066000','1066000','0','1066000','1066000','kasir','2026-07-25 11:22:44','F22625112244');
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-25','F226251122441','2026-07-25','11:22:45','DIN','1066000','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-260725-0025','D','2026-07-25','11:22:45','kasir','PENJUALAN','F226251122441','12561289000','1066000','12562355000');
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 ('F226251140031','kasir','1',' MEF3E HW ','TOKO','SMBK-F','F3E-ZGBD-155-T','GL ANAK TIFF VAR SLEP HW 8K ','OL','0.670','1','100.00','700000','0','0','15000','707000','0','5000','0','712000','TIN','T0081582','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGBD-155-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.670',berat_jual_asli=berat_jual_asli+'0.670',stock_jual='1',berat_akhir=berat_akhir-'0.670',berat_akhir_asli=berat_akhir_asli-'0.670',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='F3E-ZGBD-155-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 ('F226251140031','2026-07-25','0.670','2026-07-25','11:40:04','PLG0082612','707000','707000','5000','712000','712000','kasir','2026-07-25 11:40:03','F22625114003');
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-25','F226251140031','2026-07-25','11:40:04','TIN','712000','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-260725-0026','D','2026-07-25','11:40:04','kasir','PENJUALAN','F226251140031','12562355000','712000','12563067000');
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 ('F226251140571','kasir','1',' MEB1E CM P','TOKO','SMBK-B','B1E-ZGAH-42-T','GW MODEL PASIR VAR SLEP CM PE 8K ','OL','0.600','1','100.00','627000','0','0','15000','633000','0','5000','0','638000','TIN','T0081347','B1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZGAH-42-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-25' AND kode_barang='B1E-ZGAH-42-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 ('F226251140571','2026-07-25','0.600','2026-07-25','11:40:58','PLG0082613','633000','633000','5000','638000','638000','kasir','2026-07-25 11:40:57','F22625114057');
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-25','F226251140571','2026-07-25','11:40:58','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-260725-0027','D','2026-07-25','11:40:58','kasir','PENJUALAN','F226251140571','12563067000','638000','12563705000','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='F226251140571' 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 ('F226251140572','kasir',' 1',' MEB1E CM P','TOKO','SMBK-B','B1E-ZGAH-41-T','GW MODEL PASIR VAR SLEP CM PE 8K ','OL','0.610','1','100.00','637000','0','0','15000','644000','0','5000','0','649000','TIN','T0081346','B1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZGAH-41-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='B1E-ZGAH-41-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 ('F226251140572','2026-07-25','0.610','2026-07-25','11:40:58','PLG0082614','644000','644000','5000','649000','649000','kasir','2026-07-25 11:40:57','F22625114057');
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-25','F226251140572','2026-07-25','11:40:58','TIN','649000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260725-0028','D','2026-07-25','11:40:58','kasir','PENJUALAN','F226251140572','12563705000','649000','12564354000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='649000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251140572' 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 ('F226251140573','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZGAD-58-T','CC MODEL SLEP CM 14 8K ','OL','0.620','1','100.00','648000','0','0','15000','655000','0','5000','0','660000','TIN','T0081135','E1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGAD-58-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.620',berat_jual_asli=berat_jual_asli+'0.620',stock_jual='1',berat_akhir=berat_akhir-'0.620',berat_akhir_asli=berat_akhir_asli-'0.620',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='E1E-ZGAD-58-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 ('F226251140573','2026-07-25','0.620','2026-07-25','11:40:58','PLG0082615','655000','655000','5000','660000','660000','kasir','2026-07-25 11:40:57','F22625114057');
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-25','F226251140573','2026-07-25','11:40:58','TIN','660000','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-260725-0029','D','2026-07-25','11:40:58','kasir','PENJUALAN','F226251140573','12564354000','660000','12565014000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='660000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251140573' 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 ('F226251141571','kasir','1',' MFD1F LG ','TOKO','SMBK-D','D1F-ZGBD-115-T','LT CHARM KUPU SLEP LG 8K ','OL','0.350','1','100.00','373000','0','0','15000','376000','0','5000','0','381000','TIN','T0081542','D1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZGBD-115-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='D1F-ZGBD-115-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 ('F226251141571','2026-07-25','0.350','2026-07-25','11:41:58','PLG0082616','376000','376000','5000','381000','381000','kasir','2026-07-25 11:41:57','F22625114157');
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-25','F226251141571','2026-07-25','11:41:58','TIN','381000','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-260725-0030','D','2026-07-25','11:41:58','kasir','PENJUALAN','F226251141571','12565014000','381000','12565395000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='381000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251141571' 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 ('F226251141572','kasir',' 1',' MFD1F LG ','TOKO','SMBK-D','D1F-ZGBD-118-T','LT CHARM BINTANG SLEP LG 8K ','OL','0.360','1','100.00','383000','0','0','15000','387000','0','5000','0','392000','TIN','T0081545','D1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZGBD-118-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.360',berat_jual_asli=berat_jual_asli+'0.360',stock_jual='1',berat_akhir=berat_akhir-'0.360',berat_akhir_asli=berat_akhir_asli-'0.360',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='D1F-ZGBD-118-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 ('F226251141572','2026-07-25','0.360','2026-07-25','11:41:58','PLG0082617','387000','387000','5000','392000','392000','kasir','2026-07-25 11:41:57','F22625114157');
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-25','F226251141572','2026-07-25','11:41:58','TIN','392000','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-260725-0031','D','2026-07-25','11:41:58','kasir','PENJUALAN','F226251141572','12565395000','392000','12565787000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='392000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251141572' 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 ('F226251141573','kasir',' 1',' MEF3E HW ','TOKO','SMBK-F','F3E-ZGBD-124-T','GL RANTAI HOLLOW SLEP HW 8K ','OL','3.100','1','100.00','3239000','0','0','15000','3255000','0','16000','0','3271000','TIN','T0081551','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGBD-124-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.100',berat_jual_asli=berat_jual_asli+'3.100',stock_jual='1',berat_akhir=berat_akhir-'3.100',berat_akhir_asli=berat_akhir_asli-'3.100',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='F3E-ZGBD-124-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 ('F226251141573','2026-07-25','3.100','2026-07-25','11:41:58','PLG0082618','3255000','3255000','16000','3271000','3271000','kasir','2026-07-25 11:41:57','F22625114157');
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-25','F226251141573','2026-07-25','11:41:58','TIN','3271000','16000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260725-0032','D','2026-07-25','11:41:58','kasir','PENJUALAN','F226251141573','12565787000','3271000','12569058000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3271000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251141573' 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 ('F226251206301','kasir','1',' MEB1E CM P','TOKO','SMBK-B','B1E-ZGAD-48-T','GW MODEL HATI SLEP CM PE 8K ','OL','0.630','1','100.00','658000','0','0','15000','665000','0','5000','0','670000','TIN','T0081125','B1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZGAD-48-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-25' AND kode_barang='B1E-ZGAD-48-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 ('F226251206301','2026-07-25','0.630','2026-07-25','12:06:30','PLG0082619','665000','665000','5000','670000','670000','kasir','2026-07-25 12:06:30','F22625120630');
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-25','F226251206301','2026-07-25','12:06:30','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-260725-0033','D','2026-07-25','12:06:30','kasir','PENJUALAN','F226251206301','12569058000','670000','12569728000','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='F226251206301' 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 ('F226251206302','kasir',' 1',' MED2 X CM ','TOKO','SMBK-D','D2E-ZGBX-275-0','LT X MODEL MATA CM 8K ','OL','0.750','1','100.00','784000','0','0','15000','791000','0','5000','0','796000','TIN','00414476','D2E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZGBX-275-0' 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-25' AND kode_barang='D2E-ZGBX-275-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 ('F226251206302','2026-07-25','0.750','2026-07-25','12:06:30','PLG0082620','791000','791000','5000','796000','796000','kasir','2026-07-25 12:06:30','F22625120630');
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-25','F226251206302','2026-07-25','12:06:30','TIN','796000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260725-0034','D','2026-07-25','12:06:30','kasir','PENJUALAN','F226251206302','12569728000','796000','12570524000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='796000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251206302' 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 ('F226251206303','kasir',' 1',' MFE1F LG 1','TOKO','SMBK-E','E1F-ZGBD-6-T','CC MODEL ISYANA SLEP LG 10 8K ','OL','0.370','1','100.00','394000','0','0','15000','398000','0','5000','0','403000','TIN','T0081433','E1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGBD-6-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.370',berat_jual_asli=berat_jual_asli+'0.370',stock_jual='1',berat_akhir=berat_akhir-'0.370',berat_akhir_asli=berat_akhir_asli-'0.370',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='E1F-ZGBD-6-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226251206303','2026-07-25','0.370','2026-07-25','12:06:30','PLG0082621','398000','398000','5000','403000','403000','kasir','2026-07-25 12:06:30','F22625120630');
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-25','F226251206303','2026-07-25','12:06:30','TIN','403000','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-260725-0035','D','2026-07-25','12:06:30','kasir','PENJUALAN','F226251206303','12570524000','403000','12570927000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='403000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251206303' 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 ('F226251206304','kasir',' 1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZGAA-5-T','CC MODEL DAUN SLEP LG 16 8K ','OL','0.500','1','100.00','522000','0','0','15000','528000','0','5000','0','533000','TIN','T0081016','E1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGAA-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-25' AND kode_barang='E1E-ZGAA-5-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 ('F226251206304','2026-07-25','0.500','2026-07-25','12:06:30','PLG0082622','528000','528000','5000','533000','533000','kasir','2026-07-25 12:06:30','F22625120630');
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-25','F226251206304','2026-07-25','12:06:30','TIN','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,status_valid) VALUES ('KM-260725-0036','D','2026-07-25','12:06:30','kasir','PENJUALAN','F226251206304','12570927000','533000','12571460000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='533000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251206304' 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 ('F226251206305','kasir',' 1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZGXB-64-T','CC MDOEL ISYANA SLEP LG 14 8K ','OL','0.530','1','100.00','554000','0','0','15000','559000','0','5000','0','564000','TIN','T0080892','E1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGXB-64-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-25' AND kode_barang='E1E-ZGXB-64-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 ('F226251206305','2026-07-25','0.530','2026-07-25','12:06:30','PLG0082623','559000','559000','5000','564000','564000','kasir','2026-07-25 12:06:30','F22625120630');
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-25','F226251206305','2026-07-25','12:06:30','TIN','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-260725-0037','D','2026-07-25','12:06:30','kasir','PENJUALAN','F226251206305','12571460000','564000','12572024000','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='F226251206305' 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 ('F226251206306','kasir',' 1',' MEE2 X AY ','TOKO','SMBK-E','E2E-ZGXI-290-0','CC X MODEL MATA AY 10 8K ','OL','0.760','1','100.00','794000','0','0','15000','802000','0','5000','0','807000','TIN','00413009','E2E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZGXI-290-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.760',berat_jual_asli=berat_jual_asli+'0.760',stock_jual='1',berat_akhir=berat_akhir-'0.760',berat_akhir_asli=berat_akhir_asli-'0.760',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='E2E-ZGXI-290-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 ('F226251206306','2026-07-25','0.760','2026-07-25','12:06:30','PLG0082624','802000','802000','5000','807000','807000','kasir','2026-07-25 12:06:30','F22625120630');
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-25','F226251206306','2026-07-25','12:06:30','TIN','807000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260725-0038','D','2026-07-25','12:06:30','kasir','PENJUALAN','F226251206306','12572024000','807000','12572831000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='807000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251206306' 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 ('F226251206307','kasir',' 1',' MDE1D CM 1','TOKO','SMBK-E','E1D-ZGBD-13-T','CC MODEL ISYANA SLEP CM 16 8K ','OL','0.860','1','100.00','881000','0','0','15000','890000','0','5000','0','895000','TIN','T0081440','E1D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZGBD-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.860',berat_jual_asli=berat_jual_asli+'0.860',stock_jual='1',berat_akhir=berat_akhir-'0.860',berat_akhir_asli=berat_akhir_asli-'0.860',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='E1D-ZGBD-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 ('F226251206307','2026-07-25','0.860','2026-07-25','12:06:30','PLG0082625','890000','890000','5000','895000','895000','kasir','2026-07-25 12:06:30','F22625120630');
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-25','F226251206307','2026-07-25','12:06:30','TIN','895000','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-260725-0039','D','2026-07-25','12:06:30','kasir','PENJUALAN','F226251206307','12572831000','895000','12573726000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='895000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251206307' 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 ('F226251206308','kasir',' 1',' MEF3 13K L','TOKO','SMBK-F','F3E-ZGAD-32-T','GL MODEL PAJERO SLEP LG 8K ','OL','2.410','1','100.00','2518000','0','0','15000','2530000','0','13000','0','2543000','TIN','T0081109','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGAD-32-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.410',berat_jual_asli=berat_jual_asli+'2.410',stock_jual='1',berat_akhir=berat_akhir-'2.410',berat_akhir_asli=berat_akhir_asli-'2.410',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='F3E-ZGAD-32-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 ('F226251206308','2026-07-25','2.410','2026-07-25','12:06:30','PLG0082626','2530000','2530000','13000','2543000','2543000','kasir','2026-07-25 12:06:30','F22625120630');
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-25','F226251206308','2026-07-25','12:06:30','TIN','2543000','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-260725-0040','D','2026-07-25','12:06:30','kasir','PENJUALAN','F226251206308','12573726000','2543000','12576269000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2543000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251206308' 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 ('F226251206309','kasir',' 1',' MEH1 X UB ','TOKO','SMBK-H','H1E-ZGBA-91-0','KL X TIFF RIBBON MATA VAR UB 8K ','OL','1.680','1','100.00','1756000','0','0','15000','1764000','0','8000','0','1772000','TIN','00414573','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGBA-91-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.680',berat_jual_asli=berat_jual_asli+'1.680',stock_jual='1',berat_akhir=berat_akhir-'1.680',berat_akhir_asli=berat_akhir_asli-'1.680',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='H1E-ZGBA-91-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 ('F226251206309','2026-07-25','1.680','2026-07-25','12:06:30','PLG0082627','1764000','1764000','8000','1772000','1772000','kasir','2026-07-25 12:06:30','F22625120630');
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-25','F226251206309','2026-07-25','12:06:30','TIN','1772000','8000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260725-0041','D','2026-07-25','12:06:30','kasir','PENJUALAN','F226251206309','12576269000','1772000','12578041000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1772000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251206309' 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 ('F226251220071','kasir','1',' TFB1 X HK ','TOKO','TBK-B','B1TF-YDBC-49-T','GW X TOGE MODEL MATA VAR HK 17K ','OLS XFRRG','0.500','1','100.00','965000','0','0','15000','1013000','0','128000','0','1141000','DIN','T0068863','B1TF','0','0','-','0','1930000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1TF-YDBC-49-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-25' AND kode_barang='B1TF-YDBC-49-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226251220071','2026-07-25','0.500','2026-07-25','12:20:08','PLG0082628','1013000','1013000','128000','1141000','1141000','kasir','2026-07-25 12:20:07','F22625122007');
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-25','F226251220071','2026-07-25','12:20:08','DIN','1141000','128000');
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-260725-0042','D','2026-07-25','12:20:08','kasir','PENJUALAN','F226251220071','12578041000','1141000','12579182000');
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 ('F226251221281','kasir','1',' MEH1 UB 34','TOKO','SMBK-H','H1E-ZDXI-23-T','KL ANAK GUCCI UB 34CM 8K ','OLS WQTM6','1.050','1','100.00','1097000','0','0','15000','1150000','0','115000','0','1265000','DIN','T0078615','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDXI-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='H1E-ZDXI-23-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 ('F226251221281','2026-07-25','1.050','2026-07-25','12:21:29','PLG0082629','1150000','1150000','115000','1265000','1265000','kasir','2026-07-25 12:21:28','F22625122128');
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-25','F226251221281','2026-07-25','12:21:29','DIN','1265000','115000');
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-260725-0043','D','2026-07-25','12:21:29','kasir','PENJUALAN','F226251221281','12579182000','1265000','12580447000');
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 ('F226251222261','kasir','1',' MEH1E KH 4','TOKO','SMBK-H','H1E-ZGXB-117-T','KL SANTA KH 42 8K ','OLS A0RP7','1.530','1','100.00','1599000','0','0','15000','1675000','0','150000','0','1825000','DIN','T0080945','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGXB-117-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.530',berat_jual_asli=berat_jual_asli+'1.530',stock_jual='1',berat_akhir=berat_akhir-'1.530',berat_akhir_asli=berat_akhir_asli-'1.530',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='H1E-ZGXB-117-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 ('F226251222261','2026-07-25','1.530','2026-07-25','12:22:27','PLG0082630','1675000','1675000','150000','1825000','1825000','kasir','2026-07-25 12:22:26','F22625122226');
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-25','F226251222261','2026-07-25','12:22:27','DIN','1825000','150000');
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-260725-0044','D','2026-07-25','12:22:27','kasir','PENJUALAN','F226251222261','12580447000','1825000','12582272000');
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 ('F226251240491','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZGBA-222-0','CC X MODEL MATA CM 14 8K ','OL','1.010','1','100.00','1035000','0','0','15000','1040000','0','5000','0','1045000','LUS','00414704','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGBA-222-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='E2D-ZGBA-222-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 ('F226251240491','2026-07-25','1.010','2026-07-25','12:40:50','PLG0082631','1040000','1040000','5000','1045000','1045000','kasir','2026-07-25 12:40:49','F22625124049');
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-25','F226251240491','2026-07-25','12:40:50','LUS','1045000','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-260725-0045','D','2026-07-25','12:40:50','kasir','PENJUALAN','F226251240491','12582272000','1045000','12583317000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1045000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251240491' 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 ('F226251240492','kasir',' 1',' MEF1E YT 5','TOKO','SMBK-F','F1E-ZGXB-95-T','GL OVAL C SLEP YT 54 8K ','OL','2.070','1','100.00','2163000','0','0','15000','2175000','0','10000','0','2185000','LUS','T0080923','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZGXB-95-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-25' AND kode_barang='F1E-ZGXB-95-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 ('F226251240492','2026-07-25','2.070','2026-07-25','12:40:50','PLG0082632','2175000','2175000','10000','2185000','2185000','kasir','2026-07-25 12:40:49','F22625124049');
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-25','F226251240492','2026-07-25','12:40:50','LUS','2185000','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-260725-0046','D','2026-07-25','12:40:50','kasir','PENJUALAN','F226251240492','12583317000','2185000','12585502000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2185000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226251240492' 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 ('F226251249311','kasir','1',' MDA1 X HW ','TOKO','SMBK-A','A1D-ZGBX-220-0','AT X MODEL ITALY SLEP HW 8K ','OL','1.380','1','100.00','1414000','0','0','15000','1421000','0','7000','0','1428000','LUS','00414421','A1D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZGBX-220-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.380',berat_jual_asli=berat_jual_asli+'1.380',stock_jual='1',berat_akhir=berat_akhir-'1.380',berat_akhir_asli=berat_akhir_asli-'1.380',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='A1D-ZGBX-220-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 ('F226251249311','2026-07-25','1.380','2026-07-25','12:49:32','PLG0082633','1421000','1421000','7000','1428000','1428000','kasir','2026-07-25 12:49:31','F22625124931');
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-25','F226251249311','2026-07-25','12:49:32','LUS','1428000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260725-0047','D','2026-07-25','12:49:32','kasir','PENJUALAN','F226251249311','12585502000','1428000','12586930000');
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 ('F226251250001','kasir','1',' MEF3E X HW','TOKO','SMBK-F','F3E-ZFXC-188-0','GL X TIFF SLEP VAR HW 8K ','OL','1.280','1','100.00','1338000','0','0','15000','1344000','0','6000','0','1350000','LUS','00406731','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFXC-188-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.280',berat_jual_asli=berat_jual_asli+'1.280',stock_jual='1',berat_akhir=berat_akhir-'1.280',berat_akhir_asli=berat_akhir_asli-'1.280',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='F3E-ZFXC-188-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 ('F226251250001','2026-07-25','1.280','2026-07-25','12:50:01','PLG0082634','1344000','1344000','6000','1350000','1350000','kasir','2026-07-25 12:50:00','F22625125000');
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-25','F226251250001','2026-07-25','12:50:01','LUS','1350000','6000');
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-260725-0048','D','2026-07-25','12:50:01','kasir','PENJUALAN','F226251250001','12586930000','1350000','12588280000');
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 ('F226250121001','kasir','1',' MDD1 X 5K ','TOKO','SMBK-D','D1D-ZGAD-2-T','LT X MODEL FG SLEP LG 8K ','OL','0.980','1','100.00','1004000','0','0','15000','1014000','0','5000','0','1019000','TIN','T0081079','D1D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1D-ZGAD-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='D1D-ZGAD-2-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226250121001','2026-07-25','0.980','2026-07-25','13:21:01','PLG0082635','1014000','1014000','5000','1019000','1019000','kasir','2026-07-25 13:21:00','F22625012100');
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-25','F226250121001','2026-07-25','13:21:01','TIN','1019000','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-260725-0049','D','2026-07-25','13:21:01','kasir','PENJUALAN','F226250121001','12588280000','1019000','12589299000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1019000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250121001' 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 ('F226250121002','kasir',' 1',' MEF3E HW ','TOKO','SMBK-F','F3E-ZGBD-150-T','GL KOREA VAR SELP HW 8K ','OL','1.300','1','100.00','1358000','0','0','15000','1365000','0','7000','0','1372000','TIN','T0081577','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGBD-150-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.300',berat_jual_asli=berat_jual_asli+'1.300',stock_jual='1',berat_akhir=berat_akhir-'1.300',berat_akhir_asli=berat_akhir_asli-'1.300',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='F3E-ZGBD-150-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 ('F226250121002','2026-07-25','1.300','2026-07-25','13:21:01','PLG0082636','1365000','1365000','7000','1372000','1372000','kasir','2026-07-25 13:21:00','F22625012100');
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-25','F226250121002','2026-07-25','13:21:01','TIN','1372000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260725-0050','D','2026-07-25','13:21:01','kasir','PENJUALAN','F226250121002','12589299000','1372000','12590671000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1372000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250121002' 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 ('F226250121003','kasir',' 1',' MEH1E UB 4','TOKO','SMBK-H','H1E-ZGBD-171-T','KL TIFF PITA MATA VAR SLEP UB 42 8K ','OL','1.360','1','100.00','1421000','0','0','15000','1428000','0','7000','0','1435000','TIN','T0081598','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGBD-171-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.360',berat_jual_asli=berat_jual_asli+'1.360',stock_jual='1',berat_akhir=berat_akhir-'1.360',berat_akhir_asli=berat_akhir_asli-'1.360',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='H1E-ZGBD-171-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 ('F226250121003','2026-07-25','1.360','2026-07-25','13:21:01','PLG0082637','1428000','1428000','7000','1435000','1435000','kasir','2026-07-25 13:21:00','F22625012100');
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-25','F226250121003','2026-07-25','13:21:01','TIN','1435000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260725-0051','D','2026-07-25','13:21:01','kasir','PENJUALAN','F226250121003','12590671000','1435000','12592106000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1435000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250121003' 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 ('F226250127501','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZGXI-281-0','CC X MODEL MATA CM 16 8K ','','1.000','1','100.00','1025000','0','0','15000','1025000','0','0','0','1025000','RHM','00413000','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGXI-281-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-25' AND kode_barang='E2D-ZGXI-281-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 ('F226250127501','2026-07-25','1.000','2026-07-25','13:27:51','PLG0082638','1025000','1025000','0','1025000','1025000','kasir','2026-07-25 13:27:50','F22625012750');
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-25','F226250127501','2026-07-25','13:27:51','RHM','1025000','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-260725-0052','D','2026-07-25','13:27:51','kasir','PENJUALAN','F226250127501','12592106000','1025000','12593131000');
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 ('F226250231061','kasir','1',' MEF3 11K K','TOKO','SMBK-F','F3E-ZGBD-126-T','GL RANTAI P3 SLEP KH 8K ','','2.100','1','100.00','2194000','0','0','15000','2195000','0','11000','0','2206000','DIN','T0081553','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGBD-126-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='F3E-ZGBD-126-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 ('F226250231061','2026-07-25','2.100','2026-07-25','14:31:07','PLG0082639','2195000','2195000','11000','2206000','2206000','kasir','2026-07-25 14:31:06','F22625023106');
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-25','F226250231061','2026-07-25','14:31:07','DIN','2206000','11000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260725-0053','D','2026-07-25','14:31:07','kasir','PENJUALAN','F226250231061','12593131000','2206000','12595337000');
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 ('F226250239421','kasir','1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZGAE-11-T','CC MODEL DAUN SLEP LG 14 8K ','','0.500','1','100.00','522000','0','0','15000','523000','0','0','0','523000','DIN','T0081156','E1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGAE-11-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-25' AND kode_barang='E1E-ZGAE-11-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226250239421','2026-07-25','0.500','2026-07-25','14:39:43','PLG0082640','523000','523000','0','523000','523000','kasir','2026-07-25 14:39:42','F22625023942');
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-25','F226250239421','2026-07-25','14:39:43','DIN','523000','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-260725-0054','D','2026-07-25','14:39:43','kasir','PENJUALAN','F226250239421','12595337000','523000','12595860000');
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 ('F226250246231','kasir','1',' MFE1F KH 1','TOKO','SMBK-E','E1F-ZGBD-30-T','CC MODEL SPECTRA SLEP KH 10 8K ','','0.330','1','100.00','351000','0','0','15000','351000','0','0','0','351000','LUS','T0081457','E1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGBD-30-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.330',berat_jual_asli=berat_jual_asli+'0.330',stock_jual='1',berat_akhir=berat_akhir-'0.330',berat_akhir_asli=berat_akhir_asli-'0.330',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='E1F-ZGBD-30-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226250246231','2026-07-25','0.330','2026-07-25','14:46:24','PLG0082641','351000','351000','0','351000','351000','kasir','2026-07-25 14:46:23','F22625024623');
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-25','F226250246231','2026-07-25','14:46:24','LUS','351000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260725-0055','D','2026-07-25','14:46:24','kasir','PENJUALAN','F226250246231','12595860000','351000','12596211000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='351000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250246231' 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 ('F226250246232','kasir',' 1',' MFE1F LG 1','TOKO','SMBK-E','E1F-ZGBD-5-T','CC MODEL ISYANA SLEP LG 10 8K ','','0.380','1','100.00','405000','0','0','15000','405000','0','0','0','405000','LUS','T0081432','E1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGBD-5-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-25' AND kode_barang='E1F-ZGBD-5-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 ('F226250246232','2026-07-25','0.380','2026-07-25','14:46:24','PLG0082642','405000','405000','0','405000','405000','kasir','2026-07-25 14:46:23','F22625024623');
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-25','F226250246232','2026-07-25','14:46:24','LUS','405000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260725-0056','D','2026-07-25','14:46:24','kasir','PENJUALAN','F226250246232','12596211000','405000','12596616000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='405000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226250246232' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250121001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250121001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250121001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250121002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250121002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250121002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250121003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250121003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250121003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250127501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250127501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250127501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250231061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250231061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250231061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250239421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250239421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250239421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250246231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250246231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250246231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250246232' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250246232' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250246232';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250853231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250853231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250853231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250853232' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250853232' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250853232';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250853233' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250853233' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250853233';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250853234' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250853234' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250853234';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250853235' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250853235' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250853235';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251000481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251000481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251000481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251001211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251001211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251001211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251003151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251003151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251003151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251004511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251004511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251004511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251004512' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251004512' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251004512';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251004513' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251004513' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251004513';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251006431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251006431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251006431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251006432' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251006432' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251006432';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251006433' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251006433' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251006433';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251006434' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251006434' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251006434';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251013341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251013341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251013341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251020371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251020371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251020371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251021481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251021481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251021481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251041531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251041531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251041531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251041532' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251041532' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251041532';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251041533' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251041533' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251041533';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251041534' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251041534' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251041534';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251102461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251102461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251102461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251102462' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251102462' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251102462';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251122441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251122441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251122441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251140031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251140031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251140031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251140571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251140571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251140571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251140572' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251140572' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251140572';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251140573' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251140573' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251140573';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251141571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251141571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251141571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251141572' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251141572' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251141572';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251141573' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251141573' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251141573';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251206301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251206301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251206301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251206302' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251206302' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251206302';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251206303' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251206303' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251206303';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251206304' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251206304' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251206304';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251206305' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251206305' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251206305';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251206306' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251206306' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251206306';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251206307' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251206307' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251206307';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251206308' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251206308' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251206308';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251206309' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251206309' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251206309';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251220071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251220071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251220071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251221281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251221281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251221281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251222261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251222261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251222261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251240491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251240491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251240491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251240492' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251240492' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251240492';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251249311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251249311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251249311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226251250001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226251250001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226251250001';
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 ('F226250300431','kasir','1',' MEF1E TD 5','TOKO','SMBK-F','F1E-ZGBD-133-T','GL OVAL C SLEP TD 56 8K ','OL','4.760','1','100.00','4974000','0','0','15000','4998000','0','24000','0','5022000','LUS','T0081560','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZGBD-133-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.760',berat_jual_asli=berat_jual_asli+'4.760',stock_jual='1',berat_akhir=berat_akhir-'4.760',berat_akhir_asli=berat_akhir_asli-'4.760',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='F1E-ZGBD-133-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 ('F226250300431','2026-07-25','4.760','2026-07-25','15:00:44','PLG0082643','4998000','4998000','24000','5022000','5022000','kasir','2026-07-25 15:00:43','F22625030043');
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-25','F226250300431','2026-07-25','15:00:44','LUS','5022000','24000');
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-260725-0057','D','2026-07-25','15:00:44','kasir','PENJUALAN','F226250300431','12596616000','5022000','12601638000');
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-00005562','X-00005562','GL RANTAI HOLLOW KLINTING VAR KH 8K','GR','---','F3E','BELI','BELI001','942000','2026-07-25','1.510','1','kasir','2026-07-25 15:15:06');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00005562','X-00005562');
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-260725-0001','F225290854511','DIN','1','BELI','BELI001','F3E', 'X-00005562', 'GL RANTAI HOLLOW KLINTING VAR KH 8K','1.510','1.510','100.00','1178000','942000','623841','1045000','1','942000','942000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.510',berat_beli_asli=berat_beli_asli+'1.510',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.510',berat_akhir_asli=berat_akhir_asli+'1.510',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260725-0001','2026-07-25','2026-07-25','15:15:05','DIN','---','1.510','942000','942000','942000','942000','942000','kasir','2026-07-25 15:15:06','FB-260725-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260725-0001','AMELIA DWI','PONOROGO','','','0895334083800','kasir','2026-07-25 15:15:06');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-25' 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-260725-0058','K','2026-07-25','15:15:05','kasir','PEMBELIAN UMUM','FB-260725-0001','12601638000','942000','12600696000');
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-00005563','X-00005563','GL OVAL C SLEP UB 54 8K','GR','---','F1E','BELI','BELI001','1805000','2026-07-25','2.160','1','kasir','2026-07-25 15:21:29');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00005563','X-00005563');
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-260725-0002','F225190223241','NOV','1','BELI','BELI001','F1E', 'X-00005563', 'GL OVAL C SLEP UB 54 8K','2.160','2.160','100.00','2305000','1805000','835648','1045000','1','1805000','1805000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.160',berat_beli_asli=berat_beli_asli+'2.160',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.160',berat_akhir_asli=berat_akhir_asli+'2.160',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' 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-260725-0002','2026-07-25','2026-07-25','15:21:29','NOV','---','2.160','1805000','1805000','1805000','1805000','1805000','kasir','2026-07-25 15:21:29','FB-260725-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260725-0002','DWI SRI W.','SINGAHAN PULUNG','','','088217694658','kasir','2026-07-25 15:21:29');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-25' 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-260725-0059','K','2026-07-25','15:21:29','kasir','PEMBELIAN UMUM','FB-260725-0002','12600696000','1805000','12598891000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250300431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250300431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250300431';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260725-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260725-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260725-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260725-0002';
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 ('F226250356501','kasir','1',' MED1 5K LG','TOKO','SMBK-D','D1E-ZGXB-44-T','LT MODEL SOLITAIRE MATA SLEP LG 8K ','','0.550','1','100.00','575000','0','0','15000','575000','0','5000','0','580000','NOV','T0080872','D1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZGXB-44-T' 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-25' AND kode_barang='D1E-ZGXB-44-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 ('F226250356501','2026-07-25','0.550','2026-07-25','15:56:51','PLG0082644','575000','575000','5000','580000','580000','kasir','2026-07-25 15:56:50','F22625035650');
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-25','F226250356501','2026-07-25','15:56:51','NOV','580000','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-260725-0060','D','2026-07-25','15:56:51','kasir','PENJUALAN','F226250356501','12598891000','580000','12599471000');
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 ('F226250405561','kasir','1',' MEE2E CM 1','TOKO','SMBK-E','E2E-ZGAH-17-T','CC MODEL SOLITAIRE MATA SLEP CM 16 8K ','','0.710','1','100.00','742000','0','0','15000','742000','0','0','0','742000','DIN','T0081322','E2E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZGAH-17-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.710',berat_jual_asli=berat_jual_asli+'0.710',stock_jual='1',berat_akhir=berat_akhir-'0.710',berat_akhir_asli=berat_akhir_asli-'0.710',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='E2E-ZGAH-17-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 ('F226250405561','2026-07-25','0.710','2026-07-25','16:05:56','PLG0082645','742000','742000','0','742000','0','kasir','2026-07-25 16:05:56','F22625040556');
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-25','F226250405561','2026-07-25','16:05:56','DIN','742000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260725-0002','2026-07-25','2026-07-25 16:05:56','PENJUALAN : F226250405561','0987654321','BCA','742000','742000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260725-0003','D','2026-07-25','16:05:56','BCA','PENJUALAN','F226250405561','4640734888','742000','4641476888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0987654321','ALFI');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250405561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250405561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250405561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='';
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 ('F226250408371','kasir','1',' MEH1 X AY ','TOKO','SMBK-H','H1E-ZAAC-165-0','KL X TRIXIE NAGITA HURUF AY A 8K ','','2.000','1','100.00','2090000','0','0','15000','2090000','0','0','0','2090000','DIN','00385072','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZAAC-165-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-07-25' AND kode_barang='H1E-ZAAC-165-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 ('F226250408371','2026-07-25','2.000','2026-07-25','16:08:37','PLG0082646','2090000','2090000','0','2090000','0','kasir','2026-07-25 16:08:37','F22625040837');
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-25','F226250408371','2026-07-25','16:08:37','DIN','2090000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260725-0003','2026-07-25','2026-07-25 16:08:37','PENJUALAN : F226250408371','098877654321','BCA','2090000','2090000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260725-0004','D','2026-07-25','16:08:37','BCA','PENJUALAN','F226250408371','4641476888','2090000','4643566888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('098877654321','ALFI');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2090000' WHERE no_faktur_jual='F226250408371' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250356501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250356501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250356501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226250408371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226250408371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226250408371';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-26','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-25';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-25';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-25';
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-25' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-25';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-25';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-25';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-25';
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-26' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-25' 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-260726-0001','D','2026-07-26','16:19:11','SYSTEM','SALDO AWAL','SALDO AWAL','0','12599471000','12599471000');
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-260726-0001','D','2026-07-26','16:19:11','BCA','SALDO AWAL','SALDO AWAL','0','4643566888','4643566888');
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-260726-0001','D','2026-07-26','16:19:11','','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-260726-0001','D','2026-07-26','16:19:11','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-260726-0001','D','2026-07-26','16:19:11','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-260726-0001','D','2026-07-26','16:19:11','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-07-26';