1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
|
<?php
$sub_menu = '290100';
include_once('./_common.php');
auth_check($auth[$sub_menu], "r");
$date = preg_replace("/([0-9]{4})([0-9]{2})([0-9]{2})/", "\\1-\\2-\\3", $date);
$g5['title'] = "$date 일 매출현황";
include_once (G5_ADMIN_PATH.'/admin.head.php');
$sql = " select od_id,
mb_id,
od_name,
od_settle_case,
od_cart_price,
od_receipt_price,
od_receipt_point,
od_cancel_price,
od_misu,
(od_cart_price + od_send_cost + od_send_cost2) as orderprice,
(od_cart_coupon + od_coupon + od_send_coupon) as couponprice
from {$g5['g5_shop_order_table']}
where SUBSTRING(od_time,1,10) = '$date'
order by od_id desc ";
$result = sql_query($sql);
?>
<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>
<th scope="col">카드입금</th>
<th scope="col">휴대폰</th>
<th scope="col">포인트입금</th>
<th scope="col">주문취소</th>
<th scope="col">미수금</th>
</tr>
</thead>
<tbody>
<?php
unset($tot);
for ($i=0; $row=sql_fetch_array($result); $i++)
{
if ($row['mb_id'] == '') { // 비회원일 경우는 주문자로 링크
$href = '<a href="./orderlist.php?sel_field=od_name&search='.$row['od_name'].'">';
} else { // 회원일 경우는 회원아이디로 링크
$href = '<a href="./orderlist.php?sel_field=mb_id&search='.$row['mb_id'].'">';
}
$receipt_bank = $receipt_card = $receipt_vbank = $receipt_iche = $receipt_hp = 0;
if($row['od_settle_case'] == '무통장')
$receipt_bank = $row['od_receipt_price'];
if($row['od_settle_case'] == '가상계좌')
$receipt_vbank = $row['od_receipt_price'];
if($row['od_settle_case'] == '계좌이체')
$receipt_iche = $row['od_receipt_price'];
if($row['od_settle_case'] == '휴대폰')
$receipt_hp = $row['od_receipt_price'];
if($row['od_settle_case'] == '신용카드')
$receipt_card = $row['od_receipt_price'];
?>
<tr>
<td class="td_alignc"><a href="./orderform.php?od_id=<?php echo $row['od_id']; ?>"><?php echo $row['od_id']; ?></a></td>
<td class="td_name"><?php echo $href; ?><?php echo $row['od_name']; ?></a></td>
<td class="td_numsum"><?php echo number_format($row['orderprice']); ?></td>
<td class="td_numcoupon"><?php echo number_format($row['couponprice']); ?></td>
<td class="td_numincome"><?php echo number_format($receipt_bank); ?></td>
<td class="td_numincome"><?php echo number_format($receipt_vbank); ?></td>
<td class="td_numincome"><?php echo number_format($receipt_iche); ?></td>
<td class="td_numincome"><?php echo number_format($receipt_card); ?></td>
<td class="td_numincome"><?php echo number_format($receipt_hp); ?></td>
<td class="td_numincome"><?php echo number_format($row['od_receipt_point']); ?></td>
<td class="td_numcancel1"><?php echo number_format($row['od_cancel_price']); ?></td>
<td class="td_numrdy"><?php echo number_format($row['od_misu']); ?></td>
</tr>
<?php
$tot['orderprice'] += $row['orderprice'];
$tot['ordercancel'] += $row['od_cancel_price'];
$tot['coupon'] += $row['couponprice'] ;
$tot['receipt_bank'] += $receipt_bank;
$tot['receipt_vbank'] += $receipt_vbank;
$tot['receipt_iche'] += $receipt_iche;
$tot['receipt_card'] += $receipt_card;
$tot['receipt_hp'] += $receipt_hp;
$tot['receipt_point'] += $row['od_receipt_point'];
$tot['misu'] += $row['od_misu'];
}
if ($i == 0) {
echo '<tr><td colspan="12" class="empty_table">자료가 없습니다</td></tr>';
}
?>
</tbody>
<tfoot>
<tr>
<td colspan="2">합 계</td>
<td><?php echo number_format($tot['orderprice']); ?></td>
<td><?php echo number_format($tot['coupon']); ?></td>
<td><?php echo number_format($tot['receipt_bank']); ?></td>
<td><?php echo number_format($tot['receipt_vbank']); ?></td>
<td><?php echo number_format($tot['receipt_iche']); ?></td>
<td><?php echo number_format($tot['receipt_card']); ?></td>
<td><?php echo number_format($tot['receipt_hp']); ?></td>
<td><?php echo number_format($tot['receipt_point']); ?></td>
<td><?php echo number_format($tot['ordercancel']); ?></td>
<td><?php echo number_format($tot['misu']); ?></td>
</tr>
</tfoot>
</table>
</div>
<?php
include_once (G5_ADMIN_PATH.'/admin.tail.php');
?>
|