# 广联达上线方案

### 服务器配置

> php服务配置, 修改index.php
>
>域名修改为 <https://www.cyc-fund.com.cn>

`vim ./index.php`

![](./广联达上线方案.md.assets/20220505170925.png)

### 数据库配置

#### 添加 `T_APPLY_JINAN` 表

```sql
-- auto-generated definition
create table T_APPLY_JINAN
(
    APPLY_NO             VARCHAR2(20) not null
        constraint T_APPLY_JINAN_PK
            primary key,
    ENTERPRISE_NAME      VARCHAR2(400),
    ENTERPRISE_CODE      VARCHAR2(20),
    ENTERPRISE_EMAIL     VARCHAR2(40),
    LEGAL_NAME           VARCHAR2(400),
    LEGAL_ID_NO          VARCHAR2(30),
    LEGAL_ID_TYPE        VARCHAR2(2),
    PROJECT_NAME         VARCHAR2(400),
    PROJECT_CODE         VARCHAR2(30),
    PROJECT_AREA         VARCHAR2(6),
    TENDER_TYPE          VARCHAR2(3),
    SECTION_NAME         VARCHAR2(400),
    SECTION_CODE         VARCHAR2(30),
    TENDERER             VARCHAR2(600),
    TENDERER_CODE        VARCHAR2(20),
    AGENCY               VARCHAR2(60),
    TENDERER_ADDRESS     VARCHAR2(400),
    TENDER_BOND          NUMBER(20, 2),
    BASIC_NEED           VARCHAR2(1),
    BASIC_ACCOUNT        VARCHAR2(30),
    BASIC_ACCOUNT_NAME   VARCHAR2(400),
    BASIC_BANK_NAME      VARCHAR2(400),
    BASIC_BANK_CODE      VARCHAR2(50),
    TENDER_BOND_END_TIME VARCHAR2(20),
    TENDER_START_TIME    VARCHAR2(20),
    TENDER_EXPIRE        VARCHAR2(3),
    AGENT_NAME           VARCHAR2(30),
    AGENT_ID_NO          VARCHAR2(30),
    AGENT_ID_TYPE        VARCHAR2(2),
    AGENT_PHONE          VARCHAR2(20),
    BUSINESS_LICENSE_URL VARCHAR2(500),
    TENDER_FILE_URL      VARCHAR2(1000),
    CREATED              VARCHAR2(20),
    POST_DESC_INFO       CLOB,
    APPLY_NO_CREATETIME  NUMBER(20) default '',
    PROCESS_ID           VARCHAR2(15)
)
/

comment on table T_APPLY_JINAN is '济南交易中心申请表'
/

comment on column T_APPLY_JINAN.APPLY_NO is '业务申请码，全局唯一'
/

comment on column T_APPLY_JINAN.ENTERPRISE_NAME is '申请企业名称 '
/

comment on column T_APPLY_JINAN.ENTERPRISE_CODE is '申请企业代码（统一社会信用代码或组织机构代码）'
/

comment on column T_APPLY_JINAN.ENTERPRISE_EMAIL is '企业邮箱'
/

comment on column T_APPLY_JINAN.LEGAL_NAME is '法定代表人名称'
/

comment on column T_APPLY_JINAN.LEGAL_ID_NO is '法定代表人证件号码'
/

comment on column T_APPLY_JINAN.LEGAL_ID_TYPE is '法定代表人证件类型，默认为“01-居民身份证”'
/

comment on column T_APPLY_JINAN.PROJECT_NAME is '项目名称 项目名称'
/

comment on column T_APPLY_JINAN.PROJECT_CODE is '项目编号'
/

comment on column T_APPLY_JINAN.PROJECT_AREA is '项目所在行政区域代码'
/

comment on column T_APPLY_JINAN.TENDER_TYPE is '招标项目业务类型，具体参照“项目业务类型代码'
/

comment on column T_APPLY_JINAN.SECTION_NAME is '标段/标包名称'
/

comment on column T_APPLY_JINAN.SECTION_CODE is '标段/标包编号'
/

comment on column T_APPLY_JINAN.TENDERER is '招标人/采购人'
/

comment on column T_APPLY_JINAN.TENDERER_CODE is '招标人/采购人代码，统一社会信用代码或组织机构代码'
/

comment on column T_APPLY_JINAN.AGENCY is '招标代理'
/

comment on column T_APPLY_JINAN.TENDERER_ADDRESS is '招标/采购人地址'
/

comment on column T_APPLY_JINAN.TENDER_BOND is '保证金金额（元）,最多两位小数'
/

comment on column T_APPLY_JINAN.BASIC_NEED is '保费是否出自企业基本户，0：否，1：是'
/

comment on column T_APPLY_JINAN.BASIC_ACCOUNT is '企业银行基本户账号'
/

comment on column T_APPLY_JINAN.BASIC_ACCOUNT_NAME is '企业银行基本户账户名称'
/

comment on column T_APPLY_JINAN.BASIC_BANK_NAME is '基本户开户银行'
/

comment on column T_APPLY_JINAN.BASIC_BANK_CODE is '基本户开户银行行号'
/

comment on column T_APPLY_JINAN.TENDER_BOND_END_TIME is '保证金递交截止时间'
/

comment on column T_APPLY_JINAN.TENDER_START_TIME is '开标时间'
/

comment on column T_APPLY_JINAN.TENDER_EXPIRE is '投标有效期（天），整数，默认120'
/

comment on column T_APPLY_JINAN.AGENT_NAME is '经办人姓名'
/

comment on column T_APPLY_JINAN.AGENT_ID_NO is '经办人证件号码'
/

comment on column T_APPLY_JINAN.AGENT_ID_TYPE is '经办人证件类型，默认为“01-居民身份证”'
/

comment on column T_APPLY_JINAN.AGENT_PHONE is '经办人手机号'
/

comment on column T_APPLY_JINAN.BUSINESS_LICENSE_URL is '营业执照附件下载路径'
/

comment on column T_APPLY_JINAN.TENDER_FILE_URL is '招标文件下载路径'
/

comment on column T_APPLY_JINAN.CREATED is '提交时间'
/

comment on column T_APPLY_JINAN.POST_DESC_INFO is '请求参数json'
/

comment on column T_APPLY_JINAN.APPLY_NO_CREATETIME is '创建的时间'
/

comment on column T_APPLY_JINAN.PROCESS_ID is '保函订单id'
/
```

