INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-10-17 ','08:19:39');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-17','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-16';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-16';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-16';
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='2025-10-16' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-16';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-16';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-16';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-16';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202509 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
UPDATE tt_barang_saldo SET tanggal= '2025-10-17' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-16' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-10-17';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-10-17 ','10:32:37');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDAT-YJAG-1-0','00026160','EX ','AT JEPSI POLOS MK ','','GR','---','MD','MDAT','TOKO','INPUT1','465500','2025-10-17','465500','0.470','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 10:54:20','0.460','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDAT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDAT','MDAT-YJAG-1-0','00026160');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDAT-YJAG-1-0','MDAT','TOKO','INPUT1','100.00','0.470','0.460','1','0.470','0.460','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDAT-YJAG-2-0','00026161','EX ','AT ITALY BT HT SHB ','','GR','---','MD','MDAT','TOKO','INPUT1','1317000','2025-10-17','1317000','1.330','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 10:55:55','1.320','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDAT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDAT','MDAT-YJAG-2-0','00026161');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDAT-YJAG-2-0','MDAT','TOKO','INPUT1','100.00','1.330','1.320','1','1.330','1.320','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDAT-YJAG-3-0','00026162','EX ','AT CAP KAWAT BTR BT SHB ','','GR','---','MD','MDAT','TOKO','INPUT1','1782000','2025-10-17','1782000','1.800','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 10:57:34','1.790','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDAT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDAT','MDAT-YJAG-3-0','00026162');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDAT-YJAG-3-0','MDAT','TOKO','INPUT1','100.00','1.800','1.790','1','1.800','1.790','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-4-0','00026163','EX ','CN COR BT MK ','','GR','---','MD','MDCN','TOKO','INPUT1','921000','2025-10-17','921000','0.930','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:01:48','0.920','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-4-0','00026163');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-4-0','MDCN','TOKO','INPUT1','100.00','0.930','0.920','1','0.930','0.920','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-5-0','00026164','EX ','CN COR BT MK ','','GR','---','MD','MDCN','TOKO','INPUT1','931000','2025-10-17','931000','0.940','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:02:38','0.930','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-5-0','00026164');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-5-0','MDCN','TOKO','INPUT1','100.00','0.940','0.930','1','0.940','0.930','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-6-0','00026165','EX ','CN COR BT MK ','','GR','---','MD','MDCN','TOKO','INPUT1','851500','2025-10-17','851500','0.860','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:03:49','0.850','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-6-0','00026165');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-6-0','MDCN','TOKO','INPUT1','100.00','0.860','0.850','1','0.860','0.850','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-7-0','00026166','EX ','CN COR BT MK ','','GR','---','MD','MDCN','TOKO','INPUT1','871500','2025-10-17','871500','0.880','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:04:52','0.870','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-7-0','00026166');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-7-0','MDCN','TOKO','INPUT1','100.00','0.880','0.870','1','0.880','0.870','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-8-0','00026167','EX ','CN COR BT MK ','','GR','---','MD','MDCN','TOKO','INPUT1','911000','2025-10-17','911000','0.920','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:05:33','0.910','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-8-0','00026167');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-8-0','MDCN','TOKO','INPUT1','100.00','0.920','0.910','1','0.920','0.910','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-9-0','00026168','EX ','CN COR BT MK ','','GR','---','MD','MDCN','TOKO','INPUT1','1435500','2025-10-17','1435500','1.450','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:06:40','1.440','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-9-0','00026168');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-9-0','MDCN','TOKO','INPUT1','100.00','1.450','1.440','1','1.450','1.440','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-10-0','00026169','EX ','CN COR BT MK ','','GR','---','MD','MDCN','TOKO','INPUT1','1406000','2025-10-17','1406000','1.420','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:07:29','1.410','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-10-0','00026169');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-10-0','MDCN','TOKO','INPUT1','100.00','1.420','1.410','1','1.420','1.410','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-11-0','00026170','EX ','CN COR BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','713000','2025-10-17','713000','0.720','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:09:21','0.710','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-11-0','00026170');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-11-0','MDCN','TOKO','INPUT1','100.00','0.720','0.710','1','0.720','0.710','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-12-0','00026171','EX ','CN COR BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','713000','2025-10-17','713000','0.720','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:09:40','0.710','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-12-0','00026171');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-12-0','MDCN','TOKO','INPUT1','100.00','0.720','0.710','1','0.720','0.710','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-13-0','00026172','EX ','CN COR BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','901000','2025-10-17','901000','0.910','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:10:48','0.900','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-13-0','00026172');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-13-0','MDCN','TOKO','INPUT1','100.00','0.910','0.900','1','0.910','0.900','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-14-0','00026173','EX ','CN COR BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','1228000','2025-10-17','1228000','1.240','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:11:38','1.230','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-14-0','00026173');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-14-0','MDCN','TOKO','INPUT1','100.00','1.240','1.230','1','1.240','1.230','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-15-0','00026174','EX ','CN COR BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','1386000','2025-10-17','1386000','1.400','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:12:10','1.390','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-15-0','00026174');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-15-0','MDCN','TOKO','INPUT1','100.00','1.400','1.390','1','1.400','1.390','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-16-0','00026175','EX ','CN COR BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','2218000','2025-10-17','2218000','2.240','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:13:39','2.230','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-16-0','00026175');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-16-0','MDCN','TOKO','INPUT1','100.00','2.240','2.230','1','2.240','2.230','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-17-0','00026176','EX ','CN COR BT UBS ','','GR','---','MD','MDCN','TOKO','INPUT1','2198000','2025-10-17','2198000','2.220','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:16:26','2.210','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-17-0','00026176');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-17-0','MDCN','TOKO','INPUT1','100.00','2.220','2.210','1','2.220','2.210','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-18-0','00026177','EX ','CN COR BT BTG ','','GR','---','MD','MDCN','TOKO','INPUT1','2198000','2025-10-17','2198000','2.220','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:17:05','2.210','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-18-0','00026177');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-18-0','MDCN','TOKO','INPUT1','100.00','2.220','2.210','1','2.220','2.210','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-19-0','00026178','EX ','CN COR BT CAT UBS ','','GR','---','MD','MDCN','TOKO','INPUT1','4811500','2025-10-17','4811500','4.860','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:18:09','4.850','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-19-0','00026178');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-19-0','MDCN','TOKO','INPUT1','100.00','4.860','4.850','1','4.860','4.850','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-20-0','00026179','EX ','CN PIPA SUSUN BT MK ','','GR','---','MD','MDCN','TOKO','INPUT1','2237500','2025-10-17','2237500','2.260','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:19:07','2.250','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-20-0','00026179');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-20-0','MDCN','TOKO','INPUT1','100.00','2.260','2.250','1','2.260','2.250','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-21-0','00026180','EX ','CN SESER MK ','','GR','---','MD','MDCN','TOKO','INPUT1','2980000','2025-10-17','2980000','3.010','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:20:39','3.000','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-21-0','00026180');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-21-0','MDCN','TOKO','INPUT1','100.00','3.010','3.000','1','3.010','3.000','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-22-0','00026181','EX ','CN PLINTIR SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','1723000','2025-10-17','1723000','1.740','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:21:51','1.730','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-22-0','00026181');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-22-0','MDCN','TOKO','INPUT1','100.00','1.740','1.730','1','1.740','1.730','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-23-0','00026182','EX ','CN PLINTIR SUSUN SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','1346500','2025-10-17','1346500','1.360','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:22:46','1.350','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-23-0','00026182');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-23-0','MDCN','TOKO','INPUT1','100.00','1.360','1.350','1','1.360','1.350','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-24-0','00026183','EX ','CN COR TEBU SEKERET SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','1445500','2025-10-17','1445500','1.460','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:23:47','1.450','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-24-0','00026183');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-24-0','MDCN','TOKO','INPUT1','100.00','1.460','1.450','1','1.460','1.450','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-25-0','00026184','EX ','CN COR SETENGAH RT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','1346500','2025-10-17','1346500','1.360','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:24:52','1.350','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-25-0','00026184');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-25-0','MDCN','TOKO','INPUT1','100.00','1.360','1.350','1','1.360','1.350','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-26-0','00026185','EX ','CN COR SETENGAH RT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','1356500','2025-10-17','1356500','1.370','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:25:11','1.360','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-26-0','00026185');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-26-0','MDCN','TOKO','INPUT1','100.00','1.370','1.360','1','1.370','1.360','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-27-0','00026186','EX ','CN COR TDK BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','792000','2025-10-17','792000','0.800','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:27:32','0.790','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-27-0','00026186');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-27-0','MDCN','TOKO','INPUT1','100.00','0.800','0.790','1','0.800','0.790','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-28-0','00026187','EX ','CN COR TDK BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','1396000','2025-10-17','1396000','1.410','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:28:06','1.400','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-28-0','00026187');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-28-0','MDCN','TOKO','INPUT1','100.00','1.410','1.400','1','1.410','1.400','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-29-0','00026188','EX ','CN COR TDK BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','1000000','2025-10-17','1000000','1.010','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:28:54','1.000','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-29-0','00026188');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-29-0','MDCN','TOKO','INPUT1','100.00','1.010','1.000','1','1.010','1.000','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-30-0','00026189','EX ','CN COR TDK BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','1168500','2025-10-17','1168500','1.180','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:30:01','1.170','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-30-0','00026189');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-30-0','MDCN','TOKO','INPUT1','100.00','1.180','1.170','1','1.180','1.170','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-31-0','00026190','EX ','CN COR TDK BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','1505000','2025-10-17','1505000','1.520','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:31:11','1.510','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-31-0','00026190');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-31-0','MDCN','TOKO','INPUT1','100.00','1.520','1.510','1','1.520','1.510','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-32-0','00026191','EX ','CN COR TDK BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','1990000','2025-10-17','1990000','2.010','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:32:26','2.000','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-32-0','00026191');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-32-0','MDCN','TOKO','INPUT1','100.00','2.010','2.000','1','2.010','2.000','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-33-0','00026192','EX ','CN COR TDK BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','2257500','2025-10-17','2257500','2.280','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:33:28','2.270','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-33-0','00026192');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-33-0','MDCN','TOKO','INPUT1','100.00','2.280','2.270','1','2.280','2.270','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-34-0','00026193','EX ','CN COR TDK BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','2336500','2025-10-17','2336500','2.360','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:34:31','2.350','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-34-0','00026193');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-34-0','MDCN','TOKO','INPUT1','100.00','2.360','2.350','1','2.360','2.350','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-35-0','00026194','EX ','CN COR TDK BT LC2 ','','GR','---','MD','MDCN','TOKO','INPUT1','2356500','2025-10-17','2356500','2.380','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:35:26','2.370','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-35-0','00026194');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-35-0','MDCN','TOKO','INPUT1','100.00','2.380','2.370','1','2.380','2.370','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-36-0','00026195','EX ','CN COR TDK BT LC2 ','','GR','---','MD','MDCN','TOKO','INPUT1','1693000','2025-10-17','1693000','1.710','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:37:04','1.700','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-36-0','00026195');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-36-0','MDCN','TOKO','INPUT1','100.00','1.710','1.700','1','1.710','1.700','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-37-0','00026196','EX ','CN COR TDK BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','2425500','2025-10-17','2425500','2.450','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:38:11','2.440','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-37-0','00026196');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-37-0','MDCN','TOKO','INPUT1','100.00','2.450','2.440','1','2.450','2.440','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-38-0','00026197','EX ','CN COR TDK BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','2198000','2025-10-17','2198000','2.220','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:38:46','2.210','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-38-0','00026197');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-38-0','MDCN','TOKO','INPUT1','100.00','2.220','2.210','1','2.220','2.210','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-39-0','00026198','EX ','CN COR TDK BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','2396000','2025-10-17','2396000','2.420','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:39:40','2.410','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-39-0','00026198');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-39-0','MDCN','TOKO','INPUT1','100.00','2.420','2.410','1','2.420','2.410','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-YJAG-40-0','00026199','EX ','CN COR TDK BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','2574000','2025-10-17','2574000','2.600','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:40:26','2.590','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-YJAG-40-0','00026199');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDCN-YJAG-40-0','MDCN','TOKO','INPUT1','100.00','2.600','2.590','1','2.600','2.590','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-YJAG-41-0','00026200','EX ','GL ANAK COR PSR LC2 ','','GR','---','MD','MDGL','TOKO','INPUT1','6692500','2025-10-17','6692500','6.760','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:56:33','6.750','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-YJAG-41-0','00026200');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDGL-YJAG-41-0','MDGL','TOKO','INPUT1','100.00','6.760','6.750','1','6.760','6.750','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-YJAG-42-0','00026201','EX ','GL PIPA BT SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','3831500','2025-10-17','3831500','3.870','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:57:35','3.860','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-YJAG-42-0','00026201');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDGL-YJAG-42-0','MDGL','TOKO','INPUT1','100.00','3.870','3.860','1','3.870','3.860','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-YJAG-43-0','00026202','EX ','GL PIPA BT UBS ','','GR','---','MD','MDGL','TOKO','INPUT1','3633500','2025-10-17','3633500','3.670','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:58:40','3.660','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-YJAG-43-0','00026202');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDGL-YJAG-43-0','MDGL','TOKO','INPUT1','100.00','3.670','3.660','1','3.670','3.660','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-YJAG-44-0','00026203','EX ','GL PIPA BT HWT ','','GR','---','MD','MDGL','TOKO','INPUT1','2940500','2025-10-17','2940500','2.970','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 11:59:18','2.960','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-YJAG-44-0','00026203');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDGL-YJAG-44-0','MDGL','TOKO','INPUT1','100.00','2.970','2.960','1','2.970','2.960','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-YJAG-45-0','00026204','EX ','GL ITALY ST SRT VAR BT 18CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','1822000','2025-10-17','1822000','1.840','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 12:01:13','1.830','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-YJAG-45-0','00026204');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDGL-YJAG-45-0','MDGL','TOKO','INPUT1','100.00','1.840','1.830','1','1.840','1.830','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-YJAG-46-0','00026205','EX ','GL ITALY ST SRT VAR BT 19CM KKT PER MK ','','GR','---','MD','MDGL','TOKO','INPUT1','2871000','2025-10-17','2871000','2.900','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 12:02:36','2.890','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-YJAG-46-0','00026205');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDGL-YJAG-46-0','MDGL','TOKO','INPUT1','100.00','2.900','2.890','1','2.900','2.890','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-YJAG-47-0','00026206','EX ','GL ITALY ST SRT BTR BL PSR BL SLP 19CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','2257500','2025-10-17','2257500','2.280','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 12:04:59','2.270','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-YJAG-47-0','00026206');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDGL-YJAG-47-0','MDGL','TOKO','INPUT1','100.00','2.280','2.270','1','2.280','2.270','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-YJAG-48-0','00026207','EX ','GL RANGKAIAN BTR 16CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','3217500','2025-10-17','3217500','3.250','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 12:06:44','3.240','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-YJAG-48-0','00026207');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDGL-YJAG-48-0','MDGL','TOKO','INPUT1','100.00','3.250','3.240','1','3.250','3.240','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-YJAG-49-0','00026208','EX ','GL RANGKAIAN 17CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','3574000','2025-10-17','3574000','3.610','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 12:07:47','3.600','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-YJAG-49-0','00026208');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDGL-YJAG-49-0','MDGL','TOKO','INPUT1','100.00','3.610','3.600','1','3.610','3.600','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-YJAG-50-0','00026209','EX ','GL FANCY VAR 17CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','2505000','2025-10-17','2505000','2.530','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 12:08:54','2.520','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-YJAG-50-0','00026209');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDGL-YJAG-50-0','MDGL','TOKO','INPUT1','100.00','2.530','2.520','1','2.530','2.520','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-YJAG-51-0','00026210','EX ','GL RANGKAIAN VAR MN 4 17CM KKT PER UBS ','','GR','---','MD','MDGL','TOKO','INPUT1','3891000','2025-10-17','3891000','3.930','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 12:10:23','3.920','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-YJAG-51-0','00026210');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDGL-YJAG-51-0','MDGL','TOKO','INPUT1','100.00','3.930','3.920','1','3.930','3.920','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-YJAG-52-0','00026211','EX ','GL RANGKAIAN VAR CAT BT MN 6 18CM KKT PER UBS ','','GR','---','MD','MDGL','TOKO','INPUT1','5643000','2025-10-17','5643000','5.700','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 12:11:46','5.690','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-YJAG-52-0','00026211');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDGL-YJAG-52-0','MDGL','TOKO','INPUT1','100.00','5.700','5.690','1','5.700','5.690','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-YJAG-53-0','00026212','EX ','GL CAP HOLO 17CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','2831500','2025-10-17','2831500','2.860','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 12:17:27','2.850','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-YJAG-53-0','00026212');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDGL-YJAG-53-0','MDGL','TOKO','INPUT1','100.00','2.860','2.850','1','2.860','2.850','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-YJAG-54-0','00026213','EX ','GL CAP HOLO 17CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','2812000','2025-10-17','2812000','2.840','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 12:17:54','2.830','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-YJAG-54-0','00026213');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDGL-YJAG-54-0','MDGL','TOKO','INPUT1','100.00','2.840','2.830','1','2.840','2.830','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-YJAG-55-0','00026214','EX ','GL CAP HOLO 16CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','4267000','2025-10-17','4267000','4.310','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 12:19:34','4.300','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-YJAG-55-0','00026214');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDGL-YJAG-55-0','MDGL','TOKO','INPUT1','100.00','4.310','4.300','1','4.310','4.300','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-YJAG-56-0','00026215','EX ','GL CAP HOLO 15CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','3346500','2025-10-17','3346500','3.380','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 12:20:44','3.370','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-YJAG-56-0','00026215');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDGL-YJAG-56-0','MDGL','TOKO','INPUT1','100.00','3.380','3.370','1','3.380','3.370','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-YJAG-57-0','00026216','EX ','GL CAP HOLO 16CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','5316500','2025-10-17','5316500','5.370','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 12:22:58','5.360','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-YJAG-57-0','00026216');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDGL-YJAG-57-0','MDGL','TOKO','INPUT1','100.00','5.370','5.360','1','5.370','5.360','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-YJAG-58-0','00026217','EX ','GL CAP HOLO 17CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','6296500','2025-10-17','6296500','6.360','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 12:24:43','6.350','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-YJAG-58-0','00026217');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDGL-YJAG-58-0','MDGL','TOKO','INPUT1','100.00','6.360','6.350','1','6.360','6.350','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-YJAG-59-0','00026218','EX ','GL CAP HOLO 16CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','5445000','2025-10-17','5445000','5.500','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 12:27:11','5.490','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-YJAG-59-0','00026218');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDGL-YJAG-59-0','MDGL','TOKO','INPUT1','100.00','5.500','5.490','1','5.500','5.490','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-YJAG-60-0','00026219','EX ','GL CAP HOLO 16CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','4702500','2025-10-17','4702500','4.750','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 12:27:41','4.740','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-YJAG-60-0','00026219');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDGL-YJAG-60-0','MDGL','TOKO','INPUT1','100.00','4.750','4.740','1','4.750','4.740','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-YJAG-61-0','00026220','EX ','GL CAP HOLO 16CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','5098500','2025-10-17','5098500','5.150','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 12:28:21','5.140','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-YJAG-61-0','00026220');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDGL-YJAG-61-0','MDGL','TOKO','INPUT1','100.00','5.150','5.140','1','5.150','5.140','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-YJAG-62-0','00026221','EX ','GL CAP HOLO 17CM SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','10415000','2025-10-17','10415000','10.520','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 12:30:02','10.510','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-YJAG-62-0','00026221');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDGL-YJAG-62-0','MDGL','TOKO','INPUT1','100.00','10.520','10.510','1','10.520','10.510','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-YJAG-63-0','00026222','EX ','GL CAP HOLO 17CM SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','10623000','2025-10-17','10623000','10.730','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 12:31:20','10.720','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-YJAG-63-0','00026222');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDGL-YJAG-63-0','MDGL','TOKO','INPUT1','100.00','10.730','10.720','1','10.730','10.720','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-YJAG-64-0','00026223','EX ','GL CAP HOLO SISIK NAGA 19CM SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','12286000','2025-10-17','12286000','12.410','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 12:33:11','12.400','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-YJAG-64-0','00026223');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDGL-YJAG-64-0','MDGL','TOKO','INPUT1','100.00','12.410','12.400','1','12.410','12.400','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDKL-YJAG-65-0','00026224','EX ','KL ITALY ST VAR BT 42CM KKT PER MK ','','GR','---','MD','MDKL','TOKO','INPUT1','2970000','2025-10-17','2970000','3.000','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 12:37:02','2.990','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDKL','MDKL-YJAG-65-0','00026224');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDKL-YJAG-65-0','MDKL','TOKO','INPUT1','100.00','3.000','2.990','1','3.000','2.990','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDKL-YJAG-66-0','00026225','EX ','KL FANCY 42CM KKT PER SHB ','','GR','---','MD','MDKL','TOKO','INPUT1','2871000','2025-10-17','2871000','2.900','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 12:39:12','2.890','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDKL','MDKL-YJAG-66-0','00026225');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDKL-YJAG-66-0','MDKL','TOKO','INPUT1','100.00','2.900','2.890','1','2.900','2.890','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDKL-YJAG-67-0','00026226','EX ','KL FANCY VAR BT 40CM KKT PER BTG ','','GR','---','MD','MDKL','TOKO','INPUT1','1980000','2025-10-17','1980000','2.000','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 12:40:50','1.990','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDKL','MDKL-YJAG-67-0','00026226');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDKL-YJAG-67-0','MDKL','TOKO','INPUT1','100.00','2.000','1.990','1','2.000','1.990','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDKL-YJAG-68-0','00026227','EX ','KL FANCY DB 42CM KKT PER SHB ','','GR','---','MD','MDKL','TOKO','INPUT1','2425500','2025-10-17','2425500','2.450','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 12:41:50','2.440','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDKL','MDKL-YJAG-68-0','00026227');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDKL-YJAG-68-0','MDKL','TOKO','INPUT1','100.00','2.450','2.440','1','2.450','2.440','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDKL-YJAG-69-0','00026228','EX ','KL FANCY BL SLP 42CM KKT PER SHB ','','GR','---','MD','MDKL','TOKO','INPUT1','2475000','2025-10-17','2475000','2.500','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 12:42:41','2.490','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDKL','MDKL-YJAG-69-0','00026228');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDKL-YJAG-69-0','MDKL','TOKO','INPUT1','100.00','2.500','2.490','1','2.500','2.490','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDKL-YJAG-70-0','00026229','EX ','KL FANCY DB 42CM KKT PER SHB ','','GR','---','MD','MDKL','TOKO','INPUT1','2841500','2025-10-17','2841500','2.870','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 12:44:04','2.860','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDKL','MDKL-YJAG-70-0','00026229');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDKL-YJAG-70-0','MDKL','TOKO','INPUT1','100.00','2.870','2.860','1','2.870','2.860','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDLT-YJAG-71-0','00026230','EX ','LT COR KASANDRA UBS ','','GR','---','MD','MDLT','TOKO','INPUT1','396000','2025-10-17','396000','0.400','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 12:45:53','0.390','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDLT','MDLT-YJAG-71-0','00026230');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDLT-YJAG-71-0','MDLT','TOKO','INPUT1','100.00','0.400','0.390','1','0.400','0.390','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDLT-YJAG-72-0','00026231','EX ','LT COR KASANDRA UBS ','','GR','---','MD','MDLT','TOKO','INPUT1','643500','2025-10-17','643500','0.650','100.00','8','0','990000.00','1','0.045', 'adminpusat','2025-10-17 12:46:48','0.640','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDLT','MDLT-YJAG-72-0','00026231');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-17','MDLT-YJAG-72-0','MDLT','TOKO','INPUT1','100.00','0.650','0.640','1','0.650','0.640','1');
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('MDLT-YJAG-71-0','00026230','00026230','LT COR KASANDRA UBS ','LT COR FORT BG','','','396000','396000',' 0','0','adminpusat','2025-10-17 12:48:02');
UPDATE tm_barang SET nama_barang='LT COR FORT BG' ,nama_atribut='' ,kode_intern='EX ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MDLT-YJAG-71-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2025-10-17 ','14:55:46');
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='484500',harga_beli ='484500' WHERE kode_barcode='00026160' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='1370000',harga_beli ='1370000' WHERE kode_barcode='00026161' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='1854000',harga_beli ='1854000' WHERE kode_barcode='00026162' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='958000',harga_beli ='958000' WHERE kode_barcode='00026163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='968500',harga_beli ='968500' WHERE kode_barcode='00026164' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='886000',harga_beli ='886000' WHERE kode_barcode='00026165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='906500',harga_beli ='906500' WHERE kode_barcode='00026166' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='948000',harga_beli ='948000' WHERE kode_barcode='00026167' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='1493500',harga_beli ='1493500' WHERE kode_barcode='00026168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='1463000',harga_beli ='1463000' WHERE kode_barcode='00026169' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='742000',harga_beli ='742000' WHERE kode_barcode='00026170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='742000',harga_beli ='742000' WHERE kode_barcode='00026171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='937500',harga_beli ='937500' WHERE kode_barcode='00026172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='1277500',harga_beli ='1277500' WHERE kode_barcode='00026173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='1442000',harga_beli ='1442000' WHERE kode_barcode='00026174' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='2307500',harga_beli ='2307500' WHERE kode_barcode='00026175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='2287000',harga_beli ='2287000' WHERE kode_barcode='00026176' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='2287000',harga_beli ='2287000' WHERE kode_barcode='00026177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='5006000',harga_beli ='5006000' WHERE kode_barcode='00026178' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='2328000',harga_beli ='2328000' WHERE kode_barcode='00026179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='3100500',harga_beli ='3100500' WHERE kode_barcode='00026180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='1792500',harga_beli ='1792500' WHERE kode_barcode='00026181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='1401000',harga_beli ='1401000' WHERE kode_barcode='00026182' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='1504000',harga_beli ='1504000' WHERE kode_barcode='00026183' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='1401000',harga_beli ='1401000' WHERE kode_barcode='00026184' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='1411500',harga_beli ='1411500' WHERE kode_barcode='00026185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='824000',harga_beli ='824000' WHERE kode_barcode='00026186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='1452500',harga_beli ='1452500' WHERE kode_barcode='00026187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='1040500',harga_beli ='1040500' WHERE kode_barcode='00026188' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='1215500',harga_beli ='1215500' WHERE kode_barcode='00026189' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='1566000',harga_beli ='1566000' WHERE kode_barcode='00026190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='2070500',harga_beli ='2070500' WHERE kode_barcode='00026191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='2348500',harga_beli ='2348500' WHERE kode_barcode='00026192' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='2431000',harga_beli ='2431000' WHERE kode_barcode='00026193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='2451500',harga_beli ='2451500' WHERE kode_barcode='00026194' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='1761500',harga_beli ='1761500' WHERE kode_barcode='00026195' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='2523500',harga_beli ='2523500' WHERE kode_barcode='00026196' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='2287000',harga_beli ='2287000' WHERE kode_barcode='00026197' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='2493000',harga_beli ='2493000' WHERE kode_barcode='00026198' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='2678000',harga_beli ='2678000' WHERE kode_barcode='00026199' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='6963000',harga_beli ='6963000' WHERE kode_barcode='00026200' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='3986500',harga_beli ='3986500' WHERE kode_barcode='00026201' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='3780500',harga_beli ='3780500' WHERE kode_barcode='00026202' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='3059500',harga_beli ='3059500' WHERE kode_barcode='00026203' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='1895500',harga_beli ='1895500' WHERE kode_barcode='00026204' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='2987000',harga_beli ='2987000' WHERE kode_barcode='00026205' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='2348500',harga_beli ='2348500' WHERE kode_barcode='00026206' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='3347500',harga_beli ='3347500' WHERE kode_barcode='00026207' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='3718500',harga_beli ='3718500' WHERE kode_barcode='00026208' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='2606000',harga_beli ='2606000' WHERE kode_barcode='00026209' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='4048000',harga_beli ='4048000' WHERE kode_barcode='00026210' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='5871000',harga_beli ='5871000' WHERE kode_barcode='00026211' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='2946000',harga_beli ='2946000' WHERE kode_barcode='00026212' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='2925500',harga_beli ='2925500' WHERE kode_barcode='00026213' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='4439500',harga_beli ='4439500' WHERE kode_barcode='00026214' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='3481500',harga_beli ='3481500' WHERE kode_barcode='00026215' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='5531500',harga_beli ='5531500' WHERE kode_barcode='00026216' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='6551000',harga_beli ='6551000' WHERE kode_barcode='00026217' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='5665000',harga_beli ='5665000' WHERE kode_barcode='00026218' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='4892500',harga_beli ='4892500' WHERE kode_barcode='00026219' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='5304500',harga_beli ='5304500' WHERE kode_barcode='00026220' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='10836000',harga_beli ='10836000' WHERE kode_barcode='00026221' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='11052000',harga_beli ='11052000' WHERE kode_barcode='00026222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='12782500',harga_beli ='12782500' WHERE kode_barcode='00026223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='3090000',harga_beli ='3090000' WHERE kode_barcode='00026224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='2987000',harga_beli ='2987000' WHERE kode_barcode='00026225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='2060000',harga_beli ='2060000' WHERE kode_barcode='00026226' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='2523500',harga_beli ='2523500' WHERE kode_barcode='00026227' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='2575000',harga_beli ='2575000' WHERE kode_barcode='00026228' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='2956500',harga_beli ='2956500' WHERE kode_barcode='00026229' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='412000',harga_beli ='412000' WHERE kode_barcode='00026230' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1030000',harga_jual='669500',harga_beli ='669500' WHERE kode_barcode='00026231' LIMIT 1;
UPDATE tm_group SET harga='1030000' WHERE kode_group = 'MD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('MD','1030000','admin','2025-10-17 14:57:23');
UPDATE tm_group SET harga='1030000' WHERE kode_group = 'MS' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('MS','1030000','admin','2025-10-17 14:57:36');
UPDATE tm_group SET harga='1770000' WHERE kode_group = 'MT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('MT','1770000','admin','2025-10-17 14:57:49');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0001','1','MDAT-YJAG-1-0','1','0.470','0.470','TOKO','INPUT1','TOKO','BATMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BATMD' WHERE kode_barang='MDAT-YJAG-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BATMD','MDAT','MDAT-YJAG-1-0','100.00','1','0.470','0.460','1','0.470','0.460');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.470',berat_out_asli=berat_out_asli+'0.460',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDAT-YJAG-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0001','2','MDAT-YJAG-2-0','1','1.330','1.330','TOKO','INPUT1','TOKO','BATMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BATMD' WHERE kode_barang='MDAT-YJAG-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BATMD','MDAT','MDAT-YJAG-2-0','100.00','1','1.330','1.320','1','1.330','1.320');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.330',berat_out_asli=berat_out_asli+'1.320',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDAT-YJAG-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0001','3','MDAT-YJAG-3-0','1','1.800','1.800','TOKO','INPUT1','TOKO','BATMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BATMD' WHERE kode_barang='MDAT-YJAG-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BATMD','MDAT','MDAT-YJAG-3-0','100.00','1','1.800','1.790','1','1.800','1.790');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.800',berat_out_asli=berat_out_asli+'1.790',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDAT-YJAG-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251017-0001','2025-10-17','2025-10-17','15:39','3.6','adminpusat','2025-10-17 15:40:23');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','1','MDCN-YJAG-4-0','1','0.930','0.930','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-4-0','100.00','1','0.930','0.920','1','0.930','0.920');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.930',berat_out_asli=berat_out_asli+'0.920',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','2','MDCN-YJAG-5-0','1','0.940','0.940','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-5-0','100.00','1','0.940','0.930','1','0.940','0.930');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.940',berat_out_asli=berat_out_asli+'0.930',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','3','MDCN-YJAG-6-0','1','0.860','0.860','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-6-0','100.00','1','0.860','0.850','1','0.860','0.850');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.860',berat_out_asli=berat_out_asli+'0.850',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','4','MDCN-YJAG-7-0','1','0.880','0.880','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-7-0','100.00','1','0.880','0.870','1','0.880','0.870');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.880',berat_out_asli=berat_out_asli+'0.870',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','5','MDCN-YJAG-8-0','1','0.920','0.920','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-8-0','100.00','1','0.920','0.910','1','0.920','0.910');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.920',berat_out_asli=berat_out_asli+'0.910',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','6','MDCN-YJAG-9-0','1','1.450','1.450','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-9-0','100.00','1','1.450','1.440','1','1.450','1.440');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.450',berat_out_asli=berat_out_asli+'1.440',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','7','MDCN-YJAG-10-0','1','1.420','1.420','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-10-0','100.00','1','1.420','1.410','1','1.420','1.410');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.420',berat_out_asli=berat_out_asli+'1.410',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','8','MDCN-YJAG-11-0','1','0.720','0.720','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-11-0','100.00','1','0.720','0.710','1','0.720','0.710');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.720',berat_out_asli=berat_out_asli+'0.710',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','9','MDCN-YJAG-12-0','1','0.720','0.720','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-12-0','100.00','1','0.720','0.710','1','0.720','0.710');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.720',berat_out_asli=berat_out_asli+'0.710',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','10','MDCN-YJAG-13-0','1','0.910','0.910','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-13-0','100.00','1','0.910','0.900','1','0.910','0.900');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.910',berat_out_asli=berat_out_asli+'0.900',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','11','MDCN-YJAG-14-0','1','1.240','1.240','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-14-0','100.00','1','1.240','1.230','1','1.240','1.230');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.240',berat_out_asli=berat_out_asli+'1.230',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','12','MDCN-YJAG-15-0','1','1.400','1.400','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-15-0','100.00','1','1.400','1.390','1','1.400','1.390');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.400',berat_out_asli=berat_out_asli+'1.390',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','13','MDCN-YJAG-16-0','1','2.240','2.240','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-16-0','100.00','1','2.240','2.230','1','2.240','2.230');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.240',berat_out_asli=berat_out_asli+'2.230',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','14','MDCN-YJAG-17-0','1','2.220','2.220','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-17-0','100.00','1','2.220','2.210','1','2.220','2.210');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.220',berat_out_asli=berat_out_asli+'2.210',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','15','MDCN-YJAG-18-0','1','2.220','2.220','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-18-0','100.00','1','2.220','2.210','1','2.220','2.210');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.220',berat_out_asli=berat_out_asli+'2.210',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','16','MDCN-YJAG-19-0','1','4.860','4.860','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-19-0','100.00','1','4.860','4.850','1','4.860','4.850');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.860',berat_out_asli=berat_out_asli+'4.850',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','17','MDCN-YJAG-20-0','1','2.260','2.260','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-20-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-20-0','100.00','1','2.260','2.250','1','2.260','2.250');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.260',berat_out_asli=berat_out_asli+'2.250',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-20-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','18','MDCN-YJAG-21-0','1','3.010','3.010','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-21-0','100.00','1','3.010','3.000','1','3.010','3.000');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.010',berat_out_asli=berat_out_asli+'3.000',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','19','MDCN-YJAG-22-0','1','1.740','1.740','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-22-0','100.00','1','1.740','1.730','1','1.740','1.730');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.740',berat_out_asli=berat_out_asli+'1.730',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','20','MDCN-YJAG-23-0','1','1.360','1.360','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-23-0','100.00','1','1.360','1.350','1','1.360','1.350');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.360',berat_out_asli=berat_out_asli+'1.350',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','21','MDCN-YJAG-24-0','1','1.460','1.460','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-24-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-24-0','100.00','1','1.460','1.450','1','1.460','1.450');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.460',berat_out_asli=berat_out_asli+'1.450',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-24-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','22','MDCN-YJAG-25-0','1','1.360','1.360','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-25-0','100.00','1','1.360','1.350','1','1.360','1.350');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.360',berat_out_asli=berat_out_asli+'1.350',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','23','MDCN-YJAG-26-0','1','1.370','1.370','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-26-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-26-0','100.00','1','1.370','1.360','1','1.370','1.360');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.370',berat_out_asli=berat_out_asli+'1.360',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-26-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','24','MDCN-YJAG-27-0','1','0.800','0.800','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-27-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-27-0','100.00','1','0.800','0.790','1','0.800','0.790');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.800',berat_out_asli=berat_out_asli+'0.790',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-27-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','25','MDCN-YJAG-28-0','1','1.410','1.410','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-28-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-28-0','100.00','1','1.410','1.400','1','1.410','1.400');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.410',berat_out_asli=berat_out_asli+'1.400',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-28-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','26','MDCN-YJAG-29-0','1','1.010','1.010','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-29-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-29-0','100.00','1','1.010','1.000','1','1.010','1.000');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.010',berat_out_asli=berat_out_asli+'1.000',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-29-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','27','MDCN-YJAG-30-0','1','1.180','1.180','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-30-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-30-0','100.00','1','1.180','1.170','1','1.180','1.170');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.180',berat_out_asli=berat_out_asli+'1.170',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-30-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','28','MDCN-YJAG-31-0','1','1.520','1.520','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-31-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-31-0','100.00','1','1.520','1.510','1','1.520','1.510');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.520',berat_out_asli=berat_out_asli+'1.510',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-31-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','29','MDCN-YJAG-32-0','1','2.010','2.010','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-32-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-32-0','100.00','1','2.010','2.000','1','2.010','2.000');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.010',berat_out_asli=berat_out_asli+'2.000',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-32-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','30','MDCN-YJAG-33-0','1','2.280','2.280','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-33-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-33-0','100.00','1','2.280','2.270','1','2.280','2.270');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.280',berat_out_asli=berat_out_asli+'2.270',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-33-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','31','MDCN-YJAG-34-0','1','2.360','2.360','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-34-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-34-0','100.00','1','2.360','2.350','1','2.360','2.350');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.360',berat_out_asli=berat_out_asli+'2.350',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-34-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','32','MDCN-YJAG-35-0','1','2.380','2.380','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-35-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-35-0','100.00','1','2.380','2.370','1','2.380','2.370');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.380',berat_out_asli=berat_out_asli+'2.370',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-35-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','33','MDCN-YJAG-36-0','1','1.710','1.710','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-36-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-36-0','100.00','1','1.710','1.700','1','1.710','1.700');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.710',berat_out_asli=berat_out_asli+'1.700',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-36-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','34','MDCN-YJAG-37-0','1','2.450','2.450','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-37-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-37-0','100.00','1','2.450','2.440','1','2.450','2.440');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.450',berat_out_asli=berat_out_asli+'2.440',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-37-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','35','MDCN-YJAG-38-0','1','2.220','2.220','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-38-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-38-0','100.00','1','2.220','2.210','1','2.220','2.210');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.220',berat_out_asli=berat_out_asli+'2.210',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-38-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','36','MDCN-YJAG-39-0','1','2.420','2.420','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-39-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-39-0','100.00','1','2.420','2.410','1','2.420','2.410');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.420',berat_out_asli=berat_out_asli+'2.410',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-39-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0002','37','MDCN-YJAG-40-0','1','2.600','2.600','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YJAG-40-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BCNMD','MDCN','MDCN-YJAG-40-0','100.00','1','2.600','2.590','1','2.600','2.590');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.600',berat_out_asli=berat_out_asli+'2.590',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDCN-YJAG-40-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251017-0002','2025-10-17','2025-10-17','15:40','62.84','adminpusat','2025-10-17 15:43:32');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0003','1','MDGL-YJAG-41-0','1','6.760','6.760','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YJAG-41-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BGLMD','MDGL','MDGL-YJAG-41-0','100.00','1','6.760','6.750','1','6.760','6.750');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'6.760',berat_out_asli=berat_out_asli+'6.750',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDGL-YJAG-41-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0003','2','MDGL-YJAG-42-0','1','3.870','3.870','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YJAG-42-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BGLMD','MDGL','MDGL-YJAG-42-0','100.00','1','3.870','3.860','1','3.870','3.860');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.870',berat_out_asli=berat_out_asli+'3.860',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDGL-YJAG-42-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0003','3','MDGL-YJAG-43-0','1','3.670','3.670','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YJAG-43-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BGLMD','MDGL','MDGL-YJAG-43-0','100.00','1','3.670','3.660','1','3.670','3.660');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.670',berat_out_asli=berat_out_asli+'3.660',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDGL-YJAG-43-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0003','4','MDGL-YJAG-44-0','1','2.970','2.970','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YJAG-44-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BGLMD','MDGL','MDGL-YJAG-44-0','100.00','1','2.970','2.960','1','2.970','2.960');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.970',berat_out_asli=berat_out_asli+'2.960',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDGL-YJAG-44-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0003','5','MDGL-YJAG-45-0','1','1.840','1.840','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YJAG-45-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BGLMD','MDGL','MDGL-YJAG-45-0','100.00','1','1.840','1.830','1','1.840','1.830');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.840',berat_out_asli=berat_out_asli+'1.830',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDGL-YJAG-45-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0003','6','MDGL-YJAG-46-0','1','2.900','2.900','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YJAG-46-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BGLMD','MDGL','MDGL-YJAG-46-0','100.00','1','2.900','2.890','1','2.900','2.890');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.900',berat_out_asli=berat_out_asli+'2.890',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDGL-YJAG-46-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0003','7','MDGL-YJAG-47-0','1','2.280','2.280','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YJAG-47-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BGLMD','MDGL','MDGL-YJAG-47-0','100.00','1','2.280','2.270','1','2.280','2.270');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.280',berat_out_asli=berat_out_asli+'2.270',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDGL-YJAG-47-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0003','8','MDGL-YJAG-48-0','1','3.250','3.250','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YJAG-48-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BGLMD','MDGL','MDGL-YJAG-48-0','100.00','1','3.250','3.240','1','3.250','3.240');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.250',berat_out_asli=berat_out_asli+'3.240',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDGL-YJAG-48-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0003','9','MDGL-YJAG-49-0','1','3.610','3.610','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YJAG-49-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BGLMD','MDGL','MDGL-YJAG-49-0','100.00','1','3.610','3.600','1','3.610','3.600');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.610',berat_out_asli=berat_out_asli+'3.600',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDGL-YJAG-49-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0003','10','MDGL-YJAG-50-0','1','2.530','2.530','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YJAG-50-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BGLMD','MDGL','MDGL-YJAG-50-0','100.00','1','2.530','2.520','1','2.530','2.520');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.530',berat_out_asli=berat_out_asli+'2.520',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDGL-YJAG-50-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0003','11','MDGL-YJAG-51-0','1','3.930','3.930','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YJAG-51-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BGLMD','MDGL','MDGL-YJAG-51-0','100.00','1','3.930','3.920','1','3.930','3.920');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.930',berat_out_asli=berat_out_asli+'3.920',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDGL-YJAG-51-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0003','12','MDGL-YJAG-52-0','1','5.700','5.700','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YJAG-52-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BGLMD','MDGL','MDGL-YJAG-52-0','100.00','1','5.700','5.690','1','5.700','5.690');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.700',berat_out_asli=berat_out_asli+'5.690',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDGL-YJAG-52-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0003','13','MDGL-YJAG-53-0','1','2.860','2.860','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YJAG-53-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BGLMD','MDGL','MDGL-YJAG-53-0','100.00','1','2.860','2.850','1','2.860','2.850');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.860',berat_out_asli=berat_out_asli+'2.850',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDGL-YJAG-53-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0003','14','MDGL-YJAG-54-0','1','2.840','2.840','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YJAG-54-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BGLMD','MDGL','MDGL-YJAG-54-0','100.00','1','2.840','2.830','1','2.840','2.830');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.840',berat_out_asli=berat_out_asli+'2.830',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDGL-YJAG-54-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0003','15','MDGL-YJAG-55-0','1','4.310','4.310','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YJAG-55-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BGLMD','MDGL','MDGL-YJAG-55-0','100.00','1','4.310','4.300','1','4.310','4.300');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.310',berat_out_asli=berat_out_asli+'4.300',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDGL-YJAG-55-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0003','16','MDGL-YJAG-56-0','1','3.380','3.380','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YJAG-56-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BGLMD','MDGL','MDGL-YJAG-56-0','100.00','1','3.380','3.370','1','3.380','3.370');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.380',berat_out_asli=berat_out_asli+'3.370',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDGL-YJAG-56-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0003','17','MDGL-YJAG-57-0','1','5.370','5.370','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YJAG-57-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BGLMD','MDGL','MDGL-YJAG-57-0','100.00','1','5.370','5.360','1','5.370','5.360');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.370',berat_out_asli=berat_out_asli+'5.360',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDGL-YJAG-57-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0003','18','MDGL-YJAG-58-0','1','6.360','6.360','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YJAG-58-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BGLMD','MDGL','MDGL-YJAG-58-0','100.00','1','6.360','6.350','1','6.360','6.350');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'6.360',berat_out_asli=berat_out_asli+'6.350',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDGL-YJAG-58-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0003','19','MDGL-YJAG-59-0','1','5.500','5.500','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YJAG-59-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BGLMD','MDGL','MDGL-YJAG-59-0','100.00','1','5.500','5.490','1','5.500','5.490');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.500',berat_out_asli=berat_out_asli+'5.490',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDGL-YJAG-59-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0003','20','MDGL-YJAG-60-0','1','4.750','4.750','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YJAG-60-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BGLMD','MDGL','MDGL-YJAG-60-0','100.00','1','4.750','4.740','1','4.750','4.740');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.750',berat_out_asli=berat_out_asli+'4.740',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDGL-YJAG-60-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0003','21','MDGL-YJAG-61-0','1','5.150','5.150','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YJAG-61-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BGLMD','MDGL','MDGL-YJAG-61-0','100.00','1','5.150','5.140','1','5.150','5.140');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.150',berat_out_asli=berat_out_asli+'5.140',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDGL-YJAG-61-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0003','22','MDGL-YJAG-62-0','1','10.520','10.520','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YJAG-62-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BGLMD','MDGL','MDGL-YJAG-62-0','100.00','1','10.520','10.510','1','10.520','10.510');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'10.520',berat_out_asli=berat_out_asli+'10.510',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDGL-YJAG-62-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0003','23','MDGL-YJAG-63-0','1','10.730','10.730','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YJAG-63-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BGLMD','MDGL','MDGL-YJAG-63-0','100.00','1','10.730','10.720','1','10.730','10.720');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'10.730',berat_out_asli=berat_out_asli+'10.720',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDGL-YJAG-63-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0003','24','MDGL-YJAG-64-0','1','12.410','12.410','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YJAG-64-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BGLMD','MDGL','MDGL-YJAG-64-0','100.00','1','12.410','12.400','1','12.410','12.400');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'12.410',berat_out_asli=berat_out_asli+'12.400',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDGL-YJAG-64-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251017-0003','2025-10-17','2025-10-17','15:43','117.49','adminpusat','2025-10-17 15:45:29');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0004','1','MDKL-YJAG-65-0','1','3.000','3.000','TOKO','INPUT1','TOKO','BKLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-YJAG-65-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BKLMD','MDKL','MDKL-YJAG-65-0','100.00','1','3.000','2.990','1','3.000','2.990');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.000',berat_out_asli=berat_out_asli+'2.990',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDKL-YJAG-65-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0004','2','MDKL-YJAG-66-0','1','2.900','2.900','TOKO','INPUT1','TOKO','BKLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-YJAG-66-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BKLMD','MDKL','MDKL-YJAG-66-0','100.00','1','2.900','2.890','1','2.900','2.890');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.900',berat_out_asli=berat_out_asli+'2.890',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDKL-YJAG-66-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0004','3','MDKL-YJAG-67-0','1','2.000','2.000','TOKO','INPUT1','TOKO','BKLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-YJAG-67-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BKLMD','MDKL','MDKL-YJAG-67-0','100.00','1','2.000','1.990','1','2.000','1.990');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.000',berat_out_asli=berat_out_asli+'1.990',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDKL-YJAG-67-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0004','4','MDKL-YJAG-68-0','1','2.450','2.450','TOKO','INPUT1','TOKO','BKLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-YJAG-68-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BKLMD','MDKL','MDKL-YJAG-68-0','100.00','1','2.450','2.440','1','2.450','2.440');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.450',berat_out_asli=berat_out_asli+'2.440',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDKL-YJAG-68-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0004','5','MDKL-YJAG-69-0','1','2.500','2.500','TOKO','INPUT1','TOKO','BKLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-YJAG-69-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BKLMD','MDKL','MDKL-YJAG-69-0','100.00','1','2.500','2.490','1','2.500','2.490');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.500',berat_out_asli=berat_out_asli+'2.490',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDKL-YJAG-69-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0004','6','MDKL-YJAG-70-0','1','2.870','2.870','TOKO','INPUT1','TOKO','BKLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-YJAG-70-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BKLMD','MDKL','MDKL-YJAG-70-0','100.00','1','2.870','2.860','1','2.870','2.860');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.870',berat_out_asli=berat_out_asli+'2.860',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDKL-YJAG-70-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251017-0004','2025-10-17','2025-10-17','15:45','15.72','adminpusat','2025-10-17 15:46:30');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0005','1','MDLT-YJAG-71-0','1','0.400','0.400','TOKO','INPUT1','TOKO','BLTMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BLTMD' WHERE kode_barang='MDLT-YJAG-71-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BLTMD','MDLT','MDLT-YJAG-71-0','100.00','1','0.400','0.390','1','0.400','0.390');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.400',berat_out_asli=berat_out_asli+'0.390',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDLT-YJAG-71-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251017-0005','2','MDLT-YJAG-72-0','1','0.650','0.650','TOKO','INPUT1','TOKO','BLTMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BLTMD' WHERE kode_barang='MDLT-YJAG-72-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-17','TOKO','BLTMD','MDLT','MDLT-YJAG-72-0','100.00','1','0.650','0.640','1','0.650','0.640');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.650',berat_out_asli=berat_out_asli+'0.640',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-17' AND kode_barang='MDLT-YJAG-72-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251017-0005','2025-10-17','2025-10-17','15:46','1.05','adminpusat','2025-10-17 15:47:07');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-10-17 ','15:52:59');