gistfile1.txt

    public function get_inventory()
    {
        $warehouse_skus = $this
                            ->find('all');
        $warehouse_skus = $warehouse_skus
            ->select(
                [
                    'id'=>'WarehouseSkus.id',
                    'available'=>'sum(Inventory.available)',
                    'damaged'=>'sum(Inventory.damaged)',
                    'pallets'=>'sum(Inventory.pallets)',
                ])
            ->group('WarehouseSkus.id')
            ->leftJoinWith('Inventory')
            ->autoFields(true);
        return $warehouse_skus;
    }


    public function get_released()
    {
        $warehouse_skus = $this
                            ->find('all');
        $warehouse_skus = $warehouse_skus
            ->select(
                [
                    'id'=>'WarehouseSkus.id',
                    'released'=>'sum(FulfillmentItems.qty)',
                ])
            ->group('WarehouseSkus.id')
            ->leftJoinWith('FulfillmentItems', function($q)
                {
                    return $q->where(['FulfillmentItems.status'=>'released']);    
                }
                )
            ->autoFields(true);
        return $warehouse_skus;
    }
    
    
    *****



$whsku_released=
            $this->WarehouseSkus->find('all')
            ->select([
                    'id'=>'WarehouseSkus.id',
                    'sku'=>'Products.sku',
                    'description',
                    'pack',
                    'inner_pack',
                    'lot',
                    'released'=>'t1.released',
                    'available'=>'t2.available',
                    'damaged'=>'t2.damaged',
                    'pallets'=>'t2.pallets',
                ])
            ->leftJoinWith('Products')
            ->leftJoin(['t1'=>$this->WarehouseSkus->get_released()], 't1.id = WarehouseSkus.id')
            ->leftJoin(['t2'=>$this->WarehouseSkus->get_inventory()], 't2.id = WarehouseSkus.id');