INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-12-01 ','08:14:27');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-12-01','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-31';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-30';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-30';
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-11-30' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-30';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-30';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-30';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-30';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202510 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
UPDATE tt_barang_saldo SET tanggal= '2025-12-01' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-30' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-12-01';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-12-01 ','11:23:32');
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 ('MTCN-YLXA-1-0','00026876',' ','CN ANAK CAP PLAT BT BIRU SHB ','','GR','---','MT','MTCN','TOKO','INPUT1','818000','2025-12-01','818000','0.470','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 11:29:13','0.460','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-YLXA-1-0','00026876');
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-12-01','MTCN-YLXA-1-0','MTCN','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 ('MTCN-YLXA-2-0','00026877',' ','CN ANAK CAP PLAT TDK BT SHB ','','GR','---','MT','MTCN','TOKO','INPUT1','905000','2025-12-01','905000','0.520','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 11:30:17','0.510','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-YLXA-2-0','00026877');
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-12-01','MTCN-YLXA-2-0','MTCN','TOKO','INPUT1','100.00','0.520','0.510','1','0.520','0.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 ('MTCN-YLXA-3-0','00026878',' ','CN ANAK CAP PLAT TDK BT SHB ','','GR','---','MT','MTCN','TOKO','INPUT1','870000','2025-12-01','870000','0.500','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 11:30:51','0.490','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-YLXA-3-0','00026878');
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-12-01','MTCN-YLXA-3-0','MTCN','TOKO','INPUT1','100.00','0.500','0.490','1','0.500','0.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 ('MTCN-YLXA-4-0','00026879',' ','CN ANAK CAP PLAT TDK BT SHB ','','GR','---','MT','MTCN','TOKO','INPUT1','887500','2025-12-01','887500','0.510','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 11:31:27','0.500','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-YLXA-4-0','00026879');
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-12-01','MTCN-YLXA-4-0','MTCN','TOKO','INPUT1','100.00','0.510','0.500','1','0.510','0.500','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 ('MTCN-YLXA-5-0','00026880',' ','CN ANAK CAP NONA BT SHB ','','GR','---','MT','MTCN','TOKO','INPUT1','1044000','2025-12-01','1044000','0.600','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 11:32:19','0.590','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-YLXA-5-0','00026880');
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-12-01','MTCN-YLXA-5-0','MTCN','TOKO','INPUT1','100.00','0.600','0.590','1','0.600','0.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 ('MTGL-YLXA-6-0','00026881',' ','GL HL RT PLT TDK BT 15CM KKT S SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','2123000','2025-12-01','2123000','1.220','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 11:34:59','1.210','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-YLXA-6-0','00026881');
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-12-01','MTGL-YLXA-6-0','MTGL','TOKO','INPUT1','100.00','1.220','1.210','1','1.220','1.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 ('MTGL-YLXA-7-0','00026882',' ','GL HL RT PLT TDK BT 15CM KKT S SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','2123000','2025-12-01','2123000','1.220','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 11:35:37','1.210','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-YLXA-7-0','00026882');
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-12-01','MTGL-YLXA-7-0','MTGL','TOKO','INPUT1','100.00','1.220','1.210','1','1.220','1.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 ('MTGL-YLXA-8-0','00026883',' ','GL TALI MN LM SHB ','TL','GR','---','MT','MTGL','TOKO','INPUT1','1288000','2025-12-01','1288000','0.740','100.00','16','100000','1740000.00','1','0.045', 'adminpusat','2025-12-01 11:43:57','0.730','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-YLXA-8-0','00026883');
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-12-01','MTGL-YLXA-8-0','MTGL','TOKO','INPUT1','100.00','0.740','0.730','1','0.740','0.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 ('MTGL-YLXA-9-0','00026884','TL ','GL TALI MN LM SHB ','TL','GR','---','MT','MTGL','TOKO','INPUT1','1183500','2025-12-01','1183500','0.680','100.00','16','100000','1740000.00','1','0.045', 'adminpusat','2025-12-01 11:45:16','0.670','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-YLXA-9-0','00026884');
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-12-01','MTGL-YLXA-9-0','MTGL','TOKO','INPUT1','100.00','0.680','0.670','1','0.680','0.670','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 ('MTGL-YLXA-10-0','00026885','TL ','GL TALI MN LM SHB ','TL','GR','---','MT','MTGL','TOKO','INPUT1','1670500','2025-12-01','1670500','0.960','100.00','16','100000','1740000.00','1','0.045', 'adminpusat','2025-12-01 11:46:59','0.950','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-YLXA-10-0','00026885');
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-12-01','MTGL-YLXA-10-0','MTGL','TOKO','INPUT1','100.00','0.960','0.950','1','0.960','0.950','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 ('MTGL-YLXA-11-0','00026886','TL ','GL TALI MN KRW TAS SHB ','TL','GR','---','MT','MTGL','TOKO','INPUT1','1879500','2025-12-01','1879500','1.080','100.00','16','100000','1740000.00','1','0.045', 'adminpusat','2025-12-01 11:48:29','1.070','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-YLXA-11-0','00026886');
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-12-01','MTGL-YLXA-11-0','MTGL','TOKO','INPUT1','100.00','1.080','1.070','1','1.080','1.070','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 ('MTGW-YLXA-12-0','00026887',' ','GW COR BT SHB ','','GR','---','MT','MTGW','TOKO','INPUT1','1409500','2025-12-01','1409500','0.810','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 11:49:50','0.800','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGW' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGW','MTGW-YLXA-12-0','00026887');
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-12-01','MTGW-YLXA-12-0','MTGW','TOKO','INPUT1','100.00','0.810','0.800','1','0.810','0.800','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 ('MTGW-YLXA-13-0','00026888',' ','GW COR BT SHB ','','GR','---','MT','MTGW','TOKO','INPUT1','1409500','2025-12-01','1409500','0.810','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 11:50:06','0.800','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGW' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGW','MTGW-YLXA-13-0','00026888');
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-12-01','MTGW-YLXA-13-0','MTGW','TOKO','INPUT1','100.00','0.810','0.800','1','0.810','0.800','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 ('MTGW-YLXA-14-0','00026889',' ','GW CAP TDK BT SHB ','','GR','---','MT','MTGW','TOKO','INPUT1','922500','2025-12-01','922500','0.530','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 11:51:29','0.520','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGW' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGW','MTGW-YLXA-14-0','00026889');
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-12-01','MTGW-YLXA-14-0','MTGW','TOKO','INPUT1','100.00','0.530','0.520','1','0.530','0.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 ('MTGW-YLXA-15-0','00026890',' ','GW CAP TDK BT SHB ','','GR','---','MT','MTGW','TOKO','INPUT1','870000','2025-12-01','870000','0.500','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 11:51:48','0.490','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGW' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGW','MTGW-YLXA-15-0','00026890');
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-12-01','MTGW-YLXA-15-0','MTGW','TOKO','INPUT1','100.00','0.500','0.490','1','0.500','0.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 ('MTGW-YLXA-16-0','00026891',' ','GW CAP TDK BT SHB ','','GR','---','MT','MTGW','TOKO','INPUT1','887500','2025-12-01','887500','0.510','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 11:52:32','0.500','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGW' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGW','MTGW-YLXA-16-0','00026891');
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-12-01','MTGW-YLXA-16-0','MTGW','TOKO','INPUT1','100.00','0.510','0.500','1','0.510','0.500','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 ('MTGW-YLXA-17-0','00026892',' ','GW CAP TDK BT SHB ','','GR','---','MT','MTGW','TOKO','INPUT1','905000','2025-12-01','905000','0.520','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 11:52:49','0.510','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGW' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGW','MTGW-YLXA-17-0','00026892');
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-12-01','MTGW-YLXA-17-0','MTGW','TOKO','INPUT1','100.00','0.520','0.510','1','0.520','0.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 ('MTLT-YLXA-18-0','00026893',' ','LT CAP PLAT LM SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','1601000','2025-12-01','1601000','0.920','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 11:55:19','0.910','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-YLXA-18-0','00026893');
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-12-01','MTLT-YLXA-18-0','MTLT','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 ('MTLT-YLXA-19-0','00026894',' ','LT CAP PLAT LM SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','1653000','2025-12-01','1653000','0.950','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 11:55:37','0.940','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-YLXA-19-0','00026894');
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-12-01','MTLT-YLXA-19-0','MTLT','TOKO','INPUT1','100.00','0.950','0.940','1','0.950','0.940','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 ('MTLT-YLXA-20-0','00026895',' ','LT CAP PLAT LM SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','2558000','2025-12-01','2558000','1.470','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 11:58:04','1.460','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-YLXA-20-0','00026895');
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-12-01','MTLT-YLXA-20-0','MTLT','TOKO','INPUT1','100.00','1.470','1.460','1','1.470','1.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 ('MTLT-YLXA-21-0','00026896',' ','LT CAP PLAT LM SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','2540500','2025-12-01','2540500','1.460','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 11:58:24','1.450','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-YLXA-21-0','00026896');
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-12-01','MTLT-YLXA-21-0','MTLT','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 ('MTLT-YLXA-22-0','00026897',' ','LT CAP PLAT LM SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','3376000','2025-12-01','3376000','1.940','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 12:00:08','1.930','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-YLXA-22-0','00026897');
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-12-01','MTLT-YLXA-22-0','MTLT','TOKO','INPUT1','100.00','1.940','1.930','1','1.940','1.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 ('MTLT-YLXA-23-0','00026898',' ','LT CAP PLAT LM SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','3341000','2025-12-01','3341000','1.920','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 12:00:33','1.910','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-YLXA-23-0','00026898');
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-12-01','MTLT-YLXA-23-0','MTLT','TOKO','INPUT1','100.00','1.920','1.910','1','1.920','1.910','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 ('MTGL-YLXA-8-0','00026883','00026883','GL TALI MN LM SHB ','GL TALI MN LM SHB','TL','TL','1288000','1288000',' 100000','100000','adminpusat','2025-12-01 12:01:28');
UPDATE tm_barang SET nama_barang='GL TALI MN LM SHB' ,nama_atribut='TL' ,kode_intern=' TL', kadar_cetak='16.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MTGL-YLXA-8-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-12-01 ','12:06:40');
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-251201-0001','1','MTCN-YLXA-1-0','1','0.470','0.470','TOKO','INPUT1','TOKO','BKCNMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-YLXA-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-12-01','TOKO','BKCNMT','MTCN','MTCN-YLXA-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-12-01' AND kode_barang='MTCN-YLXA-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-251201-0001','2','MTCN-YLXA-2-0','1','0.520','0.520','TOKO','INPUT1','TOKO','BKCNMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-YLXA-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-12-01','TOKO','BKCNMT','MTCN','MTCN-YLXA-2-0','100.00','1','0.520','0.510','1','0.520','0.510');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.520',berat_out_asli=berat_out_asli+'0.510',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTCN-YLXA-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-251201-0001','3','MTCN-YLXA-3-0','1','0.500','0.500','TOKO','INPUT1','TOKO','BKCNMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-YLXA-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-12-01','TOKO','BKCNMT','MTCN','MTCN-YLXA-3-0','100.00','1','0.500','0.490','1','0.500','0.490');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.500',berat_out_asli=berat_out_asli+'0.490',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTCN-YLXA-3-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-251201-0001','4','MTCN-YLXA-4-0','1','0.510','0.510','TOKO','INPUT1','TOKO','BKCNMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-YLXA-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-12-01','TOKO','BKCNMT','MTCN','MTCN-YLXA-4-0','100.00','1','0.510','0.500','1','0.510','0.500');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.510',berat_out_asli=berat_out_asli+'0.500',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTCN-YLXA-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-251201-0001','5','MTCN-YLXA-5-0','1','0.600','0.600','TOKO','INPUT1','TOKO','BKCNMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-YLXA-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-12-01','TOKO','BKCNMT','MTCN','MTCN-YLXA-5-0','100.00','1','0.600','0.590','1','0.600','0.590');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.600',berat_out_asli=berat_out_asli+'0.590',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTCN-YLXA-5-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-251201-0001','2025-12-01','2025-12-01','12:16','2.6','adminpusat','2025-12-01 12:17: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-251201-0002','1','MTGL-YLXA-6-0','1','1.220','1.220','TOKO','INPUT1','TOKO','BKGLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-YLXA-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-12-01','TOKO','BKGLMT','MTGL','MTGL-YLXA-6-0','100.00','1','1.220','1.210','1','1.220','1.210');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.220',berat_out_asli=berat_out_asli+'1.210',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTGL-YLXA-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-251201-0002','2','MTGL-YLXA-7-0','1','1.220','1.220','TOKO','INPUT1','TOKO','BKGLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-YLXA-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-12-01','TOKO','BKGLMT','MTGL','MTGL-YLXA-7-0','100.00','1','1.220','1.210','1','1.220','1.210');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.220',berat_out_asli=berat_out_asli+'1.210',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTGL-YLXA-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-251201-0002','3','MTGL-YLXA-8-0','1','0.740','0.740','TOKO','INPUT1','TOKO','BKGLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-YLXA-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-12-01','TOKO','BKGLMT','MTGL','MTGL-YLXA-8-0','100.00','1','0.740','0.730','1','0.740','0.730');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.740',berat_out_asli=berat_out_asli+'0.730',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTGL-YLXA-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-251201-0002','4','MTGL-YLXA-9-0','1','0.680','0.680','TOKO','INPUT1','TOKO','BKGLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-YLXA-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-12-01','TOKO','BKGLMT','MTGL','MTGL-YLXA-9-0','100.00','1','0.680','0.670','1','0.680','0.670');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.680',berat_out_asli=berat_out_asli+'0.670',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTGL-YLXA-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-251201-0002','5','MTGL-YLXA-10-0','1','0.960','0.960','TOKO','INPUT1','TOKO','BKGLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-YLXA-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-12-01','TOKO','BKGLMT','MTGL','MTGL-YLXA-10-0','100.00','1','0.960','0.950','1','0.960','0.950');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.960',berat_out_asli=berat_out_asli+'0.950',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTGL-YLXA-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-251201-0002','6','MTGL-YLXA-11-0','1','1.080','1.080','TOKO','INPUT1','TOKO','BKGLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-YLXA-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-12-01','TOKO','BKGLMT','MTGL','MTGL-YLXA-11-0','100.00','1','1.080','1.070','1','1.080','1.070');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.080',berat_out_asli=berat_out_asli+'1.070',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTGL-YLXA-11-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-251201-0002','2025-12-01','2025-12-01','12:17','5.9','adminpusat','2025-12-01 12:18:10');
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-251201-0003','1','MTGW-YLXA-12-0','1','0.810','0.810','TOKO','INPUT1','TOKO','BKGWMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGWMT' WHERE kode_barang='MTGW-YLXA-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-12-01','TOKO','BKGWMT','MTGW','MTGW-YLXA-12-0','100.00','1','0.810','0.800','1','0.810','0.800');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.810',berat_out_asli=berat_out_asli+'0.800',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTGW-YLXA-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-251201-0003','2','MTGW-YLXA-13-0','1','0.810','0.810','TOKO','INPUT1','TOKO','BKGWMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGWMT' WHERE kode_barang='MTGW-YLXA-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-12-01','TOKO','BKGWMT','MTGW','MTGW-YLXA-13-0','100.00','1','0.810','0.800','1','0.810','0.800');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.810',berat_out_asli=berat_out_asli+'0.800',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTGW-YLXA-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-251201-0003','3','MTGW-YLXA-14-0','1','0.530','0.530','TOKO','INPUT1','TOKO','BKGWMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGWMT' WHERE kode_barang='MTGW-YLXA-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-12-01','TOKO','BKGWMT','MTGW','MTGW-YLXA-14-0','100.00','1','0.530','0.520','1','0.530','0.520');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.530',berat_out_asli=berat_out_asli+'0.520',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTGW-YLXA-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-251201-0003','4','MTGW-YLXA-15-0','1','0.500','0.500','TOKO','INPUT1','TOKO','BKGWMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGWMT' WHERE kode_barang='MTGW-YLXA-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-12-01','TOKO','BKGWMT','MTGW','MTGW-YLXA-15-0','100.00','1','0.500','0.490','1','0.500','0.490');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.500',berat_out_asli=berat_out_asli+'0.490',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTGW-YLXA-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-251201-0003','5','MTGW-YLXA-16-0','1','0.510','0.510','TOKO','INPUT1','TOKO','BKGWMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGWMT' WHERE kode_barang='MTGW-YLXA-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-12-01','TOKO','BKGWMT','MTGW','MTGW-YLXA-16-0','100.00','1','0.510','0.500','1','0.510','0.500');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.510',berat_out_asli=berat_out_asli+'0.500',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTGW-YLXA-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-251201-0003','6','MTGW-YLXA-17-0','1','0.520','0.520','TOKO','INPUT1','TOKO','BKGWMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGWMT' WHERE kode_barang='MTGW-YLXA-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-12-01','TOKO','BKGWMT','MTGW','MTGW-YLXA-17-0','100.00','1','0.520','0.510','1','0.520','0.510');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.520',berat_out_asli=berat_out_asli+'0.510',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTGW-YLXA-17-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-251201-0003','2025-12-01','2025-12-01','12:18','3.68','adminpusat','2025-12-01 12:18:46');
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-251201-0004','1','MTLT-YLXA-18-0','1','0.920','0.920','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-YLXA-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-12-01','TOKO','BKLTMT','MTLT','MTLT-YLXA-18-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-12-01' AND kode_barang='MTLT-YLXA-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-251201-0004','2','MTLT-YLXA-19-0','1','0.950','0.950','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-YLXA-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-12-01','TOKO','BKLTMT','MTLT','MTLT-YLXA-19-0','100.00','1','0.950','0.940','1','0.950','0.940');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.950',berat_out_asli=berat_out_asli+'0.940',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTLT-YLXA-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-251201-0004','3','MTLT-YLXA-20-0','1','1.470','1.470','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-YLXA-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-12-01','TOKO','BKLTMT','MTLT','MTLT-YLXA-20-0','100.00','1','1.470','1.460','1','1.470','1.460');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.470',berat_out_asli=berat_out_asli+'1.460',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTLT-YLXA-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-251201-0004','4','MTLT-YLXA-21-0','1','1.460','1.460','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-YLXA-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-12-01','TOKO','BKLTMT','MTLT','MTLT-YLXA-21-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-12-01' AND kode_barang='MTLT-YLXA-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-251201-0004','5','MTLT-YLXA-22-0','1','1.940','1.940','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-YLXA-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-12-01','TOKO','BKLTMT','MTLT','MTLT-YLXA-22-0','100.00','1','1.940','1.930','1','1.940','1.930');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.940',berat_out_asli=berat_out_asli+'1.930',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTLT-YLXA-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-251201-0004','6','MTLT-YLXA-23-0','1','1.920','1.920','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-YLXA-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-12-01','TOKO','BKLTMT','MTLT','MTLT-YLXA-23-0','100.00','1','1.920','1.910','1','1.920','1.910');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.920',berat_out_asli=berat_out_asli+'1.910',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTLT-YLXA-23-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-251201-0004','2025-12-01','2025-12-01','12:18','8.66','adminpusat','2025-12-01 12:19:25');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-12-01 ','12:30:30');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-12-01 ','12:51:13');
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-YLXA-24-0','00026899',' ','GL GUCI MN LM 17CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','1096500','2025-12-01','1096500','1.080','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 12:57:54','1.070','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-YLXA-24-0','00026899');
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-12-01','MDGL-YLXA-24-0','MDGL','TOKO','INPUT1','100.00','1.080','1.070','1','1.080','1.070','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-YLXA-25-0','00026900',' ','GL GUCI MN LM 17CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','1096500','2025-12-01','1096500','1.080','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 12:58:19','1.070','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-YLXA-25-0','00026900');
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-12-01','MDGL-YLXA-25-0','MDGL','TOKO','INPUT1','100.00','1.080','1.070','1','1.080','1.070','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-YLXA-26-0','00026901',' ','GL FANCY SLP SRT MN LM 18CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','1431500','2025-12-01','1431500','1.410','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 13:01:32','1.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-YLXA-26-0','00026901');
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-12-01','MDGL-YLXA-26-0','MDGL','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 ('MDGL-YLXA-27-0','00026902',' ','GL FANCY SLP SRT MN LM 18CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','1431500','2025-12-01','1431500','1.410','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 13:01:52','1.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-YLXA-27-0','00026902');
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-12-01','MDGL-YLXA-27-0','MDGL','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 ('MDGL-YLXA-28-0','00026903',' ','GL FANCY VIGARU MN LM5 16CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','3684500','2025-12-01','3684500','3.630','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 13:04:14','3.620','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-YLXA-28-0','00026903');
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-12-01','MDGL-YLXA-28-0','MDGL','TOKO','INPUT1','100.00','3.630','3.620','1','3.630','3.620','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-YLXA-29-0','00026904',' ','GL FANCY VIGARU MN LM5 16CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','3735500','2025-12-01','3735500','3.680','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 13:04:33','3.670','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-YLXA-29-0','00026904');
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-12-01','MDGL-YLXA-29-0','MDGL','TOKO','INPUT1','100.00','3.680','3.670','1','3.680','3.670','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-YLXA-30-0','00026905',' ','LT CAP PLAT LM SHB ','','GR','---','MD','MDLT','TOKO','INPUT1','1015000','2025-12-01','1015000','1.000','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 13:06:24','0.990','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-YLXA-30-0','00026905');
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-12-01','MDLT-YLXA-30-0','MDLT','TOKO','INPUT1','100.00','1.000','0.990','1','1.000','0.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 ('MDLT-YLXA-31-0','00026906',' ','LT CAP PLAT LM SHB ','','GR','---','MD','MDLT','TOKO','INPUT1','1025500','2025-12-01','1025500','1.010','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 13:06:45','1.000','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-YLXA-31-0','00026906');
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-12-01','MDLT-YLXA-31-0','MDLT','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 ('MDLT-YLXA-32-0','00026907',' ','LT CAP PLAT LM SHB ','','GR','---','MD','MDLT','TOKO','INPUT1','1015000','2025-12-01','1015000','1.000','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 13:07:15','0.990','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-YLXA-32-0','00026907');
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-12-01','MDLT-YLXA-32-0','MDLT','TOKO','INPUT1','100.00','1.000','0.990','1','1.000','0.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 ('MDLT-YLXA-33-0','00026908',' ','LT CAP PLAT LM SHB ','','GR','---','MD','MDLT','TOKO','INPUT1','1624000','2025-12-01','1624000','1.600','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 13:09:59','1.590','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-YLXA-33-0','00026908');
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-12-01','MDLT-YLXA-33-0','MDLT','TOKO','INPUT1','100.00','1.600','1.590','1','1.600','1.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 ('MDLT-YLXA-34-0','00026909',' ','LT CAP PLAT LM SHB ','','GR','---','MD','MDLT','TOKO','INPUT1','1624000','2025-12-01','1624000','1.600','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 13:10:20','1.590','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-YLXA-34-0','00026909');
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-12-01','MDLT-YLXA-34-0','MDLT','TOKO','INPUT1','100.00','1.600','1.590','1','1.600','1.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 ('MDLT-YLXA-35-0','00026910',' ','LT CAP PLAT LM SHB ','','GR','---','MD','MDLT','TOKO','INPUT1','1634500','2025-12-01','1634500','1.610','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 13:10:42','1.600','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-YLXA-35-0','00026910');
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-12-01','MDLT-YLXA-35-0','MDLT','TOKO','INPUT1','100.00','1.610','1.600','1','1.610','1.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 ('MDLT-YLXA-36-0','00026911',' ','LT CAP PLAT LM SHB ','','GR','---','MD','MDLT','TOKO','INPUT1','2000000','2025-12-01','2000000','1.970','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 13:11:22','1.960','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-YLXA-36-0','00026911');
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-12-01','MDLT-YLXA-36-0','MDLT','TOKO','INPUT1','100.00','1.970','1.960','1','1.970','1.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 ('MDLT-YLXA-37-0','00026912',' ','LT CAP PLAT LM SHB ','','GR','---','MD','MDLT','TOKO','INPUT1','2060500','2025-12-01','2060500','2.030','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 13:11:43','2.020','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-YLXA-37-0','00026912');
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-12-01','MDLT-YLXA-37-0','MDLT','TOKO','INPUT1','100.00','2.030','2.020','1','2.030','2.020','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-YLXA-38-0','00026913',' ','LT CAP BT SHB ','','GR','---','MD','MDLT','TOKO','INPUT1','1066000','2025-12-01','1066000','1.050','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 13:13:06','1.040','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-YLXA-38-0','00026913');
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-12-01','MDLT-YLXA-38-0','MDLT','TOKO','INPUT1','100.00','1.050','1.040','1','1.050','1.040','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-YLXA-39-0','00026914',' ','LT CAP BT SHB ','','GR','---','MD','MDLT','TOKO','INPUT1','1056000','2025-12-01','1056000','1.040','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 13:13:23','1.030','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-YLXA-39-0','00026914');
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-12-01','MDLT-YLXA-39-0','MDLT','TOKO','INPUT1','100.00','1.040','1.030','1','1.040','1.030','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-YLXA-40-0','00026915',' ','LT CAP BT SHB ','','GR','---','MD','MDLT','TOKO','INPUT1','1279000','2025-12-01','1279000','1.260','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 13:13:57','1.250','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-YLXA-40-0','00026915');
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-12-01','MDLT-YLXA-40-0','MDLT','TOKO','INPUT1','100.00','1.260','1.250','1','1.260','1.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 ('MDLT-YLXA-41-0','00026916',' ','LT CAP BT SHB ','','GR','---','MD','MDLT','TOKO','INPUT1','1279000','2025-12-01','1279000','1.260','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 13:14:14','1.250','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-YLXA-41-0','00026916');
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-12-01','MDLT-YLXA-41-0','MDLT','TOKO','INPUT1','100.00','1.260','1.250','1','1.260','1.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 ('MDLT-YLXA-42-0','00026917',' ','LT CAP BT SHB ','','GR','---','MD','MDLT','TOKO','INPUT1','985000','2025-12-01','985000','0.970','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 13:15:04','0.960','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-YLXA-42-0','00026917');
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-12-01','MDLT-YLXA-42-0','MDLT','TOKO','INPUT1','100.00','0.970','0.960','1','0.970','0.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 ('MDLT-YLXA-43-0','00026918',' ','LT CAP BT SHB ','','GR','---','MD','MDLT','TOKO','INPUT1','924000','2025-12-01','924000','0.910','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 13:15:30','0.900','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-YLXA-43-0','00026918');
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-12-01','MDLT-YLXA-43-0','MDLT','TOKO','INPUT1','100.00','0.910','0.900','1','0.910','0.900','1');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251201-0001','1','MTCN-YLXA-1-0','1','0.470','TOKO','BKCNMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-YLXA-1-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTCN-YLXA-1-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKCNMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKCNMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTCN-YLXA-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.470',berat_out_asli='0.460', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.470',berat_akhir_asli =berat_akhir_asli-'0.460' WHERE kode_barang='MTCN-YLXA-1-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251201-0001','2','MTCN-YLXA-2-0','1','0.520','TOKO','BKCNMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-YLXA-2-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTCN-YLXA-2-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKCNMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKCNMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTCN-YLXA-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.520',berat_out_asli='0.510', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.520',berat_akhir_asli =berat_akhir_asli-'0.510' WHERE kode_barang='MTCN-YLXA-2-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251201-0001','3','MTCN-YLXA-3-0','1','0.500','TOKO','BKCNMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-YLXA-3-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTCN-YLXA-3-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKCNMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKCNMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTCN-YLXA-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.500',berat_out_asli='0.490', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.500',berat_akhir_asli =berat_akhir_asli-'0.490' WHERE kode_barang='MTCN-YLXA-3-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251201-0001','4','MTCN-YLXA-4-0','1','0.510','TOKO','BKCNMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-YLXA-4-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTCN-YLXA-4-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKCNMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKCNMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTCN-YLXA-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.510',berat_out_asli='0.500', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.510',berat_akhir_asli =berat_akhir_asli-'0.500' WHERE kode_barang='MTCN-YLXA-4-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251201-0001','5','MTCN-YLXA-5-0','1','0.600','TOKO','BKCNMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-YLXA-5-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTCN-YLXA-5-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKCNMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKCNMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTCN-YLXA-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.600',berat_out_asli='0.590', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.600',berat_akhir_asli =berat_akhir_asli-'0.590' WHERE kode_barang='MTCN-YLXA-5-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-251201-0001','2025-12-01','2025-12-01','13:41','0.600','adminpusat','251201');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251201-0002','1','MTGL-YLXA-6-0','1','1.220','TOKO','BKGLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-YLXA-6-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-YLXA-6-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-YLXA-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.220',berat_out_asli='1.210', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.220',berat_akhir_asli =berat_akhir_asli-'1.210' WHERE kode_barang='MTGL-YLXA-6-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251201-0002','2','MTGL-YLXA-7-0','1','1.220','TOKO','BKGLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-YLXA-7-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-YLXA-7-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-YLXA-7-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.220',berat_out_asli='1.210', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.220',berat_akhir_asli =berat_akhir_asli-'1.210' WHERE kode_barang='MTGL-YLXA-7-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251201-0002','3','MTGL-YLXA-8-0','1','0.740','TOKO','BKGLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-YLXA-8-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-YLXA-8-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-YLXA-8-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.740',berat_out_asli='0.730', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.740',berat_akhir_asli =berat_akhir_asli-'0.730' WHERE kode_barang='MTGL-YLXA-8-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251201-0002','4','MTGL-YLXA-9-0','1','0.680','TOKO','BKGLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-YLXA-9-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-YLXA-9-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-YLXA-9-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.680',berat_out_asli='0.670', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.680',berat_akhir_asli =berat_akhir_asli-'0.670' WHERE kode_barang='MTGL-YLXA-9-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251201-0002','5','MTGL-YLXA-10-0','1','0.960','TOKO','BKGLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-YLXA-10-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-YLXA-10-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-YLXA-10-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.960',berat_out_asli='0.950', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.960',berat_akhir_asli =berat_akhir_asli-'0.950' WHERE kode_barang='MTGL-YLXA-10-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251201-0002','6','MTGL-YLXA-11-0','1','1.080','TOKO','BKGLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-YLXA-11-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-YLXA-11-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-YLXA-11-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.080',berat_out_asli='1.070', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.080',berat_akhir_asli =berat_akhir_asli-'1.070' WHERE kode_barang='MTGL-YLXA-11-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-251201-0002','2025-12-01','2025-12-01','13:41','1.080','adminpusat','251201');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251201-0003','1','MTGW-YLXA-12-0','1','0.810','TOKO','BKGWMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-YLXA-12-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGW-YLXA-12-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGWMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGWMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGW-YLXA-12-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.810',berat_out_asli='0.800', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.810',berat_akhir_asli =berat_akhir_asli-'0.800' WHERE kode_barang='MTGW-YLXA-12-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251201-0003','2','MTGW-YLXA-13-0','1','0.810','TOKO','BKGWMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-YLXA-13-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGW-YLXA-13-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGWMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGWMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGW-YLXA-13-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.810',berat_out_asli='0.800', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.810',berat_akhir_asli =berat_akhir_asli-'0.800' WHERE kode_barang='MTGW-YLXA-13-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251201-0003','3','MTGW-YLXA-14-0','1','0.530','TOKO','BKGWMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-YLXA-14-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGW-YLXA-14-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGWMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGWMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGW-YLXA-14-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.530',berat_out_asli='0.520', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.530',berat_akhir_asli =berat_akhir_asli-'0.520' WHERE kode_barang='MTGW-YLXA-14-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251201-0003','4','MTGW-YLXA-15-0','1','0.500','TOKO','BKGWMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-YLXA-15-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGW-YLXA-15-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGWMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGWMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGW-YLXA-15-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.500',berat_out_asli='0.490', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.500',berat_akhir_asli =berat_akhir_asli-'0.490' WHERE kode_barang='MTGW-YLXA-15-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251201-0003','5','MTGW-YLXA-16-0','1','0.510','TOKO','BKGWMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-YLXA-16-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGW-YLXA-16-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGWMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGWMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGW-YLXA-16-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.510',berat_out_asli='0.500', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.510',berat_akhir_asli =berat_akhir_asli-'0.500' WHERE kode_barang='MTGW-YLXA-16-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251201-0003','6','MTGW-YLXA-17-0','1','0.520','TOKO','BKGWMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-YLXA-17-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGW-YLXA-17-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGWMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGWMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGW-YLXA-17-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.520',berat_out_asli='0.510', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.520',berat_akhir_asli =berat_akhir_asli-'0.510' WHERE kode_barang='MTGW-YLXA-17-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-251201-0003','2025-12-01','2025-12-01','13:41','0.520','adminpusat','251201');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251201-0004','1','MTLT-YLXA-18-0','1','0.920','TOKO','BKLTMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-YLXA-18-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTLT-YLXA-18-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLTMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLTMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTLT-YLXA-18-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.920',berat_out_asli='0.910', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.920',berat_akhir_asli =berat_akhir_asli-'0.910' WHERE kode_barang='MTLT-YLXA-18-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251201-0004','2','MTLT-YLXA-19-0','1','0.950','TOKO','BKLTMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-YLXA-19-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTLT-YLXA-19-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLTMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLTMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTLT-YLXA-19-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.950',berat_out_asli='0.940', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.950',berat_akhir_asli =berat_akhir_asli-'0.940' WHERE kode_barang='MTLT-YLXA-19-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251201-0004','3','MTLT-YLXA-20-0','1','1.470','TOKO','BKLTMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-YLXA-20-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTLT-YLXA-20-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLTMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLTMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTLT-YLXA-20-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.470',berat_out_asli='1.460', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.470',berat_akhir_asli =berat_akhir_asli-'1.460' WHERE kode_barang='MTLT-YLXA-20-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251201-0004','4','MTLT-YLXA-21-0','1','1.460','TOKO','BKLTMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-YLXA-21-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTLT-YLXA-21-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLTMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLTMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTLT-YLXA-21-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.460',berat_out_asli='1.450', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.460',berat_akhir_asli =berat_akhir_asli-'1.450' WHERE kode_barang='MTLT-YLXA-21-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251201-0004','5','MTLT-YLXA-22-0','1','1.940','TOKO','BKLTMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-YLXA-22-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTLT-YLXA-22-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLTMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLTMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTLT-YLXA-22-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.940',berat_out_asli='1.930', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.940',berat_akhir_asli =berat_akhir_asli-'1.930' WHERE kode_barang='MTLT-YLXA-22-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251201-0004','6','MTLT-YLXA-23-0','1','1.920','TOKO','BKLTMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-YLXA-23-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTLT-YLXA-23-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLTMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLTMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTLT-YLXA-23-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.920',berat_out_asli='1.910', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.920',berat_akhir_asli =berat_akhir_asli-'1.910' WHERE kode_barang='MTLT-YLXA-23-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-251201-0004','2025-12-01','2025-12-01','13:41','1.920','adminpusat','251201');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-12-01 ','13:59:04');
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-251201-0005','1','MDGL-YLXA-24-0','1','1.080','1.080','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YLXA-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-12-01','TOKO','BGLMD','MDGL','MDGL-YLXA-24-0','100.00','1','1.080','1.070','1','1.080','1.070');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.080',berat_out_asli=berat_out_asli+'1.070',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MDGL-YLXA-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-251201-0005','2','MDGL-YLXA-25-0','1','1.080','1.080','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YLXA-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-12-01','TOKO','BGLMD','MDGL','MDGL-YLXA-25-0','100.00','1','1.080','1.070','1','1.080','1.070');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.080',berat_out_asli=berat_out_asli+'1.070',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MDGL-YLXA-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-251201-0005','3','MDGL-YLXA-26-0','1','1.410','1.410','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YLXA-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-12-01','TOKO','BGLMD','MDGL','MDGL-YLXA-26-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-12-01' AND kode_barang='MDGL-YLXA-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-251201-0005','4','MDGL-YLXA-27-0','1','1.410','1.410','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YLXA-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-12-01','TOKO','BGLMD','MDGL','MDGL-YLXA-27-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-12-01' AND kode_barang='MDGL-YLXA-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-251201-0005','5','MDGL-YLXA-28-0','1','3.630','3.630','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YLXA-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-12-01','TOKO','BGLMD','MDGL','MDGL-YLXA-28-0','100.00','1','3.630','3.620','1','3.630','3.620');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.630',berat_out_asli=berat_out_asli+'3.620',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MDGL-YLXA-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-251201-0005','6','MDGL-YLXA-29-0','1','3.680','3.680','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YLXA-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-12-01','TOKO','BGLMD','MDGL','MDGL-YLXA-29-0','100.00','1','3.680','3.670','1','3.680','3.670');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.680',berat_out_asli=berat_out_asli+'3.670',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MDGL-YLXA-29-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-251201-0005','2025-12-01','2025-12-01','13:59','12.29','adminpusat','2025-12-01 13:59:48');
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-251201-0006','1','MDLT-YLXA-30-0','1','1.000','1.000','TOKO','INPUT1','TOKO','BLTMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BLTMD' WHERE kode_barang='MDLT-YLXA-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-12-01','TOKO','BLTMD','MDLT','MDLT-YLXA-30-0','100.00','1','1.000','0.990','1','1.000','0.990');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.000',berat_out_asli=berat_out_asli+'0.990',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MDLT-YLXA-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-251201-0006','2','MDLT-YLXA-31-0','1','1.010','1.010','TOKO','INPUT1','TOKO','BLTMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BLTMD' WHERE kode_barang='MDLT-YLXA-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-12-01','TOKO','BLTMD','MDLT','MDLT-YLXA-31-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-12-01' AND kode_barang='MDLT-YLXA-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-251201-0006','3','MDLT-YLXA-32-0','1','1.000','1.000','TOKO','INPUT1','TOKO','BLTMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BLTMD' WHERE kode_barang='MDLT-YLXA-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-12-01','TOKO','BLTMD','MDLT','MDLT-YLXA-32-0','100.00','1','1.000','0.990','1','1.000','0.990');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.000',berat_out_asli=berat_out_asli+'0.990',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MDLT-YLXA-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-251201-0006','4','MDLT-YLXA-33-0','1','1.600','1.600','TOKO','INPUT1','TOKO','BLTMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BLTMD' WHERE kode_barang='MDLT-YLXA-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-12-01','TOKO','BLTMD','MDLT','MDLT-YLXA-33-0','100.00','1','1.600','1.590','1','1.600','1.590');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.600',berat_out_asli=berat_out_asli+'1.590',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MDLT-YLXA-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-251201-0006','5','MDLT-YLXA-34-0','1','1.600','1.600','TOKO','INPUT1','TOKO','BLTMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BLTMD' WHERE kode_barang='MDLT-YLXA-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-12-01','TOKO','BLTMD','MDLT','MDLT-YLXA-34-0','100.00','1','1.600','1.590','1','1.600','1.590');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.600',berat_out_asli=berat_out_asli+'1.590',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MDLT-YLXA-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-251201-0006','6','MDLT-YLXA-35-0','1','1.610','1.610','TOKO','INPUT1','TOKO','BLTMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BLTMD' WHERE kode_barang='MDLT-YLXA-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-12-01','TOKO','BLTMD','MDLT','MDLT-YLXA-35-0','100.00','1','1.610','1.600','1','1.610','1.600');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.610',berat_out_asli=berat_out_asli+'1.600',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MDLT-YLXA-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-251201-0006','7','MDLT-YLXA-36-0','1','1.970','1.970','TOKO','INPUT1','TOKO','BLTMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BLTMD' WHERE kode_barang='MDLT-YLXA-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-12-01','TOKO','BLTMD','MDLT','MDLT-YLXA-36-0','100.00','1','1.970','1.960','1','1.970','1.960');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.970',berat_out_asli=berat_out_asli+'1.960',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MDLT-YLXA-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-251201-0006','8','MDLT-YLXA-37-0','1','2.030','2.030','TOKO','INPUT1','TOKO','BLTMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BLTMD' WHERE kode_barang='MDLT-YLXA-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-12-01','TOKO','BLTMD','MDLT','MDLT-YLXA-37-0','100.00','1','2.030','2.020','1','2.030','2.020');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.030',berat_out_asli=berat_out_asli+'2.020',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MDLT-YLXA-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-251201-0006','9','MDLT-YLXA-38-0','1','1.050','1.050','TOKO','INPUT1','TOKO','BLTMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BLTMD' WHERE kode_barang='MDLT-YLXA-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-12-01','TOKO','BLTMD','MDLT','MDLT-YLXA-38-0','100.00','1','1.050','1.040','1','1.050','1.040');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.050',berat_out_asli=berat_out_asli+'1.040',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MDLT-YLXA-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-251201-0006','10','MDLT-YLXA-39-0','1','1.040','1.040','TOKO','INPUT1','TOKO','BLTMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BLTMD' WHERE kode_barang='MDLT-YLXA-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-12-01','TOKO','BLTMD','MDLT','MDLT-YLXA-39-0','100.00','1','1.040','1.030','1','1.040','1.030');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.040',berat_out_asli=berat_out_asli+'1.030',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MDLT-YLXA-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-251201-0006','11','MDLT-YLXA-40-0','1','1.260','1.260','TOKO','INPUT1','TOKO','BLTMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BLTMD' WHERE kode_barang='MDLT-YLXA-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-12-01','TOKO','BLTMD','MDLT','MDLT-YLXA-40-0','100.00','1','1.260','1.250','1','1.260','1.250');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.260',berat_out_asli=berat_out_asli+'1.250',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MDLT-YLXA-40-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-251201-0006','12','MDLT-YLXA-41-0','1','1.260','1.260','TOKO','INPUT1','TOKO','BLTMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BLTMD' WHERE kode_barang='MDLT-YLXA-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-12-01','TOKO','BLTMD','MDLT','MDLT-YLXA-41-0','100.00','1','1.260','1.250','1','1.260','1.250');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.260',berat_out_asli=berat_out_asli+'1.250',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MDLT-YLXA-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-251201-0006','13','MDLT-YLXA-42-0','1','0.970','0.970','TOKO','INPUT1','TOKO','BLTMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BLTMD' WHERE kode_barang='MDLT-YLXA-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-12-01','TOKO','BLTMD','MDLT','MDLT-YLXA-42-0','100.00','1','0.970','0.960','1','0.970','0.960');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.970',berat_out_asli=berat_out_asli+'0.960',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MDLT-YLXA-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-251201-0006','14','MDLT-YLXA-43-0','1','0.910','0.910','TOKO','INPUT1','TOKO','BLTMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BLTMD' WHERE kode_barang='MDLT-YLXA-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-12-01','TOKO','BLTMD','MDLT','MDLT-YLXA-43-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-12-01' AND kode_barang='MDLT-YLXA-43-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-251201-0006','2025-12-01','2025-12-01','13:59','18.31','adminpusat','2025-12-01 14:01:16');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-12-01 ','14:08:14');
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 ('MTAT-YLXA-44-0','00026919',' ','AT CAP PLAT LM BT SHB ','','GR','---','MT','MTAT','TOKO','INPUT1','2749500','2025-12-01','2749500','1.580','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 14:14:06','1.570','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTAT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTAT','MTAT-YLXA-44-0','00026919');
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-12-01','MTAT-YLXA-44-0','MTAT','TOKO','INPUT1','100.00','1.580','1.570','1','1.580','1.570','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 ('MTAT-YLXA-45-0','00026920',' ','AT CAP PLAT LM BT SHB ','','GR','---','MT','MTAT','TOKO','INPUT1','2732000','2025-12-01','2732000','1.570','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 14:15:17','1.560','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTAT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTAT','MTAT-YLXA-45-0','00026920');
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-12-01','MTAT-YLXA-45-0','MTAT','TOKO','INPUT1','100.00','1.570','1.560','1','1.570','1.560','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 ('MTGL-YLXA-46-0','00026921',' ','GL GUCI MN LM 16CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','2453500','2025-12-01','2453500','1.410','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 14:18:12','1.400','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-YLXA-46-0','00026921');
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-12-01','MTGL-YLXA-46-0','MTGL','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 ('MTGL-YLXA-47-0','00026922',' ','GL GUCI MN LM 16CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','2436000','2025-12-01','2436000','1.400','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 14:18:28','1.390','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-YLXA-47-0','00026922');
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-12-01','MTGL-YLXA-47-0','MTGL','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 ('MTGL-YLXA-48-0','00026923',' ','GL FANCY SLP SRT MN LM 18CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','3341000','2025-12-01','3341000','1.920','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 14:20:53','1.910','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-YLXA-48-0','00026923');
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-12-01','MTGL-YLXA-48-0','MTGL','TOKO','INPUT1','100.00','1.920','1.910','1','1.920','1.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 ('MTGL-YLXA-49-0','00026924',' ','GL FANCY SLP SRT MN LM 18CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','3271500','2025-12-01','3271500','1.880','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 14:21:13','1.870','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-YLXA-49-0','00026924');
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-12-01','MTGL-YLXA-49-0','MTGL','TOKO','INPUT1','100.00','1.880','1.870','1','1.880','1.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 ('MTGL-YLXA-50-0','00026925',' ','GL CATENA BTR MN LM 15CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','4019500','2025-12-01','4019500','2.310','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 14:23:26','2.300','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-YLXA-50-0','00026925');
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-12-01','MTGL-YLXA-50-0','MTGL','TOKO','INPUT1','100.00','2.310','2.300','1','2.310','2.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 ('MTGL-YLXA-51-0','00026926',' ','GL CATENA BTR MN LM 15CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','4019500','2025-12-01','4019500','2.310','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 14:23:49','2.300','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-YLXA-51-0','00026926');
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-12-01','MTGL-YLXA-51-0','MTGL','TOKO','INPUT1','100.00','2.310','2.300','1','2.310','2.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 ('MTGL-YLXA-52-0','00026927',' ','GL VIGARU MOCCA MN LM5 16CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','5290000','2025-12-01','5290000','3.040','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 14:26:29','3.030','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-YLXA-52-0','00026927');
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-12-01','MTGL-YLXA-52-0','MTGL','TOKO','INPUT1','100.00','3.040','3.030','1','3.040','3.030','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 ('MTGL-YLXA-53-0','00026928',' ','GL VIGARU MOCCA MN LM5 17CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','5446500','2025-12-01','5446500','3.130','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 14:27:09','3.120','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-YLXA-53-0','00026928');
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-12-01','MTGL-YLXA-53-0','MTGL','TOKO','INPUT1','100.00','3.130','3.120','1','3.130','3.120','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 ('MTGL-YLXA-54-0','00026929',' ','GL MOCCA LM3 15CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','5707500','2025-12-01','5707500','3.280','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 14:30:02','3.270','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-YLXA-54-0','00026929');
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-12-01','MTGL-YLXA-54-0','MTGL','TOKO','INPUT1','100.00','3.280','3.270','1','3.280','3.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 ('MTGL-YLXA-55-0','00026930',' ','GL MOCCA LM3 15CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','5742000','2025-12-01','5742000','3.300','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 14:30:23','3.290','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-YLXA-55-0','00026930');
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-12-01','MTGL-YLXA-55-0','MTGL','TOKO','INPUT1','100.00','3.300','3.290','1','3.300','3.290','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 ('MTGL-YLXA-56-0','00026931',' ','GL MOCCA DB MN LM3 BL2 16CM KKT S SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','9013500','2025-12-01','9013500','5.180','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-01 14:32:52','5.170','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-YLXA-56-0','00026931');
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-12-01','MTGL-YLXA-56-0','MTGL','TOKO','INPUT1','100.00','5.180','5.170','1','5.180','5.170','1');
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-251201-0007','1','MTAT-YLXA-44-0','1','1.580','1.580','TOKO','INPUT1','TOKO','BKATMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKATMT' WHERE kode_barang='MTAT-YLXA-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-12-01','TOKO','BKATMT','MTAT','MTAT-YLXA-44-0','100.00','1','1.580','1.570','1','1.580','1.570');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.580',berat_out_asli=berat_out_asli+'1.570',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTAT-YLXA-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-251201-0007','2','MTAT-YLXA-45-0','1','1.570','1.570','TOKO','INPUT1','TOKO','BKATMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKATMT' WHERE kode_barang='MTAT-YLXA-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-12-01','TOKO','BKATMT','MTAT','MTAT-YLXA-45-0','100.00','1','1.570','1.560','1','1.570','1.560');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.570',berat_out_asli=berat_out_asli+'1.560',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTAT-YLXA-45-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-251201-0007','2025-12-01','2025-12-01','14:43','3.15','adminpusat','2025-12-01 14:43:38');
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-251201-0008','1','MTGL-YLXA-46-0','1','1.410','1.410','TOKO','INPUT1','TOKO','BKGLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-YLXA-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-12-01','TOKO','BKGLMT','MTGL','MTGL-YLXA-46-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-12-01' AND kode_barang='MTGL-YLXA-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-251201-0008','2','MTGL-YLXA-47-0','1','1.400','1.400','TOKO','INPUT1','TOKO','BKGLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-YLXA-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-12-01','TOKO','BKGLMT','MTGL','MTGL-YLXA-47-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-12-01' AND kode_barang='MTGL-YLXA-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-251201-0008','3','MTGL-YLXA-48-0','1','1.920','1.920','TOKO','INPUT1','TOKO','BKGLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-YLXA-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-12-01','TOKO','BKGLMT','MTGL','MTGL-YLXA-48-0','100.00','1','1.920','1.910','1','1.920','1.910');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.920',berat_out_asli=berat_out_asli+'1.910',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTGL-YLXA-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-251201-0008','4','MTGL-YLXA-49-0','1','1.880','1.880','TOKO','INPUT1','TOKO','BKGLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-YLXA-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-12-01','TOKO','BKGLMT','MTGL','MTGL-YLXA-49-0','100.00','1','1.880','1.870','1','1.880','1.870');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.880',berat_out_asli=berat_out_asli+'1.870',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTGL-YLXA-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-251201-0008','5','MTGL-YLXA-50-0','1','2.310','2.310','TOKO','INPUT1','TOKO','BKGLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-YLXA-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-12-01','TOKO','BKGLMT','MTGL','MTGL-YLXA-50-0','100.00','1','2.310','2.300','1','2.310','2.300');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.310',berat_out_asli=berat_out_asli+'2.300',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTGL-YLXA-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-251201-0008','6','MTGL-YLXA-51-0','1','2.310','2.310','TOKO','INPUT1','TOKO','BKGLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-YLXA-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-12-01','TOKO','BKGLMT','MTGL','MTGL-YLXA-51-0','100.00','1','2.310','2.300','1','2.310','2.300');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.310',berat_out_asli=berat_out_asli+'2.300',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTGL-YLXA-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-251201-0008','7','MTGL-YLXA-52-0','1','3.040','3.040','TOKO','INPUT1','TOKO','BKGLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-YLXA-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-12-01','TOKO','BKGLMT','MTGL','MTGL-YLXA-52-0','100.00','1','3.040','3.030','1','3.040','3.030');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.040',berat_out_asli=berat_out_asli+'3.030',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTGL-YLXA-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-251201-0008','8','MTGL-YLXA-53-0','1','3.130','3.130','TOKO','INPUT1','TOKO','BKGLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-YLXA-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-12-01','TOKO','BKGLMT','MTGL','MTGL-YLXA-53-0','100.00','1','3.130','3.120','1','3.130','3.120');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.130',berat_out_asli=berat_out_asli+'3.120',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTGL-YLXA-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-251201-0008','9','MTGL-YLXA-54-0','1','3.280','3.280','TOKO','INPUT1','TOKO','BKGLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-YLXA-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-12-01','TOKO','BKGLMT','MTGL','MTGL-YLXA-54-0','100.00','1','3.280','3.270','1','3.280','3.270');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.280',berat_out_asli=berat_out_asli+'3.270',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTGL-YLXA-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-251201-0008','10','MTGL-YLXA-55-0','1','3.300','3.300','TOKO','INPUT1','TOKO','BKGLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-YLXA-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-12-01','TOKO','BKGLMT','MTGL','MTGL-YLXA-55-0','100.00','1','3.300','3.290','1','3.300','3.290');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.300',berat_out_asli=berat_out_asli+'3.290',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTGL-YLXA-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-251201-0008','11','MTGL-YLXA-56-0','1','5.180','5.180','TOKO','INPUT1','TOKO','BKGLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-YLXA-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-12-01','TOKO','BKGLMT','MTGL','MTGL-YLXA-56-0','100.00','1','5.180','5.170','1','5.180','5.170');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.180',berat_out_asli=berat_out_asli+'5.170',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-01' AND kode_barang='MTGL-YLXA-56-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-251201-0008','2025-12-01','2025-12-01','14:43','29.16','adminpusat','2025-12-01 14:44:43');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-12-01 ','15:20:18');
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-YLXA-57-0','00026932','EX ','AT TINDIK MN MAS MK ','','GR','---','MD','MDAT','TOKO','INPUT1','528000','2025-12-01','528000','0.520','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 15:22:07','0.510','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-YLXA-57-0','00026932');
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-12-01','MDAT-YLXA-57-0','MDAT','TOKO','INPUT1','100.00','0.520','0.510','1','0.520','0.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 ('MDAT-YLXA-58-0','00026933','EX ','AT JEPSI POLOS MK ','','GR','---','MD','MDAT','TOKO','INPUT1','487500','2025-12-01','487500','0.480','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 15:22:45','0.470','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-YLXA-58-0','00026933');
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-12-01','MDAT-YLXA-58-0','MDAT','TOKO','INPUT1','100.00','0.480','0.470','1','0.480','0.470','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-YLXA-59-0','00026934','EX ','AT JEPSI SLP KEMBANG MK ','','GR','---','MD','MDAT','TOKO','INPUT1','1015000','2025-12-01','1015000','1.000','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 15:23:26','0.990','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-YLXA-59-0','00026934');
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-12-01','MDAT-YLXA-59-0','MDAT','TOKO','INPUT1','100.00','1.000','0.990','1','1.000','0.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 ('MDAT-YLXA-60-0','00026935','EX ','AT JEPSI SLP KEMBANG MK ','','GR','---','MD','MDAT','TOKO','INPUT1','995000','2025-12-01','995000','0.980','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 15:23:48','0.970','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-YLXA-60-0','00026935');
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-12-01','MDAT-YLXA-60-0','MDAT','TOKO','INPUT1','100.00','0.980','0.970','1','0.980','0.970','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-YLXA-61-0','00026936','EX ','AT ITALY BT SHB ','','GR','---','MD','MDAT','TOKO','INPUT1','985000','2025-12-01','985000','0.970','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 15:25:00','0.960','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-YLXA-61-0','00026936');
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-12-01','MDAT-YLXA-61-0','MDAT','TOKO','INPUT1','100.00','0.970','0.960','1','0.970','0.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 ('MDAT-YLXA-62-0','00026937','EX ','AT ITALY KUPU BT SHB ','','GR','---','MD','MDAT','TOKO','INPUT1','1289500','2025-12-01','1289500','1.270','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 15:26:18','1.260','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-YLXA-62-0','00026937');
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-12-01','MDAT-YLXA-62-0','MDAT','TOKO','INPUT1','100.00','1.270','1.260','1','1.270','1.260','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-YLXA-63-0','00026938','EX ','AT ITALY VC HTM MK ','','GR','---','MD','MDAT','TOKO','INPUT1','1330000','2025-12-01','1330000','1.310','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 15:27:55','1.300','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-YLXA-63-0','00026938');
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-12-01','MDAT-YLXA-63-0','MDAT','TOKO','INPUT1','100.00','1.310','1.300','1','1.310','1.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 ('MDAT-YLXA-64-0','00026939','EX ','AT TUSUK ITALY BL SLP SHB ','','GR','---','MD','MDAT','TOKO','INPUT1','832500','2025-12-01','832500','0.820','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 15:28:55','0.810','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-YLXA-64-0','00026939');
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-12-01','MDAT-YLXA-64-0','MDAT','TOKO','INPUT1','100.00','0.820','0.810','1','0.820','0.810','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-YLXA-65-0','00026940','EX ','CN COR BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','934000','2025-12-01','934000','0.920','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 15:29:58','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-YLXA-65-0','00026940');
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-12-01','MDCN-YLXA-65-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-YLXA-66-0','00026941','EX ','CN BRILLIANT BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','670000','2025-12-01','670000','0.660','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 15:30:43','0.650','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-YLXA-66-0','00026941');
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-12-01','MDCN-YLXA-66-0','MDCN','TOKO','INPUT1','100.00','0.660','0.650','1','0.660','0.650','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-YLXA-67-0','00026942','EX ','CN COR DB SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','1543000','2025-12-01','1543000','1.520','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 15:32:05','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-YLXA-67-0','00026942');
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-12-01','MDCN-YLXA-67-0','MDCN','TOKO','INPUT1','100.00','1.520','1.510','1','1.520','1.510','1');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-12-01 ','15:33:09');
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-YLXA-68-0','00026943','EX ','CN COR TDK BT LC2 ','','GR','---','MD','MDCN','TOKO','INPUT1','2913500','2025-12-01','2913500','2.870','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 15:34:14','2.860','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-YLXA-68-0','00026943');
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-12-01','MDCN-YLXA-68-0','MDCN','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 ('MDCN-YLXA-69-0','00026944','EX ','CN PLINTIR SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','1908500','2025-12-01','1908500','1.880','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 15:34:52','1.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-YLXA-69-0','00026944');
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-12-01','MDCN-YLXA-69-0','MDCN','TOKO','INPUT1','100.00','1.880','1.870','1','1.880','1.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 ('MDGL-YLXA-70-0','00026945','EX ','GL FANCY MN DOLLAR5 17CM KKT PER LC2 ','','GR','---','MD','MDGL','TOKO','INPUT1','4872000','2025-12-01','4872000','4.800','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 15:36:14','4.790','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-YLXA-70-0','00026945');
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-12-01','MDGL-YLXA-70-0','MDGL','TOKO','INPUT1','100.00','4.800','4.790','1','4.800','4.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 ('MDGL-YLXA-71-0','00026946','EX ','GL CAP HOLO 16CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','3634000','2025-12-01','3634000','3.580','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 15:37:06','3.570','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-YLXA-71-0','00026946');
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-12-01','MDGL-YLXA-71-0','MDGL','TOKO','INPUT1','100.00','3.580','3.570','1','3.580','3.570','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-YLXA-72-0','00026947','EX ','GL CAP HOLO 16CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','5684000','2025-12-01','5684000','5.600','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 15:37:50','5.590','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-YLXA-72-0','00026947');
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-12-01','MDGL-YLXA-72-0','MDGL','TOKO','INPUT1','100.00','5.600','5.590','1','5.600','5.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-YLXA-73-0','00026948','EX ','GL RANGKAIAN COR 19CM KKT PER LC2 ','','GR','---','MD','MDGL','TOKO','INPUT1','14108500','2025-12-01','14108500','13.900','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 15:39:19','13.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-YLXA-73-0','00026948');
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-12-01','MDGL-YLXA-73-0','MDGL','TOKO','INPUT1','100.00','13.900','13.890','1','13.900','13.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-YLXA-74-0','00026949','EX ','KL FANCY ANAK VAR BT 34CM KKT PER SHB ','','GR','---','MD','MDKL','TOKO','INPUT1','1756000','2025-12-01','1756000','1.730','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 15:40:36','1.720','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-YLXA-74-0','00026949');
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-12-01','MDKL-YLXA-74-0','MDKL','TOKO','INPUT1','100.00','1.730','1.720','1','1.730','1.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 ('MDKL-YLXA-75-0','00026950','EX ','KL FANCY 42CM KKT PER SHB ','','GR','---','MD','MDKL','TOKO','INPUT1','1989500','2025-12-01','1989500','1.960','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 15:41:55','1.950','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-YLXA-75-0','00026950');
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-12-01','MDKL-YLXA-75-0','MDKL','TOKO','INPUT1','100.00','1.960','1.950','1','1.960','1.950','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-YLXA-76-0','00026951','EX ','KL ITALY ST BTR BL PSR 42CM KKT PER BLT SHB ','','GR','---','MD','MDKL','TOKO','INPUT1','3065500','2025-12-01','3065500','3.020','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 15:42:58','3.010','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-YLXA-76-0','00026951');
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-12-01','MDKL-YLXA-76-0','MDKL','TOKO','INPUT1','100.00','3.020','3.010','1','3.020','3.010','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-YLXA-77-0','00026952','EX ','LT COR BT SHB ','','GR','---','MD','MDLT','TOKO','INPUT1','1289500','2025-12-01','1289500','1.270','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 15:44:15','1.260','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-YLXA-77-0','00026952');
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-12-01','MDLT-YLXA-77-0','MDLT','TOKO','INPUT1','100.00','1.270','1.260','1','1.270','1.260','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-YLXA-78-0','00026953','EX ','LT COR DOLLAR LC2 ','','GR','---','MD','MDLT','TOKO','INPUT1','1218000','2025-12-01','1218000','1.200','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 15:45:10','1.190','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-YLXA-78-0','00026953');
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-12-01','MDLT-YLXA-78-0','MDLT','TOKO','INPUT1','100.00','1.200','1.190','1','1.200','1.190','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-YLXA-79-0','00026954','EX ','LT COR 3WRN LC2 ','','GR','---','MD','MDLT','TOKO','INPUT1','1533000','2025-12-01','1533000','1.510','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 15:46:11','1.500','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-YLXA-79-0','00026954');
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-12-01','MDLT-YLXA-79-0','MDLT','TOKO','INPUT1','100.00','1.510','1.500','1','1.510','1.500','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-YLXA-80-0','00026955','EX ','LT COR 2WRN UBS ','','GR','---','MD','MDLT','TOKO','INPUT1','2263500','2025-12-01','2263500','2.230','100.00','8','0','1015000.00','1','0.045', 'adminpusat','2025-12-01 15:46:51','2.220','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-YLXA-80-0','00026955');
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-12-01','MDLT-YLXA-80-0','MDLT','TOKO','INPUT1','100.00','2.230','2.220','1','2.230','2.220','1');