function __construct($stats_version, $ebay_profile)
{
if (!$ebay_profile) {
return;
}
$this->stats_version = $stats_version;
$this->id_ebay_profile = (int) $ebay_profile->id;
$this->data = array('id' => sha1($this->_getDefaultShopUrl()), 'profile' => $ebay_profile->id, 'ebay_username' => sha1(Configuration::get('EBAY_IDENTIFIER')), 'ebay_site' => $ebay_profile->ebay_site_id, 'is_multishop' => version_compare(_PS_VERSION_, '1.5', '>') && Shop::isFeatureActive(), 'install_date' => Configuration::get('EBAY_INSTALL_DATE'), 'nb_listings' => EbayProduct::getNbProducts($ebay_profile->id), 'percent_of_catalog' => EbayProduct::getPercentOfCatalog($ebay_profile), 'nb_prestashop_categories' => EbayCategoryConfiguration::getNbPrestashopCategories($ebay_profile->id), 'nb_ebay_categories' => EbayCategoryConfiguration::getNbEbayCategories($ebay_profile->id), 'nb_optional_item_specifics' => EbayCategorySpecific::getNbOptionalItemSpecifics($ebay_profile->id), 'nb_national_shipping_services' => EbayShipping::getNbNationalShippings($ebay_profile->id), 'nb_international_shipping_services' => EbayShipping::getNbInternationalShippings($ebay_profile->id), 'date_add' => date('Y-m-d H:i:s'), 'Configuration' => EbayConfiguration::getAll($ebay_profile->id, array('EBAY_PAYPAL_EMAIL')), 'return_policy' => $ebay_profile->getReturnsPolicyConfiguration()->ebay_returns_description == '' ? 0 : 1, 'ps_version' => _PS_VERSION_);
$this->date_add = date('Y-m-d H:i:s');
}
/**
* 2007-2014 PrestaShop
*
* NOTICE OF LICENSE
*
* This source file is subject to the Academic Free License (AFL 3.0)
* that is bundled with this package in the file LICENSE.txt.
* It is also available through the world-wide-web at this URL:
* http://opensource.org/licenses/afl-3.0.php
* If you did not receive a copy of the license and are unable to
* obtain it through the world-wide-web, please send an email
* to license@prestashop.com so we can send you a copy immediately.
*
* DISCLAIMER
*
* Do not edit or add to this file if you wish to upgrade PrestaShop to newer
* versions in the future. If you wish to customize PrestaShop for your
* needs please refer to http://www.prestashop.com for more information.
*
* @author PrestaShop SA <*****@*****.**>
* @copyright 2007-2014 PrestaShop SA
* @license http://opensource.org/licenses/afl-3.0.php Academic Free License (AFL 3.0)
* International Registered Trademark & Property of PrestaShop SA
*/
include dirname(__FILE__) . '/../../../config/config.inc.php';
if (!Tools::getValue('token') || Tools::getValue('token') != Configuration::get('EBAY_SECURITY_TOKEN')) {
die('ERROR: Invalid Token');
}
include dirname(__FILE__) . '/../classes/EbayConfiguration.php';
echo EbayConfiguration::updateAPIToken() ? 'OK' : 'KO';
/**
* For upgrade: takes the values in PS Configurations and stores them in Ebay Configurations
*
* Returns true is sucessful, false otherwise
*
* @return boolean
*/
public static function PSConfigurationsToEbayConfigurations($id_ebay_profile, $attributes, $attributes_html)
{
foreach ($attributes as $name) {
$ps_value = Configuration::get($name);
$ebay_value = EbayConfiguration::get($id_ebay_profile, $name);
if ($ps_value && !$ebay_value) {
EbayConfiguration::set($id_ebay_profile, $name, $ps_value);
}
}
foreach ($attributes_html as $name) {
$ps_value = Configuration::get($name);
$ebay_value = EbayConfiguration::get($id_ebay_profile, $name);
if ($ps_value && !$ebay_value) {
EbayConfiguration::set($id_ebay_profile, $name, $ps_value, true);
}
}
}
/**
* Updates the template image links since the image files have moved
*
*/
function upgrade_module_1_7($module)
{
include dirname(__FILE__) . '/sql/sql-upgrade-1-7.php';
if (!empty($sql) && is_array($sql)) {
foreach ($sql as $request) {
if (!Db::getInstance()->execute($request)) {
return false;
}
}
}
Db::getInstance()->Execute('UPDATE ' . _DB_PREFIX_ . 'ebay_shipping SET id_zone = ' . (int) Configuration::get('EBAY_ZONE_NATIONAL') . ' WHERE international = 0');
Db::getInstance()->Execute('UPDATE ' . _DB_PREFIX_ . 'ebay_shipping SET id_zone = ' . (int) Configuration::get('EBAY_ZONE_INTERNATIONAL') . ' WHERE international = 1');
// create default profile(s)
$is_multishop = version_compare(_PS_VERSION_, '1.5', '>') && Shop::isFeatureActive();
$id_shop_default = (int) Configuration::get('PS_SHOP_DEFAULT') ? (int) Configuration::get('PS_SHOP_DEFAULT') : 1;
// handle default returns policy
if (!($id_returns_policy_configuration = EbayReturnsPolicyConfiguration::getDefaultObjectId())) {
$id_returns_policy_configuration = EbayReturnsPolicyConfiguration::createPreviousDefaultConfiguration();
}
// handle default profile
if (version_compare(_PS_VERSION_, '1.5', '<')) {
$id_shops = array('1' => '1');
} else {
$id_shops = Shop::getShops(false, null, false);
}
foreach (array_keys($id_shops) as $id_shop) {
if (!($profile = EbayProfile::getOneByIdShop($id_shop))) {
$profile = new EbayProfile();
$profile->id_shop = $id_shop;
}
$profile->ebay_user_identifier = Configuration::get('EBAY_IDENTIFIER');
$ebay_country = EbayCountrySpec::getInstanceByKey(Configuration::get('EBAY_COUNTRY_DEFAULT'));
$profile->ebay_site = $ebay_country->getSiteExtension();
if ($id_shop_default == $id_shop) {
$profile->id_ebay_returns_policy_configuration = $id_returns_policy_configuration;
} else {
$profile->id_ebay_returns_policy_configuration = EbayReturnsPolicyConfiguration::createPreviousDefaultConfiguration();
}
$profile->save();
if ($id_shop_default == $id_shop) {
$id_default_ebay_profile = $profile->id;
}
$configurations_to_update = array('EBAY_COUNTRY_DEFAULT', 'EBAY_ORDER_LAST_UPDATE', 'EBAY_DELIVERY_TIME', 'EBAY_PICTURE_SIZE_DEFAULT', 'EBAY_PICTURE_SIZE_SMALL', 'EBAY_PICTURE_SIZE_BIG', 'EBAY_LISTING_DURATION', 'EBAY_AUTOMATICALLY_RELIST', 'EBAY_LAST_RELIST', 'EBAY_SYNC_PRODUCTS_MODE', 'EBAY_ZONE_NATIONAL', 'EBAY_ZONE_INTERNATIONAL', 'EBAY_SHOP', 'EBAY_SHOP_POSTALCODE', 'EBAY_SYNC_OPTION_RESYNC', 'EBAY_SYNC_MODE', 'EBAY_SYNC_LAST_PRODUCT', 'EBAY_SPECIFICS_LAST_UPDATE', 'EBAY_PAYPAL_EMAIL');
$configuration_to_update_html = array('EBAY_PRODUCT_TEMPLATE');
EbayConfiguration::PSConfigurationsToEbayConfigurations($profile->id, $configurations_to_update, $configuration_to_update_html);
$profile->setConfiguration('EBAY_PRODUCT_TEMPLATE_TITLE', '{TITLE}');
}
$configurations_to_delete = array_merge($configurations_to_update, array('EBAY_RETURNS_DESCRIPTION', 'EBAY_RETURNS_ACCEPTED_OPTION', 'EBAY_RETURNS_WITHIN', 'EBAY_RETURNS_WHO_PAYS'));
foreach ($configurations_to_delete as $name) {
Configuration::deleteByName($name);
}
// ebay_category_configuration table
$tables = array('ebay_category_configuration', 'ebay_shipping_zone_excluded', 'ebay_shipping_international_zone', 'ebay_category_condition', 'ebay_category_condition_configuration', 'ebay_shipping', 'ebay_product');
if (version_compare(_PS_VERSION_, '1.5', '<')) {
foreach ($tables as $table) {
Db::getInstance()->autoExecute(_DB_PREFIX_ . $table, array('id_ebay_profile' => $id_default_ebay_profile), 'UPDATE');
}
} else {
foreach ($tables as $table) {
Db::getInstance()->update($table, array('id_ebay_profile' => $id_default_ebay_profile));
}
}
$sql = 'SELECT `id_ebay_order`, `id_order`
FROM `' . _DB_PREFIX_ . 'ebay_order`';
$res = Db::getInstance()->executeS($sql);
foreach ($res as $row) {
$data = array('id_ebay_order' => $row['id_ebay_order'], 'id_order' => $row['id_order']);
if (version_compare(_PS_VERSION_, '1.5', '<')) {
Db::getInstance()->autoExecute(_DB_PREFIX_ . 'ebay_order_order', $data, 'INSERT');
} else {
Db::getInstance()->insert('ebay_order_order', $data, false, true, Db::REPLACE);
}
}
$module->setConfiguration('EBAY_VERSION', $module->version);
// TODO: at some point we need to remove the id_order column of ebay_order which becomes useless
// but we cannot do it before the data have moved
return true;
}
