52 lines
1.1 KiB
PHP
52 lines
1.1 KiB
PHP
<?php
|
|
|
|
namespace Koneko\SatCatalogs\Models;
|
|
|
|
use Illuminate\Database\Eloquent\Model;
|
|
|
|
class Municipio extends Model
|
|
{
|
|
/**
|
|
* The table associated with the model.
|
|
*
|
|
* @var string
|
|
*/
|
|
protected $table = 'sat_municipio';
|
|
|
|
|
|
/**
|
|
* The attributes that are mass assignable.
|
|
*
|
|
* @var string[]
|
|
*/
|
|
protected $fillable = [
|
|
'c_municipio',
|
|
'c_estado',
|
|
'descripcion',
|
|
'fecha_inicio_vigencia',
|
|
'fecha_fin_vigencia',
|
|
];
|
|
|
|
/**
|
|
* The attributes that should be cast.
|
|
*
|
|
* @var array
|
|
*/
|
|
protected $casts = [
|
|
'fecha_inicio_vigencia' => 'datetime',
|
|
'fecha_fin_vigencia' => 'datetime',
|
|
];
|
|
|
|
|
|
public static function selectList($c_estado, $c_municipio = false)
|
|
{
|
|
return self::select('c_municipio', 'descripcion')
|
|
->where('c_estado', $c_estado)
|
|
->when($c_municipio, function ($query) use ($c_municipio) {
|
|
$query->where('c_municipio', $c_municipio);
|
|
})
|
|
->orderBy('descripcion')
|
|
->pluck('descripcion', 'c_municipio');
|
|
}
|
|
}
|