INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-29 ','08:24:56');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-09-29 ','08:36:33');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-09-29','121','0','-176100000','121','0','-176100000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-08-29';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-09-28';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-09-28';
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-09-28' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-09-28';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-09-28';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-09-28';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-09-28';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202608 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
UPDATE tt_barang_saldo SET tanggal= '2026-09-29' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-09-28' 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-260929-0001','D','2026-09-29','08:36:43','BCA','SALDO AWAL','SALDO AWAL','0','1359829582','1359829582');
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-260929-0001','D','2026-09-29','08:36:43','','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-09-29';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-09-29 ','08:37:00');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-29 ','08:37:59');
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-260929-0001','1','X-00009849','BELI','BELI001','CN COR LBG CAT LC2','1','2.180','2080500.00' ,'0.00','2080500','','2080500','2080500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-29 08:38:17' WHERE kode_barang='X-00009849' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009849' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009849' AND kode_lokasi_toko ='BELI001' LIMIT 1;
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=stock_akhir-'1', berat_akhir=berat_akhir-'2.180',berat_akhir_asli=berat_akhir_asli-'2.180' 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-260929-0001','2','X-00009850','BELI','BELI001','CN COR BT SHB','1','0.730','696500.00' ,'0.00','696500','','696500','4857500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-29 08:38:17' WHERE kode_barang='X-00009850' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009850' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009850' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.730',berat_hancur_asli=berat_hancur_asli+'0.730', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.730',berat_akhir_asli=berat_akhir_asli-'0.730' 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-260929-0001','3','X-00009851','BELI','BELI001','CN COR BT MK','1','0.680','649000.00' ,'0.00','649000','','649000','6203000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-29 08:38:17' WHERE kode_barang='X-00009851' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009851' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009851' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.680',berat_hancur_asli=berat_hancur_asli+'0.680', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.680',berat_akhir_asli=berat_akhir_asli-'0.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-260929-0001','4','X-00009852','BELI','BELI001','CN COR BT SHB','1','0.770','539000.00' ,'0.00','539000','','539000','7391000','RONGSOK');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-29 08:38:17' WHERE kode_barang='X-00009852' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009852' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009852' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.770',berat_hancur_asli=berat_hancur_asli+'0.770', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.770',berat_akhir_asli=berat_akhir_asli-'0.770' 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-260929-0001','adminpusat','2026-09-29','2026-09-29','08:38:18','3965000','7391000', 'adminpusat','2026-09-29 08:38:17');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-29 ','09:06:37');
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-260929-0002','1','X-00009853','BELI','BELI001','AT ITALY HT BT SHB','1','0.920','1489000.00' ,'0.00','1489000','','1489000','1489000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-29 09:06:56' WHERE kode_barang='X-00009853' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009853' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009853' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.920',berat_hancur_asli=berat_hancur_asli+'0.920', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.920',berat_akhir_asli=berat_akhir_asli-'0.920' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTAT' 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-260929-0002','2','X-00009854','BELI','BELI001','GW COR TDK BT LC2','1','0.630','601000.00' ,'0.00','601000','','601000','3579000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-29 09:06:56' WHERE kode_barang='X-00009854' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009854' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009854' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.630',berat_hancur_asli=berat_hancur_asli+'0.630', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.630',berat_akhir_asli=berat_akhir_asli-'0.630' 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-260929-0002','3','X-00009855','BELI','BELI001','CN COR FORTUNE LC2','1','3.310','3159000.00' ,'0.00','3159000','','3159000','7339000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-29 09:06:56' WHERE kode_barang='X-00009855' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009855' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009855' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'3.310',berat_hancur_asli=berat_hancur_asli+'3.310', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'3.310',berat_akhir_asli=berat_akhir_asli-'3.310' 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-260929-0002','4','X-00009856','BELI','BELI001','CN COR BT SHB','1','0.920','878000.00' ,'0.00','878000','','878000','11376000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-29 09:06:56' WHERE kode_barang='X-00009856' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009856' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009856' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.920',berat_hancur_asli=berat_hancur_asli+'0.920', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.920',berat_akhir_asli=berat_akhir_asli-'0.920' 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-260929-0002','5','X-00009857','BELI','BELI001','AT TINDIK TALI AIR SHB','1','0.420','679500.00' ,'0.00','679500','','679500','12933500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-29 09:06:56' WHERE kode_barang='X-00009857' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009857' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009857' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.420',berat_hancur_asli=berat_hancur_asli+'0.420', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTAT' 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-260929-0002','adminpusat','2026-09-29','2026-09-29','09:06:57','6806500','12933500', 'adminpusat','2026-09-29 09:06:56');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-29 ','09:25:47');
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-260929-0003','1','X-00009858','BELI','BELI001','CN COR TDK BT SHB','1','2.220','1554000.00' ,'0.00','1554000','','1554000','1554000','RONGSOK');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-29 09:26:02' WHERE kode_barang='X-00009858' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009858' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009858' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'2.220',berat_hancur_asli=berat_hancur_asli+'2.220', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'2.220',berat_akhir_asli=berat_akhir_asli-'2.220' 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-260929-0003','adminpusat','2026-09-29','2026-09-29','09:26:03','1554000','1554000', 'adminpusat','2026-09-29 09:26:02');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-09-29 ','09:38:04');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-29 ','10:13:34');
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-260929-0004','1','X-00009859','BELI','BELI001','CN COR BT SHB','1','0.930','1505500.00' ,'0.00','1505500','','1505500','1505500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-29 10:13:50' WHERE kode_barang='X-00009859' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009859' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009859' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.930',berat_hancur_asli=berat_hancur_asli+'0.930', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.930',berat_akhir_asli=berat_akhir_asli-'0.930' 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-260929-0004','2','X-00009860','BELI','BELI001','GL RANGKAIAN COR 17CM KKT PER LC2','1','4.080','3894000.00' ,'0.00','3894000','','3894000','6905000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-29 10:13:50' WHERE kode_barang='X-00009860' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009860' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009860' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'4.080',berat_hancur_asli=berat_hancur_asli+'4.080', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'4.080',berat_akhir_asli=berat_akhir_asli-'4.080' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDGL' 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-260929-0004','3','X-00009861','BELI','BELI001','KL ITALY ST ANAK 34CM KKT PER BLT SHB','1','2.540','2424000.00' ,'0.00','2424000','','2424000','13223000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-29 10:13:50' WHERE kode_barang='X-00009861' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009861' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009861' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'2.540',berat_hancur_asli=berat_hancur_asli+'2.540', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'2.540',berat_akhir_asli=berat_akhir_asli-'2.540' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MSKL' 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-260929-0004','4','X-00009862','BELI','BELI001','GL FANCY DB MN 12 17CM KKT PER UBS','1','7.260','6929500.00' ,'0.00','6929500','','6929500','22576500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-29 10:13:50' WHERE kode_barang='X-00009862' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009862' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009862' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'7.260',berat_hancur_asli=berat_hancur_asli+'7.260', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'7.260',berat_akhir_asli=berat_akhir_asli-'7.260' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDGL' 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-260929-0004','5','X-00009863','BELI','BELI001','KL FANCY RUMBAI 42CM KKT S SHB','1','6.570','10636500.00' ,'0.00','10636500','','10636500','40142500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-29 10:13:50' WHERE kode_barang='X-00009863' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009863' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009863' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'6.570',berat_hancur_asli=berat_hancur_asli+'6.570', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'6.570',berat_akhir_asli=berat_akhir_asli-'6.570' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTKL' 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-260929-0004','adminpusat','2026-09-29','2026-09-29','10:13:50','25389500','40142500', 'adminpusat','2026-09-29 10:13:50');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-09-29 ','10:20:02');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-09-29 ','10:35:50');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-09-29 ','10:41:25');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-09-29 ','10:52:20');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-09-29 ','10:57:43');
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-260929-0005','1','MTKL-ZAAX-24-0','TOKO','BTKLMT','KL FANCY ANAK DB 34CM KKT PER SHB ','1','2.920','RETUR BARANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-29 10:58:15',status_delete='2.910' WHERE kode_barang='MTKL-ZAAX-24-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZAAX-24-0';
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZAAX-24-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.920,berat_hancur_asli=berat_hancur_asli+2.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-ZAAX-24-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-260929-0005','2026-09-29','admin','2026-09-29','10:58:15','admin','2026-09-29 10:58:15');
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-00009864','X-00009864','AT TINDIK PLS SHB','GR','---','MDAT','BELI','BELI001','400500','2026-09-29','0.420','1','sales','2026-09-29 12:03:33');
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-00009864','X-00009864');
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-260929-0001','FJ-241221-0005','2106','1','BELI','BELI001','MDAT', 'X-00009864', 'AT TINDIK PLS SHB','0.470','0.420','100.00','309500','400500','953571','1','400500','400500','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-09-29','BELI','BELI001','MDAT','MDAT','100.00','0.420','0.420','1','0.420','0.420','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-260929-0001','2026-09-29','2026-09-29','12:03:33','2106','---','0.420','400500','400500','400500','400500','400500','sales','2026-09-29 12:03:33','FB-260929-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260929-0001','ANISA','SIDORAME 38A','','','','sales','2026-09-29 12:03:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-29' 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-260929-0002','K','2026-09-29','12:03:33','sales','PEMBELIAN UMUM','FB-260929-0001','74751786','400500','74351286','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260929-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260929-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-29 ','13:41:33');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-29 ','13:56:59');
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-260929-0001','sales','1',' EX ','TOKO','BTCNMT','MTCN-ZEAH-39-0','CN PLINTIR SHB ','','1.450','1','100.00','2668000','0','0','0','2668000','0','0','0','2668000','2502','00029615','MTCN','221000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-ZEAH-39-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.450',berat_jual_asli=berat_jual_asli+'1.450',stock_jual='1',berat_akhir=berat_akhir-'1.450',berat_akhir_asli=berat_akhir_asli-'1.450',stock_akhir='0' WHERE tanggal='2026-09-29' AND kode_barang='MTCN-ZEAH-39-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-260929-0001','2026-09-29','1.450','2026-09-29','14:03:14','PLG0019533','2668000','2668000','0','2668000','2668000','sales','2026-09-29 14:03:14','FJ-260929-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-09-29','FJ-260929-0001','2026-09-29','14:03:14','2502','2668000','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-260929-0003','D','2026-09-29','14:03:14','sales','PENJUALAN','FJ-260929-0001','74351286','2668000','77019286');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260929-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260929-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260929-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-260929-0004','K','2026-09-29','14:14:23','cashier1','PENGELUARAN','BELI KRESEK KECIL','77019286','12000','77007286');
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-260929-0002','sales','1',' ','TOKO','BTLTMD','MDLT-ZBAI-115-0','LT COR BOROBUDUR LC2 ','','10.060','1','100.00','11167000','0','0','0','11167000','0','0','0','11167000','2502','00028491','MDLT','155500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDLT-ZBAI-115-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'10.060',berat_jual_asli=berat_jual_asli+'10.060',stock_jual='1',berat_akhir=berat_akhir-'10.060',berat_akhir_asli=berat_akhir_asli-'10.060',stock_akhir='0' WHERE tanggal='2026-09-29' AND kode_barang='MDLT-ZBAI-115-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-260929-0002','2026-09-29','10.060','2026-09-29','14:42:51','PLG0019534','11167000','11167000','0','11167000','11167000','sales','2026-09-29 14:42:50','FJ-260929-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-09-29','FJ-260929-0002','2026-09-29','14:42:51','2502','11167000','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-260929-0005','D','2026-09-29','14:42:51','sales','PENJUALAN','FJ-260929-0002','77007286','11167000','88174286');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260929-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260929-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260929-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-00009865','X-00009865','AT ITALY HT BT SHB','GR','---','MTAT','BELI','BELI001','629000','2026-09-29','0.440','1','sales','2026-09-29 14:54:33');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTAT';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTAT','X-00009865','X-00009865');
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-260929-0002','FJ-250527-0003','2403','1','BELI','BELI001','MTAT', 'X-00009865', 'AT ITALY HT BT SHB','1.000','0.440','100.00','1315000','629000','1429545','1','629000','629000','RUSAK ADA HILANG');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.440',berat_beli_asli=berat_beli_asli+'0.440',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.440',berat_akhir_asli=berat_akhir_asli+'0.440',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-29' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTAT' 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-260929-0002','2026-09-29','2026-09-29','14:54:32','2403','---','0.440','629000','629000','629000','629000','629000','sales','2026-09-29 14:54:33','FB-260929-0002','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260929-0002','ROHIMA','BULAK BANTENG KENANGA 33','','','087852830210','sales','2026-09-29 14:54:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-29' 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-260929-0006','K','2026-09-29','14:54:32','sales','PEMBELIAN UMUM','FB-260929-0002','88174286','629000','87545286','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260929-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260929-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-00009866','X-00009866','KL ITALY ST BT 42CM KKT PER BLT SHB','GR','---','MTKL','BELI','BELI001','5294000','2026-09-29','3.270','1','sales','2026-09-29 15:01:56');
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-00009866','X-00009866');
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-260929-0003','FJ-250326-0018','2105','1','BELI','BELI001','MTKL', 'X-00009866', 'KL ITALY ST BT 42CM KKT PER BLT SHB','3.320','3.270','100.00','4100500','5294000','1618960','1','5294000','5294000','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.270',berat_beli_asli=berat_beli_asli+'3.270',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.270',berat_akhir_asli=berat_akhir_asli+'3.270',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-29' 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-260929-0003','2026-09-29','2026-09-29','15:01:56','2105','---','3.270','5294000','5294000','5294000','5294000','5294000','sales','2026-09-29 15:01:56','FB-260929-0003','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260929-0003','AMANAH','BANGKALAN MADURA','','','083857349382','sales','2026-09-29 15:01:56');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-29' 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-260929-0007','K','2026-09-29','15:01:56','sales','PEMBELIAN UMUM','FB-260929-0003','87545286','5294000','82251286','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-00009867','X-00009867','GL VANESSA VAR BTR HT BT 17CM KKT PER MK','GR','---','MTGL','BELI','BELI001','7835500','2026-09-29','4.840','1','sales','2026-09-29 15:01:56');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTGL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTGL','X-00009867','X-00009867');
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-260929-0004','FJ-250326-0019','2105','2','BELI','BELI001','MTGL', 'X-00009867', 'GL VANESSA VAR BTR HT BT 17CM KKT PER MK','4.890','4.840','100.00','6039500','7835500','1618905','1','7835500','7835500','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-09-29','BELI','BELI001','MTGL','MTGL','100.00','4.840','4.840','1','4.840','4.840','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-260929-0004','2026-09-29','2026-09-29','15:01:56','2105','---','4.840','7835500','7835500','7835500','7835500','7835500','sales','2026-09-29 15:01:56','FB-260929-0003','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260929-0004','AMANAH','BANGKALAN MADURA','','','083857349382','sales','2026-09-29 15:01:56');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-29' 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-260929-0008','K','2026-09-29','15:01:56','sales','PEMBELIAN UMUM','FB-260929-0004','82251286','7835500','74415786','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260929-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260929-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260929-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260929-0004';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-29 ','15:31:55');