insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values ('操作员状态','IM_USER_STATE','0','ZH_CN','激活','EBPP','0'); insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values ('操作员状态','IM_USER_STATE','2','ZH_CN','暂时停用','EBPP','0'); insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values ('操作员状态','IM_USER_STATE','3','ZH_CN','用户停用','EBPP','0'); insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values ('操作员状态','IM_USER_STATE','4','ZH_CN','永久冻结','EBPP','0'); insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values ('操作员状态','IM_USER_STATE','5','ZH_CN','注销','EBPP','0'); insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values ('订单逾期状态','ORDER_OVERDUE_STT','00','ZH_CN','运行中','EBPP','0'); insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values ('订单逾期状态','ORDER_OVERDUE_STT','01','ZH_CN','已进入宽限期','EBPP','0'); insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values ('主页','MAIN_PAGE_URL','home/bussinessManage.html','ZH_CN','空主页','EBPP','0'); insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values ('主页','MAIN_PAGE_URL','main.html','ZH_CN','经理主页','EBPP','2'); insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values ('主页','MAIN_PAGE_URL','customerManagerCenter/customerManagerCenter.html','ZH_CN','客户经理主页','EBPP','2'); insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values ('主页','MAIN_PAGE_URL','financeManage/financeManage.html','ZH_CN','财务主页','EBPP','2'); insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values ('收支类型','TRADE_TYPE','00','ZH_CN','收入','EBPP','0'); insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values ('收支类型','TRADE_TYPE','01','ZH_CN','支出','EBPP','0'); insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) values('审批状态','APPROVE_AUTH_STT','00','ZH_CN','风控审批','EBPP','0'); insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) values('审批状态','APPROVE_AUTH_STT','01','ZH_CN','风控经理审批','EBPP','0'); insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) values('审批状态','APPROVE_AUTH_STT','02','ZH_CN','风控总监审批','EBPP','0'); insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) values('审批状态','APPROVE_AUTH_STT','03','ZH_CN','财务审批','EBPP','0'); insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) values('审批状态','APPROVE_AUTH_STT','04','ZH_CN','分管领导审批','EBPP','0'); insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) values('审批状态','APPROVE_AUTH_STT','05','ZH_CN','总经理审批','EBPP','0'); insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) values('审批状态','APPROVE_AUTH_STT','90','ZH_CN','客户经理审批','EBPP','0'); insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) values('审批结果','APPROVE_AUTH_RESULT','0','ZH_CN','通过','EBPP','0'); insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) values('审批结果','APPROVE_AUTH_RESULT','1','ZH_CN','拒绝','EBPP','0'); insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) values('操作类型','OPERATION_TYPE','00','ZH_CN','款项确认','EBPP','0'); insert into `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) values('操作类型','OPERATION_TYPE','01','ZH_CN','款项登记','EBPP','0'); INSERT INTO `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) VALUES('是否为客户经理','IS_SUSTOMER_MANAGER','00','ZH_CN','否','EBPP','0'); INSERT INTO `pub_apppar` (`APR_NAME`, `APR_CODE`, `APR_VALUE`, `APR_LANGUAGE`, `APR_SHOWMSG`, `APR_TYPE`, `APR_MFLAG`) VALUES('是否为客户经理','IS_SUSTOMER_MANAGER','01','ZH_CN','是','EBPP','0'); INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES ('币种','CURRENCY_TYPE','00','ZH_CN','美元','EBPP','0'); INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES ('币种','CURRENCY_TYPE','01','ZH_CN','欧元','EBPP','0'); INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES ('币种','CURRENCY_TYPE','02','ZH_CN','英镑','EBPP','0'); INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES ('币种','CURRENCY_TYPE','03','ZH_CN','泰铢','EBPP','0'); INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES ('币种','CURRENCY_TYPE','04','ZH_CN','港币','EBPP','0'); INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES ('币种','CURRENCY_TYPE','05','ZH_CN','韩元','EBPP','0'); INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES ('币种','CURRENCY_TYPE','06','ZH_CN','日元','EBPP','0'); INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES ('币种','CURRENCY_TYPE','07','ZH_CN','卢布','EBPP','0'); INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES ('币种','CURRENCY_TYPE','08','ZH_CN','人民币','EBPP','0'); INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES ('游戏规则状态','GAME_SETUP_STATE','0','ZH_CN','启用','EBPP','0'); INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES ('游戏规则状态','GAME_SETUP_STATE','1','ZH_CN','停用','EBPP','0'); INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES ('游戏规则状态','GAME_SETUP_STATE','2','ZH_CN','删除','EBPP','0'); INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES ('游戏类型','GAME_SETUP_TYPE','0','ZH_CN','幸运够','EBPP','0'); INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES ('游戏类型','GAME_SETUP_TYPE','1','ZH_CN','游戏购','EBPP','0'); INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES ('游戏类型','GAME_SETUP_TYPE','2','ZH_CN','超级大彩蛋','EBPP','0'); INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES ('是否中奖','IS_DRAW','00','ZH_CN','未中奖','EBPP','0'); INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES ('是否中奖','IS_DRAW','01','ZH_CN','中奖','EBPP','0'); INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES ('是否中奖','IS_DRAW','02','ZH_CN','直接购买','EBPP','0'); INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES ('支付方式','PAY_TYPE','00','ZH_CN','微信','EBPP','0'); INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES ('支付方式','PAY_TYPE','01','ZH_CN','支付宝','EBPP','0'); INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES ('支付方式','PAY_TYPE','02','ZH_CN','余额','EBPP','0'); #订单状态 insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values ('订单状态','ORDER_STATE','80','ZH_CN','已重新支付','EBPP','0'); insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values ('订单状态','ORDER_STATE','90','ZH_CN','已取消','EBPP','0'); insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values ('订单状态','ORDER_STATE','91','ZH_CN','未支付','EBPP','0'); insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values ('订单状态','ORDER_STATE','92','ZH_CN','支付中','EBPP','0'); insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values ('订单状态','ORDER_STATE','00','ZH_CN','已支付','EBPP','0'); #取货状态 INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES ('取货状态','ORDER_PICKUP_STT','00','ZH_CN','未取货','EBPP','0'); INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES ('取货状态','ORDER_PICKUP_STT','01','ZH_CN','已取货','EBPP','0'); INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES ('取货状态','ORDER_PICKUP_STT','02','ZH_CN','取货失败','EBPP','0'); #商品类型 INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES ('商品类型','PRO_TYPE','00','ZH_CN','正常商品','EBPP','0'); INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES ('商品类型','PRO_TYPE','01','ZH_CN','抽奖商品','EBPP','0'); #操作员角色 INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES ('操作员角色','USER_ROLE','00','ZH_CN','补货员','EBPP','0'); INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES ('操作员角色','USER_ROLE','01','ZH_CN','电机检测员','EBPP','0'); INSERT INTO pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) VALUES ('操作员角色','USER_ROLE','02','ZH_CN','核账员','EBPP','0'); #用户状态 insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values ('用户状态','PERSON_STATE','00','ZH_CN','正常','EBPP','0'); insert into pub_apppar (APR_NAME, APR_CODE, APR_VALUE, APR_LANGUAGE, APR_SHOWMSG, APR_TYPE, APR_MFLAG) values ('用户状态','PERSON_STATE','01','ZH_CN','冻结','EBPP','0');