<?php

if ( $_SERVER['REMOTE_ADDR'] == "175.123.107.3" ) {
	error_reporting(E_ERROR | E_PARSE);
	ini_set("display_errors", 1);
}

require( $_SERVER['DOCUMENT_ROOT'].'/wp-load.php' );
global $wpdb;

/*$mobile_agent = "/(iPod|iPhone|Android|BlackBerry|SymbianOS|SCH-M\d+|Opera Mini|Windows CE|Nokia|SonyEricsson|webOS|PalmOS)/";

if(preg_match($mobile_agent, $_SERVER['HTTP_USER_AGENT'])){
	$mobile = true;
}else{
	$mobile = false;
}*/

$page = intval($_GET['page']);

if($page < 1)
	$page = 1;

$pageSize = 10;

$queryWhere = '';

////////////////////////////////////////////////////////////////
if(strlen($_POST['lat']) > 0)
	$lat = $_POST['lat'];

if(strlen($_POST['lng']) > 0)
	$lng = $_POST['lng'];

if(strlen($_POST['store_name']) > 0)
	$queryWhere = $queryWhere." and ( name like '%".$wpdb->_escape($_POST['store_name'])."%' or address like '%".$wpdb->_escape($_POST['store_name'])."%' ) ";

if(strlen($_POST['area']) > 0)
	$queryWhere = $queryWhere." and area like '".$wpdb->_escape($_POST['area'])."%' ";

if(strlen($_POST['brand']) > 0) {
    $brand = $wpdb->_escape($_POST['brand']);
    $queryWhere = $queryWhere." and brand = '".$brand."' ";

}
if(strlen($_POST['opening']) > 0){
	$oday = $wpdb->_escape($_POST['open_date']); 
	$queryWhere = $queryWhere." and DATEDIFF(now(), open_date) < 94 ";
}
if (isset($_POST['delivery']) && $_POST['delivery'] == '가능') {
    $queryWhere = $queryWhere." and delivery_yn = '가능' ";
}

$total  = $wpdb->get_var( "SELECT count(*) as count FROM yumsem_stores a where enabled = 1 $queryWhere " );

////////////////////////////////////////////////////////////////

// if(strlen($_POST['lat']) > 0)
// 	$lat = $_POST['lat'];

// if(strlen($_POST['lng']) > 0)
// 	$lng = $_POST['lng'];

// if(strlen($_POST['store_name']) > 0)
// 	$queryWhere = $queryWhere." and ( name like '%".$wpdb->_escape($_POST['store_name'])."%' or address like '%".$wpdb->_escape($_POST['store_name'])."%' ) ";

// if(strlen($_POST['area']) > 0)
// 	$queryWhere = $queryWhere." and area like '".$wpdb->_escape($_POST['area'])."%' ";

// if(strlen($_POST['brand']) > 0) {
//     $brand = $wpdb->_escape($_POST['brand']);
//     $queryWhere = $queryWhere." and brand = '".$brand."' ";
// }

// if(strlen($_POST['opening']) > 0)
// 	$queryWhere = $queryWhere." and DATEDIFF(now(), open_date) < 94 ";

// if(strlen($_POST['delivery']) > 0)
// 	$queryWhere = $queryWhere." and delivery_yn = '가능' ";

// $total  = $wpdb->get_var( "SELECT count(*) as count FROM yumsem_stores a where enabled = 1 $queryWhere " );


$totalPage = (int)ceil($total/$pageSize); 
if($totalPage == 0)
	$totalPage = 1;

$start = ($page - 1) * $pageSize;

if(strlen($lat) == 0 || strlen($lng) == 0)
	$query = sprintf("SELECT * FROM yumsem_stores where enabled = 1 %s order by area, name limit %d, %d  ", $queryWhere, $start , $pageSize) ;
