twong329/app/models/user/UserCoin.php

<?php

namespace app\models\user;

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

class UserCoin extends BaseModel
{

    use ModelTrait;

    public static function upsertAddr($uid, $symbol, $addr)
    {
        $cond = ['uid' => $uid, 'symbol' => $symbol];
        $row = self::where($cond)->find();
        if ($row) {
            return self::where($cond)->update(['addr' => $addr]);
        } else {
            return self::create([
                'uid' => $uid,
                'symbol' => $symbol,
                'addr' => $addr,
            ]);
        }
    }

    public static function upsertCoin($uid, $symbol, $amount)
    {
        $cond = ['uid' => $uid, 'symbol' => $symbol];
        $row = self::where($cond)->find();
        if ($row) {
            return self::where($cond)->inc('balance', $amount)->update();
        } else {
            return self::create([
                'uid' => $uid,
                'symbol' => $symbol,
                'balance' => $amount,
            ]);
        }
    }

    public static function getUserCoin($uid, $page, $limit)
    {
        $rows = self::alias('c')->join('dict_coin d', 'c.symbol=d.symbol')
            ->where('c.uid', $uid)
            ->field('d.icon,c.symbol,c.balance,c.addr')
            ->order('c.symbol asc')
            ->page(intval($page), intval($limit))
            ->select();
        count($rows) && $rows = $rows->toArray();
        return $rows;
    }
}