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