ÿØÿà 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/res_good/ |
Upload File : |
<? include "../include/top_proc.html";//공통파일 인클루드 $B2b = new B2b(); $memo = addslashes($memo); //등록 if($sqlType=="insert"){ $res['msg'] = ''; $res['res'] = ''; $sql = "insert into TB_NOTICE_AGENCY set "; $sql .= " admin_id='{$TK_MEMBER['mb_id']}'"; $sql .= " ,agency_id='{$agency_id}'"; $sql .= " ,title='{$title}'"; $sql .= " ,memo='{$memo}'"; $sql .= " ,wdate=now()"; db_query($sql); $res['res'] = 'ok'; echo json_encode($res); exit; } //수정 else if($sqlType=="update"){ $res['msg'] = ''; $res['res'] = ''; if(empty($uid)) exit; $sql = "update TB_NOTICE_AGENCY set "; $sql .= " title='{$title}'"; $sql .= " ,memo='{$memo}'"; $sql .= " where uid='{$uid}'"; db_query($sql); $res['res'] = 'ok'; echo json_encode($res); exit; } //삭제 else if($sqlType=="delete") { $res['msg'] = ''; $res['res'] = ''; if(!$uid) exit; db_query("delete from TB_NOTICE_AGENCY where uid='{$uid}' "); $res['res'] = 'ok'; echo json_encode($res); exit; } //리스트 else if($sqlType=="list") { $res['msg'] = ''; $res['html'] = ''; $page = ($page)? $page : 1; $line = 10; $list = 10; // 블럭 갯수 $func_name = 'goPageB2BNotice'; $table = " TB_NOTICE_AGENCY "; $sql_where = ""; if(!empty($agency_id)) $sql_where .= " and agency_id='{$agency_id}'"; // 리스트 수 가져옴 $sql = "select count(*) as total from {$table} where 1=1 {$sql_where} "; $row = db_fetch($sql); $total = $row[total]; $total_page = ceil($total/$line); $olds = (!$total)? 1 : $line*($page-1); // $html = ''; $paging = ''; $data = array(); $sql = "select * from {$table} where 1=1 {$sql_where} "; $sql .= " order by uid desc "; if($olds>=0 and $line>0) $sql .= " limit $olds , $line"; $rs = db_query($sql); $i = 0; while($row = db_fetch_array($rs)){ $data[$i] = $row; $i++; } $num = $total - $line*($page-1); if(!empty($data)) { foreach($data as $k=>$v) { $html .= '<tr>'; $html .= '<td style="text-align:left"><a href="javascript:;" onclick="write_form(\''.$v['uid'].'\')">'.$v['title'].'</a></td>'; $html .= '<td>'.$v['wdate'].'</td>'; $html .= '</tr>'; $paging = $B2b->paging($total_page, $list, $page, $func_name); $num--; } } else { $html = ' '; $paging = ' '; } $res['html'] = $html; $res['paging'] = $paging; echo json_encode($res); exit; } //대리점 공지 메모 수정 else if($sqlType=="save"){ $res['msg'] = ''; $res['res'] = ''; if(empty($agent_id)) exit; $filecnt = 2; //첨부파일 $upload = "../../FileData/member/"; // 첨부 파일 경로 설정 $only_file = array("jpg", "gif", "png", "doc", "docx", "xls", "xlsx", "ppt", "pptx", "psd", "ai", "hwp", "pdf", "zip"); // 허용 확장자 설정 // 첨부파일 업로드 처리 for($f=1; $f<=$filecnt; $f++) { $T_UserFile_name = $_FILES["T_UserFile".$f]['name']; if ($T_UserFile_name) { $ext = strtolower(substr(strrchr($T_UserFile_name, '.'), 1)); if (in_array($ext, $only_file) == false) { error_msg('잘못된 파일입니다'); } ${"sFile".$f} = FileUploadName("", $upload, $_FILES{"T_UserFile".$f}['tmp_name'], $T_UserFile_name, "", ""); ${"sFile".$f."_org"} = $T_UserFile_name; } } $sql = "update TB_MEMBER set "; $sql .= " ag_memo='{$ag_memo}'"; for($f=1;$f<=$filecnt;$f++){ if(${"sFile".$f}){ $sql.=" ,ag_file".$f." = '".${"sFile".$f}."' \n"; $sql.=" ,ag_file".$f."_org = '".${"sFile".$f."_org"}."' \n"; } } $sql .= " where mb_id='{$agent_id}'"; db_query($sql); $res['res'] = 'ok'; echo json_encode($res); exit; } ?>