예제 #1
0
 public static function getOneNewModel()
 {
     $model = new Wr1Order();
     $var = '@tempid' . time() . mt_rand(1, 1000);
     $sql = "UPDATE ?n\n                SET `status` = 'processing',\n                `id`=({$var}:=`id`)\n                WHERE `status` = 'new'\n                ORDER BY `id`\n                LIMIT 1";
     self::$_msql->query($sql, $model->tableName());
     $sql = "SELECT {$var} as id";
     $result = self::$_msql->getRow($sql);
     $id = $result['id'];
     if (!$id) {
         return false;
     }
     $model->with('order')->findByPk($id);
     return $model->id ? $model : false;
 }
예제 #2
0
<?php

include_once '../settings/autoload.php';
$msql = SafeMySQL::getInstance();
while ($model = Wr1Order::getOneNewModel()) {
    $payment = new PaymentAPI();
    $payment->getOrderStatus($model->order, true);
    $model->delete();
}