yanglao/application/api/model/service/SkillEnsurePay.php

<?php

namespace app\api\model\service;

use think\Model;
class SkillEnsurePay extends Model
{
    // 表名
    protected $name = 'service_skill_ensure_pay';

    // 自动写入时间戳字段
    protected $autoWriteTimestamp = 'int';

    // 定义时间戳字段名
    protected $createTime = 'createtime';
    protected $updateTime = 'updatetime';

    /**
     * 服务者充值保证金升级
     * @param $uid
     * @return true
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public static function updateSkillEnsure($uid,$price)
    {
        EnsureLog::create(['user_id'=>$uid,'money'=>+$price,'memo'=>'服务者充值保证金']);
        $skill = Skill::where(['user_id'=>$uid])->field('id,user_id,ensure_id,ensure_price,ensure_name')->find();
        $list = SkillEnsure::where(['price'=>['<=',$skill['ensure_price']]])->field('id,name,price,accept_nums')->order('price asc')->select();
        if($list)
        {
            $sumEnsurePrice = self::where(['user_id'=>$uid,'state'=>1])->sum('price');
            foreach ($list as $value)
            {
                if($sumEnsurePrice>=$value['price'])
                {
                     Skill::where(['user_id'=>$uid])->update(['ensure_id'=>$value['id'],'ensure_name'=>$value['name'],'accept_nums'=>$value['accept_nums']]);
                }
            }
        }
        return true;
    }

    public static function reduceSkillEnsure($id)
    {
        $skill = Skill::where(['id'=>$id])->field('id,user_id,ensure_id,ensure_price,ensure_name')->find();
        $skillEnsure = SkillEnsure::where(['price'=>['<=',$skill['ensure_price']]])->field('id,name,price,accept_nums')->order('price desc')->find();
        if($skill['ensure_price'] == 0 || !$skillEnsure)
        {
            Skill::where(['id'=>$id])->update(['ensure_name'=>null,'accept_nums'=>ProjectConfig::getProjectConfig('accept_nums')]);
        }else{
            Skill::where(['id'=>$id])->update(['ensure_id'=>$skillEnsure['id'],'ensure_name'=>$skillEnsure['name'],'accept_nums'=>$skillEnsure['accept_nums']]);
        }
        return true;
    }


}