<?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);