<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Answer extends Model
{
    protected $table = 'answer_base';
    protected $primaryKey = 'id';

    const CREATED_AT = 'creation_date';

    public static function getList(array $problems)
    {
        $query = self::query()
            ->leftJoin('user_info as u','answer_base.user_id','=','u.id')
            ->where(['answer_base.status'=>0])
            ->whereIn('answer_base.problem_id',$problems)
            ->get();
        if ($query){
            return $query->toArray();
        }else{
            return [];
        }
    }

    public static function insertData(array $data)
    {
        return self::query()->insert($data);
    }

    public static function del(int $id)
    {
        return self::query()->where('id', $id)->delete();
    }
}