Beispiel #1
0
// 시작 열을 구함
$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']) {
Beispiel #2
0
 $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:
Beispiel #3
0
" 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 
Beispiel #5
0
        }
    } 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
}
Beispiel #6
0
<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'] != "&nbsp;") {
        $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'])) : '';
Beispiel #8
0
?>
"><?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);
Beispiel #10
0
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';
Beispiel #11
0
</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)) {
Beispiel #12
0
            ?>
</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 
}
?>