Example: I wanna create my own function for laravel model like:
(original query)
SELECT
AVG(persons_positions.points)
FROM
positions
INNER JOIN persons_positions ON (
positions.id = persons_positions.position_id
)
WHERE positions.country = 1
AND persons_positions.person_id = 2
(model class)
class Menedzher extends Model {
function oh ($x) {
return DB::table('positions')
->join('persons_positions', 'positions.id', '=', 'persons_positions.position_id')
->where('positions.country', $x) // see here
->where('persons_positions.person_id', '=', $this->id ) // see it!!
->select(DB::raw('AVG(persons_positions.hits)'));
}
}
and to use it:
Menedzher::get(1)->oh(3)
Thanks!
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire