Filter your records based on a users organization.

CourseOrgCriteria.php

<?php
/**
 * File Name: CourseOrgCriteria.php / lms-laravel
 * By:   Lucas Choate (twitter: @lchoate)
 * Date: 10/18/16
 * Time: 1:41 PM
 */

namespace Modules\Course\Criteria;

use Prettus\Repository\Contracts\CriteriaInterface;
use Prettus\Repository\Contracts\RepositoryInterface;

class CourseOrgCriteria implements CriteriaInterface
{
    /**
     * Apply criteria in query repository
     *
     * @param                     $model
     * @param RepositoryInterface $repository
     *
     * @return mixed
     */

    public function apply($model, RepositoryInterface $repository)
    {
	    $orgs = auth()->user()->organization_id;
	    if(auth()->user()->hasRole(['admin','api-user','district-admin','school-admin'])){
		    return $model;
	    } elseif(auth()->user()->hasRole(['student','teacher','tutor'])) {
		    $procChildOrgs = \DB::select('call GetChildOrgs(?)',[$orgs]);
		    $childOrgs = array_column($procChildOrgs,'id');
		    array_push($childOrgs,auth()->user()->organization_id);
		    $orgs = $childOrgs;
	    }

	    $model = $model->WhereIn('organization_id',$orgs);
	    return $model;
    }
}

My orgs are setup like:
ID | Orgname | ParentID | ...

Certain users are allowed to see the children of their organization, but never up the chain. Student would not normally be able to see down the chain, but this is code from my dev box. I was testing something.

nice!