'A' and wm_usage_ag_code like '%"._AGENCY_CODE."%')) AND wm_status='Y' and wm_lec_type='A'";
// $rowdata = $db->getFetchQuery($sql);
$rowdata = $db->getFetchQueryAll($sql);
$rand = rand(0, sizeof($rowdata)-1);
//표지(?) 는 랜덤하게 출력
$row = $rowdata[$rand];
$pl_no = $nos = '';
if(sizeof($rowdata)){
foreach($rowdata as $v){
$nos .= $v['wm_id'].',';
}
$nos = substr($nos, 0, strlen($nos)-1);
$pl_no = " AND r.wm_pl_no in (".$nos.")";
}
$fpath = IMG_S3.'lecture/';
if(empty($row)) alert('잘못된 접속입니다.');
$sql2 ="SELECT l.wm_id, l.wm_title, l.wm_title_en, l.wm_image3, l.wm_tag FROM ".$_TB['lecture_rel']." AS r LEFT JOIN ".$_TB['lecture']." AS l ON r.wm_lec_no=l.wm_id WHERE ifnull(l.wm_status,'N')='Y' ".$pl_no." ORDER BY l.wm_status asc, l.wm_title_en asc, l.wm_id asc";
$relec = $db->getFetchQueryAll($sql2);
}
else{
$where_qry = "";
if(isset($_SESSION['mb_official']) && $_SESSION['mb_official'] == 'Y') $where_qry = " or l.wm_usage='B' ";
$sql = "SELECT wm_id, wm_lec_type, wm_title, wm_title_en, wm_intro, wm_m_intro, wm_image7,
wm_peroid1, wm_peroid2, edu_person, wm_timeinfo, wm_curr_eng1, wm_curr_eng2,wm_curr_eng3,wm_curr_eng4,wm_curr_eng5,
wm_curr_kor1,wm_curr_kor2,wm_curr_kor3,wm_curr_kor4,wm_curr_kor5, wm_menu_url
FROM ".$_TB['lecture']." as l
WHERE is_del='N' and wm_business_code = '"._BIZ_CODE."' AND (wm_usage='A' ".$where_qry." or (wm_usage<>'A' and wm_usage_ag_code like '%"._AGENCY_CODE."%')) AND wm_status='Y' and wm_lec_type='A' and wm_id=".$lecture_idx."";
$row = $db->getFetchQuery($sql);
$fpath = IMG_S3.'lecture/';
if(empty($row)) alert('잘못된 접속입니다.');
$sql2 ="SELECT l.wm_id, l.wm_title, l.wm_title_en, l.wm_image3, l.wm_tag FROM ".$_TB['lecture_rel']." AS r LEFT JOIN ".$_TB['lecture']." AS l ON r.wm_lec_no=l.wm_id WHERE r.wm_pl_no=".$lecture_idx." AND ifnull(l.wm_status,'N')='Y' ORDER BY r.wm_lec_sort asc, r.wm_id asc";
$relec = $db->getFetchQueryAll($sql2);
}
if($row["wm_menu_url"] ){
alert("", $row["wm_menu_url"], "");
exit();
}
?>