$OWNER_NM, "VHRNO"=>$VHRNO);
////echo "1";
//
//echo json_decode("1");
//
//echo "
";
$content = json_encode($arrCarInfo);
//echo "2";
//
//echo "
";
$url = "https://carinfo.dev.carisyou.net/carinfo/esmotors/S1/2";
$curl = curl_init($url);
//echo "3";
//
//echo "
";
curl_setopt($curl, CURLOPT_HEADER, false);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
curl_setopt($curl, CURLOPT_HTTPHEADER, array("Content-type: application/json"));
curl_setopt($curl, CURLOPT_POST, true);
curl_setopt($curl, CURLOPT_POSTFIELDS, $content);
//echo "4";
//
//echo "
";
$json_response = curl_exec($curl);
//echo "5";
//
//echo "
";
$status = curl_getinfo($curl, CURLINFO_HTTP_CODE);
//echo "6";
//
//echo "
";
//echo $status;
//echo "
";
if ( $status != 200 ) {
die("Error: call to URL $url failed with status $status, response $json_response, curl_error " . curl_error($curl) . ", curl_errno " . curl_errno($curl));
}
curl_close($curl);
//echo "7";
//echo "
";
$response = json_decode($json_response, true);
//echo $json_response;
//echo "
";
echo $response;
echo "
";
echo count($response[INFO]);
echo "
";
echo count($response[INFO][CARINFO]);
echo "
";
echo $response[INFO][CARINFO][IMPORT_YN];
echo "
";
//$json_response log 입력
$sql="insert into car_info_log(cd_user,nm_name,nm_hp,info,dt_insert,nm_insert,dt_update,nm_update,ds_delind)
values('".$_SESSION['s_cd_user']."','".$_SESSION['s_nm_name']."','".$_SESSION['s_nm_hp']."','".$json_response."',now(),'',now(),'','N')";
echo $sql;
//exit;
echo "
";
$result = mysql_query($sql,$connect);
$cd_info_log = mysql_insert_id();
echo $cd_info_log;
echo "
";
//$json_response log 입력
//brand 중복체크/입력
$cd_category = ($response[INFO][CARINFO][IMPORT_YN] == "Y") ? "2":"1";
$_whereis = " nm_brand = '".$response[INFO][CARINFO][BRAND_NM]."' and cd_category = '".$cd_category."'";
echo $_whereis;
echo "
";
$cd_brand = $dbCon->getOneDAO("cd_brand","car_brand", $_whereis, 1);
if($cd_brand) {
} else {
$sql="insert into car_brand(nm_brand,cd_category,ds_status,dt_insert,nm_insert,dt_update,nm_update,ds_delind)
values('".$response[INFO][CARINFO][BRAND_NM]."','".$cd_category."','A0',now(),'',now(),'','N')";
$result = mysql_query($sql,$connect);
$cd_brand = mysql_insert_id();
}
echo $cd_brand;
echo "
";
//brand 중복체크/입력
//model 중복체크/입력
$_whereis = " nm_model = '".$response[INFO][CARINFO][REP_CAR_CLASS_NM]."' and cd_brand = '".$cd_brand."'";
echo $_whereis;
echo "
";
$cd_model = $dbCon->getOneDAO("cd_model","car_model", $_whereis, 1);
if($cd_model) {
} else {
$sql="insert into car_model(nm_model,cd_category,cd_brand,ds_status,ds_cate,dt_insert,nm_insert,dt_update,nm_update,ds_delind)
values('".$response[INFO][CARINFO][REP_CAR_CLASS_NM]."','".$cd_category."','".$cd_brand."','A0','A0',now(),'',now(),'','N')";
$result = mysql_query($sql,$connect);
$cd_model = mysql_insert_id();
}
echo $cd_model;
echo "
";
//model 중복체크/입력
//model_sub 중복체크/입력
$_whereis = " nm_model_sub = '".$response[INFO][CARINFO][CAR_CLASS_NM]."' and cd_model = '".$cd_model."'";
echo $_whereis;
echo "
";
$cd_model_sub = $dbCon->getOneDAO("cd_model_sub","car_model_sub", $_whereis, 1);
if($cd_model_sub) {
} else {
$sql="insert into car_model_sub(nm_model_sub,cd_category,cd_model,ds_status,ds_cate,dt_insert,nm_insert,dt_update,nm_update,ds_delind)
values('".$response[INFO][CARINFO][CAR_CLASS_NM]."','".$cd_category."','".$cd_model."','A0','A0',now(),'',now(),'','N')";
$result = mysql_query($sql,$connect);
$cd_model_sub = mysql_insert_id();
}
echo $cd_model_sub;
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
//model_sub 중복체크/입력
//grade 중복체크/입력
for ($i=0;$i";
$_whereis = " nm_grade = '".$response[INFO][CARINFO][GRADE_LIST][$i][CAR_GRADE_NM]."' and cd_model_sub = '".$cd_model_sub."'";
echo $_whereis;
echo "
";
$cd_grade = $dbCon->getOneDAO("cd_grade","car_grade", $_whereis, 1);
if($cd_grade) {
} else {
$sql="insert into car_grade(nm_grade,cd_model_sub,ds_status,dt_insert,nm_insert,dt_update,nm_update,ds_delind)
values('".$response[INFO][CARINFO][GRADE_LIST][$i][CAR_GRADE_NM]."','".$cd_model_sub."','A0',now(),'',now(),'','N')";
$result = mysql_query($sql,$connect);
$cd_grade = mysql_insert_id();
}
echo $cd_grade;
echo "
";
}
//grade 중복체크/입력
/*
*/
mysql_close($connect);
?>