40 lines
918 B
PHP
40 lines
918 B
PHP
|
<?php
|
||
|
|
|
||
|
|
namespace Koneko\SatCatalogs\Models;
|
||
|
|
|
||
|
|
use Illuminate\Database\Eloquent\Model;
|
||
|
|
|
||
|
|
class Colonia extends Model
|
||
|
|
{
|
||
|
|
/**
|
||
|
|
* The table associated with the model.
|
||
|
|
*
|
||
|
|
* @var string
|
||
|
|
*/
|
||
|
|
protected $table = 'sat_colonia';
|
||
|
|
|
||
|
|
|
||
|
|
/**
|
||
|
|
* The attributes that are mass assignable.
|
||
|
|
*
|
||
|
|
* @var string[]
|
||
|
|
*/
|
||
|
|
protected $fillable = [
|
||
|
|
'c_colonia',
|
||
|
|
'c_codigo_postal',
|
||
|
|
'nombre_del_asentamiento',
|
||
|
|
];
|
||
|
|
|
||
|
|
|
||
|
|
public static function selectList($c_codigo_postal, $c_colonia = false)
|
||
|
|
{
|
||
|
|
return self::select('c_colonia', 'nombre_del_asentamiento')
|
||
|
|
->where('c_codigo_postal', $c_codigo_postal)
|
||
|
|
->when($c_colonia, function ($query) use ($c_colonia) {
|
||
|
|
$query->where('c_colonia', $c_colonia);
|
||
|
|
})
|
||
|
|
->orderBy('nombre_del_asentamiento')
|
||
|
|
->pluck('nombre_del_asentamiento', 'c_colonia');
|
||
|
|
}
|
||
|
|
}
|