INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-02 ','08:10:31'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-02','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-01'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-01'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-01'; INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-10-01' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-01'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-01'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-01'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-01'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202609 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; UPDATE tt_barang_saldo SET tanggal= '2026-10-02' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-01' OR stock_akhir*1<0 OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS'; UPDATE tp_system SET tgl_system='2026-10-02'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-02 ','08:12:49'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-02 ','11:40:27'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-02 ','11:52:03'); 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-ZJXB-1-0','00031528',' ','GL RANGKAIAN COR KUPU 19CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','8514000','2026-10-02','8514000','7.670','100.00','8','0','1110000.00','1','0.045', 'adminpusat','2026-10-02 11:58:44','7.660','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-ZJXB-1-0','00031528'); 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-10-02','MDGL-ZJXB-1-0','MDGL','TOKO','INPUT1','100.00','7.670','7.660','1','7.670','7.660','1'); INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-ZJXB-2-0','00031529',' ','GL RANGKAIAN COR 3BNG 19CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','9058000','2026-10-02','9058000','8.160','100.00','8','0','1110000.00','1','0.045', 'adminpusat','2026-10-02 12:05:15','8.150','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-ZJXB-2-0','00031529'); 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-10-02','MDGL-ZJXB-2-0','MDGL','TOKO','INPUT1','100.00','8.160','8.150','1','8.160','8.150','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-261002-0001','1','MDGL-ZJXB-1-0','1','7.670','7.670','TOKO','INPUT1','TOKO','BGLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZJXB-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-10-02','TOKO','BGLMD','MDGL','MDGL-ZJXB-1-0','100.00','1','7.670','7.660','1','7.670','7.660'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'7.670',berat_out_asli=berat_out_asli+'7.660',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-02' AND kode_barang='MDGL-ZJXB-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261002-0001','2','MDGL-ZJXB-2-0','1','8.160','8.160','TOKO','INPUT1','TOKO','BGLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZJXB-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-10-02','TOKO','BGLMD','MDGL','MDGL-ZJXB-2-0','100.00','1','8.160','8.150','1','8.160','8.150'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'8.160',berat_out_asli=berat_out_asli+'8.150',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-02' AND kode_barang='MDGL-ZJXB-2-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-261002-0001','2026-10-02','2026-10-02','12:09','15.83','adminpusat','2026-10-02 12:10:26'); 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-ZJXB-3-0','00031530',' ','GL PAJERO 18CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','3352500','2026-10-02','3352500','3.020','100.00','8','0','1110000.00','1','0.045', 'adminpusat','2026-10-02 12:20:51','3.010','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-ZJXB-3-0','00031530'); 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-10-02','MDGL-ZJXB-3-0','MDGL','TOKO','INPUT1','100.00','3.020','3.010','1','3.020','3.010','1'); INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDGL-ZJXB-4-0','00031531',' ','GL PAJERO 18CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','3397000','2026-10-02','3397000','3.060','100.00','8','0','1110000.00','1','0.045', 'adminpusat','2026-10-02 12:23:22','3.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-ZJXB-4-0','00031531'); 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-10-02','MDGL-ZJXB-4-0','MDGL','TOKO','INPUT1','100.00','3.060','3.050','1','3.060','3.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-ZJXB-5-0','00031532',' ','GL RANGKAIAN VAR PAJERO PRMD 18CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','3452500','2026-10-02','3452500','3.110','100.00','8','0','1110000.00','1','0.045', 'adminpusat','2026-10-02 12:29:22','3.100','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-ZJXB-5-0','00031532'); 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-10-02','MDGL-ZJXB-5-0','MDGL','TOKO','INPUT1','100.00','3.110','3.100','1','3.110','3.100','1'); INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDKL-ZJXB-6-0','00031533',' ','KL PIRAMID 46CM KKT PER SHB ','','GR','---','MD','MDKL','TOKO','INPUT1','8336500','2026-10-02','8336500','7.510','100.00','8','0','1110000.00','1','0.045', 'adminpusat','2026-10-02 12:34:37','7.500','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDKL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDKL','MDKL-ZJXB-6-0','00031533'); 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-10-02','MDKL-ZJXB-6-0','MDKL','TOKO','INPUT1','100.00','7.510','7.500','1','7.510','7.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 ('MDKL-ZJXB-7-0','00031534',' ','KL PIRAMID PJG 68CM KKT PER SHB ','','GR','---','MD','MDKL','TOKO','INPUT1','12376500','2026-10-02','12376500','11.150','100.00','8','0','1110000.00','1','0.045', 'adminpusat','2026-10-02 12:37:34','11.140','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDKL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDKL','MDKL-ZJXB-7-0','00031534'); 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-10-02','MDKL-ZJXB-7-0','MDKL','TOKO','INPUT1','100.00','11.150','11.140','1','11.150','11.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 ('MDKL-ZJXB-8-0','00031535',' ','KL PAJERO PIRAMID 46CM KKT PER SHB ','','GR','---','MD','MDKL','TOKO','INPUT1','8392000','2026-10-02','8392000','7.560','100.00','8','0','1110000.00','1','0.045', 'adminpusat','2026-10-02 12:42:41','7.550','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDKL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDKL','MDKL-ZJXB-8-0','00031535'); 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-10-02','MDKL-ZJXB-8-0','MDKL','TOKO','INPUT1','100.00','7.560','7.550','1','7.560','7.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 ('MTGL-ZJXB-9-0','00031536',' ','GL VANESSA VAR BT 18CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','6238000','2026-10-02','6238000','3.390','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-10-02 12:52:38','3.380','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZJXB-9-0','00031536'); 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-10-02','MTGL-ZJXB-9-0','MTGL','TOKO','INPUT1','100.00','3.390','3.380','1','3.390','3.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 ('MTGL-ZJXB-10-0','00031537',' ','GL VANESSA VAR BT 18CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','6440000','2026-10-02','6440000','3.500','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-10-02 12:54:44','3.490','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZJXB-10-0','00031537'); 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-10-02','MTGL-ZJXB-10-0','MTGL','TOKO','INPUT1','100.00','3.500','3.490','1','3.500','3.490','1'); INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTGL-ZJXB-11-0','00031538',' ','GL VANESSA VAR 18CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','6716000','2026-10-02','6716000','3.650','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-10-02 12:59:51','3.640','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZJXB-11-0','00031538'); 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-10-02','MTGL-ZJXB-11-0','MTGL','TOKO','INPUT1','100.00','3.650','3.640','1','3.650','3.640','1'); INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTGL-ZJXB-12-0','00031539',' ','GL VANESSA VAR 18CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','6753000','2026-10-02','6753000','3.670','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-10-02 13:00:42','3.660','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZJXB-12-0','00031539'); 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-10-02','MTGL-ZJXB-12-0','MTGL','TOKO','INPUT1','100.00','3.670','3.660','1','3.670','3.660','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-261002-0002','1','MDGL-ZJXB-3-0','1','3.020','3.020','TOKO','INPUT1','TOKO','BGLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZJXB-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-10-02','TOKO','BGLMD','MDGL','MDGL-ZJXB-3-0','100.00','1','3.020','3.010','1','3.020','3.010'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.020',berat_out_asli=berat_out_asli+'3.010',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-02' AND kode_barang='MDGL-ZJXB-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-261002-0002','2','MDGL-ZJXB-4-0','1','3.060','3.060','TOKO','INPUT1','TOKO','BGLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZJXB-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-10-02','TOKO','BGLMD','MDGL','MDGL-ZJXB-4-0','100.00','1','3.060','3.050','1','3.060','3.050'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.060',berat_out_asli=berat_out_asli+'3.050',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-02' AND kode_barang='MDGL-ZJXB-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-261002-0002','3','MDGL-ZJXB-5-0','1','3.110','3.110','TOKO','INPUT1','TOKO','BGLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZJXB-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-10-02','TOKO','BGLMD','MDGL','MDGL-ZJXB-5-0','100.00','1','3.110','3.100','1','3.110','3.100'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.110',berat_out_asli=berat_out_asli+'3.100',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-02' AND kode_barang='MDGL-ZJXB-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261002-0002','2026-10-02','2026-10-02','13:07','9.19','adminpusat','2026-10-02 13:08:00'); 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-261002-0003','1','MDKL-ZJXB-6-0','1','7.510','7.510','TOKO','INPUT1','TOKO','BKLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-ZJXB-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-10-02','TOKO','BKLMD','MDKL','MDKL-ZJXB-6-0','100.00','1','7.510','7.500','1','7.510','7.500'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'7.510',berat_out_asli=berat_out_asli+'7.500',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-02' AND kode_barang='MDKL-ZJXB-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-261002-0003','2','MDKL-ZJXB-7-0','1','11.150','11.150','TOKO','INPUT1','TOKO','BKLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-ZJXB-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-10-02','TOKO','BKLMD','MDKL','MDKL-ZJXB-7-0','100.00','1','11.150','11.140','1','11.150','11.140'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'11.150',berat_out_asli=berat_out_asli+'11.140',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-02' AND kode_barang='MDKL-ZJXB-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-261002-0003','3','MDKL-ZJXB-8-0','1','7.560','7.560','TOKO','INPUT1','TOKO','BKLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-ZJXB-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-10-02','TOKO','BKLMD','MDKL','MDKL-ZJXB-8-0','100.00','1','7.560','7.550','1','7.560','7.550'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'7.560',berat_out_asli=berat_out_asli+'7.550',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-02' AND kode_barang='MDKL-ZJXB-8-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-261002-0003','2026-10-02','2026-10-02','13:08','26.22','adminpusat','2026-10-02 13:09:06'); 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-261002-0004','1','MTGL-ZJXB-9-0','1','3.390','3.390','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZJXB-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-10-02','TOKO','BKGLMT','MTGL','MTGL-ZJXB-9-0','100.00','1','3.390','3.380','1','3.390','3.380'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.390',berat_out_asli=berat_out_asli+'3.380',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-02' AND kode_barang='MTGL-ZJXB-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-261002-0004','2','MTGL-ZJXB-10-0','1','3.500','3.500','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZJXB-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-10-02','TOKO','BKGLMT','MTGL','MTGL-ZJXB-10-0','100.00','1','3.500','3.490','1','3.500','3.490'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.500',berat_out_asli=berat_out_asli+'3.490',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-02' AND kode_barang='MTGL-ZJXB-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-261002-0004','3','MTGL-ZJXB-11-0','1','3.650','3.650','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZJXB-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-10-02','TOKO','BKGLMT','MTGL','MTGL-ZJXB-11-0','100.00','1','3.650','3.640','1','3.650','3.640'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.650',berat_out_asli=berat_out_asli+'3.640',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-02' AND kode_barang='MTGL-ZJXB-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-261002-0004','4','MTGL-ZJXB-12-0','1','3.670','3.670','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZJXB-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-10-02','TOKO','BKGLMT','MTGL','MTGL-ZJXB-12-0','100.00','1','3.670','3.660','1','3.670','3.660'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.670',berat_out_asli=berat_out_asli+'3.660',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-02' AND kode_barang='MTGL-ZJXB-12-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-261002-0004','2026-10-02','2026-10-02','13:09','14.21','adminpusat','2026-10-02 13:12:08'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-02 ','13:18:29'); 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-ZJXB-13-0','00031540',' ','CN COR DB CAT SHB ','','GR','---','MT','MTCN','TOKO','INPUT1','3809000','2026-10-02','3809000','2.070','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-10-02 13:21:54','2.060','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-ZJXB-13-0','00031540'); 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-10-02','MTCN-ZJXB-13-0','MTCN','TOKO','INPUT1','100.00','2.070','2.060','1','2.070','2.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 ('MTCN-ZJXB-14-0','00031541',' ','CN COR DB CAT SHB ','','GR','---','MT','MTCN','TOKO','INPUT1','3330500','2026-10-02','3330500','1.810','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-10-02 13:23:45','1.800','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-ZJXB-14-0','00031541'); 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-10-02','MTCN-ZJXB-14-0','MTCN','TOKO','INPUT1','100.00','1.810','1.800','1','1.810','1.800','1'); INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-ZJXB-15-0','00031542',' ','CN COR DB CAT SHB ','','GR','---','MT','MTCN','TOKO','INPUT1','3312000','2026-10-02','3312000','1.800','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-10-02 13:25:20','1.790','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-ZJXB-15-0','00031542'); 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-10-02','MTCN-ZJXB-15-0','MTCN','TOKO','INPUT1','100.00','1.800','1.790','1','1.800','1.790','1'); INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTGL-ZJXB-16-0','00031543',' ','GL RANGKAIAN COR 18CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','16468500','2026-10-02','16468500','8.950','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-10-02 13:42:00','8.940','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZJXB-16-0','00031543'); 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-10-02','MTGL-ZJXB-16-0','MTGL','TOKO','INPUT1','100.00','8.950','8.940','1','8.950','8.940','1'); INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTGL-ZJXB-17-0','00031544',' ','GL RANGKAIAN VAR BLTN PSR 18CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','9807500','2026-10-02','9807500','5.330','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-10-02 13:50:07','5.320','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZJXB-17-0','00031544'); 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-10-02','MTGL-ZJXB-17-0','MTGL','TOKO','INPUT1','100.00','5.330','5.320','1','5.330','5.320','1'); INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTGL-ZJXB-18-0','00031545',' ','GL RANGKAIAN DBL CHN VAR BT 18CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','10488000','2026-10-02','10488000','5.700','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-10-02 13:53:43','5.690','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZJXB-18-0','00031545'); 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-10-02','MTGL-ZJXB-18-0','MTGL','TOKO','INPUT1','100.00','5.700','5.690','1','5.700','5.690','1'); INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZJXB-19-0','00031546',' ','KL ITALY ST BT PNT 3WRN 41CM KKT PER BLT MK ','','GR','---','MT','MTKL','TOKO','INPUT1','6238000','2026-10-02','6238000','3.390','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-10-02 14:04:12','3.380','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZJXB-19-0','00031546'); 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-10-02','MTKL-ZJXB-19-0','MTKL','TOKO','INPUT1','100.00','3.390','3.380','1','3.390','3.380','1'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-02 ','16:17:34');