Item Object
(
[ItemID] => 45119
[ProductItemID] => 45465
[OptionGroups] => Array
(
[114] => 7176
)
[UserPrice] =>
[RetailPrice] => 70.38
[ImageFolderName] => Rubi
[ItemImage] => 83957.png
[ItemCost] => 41.05
[ManufacturerID] => 54
[ManufacturerName] => Rubi
[SKU] => 261260
[MPN] => 83957
[UPC] =>
[GTIN] =>
[CartDescription] => GROOVING TROWEL 5 15/16 x 5 15/16 x 32/32" (150 x 150 x 25 mm.) STAINLESS STEEL 83957
[ItemNotes] =>
[Length] => 16
[Width] => 6
[Height] => 5
[Weight] => 1
[HandlingTypeID] => 1
[SurchargeID] => 0
[CombineTypeID] => 2
[InfoVerified] =>
[ItemAvailable] => Available
[MinimumQuantity] => 1
[PackageQuantity] => 1
[SurchargeName] =>
[Surcharge] =>
[SubsequentSurcharge] =>
[SurchargeLimit] =>
[IsMinimum] =>
[CombineTypeName] =>
[UpperLimit] =>
[InBox] =>
[MaxWeight] =>
[HandlingName] =>
[USHandlingMultiplier] =>
[TerritoryHandlingMultiplier] =>
[CanadaHandlingMultiplier] =>
[IntlHandlingMultiplier] =>
[USExpressMultiplier] =>
[TerritoryExpressMultiplier] =>
[CanadaExpressMultiplier] =>
[IntlExpressMultiplier] =>
[FMName] =>
[FMOption] =>
[FMPrice] =>
[FMNotes] =>
[FMManufacturerID] =>
[FMAvailability] =>
[Cost] =>
[NumericSKU] =>
[Fields:protected] =>
[LastUpdated] =>
[DB:protected] => Util_Query Object
(
[name:Util_Query:private] => ItemValues
[statement:Util_Query:private] =>
SELECT ProductID, productitems.ProductItemID, items.*, ManufacturerName, ImageFolderName,
retail.Price AS RetailPrice, IFNULL(userprice.Price, ( ItemCost / (1 - UserMargin/100) ) ) AS UserPrice,
GROUP_CONCAT(
DISTINCT CONCAT(
REPLACE(FORMAT(optiongroups.GroupID,0),',',''),
':',
REPLACE(FORMAT(optiongroups.OptionID,0),',','')
) ORDER BY optiongroups.GroupID, optiongroups.Priority SEPARATOR ',') AS SelectedItemGroupings
FROM productitems
INNER JOIN items ON items.ItemID = productitems.ItemID
INNER JOIN manufacturers ON manufacturers.ManufacturerID = items.ManufacturerID
LEFT JOIN optionsets ON optionsets.ProductItemID = productitems.ProductItemID
LEFT JOIN optiongroups ON optiongroups.OptionGroupID = optionsets.OptionGroupID
LEFT JOIN groups ON optiongroups.GroupID = groups.GroupID
LEFT JOIN options ON options.OptionID = optiongroups.OptionID
LEFT JOIN pricelists retail ON retail.ProductItemID = productitems.ProductItemID AND retail.UserID = 1
LEFT JOIN pricelists userprice ON userprice.ProductItemID = productitems.ProductItemID AND userprice.UserID = %s
LEFT JOIN usermanufacturers um ON um.ManufacturerID = manufacturers.ManufacturerID AND um.UserID = %s
WHERE productitems.ProductItemID = %s AND items.ItemAvailable != 'NOT DISPLAYED'
GROUP BY productitems.ProductItemID
[query:Util_Query:private] =>
SELECT ProductID, productitems.ProductItemID, items.*, ManufacturerName, ImageFolderName,
retail.Price AS RetailPrice, IFNULL(userprice.Price, ( ItemCost / (1 - UserMargin/100) ) ) AS UserPrice,
GROUP_CONCAT(
DISTINCT CONCAT(
REPLACE(FORMAT(optiongroups.GroupID,0),',',''),
':',
REPLACE(FORMAT(optiongroups.OptionID,0),',','')
) ORDER BY optiongroups.GroupID, optiongroups.Priority SEPARATOR ',') AS SelectedItemGroupings
FROM productitems
INNER JOIN items ON items.ItemID = productitems.ItemID
INNER JOIN manufacturers ON manufacturers.ManufacturerID = items.ManufacturerID
LEFT JOIN optionsets ON optionsets.ProductItemID = productitems.ProductItemID
LEFT JOIN optiongroups ON optiongroups.OptionGroupID = optionsets.OptionGroupID
LEFT JOIN groups ON optiongroups.GroupID = groups.GroupID
LEFT JOIN options ON options.OptionID = optiongroups.OptionID
LEFT JOIN pricelists retail ON retail.ProductItemID = productitems.ProductItemID AND retail.UserID = 1
LEFT JOIN pricelists userprice ON userprice.ProductItemID = productitems.ProductItemID AND userprice.UserID = -1
LEFT JOIN usermanufacturers um ON um.ManufacturerID = manufacturers.ManufacturerID AND um.UserID = -1
WHERE productitems.ProductItemID = 45465 AND items.ItemAvailable != 'NOT DISPLAYED'
GROUP BY productitems.ProductItemID
[type:Util_Query:private] => SELECT
[context:Util_Query:private] =>
[result:Util_Query:private] => Array
(
[0] => Array
(
[ProductID] => 6414
[ProductItemID] => 45465
[ItemID] => 45119
[ItemAvailable] => Available
[ManufacturerID] => 54
[SKU] => 261260
[MPN] => 83957
[UPC] =>
[GTIN] =>
[ItemCost] => 41.05
[Weight] => 1
[Length] => 16
[Height] => 5
[Width] => 6
[ItemNotes] =>
[ItemImage] => 83957.png
[CartDescription] => GROOVING TROWEL 5 15/16 x 5 15/16 x 32/32" (150 x 150 x 25 mm.) STAINLESS STEEL 83957
[HandlingTypeID] => 1
[SurchargeID] => 0
[CombineTypeID] => 2
[GroundOnly] =>
[FlatShipping] => 0
[InfoVerified] =>
[MinimumQuantity] => 1
[PackageQuantity] => 1
[ItemDateCreated] => 2012-08-06 18:04:06
[ManufacturerName] => Rubi
[ImageFolderName] => Rubi
[RetailPrice] => 70.38
[UserPrice] =>
[SelectedItemGroupings] => 114:7176
)
)
[rownum:Util_Query:private] => 1
[foundRows:Util_Query:private] =>
[loopFunction:Util_Query:private] =>
[affectedRows:Util_Query:private] =>
[database] => saunder_Store
)
[AdminMode:protected] =>
)
ss
$70.38
