'; if (!$pagecnt) $pagecnt = 18; // 한페이지 기본 출력수 30개 $rows = $pagecnt; // 한페이지 출력수 $blocks = 10; // 화면당 페이지 수 $page = ($page)?$page:1; // 현재페이지 (없을경우 1페이지) $from_record = ($page - 1) * $rows; // 시작 열을 구함 // 강좌리스트 $where_qry = (isset($_sess['mem_official']) && $_sess['mem_official'] == 'Y')?" or l.wm_usage='B'":""; // 대표/공식사이트일때 $where_usage = "AND l.wm_business_code = '".$_sess['mem_biz_code']."' AND (l.wm_usage='A' or (l.wm_usage<>'A' and l.wm_usage_ag_code like '%".$_sess['mem_ag_code']."%') ".$where_qry.")"; // 사업부/캠퍼스 조회 $WHERE = "WHERE l.is_del='N' and l.wm_use in ('Y','A') and l.wm_status in ('Y') ".$where_usage; $WHERE_CA = ''; if($wm_keyword){ if($wm_option=="keywords"){ // $WHERE.=" AND k.wm_keyword LIKE '%".$wm_keyword."%' "; //키워드 검색 => lecture > wm_id $sql = "SELECT wm_lecture_id from ".$_TB['lecture_keyword']." where is_del='N' AND wm_keyword like '%".$wm_keyword."%'"; $data3 = $db->getFetchQueryAll($sql); $in_wmid = ''; foreach($data3 as $k=>$v){ array_push($arr_in, $v['wm_lecture_id']); $in_wmid .= $v['wm_lecture_id'].','; } if(strlen($in_wmid)){ $in_wmid = substr($in_wmid, 0, strlen($in_wmid)-1); } if(strlen($in_wmid)){ $WHERE.=" AND l.wm_id in( ".$in_wmid.") "; } } else if($wm_option=="teacher"){ $WHERE.=" AND if(wm_nickname IS NULL, wm_name, wm_nickname) like '%".$wm_keyword."%'"; } else if($wm_option){ $WHERE.=" AND ".$wm_option." like '%".$wm_keyword."%'"; }else{ //9900원 이벤트 아닐떄만 if($cate!=32){ $add_q = "|| cc.c_value like '%".$wm_keyword."%'"; } /* s:키워드 검색 (메타포함되기전 추후 삭제예정) * / // 키워드 검색 $sql = "SELECT wm_content FROM sp_search_keyword WHERE wm_title='".$wm_keyword."'"; $keywords = $db->getFetchQueryOne($sql); $temp = explode("|",$keywords); if(count($temp)>0){ $add_idx = []; foreach($temp as $v){ if(trim($v)!=''){ $sql2 = "SELECT wm_id FROM sp_lecture where wm_title like '%".$v."%'"; $add_col = $db->getFetchQueryAll($sql2); foreach($add_col as $cv){ $add_idx[] = $cv["wm_id"]; } } } if(!empty($add_idx)) $add_q .=" or l.wm_id in (".implode(",",$add_idx).")"; } /* e:키워드 검색 (메타포함되기전 추후 삭제예정) */ // $WHERE.=" AND (l.wm_title like '%".$wm_keyword."%' or k.wm_keyword LIKE '%".$wm_keyword."%') "; //키워드 검색 => lecture > wm_id $sql = "SELECT wm_lecture_id from ".$_TB['lecture_keyword']." where is_del='N' AND wm_keyword like '%".$wm_keyword."%'"; $data3 = $db->getFetchQueryAll($sql); $in_wmid = ''; foreach($data3 as $k=>$v){ array_push($arr_in, $v['wm_lecture_id']); $in_wmid .= $v['wm_lecture_id'].','; } if(strlen($in_wmid)){ $in_wmid = substr($in_wmid, 0, strlen($in_wmid)-1); } if(strlen($in_wmid)){ $WHERE.=" AND (l.wm_title like '%".$wm_keyword."%' or l.wm_id in (".$in_wmid.") or if(wm_nickname IS NULL, wm_name, wm_nickname) like '%".$wm_keyword."%') "; } else{ $WHERE.=" AND (l.wm_title like '%".$wm_keyword."%' or if(wm_nickname IS NULL, wm_name, wm_nickname) like '%".$wm_keyword."%') "; } } } // if($cate) $WHERE.=" AND l.wm_category_id='".$cate."'"; //9900원 이벤트 아닐때만 || 무료강좌 아닐때만 - 2021.12.23 if($cate && !($cate==32 || $cate==33)){ $WHERE.=" AND cc.c_code = '".$cate."'"; } else{ $WHERE_CA = "AND ca.wm_main = 'Y'"; } if($keyword) $WHERE.=" AND l.wm_id in (select wm_lecture_id from ".$_TB['lecture_keyword']." where is_del='N' and wm_keyword like '%".$keyword."%')"; if($wm_orderby=='할인중' || $wm_orderby=='무료강좌'){ if($wm_orderby=='할인중') $WHERE.=" AND ( l.wm_discount_type != '' and (l.wm_discount_alldate ='Y' or (concat(wm_discount_sdate,' ',wm_discount_stime)<='".date('Y-m-d H:i')."' and concat(wm_discount_edate,' ',wm_discount_etime)>='".date('Y-m-d H:i')."')))"; else if($wm_orderby=='무료강좌') $WHERE.=" AND ( (ifnull(l.wm_sales_price,0)='0' and (l.wm_discount_alldate ='Y' or (concat(wm_discount_sdate,' ',wm_discount_stime)<='".date('Y-m-d H:i')."' and concat(wm_discount_edate,' ',wm_discount_etime)>='".date('Y-m-d H:i')."'))) or (ifnull(l.wm_lecture_price,0)='0' and ifnull(l.wm_discount_alldate,'N') ='N' and ((concat(wm_discount_sdate,' ',wm_discount_stime)>'".date('Y-m-d H:i')."' or concat(wm_discount_edate,' ',wm_discount_etime)<'".date('Y-m-d H:i')."') OR ifnull(wm_discount_sdate,'') ='')) )"; } if($wm_orderby=='') $wm_orderby = 'aa.wm_cnt_heart'; if($wm_orderby){ // if($wm_orderby=='할인중' || $wm_orderby=='무료강좌') $ORDERBY = "(case when l.wm_sales_price = 0 then 1 ELSE 2 end) ASC, l.wm_cnt_heart desc"; // else $ORDERBY = '(case when l.wm_sales_price = 0 then 1 ELSE 2 end) ASC, '.$wm_orderby." desc"; // 2022-01-10 if($wm_orderby=='할인중' || $wm_orderby=='무료강좌'){ $ORDERBY = "aa.wm_cnt_heart desc"; }else if($wm_orderby=='aa.wm_id'){ $ORDERBY = " aa.wm_use_date2 desc"; }else{ $ORDERBY = $wm_orderby." desc"; } } // 220204 조민근 찜수 저장된 수 + 5로 데이터 조정요청 (l.wm_cnt_heart+5) as wm_cnt_heart => 220321 찜갯수 추가 기능 if(_CATEGORY_ALL[$cate]['wm_title'] == '무료강좌'){ //무료강좌 $WHERE .= " and l.wm_sales_price = 0 "; } else if($cate == 'A'){ //9900원 자기개발전 $WHERE .= " and l.wm_code in ('L2021_00058','L2021_00060','L2021_00062','L2021_00063 ','L2021_00064','L2021_00065','L2021_00066','L2021_00068','L2021_00069','L2021_00071','L2021_00072','L2021_00085 ','L2021_00136','L2021_00137','L2021_00192','L2021_00215','L2021_00217','L2021_00247') "; } # 해당 이벤트 코드에 매칭된것은 페이지에 노출안됨 $WHERE .=" and l.wm_code not in( SELECT b.wm_code FROM sp_goods_info a INNER JOIN sp_goods_item_list b on a.e_code = b.e_code and b.g_isdel = 'N' WHERE e_gubun = 'event_list' AND e_isdel = 'N' ) "; /* $sql = "SELECT l.wm_id, cc.c_code, l.wm_title, l.thumb_label, l.wm_use_date2, l.wm_upfile, l.wm_lecture_price, l.wm_discount_per, l.wm_sales_price, (l.wm_cnt_heart+l.wm_cnt_heartadd) as wm_cnt_heart, (case when t.wm_nickname='' or t.wm_nickname is null then t.wm_name else t.wm_nickname end) as wm_teacher, cc.c_value as wm_category, k.wm_keyword FROM ".$_TB['lecture']." as l LEFT JOIN ".$_TB['member']." AS t ON l.wm_teacher_id=t.wm_id AND t.is_del='N' LEFT JOIN ".$_TB['lecture_category']." ca ON ca.wm_lecture_id = l.wm_id AND ca.is_del = 'N' ".$WHERE_CA." LEFT JOIN ".$_TB['common_code']." cc ON cc.c_gubun = 'lecture_category' AND cc.c_use = 'Y' AND cc.c_code = ca.wm_cate1 LEFT JOIN sp_lecture_keyword k ON k.wm_lecture_id = l.wm_id AND k.is_del = 'N' ".$WHERE." ORDER BY $ORDERBY LIMIT $from_record , $rows "; */ $sql = "SELECT aa.*, cc.c_code, cc.c_value as wm_category FROM ( SELECT l.wm_id, cc.c_code, l.wm_title, l.thumb_label, l.wm_use_date2, l.wm_upfile, l.wm_lecture_price, l.wm_discount_per, l.wm_sales_price, (l.wm_cnt_heart+l.wm_cnt_heartadd) as wm_cnt_heart, (case when t.wm_nickname='' or t.wm_nickname is null then t.wm_name else t.wm_nickname end) as wm_teacher, cc.c_value as wm_category, l.wm_cnt_student, l.wm_cnt_star FROM ".$_TB['lecture']." as l LEFT JOIN ".$_TB['member']." AS t ON l.wm_teacher_id=t.wm_id AND t.is_del='N' LEFT JOIN ".$_TB['lecture_category']." ca ON ca.wm_lecture_id = l.wm_id AND ca.is_del = 'N' ".$WHERE_CA." LEFT JOIN ".$_TB['common_code']." cc ON cc.c_gubun = 'lecture_category' AND cc.c_use = 'Y' AND cc.c_code = ca.wm_cate1 ".$WHERE." ) aa LEFT JOIN sp_lecture_category ca ON ca.wm_lecture_id = aa.wm_id AND ca.is_del = 'N' AND ca.wm_main = 'Y' LEFT JOIN sp_common_code cc ON cc.c_gubun = 'lecture_category' AND cc.c_use = 'Y' AND cc.c_code = ca.wm_cate1 ORDER BY $ORDERBY LIMIT $from_record , $rows "; // view_dump($sql); // view_dump($sql); $data = $db->getFetchQueryArray($sql); // 할인적용 수강료 $idxs = []; foreach($data['row'] as $k=>$v){ $idxs[] = $v['wm_id']; } $rtn_price = getDiscountPrice($idxs); foreach($data['row'] as $k=>$v){ if($v['wm_upfile']=='') $v['wm_upfile'] = "lecture_img.png"; // 할인적용 수강료 if(!empty($rtn_price[$v['wm_id']])){ $v['wm_discount_per'] = $rtn_price[$v['wm_id']]['wm_discount_per']; $v['wm_sales_price'] = $rtn_price[$v['wm_id']]['wm_sales_price']; $v['wm_discount_type_txt'] = $rtn_price[$v['wm_id']]['wm_discount_type_txt']; $v['thumb_label'] = $rtn_price[$v['wm_id']]['thumb_label']; } $data['row'][$k] = $v; } $total_count = $data['total']; $no = $total_count-(($page-1)*$rows); $total_page = ceil($total_count / $rows); // 전체 페이지 계산 // 내가 찜한 강좌 $sql = "SELECT wm_lecture_id from ".$_TB['lecture_heart']." where is_del='N' and wm_member_id='".$_sess['mem_no']."'"; $data2 = $db->getFetchQueryAll($sql); $heart = []; foreach($data2 as $v){ $heart[] = $v['wm_lecture_id']; } ?>