private function relistItems()
{
if (Configuration::get('EBAY_LISTING_DURATION') != 'GTC' and Configuration::get('EBAY_AUTOMATICALLY_RELIST') == 'on') {
$days = substr(Configuration::get('EBAY_LISTING_DURATION'), 5);
//We do relist automatically each day
$this->setConfiguration('EBAY_LAST_RELIST', date('Y-m-d'));
$ebay = new eBayRequest();
$items = Db::getInstance()->ExecuteS('
SELECT ep.id_product_ref AS itemID, ep.id_product
FROM ' . _DB_PREFIX_ . 'ebay_product AS ep
WHERE NOW() > DATE_ADD(ep.date_upd, INTERVAL ' . $days . ' DAY)
LIMIT 0,10
');
foreach ($items as $item) {
$newItemID = $ebay->relistFixedPriceItem($item);
$newItemID = $newItemID != 0 ? $newItemID : $item['itemID'];
//Update of the product so that we don't take it in the next 10 products to relist !
Db::getInstance()->autoExecute(_DB_PREFIX_ . 'ebay_product', array('id_product_ref' => pSQL($newItemID), 'date_upd' => date('Y-m-d h:i:s')), 'UPDATE', '`id_product_ref` = ' . $item['itemID']);
}
}
}
