INNER JOIN `' . _DB_PREFIX_ . 'attribute_lang` al
ON al.`id_attribute` = pac.`id_attribute`
AND al.`id_lang` = ' . (int) $id_lang . '
LEFT JOIN ' . ($is_one_five ? '`' . _DB_PREFIX_ . 'stock_available`' : '`' . _DB_PREFIX_ . 'product_attribute`') . ' sa
ON sa.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `' . _DB_PREFIX_ . 'ebay_product` ep
ON ep.`id_product` = pa.`id_product`
AND ep.`id_attribute` = pac.`id_product_attribute`
AND ep.`id_ebay_profile` = ' . $id_ebay_profile . '
WHERE pa.`id_product` = ' . $id_product . $ebay->addSqlRestrictionOnLang('sa') . '
ORDER BY a.`position` ASC';
$res = Db::getInstance()->ExecuteS($sql);
$final_res = array();
foreach ($res as $row) {
if (isset($final_res[$row['id_product_attribute']])) {
$final_res[$row['id_product_attribute']]['name'] .= ' ' . Tools::safeOutput($row['name']);
} else {
$row['name'] = Tools::safeOutput($row['name']);
$row['stock'] = Tools::safeOutput($row['stock']);
$row['id_product_ref'] = Tools::safeOutput($row['id_product_ref']);
if ($row['id_product_ref']) {
$row['link'] = EbayProduct::getEbayUrl($row['id_product_ref'], $ebay_request->getDev());
}
$final_res[$row['id_product_attribute']] = $row;
}
}
echo Tools::jsonEncode($final_res);
public function displayEbayListingsAjax($id_employee = null)
{
$ebay = new EbayRequest();
$employee = new Employee($id_employee);
$this->context->employee = $employee;
$link = $this->context->link;
$id_lang = $this->context->language->id;
$products_ebay_listings = array();
$products = EbayProduct::getProductsWithoutBlacklisted($id_lang, $this->ebay_profile->id, false);
$data = array('id_lang' => $id_lang, 'titleTemplate' => $this->ebay_profile->getConfiguration('EBAY_PRODUCT_TEMPLATE_TITLE'));
foreach ($products as $p) {
$data['real_id_product'] = (int) $p['id_product'];
$data['name'] = $p['name'];
$data['manufacturer_name'] = $p['manufacturer_name'];
$data['reference'] = $p['reference'];
$data['ean13'] = $p['ean13'];
$reference_ebay = $p['id_product_ref'];
$product = new Product((int) $p['id_product'], true, $id_lang);
if ((int) $p['id_attribute'] > 0) {
// No Multi Sku case so we do multiple products from a multivariation product
$combinaison = $this->_getAttributeCombinationsById($product, (int) $p['id_attribute'], $id_lang);
$combinaison = $combinaison[0];
$data['reference'] = $combinaison['reference'];
$data['ean13'] = $combinaison['ean13'];
$variation_specifics = EbaySynchronizer::_getVariationSpecifics($combinaison['id_product'], $combinaison['id_product_attribute'], $id_lang, $this->ebay_profile->ebay_site_id);
foreach ($variation_specifics as $variation_specific) {
$data['name'] .= ' ' . $variation_specific;
}
$products_ebay_listings[] = array('id_product' => $combinaison['id_product'] . '-' . $combinaison['id_product_attribute'], 'quantity' => $combinaison['quantity'], 'prestashop_title' => $data['name'], 'ebay_title' => EbayRequest::prepareTitle($data), 'reference_ebay' => $reference_ebay, 'link' => method_exists($link, 'getAdminLink') ? $link->getAdminLink('AdminProducts') . '&id_product=' . (int) $combinaison['id_product'] . '&updateproduct' : $link->getProductLink((int) $combinaison['id_product']), 'link_ebay' => EbayProduct::getEbayUrl($reference_ebay, $ebay->getDev()));
} else {
$products_ebay_listings[] = array('id_product' => $data['real_id_product'], 'quantity' => $product->quantity, 'prestashop_title' => $data['name'], 'ebay_title' => EbayRequest::prepareTitle($data), 'reference_ebay' => $reference_ebay, 'link' => method_exists($link, 'getAdminLink') ? $link->getAdminLink('AdminProducts') . '&id_product=' . (int) $data['real_id_product'] . '&updateproduct' : $link->getProductLink((int) $data['real_id_product']), 'link_ebay' => EbayProduct::getEbayUrl($reference_ebay, $ebay->getDev()));
}
}
$this->smarty->assign('products_ebay_listings', $products_ebay_listings);
echo $this->display(__FILE__, 'views/templates/hook/ebay_listings_ajax.tpl');
}