#### 修改T_AREA表

##### 备份 

``` sql

INSERT INTO FSDB.T_AREA (AREACODE, AREANAME, SHORTNAME, AREALEVEL, PARENTCODE, CITYCODE, ZIPCODE, MERGERNAME, LNG, LAT, PINYIN) VALUES ('370100', '济南市', '济南', '2', '370000', '0531', '250001', '中国,山东省,济南市', '117.000923', '36.675807', 'Jinan');
INSERT INTO FSDB.T_AREA (AREACODE, AREANAME, SHORTNAME, AREALEVEL, PARENTCODE, CITYCODE, ZIPCODE, MERGERNAME, LNG, LAT, PINYIN) VALUES ('370102', '历下区', '历下', '3', '370100', '0531', '250014', '中国,山东省,济南市,历下区', '117.0768', '36.66661', 'Lixia');
INSERT INTO FSDB.T_AREA (AREACODE, AREANAME, SHORTNAME, AREALEVEL, PARENTCODE, CITYCODE, ZIPCODE, MERGERNAME, LNG, LAT, PINYIN) VALUES ('370103', '市中区', '市中区', '3', '370100', '0531', '250001', '中国,山东省,济南市,市中区', '116.99741', '36.65101', 'Shizhongqu');
INSERT INTO FSDB.T_AREA (AREACODE, AREANAME, SHORTNAME, AREALEVEL, PARENTCODE, CITYCODE, ZIPCODE, MERGERNAME, LNG, LAT, PINYIN) VALUES ('370104', '槐荫区', '槐荫', '3', '370100', '0531', '250117', '中国,山东省,济南市,槐荫区', '116.90075', '36.65136', 'Huaiyin');
INSERT INTO FSDB.T_AREA (AREACODE, AREANAME, SHORTNAME, AREALEVEL, PARENTCODE, CITYCODE, ZIPCODE, MERGERNAME, LNG, LAT, PINYIN) VALUES ('370105', '天桥区', '天桥', '3', '370100', '0531', '250031', '中国,山东省,济南市,天桥区', '116.98749', '36.67801', 'Tianqiao');
INSERT INTO FSDB.T_AREA (AREACODE, AREANAME, SHORTNAME, AREALEVEL, PARENTCODE, CITYCODE, ZIPCODE, MERGERNAME, LNG, LAT, PINYIN) VALUES ('370112', '历城区', '历城', '3', '370100', '0531', '250100', '中国,山东省,济南市,历城区', '117.06509', '36.67995', 'Licheng');
INSERT INTO FSDB.T_AREA (AREACODE, AREANAME, SHORTNAME, AREALEVEL, PARENTCODE, CITYCODE, ZIPCODE, MERGERNAME, LNG, LAT, PINYIN) VALUES ('370113', '长清区', '长清', '3', '370100', '0531', '250300', '中国,山东省,济南市,长清区', '116.75192', '36.55352', 'Changqing');
INSERT INTO FSDB.T_AREA (AREACODE, AREANAME, SHORTNAME, AREALEVEL, PARENTCODE, CITYCODE, ZIPCODE, MERGERNAME, LNG, LAT, PINYIN) VALUES ('370124', '平阴县', '平阴', '3', '370100', '0531', '250400', '中国,山东省,济南市,平阴县', '116.45587', '36.28955', 'Pingyin');
INSERT INTO FSDB.T_AREA (AREACODE, AREANAME, SHORTNAME, AREALEVEL, PARENTCODE, CITYCODE, ZIPCODE, MERGERNAME, LNG, LAT, PINYIN) VALUES ('370125', '济阳县', '济阳', '3', '370100', '0531', '251400', '中国,山东省,济南市,济阳县', '117.17327', '36.97845', 'Jiyang');
INSERT INTO FSDB.T_AREA (AREACODE, AREANAME, SHORTNAME, AREALEVEL, PARENTCODE, CITYCODE, ZIPCODE, MERGERNAME, LNG, LAT, PINYIN) VALUES ('370126', '商河县', '商河', '3', '370100', '0531', '251600', '中国,山东省,济南市,商河县', '117.15722', '37.31119', 'Shanghe');
INSERT INTO FSDB.T_AREA (AREACODE, AREANAME, SHORTNAME, AREALEVEL, PARENTCODE, CITYCODE, ZIPCODE, MERGERNAME, LNG, LAT, PINYIN) VALUES ('370181', '章丘市', '章丘', '3', '370100', '0531', '250200', '中国,山东省,济南市,章丘市', '117.53677', '36.71392', 'Zhangqiu');
```

