<?php // (2020.12.29, 차재복, Cha Jae Bok, cjbword@gmailcom)
# 세션 스타트 (매 웹페이지 마다 필요)
session_start();
# db 접속 (dbi)
include_once "../base_utils/db_conn.php";
# (Ajax) 전달 파라미터 및 관련 함수 호출 목록
// (id, type, sub_type ?)
$script_file = substr($_SERVER[SCRIPT_NAME],strrpos($_SERVER[SCRIPT_NAME],"/")+1);
if(isset($_REQUEST['id']) and $script_file=='naviFetch.php') {
$id = $_REQUEST['id'];
if ( isset($_REQUEST[id]) and !empty($id) and !is_numeric($id) or $id<0 ) exit; // 해킹방지 (수치 ≥ 0)
$type = $_REQUEST['type'];
if (!isset($_REQUEST['type']) or $type == 'word') ajaxFetchChildWord ($id, $dbi);
else if ($type == 'source') ajaxFetchChildFile ($id, $dbi);
else if ($type == 'manual') ajaxFetchChildManual ($id, $dbi);
else if ($type == 'db_table') ajaxFetchChildDB ($id, $dbi);
else if ($type == 'src_tree') ajaxFetchChildSrcTree ($id, $dbi);
}
# (Ajax : 용어해설 분류) 용어해설 분류 id에 대해, 해당 관련 no들과 자식 id들을 쿼리하여, JSON 변환시켜 출력
// (대상 테이블 : gubun_tree_v2, book_idx)
function ajaxFetchChildWord ($id, $dbi) {
$query = "(select 'no' as item_type,titlename as name,no as id, 1 as rank, list_ord as ord, '0' as child, yoyak
from book_idx where tree_id=$id)
union all
(select 'id' as item_type,name,id, 2 as rank, sub_seq as ord, child, yoyak
from gubun_tree_v2 where parent=$id)
order by rank,ord";
$result = mysqli_query($dbi, $query);
if (mysqli_errno($dbi)) { $err_msg .= mysqli_errno($dbi)." : ".mysqli_error($dbi)."\n"; }
if (!empty($err_msg)){
$return = array('err_msg'=>$err_msg);
} else {
while ( $matched = mysqli_fetch_assoc($result) ) {
$data[] = array('item_type' => $matched[item_type], 'id'=>$matched[id], 'name'=>$matched[name], 'child'=>$matched[child], 'desc'=>$matched[yoyak]);
}
if (count($data)<1) $return = array('err_msg'=>'해당 id 없음!');
else $return = array('data' => $data);
}
echo json_encode($return, JSON_UNESCAPED_UNICODE);
}
# (Ajax : 소스 폴더 파일 리스트) 소스 파일 id에 대해, 해당 자식 id들을 쿼리하여, JSON 변환시켜 출력
// (대상 테이블 : src_files_v2)
function ajaxFetchChildFile ($id, $dbi) {
$query = "select id,name,child,yoyak,type,(select name from src_files_v2 where id=$id and type='dir') as dir from src_files_v2 where parent=$id order by name";
$result = mysqli_query($dbi, $query);
if (mysqli_errno($dbi)) { $err_msg .= mysqli_errno($dbi)." : ".mysqli_error($dbi)."\n"; }
if (!empty($err_msg)){
$return = array('err_msg'=>$err_msg);
} else {
while ( $matched = mysqli_fetch_assoc($result) ) {
$data[] = array('id'=>$matched[id], 'name'=>$matched[name], 'child'=>$matched[child], 'desc'=>$matched[yoyak], 'item_type'=>$matched[type],'dir'=>$matched[dir]);
}
if (count($data)<1) $return = array('err_msg'=>'해당 id 없음!');
else $return = array('data' => $data);
}
echo json_encode($return, JSON_UNESCAPED_UNICODE);
}
# (Ajax : 소스 관리 메뉴얼) 메뉴얼(reform) id에 대해, 해당 자식 id들을 쿼리하여, JSON 변환시켜 출력
// (대상 테이블 : reform)
function ajaxFetchChildManual ($id, $dbi) {
$query = "select id,name,child,yoyak from reform where parent=$id order by sub_seq";
$result = mysqli_query($dbi, $query);
if (mysqli_errno($dbi)) { $err_msg .= mysqli_errno($dbi)." : ".mysqli_error($dbi)."\n"; }
if (!empty($err_msg)){
$return = array('err_msg'=>$err_msg);
} else {
while ( $matched = mysqli_fetch_assoc($result) ) {
$data[] = array('id'=>$matched[id], 'name'=>$matched[name], 'child'=>$matched[child], 'desc'=>$matched[yoyak]);
}
if (count($data)<1) $return = array('err_msg'=>'해당 id 없음!');
else $return = array('data' => $data);
}
echo json_encode($return, JSON_UNESCAPED_UNICODE);
}
# (Ajax : db 테이블 및 칼럼) database table을 쿼리하여, JSON 변환시켜 출력
// (대상 테이블 : information_schema.tables)
function ajaxFetchChildDB ($id, $dbi) {
if(!empty($_SESSION['db_name'])) $db_name = $_SESSION['db_name'];
else $db_name = 'test';
// $db_name = 'test';
$query = "select (@row_number:=@row_number + 1) as id,
table_name as name,
table_comment as yoyak,
'1' as child,
'table' as item_type
from (select @row_number:=0) as t, information_schema.tables
where table_schema='{$db_name}'";
$result = mysqli_query($dbi,$query);
if (mysqli_errno($dbi)) { $err_msg .= mysqli_errno($dbi)." : ".mysqli_error($dbi)."\n"; }
if (!empty($err_msg)){
$return = array('err_msg'=>$err_msg);
} else {
while ( $matched = mysqli_fetch_assoc($result) ) {
// db 테이블
if($id == 0) {
$data[] = array('id'=>$matched[id], 'name'=>$matched[name], 'child'=>$matched[child], 'desc'=>$matched[yoyak], 'item_type' => $matched[item_type]);
// 특정 테이블 내 칼럼
} else if ($id == $matched[id]) {
$query = "select (@row_number:=@row_number + 1) as id,
concat(column_name,' : ',column_type) as name,
column_comment as yoyak,
'0' as child,
'field' as item_type
from (select @row_number:=0) as t, information_schema.columns
where table_name = '{$matched[name]}'
and table_schema = '{$db_name}'
order by name";
$result = mysqli_query($dbi,$query);
if (mysqli_errno($dbi)) { $err_msg .= mysqli_errno($dbi)." : ".mysqli_error($dbi)."\n"; }
while ( $matched = mysqli_fetch_assoc($result) ) {
$data[] = array('id'=>$matched[id], 'name'=>$matched[name], 'child'=>$matched[child], 'desc'=>$matched[yoyak], 'item_type' => $matched[item_type]);
}
}
}
$return = array('data' => $data);
}
echo json_encode($return, JSON_UNESCAPED_UNICODE);
}
# (Ajax : 소스 역할 트리) 소스 역할 트리(src_tree) id에 대해, 해당 자식 id 또는 src_files_v2의 id를 쿼리하여, JSON 변환시켜 출력
// (대상 테이블 : src_tree)
function ajaxFetchChildSrcTree ($id, $dbi) {
$query = "select a.id,a.name as name_a,a.yoyak as yoyak_a,a.child,a.link,
b.name as name_b,b.yoyak as yoyak_b
from src_tree a left join src_files_v2 b on a.link=b.id
where a.parent=$id
order by a.sub_seq";
$result = mysqli_query($dbi, $query);
if (mysqli_errno($dbi)) { $err_msg .= mysqli_errno($dbi)." : ".mysqli_error($dbi)."\n"; }
if (!empty($err_msg)){
$return = array('err_msg'=>$err_msg);
} else {
while ( $matched = mysqli_fetch_assoc($result) ) {
if(empty($matched[link])) {
$name = $matched[name_a];
$yoyak = $matched[yoyak_a];
} else {
$name = $matched[name_b];
$yoyak = $matched[yoyak_b];
}
$data[] = array('id'=>$matched[id], 'name'=>$name, 'desc'=>$yoyak, 'child'=>$matched[child]);
}
$return = array('data' => $data);
}
echo json_encode($return, JSON_UNESCAPED_UNICODE);
}
# (PHP included) 해당 no(leaf node)로부터 path 가져오기
// (대상 테이블 : gubun_tree_v2, book_idx)
function phpFetchPath ($no, $dbi) {
if(empty($no)) return;
$query = "select
c.id as leaf_id, c.titlename as leaf_name, c.path2node_v2 as full_path,
d.id as sub_id, d.name as sub_name, d.path2node_v2 as sub_path,
e.no as no_1st, e.list_ord
from
(select a.titlename,a.no,a.list_ord,b.id,b.name,b.path2node_v2 from book_idx a left join gubun_tree_v2 b on a.tree_id=b.id where a.no=$no) c
left join
gubun_tree_v2 d
on find_in_set(d.id,c.path2node_v2)
left join
book_idx e
on d.id=e.tree_id and e.list_ord=1
order by full_path,sub_path,list_ord";
$result=mysqli_query($dbi,$query);
if (mysqli_errno($dbi)) {echo mysqli_errno($dbi)." : ".mysqli_error($dbi)."\n";}
while ( $matched = mysqli_fetch_assoc($result) ) {
// 적용 필드 (5) : leaf_id, leaf_name, sub_id, sub_name, no_1st
$name = ( $matched[sub_id]=='0' ? 'Top' : $matched[sub_name] );
$path_lines[$matched[leaf_id]]['leaf_name'] = $matched[leaf_name];
$path_lines[$matched[leaf_id]]['leaf_id'] = $matched[leaf_id];
$path_lines[$matched[leaf_id]]['url_str'][$matched[sub_id]] =
"<span class='subMenu' data-id='$matched[sub_id]' data-direction='v' style='position:relative;'>
<span class='bullet'>▷</span>
<span class='title'>{$name}</span>
</span>";
}
$path = '';
if(count($path_lines) > 0)
foreach($path_lines as $key => $value) {
$path .= implode('',$value[url_str]);
$path .= '<br>';
}
else
$path .= "해당 id에 대한 path 없음";
return $path;
}
?>