open();
$show = "";
$query = "select decode(si_appl,'0','신청서','확인서') appl_txt from ge_si where si_cd = '$cd' ";
$oci->parse($query);
$oci->exec();
while($oci->fetchInto(&$col,$mode=OCI_NUM)){
$show = $show."|
\n";
}
$oci->parseFree();
$xmlStr = "\n";
$xmlStr .= " ";
$xmlStr .= $show;
$xmlStr .= " \n";
$xmlStr .= "DATANAME=_appl_title\n";
$show = "";
$query = "select a.si_cd, ge_mi_cd_fu(a.mi_cd) mi_nm, a.si_nm, ge_com_cd_fu('g008', a.si_division) division, a.si_addr1||' '||a.si_addr2 addr, a.si_tel, a.si_fax, b.si_pyoung,
b.si_room_cnt, b.si_curt_cnt, substr(a.reg_strt_day,1,4)||'/'||substr(a.reg_strt_day,5,2)||'/'||substr(a.reg_strt_day,7,2) reg_strt, d.ti_cnt, e.st_cnt,
b.si_area_sch, b.si_area_st_cnt, ge_com_cd_fu('g007',b.si_location) loca, b.si_org_usr_nm um_nm, c.en_nm, substr(b.si_org_user_jumin,1,6)||'-'||substr(b.si_org_user_jumin,7,7) jumin,
decode(substr(b.si_org_user_jumin,7,1),'1','남','2','여') sex, b.si_org_user_phone tel, c.cel, c.edu_cls, c.usr_his
from ge_si a,
ge_si_etc b,
(select a.si_cd si_cd, a.um_id um_id, a.et_edu_no edu_no, ge_com_cd_fu('g009',a.si_edu_cls) edu_cls, a.si_usr_his usr_his, b.um_nm um_nm,
b.um_en_nm en_nm, substr(b.um_jumin,1,6)||'-'||substr(b.um_jumin,7,1)||'******' jumin, decode(substr(b.um_jumin,7,1),'1','남','2','여') sex,
b.um_tel tel, b.um_cel cel
from ge_si_usr a,
ge_usr b
where a.um_id = b.um_id) c,
(select si_cd, count(si_cd) as ti_cnt from ge_ti group by si_cd) d,
(select si_cd, count(si_cd) as st_cnt from ge_st group by si_cd) e
where a.si_cd = b.si_cd(+)
and a.si_cd = c.si_cd(+)
and a.si_cd = d.si_cd(+)
and a.si_cd = e.si_cd(+)
and a.si_cd = '$cd' ";
$oci->parse($query);
$oci->exec();
while($oci->fetchInto(&$col,$mode=OCI_NUM)){
$show = $show."|
\n";
}
$oci->parseFree();
/*--------------------------------------------------*/
/* 오라클 데이테베이스 CLOSE
/*--------------------------------------------------*/
$oci->close();
$xmlStr .= "
";
$xmlStr .= $show;
$xmlStr .= " \n";
$xmlStr .= "DATANAME=_si_info\n";
$xmlStr .= "
";
echo $xmlStr;
?>