ÿØÿà 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/work_request/ |
Upload File : |
<? include "../include/top_proc.html"; //공통파일 인클루드 include "_common.php"; $table = "TB_MEMBER"; // 근태수정 if($SqlType=="s01_updt"){ if (!$seq) exit; $sql= "update {$table}_S01 set mb_date='{$mb_date}' "; $sql .= " , gubun='{$gubun}' "; $sql .= " , edit_admin = '{$TK_MEMBER[mb_id]}' "; $sql .= " , edit_dt = now()"; $sql .= " where seq='{$seq}' "; db_query($sql); error_msg("document.location.href='manager_s01.html?mb_id={$mb_id}&tmp_layer_id={$tmp_layer_id}';","script"); } // 근태삭제 elseif($SqlType=="s01_dele"){ if (!$seq) exit; $sql = "delete from {$table}_S01 where seq='{$seq}' "; db_query($sql); error_msg("document.location.href='manager_s01.html?mb_id={$mb_id}&tmp_layer_id={$tmp_layer_id}';","script"); } // 연장근무 수정 else if($SqlType=="s02_updt"){ if (!$seq) exit; $start_tm = $start_tm_1.":".$start_tm_2; $end_tm = $end_tm_1.":".$end_tm_2; $sql= "update {$table}_S02 set mb_date='{$mb_date}' "; $sql .= " ,start_tm = '{$start_tm}' "; $sql .= " ,end_tm = '{$end_tm}' "; $sql .= " ,work_minute = '{$work_minute}' "; $sql .= " , edit_admin = '{$TK_MEMBER[mb_id]}' "; $sql .= " , edit_dt = now()"; $sql .= " where seq='{$seq}' "; db_query($sql); error_msg("document.location.href='manager_s02.html?mb_id={$mb_id}&tmp_layer_id={$tmp_layer_id}';","script"); } // 연장근무 삭제 elseif($SqlType=="s02_dele"){ if (!$seq) exit; $sql = "delete from {$table}_S02 where seq='{$seq}' "; db_query($sql); error_msg("document.location.href='manager_s02.html?mb_id={$mb_id}&tmp_layer_id={$tmp_layer_id}';","script"); } // 휴가월차 수정 else if($SqlType=="s03_updt"){ if (!$seq) exit; $start_tm = $start_tm_1.":".$start_tm_2; $end_tm = $end_tm_1.":".$end_tm_2; $sql= "update {$table}_S03 set mb_date='{$mb_date}' "; $sql .= " ,gubun = '{$gubun}' "; $sql .= " ,start_dt = '{$start_dt}' "; $sql .= " ,end_dt = '{$end_dt}' "; $sql .= " , edit_admin = '{$TK_MEMBER[mb_id]}' "; $sql .= " , edit_dt = now()"; $sql .= " where seq='{$seq}' "; db_query($sql); error_msg("document.location.href='manager_s03.html?mb_id={$mb_id}&tmp_layer_id={$tmp_layer_id}';","script"); } // 휴가월차 삭제 elseif($SqlType=="s03_dele"){ if (!$seq) exit; $sql = "delete from {$table}_S03 where seq='{$seq}' "; db_query($sql); error_msg("document.location.href='manager_s03.html?mb_id={$mb_id}&tmp_layer_id={$tmp_layer_id}';","script"); } ?>