/**
     * Unit test for eZProductCollection::cleanupList()
     *
     * Outline:
     * 1) Create 10 eZProductCollection objects
     * 2) Pick 5 random ID of created items
     * 3) Call cleanupList() on these 5 items
     * 4) Check that the 5 items have been removed
     * 5) Check that the 5 other items haven't been removed
     */
    public function testCleanupList()
    {
        // Create a few collections
        $row = array( 'created' => time(), 'currency_code' => 'EUR' );
        $collection = new eZProductCollection( $row );
        $collection->store();

        $collectionIDArray[] = $collection->attribute( 'id' );

        for( $i = 0; $i < 1500; $i++ )
        {
            $newCollection = $collection->copy();
            $collectionIDArray[] = $newCollection->attribute( 'id' );
        }

        // pick a few random ID to delete
        $deleteIDArray = array_rand( $collectionIDArray, round( count( $collectionIDArray ) / 2 ) );
        $remainingIDArray = array_diff( $collectionIDArray, $deleteIDArray );

        eZProductCollection::cleanupList( $deleteIDArray );

        // Check that each item of deleteIDArray has been removed
        foreach( $deleteIDArray as $id )
        {
            $this->assertNull( eZProductCollection::fetch( $id ) );
        }

        // And check that each item of remainingIDArray hasn't been deleted
        foreach( $remainingIDArray as $id )
        {
            $this->assertInstanceOf( 'eZProductCollection', eZProductCollection::fetch( $id ) );
        }
    }

 function fetchBasket()
 {
     $http = eZHTTPTool::instance();
     $sessionID = $http->sessionID();
     $basketList = eZPersistentObject::fetchObjectList(eZBasket::definition(), null, array("session_id" => $sessionID), null, null, true);
     $currentBasket = false;
     if (count($basketList) == 0) {
         // If we don't have a stored basket we create a temporary
         // one which can be returned.
         $collection = eZProductCollection::create();
         $currentBasket = new eZBasket(array("session_id" => $sessionID, "productcollection_id" => 0));
     } else {
         $currentBasket = $basketList[0];
     }
     if ($currentBasket === null) {
         $result = array('error' => array('error_type' => 'kernel', 'error_code' => eZError::KERNEL_NOT_FOUND));
     } else {
         $result = array('result' => $currentBasket);
     }
     return $result;
 }

 static function verify($id)
 {
     $invalidItemArray = array();
     $collection = eZProductCollection::fetch($id);
     if (!is_object($collection)) {
         return $invalidItemArray;
     }
     $currency = $collection->attribute('currency_code');
     $productItemList = eZPersistentObject::fetchObjectList(eZProductCollectionItem::definition(), null, array("productcollection_id" => $id), null, null, true);
     $isValid = true;
     foreach ($productItemList as $productItem) {
         if (!$productItem->verify($currency)) {
             $invalidItemArray[] = $productItem;
             $isValid = false;
         }
     }
     if (!$isValid) {
         return $invalidItemArray;
     }
     return $isValid;
 }

 static function cleanupCurrentBasket($useSetting = true)
 {
     $ini = eZINI::instance();
     $removeBasket = true;
     if ($useSetting) {
         $removeBasket = $ini->hasVariable('ShopSettings', 'ClearBasketOnLogout') ? $ini->variable('ShopSettings', 'ClearBasketOnLogout') == 'enabled' : false;
     }
     if ($removeBasket) {
         $basket = eZBasket::currentBasket();
         if (!is_object($basket)) {
             return false;
         }
         $db = eZDB::instance();
         $db->begin();
         $productCollectionID = $basket->attribute('productcollection_id');
         eZProductCollection::cleanupList(array($productCollectionID));
         $basket->remove();
         $db->commit();
     }
     return true;
 }

if ( $clean['tipafriend'] )
{
    $cli->output( "Removing all counters for tip-a-friend" );
    eZTipafriendCounter::cleanup();
}

if ( $clean['shop'] )
{
    $cli->output( "Removing all baskets" );
    eZBasket::cleanup();
    $cli->output( "Removing all wishlists" );
    eZWishList::cleanup();
    $cli->output( "Removing all orders" );
    eZOrder::cleanup();
    $productCount = eZPersistentObject::count( eZProductCollection::definition() );
    if ( $productCount > 0 )
    {
        $cli->warning( "$productCount product collections still exists, must be a leak" );
    }
}

if ( $clean['forgotpassword'] )
{
    $cli->output( "Removing all forgot password requests" );
    eZForgotPassword::cleanup();
}

