INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-08-26 ','08:26:14');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-08-26','129','0','-162300000','129','0','-162300000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-07-26';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-08-25';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-08-25';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-08-25' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-08-25';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-08-25';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-08-25';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-08-25';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202607 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
UPDATE tt_barang_saldo SET tanggal= '2026-08-26' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-08-25' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
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-260826-0001','D','2026-08-26','08:26:29','BCA','SALDO AWAL','SALDO AWAL','0','2013304213','2013304213');
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-260826-0001','D','2026-08-26','08:26:29','','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-08-26';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-08-26 ','08:26:54');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-08-26 ','08:29:26');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-08-26 ','08:43:12');
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-00009753','X-00009753','CN COR TDK BT SHB','GR','---','MDCN','BELI','BELI001','1435000','2026-08-26','1.950','1','sales','2026-08-26 09:00:53');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDCN';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDCN','X-00009753','X-00009753');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260826-0001','FJ-260210-0002','2403','1','BELI','BELI001','MDCN', 'X-00009753', 'CN COR TDK BT SHB','1.950','1.950','100.00','2447500','1435000','735897','1','1435000','1435000','RONGSOK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.950',berat_beli_asli=berat_beli_asli+'1.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.950',berat_akhir_asli=berat_akhir_asli+'1.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MDCN' 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,status_valid) VALUES ('FB-260826-0001','2026-08-26','2026-08-26','09:00:49','2403','---','1.950','1435000','1435000','1435000','1435000','1435000','sales','2026-08-26 09:00:53','FB-260826-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260826-0001','ANITA','JL. KALILOM LOR TMUR 1/16','','','','sales','2026-08-26 09:00:53');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-26' 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,status_valid) VALUES ('KK-260826-0002','K','2026-08-26','09:00:49','sales','PEMBELIAN UMUM','FB-260826-0001','48349821','1435000','46914821','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260826-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260826-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-26 ','09:48:55');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-26 ','09:51:05');
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260826-0001','1','X-00009744','BELI','BELI001','KL SUPERLIGHT 45CM KKT S HWT','1','7.100','11679500.00' ,'0.00','11679500','','11679500','11679500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-08-26 09:51:39' WHERE kode_barang='X-00009744' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009744' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009744' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'7.100',berat_hancur_asli=berat_hancur_asli+'7.100', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'7.100',berat_akhir_asli=berat_akhir_asli-'7.100' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTKL' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260826-0001','2','X-00009745','BELI','BELI001','CN COR TDK BT SHB','1','1.680','1625000.00' ,'0.00','1625000','','1625000','24984000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-08-26 09:51:39' WHERE kode_barang='X-00009745' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009745' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009745' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.680',berat_hancur_asli=berat_hancur_asli+'1.680', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.680',berat_akhir_asli=berat_akhir_asli-'1.680' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDCN' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260826-0001','3','X-00009746','BELI','BELI001','GW COR TDK BT LC2','1','2.050','1983000.00' ,'0.00','1983000','','1983000','28592000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-08-26 09:51:39' WHERE kode_barang='X-00009746' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009746' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009746' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'2.050',berat_hancur_asli=berat_hancur_asli+'2.050', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDGW' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260826-0001','4','X-00009747','BELI','BELI001','CN COR BT SHB','1','0.870','841500.00' ,'0.00','841500','','841500','31416500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-08-26 09:51:39' WHERE kode_barang='X-00009747' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009747' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009747' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.870',berat_hancur_asli=berat_hancur_asli+'0.870', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.870',berat_akhir_asli=berat_akhir_asli-'0.870' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDCN' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260826-0001','5','X-00009748','BELI','BELI001','CN COR TDK BT SHB','1','2.960','4869000.00' ,'0.00','4869000','','4869000','37127000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-08-26 09:51:39' WHERE kode_barang='X-00009748' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009748' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009748' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'2.960',berat_hancur_asli=berat_hancur_asli+'2.960', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'2.960',berat_akhir_asli=berat_akhir_asli-'2.960' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTCN' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260826-0001','6','X-00009749','BELI','BELI001','AT CAP KAWAT LM BT SHB','1','1.440','1198000.00' ,'0.00','1198000','','1198000','43194000','RUSAK BIASA');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-08-26 09:51:39' WHERE kode_barang='X-00009749' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009749' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009749' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.440',berat_hancur_asli=berat_hancur_asli+'1.440', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.440',berat_akhir_asli=berat_akhir_asli-'1.440' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDAT' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260826-0001','7','X-00009750','BELI','BELI001','CN COR BT SHB','1','1.550','1499500.00' ,'0.00','1499500','','1499500','45891500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-08-26 09:51:39' WHERE kode_barang='X-00009750' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009750' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009750' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.550',berat_hancur_asli=berat_hancur_asli+'1.550', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDCN' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_head(no_waste,sales_id,tgl_system,tgl_waste,jam_Waste,jml_beli_waste_rp,jml_jual_waste_rp,input_by,input_date) VALUES ('BS-260826-0001','adminpusat','2026-08-26','2026-08-26','09:51:40','23695500','45891500', 'adminpusat','2026-08-26 09:51:39');
INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI26-01841','2502','1','GL PIPA BT UBS 8K SRT 1LBR','0','1','0','','')
UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'2500000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'2500000'  WHERE tanggal='2026-08-26'
INSERT INTO tt_hutang_head (no_hutang,tgl_system,tgl_hutang,jam_hutang,kode_customer,sales_id,lama_hari,tgl_jth_tmp,input_by,input_date,berat,jml_awal_rp,bunga_persen,bunga_rp,jml_akhir_rp,sld_akhir_rp,status,berat_plus,qty,tgl_lunas,byr_harus_rp,kembali_rp)VALUES('PI26-01841','2026-08-26','2026-08-26','09:54:58','PLG0019360','2502','90','2026-11-24','sales','2026-08-26 09:54:58','5.400','2500000','3.00','225000','2725000','0','OPEN','17.88','1','2026-11-24','0','2725000')
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 ('KK-260826-0003','K','2026-08-26','09:54:58','sales','HUTANG','PI26-01841','46914821','2500000','44414821','OPEN') 
INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI26-01842','2502','1','CN PLINTIR SHB 8K SRT 1LBR','0','1','0','','')
UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'500000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'500000'  WHERE tanggal='2026-08-26'
INSERT INTO tt_hutang_head (no_hutang,tgl_system,tgl_hutang,jam_hutang,kode_customer,sales_id,lama_hari,tgl_jth_tmp,input_by,input_date,berat,jml_awal_rp,bunga_persen,bunga_rp,jml_akhir_rp,sld_akhir_rp,status,berat_plus,qty,tgl_lunas,byr_harus_rp,kembali_rp)VALUES('PI26-01842','2026-08-26','2026-08-26','09:59:38','PLG0019361','2502','90','2026-11-24','sales','2026-08-26 09:59:38','0.970','500000','4.00','60000','560000','0','OPEN','7.27','1','2026-11-24','0','560000')
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 ('KK-260826-0004','K','2026-08-26','09:59:38','sales','HUTANG','PI26-01842','44414821','500000','43914821','OPEN') 
UPDATE tt_hutang_head SET status_valid='DONE',status='OPEN' WHERE no_hutang='PI26-01841' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='PI26-01841';
UPDATE tt_hutang_head SET status_valid='DONE',status='OPEN' WHERE no_hutang='PI26-01842' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='PI26-01842';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-26 ','10:21:07');
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260826-0002','1','X-00009751','BELI','BELI001','KL ITALY ST VAR BT 43CM KKT PER BLT SHB','1','2.750','4111000.00' ,'0.00','4111000','','4111000','4111000','RONGSOK');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-08-26 10:21:35' WHERE kode_barang='X-00009751' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009751' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009751' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'2.750',berat_hancur_asli=berat_hancur_asli+'2.750', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'2.750',berat_akhir_asli=berat_akhir_asli-'2.750' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTKL' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260826-0002','2','X-00009752','BELI','BELI001','GL PLINTIR SHB','1','14.620','14144500.00' ,'0.00','14144500','','14144500','22366500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-08-26 10:21:35' WHERE kode_barang='X-00009752' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009752' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009752' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'14.620',berat_hancur_asli=berat_hancur_asli+'14.620', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'14.620',berat_akhir_asli=berat_akhir_asli-'14.620' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MSGL' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_head(no_waste,sales_id,tgl_system,tgl_waste,jam_Waste,jml_beli_waste_rp,jml_jual_waste_rp,input_by,input_date) VALUES ('BS-260826-0002','adminpusat','2026-08-26','2026-08-26','10:21:35','18255500','22366500', 'adminpusat','2026-08-26 10:21:35');
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-260826-0005','D','2026-08-26','10:33:34','cashier1','PEMASUKAN','TERIMA DARI PUSAT PAK BUDI ','43914821','100000000','143914821');
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-260826-0006','K','2026-08-26','10:35:30','cashier1','PENGELUARAN','BELI DOMPET KECIL MIKA MOTIF BUNGA 1112BJ ','143914821','1223200','142691621');
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,potong_rp) VALUES ('FJ-260826-0001','sales','1',' EX ','TOKO','BTKLMD','MDKL-YKXE-112-0','KL ITALY ST VC MRH 42CM KKT PER MK ','','3.110','1','100.00','3499000','0','0','0','3499000','0','0','0','3499000','2502','00026824','MDKL','157500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDKL-YKXE-112-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.110',berat_jual_asli=berat_jual_asli+'3.110',stock_jual='1',berat_akhir=berat_akhir-'3.110',berat_akhir_asli=berat_akhir_asli-'3.110',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='MDKL-YKXE-112-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTKLMD' 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 ('FJ-260826-0001','2026-08-26','3.110','2026-08-26','10:58:37','PLG0019362','3499000','3499000','0','3499000','3499000','sales','2026-08-26 10:58:35','FJ-260826-0001');
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-08-26','FJ-260826-0001','2026-08-26','10:58:37','2502','3499000','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-260826-0007','D','2026-08-26','10:58:37','sales','PENJUALAN','FJ-260826-0001','142691621','3499000','146190621');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260826-0001';
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,potong_rp) VALUES ('FJ-260826-0002','sales','1',' ','TOKO','BTGLMT','MTGL-ZGAD-29-0','GL RANGKAIAN COR 19CM KKT PER SHB ','','6.080','1','100.00','11370000','0','0','0','11370000','0','0','0','11370000','2106','00030747','MTGL','225000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTGL-ZGAD-29-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.080',berat_jual_asli=berat_jual_asli+'6.080',stock_jual='1',berat_akhir=berat_akhir-'6.080',berat_akhir_asli=berat_akhir_asli-'6.080',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='MTGL-ZGAD-29-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMT' 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 ('FJ-260826-0002','2026-08-26','6.080','2026-08-26','11:07:09','PLG0019363','11370000','11370000','0','11370000','11370000','sales','2026-08-26 11:07:08','FJ-260826-0002');
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-08-26','FJ-260826-0002','2026-08-26','11:07:09','2106','11370000','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-260826-0008','D','2026-08-26','11:07:09','sales','PENJUALAN','FJ-260826-0002','146190621','11370000','157560621');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260826-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-26 ','11:17:14');
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,potong_rp) VALUES ('FJ-260826-0003','sales','1',' ','TOKO','BTGLMT','MTGL-ZECX-7-0','GL PLINTIR SHB ','','7.040','1','100.00','13165000','0','0','0','13165000','0','0','0','13165000','2403','00029784','MTGL','225000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTGL-ZECX-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'7.040',berat_jual_asli=berat_jual_asli+'7.040',stock_jual='1',berat_akhir=berat_akhir-'7.040',berat_akhir_asli=berat_akhir_asli-'7.040',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='MTGL-ZECX-7-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMT' 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 ('FJ-260826-0003','2026-08-26','7.040','2026-08-26','11:24:39','PLG0019364','13165000','13165000','0','13165000','13165000','sales','2026-08-26 11:24:39','FJ-260826-0003');
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-08-26','FJ-260826-0003','2026-08-26','11:24:39','2403','13165000','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-260826-0009','D','2026-08-26','11:24:39','sales','PENJUALAN','FJ-260826-0003','157560621','13165000','170725621','OPEN');
UPDATE tt_jual_head SET dibayar_rp='13165000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260826-0003' 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,potong_rp) VALUES ('FJ-260826-0004','sales',' 1',' ','TOKO','BTGLMT','MTGL-ZBXI-97-0','GL HL RT ANAK MN1 1BEL 13CM KKT PER SHB ','','5.050','1','100.00','9443500','0','0','0','9443500','0','0','0','9443500','2403','00027911','MTGL','225000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTGL-ZBXI-97-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.050',berat_jual_asli=berat_jual_asli+'5.050',stock_jual='1',berat_akhir=berat_akhir-'5.050',berat_akhir_asli=berat_akhir_asli-'5.050',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='MTGL-ZBXI-97-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMT' 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 ('FJ-260826-0004','2026-08-26','5.050','2026-08-26','11:24:39','PLG0019365','9443500','9443500','0','9443500','9443500','sales','2026-08-26 11:24:39','FJ-260826-0003');
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-08-26','FJ-260826-0004','2026-08-26','11:24:39','2403','9443500','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-260826-0010','D','2026-08-26','11:24:39','sales','PENJUALAN','FJ-260826-0004','170725621','9443500','180169121','OPEN');
UPDATE tt_jual_head SET dibayar_rp='9443500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260826-0004' 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,potong_rp) VALUES ('FJ-260826-0005','sales','1',' EX ','TOKO','BTCNMD','MDCN-ZFAC-57-0','CN PLINTIR SHB ','','1.940','1','100.00','2182500','0','0','0','2182500','0','0','0','2182500','2103','00030249','MDCN','157500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZFAC-57-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.940',berat_jual_asli=berat_jual_asli+'1.940',stock_jual='1',berat_akhir=berat_akhir-'1.940',berat_akhir_asli=berat_akhir_asli-'1.940',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='MDCN-ZFAC-57-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' 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 ('FJ-260826-0005','2026-08-26','1.940','2026-08-26','11:26:46','PLG0019366','2182500','2182500','0','2182500','2182500','sales','2026-08-26 11:26:46','FJ-260826-0005');
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-08-26','FJ-260826-0005','2026-08-26','11:26:46','2103','2182500','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-260826-0011','D','2026-08-26','11:26:46','sales','PENJUALAN','FJ-260826-0005','180169121','2182500','182351621');
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,potong_rp) VALUES ('FJ-260826-0006','sales','1',' EX ','TOKO','BTCNMT','MTCN-ZCAD-8-0','CN ANAK CAP PLAT TDK BT SHB ','','0.500','1','100.00','935000','0','0','0','935000','0','0','0','935000','2105','00028992','MTCN','225000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-ZCAD-8-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-08-26' AND kode_barang='MTCN-ZCAD-8-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMT' 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 ('FJ-260826-0006','2026-08-26','0.500','2026-08-26','11:27:38','PLG0019367','935000','935000','0','935000','935000','sales','2026-08-26 11:27:38','FJ-260826-0006');
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-08-26','FJ-260826-0006','2026-08-26','11:27:38','2105','935000','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-260826-0012','D','2026-08-26','11:27:38','sales','PENJUALAN','FJ-260826-0006','182351621','935000','183286621','OPEN');
UPDATE tt_jual_head SET dibayar_rp='935000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260826-0006' 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,potong_rp) VALUES ('FJ-260826-0007','sales',' 1',' EX ','TOKO','BTCNMT','MTCN-ZFAC-63-0','CN CAP PLT ANK TDK BT SHB ','','0.540','1','100.00','1010000','0','0','0','1010000','0','0','0','1010000','2105','00030255','MTCN','225000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-ZFAC-63-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.540',berat_jual_asli=berat_jual_asli+'0.540',stock_jual='1',berat_akhir=berat_akhir-'0.540',berat_akhir_asli=berat_akhir_asli-'0.540',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='MTCN-ZFAC-63-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMT' 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 ('FJ-260826-0007','2026-08-26','0.540','2026-08-26','11:27:38','PLG0019368','1010000','1010000','0','1010000','1010000','sales','2026-08-26 11:27:38','FJ-260826-0006');
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-08-26','FJ-260826-0007','2026-08-26','11:27:38','2105','1010000','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-260826-0013','D','2026-08-26','11:27:38','sales','PENJUALAN','FJ-260826-0007','183286621','1010000','184296621','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1010000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260826-0007' 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,potong_rp) VALUES ('FJ-260826-0008','cashier1','1',' ','TOKO','BTCNMD','MDCN-ZFXE-25-0','CN COR BT SHB','','0.890','1','100.00','1001500','0','0','0','1001500','0','0','0','1001500','2105','00029923','MDCN','157500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZFXE-25-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.890',berat_jual_asli=berat_jual_asli+'0.890',stock_jual='1',berat_akhir=berat_akhir-'0.890',berat_akhir_asli=berat_akhir_asli-'0.890',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='MDCN-ZFXE-25-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' 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 ('FJ-260826-0008','2026-08-26','0.890','2026-08-26','11:28:18','PLG0019369','1001500','1001500','0','1001500','1001500','cashier1','2026-08-26 11:28:17','FJ-260826-0008');
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-08-26','FJ-260826-0008','2026-08-26','11:28:18','2105','1001500','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-260826-0014','D','2026-08-26','11:28:18','cashier1','PENJUALAN','FJ-260826-0008','184296621','1001500','185298121','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1001500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260826-0008' 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,potong_rp) VALUES ('FJ-260826-0009','cashier1',' 1',' EX ','TOKO','BTCNMD','MDCN-ZBAB-16-0','CN COR BT SHB ','','0.810','1','100.00','911500','0','0','0','911500','0','0','0','911500','2105','00028080','MDCN','157500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZBAB-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.810',berat_jual_asli=berat_jual_asli+'0.810',stock_jual='1',berat_akhir=berat_akhir-'0.810',berat_akhir_asli=berat_akhir_asli-'0.810',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='MDCN-ZBAB-16-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' 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 ('FJ-260826-0009','2026-08-26','0.810','2026-08-26','11:28:18','PLG0019370','911500','911500','0','911500','911500','cashier1','2026-08-26 11:28:17','FJ-260826-0008');
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-08-26','FJ-260826-0009','2026-08-26','11:28:18','2105','911500','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-260826-0015','D','2026-08-26','11:28:18','cashier1','PENJUALAN','FJ-260826-0009','185298121','911500','186209621','OPEN');
UPDATE tt_jual_head SET dibayar_rp='911500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260826-0009' 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,potong_rp) VALUES ('FJ-260826-0010','sales','1',' EX ','TOKO','BTKLMT','MTKL-ZAAX-42-0','KL ITALY ST VAR BT DSC 42CM KKT PER BLT SHB ','','3.070','1','100.00','5741000','0','0','0','5741000','0','0','0','5741000','2106','00027451','MTKL','225000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTKL-ZAAX-42-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.070',berat_jual_asli=berat_jual_asli+'3.070',stock_jual='1',berat_akhir=berat_akhir-'3.070',berat_akhir_asli=berat_akhir_asli-'3.070',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='MTKL-ZAAX-42-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTKLMT' 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 ('FJ-260826-0010','2026-08-26','3.070','2026-08-26','11:31:12','PLG0019371','5741000','5741000','0','5741000','5741000','sales','2026-08-26 11:31:11','FJ-260826-0010');
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-08-26','FJ-260826-0010','2026-08-26','11:31:12','2106','5741000','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-260826-0016','D','2026-08-26','11:31:12','sales','PENJUALAN','FJ-260826-0010','186209621','5741000','191950621','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5741000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260826-0010' 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,potong_rp) VALUES ('FJ-260826-0011','sales',' 1',' ','TOKO','BTATMT','MTAT-ZEBI-56-0','AT COR KAWAT DAISY SHB ','','1.070','1','100.00','2001000','0','0','0','2001000','0','0','0','2001000','2106','00029766','MTAT','225000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTAT-ZEBI-56-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='MTAT-ZEBI-56-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTATMT' 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 ('FJ-260826-0011','2026-08-26','1.070','2026-08-26','11:31:12','PLG0019372','2001000','2001000','0','2001000','2001000','sales','2026-08-26 11:31:11','FJ-260826-0010');
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-08-26','FJ-260826-0011','2026-08-26','11:31:12','2106','2001000','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-260826-0017','D','2026-08-26','11:31:12','sales','PENJUALAN','FJ-260826-0011','191950621','2001000','193951621','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2001000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260826-0011' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260826-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260826-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260826-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260826-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260826-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260826-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260826-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260826-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260826-0011';
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,potong_rp) VALUES ('FJ-260826-0012','sales','1',' EX ','TOKO','BTGLMD','MDGL-ZFAC-35-0','GL CAP HOLO 17CM SHB ','','10.740','1','100.00','12082500','0','0','0','12082500','0','0','0','12082500','2502','00030227','MDGL','157500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-ZFAC-35-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'10.740',berat_jual_asli=berat_jual_asli+'10.740',stock_jual='1',berat_akhir=berat_akhir-'10.740',berat_akhir_asli=berat_akhir_asli-'10.740',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='MDGL-ZFAC-35-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMD' 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 ('FJ-260826-0012','2026-08-26','10.740','2026-08-26','11:40:43','PLG0019373','12082500','12082500','0','12082500','12082500','sales','2026-08-26 11:40:42','FJ-260826-0012');
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-08-26','FJ-260826-0012','2026-08-26','11:40:43','2502','12082500','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-260826-0018','D','2026-08-26','11:40:43','sales','PENJUALAN','FJ-260826-0012','193951621','12082500','206034121','OPEN');
UPDATE tt_jual_head SET dibayar_rp='12082500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260826-0012' 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,potong_rp) VALUES ('FJ-260826-0013','sales',' 1',' EX ','TOKO','BTCNMD','MDCN-YKXD-114-0','CN COR BT SHB ','','1.500','1','100.00','1687500','0','0','0','1687500','0','0','0','1687500','2502','00026620','MDCN','157500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-YKXD-114-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='MDCN-YKXD-114-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' 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 ('FJ-260826-0013','2026-08-26','1.500','2026-08-26','11:40:43','PLG0019374','1687500','1687500','0','1687500','1687500','sales','2026-08-26 11:40:42','FJ-260826-0012');
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-08-26','FJ-260826-0013','2026-08-26','11:40:43','2502','1687500','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-260826-0019','D','2026-08-26','11:40:43','sales','PENJUALAN','FJ-260826-0013','206034121','1687500','207721621','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1687500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260826-0013' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260826-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260826-0013';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-26 ','11:54:09');
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-00009754','X-00009754','KL KOREA 43CM KKT S SHB','GR','---','MTKL','BELI','BELI001','6612500','2026-08-26','4.020','1','sales','2026-08-26 12:14:22');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTKL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTKL','X-00009754','X-00009754');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260826-0002','FJ-250906-0001','2105','1','BELI','BELI001','MTKL', 'X-00009754', 'KL KOREA 43CM KKT S SHB','4.020','4.020','100.00','5749000','6612500','1644900','1','6612500','6612500','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.020',berat_beli_asli=berat_beli_asli+'4.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.020',berat_akhir_asli=berat_akhir_asli+'4.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTKL' 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,status_valid) VALUES ('FB-260826-0002','2026-08-26','2026-08-26','12:14:22','2105','---','4.020','6612500','6612500','6612500','6612500','6612500','sales','2026-08-26 12:14:22','FB-260826-0002','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260826-0002','IMA','JATIPURWO 5/59','','','081547629873','sales','2026-08-26 12:14:22');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-26' 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,status_valid) VALUES ('KK-260826-0020','K','2026-08-26','12:14:22','sales','PEMBELIAN UMUM','FB-260826-0002','207721621','6612500','201109121','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260826-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260826-0002';
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-00009755','X-00009755','AT ITALY HT TDK BT UBS','GR','---','MDAT','BELI','BELI001','1025500','2026-08-26','1.060','1','sales','2026-08-26 12:30:16');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDAT';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDAT','X-00009755','X-00009755');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260826-0003','FJ-260125-0003','2403','1','BELI','BELI001','MDAT', 'X-00009755', 'AT ITALY HT TDK BT UBS','1.060','1.060','100.00','1251000','1025500','967453','1','1025500','1025500','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.060',berat_beli_asli=berat_beli_asli+'1.060',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.060',berat_akhir_asli=berat_akhir_asli+'1.060',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MDAT' 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,status_valid) VALUES ('FB-260826-0003','2026-08-26','2026-08-26','12:30:15','2403','---','1.060','1025500','1025500','1025500','1025500','1025500','sales','2026-08-26 12:30:16','FB-260826-0003','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260826-0003','VIKA','BLK BNTNG 1/29','','','','sales','2026-08-26 12:30:16');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-26' 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,status_valid) VALUES ('KK-260826-0021','K','2026-08-26','12:30:15','sales','PEMBELIAN UMUM','FB-260826-0003','201109121','1025500','200083621','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260826-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260826-0003';
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,potong_rp) VALUES ('FJ-260826-0014','sales','1',' EX ','TOKO','BTGLMD','MDGL-ZEAI-42-0','GL CAP HOLO 17CM KKT PER SHB ','','2.890','1','100.00','3251500','0','0','0','3251500','0','0','0','3251500','2403','00029684','MDGL','157500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-ZEAI-42-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.890',berat_jual_asli=berat_jual_asli+'2.890',stock_jual='1',berat_akhir=berat_akhir-'2.890',berat_akhir_asli=berat_akhir_asli-'2.890',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='MDGL-ZEAI-42-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMD' 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 ('FJ-260826-0014','2026-08-26','2.890','2026-08-26','12:37:04','PLG0019375','3251500','3251500','0','3251500','3251500','sales','2026-08-26 12:37:03','FJ-260826-0014');
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-08-26','FJ-260826-0014','2026-08-26','12:37:04','2403','3251500','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-260826-0022','D','2026-08-26','12:37:04','sales','PENJUALAN','FJ-260826-0014','200083621','3251500','203335121','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3251500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260826-0014' 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,potong_rp) VALUES ('FJ-260826-0015','sales',' 1',' EX ','TOKO','BTCNMD','MDCN-ZBAB-23-0','CN COR BT UBS ','','2.020','1','100.00','2272500','0','0','0','2272500','0','0','0','2272500','2403','00028087','MDCN','157500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZBAB-23-0' 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-08-26' AND kode_barang='MDCN-ZBAB-23-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' 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 ('FJ-260826-0015','2026-08-26','2.020','2026-08-26','12:37:04','PLG0019376','2272500','2272500','0','2272500','2272500','sales','2026-08-26 12:37:03','FJ-260826-0014');
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-08-26','FJ-260826-0015','2026-08-26','12:37:04','2403','2272500','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-260826-0023','D','2026-08-26','12:37:04','sales','PENJUALAN','FJ-260826-0015','203335121','2272500','205607621','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2272500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260826-0015' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-08-26 ','12:39:52');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-08-26 ','12:40:25');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260826-0014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260826-0015';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-08-26 ','12:41:41');
UPDATE tm_barang SET stock_on_hand='1' WHERE kode_barang='MDKL-YKXE-112-0' AND kode_lokasi_toko='BTKLMD' LIMIT 1;
UPDATE tt_jual_sales SET jml_jual_rp =jml_jual_rp-'3499000',ongkos_rp=ongkos_rp-'0' WHERE no_faktur_jual ='FJ-260826-0001';
UPDATE tt_jual_head SET status_return = 'CLOS' WHERE no_faktur_jual ='FJ-260826-0001';
UPDATE tt_barang_tukar SET status='CLOS' WHERE no_faktur_group='FJ-260826-0001';
UPDATE tt_voucher_customer SET status='OPEN' WHERE no_voucher='-'
UPDATE tt_barang_saldo SET stock_jual=stock_jual-1, berat_jual = berat_jual-'3.11',berat_jual_asli = berat_jual_asli-'3.1', stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'3.11',berat_akhir_asli=berat_akhir_asli+'3.1' WHERE tanggal ='2026-08-26' AND kode_lokasi_toko ='BTKLMD' AND kode_barang='MDKL-YKXE-112-0' AND stock_jual*1 > 0 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-260826-0024','K','2026-08-26','12:42:26','sales','BATAL PENJUALAN','BJ-260826-0001','205607621','3499000','202108621');
INSERT INTO tt_jual_retur_detail(no_retur_jual,no_urut,no_faktur_jual,kode_barang,nama_barang,berat,harga,ongkos,jml_detail,kode_lokasi_toko,kode_dept,kadar,sales_id,alasan,harga_atribut) VALUES ('BJ-260826-0001','1','FJ-260826-0001','MDKL-YKXE-112-0','KL ITALY ST VC MRH 42CM KKT PER MK ','3.11','3499000.00','0','3499000','BTKLMD','MDKL','100.00','sales','RETUR SALAH BERAT','0');
DELETE FROM tt_jual_head WHERE no_faktur_jual ='FJ-260826-0001' LIMIT 1;
DELETE FROM tt_jual_detail WHERE no_faktur_jual ='FJ-260826-0001' LIMIT 1;
DELETE FROM tt_jual_sales WHERE no_faktur_jual ='FJ-260826-0001' LIMIT 1;
INSERT INTO tt_jual_retur_head(no_retur_jual,tgl_system,tgl_retur_jual,kode_customer,dpp_netto_rp,jml_retur_rp,input_by,input_date)VALUES('BJ-260826-0001','2026-08-26','2026-08-26','PLG0019362','3499000','3499000','sales','2026-08-26 12:42:26');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-08-26 ','12:44:01');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260826-0016','sales','1',' EX ','TOKO','BTKLMD','MDKL-YKXE-112-0','KL ITALY ST VC MRH 42CM KKT PER MK ','','3.110','1','100.00','3499000','0','0','0','3515000','16000','0','0','3515000','2502','00026824','MDKL','157500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDKL-YKXE-112-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.110',berat_jual_asli=berat_jual_asli+'3.110',stock_jual='1',berat_akhir=berat_akhir-'3.110',berat_akhir_asli=berat_akhir_asli-'3.110',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='MDKL-YKXE-112-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTKLMD' 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 ('FJ-260826-0016','2026-08-26','3.110','2026-08-26','12:44:47','PLG0019377','3515000','3515000','0','3515000','3515000','sales','2026-08-26 12:44:46','FJ-260826-0016');
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-08-26','FJ-260826-0016','2026-08-26','12:44:47','2502','3515000','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-260826-0025','D','2026-08-26','12:44:47','sales','PENJUALAN','FJ-260826-0016','202108621','3515000','205623621');
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,potong_rp) VALUES ('FJ-260826-0017','sales','1',' EX ','TOKO','BTCNMT','MTCN-ZEAH-31-0','CN COR DB SHB ','','2.980','1','100.00','5573000','0','0','0','5573000','0','0','0','5573000','2602','00029607','MTCN','225000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-ZEAH-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.980',berat_jual_asli=berat_jual_asli+'2.980',stock_jual='1',berat_akhir=berat_akhir-'2.980',berat_akhir_asli=berat_akhir_asli-'2.980',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='MTCN-ZEAH-31-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMT' 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 ('FJ-260826-0017','2026-08-26','2.980','2026-08-26','12:51:20','PLG0019378','5573000','5573000','0','5573000','0','sales','2026-08-26 12:51:19','FJ-260826-0017');
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-08-26','FJ-260826-0017','2026-08-26','12:51:20','2602','5573000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260826-0001','2026-08-26','2026-08-26 12:51:19','PENJUALAN : FJ-260826-0017','bca','BCA','5573000','5573000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260826-0002','D','2026-08-26','12:51:20','BCA','PENJUALAN','FJ-260826-0017','2013304213','5573000','2018877213','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','SITI AMINAH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='5573000' WHERE no_faktur_jual='FJ-260826-0017' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-26 ','12:52:19');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260826-0016';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260826-0017';
INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI26-01843','2502','1','GL RANGKAIAN SHB700','0','1','0','','')
UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'5000000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'5000000'  WHERE tanggal='2026-08-26'
INSERT INTO tt_hutang_head (no_hutang,tgl_system,tgl_hutang,jam_hutang,kode_customer,sales_id,lama_hari,tgl_jth_tmp,input_by,input_date,berat,jml_awal_rp,bunga_persen,bunga_rp,jml_akhir_rp,sld_akhir_rp,status,berat_plus,qty,tgl_lunas,byr_harus_rp,kembali_rp)VALUES('PI26-01843','2026-08-26','2026-08-26','12:57:55','PLG0019379','2502','90','2026-11-24','sales','2026-08-26 12:57:55','9.930','5000000','3.00','450000','5450000','0','OPEN','21.08','1','2026-11-24','0','5450000')
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 ('KK-260826-0026','K','2026-08-26','12:57:55','sales','HUTANG','PI26-01843','205623621','5000000','200623621','OPEN') 
UPDATE tt_hutang_head SET status_valid='DONE',status='OPEN' WHERE no_hutang='PI26-01843' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='PI26-01843';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-26 ','13:15:28');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-08-26 ','13:40:02');
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','1','MTKL-YEXE-149-0','TOKO','BTKLMT','KL ANAK FANCY DB 34CM KKT S SHB ','1','2.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='1.990' WHERE kode_barang='MTKL-YEXE-149-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YEXE-149-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YEXE-149-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.000,berat_hancur_asli=berat_hancur_asli+2.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YEXE-149-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','2','MTKL-YCXF-194-0','TOKO','BTKLMT','KL FANCY ANAK DB 34CM KKT S SHB','1','2.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='1.990' WHERE kode_barang='MTKL-YCXF-194-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCXF-194-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCXF-194-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.000,berat_hancur_asli=berat_hancur_asli+2.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCXF-194-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','3','MTKL-YCXF-169-0','TOKO','BTKLMT','KL FANCY ANAK VAR BL BT 34CM KKT S SHB','1','1.520','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='1.510' WHERE kode_barang='MTKL-YCXF-169-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCXF-169-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCXF-169-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.520,berat_hancur_asli=berat_hancur_asli+1.520, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCXF-169-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','4','MTKL-XLXB-60-0','TOKO','BTKLMT','KL FANCY ANAK DB 34CM KKT S SHB ','1','2.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='1.990' WHERE kode_barang='MTKL-XLXB-60-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XLXB-60-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XLXB-60-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.000,berat_hancur_asli=berat_hancur_asli+2.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XLXB-60-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','5','MTKL-YCXF-178-0','TOKO','BTKLMT','KL FANCY ANAK VAR BT 34CM KKT S SHB','1','2.200','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='2.190' WHERE kode_barang='MTKL-YCXF-178-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCXF-178-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCXF-178-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.200,berat_hancur_asli=berat_hancur_asli+2.200, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCXF-178-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','6','MTKL-YCXF-191-0','TOKO','BTKLMT','KL FANCY ANAK DB 34CM KKT S SHB','1','2.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='1.990' WHERE kode_barang='MTKL-YCXF-191-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCXF-191-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCXF-191-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.000,berat_hancur_asli=berat_hancur_asli+2.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCXF-191-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','7','MTKL-YCXF-181-0','TOKO','BTKLMT','KL FANCY ANAK VAR BT 34CM KKT S SHB','1','2.180','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='2.170' WHERE kode_barang='MTKL-YCXF-181-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCXF-181-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCXF-181-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.180,berat_hancur_asli=berat_hancur_asli+2.180, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCXF-181-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','8','MTKL-YCXF-172-0','TOKO','BTKLMT','KL FANCY ANAK VAR HT BT 34CM KKT S SHB','1','1.600','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='1.590' WHERE kode_barang='MTKL-YCXF-172-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCXF-172-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCXF-172-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.600,berat_hancur_asli=berat_hancur_asli+1.600, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCXF-172-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','9','MTKL-YCXF-189-0','TOKO','BTKLMT','KL FANCY ANAK DB 34CM KKT S SHB','1','2.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='1.990' WHERE kode_barang='MTKL-YCXF-189-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCXF-189-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCXF-189-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.000,berat_hancur_asli=berat_hancur_asli+2.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCXF-189-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','10','MTKL-YEXE-148-0','TOKO','BTKLMT','KL ANAK FANCY VAR BT 34CM KKT S SHB ','1','1.500','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='1.490' WHERE kode_barang='MTKL-YEXE-148-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YEXE-148-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YEXE-148-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.500,berat_hancur_asli=berat_hancur_asli+1.500, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YEXE-148-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','11','MTKL-YCXF-180-0','TOKO','BTKLMT','KL FANCY ANAK VAR BT 34CM KKT S SHB','1','2.390','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='2.380' WHERE kode_barang='MTKL-YCXF-180-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCXF-180-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCXF-180-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.390,berat_hancur_asli=berat_hancur_asli+2.390, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCXF-180-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','12','MTKL-YCXF-173-0','TOKO','BTKLMT','KL FANCY ANAK VAR BUNGA BT 34CM KKT S SHB','1','1.600','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='1.590' WHERE kode_barang='MTKL-YCXF-173-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCXF-173-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCXF-173-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.600,berat_hancur_asli=berat_hancur_asli+1.600, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCXF-173-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','13','MTKL-YCXF-192-0','TOKO','BTKLMT','KL FANCY ANAK DB 34CM KKT S SHB','1','2.040','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='2.030' WHERE kode_barang='MTKL-YCXF-192-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCXF-192-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCXF-192-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.040,berat_hancur_asli=berat_hancur_asli+2.040, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCXF-192-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','14','MTKL-YCXF-185-0','TOKO','BTKLMT','KL FANCY ANAK DB 34CM KKT S SHB','1','2.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='1.990' WHERE kode_barang='MTKL-YCXF-185-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCXF-185-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCXF-185-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.000,berat_hancur_asli=berat_hancur_asli+2.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCXF-185-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','15','MTKL-YCXF-176-0','TOKO','BTKLMT','KL FANCY ANAK VAR BT 34CM KKT S SHB','1','2.010','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='2.000' WHERE kode_barang='MTKL-YCXF-176-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCXF-176-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCXF-176-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.010,berat_hancur_asli=berat_hancur_asli+2.010, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCXF-176-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','16','MTKL-YCXF-174-0','TOKO','BTKLMT','KL FANCY ANAK VAR BUNGA BT 34CM KKT S SHB','1','1.610','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='1.600' WHERE kode_barang='MTKL-YCXF-174-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCXF-174-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCXF-174-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.610,berat_hancur_asli=berat_hancur_asli+1.610, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCXF-174-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','17','MTKL-XJBE-9-0','TOKO','BTKLMT','KL FANCY ANAK CAT 33CM KKT S MK ','1','2.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='1.990' WHERE kode_barang='MTKL-XJBE-9-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XJBE-9-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XJBE-9-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.000,berat_hancur_asli=berat_hancur_asli+2.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XJBE-9-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','18','MTKL-XKXB-67-0','TOKO','BTKLMT','KL FANCY ANAK CAT 33CM KKT S MK ','1','2.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='1.990' WHERE kode_barang='MTKL-XKXB-67-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XKXB-67-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XKXB-67-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.000,berat_hancur_asli=berat_hancur_asli+2.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XKXB-67-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','19','MTKL-XJBE-11-0','TOKO','BTKLMT','KL FANCY ANAK CAT 33CM KKT S MK ','1','2.030','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='2.020' WHERE kode_barang='MTKL-XJBE-11-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XJBE-11-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XJBE-11-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.030,berat_hancur_asli=berat_hancur_asli+2.030, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XJBE-11-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','20','MTKL-YBXC-20-0','TOKO','BTKLMT','KL VIGARU FANCY ANAK CAT 34CM KKT S MK ','1','2.450','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='2.440' WHERE kode_barang='MTKL-YBXC-20-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YBXC-20-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YBXC-20-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.450,berat_hancur_asli=berat_hancur_asli+2.450, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YBXC-20-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','21','MTKL-XLBG-56-0','TOKO','BTKLMT','KL FANCY DB 42CM KKT S SHB ','1','2.230','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='2.220' WHERE kode_barang='MTKL-XLBG-56-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XLBG-56-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XLBG-56-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.230,berat_hancur_asli=berat_hancur_asli+2.230, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XLBG-56-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','22','MTKL-YACX-58-0','TOKO','BTKLMT','KL MILANO BT AD MRH 42CM KKT S SHB ','1','5.220','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='5.210' WHERE kode_barang='MTKL-YACX-58-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YACX-58-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YACX-58-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.220,berat_hancur_asli=berat_hancur_asli+5.220, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YACX-58-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','23','MTKL-YCXF-163-0','TOKO','BTKLMT','KL VALENTINE 42CM KKT S SHB ','1','3.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='2.990' WHERE kode_barang='MTKL-YCXF-163-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCXF-163-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCXF-163-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.000,berat_hancur_asli=berat_hancur_asli+3.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCXF-163-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','24','MTKL-YCBE-112-0','TOKO','BTKLMT','KL KOREA 47CM KKT S SHB ','1','6.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='5.990' WHERE kode_barang='MTKL-YCBE-112-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCBE-112-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCBE-112-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+6.000,berat_hancur_asli=berat_hancur_asli+6.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCBE-112-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','25','MTKL-YCXG-20-0','TOKO','BTKLMT','KL FANCY PLAT HURUF R 41CM KKT PER BLT SHB ','1','3.330','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='3.320' WHERE kode_barang='MTKL-YCXG-20-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCXG-20-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCXG-20-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.330,berat_hancur_asli=berat_hancur_asli+3.330, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCXG-20-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','26','MTKL-YCXG-16-0','TOKO','BTKLMT','KL FANCY PLAT HURUF M 41CM KKT PER BLT SHB ','1','3.600','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='3.590' WHERE kode_barang='MTKL-YCXG-16-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCXG-16-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCXG-16-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.600,berat_hancur_asli=berat_hancur_asli+3.600, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCXG-16-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','27','MTKL-YCXG-14-0','TOKO','BTKLMT','KL FANCY PLAT HURUF E 41CM KKT PER BLT SHB ','1','3.270','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='3.260' WHERE kode_barang='MTKL-YCXG-14-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCXG-14-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCXG-14-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.270,berat_hancur_asli=berat_hancur_asli+3.270, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCXG-14-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','28','MTKL-YCBE-85-0','TOKO','BTKLMT','KL ITALY ST ANAK CAT 35CM KKT PER BLT UBS ','1','3.160','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='3.150' WHERE kode_barang='MTKL-YCBE-85-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCBE-85-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCBE-85-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.160,berat_hancur_asli=berat_hancur_asli+3.160, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCBE-85-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','29','MTKL-YCBE-91-0','TOKO','BTKLMT','KL ITALY ST ANAK CAT 35CM KKT PER BLT UBS ','1','3.450','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='3.440' WHERE kode_barang='MTKL-YCBE-91-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCBE-91-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCBE-91-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.450,berat_hancur_asli=berat_hancur_asli+3.450, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCBE-91-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','30','MTKL-YCBE-87-0','TOKO','BTKLMT','KL ITALY ST ANAK CAT 35CM KKT PER BLT UBS ','1','2.850','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='2.840' WHERE kode_barang='MTKL-YCBE-87-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCBE-87-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCBE-87-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.850,berat_hancur_asli=berat_hancur_asli+2.850, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCBE-87-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','31','MTKL-YCBE-92-0','TOKO','BTKLMT','KL ITALY ST ANAK CAT BT 35CM KKT PER BLT UBS ','1','2.930','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='2.920' WHERE kode_barang='MTKL-YCBE-92-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCBE-92-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCBE-92-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.930,berat_hancur_asli=berat_hancur_asli+2.930, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCBE-92-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','32','MTKL-YCBE-90-0','TOKO','BTKLMT','KL ITALY ST ANAK CAT 35CM KKT PER BLT UBS ','1','3.180','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='3.170' WHERE kode_barang='MTKL-YCBE-90-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCBE-90-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCBE-90-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.180,berat_hancur_asli=berat_hancur_asli+3.180, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCBE-90-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','33','MTKL-YBXC-17-0','TOKO','BTKLMT','KL ITALY ST ANAK CAT 34CM KKT PER BLT SHB ','1','2.620','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='2.610' WHERE kode_barang='MTKL-YBXC-17-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YBXC-17-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YBXC-17-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.620,berat_hancur_asli=berat_hancur_asli+2.620, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YBXC-17-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','34','MTKL-YBXC-15-0','TOKO','BTKLMT','KL ITALY ST ANAK CAT 34CM KKT PER BLT MK ','1','2.640','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='2.630' WHERE kode_barang='MTKL-YBXC-15-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YBXC-15-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YBXC-15-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.640,berat_hancur_asli=berat_hancur_asli+2.640, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YBXC-15-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','35','MTKL-YCBE-93-0','TOKO','BTKLMT','KL FANCY ANAK TDK BT 39CM KKT PER BLT UBS ','1','3.050','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='3.040' WHERE kode_barang='MTKL-YCBE-93-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCBE-93-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCBE-93-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.050,berat_hancur_asli=berat_hancur_asli+3.050, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCBE-93-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','36','MTKL-YEXC-76-0','TOKO','BTKLMT','KL MILANO 42CM KKT PER BLT SHB ','1','4.020','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='4.010' WHERE kode_barang='MTKL-YEXC-76-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YEXC-76-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YEXC-76-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.020,berat_hancur_asli=berat_hancur_asli+4.020, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YEXC-76-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','37','MTKL-YEXC-63-0','TOKO','BTKLMT','KL MILANO 43CM KKT PER BLT SHB ','1','1.980','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='1.970' WHERE kode_barang='MTKL-YEXC-63-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YEXC-63-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YEXC-63-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.980,berat_hancur_asli=berat_hancur_asli+1.980, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YEXC-63-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','38','MTKL-YEXC-75-0','TOKO','BTKLMT','KL MILANO 42CM KKT PER BLT SHB ','1','2.010','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='2.000' WHERE kode_barang='MTKL-YEXC-75-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YEXC-75-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YEXC-75-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.010,berat_hancur_asli=berat_hancur_asli+2.010, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YEXC-75-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','39','MTKL-YEXC-82-0','TOKO','BTKLMT','KL MILANO 47CM KKT PER BLT SHB ','1','4.380','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='4.370' WHERE kode_barang='MTKL-YEXC-82-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YEXC-82-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YEXC-82-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.380,berat_hancur_asli=berat_hancur_asli+4.380, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YEXC-82-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','40','MTKL-YEXC-66-0','TOKO','BTKLMT','KL MILANO 42CM KKT PER BLT SHB ','1','4.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='3.990' WHERE kode_barang='MTKL-YEXC-66-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YEXC-66-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YEXC-66-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.000,berat_hancur_asli=berat_hancur_asli+4.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YEXC-66-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','41','MTKL-YEXC-74-0','TOKO','BTKLMT','KL MILANO 46CM KKT PER BLT SHB ','1','1.960','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='1.950' WHERE kode_barang='MTKL-YEXC-74-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YEXC-74-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YEXC-74-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.960,berat_hancur_asli=berat_hancur_asli+1.960, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YEXC-74-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','42','MTKL-YEXC-62-0','TOKO','BTKLMT','KL MILANO 43CM KKT PER BLT SHB ','1','1.960','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='1.950' WHERE kode_barang='MTKL-YEXC-62-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YEXC-62-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YEXC-62-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.960,berat_hancur_asli=berat_hancur_asli+1.960, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YEXC-62-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','43','MTKL-YEXC-80-0','TOKO','BTKLMT','KL MILANO 43CM KKT PER BLT SHB ','1','2.900','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='2.890' WHERE kode_barang='MTKL-YEXC-80-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YEXC-80-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YEXC-80-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.900,berat_hancur_asli=berat_hancur_asli+2.900, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YEXC-80-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','44','MTKL-YCBE-103-0','TOKO','BTKLMT','KL MILANO 42CM KKT PER BLT SHB ','1','6.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='5.990' WHERE kode_barang='MTKL-YCBE-103-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCBE-103-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCBE-103-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+6.000,berat_hancur_asli=berat_hancur_asli+6.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YCBE-103-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','45','MTKL-YEXC-87-0','TOKO','BTKLMT','KL MILANO ICE 42CM KKT PER BLT SHB ','1','2.800','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='2.790' WHERE kode_barang='MTKL-YEXC-87-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YEXC-87-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YEXC-87-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.800,berat_hancur_asli=berat_hancur_asli+2.800, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YEXC-87-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','46','MTKL-YEXC-85-0','TOKO','BTKLMT','KL MILTA 45CM KKT PER SHB ','1','6.030','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='6.020' WHERE kode_barang='MTKL-YEXC-85-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YEXC-85-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YEXC-85-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+6.030,berat_hancur_asli=berat_hancur_asli+6.030, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YEXC-85-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','47','MTKL-YEXC-84-0','TOKO','BTKLMT','KL MILTA 44CM KKT PER SHB ','1','7.950','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='7.940' WHERE kode_barang='MTKL-YEXC-84-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YEXC-84-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YEXC-84-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+7.950,berat_hancur_asli=berat_hancur_asli+7.950, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YEXC-84-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','48','MTKL-YEXC-48-0','TOKO','BTKLMT','KL ITALY ST 41CM KKT PER BLT SHB ','1','2.060','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='2.050' WHERE kode_barang='MTKL-YEXC-48-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YEXC-48-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YEXC-48-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.060,berat_hancur_asli=berat_hancur_asli+2.060, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YEXC-48-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','49','MTKL-YEXC-83-0','TOKO','BTKLMT','KL MILTA 43CM KKT PER SHB ','1','7.110','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='7.100' WHERE kode_barang='MTKL-YEXC-83-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YEXC-83-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YEXC-83-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+7.110,berat_hancur_asli=berat_hancur_asli+7.110, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YEXC-83-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','50','MTKL-YEXC-89-0','TOKO','BTKLMT','KL MILANO ICE 43CM KKT PER SHB ','1','5.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='4.990' WHERE kode_barang='MTKL-YEXC-89-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YEXC-89-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YEXC-89-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.000,berat_hancur_asli=berat_hancur_asli+5.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YEXC-89-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','51','MTKL-YEXC-47-0','TOKO','BTKLMT','KL ITALY ST 41CM KKT PER BLT SHB ','1','2.060','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='2.050' WHERE kode_barang='MTKL-YEXC-47-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YEXC-47-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YEXC-47-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.060,berat_hancur_asli=berat_hancur_asli+2.060, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YEXC-47-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','52','MTKL-YEXC-57-0','TOKO','BTKLMT','KL ITALY CEMET 45CM KKT PER BLT SHB','1','1.960','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='1.950' WHERE kode_barang='MTKL-YEXC-57-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YEXC-57-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YEXC-57-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.960,berat_hancur_asli=berat_hancur_asli+1.960, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YEXC-57-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','53','MTKL-YEXC-55-0','TOKO','BTKLMT','KL ITALY ST 42CM KKT PER BLT SHB ','1','2.620','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='2.610' WHERE kode_barang='MTKL-YEXC-55-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YEXC-55-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YEXC-55-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.620,berat_hancur_asli=berat_hancur_asli+2.620, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YEXC-55-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','54','MTKL-YEXC-94-0','TOKO','BTKLMT','KL FANCY PJG 66CM KKT PER SHB ','1','7.800','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='7.790' WHERE kode_barang='MTKL-YEXC-94-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YEXC-94-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YEXC-94-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+7.800,berat_hancur_asli=berat_hancur_asli+7.800, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YEXC-94-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','55','MTKL-YEXC-93-0','TOKO','BTKLMT','KL FANCY 63CM KKT PER SHB ','1','9.700','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='9.690' WHERE kode_barang='MTKL-YEXC-93-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YEXC-93-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YEXC-93-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+9.700,berat_hancur_asli=berat_hancur_asli+9.700, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YEXC-93-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','56','MTKL-YEXC-92-0','TOKO','BTKLMT','KL FANCY 55CM KKT PER SHB ','1','9.630','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='9.620' WHERE kode_barang='MTKL-YEXC-92-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YEXC-92-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YEXC-92-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+9.630,berat_hancur_asli=berat_hancur_asli+9.630, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YEXC-92-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260826-0003','57','MTKL-YACX-81-0','TOKO','BTKLMT','KL CATENA VAR BT 42CM KKT PER SHB ','1','4.350','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-08-26 13:51:42',status_delete='4.340' WHERE kode_barang='MTKL-YACX-81-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YACX-81-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YACX-81-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.350,berat_hancur_asli=berat_hancur_asli+4.350, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YACX-81-0' AND stock_akhir > 0;
INSERT INTO tt_waste_head (no_waste,tgl_system,sales_id,tgl_waste,jam_Waste,input_by,input_date) VALUES ('BS-260826-0003','2026-08-26','admin','2026-08-26','13:51:42','admin','2026-08-26 13:51:42');
INSERT INTO tm_credit_card(id_card,nama_customer,no_ktp,alamat1,alamat2,kota,no_telp,tgl_daftar,tgl_valid_until,tgl_last_gesek) VALUES ('6019009515161476','BCA','', ' ' , ' ' , ' ' ,'','2026-08-26 15:00:03','','2026-08-26 15:00:03');
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,potong_rp) VALUES ('FJ-260826-0018','cashier1','1',' ','TOKO','BTATMD','MDAT-ZBAI-154-0','AT TUSUK ITALY TDK BT UBS ','','0.780','1','100.00','877500','0','0','0','877500','0','0','0','877500','2502','00028530','MDAT','157500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDAT-ZBAI-154-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.780',berat_jual_asli=berat_jual_asli+'0.780',stock_jual='1',berat_akhir=berat_akhir-'0.780',berat_akhir_asli=berat_akhir_asli-'0.780',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='MDAT-ZBAI-154-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTATMD' 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 ('FJ-260826-0018','2026-08-26','0.780','2026-08-26','15:00:06','PLG0019380','877500','877500','0','877500','0','cashier1','2026-08-26 15:00:05','FJ-260826-0018');
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-08-26','FJ-260826-0018','2026-08-26','15:00:06','2502','877500','0');
INSERT INTO tt_debet(no_trx,tgl_system,tgl_trx,deskripsi,id_card,kode_bank,jml_cash_rp,debet_rp,debet_fee_rp) VALUES ('DC-260826-0001','2026-08-26','2026-08-26 15:00:05','PENJUALAN : FJ-260826-0018','6019009515161476','BCA','877500','877500','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260826-0003','D','2026-08-26','15:00:06','BCA','PENJUALAN','FJ-260826-0018','2018877213','877500','2019754713','DEBET');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='877500',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260826-0018' 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,potong_rp) VALUES ('FJ-260826-0019','cashier1',' 1',' EX ','TOKO','BTKLMS','MSKL-YKXC-115-0','KL ITALY ST VAR TDK BT PJG 66CM KKT S UBS ','','12.270','1','100.00','13804000','0','0','0','13804000','0','0','0','13804000','2502','00026503','MSKL','157500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MSKL-YKXC-115-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'12.270',berat_jual_asli=berat_jual_asli+'12.270',stock_jual='1',berat_akhir=berat_akhir-'12.270',berat_akhir_asli=berat_akhir_asli-'12.270',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='MSKL-YKXC-115-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTKLMS' 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 ('FJ-260826-0019','2026-08-26','12.270','2026-08-26','15:00:06','PLG0019381','13804000','13804000','0','13804000','0','cashier1','2026-08-26 15:00:05','FJ-260826-0018');
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-08-26','FJ-260826-0019','2026-08-26','15:00:06','2502','13804000','0');
INSERT INTO tt_debet(no_trx,tgl_system,tgl_trx,deskripsi,id_card,kode_bank,jml_cash_rp,debet_rp,debet_fee_rp) VALUES ('DC-260826-0002','2026-08-26','2026-08-26 15:00:05','PENJUALAN : FJ-260826-0019','6019009515161476','BCA','13804000','13804000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260826-0004','D','2026-08-26','15:00:06','BCA','PENJUALAN','FJ-260826-0019','2019754713','13804000','2033558713','DEBET');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='13804000',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260826-0019' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260826-0018';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260826-0019';
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,potong_rp) VALUES ('FJ-260826-0020','cashier1','1',' EX ','TOKO','BTATMD','MDAT-YCBE-133-0','AT COR KLP BT AD MRH SHB ','','1.200','1','100.00','1350000','0','0','0','1350000','0','0','0','1350000','2103','00024416','MDAT','157500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDAT-YCBE-133-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.200',berat_jual_asli=berat_jual_asli+'1.200',stock_jual='1',berat_akhir=berat_akhir-'1.200',berat_akhir_asli=berat_akhir_asli-'1.200',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='MDAT-YCBE-133-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTATMD' 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 ('FJ-260826-0020','2026-08-26','1.200','2026-08-26','15:32:00','PLG0019382','1350000','1350000','0','1350000','1350000','cashier1','2026-08-26 15:32:00','FJ-260826-0020');
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-08-26','FJ-260826-0020','2026-08-26','15:32:00','2103','1350000','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-260826-0027','D','2026-08-26','15:32:00','cashier1','PENJUALAN','FJ-260826-0020','200623621','1350000','201973621');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0020' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260826-0020' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260826-0020';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-08-26 ','15:42:04');
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-00009756','X-00009756','KL FANCY BL SLP 42CM KKT PER SHB','GR','---','MDKL','BELI','BELI001','2071500','2026-08-26','2.490','1','sales','2026-08-26 15:44:51');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDKL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDKL','X-00009756','X-00009756');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260826-0004','FJ-260616-0008','2401','1','BELI','BELI001','MDKL', 'X-00009756', 'KL FANCY BL SLP 42CM KKT PER SHB','2.490','2.490','100.00','2826500','2071500','831928','1','2071500','2071500','RUSAK BIASA');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-08-26','BELI','BELI001','MDKL','MDKL','100.00','2.490','2.490','1','2.490','2.490','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,status_valid) VALUES ('FB-260826-0004','2026-08-26','2026-08-26','15:44:51','2401','---','2.490','2071500','2071500','2071500','2071500','2071500','sales','2026-08-26 15:44:51','FB-260826-0004','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260826-0004','MERY','BANGKALAN','','','087815249293','sales','2026-08-26 15:44:51');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-26' 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,status_valid) VALUES ('KK-260826-0028','K','2026-08-26','15:44:51','sales','PEMBELIAN UMUM','FB-260826-0004','201973621','2071500','199902121','OPEN');
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-00009757','X-00009757','CN COR BT MK','GR','---','MDCN','BELI','BELI001','507500','2026-08-26','0.690','1','sales','2026-08-26 15:44:51');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDCN';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDCN','X-00009757','X-00009757');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260826-0005','FJ-260616-0007','2401','2','BELI','BELI001','MDCN', 'X-00009757', 'CN COR BT MK','0.820','0.690','100.00','931000','507500','735507','1','507500','507500','RONGSOK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.690',berat_beli_asli=berat_beli_asli+'0.690',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.690',berat_akhir_asli=berat_akhir_asli+'0.690',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MDCN' 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,status_valid) VALUES ('FB-260826-0005','2026-08-26','2026-08-26','15:44:51','2401','---','0.690','507500','507500','507500','507500','507500','sales','2026-08-26 15:44:51','FB-260826-0004','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260826-0005','MERY','BANGKALAN','','','087815249293','sales','2026-08-26 15:44:51');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-26' 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,status_valid) VALUES ('KK-260826-0029','K','2026-08-26','15:44:51','sales','PEMBELIAN UMUM','FB-260826-0005','199902121','507500','199394621','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260826-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260826-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260826-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260826-0005';
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-260826-0030','K','2026-08-26','15:54:32','cashier1','PENGELUARAN','BELI AIR MINUM 3 GALON CLUB ','199394621','54000','199340621');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-26 ','15:56:55');