get cart items from custom column value

Question

I have a custom column in my sales_flat_quote_item table named as device_id. I am working on to create a api where a device id is sent and the cart available items are displayed for guest users.

$deviceId=802;
$quote = Mage::getModel('sales/quote')->load($deviceId);
$cartItems = $quote->getAllVisibleItems();
foreach ($cartItems as $item) {
echo $pid = $item->getProductId();
}

which is not working.Is this not the proper way ?Please help thanks

Answer 1

You can try the below code:

$deviceId=802;
$collection = Mage::getModel('sales/quote_item')->setStoreId(1)->getCollection()->addFieldToFilter('device_id', array('eq' => $deviceId));
foreach($collection as $item)
{
  var_dump($item->getData());
}

Answer 2

you can do, try below code tested by me

$deviceId=802;  //if your value in ales_flat_quote table
$quote = Mage::getModel('sales/quote')->load($deviceId,'device_id');//here device_id is feild in database
$cartItems = $quote->getAllVisibleItems();
foreach ($cartItems as $item) {
  echo $pid = $item->getProductId();
}

according your comment

$deviceId=802;
$quote_colle = Mage::getModel('sales/quote')->getCollection();
foreach($quote_colle as $quote){

  $cartItems = $quote->getAllVisibleItems();
  foreach ($cartItems as $item) {
   if($item->getDeviceId()==802){
    echo $pid = $item->getProductId();
   }
  }
}

3rd way

Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);
$deviceId=802;
$collection = Mage::getModel('sales/quote_item')->getCollection()->addFieldToFilter('device_id',  $deviceId);
foreach($collection as $item)
{
 echo $item->getId();
}