setting all active quotes to inactive , for the logged user

Question

This is the code I use, which is not working, in order to make all of active quotes for the logged user to inactive, but it keeps taking only one quote.

$quote = Mage::getSingleton('sales/quote');
$quoteID = $quote->getId();

while ($quoteID)
{

    // Set inactive 
    $quote->setIsActive(0);
    $quote->save();

    // find next inactive quote <- NOT WORKING! $quoteID STAYS THE SAME!
    $quote = Mage::getSingleton('sales/quote');
    $quoteID = $quote->getId();

}

Answer 1

Try the following -:

if (Mage::getSingleton('customer/session')->isLoggedIn()) {
  $customer = Mage::getSingleton('customer/session')->getCustomer();
  $collection = Mage::getResourceModel('sales/quote_collection');
  $collection->getSelect()->where('(is_active=1 and customer_id='.$customer->getId().')');
  foreach($collection as $col){
      $quote = Mage::getModel('sales/quote')->load($col->getId());
      $quote->setIsActive(0);
      $quote->save();
  } //foreach
}//If clause

Hope it helps

Cheers S