tp锁表查询是否存在及多表处理

$result=false;
        $errmsg="领取失败。";
        Db::startTrans();
        try {
            $row=Win::lock(true)->where("user_id",$this->auth->id)->where("id",$win_id)->where("status","1")->find();
            if(!empty($row)){
                $data["money"]=$row["prizemoney"];
                $res=sendprize($this->auth->username,$row["prizemoney"]);
                $upremarks=empty($row["remarks"]) ? $res : $row["remarks"]."\r\n".$res;
                $res=json_decode($res,true);
                if($res["errcode"]==0){
                    $result=true;
                    $save=$row->save(["remarks"=>$upremarks,"status"=>"2"]);
                    if($save){
                        Prize::where("id",$row["prize_id"])->setInc('receive');
                    }
                    
                }else{
                    $row->save(["remarks"=>$upremarks]);
                }
            }else{
                $errmsg="请勿重复领取！";
            }

            Db::commit();
        } catch (\Exception $e) {
            Db::rollback();
        }
        if($result){
            $this->success();
        }else{
            $this->error($errmsg);
            
        }

快捷键：suobiaochaxun

源：

sublime_text格式

<snippet>
    <content><![CDATA[
\$result=false;
        \$errmsg="领取失败。";
        Db::startTrans();
        try {
            \$row=Win::lock(true)->where("user_id",\$this->auth->id)->where("id",\$win_id)->where("status","1")->find();
            if(!empty(\$row)){
                \$data["money"]=\$row["prizemoney"];
                \$res=sendprize(\$this->auth->username,\$row["prizemoney"]);
                \$upremarks=empty(\$row["remarks"]) ? \$res : \$row["remarks"]."\r\n".\$res;
                \$res=json_decode(\$res,true);
                if(\$res["errcode"]==0){
                    \$result=true;
                    \$save=\$row->save(["remarks"=>\$upremarks,"status"=>"2"]);
                    if(\$save){
                        Prize::where("id",\$row["prize_id"])->setInc('receive');
                    }
                    
                }else{
                    \$row->save(["remarks"=>\$upremarks]);
                }
            }else{
                \$errmsg="请勿重复领取！";
            }

            Db::commit();
        } catch (\Exception \$e) {
            Db::rollback();
        }
        if(\$result){
            \$this->success();
        }else{
            \$this->error(\$errmsg);
            
        }
]]></content>
   <tabTrigger>suobiaochaxun(tp锁表查询是否存在及多表处理)</tabTrigger>
   <scope></scope>
</snippet>