custom query function laravel

Question

I often need to perform this query:

$Op = JobCardOp::where([
        ['JobCardNum', '=', $JobCardNum ],
        ['OpNum', '=', $OpNum ]
        ])->first();

So rather than writing this out every time I want a function like:

 public function getOp($JobCardNum, $OpNum)
{
    $Op = JobCardOp::where([
        ['JobCardNum', '=', $JobCardNum ],
        ['OpNum', '=', $OpNum ]
        ])->first();
    return $Op;
}

That I can call in my controller. Where should I define my function, at the moment the I only need it in one controller but I may need it an another if thats possible. Any help appreciated.

lagbox · Accepted Answer · 2016-07-28 18:45:01Z

3

You could put this method on your Model if you wanted to as a static function.

public static function getOp($cardNum, $opNum)
{
    return static::where([
        ['JobCardNum', '=', $cardNum],
        ['OpNum', '=', $opNum]
    ])->first();
}

// controller

$res = YourModel::getOp($cardNum, $opNum);

Or add a query scope to the model

public function scopeGetOp($query, $cardNum, $opNum)
{
    return $query->where([
        ['JobCardNum', '=', $cardNum],
        ['OpNum', '=', $opNum]
    ]);
}

// controller

$res = YourModel::with(...)->getOp($cardNum, $opNum)->first();

Kinda depends how you want to use it.

edited Jul 28, 2016 at 18:45

answered Jul 28, 2016 at 18:32

lagbox

50.7k8 gold badges76 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jeremy Harris Over a year ago

Scopes are definitely the way to go. Let's you continue your query if necessary.

Phargelm · Accepted Answer · 2016-07-28 18:45:05Z

3

You may define your function in JobCardOpt model as static:

public static function getOp($JobCardNum, $OpNum)
{
    $Op = static::where([
        ['JobCardNum', '=', $JobCardNum],
        ['OpNum', '=', $OpNum]
    ])->first();
    return $Op;
}

And use it like this in your controllers:

$jobCardOpt = JobCardOpt::getOp(1, 2);

edited Jul 28, 2016 at 18:45

answered Jul 28, 2016 at 18:31

Phargelm

7185 silver badges16 bronze badges

Collectives™ on Stack Overflow

custom query function laravel

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related