정세찬_우리산전

우리산전 대리점 현황

우리산전 제품 판매 대리점을 쉽게 검색할 수 있습니다.

1. 직관적인 검색: 지점명을 몰라도 지도를 클릭하여 검색할 수 있습니다.

2. 손쉬운 검색: 기억나는 지점이나 주소 단어를 입력하면 쉽게 원하는 대리점을 검색할 수 있습니다.

include_once "./__RootDir__.php";
        include_once "./_lib/_header.php";

$banner_path = "customer";
        $banner_title = "DEALER GUIDE";
        $banner_text = "작은 이익보다는 고객에게 감동을 안겨주는 <br>큰 노력을 계속 하겠습니다";
        $category_name = "고객지원";
        $page_name = "대리점안내";
        $category_page ="e1_notice";
        $this_page = "e2_agency";
        include_once("header.php");
        include_once("sub_banner.php");

$page						= xssClean($_GET["page"]);
        $s_keyword			= xssClean($_GET["s_keyword"]);
        $s_cate					= xssClean($_GET["s_cate"]);

$nowpage = "branch";

if(!$page) $page = 1;
        if(!$size) $size = 5;

if($s_lang){
        	$search_query .=" and  str_lang = '".$s_lang."'  ";
        }

if($s_cate){
        	$search_query .=" and  str_area = '".$s_cate."'  ";
        }

if( $s_keyword){
        	$search_query .=" and (str_title like '%".$s_keyword."%' || str_address like '%".$s_keyword."%' ) ";
        }

$query = "select count(*)  as cnt from  ( select a.*, (select ad_name from sm_admin where a.str_regid =  ad_id) as str_writer from sm_store a ) as temp  where 1=1  ".$str_language_query." "  . $search_query;
        $row = mysqli_fetch_assoc(query($query));

$affect_num = $row["cnt"];

if($affect_num > 0) {
        	if($page > ceil($affect_num / $size)) $page = ceil($affect_num / $size);
        	$start_num = ($page - 1) * $size;

$query = "select * from (select a.*, (select ad_name from sm_admin where a.str_regid =  ad_id) as str_writer from sm_store a ) as temp where 1=1  ".$str_language_query."  ". $search_query . " order by  str_title asc   limit ".$start_num.", ".$size;
        	$result = query($query);
        }

$getvalue = "s_keyfield=".$s_keyfield."&s_keyword=".$s_keyword."&s_cate=".$s_cate;

<section class="sub_page sub_padding agency">
        	<div class="title_box">
        		<h2> echo $page_name; </h2>
        		<p>작은 이익보다는 고객에게 감동을 안겨주는 <br class="hidden-xs">큰 노력을 계속 하겠습니다</p>
        	</div>

