INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-09-01','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-08-01';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-08-31';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-08-31';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-08-31' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-08-31';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-08-31';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-08-31';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-08-31';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202507 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
UPDATE tt_barang_saldo SET tanggal= '2025-09-01' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-08-31' 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-250901-0001','D','2025-09-01','07:44:01','SYSTEM','SALDO AWAL','SALDO AWAL','0','211492000','211492000');
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-250901-0001','D','2025-09-01','07:44:01','BCA','SALDO AWAL','SALDO AWAL','0','3944381888','3944381888');
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-250901-0001','D','2025-09-01','07:44:01','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-250901-0001','D','2025-09-01','07:44:01','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-250901-0001','D','2025-09-01','07:44:01','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250901-0001','D','2025-09-01','07:44:01','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2025-09-01';
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 ('F225010917091','kasir','1',' MFF3 HW ','TOKO','SMBK-F','F3F-YGAB-8-T','GL PITON SABITO VAR HW 8K ','','1.770','1','100.00','1490000','0','0','15000','1560000','0','0','0','1560000','NS','T0070891','F3F','0','0','-','0','862000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YGAB-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.770',berat_jual_asli=berat_jual_asli+'1.770',stock_jual='1',berat_akhir=berat_akhir-'1.770',berat_akhir_asli=berat_akhir_asli-'1.770',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='F3F-YGAB-8-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225010917091','2025-09-01','1.770','2025-09-01','09:17:09','PLG0072096','1560000','1560000','0','1560000','1560000','kasir','2025-09-01 09:17:09','F22501091709');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225010917091','2025-09-01','09:17:09','NS','1560000','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-250901-0002','D','2025-09-01','09:17:09','kasir','PENJUALAN','F225010917091','211492000','1560000','213052000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1560000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225010917091' 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 ('F225010917092','kasir',' 1',' MFF3 UB ','TOKO','SMBK-F','F3F-YHAE-71-T','GL KOREA UB 8K ','','2.070','1','100.00','1743000','0','0','15000','1825000','0','0','0','1825000','NS','T0072371','F3F','0','0','-','0','862000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YHAE-71-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='2025-09-01' AND kode_barang='F3F-YHAE-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 ('F225010917092','2025-09-01','2.070','2025-09-01','09:17:09','PLG0072097','1825000','1825000','0','1825000','1825000','kasir','2025-09-01 09:17:09','F22501091709');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225010917092','2025-09-01','09:17:09','NS','1825000','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-250901-0003','D','2025-09-01','09:17:09','kasir','PENJUALAN','F225010917092','213052000','1825000','214877000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1825000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225010917092' 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 ('F225010937121','kasir','1',' MDA1D X LG','TOKO','SMBK-A','A1D-YGAG-32-0','AQT X HUGGIES KLIP MATA VAR LG 8K ','OL','1.430','1','100.00','1155000','0','0','15000','1247000','0','10000','0','1257000','NS','00361117','A1D','0','0','-','0','847000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YGAG-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.430',berat_jual_asli=berat_jual_asli+'1.430',stock_jual='1',berat_akhir=berat_akhir-'1.430',berat_akhir_asli=berat_akhir_asli-'1.430',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='A1D-YGAG-32-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 ('F225010937121','2025-09-01','1.430','2025-09-01','09:37:12','PLG0072098','1247000','1247000','10000','1257000','1257000','kasir','2025-09-01 09:37:12','F22501093712');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225010937121','2025-09-01','09:37:12','NS','1257000','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-250901-0004','D','2025-09-01','09:37:12','kasir','PENJUALAN','F225010937121','214877000','1257000','216134000');
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 ('F225011006161','kasir','1',' MEE1 CM 14','TOKO','SMBK-E','E1E-YHBH-183-T','CC MODEL PASIR SLEP VAR CM 14 8K ','OL','0.630','1','100.00','524000','0','0','15000','555000','0','5000','0','560000','RTA','T0072679','E1E','0','0','-','0','864000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YHBH-183-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.630',berat_jual_asli=berat_jual_asli+'0.630',stock_jual='1',berat_akhir=berat_akhir-'0.630',berat_akhir_asli=berat_akhir_asli-'0.630',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='E1E-YHBH-183-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 ('F225011006161','2025-09-01','0.630','2025-09-01','10:06:16','PLG0072099','555000','555000','5000','560000','560000','kasir','2025-09-01 10:06:16','F22501100616');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011006161','2025-09-01','10:06:16','RTA','560000','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-250901-0005','D','2025-09-01','10:06:16','kasir','PENJUALAN','F225011006161','216134000','560000','216694000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='560000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011006161' 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 ('F225011006162','kasir',' 1',' MEB1 LG PE','TOKO','SMBK-B','B1E-YHBH-158-T','GW TUSUK AUREL MATA LG PE 8K ','OL','0.550','1','100.00','458000','0','0','15000','483000','0','5000','0','488000','RTA','T0072654','B1E','0','0','-','0','864000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YHBH-158-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='2025-09-01' AND kode_barang='B1E-YHBH-158-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 ('F225011006162','2025-09-01','0.550','2025-09-01','10:06:16','PLG0072100','483000','483000','5000','488000','488000','kasir','2025-09-01 10:06:16','F22501100616');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011006162','2025-09-01','10:06:16','RTA','488000','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-250901-0006','D','2025-09-01','10:06:16','kasir','PENJUALAN','F225011006162','216694000','488000','217182000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='488000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011006162' 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 ('F225011024281','kasir','1',' MEH1 UB ','TOKO','SMBK-H','H1E-YHXD-7-T','KL TRIXIE MODEL PITA MATA VAR UB 8K ','OL','1.360','1','100.00','1122000','0','0','15000','1188000','0','7000','0','1195000','RTA','T0071767','H1E','0','0','-','0','864000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YHXD-7-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='2025-09-01' AND kode_barang='H1E-YHXD-7-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 ('F225011024281','2025-09-01','1.360','2025-09-01','10:24:28','PLG0072101','1188000','1188000','7000','1195000','1195000','kasir','2025-09-01 10:24:28','F22501102428');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011024281','2025-09-01','10:24:28','RTA','1195000','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-250901-0007','D','2025-09-01','10:24:28','kasir','PENJUALAN','F225011024281','217182000','1195000','218377000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1195000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011024281' 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 ('F225011024282','kasir',' 1',' MEE2 10K L','TOKO','SMBK-E','E2E-XGXE-51-T','CC MODEL MATA SLEP VAR LG 14 8K ','OL','1.380','1','100.00','1138000','0','0','15000','1203000','0','10000','0','1213000','RTA','T0059041','E2E','0','0','-','0','864000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-XGXE-51-T' 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='2025-09-01' AND kode_barang='E2E-XGXE-51-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225011024282','2025-09-01','1.380','2025-09-01','10:24:28','PLG0072102','1203000','1203000','10000','1213000','1213000','kasir','2025-09-01 10:24:28','F22501102428');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011024282','2025-09-01','10:24:28','RTA','1213000','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-250901-0008','D','2025-09-01','10:24:28','kasir','PENJUALAN','F225011024282','218377000','1213000','219590000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1213000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011024282' 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 ('F225011024283','kasir',' 1',' MEE1 CM 12','TOKO','SMBK-E','E1E-YHBH-188-T','CC MODEL PASIR SLEP VAR CM 12 8K ','OL','0.620','1','100.00','516000','0','0','15000','545000','0','5000','0','550000','RTA','T0072684','E1E','0','0','-','0','864000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YHBH-188-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='2025-09-01' AND kode_barang='E1E-YHBH-188-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 ('F225011024283','2025-09-01','0.620','2025-09-01','10:24:28','PLG0072103','545000','545000','5000','550000','550000','kasir','2025-09-01 10:24:28','F22501102428');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011024283','2025-09-01','10:24:28','RTA','550000','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-250901-0009','D','2025-09-01','10:24:28','kasir','PENJUALAN','F225011024283','219590000','550000','220140000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='550000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011024283' 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 ('F225011024284','kasir',' 1',' MEB1 LG PE','TOKO','SMBK-B','B1E-YHBH-160-T','GW TUSUK AUREL MATA LG PE 8K ','OL','0.500','1','100.00','416000','0','0','15000','440000','0','5000','0','445000','RTA','T0072656','B1E','0','0','-','0','864000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YHBH-160-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='2025-09-01' AND kode_barang='B1E-YHBH-160-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 ('F225011024284','2025-09-01','0.500','2025-09-01','10:24:28','PLG0072104','440000','440000','5000','445000','445000','kasir','2025-09-01 10:24:28','F22501102428');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011024284','2025-09-01','10:24:28','RTA','445000','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-250901-0010','D','2025-09-01','10:24:28','kasir','PENJUALAN','F225011024284','220140000','445000','220585000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='445000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011024284' 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 ('F225011024285','kasir',' 1',' MDA1D X YT','TOKO','SMBK-A','A1D-YHXI-25-0','AT X HUGGIES SPECTRA HITAM VAR YT 8K ','OL','1.310','1','100.00','1068000','0','0','15000','1141000','0','10000','0','1151000','RTA','00364889','A1D','0','0','-','0','847000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YHXI-25-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.310',berat_jual_asli=berat_jual_asli+'1.310',stock_jual='1',berat_akhir=berat_akhir-'1.310',berat_akhir_asli=berat_akhir_asli-'1.310',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='A1D-YHXI-25-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 ('F225011024285','2025-09-01','1.310','2025-09-01','10:24:28','PLG0072105','1141000','1141000','10000','1151000','1151000','kasir','2025-09-01 10:24:28','F22501102428');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011024285','2025-09-01','10:24:28','RTA','1151000','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-250901-0011','D','2025-09-01','10:24:28','kasir','PENJUALAN','F225011024285','220585000','1151000','221736000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1151000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011024285' 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 ('F225011024286','kasir',' 1',' MFD1F X YT','TOKO','SMBK-D','D1F-YHBH-24-0','LT X MODEL SPECTRA HITAM YT 8K ','OL','0.320','1','100.00','276000','0','0','15000','287000','0','5000','0','292000','RTA','00367010','D1F','0','0','-','0','862000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YHBH-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.320',berat_jual_asli=berat_jual_asli+'0.320',stock_jual='1',berat_akhir=berat_akhir-'0.320',berat_akhir_asli=berat_akhir_asli-'0.320',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='D1F-YHBH-24-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 ('F225011024286','2025-09-01','0.320','2025-09-01','10:24:28','PLG0072106','287000','287000','5000','292000','292000','kasir','2025-09-01 10:24:28','F22501102428');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011024286','2025-09-01','10:24:28','RTA','292000','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-250901-0012','D','2025-09-01','10:24:28','kasir','PENJUALAN','F225011024286','221736000','292000','222028000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='292000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011024286' 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 ('F225011036121','kasir','1',' MEA1 5K LG','TOKO','SMBK-A','A1E-YHBX-262-0','AT BONEKA ANAK MATA CAT LG 8K ','OL','0.540','1','100.00','467000','0','0','15000','472000','0','5000','0','477000','TJ','00366540','A1E','0','0','-','0','864000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YHBX-262-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.540',berat_jual_asli=berat_jual_asli+'0.540',stock_jual='1',berat_akhir=berat_akhir-'0.540',berat_akhir_asli=berat_akhir_asli-'0.540',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='A1E-YHBX-262-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 ('F225011036121','2025-09-01','0.540','2025-09-01','10:36:13','PLG0072107','472000','472000','5000','477000','477000','kasir','2025-09-01 10:36:12','F22501103612');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011036121','2025-09-01','10:36:13','TJ','477000','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-250901-0013','D','2025-09-01','10:36:13','kasir','PENJUALAN','F225011036121','222028000','477000','222505000');
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 ('F225011036461','kasir','1',' MEA1E X LG','TOKO','SMBK-A','A1E-YGBF-9-0','AT X MODEL APEL CAT MATA VAR LG 8K ','OL','0.520','1','100.00','432000','0','0','15000','464000','0','5000','0','469000','TJ','00362665','A1E','0','0','-','0','864000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YGBF-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='A1E-YGBF-9-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 ('F225011036461','2025-09-01','0.520','2025-09-01','10:36:47','PLG0072108','464000','464000','5000','469000','0','kasir','2025-09-01 10:36:46','F22501103646');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011036461','2025-09-01','10:36:47','TJ','469000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250901-0001','2025-09-01','2025-09-01 10:36:46','PENJUALAN : F225011036461','6325872469428','BCA','469000','469000','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-250901-0002','D','2025-09-01','10:36:47','BCA','PENJUALAN','F225011036461','3944381888','469000','3944850888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('6325872469428','LIYA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='469000' WHERE no_faktur_jual='F225011036461' 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 ('F225011037391','kasir','1',' MFF3 UB ','TOKO','SMBK-F','F3F-YHCX-15-T','GL KAKI RANTAI HOLLOW UB 8K ','OL','0.520','1','100.00','448000','0','0','15000','464000','0','5000','0','469000','TJ','T0072726','F3F','0','0','-','0','862000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YHCX-15-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='2025-09-01' AND kode_barang='F3F-YHCX-15-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 ('F225011037391','2025-09-01','0.520','2025-09-01','10:37:39','PLG0072109','464000','464000','5000','469000','0','kasir','2025-09-01 10:37:39','F22501103739');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011037391','2025-09-01','10:37:39','TJ','469000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250901-0002','2025-09-01','2025-09-01 10:37:39','PENJUALAN : F225011037391','76493874084','BCA','469000','469000','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-250901-0003','D','2025-09-01','10:37:39','BCA','PENJUALAN','F225011037391','3944850888','469000','3945319888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('76493874084','LIYA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='469000' WHERE no_faktur_jual='F225011037391' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011036461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011036461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011036461';
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 ('F225011039341','kasir','1',' MEA1E X LG','TOKO','SMBK-A','A1E-YGBF-9-0','AT X MODEL APEL CAT MATA VAR LG 8K ','OL','0.520','1','100.00','432000','0','0','15000','455000','0','5000','0','460000','TJ','00362665','A1E','0','0','-','0','864000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YGBF-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='A1E-YGBF-9-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 ('F225011039341','2025-09-01','0.520','2025-09-01','10:39:34','PLG0072110','455000','455000','5000','460000','0','kasir','2025-09-01 10:39:34','F22501103934');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011039341','2025-09-01','10:39:34','TJ','460000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250901-0003','2025-09-01','2025-09-01 10:39:34','PENJUALAN : F225011039341','794398470349','BCA','460000','460000','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-250901-0004','D','2025-09-01','10:39:34','BCA','PENJUALAN','F225011039341','3945319888','460000','3945779888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('794398470349','LIYA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='460000' WHERE no_faktur_jual='F225011039341' 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 ('F225011041081','kasir','1',' MEF1 TD D5','TOKO','SMBK-F','F1E-YHAI-88-T','GL OVAL MODEL C TD D58 8K ','OL','3.190','1','100.00','2632000','0','0','15000','2788000','0','16000','0','2804000','TJ','T0072428','F1E','0','0','-','0','864000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YHAI-88-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.190',berat_jual_asli=berat_jual_asli+'3.190',stock_jual='1',berat_akhir=berat_akhir-'3.190',berat_akhir_asli=berat_akhir_asli-'3.190',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='F1E-YHAI-88-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 ('F225011041081','2025-09-01','3.190','2025-09-01','10:41:08','PLG0072111','2788000','2788000','16000','2804000','2804000','kasir','2025-09-01 10:41:08','F22501104108');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011041081','2025-09-01','10:41:08','TJ','2804000','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-250901-0014','D','2025-09-01','10:41:08','kasir','PENJUALAN','F225011041081','222505000','2804000','225309000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2804000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011041081' 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 ('F225011041082','kasir',' 1',' MFF3 UB ','TOKO','SMBK-F','F3F-YHBH-179-T','GL KAKI RANTAI HOLLOW UB 8K ','OL','0.510','1','100.00','433000','0','0','15000','457000','0','5000','0','462000','TJ','T0072675','F3F','0','0','-','0','862000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YHBH-179-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='F3F-YHBH-179-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 ('F225011041082','2025-09-01','0.510','2025-09-01','10:41:08','PLG0072112','457000','457000','5000','462000','462000','kasir','2025-09-01 10:41:08','F22501104108');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011041082','2025-09-01','10:41:08','TJ','462000','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-250901-0015','D','2025-09-01','10:41:08','kasir','PENJUALAN','F225011041082','225309000','462000','225771000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='462000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011041082' 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 ('F225011041083','kasir',' 1',' MEB1 LG PE','TOKO','SMBK-B','B1E-YHBH-163-T','GW TUSUK MODEL PITA LG PE 8K ','OL','0.480','1','100.00','399000','0','0','15000','422000','0','5000','0','427000','TJ','T0072659','B1E','0','0','-','0','864000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YHBH-163-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='B1E-YHBH-163-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 ('F225011041083','2025-09-01','0.480','2025-09-01','10:41:08','PLG0072113','422000','422000','5000','427000','427000','kasir','2025-09-01 10:41:08','F22501104108');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011041083','2025-09-01','10:41:08','TJ','427000','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-250901-0016','D','2025-09-01','10:41:08','kasir','PENJUALAN','F225011041083','225771000','427000','226198000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='427000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011041083' 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 ('F225011041084','kasir',' 1',' MEB1 5K LG','TOKO','SMBK-B','B1E-YHBH-169-T','GW TUSUK APEL CAT VAR LG PE 8K ','OL','0.500','1','100.00','416000','0','0','15000','440000','0','5000','0','445000','TJ','T0072665','B1E','0','0','-','0','864000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YHBH-169-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='2025-09-01' AND kode_barang='B1E-YHBH-169-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 ('F225011041084','2025-09-01','0.500','2025-09-01','10:41:08','PLG0072114','440000','440000','5000','445000','445000','kasir','2025-09-01 10:41:08','F22501104108');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011041084','2025-09-01','10:41:08','TJ','445000','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-250901-0017','D','2025-09-01','10:41:08','kasir','PENJUALAN','F225011041084','226198000','445000','226643000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='445000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011041084' 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 ('F225011043261','kasir','1',' MEF1 15K U','TOKO','SMBK-F','F1E-YHXH-5-T','GL BANGKOK TIMBUL PASIR VAR UB D56 8K ','OL','3.000','1','100.00','2475000','0','0','15000','2623000','0','15000','0','2638000','TJ','T0072105','F1E','0','0','-','0','864000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YHXH-5-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.000',berat_jual_asli=berat_jual_asli+'3.000',stock_jual='1',berat_akhir=berat_akhir-'3.000',berat_akhir_asli=berat_akhir_asli-'3.000',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='F1E-YHXH-5-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 ('F225011043261','2025-09-01','3.000','2025-09-01','10:43:26','PLG0072115','2623000','2623000','15000','2638000','2638000','kasir','2025-09-01 10:43:26','F22501104326');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011043261','2025-09-01','10:43:26','TJ','2638000','15000');
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-250901-0018','D','2025-09-01','10:43:26','kasir','PENJUALAN','F225011043261','226643000','2638000','229281000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2638000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011043261' 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 ('F225011043262','kasir',' 1',' MGF3 UB ','TOKO','SMBK-F','F3G-YHCX-25-T','GL BORSALINO UB 8K ','OL','0.360','1','100.00','320000','0','0','15000','329000','0','5000','0','334000','TJ','T0072736','F3G','0','0','-','0','888000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3G-YHCX-25-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='2025-09-01' AND kode_barang='F3G-YHCX-25-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 ('F225011043262','2025-09-01','0.360','2025-09-01','10:43:26','PLG0072116','329000','329000','5000','334000','334000','kasir','2025-09-01 10:43:26','F22501104326');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011043262','2025-09-01','10:43:26','TJ','334000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250901-0019','D','2025-09-01','10:43:26','kasir','PENJUALAN','F225011043262','229281000','334000','229615000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='334000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011043262' 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 ('F225011043263','kasir',' 1',' MGF3 UB ','TOKO','SMBK-F','F3G-YHCX-23-T','GL BORSALINO UB 8K ','OL','0.360','1','100.00','320000','0','0','15000','329000','0','5000','0','334000','TJ','T0072734','F3G','0','0','-','0','888000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3G-YHCX-23-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='2025-09-01' AND kode_barang='F3G-YHCX-23-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 ('F225011043263','2025-09-01','0.360','2025-09-01','10:43:26','PLG0072117','329000','329000','5000','334000','334000','kasir','2025-09-01 10:43:26','F22501104326');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011043263','2025-09-01','10:43:26','TJ','334000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250901-0020','D','2025-09-01','10:43:26','kasir','PENJUALAN','F225011043263','229615000','334000','229949000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='334000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011043263' 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 ('F225011043264','kasir',' 1',' MGF3 UB ','TOKO','SMBK-F','F3G-YHCX-26-T','GL BORSALINO UB 8K ','OL','0.360','1','100.00','320000','0','0','15000','329000','0','5000','0','334000','TJ','T0072737','F3G','0','0','-','0','888000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3G-YHCX-26-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='2025-09-01' AND kode_barang='F3G-YHCX-26-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 ('F225011043264','2025-09-01','0.360','2025-09-01','10:43:26','PLG0072118','329000','329000','5000','334000','334000','kasir','2025-09-01 10:43:26','F22501104326');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011043264','2025-09-01','10:43:26','TJ','334000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250901-0021','D','2025-09-01','10:43:26','kasir','PENJUALAN','F225011043264','229949000','334000','230283000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='334000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011043264' 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 ('F225011043265','kasir',' 1',' MFF3 UB ','TOKO','SMBK-F','F3F-YHCX-20-T','GL KAKI RANTAI HOLLOW UB 8K ','OL','0.510','1','100.00','440000','0','0','15000','457000','0','5000','0','462000','TJ','T0072731','F3F','0','0','-','0','862000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YHCX-20-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='F3F-YHCX-20-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 ('F225011043265','2025-09-01','0.510','2025-09-01','10:43:26','PLG0072119','457000','457000','5000','462000','462000','kasir','2025-09-01 10:43:26','F22501104326');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011043265','2025-09-01','10:43:26','TJ','462000','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-250901-0022','D','2025-09-01','10:43:26','kasir','PENJUALAN','F225011043265','230283000','462000','230745000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='462000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011043265' 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 ('F225011043266','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-YHBA-18-T','GL MODEL FLIK VAR HW 8K ','OL','2.540','1','100.00','2095000','0','0','15000','2220000','0','13000','0','2233000','TJ','T0072448','F3E','0','0','-','0','864000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YHBA-18-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.540',berat_jual_asli=berat_jual_asli+'2.540',stock_jual='1',berat_akhir=berat_akhir-'2.540',berat_akhir_asli=berat_akhir_asli-'2.540',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='F3E-YHBA-18-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 ('F225011043266','2025-09-01','2.540','2025-09-01','10:43:26','PLG0072120','2220000','2220000','13000','2233000','2233000','kasir','2025-09-01 10:43:26','F22501104326');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011043266','2025-09-01','10:43:26','TJ','2233000','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-250901-0023','D','2025-09-01','10:43:26','kasir','PENJUALAN','F225011043266','230745000','2233000','232978000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2233000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011043266' 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 ('F225011045221','kasir','1',' MDE2 X LG ','TOKO','SMBK-E','E2D-YHBI-115-0','CC X SOLITAIRE MATA LG 16 8K ','OL','1.320','1','100.00','1105000','0','0','15000','1153000','0','7000','0','1160000','TJ','00367356','E2D','0','0','-','0','847000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YHBI-115-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.320',berat_jual_asli=berat_jual_asli+'1.320',stock_jual='1',berat_akhir=berat_akhir-'1.320',berat_akhir_asli=berat_akhir_asli-'1.320',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='E2D-YHBI-115-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225011045221','2025-09-01','1.320','2025-09-01','10:45:22','PLG0072121','1153000','1153000','7000','1160000','1160000','kasir','2025-09-01 10:45:22','F22501104522');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011045221','2025-09-01','10:45:22','TJ','1160000','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-250901-0024','D','2025-09-01','10:45:22','kasir','PENJUALAN','F225011045221','232978000','1160000','234138000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1160000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011045221' 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 ('F225011045222','kasir',' 1',' MEE2 5K LG','TOKO','SMBK-E','E2E-YHXG-27-T','CC MODEL MATA VAR LG 10 8K ','OL','0.520','1','100.00','429000','0','0','15000','457000','0','5000','0','462000','TJ','T0072014','E2E','0','0','-','0','864000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YHXG-27-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='2025-09-01' AND kode_barang='E2E-YHXG-27-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 ('F225011045222','2025-09-01','0.520','2025-09-01','10:45:22','PLG0072122','457000','457000','5000','462000','462000','kasir','2025-09-01 10:45:22','F22501104522');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011045222','2025-09-01','10:45:22','TJ','462000','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-250901-0025','D','2025-09-01','10:45:22','kasir','PENJUALAN','F225011045222','234138000','462000','234600000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='462000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011045222' 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 ('F225011045223','kasir',' 1',' MFB1F X UB','TOKO','SMBK-B','B1F-YHAC-150-0','GW X ITALY ARESO SLEP UB 8K ','OL','0.660','1','100.00','556000','0','0','15000','591000','0','5000','0','596000','TJ','00365521','B1F','0','0','-','0','862000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-YHAC-150-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.660',berat_jual_asli=berat_jual_asli+'0.660',stock_jual='1',berat_akhir=berat_akhir-'0.660',berat_akhir_asli=berat_akhir_asli-'0.660',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='B1F-YHAC-150-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225011045223','2025-09-01','0.660','2025-09-01','10:45:22','PLG0072123','591000','591000','5000','596000','596000','kasir','2025-09-01 10:45:22','F22501104522');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011045223','2025-09-01','10:45:22','TJ','596000','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-250901-0026','D','2025-09-01','10:45:22','kasir','PENJUALAN','F225011045223','234600000','596000','235196000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='596000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011045223' 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 ('F225011045224','kasir',' 1',' MEH1 KH 44','TOKO','SMBK-H','H1E-YCXE-6-T','KL FANCY KH 44CM 8K ','OL','2.080','1','100.00','1716000','0','0','15000','1818000','0','10000','0','1828000','TJ','T0067691','H1E','0','0','-','0','864000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YCXE-6-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.080',berat_jual_asli=berat_jual_asli+'2.080',stock_jual='1',berat_akhir=berat_akhir-'2.080',berat_akhir_asli=berat_akhir_asli-'2.080',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='H1E-YCXE-6-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 ('F225011045224','2025-09-01','2.080','2025-09-01','10:45:22','PLG0072124','1818000','1818000','10000','1828000','1828000','kasir','2025-09-01 10:45:22','F22501104522');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011045224','2025-09-01','10:45:22','TJ','1828000','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-250901-0027','D','2025-09-01','10:45:22','kasir','PENJUALAN','F225011045224','235196000','1828000','237024000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1828000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011045224' 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 ('F225011045225','kasir',' 1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YHBA-26-T','LT SLOBOK BALOK HURUF BG S 8K ','OL','0.420','1','100.00','361000','0','0','15000','385000','0','5000','0','390000','TJ','T0072456','D1G','0','0','-','0','888000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YHBA-26-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.420',berat_jual_asli=berat_jual_asli+'0.420',stock_jual='1',berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='D1G-YHBA-26-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 ('F225011045225','2025-09-01','0.420','2025-09-01','10:45:22','PLG0072125','385000','385000','5000','390000','390000','kasir','2025-09-01 10:45:22','F22501104522');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011045225','2025-09-01','10:45:22','TJ','390000','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-250901-0028','D','2025-09-01','10:45:22','kasir','PENJUALAN','F225011045225','237024000','390000','237414000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='390000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011045225' 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 ('F225011100191','kasir','1',' MJH2 X KH ','TOKO','SMBK-H','H2J-YHXG-467-0','KL X BORSALINO KH 42 9K ','OLS 1W03','1.100','1','100.00','1001000','0','0','15000','1068000','0','70000','0','1138000','AN','00364517','H2J','0','0','-','0','915000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-YHXG-467-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='H2J-YHXG-467-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 ('F225011100191','2025-09-01','1.100','2025-09-01','11:00:20','PLG0072126','1068000','1068000','70000','1138000','1138000','kasir','2025-09-01 11:00:19','F22501110019');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011100191','2025-09-01','11:00:20','AN','1138000','70000');
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-250901-0029','D','2025-09-01','11:00:20','kasir','PENJUALAN','F225011100191','237414000','1138000','238552000');
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 ('F225011101031','kasir','1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YHBE-41-T','LT SLOBOK BALOK HURUF BG Y 8K ','OLS RM9N','0.320','1','100.00','275000','0','0','15000','290000','0','60000','0','350000','AN','T0072526','D1G','0','0','-','0','888000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YHBE-41-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.320',berat_jual_asli=berat_jual_asli+'0.320',stock_jual='1',berat_akhir=berat_akhir-'0.320',berat_akhir_asli=berat_akhir_asli-'0.320',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='D1G-YHBE-41-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 ('F225011101031','2025-09-01','0.320','2025-09-01','11:01:04','PLG0072127','290000','290000','60000','350000','350000','kasir','2025-09-01 11:01:03','F22501110103');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011101031','2025-09-01','11:01:04','AN','350000','60000');
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-250901-0030','D','2025-09-01','11:01:04','kasir','PENJUALAN','F225011101031','238552000','350000','238902000');
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 ('F225011101381','kasir','1',' MEE1 HW 15','TOKO','SMBK-E','E1E-YHBA-45-T','CC MODEL SLEP VAR HW 15 8K ','OL','0.600','1','100.00','495000','0','0','15000','527000','0','5000','0','532000','RTA','T0072475','E1E','0','0','-','0','864000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YHBA-45-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='E1E-YHBA-45-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 ('F225011101381','2025-09-01','0.600','2025-09-01','11:01:38','PLG0072128','527000','527000','5000','532000','532000','kasir','2025-09-01 11:01:38','F22501110138');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011101381','2025-09-01','11:01:38','RTA','532000','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-250901-0031','D','2025-09-01','11:01:38','kasir','PENJUALAN','F225011101381','238902000','532000','239434000');
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 ('F225011102051','kasir','1',' MEF3 HW ','TOKO','SMBK-F','F3E-YCXC-33-T','GL HARLEY HW 8K ','OL','2.020','1','100.00','1666000','0','0','15000','1766000','0','10000','0','1776000','RTA','T0067421','F3E','0','0','-','0','864000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YCXC-33-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='F3E-YCXC-33-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225011102051','2025-09-01','2.020','2025-09-01','11:02:06','PLG0072129','1766000','1766000','10000','1776000','1776000','kasir','2025-09-01 11:02:05','F22501110205');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011102051','2025-09-01','11:02:06','RTA','1776000','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-250901-0032','D','2025-09-01','11:02:06','kasir','PENJUALAN','F225011102051','239434000','1776000','241210000');
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 ('F225011111351','kasir','1',' MDE1 X CM ','TOKO','SMBK-E','E1D-YHXB-274-0','CC X SOLITARE MATA CM 16 8K ','OL','1.030','1','100.00','832000','0','0','15000','893000','0','10000','0','903000','NS','00363684','E1D','0','0','-','0','847000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YHXB-274-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='E1D-YHXB-274-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 ('F225011111351','2025-09-01','1.030','2025-09-01','11:11:36','PLG0072130','893000','893000','10000','903000','903000','kasir','2025-09-01 11:11:35','F22501111135');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011111351','2025-09-01','11:11:36','NS','903000','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-250901-0033','D','2025-09-01','11:11:36','kasir','PENJUALAN','F225011111351','241210000','903000','242113000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='903000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011111351' 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 ('F225011111352','kasir',' 1',' MEH1 UB ','TOKO','SMBK-H','H1E-YHCX-2-T','KL SANTA MODEL BOLA ARESO VAR UB 8K ','OL','2.620','1','100.00','2238000','0','0','15000','2285000','0','13000','0','2298000','NS','T0072713','H1E','0','0','-','0','864000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YHCX-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.620',berat_jual_asli=berat_jual_asli+'2.620',stock_jual='1',berat_akhir=berat_akhir-'2.620',berat_akhir_asli=berat_akhir_asli-'2.620',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='H1E-YHCX-2-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 ('F225011111352','2025-09-01','2.620','2025-09-01','11:11:36','PLG0072131','2285000','2285000','13000','2298000','2298000','kasir','2025-09-01 11:11:35','F22501111135');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011111352','2025-09-01','11:11:36','NS','2298000','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-250901-0034','D','2025-09-01','11:11:36','kasir','PENJUALAN','F225011111352','242113000','2298000','244411000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2298000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011111352' 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 ('F225011116351','kasir','1',' MFF3 UB ','TOKO','SMBK-F','F3F-YHXH-65-T','GL KOREA UB 8K ','OL','0.450','1','100.00','379000','0','0','15000','406000','0','5000','0','411000','RTA','T0072165','F3F','0','0','-','0','862000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YHXH-65-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='F3F-YHXH-65-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225011116351','2025-09-01','0.450','2025-09-01','11:16:35','PLG0072132','406000','406000','5000','411000','411000','kasir','2025-09-01 11:16:35','F22501111635');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011116351','2025-09-01','11:16:35','RTA','411000','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-250901-0035','D','2025-09-01','11:16:35','kasir','PENJUALAN','F225011116351','244411000','411000','244822000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='411000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011116351' 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 ('F225011116352','kasir',' 1',' MFF3 UB ','TOKO','SMBK-F','F3F-YHXH-70-T','GL KOREA UB 8K ','OL','0.450','1','100.00','379000','0','0','15000','406000','0','5000','0','411000','RTA','T0072170','F3F','0','0','-','0','862000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YHXH-70-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='F3F-YHXH-70-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225011116352','2025-09-01','0.450','2025-09-01','11:16:35','PLG0072133','406000','406000','5000','411000','411000','kasir','2025-09-01 11:16:35','F22501111635');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011116352','2025-09-01','11:16:35','RTA','411000','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-250901-0036','D','2025-09-01','11:16:35','kasir','PENJUALAN','F225011116352','244822000','411000','245233000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='411000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011116352' 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 ('F225011116353','kasir',' 1',' MEF3 YT ','TOKO','SMBK-F','F3E-YFAB-30-T','GL MODEL FLIK VAR YT 8K ','OL','2.600','1','100.00','2145000','0','0','15000','2288000','0','13000','0','2301000','RTA','T0069969','F3E','0','0','-','0','864000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YFAB-30-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.600',berat_jual_asli=berat_jual_asli+'2.600',stock_jual='1',berat_akhir=berat_akhir-'2.600',berat_akhir_asli=berat_akhir_asli-'2.600',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='F3E-YFAB-30-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 ('F225011116353','2025-09-01','2.600','2025-09-01','11:16:35','PLG0072134','2288000','2288000','13000','2301000','2301000','kasir','2025-09-01 11:16:35','F22501111635');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011116353','2025-09-01','11:16:35','RTA','2301000','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-250901-0037','D','2025-09-01','11:16:35','kasir','PENJUALAN','F225011116353','245233000','2301000','247534000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2301000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011116353' 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 ('F225011116354','kasir',' 1',' MGD1 X 5K ','TOKO','SMBK-D','D1G-YCAA-58-0','LT X SLOBOK BULAT HURUF BG R 8K ','OL','0.620','1','100.00','533000','0','0','15000','570000','0','5000','0','575000','RTA','00342965','D1G','0','0','-','0','888000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YCAA-58-0' 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='2025-09-01' AND kode_barang='D1G-YCAA-58-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 ('F225011116354','2025-09-01','0.620','2025-09-01','11:16:35','PLG0072135','570000','570000','5000','575000','575000','kasir','2025-09-01 11:16:35','F22501111635');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011116354','2025-09-01','11:16:35','RTA','575000','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-250901-0038','D','2025-09-01','11:16:35','kasir','PENJUALAN','F225011116354','247534000','575000','248109000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='575000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011116354' 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 ('F225011116355','kasir',' 1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YGAH-87-T','LT SLOBOK BULAT HURUF BG D 8K ','OL','0.650','1','100.00','558000','0','0','15000','597000','0','5000','0','602000','RTA','T0071118','D1G','0','0','-','0','888000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YGAH-87-T' 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='2025-09-01' AND kode_barang='D1G-YGAH-87-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 ('F225011116355','2025-09-01','0.650','2025-09-01','11:16:35','PLG0072136','597000','597000','5000','602000','602000','kasir','2025-09-01 11:16:35','F22501111635');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011116355','2025-09-01','11:16:35','RTA','602000','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-250901-0039','D','2025-09-01','11:16:35','kasir','PENJUALAN','F225011116355','248109000','602000','248711000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='602000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011116355' 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 ('F225011138301','kasir','1',' MHD1 5K BG','TOKO','SMBK-D','D1H-YHBA-31-T','LT SLOBOK BOLA KRAWANG BG 8K ','OL','0.270','1','100.00','237000','0','0','15000','253000','0','5000','0','258000','RTA','T0072461','D1H','0','0','-','0','883000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1H-YHBA-31-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.270',berat_jual_asli=berat_jual_asli+'0.270',stock_jual='1',berat_akhir=berat_akhir-'0.270',berat_akhir_asli=berat_akhir_asli-'0.270',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='D1H-YHBA-31-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 ('F225011138301','2025-09-01','0.270','2025-09-01','11:38:30','PLG0072137','253000','253000','5000','258000','258000','kasir','2025-09-01 11:38:30','F22501113830');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011138301','2025-09-01','11:38:30','RTA','258000','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-250901-0040','D','2025-09-01','11:38:30','kasir','PENJUALAN','F225011138301','248711000','258000','248969000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='258000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011138301' 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 ('F225011138302','kasir',' 1',' MHD1 5K BG','TOKO','SMBK-D','D1H-YHBA-27-T','LT SLOBOK BOLA KRAWANG BG 8K ','OL','0.270','1','100.00','237000','0','0','15000','253000','0','5000','0','258000','RTA','T0072457','D1H','0','0','-','0','883000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1H-YHBA-27-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.270',berat_jual_asli=berat_jual_asli+'0.270',stock_jual='1',berat_akhir=berat_akhir-'0.270',berat_akhir_asli=berat_akhir_asli-'0.270',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='D1H-YHBA-27-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 ('F225011138302','2025-09-01','0.270','2025-09-01','11:38:30','PLG0072138','253000','253000','5000','258000','258000','kasir','2025-09-01 11:38:30','F22501113830');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011138302','2025-09-01','11:38:30','RTA','258000','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-250901-0041','D','2025-09-01','11:38:30','kasir','PENJUALAN','F225011138302','248969000','258000','249227000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='258000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011138302' 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 ('F225011138303','kasir',' 1',' MHD1 5K BG','TOKO','SMBK-D','D1H-YHBA-28-T','LT SLOBOK BOLA KRAWANG BG 8K ','OL','0.270','1','100.00','237000','0','0','15000','253000','0','5000','0','258000','RTA','T0072458','D1H','0','0','-','0','883000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1H-YHBA-28-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.270',berat_jual_asli=berat_jual_asli+'0.270',stock_jual='1',berat_akhir=berat_akhir-'0.270',berat_akhir_asli=berat_akhir_asli-'0.270',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='D1H-YHBA-28-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 ('F225011138303','2025-09-01','0.270','2025-09-01','11:38:30','PLG0072139','253000','253000','5000','258000','258000','kasir','2025-09-01 11:38:30','F22501113830');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011138303','2025-09-01','11:38:30','RTA','258000','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-250901-0042','D','2025-09-01','11:38:30','kasir','PENJUALAN','F225011138303','249227000','258000','249485000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='258000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011138303' 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 ('F225011138304','kasir',' 1',' MEE2 5K CM','TOKO','SMBK-E','E2E-YCXD-66-T','CC MODEL AUREL MATA VAR CM 12 8K ','OL','0.800','1','100.00','660000','0','0','15000','708000','0','5000','0','713000','RTA','T0067609','E2E','0','0','-','0','864000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YCXD-66-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='E2E-YCXD-66-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 ('F225011138304','2025-09-01','0.800','2025-09-01','11:38:30','PLG0072140','708000','708000','5000','713000','713000','kasir','2025-09-01 11:38:30','F22501113830');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011138304','2025-09-01','11:38:30','RTA','713000','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-250901-0043','D','2025-09-01','11:38:30','kasir','PENJUALAN','F225011138304','249485000','713000','250198000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='713000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011138304' 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 ('F225011138305','kasir',' 1',' MEE1 CP 11','TOKO','SMBK-E','E1E-YHBH-180-T','CC MODEL DAUN SLEP VAR CP 11 8K ','OL','0.750','1','100.00','624000','0','0','15000','665000','0','5000','0','670000','RTA','T0072676','E1E','0','0','-','0','864000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YHBH-180-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='E1E-YHBH-180-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 ('F225011138305','2025-09-01','0.750','2025-09-01','11:38:30','PLG0072141','665000','665000','5000','670000','670000','kasir','2025-09-01 11:38:30','F22501113830');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011138305','2025-09-01','11:38:30','RTA','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-250901-0044','D','2025-09-01','11:38:30','kasir','PENJUALAN','F225011138305','250198000','670000','250868000','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='F225011138305' 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 ('F225011138306','kasir',' 1',' MEE1 UB 13','TOKO','SMBK-E','E1E-YHXH-41-T','CC MODEL DAUN VAR UB 13 8K ','OL','0.680','1','100.00','561000','0','0','15000','761000','0','5000','0','766000','RTA','T0072141','E1E','0','0','-','0','864000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YHXH-41-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.680',berat_jual_asli=berat_jual_asli+'0.680',stock_jual='1',berat_akhir=berat_akhir-'0.680',berat_akhir_asli=berat_akhir_asli-'0.680',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='E1E-YHXH-41-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 ('F225011138306','2025-09-01','0.680','2025-09-01','11:38:30','PLG0072142','761000','761000','5000','766000','766000','kasir','2025-09-01 11:38:30','F22501113830');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011138306','2025-09-01','11:38:30','RTA','766000','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-250901-0045','D','2025-09-01','11:38:30','kasir','PENJUALAN','F225011138306','250868000','766000','251634000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='766000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011138306' 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 ('F225011138307','kasir',' 1',' MEB1 5K LG','TOKO','SMBK-B','B1E-YHBH-165-T','GW TUSUK APEL CAT VAR LG PE 8K ','OL','0.500','1','100.00','416000','0','0','15000','443000','0','5000','0','448000','RTA','T0072661','B1E','0','0','-','0','864000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YHBH-165-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='2025-09-01' AND kode_barang='B1E-YHBH-165-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 ('F225011138307','2025-09-01','0.500','2025-09-01','11:38:30','PLG0072143','443000','443000','5000','448000','448000','kasir','2025-09-01 11:38:30','F22501113830');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011138307','2025-09-01','11:38:30','RTA','448000','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-250901-0046','D','2025-09-01','11:38:30','kasir','PENJUALAN','F225011138307','251634000','448000','252082000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='448000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011138307' 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 ('F225011138308','kasir',' 1',' MEB1 5K LG','TOKO','SMBK-B','B1E-YHBH-167-T','GW TUSUK APEL CAT VAR LG PE 8K ','OL','0.500','1','100.00','416000','0','0','15000','443000','0','5000','0','448000','RTA','T0072663','B1E','0','0','-','0','864000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YHBH-167-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='2025-09-01' AND kode_barang='B1E-YHBH-167-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 ('F225011138308','2025-09-01','0.500','2025-09-01','11:38:30','PLG0072144','443000','443000','5000','448000','448000','kasir','2025-09-01 11:38:30','F22501113830');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011138308','2025-09-01','11:38:30','RTA','448000','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-250901-0047','D','2025-09-01','11:38:30','kasir','PENJUALAN','F225011138308','252082000','448000','252530000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='448000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011138308' 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 ('F225011138309','kasir',' 1',' MEB1 LG PE','TOKO','SMBK-B','B1E-YHBH-157-T','GW TUSUK AUREL MATA LG PE 8K ','OL','0.550','1','100.00','458000','0','0','15000','487000','0','5000','0','492000','RTA','T0072653','B1E','0','0','-','0','864000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YHBH-157-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='2025-09-01' AND kode_barang='B1E-YHBH-157-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 ('F225011138309','2025-09-01','0.550','2025-09-01','11:38:30','PLG0072145','487000','487000','5000','492000','492000','kasir','2025-09-01 11:38:30','F22501113830');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011138309','2025-09-01','11:38:30','RTA','492000','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-250901-0048','D','2025-09-01','11:38:30','kasir','PENJUALAN','F225011138309','252530000','492000','253022000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='492000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011138309' 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 ('F225011139261','kasir','1',' MFB1 LG ','TOKO','SMBK-B','B1F-YGCX-16-T','GW TRIXIE PANJANG HATI MATA VAR LG 8K ','OL','0.540','1','100.00','455000','0','0','15000','487000','0','5000','0','492000','RTA','T0071681','B1F','0','0','-','0','862000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-YGCX-16-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.540',berat_jual_asli=berat_jual_asli+'0.540',stock_jual='1',berat_akhir=berat_akhir-'0.540',berat_akhir_asli=berat_akhir_asli-'0.540',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='B1F-YGCX-16-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 ('F225011139261','2025-09-01','0.540','2025-09-01','11:39:27','PLG0072146','487000','487000','5000','492000','492000','kasir','2025-09-01 11:39:26','F22501113926');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011139261','2025-09-01','11:39:27','RTA','492000','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-250901-0049','D','2025-09-01','11:39:27','kasir','PENJUALAN','F225011139261','253022000','492000','253514000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='492000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011139261' 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 ('F225011139262','kasir',' 1',' MFB1 LG ','TOKO','SMBK-B','B1F-YGCX-21-T','GW TRIXIE PANJANG HATI MATA VAR LG 8K ','OL','0.550','1','100.00','463000','0','0','15000','496000','0','5000','0','501000','RTA','T0071686','B1F','0','0','-','0','862000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-YGCX-21-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='2025-09-01' AND kode_barang='B1F-YGCX-21-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 ('F225011139262','2025-09-01','0.550','2025-09-01','11:39:27','PLG0072147','496000','496000','5000','501000','501000','kasir','2025-09-01 11:39:26','F22501113926');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011139262','2025-09-01','11:39:27','RTA','501000','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-250901-0050','D','2025-09-01','11:39:27','kasir','PENJUALAN','F225011139262','253514000','501000','254015000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='501000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225011139262' 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 ('F225011156561','kasir','1',' MDE2 CM 14','TOKO','SMBK-E','E2D-YGXA-51-T','CC MODEL MATA VAR CM 14 8K ','OL H','1.000','1','100.00','808000','0','0','15000','875000','0','10000','0','885000','NS','T0070571','E2D','0','0','-','0','847000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YGXA-51-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='E2D-YGXA-51-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225011156561','2025-09-01','1.000','2025-09-01','11:56:56','PLG0072148','875000','875000','10000','885000','885000','kasir','2025-09-01 11:56:56','F22501115656');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011156561','2025-09-01','11:56:56','NS','885000','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-250901-0051','D','2025-09-01','11:56:56','kasir','PENJUALAN','F225011156561','254015000','885000','254900000');
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 ('F225011222191','kasir','1',' TEE2 AY 14','TOKO','TBK-E','E2TE-VCCX-81-T','CC SOLITAIRE V MATA BIRU AY 14 ','OL','1.130','1','100.00','1655000','0','0','15000','1738000','0','8000','0','1746000','NS','T0032132','E2TE','0','0','-','0','1495000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TE-VCCX-81-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.130',berat_jual_asli=berat_jual_asli+'1.130',stock_jual='1',berat_akhir=berat_akhir-'1.130',berat_akhir_asli=berat_akhir_asli-'1.130',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='E2TE-VCCX-81-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225011222191','2025-09-01','1.130','2025-09-01','12:22:20','PLG0072149','1738000','1738000','8000','1746000','1746000','kasir','2025-09-01 12:22:19','F22501122219');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011222191','2025-09-01','12:22:20','NS','1746000','8000');
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-250901-0052','D','2025-09-01','12:22:20','kasir','PENJUALAN','F225011222191','254900000','1746000','256646000');
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 ('F225011228471','kasir','1',' MFF3 HW ','TOKO','SMBK-F','F3F-YHCX-9-T','GL MODEL TETES ARESO VAR HW 8K ','','2.550','1','100.00','2198000','0','0','15000','2262000','0','0','0','2262000','RTA','T0072720','F3F','0','0','-','0','862000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YHCX-9-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.550',berat_jual_asli=berat_jual_asli+'2.550',stock_jual='1',berat_akhir=berat_akhir-'2.550',berat_akhir_asli=berat_akhir_asli-'2.550',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='F3F-YHCX-9-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225011228471','2025-09-01','2.550','2025-09-01','12:28:48','PLG0072150','2262000','2262000','0','2262000','2262000','kasir','2025-09-01 12:28:47','F22501122847');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011228471','2025-09-01','12:28:48','RTA','2262000','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-250901-0053','D','2025-09-01','12:28:48','kasir','PENJUALAN','F225011228471','256646000','2262000','258908000');
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 ('F225011236571','kasir','1',' MDE2 CM 16','TOKO','SMBK-E','E2D-YHBE-50-T','CC WEDDING MATA CM 16 8K ','','2.130','1','100.00','1736000','0','0','15000','1817000','0','0','0','1817000','NS','T0072535','E2D','0','0','-','0','847000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YHBE-50-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.130',berat_jual_asli=berat_jual_asli+'2.130',stock_jual='1',berat_akhir=berat_akhir-'2.130',berat_akhir_asli=berat_akhir_asli-'2.130',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='E2D-YHBE-50-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 ('F225011236571','2025-09-01','2.130','2025-09-01','12:36:58','PLG0072151','1817000','1817000','0','1817000','1817000','kasir','2025-09-01 12:36:57','F22501123657');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225011236571','2025-09-01','12:36:58','NS','1817000','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-250901-0054','D','2025-09-01','12:36:58','kasir','PENJUALAN','F225011236571','258908000','1817000','260725000');
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 ('F225010210431','kasir','1',' TEE1 LG 12','TOKO','TBK-E','E1TE-YHBF-20-T','CC MODEL DAUN SLEP VAR LG 12 17K ','','0.600','1','100.00','879000','0','0','15000','915000','0','0','0','915000','RTA','T0072583','E1TE','0','0','-','0','1495000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TE-YHBF-20-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='E1TE-YHBF-20-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225010210431','2025-09-01','0.600','2025-09-01','14:10:44','PLG0072152','915000','915000','0','915000','915000','kasir','2025-09-01 14:10:43','F22501021043');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225010210431','2025-09-01','14:10:44','RTA','915000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250901-0055','D','2025-09-01','14:10:44','kasir','PENJUALAN','F225010210431','260725000','915000','261640000');
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 ('F225010225491','kasir','1',' MDE2 LG 11','TOKO','SMBK-E','E2D-YDAH-92-T','CC MODEL HATI MATA VAR LG 11 8K','','1.030','1','100.00','832000','0','0','15000','880000','0','0','0','880000','AN','T0068778','E2D','0','0','-','0','847000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YDAH-92-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='E2D-YDAH-92-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 ('F225010225491','2025-09-01','1.030','2025-09-01','14:25:49','PLG0072153','880000','880000','0','880000','880000','kasir','2025-09-01 14:25:49','F22501022549');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225010225491','2025-09-01','14:25:49','AN','880000','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-250901-0056','D','2025-09-01','14:25:49','kasir','PENJUALAN','F225010225491','261640000','880000','262520000');
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 ('F225010228121','kasir','1',' MDE2 5K YT','TOKO','SMBK-E','E2D-XIXF-19-T','CC MODEL MATA VAR YT 12 8K ','','1.030','1','100.00','832000','0','0','15000','879000','0','5000','0','884000','NS','T0061418','E2D','0','0','-','0','847000');
UPDATE tm_barang SET tgl_last_jual='2025-09-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-XIXF-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2025-09-01' AND kode_barang='E2D-XIXF-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 ('F225010228121','2025-09-01','1.030','2025-09-01','14:28:13','PLG0072154','879000','879000','5000','884000','884000','kasir','2025-09-01 14:28:12','F22501022812');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-01','F225010228121','2025-09-01','14:28:13','NS','884000','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-250901-0057','D','2025-09-01','14:28:13','kasir','PENJUALAN','F225010228121','262520000','884000','263404000');
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-00004577','X-00004577','GL BANGKOK HOLLOW LASER PM D58 8K','GR','---','F1E','BELI','BELI001','3782000','2025-09-01','4.950','1','kasir','2025-09-01 14:37:36');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00004577','X-00004577');
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-250901-0001','F225161114211','RTA','1','BELI','BELI001','F1E', 'X-00004577', 'GL BANGKOK HOLLOW LASER PM D58 8K','4.950','4.950','100.00','4203000','3782000','764040','864000','1','3782000','3782000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.950',berat_beli_asli=berat_beli_asli+'4.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.950',berat_akhir_asli=berat_akhir_asli+'4.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-01' 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-250901-0001','2025-09-01','2025-09-01','14:37:36','RTA','---','4.950','3782000','3782000','3782000','3782000','3782000','kasir','2025-09-01 14:37:36','FB-250901-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250901-0001','AZIZ','BULULOR JAMBON','','','081335657718','kasir','2025-09-01 14:37:36');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-01' 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-250901-0058','K','2025-09-01','14:37:36','kasir','PEMBELIAN UMUM','FB-250901-0001','263404000','3782000','259622000');
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-00004578','X-00004578','KL NORY UB 46CM 8K','GR','---','H1E','BELI','BELI001','733000','2025-09-01','0.980','1','kasir','2025-09-01 14:37:51');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00004578','X-00004578');
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-250901-0002','F225230141221','AN','1','BELI','BELI001','H1E', 'X-00004578', 'KL NORY UB 46CM 8K','0.980','0.980','100.00','815000','733000','747959','864000','1','733000','733000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.980',berat_beli_asli=berat_beli_asli+'0.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.980',berat_akhir_asli=berat_akhir_asli+'0.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-01' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-250901-0002','2025-09-01','2025-09-01','14:37:50','AN','---','0.980','733000','733000','733000','733000','733000','kasir','2025-09-01 14:37:51','FB-250901-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250901-0002','GAVIN','KENITEN','','','0895395790181','kasir','2025-09-01 14:37:51');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-01' 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-250901-0059','K','2025-09-01','14:37:50','kasir','PEMBELIAN UMUM','FB-250901-0002','259622000','733000','258889000');
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-00004579','X-00004579','KL RANTAI HOLLOW UB 45CM 8K','GR','---','H1F','BELI','BELI001','600000','2025-09-01','0.850','1','kasir','2025-09-01 14:38:11');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1F','X-00004579','X-00004579');
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-250901-0003','F225240913281','NS','1','BELI','BELI001','H1F', 'X-00004579', 'KL RANTAI HOLLOW UB 45CM 8K','0.850','0.850','100.00','775000','600000','705882','862000','1','600000','600000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.850',berat_beli_asli=berat_beli_asli+'0.850',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.850',berat_akhir_asli=berat_akhir_asli+'0.850',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-01' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1F' 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-250901-0003','2025-09-01','2025-09-01','14:38:11','NS','---','0.850','600000','600000','600000','600000','600000','kasir','2025-09-01 14:38:11','FB-250901-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250901-0003','PRATIWI','','','','','kasir','2025-09-01 14:38:11');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-01' 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-250901-0060','K','2025-09-01','14:38:11','kasir','PEMBELIAN UMUM','FB-250901-0003','258889000','600000','258289000');
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-00004580','X-00004580','CC MODEL SPECTRA MATA VAR CM 12 17K','GR','---','E2TE','BELI','BELI001','1100000','2025-09-01','1.100','1','kasir','2025-09-01 14:38:58');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TE','X-00004580','X-00004580');
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-250901-0004','F224230307231','RTA','1','BELI','BELI001','E2TE', 'X-00004580', 'CC MODEL SPECTRA MATA VAR CM 12 17K','1.150','1.100','100.00','1040000','1100000','1000000','1495000','1','1100000','1100000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.100',berat_beli_asli=berat_beli_asli+'1.100',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.100',berat_akhir_asli=berat_akhir_asli+'1.100',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-01' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TE' 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-250901-0004','2025-09-01','2025-09-01','14:38:58','RTA','---','1.100','1100000','1100000','1100000','1100000','1100000','kasir','2025-09-01 14:38:58','FB-250901-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250901-0004','AFA','GRAHA KENITEN','','','085736426123','kasir','2025-09-01 14:38:58');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-01' 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-250901-0061','K','2025-09-01','14:38:58','kasir','PEMBELIAN UMUM','FB-250901-0004','258289000','1100000','257189000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225010210431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225010210431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225010210431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225010225491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225010225491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225010225491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225010228121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225010228121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225010228121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225010917091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225010917091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225010917091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225010917092' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225010917092' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225010917092';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225010937121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225010937121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225010937121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011006161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011006161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011006161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011006162' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011006162' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011006162';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011024281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011024281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011024281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011024282' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011024282' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011024282';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011024283' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011024283' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011024283';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011024284' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011024284' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011024284';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011024285' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011024285' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011024285';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011024286' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011024286' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011024286';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011036121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011036121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011036121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011037391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011037391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011037391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011039341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011039341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011039341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011041081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011041081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011041081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011041082' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011041082' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011041082';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011041083' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011041083' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011041083';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011041084' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011041084' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011041084';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011043261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011043261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011043261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011043262' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011043262' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011043262';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011043263' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011043263' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011043263';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011043264' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011043264' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011043264';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011043265' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011043265' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011043265';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011043266' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011043266' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011043266';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011045221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011045221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011045221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011045222' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011045222' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011045222';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011045223' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011045223' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011045223';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011045224' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011045224' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011045224';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011045225' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011045225' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011045225';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011100191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011100191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011100191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011101031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011101031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011101031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011101381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011101381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011101381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011102051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011102051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011102051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011111351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011111351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011111351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011111352' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011111352' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011111352';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011116351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011116351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011116351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011116352' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011116352' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011116352';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011116353' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011116353' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011116353';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011116354' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011116354' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011116354';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011116355' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011116355' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011116355';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011138301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011138301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011138301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011138302' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011138302' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011138302';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011138303' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011138303' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011138303';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011138304' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011138304' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011138304';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011138305' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011138305' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011138305';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011138306' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011138306' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011138306';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011138307' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011138307' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011138307';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011138308' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011138308' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011138308';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011138309' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011138309' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011138309';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011139261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011139261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011139261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011139262' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011139262' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011139262';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011156561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011156561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011156561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011222191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011222191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011222191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011228471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011228471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011228471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225011236571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225011236571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225011236571';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250901-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250901-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250901-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250901-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250901-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250901-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250901-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250901-0004';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-09-02','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-08-02';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-09-01';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-09-01';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-09-01' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-09-01';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-09-01';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-09-01';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-09-01';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202508 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
UPDATE tt_barang_saldo SET tanggal= '2025-09-02' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-09-01' 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-250902-0001','D','2025-09-02','16:07:21','SYSTEM','SALDO AWAL','SALDO AWAL','0','257189000','257189000');
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-250902-0001','D','2025-09-02','16:07:21','BCA','SALDO AWAL','SALDO AWAL','0','3945779888','3945779888');
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-250902-0001','D','2025-09-02','16:07:21','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
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-250902-0001','D','2025-09-02','16:07:21','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250902-0001','D','2025-09-02','16:07:21','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-250902-0001','D','2025-09-02','16:07:21','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2025-09-02';