PHP orders类代码示例

 public static function getInstance() {
     if (!self::$me) {
         $class=new orders();
         self::$me=$class;
     }
     return self::$me;
 }

 public function actionStop()
 {
     $orderNow = orders::find()->where(['active' => 1])->one();
     $timeOld = $orderNow->time_total;
     $timeBegin = new DateTime($orderNow->time_begin);
     $timeEnd = new DateTime(date("Y-m-d H:i:s"));
     $orderNow->active = 0;
     $timeWork = $timeBegin->diff($timeEnd);
     $MinutesWork = $timeWork->i + $timeWork->h * 60 + $timeWork->d * 60 * 24 + $timeOld;
     $orderNow->time_total = $MinutesWork;
     $orderNow->save();
     Yii::$app->response->redirect(array('site/index'));
 }

    function respond() {
        require_once ("tenpay/PayResponseHandler.class.php");
        $resHandler = new PayResponseHandler();
        $sp_billno = $resHandler->getParameter("sp_billno");
        if(preg_match('/(select|union|and|\'|"|\))/i',$sp_billno)){
        	exit('非法参数');
        }
        preg_match_all("/-(.*)-(.*)-(.*)/isu",$sp_billno,$oidout);
        $paytype = $where['pay_code'] = $oidout[3][0];
        include_once ROOT.'/lib/plugins/pay/'.$paytype.'.php';
        $pay = pay::getInstance()->getrows($where);
        $payconfig = unserialize($pay[0]['pay_config']);
        $resHandler->setKey($payconfig[1]['value']);
        
        $where = array();
        $where['oid']=$sp_billno;
        $orders=orders::getInstance()->getrow($where);

        if($resHandler->isTenpaySign()) {
            $transaction_id = $resHandler->getParameter("transaction_id");
            $total_fee = $resHandler->getParameter("total_fee");
            $pay_result = $resHandler->getParameter("pay_result");
            if("0" == $pay_result) {
                if (!pay::check_money($orders['id'],$total_fee/100)) {
                    echo "<br/>" . "金额不符" . "<br/>";
                    return false;
                }
                pay::changeorders($orders['id'],$_GET);
                $show = config::get('site_url');
                $resHandler->doShow($show);
            } else {
                echo "<br/>" . "支付失败" . "<br/>";
                 return false;
            }
        } else {
            echo "<br/>" . "认证签名失败" . "<br/>";
             return false;
        }
    }

 /**
  * Send a custom e-mail to the user
  * @developer Brandon Hansen
  * @date Oct 23, 2010
  */
 public function send_custom(Order_Model $order)
 {
     orders::history_entry($order, 'Sent Email to Customer');
 }

/**
 * Get vip status of customer from an order
 * @param String $type
 * @param Int $orders_id
 * @return Boolean
 */
