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 ('F326200813301','input','1',' MEA1E X BW','TOKO','PM-A','A1E-ZDAX-86-0','AT X ITALY SLEP VAR BW 8K ','','0.530','1','100.00','549000','0','0','15000','550000','0','0','0','550000','AAT','00398856','A1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZDAX-86-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='A1E-ZDAX-86-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326200813301','2026-07-20','0.530','2026-07-20','08:13:31','PLG0030397','550000','550000','0','550000','550000','input','2026-07-20 08:13:30','F32620081330');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-20','F326200813301','2026-07-20','08:13:31','AAT','550000','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-260720-0002','D','2026-07-20','08:13:31','input','PENJUALAN','F326200813301','6392426000','550000','6392976000');
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 ('F326200921411','input','1',' TGF3 X UB ','TOKO','PT-F','F3TG-XJAB-163-T','GL X SANTA KLINTING VAR UB 17K ','','5.060','1','100.00','9816000','0','0','15000','9815000','0','0','0','9815000','LIS','T0063024','F3TG','0','0','-','1','1940000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TG-XJAB-163-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.060',berat_jual_asli=berat_jual_asli+'5.060',stock_jual='1',berat_akhir=berat_akhir-'5.060',berat_akhir_asli=berat_akhir_asli-'5.060',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='F3TG-XJAB-163-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326200921411','2026-07-20','5.060','2026-07-20','09:21:41','PLG0030398','9815000','9815000','0','9815000','9815000','input','2026-07-20 09:21:41','F32620092141');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-20','F326200921411','2026-07-20','09:21:41','LIS','9815000','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-260720-0003','D','2026-07-20','09:21:41','input','PENJUALAN','F326200921411','6392976000','9815000','6402791000');
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 ('F326200945561','input','1',' MEF3 PM ','TOKO','PM-F','F3E-ZGAH-139-0','GL LEMES MODEL DAUN PM 8K ','','3.180','1','100.00','3323000','0','0','15000','3290000','0','0','0','3290000','LIS','00414200','F3E','0','0','-','1','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGAH-139-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.180',berat_jual_asli=berat_jual_asli+'3.180',stock_jual='1',berat_akhir=berat_akhir-'3.180',berat_akhir_asli=berat_akhir_asli-'3.180',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='F3E-ZGAH-139-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326200945561','2026-07-20','3.180','2026-07-20','09:45:57','PLG0030399','3290000','3290000','0','3290000','3290000','input','2026-07-20 09:45:56','F32620094556');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-20','F326200945561','2026-07-20','09:45:57','LIS','3290000','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-260720-0004','D','2026-07-20','09:45:57','input','PENJUALAN','F326200945561','6402791000','3290000','6406081000');
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 ('F326201020491','input','1',' MDE2 CM 18','TOKO','PM-E','E2D-ZFAF-2-0','CC WEDDING MATA CM 18 8K ','','1.120','1','100.00','1137000','0','0','15000','1138000','0','10000','0','1148000','LIS','00408751','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFAF-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.120',berat_jual_asli=berat_jual_asli+'1.120',stock_jual='1',berat_akhir=berat_akhir-'1.120',berat_akhir_asli=berat_akhir_asli-'1.120',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='E2D-ZFAF-2-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326201020491','2026-07-20','1.120','2026-07-20','10:20:50','PLG0030400','1138000','1138000','10000','1148000','1148000','input','2026-07-20 10:20:49','F32620102049');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-20','F326201020491','2026-07-20','10:20:50','LIS','1148000','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-260720-0005','D','2026-07-20','10:20:50','input','PENJUALAN','F326201020491','6406081000','1148000','6407229000');
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 ('F326201046061','input','1',' MDE2 CM 16','TOKO','PM-E','E2D-ZFXF-85-0','CC WEDDING MATA CM 16 8K ','','0.870','1','100.00','883000','0','0','15000','883000','0','0','0','883000','SIN','00407614','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFXF-85-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.870',berat_jual_asli=berat_jual_asli+'0.870',stock_jual='1',berat_akhir=berat_akhir-'0.870',berat_akhir_asli=berat_akhir_asli-'0.870',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='E2D-ZFXF-85-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326201046061','2026-07-20','0.870','2026-07-20','10:46:07','PLG0030401','883000','883000','0','883000','883000','input','2026-07-20 10:46:06','F32620104606');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-20','F326201046061','2026-07-20','10:46:07','SIN','883000','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-260720-0006','D','2026-07-20','10:46:07','input','PENJUALAN','F326201046061','6407229000','883000','6408112000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='883000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326201046061' 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 ('F326201046062','input',' 1',' MDE2 CM 16','TOKO','PM-E','E2D-ZFAE-6-0','CC WEDDING MATA CM 16 8K ','','0.860','1','100.00','873000','0','0','15000','873000','0','0','0','873000','SIN','00408714','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFAE-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.860',berat_jual_asli=berat_jual_asli+'0.860',stock_jual='1',berat_akhir=berat_akhir-'0.860',berat_akhir_asli=berat_akhir_asli-'0.860',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='E2D-ZFAE-6-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326201046062','2026-07-20','0.860','2026-07-20','10:46:07','PLG0030402','873000','873000','0','873000','873000','input','2026-07-20 10:46:06','F32620104606');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-20','F326201046062','2026-07-20','10:46:07','SIN','873000','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-260720-0007','D','2026-07-20','10:46:07','input','PENJUALAN','F326201046062','6408112000','873000','6408985000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='873000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326201046062' 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 ('F326201051001','input','1',' MEH1E UB 4','TOKO','PM-H','H1E-ZFAI-113-0','KL MILANO SLEP UB 40 8K ','','2.110','1','100.00','2184000','0','0','15000','2184000','0','0','0','2184000','LIS','00409418','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFAI-113-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.110',berat_jual_asli=berat_jual_asli+'2.110',stock_jual='1',berat_akhir=berat_akhir-'2.110',berat_akhir_asli=berat_akhir_asli-'2.110',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='H1E-ZFAI-113-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326201051001','2026-07-20','2.110','2026-07-20','10:51:01','PLG0030403','2184000','2184000','0','2184000','2184000','input','2026-07-20 10:51:00','F32620105100');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-20','F326201051001','2026-07-20','10:51:01','LIS','2184000','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-260720-0008','D','2026-07-20','10:51:01','input','PENJUALAN','F326201051001','6408985000','2184000','6411169000');
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 ('F326201051451','input','1',' MFE1F CM 1','TOKO','PM-E','E1F-ZGAA-63-0','CC MODEL SLEP CM 12 8K ','','0.350','1','100.00','369000','0','0','15000','369000','0','0','0','369000','LIS','00413242','E1F','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGAA-63-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='E1F-ZGAA-63-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326201051451','2026-07-20','0.350','2026-07-20','10:51:45','PLG0030404','369000','369000','0','369000','369000','input','2026-07-20 10:51:45','F32620105145');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-20','F326201051451','2026-07-20','10:51:45','LIS','369000','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-260720-0009','D','2026-07-20','10:51:45','input','PENJUALAN','F326201051451','6411169000','369000','6411538000');
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 ('F326201110271','input','1',' MEH1E KH 4','TOKO','PM-H','H1E-ZFAI-112-0','KL RANTAI HOLLOW SLEP KH 44 8K ','','2.080','1','100.00','2153000','0','0','15000','2155000','0','0','0','2155000','AAT','00409417','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFAI-112-0' 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='2026-07-20' AND kode_barang='H1E-ZFAI-112-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326201110271','2026-07-20','2.080','2026-07-20','11:10:28','PLG0030405','2155000','2155000','0','2155000','2155000','input','2026-07-20 11:10:27','F32620111027');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-20','F326201110271','2026-07-20','11:10:28','AAT','2155000','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-260720-0010','D','2026-07-20','11:10:28','input','PENJUALAN','F326201110271','6411538000','2155000','6413693000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2155000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326201110271' 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 ('F326201110272','input',' 1',' MEH1 X UB ','TOKO','PM-H','H1E-ZDBG-170-0','KL X GUCCI ANAK UB 32 8K ','','1.000','1','100.00','1035000','0','0','15000','1035000','0','0','0','1035000','AAT','00401413','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDBG-170-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='H1E-ZDBG-170-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326201110272','2026-07-20','1.000','2026-07-20','11:10:28','PLG0030406','1035000','1035000','0','1035000','1035000','input','2026-07-20 11:10:27','F32620111027');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-20','F326201110272','2026-07-20','11:10:28','AAT','1035000','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-260720-0011','D','2026-07-20','11:10:28','input','PENJUALAN','F326201110272','6413693000','1035000','6414728000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1035000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326201110272' 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 ('F326201118001','input','1',' MEH1 KH 44','TOKO','PM-H','H1E-ZABC-142-0','KL RANTAI HOLLOW DOUBLE KH 44CM 8K ','','5.030','1','100.00','5206000','0','0','15000','5207000','0','0','0','5207000','FIT','00386772','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZABC-142-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.030',berat_jual_asli=berat_jual_asli+'5.030',stock_jual='1',berat_akhir=berat_akhir-'5.030',berat_akhir_asli=berat_akhir_asli-'5.030',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='H1E-ZABC-142-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326201118001','2026-07-20','5.030','2026-07-20','11:18:01','PLG0030407','5207000','5207000','0','5207000','5207000','input','2026-07-20 11:18:00','F32620111800');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-20','F326201118001','2026-07-20','11:18:01','FIT','5207000','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-260720-0012','D','2026-07-20','11:18:01','input','PENJUALAN','F326201118001','6414728000','5207000','6419935000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5207000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326201118001' 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 ('F326201118002','input',' 1',' MEB1 CM PE','TOKO','PM-B','B1E-ZGXF-7-0','GW MODEL SLEP CM PE 8K ','','0.510','1','100.00','528000','0','0','15000','528000','0','0','0','528000','FIT','00412388','B1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZGXF-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='B1E-ZGXF-7-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326201118002','2026-07-20','0.510','2026-07-20','11:18:01','PLG0030408','528000','528000','0','528000','528000','input','2026-07-20 11:18:00','F32620111800');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-20','F326201118002','2026-07-20','11:18:01','FIT','528000','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-260720-0013','D','2026-07-20','11:18:01','input','PENJUALAN','F326201118002','6419935000','528000','6420463000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='528000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326201118002' 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 ('F326201130201','input','1',' MDE2 CM 12','TOKO','PM-E','E2D-ZFXF-86-0','CC WEDDING MATA CM 12 8K ','','0.870','1','100.00','883000','0','0','15000','883000','0','0','0','883000','SIN','00407615','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFXF-86-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.870',berat_jual_asli=berat_jual_asli+'0.870',stock_jual='1',berat_akhir=berat_akhir-'0.870',berat_akhir_asli=berat_akhir_asli-'0.870',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='E2D-ZFXF-86-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326201130201','2026-07-20','0.870','2026-07-20','11:30:21','PLG0030409','883000','883000','0','883000','883000','input','2026-07-20 11:30:20','F32620113020');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-20','F326201130201','2026-07-20','11:30:21','SIN','883000','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-260720-0014','D','2026-07-20','11:30:21','input','PENJUALAN','F326201130201','6420463000','883000','6421346000');
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-00019687','X-00019687','CC COR T 17K','GR','---','E1TE','BELI','BELI001','2995000','2026-07-20','2.010','1','kasir','2026-07-20 11:47:58');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1TE','X-00019687','X-00019687');
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-260720-0001','F323221001472','FIT','1','BELI','BELI001','E1TE', 'X-00019687', 'CC COR T 17K','2.010','2.010','100.00','1558000','2995000','1490050','1900000','1','2995000','2995000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.010',berat_beli_asli=berat_beli_asli+'2.010',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.010',berat_akhir_asli=berat_akhir_asli+'2.010',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1TE' 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-260720-0001','2026-07-20','2026-07-20','11:47:57','FIT','---','2.010','2995000','2995000','2995000','2995000','2995000','kasir','2026-07-20 11:47:58','FB-260720-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260720-0001','IMAM','LEMAHBANG KISMANTORO','','','','kasir','2026-07-20 11:47:58');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-20' 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-260720-0015','K','2026-07-20','11:47:57','kasir','PEMBELIAN UMUM','FB-260720-0001','6421346000','2995000','6418351000');
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-00019688','X-00019688','CC X POLOS CM 17','GR','---','E1E','BELI','BELI001','1370000','2026-07-20','1.450','1','kasir','2026-07-20 11:48:17');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00019688','X-00019688');
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-260720-0002','F325270753491','FIT','1','BELI','BELI001','E1E', 'X-00019688', 'CC X POLOS CM 17','1.450','1.450','100.00','1473000','1370000','944828','1045000','1','1370000','1370000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.450',berat_beli_asli=berat_beli_asli+'1.450',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.450',berat_akhir_asli=berat_akhir_asli+'1.450',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260720-0002','2026-07-20','2026-07-20','11:48:17','FIT','---','1.450','1370000','1370000','1370000','1370000','1370000','kasir','2026-07-20 11:48:17','FB-260720-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260720-0002','WIJI','BITING PURWANTORO','','','','kasir','2026-07-20 11:48:17');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-20' 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-260720-0016','K','2026-07-20','11:48:17','kasir','PEMBELIAN UMUM','FB-260720-0002','6418351000','1370000','6416981000');
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-00019689','X-00019689','CC MODEL DAUN SLEP LG 16 8K','GR','---','E1E','BELI','BELI001','530000','2026-07-20','0.550','1','kasir','2026-07-20 11:48:37');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00019689','X-00019689');
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-260720-0003','F326020121471','LIS','1','BELI','BELI001','E1E', 'X-00019689', 'CC MODEL DAUN SLEP LG 16 8K','0.550','0.550','100.00','575000','530000','963636','1045000','1','530000','530000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.550',berat_beli_asli=berat_beli_asli+'0.550',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.550',berat_akhir_asli=berat_akhir_asli+'0.550',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260720-0003','2026-07-20','2026-07-20','11:48:36','LIS','---','0.550','530000','530000','530000','530000','530000','kasir','2026-07-20 11:48:37','FB-260720-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260720-0003','NURUL','SLOGOHIMO','','','','kasir','2026-07-20 11:48:37');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-20' 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-260720-0017','K','2026-07-20','11:48:36','kasir','PEMBELIAN UMUM','FB-260720-0003','6416981000','530000','6416451000');
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-00019690','X-00019690','GL XXX SANTA ARESO SERUT VAR UB 8K','GR','---','F3E','BELI','BELI001','2055000','2026-07-20','2.070','1','kasir','2026-07-20 11:49:00');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019690','X-00019690');
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-260720-0004','F326311137191','SIN','1','BELI','BELI001','F3E', 'X-00019690', 'GL XXX SANTA ARESO SERUT VAR UB 8K','2.070','2.070','100.00','2235000','2055000','992754','1045000','1','2055000','2055000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.070',berat_beli_asli=berat_beli_asli+'2.070',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.070',berat_akhir_asli=berat_akhir_asli+'2.070',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260720-0004','2026-07-20','2026-07-20','11:48:59','SIN','---','2.070','2055000','2055000','2055000','2055000','2055000','kasir','2026-07-20 11:49:00','FB-260720-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260720-0004','VERA','NADI BULUKERTO','','','','kasir','2026-07-20 11:49:00');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-20' 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-260720-0018','K','2026-07-20','11:48:59','kasir','PEMBELIAN UMUM','FB-260720-0004','6416451000','2055000','6414396000');
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 ('F326201217521','kasir','1',' MDE2 X PM ','TOKO','PM-E','E2D-YJBC-19-0','CC X MODEL ANAK MATA PM 6 8K ','','1.080','1','100.00','1096000','0','0','15000','1096000','0','0','0','1096000','LIS','00374337','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJBC-19-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='E2D-YJBC-19-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326201217521','2026-07-20','1.080','2026-07-20','12:17:53','PLG0030410','1096000','1096000','0','1096000','1096000','kasir','2026-07-20 12:17:52','F32620121752');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-20','F326201217521','2026-07-20','12:17:53','LIS','1096000','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-260720-0019','D','2026-07-20','12:17:53','kasir','PENJUALAN','F326201217521','6414396000','1096000','6415492000');
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 ('F326201239491','kasir','1',' MDE2 XX LG','TOKO','PM-E','E2D-YEBD-327-0','CC XX MODEL CAT MATA ANAK LG 8K ','','1.050','1','100.00','1066000','0','0','15000','1035000','0','0','0','1035000','AAT','00355414','E2D','0','0','-','1','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YEBD-327-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='E2D-YEBD-327-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326201239491','2026-07-20','1.050','2026-07-20','12:39:49','PLG0030411','1035000','1035000','0','1035000','1035000','kasir','2026-07-20 12:39:49','F32620123949');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-20','F326201239491','2026-07-20','12:39:49','AAT','1035000','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-260720-0020','D','2026-07-20','12:39:49','kasir','PENJUALAN','F326201239491','6415492000','1035000','6416527000');
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 ('F326201240351','kasir','1',' MGB1G X HK','TOKO','PM-B','B1G-ZEBG-145-0','GW X MODEL TAUGE DAISY HK 8K ','','0.250','1','100.00','269000','0','0','15000','270000','0','0','0','270000','FIT','00405143','B1G','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZEBG-145-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='B1G-ZEBG-145-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326201240351','2026-07-20','0.250','2026-07-20','12:40:36','PLG0030412','270000','270000','0','270000','270000','kasir','2026-07-20 12:40:35','F32620124035');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-20','F326201240351','2026-07-20','12:40:36','FIT','270000','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-260720-0021','D','2026-07-20','12:40:36','kasir','PENJUALAN','F326201240351','6416527000','270000','6416797000');
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-00019691','X-00019691','CC MODEL SLEP KH 12 8K','GR','---','E1E','BELI','BELI001','450000','2026-07-20','0.470','1','kasir','2026-07-20 13:13:40');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00019691','X-00019691');
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-260720-0005','F326071205321','LIS','1','BELI','BELI001','E1E', 'X-00019691', 'CC MODEL SLEP KH 12 8K','0.470','0.470','100.00','490000','450000','957447','1045000','1','450000','450000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.470',berat_beli_asli=berat_beli_asli+'0.470',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.470',berat_akhir_asli=berat_akhir_asli+'0.470',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260720-0005','2026-07-20','2026-07-20','13:13:40','LIS','---','0.470','450000','450000','450000','450000','450000','kasir','2026-07-20 13:13:40','FB-260720-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260720-0005','PUTRI','TENGGER','','','','kasir','2026-07-20 13:13:40');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-20' 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-260720-0022','K','2026-07-20','13:13:40','kasir','PEMBELIAN UMUM','FB-260720-0005','6416797000','450000','6416347000');
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 ('F326200123551','kasir','1',' MFD1F 5K B','TOKO','PM-D','D1F-YLBB-114-0','LT MODEL BALLERINA SLEP BG 8K ','','0.550','1','100.00','580000','0','0','15000','580000','0','5000','0','585000','SIN','00382264','D1F','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YLBB-114-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='D1F-YLBB-114-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326200123551','2026-07-20','0.550','2026-07-20','13:23:55','PLG0030413','580000','580000','5000','585000','585000','kasir','2026-07-20 13:23:55','F32620012355');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-20','F326200123551','2026-07-20','13:23:55','SIN','585000','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-260720-0023','D','2026-07-20','13:23:55','kasir','PENJUALAN','F326200123551','6416347000','585000','6416932000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='585000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326200123551' 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 ('F326200123552','kasir',' 1',' MEE1 LG 22','TOKO','PM-E','E1E-ZFXA-129-0','CC BANGKOK SLEP LG 22 8K ','','0.530','1','100.00','549000','0','0','15000','550000','0','0','0','550000','SIN','00406297','E1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFXA-129-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='E1E-ZFXA-129-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326200123552','2026-07-20','0.530','2026-07-20','13:23:55','PLG0030414','550000','550000','0','550000','550000','kasir','2026-07-20 13:23:55','F32620012355');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-20','F326200123552','2026-07-20','13:23:55','SIN','550000','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-260720-0024','D','2026-07-20','13:23:55','kasir','PENJUALAN','F326200123552','6416932000','550000','6417482000','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='F326200123552' 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 ('F326200146021','kasir','1',' MDE2 CM 8 ','TOKO','PM-E','E2D-ZGAH-130-0','CC COR MODEL MATA CM 8 8K ','','0.800','1','100.00','820000','0','0','15000','813000','0','0','0','813000','SIN','00414191','E2D','0','0','-','1','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGAH-130-0' 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='2026-07-20' AND kode_barang='E2D-ZGAH-130-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326200146021','2026-07-20','0.800','2026-07-20','13:46:03','PLG0030415','813000','813000','0','813000','813000','kasir','2026-07-20 13:46:02','F32620014602');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-20','F326200146021','2026-07-20','13:46:03','SIN','813000','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-260720-0025','D','2026-07-20','13:46:03','kasir','PENJUALAN','F326200146021','6417482000','813000','6418295000');
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-00019692','X-00019692','GL TRIXIE BUNGA ARESO VAR YT 8K','GR','---','F3E','BELI','BELI001','1282000','2026-07-20','1.340','1','kasir','2026-07-20 14:16:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019692','X-00019692');
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-260720-0006','F326071145511','SIN','1','BELI','BELI001','F3E', 'X-00019692', 'GL TRIXIE BUNGA ARESO VAR YT 8K','1.340','1.340','100.00','1395000','1282000','956716','1045000','1','1282000','1282000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.340',berat_beli_asli=berat_beli_asli+'1.340',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.340',berat_akhir_asli=berat_akhir_asli+'1.340',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260720-0006','2026-07-20','2026-07-20','14:16:23','SIN','---','1.340','1282000','1282000','1282000','1282000','1282000','kasir','2026-07-20 14:16:23','FB-260720-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260720-0006','DIKI','LEMAHBANG KISMANTORO','','','082243934003','kasir','2026-07-20 14:16:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-20' 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-260720-0026','K','2026-07-20','14:16:23','kasir','PEMBELIAN UMUM','FB-260720-0006','6418295000','1282000','6417013000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260720-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260720-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260720-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260720-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260720-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260720-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260720-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260720-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260720-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260720-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260720-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260720-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326200123551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326200123551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326200123551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326200123552' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326200123552' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326200123552';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326200146021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326200146021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326200146021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326200813301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326200813301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326200813301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326200921411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326200921411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326200921411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326200945561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326200945561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326200945561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201020491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201020491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201020491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201046061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201046061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201046061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201046062' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201046062' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201046062';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201051001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201051001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201051001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201051451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201051451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201051451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201110271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201110271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201110271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201110272' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201110272' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201110272';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201118001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201118001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201118001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201118002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201118002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201118002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201130201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201130201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201130201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201217521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201217521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201217521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201239491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201239491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201239491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201240351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201240351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201240351';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-21','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-20';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-20';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-20';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-07-20' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-20';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-20';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-20';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-20';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-21' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-20' 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-260721-0001','D','2026-07-21','15:09:37','SYSTEM','SALDO AWAL','SALDO AWAL','0','6417013000','6417013000');
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-260721-0001','D','2026-07-21','15:09:37','BCA','SALDO AWAL','SALDO AWAL','0','738685000','738685000');
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-260721-0001','D','2026-07-21','15:09:37','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-260721-0001','D','2026-07-21','15:09:37','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-07-21';