// 250402 CI 작업으로 인한 redirect by 양찬용
# 뷰티 리뉴얼 > 실 적용 시 주석 해제
// if(!_IS_QA) {
header("Location: /camp/main");
exit();
// }
include(dirname(__FILE__)."/inc/top.php");
$idx = param_get_post('idx');
?>
/**
* 학과별 교육과정 소개 영상 Youtube - 2023-02-06
* 1:메이크업
* 2:헤어디자인
* 3:네일아트
* 4:에스테틱
* 5:스페셜단과코스
* 6:입시 코스
* 7:취·창업 코스
*/
$arr_video = array(1=>'https://www.youtube.com/embed/xDneFms_YQc', 2=>'https://www.youtube.com/embed/caftG5tx-x0', 3=>'https://www.youtube.com/embed/o5Q6MHz-JzM', 4=>'https://www.youtube.com/embed/8npFmxivS84', 5=>'', 6=>'https://www.youtube.com/embed/raB7GbNiksE', 7=>'', );
$arr_visual_stit = array(1=>"K-뷰티 메이크업 트렌드를 선도하는 학과,
차별화된 교육을 약속드립니다.", 2=>"뿌리부터 탄탄하게
뻗어 나갈 수 있도록 도와드립니다.", 3=>"네일리스트로서 현장을 이끌어갈
실력 있는 프로 양성을 책임집니다.", 4=>"자격증·취업 합격률로 증명된
가치와 실력을 보여드립니다.", 5=>"", 6=>"", 7=>"", );
// 정규과정 정보
$where_qry = (isset($_sess['mem_official']) && $_sess['mem_official'] == 'Y')?" or wm_usage='B'":""; // 대표/공식사이트일때
$where_usage = "AND wm_business_code = '".$_sess['mem_biz_code']."' AND (wm_usage='A' or (wm_usage<>'A' and wm_usage_ag_code like '%".$_sess['mem_ag_code']."%') ".$where_qry.")"; // 사업부/캠퍼스 조회
$sql = "SELECT wm_id, wm_lec_type, wm_title_front as wm_title, wm_title_en, wm_category, wm_image6, wm_m_intro, wm_intro
FROM ".$_TB['lecture']." WHERE wm_status='Y' AND wm_usage IN ('A','B') ".$where_usage." and wm_id='".$idx."' and wm_lec_type in ('A','F')";
$row = $db->getFetchQuery($sql);
$fpath = IMG_S3.'lecture/';
// 입시일때 이동처리
if($row['wm_lec_type']=='F'){
echo "";
}
if(empty($row['wm_id'])) alert('잘못된 접속입니다.');
// 카테고리 정보
$sql = "SELECT wm_id, wm_ca_name as wm_title, wm_1 as wm_content, wm_4 as wm_img, wm_5 as wm_img_sub from ".$_TB['category']." WHERE is_del='N' and wm_business_code='".$_SESSION['mem_biz_code']."' and wm_id=".$row['wm_category'];
$category = $db->getFetchQuery($sql);
$category_fpath = RFU.'/category/';
// 강사진
$sql = "SELECT wm_id, wm_title, wm_type, wm_name, wm_info , wm_content, wm_content2, wm_upfile, wm_upfile2, wm_upfile3, wm_intro_text
FROM ".$_TB['teacher']."
WHERE is_del='N' and wm_business_code = '".$_sess['mem_biz_code']."' AND wm_status = 'Y' AND wm_main_status = 'Y' and FIND_IN_SET('".$row['wm_category']."', wm_category)
ORDER BY wm_sort ASC";
$teacher = $db->getFetchQueryAll($sql);
$teacher_fpath = IMG_S3."intra/teacher/";
// 정규과정 > 과제
$sql = "SELECT wm_id, wm_pl_no, wm_title1 as wm_title, wm_content1 as wm_content, wm_r_file as wm_upfile, wm_sort
FROM ".$_TB['lecture_curr']."
WHERE is_del='N' and wm_pl_no=".$row['wm_id']."
ORDER BY wm_sort asc";
$task = $db->getFetchQueryAll($sql);
// 단과과정 정보
$sql = "SELECT l.wm_id, l.wm_title_front as wm_title, l.wm_intro, l.wm_e_dist, l.wm_m_intro, l.wm_content, l.wm_content_new
FROM ".$_TB['lecture_rel']." AS lr
LEFT JOIN ".$_TB['lecture']." AS l ON lr.wm_lec_no=l.wm_id AND l.is_del='N'
WHERE lr.is_del='N' and wm_status='Y' and lr.wm_pl_no=".$row['wm_id']."
ORDER BY lr.wm_lec_sort asc";
$rows = $db->getFetchQueryAll($sql);
foreach($rows as $k=>$v){
// 단과과정 > 커리큘럼
$sql = "SELECT wm_id, wm_pl_no, wm_title1 as wm_title, wm_content1 as wm_content, wm_r_file as wm_upfile, wm_sort
FROM ".$_TB['lecture_curr']."
WHERE is_del='N' and wm_pl_no=".$v['wm_id']."
ORDER BY wm_sort asc";
$curriculum = $db->getFetchQueryAll($sql);
$rows[$k]['curriculum'] = $curriculum;
// 단과과정 > 대학
$sql = "SELECT wm_id, wm_pl_no, wm_type, wm_title, wm_content, wm_upfile, wm_sort
FROM ".$_TB['lecture_univ']."
WHERE is_del='N' and wm_pl_no=".$v['wm_id']."
ORDER BY wm_type asc, wm_sort asc";
$data = $db->getFetchQueryAll($sql);
$univ = [];
foreach($data as $v2){
$univ[$v2['wm_type']][] = $v2;
}
krsort($univ);
$rows[$k]['univ'] = $univ;
}
?>