getFetchQuery($sql); */ $WHERE = "WHERE l.is_del='N' ".$add_q." AND l.wm_id=".$idx; $sql = "SELECT l.*, (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 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' 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; $row = $db->getFetchQuery($sql); if($row['wm_upfile']=='') $row['wm_upfile'] = "lecture_img.png"; // 220204 조민근 찜수 저장된 수 + 5로 데이터 조정요청 => 220321 찜갯수 추가 기능 $row['wm_cnt_heart'] = $row['wm_cnt_heart']+$row['wm_cnt_heartadd']; // 할인적용 수강료 $rtn_price = getDiscountPrice($row['wm_id']); if(!empty($rtn_price[$row['wm_id']])){ $row['wm_discount_per'] = $rtn_price[$row['wm_id']]['wm_discount_per']; $row['wm_sales_price'] = $rtn_price[$row['wm_id']]['wm_sales_price']; $row['wm_discount_type_txt'] = $rtn_price[$row['wm_id']]['wm_discount_type_txt']; $row['thumb_label'] = $rtn_price[$row['wm_id']]['thumb_label']; $row['wm_discount_edate'] = $rtn_price[$row['wm_id']]['wm_discount_edate']; // 할인중 일때는 라벨 미노출처리 if($row['thumb_label']=='할인중'){ $row['thumb_label'] = ""; $row['wm_discount_edate'] = ""; } } if($row['wm_id']=='') alert('잘못된 접근입니다.'); // 학습중 여부 - 2022.03.04 // free 강의는 학습중에서 제외 - 2023.10.18 $sql = "SELECT s.wm_id, p.wm_payment_type FROM sp_lecture_student s LEFT JOIN sp_lecture l ON l.wm_id = s.wm_lecture_id LEFT JOIN sp_payment_sub p ON p.wm_id = s.wm_pay_sub_id WHERE s.wm_lecture_id = ".$row['wm_id']." AND s.wm_member_id = '".$_sess['mem_no']."' AND s.is_del = 'N' AND l.is_del = 'N' and s.wm_status = 'Y' AND ( s.wm_unlimited = 'Y' or (s.wm_unlimited != 'Y' AND s.wm_lec_end >= NOW()) or s.wm_review_unlimited = 'Y' or (s.wm_review_unlimited != 'Y' AND s.wm_review_end >= NOW()) )"; $lec_ing_type = $db->getFetchQuery($sql); $lec_ing = ''; if($lec_ing_type['wm_payment_type'] != 'free'){ $lec_ing = $lec_ing_type['wm_id']; } // 키워드 $sql = "SELECT wm_keyword FROM ".$_TB['lecture_keyword']." WHERE is_del='N' and wm_lecture_id=".$idx; $kdata = $db->getFetchQueryOne($sql); $keywords = explode('|', $kdata); // 내가 찜한 강좌 $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']; } //커리큘럼 $sql = "SELECT wm_id, wm_title, wm_sort FROM ".$_TB['chapter']." WHERE is_del = 'N' and wm_lecture_id=".$idx." order by wm_sort asc"; $ldata = $db->getFetchQueryAll($sql); $lfree = []; //무료강좌 foreach($ldata as $k=>$v){ $sql = "SELECT wm_id, wm_code, wm_title, wm_mediakey, wm_playtime, wm_free, wm_vod_gubun, vi_viewcode FROM ".$_TB['course']." WHERE is_del='N' and wm_lecture_id=".$idx." and wm_chapter_id=".$v['wm_id']." and wm_use='Y' order by wm_sort asc, wm_code ASC"; $datal = $db->getFetchQueryAll($sql); #view_dump($sql); $playtime_total = 0; //챕터별 총수업시간 $vi_viewcode_total = 0; //이벤트영상 코드 foreach($datal as $k2=>$v2){ $ldata[$k]['course_list'] = $datal; $playtime_total += $v2['wm_playtime']; if($v2['wm_free']=='Y') $lfree[] = $v2; if(!empty($v2['vi_viewcode'])) $vi_viewcode_total += 1; } // 총강의수 & 총 수업시간 $ldata[$k]['course_time'] = $playtime_total; $ldata[$k]['course_cnt'] = count($datal); $ldata[$k]['vi_viewcode_total'] = $vi_viewcode_total; } // 수강후기 (별점) $sql = "SELECT wm_point, COUNT(*) as cnt FROM sp_evaluation_student WHERE is_del='N' and wm_status='Y' and wm_lecture_id=".$idx." GROUP BY wm_point"; $data = $db->getFetchQueryAll($sql); $star = []; $sum_star = 0; foreach($data as $k=>$v){ $sum_star += $v['cnt']; $star[$v['wm_point']] = $v['cnt']; } // Q&A 수강생 여부에 따른 카테고리 $wm_ca = "수강상담"; //비수강생 $sql = "SELECT wm_id FROM sp_lecture_student WHERE is_del='N' AND wm_status='Y' AND wm_lecture_id='".$idx."' AND wm_member_id='".$_sess["mem_no"]."' and (SUBSTR(wm_lec_start, 1, 10) <= SUBSTR(NOW(), 1, 10) AND SUBSTR(wm_lec_end, 1, 10) >= SUBSTR(NOW(), 1, 10)) limit 1"; $is_student = $db->getFetchQueryOne($sql); // echo '
'.$sql.'
'; if($is_student>0) $wm_ca = "학습질문"; //수강생 $arr_review_unlimited = [ ""=>"복습없음" ,"Y"=>"평생수강" ,"N"=>"제한" ]; ?> $row["wm_title"], "_ct" => $row["wm_category"], "_amt" => $row["wm_sales_price"] ]; /* AceCounter eCommerce (Product_Detail) v8.0 End*/ //view_dump($acecounter_prd_detail); //view_dump($row); $facebook_prd_detail = [ "content_ids" => $row["wm_code"], "content_type" => "product", "content_category" => $row["wm_category"], "content_name" => $row["wm_title"], "currency" => "KRW", "value" => $row["wm_sales_price"] ]; ?>

신고

관리자 처리 후 삭제처리 됩니다.

신고 취소

신고

정말 삭제하시겠습니까?

삭제 후에는 복구가 불가능 합니다.

신고 취소
*/?>
0){?>

무료강의

0){?>

Q&A 작성하기

이름은 일부 * 처리 되어 공개됩니다. ‘학습질문’은 수강생만 가능합니다.
분류
제목
내용
첨부파일 첨부파일

파일이 다수일 경우, 압축하여 하나의 파일로 첨부 바랍니다.(최대 10MB이하만 업로드 가능)

Tab 1

강좌소개

커리큘럼총 강

수강후기총 00개

0){?> 작성하기

    • =1;$i--){ $star_value = ($sum_star>0 && $star[$i]>0)?($star[$i]/$sum_star) * 100:0; ?>

    • 점

수강후기 더보기

Tab 2

Q&A총 00개

0){?> 작성하기
Q&A 더보기

Q&A총 00개 답변

이전
0){?>