<?php
$commonDbArr = include('D:\www\common/db.config.php');
// $commonDbArr = include('D:\webserver\www\common/db.config.php');
$com_config['DB'] = [
    'MAIN' => [
            'db_type'   =>'mysql',
            'db_host'   =>'192.168.1.42',
            'db_port'   =>'3306',
            'db_name'   =>'api_main',
            'db_user'   =>'root',
            'db_pass'   =>'yiparts007',
            'db_charset'=>'utf8'
    ],
    //邮件、短信发送中心
    'SEND' => [
            'db_type'   =>'mysql',
            'db_host'   =>'192.168.1.42',
            'db_port'   =>'3306',
            'db_name'   =>'yp_send_center',
            'db_user'   =>'root',
            'db_pass'   =>'yiparts007',
            'db_charset'=>'utf8'
    ],
    //宜配网非产品库
    'YP_WRITE' => [
            'db_type'   =>'mysql',
            'db_host'   =>'192.168.1.42',
            'db_port'   =>'3306',
            'db_name'   =>'ypdb_write',
            'db_user'   =>'root',
            'db_pass'   =>'yiparts007',
            'db_charset'=>'utf8'
    ],
    //宜配车型库
    'YP' => $commonDbArr['ypdb'],
    'YP_CAR' => $commonDbArr['yp_car'],
    'B2C_CAR' => $commonDbArr['b2c_car'],
    //OEM车型库
    'OEM' => [
            'db_type'   =>'mysql',
            'db_host'   =>'192.168.1.42',
            'db_port'   =>'3306',
            'db_name'   =>'vin_oem',
            'db_user'   =>'root',
            'db_pass'   =>'yiparts007',
            'db_charset'=>'utf8'
    ],
    //JDC车型库
    'JDC' => [
            'db_type'   =>'mysql',
            'db_host'   =>'192.168.1.42',
            'db_port'   =>'3306',
            'db_name'   =>'model_jdcsww',
            'db_user'   =>'root',
            'db_pass'   =>'yiparts007',
            'db_charset'=>'utf8'
    ],
    //CAR车型库
    'CAR' => [
            'db_type'   =>'mysql',
            'db_host'   =>'192.168.1.42',
            'db_port'   =>'3306',
            'db_name'   =>'model_qczj',
            'db_user'   =>'root',
            'db_pass'   =>'yiparts007',
            'db_charset'=>'utf8'
    ],
    //VinCh车型库
    'VinCh' => [
            'db_type'   =>'mysql',
            'db_host'   =>'192.168.1.42',
            'db_port'   =>'3306',
            'db_name'   =>'vin_carhistory',
            'db_user'   =>'root',
            'db_pass'   =>'yiparts007',
            'db_charset'=>'utf8'
    ],
    //VinCh车型库
    'Etk' => [
            'db_type'   =>'mysql',
            'db_host'   =>'192.168.1.67',
            'db_port'   =>'3306',
            'db_name'   =>'realoem_basic',
            'db_user'   =>'root',
            'db_pass'   =>'yiparts007',
            'db_charset'=>'utf8'
    ],
	'TCD' => [
            'db_type'	=>'oci',
			'db_host'	=>'192.168.1.5',
			'db_port'	=>'1521',
			'db_name'	=>'tecdoc_2019_2',
			'db_user'	=>'tecdoc_2019_2',
			'db_pass'	=>'tecdoc007',
			'db_charset'=>'AL32UTF8'
    ],
	//统计库
	'TJ' => [
            'db_type'	=>'oci',
			'db_host'	=>'192.168.1.5',
			'db_port'	=>'1521',
			'db_name'	=>'YPCOM_TONGJI_TEST',
			'db_user'	=>'YPCOM_TONGJI_TEST',
			'db_pass'	=>'ypcom007',
			'db_charset'=>'AL32UTF8'
    ],
	'B2C' => [
			'db_type'	=>'mysql',
			'db_host'	=>'192.168.1.42',
			'db_port'	=>'3306',
			'db_name'	=>'ypb2c',
			'db_user'	=>'root',
			'db_pass'	=>'yiparts007',
			'db_charset'=>'utf8'
	],
	//原厂ETK独立库
	'EPC' => [
		7 => [
			'db_type'	=>'mysql',
			'db_host'	=>'192.168.1.67',
			'db_port'	=>'3306',
			'db_name'	=>'realoem_mercedes',
			'db_user'	=>'root',
			'db_pass'	=>'yiparts007',
			'db_charset'=>'utf8'
		],
		2 => [
			'db_type'	=>'mysql',
			'db_host'	=>'192.168.1.67',
			'db_port'	=>'3306',
			'db_name'	=>'realoem_bmw',
			'db_user'	=>'root',
			'db_pass'	=>'yiparts007',
			'db_charset'=>'utf8'
		],
		11 => [
			'db_type'	=>'mysql',
			'db_host'	=>'192.168.1.67',
			'db_port'	=>'3306',
			'db_name'	=>'realoem_nissan',
			'db_user'	=>'root',
			'db_pass'	=>'yiparts007',
			'db_charset'=>'utf8'
		],
		1 => [
			'db_type'	=>'mysql',
			'db_host'	=>'192.168.1.67',
			'db_port'	=>'3306',
			'db_name'	=>'realoem_wulin',
			'db_user'	=>'root',
			'db_pass'	=>'yiparts007',
			'db_charset'=>'utf8'
		],
		5 => [
			'db_type'	=>'mysql',
			'db_host'	=>'192.168.1.67',
			'db_port'	=>'3306',
			'db_name'	=>'realoem_citroen',
			'db_user'	=>'root',
			'db_pass'	=>'yiparts007',
			'db_charset'=>'utf8'
		],
		12 => [
			'db_type'	=>'mysql',
			'db_host'	=>'192.168.1.67',
			'db_port'	=>'3306',
			'db_name'	=>'realoem_porsche',
			'db_user'	=>'root',
			'db_pass'	=>'yiparts007',
			'db_charset'=>'utf8'
		],
		10 => [
			'db_type'	=>'mysql',
			'db_host'	=>'192.168.1.67',
			'db_port'	=>'3306',
			'db_name'	=>'realoem_vw',
			'db_user'	=>'root',
			'db_pass'	=>'yiparts007',
			'db_charset'=>'utf8'
		],
		13 => [
			'db_type'	=>'mysql',
			'db_host'	=>'192.168.1.67',
			'db_port'	=>'3306',
			'db_name'	=>'realoem_volvo',
			'db_user'	=>'root',
			'db_pass'	=>'yiparts007',
			'db_charset'=>'utf8'
		],
		9 => [
			'db_type'	=>'mysql',
			'db_host'	=>'192.168.1.67',
			'db_port'	=>'3306',
			'db_name'	=>'realoem_honda',
			'db_user'	=>'root',
			'db_pass'	=>'yiparts007',
			'db_charset'=>'utf8'
		],
		8 => [
			'db_type'	=>'mysql',
			'db_host'	=>'192.168.1.67',
			'db_port'	=>'3306',
			'db_name'	=>'realoem_toyota',
			'db_user'	=>'root',
			'db_pass'	=>'yiparts007',
			'db_charset'=>'utf8'
		],
		14 => [
			'db_type'	=>'mysql',
			'db_host'	=>'192.168.1.67',
			'db_port'	=>'3306',
			'db_name'	=>'realoem_mitsubishi',
			'db_user'	=>'root',
			'db_pass'	=>'yiparts007',
			'db_charset'=>'utf8'
		],
		15 => [
			'db_type'	=>'mysql',
			'db_host'	=>'192.168.1.67',
			'db_port'	=>'3306',
			'db_name'	=>'realoem_mazda',
			'db_user'	=>'root',
			'db_pass'	=>'yiparts007',
			'db_charset'=>'utf8'
		],
		4 => [
			'db_type'	=>'mysql',
			'db_host'	=>'192.168.1.67',
			'db_port'	=>'3306',
			'db_name'	=>'realoem_chery',
			'db_user'	=>'root',
			'db_pass'	=>'yiparts007',
			'db_charset'=>'utf8'
		],
		16 => [
			'db_type'	=>'mysql',
			'db_host'	=>'192.168.1.67',
			'db_port'	=>'3306',
			'db_name'	=>'realoem_roewe',
			'db_user'	=>'root',
			'db_pass'	=>'yiparts007',
			'db_charset'=>'utf8'
		],
		3 => [
			'db_type'	=>'mysql',
			'db_host'	=>'192.168.1.67',
			'db_port'	=>'3306',
			'db_name'	=>'realoem_hyundai',
			'db_user'	=>'root',
			'db_pass'	=>'yiparts007',
			'db_charset'=>'utf8'
		],
		17 => [
			'db_type'	=>'mysql',
			'db_host'	=>'192.168.1.67',
			'db_port'	=>'3306',
			'db_name'	=>'realoem_subaru',
			'db_user'	=>'root',
			'db_pass'	=>'yiparts007',
			'db_charset'=>'utf8'
		],
		18 => [
			'db_type'	=>'mysql',
			'db_host'	=>'192.168.1.67',
			'db_port'	=>'3306',
			'db_name'	=>'realoem_gm',
			'db_user'	=>'root',
			'db_pass'	=>'yiparts007',
			'db_charset'=>'utf8'
		],
		19 => [
			'db_type'	=>'mysql',
			'db_host'	=>'192.168.1.67',
			'db_port'	=>'3306',
			'db_name'	=>'realoem_changan',
			'db_user'	=>'root',
			'db_pass'	=>'yiparts007',
			'db_charset'=>'utf8'
		],
		20 => [
			'db_type'	=>'mysql',
			'db_host'	=>'192.168.1.67',
			'db_port'	=>'3306',
			'db_name'	=>'realoem_chrysler',
			'db_user'	=>'root',
			'db_pass'	=>'yiparts007',
			'db_charset'=>'utf8'
		],
		21 => [
			'db_type'	=>'mysql',
			'db_host'	=>'192.168.1.67',
			'db_port'	=>'3306',
			'db_name'	=>'realoem_haima',
			'db_user'	=>'root',
			'db_pass'	=>'yiparts007',
			'db_charset'=>'utf8'
		],
		22 => [
			'db_type'	=>'mysql',
			'db_host'	=>'192.168.1.67',
			'db_port'	=>'3306',
			'db_name'	=>'realoem_gwn',
			'db_user'	=>'root',
			'db_pass'	=>'yiparts007',
			'db_charset'=>'utf8'
		],
		23 => [
			'db_type'	=>'mysql',
			'db_host'	=>'192.168.1.67',
			'db_port'	=>'3306',
			'db_name'	=>'realoem_ford',
			'db_user'	=>'root',
			'db_pass'	=>'yiparts007',
			'db_charset'=>'utf8'
		],
		24 => [
			'db_type'	=>'mysql',
			'db_host'	=>'192.168.1.67',
			'db_port'	=>'3306',
			'db_name'	=>'realoem_bentley',
			'db_user'	=>'root',
			'db_pass'	=>'yiparts007',
			'db_charset'=>'utf8'
		]
	],
	'PJL' => [
		'db_type'   =>'mysql',
		'db_host'   =>'192.168.1.42',
		'db_port'   =>'3306',
		'db_name'   =>'yp_paojieling',
		'db_user'   =>'root',
		'db_pass'   =>'yiparts007',
		'db_charset'=>'utf8'
    ],
	'AAIA' => [
		'db_type'	=>'mysql',
		'db_host'	=>'192.168.1.168',
		'db_port'	=>'6033',
		'db_name'	=>'ypdb_aaia',
		'db_user'	=>'root_pro', 
		'db_pass'	=>'AcHN.M9YKuPqbbCa',
		'db_charset'=>'utf8'
    ],
    'APITJ'=>[
		'db_type'   =>'mysql',
		'db_host'   =>'192.168.1.42',
		'db_port'   =>'3306',
		'db_name'   =>'api_tongji',
		'db_user'   =>'root',
		'db_pass'   =>'yiparts007',
		'db_charset'=>'utf8'
    ],
	'TCDCN'=>[
		'db_type'	=>'mysql',
		'db_host'	=>'192.168.1.67',
		'db_port'	=>'3306',
		'db_name'	=>'realoem_tecdoc_wx',
		'db_user'	=>'root',
		'db_pass'	=>'yiparts007',
		'db_charset'=>'utf8'
	],
	'CART'=>[
		'db_type'	=>'mysql',
		'db_host'	=>'192.168.1.177',
		'db_port'	=>'3306',
		'db_name'	=>'model_cart',
		'db_user'	=>'root',
		'db_pass'	=>'yiparts007',
		'db_charset'=>'utf8'
	],
	'ZHIPEI'=>[
		'db_type'	=>'mysql',
		'db_host'	=>'192.168.1.67',
		'db_port'	=>'3306',
		'db_name'	=>'temp_51cjml',
		'db_user'	=>'root',
		'db_pass'	=>'yiparts007',
		'db_charset'=>'utf8'
	],
	'B2COTH' => [
		'db_type'	=>'mysql',
		'db_host'	=>'192.168.1.42',
		'db_port'	=>'3306',
		'db_name'	=>'b2c_other',
		'db_user'	=>'root',
		'db_pass'	=>'yiparts007',
		'db_charset'=>'utf8'
	],
	'YPCAR67' => [
		'db_type'	=>'mysql',
		'db_host'	=>'192.168.1.67',
		'db_port'	=>'3306',
		'db_name'	=>'yp_car',
		'db_user'	=>'root',
		'db_pass'	=>'yiparts007',
		'db_charset'=>'utf8'
	],
	'YPREAL' => [
		'db_type'	=>'mysql',
		'db_host'	=>'192.168.1.67',
		'db_port'	=>'3306',
		'db_name'	=>'yp_realoem',
		'db_user'	=>'root',
		'db_pass'	=>'yiparts007',
		'db_charset'=>'utf8'
	],
];


$OTHERSITEBASE = [
	'BENDIX'   => 'fac_bendix',
	'SANGSIN'  => 'fac_sangsin',
	'TWBRAKE'  => 'fac_twbrake',
	'FEBEST'   => 'fac_febest',
	'MANN'     => 'fac_mann',
	'FMSI'     => 'fac_fmsi',
	'WIXFILTERS' => 'fac_wixfilters',
	'FRAM'     => 'fac_fram',
	'NGK'      => 'fac_ngk',
	'FMECAT'   => 'fac_fmecat',
];

foreach ($OTHERSITEBASE as $dbk => $dbv) 
{
	$com_config['DB']['site'][$dbk] = [
		'db_type'	=>'mysql',
		'db_host'	=>'192.168.1.67',
		'db_port'	=>'3306',
		'db_name'	=> $dbv,
		'db_user'	=>'root',
		'db_pass'	=>'yiparts007',
		'db_charset'=>'utf8'
	];
}