ÿØÿà JFIF ` ` ÿþ
Server : Apache System : Linux ruga7-004.fmcity.com 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : tkt_travelbus ( 1137) PHP Version : 7.0.0p1 Disable Function : mysql_pconnect Directory : /tkt_travelbus/www/admin/setting/ |
Upload File : |
<? include "../include/top_proc.html"; // 작성권한설정 if($SqlType=="paper_auth_updt") { if(!$ptype) exit; $auth_ga=""; // 삭제 db_query("delete from TB_PAPER_AUTH where ptype='{$ptype}' "); if(is_array($auth_arr)) { foreach($auth_arr as $v) { $auth_ga .= $v."||"; } } // 저장 $sql = "insert into TB_PAPER_AUTH set "; $sql .= "ptype='{$ptype}', "; $sql .= "auth_ga='{$auth_ga}', "; $sql .= "ins_id='{$TK_MEMBER[mb_id]}',"; $sql .= "ins_nm='{$TK_MEMBER[mb_nm]}',"; $sql .= "ins_dt = now() "; db_query($sql); error_msg("document.location.reload();","script"); } // 승인항목 저장 elseif($SqlType=="paper_ins") { if(!$ptype) exit; $sql = "insert into TB_PAPER set ptype='{$ptype}', psubj='{$psubj}', "; for($i=1 ; $i<=7 ; $i++) { $cfm_rank_id = ${"cfm".$i."_rank_id"}; // 직급 $cfm_id = ${"cfm".$i."_id"}; // ID // 직급 $cfm_rank_nm = ""; if($cfm_rank_id) { $data_rank = base_codec("CRP","RANK",$cfm_rank_id,"N"); $row_rank = $data_rank[0]; $cfm_rank_nm = $row_rank['cd_nm']; } // member ID $cfm_nm = ""; if($cfm_id) { $row_member = get_member($cfm_id); $cfm_nm = $row_member['mb_nm']; } $sql .= "cfm{$i}_rank_id='{$cfm_rank_id}' ,cfm{$i}_rank_nm='{$cfm_rank_nm}', cfm{$i}_id='{$cfm_id}', cfm{$i}_nm='{$cfm_nm}', "; } $sql .= "ins_dt=now()"; db_query($sql); error_msg("parent.document.location.reload();","script"); } // 승인항목 수정 elseif($SqlType=="paper_updt") { if(!$pidx) exit; $sql = "update TB_PAPER set psubj='{$psubj}', "; for($i=1 ; $i<=7 ; $i++) { $cfm_rank_id = ${"cfm".$i."_rank_id"}; // 직급 $cfm_id = ${"cfm".$i."_id"}; // ID // 직급 $cfm_rank_nm = ""; if($cfm_rank_id) { $data_rank = base_codec("CRP","RANK",$cfm_rank_id,"N"); $row_rank = $data_rank[0]; $cfm_rank_nm = $row_rank['cd_nm']; } // member ID $cfm_nm = ""; if($cfm_id) { $row_member = get_member($cfm_id); $cfm_nm = $row_member['mb_nm']; } $sql .= "cfm{$i}_rank_id='{$cfm_rank_id}' ,cfm{$i}_rank_nm='{$cfm_rank_nm}', cfm{$i}_id='{$cfm_id}', cfm{$i}_nm='{$cfm_nm}', "; } $sql .= "ins_dt=now() where pidx='{$pidx}' "; db_query($sql); error_msg("parent.document.location.reload();","script"); } // 승인항목 삭제 elseif($SqlType=="del_paper") { if(!$pidx) exit; db_query("delete from TB_PAPER where pidx='{$pidx}' "); error_msg("parent.document.location.reload();","script"); } ?>