if ( $clean['workflow'] )
{
    $cli->output( "Removing all workflow processes and operation mementos" );

 function collectBaskets($maxTime = false, $sleepTime = false, $limit = false)
 {
     $db = eZDB::instance();
     if ($maxTime === false and $db->hasRequiredServerVersion('4.0', 'mysql')) {
         $sql = "DELETE FROM ezbasket, ezproductcollection, ezproductcollection_item, ezproductcollection_item_opt\nUSING ezsession\n      RIGHT JOIN ezbasket\n        ON ezsession.session_key = ezbasket.session_id\n      LEFT JOIN ezproductcollection\n        ON ezbasket.productcollection_id = ezproductcollection.id\n      LEFT JOIN ezproductcollection_item\n        ON ezproductcollection.id = ezproductcollection_item.productcollection_id\n      LEFT JOIN ezproductcollection_item_opt\n        ON ezproductcollection_item.id = ezproductcollection_item_opt.item_id\nWHERE ezsession.session_key IS NULL";
         $db->query($sql);
         return;
     }
     // Find all baskets which are lacking a session (db leaks)
     if ($db->hasRequiredServerVersion('8', 'oracle')) {
         $sql = "SELECT id, productcollection_id\nFROM ezsession, ezbasket\nWHERE ezbasket.session_id = ezsession.session_key (+) AND\n      ezsession.session_key IS NULL";
     } else {
         $sql = "SELECT id, productcollection_id\nFROM ezsession\n     RIGHT JOIN ezbasket\n       ON ezbasket.session_id = ezsession.session_key\nWHERE ezsession.session_key IS NULL";
     }
     if ($limit === false) {
         $limit = eZDBGarbageCollector::ITEM_LIMIT;
     }
     $end = false;
     if (is_numeric($maxTime)) {
         $end = time() + $maxTime;
     }
     do {
         $rows = $db->arrayQuery($sql, array('offset' => 0, 'limit' => $limit));
         if (count($rows) == 0) {
             break;
         }
         $productCollectionIDList = array();
         $idList = array();
         foreach ($rows as $row) {
             $idList[] = (int) $row['id'];
             $productCollectionIDList[] = (int) $row['productcollection_id'];
         }
         eZProductCollection::cleanupList($productCollectionIDList);
         $ids = implode(', ', $idList);
         $db->query("DELETE FROM ezbasket WHERE id IN ( {$ids} )");
         // Stop when we used up our time
         if ($end !== false and time() > $end) {
             break;
         }
         // Sleep a little if required, reduces load on server
         if ($sleepTime !== false) {
             sleep($sleepTime);
         }
     } while (true);
 }

 function currencyCode($collection = false)
 {
     if (is_string($collection) and $collection != '') {
         $currencyCode = $collection;
     } else {
         if ($collection instanceof eZProductCollection === false) {
             $collection = eZProductCollection::fetch($this->attribute('productcollection_id'));
         }
         $currencyCode = $collection->attribute('currency_code');
     }
     // Backwards compability for orders done with the price datatype.
     if ($currencyCode == '') {
         $currencyCode = eZOrder::fetchLocaleCurrencyCode();
     }
     return $currencyCode;
 }

}
if ($http->hasPostVariable("RemoveProductItemButton")) {
    $itemList = $http->postVariable("RemoveProductItemDeleteList");
    $wishList = eZWishList::currentWishList();
    $db = eZDB::instance();
    $db->begin();
    foreach ($itemList as $item) {
        $wishList->removeItem($item);
    }
    $db->commit();
    $module->redirectTo($module->functionURI("wishlist") . "/");
    return;
}
if ($http->hasPostVariable("StoreChangesButton")) {
    $wishList = eZWishList::currentWishList();
    $collection = eZProductCollection::fetch($wishList->attribute('productcollection_id'));
    if ($collection and $http->hasPostVariable("ProductItemIDList")) {
        $collectionItems = $collection->itemList();
        $productItemIDlist = $http->postVariable("ProductItemIDList");
        $productItemCountList = $http->hasPostVariable("ProductItemCountList") ? $http->postVariable("ProductItemCountList") : false;
        if ($productItemCountList == false) {
            $module->redirectTo($module->functionURI("wishlist") . "/");
            return;
        }
        $productItemsCount = array();
        // Create array of productItemID (as index) and productItemCount (as value)
        foreach ($productItemIDlist as $key => $productItemID) {
            if (isset($productItemCountList[$key])) {
                $productItemsCount[$productItemID] = $productItemCountList[$key];
            }
        }

 static function cleanup()
 {
     $db = eZDB::instance();
     $db->begin();
     $rows = $db->arrayQuery("SELECT productcollection_id FROM ezwishlist");
     if (count($rows) > 0) {
         $productCollectionIDList = array();
         foreach ($rows as $row) {
             $productCollectionIDList[] = $row['productcollection_id'];
         }
         eZProductCollection::cleanupList($productCollectionIDList);
     }
     $db->query("DELETE FROM ezwishlist");
     $db->commit();
 }

             return;
         }
     }
 }
 // Fetch the shop account handler
 $accountHandler = eZShopAccountHandler::instance();
 // Do we have all the information we need to start the checkout
 if (!$accountHandler->verifyAccountInformation()) {
     // Fetches the account information, normally done with a redirect
     $accountHandler->fetchAccountInformation($module);
     return;
 } else {
     // Creates an order and redirects
     $basket = eZBasket::currentBasket();
     $productCollectionID = $basket->attribute('productcollection_id');
     $verifyResult = eZProductCollection::verify($productCollectionID);
     $db = eZDB::instance();
     $db->begin();
     $basket->updatePrices();
     if ($verifyResult === true) {
         $order = $basket->createOrder();
         $order->setAttribute('account_identifier', "default");
         $order->store();
         $http->setSessionVariable('MyTemporaryOrderID', $order->attribute('id'));
         $db->commit();
         $module->redirectTo('/shop/confirmorder/');
         return;
     } else {
         $basket = eZBasket::currentBasket();
         $removedItems = array();
         foreach ($itemList as $item) {