<?php
//API 모음
session_start();

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


//게시판 글쓰기
$mode = trim(avoid_crack($_REQUEST["mode"]));


switch($mode) {


	case "listModelSubByModel" :
		$where = "";
		if($pcode ==""){

		}else{
			//$where .=" AND ds_domestic ='$pcode' ";
			$where .=" AND cd_model ='$pcode' ";
		}
		$sql = "SELECT cd_model_sub as seq, cd_model_sub as code , nm_model_sub as name , '' as pcode  , '' as etc
				 FROM  car_model_sub WHERE  ds_delind = 'N' $where  ORDER by cd_model_sub asc ";

		$rows = mysql_query($sql);

		$jsonArray = array();
		while($row = mysql_fetch_array($rows)) {
			array_push($jsonArray,$row);
		}
	   	echo json_encode($jsonArray);

	break;
	case "listGradeByModelSub" :
		$where = "";
		if($pcode ==""){

		}else{
			//$where .=" AND ds_domestic ='$pcode' ";
			$where .=" AND cd_model_sub ='$pcode' ";
		}
		$sql = "SELECT cd_grade as seq, cd_grade as code , nm_grade as name , '' as pcode  , '' as etc
				 FROM  car_grade WHERE  ds_delind = 'N' $where  ORDER by cd_grade asc ";

		$rows = mysql_query($sql);

		$jsonArray = array();
		while($row = mysql_fetch_array($rows)) {
			array_push($jsonArray,$row);
		}
	   	echo json_encode($jsonArray);

	break;
	case "listModelBybrandAndCate" :
		$where = "";
		if($pcode ==""){

		}else{
			//$where .=" AND ds_domestic ='$pcode' ";
			$where .=" AND cd_brand ='$pcode' ";
		}

		if($cd_category ==""){

		}else{
			//$where .=" AND ds_domestic ='$pcode' ";
			$where .=" AND cd_category ='$cd_category' ";
		}

		$sql = "SELECT cd_model as seq, cd_model as code , nm_model as name , '' as pcode  , '' as etc
				 FROM  car_model WHERE  ds_delind = 'N' $where  ORDER by nm_model asc ";

		$rows = mysql_query($sql);
		$jsonArray = array();
		while($row = mysql_fetch_array($rows)) {
			array_push($jsonArray,$row);
		}
	   	echo json_encode($jsonArray);

	break;
	case "listModelBybrand" :
		$where = "";
		if($pcode ==""){

		}else{
			//$where .=" AND ds_domestic ='$pcode' ";
			$where .=" AND cd_brand ='$pcode' ";
		}
		$sql = "SELECT cd_model as seq, cd_model as code , nm_model as name , '' as pcode  , '' as etc
				 FROM  car_model WHERE  ds_delind = 'N' $where  ORDER by nm_model asc ";

		$rows = mysql_query($sql);

		$jsonArray = array();
		while($row = mysql_fetch_array($rows)) {
			array_push($jsonArray,$row);
		}
	   	echo json_encode($jsonArray);

	break;

	case "listBrandBycate" :
		$where = "";
		if($pcode ==""){

		}else{
			//$where .=" AND ds_domestic ='$pcode' ";
			$where .=" AND cd_category ='$pcode' ";
		}
		$sql = "SELECT cd_brand as seq, cd_brand as code , nm_brand as name , '' as pcode  , '' as etc
				 FROM  car_brand WHERE  ds_delind = 'N' $where  ORDER by nm_brand asc ";

		$rows = mysql_query($sql);

		$jsonArray = array();
		while($row = mysql_fetch_array($rows)) {
			array_push($jsonArray,$row);
		}
	   	echo json_encode($jsonArray);

	break;


	case "listConsultant" :
		$where = "";

		$sql = "SELECT cd_consultant as seq, cd_consultant as code , nm_name as name , '' as pcode  , '' as etc
				 FROM  consultant_master WHERE  ds_delind = 'N' $where  ORDER by cd_consultant asc ";

		$rows = mysql_query($sql);

		$jsonArray = array();
		while($row = mysql_fetch_array($rows)) {
			array_push($jsonArray,$row);
		}
	   	echo json_encode($jsonArray);

	break;
	//  차량 브랜드
	case "listBrand" :
		$where = "";
		if($pcode ==""){

		}else{
			//$where .=" AND ds_domestic ='$pcode' ";
			$where .=" AND cd_category ='$pcode' ";
		}
		/*
		$sql = "SELECT cd_brand as seq, cd_brand as code , nm_brand as name , '' as pcode  , '' as etc
				 FROM  car_brand WHERE  ds_delind = 'N' AND ds_status = 'A0' $where ORDER by cd_brand desc ";
*/

		$sql = "SELECT cd_brand as seq, cd_brand as code , nm_brand as name , '' as pcode  , '' as etc
				 FROM  car_brand WHERE  ds_delind = 'N' AND ds_status = 'A0' $where ORDER by nm_brand asc ";


		$rows = mysql_query($sql);

		$jsonArray = array();
		while($row = mysql_fetch_array($rows)) {
			array_push($jsonArray,$row);
		}
	   	echo json_encode($jsonArray);

	break;

	case "listModelBybrand" :
		$where = "";
		if($pcode ==""){

		}else{
			$where .=" AND cd_brand ='$pcode' ";
		}

		$sql = "SELECT cd_model as seq, cd_model as code , nm_model as name , '' as pcode  , '' as etc
				 FROM  car_model WHERE  ds_delind = 'N' $where  ORDER by nm_model asc ";

		$rows = mysql_query($sql);

		$jsonArray = array();
		while($row = mysql_fetch_array($rows)) {
			array_push($jsonArray,$row);
		}
	   	echo json_encode($jsonArray);

	break;

	//차량 코드 테이블 내용을 반환한다.
	case "listcode" :

		//코드정보 JSON RETURN
		$nm_table = trim(avoid_crack($_REQUEST["nm_table"]));
		$nm_column = trim(avoid_crack($_REQUEST["nm_column"]));
		$pcode = trim(avoid_crack($_REQUEST["pcode"]));

		$sql = "SELECT cd_seq as seq, nm_code as code , nm_name as name , nm_pcode as pcode , nm_etc_01 as etc
				 FROM  code_master WHERE  nm_table ='$nm_table' AND nm_column='$nm_column' and  ds_delind = 'N'";

		if($pcode!=""){
			$sql = $sql . " 	AND nm_pcode ='$pcode'";
		}
		if($nm_column == "ds_year"){
			$sql = $sql . " 	Order by no_order desc ";
		}else{
			$sql = $sql . " 	Order by no_order asc ";
		}

		$rows = mysql_query($sql);

		$jsonArray = array();
		while($row = mysql_fetch_array($rows)) {
			array_push($jsonArray,$row);
		}
	   	echo json_encode($jsonArray);

	break;

	//차량 카테고리 정보를 반환한다.
	case "listcate" :
		$sql = "SELECT cd_seq as seq, cd_seq as code , nm_class as name , '' as pcode  , '' as etc
				 FROM  cate_master WHERE  ds_open ='Y' AND  ds_delind = 'N' ORDER by cd_seq desc ";

		$rows = mysql_query($sql);

		$jsonArray = array();
		while($row = mysql_fetch_array($rows)) {
			array_push($jsonArray,$row);
		}
	   	echo json_encode($jsonArray);

	break;

	//차량 카테고리 정보를 반환한다.
	case "listcategory" :
		$sql = "SELECT cd_category as seq, cd_category as code , nm_category as name , '' as pcode  , '' as etc
				 FROM  car_category WHERE ds_delind = 'N' ORDER by cd_category desc ";

		$rows = mysql_query($sql);

		$jsonArray = array();
		while($row = mysql_fetch_array($rows)) {
			array_push($jsonArray,$row);
		}
	   	echo json_encode($jsonArray);

	break;

	//차량 클래스에 속한 차량 정보를 반환한다.
	case "listcar" :

		$pcode = trim(avoid_crack($_REQUEST["pcode"]));
		$sql = "SELECT cd_seq as seq, cd_seq as code , nm_model as name , '' as pcode  , '' as etc
				 FROM  car_master WHERE  cd_cate = '$pcode' and ds_open ='Y' AND  ds_delind = 'N' AND ds_front ='Y' ORDER by cd_seq desc ";

		$rows = mysql_query($sql);
		$jsonArray = array();
		while($row = mysql_fetch_array($rows)) {
			array_push($jsonArray,$row);
		}
	   	echo json_encode($jsonArray);

	break;

	case "listtypeofcar" :

		$pcode = trim(avoid_crack($_REQUEST["pcode"]));
		//$cate = $pcode['cd_cate'];
		//$type = $pcode['nm_type'];
		$nm_column = trim(avoid_crack($_REQUEST["nm_column"]));
		$sql = "SELECT cd_seq as seq, cd_seq as code , nm_model as name , '' as pcode  , '' as etc
				 FROM  car_master WHERE  cd_cate = '$pcode' and nm_type='$nm_column' and ds_open ='Y' AND  ds_delind = 'N' AND ds_front ='Y' ORDER by cd_seq desc ";

		$rows = mysql_query($sql);
		$jsonArray = array();
		while($row = mysql_fetch_array($rows)) {
			array_push($jsonArray,$row);
		}
	   	echo json_encode($jsonArray);

	break;

		//차량 모델에 속한 차량 정보를 반환한다.
	case "listModel" :
		$pcode = trim(avoid_crack($_REQUEST["pcode"]));
		if($pcode==""){
			$sql = "SELECT cd_model as seq, cd_model as code , nm_model as name , '' as pcode  , '' as etc
				 FROM  car_model WHERE  ds_delind = 'N' ORDER by no_order asc ";


		}else if($pcode =="Z0"){
			$sql = "SELECT cd_model as seq, cd_model as code , nm_model as name , '' as pcode  , '' as etc
				 FROM  car_model WHERE  ds_delind = 'N' and ds_cate IN ('C0','B0') AND ds_status = 'A0' ORDER by no_order asc ";

		}else{

			$sql = "SELECT cd_model as seq, cd_model as code , nm_model as name , '' as pcode  , '' as etc
				 FROM  car_model WHERE  ds_delind = 'N' and ds_cate = '".$pcode."' AND ds_status = 'A0' ORDER by no_order asc ";

		}

		$rows = mysql_query($sql);

		$jsonArray = array();
		while($row = mysql_fetch_array($rows)) {
			array_push($jsonArray,$row);
		}
	   	echo json_encode($jsonArray);

	break;

	case "listGrade" :

		$sql = "SELECT cd_grade as seq, cd_grade as code , nm_grade as name , '' as pcode  , '' as etc
				 FROM  car_grade WHERE  ds_delind = 'N' AND ds_status = 'A0' AND cd_model ='$pcode' ORDER by nm_grade asc ";


		$rows = mysql_query($sql);

		$jsonArray = array();
		while($row = mysql_fetch_array($rows)) {
			array_push($jsonArray,$row);
		}
	   	echo json_encode($jsonArray);

	break;

	case "areacode":

		$row1 = array('seq' =>'010'  ,'code'=> '010','name'=> '010','pcode'=>'' , 'etc'=>'' );
		$row2 = array('seq' =>'011'  ,'code'=> '011','name'=> '011','pcode'=>'' , 'etc'=>'' );
		$row3 = array('seq' =>'016'  ,'code'=> '016','name'=> '016','pcode'=>'' , 'etc'=>'' );
		$row4 = array('seq' =>'017'  ,'code'=> '017','name'=> '017','pcode'=>'' , 'etc'=>'' );
		$row5 = array('seq' =>'070'  ,'code'=> '070','name'=> '070','pcode'=>'' , 'etc'=>'' );

		$jsonArray = array();

		array_push($jsonArray,$row1);
		array_push($jsonArray,$row2);
		array_push($jsonArray,$row3);
		array_push($jsonArray,$row4);
		array_push($jsonArray,$row5);

   		echo json_encode($jsonArray);
	break;

	case "areacode2":

		$row1 = array('seq'=>'02' ,'code'=>'02','name'=>'02','pcode'=>'','etc'=>'');
		$row2 = array('seq'=>'031' ,'code'=>'031','name'=>'031','pcode'=>'','etc'=>'');
		$row3 = array('seq'=>'032'  ,'code'=>'032','name'=>'032','pcode'=>'','etc'=>'');
		$row4 = array('seq'=>'042'  ,'code'=>'042','name'=>'042','pcode'=>'','etc'=>'');
		$row5 = array('seq'=>'053'  ,'code'=>'053','name'=>'053','pcode'=>'','etc'=>'');
		$row6 = array('seq'=>'062'  ,'code'=>'062','name'=>'062','pcode'=>'','etc'=>'');
		$row7 = array('seq'=>'051'  ,'code'=>'051','name'=>'051','pcode'=>'','etc'=>'');
		$row8 = array('seq'=>'033'  ,'code'=>'033','name'=>'033','pcode'=>'','etc'=>'');
		$row9 = array('seq'=>'034'  ,'code'=>'034','name'=>'034','pcode'=>'','etc'=>'');
		$row10 = array('seq'=>'064'  ,'code'=>'064','name'=>'064','pcode'=>'','etc'=>'');
		$row11 = array('seq'=>'041'  ,'code'=>'041','name'=>'041','pcode'=>'','etc'=>'');
		$row12 = array('seq'=>'043'  ,'code'=>'043','name'=>'043','pcode'=>'','etc'=>'');
		$row13 = array('seq'=>'054'  ,'code'=>'054','name'=>'054','pcode'=>'','etc'=>'');
		$row14 = array('seq'=>'055'  ,'code'=>'055','name'=>'055','pcode'=>'','etc'=>'');
		$row15 = array('seq'=>'063'  ,'code'=>'063','name'=>'063','pcode'=>'','etc'=>'');
		$row16 = array('seq'=>'061'  ,'code'=>'061','name'=>'061','pcode'=>'','etc'=>'');
		$row17 = array('seq'=>'070'  ,'code'=>'070','name'=>'070','pcode'=>'','etc'=>'');

		$jsonArray = array();

		array_push($jsonArray,$row1);
		array_push($jsonArray,$row2);
		array_push($jsonArray,$row3);
		array_push($jsonArray,$row4);
		array_push($jsonArray,$row5);
		array_push($jsonArray,$row6);
		array_push($jsonArray,$row7);
		array_push($jsonArray,$row8);
		array_push($jsonArray,$row9);
		array_push($jsonArray,$row10);
		array_push($jsonArray,$row11);
		array_push($jsonArray,$row12);
		array_push($jsonArray,$row13);
		array_push($jsonArray,$row14);
		array_push($jsonArray,$row15);
		array_push($jsonArray,$row16);
		array_push($jsonArray,$row17);

   		echo json_encode($jsonArray);
	break;

	case "emailtype":
		$jsonArray = array('naver.com','nate.com','empal.com','hotmail.com','lycos.co.kr','msn.com','hanmail.net','yahoo.com','korea.com','kornet.net','yahoo.co.k','kebi.com','orgio.net','paran.com','gmail.com');

	   	echo json_encode($jsonArray);
	break;


	case "listPhone":
		$jsonArray = array();
		$phones = array('010', '011', '016', '017', '018', '019', '070');
		foreach($phones as $key => $phone) {
			$jsonArray[] = array('seq' => $phone, 'code' => $phone, 'name' => $phone, 'pcode' => '', 'etc' => '');
		}

		echo json_encode($jsonArray);
	break;


	case "listTel":
		$jsonArray = array();
		$tels = array('02', '031', '032', '033', '034', '041', '042', '043', '051', '053', '054', '055', '061', '062', '063', '064', '070', '080');
		foreach($tels as $key => $tel) {
			$jsonArray[] = array('seq' => $tel, 'code' => $tel, 'name' => $tel, 'pcode' => '', 'etc' => '');
		}

		echo json_encode($jsonArray);
	break;

	case "listYear":
		$jsonArray = array();
		$cur_year = date("Y");;
		$numbers = array();
		for($i="1900"; $i <= $cur_year; $i++) {
			$numbers[] = $i;
		}
		// rsort($numbers);
		foreach($numbers as $number) {
			$jsonArray[] = array('seq' => sprintf("%02d", $number), 'code' => sprintf("%02d", $number), 'name' => $number, 'pcode' => '', 'etc' => '');
		}

		echo json_encode($jsonArray);
	break;
	case "listMonth":
		$jsonArray = array();
		$cur_year = date("Y");;
		$numbers = array();
		for($i="1"; $i <= 12; $i++) {
			$numbers[] = $i;
		}
		// rsort($numbers);
		foreach($numbers as $number) {
			$jsonArray[] = array('seq' => sprintf("%02d", $number), 'code' => sprintf("%02d", $number), 'name' => $number, 'pcode' => '', 'etc' => '');
		}

		echo json_encode($jsonArray);
	break;
	case "listDay":
		$jsonArray = array();
		$cur_year = date("Y");;
		$numbers = array();
		for($i="1"; $i <= 31; $i++) {
			$numbers[] = $i;
		}
		// rsort($numbers);
		foreach($numbers as $number) {
			$jsonArray[] = array('seq' => sprintf("%02d", $number), 'code' => sprintf("%02d", $number), 'name' => $number, 'pcode' => '', 'etc' => '');
		}

		echo json_encode($jsonArray);
	break;

	case "listEmail":
		$jsonArray = array();
		$emails = array('naver.com', 'daum.net', 'nate.com','gmail.com', 'empal.com','hotmail.com','lycos.co.kr','msn.com','hanmail.net','yahoo.com','korea.com','kornet.net','yahoo.co.kr','kebi.com','orgio.net','paran.com', 'chollian.net', 'dreamwiz.com', 'freechal.com', 'hanafos.com');
		foreach($emails as $key => $email) {
			$jsonArray[] = array('seq' => $email, 'code' => $email, 'name' => $email, 'pcode' => '', 'etc' => '');
		}

		echo json_encode($jsonArray);
	break;

}