<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class InquiryModel extends Model
{

    protected $table = 'inquiry';

    public $timestamps = false;

    const PRIORITY_HIGH = 2;

    const STATUS_PROCESSED = 1;
    const STATUS_PENDING = 0;
    const STATUS_CLOSED = -1;

    public function inquiry_items()
    {
        return $this->hasMany(InquiryItemsModel::class, 'inquiry_id', 'inquiry_id');
    }

    public static function addInquiry($inquiry)
    {
        return self::insertGetId($inquiry);
    }

    public static function getInquiryCountByStatus($userId, $status = null)
    {
        $query = self::where('user_id', $userId);
        if ($status !== null) {
            $query->where('status', $status);
        }
        return $query->count();
    }

}