INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-07-02 ','08:13:25');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-07-02 ','08:34:24');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-02','133','0','-149700000','133','0','-149700000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-01';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-01';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-01';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-07-01' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-01';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-01';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-01';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-01';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-02' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-01' 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-260702-0001','D','2026-07-02','08:34:39','BCA','SALDO AWAL','SALDO AWAL','0','2249389567','2249389567');
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-260702-0001','D','2026-07-02','08:34:39','','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-07-02';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-07-02 ','08:35:12');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-07-02 ','08:38:42');
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-260702-0001','1','X-00009614','BELI','BELI001','GL BABY PLINTIR 2 BEL SHB','1','4.860','7912000.00' ,'0.00','7912000','','7912000','7912000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-07-02 08:40:14' WHERE kode_barang='X-00009614' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009614' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009614' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'4.860',berat_hancur_asli=berat_hancur_asli+'4.860', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'4.860',berat_akhir_asli=berat_akhir_asli-'4.860' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTGL' 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-260702-0001','2','X-00009615','BELI','BELI001','CN COR BT MK','1','0.850','814500.00' ,'0.00','814500','','814500','16638500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-07-02 08:40:14' WHERE kode_barang='X-00009615' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009615' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009615' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.850',berat_hancur_asli=berat_hancur_asli+'0.850', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850' 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-260702-0001','3','X-00009616','BELI','BELI001','GL CAP HOLO 17CM KKT PER MK','1','4.010','3843500.00' ,'0.00','3843500','','3843500','21296500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-07-02 08:40:14' WHERE kode_barang='X-00009616' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009616' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009616' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'4.010',berat_hancur_asli=berat_hancur_asli+'4.010', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'4.010',berat_akhir_asli=berat_akhir_asli-'4.010' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDGL' 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-260702-0001','adminpusat','2026-07-02','2026-07-02','08:40:15','12570000','21296500', 'adminpusat','2026-07-02 08:40:14');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-07-02 ','08:54:32');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-07-02 ','09:25:54');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-07-02 ','09:32:29');
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-260702-0002','1','MTKL-YCBF-14-0','TOKO','BTKLMT','KL SATELIT PSR 50CM KKT PER BG3 ','1','20.450','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='20.440' WHERE kode_barang='MTKL-YCBF-14-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCBF-14-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCBF-14-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+20.450,berat_hancur_asli=berat_hancur_asli+20.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-YCBF-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-260702-0002','2','MTKL-YCXE-14-0','TOKO','BTKLMT','KL SATELIT PSR 50CM KKT PER BG3 ','1','29.060','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='29.050' WHERE kode_barang='MTKL-YCXE-14-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCXE-14-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCXE-14-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+29.060,berat_hancur_asli=berat_hancur_asli+29.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-YCXE-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-260702-0002','3','MTKL-YACX-20-0','TOKO','BTKLMT','KL FANCY POCO 45CM KKT S SHB ','1','9.800','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='9.790' WHERE kode_barang='MTKL-YACX-20-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YACX-20-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YACX-20-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+9.800,berat_hancur_asli=berat_hancur_asli+9.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-YACX-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-260702-0002','4','MTKL-YACX-17-0','TOKO','BTKLMT','KL HL RANTAI 45CM KKT S SHB ','1','9.960','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='9.950' WHERE kode_barang='MTKL-YACX-17-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YACX-17-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YACX-17-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+9.960,berat_hancur_asli=berat_hancur_asli+9.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-YACX-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-260702-0002','5','MTKL-YCBE-113-0','TOKO','BTKLMT','KL KOREA 46CM KKT S SHB ','1','4.500','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='4.490' WHERE kode_barang='MTKL-YCBE-113-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCBE-113-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCBE-113-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.500,berat_hancur_asli=berat_hancur_asli+4.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-YCBE-113-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-260702-0002','6','MTKL-XKXD-75-0','TOKO','BTKLMT','KL FANCY DB LMK 41CM KKT S SHB ','1','3.290','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='3.280' WHERE kode_barang='MTKL-XKXD-75-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XKXD-75-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XKXD-75-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.290,berat_hancur_asli=berat_hancur_asli+3.290, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XKXD-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-260702-0002','7','MTKL-XCBC-94-0','TOKO','BTKLMT','KL FANCY VAR DB 41CM KKT S SHB ','1','2.290','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='2.280' WHERE kode_barang='MTKL-XCBC-94-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XCBC-94-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XCBC-94-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.290,berat_hancur_asli=berat_hancur_asli+2.290, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XCBC-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-260702-0002','8','MTKL-WIAH-12-0','TOKO','BTKLMT','KL CATENA VAR BT BTR 41CM KKT PER MK','1','3.520','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='3.510' WHERE kode_barang='MTKL-WIAH-12-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-WIAH-12-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-WIAH-12-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.520,berat_hancur_asli=berat_hancur_asli+3.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-WIAH-12-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-260702-0002','9','MTKL-XEBE-92-0','TOKO','BTKLMT','KL FANCY BTR 41CM KKT S SHB ','1','2.100','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='2.090' WHERE kode_barang='MTKL-XEBE-92-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XEBE-92-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XEBE-92-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.100,berat_hancur_asli=berat_hancur_asli+2.100, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XEBE-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-260702-0002','10','MTKL-XEBE-85-0','TOKO','BTKLMT','KL ITALY ST BTR 41CM KKT PER BLT SHB ','1','2.900','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='2.890' WHERE kode_barang='MTKL-XEBE-85-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XEBE-85-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XEBE-85-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-XEBE-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-260702-0002','11','MTKL-XHXH-24-0','TOKO','BTKLMT','KL ITALY ST VC BT 42CM KKT PER BLT MK ','1','3.290','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='3.280' WHERE kode_barang='MTKL-XHXH-24-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XHXH-24-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XHXH-24-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.290,berat_hancur_asli=berat_hancur_asli+3.290, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XHXH-24-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-260702-0002','12','MTKL-XIXE-85-0','TOKO','BTKLMT','KL ITALY ST VAR BT VC PTH 42CM KKT PER BLT MK ','1','3.940','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='3.930' WHERE kode_barang='MTKL-XIXE-85-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XIXE-85-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XIXE-85-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.940,berat_hancur_asli=berat_hancur_asli+3.940, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XIXE-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-260702-0002','13','MTKL-XEBE-88-0','TOKO','BTKLMT','KL VANESSA 45CM KKT S SHB ','1','3.980','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='3.970' WHERE kode_barang='MTKL-XEBE-88-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XEBE-88-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XEBE-88-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.980,berat_hancur_asli=berat_hancur_asli+3.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-XEBE-88-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-260702-0002','14','MTKL-XKXG-69-0','TOKO','BTKLMT','KL ITALY ST BOLA KRW 41CM KKT PER BLT SHB ','1','2.980','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='2.970' WHERE kode_barang='MTKL-XKXG-69-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XKXG-69-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XKXG-69-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.980,berat_hancur_asli=berat_hancur_asli+2.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-XKXG-69-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-260702-0002','15','MTKL-XKXG-65-0','TOKO','BTKLMT','KL CATENA VAR BT 41CM KKT PER SHB ','1','3.650','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='3.640' WHERE kode_barang='MTKL-XKXG-65-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XKXG-65-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XKXG-65-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.650,berat_hancur_asli=berat_hancur_asli+3.650, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XKXG-65-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-260702-0002','16','MTKL-XJAE-127-0','TOKO','BTKLMT','KL FANCY 46CM KKT S SHB ','1','2.940','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='2.930' WHERE kode_barang='MTKL-XJAE-127-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XJAE-127-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XJAE-127-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.940,berat_hancur_asli=berat_hancur_asli+2.940, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XJAE-127-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-260702-0002','17','MTKL-XKXG-99-0','TOKO','BTKLMT','KL FANCY PJG 65CM KKT PER SHB ','1','15.280','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='15.270' WHERE kode_barang='MTKL-XKXG-99-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XKXG-99-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XKXG-99-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+15.280,berat_hancur_asli=berat_hancur_asli+15.280, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-XKXG-99-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-260702-0002','18','MTKL-YACX-57-0','TOKO','BTKLMT','KL ITALY ST BT AD BIRU 41CM KKT PER BLT UBS ','1','5.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='4.990' WHERE kode_barang='MTKL-YACX-57-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YACX-57-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YACX-57-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-YACX-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-260702-0002','19','MTKL-YACX-59-0','TOKO','BTKLMT','KL ITALY ST BT BTR 42CM KKT S SHB ','1','3.020','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='3.010' WHERE kode_barang='MTKL-YACX-59-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YACX-59-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YACX-59-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.020,berat_hancur_asli=berat_hancur_asli+3.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-YACX-59-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-260702-0002','20','MTKL-XLXB-64-0','TOKO','BTKLMT','KL MILANO ST PJG 68CM KKT PER SHB ','1','13.010','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='13.000' WHERE kode_barang='MTKL-XLXB-64-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-XLXB-64-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-XLXB-64-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+13.010,berat_hancur_asli=berat_hancur_asli+13.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-XLXB-64-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-260702-0002','21','MTKL-YACX-10-0','TOKO','BTKLMT','KL FANCY VAR BT 42CM KKT PER BLT UBS ','1','4.420','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='4.410' WHERE kode_barang='MTKL-YACX-10-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YACX-10-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YACX-10-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.420,berat_hancur_asli=berat_hancur_asli+4.420, 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-10-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-260702-0002','22','MTKL-YACX-52-0','TOKO','BTKLMT','KL ITALY ST VAR BL PSR BL SLP 42CM KKT PER BLT SHB ','1','2.970','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='2.960' WHERE kode_barang='MTKL-YACX-52-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YACX-52-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YACX-52-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.970,berat_hancur_asli=berat_hancur_asli+2.970, 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-52-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-260702-0002','23','MTKL-YACX-13-0','TOKO','BTKLMT','KL ITALY ST ROSARIO 64CM SHB ','1','9.620','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='9.610' WHERE kode_barang='MTKL-YACX-13-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YACX-13-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YACX-13-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+9.620,berat_hancur_asli=berat_hancur_asli+9.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-YACX-13-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-260702-0002','24','MTKL-YACX-30-0','TOKO','BTKLMT','KL FANCY 48CM KKT PER SHB ','1','14.980','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='14.970' WHERE kode_barang='MTKL-YACX-30-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YACX-30-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YACX-30-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+14.980,berat_hancur_asli=berat_hancur_asli+14.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-YACX-30-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-260702-0002','25','MTKL-YACX-31-0','TOKO','BTKLMT','KL FANCY 45CM KKT S SHB ','1','5.050','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='5.040' WHERE kode_barang='MTKL-YACX-31-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YACX-31-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YACX-31-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.050,berat_hancur_asli=berat_hancur_asli+5.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-YACX-31-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-260702-0002','26','MTKL-YACX-48-0','TOKO','BTKLMT','KL CATENA VAR BT 41CM KKT PER MK ','1','3.540','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='3.530' WHERE kode_barang='MTKL-YACX-48-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YACX-48-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YACX-48-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.540,berat_hancur_asli=berat_hancur_asli+3.540, 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-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-260702-0002','27','MTKL-YACX-49-0','TOKO','BTKLMT','KL CATENA VAR BT 41CM KKT PER SHB ','1','3.770','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='3.760' WHERE kode_barang='MTKL-YACX-49-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YACX-49-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YACX-49-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.770,berat_hancur_asli=berat_hancur_asli+3.770, 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-49-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-260702-0002','28','MTKL-YACX-37-0','TOKO','BTKLMT','KL MILANO 42CM KKT PER BLT SHB ','1','6.010','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='6.000' WHERE kode_barang='MTKL-YACX-37-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YACX-37-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YACX-37-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+6.010,berat_hancur_asli=berat_hancur_asli+6.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-YACX-37-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-260702-0002','29','MTKL-YACX-80-0','TOKO','BTKLMT','KL CATENA VAR BT 41CM KKT PER MK ','1','5.720','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='5.710' WHERE kode_barang='MTKL-YACX-80-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YACX-80-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YACX-80-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.720,berat_hancur_asli=berat_hancur_asli+5.720, 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-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-260702-0002','30','MTKL-YACX-74-0','TOKO','BTKLMT','KL ITALY ST DB 41CM KKT PER BLT SHB','1','4.200','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='4.190' WHERE kode_barang='MTKL-YACX-74-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YACX-74-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YACX-74-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.200,berat_hancur_asli=berat_hancur_asli+4.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-YACX-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-260702-0002','31','MTKL-YACX-65-0','TOKO','BTKLMT','KL ITALY ST BT 42CM KKT PER BLT SHB ','1','3.220','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='3.210' WHERE kode_barang='MTKL-YACX-65-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YACX-65-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YACX-65-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.220,berat_hancur_asli=berat_hancur_asli+3.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-65-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-260702-0002','32','MTKL-YACX-76-0','TOKO','BTKLMT','KL ITALY ST BTR 41CM KKT PER BLT MK','1','3.110','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='3.100' WHERE kode_barang='MTKL-YACX-76-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YACX-76-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YACX-76-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.110,berat_hancur_asli=berat_hancur_asli+3.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-YACX-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-260702-0002','33','MTKL-YCXA-4-0','TOKO','BTKLMT','KL SQUIEDEST 41CM KKT S SHB ','1','3.020','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='3.010' WHERE kode_barang='MTKL-YCXA-4-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCXA-4-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCXA-4-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.020,berat_hancur_asli=berat_hancur_asli+3.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-YCXA-4-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-260702-0002','34','MTKL-YACX-78-0','TOKO','BTKLMT','KL ITALY VC HTM 42CM KKT PER BLT MK ','1','3.630','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='3.620' WHERE kode_barang='MTKL-YACX-78-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YACX-78-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YACX-78-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.630,berat_hancur_asli=berat_hancur_asli+3.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-YACX-78-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-260702-0002','35','MTKL-YEXC-44-0','TOKO','BTKLMT','KL FANCY VAR VC 40CM KKT PER BTG ','1','3.070','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='3.060' WHERE kode_barang='MTKL-YEXC-44-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YEXC-44-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YEXC-44-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.070,berat_hancur_asli=berat_hancur_asli+3.070, 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-44-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-260702-0002','36','MTKL-YCBE-109-0','TOKO','BTKLMT','KL SQUIDEST 41CM KKT S SHB ','1','3.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='2.990' WHERE kode_barang='MTKL-YCBE-109-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCBE-109-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCBE-109-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-YCBE-109-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-260702-0002','37','MTKL-YCBE-105-0','TOKO','BTKLMT','KL MILANO 44CM KKT PER SHB ','1','6.920','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='6.910' WHERE kode_barang='MTKL-YCBE-105-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCBE-105-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCBE-105-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+6.920,berat_hancur_asli=berat_hancur_asli+6.920, 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-105-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-260702-0002','38','MTKL-YEXC-95-0','TOKO','BTKLMT','KL MILANO PJG 67CM KKT PER BLT SHB','1','5.800','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='5.790' WHERE kode_barang='MTKL-YEXC-95-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YEXC-95-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YEXC-95-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.800,berat_hancur_asli=berat_hancur_asli+5.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-95-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-260702-0002','39','MTKL-YCBE-107-0','TOKO','BTKLMT','KL MILANO 51CM KKT PER SHB ','1','9.980','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='9.970' WHERE kode_barang='MTKL-YCBE-107-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCBE-107-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCBE-107-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+9.980,berat_hancur_asli=berat_hancur_asli+9.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-YCBE-107-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-260702-0002','40','MTKL-YCBE-106-0','TOKO','BTKLMT','KL MILANO 44CM KKT PER SHB ','1','8.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='7.990' WHERE kode_barang='MTKL-YCBE-106-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCBE-106-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCBE-106-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+8.000,berat_hancur_asli=berat_hancur_asli+8.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-106-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-260702-0002','41','MTKL-YEXC-99-0','TOKO','BTKLMT','KL MILANO ST PJG 65CM KKT PER SHB ','1','8.870','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='8.860' WHERE kode_barang='MTKL-YEXC-99-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YEXC-99-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YEXC-99-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+8.870,berat_hancur_asli=berat_hancur_asli+8.870, 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-99-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-260702-0002','42','MTKL-YCBE-48-0','TOKO','BTKLMT','KL FANCY 42CM KKT S SHB ','1','4.010','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='4.000' WHERE kode_barang='MTKL-YCBE-48-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCBE-48-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCBE-48-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.010,berat_hancur_asli=berat_hancur_asli+4.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-YCBE-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-260702-0002','43','MTKL-YEXC-60-0','TOKO','BTKLMT','KL ITALY CEMET 44CM KKT PER SHB ','1','4.920','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='4.910' WHERE kode_barang='MTKL-YEXC-60-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YEXC-60-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YEXC-60-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.920,berat_hancur_asli=berat_hancur_asli+4.920, 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-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-260702-0002','44','MTKL-YEXC-65-0','TOKO','BTKLMT','KL MILANO 44CM KKT PER BLT SHB','1','2.960','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='2.950' WHERE kode_barang='MTKL-YEXC-65-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YEXC-65-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YEXC-65-0';
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=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YEXC-65-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-260702-0002','45','MTKL-YCBE-100-0','TOKO','BTKLMT','KL BLB VAR 42CM KKT PER SHB ','1','10.480','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='10.470' WHERE kode_barang='MTKL-YCBE-100-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCBE-100-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCBE-100-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.480,berat_hancur_asli=berat_hancur_asli+10.480, 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-100-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-260702-0002','46','MTKL-YEXC-79-0','TOKO','BTKLMT','KL MILANO 43CM KKT PER BLT SHB ','1','5.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='4.990' WHERE kode_barang='MTKL-YEXC-79-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YEXC-79-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YEXC-79-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-79-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-260702-0002','47','MTKL-YCBE-104-0','TOKO','BTKLMT','KL MILANO 44CM KKT PER SHB ','1','6.940','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='6.930' WHERE kode_barang='MTKL-YCBE-104-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCBE-104-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCBE-104-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+6.940,berat_hancur_asli=berat_hancur_asli+6.940, 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-104-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-260702-0002','48','MTKL-YCBE-99-0','TOKO','BTKLMT','KL VANESSA DB 46CM KKT PER SHB ','1','8.630','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='8.620' WHERE kode_barang='MTKL-YCBE-99-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YCBE-99-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YCBE-99-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+8.630,berat_hancur_asli=berat_hancur_asli+8.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-YCBE-99-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-260702-0002','49','MTKL-YFAH-169-0','TOKO','BTKLMT','KL FANCY 44CM KKT S SHB ','1','3.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='2.990' WHERE kode_barang='MTKL-YFAH-169-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YFAH-169-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YFAH-169-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-YFAH-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-260702-0002','50','MTKL-YHBF-7-0','TOKO','BTKLMT','KL RANGKAIAN 42CM KKT PER MK ','1','20.120','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='20.110' WHERE kode_barang='MTKL-YHBF-7-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YHBF-7-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YHBF-7-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+20.120,berat_hancur_asli=berat_hancur_asli+20.120, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YHBF-7-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-260702-0002','51','MTKL-YGAE-47-0','TOKO','BTKLMT','KL ITALY ST VAR BT 42CM KKT PER BLT SHB ','1','3.170','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='3.160' WHERE kode_barang='MTKL-YGAE-47-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YGAE-47-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YGAE-47-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.170,berat_hancur_asli=berat_hancur_asli+3.170, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YGAE-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-260702-0002','52','MTKL-YGAE-86-0','TOKO','BTKLMT','KL FANCY 43CM KKT PER SHB ','1','5.010','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='5.000' WHERE kode_barang='MTKL-YGAE-86-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YGAE-86-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YGAE-86-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.010,berat_hancur_asli=berat_hancur_asli+5.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-YGAE-86-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-260702-0002','53','MTKL-YGAE-64-0','TOKO','BTKLMT','KL ITALY ST VAR TDK BT 42CM KKT PER BLT SHB ','1','3.210','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='3.200' WHERE kode_barang='MTKL-YGAE-64-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YGAE-64-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YGAE-64-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.210,berat_hancur_asli=berat_hancur_asli+3.210, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YGAE-64-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-260702-0002','54','MTKL-YJCX-42-0','TOKO','BTKLMT','KL ITALY ST VC HTM 42CM KKT PER BLT MK ','1','3.910','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='3.900' WHERE kode_barang='MTKL-YJCX-42-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YJCX-42-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YJCX-42-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.910,berat_hancur_asli=berat_hancur_asli+3.910, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YJCX-42-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-260702-0002','55','MTKL-YHBI-45-0','TOKO','BTKLMT','KL ITALY ST VC HTM 42CM KKT PER BLT MK ','1','3.780','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='3.770' WHERE kode_barang='MTKL-YHBI-45-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YHBI-45-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YHBI-45-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.780,berat_hancur_asli=berat_hancur_asli+3.780, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YHBI-45-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-260702-0002','56','MTKL-YHBI-39-0','TOKO','BTKLMT','KL FANCY 46CM KKT PER SHB ','1','5.050','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='5.040' WHERE kode_barang='MTKL-YHBI-39-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YHBI-39-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YHBI-39-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.050,berat_hancur_asli=berat_hancur_asli+5.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-YHBI-39-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-260702-0002','57','MTKL-YHBI-41-0','TOKO','BTKLMT','KL CASTELI 43CM KKT S SHB ','1','2.480','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-02 09:43:29',status_delete='2.470' WHERE kode_barang='MTKL-YHBI-41-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-YHBI-41-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-YHBI-41-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.480,berat_hancur_asli=berat_hancur_asli+2.480, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTKLMT' AND kode_barang='MTKL-YHBI-41-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-260702-0002','2026-07-02','admin','2026-07-02','09:43:29','admin','2026-07-02 09:43:29');
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-260702-0001','sales','1',' EX ','TOKO','BTATMD','MDAT-ZEAI-8-0','AT ITALY BT SHB ','','1.200','1','100.00','1338000','0','0','0','1338000','0','0','0','1338000','2103','00029650','MDAT','156500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-07-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDAT-ZEAI-8-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-07-02' AND kode_barang='MDAT-ZEAI-8-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-260702-0001','2026-07-02','1.200','2026-07-02','10:20:51','PLG0019089','1338000','1338000','0','1338000','1338000','sales','2026-07-02 10:20:48','FJ-260702-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-07-02','FJ-260702-0001','2026-07-02','10:20:51','2103','1338000','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-260702-0002','D','2026-07-02','10:20:51','sales','PENJUALAN','FJ-260702-0001','259848848','1338000','261186848');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260702-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260702-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260702-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-260702-0002','sales','1',' EX ','TOKO','BTCNMT','MTCN-ZFAH-17-0','CN COR BT SHB ','','1.370','1','100.00','2534500','0','0','0','2534500','0','0','0','2534500','2403','00030428','MTCN','222000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-07-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-ZFAH-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.370',berat_jual_asli=berat_jual_asli+'1.370',stock_jual='1',berat_akhir=berat_akhir-'1.370',berat_akhir_asli=berat_akhir_asli-'1.370',stock_akhir='0' WHERE tanggal='2026-07-02' AND kode_barang='MTCN-ZFAH-17-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-260702-0002','2026-07-02','1.370','2026-07-02','10:25:11','PLG0019090','2534500','2534500','0','2534500','2534500','sales','2026-07-02 10:25:10','FJ-260702-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-07-02','FJ-260702-0002','2026-07-02','10:25:11','2403','2534500','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-260702-0003','D','2026-07-02','10:25:11','sales','PENJUALAN','FJ-260702-0002','261186848','2534500','263721348');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260702-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260702-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260702-0002';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260702-0003','sales','1',' ','TOKO','BTGLMD','MDGL-ZEAB-13-0','GL RANGKAIAN COR 16CM KKT PER SHB ','','4.570','1','100.00','5096000','0','0','0','5096000','0','0','0','5096000','2105','00029489','MDGL','156500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-07-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-ZEAB-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.570',berat_jual_asli=berat_jual_asli+'4.570',stock_jual='1',berat_akhir=berat_akhir-'4.570',berat_akhir_asli=berat_akhir_asli-'4.570',stock_akhir='0' WHERE tanggal='2026-07-02' AND kode_barang='MDGL-ZEAB-13-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-260702-0003','2026-07-02','4.570','2026-07-02','10:35:37','PLG0019091','5096000','5096000','0','5096000','5096000','sales','2026-07-02 10:35:37','FJ-260702-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-07-02','FJ-260702-0003','2026-07-02','10:35:37','2105','5096000','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-260702-0004','D','2026-07-02','10:35:37','sales','PENJUALAN','FJ-260702-0003','263721348','5096000','268817348');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260702-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260702-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260702-0003';
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 ('5260512041500834','BCA','', ' ' , ' ' , ' ' ,'','2026-07-02 11:09:38','','2026-07-02 11:09:38');
UPDATE tm_credit_card SET nama_customer='BCA',no_ktp='',alamat1=' ' ,alamat2=' ' ,kota= ' ' ,no_telp='',tgl_valid_until='',tgl_last_gesek='2026-07-02 11:09:39' WHERE id_card = '5260512041500834';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-07-02 ','11:10:24');
UPDATE tm_credit_card SET nama_customer='BCA',no_ktp='',alamat1=' ' ,alamat2=' ' ,kota= ' ' ,no_telp='',tgl_valid_until='',tgl_last_gesek='2026-07-02 11:11:16' WHERE id_card = '5260512041500834';
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-260702-0004','sales','1',' EX ','TOKO','BTCNMT','MTCN-XKXG-21-0','CN SESER SHB ','','10.100','1','100.00','18685000','0','0','0','18685000','0','0','0','18685000','2602','00021449','MTCN','222000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-07-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-XKXG-21-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'10.100',berat_jual_asli=berat_jual_asli+'10.100',stock_jual='1',berat_akhir=berat_akhir-'10.100',berat_akhir_asli=berat_akhir_asli-'10.100',stock_akhir='0' WHERE tanggal='2026-07-02' AND kode_barang='MTCN-XKXG-21-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-260702-0004','2026-07-02','10.100','2026-07-02','11:11:20','PLG0019092','18685000','18685000','0','18685000','0','sales','2026-07-02 11:11:18','FJ-260702-0004');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-02','FJ-260702-0004','2026-07-02','11:11:20','2602','18685000','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-260702-0001','2026-07-02','2026-07-02 11:11:18','PENJUALAN : FJ-260702-0004','5260512041500834','BCA','18685000','18685000','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-260702-0002','D','2026-07-02','11:11:20','BCA','PENJUALAN','FJ-260702-0004','2249389567','18685000','2268074567','DEBET');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='18685000',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260702-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260702-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260702-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260702-0004';
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-260702-0005','sales','1',' ','TOKO','BTGLMT','MTGL-YDCX-109-0','GL SHANIA VAR 17CM KKT PER BLT SHB ','','2.170','1','100.00','4014500','0','0','0','4014500','0','0','0','4014500','2401','00024598','MTGL','222000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-07-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTGL-YDCX-109-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.170',berat_jual_asli=berat_jual_asli+'2.170',stock_jual='1',berat_akhir=berat_akhir-'2.170',berat_akhir_asli=berat_akhir_asli-'2.170',stock_akhir='0' WHERE tanggal='2026-07-02' AND kode_barang='MTGL-YDCX-109-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-260702-0005','2026-07-02','2.170','2026-07-02','11:17:14','PLG0019093','4014500','4014500','0','4014500','4014500','sales','2026-07-02 11:17:13','FJ-260702-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-07-02','FJ-260702-0005','2026-07-02','11:17:14','2401','4014500','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-260702-0005','D','2026-07-02','11:17:14','sales','PENJUALAN','FJ-260702-0005','268817348','4014500','272831848');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260702-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260702-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260702-0005';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-07-02 ','11:30:09');
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-260702-0006','sales','1',' EX ','TOKO','BTLTMD','MDLT-ZFAH-96-0','LT CAP PLT LM SHB ','','1.000','1','100.00','1115000','0','0','0','1115000','0','0','0','1115000','2106','00030507','MDLT','156500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-07-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDLT-ZFAH-96-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-07-02' AND kode_barang='MDLT-ZFAH-96-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTLTMD' 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-260702-0006','2026-07-02','1.000','2026-07-02','11:38:07','PLG0019094','1115000','1115000','0','1115000','0','sales','2026-07-02 11:38:06','FJ-260702-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-07-02','FJ-260702-0006','2026-07-02','11:38:07','2106','1115000','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-260702-0001','2026-07-02','2026-07-02 11:38:06','PENJUALAN : FJ-260702-0006','bni','BCA','1115000','1115000','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-260702-0003','D','2026-07-02','11:38:07','BCA','PENJUALAN','FJ-260702-0006','2268074567','1115000','2269189567','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bni','MUHDAR');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1115000' WHERE no_faktur_jual='FJ-260702-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-260702-0007','sales',' 1',' EX','TOKO','BTCNMT','MTCN-YHBH-165-0','CN COR DB SHB','','2.250','1','100.00','4162500','0','0','0','4162500','0','0','0','4162500','2106','00026079','MTCN','222000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-07-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-YHBH-165-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.250',berat_jual_asli=berat_jual_asli+'2.250',stock_jual='1',berat_akhir=berat_akhir-'2.250',berat_akhir_asli=berat_akhir_asli-'2.250',stock_akhir='0' WHERE tanggal='2026-07-02' AND kode_barang='MTCN-YHBH-165-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-260702-0007','2026-07-02','2.250','2026-07-02','11:38:07','PLG0019095','4162500','4162500','0','4162500','0','sales','2026-07-02 11:38:06','FJ-260702-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-07-02','FJ-260702-0007','2026-07-02','11:38:07','2106','4162500','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-260702-0002','2026-07-02','2026-07-02 11:38:06','PENJUALAN : FJ-260702-0007','bni','BCA','4162500','4162500','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-260702-0004','D','2026-07-02','11:38:07','BCA','PENJUALAN','FJ-260702-0007','2269189567','4162500','2273352067','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bni','MUHDAR');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='4162500' WHERE no_faktur_jual='FJ-260702-0007' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260702-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260702-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260702-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260702-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260702-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260702-0007';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-07-02 ','12:41:21');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-07-02 ','13:37:45');
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-00009617','X-00009617','KL MILANO KC 41CM KKT PER UBS','GR','---','MTKL','BELI','BELI001','6349000','2026-07-02','3.900','1','sales','2026-07-02 13:50:57');
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-00009617','X-00009617');
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-260702-0001','FJ-250210-0003','2106','1','BELI','BELI001','MTKL', 'X-00009617', 'KL MILANO KC 41CM KKT PER UBS','4.000','3.900','100.00','4540000','6349000','1627949','1','6349000','6349000','MULUS');
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-07-02','BELI','BELI001','MTKL','MTKL','100.00','3.900','3.900','1','3.900','3.900','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-260702-0001','2026-07-02','2026-07-02','13:50:55','2106','---','3.900','6349000','6349000','6349000','6349000','6349000','sales','2026-07-02 13:50:57','FB-260702-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260702-0001','H RUS','DKH BLK BNTNG SKLH 4/48','','SBY','','sales','2026-07-02 13:50:57');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-02' 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-260702-0006','K','2026-07-02','13:50:55','sales','PEMBELIAN UMUM','FB-260702-0001','272831848','6349000','266482848','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260702-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260702-0001';
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-260702-0007','K','2026-07-02','13:54:19','cashier1','PENGELUARAN','IURAN PONTEN JULI 2026','266482848','200000','266282848');
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-260702-0008','sales','1',' EX ','TOKO','BTATMT','MTAT-ZDAG-30-0','AT CAP KWT BTR BLB BT SHB ','','2.240','1','100.00','4144000','0','0','0','4144000','0','0','0','4144000','2105','00029190','MTAT','222000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-07-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTAT-ZDAG-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.240',berat_jual_asli=berat_jual_asli+'2.240',stock_jual='1',berat_akhir=berat_akhir-'2.240',berat_akhir_asli=berat_akhir_asli-'2.240',stock_akhir='0' WHERE tanggal='2026-07-02' AND kode_barang='MTAT-ZDAG-30-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-260702-0008','2026-07-02','2.240','2026-07-02','15:09:19','PLG0019096','4144000','4144000','0','4144000','4144000','sales','2026-07-02 15:09:18','FJ-260702-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-07-02','FJ-260702-0008','2026-07-02','15:09:19','2105','4144000','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-260702-0008','D','2026-07-02','15:09:19','sales','PENJUALAN','FJ-260702-0008','266282848','4144000','270426848');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260702-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260702-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260702-0008';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-07-02 ','15:23:12');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-07-02 ','16:18:36');