function checkCustomerIsVIP($type, $orders_id)
{
    $type = strtoupper($type);
    $is_vip = false;
    if ($type == 'SP') {
        use_class('jng_sp_orders');
        use_class('jng_sp_customers');
        use_class('jng_sp_customers_special');
        $class_jo = new jng_sp_orders();
        $class_jc = new jng_sp_customers();
        $class_jcs = new jng_sp_customers_special();
        $o = $class_jo->retrieveDetail($orders_id);
        //GET CUSTOMER DETAIL VIP OR NOT
        $cust_data = $class_jc->retrieveDetail(null, $o['jng_sp_id'], $o['customer_billing_id']);
        if (is_array($cust_data) && $cust_data['jng_sp_customers_id'] > 0) {
            $cust_detail = $class_jcs->getCustomerDetail($cust_data['jng_sp_customers_id']);
        }
        $is_vip = $cust_detail['list_type'] == 'V';
    } elseif ($type == 'JG') {
        use_class('orders');
        use_class('customers_special_list');
        $class_o = new orders();
        $class_csl = new customers_special_list();
        $o = $class_o->retrieveDetail($orders_id);
        //GET CUSTOMER DETAIL VIP OR NOT
        $cust_detail = $class_csl->getCustomerDetail($o['customers_id']);
        $is_vip = $cust_detail['list_type'] == 'V';
    } elseif ($type == 'DP') {
        use_class('depot_orders');
        $class_do = new depot_orders();
        $do = $class_do->retrieveDetail($orders_id);
        if ($do['trans_type'] == 'SP' || $do['trans_type'] == 'JG') {
            if ($do['trans_type'] == 'SP') {
                use_class('jng_sp_orders');
                $class_jo = new jng_sp_orders();
                $it = $class_jo->retrieveItemDetail($do['trans_id']);
                $orders_id = $it['jng_sp_orders_id'];
            } elseif ($do['trans_type'] == 'JG') {
                use_class('orders');
                $class_o = new orders();
                $it = $class_o->retrieveProductDetail($do['trans_id']);
                $orders_id = $it['orders_id'];
            }
            $is_vip = checkCustomerIsVIP($do['trans_type'], $orders_id);
        }
    }
    return $is_vip;
}

    }
}
$item['description'] = replaceEmoticons($item['description']);
$item["theme_preview"] = DATA_SERVER . "/uploads/items/" . $item["id"] . "/" . $item["theme_preview"];
abr('item', $item);
#BUY ITEM
//购买作品
if (isset($_SESSION['tmp']['order_id']) && $_SESSION['tmp']['order_id']) {
    $_SESSION['tmp']['order_id'] = 0;
}
if (isset($_POST['licence'])) {
    if (!check_login_bool()) {
        $_SESSION['temp']['golink'] = '/' . $languageURL . 'items/' . $itemID;
        refresh('/' . $languageURL . 'sign_in/');
    }
    $ordersClass = new orders();
    if ($_POST['licence'] == 'regular') {
        //余额购买作品
        if (isset($_POST['pay_method']) && $_POST['pay_method'] == 'paymethod') {
            $orderID = $ordersClass->add($item['price']);
            if (isset($_SESSION['tmp']['deposit_id'])) {
                unset($_SESSION['tmp']['deposit_id']);
            }
            $_SESSION['tmp']['order_id'] = $orderID;
            refresh('/' . $languageURL . 'items/payment/');
        } else {
            //判断余额
            if ($_SESSION['user']['total'] < $item['prepaid_price']) {
                addErrorMessage($langArray['error_not_enought_money'], '', 'error');
            } else {
                $total_money = floatval($item['prepaid_price']) + floatval($item['your_profit']);

    $anketa = new users();
    $anketa->get_user_info($_SESSION['user_uniq']);
    //echo $anketa->name."<br>";
    //echo $anketa->famil."<br>";
    //echo $anketa->otch."<br>";
    //echo $anketa->email."<br>";
    $recent_order = $_GET['recent_order'];
    if ($recent_order == '1') {
        echo '<div class="alert alert-info">
<button type="button" class="close" data-dismiss="alert">&times;</button>
<strong>Уважаемая(ый) ' . $anketa->name . '!</strong><br> Ваш заказ принят и в самом скором времени будет обработан. Вы можете следить за исполнением заказа из своего личного кабинета.
</div>
';
    }
    //Проверка на наличие наобработанных заказов
    $unprocessed_orders = new orders();
    $unprocessed_orders->get_unprocessed_orders();
    if ($unprocessed_orders->num_rows > 0) {
        echo "<p>Кажется у нас есть необработанные заказы! И их целых<span class=\"badge badge-important\">{$unprocessed_orders->num_rows}</span>шт.! <a href='unprocessed_orders.php'>Просмотреть</a></p>";
    } else {
        echo "<p><a href='unprocessed_orders.php'>Лист заказов </a></p>";
    }
    ?>
 
    
    
    
<br>
<?php 
    //   $tyty = new orders();
    //   $tyty->get_order($_SESSION['user_uniq']);

<?php

session_start();
$page_title = "Tambah Order";
include_once $_SERVER['DOCUMENT_ROOT'] . '/pages/header.php';
include_once $_SERVER['DOCUMENT_ROOT'] . '/config/database.php';
include_once $_SERVER['DOCUMENT_ROOT'] . '/objects/orders.php';
include_once $_SERVER['DOCUMENT_ROOT'] . '/objects/orderdetail.php';
echo "\t\t\t\t<div class='col-md-3'>";
include_once $_SERVER['DOCUMENT_ROOT'] . '/pages/sidebarmenu.php';
echo "\t\t\t\t</div>";
$database = new database();
$db = $database->getConnection();
$orders = new orders($db);
$orderdetail = new orderdetail($db);
$orders->order_id = $orders->AutoNumber();
include_once $_SERVER['DOCUMENT_ROOT'] . '/objects/customer.php';
$custoer = new customer($db);
$customer = new customer($db);
$orders->cust_kode = "";
$statement = $orderdetail->ShowTemp($orders->order_id);
$bayar = isset($bayar) ? $bayar : 0;
$kembali = isset($kembali) ? $kembali : 0;
echo "\t\t\t\t<div class='col-md-9'>";
//echo "<div class='container'>";
echo "<div class='panel panel-default'>";
echo "<div class='panel-body'>";
echo "\t\t\t<div class='row' style='border-bottom: none;'>";
echo "\t\t\t\t<div class='col-md-2'>";
echo "\t\t\t\t\t<label>Order No</label>";
echo "\t\t\t\t</div>";

        $sp_prefix[$sp['jng_sp_id']] = $sp['package_prefix'];
    }
    use_class("jng_sp_packages");
    $class_jp = new jng_sp_packages();
    use_class("jng_sp_orders");
    $class_jo = new jng_sp_orders();
    $package_id = tep_db_prepare_input($_GET['id']);
    $orders_array = $class_jp->getOrders($package_id);
    $items_array = $class_jp->getItems($package_id);
} elseif (isset($_GET['pid']) && $_GET['pid'] != '') {
    $type = 'jng';
    //JNG PACKAGES
    use_class("minierp_packages");
    $class_mp = new minierp_packages();
    use_class("orders");
    $class_o = new orders();
    $package_id = tep_db_prepare_input($_GET['pid']);
    $orders_array = $class_mp->getOrders($package_id);
    $items_array = $class_mp->getProducts($package_id);
} else {
    exit;
}
class PDF extends FPDF
{
    var $left_margin;
    var $page_width;
    var $label_width;
    var $label_height;
    var $label_per_width;
    var $label_per_height;
    //Page header

<?php

ob_start();
session_start();
function __autoload($name)
{
    include_once "files/" . $name . ".php";
}
$orders = new orders();
$rooms = new rooms();
$products = new products();
$validate = new validation();
if (isset($_SESSION['cafeteriaSystem'])) {
    ?>
<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
    <title>Cafeteria System | Home Page</title>
	<link href="css/bootstrap.min.css" rel="stylesheet">
    <link href="css/css.css" rel="stylesheet">
    
    
	
    <style>
		body{
			margin-top:10px ;	
		}

<?php 
session_start();
ini_set('max_execution_time', 0);
require_once "../files/dbConnect.php";
require_once "../files/orders.php";
$orders = new orders();
$db = dbConnect::getInstance();
$mysqli = $db->getConnection();
$query = " select * from check_tb  where  u_id = '" . $_SESSION['cafeteriaSystem'] . "' ";
$res = $mysqli->query($query) or die(mysqli_error($mysqli));
$row = mysqli_num_rows($res);
//$file_name = 'document.txt';
$client_amount = isset($_GET['lastModified']) ? $_GET['lastModified'] : 0;
//$client_deliver = isset($_GET['LastModifiedDelivered'])?$_GET['LastModifiedDelivered']:0;
//$client_process = isset($_GET['LastModifiedProcessing'])?$_GET['LastModifiedProcessing']:0;
/* Get Deliver number 
$queryDeliver = " select * from check_tb  where  u_id = '".$_SESSION['cafeteriaSystem']."' and status='2' ";  
$resDeliver = $mysqli->query($queryDeliver) or die (mysqli_error($mysqli));

$serverDeliver=mysqli_num_rows($resDeliver);


/* Get Process number 
$queryProcess = " select * from check_tb  where  u_id = '".$_SESSION['cafeteriaSystem']."' and status='3' ";  
$resProcess = $mysqli->query($queryProcess) or die (mysqli_error($mysqli));

$serverProcess=mysqli_num_rows($resProcess);


$client_process = $serverProcess;

// | Demila [ Beautiful Digital Content Trading System ]
// +----------------------------------------------------------------------
// | Copyright (c) 2015 http://demila.org All rights reserved.
// +----------------------------------------------------------------------
// | Licensed ( http://www.apache.org/licenses/LICENSE-2.0 )
// +----------------------------------------------------------------------
// | Email author@demila.org
// +----------------------------------------------------------------------
_setView(__FILE__);
_setTitle($langArray['downloads_setTitle']);
if (!check_login_bool()) {
    $_SESSION['temp']['golink'] = '/' . $languageURL . 'download/';
    refresh('/' . $languageURL . 'sign_in/');
}
require_once ROOT_PATH . '/apps/items/models/orders.class.php';
$ordersClass = new orders();
#下载作品
$itemID = get_id(2);
if (is_numeric($itemID)) {
    require_once ROOT_PATH . '/apps/items/models/items.class.php';
    $itemsClass = new items();
    $item = $itemsClass->get($itemID);
    if (!is_array($item) || check_login_bool() && $item['status'] == 'unapproved' && $item['user_id'] != $_SESSION['user']['user_id'] || $item['status'] == 'queue') {
        header("HTTP/1.0 404 Not Found");
        header("Location: http://" . DOMAIN . "/" . $languageURL . "error");
    }
    if (isset($_POST['rating'])) {
        $_GET['rating'] = $_POST['rating'];
    }
    if (isset($_GET['rating'])) {
        if (!isset($_GET['rating']) || !is_numeric($_GET['rating']) || $_GET['rating'] > 5) {

#  Author  : D3W4 & SAHAT                                       #
#  Created : Jul 2, 2010 5:34:28 PM                             #
#  Purpose : send email reminder to customer to pay the order   #
#################################################################
global $db;
require_once '../confy.php';
require_once '../functions.php';
require_once '../functions-2.php';
tep_db_connect();
use_class('logger');
$logger = new logger('cron', 'email-vorkasse-reminder');
use_class('Order');
use_class('orders');
use_class('jng_sp_orders');
use_class('payone_invoice');
$class_o = new orders();
$class_jo = new jng_sp_orders();
$sp_need_reminder = array('2');
$tolerance_before_really_cancelling_orders = '7 days';
$languages[2]['path'] = 'german';
function sendUnderpaidReminder($order, $open_amount, $language)
{
    global $class_o, $class_jo;
    $status = '1';
    $order_id = $order['orders_id'];
    $order_no = $order['orders_no'];
    $to_name = $order['customers_name'];
    $to_email_address = $order['customers_email_address'];
    $order_currency = $order['currency'];
    $from_email_name = FROM_EMAIL_NAME;
    $from_email_address = FROM_EMAIL_ADDRESS;

 public static function changeorders($id,$orderlog) {
     $where=array();
     $where['id']=$id;
     $where['status']=4;
     $where['orderlog']=serialize($orderlog);
     $update=orders::getInstance()->rec_update($where,$id);
     if($update<1) {
         exit('改变订单状态出错，请联系管理员');
     }
 }

// | Demila [ Beautiful Digital Content Trading System ]
// +----------------------------------------------------------------------
// | Copyright (c) 2015 http://demila.org All rights reserved.
// +----------------------------------------------------------------------
// | Licensed ( http://www.apache.org/licenses/LICENSE-2.0 )
// +----------------------------------------------------------------------
// | Email author@demila.org
// +----------------------------------------------------------------------
_setView(__FILE__);
_setTitle($langArray['earnings_setTitle']);
if (!check_login_bool()) {
    $_SESSION['temp']['golink'] = '/' . $languageURL . 'earnings/';
    refresh('/' . $languageURL . 'sign_in/');
}
require_once ROOT_PATH . '/apps/items/models/orders.class.php';
$ordersClass = new orders();
if (isset($_POST['ajax'])) {
    $month = get_id(2);
    $year = get_id(3);
    $text = '';
    $sales = $ordersClass->getAll(" `paid_datetime` > '" . date('Y-m-d 23:59:59', mktime(0, 0, 0, $month - 1, date('t', mktime(0, 0, 0, $month - 1, 1, $year)), $year)) . "' AND `paid_datetime` < '" . date('Y-m-d 00:00:00', mktime(0, 0, 0, $month + 1, 1, $year)) . "' AND `paid` = 'true' AND `type` = 'buy' AND `owner_id` = '" . intval($_SESSION['user']['user_id']) . "' ", "`paid_datetime` ASC");
    if (is_array($sales)) {
        $buff = array();
        foreach ($sales as $s) {
            $day = explode(' ', $s['paid_datetime']);
            $day = explode('-', $day[0]);
            if (!isset($buff[$day[2]])) {
                $buff[$day[2]]['sale'] = 1;
                $buff[$day[2]]['earning'] = $s['receive'];
            } else {
                $buff[$day[2]]['sale']++;