'A' and l.wm_usage_ag_code like '%"._AGENCY_CODE."%')) ";
$sql = "SELECT r.wm_pl_no, l2.wm_title as title, l2.wm_title_en as title_en, l2.wm_image6, l2.wm_m_intro, r.wm_lec_sort, l.wm_id, l.wm_title FROM sp_lecture_rel AS r
LEFT JOIN sp_lecture AS l ON r.wm_lec_no=l.wm_id
LEFT JOIN sp_lecture AS l2 ON r.wm_pl_no=l2.wm_id
".$WHERE." and l2.wm_lec_type='".$lec_type."'
ORDER BY r.wm_pl_no ASC, r.wm_lec_sort asc, r.wm_id asc";
$data = $db->getFetchQueryAll($sql);
// echo '';
$regular = [];
foreach($data as $v){
if(!isset($regular[$v['wm_pl_no']])){
$regular[$v['wm_pl_no']] = [];
$regular[$v['wm_pl_no']]['title'] = $v['title'];
$regular[$v['wm_pl_no']]['title_en'] = $v['title_en'];
$regular[$v['wm_pl_no']]['img'] = $v['wm_image6'];
$regular[$v['wm_pl_no']]['intro'] = $v['wm_m_intro'];
}
$regular[$v['wm_pl_no']]['process'][] = $v;
}
?>
'A' and l.wm_usage_ag_code like '%"._AGENCY_CODE."%')) ";
$sql = "SELECT wm_id, wm_title, CONCAT('/lecture/', wm_id) AS wm_url
FROM sp_lecture l
".$WHERE." and l.wm_lec_type='".$lec_type."'
and l.wm_status = 'Y'
";
$lecture = $db->getFetchQueryAll($sql);
}
?>
-
getFetchQuery("SELECT * FROM ".$_TB['lecture']." WHERE wm_id = '".$lec_no."'");
$url = "/lecture/".$v['wm_id'];
if($v['wm_lec_type']=='A') $url = "/regular/".$v['wm_id'];
else if($v['wm_lec_type']=='C') $url = "/national/".$v['wm_id'];
if($lec_type == "A") $atagurl = $v2['wm_url'];
else $atagurl = $url;
$icon_img = $fpath.$v['wm_image3'];
$target = "";
if($v2['wm_title'] == '메타버스(온라인강좌)'){
$atagurl = $v2['wm_url'];
$v['wm_image3'] = 'z';
$icon_img = 'http://intra.megastudy-computer.com/data/lecture/Meta.png';
$v['wm_title_en'] = 'Metaverse';
$target = " target='_blank' ";
}
?>
-
>