<?php

namespace app\common\model\plus\table;

use app\common\model\BaseModel;

/**
 * 万能表单模型
 */
class Record extends BaseModel
{
    protected $name = 'table_record';
    protected $pk = 'table_record_id';

    /**
     * 关联表单
     */
    public function tableM()
    {
        return $this->belongsTo('app\\common\\model\\plus\\table\\Table', 'table_id', 'table_id');
    }

    /**
     * 关联表单
     */
    public function user()
    {
        return $this->belongsTo('app\\common\\model\\user\\User', 'user_id', 'user_id');
    }

    /**
     * 获取详情
     */
    public static function detail($table_record_id)
    {
        return (new static())->with(['tableM'])->find($table_record_id);
    }

    /**
     * 获取用户最新表单记录id
     */
    public static function getLastRecordId($user_id, $call_index)
    {
        $res = (new static())->where('user_id', $user_id)
            ->where('call_index', $call_index)
            ->order('table_record_id', 'desc')
            ->limit(1)
            ->select()
            ->toArray();
        return $res ? $res[0]['table_record_id'] : 0;
    }
}