주문자이름 수량가져오는소스? 채택완료
상품주문시에만 아래정보를 가져오려고함니다(신규주문없을시 숨김)
관리자로그인일경우 상단에 주문자이름과 갯수등을 가져와서 표시해주려고하는데요
가져오는소스가어덯게되는지 알수잇을가요?
<?php if($member['admin']) {?>
<li><a href="<?php echo G5_ADMIN_URL;?>">주문자: 000님의<font color="red">0</font> 개의 주문이 있습니다</a>
</li>
<?php } ?>
답변 3개
답변에 대한 댓글 1개
댓글을 작성하려면 로그인이 필요합니다.
아래소스로 맨위에주문만 가져오는건성공햇는데 주문이없으면 안나오게하려면 어디를수정해야되는지알수잇을가요?
클릭해서확인하면 안나오게하려구여..
</b></span></font><span style="font-size: 10pt; line-height: 1.5;"><?php</span></p><p>include_once('./_common.php');</p><p> </p><p>$where = array();</p><p>$sql_search = "";</p><p>if ($search != "") {</p><p> if ($sel_field != "") {</p><p> $where[] = " $sel_field like '%$search%' ";</p><p> }</p><p> </p><p> if ($save_search != $search) {</p><p> $page = 1;</p><p> }</p><p>}</p><p> </p><p>if ($od_status) {</p><p> </p><p> </p><p> switch ($od_status) {</p><p> case '주문' :</p><p> $sort1 = "od_id";</p><p> $sort2 = "desc";</p><p> break;</p><p> </p><p> }</p><p>}</p><p> </p><p> </p><p> </p><p>if ($fr_date && $to_date) {</p><p> $where[] = " od_time between '$fr_date 00:00:00' and '$to_date 23:59:59' ";</p><p>}</p><p> </p><p>if ($where) {</p><p> $sql_search = ' where '.implode(' and ', $where);</p><p>}</p><p> </p><p>if ($sel_field == "") $sel_field = "od_id";</p><p>if ($sort1 == "") $sort1 = "od_id";</p><p>if ($sort2 == "") $sort2 = "desc";</p><p> </p><p>$sql_common = " from {$g5['g5_shop_order_table']} $sql_search ";</p><p> </p><p>$sql = " select count(od_id) as cnt " . $sql_common;</p><p>$row = sql_fetch($sql);</p><p>$total_count = $row['cnt'];</p><p>$rows = '1';</p><p>$rows = $config['cf_page_rows'];</p><p>$total_page = ceil($total_count / $rows); // 전체 페이지 계산</p><p>if ($page < 1) { $page = 1; } // 페이지가 없으면 첫 페이지 (1 페이지)</p><p>$from_record = ($page - 1) * $rows; // 시작 열을 구함</p><p> </p><p>$sql = " select *,</p><p> (od_cart_coupon + od_coupon + od_send_coupon) as couponprice</p><p> $sql_common</p><p> order by $sort1 $sort2</p><p> limit $from_record, $rows ";</p><p>$result = sql_query($sql);</p><p> </p><p>$qstr1 = "od_status=".urlencode($od_status)."&od_settle_case=".urlencode($od_settle_case)."&od_misu=$od_misu&od_cancel_price=$od_cancel_price&od_refund_price=$od_refund_price&od_receipt_point=$od_receipt_point&od_coupon=$od_coupon&fr_date=$fr_date&to_date=$to_date&sel_field=$sel_field&search=$search&save_search=$search";</p><p>$qstr = "$qstr1&sort1=$sort1";</p><p> </p><p> </p><p> </p><p> </p><p>?></p><p><style type="text/css"></p><p>.topadm {color:#fff; font-size:11px; height:20px}</p><p>.topadm .a {color:#red;</p><p>}</p><p></style></p><p> <div class="topadm"></p><p> <?php</p><p> for ($i=0; $row=sql_fetch_array($result); $i++)</p><p> {</p><p> // 결제 수단</p><p> $s_receipt_way = $s_br = "";</p><p> if ($row['od_settle_case'])</p><p> {</p><p> $s_receipt_way = $row['od_settle_case'];</p><p> $s_br = '
';</p><p> }</p><p> else</p><p> {</p><p> $s_receipt_way = '결제수단없음';</p><p> $s_br = '
';</p><p> }</p><p> </p><p> if ($row['od_receipt_point'] > 0)</p><p> $s_receipt_way .= $s_br."포인트";</p><p> </p><p> $mb_nick = get_sideview($row['mb_id'], get_text($row['od_name']), $row['od_email'], '');</p><p> </p><p> $od_cnt = 0;</p><p> if ($row['mb_id'])</p><p> {</p><p> $sql2 = " select count(*) as cnt from {$g5['g5_shop_order_table']} where mb_id = '{$row['mb_id']}' ";</p><p> $row2 = sql_fetch($sql2);</p><p> $od_cnt = $row2['cnt'];</p><p> }</p><p> </p><p> // 주문 번호에 device 표시</p><p> $od_mobile = '';</p><p> if($row['od_mobile'])</p><p> $od_mobile = '(M)';</p><p> </p><p> // 주문번호에 - 추가</p><p> switch(strlen($row['od_id'])) {</p><p> case 16:</p><p> $disp_od_id = substr($row['od_id'],0,8).'-'.substr($row['od_id'],8);</p><p> break;</p><p> default:</p><p> $disp_od_id = substr($row['od_id'],0,6).'-'.substr($row['od_id'],6);</p><p> break;</p><p> }</p><p> </p><p> // 주문 번호에 에스크로 표시</p><p> $od_paytype = '';</p><p> if($default['de_escrow_use'] && $row['od_escrow'])</p><p> $od_paytype = '<span class="list_escrow">에스크로</span>';</p><p> </p><p> $uid = md5($row['od_id'].$row['od_time'].$row['od_ip']);</p><p> </p><p> $invoice_time = is_null_time($row['od_invoice_time']) ? G5_TIME_YMDHIS : $row['od_invoice_time'];</p><p> $delivery_company = $row['od_delivery_company'] ? $row['od_delivery_company'] : $default['de_delivery_company'];</p><p> </p><p> $bg = 'bg'.($i%2);</p><p> $td_color = 0;</p><p> if($row['od_cancel_price'] > 0) {</p><p> $bg .= 'cancel';</p><p> $td_color = 1;</p><p> }</p><p> ?></p><p> </p><p> </p><p> <!-- <td headers="th_ordnum" class="td_odrnum2"></p><p> <?php echo $od_mobile; ?></p><p> <a href="<?php echo G5_SHOP_URL; ?>/orderinquiryview.php?od_id=<?php echo $row['od_id']; ?>&uid=<?php echo $uid; ?>"><?php echo $row['od_id']; ?></a>
</p><p> </td> --></p><p> <!--td>주문번호:</p><p> <a href="<?php echo G5_SHOP_URL; ?>/orderinquiryview.php?od_id=<?php echo $row['od_id']; ?>&uid=<?php echo $uid; ?>" class="orderitem"><?php echo $disp_od_id; ?></a></p><p> </td--></p><p> <td><a href="<?php echo G5_ADMIN_URL; ?>/shop_admin/orderlist.php" target="new"><?php echo $row['mb_id']; ?></a>님</td></p><p> </p><p> <td>금액:<?php echo number_format($row['od_cart_price'] + $row['od_send_cost'] + $row['od_send_cost2']); ?></td></p><p> </p><p> </p><p> </p><p> <?php</p><p> $info = get_order_status_sum('주문');</p><p> ?></p><p> </p><p> <input type="hidden" name="current_status[<?php echo $i ?>]" value="<?php echo $row['od_status'] ?>"></p><p> <?php echo $row['od_status']; ?></p><p> </p><p> </p><p> </p><p> <?php</p><p> $tot_itemcount += $row['od_cart_count'];</p><p> $tot_orderprice += ($row['od_cart_price'] + $row['od_send_cost'] + $row['od_send_cost2']);</p><p> $tot_ordercancel += $row['od_cancel_price'];</p><p> $tot_receiptprice += $row['od_receipt_price'];</p><p> $tot_misu += $row['od_misu'];</p><p> }</p><p> mysql_free_result($result);</p><p> if ($i == 0)</p><p> echo '<tr><td colspan="6 class="empty_table">자료가 없습니다.</td></tr>';</p><p> ?>
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인