Item Object
(
[ItemID] => 45104
[ProductItemID] => 45444
[OptionGroups] =>
[UserPrice] =>
[RetailPrice] => 121.93
[ImageFolderName] => Rubi
[ItemImage] => 69932.png
[ItemCost] => 71.13
[ManufacturerID] => 54
[ManufacturerName] => Rubi
[SKU] => 261247
[MPN] => 69932
[UPC] =>
[GTIN] =>
[CartDescription] => CERAMIC TILING KIT 69932
[ItemNotes] =>
[Length] => 15
[Width] => 3
[Height] => 3
[Weight] => 4
[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 = 45444 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] => 6405
[ProductItemID] => 45444
[ItemID] => 45104
[ItemAvailable] => Available
[ManufacturerID] => 54
[SKU] => 261247
[MPN] => 69932
[UPC] =>
[GTIN] =>
[ItemCost] => 71.13
[Weight] => 4
[Length] => 15
[Height] => 3
[Width] => 3
[ItemNotes] =>
[ItemImage] => 69932.png
[CartDescription] => CERAMIC TILING KIT 69932
[HandlingTypeID] => 1
[SurchargeID] => 0
[CombineTypeID] => 2
[GroundOnly] =>
[FlatShipping] => 0
[InfoVerified] =>
[MinimumQuantity] => 1
[PackageQuantity] => 1
[ItemDateCreated] => 2012-08-06 17:02:12
[ManufacturerName] => Rubi
[ImageFolderName] => Rubi
[RetailPrice] => 121.93
[UserPrice] =>
[SelectedItemGroupings] =>
)
)
[rownum:Util_Query:private] => 1
[foundRows:Util_Query:private] =>
[loopFunction:Util_Query:private] =>
[affectedRows:Util_Query:private] =>
[database] => saunder_Store
)
[AdminMode:protected] =>
)
ss
