NAME

Interchange6::Schema::ResultSet::Product

SYNOPSIS

Provides extra accessor methods for Interchange6::Schema::Result::Product

METHODS

See also DBIx::Class::Helper::ResultSet::Shortcut which is loaded by this result set.

active

Returns all rows where "active" in Interchange6::Schema::Result::Product is true.

listing

Returns a result set which has been inflated using DBIx::Class::ResultClass::HashRefInflator ready for use by a product listing page.

Accepts a hashref of the following optional arguments:

• quantity => minimum value of "quantity" in Interchange6::Schema::Result::PriceModifier

• users_id => "users_id" in Interchange6::Schema::Result::User

Returned columns are:

• "sku" in Interchange6::Schema::Result::Product

• "name" in Interchange6::Schema::Result::Product

• "uri" in Interchange6::Schema::Result::Product

• "price" in Interchange6::Schema::Result::Product

• selling_price from "price" in Interchange6::Schema::Result::PriceModifier

• inventory from "quantity" in Interchange6::Schema::Result::Inventory

• discount_percent based on difference between price and selling_price

Since the last three columns are normally only available via ->get_column('column_name') it is suggested that any returned result set is inflated into hash references using DBIx::Class::ResultClass::HashRefInflator to make these values easily accessible.

NOTE: it is NOT necessarily safe to chain on the end of this method due to its use of the relationship "current_price_modifiers" in Interchange6::Schema::Result::Product which requires bind values to be passed so test very carefully. It is certainly NOT possible to call ->count on the returned result set as it will either throw an exception or give you a completely unexpected result. If you need to count the result set then do that before calling this method.