File: D:/HostingSpaces/SBogers10/umans.komma.pro/app/Komma/Colleagues/ColleagueService.php
<?php
/**
* Short description for the file.
*
* @author Tim Van Samang <timvansamang@komma.pro>
* @copyright (c) 2012-2015, Komma Mediadesign
*/
namespace Komma\Colleagues;
use Komma\Colleagues\Models\Colleague;
use Komma\Images\Models\Image;
class ColleagueService
{
/**
* Get collection of all the colleagues
*
* @return mixed
*/
public function getColleagues()
{
$colleagues = Colleague::on('mysql')
->where('lft', '!=', 1)
->with('translation')
->orderBy('lft')
->where('active', '=', 1)
->get();
// load images manual because you have to set the connection
// key them by their imageble_id for easy mapping
$colleaguesImage = Image::on('mysql')
->where('imageble_type', 'Komma\Kms\Colleagues\Models\Colleague')
->get()
->keyBy('imageble_id');
// // map right image to colleague
// $colleagues = $colleagues->map(function ($colleague) use($colleaguesImage){
//
// // if image is found bind them to the colleague
// if(isset($colleaguesImage[$colleague->id])){
// $colleague->image = $colleaguesImage[$colleague->id];
// }
// return $colleague;
// });
// map colleague images to the right colleague
foreach ($colleagues as &$colleague){
// if image is found bind them to the colleague
if(isset($colleaguesImage[$colleague->id])){
$colleague->image = $colleaguesImage[$colleague->id];
}
}
return $colleagues;
}
}