HEX
Server: Microsoft-IIS/8.5
System: Windows NT YDAWBH120 6.3 build 9600 (Windows Server 2012 R2 Standard Edition) AMD64
User: tentjecom_web (0)
PHP: 7.4.14
Disabled: NONE
Upload Files
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;

    }
}