require_once "common.html"; $wm_db_id = $_GET['wm_id']; //기본 지점 $sql = "SELECT d.wm_title, c.wm_agency_code, c.wm_agency_name FROM sp_consultdb d, sp_agency c WHERE d.wm_id = ".$wm_db_id." AND d.wm_basic_business = c.wm_business_code AND c.wm_official = 'N' ORDER BY wm_agency_code asc"; $basic_cmp = $db->getFetchQueryAll($sql); $db_title = $basic_cmp[0]['wm_title']; //과정 & 과목 리스트 $sql = "SELECT p.wm_title AS part, s.wm_id, s.wm_title, s.wm_ag_cd, s.wm_ag_nm FROM sp_consultdb_part_subject AS s LEFT JOIN sp_consultdb_part AS p ON p.wm_id = s.wm_part_id and p.is_del = 'N' WHERE s.is_del = 'N' AND p.wm_db_id = ".$wm_db_id." ORDER BY p.wm_sort ASC, s.wm_sort ASC"; $part_subject = $db->getFetchQueryAll($sql); $fst_title = $part_subject[0]['part']; $arr_part = $arr_sbj = array(); if(sizeof($part_subject)){ foreach($part_subject as $v){ if(!isset($arr_sbj[$v['part']])) $arr_sbj[$v['part']] = []; $arr_sbj[$v['part']][] = $v; if(!in_array($v['part'], $arr_part)){ array_push($arr_part, $v['part']); } } } // 하단 학과선택 체크 하기 if(!isset($lec_key) || $lec_key=='') $lec_key = 1; ?>