GiftCardTransaction.php

    public function scopeByInStore($query)
    {
        $inStoreOrderType = GiftCardOrderTypes::$inStore;
        $id               = GiftCardBatch::where('name', '=', $inStoreOrderType)->first()->id;
        $inStoreGiftCardIds = GiftCard::where('gift_card_batch_id', '=', $id)
            ->lists('id');

        return $query->whereIn('gift_card_id', $inStoreGiftCardIds);
    }