document.location.href='/bootcamp/index';";
// exit;
// }
$preview = param_get_post('preview');
$preview_id = param_get_post('preview_id');
$agency = param_get_post('agency');
$preview_group = param_get_post('preview_group');
$preview_type = param_get_post('preview_type');
?>
220321 찜갯수 추가 기능
$where_qry = (isset($_sess['mem_official']) && $_sess['mem_official'] == 'Y')?" or m.wm_usage='B'":""; // 대표/공식사이트일때
$where_usage = "AND m.wm_business_code = '".$_sess['mem_biz_code']."' AND (m.wm_usage='A' or (m.wm_usage<>'A' and m.wm_usage_ag_code like '%".$_sess['mem_ag_code']."%') ".$where_qry.")"; // 사업부/캠퍼스 조회
$add_query = ($preview=='Y' && $preview_id>0)?" or m.wm_id=".$preview_id:""; // 미리보기시에 사용
/*
$sql = "SELECT m.wm_type, l.wm_id, l.wm_category_id, l.wm_title, l.thumb_label, l.wm_use_date2, l.wm_upfile, l.wm_info, 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, c.wm_title as wm_category
FROM ".$_TB['main']." AS m
LEFT JOIN ".$_TB['main_lecture']." AS ml ON m.wm_id=ml.wm_main_id AND ml.is_del='N'
LEFT JOIN ".$_TB['lecture']." AS l ON ml.wm_lecture_id=l.wm_id AND l.is_del='N'
LEFT JOIN ".$_TB['member']." AS t ON l.wm_teacher_id=t.wm_id AND t.is_del='N'
LEFT JOIN ".$_TB['category']." AS c ON l.wm_category_id=c.wm_id AND c.is_del='N'
WHERE m.is_del='N' AND m.wm_group='main' AND m. wm_use='Y' AND (m.wm_alldate='Y' or ((m.wm_start_date is null AND m.wm_end_date is null) or (concat(m.wm_start_date, ' ',m.wm_start_time)<='".date('Y-m-d H:i:00')."' AND concat(m.wm_end_date, ' ',m.wm_end_time)>='".date('Y-m-d H:i:00')."')))
and l.wm_use in ('Y','A') and l.wm_status != 'H'
".$where_usage." ".$add_query."
ORDER BY m.wm_sort asc, m.wm_id DESC, ml.wm_sort asc";
$rtn = $db->getFetchQueryAll($sql);
*/
$sql = "SELECT m.wm_type, l.wm_id, l.wm_category_id, l.wm_title, l.thumb_label, l.wm_use_date2, l.wm_upfile, l.wm_info, 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
FROM ".$_TB['main']." AS m
LEFT JOIN ".$_TB['main_lecture']." AS ml ON m.wm_id=ml.wm_main_id AND ml.is_del='N'
LEFT JOIN ".$_TB['lecture']." AS l ON ml.wm_lecture_id=l.wm_id AND l.is_del='N'
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' AND ca.wm_main = 'Y'
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 m.is_del='N' AND m.wm_group='main' AND m. wm_use='Y' AND (m.wm_alldate='Y' or ((m.wm_start_date is null AND m.wm_end_date is null) or (concat(m.wm_start_date, ' ',m.wm_start_time)<='".date('Y-m-d H:i:00')."' AND concat(m.wm_end_date, ' ',m.wm_end_time)>='".date('Y-m-d H:i:00')."')))
and l.wm_use in ('Y','A') and l.wm_status != 'H'
".$where_usage." ".$add_query."
ORDER BY m.wm_sort asc, m.wm_id DESC, ml.wm_sort asc";
$rtn = $db->getFetchQueryAll($sql);
$main = [];
// 할인적용 수강료
$idxs = [];
foreach($rtn as $k=>$v){
if($v['wm_id']!='') $idxs[] = $v['wm_id'];
}
$rtn_price = getDiscountPrice($idxs);
foreach($rtn 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'];
}
$main[$v['wm_type']][] = $v;
}
// 내가 찜한 강좌
$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'];
}
$agency = "boot";
// 진행중인 클래스
$sql = "SELECT * FROM ".$_TB['bc_course']." WHERE is_del = 'N' and wm_visible2='Y' ORDER BY wm_id ASC";
$clist = $db->getFetchQueryAll($sql);
// 진행중인 기수
$sql = "SELECT br.wm_id, br.wm_seq, br.wm_code, br.wm_course_code, concat(bc.wm_name_kor,' ',br.wm_name) AS wm_title, br.wm_start_date as wm_study_start, DATE_ADD(br.wm_start_date, INTERVAL ((bc.wm_study_week*7)-1) DAY) as wm_study_end, br.wm_person, br.wm_s_status
FROM ".$_TB['bc_round']." as br
LEFT JOIN ".$_TB['bc_course']." AS bc ON br.wm_course_code=bc.wm_code AND bc.is_del='N'
WHERE br.is_del = 'N' AND br.wm_o_status = 'B' AND br.wm_s_status IN ('A','B') and bc.wm_visible2='Y' AND br.wm_main = 'Y' ORDER BY br.wm_seq ASC";
$rlist = $db->getFetchQueryAll($sql);
$yoil_arr = array("일","월","화","수","목","금","토");
// 잔여인원 체크
$sql = "SELECT wm_round_code, COUNT(*) AS cnt
FROM ".$_TB['bc_round_student']."
WHERE is_del='N' AND wm_status='Y'
group by wm_round_code";
$slist = $db->getFetchQueryAll($sql);
$arr_student = [];
foreach($slist as $v){
$arr_student[$v['wm_round_code']] = $v['cnt'];
}
?>
