GiftCardTransaction.php

    public function scopeByInStore($query)
    {
        return GiftCardTransaction::whereHas('GiftCard', function ($query)
        {
            $query->whereHas('GiftCardBatch', function ($query)
            {
                $inStoreOrderType = GiftCardOrderTypes::$inStore;
                $id               = GiftCardBatch::where('name', '=', $inStoreOrderType)->first()->id;
                $query->where('id', $id);
            });
        });
    }