guomao/DOC/DB/01_data/pub_syspar_data.sql

/**ftp相关*/
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('FILE_SERVER_URL', '文件服务器访问路径(售货机)', 'http://guomaoimg.keao.tech/');
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('FILE_SERVER_BASE_PATH', '文件存放路径', '/home/ftp_file/');
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('FILE_PATH_00', '文件服务器存放目录(图片)', 'guomao/img/');
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('FILE_PATH_01', '文件服务器存放目录(文档)', 'guomao/doc/'); 
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('FILE_PATH_02', '文件服务器存放目录(视频)', 'guomao/video/'); 
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('FILE_PATH_03', '文件服务器存放目录(压缩包)', 'guomao/zips/'); 
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('FTP_IP', '售货机FTP上传IP', '47.97.60.205');
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('FTP_PORT', '售货机FTP上传端口', 21);
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('FTP_USERNAME', '售货机FTP上传用户名', 'guomaoftp');
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('FTP_PASSWORD', '售货机FTP上传密码', 'guomao@2019');
insert into pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE, SPR_TYPE, SPR_SCOPE, SPR_MFLAG) 
values('DEFAULT_PASSWORD','默认密码', 'q1111111','0','0','0');
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('COMPANY_ID_ND', '宁东公司id', 'O100001143');
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('COMPANY_ID_QTX', '青铜峡公司id', 'O100000804');
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('COMPANY_ID_SH', '上海公司id', 'O000001');
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('COMPANY_ID_SX', '山西铝业公司id', '100001');
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('SH_LY_ADDRESS', '上海铝业地址', 'http://47.97.60.205:8099/adm');
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)

INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('APP_ID', '微信AppId', 'wxc1bca6b8f6afcfbd');
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('APP_SECRET', '微信SECRET', 'c18453481763ceeedd1e5a052db761c0');
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('CHECK_VERSION', '当前审核版本', '1.0.1');

INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('ADM_HTTP_URL', '后台内管访问地址', 'http://shanghai.keao.tech/adm/');

INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('OPENACC_NEXT_OPENID', '获取用户OPENID，最后一次ID', '');
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('OPENACC_APPID', '公众号的appID', 'wxa1f93b31a28d069f');
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('OPENACC_APPSECRET', '公众号的AppSecret', '9d601305140210f9c3458feaff5b1b63');

INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('wxa1f93b31a28d069f_TOKEN', '公众号的Token', '');

INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('MINI_APPID', '小程序ID', 'wxfdb9d13de2155f5a');

INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('SCAN_INVOICE_URL', '发票查验API地址', 'https://api.jisuapi.com/invoiceverify/verify');
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('INVOICE_APPKEY', '发票查验appkey', '042969c74511eb72');
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('API_KEY', '百度发票查验apikey', 'A5UwmGm1nDaHcu9GEhwL0d2k');
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('SECRET_KEY', '百度发票查验SecretKey', 'BamxGr7nO2Exc3Yrty1AjMgm2eYqbWA5');
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('TOCKEN_URL', '百度发票查验tocken', 'https://aip.baidubce.com/oauth/2.0/token');
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('BAIDU_URL', '百度发票查验api地址', 'https://aip.baidubce.com/rest/2.0/ocr/v1/vat_invoice');
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('BAIDU_TOCKEN', '20190908', 'https://aip.baidubce.com/rest/2.0/ocr/v1/vat_invoice');

/**结算相关*/
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('CALENDER_START', '自然月结算开始日期', '01');
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('CALENDER_END', '自然月结算结束日期', '31');
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('SPAN_START', '跨月结算开始日期', '26');
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('SPAN_END', '跨月结算结束日期', '25');
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('FUTURES_START', '期货跨月结开始束日期', '16');
INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('FUTURES_END', '期货跨月结算结束日期', '15');

INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('CHECK_LOGIN_MOBILE', '登录验证短信验证码', 'true');

INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('COMM_MOBILE_MODE', '通用验证码模板', '验证码：@，如非本人操作，请忽略本短信【国贸铝业】');

INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('THIS_PART', '国家电投公司ID', '103');

INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('FREE_TRADE_ZONE', '中电投公司ID', '104');

INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('PU_AL_ID', '普铝规格ID', '105');

INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('LOW_IRON_ID', '低铁规格ID', '106');

INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('INVENTORY_KEEPER_ID', '库管ID', '100006');

INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('PUSH_INVOICE_URL', '发票推送接口', 'http//');

INSERT INTO pub_syspar (SPR_CODE, SPR_NAME, SPR_VALUE)
VALUES ('ORDER_DEAFULT_CONTRACT_ID', '默认合同编号', '999999');

INSERT INTO ap_contract_inf(ACI_ID,ACI_NAME,ACI_TYPE,ACI_CONTRACT_TYPE,ACI_BUYER_ID,ACI_CONTRACT_NO,ACI_BRANCH_ID,ACI_STATE,ACI_CHOOSE_TIME)
VALUES('999999','转仓单虚拟合同','00','02','O000001','转仓单虚拟合同','100002','01','19900101000000');