hmw1001
119 lines
4.0 KiB
PHP
119 lines
4.0 KiB
PHP
<?php
|
|
$sub_menu = '400900'; // 임시 메뉴 코드 (적절히 변경 필요)
|
|
include_once('./_common.php');
|
|
|
|
auth_check_menu($auth, $sub_menu, "r");
|
|
|
|
$g5['title'] = '결제 내역 관리';
|
|
include_once(G5_ADMIN_PATH.'/admin.head.php');
|
|
|
|
// 검색 조건
|
|
$sfl = $_GET['sfl'] ?? '';
|
|
$stx = $_GET['stx'] ?? '';
|
|
$sod = $_GET['sod'] ?? '';
|
|
$spt = $_GET['spt'] ?? '';
|
|
$page = $_GET['page'] ?? 1;
|
|
|
|
$where = " WHERE 1 ";
|
|
if ($stx) {
|
|
if ($sfl === 'od_id') {
|
|
$where .= " AND od_id LIKE '%{$stx}%' ";
|
|
} else if ($sfl === 'mb_id') {
|
|
$where .= " AND mb_id LIKE '%{$stx}%' ";
|
|
} else if ($sfl === 'od_name') {
|
|
$where .= " AND od_name LIKE '%{$stx}%' ";
|
|
}
|
|
}
|
|
|
|
$sql_common = " FROM {$g5['g5_shop_order_table']} {$where} ";
|
|
$sql_order = " ORDER BY od_id DESC ";
|
|
|
|
$row_count = sql_fetch(" SELECT COUNT(*) as cnt {$sql_common} ");
|
|
$total_count = $row_count['cnt'];
|
|
|
|
$rows = $config['cf_page_rows'];
|
|
$total_page = ceil($total_count / $rows); // 전체 페이지 계산
|
|
$from_record = ($page - 1) * $rows; // 시작 레코드 구함
|
|
|
|
$sql = " SELECT * {$sql_common} {$sql_order} LIMIT {$from_record}, {$rows} ";
|
|
$result = sql_query($sql);
|
|
|
|
$qstr = 'sfl='.$sfl.'&stx='.$stx.'&sod='.$sod.'&spt='.$spt;
|
|
?>
|
|
|
|
<div class="local_sch01 local_sch">
|
|
<form name="fsearch" id="fsearch" class="local_sch_search" method="get">
|
|
<label for="sfl" class="sound_only">검색대상</label>
|
|
<select name="sfl" id="sfl">
|
|
<option value="od_id" <?php echo get_selected($sfl, 'od_id'); ?>>주문번호</option>
|
|
<option value="mb_id" <?php echo get_selected($sfl, 'mb_id'); ?>>회원ID</option>
|
|
<option value="od_name" <?php echo get_selected($sfl, 'od_name'); ?>>주문자명</option>
|
|
</select>
|
|
<label for="stx" class="sound_only">검색어<strong class="sound_only"> 필수</strong></label>
|
|
<input type="text" name="stx" value="<?php echo $stx; ?>" id="stx" required class="frm_input">
|
|
<input type="submit" value="검색" class="btn_submit">
|
|
</form>
|
|
</div>
|
|
|
|
<div class="local_ov01 local_ov">
|
|
전체 <?php echo number_format($total_count); ?> 건
|
|
</div>
|
|
|
|
<div class="tbl_head01 tbl_wrap">
|
|
<table>
|
|
<caption><?php echo $g5['title']; ?> 목록</caption>
|
|
<thead>
|
|
<tr>
|
|
<th scope="col">주문번호</th>
|
|
<th scope="col">주문자</th>
|
|
<th scope="col">결제금액</th>
|
|
<th scope="col">결제수단</th>
|
|
<th scope="col">결제상태</th>
|
|
<th scope="col">주문일시</th>
|
|
<th scope="col">관리</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php
|
|
for ($i=0; $row=sql_fetch_array($result); $i++) {
|
|
$bg = 'bg'.($i%2);
|
|
?>
|
|
<tr class="<?php echo $bg; ?>">
|
|
<td class="td_num">
|
|
<a href="./payment_form.php?od_id=<?php echo $row['od_id']; ?>&<?php echo $qstr; ?>&page=<?php echo $page; ?>"><?php echo $row['od_id']; ?></a>
|
|
</td>
|
|
<td class="td_mb_id">
|
|
<?php echo $row['od_name']; ?> (<?php echo $row['mb_id'] ? $row['mb_id'] : '비회원'; ?>)
|
|
</td>
|
|
<td class="td_numbig">
|
|
<?php echo number_format($row['od_receipt_price']); ?>원
|
|
</td>
|
|
<td class="td_center">
|
|
<?php echo $row['od_settle_case']; ?>
|
|
</td>
|
|
<td class="td_center">
|
|
<?php echo $row['od_status']; ?>
|
|
</td>
|
|
<td class="td_datetime">
|
|
<?php echo $row['od_time']; ?>
|
|
</td>
|
|
<td class="td_mng">
|
|
<a href="./payment_form.php?od_id=<?php echo $row['od_id']; ?>&<?php echo $qstr; ?>&page=<?php echo $page; ?>" class="btn btn_03">상세</a>
|
|
</td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
if ($total_count == 0) {
|
|
echo '<tr><td colspan="7" class="empty_table">데이터가 없습니다.</td></tr>';
|
|
}
|
|
?>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
|
|
<?php echo get_paging_admin(G5_IS_MOBILE ? $config['cf_mobile_pages'] : $config['cf_page_rows'], $page, $total_page, $_SERVER['SCRIPT_NAME'].'?'.$qstr.'&page='); ?>
|
|
|
|
<?php
|
|
include_once(G5_ADMIN_PATH.'/admin.tail.php');
|
|
?>
|