<?
require $_SERVER['DOCUMENT_ROOT'].'/lib/global.php';
// echo $_SERVER['PHP_SELF']."<br/>";
$etongName=explode('/',$_SERVER['PHP_SELF']);
// var_dump($etongName);
$ecompany=explode('_',$etongName[2]);
$tableHead=strtoupper($ecompany[0]);
switch ($tableHead) {
	case 'UMOBI':
		$tableHead='UM';
		break;
	case '7MOBILE':
		$tableHead='7M';
		break;
	case '7MOBLIE':
		$tableHead='7M';
		break;
}
$columnHead=strtolower($tableHead);
// echo $tableHead;


//SK DATA
	if($_REQUEST['MAKE'] == '' && $_REQUEST['FIND_NAME'] == ''){
		$sql	=	"
				SELECT
					 ".$columnHead."_make as make
				FROM
					_".$tableHead."_DATA
				GROUP BY
					".$columnHead."_make
				ORDER BY
					make
				desc
				";
		// exit($sql);
		$rs		=	query($sql);
		for($i=0; $row = assoc($rs); $i++){
			$data[]			=	$row;
		}
	//	echoAr($data);
		if(is_array($data)){
			$TOTAL_CNT	=	getValue('_'.$tableHead.'_DATA', "WHERE 1  GROUP BY ".$columnHead."_make ", 'CNT', 'COUNT('.$columnHead.'_make) as CNT');
			$json_array	=	json_encode(array("LIST" => $data,"TOTAL_CNT" => $TOTAL_CNT));
			exit($json_array);
		}else{
			exit('{"result":"N","message":"일치하는 데이터가 없습니다."}');
		}
	}else if($_REQUEST['NAME'] == '' && $_REQUEST['MAKE'] !='' && $_REQUEST['GROUP'] == '' && $_REQUEST['IDX'] == ''){

		$_ADDFIND	=	'';
		if($_REQUEST['FIND_NAME'] != '' && $_REQUEST['FIND_MODEL'] == '')
			$_ADDFIND .=	" AND LOWER(Atable.".$columnHead."_name) like '%".strtolower($_REQUEST['FIND_NAME'])."%' ";
		if($_REQUEST['FIND_NAME'] == '' && $_REQUEST['FIND_MODEL'] != '')
			$_ADDFIND .=	" AND LOWER(Atable.".$columnHead."_model) like '%".strtolower($_REQUEST['FIND_MODEL'])."%' ";
		if($_REQUEST['FIND_NAME'] != '' && $_REQUEST['FIND_MODEL'] != '')
			$_ADDFIND .=	" AND (LOWER(Atable.".$columnHead."_name) like '%".strtolower($_REQUEST['FIND_NAME'])."%' OR LOWER(".$columnHead."_model) like '%".strtolower($_REQUEST['FIND_MODEL'])."%') ";
$Q=" SELECT
			 Atable.".$columnHead."_name as name
			,Atable.".$columnHead."_model as model
			,Atable.".$columnHead."_make as make
			,Atable.".$columnHead."_model_type as model_type
			,Atable.".$columnHead."_basic_kp_idx as basic_kp_idx
			,Atable.".$columnHead."_first_price as first_price
			,Atable.".$columnHead."_model_order as model_order
			,Atable.".$columnHead."_model_idx as model_idx
			,MD.md_launch_Date
		FROM
			_".$tableHead."_DATA Atable
		LEFT JOIN
			_MOBILE_DATA MD
		on
			Atable.".$columnHead."_model_idx=MD.md_idx
		where
			Atable.".$columnHead."_make	=	'".$_REQUEST['MAKE']."'
		".$_ADDFIND."
		GROUP BY
			".$columnHead."_name
		ORDER BY
			".$columnHead."_model_order desc
			,".$columnHead."_regdate	desc
		";
		// exit($Q);
		$sql	=	query($Q);
		for($i=0; $row = assoc($sql); $i++){
			$row['basic_kp_name']	=	getValue('_PLAN', "WHERE kp_idx = '".$row['basic_kp_idx']."' ", 'kp_fee_data', 'kp_fee_data');
			$data[]			=	$row;
		}
		//echoAr($data);
		if(is_array($data)){
			//$TOTAL_CNT	=	getValue('_SK_DATA', "WHERE sk_make = '".$_REQUEST['MAKE']."' ".$_ADDFIND." GROUP BY sk_name ", 'CNT', 'COUNT(sk_name) as CNT');
			$TOTAL_CNT	=	0;
			$json_array	=	json_encode(array("LIST" => $data,"TOTAL_CNT" => $TOTAL_CNT));
			exit($json_array);
		}else{
			exit('{"result":"N","message":"일치하는 데이터가 없습니다."}');
		}


	//2016-03-15 JJ MAKE 값 없이도 FIND_NAME 할수있게한다.
	}else if($_REQUEST['NAME'] == '' && $_REQUEST['MAKE'] == '' && $_REQUEST['GROUP'] == '' && $_REQUEST['IDX'] == '' && $_REQUEST['FIND_NAME'] != ''){
		$_ADDFIND	=	'';
		if($_REQUEST['FIND_NAME'] != '' && $_REQUEST['FIND_MODEL'] == '') $_ADDFIND .=	" AND LOWER(".$columnHead."_name) like '%".strtolower($_REQUEST['FIND_NAME'])."%' ";
		if($_REQUEST['FIND_NAME'] == '' && $_REQUEST['FIND_MODEL'] != '') $_ADDFIND .=	" AND LOWER(".$columnHead."_model) like '%".strtolower($_REQUEST['FIND_MODEL'])."%' ";
		if($_REQUEST['FIND_NAME'] != '' && $_REQUEST['FIND_MODEL'] != '') $_ADDFIND .=	" AND (LOWER(".$columnHead."_name) like '%".strtolower($_REQUEST['FIND_NAME'])."%' OR LOWER(sk_model) like '%".strtolower($_REQUEST['FIND_MODEL'])."%') ";
		$Q="
				SELECT
					 ".$columnHead."_name as name
					,".$columnHead."_model as model
					,".$columnHead."_make as make
					,".$columnHead."_model_type as model_type
					,".$columnHead."_basic_kp_idx as basic_kp_idx
					,".$columnHead."_first_price as first_price
				FROM
					_".$tableHead."_DATA
				where
					1
				".$_ADDFIND."
				GROUP BY
					".$columnHead."_name
				ORDER BY
					".$columnHead."_model_order desc
					,".$columnHead."_regdate	desc
				";
				// echo $Q;
		$sql	=	query($Q);
		for($i=0; $row = assoc($sql); $i++){
			$row['basic_kp_name']	=	getValue('_PLAN', "WHERE kp_idx = '".$row['basic_kp_idx']."' ", 'kp_fee_data', 'kp_fee_data');
			$data[]			=	$row;
		}
		//echoAr($data);
		if(is_array($data)){
			//$TOTAL_CNT	=	getValue('_SK_DATA', "WHERE 1 ".$_ADDFIND." GROUP BY sk_name ", 'CNT', 'COUNT(sk_name) as CNT');
			$TOTAL_CNT	=	0;
			$json_array	=	json_encode(array("LIST" => $data,"TOTAL_CNT" => $TOTAL_CNT));
			exit($json_array);
		}else{
			exit('{"result":"N","message":"일치하는 데이터가 없습니다."}');
		}

	}else if($_REQUEST['NAME'] !='' && $_REQUEST['FEE'] == '' && $_REQUEST['MAKE'] !='' && $_REQUEST['GROUP'] == '' && $_REQUEST['IDX'] == ''){
		// exit();
		$_ADDFIND	=	'';
		if($_REQUEST['FIND_DATA']) $_ADDFIND .=	" AND LOWER(".$columnHead."_fee_data) like '%".$_REQUEST['FIND_DATA']."%' ";
		if($_REQUEST['FIND_GROUP']) $_ADDFIND .=	" AND LOWER(".$columnHead."_fee_data_group) = '".strtolower($_REQUEST['FIND_GROUP'])."' ";
		$sql	=	"
				SELECT
					 ".$columnHead."_fee_idx	as fee_idx
					,".$columnHead."_fee_data as fee_data
					,".$columnHead."_fee_price as fee_price
					,".$columnHead."_first_price as first_price
					,".$columnHead."_fee_price_nosms as fee_price_nosms
					,".$columnHead."_fee_choice_price as fee_choice_price
					,".$columnHead."_fee_choice_price2 as fee_choice_price2
					,".$columnHead."_fee_tel as fee_tel
					,".$columnHead."_fee_sms as fee_sms
					,".$columnHead."_fee_lte as fee_lte
					,".$columnHead."_prm_idx as prm_idx
					,".$columnHead."_prm_idx2 as prm_idx2
					,".$columnHead."_model_type as model_type
					,".$columnHead."_no_plan_price as no_plan_price
					,".$columnHead."_12month_plan_price as 12month_plan_price
					,".$columnHead."_24month_plan_price as 24month_plan_price
					,".$columnHead."_30month_plan_price as 30month_plan_price
					,".$columnHead."_36month_plan_price as 36month_plan_price
					,".$columnHead."_order as fee_order
				FROM
					_".$tableHead."_DATA
				WHERE
					".$columnHead."_name	=	'".$_REQUEST['NAME']."'
				".$_ADDFIND."
				AND
					".$columnHead."_fee_data NOT like '%맞춤형%'
				GROUP BY
					".$columnHead."_fee_data
				ORDER BY
					".$columnHead."_order desc,
					".$columnHead."_regdate desc
				";
		// exit($sql);
		$rs		=	query($sql);

		for($i=0; $row = assoc($rs); $i++){
			//2016-03-09 JJ 프로모션 연동
			$row['prm_content']	=	'';
			$row['prm_price']	=	'';
			$row['prm_content2']	=	'';
			$row['prm_price2']	=	'';

			if($row['fee_price_nosms'] =='0') {
				$row['fee_price_nosms'] = $row['fee_price'];
			}

			if($row['prm_idx'] > 0){
				$GETPRM				=	getValue('_PROMOTION', "WHERE prm_idx = '".$row['prm_idx']."' AND prm_use = 'Y' ", 'ar', 'prm_content, prm_price');
				$row['prm_content']	=	$GETPRM['prm_content'];
				$row['prm_price']	=	$GETPRM['prm_price'];
			}

			if($row['prm_idx2'] > 0){
				$GETPRM2			=	getValue('_PROMOTION', "WHERE prm_idx = '".$row['prm_idx2']."' AND prm_use = 'Y' ", 'ar', 'prm_content, prm_price');
				$row['prm_content2']=	$GETPRM2['prm_content'];
				$row['prm_price2']	=	$GETPRM2['prm_price'];
			}
			$data[]			=	$row;
		}
		//echoAr($data);
		if(is_array($data)){
			//$TOTAL_CNT	=	getValue('_SK_DATA', "WHERE sk_name	= '".$_REQUEST['NAME']."' ".$_ADDFIND." AND sk_fee_data NOT like '%맞춤형%' GROUP BY sk_fee_data ", 'CNT', 'COUNT(sk_fee_data) as CNT');
			$TOTAL_CNT	=	0;
			$json_array	=	json_encode(array("LIST" => $data,"TOTAL_CNT" => $TOTAL_CNT));
			exit($json_array);
		}else{
			exit('{"result":"N","message":"일치하는 데이터가 없습니다."}');
		}

	}else if($_REQUEST['NAME'] !='' && $_REQUEST['FEE'] !='' && $_REQUEST['GROUP'] == '' && $_REQUEST['IDX'] == ''){
		// echo "string";
		$sql	=	"
				SELECT
					 ".$columnHead."_fee_idx	as fee_idx
					,".$columnHead."_name as name
					,".$columnHead."_fee_data as fee_data
					,".$columnHead."_fee_price as fee_price
					,".$columnHead."_fee_price_nosms as fee_price_nosms
					,".$columnHead."_fee_choice_price as fee_choice_price
					,".$columnHead."_fee_choice_price2 as fee_choice_price2
					,".$columnHead."_fee_sale as fee_sale
					,".$columnHead."_fee_lte as fee_lte
					,".$columnHead."_fee_tel as fee_tel
					,".$columnHead."_fee_sms as fee_sms
					,".$columnHead."_fee_plus as fee_plus
					,".$columnHead."_first_price as first_price
					,".$columnHead."_back_price as back_price
					,".$columnHead."_plus_price as plus_price
					,".$columnHead."_back_all_price as back_all_price
					,".$columnHead."_monthly_all_price as monthly_all_price
					,".$columnHead."_back_regdate as back_regdate
					,".$columnHead."_discount as discount
					,".$columnHead."_prm_idx as prm_idx
					,".$columnHead."_prm_idx2 as prm_idx2
					,".$columnHead."_model_type as model_type
					,".$columnHead."_no_plan_price as no_plan_price
					,".$columnHead."_12month_plan_price as 12month_plan_price
					,".$columnHead."_24month_plan_price as 24month_plan_price
					,".$columnHead."_30month_plan_price as 30month_plan_price
					,".$columnHead."_36month_plan_price as 36month_plan_price
				FROM
					_".$tableHead."_DATA
				WHERE
					".$columnHead."_name	=	'".$_REQUEST['NAME']."' and ".$columnHead."_fee_data	=	'".$_REQUEST['FEE']."'
				GROUP BY
					".$columnHead."_first_price
				ORDER BY
					".$columnHead."_order desc,
					".$columnHead."_regdate desc
				";
		//exit($sql);
		$rs		=	query($sql);
		for($i=0; $row = assoc($rs); $i++){
			//2016-03-09 JJ 프로모션 연동
			$row['prm_content']	=	'';
			$row['prm_price']	=	'';
			$row['prm_content2']	=	'';
			$row['prm_price2']	=	'';

			if($row['fee_price_nosms'] =='0') {
				$row['fee_price_nosms'] = $row['fee_price'];
			}

			if($row['prm_idx'] > 0){
				$GETPRM				=	getValue('_PROMOTION', "WHERE prm_idx = '".$row['prm_idx']."' AND prm_use = 'Y' ", 'ar', 'prm_content, prm_price');
				$row['prm_content']	=	$GETPRM['prm_content'];
				$row['prm_price']	=	$GETPRM['prm_price'];
			}

			if($row['prm_idx2'] > 0){
				$GETPRM2			=	getValue('_PROMOTION', "WHERE prm_idx = '".$row['prm_idx2']."' AND prm_use = 'Y' ", 'ar', 'prm_content, prm_price');
				$row['prm_content2']=	$GETPRM2['prm_content'];
				$row['prm_price2']	=	$GETPRM2['prm_price'];
			}
			$data[]			=	$row;
		}
		//echoAr($data);
		if(is_array($data)){
			//$TOTAL_CNT	=	getValue('_SK_DATA', "WHERE sk_name	=	'".$_REQUEST['NAME']."' and sk_fee_data	=	'".$_REQUEST['FEE']."' ", 'CNT', 'COUNT(*) as CNT');
			$TOTAL_CNT	=	0;
			$json_array	=	json_encode(array("LIST" => $data,"TOTAL_CNT" => $TOTAL_CNT));
			exit($json_array);
		}else{
			exit('{"result":"N","message":"일치하는 데이터가 없습니다."}');
		}

	//2016-03-07 JJ 같은이름의 다른옵션인 요금제가 있어서..
	}else if($_REQUEST['NAME'] !='' && $_REQUEST['IDX'] != '' && $_REQUEST['GROUP'] == '' && $_REQUEST['FEE'] == ''){
// echo "string";
		$sql	=	"
				SELECT
					 ".$columnHead."_fee_idx	as fee_idx
					,".$columnHead."_name as name
					,".$columnHead."_fee_data as fee_data
					,".$columnHead."_fee_price as fee_price
					,".$columnHead."_fee_price_nosms as fee_price_nosms
					,".$columnHead."_fee_choice_price as fee_choice_price
					,".$columnHead."_fee_choice_price2 as fee_choice_price2
					,".$columnHead."_fee_sale as fee_sale
					,".$columnHead."_fee_lte as fee_lte
					,".$columnHead."_fee_tel as fee_tel
					,".$columnHead."_fee_sms as fee_sms
					,".$columnHead."_fee_plus as fee_plus
					,".$columnHead."_first_price as first_price
					,".$columnHead."_back_price as back_price
					,".$columnHead."_plus_price as plus_price
					,".$columnHead."_back_all_price as back_all_price
					,".$columnHead."_monthly_all_price as monthly_all_price
					,".$columnHead."_back_regdate as back_regdate
					,".$columnHead."_discount as discount
					,".$columnHead."_prm_idx as prm_idx
					,".$columnHead."_prm_idx2 as prm_idx2
					,".$columnHead."_model_type as model_type
					,".$columnHead."_no_plan_price as no_plan_price
					,".$columnHead."_12month_plan_price as 12month_plan_price
					,".$columnHead."_24month_plan_price as 24month_plan_price
					,".$columnHead."_30month_plan_price as 30month_plan_price
					,".$columnHead."_36month_plan_price as 36month_plan_price
				FROM
					_".$tableHead."_DATA
				WHERE
					".$columnHead."_name	=	'".$_REQUEST['NAME']."' and ".$columnHead."_fee_idx	=	'".$_REQUEST['IDX']."'
				ORDER BY
					".$columnHead."_order desc,
					".$columnHead."_regdate desc
				";
		//exit($sql);
		$rs		=	query($sql);
		for($i=0; $row = assoc($rs); $i++){
			$row['prm_content']	=	'';
			$row['prm_price']	=	'';
			$row['prm_content2']	=	'';
			$row['prm_price2']	=	'';

			if($row['fee_price_nosms'] =='0') {
				$row['fee_price_nosms'] = $row['fee_price'];
			}

			if($row['prm_idx'] > 0){
				$GETPRM				=	getValue('_PROMOTION', "WHERE prm_idx = '".$row['prm_idx']."' AND prm_use = 'Y' ", 'ar', 'prm_content, prm_price');
				$row['prm_content']	=	$GETPRM['prm_content'];
				$row['prm_price']	=	$GETPRM['prm_price'];
			}

			if($row['prm_idx2'] > 0){
				$GETPRM2			=	getValue('_PROMOTION', "WHERE prm_idx = '".$row['prm_idx2']."' AND prm_use = 'Y' ", 'ar', 'prm_content, prm_price');
				$row['prm_content2']=	$GETPRM2['prm_content'];
				$row['prm_price2']	=	$GETPRM2['prm_price'];
			}
			$data[]			=	$row;
		}
		//echoAr($data);
		if(is_array($data)){
			//$TOTAL_CNT	=	getValue('_SK_DATA', "WHERE sk_name	=	'".$_REQUEST['NAME']."' and sk_fee_data	=	'".$_REQUEST['IDX']."' ", 'CNT', 'COUNT(*) as CNT');
			$TOTAL_CNT	=	0;
			$json_array	=	json_encode(array("LIST" => $data,"TOTAL_CNT" => $TOTAL_CNT));
			exit($json_array);
		}else{
			exit('{"result":"N","message":"일치하는 데이터가 없습니다."}');
		}

	//2016-02-22 JJ 기기 + 요금제만 받아서 요금제 그룹 호출
	}else if($_REQUEST['NAME'] !='' && $_REQUEST['FEE'] != '' && $_REQUEST['MODE'] == 'GROUP' && $_REQUEST['IDX'] == ''){
		// echo "string";
		$sql	=	"
				SELECT
					 ".$columnHead."_name as name
					,".$columnHead."_fee_data as fee_data
					,".$columnHead."_fee_price_nosms as fee_price_nosms
					,".$columnHead."_fee_data_group as fee_data_group
					,".$columnHead."_prm_idx as prm_idx
					,".$columnHead."_prm_idx2 as prm_idx2
					,".$columnHead."_model_type as model_type
					,".$columnHead."_no_plan_price as no_plan_price
					,".$columnHead."_12month_plan_price as 12month_plan_price
					,".$columnHead."_24month_plan_price as 24month_plan_price
					,".$columnHead."_30month_plan_price as 30month_plan_price
					,".$columnHead."_36month_plan_price as 36month_plan_price
					,".$columnHead."_first_price as first_price
				FROM
					_".$tableHead."_DATA
				WHERE
					".$columnHead."_name		=	'".$_REQUEST['NAME']."'
				AND
					".$columnHead."_fee_data	=	'".$_REQUEST['FEE']."'
				AND
					".$columnHead."_fee_data NOT like '%맞춤형%'
				ORDER BY
					".$columnHead."_order desc,
					".$columnHead."_regdate desc
				";
		//exit($sql);
		$rs		=	query($sql);
		for($i=0; $row = assoc($rs); $i++){
			$row['prm_content']	=	'';
			$row['prm_price']	=	'';
			$row['prm_content2']	=	'';
			$row['prm_price2']	=	'';

			if($row['fee_price_nosms'] =='0') {
				$row['fee_price_nosms'] = $row['fee_price'];
			}

			if($row['prm_idx'] > 0){
				$GETPRM				=	getValue('_PROMOTION', "WHERE prm_idx = '".$row['prm_idx']."' AND prm_use = 'Y' ", 'ar', 'prm_content, prm_price');
				$row['prm_content']	=	$GETPRM['prm_content'];
				$row['prm_price']	=	$GETPRM['prm_price'];
			}

			if($row['prm_idx2'] > 0){
				$GETPRM2			=	getValue('_PROMOTION', "WHERE prm_idx = '".$row['prm_idx2']."' AND prm_use = 'Y' ", 'ar', 'prm_content, prm_price');
				$row['prm_content2']=	$GETPRM2['prm_content'];
				$row['prm_price2']	=	$GETPRM2['prm_price'];
			}
			$data[]			=	$row;
		}
		//echoAr($data);
		if(is_array($data)){
			//$TOTAL_CNT	=	getValue('_SK_DATA', "WHERE sk_name	= '".$_REQUEST['NAME']."' and sk_fee_data = '".$_REQUEST['FEE']."' AND sk_fee_data NOT like '%맞춤형%' ", 'CNT', 'COUNT(*) as CNT');
			$TOTAL_CNT	=	0;
			$json_array	=	json_encode(array("LIST" => $data,"TOTAL_CNT" => $TOTAL_CNT));
			exit($json_array);
		}else{
			exit('{"result":"N","message":"일치하는 데이터가 없습니다."}');
		}

	//2015-12-29 JJ 요금제그룹
	}else if($_REQUEST['GROUP'] !='' && $_REQUEST['NAME'] !='' && $_REQUEST['MAKE'] !='' && $_REQUEST['IDX'] == ''){
		// echo "string";
		$sql	=	"
				SELECT
					".$columnHead."_fee_idx	as fee_idx
					,".$columnHead."_fee_data as fee_data
					,".$columnHead."_fee_price_nosms as fee_price_nosms
					,".$columnHead."_fee_price as fee_price

					,".$columnHead."_no_plan_price as no_plan_price
					,".$columnHead."_12month_plan_price as 12month_plan_price
					,".$columnHead."_24month_plan_price as 24month_plan_price
					,".$columnHead."_30month_plan_price as 30month_plan_price
					,".$columnHead."_36month_plan_price as 36month_plan_price
					,".$columnHead."_first_price as first_price
				FROM
					_".$tableHead."_DATA
				WHERE
					".$columnHead."_fee_data_group	=	'".$_REQUEST['GROUP']."'
				AND
					".$columnHead."_name				=	'".$_REQUEST['NAME']."'
				AND
					".$columnHead."_make				=	'".$_REQUEST['MAKE']."'
				AND
					".$columnHead."_fee_data not like '%맞춤형%'
				GROUP BY
					".$columnHead."_fee_data
				ORDER BY
					".$columnHead."_order desc,
					".$columnHead."_regdate desc
				";
		//exit($sql);
		$rs		=	query($sql);
		for($i=0; $row = assoc($rs); $i++){

			if($row['fee_price_nosms'] =='0') {
				$row['fee_price_nosms'] = $row['fee_price'];
			}

			$data[]			=	$row;

		}
		//echoAr($data);
		if(is_array($data)){
			//$TOTAL_CNT	=	getValue('_SK_DATA', "WHERE sk_fee_data_group = '".$_REQUEST['GROUP']."' AND sk_name = '".$_REQUEST['NAME']."' AND sk_make = '".$_REQUEST['MAKE']."' ", 'CNT', 'COUNT(*) as CNT');
			$TOTAL_CNT	=	0;
			$json_array	=	json_encode(array("LIST" => $data,"TOTAL_CNT" => $TOTAL_CNT));
			exit($json_array);
		}else{
			exit('{"result":"N","message":"일치하는 데이터가 없습니다."}');
		}


	}



/*

		$sql	=	query("
				SELECT
					sk_name
					,sk_model
					,sk_fee_data
					,sk_fee_price
					,sk_first_price
					,sk_back_price
					,sk_plus_price
					,sk_back_all_price
					,sk_monthly_all_price
					,sk_back_regdate
				FROM
					_SK_DATA


				ORDER BY
					sk_idx
				ASC
				");
		for($i=0; $row = assoc($sql); $i++){
			$data[]			=	$row;
		}
		//echoAr($data);
		if(is_array($data)){
			$TOTAL_CNT	=	getValue('_SK_DATA', "WHERE 1  ", 'CNT', 'COUNT(sk_first_price) as CNT');
			$json_array	=	json_encode(array("LIST" => $data,"TOTAL_CNT" => $TOTAL_CNT));
			exit($json_array);
		}else{
			exit('{"result":"N","message":"일치하는 데이터가 없습니다."}');
		}
*/


?>