#####  删除济南地区信息记录

``` sql

delete T_AREA where AREACODE like '3701%';

```

##### 添加新济南地区信息记录

``` sql
INSERT INTO DEV.T_AREA (AREACODE, AREANAME, SHORTNAME, AREALEVEL, PARENTCODE, CITYCODE, ZIPCODE, MERGERNAME, LNG, LAT, PINYIN) VALUES ('370100', '济南市', '济南', '2', '370000', '0531', '250001', '中国,山东省,济南市', '117.000923', '36.675807', 'Jinan');
INSERT INTO DEV.T_AREA (AREACODE, AREANAME, SHORTNAME, AREALEVEL, PARENTCODE, CITYCODE, ZIPCODE, MERGERNAME, LNG, LAT, PINYIN) VALUES ('370101', '济南市区', '历下', '3', '370100', '0531', '250014', '中国,山东省,济南市,历下区', '117.0768', '36.66661', 'Lixia');
INSERT INTO DEV.T_AREA (AREACODE, AREANAME, SHORTNAME, AREALEVEL, PARENTCODE, CITYCODE, ZIPCODE, MERGERNAME, LNG, LAT, PINYIN) VALUES ('370102', '历下区', '市中区', '3', '370100', '0531', '250001', '中国,山东省,济南市,市中区', '116.99741', '36.65101', 'Shizhongqu');
INSERT INTO DEV.T_AREA (AREACODE, AREANAME, SHORTNAME, AREALEVEL, PARENTCODE, CITYCODE, ZIPCODE, MERGERNAME, LNG, LAT, PINYIN) VALUES ('370103', '市中区', '槐荫', '3', '370100', '0531', '250117', '中国,山东省,济南市,槐荫区', '116.90075', '36.65136', 'Huaiyin');
INSERT INTO DEV.T_AREA (AREACODE, AREANAME, SHORTNAME, AREALEVEL, PARENTCODE, CITYCODE, ZIPCODE, MERGERNAME, LNG, LAT, PINYIN) VALUES ('370104', '槐荫区', '天桥', '3', '370100', '0531', '250031', '中国,山东省,济南市,天桥区', '116.98749', '36.67801', 'Tianqiao');
INSERT INTO DEV.T_AREA (AREACODE, AREANAME, SHORTNAME, AREALEVEL, PARENTCODE, CITYCODE, ZIPCODE, MERGERNAME, LNG, LAT, PINYIN) VALUES ('370105', '天桥区', '历城', '3', '370100', '0531', '250100', '中国,山东省,济南市,历城区', '117.06509', '36.67995', 'Licheng');
INSERT INTO DEV.T_AREA (AREACODE, AREANAME, SHORTNAME, AREALEVEL, PARENTCODE, CITYCODE, ZIPCODE, MERGERNAME, LNG, LAT, PINYIN) VALUES ('370112', '历城区', '长清', '3', '370100', '0531', '250300', '中国,山东省,济南市,长清区', '116.75192', '36.55352', 'Changqing');
INSERT INTO DEV.T_AREA (AREACODE, AREANAME, SHORTNAME, AREALEVEL, PARENTCODE, CITYCODE, ZIPCODE, MERGERNAME, LNG, LAT, PINYIN) VALUES ('370113', '长清区', '平阴', '3', '370100', '0531', '250400', '中国,山东省,济南市,平阴县', '116.45587', '36.28955', 'Pingyin');
INSERT INTO DEV.T_AREA (AREACODE, AREANAME, SHORTNAME, AREALEVEL, PARENTCODE, CITYCODE, ZIPCODE, MERGERNAME, LNG, LAT, PINYIN) VALUES ('370114', '章丘区', '济阳', '3', '370100', '0531', '251400', '中国,山东省,济南市,济阳县', '117.17327', '36.97845', 'Jiyang');
INSERT INTO DEV.T_AREA (AREACODE, AREANAME, SHORTNAME, AREALEVEL, PARENTCODE, CITYCODE, ZIPCODE, MERGERNAME, LNG, LAT, PINYIN) VALUES ('370115', '济阳区', '商河', '3', '370100', '0531', '251600', '中国,山东省,济南市,商河县', '117.15722', '37.31119', 'Shanghe');
INSERT INTO DEV.T_AREA (AREACODE, AREANAME, SHORTNAME, AREALEVEL, PARENTCODE, CITYCODE, ZIPCODE, MERGERNAME, LNG, LAT, PINYIN) VALUES ('370116', '莱芜区', '章丘', '3', '370100', '0531', '250200', '中国,山东省,济南市,章丘市', '117.53677', '36.71392', 'Zhangqiu');
INSERT INTO DEV.T_AREA (AREACODE, AREANAME, SHORTNAME, AREALEVEL, PARENTCODE, CITYCODE, ZIPCODE, MERGERNAME, LNG, LAT, PINYIN) VALUES ('370117', '钢城区', '钢城区', '3', '370100', '0531', null, null, null, null, null);
INSERT INTO DEV.T_AREA (AREACODE, AREANAME, SHORTNAME, AREALEVEL, PARENTCODE, CITYCODE, ZIPCODE, MERGERNAME, LNG, LAT, PINYIN) VALUES ('370118', '交通运输委', '交通运输委', '3', '370100', '0531', null, null, null, null, null);
INSERT INTO DEV.T_AREA (AREACODE, AREANAME, SHORTNAME, AREALEVEL, PARENTCODE, CITYCODE, ZIPCODE, MERGERNAME, LNG, LAT, PINYIN) VALUES ('370124', '平阴县', '平阴县', '3', '370100', '0531', null, null, null, null, null);
INSERT INTO DEV.T_AREA (AREACODE, AREANAME, SHORTNAME, AREALEVEL, PARENTCODE, CITYCODE, ZIPCODE, MERGERNAME, LNG, LAT, PINYIN) VALUES ('370126', '商河县', '商河县', '3', '370100', '0531', null, null, null, null, null);
INSERT INTO DEV.T_AREA (AREACODE, AREANAME, SHORTNAME, AREALEVEL, PARENTCODE, CITYCODE, ZIPCODE, MERGERNAME, LNG, LAT, PINYIN) VALUES ('370171', '济南高新技术产业开发区', '济南高新技术产业开发区', '3', '370100', '0531', null, null, null, null, null);
INSERT INTO DEV.T_AREA (AREACODE, AREANAME, SHORTNAME, AREALEVEL, PARENTCODE, CITYCODE, ZIPCODE, MERGERNAME, LNG, LAT, PINYIN) VALUES ('370190', '南山管理委员会', '南山管理委员会', '3', '370100', '0531', null, null, null, null, null);
INSERT INTO DEV.T_AREA (AREACODE, AREANAME, SHORTNAME, AREALEVEL, PARENTCODE, CITYCODE, ZIPCODE, MERGERNAME, LNG, LAT, PINYIN) VALUES ('370191', '济南新旧动能转换先行区', '济南新旧动能转换先行区', '3', '370100', '0531', null, null, null, null, null);
```

### java wawapp config配置

>修改 webapp/config.properties

```properties
jinan_apply_apply_guarantee_page_flow_prod=https://www.cyc-fund.com.cn/applyjinan/applyGuarantee.do?userid=%s&accept_no=%s&timestamp=%s
```