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 ('F326310753451','input','1',' MGA1G CM ','TOKO','PM-A','A1G-ZEBB-99-T','AT TINDIK ANAK SLEP CM 8K ','','0.260','1','100.00','299000','0','0','15000','300000','0','0','0','300000','SIN','T0079862','A1G','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1G-ZEBB-99-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='A1G-ZEBB-99-T' 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 ('F326310753451','2026-05-31','0.260','2026-05-31','07:53:46','PLG0029474','300000','300000','0','300000','300000','input','2026-05-31 07:53:45','F32631075345');
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-05-31','F326310753451','2026-05-31','07:53:46','SIN','300000','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-260531-0002','D','2026-05-31','07:53:46','input','PENJUALAN','F326310753451','5319979000','300000','5320279000');
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 ('F326310802581','input','1',' MDE1 CM 22','TOKO','PM-E','E1D-ZCXG-335-0','CC MODEL C CM 22 8K ','','1.030','1','100.00','1123000','0','0','15000','1123000','0','0','0','1123000','SIN','00392771','E1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZCXG-335-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='2026-05-31' AND kode_barang='E1D-ZCXG-335-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 ('F326310802581','2026-05-31','1.030','2026-05-31','08:02:59','PLG0029475','1123000','1123000','0','1123000','1123000','input','2026-05-31 08:02:58','F32631080258');
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-05-31','F326310802581','2026-05-31','08:02:59','SIN','1123000','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-260531-0003','D','2026-05-31','08:02:59','input','PENJUALAN','F326310802581','5320279000','1123000','5321402000');
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 ('F326310850541','input','1',' TAE0 X DW ','TOKO','PT-E','E0TA-WLBF-116-T','CC X POLOS DW 17 ','','2.020','1','100.00','3919000','0','0','15000','3920000','0','0','0','3920000','SIN','T0052777','E0TA','0','0','-','0','1940000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E0TA-WLBF-116-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='2026-05-31' AND kode_barang='E0TA-WLBF-116-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326310850541','2026-05-31','2.020','2026-05-31','08:50:55','PLG0029476','3920000','3920000','0','3920000','3920000','input','2026-05-31 08:50:54','F32631085054');
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-05-31','F326310850541','2026-05-31','08:50:55','SIN','3920000','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-260531-0004','D','2026-05-31','08:50:55','input','PENJUALAN','F326310850541','5321402000','3920000','5325322000');
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 ('F326310854311','input','1',' MDE1 X OR ','TOKO','PM-E','E1D-YLAE-126-0','CC X BANGKOK POLOS OR 14 8K ','','0.970','1','100.00','1057000','0','0','15000','1058000','0','0','0','1058000','AAT','00381104','E1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YLAE-126-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='E1D-YLAE-126-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 ('F326310854311','2026-05-31','0.970','2026-05-31','08:54:32','PLG0029477','1058000','1058000','0','1058000','1058000','input','2026-05-31 08:54:31','F32631085431');
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-05-31','F326310854311','2026-05-31','08:54:32','AAT','1058000','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-260531-0005','D','2026-05-31','08:54:32','input','PENJUALAN','F326310854311','5325322000','1058000','5326380000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1058000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326310854311' 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 ('F326310854312','input',' 1',' MEF3E XXX ','TOKO','PM-F','F3E-ZEXI-170-0','GL XXX CAPELLA SLEP YT 8K ','','1.050','1','100.00','1165000','0','0','15000','1135000','0','0','0','1135000','AAT','00402991','F3E','0','0','-','1','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXI-170-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-05-31' AND kode_barang='F3E-ZEXI-170-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 ('F326310854312','2026-05-31','1.050','2026-05-31','08:54:32','PLG0029478','1135000','1135000','0','1135000','1135000','input','2026-05-31 08:54:31','F32631085431');
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-05-31','F326310854312','2026-05-31','08:54:32','AAT','1135000','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-260531-0006','D','2026-05-31','08:54:32','input','PENJUALAN','F326310854312','5326380000','1135000','5327515000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1135000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326310854312' 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 ('F326310918051','input','1',' MEE1 HTM 2','TOKO','PM-E','E1E-ZEXA-39-0','CC PIPA MODEL CLOVER VAR HTM 20 8K ','','0.570','1','100.00','633000','0','0','15000','633000','0','0','0','633000','FIT','00401936','E1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXA-39-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='E1E-ZEXA-39-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 ('F326310918051','2026-05-31','0.570','2026-05-31','09:18:06','PLG0029479','633000','633000','0','633000','633000','input','2026-05-31 09:18:05','F32631091805');
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-05-31','F326310918051','2026-05-31','09:18:06','FIT','633000','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-260531-0007','D','2026-05-31','09:18:06','input','PENJUALAN','F326310918051','5327515000','633000','5328148000');
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 ('F326310918281','input','1',' MDE2 X CM ','TOKO','PM-E','E2D-ZEBH-216-0','CC X MODEL MATA CM 20 8K ','','1.250','1','100.00','1362000','0','0','15000','1362000','0','0','0','1362000','FIT','00405434','E2D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEBH-216-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.250',berat_jual_asli=berat_jual_asli+'1.250',stock_jual='1',berat_akhir=berat_akhir-'1.250',berat_akhir_asli=berat_akhir_asli-'1.250',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='E2D-ZEBH-216-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 ('F326310918281','2026-05-31','1.250','2026-05-31','09:18:28','PLG0029480','1362000','1362000','0','1362000','1362000','input','2026-05-31 09:18:28','F32631091828');
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-05-31','F326310918281','2026-05-31','09:18:28','FIT','1362000','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-260531-0008','D','2026-05-31','09:18:28','input','PENJUALAN','F326310918281','5328148000','1362000','5329510000');
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 ('F326310921091','input','1',' MHB1H CM ','TOKO','PM-B','B1H-YHBH-243-0','GW MODEL TAUGE SLEP CM 8K ','','0.290','1','100.00','339000','0','0','15000','340000','0','0','0','340000','AAT','00367229','B1H','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-YHBH-243-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.290',berat_jual_asli=berat_jual_asli+'0.290',stock_jual='1',berat_akhir=berat_akhir-'0.290',berat_akhir_asli=berat_akhir_asli-'0.290',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='B1H-YHBH-243-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 ('F326310921091','2026-05-31','0.290','2026-05-31','09:21:10','PLG0029481','340000','340000','0','340000','340000','input','2026-05-31 09:21:09','F32631092109');
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-05-31','F326310921091','2026-05-31','09:21:10','AAT','340000','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-260531-0009','D','2026-05-31','09:21:10','input','PENJUALAN','F326310921091','5329510000','340000','5329850000');
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 ('F326310924131','input','1',' TDA1 X UB ','TOKO','PT-A','A1TD-YLAC-12-T','AT X COR MODEL ITALY VAR UB 17K ','','1.310','1','100.00','2633000','0','0','15000','2633000','0','0','0','2633000','LIS','T0075747','A1TD','0','0','-','0','2010000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TD-YLAC-12-T' 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='2026-05-31' AND kode_barang='A1TD-YLAC-12-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326310924131','2026-05-31','1.310','2026-05-31','09:24:13','PLG0029482','2633000','2633000','0','2633000','2633000','input','2026-05-31 09:24:13','F32631092413');
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-05-31','F326310924131','2026-05-31','09:24:13','LIS','2633000','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-260531-0010','D','2026-05-31','09:24:13','input','PENJUALAN','F326310924131','5329850000','2633000','5332483000');
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 ('F326311005581','input','1',' MDE2 X YT ','TOKO','PM-E','E2D-ZCAI-444-0','CC X SOLITAIRE MATA YT 16 8K ','','0.970','1','100.00','1057000','0','0','15000','1058000','0','0','0','1058000','AAT','00395842','E2D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCAI-444-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='E2D-ZCAI-444-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 ('F326311005581','2026-05-31','0.970','2026-05-31','10:05:59','PLG0029483','1058000','1058000','0','1058000','1058000','input','2026-05-31 10:05:58','F32631100558');
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-05-31','F326311005581','2026-05-31','10:05:59','AAT','1058000','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-260531-0011','D','2026-05-31','10:05:59','input','PENJUALAN','F326311005581','5332483000','1058000','5333541000');
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 ('F326311008191','input','1',' MEH1 X KH ','TOKO','PM-H','H1E-ZEBH-138-0','KL X SIEM COBRA MATA VAR KH 42 ','','1.820','1','100.00','2020000','0','0','15000','2020000','0','0','0','2020000','FIT','00405356','H1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEBH-138-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.820',berat_jual_asli=berat_jual_asli+'1.820',stock_jual='1',berat_akhir=berat_akhir-'1.820',berat_akhir_asli=berat_akhir_asli-'1.820',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='H1E-ZEBH-138-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 ('F326311008191','2026-05-31','1.820','2026-05-31','10:08:19','PLG0029484','2020000','2020000','0','2020000','2020000','input','2026-05-31 10:08:19','F32631100819');
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-05-31','F326311008191','2026-05-31','10:08:19','FIT','2020000','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-260531-0012','D','2026-05-31','10:08:19','input','PENJUALAN','F326311008191','5333541000','2020000','5335561000');
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 ('F326311014421','input','1',' MEF1 X UB ','TOKO','PM-F','F1E-YLBE-57-0','GL X OVAL SLEP UB 56 8K ','','4.900','1','100.00','5439000','0','0','15000','5440000','0','0','0','5440000','LIS','00383077','F1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YLBE-57-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.900',berat_jual_asli=berat_jual_asli+'4.900',stock_jual='1',berat_akhir=berat_akhir-'4.900',berat_akhir_asli=berat_akhir_asli-'4.900',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='F1E-YLBE-57-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 ('F326311014421','2026-05-31','4.900','2026-05-31','10:14:43','PLG0029485','5440000','5440000','0','5440000','5440000','input','2026-05-31 10:14:42','F32631101442');
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-05-31','F326311014421','2026-05-31','10:14:43','LIS','5440000','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-260531-0013','D','2026-05-31','10:14:43','input','PENJUALAN','F326311014421','5335561000','5440000','5341001000');
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 ('F326311019501','input','1',' MIH2 X UB ','TOKO','PM-H','H2I-YHXH-196-0','KL X RANTAI HOLLOW UB 46 9K ','','10.050','1','100.00','11959000','0','0','15000','11960000','0','0','0','11960000','SIN','00364724','H2I','0','0','-','0','1190000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-YHXH-196-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'10.050',berat_jual_asli=berat_jual_asli+'10.050',stock_jual='1',berat_akhir=berat_akhir-'10.050',berat_akhir_asli=berat_akhir_asli-'10.050',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='H2I-YHXH-196-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 ('F326311019501','2026-05-31','10.050','2026-05-31','10:19:50','PLG0029486','11960000','11960000','0','11960000','11960000','input','2026-05-31 10:19:50','F32631101950');
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-05-31','F326311019501','2026-05-31','10:19:50','SIN','11960000','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-260531-0014','D','2026-05-31','10:19:50','input','PENJUALAN','F326311019501','5341001000','11960000','5352961000');
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 ('F326311039141','input','1',' MDE2 X HW ','TOKO','PM-E','E2D-ZDAX-178-0','CC X SOLITAIRE MATA HW 13 8K ','','0.880','1','100.00','959000','0','0','15000','960000','0','10000','0','970000','FIT','00398948','E2D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZDAX-178-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.880',berat_jual_asli=berat_jual_asli+'0.880',stock_jual='1',berat_akhir=berat_akhir-'0.880',berat_akhir_asli=berat_akhir_asli-'0.880',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='E2D-ZDAX-178-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 ('F326311039141','2026-05-31','0.880','2026-05-31','10:39:15','PLG0029487','960000','960000','10000','970000','970000','input','2026-05-31 10:39:14','F32631103914');
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-05-31','F326311039141','2026-05-31','10:39:15','FIT','970000','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-260531-0015','D','2026-05-31','10:39:15','input','PENJUALAN','F326311039141','5352961000','970000','5353931000');
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 ('F326311041401','input','1',' MDE1 X CM ','TOKO','PM-E','E1D-ZDBG-280-0','CC X VELG C SLEP CM 16 ','','0.960','1','100.00','1046000','0','0','15000','1046000','0','0','0','1046000','SIN','00401523','E1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDBG-280-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.960',berat_jual_asli=berat_jual_asli+'0.960',stock_jual='1',berat_akhir=berat_akhir-'0.960',berat_akhir_asli=berat_akhir_asli-'0.960',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='E1D-ZDBG-280-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 ('F326311041401','2026-05-31','0.960','2026-05-31','10:41:40','PLG0029488','1046000','1046000','0','1046000','1046000','input','2026-05-31 10:41:40','F32631104140');
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-05-31','F326311041401','2026-05-31','10:41:40','SIN','1046000','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-260531-0016','D','2026-05-31','10:41:40','input','PENJUALAN','F326311041401','5353931000','1046000','5354977000');
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 ('F326311048201','input','1',' MIH2 X KH ','TOKO','PM-H','H2I-ZDXD-181-0','KL X SANTA KH 44 9K ','','1.950','1','100.00','2320000','0','0','15000','2320000','0','0','0','2320000','LIS','00397881','H2I','0','0','-','0','1190000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-ZDXD-181-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.950',berat_jual_asli=berat_jual_asli+'1.950',stock_jual='1',berat_akhir=berat_akhir-'1.950',berat_akhir_asli=berat_akhir_asli-'1.950',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='H2I-ZDXD-181-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 ('F326311048201','2026-05-31','1.950','2026-05-31','10:48:21','PLG0029489','2320000','2320000','0','2320000','2320000','input','2026-05-31 10:48:20','F32631104820');
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-05-31','F326311048201','2026-05-31','10:48:21','LIS','2320000','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-260531-0017','D','2026-05-31','10:48:21','input','PENJUALAN','F326311048201','5354977000','2320000','5357297000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2320000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326311048201' 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 ('F326311048202','input',' 1',' MEE2 5K LG','TOKO','PM-E','E2E-ZDXG-222-0','CC ANAK OSROT BONEKA CAT MATA VAR LG 8K ','','0.500','1','100.00','555000','0','0','15000','555000','0','5000','0','560000','LIS','00398400','E2E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZDXG-222-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='E2E-ZDXG-222-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 ('F326311048202','2026-05-31','0.500','2026-05-31','10:48:21','PLG0029490','555000','555000','5000','560000','560000','input','2026-05-31 10:48:20','F32631104820');
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-05-31','F326311048202','2026-05-31','10:48:21','LIS','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-260531-0018','D','2026-05-31','10:48:21','input','PENJUALAN','F326311048202','5357297000','560000','5357857000','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='F326311048202' 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 ('F326311051221','input','1',' MDA1D X LG','TOKO','PM-A','A1D-YHXB-30-0','AT X DAISY MATA LG 8K ','','1.010','1','100.00','1101000','0','0','15000','1100000','0','10000','0','1110000','FIT','00363440','A1D','0','0','-','1','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YHXB-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='A1D-YHXB-30-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 ('F326311051221','2026-05-31','1.010','2026-05-31','10:51:22','PLG0029491','1100000','1100000','10000','1110000','1110000','input','2026-05-31 10:51:22','F32631105122');
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-05-31','F326311051221','2026-05-31','10:51:22','FIT','1110000','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-260531-0019','D','2026-05-31','10:51:22','input','PENJUALAN','F326311051221','5357857000','1110000','5358967000');
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 ('F326311058571','input','1',' MDB1 X LG ','TOKO','PM-B','B1D-YJAA-12-0','GW X PANJANG MATA LG 8K ','','0.900','1','100.00','981000','0','0','15000','980000','0','0','0','980000','AAT','00372550','B1D','0','0','-','1','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-YJAA-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.900',berat_jual_asli=berat_jual_asli+'0.900',stock_jual='1',berat_akhir=berat_akhir-'0.900',berat_akhir_asli=berat_akhir_asli-'0.900',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='B1D-YJAA-12-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 ('F326311058571','2026-05-31','0.900','2026-05-31','10:58:58','PLG0029492','980000','980000','0','980000','980000','input','2026-05-31 10:58:57','F32631105857');
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-05-31','F326311058571','2026-05-31','10:58:58','AAT','980000','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-260531-0020','D','2026-05-31','10:58:58','input','PENJUALAN','F326311058571','5358967000','980000','5359947000');
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 ('F326311129241','input','1',' MEF3E X YT','TOKO','PM-F','F3E-ZDBG-101-0','GL X TIFF CAPELLA VAR YT 8K ','','1.750','1','100.00','1942000','0','0','15000','1943000','0','0','0','1943000','LIS','00401344','F3E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDBG-101-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.750',berat_jual_asli=berat_jual_asli+'1.750',stock_jual='1',berat_akhir=berat_akhir-'1.750',berat_akhir_asli=berat_akhir_asli-'1.750',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='F3E-ZDBG-101-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 ('F326311129241','2026-05-31','1.750','2026-05-31','11:29:25','PLG0029493','1943000','1943000','0','1943000','1943000','input','2026-05-31 11:29:24','F32631112924');
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-05-31','F326311129241','2026-05-31','11:29:25','LIS','1943000','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-260531-0021','D','2026-05-31','11:29:25','input','PENJUALAN','F326311129241','5359947000','1943000','5361890000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1943000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326311129241' 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 ('F326311129242','input',' 1',' MEE1E LG 1','TOKO','PM-E','E1E-ZEBH-125-T','CC MODEL ISYANA SLEP LG 14 8K ','','0.500','1','100.00','555000','0','0','15000','555000','0','0','0','555000','LIS','T0080066','E1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBH-125-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='E1E-ZEBH-125-T' 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 ('F326311129242','2026-05-31','0.500','2026-05-31','11:29:25','PLG0029494','555000','555000','0','555000','555000','input','2026-05-31 11:29:24','F32631112924');
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-05-31','F326311129242','2026-05-31','11:29:25','LIS','555000','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-260531-0022','D','2026-05-31','11:29:25','input','PENJUALAN','F326311129242','5361890000','555000','5362445000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='555000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326311129242' 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 ('F326311137191','input','1',' MEF3E XXX ','TOKO','PM-F','F3E-ZBXF-52-0','GL XXX SANTA ARESO SERUT VAR UB 8K ','','2.070','1','100.00','2298000','0','0','15000','2235000','0','0','0','2235000','SIN','00388634','F3E','0','0','-','1','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBXF-52-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='F3E-ZBXF-52-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 ('F326311137191','2026-05-31','2.070','2026-05-31','11:37:19','PLG0029495','2235000','2235000','0','2235000','2235000','input','2026-05-31 11:37:19','F32631113719');
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-05-31','F326311137191','2026-05-31','11:37:19','SIN','2235000','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-260531-0023','D','2026-05-31','11:37:19','input','PENJUALAN','F326311137191','5362445000','2235000','5364680000');
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 ('F326311140471','input','1',' MEF1 X YT ','TOKO','PM-F','F1E-ZCXB-238-0','GL X OVAL C SLEP YT 56 8K ','','3.420','1','100.00','3796000','0','0','15000','3795000','0','0','0','3795000','AAT','00391661','F1E','0','0','-','1','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZCXB-238-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.420',berat_jual_asli=berat_jual_asli+'3.420',stock_jual='1',berat_akhir=berat_akhir-'3.420',berat_akhir_asli=berat_akhir_asli-'3.420',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='F1E-ZCXB-238-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 ('F326311140471','2026-05-31','3.420','2026-05-31','11:40:48','PLG0029496','3795000','3795000','0','3795000','3795000','input','2026-05-31 11:40:47','F32631114047');
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-05-31','F326311140471','2026-05-31','11:40:48','AAT','3795000','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-260531-0024','D','2026-05-31','11:40:48','input','PENJUALAN','F326311140471','5364680000','3795000','5368475000');
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 ('F326311147031','input','1',' MEF3 HW ','TOKO','PM-F','F3E-ZDBC-197-0','GL FLIK MODEL BOLA ARESO VAR HW 8K ','','3.380','1','100.00','3752000','0','0','15000','3752000','0','0','0','3752000','LIS','00400919','F3E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDBC-197-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.380',berat_jual_asli=berat_jual_asli+'3.380',stock_jual='1',berat_akhir=berat_akhir-'3.380',berat_akhir_asli=berat_akhir_asli-'3.380',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='F3E-ZDBC-197-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 ('F326311147031','2026-05-31','3.380','2026-05-31','11:47:03','PLG0029497','3752000','3752000','0','3752000','3752000','input','2026-05-31 11:47:03','F32631114703');
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-05-31','F326311147031','2026-05-31','11:47:03','LIS','3752000','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-260531-0025','D','2026-05-31','11:47:03','input','PENJUALAN','F326311147031','5368475000','3752000','5372227000');
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 ('F326311148101','input','1',' MEE1 X HT1','TOKO','PM-E','E1E-ZEAA-108-0','CC X PIPA DAUN SLEP HT 16 8K ','','0.460','1','100.00','511000','0','0','15000','496000','0','0','0','496000','FIT','00403213','E1E','0','0','-','1','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEAA-108-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='E1E-ZEAA-108-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 ('F326311148101','2026-05-31','0.460','2026-05-31','11:48:11','PLG0029498','496000','496000','0','496000','496000','input','2026-05-31 11:48:10','F32631114810');
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-05-31','F326311148101','2026-05-31','11:48:11','FIT','496000','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-260531-0026','D','2026-05-31','11:48:11','input','PENJUALAN','F326311148101','5372227000','496000','5372723000');
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 ('F326311227181','input','1',' TEH1 X UB ','TOKO','PT-H','H1TE-ZEBA-17-T','KL X SANTA ANAK SLEP UB 34 17K ','','3.900','1','100.00','7917000','0','0','15000','7918000','0','0','0','7918000','SIN','T0079724','H1TE','0','0','-','0','2030000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TE-ZEBA-17-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.900',berat_jual_asli=berat_jual_asli+'3.900',stock_jual='1',berat_akhir=berat_akhir-'3.900',berat_akhir_asli=berat_akhir_asli-'3.900',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='H1TE-ZEBA-17-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326311227181','2026-05-31','3.900','2026-05-31','12:27:18','PLG0029499','7918000','7918000','0','7918000','7918000','input','2026-05-31 12:27:18','F32631122718');
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-05-31','F326311227181','2026-05-31','12:27:18','SIN','7918000','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-260531-0027','D','2026-05-31','12:27:18','input','PENJUALAN','F326311227181','5372723000','7918000','5380641000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='7918000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326311227181' 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 ('F326311227182','input',' 1',' TDE1 CM 12','TOKO','PT-E','E1TD-YGAI-11-T','CC POLOS CM 12 17K ','','2.030','1','100.00','4080000','0','0','15000','4080000','0','0','0','4080000','SIN','T0071248','E1TD','0','0','-','0','2010000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-YGAI-11-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='E1TD-YGAI-11-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326311227182','2026-05-31','2.030','2026-05-31','12:27:18','PLG0029500','4080000','4080000','0','4080000','4080000','input','2026-05-31 12:27:18','F32631122718');
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-05-31','F326311227182','2026-05-31','12:27:18','SIN','4080000','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-260531-0028','D','2026-05-31','12:27:18','input','PENJUALAN','F326311227182','5380641000','4080000','5384721000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4080000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326311227182' 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 ('F326311227541','input','1',' MDE2 X UB ','TOKO','PM-E','E2D-ZEBH-207-0','CC X MODEL MATA UB 12 8K ','','1.250','1','100.00','1362000','0','0','15000','1363000','0','0','0','1363000','FIT','00405425','E2D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEBH-207-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.250',berat_jual_asli=berat_jual_asli+'1.250',stock_jual='1',berat_akhir=berat_akhir-'1.250',berat_akhir_asli=berat_akhir_asli-'1.250',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='E2D-ZEBH-207-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 ('F326311227541','2026-05-31','1.250','2026-05-31','12:27:55','PLG0029501','1363000','1363000','0','1363000','1363000','input','2026-05-31 12:27:54','F32631122754');
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-05-31','F326311227541','2026-05-31','12:27:55','FIT','1363000','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-260531-0029','D','2026-05-31','12:27:55','input','PENJUALAN','F326311227541','5384721000','1363000','5386084000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1363000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326311227541' 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 ('F326311227542','input',' 1',' MEE1E LG 1','TOKO','PM-E','E1E-ZEBH-123-T','CC MODEL ISYANA SLEP LG 14 8K ','','0.500','1','100.00','555000','0','0','15000','555000','0','0','0','555000','FIT','T0080064','E1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBH-123-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='E1E-ZEBH-123-T' 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 ('F326311227542','2026-05-31','0.500','2026-05-31','12:27:55','PLG0029502','555000','555000','0','555000','555000','input','2026-05-31 12:27:54','F32631122754');
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-05-31','F326311227542','2026-05-31','12:27:55','FIT','555000','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-260531-0030','D','2026-05-31','12:27:55','input','PENJUALAN','F326311227542','5386084000','555000','5386639000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='555000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326311227542' LIMIT 1;
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-00019260','X-00019260','CC BANGKOK POLOS DW 18','GR','---','E0TA','BELI','BELI001','1482000','2026-05-31','1.000','1','kasir','2026-05-31 12:51:55');
DELETE FROM tp_barang WHERE kode_dept = 'X-E0TA';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E0TA','X-00019260','X-00019260');
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-260531-0001','F325231008281','FIT','1','BELI','BELI001','E0TA', 'X-00019260', 'CC BANGKOK POLOS DW 18','1.000','1.000','100.00','1375000','1482000','1482000','1940000','1','1482000','1482000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.000',berat_beli_asli=berat_beli_asli+'1.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.000',berat_akhir_asli=berat_akhir_asli+'1.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-31' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E0TA' 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-260531-0001','2026-05-31','2026-05-31','12:51:55','FIT','---','1.000','1482000','1482000','1482000','1482000','1482000','kasir','2026-05-31 12:51:55','FB-260531-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260531-0001','SARIJEM','TINASAT','','','','kasir','2026-05-31 12:51:55');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-31' 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-260531-0031','K','2026-05-31','12:51:55','kasir','PEMBELIAN UMUM','FB-260531-0001','5386639000','1482000','5385157000');
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-00019261','X-00019261','CC COR M 8K','GR','---','E2F','BELI','BELI001','525000','2026-05-31','0.810','1','kasir','2026-05-31 12:52:57');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2F','X-00019261','X-00019261');
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-260531-0002','t0052199','AAT','1','BELI','BELI001','E2F', 'X-00019261', 'CC COR M 8K','0.810','0.810','100.00','407000','525000','648148','1140000','1','525000','525000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.810',berat_beli_asli=berat_beli_asli+'0.810',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.810',berat_akhir_asli=berat_akhir_asli+'0.810',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-31' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2F' 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-260531-0002','2026-05-31','2026-05-31','12:52:57','AAT','---','0.810','525000','525000','525000','525000','525000','kasir','2026-05-31 12:52:57','FB-260531-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260531-0002','MAYA','BANGSRI PURWANTORO','','','','kasir','2026-05-31 12:52:57');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-31' 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-260531-0032','K','2026-05-31','12:52:57','kasir','PEMBELIAN UMUM','FB-260531-0002','5385157000','525000','5384632000');
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-00019262','X-00019262','GW MODEL SLEP LG PE 8K','GR','---','B1E','BELI','BELI001','485000','2026-05-31','0.500','1','kasir','2026-05-31 12:53:17');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1E','X-00019262','X-00019262');
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-260531-0003','F325201049351','AAT','1','BELI','BELI001','B1E', 'X-00019262', 'GW MODEL SLEP LG PE 8K','0.500','0.500','100.00','528000','485000','970000','1100000','1','485000','485000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.500',berat_beli_asli=berat_beli_asli+'0.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.500',berat_akhir_asli=berat_akhir_asli+'0.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-31' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1E' 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-260531-0003','2026-05-31','2026-05-31','12:53:16','AAT','---','0.500','485000','485000','485000','485000','485000','kasir','2026-05-31 12:53:17','FB-260531-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260531-0003','ARI','SLOGOHIMO','','','089649607608','kasir','2026-05-31 12:53:17');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-31' 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-260531-0033','K','2026-05-31','12:53:16','kasir','PEMBELIAN UMUM','FB-260531-0003','5384632000','485000','5384147000');
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-00019263','X-00019263','AT X ANAK BONEKA CAT VAR CM 8K','GR','---','A1E','BELI','BELI001','455000','2026-05-31','0.440','1','kasir','2026-05-31 12:53:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00019263','X-00019263');
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-260531-0004','F326290225561','SIN','1','BELI','BELI001','A1E', 'X-00019263', 'AT X ANAK BONEKA CAT VAR CM 8K','0.440','0.440','100.00','490000','455000','1034091','1100000','1','455000','455000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.440',berat_beli_asli=berat_beli_asli+'0.440',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.440',berat_akhir_asli=berat_akhir_asli+'0.440',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-31' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' 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-260531-0004','2026-05-31','2026-05-31','12:53:33','SIN','---','0.440','455000','455000','455000','455000','455000','kasir','2026-05-31 12:53:33','FB-260531-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260531-0004','HARTI','JAGIR','','','08522642902','kasir','2026-05-31 12:53:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-31' 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-260531-0034','K','2026-05-31','12:53:33','kasir','PEMBELIAN UMUM','FB-260531-0004','5384147000','455000','5383692000');
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-00019264','X-00019264','LT COR M 8K','GR','---','D2E','BELI','BELI001','1077000','2026-05-31','1.610','1','kasir','2026-05-31 12:57:04');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2E','X-00019264','X-00019264');
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-260531-0005','F323130908381','AAT','1','BELI','BELI001','D2E', 'X-00019264', 'LT COR M 8K','1.610','1.610','100.00','730000','1077000','668944','1100000','1','1077000','1077000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.610',berat_beli_asli=berat_beli_asli+'1.610',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.610',berat_akhir_asli=berat_akhir_asli+'1.610',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-31' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2E' 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-260531-0005','2026-05-31','2026-05-31','12:57:03','AAT','---','1.610','1077000','1077000','1077000','1077000','1077000','kasir','2026-05-31 12:57:04','FB-260531-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260531-0005','NATUN','BLIMBING PURWANTORO','','','','kasir','2026-05-31 12:57:04');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-31' 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-260531-0035','K','2026-05-31','12:57:03','kasir','PEMBELIAN UMUM','FB-260531-0005','5383692000','1077000','5382615000');
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-00019265','X-00019265','GL XX FLIK SLEP YT 8K','GR','---','F3E','BELI','BELI001','1075000','2026-05-31','1.010','1','kasir','2026-05-31 12:57:27');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019265','X-00019265');
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-260531-0006','F326201039201','LIS','1','BELI','BELI001','F3E', 'X-00019265', 'GL XX FLIK SLEP YT 8K','1.010','1.010','100.00','1140000','1075000','1064356','1100000','1','1075000','1075000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.010',berat_beli_asli=berat_beli_asli+'1.010',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.010',berat_akhir_asli=berat_akhir_asli+'1.010',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-31' 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-260531-0006','2026-05-31','2026-05-31','12:57:26','LIS','---','1.010','1075000','1075000','1075000','1075000','1075000','kasir','2026-05-31 12:57:27','FB-260531-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260531-0006','DWI','GAMBIRANOM KISMANTORO','','','085716073045','kasir','2026-05-31 12:57:27');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-31' 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-260531-0036','K','2026-05-31','12:57:26','kasir','PEMBELIAN UMUM','FB-260531-0006','5382615000','1075000','5381540000');
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-00019266','X-00019266','GL OSROT ANAK CAT LG 8K','GR','---','F1E','BELI','BELI001','943000','2026-05-31','1.030','1','kasir','2026-05-31 12:59:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00019266','X-00019266');
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-260531-0007','F326101206321','AAT','1','BELI','BELI001','F1E', 'X-00019266', 'GL OSROT ANAK CAT LG 8K','1.030','1.030','100.00','1143000','943000','915534','1100000','1','943000','943000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.030',berat_beli_asli=berat_beli_asli+'1.030',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.030',berat_akhir_asli=berat_akhir_asli+'1.030',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-31' 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-260531-0007','2026-05-31','2026-05-31','12:59:23','AAT','---','1.030','943000','943000','943000','943000','943000','kasir','2026-05-31 12:59:23','FB-260531-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260531-0007','SULIS','JATISARI BITING','','','088292172047','kasir','2026-05-31 12:59:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-31' 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-260531-0037','K','2026-05-31','12:59:23','kasir','PEMBELIAN UMUM','FB-260531-0007','5381540000','943000','5380597000');
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 ('F326310146071','kasir','1',' MEE1E LG16','TOKO','PM-E','E1E-ZEBB-113-T','CC MODEL DAUN SLEP LG 16 8K ','','0.470','1','100.00','522000','0','0','15000','522000','0','0','0','522000','FIT','T0079876','E1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBB-113-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='E1E-ZEBB-113-T' 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 ('F326310146071','2026-05-31','0.470','2026-05-31','13:46:08','PLG0029503','522000','522000','0','522000','522000','kasir','2026-05-31 13:46:07','F32631014607');
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-05-31','F326310146071','2026-05-31','13:46:08','FIT','522000','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-260531-0038','D','2026-05-31','13:46:08','kasir','PENJUALAN','F326310146071','5380597000','522000','5381119000');
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-00019267','X-00019267','CC PIPA KUKU MACAN SLEP CM 14 8K','GR','---','E1E','BELI','BELI001','597000','2026-05-31','0.580','1','kasir','2026-05-31 14:06:32');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00019267','X-00019267');
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-260531-0008','F326151042061','FIT','1','BELI','BELI001','E1E', 'X-00019267', 'CC PIPA KUKU MACAN SLEP CM 14 8K','0.580','0.580','100.00','690000','597000','1029310','1100000','1','597000','597000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.580',berat_beli_asli=berat_beli_asli+'0.580',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.580',berat_akhir_asli=berat_akhir_asli+'0.580',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-31' 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-260531-0008','2026-05-31','2026-05-31','14:06:32','FIT','---','0.580','597000','597000','597000','597000','597000','kasir','2026-05-31 14:06:32','FB-260531-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260531-0008','WARSINI','WOTGALIH BAKALAN','','','','kasir','2026-05-31 14:06:32');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-31' 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-260531-0039','K','2026-05-31','14:06:32','kasir','PEMBELIAN UMUM','FB-260531-0008','5381119000','597000','5380522000');
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 ('F326310208171','kasir','1',' MEF1 TD D3','TOKO','PM-F','F1E-ZCAC-191-0','GL ANAK MODEL C GELOMBANG TD D38 8K ','','2.390','1','100.00','2653000','0','0','15000','2653000','0','0','0','2653000','AAT','00394092','F1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZCAC-191-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.390',berat_jual_asli=berat_jual_asli+'2.390',stock_jual='1',berat_akhir=berat_akhir-'2.390',berat_akhir_asli=berat_akhir_asli-'2.390',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='F1E-ZCAC-191-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 ('F326310208171','2026-05-31','2.390','2026-05-31','14:08:17','PLG0029504','2653000','2653000','0','2653000','2653000','kasir','2026-05-31 14:08:17','F32631020817');
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-05-31','F326310208171','2026-05-31','14:08:17','AAT','2653000','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-260531-0040','D','2026-05-31','14:08:17','kasir','PENJUALAN','F326310208171','5380522000','2653000','5383175000');
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-00019268','X-00019268','CC X SOLITAIRE MATA BIRU AY 18 8K','GR','---','E2F','BELI','BELI001','910000','2026-05-31','0.860','1','kasir','2026-05-31 14:54:15');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2F','X-00019268','X-00019268');
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-260531-0009','F326131052331','SIN','1','BELI','BELI001','E2F', 'X-00019268', 'CC X SOLITAIRE MATA BIRU AY 18 8K','0.860','0.860','100.00','993000','910000','1058140','1140000','1','910000','910000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.860',berat_beli_asli=berat_beli_asli+'0.860',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.860',berat_akhir_asli=berat_akhir_asli+'0.860',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-31' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2F' 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-260531-0009','2026-05-31','2026-05-31','14:54:14','SIN','---','0.860','910000','910000','910000','910000','910000','kasir','2026-05-31 14:54:15','FB-260531-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260531-0009','NUR AINI','PURWANTORO','','','088200615780','kasir','2026-05-31 14:54:15');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-31' 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-260531-0041','K','2026-05-31','14:54:14','kasir','PEMBELIAN UMUM','FB-260531-0009','5383175000','910000','5382265000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260531-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260531-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260531-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260531-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260531-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260531-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260531-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260531-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260531-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260531-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260531-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260531-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260531-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260531-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260531-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260531-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260531-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260531-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326310146071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326310146071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326310146071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326310208171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326310208171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326310208171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326310753451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326310753451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326310753451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326310802581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326310802581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326310802581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326310850541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326310850541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326310850541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326310854311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326310854311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326310854311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326310854312' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326310854312' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326310854312';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326310918051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326310918051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326310918051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326310918281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326310918281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326310918281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326310921091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326310921091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326310921091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326310924131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326310924131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326310924131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326311005581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326311005581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326311005581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326311008191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326311008191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326311008191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326311014421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326311014421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326311014421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326311019501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326311019501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326311019501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326311039141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326311039141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326311039141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326311041401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326311041401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326311041401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326311048201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326311048201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326311048201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326311048202' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326311048202' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326311048202';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326311051221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326311051221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326311051221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326311058571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326311058571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326311058571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326311129241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326311129241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326311129241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326311129242' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326311129242' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326311129242';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326311137191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326311137191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326311137191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326311140471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326311140471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326311140471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326311147031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326311147031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326311147031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326311148101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326311148101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326311148101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326311227181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326311227181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326311227181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326311227182' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326311227182' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326311227182';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326311227541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326311227541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326311227541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326311227542' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326311227542' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326311227542';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-01','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-01';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-31';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-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='2026-05-31' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-31';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-31';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-31';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-31';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202604 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
UPDATE tt_barang_saldo SET tanggal= '2026-06-01' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-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-260601-0001','D','2026-06-01','15:12:02','SYSTEM','SALDO AWAL','SALDO AWAL','0','5382265000','5382265000');
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-260601-0001','D','2026-06-01','15:12:02','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-260601-0001','D','2026-06-01','15:12:02','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-260601-0001','D','2026-06-01','15:12:02','BCA','SALDO AWAL','SALDO AWAL','0','712562000','712562000');
UPDATE tp_system SET tgl_system='2026-06-01';