echajoa/sell/car_info_proc_____db_insert______success.php

<?php
	include $_SERVER['DOCUMENT_ROOT'].'/common/lib/comm.php';
//	include $_SERVER['DOCUMENT_ROOT'].'/common/auth_chk.php';

header("Content-Type: text/html; charset=utf-8"); 

//	$OWNER_NM = $_POST[nm_name];
//	$VHRNO = $_POST[nm_number];
	$OWNER_NM = "구일호";
	$VHRNO = "68소5427";
	$arrCarInfo = array("OWNER_NM"=>$OWNER_NM, "VHRNO"=>$VHRNO);

////echo "1";
//
//echo json_decode("1");
//
//echo "<br>";

$content = json_encode($arrCarInfo);

//echo "2";
//
//echo "<br>";

$url = "https://carinfo.dev.carisyou.net/carinfo/esmotors/S1/2";

$curl = curl_init($url);

//echo "3";
//
//echo "<br>";

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 "<br>";

$json_response = curl_exec($curl);

//echo "5";
//
//echo "<br>";


$status = curl_getinfo($curl, CURLINFO_HTTP_CODE);

//echo "6";
//
//echo "<br>";


//echo $status;

//echo "<br>";

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 "<br>";


$response = json_decode($json_response, true);

//echo $json_response;

//echo "<br>";

echo $response;

echo "<br>";

echo count($response[INFO]);

echo "<br>";

echo count($response[INFO][CARINFO]);

echo "<br>";

echo $response[INFO][CARINFO][IMPORT_YN];

echo "<br>";

//$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 "<br>";

	$result  = mysql_query($sql,$connect);		
	$cd_info_log  = mysql_insert_id();

echo $cd_info_log;

echo "<br>";

//$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 "<br>";


	$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 "<br>";

//brand 중복체크/입력


//model 중복체크/입력

	$_whereis = " nm_model = '".$response[INFO][CARINFO][REP_CAR_CLASS_NM]."' and cd_brand = '".$cd_brand."'";

echo $_whereis;

echo "<br>";


	$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 "<br>";

//model 중복체크/입력


//model_sub 중복체크/입력

	$_whereis = " nm_model_sub = '".$response[INFO][CARINFO][CAR_CLASS_NM]."' and cd_model = '".$cd_model."'";

echo $_whereis;

echo "<br>";


	$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 "<br>";
echo "<br>";
echo "<br>";
echo "<br>";
echo "<br>";
echo "<br>";
echo "<br>";
echo "<br>";
echo "<br>";
echo "<br>";

//model_sub 중복체크/입력


//grade 중복체크/입력
	
	for ($i=0;$i<count($response[INFO][CARINFO][GRADE_LIST]);$i++){
echo $response[INFO][CARINFO][GRADE_LIST][$i][CAR_GRADE_NM];

echo "<br>";
	$_whereis = " nm_grade = '".$response[INFO][CARINFO][GRADE_LIST][$i][CAR_GRADE_NM]."' and cd_model_sub = '".$cd_model_sub."'";

echo $_whereis;

echo "<br>";


	$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 "<br>";
	}


//grade 중복체크/입력


/*
*/


mysql_close($connect);

?>