scottbedard / oc-shop-plugin

     * @param  \October\Rain\Database\Builder   $query

     * @return \October\Rain\Database\Builder

     */

    public function scopeJoinInventory(Builder $query)

    {

        $alias = 'inventories';

        $grammar = $query->getQuery()->getGrammar();

        $subquery = Inventory::addSelect('bedard_shop_inventories.product_id')

            ->selectRaw('SUM('.$grammar->wrap('bedard_shop_inventories.quantity').') as '.$grammar->wrap('inventory'))

            ->groupBy('bedard_shop_inventories.product_id');

        return $query

            ->addSelect($alias.'.inventory')

            ->joinSubquery($subquery, $alias, 'bedard_shop_products.id', '=', $alias.'.product_id', 'leftJoin');

    }

    /**

     * Left joins a subquery containing the product price.

     * @param  \October\Rain\Database\Builder   $query

     * @return \October\Rain\Database\Builder

     */

    public function scopeJoinPrice(Builder $query)

    {

        $alias = 'prices';

        $grammar = $query->getQuery()->getGrammar();

        $subquery = Price::isActive()

            ->addselect('bedard_shop_prices.product_id')

            ->selectRaw('MIN('.$grammar->wrap('bedard_shop_prices.price').') as '.$grammar->wrap('price'))

            ->groupBy('bedard_shop_prices.product_id');

        return $query

            ->addSelect($alias.'.price')

            ->joinSubquery($subquery, $alias, 'bedard_shop_products.id', '=', $alias.'.product_id');

    }

    /**

     * This exists to makes statuses sortable by assigning them a value.