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;
    }
}

nice!