<?php

namespace App;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;

class PincodeClassification extends Model
{
    use SoftDeletes;

    const TYPE_NEGATIVE = 0;
    const TYPE_POSITIVE = 1;
    const TYPE_RISKY = 2;

    protected $table = 'pincode_classifications';

    protected $fillable = [
        'pincode',
        'type',
        'state',
        'city',
        'area',
        'location',
        'comment',
        'level',
        'user_id',
        'agency_name',
    ];

    public function scopeNegative($query)
    {
        return $query->where('type', self::TYPE_NEGATIVE);
    }

    public function scopePositive($query)
    {
        return $query->where('type', self::TYPE_POSITIVE);
    }

    public function scopeRisky($query)
    {
        return $query->where('type', self::TYPE_RISKY);
    }

    public function scopePincode($query, $pincode)
    {
        return $query->where('pincode', (string) $pincode);
    }
}