// 시작 열을 구함
$sql = " select *\n {$sql_common}\n order by ad_default desc, ad_id desc\n limit {$from_record}, {$rows}";
$result = sql_query($sql);
if (!sql_num_rows($result)) {
alert_close('배송지 목록 자료가 없습니다.');
}
$list = array();
$sep = chr(30);
for ($i = 0; $row = sql_fetch_array($result); $i++) {
$list[$i] = $row;
$list[$i]['addr'] = $row['ad_name'] . $sep . $row['ad_tel'] . $sep . $row['ad_hp'] . $sep . $row['ad_zip1'] . $sep . $row['ad_zip2'] . $sep . $row['ad_addr1'] . $sep . $row['ad_addr2'] . $sep . $row['ad_addr3'] . $sep . $row['ad_jibeon'] . $sep . $row['ad_subject'];
$list[$i]['addr'] = get_text($list[$i]['addr']);
$list[$i]['ad_name'] = get_text($list[$i]['ad_name']);
$list[$i]['ad_subject'] = get_text($list[$i]['ad_subject']);
$list[$i]['del_href'] = $_SERVER['SCRIPT_NAME'] . '?w=d&ad_id=' . $row['ad_id'];
$list[$i]['print_addr'] = print_address($row['ad_addr1'], $row['ad_addr2'], $row['ad_addr3'], $row['ad_jibeon']);
}
$action_url = G5_HTTPS_SHOP_URL . '/orderaddressupdate.php';
$write_pages = G5_IS_MOBILE ? $config['cf_mobile_pages'] : $config['cf_write_pages'];
$list_page = $_SERVER['SCRIPT_NAME'] . '?' . $qstr . '&page=';
$pid = $pid ? $pid : '';
// Page ID
$at = apms_page_thema($pid);
include_once G5_LIB_PATH . '/apms.thema.lib.php';
$skin_row = array();
$skin_row = apms_rows('order_' . MOBILE_ . 'skin, order_' . MOBILE_ . 'set');
$order_skin_path = G5_SKIN_PATH . '/apms/order/' . $skin_row['order_' . MOBILE_ . 'skin'];
$order_skin_url = G5_SKIN_URL . '/apms/order/' . $skin_row['order_' . MOBILE_ . 'skin'];
// 스킨설정
$wset = array();
if ($skin_row['order_' . MOBILE_ . 'set']) {
$intercept_msg = '';
$intercept_title = '';
if ($row['mb_leave_date']) {
$mb_id = $mb_id;
$leave_msg = '<span class="mb_leave_msg">탈퇴함</span>';
} else {
if ($row['mb_intercept_date']) {
$mb_id = $mb_id;
$intercept_msg = '<span class="mb_intercept_msg">차단됨</span>';
$intercept_title = '차단해제';
}
}
if ($intercept_title == '') {
$intercept_title = '차단하기';
}
$address = $row['mb_zip1'] ? print_address($row['mb_addr1'], $row['mb_addr2'], $row['mb_addr3'], $row['mb_addr_jibeon']) : '';
$bg = 'bg' . $i % 2;
switch ($row['mb_certify']) {
case 'hp':
$mb_certify_case = '휴대폰';
$mb_certify_val = 'hp';
break;
case 'ipin':
$mb_certify_case = '아이핀';
$mb_certify_val = '';
break;
case 'admin':
$mb_certify_case = '관리자';
$mb_certify_val = 'admin';
break;
default:
" id="ad_default<?php
echo $i;
?>
" <?php
if ($row['ad_default']) {
echo 'checked="checked"';
}
?>
>
<label for="ad_default<?php
echo $i;
?>
">기본배송지 설정</label>
</div>
<div class="addr_addr"><?php
echo print_address($row['ad_addr1'], $row['ad_addr2'], $row['ad_addr3'], $row['ad_jibeon']);
?>
</div>
<div class="addr_name"><?php
echo $row['ad_name'];
?>
</div>
<div class="addr_tel"><?php
echo $row['ad_tel'];
?>
/ <?php
echo $row['ad_hp'];
?>
</div>
<div class="addr_btn">
<input type="hidden" value="<?php
<td><?php
echo get_text($od['od_b_tel']);
?>
</td>
</tr>
<tr>
<th scope="row">핸드폰</th>
<td><?php
echo get_text($od['od_b_hp']);
?>
</td>
</tr>
<tr>
<th scope="row">주 소</th>
<td><?php
echo get_text(sprintf("(%s%s)", $od['od_b_zip1'], $od['od_b_zip2']) . ' ' . print_address($od['od_b_addr1'], $od['od_b_addr2'], $od['od_b_addr3'], $od['od_b_addr_jibeon']));
?>
</td>
</tr>
<?php
// 희망배송일을 사용한다면
if ($default['de_hope_date_use']) {
?>
<tr>
<th scope="row">희망배송일</th>
<td><?php
echo substr($od['od_hope_date'], 0, 10) . ' (' . get_yoil($od['od_hope_date']) . ')';
?>
</td>
</tr>
<?php
}
} else {
$billing = false;
}
if ($_POST['endpos']) {
$endpos = $_POST['endpos'];
} else {
$endpos = NUM_LABELS_PER_PAGE;
}
if (!tep_db_num_rows($orders_query) > 0) {
message_handler('NO_ORDERS');
}
change_color(GENERAL_FONT_COLOR);
for ($y = $pdf->ez['pageHeight'] - STARTY; $y > LABEL_HEIGHT - STARTY; $y -= LABEL_HEIGHT) {
for ($x = STARTX; $x < STARTX + NUM_COLUMNS * LABEL_WIDTH; $x += LABEL_WIDTH) {
if ($startpos <= $pos && $num < $endpos) {
if (print_address($x, $y, $num)) {
$num++;
}
}
$pos++;
}
// Send fake header to avoid timeout, got this trick from phpMyAdmin
$time1 = time();
if ($time1 >= $time0 + 30) {
$time0 = $time1;
header('X-bpPing: Pong');
}
}
// EOWHILE
}
<tr><td align="right" class="order_header">Tax:</td><td align="right">$<?php
echo sprintf("%0.2f", $db->result("tax"));
?>
</td></tr>
<tr><td align="right" class="order_header">Total:</td><td align="right">$<?php
echo sprintf("%0.2f", $db->result("total"));
?>
</td></tr>
</table>
</td></tr>
</table><br>
<table width="95%" align="center" cellpadding="4" cellspacing="0" style="border:2px solid #000000;">
<tr class="bar"><td colspan="2" align="left" style="font-weight:bold;font-size:14px;">Billing Information</td></tr>
<tr><td valign="top"><?php
print_address($db->result("bill_address"));
?>
</td><td valign="top">
<table align="right" cellpadding="2" cellspacing="0" border="0">
<tr><td align="right" class="order_header">Payment Type:</td><td align="left"><?php
if ($db->result("payment_method") == 'cc') {
print "Credit Card";
} else {
print "Purchase Order";
}
?>
</td></tr>
<?php
if ($db->result("payment_method") == 'cc') {
$tdb->query("select * from cc_charges where order_id = '{$order_id}' order by datetime desc limit 0,1");
if ($tdb->numrows()) {
} else {
echo $fr_od_id . ' 부터 ' . $to_od_id . ' 까지 ' . $ct_status . ' 내역';
}
?>
</h1>
<?php
$mod = 10;
$tot_total_price = 0;
$save_it_id = '';
for ($i = 0; $row = sql_fetch_array($result); $i++) {
$sql1 = " select * from {$g5['g5_shop_order_table']} where od_id = '{$row['od_id']}' ";
$row1 = sql_fetch($sql1);
// 1.03.02
$row1['od_addr'] = '(' . $row1['od_zip1'] . $row1['od_zip2'] . ') ' . print_address($row1['od_addr1'], $row1['od_addr2'], $row1['od_addr3'], $row1['od_addr_jibeon']);
$row1['od_b_addr'] = '(' . $row1['od_b_zip1'] . $row1['od_b_zip2'] . ') ' . print_address($row1['od_b_addr1'], $row1['od_b_addr2'], $row1['od_b_addr3'], $row1['od_b_addr_jibeon']);
$row1['od_addr'] = $row1['od_addr'] ? $row1['od_addr'] : '입력안함';
$row1['od_tel'] = $row1['od_tel'] ? $row1['od_tel'] : '입력안함';
$row1['od_hp'] = $row1['od_hp'] ? $row1['od_hp'] : '입력안함';
$row1['od_b_tel'] = $row1['od_b_tel'] ? $row1['od_b_tel'] : '입력안함';
$row1['od_b_hp'] = $row1['od_b_hp'] ? $row1['od_b_hp'] : '입력안함';
// 보내는 사람과 받는 사람이 완전 일치하면 간단하게 출력
// 보내는 사람과 받는 사람이 부분 일치하더라도 원래 내용을 모두 출력
// 지운아빠 2013-04-18
if ($row1['od_name'] == $row1['od_b_name'] && $row1['od_addr'] == $row1['od_b_addr'] && $row1['od_tel'] == $row1['od_b_tel'] && $row1['od_hp'] == $row1['od_b_hp'] && $row1['od_hp'] != " ") {
$samesamesame = 1;
} else {
$samesamesame = '';
}
$od_memo = $row1['od_memo'] ? get_text(stripslashes($row1['od_memo'])) : '';
$od_shop_memo = $row1['od_shop_memo'] ? get_text(stripslashes($row1['od_shop_memo'])) : '';
?>
"><?php
echo $od_b_hp;
?>
</td>
</tr>
<tr>
<th scope="row" style="<?php
echo $th_st;
?>
">주소</th>
<td style="<?php
echo $td_st;
?>
"><?php
echo sprintf("(%s%s)", $od_b_zip1, $od_b_zip2) . ' ' . print_address($od_b_addr1, $od_b_addr2, $od_b_addr3, $od_b_addr_jibeon);
?>
</td>
</tr>
<tr>
<th scope="row" style="<?php
echo $th_st;
?>
">전하실 말씀</th>
<td style="<?php
echo $td_st;
?>
"><?php
echo $od_memo;
?>
</td>
include_once G5_LIB_PATH . '/Excel/php_writeexcel/class.writeexcel_workbook.inc.php';
include_once G5_LIB_PATH . '/Excel/php_writeexcel/class.writeexcel_worksheet.inc.php';
$fname = tempnam(G5_DATA_PATH, "tmp-deliverylist.xls");
$workbook = new writeexcel_workbook($fname);
$worksheet = $workbook->addworksheet();
// Put Excel data
$data = array('주문번호', '주문자명', '주문자전화1', '주문자전화2', '배송자명', '배송지전화1', '배송지전화2', '배송지주소', '배송회사', '운송장번호');
$data = array_map('iconv_euckr', $data);
$col = 0;
foreach ($data as $cell) {
$worksheet->write(0, $col++, $cell);
}
for ($i = 1; $row = sql_fetch_array($result); $i++) {
$row = array_map('iconv_euckr', $row);
$worksheet->write($i, 0, ' ' . $row['od_id']);
$worksheet->write($i, 1, $row['od_name']);
$worksheet->write($i, 2, ' ' . $row['od_tel']);
$worksheet->write($i, 3, ' ' . $row['od_hp']);
$worksheet->write($i, 4, $row['od_b_name']);
$worksheet->write($i, 5, ' ' . $row['od_b_tel']);
$worksheet->write($i, 6, ' ' . $row['od_b_hp']);
$worksheet->write($i, 7, print_address($row['od_b_addr1'], $row['od_b_addr2'], $row['od_b_addr3'], $row['od_b_addr_jibeon']));
$worksheet->write($i, 8, $row['od_delivery_company']);
$worksheet->write($i, 9, $row['od_invoice']);
}
$workbook->close();
header("Content-Type: application/x-msexcel; name=\"deliverylist-" . date("ymd", time()) . ".xls\"");
header("Content-Disposition: inline; filename=\"deliverylist-" . date("ymd", time()) . ".xls\"");
$fh = fopen($fname, "rb");
fpassthru($fh);
unlink($fname);
echo $member['mb_email'] ? $member['mb_email'] : '미등록';
?>
</dd>
<dt>최종접속일시</dt>
<dd><?php
echo $member['mb_today_login'];
?>
</dd>
<dt>회원가입일시</dt>
<dd><?php
echo $member['mb_datetime'];
?>
</dd>
<dt class="ov_addr">주소</dt>
<dd class="ov_addr"><?php
echo sprintf("(%s-%s)", $member['mb_zip1'], $member['mb_zip2']) . ' ' . print_address($member['mb_addr1'], $member['mb_addr2'], $member['mb_addr3'], $member['mb_addr_jibeon']);
?>
</dd>
</dl>
</section>
<section id="smb_my_od">
<h2><a href="<?php
echo G5_SHOP_URL;
?>
/orderinquiry.php">최근 주문내역</a></h2>
<?php
// 최근 주문내역
define("_ORDERINQUIRY_", true);
$limit = " limit 0, 5 ";
include G5_MSHOP_PATH . '/orderinquiry.sub.php';
</td></tr>
<tr><td align="right"><b>Tax:</b></td><td align="right">$<?php
echo sprintf("%0.2f", $order['tax']);
?>
</td></tr>
<tr><td align="right"><b>Total:</b></td><td align="right">$<?php
echo sprintf("%0.2f", $order['total']);
?>
</td></tr>
</table>
</td></tr>
</table><br>
<br>
<table width="95%" align="center" cellpadding="4" cellspacing="0">
<tr><td valign="top"><b>Billing Address</b><br><?php
print_address($order['bill_address']);
?>
</td><td valign="top">
<table align="right" cellpadding="2" cellspacing="0" border="0">
<tr><td align="right" class="order_header">Payment Type:</td><td align="left"><?php
if ($order['payment_method'] == 'cc') {
print "Credit Card";
} else {
print "Purchase Order";
}
?>
</td></tr>
<?php
if ($order['payment_method'] == 'cc') {
$results = mysql_query("select * from cc_charges where order_id = '" . $order['id'] . "' order by datetime desc limit 0,1");
if (mysql_num_rows($results)) {
?>
</table>
<?php
} else {
?>
<div class="order_header">Purchase Order Information</div><br>
<?php
$results = mysql_query("select * from order_po where id = '" . $db->result("id") . "' limit 0,1", $dbh);
echo '<span class="order_header">PO Number</span>: ', mysql_result($results, 0, "po_number");
}
?>
</td></tr>
<tr><td>
<div class="order_header">Shipping Information</div>
<?php
print_address($db->result("ship_address"));
?>
</td></tr>
</table>
<?php
}
}
?>
<div id="footer"><?php
if (isset($_GET[start_date])) {
print "<a href=\"report.php?start_date={$_GET['start_date']}&end_date={$_GET['end_date']}&status={$_GET['status']}\">Back to Report</a>";
} else {
?>
<a href="/admin/">Main Menu</a><?php
}
?>
