/* 비주얼에서 사용하는 필드 정보 wm_intro > 과정 카피문구 wm_m_intro > 과정 카피문구 wm_e_days > 개강일 edu_dist > 수업기간 wm_image1 > 강좌 배경이미지 -pc wm_image_mo1 > 강좌 배경이미지 -mobile wm_theme > 수업소개 wm_teacher_info > 수업내용 wm_teacher_url > 영상코드 wm_image2 > 로드맵 이미지-pc wm_image_mo2 > 로드맵 이미지-mobile wm_recommend1 > 로드맵 제목 wm_recommend2 > 로드맵 내용 wm_recommend3 > 수업목표 제목 wm_recommend4 > 수업목표 내용 wm_recommend5 > 수업목표 영상경로 wm_typical_title > 수업포인트제목 wm_typical_info > 수업포인트 내용 wm_board > 수업방식 제목 wm_board_title > 수업방식 내용 wm_curr_eng1 > 수업방식 콘텐츠내용1 wm_curr_eng2 > 수업방식 콘텐츠내용2 wm_curr_eng3 > 수업방식 콘텐츠내용3 wm_curr_eng4 > 수업방식 콘텐츠내용4 wm_teacher_ename > 수업방식 콘텐츠내용5 wm_content > 사전 준비항목 wm_timeinfo > 취업분야/전망 제목 wm_curriculum > 취업분야 /전망 내용 wm_e_dist > 취업분야 wm_e_dist2 > 작업분야 wm_e_people > 자격증 그룹 wm_curr_kor1 > 자격증 1 wm_curr_kor2 > 자격증 2 wm_curr_kor3 > 자격증 3 wm_curr_kor4 > 자격증 4 wm_curr_kor5 > 자격증 5 wm_e_contact > 포트 폴리오 제목 wm_goal > 카테고리 */ $yoil = array("일","월","화","수","목","금","토"); $lecture_idx = param_get_post("idx"); // 파트별 검색 수 $sql = "select * from sp_lecture where wm_business_code = 'B0001' and wm_lec_type = 'I' and wm_main = 'Y' and wm_status = 'Y' and wm_id = '{$lecture_idx}'"; $row = $db->getFetchQuery($sql); /** * 2023.07.21 * * 과정관리 > 링크이동이 Y 이고, 링크가 있으면 이동 * [MEGASTUDY-1023] 비주얼 커리큘럼 노출하면서 추가함 */ if($row['wm_menu_url_yn'] == 'Y' && $row['wm_menu_url']){ alert("", $row["wm_menu_url"], ""); exit(); } #디자인 연관 과정 $sql = " select sub.* from sp_menu_sub sub inner join sp_menu main on sub.wm_menu_id = main.wm_id and main.wm_site_type in('all', 'pc') and wm_business_code = 'B0001' where sub.wm_id in(select wm_parent from sp_menu_sub where wm_url in('/lecture/{$lecture_idx}','/curriculum/{$lecture_idx}') ) order by sub.wm_id asc "; $arr_cate = $db->getFetchQuery($sql); if($arr_cate["wm_menu_id"]){ $sql = " select * from sp_menu_sub where wm_menu_id in({$arr_cate["wm_menu_id"]}) and wm_parent in({$arr_cate["wm_id"]}) order by wm_sort asc "; $arr_menu = $db->getFetchQueryAll($sql); if($arr_menu){ foreach($arr_menu as $index =>$key ){ if(substr($key["wm_title"],0,1)== "^" || trim($key["wm_title"]) == ""){ unset($arr_menu[$index]); if($key["wm_url"] == "/lecture/{$lecture_idx}" || $key["wm_url"] == "/curriculum/{$lecture_idx}"){ $my_title = str_replace('^', '', $key["wm_title"]); } }else{ if($key["wm_url"] == "/lecture/{$lecture_idx}" || $key["wm_url"] == "/curriculum/{$lecture_idx}"){ $arr_menu[$index]["mymenu"] = "Y"; $my_title = $key["wm_title"]; }else{ $arr_menu[$index]["mymenu"] = "N"; // $my_title = $key["wm_title"]; } } } } }else{ //- 메뉴로 가져오는 정보를 쿼리로 가져오자 // $urlcheck = explode("/",$_SERVER['HTTP_REFERER']); // $urlFlg = $urlcheck[count($urlcheck)-1]; # 리스트 가져오기 $sql = " select wm_id , 1 , wm_title ,concat('/curriculum/',wm_id) as wm_url , 0 as wm_parent , 0 as wm_depth , wm_order as wm_sort , wm_wdate , is_del , wm_image3 , '#000000' as wm_color , 'Y' as wm_mainshow , '_self' as wm_target from sp_lecture where wm_recommend1 in('certificate') and wm_status = 'Y' and is_del = 'N' order by wm_order asc "; // view_dump($sql); $arr_menu = $db->getFetchQueryAll($sql); // view_dump($arr_menu); if($arr_menu){ foreach($arr_menu as $index =>$key ){ if(substr($key["wm_title"],0,1)== "^" || trim($key["wm_title"]) == ""){ unset($arr_menu[$index]); }else{ if($key["wm_url"] == "/lecture/{$lecture_idx}" || $key["wm_url"] == "/curriculum/{$lecture_idx}"){ $arr_menu[$index]["mymenu"] = "Y"; $my_title = $key["wm_title"]; }else{ $arr_menu[$index]["mymenu"] = "N"; } } } } } //- 헤더 이미지 비디오 여부 if($row["wm_image1"] != ""){ $arr_main_img = explode(".",$row["wm_image1"]); if($arr_main_img[1] == "mp4"){ $headimg = "N"; }else{ $headimg = "Y"; } } if($row["wm_e_dist"] != ""): $arr_e_dist = explode("|",$row["wm_e_dist"]); endif; if($row["wm_e_dist2"] != ""): $arr_e_dist2 = explode("|",$row["wm_e_dist2"]); endif; if($row["wm_goal"] != ""): $arr_wm_goal = explode("|",$row["wm_goal"]); endif; /* # 포트 폴리오 */ if($arr_wm_goal){ $wm_cate .= "in("; foreach($arr_wm_goal as $index => $value){ if($wm_cate != "in("){ $wm_cate .= ","; } $wm_cate .= "'{$value}'"; } $wm_cate .= ")"; // 파트별 검색 수 $sql = "select a.* ,(SELECT wm_filename FROM sp_board_file WHERE wm_table='portfolio2' and wm_bid=a.wm_id and wm_num=0) as wm_filename from sp_wm_portfolio2 a where wm_business_code = 'B0001' and wm_ca {$wm_cate} AND (wm_usage='A' or wm_usage='B' ) and is_temp='N' and wm_status='Y' order by wm_parent desc, wm_num limit 10"; $arr_portfolio = $db->getFetchQueryAll($sql); } /* 커리큘럼 정보 */ // 파트별 검색 수 $sql_curr_main = "select * from sp_lecture_curr where wm_pl_no = '{$lecture_idx}' and wm_catecode1 = 0 and is_del = 'N'"; $curr_main = $db->getFetchQueryAll($sql_curr_main); $sql_curr_sub = "select * from sp_lecture_curr where wm_pl_no = '{$lecture_idx}' and wm_catecode1 > 0 and is_del = 'N'"; $curr_sub = $db->getFetchQueryAll($sql_curr_sub); //- 자격증 정보 프로그램 정보 가져오기 $arr_cer = array('wm_curr_kor1', 'wm_curr_kor2', 'wm_curr_kor3', 'wm_curr_kor4'); $in = ''; foreach($arr_cer as $v){ if($row[$v]){ $in .= $row[$v].','; } } $api_param = array(); //- 경로 체크 $api_param["apiUrl"] = "/mega/megadem/certificate"; if($in){ $api_param["data"]["wm_id"] = $in; $api_param["method"] = "GET"; } $return_val = xhrApiData($api_param); if($return_val["status"] == 1){ $confi = $return_val["returnVal"]; } if($row["wm_m_intro2"] != ""){ $program_wm_id = str_replace("|",",",$row["wm_m_intro2"]) ; $api_param2 = array(); $api_param2["apiUrl"] = "/mega/megadem/program"; $api_param2["data"]["wm_id"] =$program_wm_id; $api_param2["method"] = "GET"; $return_val2 = xhrApiData($api_param2); if($return_val2["status"] == 1){ $arr_program = $return_val2["returnVal"]; } } # "|" 가 들어온경우 괄호를 넣는 작업 (민근대리 요청) $arr_wm_title = explode("|",$arr_cate["wm_title"]); if(count($arr_wm_title) > 1){ $view_wm_title = $arr_wm_title[0]."(".$arr_wm_title[1].")"; }else{ $view_wm_title = $arr_cate["wm_title"]; } ?>
=$row["wm_title"]?>=($row["wm_title_en"] != "")?" : ".$row["wm_title_en"]:""?>
=nl2br($row["wm_theme"])?>
=$row["wm_recommend3"]?>
=$row["wm_typical_title"]?>
=str_replace("
","
",$content) ?>
=str_replace("
","
",$content) ?>
=$row["wm_board"]?>
=$row["wm_board_title"]?>=$row["wm_content"]?>
=nl2br($row["wm_hot_content"])?>
".$value."
"; endforeach; endif; ?>" alt=""> =$key["wm_title"]?>
=$row["wm_timeinfo"]?>
=$row["wm_e_contact"]?>
=$curr_main[0]["wm_sub_title"]?>
=nl2br($key["wm_content2"])?>