/**
* Process entered data for the shipping screen
*/
private function _postProcessShipping()
{
//Update excluded location
if (Tools::getValue('excludeLocationHidden')) {
Db::getInstance()->Execute('UPDATE ' . _DB_PREFIX_ . 'ebay_shipping_zone_excluded SET excluded = 0');
if ($exclude_locations = Tools::getValue('excludeLocation')) {
$where = '0 || ';
foreach ($exclude_locations as $location => $on) {
//build update $where
$where .= 'location = "' . pSQL($location) . '" || ';
}
$where .= ' 0';
if (version_compare(_PS_VERSION_, '1.5', '>')) {
DB::getInstance()->update('ebay_shipping_zone_excluded', array('excluded' => 1), $where);
} else {
Db::getInstance()->autoExecute(_DB_PREFIX_ . 'ebay_shipping_zone_excluded', array('excluded' => 1), 'UPDATE', $where);
}
}
}
//Update global information about shipping (delivery time, ...)
$this->setConfiguration('EBAY_DELIVERY_TIME', Tools::getValue('deliveryTime'));
$this->setConfiguration('EBAY_ZONE_INTERNATIONAL', Tools::getValue('internationalZone'));
$this->setConfiguration('EBAY_ZONE_NATIONAL', Tools::getValue('nationalZone'));
//Update Shipping Method for National Shipping (Delete And Insert)
EbayShipping::truncate();
if ($ebay_carriers = Tools::getValue('ebayCarrier')) {
$ps_carriers = Tools::getValue('psCarrier');
$extra_fees = Tools::getValue('extrafee');
foreach ($ebay_carriers as $key => $ebay_carrier) {
EbayShipping::insert($ebay_carrier, $ps_carriers[$key], $extra_fees[$key]);
}
}
Db::getInstance()->Execute('TRUNCATE ' . _DB_PREFIX_ . 'ebay_shipping_international_zone');
if ($ebay_carriers_international = Tools::getValue('ebayCarrier_international')) {
$ps_carriers_international = Tools::getValue('psCarrier_international');
$extra_fees_international = Tools::getValue('extrafee_international');
$international_shipping_locations = Tools::getValue('internationalShippingLocation');
$international_excluded_shipping_locations = Tools::getValue('internationalExcludedShippingLocation');
foreach ($ebay_carriers_international as $key => $ebay_carrier_international) {
EbayShipping::insert($ebay_carrier_international, $ps_carriers_international[$key], $extra_fees_international[$key], true);
$last_id = EbayShipping::getLastShippingId();
if (isset($international_shipping_locations[$key])) {
foreach (array_keys($international_shipping_locations[$key]) as $id_ebay_zone) {
EbayShippingInternationalZone::insert($last_id, $id_ebay_zone);
}
}
}
}
}
function postProcess()
{
//Update excluded location
if (Tools::getValue('excludeLocationHidden')) {
Db::getInstance()->Execute('UPDATE ' . _DB_PREFIX_ . 'ebay_shipping_zone_excluded
SET excluded = 0
WHERE `id_ebay_profile` = ' . (int) $this->ebay_profile->id);
if ($exclude_locations = Tools::getValue('excludeLocation')) {
$locations = array_keys($exclude_locations);
$where = 'location IN ("' . implode('","', array_map('pSQL', $locations)) . '")';
$where .= ' AND `id_ebay_profile` = ' . (int) $this->ebay_profile->id;
if (version_compare(_PS_VERSION_, '1.5', '>')) {
DB::getInstance()->update('ebay_shipping_zone_excluded', array('excluded' => 1), $where);
} else {
Db::getInstance()->autoExecute(_DB_PREFIX_ . 'ebay_shipping_zone_excluded', array('excluded' => 1), 'UPDATE', $where);
}
}
}
//Update global information about shipping (delivery time, ...)
$this->ebay_profile->setConfiguration('EBAY_DELIVERY_TIME', Tools::getValue('deliveryTime'));
//Update Shipping Method for National Shipping (Delete And Insert)
EbayShipping::truncate($this->ebay_profile->id);
if ($ebay_carriers = Tools::getValue('ebayCarrier')) {
$ps_carriers = Tools::getValue('psCarrier');
$extra_fees = Tools::getValue('extrafee');
foreach ($ebay_carriers as $key => $ebay_carrier) {
if (!empty($ebay_carrier) && !empty($ps_carriers[$key])) {
//Get id_carrier and id_zone from ps_carrier
$infos = explode('-', $ps_carriers[$key]);
EbayShipping::insert($this->ebay_profile->id, $ebay_carrier, $infos[0], $extra_fees[$key], $infos[1]);
}
}
}
Db::getInstance()->Execute('DELETE FROM ' . _DB_PREFIX_ . 'ebay_shipping_international_zone
WHERE `id_ebay_profile` = ' . (int) $this->ebay_profile->id);
if ($ebay_carriers_international = Tools::getValue('ebayCarrier_international')) {
$ps_carriers_international = Tools::getValue('psCarrier_international');
$extra_fees_international = Tools::getValue('extrafee_international');
$international_shipping_locations = Tools::getValue('internationalShippingLocation');
$international_excluded_shipping_locations = Tools::getValue('internationalExcludedShippingLocation');
foreach ($ebay_carriers_international as $key => $ebay_carrier_international) {
if (!empty($ebay_carrier_international) && !empty($ps_carriers_international[$key]) && isset($international_shipping_locations[$key])) {
$infos = explode('-', $ps_carriers_international[$key]);
EbayShipping::insert($this->ebay_profile->id, $ebay_carrier_international, $infos[0], $extra_fees_international[$key], $infos[1], true);
$last_id = EbayShipping::getLastShippingId($this->ebay_profile->id);
foreach (array_keys($international_shipping_locations[$key]) as $id_ebay_zone) {
EbayShippingInternationalZone::insert($this->ebay_profile->id, $last_id, $id_ebay_zone);
}
}
}
}
}