include "../include/top.html"; // 본지점 $data_brch = base_codec("CRP","BRCH", "", "N"); $arr = array(); foreach($data_brch as $v){ // 본지점으로 등록된 사원이 없으면 본지점 노출 안함 //$sql = "select count(*) as mcnt from TB_MEMBER where 0=0 AND mb_level < 10 AND emp_guide='Y' AND del_flag='N' and emp_brench_cd='{$v['code']}' "; $sql = "select count(*) as mcnt from TB_MEMBER where (0=0 AND mb_level < 14 AND emp_guide='Y' AND del_flag='N' and emp_brench_cd='{$v['code']}') or emp_depart_cd='DEPT006'"; $r = db_fetch($sql); if ($r['mcnt'] > 0) $arr[] = $v; } $data_brch = $arr; // 업로드 $upload = "../FileData/emp/"; ?>