/**
* Action для страницы "Управление заказами"
*/
public function actionIndex()
{
// Получаем список заказов
$orders = Order::getOrderList();
// Подключаем вид
require_once ROOT . '/views/admin_order/index.php';
return true;
}
public function run()
{
$order_model = Order::getOrderList();
$nurser = NurseUser::getNOList();
//print_r($order_model);die;
$vars = array('order_model' => $order_model);
$this->controller->render('index', $vars);
}
<?php
require_once '../common/config/config.inc.php';
require_once SOURCE_ROOT . 'classes/class.paging.php';
require_once SOURCE_ROOT . 'classes/class.sort.php';
require_once SOURCE_ROOT . 'classes/class.order.php';
// CREATING OBJECTS------------------------
$objPaging = new Paging();
$objOrder = new Order();
// GETTING PAGE RECORD LOMIT.
$varPageStart = $objPaging->getPageStartLimit($_GET['page'], ADMIN_PAGE_RECORD_SIZE);
$varLimit = $varPageStart . ',' . ADMIN_PAGE_RECORD_SIZE;
// BLANK WHERE CONDITION TO GET ALL RECORDS WITH LIMIT.
$varWhereCondition = $objOrder->getOrderSearchKeyWhere($_GET);
$arrCol = array('orders.pkOrderID', 'orders.OrderUniqueCode', 'orders.OrderFinalPrice', 'orders.OrderStatus', 'orders.OrderDateAdded', 'orders.OrderPaymentStatus');
$arrResult = $objOrder->getOrderList($_REQUEST, TABLE_ORDER, $arrCol, $varWhereCondition, $varLimit);
// GETTING ALL RECORDS WITHOUT LIMIT.
$objRecords = $objOrder->getOrderList($_REQUEST, TABLE_ORDER, $arrCol, $varWhereCondition, '');
// GETTING NUMBER OF PAGES.
if ($objRecords) {
$varNumberofRows = count($objRecords);
}
$varNumberPages = $objPaging->calculateNumberofPages($varNumberofRows, ADMIN_PAGE_RECORD_SIZE);
$_SESSION['sessOrders'] = '';
if ($_SERVER['QUERY_STRING'] != '') {
$_SESSION['sessOrders'] = basename($_SERVER['PHP_SELF']) . "?" . $_SERVER['QUERY_STRING'];
} else {
$_SESSION['sessOrders'] = basename($_SERVER['PHP_SELF']);
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
//customer session is checked whether it is valid or not
if (!$objCustomerLogin->checkCustomerSession()) {
header('location:login.php');
die;
}
// CREATING OBJECTS------------------------
$objPaging = new Paging();
$objOrder = new Order();
// GETTING PAGE RECORD LOMIT.
$varPageStart = $objPaging->getPageStartLimit($_GET['page'], SITE_RECORD_LIMIT);
$varLimit = $varPageStart . ',' . SITE_RECORD_LIMIT;
// BLANK WHERE CONDITION TO GET ALL RECORDS WITH LIMIT.
$arrCol = array('orders.pkOrderID', 'orders.OrderUniqueCode', 'customers.CustomerEmailID', 'orders.OrderFinalPrice', 'orders.OrderStatus', 'orders.OrderDateAdded', 'orders.OrderPaymentStatus');
$varTable = TABLE_CUSTOMERS . ' INNER JOIN ' . TABLE_ORDER . ' ON ' . TABLE_CUSTOMERS . '.pkCustomerID = ' . TABLE_ORDER . '.fkUserID';
$varWhere = ' AND pkCustomerID = \'' . $_SESSION['sessCustomerID'] . '\'';
$arrResult = $objOrder->getOrderList($_GET, $varTable, $arrCol, $varWhere, $varLimit);
// GETTING ALL RECORDS WITHOUT LIMIT.
$arrRecords = $objOrder->getOrderList($_GET, $varTable, $arrCol, $varWhere, '');
// GETTING NUMBER OF PAGES.
if ($arrRecords) {
$varNumberofRows = count($arrRecords);
}
$varNumberPages = $objPaging->calculateNumberofPages($varNumberofRows, SITE_RECORD_LIMIT);
$_SESSION['sessOrders'] = '';
if ($_SERVER['QUERY_STRING'] != '') {
$_SESSION['sessOrders'] = basename($_SERVER['PHP_SELF']) . "?" . $_SERVER['QUERY_STRING'];
} else {
$_SESSION['sessOrders'] = basename($_SERVER['PHP_SELF']);
}
?>
<?php
require_once '../common/config/config.inc.php';
require_once SOURCE_ROOT . 'classes/class.sort.php';
require_once SOURCE_ROOT . 'classes/class.paging.php';
require_once SOURCE_ROOT . 'classes/class.order.php';
$objOrder = new Order();
$objPaging = new Paging();
$fileName = "reports/order_report.xls";
if (isset($_REQUEST['frmSearchPressed']) && $_REQUEST['frmSearchPressed'] == 'Yes') {
$varSearchWhere = $objOrderr->getOrderSearchKeyWhere($_GET);
}
$arrOrderFlds = array('orders.pkOrderID', 'orders.OrderUniqueCode', 'orders.OrderFinalPrice', 'orders.OrderStatus', 'orders.OrderDateAdded', 'orders.OrderPaymentStatus');
$arrOrderList = $objOrder->getOrderList('', TABLE_ORDER, $arrOrderFlds, $varSearchWhere, '');
$sep = "\t";
$arr_headers = array('OrderID', 'Amount', 'Payment Status', 'Order Status', 'Added Date');
foreach ($arr_headers as $header) {
$str .= $header . $sep;
}
$str .= "\r\n";
if (is_array($arrOrderList)) {
foreach ($arrOrderList as $varKey => $varValue) {
$str .= $varValue['OrderUniqueCode'] . $sep;
$str .= $objCore->setPriceFormat($varValue['OrderFinalPrice']) . $sep;
$str .= $varValue['OrderPaymentStatus'] . $sep;
$str .= $varValue['OrderStatus'] . $sep;
$str .= $objCore->datetime_format($varValue['OrderDateAdded']) . $sep;
$str .= "\r\n";
}
$fp = fopen($fileName, "w");
fwrite($fp, $str);
<?php
//error_reporting(E_ALL);
require 'class.db.php';
require 'class.order.php';
error_reporting(0);
// константы для подключени к БД
define('HOST', 'localhost');
//сервер
define('USER', 'admin');
//пользователь
define('PASSWORD', '1234');
//пароль
define('NAME_BD', 'db_example');
//база
DB::getInstance();
// инициализация экземпляра класса дл работы с БД
//свободное использование класса
//вывод таблицы продуктов
$result = DB::query("SELECT products_id,title FROM `product`");
echo '<h2>Products:</h2> <table border="1">';
while ($obj = DB::fetch_object($result)) {
echo '<tr><td>' . $obj->id . '</td><td>' . $obj->title . '</td><tr>';
}
echo '</table>';
$order = new Order();
echo $order->getOrderList();
//попробуем создать новый экземпляр DB
echo "<span style='color:red'>";
