//수강료 DB 조회
$sql = "SELECT wm_agency_code, wm_tab_code, wm_subject, wm_minutes, wm_fee FROM sp_tuition WHERE wm_business_code = '"._BIZ_CODE."' and length(wm_agency_code)>=5 order by wm_id asc";
$tt_data = $db->getFetchQueryAll($sql);
if(_BIZ_CODE=='B0001'){
//메스컴
$arr_tuition = array();
foreach($tt_data as $k=>$v){
$tmp['wm_subject'] = $v['wm_subject'];
$tmp['wm_minutes'] = $v['wm_minutes'];
$tmp['wm_fee'] = $v['wm_fee'];
$arr_tuition[$v['wm_agency_code']][] = $tmp;
}
$_AGENCY_CODE = _AGENCY_CODE?_AGENCY_CODE:'A0001';
//탭별 수강료 목록
$t_table = '';
foreach($arr_tuition as $k=>$t_list){
// $t_table .= '
';
//on
$display_tab = '';
if($_AGENCY_CODE == $k){
$display_tab = 'style="display:inline-table"';
}
$t_table .= '
| 과목명 |
총 교습 시간(분) |
수강료(원) |
';
foreach($t_list as $kk=>$vv){
$t_table .= '
| '.$vv['wm_subject'].' |
'.$vv['wm_minutes'].' |
'.$vv['wm_fee'].' |
';
}
$t_table .= '
';
}
}
else if(_BIZ_CODE=='B0002'){
//메가IT
$arr_tuition = array();
foreach($tt_data as $k=>$v){
$tmp['wm_agency_code'] = $v['wm_agency_code'];
$tmp['wm_tab_code'] = $v['wm_tab_code'];
$tmp['wm_subject'] = $v['wm_subject'];
$tmp['wm_minutes'] = $v['wm_minutes'];
$tmp['wm_fee'] = $v['wm_fee'];
$arr_tuition[$v['wm_agency_code']][$v['wm_tab_code']][] = $tmp;
}
$_AGENCY_CODE = _AGENCY_CODE?_AGENCY_CODE:'C0001';
$arr_tabnm = array('A'=>'정규과정', 'B'=>'단과과정', 'C'=>'방학특강과정', 'D'=>'자격증과정');
//탭별 수강료 목록
$t_table = '';
foreach($arr_tuition as $k=>$agen){
foreach($agen as $kk=>$tabs){
//on
$display_tab = '';
if($_AGENCY_CODE.'A' == $k.$kk){
$display_tab = 'style="display:inline-table"';
}
$t_table .= '
| 과목명 |
총 교습 시간(분) |
수강료(원) |
';
foreach($tabs as $kkk=>$v){
$t_table .= '
| '.$v['wm_subject'].' |
'.$v['wm_minutes'].' |
'.$v['wm_fee'].' |
';
}
$t_table .= '
';
}
}
//tabs
foreach($arr_tabnm as $k=>$v){
//li > tabs
$li_tabs .= '
'.$v.'';
}
}
?>
수강료 안내
CURRICULUM AND COST
if(_BIZ_CODE == "B0001"){?>
}else if(_BIZ_CODE == 'B0002'){?>
}?>
=$t_table?>
$lec_name = $lecture['wm_title']; //단과과정
include(Vi."quickcounseling.php");
?>