$page = param_get_post('page');
$wm_order = param_get_post('wm_order');
$wm_keyword = param_get_post('wm_keyword');
$rows = 10; //한페이지 출력수
if (!$page) $page = 1; // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함
if($wm_order=='') $wm_order = "b.wm_public_ymd DESC";
$WHERE = " and s.wm_business_code = '"._BIZ_CODE."'";
if(!isset($_SESSION['mb_official']) || $_SESSION['mb_official'] == 'N') $WHERE = " and s.wm_agency_code = '"._AGENCY_CODE."'"; //220916 캠퍼스별 시간표 저장시 기본사업부로만 저장되어 검색시에는 캠퍼스 코드만 비교할수 있도록 $WHERE.= 에서 $WHERE= 으로 변경처리함
if($wm_keyword!=''){
$WHERE .=" and (b.wm_name like '%".$wm_keyword."%' or b.wm_introduction like '%".$wm_keyword."%')";
}
$sql = "SELECT b.wm_id, b.wm_book_img, b.wm_name, b.wm_author, b.wm_publisher, b.wm_public_ymd, s.wm_business_code,
b.wm_introduction, b.wm_price, b.wm_sale_price, b.wm_sale_price_it, b.wm_discount_rate, b.wm_discount_rate_it, b.wm_wdate, s.wm_id as subject_id
FROM sp_subject s
LEFT JOIN sp_book AS b ON b.wm_id=s.book_wm_id AND b.is_del='N'
WHERE b.wm_open='Y' ".$WHERE."
and s.is_del='N'
group by b.wm_id
ORDER BY $wm_order LIMIT $from_record , $rows ";
$bk = $db->getFetchQueryArray($sql);
$total_count = $bk['total'];
$no = $total_count-(($page-1)*$rows);
$total_page = ceil($total_count / $rows);
$fpath = IMG_S3.'intra/book/';
?>
PROFESSIONAL BOOKS
=$v['wm_name']?>}?>=$v['wm_author']?> 저ㅣ =$v['wm_publisher']?>=$v['wm_public_ymd']?> |
|
|---|---|
|
=$v['wm_introduction']?> =number_format($wm_sale_price)?>원'>
1
|