/**
* Retrieves all orders (if the authenticated user is an admin) or orders
* of a certain customer (if the authenticated user is a customer) from the
* database as well as their products. Displays the order list.
*/
public static function get_orders()
{
$orders = array();
$user = self::get_user_logged_in();
if ($user) {
if ($user->username == 'admin') {
$orders = Orders::findAll();
} else {
$orders = Orders::findByUser($user->id);
}
}
foreach ($orders as $order) {
$order_products = OrderProduct::findByOrder($order->id);
foreach ($order_products as $index => $order_product) {
$order->products[$index] = json_decode($order_product->product_info);
}
$order->user_info = json_decode($order->user_info);
}
View::make('order/list.html', array('orders' => $orders));
}
/**
* 首页
*
*/
public function actionIndex()
{
$model = new Orders();
$criteria = new CDbCriteria();
$condition = "1=1";
$username = trim($this->_request->getParam('username'));
$order_code = trim($this->_request->getParam('order_code'));
$status = intval($this->_request->getParam('status'));
$username && ($condition .= ' AND username LIKE \'%' . $username . '%\'');
$order_code && ($condition .= ' AND order_code like \'%' . $order_code . '%\'');
$status && ($condition .= ' AND status= ' . $status);
$criteria->condition = $condition;
$criteria->order = 'id DESC';
$count = $model->count($criteria);
$pages = new CPagination($count);
$pages->pageSize = 10;
//根据goods_name,catelogId查询
$pageParams = $this->buildCondition($_GET, array('username', 'order_code', 'status'));
$pages->params = is_array($pageParams) ? $pageParams : array();
$criteria->limit = $pages->pageSize;
$criteria->offset = $pages->currentPage * $pages->pageSize;
$result = $model->findAll($criteria);
$this->render('index', array('datalist' => $result, 'pagebar' => $pages));
}
<?php
/**
* [PHPB2B] Copyright (C) 2007-2099, Ualink Inc. All Rights Reserved.
* The contents of this file are subject to the License; you may not use this file except in compliance with the License.
*
* @version $Revision: 2075 $
*/
require "../libraries/common.inc.php";
require "room.share.php";
require PHPB2B_ROOT . './libraries/page.class.php';
uses("order");
$page = new Pages();
$page->displaypg = 25;
$options = cache_read("typeoption");
setvar("pay_status", $options['common_option']);
setvar("order_status", $options['common_status']);
$conditions[] = "member_id=" . $the_memberid;
if (isset($_GET['action'])) {
$action = trim($_GET['action']);
if ($action == "cancel" && !empty($_GET['tradeno'])) {
$pdb->Execute("DELETE FROM " . $tb_prefix . "orders WHERE trade_no='" . $_GET['tradeno'] . "' AND member_id='" . $the_memberid . "' AND pay_status='0'");
}
}
$order = new Orders();
$amount = $order->findCount(null, $conditions);
$page->setPagenav($amount);
$result = $order->findAll("*", null, $conditions, " id desc", $page->firstcount, $page->displaypg);
setvar("ByPages", $page->pagenav);
setvar("datas", $result);
vtemplate("order");
}
}
$tpl_file = "order.goods";
$result = $pdb->GetArray($sql);
if (!empty($result)) {
$total_price = 0;
for ($i = 0; $i < count($result); $i++) {
$tmp_str = explode("|", $result[$i]['content']);
if ($result[$i]['goods_id'] == "2" && strpos($result[$i]['content'], "|") === false) {
$total_price = $result[$i]['total_price'];
$result[$i]['price'] = $result[$i]['total_price'];
$result[$i]['charge'] = 1;
} else {
$total_price += $result[$i]['price'] * $result[$i]['amount'];
}
}
setvar("Items", $result);
setvar("TotalPrice", $total_price);
}
template($tpl_file);
exit;
}
}
}
$joins[] = "LEFT JOIN {$tb_prefix}members m ON m.id=Orders.member_id LEFT JOIN {$tb_prefix}memberfields mf ON mf.member_id=Orders.member_id";
$amount = $order->findCount($joins, null, "Orders.id");
$page->setPagenav($amount);
$result = $order->findAll("Orders.*,m.username,mf.first_name,mf.last_name as true_name", $joins, $conditions, " Orders.id DESC", $page->firstcount, $page->displaypg);
setvar("Items", $result);
setvar("ByPages", $page->pagenav);
template($tpl_file);
