twong329/app/models/store/StoreOrderCartInfo.php

<?php
/**
 *
 * @author: xaboy<365615158@qq.com>
 * @day: 2017/12/26
 */

namespace app\models\store;

use crmeb\basic\BaseModel;
use crmeb\traits\ModelTrait;

/**
 * TODO 订单记录Model
 * Class StoreOrderCartInfo
 * @package app\models\store
 */
class StoreOrderCartInfo extends BaseModel
{
    /**
     * 模型名称
     * @var string
     */
    protected $name = 'store_order_cart_info';

    use ModelTrait;

    public static function setCartInfo($oid,array $cartInfo)
    {
        $group = [];
        foreach ($cartInfo as $cart){
            $group[] = [
                'oid'=>$oid,
                'cart_id'=>$cart['id'],
                'product_id'=>$cart['productInfo']['id'],
                'cart_info'=>json_encode($cart),
                'unique'=>md5($cart['id'].''.$oid)
            ];
        }
        return self::setAll($group);
    }

    /**
     * 得到还没参加挖矿的一个订单号
     *
     * @param $uid
     * @return mixed
     */
    public static function getMiningOrderId($uid) {
        $row = self::where('so.uid', $uid)
            ->where('so.paid', 1)
            ->where('ci.mine', 0)
            ->alias('ci')->join('store_order so', 'ci.oid=so.id')->field('ci.oid')->limit(1)->value('oid');
        return $row;
    }

    /**
     * 标记为已参加挖矿
     *
     * @param $orderId
     * @return StoreOrderCartInfo
     */
    public static function setMining($orderId, $mine=1) {
        return self::where('oid', $orderId)->update(['mine'=>$mine]);
    }
}