function verifyPayment_paypalstandard()
{
$orderid = Request::get('custom', 0);
$status = Request::get('payment_status', 'cancel');
$status = strtolower($status);
$updateData = array('order_status' => 'cancel');
if ($status == 'completed') {
$updateData['order_status'] = 'completed';
}
Orders::update($orderid, $updateData);
}
function verifyPayment_moneybookers()
{
$status = Request::get('status', 2);
if ((int) $status == 2) {
$text = Request::get('detail1_text', '');
if (!isset($text[1])) {
return false;
}
preg_match('/(\\d+)/', $text, $match);
Orders::update($match[1], array('order_status' => 'cancel'));
}
}
function verifyPayment_payza()
{
$loadData = Paymentmethods::loadSetting('payza');
$ap_securitycode = Request::get('ap_securitycode', '');
if (!isset($ap_securitycode[1])) {
return false;
}
if ($ap_securitycode != $loadData['secret']) {
$orderid = Request::get('ap_itemcode', '0');
Orders::update($orderid, array('order_status' => 'cancel'));
}
}
$oxid['db'] = new ezSQL_mysql($oxid['db_user'], $oxid['db_password'], $oxid['db_name'], $oxid['db_host']);
$selectline['db'] = new ezSQL_sqlsrv($selectline['db_user'], $selectline['db_password'], $selectline['db_name'], $selectline['db_host']);
//$selectline['db']->get_row("SELECT * FROM ".$selectline['table_orders']."");
if ($action == 'product-import') {
if (!oxid_userlogin()) {
echo json_encode(array('msg' => '<p class="alert alert-danger">SelectConnect konnte sich nicht bei Oxid einloggen!</p>'));
exit;
}
$step = isset($_GET['step']) ? $_GET['step'] : 0;
$products = new Products();
echo json_encode(array('msg' => $products->import($step)));
exit;
}
if ($action == 'cron' || $argv[1] == 'cron') {
$orders = new Orders();
$orders->update();
exit;
}
?>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml" lang="de">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>SelectConnect | made by WortBildTon.de</title>
<link href='http://fonts.googleapis.com/css?family=Roboto+Condensed:400,300,700' rel='stylesheet' type='text/css'>
<link href='bootstrap/css/bootstrap.min.css' rel='stylesheet' type='text/css'>
<link href='bootstrap/css/bootstrap-select.min.css' rel='stylesheet' type='text/css'>
<link href='css/style.css' rel='stylesheet' type='text/css'>
function orderNotify()
{
$orders = Orders::publicPayOrderSignVerify();
$order_code = isset($orders['order_code']) ? $orders['order_code'] : '';
$order_id = isset($orders['id']) ? (int) $orders['id'] : 0;
$order_status = isset($orders['order_status']) ? (int) $orders['order_status'] : 0;
$pay_transaction_id = isset($orders['pay_transaction_id']) ? $orders['pay_transaction_id'] : '';
$paid = isset($orders['paid']) ? $orders['paid'] : 0;
$paymethod_code = $orders['paymethod_code'];
if (1 == $order_status) {
$pay_method = PaymentMethod::getOne(array('code' => $paymethod_code), 'id');
$pay_method = isset($pay_method['id']) ? (int) $pay_method['id'] : 0;
$sk_order_code = null;
$order_type = substr($order_code, -2, 2);
if ('YK' == $order_type) {
$sk_order_code = str_replace('YK', 'SK', $order_code);
}
DB::tranBegin('notify');
//事务开始
Orders::update(array('order_code' => $order_code), array('paid' => $paid, 'order_status' => 2, 'pay_method' => $pay_method, 'pay_transaction_id' => $pay_transaction_id, 'pay_time' => time()));
if ($sk_order_code) {
Orders::update(array('order_code' => $sk_order_code), array('order_status' => 5));
}
ProductsStockLock::changeStatus($order_code, 1);
OrdersProducts::updateOrderProductStock($order_code);
$commit_status = DB::tranEnd('notify');
if (!$commit_status) {
ABase::toJson(1, 'FAIL', $orders);
}
}
ABase::toJson(0, 'SUCCESS', $orders);
}
//先把状态改成 订单取消，回滚完库存把状态改成7:订单关闭
ABase::log("Order ids in 1 hour : " . serialize($ids), 'cron_');
$time = time() - 10800;
//3小时前的订单库存回收,考虑订单生成后还差一分钟订单失效时用户点击付款，并在付款操作时又等待了2小时
$orders = Orders::getList("create_time<{$time} AND order_status=6", 'id,order_code');
//首先在1个小时内使订单失效
foreach ($orders as $k => $order) {
$oid = $order['id'];
$order_code = $order['order_code'];
$order_type = substr($order_code, -2, 2);
if ('SK' != $order_type) {
unset($orders[$k]);
continue;
}
//DB::Debug();
$stocks = ProductsStockLock::getList("order_code='{$order_code}' AND status=0");
ABase::log("Stocks in 3 hour order: " . serialize($stocks), 'cron_');
DB::tranBegin('stock_recycle');
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('stock_recycle');
}
ABase::log("Orders in 3 hour : " . serialize($orders), 'cron_');
//---------- END 过期未支付订单库存回收
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');
}
/**
* Updates the status of an order and redirects back to the order history
* page.
*
* @param int $id id of the edited order
*/
public static function edit($id)
{
$params = $_POST;
$attributes = array('id' => $id, 'status' => $params['status']);
if ($attributes['status'] == 'Toimitettu') {
$attributes['actual_delivery_time'] = date('d-m-Y H:i:s');
}
$order = new Orders($attributes);
$order->update();
Redirect::to('/tilaushistoria', array('message' => 'Tilaustietoja muokattu!'));
}
