INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-02-03 ','08:30:35');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-02-03','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-01-03';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-02-02';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-02-02';
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-02-02' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-02-02';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-02-02';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-02-02';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-02-02';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202601 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
UPDATE tt_barang_saldo SET tanggal= '2026-02-03' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-02-02' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-02-03';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-02-03 ','08:30:59');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260203-0001','1','ABRE-ZBXB-3-0','1','2.660','TOKO','ABRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='ABRE-ZBXB-3-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='ABRE-ZBXB-3-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='ABRE-ZBXB-3-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='ABRE-ZBXB-3-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='ABRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='ABRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='ABRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='ABRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='ABRE-ZBXB-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.660',berat_out_asli='2.660', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.660',berat_akhir_asli =berat_akhir_asli-'2.660' WHERE kode_barang='ABRE-ZBXB-3-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260203-0001','2','ABRE-ZBXB-4-0','1','2.400','TOKO','ABRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='ABRE-ZBXB-4-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='ABRE-ZBXB-4-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='ABRE-ZBXB-4-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='ABRE-ZBXB-4-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='ABRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='ABRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='ABRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='ABRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='ABRE-ZBXB-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.400',berat_out_asli='2.400', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.400',berat_akhir_asli =berat_akhir_asli-'2.400' WHERE kode_barang='ABRE-ZBXB-4-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260203-0001','3','ABRE-ZBXB-7-0','1','5.770','TOKO','ABRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='ABRE-ZBXB-7-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='ABRE-ZBXB-7-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='ABRE-ZBXB-7-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='ABRE-ZBXB-7-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='ABRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='ABRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='ABRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='ABRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='ABRE-ZBXB-7-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.770',berat_out_asli='5.770', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.770',berat_akhir_asli =berat_akhir_asli-'5.770' WHERE kode_barang='ABRE-ZBXB-7-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260203-0001','4','ABRE-ZBXB-14-0','1','2.160','TOKO','ABRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='ABRE-ZBXB-14-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='ABRE-ZBXB-14-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='ABRE-ZBXB-14-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='ABRE-ZBXB-14-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='ABRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='ABRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='ABRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='ABRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='ABRE-ZBXB-14-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.160',berat_out_asli='2.160', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.160',berat_akhir_asli =berat_akhir_asli-'2.160' WHERE kode_barang='ABRE-ZBXB-14-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260203-0001','5','ABRE-ZBXB-21-0','1','1.780','TOKO','ABRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='ABRE-ZBXB-21-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='ABRE-ZBXB-21-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='ABRE-ZBXB-21-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='ABRE-ZBXB-21-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='ABRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='ABRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='ABRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='ABRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='ABRE-ZBXB-21-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.780',berat_out_asli='1.780', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.780',berat_akhir_asli =berat_akhir_asli-'1.780' WHERE kode_barang='ABRE-ZBXB-21-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260203-0001','2026-02-03','2026-02-03','08:31','1.780','input','2026-02-03 08:31:29','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260203-0002','1','AMR-ZBXB-17-0','1','2.770','TOKO','AMRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='AMR-ZBXB-17-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='AMR-ZBXB-17-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='AMR-ZBXB-17-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='AMR-ZBXB-17-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='AMR' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='AMR' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='AMRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='AMRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='AMR-ZBXB-17-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.770',berat_out_asli='2.770', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.770',berat_akhir_asli =berat_akhir_asli-'2.770' WHERE kode_barang='AMR-ZBXB-17-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260203-0002','2026-02-03','2026-02-03','08:31','2.770','input','2026-02-03 08:31:42','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260203-0003','1','CBRE-ZBXB-5-0','1','1.120','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZBXB-5-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-ZBXB-5-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-ZBXB-5-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-ZBXB-5-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-ZBXB-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.120',berat_out_asli='1.120', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.120',berat_akhir_asli =berat_akhir_asli-'1.120' WHERE kode_barang='CBRE-ZBXB-5-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260203-0003','2','CBRE-ZBXB-8-0','1','1.900','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZBXB-8-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-ZBXB-8-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-ZBXB-8-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-ZBXB-8-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-ZBXB-8-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.900',berat_out_asli='1.900', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.900',berat_akhir_asli =berat_akhir_asli-'1.900' WHERE kode_barang='CBRE-ZBXB-8-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260203-0003','3','CBRE-ZBXB-9-0','1','13.460','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZBXB-9-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-ZBXB-9-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-ZBXB-9-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-ZBXB-9-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-ZBXB-9-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='13.460',berat_out_asli='13.460', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'13.460',berat_akhir_asli =berat_akhir_asli-'13.460' WHERE kode_barang='CBRE-ZBXB-9-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260203-0003','4','CBRE-ZBXB-15-0','1','1.250','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZBXB-15-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-ZBXB-15-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-ZBXB-15-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-ZBXB-15-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-ZBXB-15-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.250',berat_out_asli='1.250', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.250',berat_akhir_asli =berat_akhir_asli-'1.250' WHERE kode_barang='CBRE-ZBXB-15-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260203-0003','5','CBRE-ZBXB-16-0','1','9.670','TOKO','CBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZBXB-16-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-ZBXB-16-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-ZBXB-16-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-ZBXB-16-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-ZBXB-16-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='9.670',berat_out_asli='9.670', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'9.670',berat_akhir_asli =berat_akhir_asli-'9.670' WHERE kode_barang='CBRE-ZBXB-16-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260203-0003','2026-02-03','2026-02-03','08:31','9.670','input','2026-02-03 08:31:53','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260203-0004','1','CKBE-ZBXB-12-0','1','2.060','TOKO','CKBE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CKBE-ZBXB-12-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKBE-ZBXB-12-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKBE-ZBXB-12-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKBE-ZBXB-12-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKBE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKBE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CKBE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CKBE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKBE-ZBXB-12-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.060',berat_out_asli='2.060', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.060',berat_akhir_asli =berat_akhir_asli-'2.060' WHERE kode_barang='CKBE-ZBXB-12-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260203-0004','2','CKBE-ZBXB-22-0','1','3.280','TOKO','CKBE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CKBE-ZBXB-22-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKBE-ZBXB-22-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKBE-ZBXB-22-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKBE-ZBXB-22-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKBE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKBE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CKBE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CKBE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKBE-ZBXB-22-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.280',berat_out_asli='3.280', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.280',berat_akhir_asli =berat_akhir_asli-'3.280' WHERE kode_barang='CKBE-ZBXB-22-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260203-0004','2026-02-03','2026-02-03','08:32','3.280','input','2026-02-03 08:32:03','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260203-0005','1','CMK-ZBXB-18-0','1','2.090','TOKO','CMKE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='CMK-ZBXB-18-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CMK-ZBXB-18-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CMK-ZBXB-18-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CMK-ZBXB-18-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CMK' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CMK' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CMKE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CMKE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CMK-ZBXB-18-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.090',berat_out_asli='2.090', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.090',berat_akhir_asli =berat_akhir_asli-'2.090' WHERE kode_barang='CMK-ZBXB-18-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260203-0005','2026-02-03','2026-02-03','08:32','2.090','input','2026-02-03 08:32:14','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260203-0006','1','KLBE-ZBXB-6-0','1','4.420','TOKO','KLBE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='KLBE-ZBXB-6-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='KLBE-ZBXB-6-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='KLBE-ZBXB-6-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='KLBE-ZBXB-6-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='KLBE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='KLBE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='KLBE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='KLBE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='KLBE-ZBXB-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.420',berat_out_asli='4.420', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.420',berat_akhir_asli =berat_akhir_asli-'4.420' WHERE kode_barang='KLBE-ZBXB-6-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260203-0006','2026-02-03','2026-02-03','08:32','4.420','input','2026-02-03 08:32:26','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260203-0007','1','KMK-ZBXB-19-0','1','2.910','TOKO','KMKE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='KMK-ZBXB-19-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='KMK-ZBXB-19-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='KMK-ZBXB-19-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='KMK-ZBXB-19-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='KMK' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='KMK' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='KMKE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='KMKE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='KMK-ZBXB-19-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.910',berat_out_asli='2.910', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.910',berat_akhir_asli =berat_akhir_asli-'2.910' WHERE kode_barang='KMK-ZBXB-19-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260203-0007','2026-02-03','2026-02-03','08:32','2.910','input','2026-02-03 08:32:37','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260203-0008','1','LBRE-ZBXB-10-0','1','2.220','TOKO','LBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='LBRE-ZBXB-10-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LBRE-ZBXB-10-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LBRE-ZBXB-10-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LBRE-ZBXB-10-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='LBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LBRE-ZBXB-10-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.220',berat_out_asli='2.220', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.220',berat_akhir_asli =berat_akhir_asli-'2.220' WHERE kode_barang='LBRE-ZBXB-10-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260203-0008','2','LBRE-ZBXB-23-0','1','1.170','TOKO','LBRE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='LBRE-ZBXB-23-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LBRE-ZBXB-23-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LBRE-ZBXB-23-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LBRE-ZBXB-23-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='LBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LBRE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LBRE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LBRE-ZBXB-23-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.170',berat_out_asli='1.170', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.170',berat_akhir_asli =berat_akhir_asli-'1.170' WHERE kode_barang='LBRE-ZBXB-23-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260203-0008','2026-02-03','2026-02-03','08:32','1.170','input','2026-02-03 08:32:45','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260203-0009','1','LMK-ZBXB-20-0','1','1.680','TOKO','LMKE.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='LMK-ZBXB-20-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LMK-ZBXB-20-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LMK-ZBXB-20-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LMK-ZBXB-20-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='LMK' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LMK' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LMKE.BALIK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LMKE.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LMK-ZBXB-20-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.680',berat_out_asli='1.680', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.680',berat_akhir_asli =berat_akhir_asli-'1.680' WHERE kode_barang='LMK-ZBXB-20-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260203-0009','2026-02-03','2026-02-03','08:32','1.680','input','2026-02-03 08:32:54','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260203-0010','1','CKPRE-ZBXB-13-0','1','4.260','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZBXB-13-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-ZBXB-13-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-ZBXB-13-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-ZBXB-13-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-ZBXB-13-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.260',berat_out_asli='4.260', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.260',berat_akhir_asli =berat_akhir_asli-'4.260' WHERE kode_barang='CKPRE-ZBXB-13-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260203-0010','2026-02-03','2026-02-03','08:33','4.260','input','2026-02-03 08:33:02','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260203-0011','1','TFC-ZBXB-11-0','1','4.960','TOKO','TFC.BALIK');
DELETE FROM tm_barang_export WHERE kode_barang='TFC-ZBXB-11-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='TFC-ZBXB-11-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='TFC-ZBXB-11-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='TFC-ZBXB-11-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='TFC' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='TFC' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='TFC.BALIK';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='TFC.BALIK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='TFC-ZBXB-11-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.960',berat_out_asli='4.960', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.960',berat_akhir_asli =berat_akhir_asli-'4.960' WHERE kode_barang='TFC-ZBXB-11-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260203-0011','2026-02-03','2026-02-03','08:33','4.960','input','2026-02-03 08:33:14','THIFA');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-02-03 ','08:47:22');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01615';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-ZBXC-1-0','00041295','DP-01615BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','404000','2026-02-03','404000','1.980','17.00','10','300000','1200000.00','1','0.14', 'input','2026-02-03 10:02:49','1.980','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01615BIP','1','RS 15','','DP-01615');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZBXC-1-0','00041295');
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-02-03','PSPLT-ZBXC-1-0','PSPLT','TOKO','PSNB','17.00','1.980','1.980','1','1.980','1.980','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01615BIP ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01608';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-ZBXC-2-0','00041296','DP-01608T ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNT','855000','2026-02-03','855000','4.190','17.00','10','300000','1200000.00','1','0.14', 'input','2026-02-03 10:04:30','4.190','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01608BIP','1','RS 18','','DP-01608');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZBXC-2-0','00041296');
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-02-03','PSPLT-ZBXC-2-0','PSPLT','TOKO','PSNT','17.00','4.190','4.190','1','4.190','4.190','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01608T ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01609';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-ZBXC-3-0','00041297','DP-01609BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','355000','2026-02-03','355000','1.740','17.00','10','300000','1200000.00','1','0.14', 'input','2026-02-03 10:06:03','1.740','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01609BIP','1','RS 11','','DP-01609');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZBXC-3-0','00041297');
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-02-03','PSPLT-ZBXC-3-0','PSPLT','TOKO','PSNB','17.00','1.740','1.740','1','1.740','1.740','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01609BIP ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01614';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-ZBXC-4-0','00041298','DP-01614BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','447000','2026-02-03','447000','2.190','17.00','10','300000','1200000.00','1','0.14', 'input','2026-02-03 10:07:47','2.190','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01614BIP','1','RS 16','','DP-01614');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZBXC-4-0','00041298');
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-02-03','PSPLT-ZBXC-4-0','PSPLT','TOKO','PSNB','17.00','2.190','2.190','1','2.190','2.190','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01614BIP ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01605';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-ZBXC-5-0','00041299','DP-01605BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','957000','2026-02-03','957000','4.690','17.00','10','300000','1200000.00','1','0.14', 'input','2026-02-03 10:09:11','4.690','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01605BIP','1','RS 25','','DP-01605');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZBXC-5-0','00041299');
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-02-03','PSPLT-ZBXC-5-0','PSPLT','TOKO','PSNB','17.00','4.690','4.690','1','4.690','4.690','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01605BIP ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01622';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-ZBXC-6-0','00041300','DP-01622MM ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','MMPSN','1006500','2026-02-03','1006500','2.620','32.00','25','300000','1200000.00','1','0.14', 'input','2026-02-03 10:11:10','2.620','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01622MM','1','RS 18','','DP-01622');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZBXC-6-0','00041300');
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-02-03','PSPLT-ZBXC-6-0','PSPLT','TOKO','MMPSN','32.00','2.620','2.620','1','2.620','2.620','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01622MM ');
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZBXC-2-0';
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 ('PSPLT-ZBXC-2-0','00041296','00041296','CINCIN PALADIUM ','CINCIN PALADIUM','','','855000','855000',' 300000','300000','input','2026-02-03 10:11:34');
UPDATE tm_barang SET nama_barang='CINCIN PALADIUM' ,nama_atribut='' ,kode_intern='DP-01608T ', kadar_cetak='10.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 18',total_usd_ext='PSN01608T',total_usd='0' WHERE kode_barang='PSPLT-ZBXC-2-0' LIMIT 1;
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PMM-ZBXC-7-0','00041301','500K-22-789 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','223000','2026-02-03','223000','2.230','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-03 10:42:04','2.230','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZBXC-7-0','00041301');
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-02-03','PMM-ZBXC-7-0','PMM','TOKO','MMPER','100.00','2.230','2.230','1','2.230','2.230','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','500K-22-789 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PMM-ZBXC-8-0','00041302','500K-22-790 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','212000','2026-02-03','212000','2.120','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-03 10:42:31','2.120','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZBXC-8-0','00041302');
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-02-03','PMM-ZBXC-8-0','PMM','TOKO','MMPER','100.00','2.120','2.120','1','2.120','2.120','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','500K-22-790 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PMM-ZBXC-9-0','00041303','500K-21-791 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','209000','2026-02-03','209000','2.090','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-03 10:42:57','2.090','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZBXC-9-0','00041303');
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-02-03','PMM-ZBXC-9-0','PMM','TOKO','MMPER','100.00','2.090','2.090','1','2.090','2.090','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','500K-21-791 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PMM-ZBXC-10-0','00041304','500K-23-792 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','227000','2026-02-03','227000','2.270','100.00','925','150000','100000.00','1','0.14', 'input','2026-02-03 10:43:20','2.270','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZBXC-10-0','00041304');
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-02-03','PMM-ZBXC-10-0','PMM','TOKO','MMPER','100.00','2.270','2.270','1','2.270','2.270','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','500K-23-792 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PMM-ZBXC-11-0','00041305','750K-20-793 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','461500','2026-02-03','461500','4.610','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-03 10:44:03','4.610','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZBXC-11-0','00041305');
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-02-03','PMM-ZBXC-11-0','PMM','TOKO','MMPER','100.00','4.610','4.610','1','4.610','4.610','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','750K-20-793 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PMM-ZBXC-12-0','00041306','750K-22-794 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','486500','2026-02-03','486500','4.860','100.00','925','200000','100000.00','1','0.14', 'input','2026-02-03 10:44:41','4.860','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZBXC-12-0','00041306');
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-02-03','PMM-ZBXC-12-0','PMM','TOKO','MMPER','100.00','4.860','4.860','1','4.860','4.860','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','750K-22-794 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PMM-ZBXC-13-0','00041307','750K-21-795 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','470000','2026-02-03','470000','4.700','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-03 10:45:06','4.700','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZBXC-13-0','00041307');
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-02-03','PMM-ZBXC-13-0','PMM','TOKO','MMPER','100.00','4.700','4.700','1','4.700','4.700','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','750K-21-795 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PMM-ZBXC-14-0','00041308','700K-20-796 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','418000','2026-02-03','418000','4.180','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-03 10:45:50','4.180','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZBXC-14-0','00041308');
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-02-03','PMM-ZBXC-14-0','PMM','TOKO','MMPER','100.00','4.180','4.180','1','4.180','4.180','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','700K-20-796 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PMM-ZBXC-15-0','00041309','750K-24-797 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','511500','2026-02-03','511500','5.110','100.00','925','200000','100000.00','1','0.14', 'input','2026-02-03 10:46:21','5.110','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZBXC-15-0','00041309');
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-02-03','PMM-ZBXC-15-0','PMM','TOKO','MMPER','100.00','5.110','5.110','1','5.110','5.110','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','750K-24-797 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PMM-ZBXC-16-0','00041310','950K-16-798 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','177000','2026-02-03','177000','1.770','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-03 10:47:05','1.770','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZBXC-16-0','00041310');
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-02-03','PMM-ZBXC-16-0','PMM','TOKO','MMPER','100.00','1.770','1.770','1','1.770','1.770','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','950K-16-798 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PMM-ZBXC-17-0','00041311','950K-15-799 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','181000','2026-02-03','181000','1.810','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-03 10:47:26','1.810','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZBXC-17-0','00041311');
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-02-03','PMM-ZBXC-17-0','PMM','TOKO','MMPER','100.00','1.810','1.810','1','1.810','1.810','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','950K-15-799 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PMM-ZBXC-18-0','00041312','950K-11-800 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','166000','2026-02-03','166000','1.660','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-03 10:47:55','1.660','0','','17000.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZBXC-18-0','00041312');
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-02-03','PMM-ZBXC-18-0','PMM','TOKO','MMPER','100.00','1.660','1.660','1','1.660','1.660','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','950K-11-800 ');
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='2720500',harga_beli ='2720500' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='5510500',harga_beli ='5510500' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='214500',harga_beli ='214500' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='3117500',harga_beli ='3117500' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='6902500',harga_beli ='6902500' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='2586000',harga_beli ='2586000' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='2473500',harga_beli ='2473500' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='2518500',harga_beli ='2518500' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='6003000',harga_beli ='6003000' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='22168000',harga_beli ='22168000' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='3084500',harga_beli ='3084500' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='3056500',harga_beli ='3056500' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='2888000',harga_beli ='2888000' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='3000000',harga_beli ='3000000' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='2972000',harga_beli ='2972000' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='8342500',harga_beli ='8342500' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='3194000',harga_beli ='3194000' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='11442500',harga_beli ='11442500' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='4127500',harga_beli ='4127500' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='4852000',harga_beli ='4852000' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='4983500',harga_beli ='4983500' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='5862000',harga_beli ='5862000' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='4742000',harga_beli ='4742000' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='6784000',harga_beli ='6784000' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='8101000',harga_beli ='8101000' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='9769500',harga_beli ='9769500' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='7903500',harga_beli ='7903500' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='1647000',harga_beli ='1647000' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='3052000',harga_beli ='3052000' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='4654500',harga_beli ='4654500' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='4215500',harga_beli ='4215500' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='2415000',harga_beli ='2415000' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='2327500',harga_beli ='2327500' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='7135000',harga_beli ='7135000' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='8562000',harga_beli ='8562000' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='7574000',harga_beli ='7574000' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='6015500',harga_beli ='6015500' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='2920000',harga_beli ='2920000' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='2481000',harga_beli ='2481000' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='5642500',harga_beli ='5642500' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='3952000',harga_beli ='3952000' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='5857500',harga_beli ='5857500' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='7552500',harga_beli ='7552500' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='11438000',harga_beli ='11438000' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='10318500',harga_beli ='10318500' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='3776500',harga_beli ='3776500' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='5884000',harga_beli ='5884000' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='8211000',harga_beli ='8211000' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='7486500',harga_beli ='7486500' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='7706000',harga_beli ='7706000' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='8847500',harga_beli ='8847500' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='17651000',harga_beli ='17651000' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='1800500',harga_beli ='1800500' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='1800500',harga_beli ='1800500' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='1712500',harga_beli ='1712500' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='1647000',harga_beli ='1647000' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='5444500',harga_beli ='5444500' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='9352500',harga_beli ='9352500' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='10691500',harga_beli ='10691500' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='9089000',harga_beli ='9089000' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='8518000',harga_beli ='8518000' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='9330500',harga_beli ='9330500' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='8320500',harga_beli ='8320500' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='4962000',harga_beli ='4962000' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='59560000',harga_beli ='59560000' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='9264500',harga_beli ='9264500' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='8562000',harga_beli ='8562000' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='6345000',harga_beli ='6345000' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='12184500',harga_beli ='12184500' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='14139500',harga_beli ='14139500' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='8123000',harga_beli ='8123000' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='6564500',harga_beli ='6564500' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='7201000',harga_beli ='7201000' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='5642500',harga_beli ='5642500' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_group SET harga='2645000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2645000','input','2026-02-03 13:09:30');
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='18548500',harga_beli ='18548500' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='10882000',harga_beli ='10882000' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='5733500',harga_beli ='5733500' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='5778500',harga_beli ='5778500' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='6705500',harga_beli ='6705500' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='5089500',harga_beli ='5089500' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='12640500',harga_beli ='12640500' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='3880000',harga_beli ='3880000' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='14548000',harga_beli ='14548000' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='6915500',harga_beli ='6915500' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_group SET harga='2645000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2645000','input','2026-02-03 13:09:37');
UPDATE tm_group SET harga='2645000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2645000','input','2026-02-03 13:09:43');
UPDATE tm_group SET harga='2645000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','2645000','input','2026-02-03 13:09:46');
UPDATE tm_group SET harga='2645000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','2645000','input','2026-02-03 13:09:50');
UPDATE tm_group SET harga='2645000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','2645000','input','2026-02-03 13:09:57');
UPDATE tm_group SET harga='2645000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','2645000','input','2026-02-03 13:10:01');
UPDATE tm_barang SET harga_skrg ='2645000',harga_jual='3996000',harga_beli ='3996000' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_group SET harga='2645000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','2645000','input','2026-02-03 13:10:08');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LGM5-ZBXC-19-0','00041313','LGM5-120% ','LM ANTAM 5 GR H75670455 ','','GR','---','GOLD','LGM5','TOKO','LM','15870000','2026-02-03','15870000','5.000','120.00','9999','0','2645000.00','1','0.04', 'input','2026-02-03 13:11:44','5.000','0','','17000.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LGM5' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LGM5','LGM5-ZBXC-19-0','00041313');
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-02-03','LGM5-ZBXC-19-0','LGM5','TOKO','LM','120.00','5.000','5.000','1','5.000','5.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LGM5';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LGM5','LGM5-120% ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LGM5-ZBXC-20-0','00041314','LGM5-120% ','LM ANTAM 5 GR H75670447 ','','GR','---','GOLD','LGM5','TOKO','LM','15870000','2026-02-03','15870000','5.000','120.00','9999','0','2645000.00','1','0.04', 'input','2026-02-03 13:12:12','5.000','0','','17000.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LGM5' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LGM5','LGM5-ZBXC-20-0','00041314');
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-02-03','LGM5-ZBXC-20-0','LGM5','TOKO','LM','120.00','5.000','5.000','1','5.000','5.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LGM5';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LGM5','LGM5-120% ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LGM5-ZBXC-21-0','00041315','LGM5-120% ','LM ANTAM 5 GR H75670456 ','','GR','---','GOLD','LGM5','TOKO','LM','15870000','2026-02-03','15870000','5.000','120.00','9999','0','2645000.00','1','0.04', 'input','2026-02-03 13:12:36','5.000','0','','17000.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LGM5' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LGM5','LGM5-ZBXC-21-0','00041315');
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-02-03','LGM5-ZBXC-21-0','LGM5','TOKO','LM','120.00','5.000','5.000','1','5.000','5.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LGM5';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LGM5','LGM5-120% ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LGM5-ZBXC-22-0','00041316','LGM5-120% ','LM ANTAM 5 GR H75670444 ','','GR','---','GOLD','LGM5','TOKO','LM','15870000','2026-02-03','15870000','5.000','120.00','9999','0','2645000.00','1','0.04', 'input','2026-02-03 13:13:03','5.000','0','','17000.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LGM5' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LGM5','LGM5-ZBXC-22-0','00041316');
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-02-03','LGM5-ZBXC-22-0','LGM5','TOKO','LM','120.00','5.000','5.000','1','5.000','5.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LGM5';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LGM5','LGM5-120% ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LGM5-ZBXC-23-0','00041317','LGM5-120% ','LM ANTAM 5 GR H75670690 ','','GR','---','GOLD','LGM5','TOKO','LM','15870000','2026-02-03','15870000','5.000','120.00','9999','0','2645000.00','1','0.04', 'input','2026-02-03 13:13:33','5.000','0','','17000.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LGM5' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LGM5','LGM5-ZBXC-23-0','00041317');
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-02-03','LGM5-ZBXC-23-0','LGM5','TOKO','LM','120.00','5.000','5.000','1','5.000','5.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LGM5';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LGM5','LGM5-120% ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01618';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-ZBXC-24-0','00041318','DP-01618BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','1030500','2026-02-03','1030500','5.050','17.00','10','300000','1200000.00','1','0.14', 'input','2026-02-03 14:59:24','5.050','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01618BIP','1','RS 23','','DP-01618');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZBXC-24-0','00041318');
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-02-03','PSPLT-ZBXC-24-0','PSPLT','TOKO','PSNB','17.00','5.050','5.050','1','5.050','5.050','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01618BIP ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01607';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-ZBXC-25-0','00041319','DP-01607BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','314500','2026-02-03','314500','1.540','17.00','10','300000','1200000.00','1','0.14', 'input','2026-02-03 15:01:14','1.540','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01607BIP','1','RS 11','','DP-01607');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZBXC-25-0','00041319');
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-02-03','PSPLT-ZBXC-25-0','PSPLT','TOKO','PSNB','17.00','1.540','1.540','1','1.540','1.540','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01607BIP ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01587';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-ZBXC-26-0','00041320','DP-01587BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','438000','2026-02-03','438000','1.140','32.00','25','300000','1200000.00','1','0.14', 'input','2026-02-03 15:02:52','1.140','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01587BIP','1','RS 8','','DP-01587');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZBXC-26-0','00041320');
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-02-03','PSPLT-ZBXC-26-0','PSPLT','TOKO','PSNB','32.00','1.140','1.140','1','1.140','1.140','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01587BIP ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01642';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-ZBXC-27-0','00041321','DP-01642BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','117000','2026-02-03','117000','1.170','100.00','925','350000','100000.00','1','0.14', 'input','2026-02-03 15:04:14','1.170','0','','17000.00','','TOKO','FREETAG','','2','','','PSN01642BIP','1','RS 14','','DP-01642');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZBXC-27-0','00041321');
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-02-03','PSPRT-ZBXC-27-0','PSPRT','TOKO','PSNB','100.00','1.170','1.170','1','1.170','1.170','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01642BIP ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01641';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-ZBXC-28-0','00041322','DP-01641BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','459000','2026-02-03','459000','4.590','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-03 15:06:28','4.590','0','','17000.00','','TOKO','FREETAG','','2','','','','1','RS 26','','DP-01641');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZBXC-28-0','00041322');
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-02-03','PSPRT-ZBXC-28-0','PSPRT','TOKO','PSNB','100.00','4.590','4.590','1','4.590','4.590','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01641BIP ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01638';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-ZBXC-29-0','00041323','DP-01638MM ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','MMPSN','1056000','2026-02-03','1056000','2.750','32.00','25','300000','1200000.00','1','0.14', 'input','2026-02-03 15:08:11','2.750','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01638MM','1','RS 17','','DP-01638');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZBXC-29-0','00041323');
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-02-03','PSPLT-ZBXC-29-0','PSPLT','TOKO','MMPSN','32.00','2.750','2.750','1','2.750','2.750','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01638MM ');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260203-0012','1','PSPLT-ZBXC-1-0','1','1.980','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZBXC-1-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZBXC-1-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZBXC-1-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZBXC-1-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZBXC-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.980',berat_out_asli='1.980', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.980',berat_akhir_asli =berat_akhir_asli-'1.980' WHERE kode_barang='PSPLT-ZBXC-1-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260203-0012','2','PSPLT-ZBXC-3-0','1','1.740','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZBXC-3-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZBXC-3-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZBXC-3-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZBXC-3-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZBXC-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.740',berat_out_asli='1.740', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.740',berat_akhir_asli =berat_akhir_asli-'1.740' WHERE kode_barang='PSPLT-ZBXC-3-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260203-0012','3','PSPLT-ZBXC-4-0','1','2.190','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZBXC-4-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZBXC-4-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZBXC-4-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZBXC-4-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZBXC-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.190',berat_out_asli='2.190', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.190',berat_akhir_asli =berat_akhir_asli-'2.190' WHERE kode_barang='PSPLT-ZBXC-4-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260203-0012','4','PSPLT-ZBXC-5-0','1','4.690','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZBXC-5-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZBXC-5-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZBXC-5-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZBXC-5-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZBXC-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.690',berat_out_asli='4.690', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.690',berat_akhir_asli =berat_akhir_asli-'4.690' WHERE kode_barang='PSPLT-ZBXC-5-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260203-0012','5','PSPLT-ZBXC-24-0','1','5.050','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZBXC-24-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZBXC-24-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZBXC-24-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZBXC-24-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZBXC-24-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.050',berat_out_asli='5.050', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.050',berat_akhir_asli =berat_akhir_asli-'5.050' WHERE kode_barang='PSPLT-ZBXC-24-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260203-0012','6','PSPLT-ZBXC-25-0','1','1.540','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZBXC-25-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZBXC-25-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZBXC-25-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZBXC-25-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZBXC-25-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.540',berat_out_asli='1.540', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.540',berat_akhir_asli =berat_akhir_asli-'1.540' WHERE kode_barang='PSPLT-ZBXC-25-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260203-0012','7','PSPLT-ZBXC-26-0','1','1.140','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZBXC-26-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZBXC-26-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZBXC-26-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZBXC-26-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZBXC-26-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.140',berat_out_asli='1.140', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.140',berat_akhir_asli =berat_akhir_asli-'1.140' WHERE kode_barang='PSPLT-ZBXC-26-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260203-0012','8','PSPRT-ZBXC-27-0','1','1.170','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZBXC-27-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZBXC-27-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZBXC-27-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZBXC-27-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZBXC-27-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.170',berat_out_asli='1.170', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.170',berat_akhir_asli =berat_akhir_asli-'1.170' WHERE kode_barang='PSPRT-ZBXC-27-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260203-0012','9','PSPRT-ZBXC-28-0','1','4.590','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZBXC-28-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZBXC-28-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZBXC-28-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZBXC-28-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZBXC-28-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.590',berat_out_asli='4.590', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.590',berat_akhir_asli =berat_akhir_asli-'4.590' WHERE kode_barang='PSPRT-ZBXC-28-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260203-0012','2026-02-03','2026-02-03','15:11','4.590','input','2026-02-03 15:11:33','THIFA');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-02-03 ','16:46:24');