|
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/intra/ |
Upload File : |
<?php
include "../../Lib/config.php";
if( ($_COOKIE['MemberLevel'] == $cf['agent_level'] || $_COOKIE['MemberLevel'] == $cf['trade_level']) ) {
include "../include/top_agent.html";
$b2b_mode = true;
} else {
include "../include/top.html";
$b2b_not_mode = true; //대리점 또는 공급처 외
}
include "_common.php";
if($b2b_mode == true) {
$sql_where .= " and AGENT_ID = '{$TK_MEMBER[mb_id]}'";
$sql_where_cate = " WHERE AGENT_ID = '{$TK_MEMBER[mb_id]}'";
}
// 검색
if ($mode == "search" && $input_key) {
if($select_key == 'MTITLE'){
$sql_where .= sprintf(" and (%s like '%%%s%%' OR AGENT_ID in (SELECT mb_id FROM TB_MEMBER WHERE bz_corp_nm LIKE '%%%s%%'))", $select_key, $input_key, $input_key);
} else {
$sql_where .= " and ".$select_key." like '%".$input_key."%' ";
}
}
// 분류
$sql_where .= " and MLEVEL = 0 AND MCATE = 'CAL' AND CONFIRM_YN = 'N'";
if($mcate) $sql_where .= " and MCATE = '{$mcate}' ";
// 정렬 설정
$sql_order = " MREF DESC, MSTEP ASC, MSEQ DESC ";
$total = TBL_TOTAL('TB_INTRA_DATA', "where 1=1" . $sql_where);
// 페이지수 설정
if (!$page) $page = 1; // 페이지 번호
$line = 40; // 보여줄 갯수
$list = 10; // 블럭 갯수
$total_page = ceil($total / $line); // 총페이지
if ($total == 0) $total_page = 1; // 데이터가 하나도 없으면 총페이지 1
if ($page > $total_page) $page = $total_page; // 페이지가 전체 페이지보다 크면 페이지 번호를 바꿈
$total_list = intval($total_page / $list);
if ($total_page % $list == 0) $total_list--;
$curr_list = intval($page / $list);
if ($page % $list == 0) $curr_list--;
$start_page = $curr_list * $list + 1;
$prev_list = $start_page - $list;
$next_list = $start_page + $list;
$olds = $line * ($page - 1);
//p($sql_where);
//p($sql_order);
//p();
//리스트불러오기
$DATA = board_intra_list($sql_where,$sql_order,$olds,$line);
//파라메터
$href= "&mcate=$mcate";
$href.= "&mode=$mode";
$href.= "&select_key=$select_key";
$href.= "&input_key=$input_key";
$param = $href."&page=$page";
?>
<script type="text/javascript">
$(document).ready(function(){
$("input[name='mcate']").on("click",function(){
document.location.href='<?=$PHP_SELF?>?<?=$href?>&mcate='+$(this).val();
});
});
// 인트라넷 상태변경
function intra_change_status(mseq){
ajax_post('','../intra/intra_proc.php?SqlType=change_status&mseq='+mseq);
}
</script>
<style>
.price{border:1px solid #ccc}
</style>
<div class="contents_wrap">
<div class="contents_wrap_in">
<div class="title">
<?php
if($b2b_not_mode) {
?>
<p style="display:none">인트라넷</p><!-- 삭제시 title태그에 안나오므로 삭제 유의 -->
<img style="width:128px;margin-left: -10px;margin-top:-2px" src="/admin/image/intranet/intranetImg4.png" />
<?php } else { ?>
<strong><?=_e('정산관리&리스트')?></strong>
<? } ?>
</div>
<div class="contents_detail">
<form name="Search_List" method="GET" action="<?=$PHP_SELF?>">
<input type="hidden" name="mode" value="search" />
<div class="c_top_bar">
<ul class="c_top_search">
<li>
<select name="select_key" id="select_key">
<option value="MTITLE" <?if($select_key=='MTITLE') echo "selected";?>><?=_e('제목')?></option>
<option value="MEM_NM" <?if($select_key=='MEM_NM') echo "selected";?>><?=_e('작성자')?></option>
<option value="MCONT" <?if($select_key=='MCONT') echo "selected";?>><?=_e('내용')?></option>
</select>
</li>
<li>
<label for="input_key" class="v_none2"><?=_e('검색어 입력')?></label>
<input class="search_box" id="input_key" name="input_key" type="text" value="<?=$input_key?>" />
<?php
if(strpos($_SERVER['HTTP_HOST'], 'tkplace.co.kr') !== false){
?>
<input type="submit" value="<?=_e('검색')?>" style="background:#34495e;color:#fff;border:none;height: 28px;" />
<?php
}else{
?>
<input type="image" src="../image/btn/btn_search.gif" align="top" alt="<?=_e('검색')?>검색" 11 class="input_btn_search" />
<?php
}
?>
</li>
</ul>
</div>
<div id="Content_box">
</form>
<form name="board_List" id="board_List" method="POST">
<input type="hidden" name="SqlType" id="SqlType" value="" />
<table width="100%" border="0" cellspacing="0" cellpadding="0" id="board_list_tbl" class="t_list intra_list" summary="<?=_e('게시물을 확인하실 수 있습니다.')?>">
<caption><?=_e('게시물 확인')?></caption>
<colgroup>
<col style="width:60px" />
<col style="width:110px" />
<col />
<col style="width:110px" />
<col style="width:110px" />
<col style="width:100px" />
<col style="width:140px" />
<col style="width:110px" />
<col style="width:130px" />
<col style="width:60px" />
</colgroup>
<thead>
<tr>
<th scope="col">No</th>
<th scope="col"><?=_e('구분')?></th>
<th scope="col"><?=_e('제목')?></th>
<th scope="col"><?=_e('청구금액')?></th>
<th scope="col"><?=_e('담당부서')?></th>
<th scope="col"><?=_e('작성자')?></th>
<th scope="col"><?=_e('등록일')?></th>
<th scope="col"><?=_e('상태')?></th>
<th scope="col"><?=_e('첨부파일')?></th>
<th scope="col"><?=_e('조회')?></th>
</tr>
</thead>
<tbody>
<?php
for($i=0 ; $i < count($DATA) ; $i++){
$row = $DATA[$i];
if($row['MCATE'] != 'NOTI'){
$num = $total - ($page - 1) * $line - $count;
$count++;
} else {
$num = "공지";
}
$FontTitle = "";
if($row['MLEVEL']>0){
if($row['MLEVEL'] > 5){
$row['MLEVEL']=5;
}
for($j=1;$j<=$row['MLEVEL'];$j++){
$FontTitle .= " ";
}
}
//리플이미지
if($row['MSTEP']>0){
$REPLE_IMG = "<img src='../image/board/re2.png' />";
}else{
$REPLE_IMG ="";
}
$FontTitle .= $REPLE_IMG;
?>
<tr <? if($row[MCATE] == 'NOTI') echo "style='background-color:#e7f2f8;'" ?>>
<td><?=$num?></td>
<td>
<?
switch ($row[CATE_NM]) {
case '중요메모' :
$cate_color = "#eb3b5a";
break;
case '환불내역서' :
$cate_color = "#fc5c65";
break;
case '프로젝트' :
$cate_color = "#2d3436";
break;
case '거래처정산' :
$cate_color = "#00b894";
break;
case '대외공문' :
$cate_color = "#30336b";
break;
case '미팅보고서' :
$cate_color = "#f9ca24";
break;
case '업무일지' :
$cate_color = "#a4b0be";
break;
case '품의보고' :
$cate_color = "#fc5c65";
break;
// case '정산요청' :
case '공급처정산' :
$cate_color = "#eb3b5a";
break;
case '정산답변' :
$cate_color = "#00b894";
break;
case '세무회계' :
$cate_color = "#837392";
break;
default :
$cate_color = "";
break;
}
?>
<?if($row[MLEVEL] == 0) { ?>
<? if($cate_color){ ?>
<span 1212c style="background-color:<?=$cate_color?>; padding:3px 5px; color:#FFF;display:inline-block;border-radius:3px"><?=_e($row[CATE_NM])?></span>
<? } else { ?>
<?=_e($row[CATE_NM])?>
<? } ?>
<? } ?>
</td>
<td class="t_title" style="font-weight:normal;">
<a href="intra_view.html?<?=$param?>&MSEQ=<?=$row[MSEQ]?>">
<?if($b2b_not_mode && $row[CORP_NM] && $row[MLEVEL] == 0) echo "<b><font color='{$cate_color}'>[{$row[CORP_NM]}]</b></font>" ?>
<?=$FontTitle?>
<?=$row[MTITLE]?>
</a>
<? if($row[COMT_CNT] > 0) echo "<img src='../../image/board/btu_comment.gif' align='absmiddle' border='0' alt='코멘트관리' /><span class='comment c_red'><b>(".$row[COMT_CNT].")</b></span>"; ?>
<?=$row[NEW_IMG]?>
<?php
$isFile = false;
for($j=1;$j<=3;$j++){
if($row["MFILE".$j]!=""){
$isFile = true;
}
}
if($isFile){
echo '<img src="../../image/board/bullet_disk.gif">';
}
?>
<?=$row[HOT_IMG]?>
<?=$row[DEPOSIT_IMG]?>
<?=$row[NODEPOSIT_IMG]?>
</td>
<td>
<b style="color:red;color: red;
float: right;
margin-right: 23px;"><?=number_format($row['price'])?></b>
</td>
<td><?=$row[DEPT_NM]?></td>
<td><?=$row[MEM_NM]?></td>
<td>
<?php
// echo str_replace('-','.',substr($row[INSDT], 0, 16));
// echo '<br>';
echo date('Y.m.d / H:i:s',strtotime($row['INSDT']));
?>
</td>
<td class="intra_status">
<?php
if($row[MLEVEL] == 0) {
echo $row[STATUS];
}
?>
</td>
<td style="padding:0;">
<?
for($j=1;$j<=3;$j++){
if($row["MFILE".$j]!=""){
?>
<?=$j?><a href="../lib/Download.php?Type=INTRA&FileName=<?=$row["MFILE".$j]?>&FileNameOrg=<?=$row["MFILE".$j."_org"]?>" title="다운로드"><img src='/admin/image/cal_file_icon.gif' width='25'></a>
<?
}
}
?>
</td>
<td><?=$row[READCNT]?></td>
</tr>
<? } ?>
</tbody>
</table>
</form>
</div>
<?=adm_get_paging($total_page, $page, $list, "?$href&page=", "")?>
</div>
</div>
</div>
<? include "../include/footer.html" ?>
<?
?>