Mer-No.02 合并、采集添加新的字段
PS_BROWSELOG ? ??--> ?broad原始数据中位置为36、37，对应的产生csv为216、217
PS_MMSLOG ? ? ? ? ? ?--> ?broad原始数据中位置为39、40，对应的产生csv为216、217? ?
PS_EMAILLOG ? ? ? ?--> ?broad原始数据中位置为37、38，对应的产生csv为216、217?
PS_SIPREGLOG ? ? ?--> ?broad原始数据中位置为32、33，对应的产生csv为216、217?
PS_GBIUPSLO ? ? ? ?--> ?broad原始数据中位置为26，对应的产生csv为222
PS_RSTPLOG ? ? ? ????--> ?broad原始数据中位置为32、33，对应的产生csv为216、217?
?
1、修改CFG_SYS_BROAD_GROUP表
?
?
UPDATE CFG_SYS_BROAD_GROUP SET NUM_OUT_FIELDS = '223' WHERE ID = 'L0501'
?
?2、修改表CFG_SYS_BROAD_FIELD表
?
?
INSERT INTO CFG_SYS_BROAD_FIELD (ID, FILE_ID, MAP_FORMULA, MAP_TYPE, OUTPUT_SERIAL) VALUES ('10131217', '1013','40','1', '217');INSERT INTO CFG_SYS_BROAD_FIELD (ID, FILE_ID, MAP_FORMULA, MAP_TYPE, OUTPUT_SERIAL) VALUES ('10131216', '1013','39','1', '216');INSERT INTO CFG_SYS_BROAD_FIELD (ID, FILE_ID, MAP_FORMULA, MAP_TYPE, OUTPUT_SERIAL) VALUES ('10171216', '1017','32','1', '216');INSERT INTO CFG_SYS_BROAD_FIELD (ID, FILE_ID, MAP_FORMULA, MAP_TYPE, OUTPUT_SERIAL) VALUES ('10171217', '1017','33','1', '217');INSERT INTO CFG_SYS_BROAD_FIELD (ID, FILE_ID, MAP_FORMULA, MAP_TYPE, OUTPUT_SERIAL) VALUES ('10051216', '1005','37','1', '216');INSERT INTO CFG_SYS_BROAD_FIELD (ID, FILE_ID, MAP_FORMULA, MAP_TYPE, OUTPUT_SERIAL) VALUES ('10051217', '1005','38','1', '217');INSERT INTO CFG_SYS_BROAD_FIELD (ID, FILE_ID, MAP_FORMULA, MAP_TYPE, OUTPUT_SERIAL) VALUES ('10191216', '1019','32','1', '216');INSERT INTO CFG_SYS_BROAD_FIELD (ID, FILE_ID, MAP_FORMULA, MAP_TYPE, OUTPUT_SERIAL) VALUES ('10191217', '1019','33','1', '217');INSERT INTO CFG_SYS_BROAD_FIELD (ID, FILE_ID, MAP_FORMULA, MAP_TYPE, OUTPUT_SERIAL) VALUES ('10071222', '1007','26','1', '222');INSERT INTO CFG_SYS_BROAD_FIELD (ID, FILE_ID, MAP_FORMULA, MAP_TYPE, OUTPUT_SERIAL) VALUES ('10021217', '1002','37','1', '217');INSERT INTO CFG_SYS_BROAD_FIELD (ID, FILE_ID, MAP_FORMULA, MAP_TYPE, OUTPUT_SERIAL) VALUES ('10021216', '1002','36','1', '216');?3、修改dic_vendor_field_def
?
?
insert into dic_vendor_field_def (ID, PERF_CLASS, FIELD_ID, SERIAL, FIELD_TYPE, FIELD_VENDOR_LABEL, FIELD_NAME, TABLE_NAME, TABLE_COLUMN, TABLE_COLUMN_TYPE, FIELD_FORMULA, IS_AVAILABLE, IS_INDEX, IND_TABLE_NAME, IND_TABLE_COLUMN, IND_TABLE_COLUMN_TYPE, SQLLDR_DATATYPE, GROUP_NAME, REMARK, PROJECTIONS, ISJUMP)values (50000222, 'L0501', 'MC0101840219', 219, 1, 222, 'APN_IU', 'perf_o_tdr_v1', 'APN_IU', 'char', '', 3, 0, '', '219', '', '', '', '', 'L0513,L0506', 1);??
?
insert into CFG_SYS_BROAD_FIELD (ID, FILE_ID, MAP_FORMULA, MAP_TYPE, REMARK, OUTPUT_SERIAL)values ('10131217', '1013', '40', 1, '', 217);insert into CFG_SYS_BROAD_FIELD (ID, FILE_ID, MAP_FORMULA, MAP_TYPE, REMARK, OUTPUT_SERIAL)values ('10131216', '1013', '39', 1, '', 216);insert into CFG_SYS_BROAD_FIELD (ID, FILE_ID, MAP_FORMULA, MAP_TYPE, REMARK, OUTPUT_SERIAL)values ('10171216', '1017', '32', 1, '', 216);insert into CFG_SYS_BROAD_FIELD (ID, FILE_ID, MAP_FORMULA, MAP_TYPE, REMARK, OUTPUT_SERIAL)values ('10171217', '1017', '33', 1, '', 217);insert into CFG_SYS_BROAD_FIELD (ID, FILE_ID, MAP_FORMULA, MAP_TYPE, REMARK, OUTPUT_SERIAL)values ('10051216', '1005', '37', 1, '', 216);insert into CFG_SYS_BROAD_FIELD (ID, FILE_ID, MAP_FORMULA, MAP_TYPE, REMARK, OUTPUT_SERIAL)values ('10051217', '1005', '38', 1, '', 217);insert into CFG_SYS_BROAD_FIELD (ID, FILE_ID, MAP_FORMULA, MAP_TYPE, REMARK, OUTPUT_SERIAL)values ('10191216', '1019', '32', 1, '', 216);insert into CFG_SYS_BROAD_FIELD (ID, FILE_ID, MAP_FORMULA, MAP_TYPE, REMARK, OUTPUT_SERIAL)values ('10191217', '1019', '33', 1, '', 217);insert into CFG_SYS_BROAD_FIELD (ID, FILE_ID, MAP_FORMULA, MAP_TYPE, REMARK, OUTPUT_SERIAL)values ('10071222', '1007', '26', 1, '', 222);insert into CFG_SYS_BROAD_FIELD (ID, FILE_ID, MAP_FORMULA, MAP_TYPE, REMARK, OUTPUT_SERIAL)values ('10021217', '1002', '37', 1, '', 217);insert into CFG_SYS_BROAD_FIELD (ID, FILE_ID, MAP_FORMULA, MAP_TYPE, REMARK, OUTPUT_SERIAL)values ('10021216', '1002', '36', 1, '', 216);4、修改代码
?
package com.metarnet.VASROAM.formula;import java.util.Map;public class GetApnName extends FormulaAbstract {@Overridepublic String getResult(Map<String, String> pMap, String szLine, String oldValue) {//if(oldValue == null){//return null ;//}else {//return oldValue.toLowerCase() ;//}// modity by shma1664 2012年5月11日 09:31:30if(oldValue != null && oldValue.length() != 0 && !oldValue.equals("")) {return oldValue ;} else {String apn_iu = pMap.get(this.params[0]);if(apn_iu != null && apn_iu.length() != 0 && !apn_iu.equals("")) {return apn_iu;}}return null;}}??