else
	$query = sprintf("SELECT * FROM (select *, ( 6371 * acos ( cos ( radians($lat) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians($lng) ) + sin ( radians($lat) ) * sin( radians( latitude ) ) ) ) AS distance from yumsem_stores ) a where enabled = 1 %s order by distance, area, name limit %d, %d  ", $queryWhere, $start , $pageSize) ;

//echo $query;
$result = $wpdb->get_results($query);


if($total > 0)
{
	foreach($result as $row) {

		if($row->brand == '얌샘김밥')
			$icon = '/wp-content/stores/images/store_logo.svg';
		else if($row->brand == '얌샘김밥플러스')
			$icon = '/wp-content/stores/images/store_plus_2024.png';	
		else if($row->brand == 'YUMSEM Eats')
			$icon = '/wp-content/uploads/2024/12/yumsem_eats.png';
		else
			$icon = '/wp-content/stores/images/yumsem_logo_img.png';
	?>
			<tr>
				<td><?php echo $row->area; ?></td>
				<td data-key="<?php echo $row->brand;?>" class="brand"><?php echo $row->brand;?></td>
				<td data-key="<?php echo $row->ys_srl;?>" class="moveMap"><img src="<?php echo $icon; ?>" class="store_logo_img" /><?php echo $row->name; ?></td>
				<td data-key="<?php echo $row->ys_srl;?>" class="view_detail_btn"><?php echo $row->address; ?></td>
				<!-- <td><?php echo $row->op_hour; ?></td>
				<td><?php echo $row->delivery_yn; ?></td> -->
				<td><span class="tel"><?php echo $row->tel; ?></span></td>
				<td class="mb_view">
	<?php
		if($row->baemin_link)
		{
	?>
			<a href="<?php echo $row->baemin_link; ?>" target="_blank" class="btn_delivery"><img src="/wp-content/stores/images/ci_baemin.svg" alt="배민" /></a>
	<?php
		}
	?>
				<a class="view_detail_btn" data-key="<?php echo $row->ys_srl;?>"><img src="/wp-content/stores/images/icon_information.svg" alt="정보" /></a>
				<a class="btn_navi" data-key="<?php echo $row->ys_srl;?>"><img src="/wp-content/stores/images/k_map.png" alt="길찾기" /></a>
				</td>
			</tr>

	<?php
	}
}
else
{
?>
          <tr>
            <td colspan="7" style="text-align:center;">검색된 매장이 없습니다</td>
          </tr>
<?php
}

$listSize = 5;

if($page > $totalPage)
	$page = $totalPage;

$startPage = $page - (int)ceil($listSize/2) + 1; 

if($startPage < 1)
	$startPage = 1;

$endPage = $startPage + $listSize -1;
if($endPage > $totalPage)
	$endPage = $totalPage;

$prevPage = $page - 1;
if($prevPage < 1)
	$prevPage = 0;

$nextPage = $page + 1;
if($nextPage > $totalPage)
	$nextPage = $totalPage;

$info = new stdClass();
$info->total = $total;
$info->totalPage = $totalPage;
$info->curPage = $page;
$info->startPage = $startPage;
$info->endPage = $endPage;
$info->prevPage = $prevPage;
$info->nextPage = $nextPage;
$info->listSize = $listSize;
?>
<script>
var pInfo = <?php echo json_encode($info); ?>;

$('.pagination_wrap > ul').html('');
var spage = pInfo.startPage;


$('.pagination_wrap > ul').append('<li><a href="javascript:getSearchList('+ pInfo.prevPage +');">&lt;</a></li>');

for(spage = pInfo.startPage;spage<=pInfo.endPage;spage++)
{
	if(spage == pInfo.curPage)
		$('.pagination_wrap > ul').append('<li><a class="active" href="javascript:getSearchList('+ spage +');">'+ spage +'</a></li>');
	else
		$('.pagination_wrap > ul').append('<li><a href="javascript:getSearchList('+ spage +');">'+ spage +'</a></li>');
}

$('.pagination_wrap > ul').append('<li><a href="javascript:getSearchList('+ pInfo.nextPage +');">&gt;</a></li>');
</script>