// 250402 CI 작업으로 인한 redirect by 양찬용
# 뷰티 리뉴얼 > 실 적용 시 주석 해제
// if(!_IS_QA) {
header("Location: /camp/doc/customer");
exit();
// }
/**
* 고객상담센터 >간편 수강료 조회(t), 간편 상담예약(v), 온라인 상담예약(o)
*/
include(dirname(__FILE__)."/../inc/top.php");
$arr_cs = array('t'=>'간편 수강료 조회', 'v'=>'간편 방문 상담예약', 'o'=>'온라인 상담예약');
$flag = param_get_post('flag');
$flag = $flag ? $flag : 't';
$u = param_get_post('u');
if(strpos($_SERVER['PHP_SELF'], 'customer2') !== false){
$flag = 's';
}
// 분야정보
$sql = "SELECT wm_id, wm_title
FROM ".$_TB['counsel']."
WHERE is_del='N' and wm_business_code = '".$_sess['mem_biz_code']."'
order by wm_sort asc";
$data = $db->getFetchQueryAll($sql);
$arr_lecgroup = [];
foreach($data as $v){
$arr_lecgroup[] = $v;
}
// 분야체크 과정 array
$sql = "SELECT c.wm_id AS part_id, c.wm_title AS part_title, c.wm_sort AS part_sort,s.wm_id, s.wm_title, s.wm_sort
FROM ".$_TB['counsel']." c, ".$_TB['counsel_sub']." s
WHERE c.is_del='N' AND c.wm_business_code = '".$_sess['mem_biz_code']."' AND c.wm_id = s.wm_parent_id AND s.is_del = 'N'
AND (s.wm_auto_end_date is null or DATE_FORMAT(wm_auto_end_date, '%Y-%m-%d') >= DATE_FORMAT(NOW(), '%Y-%m-%d'))
ORDER BY c.wm_sort ASC, s.wm_sort ASC";
$cs_lec = $db->getFetchQueryAll($sql);
$arr_lec = [];
foreach($cs_lec as $v){
$arr_lec[$v['part_id']][] = $v;
}
// 하단 과정선택 체크 하기
if($lec_major=='') $lec_major = $cs_major;
foreach($arr_lecgroup as $k=>$v){
if($lec_major==$v) $lec_key = ($k+1);
}
if(!isset($lec_key) || $lec_key=='') $lec_key = 1;
?>