echajoa/sell/car_info_proc.php

<?php
	include $_SERVER['DOCUMENT_ROOT'].'/common/lib/comm.php';
//	include $_SERVER['DOCUMENT_ROOT'].'/common/auth_chk.php';
	exit;
header("Content-Type: text/html; charset=utf-8");

	$OWNER_NM = $_POST[nm_name];
	$VHRNO = $_POST[nm_number];
//	$OWNER_NM = "염수환";
//	$VHRNO = "37저4633";
	$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";

//운영
$url = "https://usedcar.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 중복체크/입력


//$response 에 자체 코드값 추가 : $cd_category, $cd_brand, $cd_model, $cd_model_sub
$response[INFO][CARINFO][CD_CATEGORY] = $cd_category;
$response[INFO][CARINFO][CD_BRAND] = $cd_brand;
$response[INFO][CARINFO][CD_MODEL] = $cd_model;
$response[INFO][CARINFO][CD_MODEL_SUB] = $cd_model_sub;

/*
array_push($response[INFO][CARINFO][CD_CATEGORY], $cd_category);
array_push($response[INFO][CARINFO][CD_BRAND], $cd_brand);
array_push($response[INFO][CARINFO][CD_MODEL], $cd_model);
array_push($response[INFO][CARINFO][CD_MODEL_SUB], $cd_model_sub);
*/

/*
function raw_json_encode($input, $flags = 0) {
    $fails = implode('|', array_filter(array(
        '\\\\',
        $flags & JSON_HEX_TAG ? 'u003[CE]' : '',
        $flags & JSON_HEX_AMP ? 'u0026' : '',
        $flags & JSON_HEX_APOS ? 'u0027' : '',
        $flags & JSON_HEX_QUOT ? 'u0022' : '',
    )));
    $pattern = "/\\\\(?:(?:$fails)(*SKIP)(*FAIL)|u([0-9a-fA-F]{4}))/";
    $callback = function ($m) {
        return html_entity_decode("&#x$m[1];", ENT_QUOTES, 'UTF-8');
    };
    return preg_replace_callback($pattern, $callback, json_encode($input, $flags));
}

echo raw_json_encode(json_encode($response));
*/

echo json_encode($response);

/*
*/


mysql_close($connect);

?>