📄 orders.php
字号:
<table cellspacing="0" cellpadding="0" border="0" width="99%" align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%" style="word-break:break-all;">
<tr class="header" align="center">
<td align="left" width="6%"><?=;?></td>
<td align="left" width="22%"><?=TABLE_HEADING_PRODUCTS;?></td>
<td align="left" width="12%"><?=TABLE_HEADING_PRODUCTS_MODEL;?></td>
<td align="left" width="8%"><?=TABLE_HEADING_TAX;?></td>
<td align="left" width="13%"><?=TABLE_HEADING_PRICE_EXCLUDING_TAX;?></td>
<td align="left" width="13%"><?=TABLE_HEADING_PRICE_INCLUDING_TAX;?></td>
<td align="left" width="13%"><?=TABLE_HEADING_TOTAL_EXCLUDING_TAX;?></td>
<td align="left" width="13%"><?=TABLE_HEADING_TOTAL_INCLUDING_TAX;?></td>
</tr>
<?
for ($i=0, $n=sizeof($order->products); $i<$n; $i++) {
?>
<tr align="left">
<td bgcolor="<?=ALTBG1?>"><?php echo $order->products[$i]['qty']; ?></td>
<td align="left" bgcolor="<?=ALTBG1?>"><?php echo $order->products[$i]['name'];
if (isset($order->products[$i]['attributes']) && (sizeof($order->products[$i]['attributes']) > 0)) {
for ($j = 0, $k = sizeof($order->products[$i]['attributes']); $j < $k; $j++) {
echo '<br><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'];
if ($order->products[$i]['attributes'][$j]['price'] != '0') echo ' (' . $order->products[$i]['attributes'][$j]['prefix'] . $currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . ')';
echo '</i></small></nobr>';
}
}
?>
</td>
<td align="left" bgcolor="<?=ALTBG1?>"><?php echo $order->products[$i]['model'];?></td>
<td align="left" bgcolor="<?=ALTBG1?>"><?php echo tep_display_tax_value($order->products[$i]['tax']);?></td>
<td align="left" bgcolor="<?=ALTBG1?>"><?php echo $currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']);?></td>
<td align="left" bgcolor="<?=ALTBG1?>"><?php echo $currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value']);?></td>
<td align="left" bgcolor="<?=ALTBG1?>"><?php echo $currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']);?></td>
<td align="left" bgcolor="<?=ALTBG1?>"><?php echo $currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']);?></td>
</tr>
<?
}
?>
</table></td></tr></table>
<br>
<table cellspacing="0" cellpadding="0" border="0" width="95%" align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%" style="word-break:break-all;">
<tr class="header" align="center">
<td align="left"><?=ENTRY_PAYMENT_METHOD; echo $order->delivery['customers_name'].$order->delivery['lastname']?></td>
</tr>
<tr>
<td bgcolor="<?=ALTBG1?>" valign="top">
<table cellspacing="0" cellpadding="0" border="0" width="100%" align="center">
<tr><td align="right" width="25%"><?=ENTRY_PAYMENT_METHOD; ?></td><td align="left" width="25%"><?php echo $order->info['payment_method']; ?></td><td align="right" width="25%"></td><td align="left" width="25%"></td></tr>
<?php
if (tep_not_null($order->info['cc_type']) || tep_not_null($order->info['cc_owner']) || tep_not_null($order->info['cc_number'])) {
?>
<tr><td align="right"><?php echo ENTRY_CREDIT_CARD_TYPE; ?></td><td align="left"><?php echo $order->info['cc_type']; ?></td><td align="right"><?php echo ENTRY_CREDIT_CARD_OWNER; ?></td><td align="left"><?php echo $order->info['cc_owner']; ?></td></tr>
<tr><td align="right"><?php echo ENTRY_CREDIT_CARD_NUMBER; ?></td><td align="left"><?php echo $order->info['cc_number']; ?></td><td align="right"><?php echo ENTRY_CREDIT_CARD_EXPIRES; ?></td><td align="left"><?php echo $order->info['cc_expires']; ?></td></tr>
<?php
}
?>
</table></td></tr></table></td></tr></table>
<br>
<table cellspacing="0" cellpadding="0" border="0" width="95%" align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%" style="word-break:break-all;">
<tr class="header" align="center">
<td align="left">订单总计</td>
</tr>
<tr>
<td bgcolor="<?=ALTBG1?>" valign="top">
<table cellspacing="0" cellpadding="0" border="0" width="95%" align="center">
<?php
for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
//echo $order->totals[$i]['text'];
echo '<tr>
<td align="right" width="65%">' . $order->totals[$i]['title'] . '</td>
<td align="left" >' . $order->totals[$i]['text'] . '</td>
</tr>';
}
?>
</table></td></tr></table></td></tr></table>
<br>
<table cellspacing="0" cellpadding="0" border="0" width="95%" align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%" style="word-break:break-all;">
<tr class="header" align="center">
<td align="center" width="25%"><?=TABLE_HEADING_DATE_ADDED;?></td>
<td align="center" width="15%"><?=TABLE_HEADING_CUSTOMER_NOTIFIED;?></td>
<td align="center" width="10%"><?=TABLE_HEADING_STATUS;?></td>
<td align="center" width="15%"><?=ENTRY_MEMBER_MARK_ADD;?></td>
<td align="center"><?=TABLE_HEADING_COMMENTS;?></td>
</tr>
<?php
$query = $db->query("select osh.orders_status_id,os.orders_status_name, osh.date_added, osh.customer_notified, osh.comments,osh.comments2, osh.total_mark from $table_orders_status_history osh left join $table_orders_status os on osh.orders_status_id=os.orders_status_id where osh.orders_id = '" . addslashes($oID) . "' and os.language_id='".$languages_id."' order by date_added");
//echo "<Pre>";print_r($order->customer);
if ($db->num_rows($query)) {
while ($orders_history = $db->fetch_array($query)) {
if($orders_history['comments2']!=""){
$comments2=$orders_history['comments'];
}
echo '<tr>
<td align="center" bgcolor="'.ALTBG1.'">' .($orders_history['date_added']) . '</td>
<td bgcolor="'.ALTBG1.'" align="center">';
if ($orders_history['customer_notified'] == '1') {
echo '<img src="images/icons/tick.gif" border="0" alt="'.ICON_TICK.'"></td>';
} else {
echo '<img src="images/icons/cross.gif" border="0" alt="'.ICON_CROSS.'"></td>';
}
echo ' <td bgcolor="'.ALTBG1.'">' .$orders_history['orders_status_name']. '</td>
<td bgcolor="'.ALTBG1.'" align="center">' .($orders_history['total_mark']==1 ? ENTRY_UPDATE_MEMBER_MARK_YET : ENTRY_UPDATE_MEMBER_MARK_NOT ). '</td>
<td bgcolor="'.ALTBG1.'">' . nl2br(addslashes($orders_history['comments'])) . ' </td>
</tr>';
$do_member_total_mark_check=$orders_history['total_mark'];
}
//echo $do_member_total_mark_check;
} else {
echo '<tr>
<td bgcolor="'.ALTBG1.'" colspan="5">' . TEXT_NO_ORDER_HISTORY . '</td>
</tr>';
$do_member_total_mark_check=0;
}
?>
</table></td></tr></table>
<br>
<table cellspacing="0" cellpadding="0" border="0" width="95%" align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>"> <table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%" style="word-break:break-all;">
<tr class="header" align="center"><td align="left"><?=ENTRY_ORDERS_COMMENTS2?></td></tr>
<tr bgcolor="<?=ALTBG1?>" align="center"><td align="left"><?=$comments2?></td></tr>
</table></td></tr></table>
<form name="status" <?php echo 'action="' . tep_href_link('admincp.php', 'act=orders&action=update&oID='.$oID, 'NONSSL') . '"'; ?> method="post">
<table cellspacing="0" cellpadding="0" border="0" width="95%" align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%" style="word-break:break-all;">
<tr class="header" align="center">
<td align="left"><?=ENTRY_NOTIFY_COMMENTS; ?></td>
</tr>
<tr>
<td bgcolor="<?=ALTBG1?>" valign="top" align="center">
<textarea name="comments" wrap="soft" cols="60" rows="3"></textarea>
</td></tr></table></td></tr></table>
<br>
<table cellspacing="0" cellpadding="0" border="0" width="95%" align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%" style="word-break:break-all;">
<tr class="header" align="center">
<td align="left"><?=ENTRY_CUSTOMER; echo $order->customer['name']?></td>
</tr>
<tr>
<td bgcolor="<?=ALTBG1?>" valign="top">
<table cellspacing="0" cellpadding="0" border="0" width="95%" align="center">
<tr ><td width="25%" align="right"><?php echo ENTRY_STATUS; ?></td><td align="left" width="25%"><?=tep_draw_pull_down_menu('new_orders_status', $orders_statuses, $order->info['orders_status']); ?></td><td align="right" width="25%"><?php echo ENTRY_NOTIFY_CUSTOMER; ?></td><td align="left"><input type="checkbox" name="notify"></td></tr>
<tr ><td width="25%" align="right"><?php echo ENTRY_NOTIFY_COMMENTS; ?></td><td align="left"><input type="checkbox" name="notify_comments"></td><td align="right"><?php echo ($do_member_total_mark_check==1) ? ENTRY_UPDATE_MEMBER_MARK_DELETE : ENTRY_UPDATE_MEMBER_MARK_ADD; ?></td><td align="left"><input type="hidden" name="member_mark_status" value="<?=$do_member_total_mark_check?>"><?php echo ($do_member_total_mark_check==1) ? '<input type="checkbox" name="do_member_mark" value="0">' : '<input type="checkbox" name="do_member_mark" value="1">';; ?></td></tr>
</table></td></tr></table></td></tr></table>
<br><center><?=$warning?>
<input type="submit" name="submit" value="提 交">
</center></form><br><br>
<?php
}
break;
case 'edit_customers':
$query = $db->query("select c.customers_id, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_default_address_id from $table_customers c left join $table_address_book a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '" . (int)$HTTP_GET_VARS['cID'] . "'");
@extract($db->fetch_array($query));
$newsletter = '<select name="customers_newsletter"><option value="1" '.($customers_newsletter=='1' ? "selected" :'').'>' .ENTRY_NEWSLETTER_YES . '</option><option value="0" '.($customers_newsletter=='0' ? "selected" :'').'>' .ENTRY_NEWSLETTER_NO. '</option></select>';
break;
default:
}
}else{
if($page) {
$start_limit = ($page - 1) * MAX_DISPLAY_SEARCH_RESULTS ;
} else {
$start_limit = 0;
$page = 1;
}
$conditions = "";
$conditions.= $orders_id != "" ? " AND (o.orders_id LIKE '%$orders_id%' OR o.orders_id='$orders_id')" : NULL;
$conditions.= $customers_name != "" ? " AND (o.customers_name LIKE '%$customers_name%' OR o.customers_name='$customers_name')" : NULL;
$conditions.= $customers_email != "" ? " AND (o.customers_email_address LIKE '%$customers_email%' OR o.customers_email_address='$customers_email')" : NULL;
$conditions.= $status_id != "" ? " AND s.orders_status_id = '" . (int)$status_id . "' " : NULL;
$query=$db->query("select COUNT(*) from $table_orders o left join $table_orders_total ot on (o.orders_id = ot.orders_id), $table_orders_status s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' $conditions order by o.orders_id DESC");
$multipage = multi($db->result($query, 0), MAX_DISPLAY_SEARCH_RESULTS, $page, "admincp.php?act=orders&order=$order".($desc ? "&desc=$desc" : NULL));
$query=$db->query("select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from $table_orders o left join $table_orders_total ot on (o.orders_id = ot.orders_id), $table_orders_status s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' $conditions order by o.orders_id DESC limit $start_limit ,".MAX_DISPLAY_SEARCH_RESULTS);
?>
<br>
<br>
<table cellspacing="0" cellpadding="0" border="0" width="95%" align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%" style="word-break:break-all;">
</tr><td bgcolor="<?=ALTBG1?>" colspan="2">
<?=$multipage?></td></tr>
</table></td></tr></table>
<br>
<table cellspacing="0" cellpadding="0" border="0" width="95%" align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%" style="word-break:break-all;">
<tr class="header" align="center">
<td><?=TABLE_HEADING_CUSTOMERS; ?></td>
<td><?=TABLE_HEADING_ORDER_TOTAL; ?></td>
<td><?=TABLE_HEADING_DATE_PURCHASED; ?></td>
<td><?=TABLE_HEADING_STATUS; ?></td>
<td><?=TABLE_HEADING_ACTION; ?></td></tr>
<?
while ($orders = $db->fetch_array($query)) {
?>
<tr>
<td bgcolor="<?=ALTBG1?>" width="15%"><?php echo $orders['customers_name']; ?></td>
<td bgcolor="<?=ALTBG1?>" align="left" width="15%"><?php echo strip_tags($orders['order_total']); ?></td>
<td bgcolor="<?=ALTBG1?>" align="center"><?php echo ($orders['date_purchased']); ?></td>
<td bgcolor="<?=ALTBG1?>" align="center"><?php echo $orders['orders_status_name']; ?></td>
<td bgcolor="<?=ALTBG2?>" align="center" width="15%">
<a href="<?echo tep_href_link("admincp.php", 'act=orders&oID=' . $orders['orders_id'].'&type=delete');?>">删除</a>
<a href="<?echo tep_href_link('admincp.php', 'act=orders&oID=' . $orders['orders_id'].'&type=edit');?>">详情</a>
</td>
</tr>
<?
}
?>
</table></td></tr></table>
<br>
<table cellspacing="0" cellpadding="0" border="0" width="95%" align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%" style="word-break:break-all;">
</tr>
<td bgcolor="<?=ALTBG1?>" colspan="2">
<?=$multipage?></td></tr>
</table></td></tr></table>
<?
}
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -