INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-14 ','08:29:45');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-08-14','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-07-14';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-08-13';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-08-13';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-08-13' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-08-13';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-08-13';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-08-13';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-08-13';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202607 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
UPDATE tt_barang_saldo SET tanggal= '2026-08-14' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-08-13' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-08-14';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-14 ','09:42:50');
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-ZHAD-1-0','00031071','EX ','LT COR BT SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','3270000','2026-08-14','3270000','1.730','100.00','16','0','1890000.00','1','0.045', 'adminpusat','2026-08-14 09:46:41','1.720','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-ZHAD-1-0','00031071');
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 ('2026-08-14','MTLT-ZHAD-1-0','MTLT','TOKO','INPUT1','100.00','1.730','1.720','1','1.730','1.720','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-260814-0001','1','MTLT-ZHAD-1-0','1','1.730','1.730','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZHAD-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('2026-08-14','TOKO','BKLTMT','MTLT','MTLT-ZHAD-1-0','100.00','1','1.730','1.720','1','1.730','1.720');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.730',berat_out_asli=berat_out_asli+'1.720',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MTLT-ZHAD-1-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-260814-0001','2026-08-14','2026-08-14','09:50','1.73','adminpusat','2026-08-14 09:51:07');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-14 ','09:53:42');
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-ZHAD-2-0','00031072','EX ','GL BANGKOK SLP SMBR PTH UBS ','','GR','---','MD','MDGL','TOKO','INPUT1','5993000','2026-08-14','5993000','5.280','100.00','8','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 09:59:46','5.270','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-ZHAD-2-0','00031072');
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 ('2026-08-14','MDGL-ZHAD-2-0','MDGL','TOKO','INPUT1','100.00','5.280','5.270','1','5.280','5.270','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-ZHAD-3-0','00031073','EX ','GL PIPA BT SMBR PTH UBS ','','GR','---','MD','MDGL','TOKO','INPUT1','9159500','2026-08-14','9159500','8.070','100.00','8','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 10:02:49','8.060','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-ZHAD-3-0','00031073');
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 ('2026-08-14','MDGL-ZHAD-3-0','MDGL','TOKO','INPUT1','100.00','8.070','8.060','1','8.070','8.060','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-ZHAD-4-0','00031074','EX ','GL KRC PLNTR SMBR PRH 6 SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','22507500','2026-08-14','22507500','19.830','100.00','8','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 10:05:23','19.820','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-ZHAD-4-0','00031074');
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 ('2026-08-14','MDGL-ZHAD-4-0','MDGL','TOKO','INPUT1','100.00','19.830','19.820','1','19.830','19.820','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-ZHAD-5-0','00031075','EX ','GL PIPA FORTUNE LC2 ','','GR','---','MD','MDGL','TOKO','INPUT1','19704000','2026-08-14','19704000','17.360','100.00','8','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 10:18:01','17.350','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-ZHAD-5-0','00031075');
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 ('2026-08-14','MDGL-ZHAD-5-0','MDGL','TOKO','INPUT1','100.00','17.360','17.350','1','17.360','17.350','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-ZHAD-6-0','00031076','EX ','GL RANGKAIAN COR 18CM KKT PER LC2 ','','GR','---','MD','MDGL','TOKO','INPUT1','6901000','2026-08-14','6901000','6.080','100.00','8','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 10:20:42','6.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-ZHAD-6-0','00031076');
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 ('2026-08-14','MDGL-ZHAD-6-0','MDGL','TOKO','INPUT1','100.00','6.080','6.070','1','6.080','6.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-ZHAD-7-0','00031077','EX ','GL FANCY VAR MN7 17CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','3337000','2026-08-14','3337000','2.940','100.00','8','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 10:24:40','2.930','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-ZHAD-7-0','00031077');
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 ('2026-08-14','MDGL-ZHAD-7-0','MDGL','TOKO','INPUT1','100.00','2.940','2.930','1','2.940','2.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 ('MDGL-ZHAD-8-0','00031078','EX ','GL ITALY ST SRT VC HTM MN BT 19CM KKT PER MK ','','GR','---','MD','MDGL','TOKO','INPUT1','2872000','2026-08-14','2872000','2.530','100.00','8','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 10:31:11','2.520','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-ZHAD-8-0','00031078');
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 ('2026-08-14','MDGL-ZHAD-8-0','MDGL','TOKO','INPUT1','100.00','2.530','2.520','1','2.530','2.520','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-ZHAD-9-0','00031079','EX ','GL PIPA BT UBS ','','GR','---','MD','MDGL','TOKO','INPUT1','11793000','2026-08-14','11793000','10.390','100.00','8','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 10:33:00','10.380','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-ZHAD-9-0','00031079');
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 ('2026-08-14','MDGL-ZHAD-9-0','MDGL','TOKO','INPUT1','100.00','10.390','10.380','1','10.390','10.380','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-ZHAD-10-0','00031080','EX ','GL PIPA BT UBS ','','GR','---','MD','MDGL','TOKO','INPUT1','10646500','2026-08-14','10646500','9.380','100.00','8','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 10:39:39','9.370','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-ZHAD-10-0','00031080');
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 ('2026-08-14','MDGL-ZHAD-10-0','MDGL','TOKO','INPUT1','100.00','9.380','9.370','1','9.380','9.370','1');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-14 ','10:43:37');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-ZHAD-11-0','00031081','EX ','GL PIPA BT SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','9659000','2026-08-14','9659000','8.510','100.00','8','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 10:45:57','8.500','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-ZHAD-11-0','00031081');
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 ('2026-08-14','MDGL-ZHAD-11-0','MDGL','TOKO','INPUT1','100.00','8.510','8.500','1','8.510','8.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 ('MDGL-ZHAD-12-0','00031082',' ','GL COR 18CM LC2 ','','GR','---','MD','MDGL','TOKO','INPUT1','23869500','2026-08-14','23869500','21.030','100.00','8','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 10:48:53','21.020','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-ZHAD-12-0','00031082');
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 ('2026-08-14','MDGL-ZHAD-12-0','MDGL','TOKO','INPUT1','100.00','21.030','21.020','1','21.030','21.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 ('MDGL-ZHAD-13-0','00031083',' ','GL CAP HOLO 18CM SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','12394500','2026-08-14','12394500','10.920','100.00','8','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 10:50:36','10.910','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-ZHAD-13-0','00031083');
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 ('2026-08-14','MDGL-ZHAD-13-0','MDGL','TOKO','INPUT1','100.00','10.920','10.910','1','10.920','10.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 ('MDGL-ZHAD-14-0','00031084',' ','GL ITALY ST VAR 17CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','2327000','2026-08-14','2327000','2.050','100.00','8','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 10:53:47','2.040','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-ZHAD-14-0','00031084');
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 ('2026-08-14','MDGL-ZHAD-14-0','MDGL','TOKO','INPUT1','100.00','2.050','2.040','1','2.050','2.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 ('MDGL-ZHAD-15-0','00031085',' ','GL ITALY ST VAR 17CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','2338500','2026-08-14','2338500','2.060','100.00','8','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 10:54:26','2.050','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-ZHAD-15-0','00031085');
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 ('2026-08-14','MDGL-ZHAD-15-0','MDGL','TOKO','INPUT1','100.00','2.060','2.050','1','2.060','2.050','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-ZHAD-16-0','00031086',' ','GL HL POLES 18CM SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','16946000','2026-08-14','16946000','14.930','100.00','8','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 10:59:18','14.920','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-ZHAD-16-0','00031086');
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 ('2026-08-14','MDGL-ZHAD-16-0','MDGL','TOKO','INPUT1','100.00','14.930','14.920','1','14.930','14.920','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-ZHAD-17-0','00031087',' ','GL HL POLES 21CM SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','29919000','2026-08-14','29919000','26.360','100.00','8','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 11:02:33','26.350','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-ZHAD-17-0','00031087');
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 ('2026-08-14','MDGL-ZHAD-17-0','MDGL','TOKO','INPUT1','100.00','26.360','26.350','1','26.360','26.350','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-ZHAD-18-0','00031088',' ','GL KPNG 17CM UBS ','','GR','---','MD','MDGL','TOKO','INPUT1','22927000','2026-08-14','22927000','20.200','100.00','8','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 11:05:46','20.190','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-ZHAD-18-0','00031088');
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 ('2026-08-14','MDGL-ZHAD-18-0','MDGL','TOKO','INPUT1','100.00','20.200','20.190','1','20.200','20.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 ('MDGL-ZHAD-19-0','00031089',' ','GL PIPA TDK BT UBS ','','GR','---','MD','MDGL','TOKO','INPUT1','5561500','2026-08-14','5561500','4.900','100.00','8','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 11:07:12','4.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-ZHAD-19-0','00031089');
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 ('2026-08-14','MDGL-ZHAD-19-0','MDGL','TOKO','INPUT1','100.00','4.900','4.890','1','4.900','4.890','1');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-14 ','11:38:24');
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 ('MDGL-ZHAD-4-0','00031074','00031074','GL KRC PLNTR SMBR PRH 6 SHB ','GL KRC PLNTR SMBR PTH 6 SHB','','','22507500','22507500',' 0','0','adminpusat','2026-08-14 11:57:05');
UPDATE tm_barang SET nama_barang='GL KRC PLNTR SMBR PTH 6 SHB' ,nama_atribut='' ,kode_intern='EX ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MDGL-ZHAD-4-0' LIMIT 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-ZHAD-20-0','00031090','EX ','GL RANGKAIAN COR 19CM KKT PER LC2 ','','GR','---','MD','MDGL','TOKO','INPUT1','5845500','2026-08-14','5845500','5.150','100.00','8','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 12:06:04','5.140','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-ZHAD-20-0','00031090');
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 ('2026-08-14','MDGL-ZHAD-20-0','MDGL','TOKO','INPUT1','100.00','5.150','5.140','1','5.150','5.140','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-ZHAD-21-0','00031091','PM ','GL KPNG 3WRN KKT PER UBS ','PM','GR','---','MD','MDGL','TOKO','INPUT1','4619500','2026-08-14','4619500','4.070','100.00','8','306000','1135000.00','1','0.045', 'adminpusat','2026-08-14 12:08:50','4.060','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-ZHAD-21-0','00031091');
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 ('2026-08-14','MDGL-ZHAD-21-0','MDGL','TOKO','INPUT1','100.00','4.070','4.060','1','4.070','4.060','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-260814-0002','1','MDGL-ZHAD-2-0','1','5.280','5.280','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZHAD-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('2026-08-14','TOKO','BGLMD','MDGL','MDGL-ZHAD-2-0','100.00','1','5.280','5.270','1','5.280','5.270');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.280',berat_out_asli=berat_out_asli+'5.270',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MDGL-ZHAD-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-260814-0002','2','MDGL-ZHAD-3-0','1','8.070','8.070','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZHAD-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('2026-08-14','TOKO','BGLMD','MDGL','MDGL-ZHAD-3-0','100.00','1','8.070','8.060','1','8.070','8.060');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'8.070',berat_out_asli=berat_out_asli+'8.060',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MDGL-ZHAD-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-260814-0002','3','MDGL-ZHAD-4-0','1','19.830','19.830','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZHAD-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('2026-08-14','TOKO','BGLMD','MDGL','MDGL-ZHAD-4-0','100.00','1','19.830','19.820','1','19.830','19.820');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'19.830',berat_out_asli=berat_out_asli+'19.820',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MDGL-ZHAD-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-260814-0002','4','MDGL-ZHAD-5-0','1','17.360','17.360','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZHAD-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('2026-08-14','TOKO','BGLMD','MDGL','MDGL-ZHAD-5-0','100.00','1','17.360','17.350','1','17.360','17.350');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'17.360',berat_out_asli=berat_out_asli+'17.350',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MDGL-ZHAD-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260814-0002','5','MDGL-ZHAD-6-0','1','6.080','6.080','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZHAD-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('2026-08-14','TOKO','BGLMD','MDGL','MDGL-ZHAD-6-0','100.00','1','6.080','6.070','1','6.080','6.070');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'6.080',berat_out_asli=berat_out_asli+'6.070',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MDGL-ZHAD-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-260814-0002','6','MDGL-ZHAD-7-0','1','2.940','2.940','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZHAD-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('2026-08-14','TOKO','BGLMD','MDGL','MDGL-ZHAD-7-0','100.00','1','2.940','2.930','1','2.940','2.930');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.940',berat_out_asli=berat_out_asli+'2.930',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MDGL-ZHAD-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-260814-0002','7','MDGL-ZHAD-8-0','1','2.530','2.530','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZHAD-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('2026-08-14','TOKO','BGLMD','MDGL','MDGL-ZHAD-8-0','100.00','1','2.530','2.520','1','2.530','2.520');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.530',berat_out_asli=berat_out_asli+'2.520',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MDGL-ZHAD-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-260814-0002','8','MDGL-ZHAD-9-0','1','10.390','10.390','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZHAD-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('2026-08-14','TOKO','BGLMD','MDGL','MDGL-ZHAD-9-0','100.00','1','10.390','10.380','1','10.390','10.380');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'10.390',berat_out_asli=berat_out_asli+'10.380',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MDGL-ZHAD-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-260814-0002','9','MDGL-ZHAD-10-0','1','9.380','9.380','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZHAD-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('2026-08-14','TOKO','BGLMD','MDGL','MDGL-ZHAD-10-0','100.00','1','9.380','9.370','1','9.380','9.370');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'9.380',berat_out_asli=berat_out_asli+'9.370',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MDGL-ZHAD-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-260814-0002','10','MDGL-ZHAD-11-0','1','8.510','8.510','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZHAD-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('2026-08-14','TOKO','BGLMD','MDGL','MDGL-ZHAD-11-0','100.00','1','8.510','8.500','1','8.510','8.500');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'8.510',berat_out_asli=berat_out_asli+'8.500',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MDGL-ZHAD-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260814-0002','11','MDGL-ZHAD-12-0','1','21.030','21.030','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZHAD-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('2026-08-14','TOKO','BGLMD','MDGL','MDGL-ZHAD-12-0','100.00','1','21.030','21.020','1','21.030','21.020');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'21.030',berat_out_asli=berat_out_asli+'21.020',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MDGL-ZHAD-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-260814-0002','12','MDGL-ZHAD-13-0','1','10.920','10.920','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZHAD-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('2026-08-14','TOKO','BGLMD','MDGL','MDGL-ZHAD-13-0','100.00','1','10.920','10.910','1','10.920','10.910');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'10.920',berat_out_asli=berat_out_asli+'10.910',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MDGL-ZHAD-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-260814-0002','13','MDGL-ZHAD-14-0','1','2.050','2.050','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZHAD-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('2026-08-14','TOKO','BGLMD','MDGL','MDGL-ZHAD-14-0','100.00','1','2.050','2.040','1','2.050','2.040');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.050',berat_out_asli=berat_out_asli+'2.040',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MDGL-ZHAD-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-260814-0002','14','MDGL-ZHAD-15-0','1','2.060','2.060','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZHAD-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('2026-08-14','TOKO','BGLMD','MDGL','MDGL-ZHAD-15-0','100.00','1','2.060','2.050','1','2.060','2.050');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.060',berat_out_asli=berat_out_asli+'2.050',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MDGL-ZHAD-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-260814-0002','15','MDGL-ZHAD-16-0','1','14.930','14.930','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZHAD-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('2026-08-14','TOKO','BGLMD','MDGL','MDGL-ZHAD-16-0','100.00','1','14.930','14.920','1','14.930','14.920');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'14.930',berat_out_asli=berat_out_asli+'14.920',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MDGL-ZHAD-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-260814-0002','16','MDGL-ZHAD-17-0','1','26.360','26.360','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZHAD-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('2026-08-14','TOKO','BGLMD','MDGL','MDGL-ZHAD-17-0','100.00','1','26.360','26.350','1','26.360','26.350');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'26.360',berat_out_asli=berat_out_asli+'26.350',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MDGL-ZHAD-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260814-0002','17','MDGL-ZHAD-18-0','1','20.200','20.200','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZHAD-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('2026-08-14','TOKO','BGLMD','MDGL','MDGL-ZHAD-18-0','100.00','1','20.200','20.190','1','20.200','20.190');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'20.200',berat_out_asli=berat_out_asli+'20.190',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MDGL-ZHAD-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-260814-0002','18','MDGL-ZHAD-19-0','1','4.900','4.900','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZHAD-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('2026-08-14','TOKO','BGLMD','MDGL','MDGL-ZHAD-19-0','100.00','1','4.900','4.890','1','4.900','4.890');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.900',berat_out_asli=berat_out_asli+'4.890',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MDGL-ZHAD-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-260814-0002','19','MDGL-ZHAD-20-0','1','5.150','5.150','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZHAD-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('2026-08-14','TOKO','BGLMD','MDGL','MDGL-ZHAD-20-0','100.00','1','5.150','5.140','1','5.150','5.140');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.150',berat_out_asli=berat_out_asli+'5.140',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MDGL-ZHAD-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-260814-0002','20','MDGL-ZHAD-21-0','1','4.070','4.070','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZHAD-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('2026-08-14','TOKO','BGLMD','MDGL','MDGL-ZHAD-21-0','100.00','1','4.070','4.060','1','4.070','4.060');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.070',berat_out_asli=berat_out_asli+'4.060',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MDGL-ZHAD-21-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-260814-0002','2026-08-14','2026-08-14','12:16','202.04','adminpusat','2026-08-14 12:18: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 ('MSCN-ZHAD-22-0','00031092',' ','CN COR BT SHB ','','GR','---','MS','MSCN','TOKO','INPUT1','1317000','2026-08-14','1317000','1.160','100.00','9','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 12:38:12','1.150','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSCN','MSCN-ZHAD-22-0','00031092');
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 ('2026-08-14','MSCN-ZHAD-22-0','MSCN','TOKO','INPUT1','100.00','1.160','1.150','1','1.160','1.150','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 ('MSCN-ZHAD-23-0','00031093',' ','CN COR BT SHB ','','GR','---','MS','MSCN','TOKO','INPUT1','1294000','2026-08-14','1294000','1.140','100.00','9','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 12:39:33','1.130','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSCN','MSCN-ZHAD-23-0','00031093');
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 ('2026-08-14','MSCN-ZHAD-23-0','MSCN','TOKO','INPUT1','100.00','1.140','1.130','1','1.140','1.130','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 ('MSCN-ZHAD-24-0','00031094',' ','CN COR BT SHB ','','GR','---','MS','MSCN','TOKO','INPUT1','1056000','2026-08-14','1056000','0.930','100.00','9','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 12:40:49','0.920','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSCN','MSCN-ZHAD-24-0','00031094');
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 ('2026-08-14','MSCN-ZHAD-24-0','MSCN','TOKO','INPUT1','100.00','0.930','0.920','1','0.930','0.920','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MSCN-ZHAD-25-0','00031095',' ','CN COR BT SHB ','','GR','---','MS','MSCN','TOKO','INPUT1','1612000','2026-08-14','1612000','1.420','100.00','9','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 12:42:16','1.410','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSCN','MSCN-ZHAD-25-0','00031095');
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 ('2026-08-14','MSCN-ZHAD-25-0','MSCN','TOKO','INPUT1','100.00','1.420','1.410','1','1.420','1.410','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MSCN-ZHAD-26-0','00031096',' ','CN COR BT MK ','','GR','---','MS','MSCN','TOKO','INPUT1','1317000','2026-08-14','1317000','1.160','100.00','9','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 12:43:29','1.150','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSCN','MSCN-ZHAD-26-0','00031096');
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 ('2026-08-14','MSCN-ZHAD-26-0','MSCN','TOKO','INPUT1','100.00','1.160','1.150','1','1.160','1.150','1');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-14 ','12:44:30');
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 ('MSCN-ZHAD-27-0','00031097','EX ','CN COR BT MK ','','GR','---','MS','MSCN','TOKO','INPUT1','874000','2026-08-14','874000','0.770','100.00','9','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 12:45:38','0.760','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSCN','MSCN-ZHAD-27-0','00031097');
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 ('2026-08-14','MSCN-ZHAD-27-0','MSCN','TOKO','INPUT1','100.00','0.770','0.760','1','0.770','0.760','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 ('MSCN-ZHAD-28-0','00031098','EX ','CN COR BT SHB ','','GR','---','MS','MSCN','TOKO','INPUT1','1010500','2026-08-14','1010500','0.890','100.00','9','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 12:47:03','0.880','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSCN','MSCN-ZHAD-28-0','00031098');
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 ('2026-08-14','MSCN-ZHAD-28-0','MSCN','TOKO','INPUT1','100.00','0.890','0.880','1','0.890','0.880','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-260814-0003','1','MSCN-ZHAD-22-0','1','1.160','1.160','TOKO','INPUT1','TOKO','BCNMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMS' WHERE kode_barang='MSCN-ZHAD-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('2026-08-14','TOKO','BCNMS','MSCN','MSCN-ZHAD-22-0','100.00','1','1.160','1.150','1','1.160','1.150');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.160',berat_out_asli=berat_out_asli+'1.150',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-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-260814-0003','2','MSCN-ZHAD-23-0','1','1.140','1.140','TOKO','INPUT1','TOKO','BCNMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMS' WHERE kode_barang='MSCN-ZHAD-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('2026-08-14','TOKO','BCNMS','MSCN','MSCN-ZHAD-23-0','100.00','1','1.140','1.130','1','1.140','1.130');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.140',berat_out_asli=berat_out_asli+'1.130',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260814-0003','3','MSCN-ZHAD-24-0','1','0.930','0.930','TOKO','INPUT1','TOKO','BCNMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMS' WHERE kode_barang='MSCN-ZHAD-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('2026-08-14','TOKO','BCNMS','MSCN','MSCN-ZHAD-24-0','100.00','1','0.930','0.920','1','0.930','0.920');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.930',berat_out_asli=berat_out_asli+'0.920',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-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-260814-0003','4','MSCN-ZHAD-25-0','1','1.420','1.420','TOKO','INPUT1','TOKO','BCNMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMS' WHERE kode_barang='MSCN-ZHAD-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('2026-08-14','TOKO','BCNMS','MSCN','MSCN-ZHAD-25-0','100.00','1','1.420','1.410','1','1.420','1.410');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.420',berat_out_asli=berat_out_asli+'1.410',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-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-260814-0003','5','MSCN-ZHAD-26-0','1','1.160','1.160','TOKO','INPUT1','TOKO','BCNMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMS' WHERE kode_barang='MSCN-ZHAD-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('2026-08-14','TOKO','BCNMS','MSCN','MSCN-ZHAD-26-0','100.00','1','1.160','1.150','1','1.160','1.150');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.160',berat_out_asli=berat_out_asli+'1.150',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-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-260814-0003','6','MSCN-ZHAD-27-0','1','0.770','0.770','TOKO','INPUT1','TOKO','BCNMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMS' WHERE kode_barang='MSCN-ZHAD-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('2026-08-14','TOKO','BCNMS','MSCN','MSCN-ZHAD-27-0','100.00','1','0.770','0.760','1','0.770','0.760');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.770',berat_out_asli=berat_out_asli+'0.760',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-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-260814-0003','7','MSCN-ZHAD-28-0','1','0.890','0.890','TOKO','INPUT1','TOKO','BCNMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMS' WHERE kode_barang='MSCN-ZHAD-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('2026-08-14','TOKO','BCNMS','MSCN','MSCN-ZHAD-28-0','100.00','1','0.890','0.880','1','0.890','0.880');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.890',berat_out_asli=berat_out_asli+'0.880',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-28-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-260814-0003','2026-08-14','2026-08-14','12:55','7.47','adminpusat','2026-08-14 12:55:57');
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-260814-0004','1','MSCN-ZHAD-22-0','1','1.160','1.160','TOKO','BCNMS','TOKO','INPUT1');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='INPUT1' WHERE kode_barang='MSCN-ZHAD-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BCNMS';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'1.160',berat_in_asli=berat_in_asli+'1.150',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'1.160',berat_akhir_asli=berat_akhir_asli+'1.150' WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.160',berat_out_asli=berat_out_asli+'1.150',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BCNMS' 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-260814-0004','2','MSCN-ZHAD-23-0','1','1.140','1.140','TOKO','BCNMS','TOKO','INPUT1');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='INPUT1' WHERE kode_barang='MSCN-ZHAD-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BCNMS';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'1.140',berat_in_asli=berat_in_asli+'1.130',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'1.140',berat_akhir_asli=berat_akhir_asli+'1.130' WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.140',berat_out_asli=berat_out_asli+'1.130',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BCNMS' 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-260814-0004','3','MSCN-ZHAD-24-0','1','0.930','0.930','TOKO','BCNMS','TOKO','INPUT1');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='INPUT1' WHERE kode_barang='MSCN-ZHAD-24-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BCNMS';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'0.930',berat_in_asli=berat_in_asli+'0.920',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'0.930',berat_akhir_asli=berat_akhir_asli+'0.920' WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-24-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.930',berat_out_asli=berat_out_asli+'0.920',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-24-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BCNMS' 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-260814-0004','4','MSCN-ZHAD-25-0','1','1.420','1.420','TOKO','BCNMS','TOKO','INPUT1');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='INPUT1' WHERE kode_barang='MSCN-ZHAD-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BCNMS';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'1.420',berat_in_asli=berat_in_asli+'1.410',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'1.420',berat_akhir_asli=berat_akhir_asli+'1.410' WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.420',berat_out_asli=berat_out_asli+'1.410',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BCNMS' 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-260814-0004','5','MSCN-ZHAD-26-0','1','1.160','1.160','TOKO','BCNMS','TOKO','INPUT1');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='INPUT1' WHERE kode_barang='MSCN-ZHAD-26-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BCNMS';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'1.160',berat_in_asli=berat_in_asli+'1.150',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'1.160',berat_akhir_asli=berat_akhir_asli+'1.150' WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-26-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.160',berat_out_asli=berat_out_asli+'1.150',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-26-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BCNMS' 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-260814-0004','6','MSCN-ZHAD-27-0','1','0.770','0.770','TOKO','BCNMS','TOKO','INPUT1');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='INPUT1' WHERE kode_barang='MSCN-ZHAD-27-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BCNMS';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'0.770',berat_in_asli=berat_in_asli+'0.760',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'0.770',berat_akhir_asli=berat_akhir_asli+'0.760' WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-27-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.770',berat_out_asli=berat_out_asli+'0.760',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-27-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BCNMS' 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-260814-0004','7','MSCN-ZHAD-28-0','1','0.890','0.890','TOKO','BCNMS','TOKO','INPUT1');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='INPUT1' WHERE kode_barang='MSCN-ZHAD-28-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BCNMS';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'0.890',berat_in_asli=berat_in_asli+'0.880',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'0.890',berat_akhir_asli=berat_akhir_asli+'0.880' WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-28-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.890',berat_out_asli=berat_out_asli+'0.880',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-28-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BCNMS' 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-260814-0004','2026-08-14','2026-08-14','12:58','7.47','adminpusat','2026-08-14 12:58: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-260814-0005','1','MSCN-ZHAD-22-0','1','1.160','1.160','TOKO','INPUT1','TOKO','BCNMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMS' WHERE kode_barang='MSCN-ZHAD-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'1.160',berat_in_asli=berat_in_asli+'1.150',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'1.160',berat_akhir_asli=berat_akhir_asli+'1.150' WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BCNMS';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.160',berat_out_asli=berat_out_asli+'1.150',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-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-260814-0005','2','MSCN-ZHAD-23-0','1','1.140','1.140','TOKO','INPUT1','TOKO','BCNMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMS' WHERE kode_barang='MSCN-ZHAD-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'1.140',berat_in_asli=berat_in_asli+'1.130',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'1.140',berat_akhir_asli=berat_akhir_asli+'1.130' WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BCNMS';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.140',berat_out_asli=berat_out_asli+'1.130',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260814-0005','3','MSCN-ZHAD-24-0','1','0.930','0.930','TOKO','INPUT1','TOKO','BCNMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMS' WHERE kode_barang='MSCN-ZHAD-24-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'0.930',berat_in_asli=berat_in_asli+'0.920',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'0.930',berat_akhir_asli=berat_akhir_asli+'0.920' WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-24-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BCNMS';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.930',berat_out_asli=berat_out_asli+'0.920',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-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-260814-0005','4','MSCN-ZHAD-25-0','1','1.420','1.420','TOKO','INPUT1','TOKO','BCNMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMS' WHERE kode_barang='MSCN-ZHAD-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'1.420',berat_in_asli=berat_in_asli+'1.410',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'1.420',berat_akhir_asli=berat_akhir_asli+'1.410' WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BCNMS';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.420',berat_out_asli=berat_out_asli+'1.410',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-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-260814-0005','5','MSCN-ZHAD-26-0','1','1.160','1.160','TOKO','INPUT1','TOKO','BCNMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMS' WHERE kode_barang='MSCN-ZHAD-26-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'1.160',berat_in_asli=berat_in_asli+'1.150',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'1.160',berat_akhir_asli=berat_akhir_asli+'1.150' WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-26-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BCNMS';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.160',berat_out_asli=berat_out_asli+'1.150',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-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-260814-0005','6','MSCN-ZHAD-27-0','1','0.770','0.770','TOKO','INPUT1','TOKO','BCNMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMS' WHERE kode_barang='MSCN-ZHAD-27-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'0.770',berat_in_asli=berat_in_asli+'0.760',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'0.770',berat_akhir_asli=berat_akhir_asli+'0.760' WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-27-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BCNMS';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.770',berat_out_asli=berat_out_asli+'0.760',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-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-260814-0005','7','MSCN-ZHAD-28-0','1','0.890','0.890','TOKO','INPUT1','TOKO','BCNMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMS' WHERE kode_barang='MSCN-ZHAD-28-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'0.890',berat_in_asli=berat_in_asli+'0.880',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'0.890',berat_akhir_asli=berat_akhir_asli+'0.880' WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-28-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BCNMS';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.890',berat_out_asli=berat_out_asli+'0.880',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSCN-ZHAD-28-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-260814-0005','2026-08-14','2026-08-14','12:59','7.47','adminpusat','2026-08-14 12:59:55');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-14 ','13:01:27');
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 ('MSKL-ZHAD-29-0','00031099','EX ','KL MILANO VAR BT 42CM KKT S UBS ','','GR','---','MS','MSKL','TOKO','BATMD','8637500','2026-08-14','8637500','7.610','100.00','9','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 13:06:35','7.600','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSKL','MSKL-ZHAD-29-0','00031099');
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 ('2026-08-14','MSKL-ZHAD-29-0','MSKL','TOKO','BATMD','100.00','7.610','7.600','1','7.610','7.600','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-260814-0006','1','MSKL-ZHAD-29-0','1','7.610','7.610','TOKO','BATMD','TOKO','INPUT1');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='INPUT1' WHERE kode_barang='MSKL-ZHAD-29-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BATMD';
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('2026-08-14','TOKO','INPUT1','MSKL','MSKL-ZHAD-29-0','100.00','1','7.610','7.600','1','7.610','7.600');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'7.610',berat_out_asli=berat_out_asli+'7.600',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSKL-ZHAD-29-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BATMD' 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-260814-0006','2026-08-14','2026-08-14','13:07','7.61','adminpusat','2026-08-14 13:07:47');
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 ('MSKL-ZHAD-30-0','00031100','EX ','KL VAR BT 43CM KKT S UBS ','','GR','---','MS','MSKL','TOKO','INPUT1','11384500','2026-08-14','11384500','10.030','100.00','9','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 13:11:08','10.020','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSKL','MSKL-ZHAD-30-0','00031100');
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 ('2026-08-14','MSKL-ZHAD-30-0','MSKL','TOKO','INPUT1','100.00','10.030','10.020','1','10.030','10.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 ('MSKL-ZHAD-31-0','00031101','EX ','KL BTR VAR BT 44CM KKT S HWT ','','GR','---','MS','MSKL','TOKO','INPUT1','12462500','2026-08-14','12462500','10.980','100.00','9','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 13:12:58','10.970','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSKL','MSKL-ZHAD-31-0','00031101');
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 ('2026-08-14','MSKL-ZHAD-31-0','MSKL','TOKO','INPUT1','100.00','10.980','10.970','1','10.980','10.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 ('MSKL-ZHAD-32-0','00031102','EX ','KL ITALY ST VAR BT 42CM KKT S HWT ','','GR','---','MS','MSKL','TOKO','INPUT1','9137000','2026-08-14','9137000','8.050','100.00','9','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 13:14:34','8.040','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSKL','MSKL-ZHAD-32-0','00031102');
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 ('2026-08-14','MSKL-ZHAD-32-0','MSKL','TOKO','INPUT1','100.00','8.050','8.040','1','8.050','8.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 ('MSKL-ZHAD-33-0','00031103','EX ','KL MILANO BLT VAR BT 43CM KKT S UBS ','','GR','---','MS','MSKL','TOKO','INPUT1','4824000','2026-08-14','4824000','4.250','100.00','9','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 13:18:12','4.240','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSKL','MSKL-ZHAD-33-0','00031103');
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 ('2026-08-14','MSKL-ZHAD-33-0','MSKL','TOKO','INPUT1','100.00','4.250','4.240','1','4.250','4.240','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MSKL-ZHAD-34-0','00031104','EX ','KL MILANO BLT VAR BT 43CM KKT S UBS ','','GR','---','MS','MSKL','TOKO','INPUT1','4756000','2026-08-14','4756000','4.190','100.00','9','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 13:19:27','4.180','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSKL','MSKL-ZHAD-34-0','00031104');
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 ('2026-08-14','MSKL-ZHAD-34-0','MSKL','TOKO','INPUT1','100.00','4.190','4.180','1','4.190','4.180','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 ('MSKL-ZHAD-35-0','00031105','EX ','KL CEMET 42CM KKT S HWT ','','GR','---','MS','MSKL','TOKO','INPUT1','5573000','2026-08-14','5573000','4.910','100.00','9','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 13:20:57','4.900','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSKL','MSKL-ZHAD-35-0','00031105');
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 ('2026-08-14','MSKL-ZHAD-35-0','MSKL','TOKO','INPUT1','100.00','4.910','4.900','1','4.910','4.900','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MSKL-ZHAD-36-0','00031106','EX ','KL MILANO ANAK 34CM KKT PER BLT SHB ','','GR','---','MS','MSKL','TOKO','INPUT1','2315500','2026-08-14','2315500','2.040','100.00','9','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 13:23:28','2.030','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSKL','MSKL-ZHAD-36-0','00031106');
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 ('2026-08-14','MSKL-ZHAD-36-0','MSKL','TOKO','INPUT1','100.00','2.040','2.030','1','2.040','2.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 ('MSKL-ZHAD-37-0','00031107','EX ','KL MILANO ANAK 33CM KKT S SHB ','','GR','---','MS','MSKL','TOKO','INPUT1','4461000','2026-08-14','4461000','3.930','100.00','9','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 13:25:10','3.920','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSKL','MSKL-ZHAD-37-0','00031107');
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 ('2026-08-14','MSKL-ZHAD-37-0','MSKL','TOKO','INPUT1','100.00','3.930','3.920','1','3.930','3.920','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MSKL-ZHAD-38-0','00031108','EX ','KL MILANO ANAK 34CM KKT S SHB ','','GR','---','MS','MSKL','TOKO','INPUT1','2610500','2026-08-14','2610500','2.300','100.00','9','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 13:25:57','2.290','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSKL','MSKL-ZHAD-38-0','00031108');
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 ('2026-08-14','MSKL-ZHAD-38-0','MSKL','TOKO','INPUT1','100.00','2.300','2.290','1','2.300','2.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 ('MSKL-ZHAD-39-0','00031109','EX ','KL MILANO ANAK 34CM KKT S SHB ','','GR','---','MS','MSKL','TOKO','INPUT1','3360000','2026-08-14','3360000','2.960','100.00','9','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 13:26:57','2.950','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSKL','MSKL-ZHAD-39-0','00031109');
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 ('2026-08-14','MSKL-ZHAD-39-0','MSKL','TOKO','INPUT1','100.00','2.960','2.950','1','2.960','2.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 ('MSKL-ZHAD-40-0','00031110','EX ','KL MILANO ANAK 33CM KKT S SHB ','','GR','---','MS','MSKL','TOKO','INPUT1','4517500','2026-08-14','4517500','3.980','100.00','9','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 13:28:05','3.970','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSKL','MSKL-ZHAD-40-0','00031110');
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 ('2026-08-14','MSKL-ZHAD-40-0','MSKL','TOKO','INPUT1','100.00','3.980','3.970','1','3.980','3.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 ('MSKL-ZHAD-41-0','00031111','EX ','KL MILANO ANAK 33CM KKT S SHB ','','GR','---','MS','MSKL','TOKO','INPUT1','5221000','2026-08-14','5221000','4.600','100.00','9','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 13:29:03','4.590','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSKL','MSKL-ZHAD-41-0','00031111');
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 ('2026-08-14','MSKL-ZHAD-41-0','MSKL','TOKO','INPUT1','100.00','4.600','4.590','1','4.600','4.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 ('MSKL-ZHAD-42-0','00031112',' ','KL ITALY ST ANAK 34CM KKT PER BLT SHB ','','GR','---','MS','MSKL','TOKO','INPUT1','2962500','2026-08-14','2962500','2.610','100.00','9','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 13:30:16','2.600','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSKL','MSKL-ZHAD-42-0','00031112');
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 ('2026-08-14','MSKL-ZHAD-42-0','MSKL','TOKO','INPUT1','100.00','2.610','2.600','1','2.610','2.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 ('MSKL-ZHAD-43-0','00031113',' ','KL ITALY ST ANAK 34CM KKT PER BLT SHB ','','GR','---','MS','MSKL','TOKO','INPUT1','2951000','2026-08-14','2951000','2.600','100.00','9','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 13:31:07','2.590','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSKL','MSKL-ZHAD-43-0','00031113');
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 ('2026-08-14','MSKL-ZHAD-43-0','MSKL','TOKO','INPUT1','100.00','2.600','2.590','1','2.600','2.590','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MSKL-ZHAD-44-0','00031114',' ','KL ITALY ST ANAK 34CM KKT PER BLT SHB ','','GR','---','MS','MSKL','TOKO','INPUT1','2906000','2026-08-14','2906000','2.560','100.00','9','0','1135000.00','1','0.045', 'adminpusat','2026-08-14 13:33:15','2.550','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSKL','MSKL-ZHAD-44-0','00031114');
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 ('2026-08-14','MSKL-ZHAD-44-0','MSKL','TOKO','INPUT1','100.00','2.560','2.550','1','2.560','2.550','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 ('MSKL-ZHAD-45-0','00031115','KS ','KL TALIA SMBR PTH 45CM KKT PER UBS ','KS','GR','---','MS','MSKL','TOKO','INPUT1','9171000','2026-08-14','9171000','8.080','100.00','9','606000','1135000.00','1','0.045', 'adminpusat','2026-08-14 13:36:39','8.070','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSKL','MSKL-ZHAD-45-0','00031115');
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 ('2026-08-14','MSKL-ZHAD-45-0','MSKL','TOKO','INPUT1','100.00','8.080','8.070','1','8.080','8.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 ('MSKL-ZHAD-46-0','00031116','KS ','KL TALIA SMBR PTH 43CM KKT PER UBS ','KS','GR','---','MS','MSKL','TOKO','INPUT1','9046000','2026-08-14','9046000','7.970','100.00','9','598000','1135000.00','1','0.045', 'adminpusat','2026-08-14 13:38:32','7.960','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSKL','MSKL-ZHAD-46-0','00031116');
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 ('2026-08-14','MSKL-ZHAD-46-0','MSKL','TOKO','INPUT1','100.00','7.970','7.960','1','7.970','7.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 ('MSKL-ZHAD-47-0','00031117','KS ','KL TALIA SMBR PTH 46CM KKT PER BLT UBS ','KS','GR','---','MS','MSKL','TOKO','INPUT1','7139500','2026-08-14','7139500','6.290','100.00','9','472000','1135000.00','1','0.045', 'adminpusat','2026-08-14 13:40:06','6.280','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSKL','MSKL-ZHAD-47-0','00031117');
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 ('2026-08-14','MSKL-ZHAD-47-0','MSKL','TOKO','INPUT1','100.00','6.290','6.280','1','6.290','6.280','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 ('MSKL-ZHAD-48-0','00031118','KS ','KL TALIA SMBR PTH 43CM KKT PER BLT UBS ','KS','GR','---','MS','MSKL','TOKO','INPUT1','6833000','2026-08-14','6833000','6.020','100.00','9','452000','1135000.00','1','0.045', 'adminpusat','2026-08-14 13:41:19','6.010','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSKL','MSKL-ZHAD-48-0','00031118');
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 ('2026-08-14','MSKL-ZHAD-48-0','MSKL','TOKO','INPUT1','100.00','6.020','6.010','1','6.020','6.010','1');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-14 ','14:49:34');
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-260814-0007','1','MSKL-ZHAD-29-0','1','7.610','7.610','TOKO','INPUT1','TOKO','BKLMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMS' WHERE kode_barang='MSKL-ZHAD-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('2026-08-14','TOKO','BKLMS','MSKL','MSKL-ZHAD-29-0','100.00','1','7.610','7.600','1','7.610','7.600');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'7.610',berat_out_asli=berat_out_asli+'7.600',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSKL-ZHAD-29-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260814-0007','2','MSKL-ZHAD-30-0','1','10.030','10.030','TOKO','INPUT1','TOKO','BKLMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMS' WHERE kode_barang='MSKL-ZHAD-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('2026-08-14','TOKO','BKLMS','MSKL','MSKL-ZHAD-30-0','100.00','1','10.030','10.020','1','10.030','10.020');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'10.030',berat_out_asli=berat_out_asli+'10.020',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSKL-ZHAD-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-260814-0007','3','MSKL-ZHAD-31-0','1','10.980','10.980','TOKO','INPUT1','TOKO','BKLMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMS' WHERE kode_barang='MSKL-ZHAD-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('2026-08-14','TOKO','BKLMS','MSKL','MSKL-ZHAD-31-0','100.00','1','10.980','10.970','1','10.980','10.970');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'10.980',berat_out_asli=berat_out_asli+'10.970',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSKL-ZHAD-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-260814-0007','4','MSKL-ZHAD-32-0','1','8.050','8.050','TOKO','INPUT1','TOKO','BKLMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMS' WHERE kode_barang='MSKL-ZHAD-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('2026-08-14','TOKO','BKLMS','MSKL','MSKL-ZHAD-32-0','100.00','1','8.050','8.040','1','8.050','8.040');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'8.050',berat_out_asli=berat_out_asli+'8.040',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSKL-ZHAD-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-260814-0007','5','MSKL-ZHAD-33-0','1','4.250','4.250','TOKO','INPUT1','TOKO','BKLMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMS' WHERE kode_barang='MSKL-ZHAD-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('2026-08-14','TOKO','BKLMS','MSKL','MSKL-ZHAD-33-0','100.00','1','4.250','4.240','1','4.250','4.240');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.250',berat_out_asli=berat_out_asli+'4.240',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSKL-ZHAD-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-260814-0007','6','MSKL-ZHAD-34-0','1','4.190','4.190','TOKO','INPUT1','TOKO','BKLMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMS' WHERE kode_barang='MSKL-ZHAD-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('2026-08-14','TOKO','BKLMS','MSKL','MSKL-ZHAD-34-0','100.00','1','4.190','4.180','1','4.190','4.180');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.190',berat_out_asli=berat_out_asli+'4.180',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSKL-ZHAD-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-260814-0007','7','MSKL-ZHAD-35-0','1','4.910','4.910','TOKO','INPUT1','TOKO','BKLMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMS' WHERE kode_barang='MSKL-ZHAD-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('2026-08-14','TOKO','BKLMS','MSKL','MSKL-ZHAD-35-0','100.00','1','4.910','4.900','1','4.910','4.900');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.910',berat_out_asli=berat_out_asli+'4.900',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSKL-ZHAD-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-260814-0007','8','MSKL-ZHAD-36-0','1','2.040','2.040','TOKO','INPUT1','TOKO','BKLMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMS' WHERE kode_barang='MSKL-ZHAD-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('2026-08-14','TOKO','BKLMS','MSKL','MSKL-ZHAD-36-0','100.00','1','2.040','2.030','1','2.040','2.030');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.040',berat_out_asli=berat_out_asli+'2.030',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSKL-ZHAD-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-260814-0007','9','MSKL-ZHAD-37-0','1','3.930','3.930','TOKO','INPUT1','TOKO','BKLMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMS' WHERE kode_barang='MSKL-ZHAD-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('2026-08-14','TOKO','BKLMS','MSKL','MSKL-ZHAD-37-0','100.00','1','3.930','3.920','1','3.930','3.920');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.930',berat_out_asli=berat_out_asli+'3.920',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSKL-ZHAD-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-260814-0007','10','MSKL-ZHAD-38-0','1','2.300','2.300','TOKO','INPUT1','TOKO','BKLMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMS' WHERE kode_barang='MSKL-ZHAD-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('2026-08-14','TOKO','BKLMS','MSKL','MSKL-ZHAD-38-0','100.00','1','2.300','2.290','1','2.300','2.290');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.300',berat_out_asli=berat_out_asli+'2.290',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSKL-ZHAD-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-260814-0007','11','MSKL-ZHAD-39-0','1','2.960','2.960','TOKO','INPUT1','TOKO','BKLMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMS' WHERE kode_barang='MSKL-ZHAD-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('2026-08-14','TOKO','BKLMS','MSKL','MSKL-ZHAD-39-0','100.00','1','2.960','2.950','1','2.960','2.950');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.960',berat_out_asli=berat_out_asli+'2.950',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSKL-ZHAD-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-260814-0007','12','MSKL-ZHAD-40-0','1','3.980','3.980','TOKO','INPUT1','TOKO','BKLMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMS' WHERE kode_barang='MSKL-ZHAD-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('2026-08-14','TOKO','BKLMS','MSKL','MSKL-ZHAD-40-0','100.00','1','3.980','3.970','1','3.980','3.970');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.980',berat_out_asli=berat_out_asli+'3.970',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSKL-ZHAD-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-260814-0007','13','MSKL-ZHAD-41-0','1','4.600','4.600','TOKO','INPUT1','TOKO','BKLMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMS' WHERE kode_barang='MSKL-ZHAD-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('2026-08-14','TOKO','BKLMS','MSKL','MSKL-ZHAD-41-0','100.00','1','4.600','4.590','1','4.600','4.590');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.600',berat_out_asli=berat_out_asli+'4.590',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSKL-ZHAD-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-260814-0007','14','MSKL-ZHAD-42-0','1','2.610','2.610','TOKO','INPUT1','TOKO','BKLMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMS' WHERE kode_barang='MSKL-ZHAD-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('2026-08-14','TOKO','BKLMS','MSKL','MSKL-ZHAD-42-0','100.00','1','2.610','2.600','1','2.610','2.600');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.610',berat_out_asli=berat_out_asli+'2.600',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSKL-ZHAD-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-260814-0007','15','MSKL-ZHAD-43-0','1','2.600','2.600','TOKO','INPUT1','TOKO','BKLMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMS' WHERE kode_barang='MSKL-ZHAD-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('2026-08-14','TOKO','BKLMS','MSKL','MSKL-ZHAD-43-0','100.00','1','2.600','2.590','1','2.600','2.590');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.600',berat_out_asli=berat_out_asli+'2.590',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSKL-ZHAD-43-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260814-0007','16','MSKL-ZHAD-44-0','1','2.560','2.560','TOKO','INPUT1','TOKO','BKLMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMS' WHERE kode_barang='MSKL-ZHAD-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('2026-08-14','TOKO','BKLMS','MSKL','MSKL-ZHAD-44-0','100.00','1','2.560','2.550','1','2.560','2.550');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.560',berat_out_asli=berat_out_asli+'2.550',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSKL-ZHAD-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-260814-0007','17','MSKL-ZHAD-45-0','1','8.080','8.080','TOKO','INPUT1','TOKO','BKLMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMS' WHERE kode_barang='MSKL-ZHAD-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('2026-08-14','TOKO','BKLMS','MSKL','MSKL-ZHAD-45-0','100.00','1','8.080','8.070','1','8.080','8.070');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'8.080',berat_out_asli=berat_out_asli+'8.070',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSKL-ZHAD-45-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260814-0007','18','MSKL-ZHAD-46-0','1','7.970','7.970','TOKO','INPUT1','TOKO','BKLMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMS' WHERE kode_barang='MSKL-ZHAD-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('2026-08-14','TOKO','BKLMS','MSKL','MSKL-ZHAD-46-0','100.00','1','7.970','7.960','1','7.970','7.960');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'7.970',berat_out_asli=berat_out_asli+'7.960',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSKL-ZHAD-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-260814-0007','19','MSKL-ZHAD-47-0','1','6.290','6.290','TOKO','INPUT1','TOKO','BKLMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMS' WHERE kode_barang='MSKL-ZHAD-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('2026-08-14','TOKO','BKLMS','MSKL','MSKL-ZHAD-47-0','100.00','1','6.290','6.280','1','6.290','6.280');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'6.290',berat_out_asli=berat_out_asli+'6.280',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSKL-ZHAD-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-260814-0007','20','MSKL-ZHAD-48-0','1','6.020','6.020','TOKO','INPUT1','TOKO','BKLMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMS' WHERE kode_barang='MSKL-ZHAD-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('2026-08-14','TOKO','BKLMS','MSKL','MSKL-ZHAD-48-0','100.00','1','6.020','6.010','1','6.020','6.010');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'6.020',berat_out_asli=berat_out_asli+'6.010',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MSKL-ZHAD-48-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-260814-0007','2026-08-14','2026-08-14','14:49','105.96','adminpusat','2026-08-14 14:51:08');
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-ZHAD-49-0','00031119','EX ','CN PLINTIR SHB ','','GR','---','MT','MTCN','TOKO','INPUT1','4385000','2026-08-14','4385000','2.320','100.00','16','0','1890000.00','1','0.045', 'adminpusat','2026-08-14 15:08:01','2.310','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-ZHAD-49-0','00031119');
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 ('2026-08-14','MTCN-ZHAD-49-0','MTCN','TOKO','INPUT1','100.00','2.320','2.310','1','2.320','2.310','1');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-14 ','15:14:08');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-14 ','16:10:48');
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 ('MTCN-ZHAD-49-0','00031119','00031119','CN PLINTIR SHB ','CN PLINTIR SHB','','','4385000','4385000',' 0','0','adminpusat','2026-08-14 16:12:37');
UPDATE tm_barang SET nama_barang='CN PLINTIR SHB' ,nama_atribut='' ,kode_intern='EX ', kadar_cetak='16.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MTCN-ZHAD-49-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-08-14 ','16:23:54');
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-260814-0008','1','MTCN-ZHAD-49-0','1','2.320','2.320','TOKO','INPUT1','TOKO','BKCNMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-ZHAD-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('2026-08-14','TOKO','BKCNMT','MTCN','MTCN-ZHAD-49-0','100.00','1','2.320','2.310','1','2.320','2.310');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.320',berat_out_asli=berat_out_asli+'2.310',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-08-14' AND kode_barang='MTCN-ZHAD-49-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-260814-0008','2026-08-14','2026-08-14','16:24','2.32','adminpusat','2026-08-14 16:25:13');