<div class="agency_wrap">
        		<div class="container">
        			<div class="search_wrap">
        				<div class="left_box">
        					<div class="search_box">
        						<h3><b>우리산전</b> 대리점 안내</h3>
        						<p>저희 POWNIX는 판매망 구축을 위해 전국적으로 본사 직영의 <br class="hidden-md hidden-sm hidden-xs">
        							특약점을 운영하고 있으며 제품구입 문의시 가까운 특약점으로 일임해 드리는 등 <br class="hidden-md hidden-sm hidden-xs">
        							특약점 사업정착을 위해 최선의 노력을 다하고 있습니다.
        						</p>
        						<form name="sform" id="sform" method="get">
        							<input type="hidden" name="s_cate" id="s_cate" value="=$s_cate">
        							<ul>
        								<li>
        									<label for="">지역</label>
        									<input class="area_input" disabled type="text" name="s_cate_text" value="=$s_cate!=""?$area_array[$language][$s_cate]:""" placeholder="검색할 지역을 지도에서 클릭해주세요.">
        								</li>
        								<li>
        									<label for="">지점명ㆍ주소</label>
        									<input type="text" name="s_keyword" id="s_keyword" value="php echo $s_keyword " placeholder="지점명 또는 주소를 입력하세요.">
        								</li>
        								<li>
        									<button class="search_btn" type="button" name="button" onclick="sform.submit()" style="cursor:pointer">검색</button>
        								</li>
        							</ul>
        						</form>
        					</div>
        				</div>
        				<div class="right_box">
        					<div class="map_box">
        						<div class="korea_map">
        							<ul>
        								<li class="city_1 =$s_cate=="D"?"on":""">
        									<span class="sound_only" data-area="D">인천광역시</span>
        									<img src="images/korea_map/city_1.png" alt="">
        								</li>
        								<li class="city_2 =$s_cate=="A"?"on":""">
        									<span class="sound_only" data-area="A">서울특별시</span>
        									<img src="images/korea_map/city_2.png" alt="">
        								</li>
        								<li class="city_3 =$s_cate=="I"?"on":""">
        									<span class="sound_only" data-area="I">경기도</span>
        									<img src="images/korea_map/city_3.png" alt="">
        								</li>
        								<li class="city_4 =$s_cate=="J"?"on":""">
        									<span class="sound_only" data-area="J">강원도</span>
        									<img src="images/korea_map/city_4.png" alt="">
        								</li>
        								<li class="city_5 =$s_cate=="L"?"on":""">
        									<span class="sound_only" data-area="L">충청남도</span>
        									<img src="images/korea_map/city_5.png" alt="">
        								</li>
        								<li class="city_6 =$s_cate=="H"?"on":""">
        									<span class="sound_only" data-area="H">세종특별자치시</span>
        									<img src="images/korea_map/city_6.png" alt="">
        								</li>
        								<li class="city_7 =$s_cate=="F"?"on":""">
        									<span class="sound_only" data-area="F">대전광역시</span>
        									<img src="images/korea_map/city_7.png" alt="">
        								</li>
        								<li class="city_8 =$s_cate=="K"?"on":""" >
        									<span class="sound_only" data-area="K">충청북도</span>
        									<img src="images/korea_map/city_8.png" alt="">
        								</li>
        								<li class="city_9 =$s_cate=="O"?"on":""">
        									<span class="sound_only" data-area="O">경상북도</span>
        									<img src="images/korea_map/city_9.png" alt="">
        								</li>
        								<li class="city_10 =$s_cate=="C"?"on":""">
        									<span class="sound_only" data-area="C">대구광역시</span>
        									<img src="images/korea_map/city_10.png" alt="">
        								</li>
        								<li class="city_11 =$s_cate=="G"?"on":""">
        									<span class="sound_only" data-area="G">울산광역시</span>
        									<img src="images/korea_map/city_11.png" alt="">
        								</li>
        								<li class="city_12 =$s_cate=="M"?"on":""">
        									<span class="sound_only" data-area="M">전라북도</span>
        									<img src="images/korea_map/city_12.png" alt="">
        								</li>
        								<li class="city_13 =$s_cate=="E"?"on":""">
        									<span class="sound_only" data-area="E">광주광역시</span>
        									<img src="images/korea_map/city_13.png" alt="">
        								</li>
        								<li class="city_14 =$s_cate=="N"?"on":""" >
        									<span class="sound_only" data-area="N">전라남도</span>
        									<img src="images/korea_map/city_14.png" alt="">
        								</li>
        								<li class="city_15 =$s_cate=="P"?"on":""">
        									<span class="sound_only" data-area="P">경상남도</span>
        									<img src="images/korea_map/city_15.png" alt="">
        								</li>
        								<li class="city_16 =$s_cate=="B"?"on":""">
        									<span class="sound_only" data-area="B">부산광역시</span>
        									<img src="images/korea_map/city_16.png" alt="">
        								</li>
        								<li class="city_17 =$s_cate=="Q"?"on":""">
        									<span class="sound_only" data-area="Q">제주특별자치도</span>
        									<img src="images/korea_map/city_17.png" alt="">
        								</li>
        							</ul>
        						</div>
        					</div>
        				</div>
        			</div>
        			<div class="result_wrap" id="set_conetnt">
        				<table>
        					<thead>
        						<tr>
        							<th>지역</th>
        							<th>이름</th>
        							<th>주소</th>
        							<th>전화번호</th>
        						</tr>
        					</thead>
        					<tbody>
        						php
        						$map_array = array();
        						if($affect_num > 0) {
        							$map_count =0;
        							$count = $affect_num - ($page - 1) * $size;
        							while($row = mysqli_fetch_assoc($result)){

<tr>
        									<td>=$area_array[$language][$row["str_area"]] =$row["str_sido"]!=""?$row["str_sido"]:""</td>
        									<td>=$row["str_title"]</td>
        									<td>=nl2br($row["str_address"])</td>
        									<td>=$row["str_tel"]</td>
        								</tr>

$count--;
        							}
        						}
        						else {
        							echo "<tr><td colspan=\"4\" align=\"center\">등록(검색)된 정보가 없습니다.</td></tr>";
        						}

</tbody>
        				</table>
        				<ul class="list_num">
        					 user_paging_board_ajax($_SERVER["PHP_SELF"]."?".$getvalue, $affect_num, $page, $size,$bid);
        				</ul>
        			</div>
        		</div>
        	</div>
        </section>
         include_once("footer.php");
        <script>
        	$(document).on("click",".btn_board_paging",function(){
        		urls = "./ajax_store_list.php?page="+ $(this).attr("data-idx") + "&s_keyword="+$("input[name='s_keyword']").val()+ "&s_cate="+$("input[name='s_cate']").val();
        		$.ajax({
        			url:urls ,
        			cache: false,
        			context: document.body,
        			beforeSend : function() {  },
        			statusCode : {   404 : function () {  alert('레이아웃 로딩 실패');  }  },
        			success    : function(html) {
        				if(html){
        					$("#set_conetnt").html(html);
        				}
        			},
        			error      : function() { alert('통신오류발생');  },
        			complete   : function() {
        			}
        		});
        	});
        </script>