63 lines
1.6 KiB
PHP
63 lines
1.6 KiB
PHP
<?php
|
|
include_once('./_common.php');
|
|
|
|
$g5['title'] = '상품문의';
|
|
include_once(G5_MSHOP_PATH.'/_head.php');
|
|
|
|
$sql_common = " from `{$g5['g5_shop_item_qa_table']}` a join `{$g5['g5_shop_item_table']}` b on (a.it_id=b.it_id) ";
|
|
$sql_search = " where (1) ";
|
|
|
|
if(!$sfl)
|
|
$sfl = 'b.it_name';
|
|
|
|
if ($stx) {
|
|
$sql_search .= " and ( ";
|
|
switch ($sfl) {
|
|
case "a.it_id" :
|
|
$sql_search .= " ($sfl like '$stx%') ";
|
|
break;
|
|
case "a.iq_name" :
|
|
case "a.mb_id" :
|
|
$sql_search .= " ($sfl = '$stx') ";
|
|
break;
|
|
default :
|
|
$sql_search .= " ($sfl like '%$stx%') ";
|
|
break;
|
|
}
|
|
$sql_search .= " ) ";
|
|
}
|
|
|
|
if (!$sst) {
|
|
$sst = "a.iq_id";
|
|
$sod = "desc";
|
|
}
|
|
$sql_order = " order by $sst $sod ";
|
|
|
|
$sql = " select count(*) as cnt
|
|
$sql_common
|
|
$sql_search
|
|
$sql_order ";
|
|
$row = sql_fetch($sql);
|
|
$total_count = $row['cnt'];
|
|
|
|
$rows = $config['cf_mobile_page_rows'];
|
|
$total_page = ceil($total_count / $rows); // 전체 페이지 계산
|
|
if ($page < 1) { $page = 1; } // 페이지가 없으면 첫 페이지 (1 페이지)
|
|
$from_record = ($page - 1) * $rows; // 시작 열을 구함
|
|
|
|
$sql = " select a.*, b.it_name
|
|
$sql_common
|
|
$sql_search
|
|
$sql_order
|
|
limit $from_record, $rows ";
|
|
$result = sql_query($sql);
|
|
|
|
$itemqalist_skin = G5_MSHOP_SKIN_PATH.'/itemqalist.skin.php';
|
|
|
|
if(!file_exists($itemqalist_skin)) {
|
|
echo str_replace(G5_PATH.'/', '', $itemqalist_skin).' 스킨 파일이 존재하지 않습니다.';
|
|
} else {
|
|
include_once($itemqalist_skin);
|
|
}
|
|
|
|
include_once(G5_MSHOP_PATH.'/_tail.php'); |