|
Server : Apache/2.4.58 (Ubuntu) System : Linux yumsem00.cafe24.com 5.4.0-131-generic #147-Ubuntu SMP Fri Oct 14 17:07:22 UTC 2022 x86_64 User : root ( 0) PHP Version : 8.2.14 Disable Function : NONE Directory : /var/www/html/wp-content/stores/ |
Upload File : |
<?php
//require( $_SERVER['DOCUMENT_ROOT'].'/wp-load.php' );
global $wpdb;
$stores = array();
$result = $wpdb->get_results('SELECT * FROM yumsem_stores where enabled = 1 ');
foreach($result as $row) {
$s = new stdClass();
$s->key = $row->ys_srl;
$s->name = $row->name ;
$s->lat = $row->latitude ;
$s->lng = $row->longitude ;
$s->brand = $row->brand ;
$s->addr = $row->address ;
$s->oday = $row->open_date ;
$s->delivery = $row->delivery_yn ;
$s->tel = $row->tel ;
$s->baemin = $row->baemin_link ;
$stores[] = $s;
}
?>
<link href="/wp-content/stores/css/custom.css" rel="stylesheet">
<style>
.gm-style-iw-d .view_detail_btn {
display: inline-block;
text-decoration: none;
background-color: #1d1d1e;
color: #fff;
border-radius: 30px;
padding: 7px 24px;
margin-top: 10px;
margin-bottom: 10px;
font-size: 15px;
cursor:pointer;
color:white!important;
}
.gm-style-iw-d h2 {
color: #1d1d1e;
font-size: 20px;
text-align:center;
}
#popMap { height: 200px }
</style>
<link type="text/css" rel="stylesheet" href="/wp-content/stores/js/waitMe/waitMe.min.css">
</head>
<body>
<div class="find_store_wrap">
<div class='ns_tit'>신규매장 오픈</div>
<div class="yum_newstore">
<?php
global $wpdb;
// $result = $wpdb->get_results("SELECT name, area, open_date FROM yumsem_stores where enabled = 1 AND open_date = '1905-03-19'", ARRAY_A);
$result = $wpdb->get_results("SELECT ys_srl, name, area, open_date FROM yumsem_stores WHERE enabled = 1 AND open_date IS NOT NULL AND DATEDIFF(NOW(), open_date) <= 94 ORDER BY open_date DESC", ARRAY_A);
if ($result) {
$num_columns = 12;
$counter = 0;
foreach ($result as $row) {
if ($counter >= $num_columns) {
break;
}
echo "<div class='store_column view_detail_btn' data-key=" . $row['ys_srl'] .">";
echo "<p class='ns_store_name'>" . $row['name'] . "</p>";
echo "<p class='ns_store_area'>" . $row['area'] . "</p>";
echo "<p class='opening-date'>" . $row['open_date'] . " OPEN<em>!</em></p>";
echo "</div>";
$counter++;
}
} else {
echo "0 results";
}
?>
<style>
.ns_tit{color: #1D1D1E;font-family: 'GmarketSans', sans-serif !important;font-size: 34px;font-weight: 800;line-height: 54px;letter-spacing: -0.02px;margin-bottom:30px;text-align:center;}
.yum_newstore{display:flex;flex-wrap:wrap;justify-content: center;margin-bottom:30px;}
.yum_newstore .ns_store_name{margin-bottom: 5px !important;font-size: 24px;font-weight: 600;font-family: 'GmarketSans', sans-serif !important;text-align:center;padding: 0 5px;}
.yum_newstore .ns_store_area{font-size: 16px;font-weight: 400;text-align:center;padding: 0 5px 5px;}
.yum_newstore .opening-date {background-color: #009273;color: #fff;padding: 5px 0;font-size: 18px;font-weight: 500;text-align:center;}
.store_column {width: calc(25% - 20px);border: 2px solid #ddd;max-height: 300px;height: 100%;display: flex;flex-direction: column;justify-content: center;padding-top: 20px;margin: 0 5px 5px 0;cursor: pointer;}
@media screen and (max-width: 1024px){
.ns_tit{font-size: 28px;line-height: 36px;}
}
@media screen and (max-width: 767px){
.ns_tit{font-size: 20px;line-height: 26px;}
.yum_newstore .ns_store_name{font-size: 18px;}
.yum_newstore .opening-date{font-size: 16px;}
.store_column {width: calc(50% - 20px);margin-bottom:10px;}
}
</style>
</div><br/><br/>
<div class='ns_tit'>가까운 매장찾기</div>
<div class="yum_map">
<div id="mapArea" style="width:100%;"></div>
</div>
<div class="search_area_wrap">
<form id="sFrm" onsubmit="return false">
<select name="area">
<option value="" selected>지역명</option>
<option value="서울">서울</option>
<option value="부산">부산</option>
<option value="대구">대구</option>
<option value="인천">인천</option>
<option value="광주">광주</option>
<option value="대전">대전</option>
<option value="울산">울산</option>
<option value="세종">세종</option>
<option value="경기">경기</option>
<option value="강원">강원</option>
<option value="충북">충북</option>
<option value="충남">충남</option>
<option value="전북">전북</option>
<option value="전남">전남</option>
<option value="경북">경북</option>
<option value="경남">경남</option>
<option value="제주">제주</option>
<option value="대만">대만</option>
<option value="미국">미국</option>
</select>
<select name="brand">
<option value="" selected>브랜드명</option>
<option value="얌샘">얌샘</option>
<option value="얌샘김밥">얌샘김밥</option>
<option value="얌샘김밥플러스">얌샘김밥플러스</option>
<option value="YUMSEM Eats">YUMSEM Eats</option>
</select>
<input type="text" name="store_name" placeholder="매장명을 입력해주세요." />
<button type="button" class="search_btn">검색</button>
<label class="deliveryuse_wrap chkStyle2"><input type="checkbox" name="delivery" value="가능"><span class="wpcf7-list-item-label">배달가능 매장</span></label>
</form>
</div>
<div class="search_list_wrap">
<table>
<thead>
<tr>
<th>지역명</th>
<th>브랜드명</th>
<th width="13%">매장명</th>
<th>주소</th>
<!-- <th>영업시간</th>
<th>배달</th> -->
<th>전화번호</th>
</tr>
</thead>
<tbody id="listPH">
</tbody>
</table>
</div>
<!--페이지네이션-->
<div class="pagination_wrap">
<ul>
<li><a class="active">1</a></li>
</ul>
</div>
<?php
include($_SERVER['DOCUMENT_ROOT'].'/wp-content/stores/part_popinfo.php');
?>
</div>
<script>
var ctype = 'n';
</script>
<?php
include($_SERVER['DOCUMENT_ROOT'].'/wp-content/stores/common_js.php');
?>