/** Returns query builder of organizations having activity or organization file published.
* @return mixed
*/
public function initializeOrganizationQueryBuilder()
{
return Organization::leftJoin('activity_published', 'organizations.id', '=', 'activity_published.organization_id')->leftJoin('organization_published', 'organizations.id', '=', 'organization_published.organization_id')->where('activity_published.published_to_register', 1)->orWhere('organization_published.published_to_register', 1)->select('organizations.id', 'organizations.name', 'organizations.logo_url')->groupBy('organizations.id')->orderBy('organizations.name');
}
