public function orders() { $data = array(); $seo['seo_title'] = 'Управления заказами'; Funcs::setMeta($seo); if (Funcs::$uri[2] == '') { $data['list'] = Manager::getManagerOrders(); View::render('manager/orders', $data); } else { $data = Orders::getOne(Funcs::$uri[2]); $data['avatar'] = User::getAvatar($data['iuser']); View::render('manager/order', $data); } }
public static function getManagerOrders() { $data = array(); $status = ''; if ($_GET['status'] && $_GET['status'] != 'all') { $status = ' WHERE status=\'' . $_GET['status'] . '\' '; } $sql = ' SELECT id, cdate FROM {{orders}} ' . $status . ' ORDER BY cdate DESC '; $list = DB::getPagi($sql); foreach ($list as $item) { $data[] = Orders::getOne($item['id']); } return $data; }
function save() { $ids = isset($_REQUEST['ids']) ? $_REQUEST['ids'] : array(); $order_code = isset($_REQUEST['order_code']) ? $_REQUEST['order_code'] : ''; $user_code = isset($_SESSION['user_code']) ? $_SESSION['user_code'] : ''; $bh_order_code = str_replace('SK', 'BH', $order_code); $order_bh = Orders::getOne(array('order_code' => $bh_order_code)); if ($order_bh) { $time = $order_bh['create_time']; $time = date('Y-m-d H:i:s', $time); Templates::Assign('errormsg', "订单已在 {$time} 补过一次货,不能再补货了。"); Templates::Display('error.html'); exit; } $orders = Orders::getOne(array('order_code' => $order_code, 'order_status' => 5), 'id, order_status'); $order_status = isset($orders['order_status']) ? (int) $orders['order_status'] : 0; if (!$orders) { Templates::Assign('errormsg', "订单未找到,请核对该订单能补货 ,订单号: {$order_code}, order_status : {$order_status}"); Templates::Display('error.html'); exit; } DB::Debug(); DB::tranBegin('replen'); //事务开始 Orders::createBHOrder($order_code); //生成补货订单 foreach ($ids as $id) { $replen = OrdersBH::getData($id); $qt = $replen['num']; $sku = $replen['sku']; $status = ProductsStock::outStockInsertOrderProduct($bh_order_code, $sku, $qt); if (!$status) { DB::rollBack(); Templates::Assign('errormsg', "补货保存失败,[{$sku}] 库存不足,错误代码 BH001"); Templates::Display('error.html'); exit; } OrdersBH::update($id, array('status' => 1)); } $commit_status = DB::tranEnd('replen'); header("Location: /order/?order_code={$order_code}"); }
function orders() { if (Funcs::$uri[2] == '') { $data['seo_title'] = $data['name'] = 'Мои заказы'; Funcs::setMeta($data); $data['list'] = Cabinet::getOrdersList(); View::render('cabinet/orders', $data); } else { $data = Orders::getOne(Funcs::$uri[2]); $data['seo_title'] = $data['name'] = 'Закакз №' . str_repeat('0', 6 - strlen($data['id'])) . $data['id']; View::render('cabinet/ordersOne', $data); } }
/** * 功能号:12070 * 客户认证 * */ public function certification() { COMFilter::$_jump = false; $code = trim(Core::$_dataFilter->valueCheck(Core::get("code"), "Require,Limit", "认证码不能为空,最多6个字符", false, 6)); $clientmac = $_COOKIE['CLIENTMAC']; // print $clientmac; $clientboxid = intval($_COOKIE['CLIENTBOXID']); $clientphone = $_COOKIE['CLIENTPHONE']; $user = new Users(); $addate = COMCommon::sysTime(); $one = $user->getOne('user_name=?', $clientphone); if ($one) { $id = $one->id; } else { $msg = '用户不存在'; Core::json_error($msg); } $token = new Users_token(); //$host = 'http://115.28.92.216'; $host = $this->_host; $network = Core::check_network($host); if ($network) { $param = array("m" => 12070, "phone" => $clientphone, "code" => $code); $onecert = $token->getOne("id = ? and end_time - UNIX_TIMESTAMP() > 0", $id); if (empty($onecert)) { $param['pal'] = 1; } else { if ($onecert->status > 0 && $onecert->authcode != $code) { $onecert->errnum = $onecert->errnum + 1; $onecert->save(); $msg = '认证码不正确'; Core::json_error($msg); } } $param['at'] = $_SERVER['REQUEST_TIME']; $sign = Core::get_signature($param); $param["sign"] = $sign; $url = "http://{$host}/tvmv/?m=12070"; $temp = Core::request_url($url, $param, 1); $return = json_decode($temp); if ($return->status === 1) { $data = $return->data; if ($data->token) { if (!$data->status) { $order = new Orders(); $one = $order->getOne("order_sn=?", $data->ordersn, "pay_time desc"); if ($one) { $one->status = 1; $one->pay_time = date("Y-m-d H:i:s", $data->start_time); $flag = $one->save(); if ($flag) { $one = $token->getOne("id = ?", $id); if ($one) { $flag = $token->edit(1, $data->ordersn, $data->token, $data->start_time, $data->end_time, 1, $data->code, $id); } else { $flag = $token->add($id, 1, $data->ordersn, $data->token, $data->start_time, $data->end_time, 1, $data->code); } if ($flag) { $this->notify_server($one, $data->token); } } } } $onecert->errnum = 0; $onecert->save(); setcookie("CLIENTTOKEN", $data->token); Core::json_result('', '已认证'); } } else { $msg = $return->msg; Core::json_error($msg); } } else { $flag = $token->del("id = {$id} and end_time - UNIX_TIMESTAMP() < 0"); $one = $token->getOne("id = ? and end_time - UNIX_TIMESTAMP() > 0", $id); if ($one) { if ($one->status > 0) { if ($one->authcode != $code) { $one->errnum = $one->errnum + 1; $one->save(); $msg = '认证码不正确'; Core::json_error($msg); } else { $one->errnum = 0; $one->save(); setcookie("CLIENTTOKEN", $data->token); Core::json_result('', '已认证'); } } else { $msg = '网络没有联接,如果没有支付,请支付相关费用!'; Core::json_error($msg); } } else { $msg = "网络没有联接,如果您没有购买服务,请先购买观影服务!"; Core::json_error($msg); } } }
public function getOrdersList() { $data = array(); $status = ''; if ($_GET['status'] && $_GET['status'] != 'all') { $status = ' AND status=\'' . $_GET['status'] . '\' '; } $sql = ' SELECT id FROM {{orders}} WHERE iuser='******'iuser']['id'] . ' ' . $status . ' ORDER BY cdate DESC '; $list = DB::getPagi($sql); foreach ($list as $item) { $data[] = Orders::getOne($item['id']); } return $data; }
public static function cancelOrder($order_code, $user) { $order_type = substr($order_code, -2, 2); if ('SK' != $order_type) { return false; } $order = Orders::getOne(array('order_code' => $order_code), 'id, order_status'); if (1 != $order['order_status']) { return false; } $oid = $order['id']; //DB::Debug(); $stocks = ProductsStockLock::getList("order_code='{$order_code}' AND status=0"); ABase::log("Stocks in cancelOrder: " . serialize($stocks), 'cancel_order_'); DB::tranBegin('Orders.cancelOrder'); //事务开始 OrdersLog::insert(array('order_code' => $order_code, 'ex_status' => '取消订单', 'admin' => $user, 'action' => '订单取消', 'ip' => Func::getIP(), 'create_time' => time())); foreach ($stocks as $stock) { $sid = $stock['id']; $product_sku = $stock['product_sku']; $product_num = $stock['product_num']; $exp_date = $stock['exp_date']; ProductsStock::increase("product_sku='{$product_sku}' AND exp_date='{$exp_date}'", "stock", $product_num); ProductsStockLock::update($sid, array('status' => 2)); } Orders::update($oid, array('order_status' => 7)); $commit_status = DB::tranEnd('Orders.cancelOrder'); }
DB::tranStop(); } $commit_status = DB::tranEnd('pay'); //--- end tran if (!$order_id || !$commit_status) { Templates::Assign('errormsg', "订单保存失败,[{$product_sku}] 库存不足,错误代码 PAY002"); Templates::Display('error.html'); exit; } } else { $yk = isset($_GET['yk']) ? (int) $_GET['yk'] : 0; $user_code = isset($_SESSION['user_code']) ? $_SESSION['user_code'] : ''; if (!$yk) { $orders = Orders::getOne(array('order_code' => $order_code, 'order_status' => 1), 'id'); } else { $orders = Orders::getOne(array('order_code' => $order_code, 'user_code' => $user_code, 'order_status' => array('<' => 5)), 'id,order_status'); $order_status = isset($orders['order_status']) ? (int) $orders['order_status'] : 0; if ($order_status <= 1) { $orders = null; } else { $orders = Orders::createYKOrder($order_code); $order_code = isset($orders['order_code']) ? $orders['order_code'] : ''; if (!$order_code) { Templates::Assign('errormsg', "余款订单生成失败, 请核对后再试"); Templates::Display('error.html'); exit; } } } if (!$orders) { Templates::Assign('errormsg', "未获取到相应的订单,或订单已支付,或订单已过期, 请核对后再试");
if ($order_status > 2) { $shiped = OrdersLog::getOne(array('order_code' => $order_code, 'action' => '已发货'), 'create_time'); $shiped_time = isset($shiped['create_time']) ? (int) $shiped['create_time'] : 0; } $orders['shiped_time'] = $shiped_time; $YK_orders = array(); $yk_order_code = str_replace('SK', 'YK', $order_code); $YK_orders = Orders::getOne(array('order_code' => $yk_order_code)); if ($YK_orders) { $yk_paymethodid = $YK_orders['pay_method']; $YK_orders['yk_pay_method'] = PaymentMethod::getData($yk_paymethodid); } $BH_orders = array(); $BH_products = array(); $bh_order_code = str_replace('SK', 'BH', $order_code); $BH_orders = Orders::getOne(array('order_code' => $bh_order_code)); if ($BH_orders) { $BH_products = Orders::getOrderPrducts($bh_order_code); } $receiver_address_id = (int) $orders['receiver_address_id']; $address = ReceiverAddress::getInfo($receiver_address_id); $paymethodid = $orders['pay_method']; $paymethod = PaymentMethod::getData($paymethodid); $userlevel = Users::getLevel($userid); $discount = $userlevel['discount']; $products = Orders::getOrderPrducts($order_code); //获取order status 名称 $statusname = OrdersStatus::getData($order_status); $orders['order_statusname'] = $statusname['name']; //var_dump($orders); Templates::Assign('order_code', $order_code);