function fn_update_payment($payment_data, $payment_id, $lang_code = DESCR_SL)
{
if (!empty($payment_data['processor_id'])) {
$payment_data['template'] = db_get_field("SELECT processor_template FROM ?:payment_processors WHERE processor_id = ?i", $payment_data['processor_id']);
}
$payment_data['localization'] = !empty($payment_data['localization']) ? fn_implode_localizations($payment_data['localization']) : '';
$payment_data['usergroup_ids'] = !empty($payment_data['usergroup_ids']) ? implode(',', $payment_data['usergroup_ids']) : '';
if (!empty($payment_id)) {
db_query("UPDATE ?:payments SET ?u WHERE payment_id = ?i", $payment_data, $payment_id);
db_query("UPDATE ?:payment_descriptions SET ?u WHERE payment_id = ?i AND lang_code = ?s", $payment_data, $payment_id, $lang_code);
} else {
$payment_data['payment_id'] = $payment_id = db_query("INSERT INTO ?:payments ?e", $payment_data);
foreach ((array) Registry::get('languages') as $payment_data['lang_code'] => $_v) {
db_query("INSERT INTO ?:payment_descriptions ?e", $payment_data);
}
}
fn_attach_image_pairs('payment_image', 'payment', $payment_id, $lang_code);
// Update payment processor settings
if (!empty($payment_data['processor_params'])) {
db_query("UPDATE ?:payments SET params = ?s WHERE payment_id = ?i", serialize($payment_data['processor_params']), $payment_id);
}
return $payment_id;
}
function fn_banners_update_banner($data, $banner_id, $lang_code = DESCR_SL)
{
if (isset($data['timestamp'])) {
$data['timestamp'] = fn_parse_date($data['timestamp']);
}
$data['localization'] = empty($data['localization']) ? '' : fn_implode_localizations($data['localization']);
if (!empty($banner_id)) {
db_query("UPDATE ?:banners SET ?u WHERE banner_id = ?i", $data, $banner_id);
db_query("UPDATE ?:banner_descriptions SET ?u WHERE banner_id = ?i AND lang_code = ?s", $data, $banner_id, $lang_code);
$banner_image_id = fn_get_banner_image_id($banner_id, $lang_code);
$banner_image_exist = !empty($banner_image_id);
$banner_is_multilang = Registry::get('addons.banners.banner_multilang') == 'Y';
$image_is_update = fn_banners_need_image_update();
if ($banner_is_multilang) {
if ($banner_image_exist && $image_is_update) {
fn_delete_image_pairs($banner_image_id, 'promo');
db_query("DELETE FROM ?:banner_images WHERE banner_id = ?i AND lang_code = ?s", $banner_id, $lang_code);
$banner_image_exist = false;
}
} else {
if (isset($data['url'])) {
db_query("UPDATE ?:banner_descriptions SET url = ?s WHERE banner_id = ?i", $data['url'], $banner_id);
}
}
if ($image_is_update && !$banner_image_exist) {
$banner_image_id = db_query("INSERT INTO ?:banner_images (banner_id, lang_code) VALUE(?i, ?s)", $banner_id, $lang_code);
}
$pair_data = fn_attach_image_pairs('banners_main', 'promo', $banner_image_id, $lang_code);
if (!$banner_is_multilang && !$banner_image_exist) {
fn_banners_image_all_links($banner_id, $pair_data, $lang_code);
}
} else {
$banner_id = $data['banner_id'] = db_query("REPLACE INTO ?:banners ?e", $data);
foreach (Languages::getAll() as $data['lang_code'] => $v) {
db_query("REPLACE INTO ?:banner_descriptions ?e", $data);
}
if (fn_banners_need_image_update()) {
$data_banner_image = array('banner_id' => $banner_id, 'lang_code' => $lang_code);
$banner_image_id = db_get_next_auto_increment_id('banner_images');
$pair_data = fn_attach_image_pairs('banners_main', 'promo', $banner_image_id, $lang_code);
if (!empty($pair_data)) {
db_query("INSERT INTO ?:banner_images ?e", $data_banner_image);
fn_banners_image_all_links($banner_id, $pair_data, $lang_code);
}
}
}
return $banner_id;
}
function fn_update_banner($data, $banner_id, $lang_code = DESCR_SL)
{
if (isset($data['timestamp'])) {
$data['timestamp'] = fn_parse_date($data['timestamp']);
}
$data['localization'] = empty($data['localization']) ? '' : fn_implode_localizations($data['localization']);
if (!empty($banner_id)) {
db_query("UPDATE ?:banners SET ?u WHERE banner_id = ?i", $data, $banner_id);
db_query("UPDATE ?:banner_descriptions SET ?u WHERE banner_id = ?i AND lang_code = ?s", $data, $banner_id, $lang_code);
} else {
$banner_id = $data['banner_id'] = db_query("REPLACE INTO ?:banners ?e", $data);
foreach ((array) Registry::get('languages') as $data['lang_code'] => $v) {
db_query("REPLACE INTO ?:banner_descriptions ?e", $data);
}
}
fn_attach_image_pairs('banners_main', 'banner', $banner_id, $lang_code);
return $banner_id;
}
function fn_update_product($product_data, $product_id = 0, $lang_code = CART_LANGUAGE)
{
$_data = $product_data;
if (!empty($product_data['timestamp'])) {
$_data['timestamp'] = fn_parse_date($product_data['timestamp']);
// Minimal data for product record
}
if (!empty($product_data['avail_since'])) {
$_data['avail_since'] = fn_parse_date($product_data['avail_since']);
}
if (isset($product_data['tax_ids'])) {
$_data['tax_ids'] = empty($product_data['tax_ids']) ? '' : fn_create_set($product_data['tax_ids']);
}
if (isset($product_data['localization'])) {
$_data['localization'] = empty($product_data['localization']) ? '' : fn_implode_localizations($_data['localization']);
}
if (isset($product_data['usergroup_ids'])) {
$_data['usergroup_ids'] = empty($product_data['usergroup_ids']) ? '' : implode(',', $_data['usergroup_ids']);
}
if (Registry::get('settings.General.allow_negative_amount') == 'N' && isset($_data['amount'])) {
$_data['amount'] = abs($_data['amount']);
}
// add new product
if (empty($product_id)) {
$create = true;
// product title can't be empty
if (empty($product_data['product'])) {
return false;
}
$product_id = db_query("INSERT INTO ?:products ?e", $_data);
if (empty($product_id)) {
return false;
}
//
// Adding same product descriptions for all cart languages
//
$_data = $product_data;
$_data['product_id'] = $product_id;
$_data['product'] = trim($_data['product'], " -");
foreach ((array) Registry::get('languages') as $_data['lang_code'] => $_v) {
db_query("INSERT INTO ?:product_descriptions ?e", $_data);
}
// update product
} else {
if (isset($product_data['product']) && empty($product_data['product'])) {
unset($product_data['product']);
}
db_query("UPDATE ?:products SET ?u WHERE product_id = ?i", $_data, $product_id);
$_data = $product_data;
if (!empty($_data['product'])) {
$_data['product'] = trim($_data['product'], " -");
}
db_query("UPDATE ?:product_descriptions SET ?u WHERE product_id = ?i AND lang_code = ?s", $_data, $product_id, $lang_code);
}
// Log product add/update
fn_log_event('products', !empty($create) ? 'create' : 'update', array('product_id' => $product_id));
if (!empty($product_data['product_features'])) {
$i_data = array('product_id' => $product_id, 'lang_code' => $lang_code);
foreach ($product_data['product_features'] as $feature_id => $value) {
// Check if feature is applicable for this product
$id_paths = db_get_fields("SELECT ?:categories.id_path FROM ?:products_categories LEFT JOIN ?:categories ON ?:categories.category_id = ?:products_categories.category_id WHERE product_id = ?i", $product_id);
$_params = array('category_ids' => array_unique(explode('/', implode('/', $id_paths))), 'feature_id' => $feature_id);
list($_feature) = fn_get_product_features($_params);
if (empty($_feature)) {
$_feature = db_get_field("SELECT description FROM ?:product_features_descriptions WHERE feature_id = ?i AND lang_code = ?s", $feature_id, CART_LANGUAGE);
$_product = db_get_field("SELECT product FROM ?:product_descriptions WHERE product_id = ?i AND lang_code = ?s", $product_id, CART_LANGUAGE);
fn_set_notification('E', fn_get_lang_var('error'), str_replace(array('[feature_name]', '[product_name]'), array($_feature, $_product), fn_get_lang_var('product_feature_cannot_assigned')));
continue;
}
$i_data['feature_id'] = $feature_id;
unset($i_data['value']);
unset($i_data['variant_id']);
unset($i_data['value_int']);
$feature_type = db_get_field("SELECT feature_type FROM ?:product_features WHERE feature_id = ?i", $feature_id);
// Delete variants in current language
if ($feature_type == 'T') {
db_query("DELETE FROM ?:product_features_values WHERE feature_id = ?i AND product_id = ?i AND lang_code = ?s", $feature_id, $product_id, $lang_code);
} else {
db_query("DELETE FROM ?:product_features_values WHERE feature_id = ?i AND product_id = ?i", $feature_id, $product_id);
}
if ($feature_type == 'D') {
$i_data['value_int'] = fn_parse_date($value);
} elseif ($feature_type == 'M') {
if (!empty($product_data['add_new_variant'][$feature_id]['variant'])) {
$value = empty($value) ? array() : $value;
$value[] = fn_add_feature_variant($feature_id, $product_data['add_new_variant'][$feature_id]);
}
if (!empty($value)) {
foreach ($value as $variant_id) {
foreach (Registry::get('languages') as $i_data['lang_code'] => $_d) {
// insert for all languages
$i_data['variant_id'] = $variant_id;
db_query("REPLACE INTO ?:product_features_values ?e", $i_data);
}
}
}
continue;
} elseif (in_array($feature_type, array('S', 'N', 'E'))) {
if (!empty($product_data['add_new_variant'][$feature_id]['variant'])) {
$i_data['variant_id'] = fn_add_feature_variant($feature_id, $product_data['add_new_variant'][$feature_id]);
} elseif (!empty($value) && $value != 'disable_select') {
if ($feature_type == 'N') {
$i_data['value_int'] = db_get_field("SELECT variant FROM ?:product_feature_variant_descriptions WHERE variant_id = ?i AND lang_code = ?s", $value, CART_LANGUAGE);
}
$i_data['variant_id'] = $value;
} else {
continue;
}
} else {
if ($value == '') {
continue;
}
if ($feature_type == 'O') {
$i_data['value_int'] = $value;
} else {
$i_data['value'] = $value;
}
}
if ($feature_type != 'T') {
// feature values are common for all languages, except text (T)
foreach (Registry::get('languages') as $i_data['lang_code'] => $_d) {
db_query("REPLACE INTO ?:product_features_values ?e", $i_data);
}
} else {
// for text feature, update current language only
$i_data['lang_code'] = $lang_code;
db_query("INSERT INTO ?:product_features_values ?e", $i_data);
}
}
}
// Update product prices
if (isset($product_data['price'])) {
if (!isset($product_data['prices'])) {
$product_data['prices'] = array();
$skip_price_delete = true;
}
$_price = array('price' => abs($product_data['price']), 'lower_limit' => 1);
array_unshift($product_data['prices'], $_price);
}
if (!empty($product_data['prices'])) {
if (empty($skip_price_delete)) {
db_query("DELETE FROM ?:product_prices WHERE product_id = ?i", $product_id);
}
foreach ($product_data['prices'] as $v) {
if (!empty($v['lower_limit'])) {
$v['product_id'] = $product_id;
db_query("REPLACE INTO ?:product_prices ?e", $v);
}
}
}
if (!empty($product_data['popularity'])) {
$_data = array('product_id' => $product_id, 'total' => intval($product_data['popularity']));
db_query("INSERT INTO ?:product_popularity ?e ON DUPLICATE KEY UPDATE total = ?i", $_data, $product_data['popularity']);
}
fn_set_hook('update_product', $product_data, $product_id, $lang_code);
return $product_id;
}
function fn_update_news($news_id, $news_data, $lang_code = CART_LANGUAGE)
{
// news title required
if (empty($news_data['news'])) {
return false;
}
if (!empty($news_id) && !fn_check_company_id('news', 'news_id', $news_id)) {
fn_company_access_denied_notification();
return false;
}
$_data = $news_data;
$_data['date'] = fn_parse_date($news_data['date']);
if (isset($_data['localization'])) {
$_data['localization'] = empty($_data['localization']) ? '' : fn_implode_localizations($_data['localization']);
}
if (empty($news_id)) {
$create = true;
$news_id = $_data['news_id'] = db_query("REPLACE INTO ?:news ?e", $_data);
if (empty($news_id)) {
return false;
}
// Adding descriptions
foreach (fn_get_translation_languages() as $_data['lang_code'] => $v) {
db_query("INSERT INTO ?:news_descriptions ?e", $_data);
}
} else {
$create = false;
db_query("UPDATE ?:news SET ?u WHERE news_id = ?i", $_data, $news_id);
// update news descriptions
$_data = $news_data;
db_query("UPDATE ?:news_descriptions SET ?u WHERE news_id = ?i AND lang_code = ?s", $_data, $news_id, $lang_code);
}
// Log news update/add
fn_log_event('news', !empty($create) ? 'create' : 'update', array('news_id' => $news_id));
fn_set_hook('update_news', $news_data, $news_id, $lang_code, $create);
return $news_id;
}
function fn_update_page($page_data, $page_id = 0, $lang_code = CART_LANGUAGE)
{
if (!empty($page_data['avail_from_timestamp'])) {
$page_data['avail_from_timestamp'] = fn_parse_date($page_data['avail_from_timestamp']);
} else {
$page_data['avail_from_timestamp'] = 0;
}
if (!empty($page_data['avail_till_timestamp'])) {
$page_data['avail_till_timestamp'] = fn_parse_date($page_data['avail_till_timestamp']) + 86399;
} else {
$page_data['avail_till_timestamp'] = 0;
}
if (isset($page_data['usergroup_ids'])) {
$page_data['usergroup_ids'] = empty($page_data['usergroup_ids']) ? '' : implode(',', $page_data['usergroup_ids']);
}
$_data = $page_data;
if (isset($page_data['timestamp'])) {
$_data['timestamp'] = fn_parse_date($page_data['timestamp']);
}
if (isset($_data['localization'])) {
$_data['localization'] = empty($_data['localization']) ? '' : fn_implode_localizations($_data['localization']);
}
fn_set_company_id($_data);
if (empty($page_id)) {
// page title required
if (empty($page_data['page'])) {
return false;
}
// add new page
$_data['page_id'] = $page_id = db_query('INSERT INTO ?:pages ?e', $_data);
foreach ((array) Registry::get('languages') as $_data['lang_code'] => $v) {
db_query('INSERT INTO ?:page_descriptions ?e', $_data);
}
// now we need to update 'id_path' field, as we know $page_id
/* Generate id_path for page */
$parent_id = intval($_data['parent_id']);
if ($parent_id == 0) {
$id_path = $page_id;
} else {
$id_path = db_get_row("SELECT id_path FROM ?:pages WHERE page_id = ?i", $parent_id);
$id_path = $id_path['id_path'] . '/' . $page_id;
}
db_query('UPDATE ?:pages SET ?u WHERE page_id = ?i', array('id_path' => $id_path), $page_id);
} else {
if (!fn_check_company_id('pages', 'page_id', $page_id)) {
fn_company_access_denied_notification();
return false;
}
$old_company_id = fn_get_company_id('pages', 'page_id', $page_id);
if ($_data['company_id'] != $old_company_id) {
fn_change_page_company($page_id, $_data['company_id']);
}
// page title is not updated
if (empty($page_data['page'])) {
unset($page_data['page']);
}
// update existing page
db_query('UPDATE ?:pages SET ?u WHERE page_id = ?i', $_data, $page_id);
db_query('UPDATE ?:page_descriptions SET ?u WHERE page_id = ?i AND lang_code = ?s', $_data, $page_id, $lang_code);
// regenerate id_path for child pages
if (isset($page_data['parent_id'])) {
fn_change_page_parent($page_id, $page_data['parent_id']);
}
}
if (!empty($page_data['block_id'])) {
fn_add_items_to_block($page_data['block_id'], $page_data['add_items'], $page_id, 'pages');
}
fn_set_hook('update_page', $page_data, $page_id, $lang_code);
return $page_id;
}
/**
* Adds or updates category
*
* @param array $category_data Category data
* @param int $category_id Category identifier
* @param string $lang_code Two-letter language code (e.g. 'en', 'ru', etc.)
* @return int New or updated category identifier
*/
function fn_update_category($category_data, $category_id = 0, $lang_code = CART_LANGUAGE)
{
/**
* Update category data (running before fn_update_category() function)
*
* @param array $category_data Category data
* @param int $category_id Category identifier
* @param string $lang_code Two-letter language code (e.g. 'en', 'ru', etc.)
*/
fn_set_hook('update_category_pre', $category_data, $category_id, $lang_code);
// category title required
if (empty($category_data['category'])) {
//return false; // FIXME: management page doesn't have category name
}
if (isset($category_data['localization'])) {
$category_data['localization'] = empty($category_data['localization']) ? '' : fn_implode_localizations($category_data['localization']);
}
if (isset($category_data['usergroup_ids'])) {
$category_data['usergroup_ids'] = empty($category_data['usergroup_ids']) ? '0' : implode(',', $category_data['usergroup_ids']);
}
if (fn_allowed_for('ULTIMATE')) {
fn_set_company_id($category_data);
}
$_data = $category_data;
unset($_data['parent_id']);
if (isset($category_data['timestamp'])) {
$_data['timestamp'] = fn_parse_date($category_data['timestamp']);
}
if (isset($_data['position']) && empty($_data['position']) && $_data['position'] != '0' && isset($category_data['parent_id'])) {
$_data['position'] = db_get_field("SELECT max(position) FROM ?:categories WHERE parent_id = ?i", $category_data['parent_id']);
$_data['position'] = $_data['position'] + 10;
}
if (isset($_data['selected_layouts'])) {
$_data['selected_layouts'] = serialize($_data['selected_layouts']);
}
if (isset($_data['use_custom_templates']) && $_data['use_custom_templates'] == 'N') {
// Clear the layout settings if the category custom templates were disabled
$_data['product_columns'] = $_data['selected_layouts'] = $_data['default_layout'] = '';
}
// create new category
if (empty($category_id)) {
if (fn_allowed_for('ULTIMATE') && empty($_data['company_id'])) {
fn_set_notification('E', __('error'), __('need_company_id'));
return false;
}
$create = true;
$category_id = db_query("INSERT INTO ?:categories ?e", $_data);
$_data['category_id'] = $category_id;
foreach (fn_get_translation_languages() as $_data['lang_code'] => $v) {
db_query("INSERT INTO ?:category_descriptions ?e", $_data);
}
$category_data['parent_id'] = !empty($category_data['parent_id']) ? $category_data['parent_id'] : 0;
// update existing category
} else {
$category_data['old_company_id'] = db_get_field("SELECT company_id FROM ?:categories WHERE category_id = ?i", $category_id);
$arow = db_query("UPDATE ?:categories SET ?u WHERE category_id = ?i", $_data, $category_id);
$arow_description = db_query("UPDATE ?:category_descriptions SET ?u WHERE category_id = ?i AND lang_code = ?s", $_data, $category_id, $lang_code);
if ($arow === false && $arow_description === false) {
fn_set_notification('E', __('error'), __('object_not_found', array('[object]' => __('category'))), '', '404');
$category_id = false;
}
}
if ($category_id) {
// regenerate id_path for all child categories of the updated category
if (isset($category_data['parent_id'])) {
fn_change_category_parent($category_id, intval($category_data['parent_id']));
}
// Log category add/update
fn_log_event('categories', !empty($create) ? 'create' : 'update', array('category_id' => $category_id));
// Assign usergroup to all subcategories
if (!empty($_data['usergroup_to_subcats']) && $_data['usergroup_to_subcats'] == 'Y') {
$id_path = db_get_field("SELECT id_path FROM ?:categories WHERE category_id = ?i", $category_id);
db_query("UPDATE ?:categories SET usergroup_ids = ?s WHERE id_path LIKE ?l", $_data['usergroup_ids'], "{$id_path}/%");
}
}
/**
* Update category data (running after fn_update_category() function)
*
* @param array $category_data Category data
* @param int $category_id Category identifier
* @param string $lang_code Two-letter language code (e.g. 'en', 'ru', etc.)
*/
fn_set_hook('update_category_post', $category_data, $category_id, $lang_code);
return $category_id;
}
function fn_update_static_data($data, $param_id, $section, $lang_code = DESCR_SL)
{
$current_id_path = '';
$schema = fn_get_schema('static_data', 'schema');
$section_data = $schema[$section];
if (!empty($section_data['has_localization'])) {
$data['localization'] = empty($data['localization']) ? '' : fn_implode_localizations($data['localization']);
}
if (!empty($data['megabox'])) {
// parse megabox value
foreach ($data['megabox']['type'] as $p => $v) {
if (!empty($v)) {
$data[$p] = $v . ':' . intval($data[$p][$v]) . ':' . $data['megabox']['use_item'][$p];
} else {
$data[$p] = '';
}
}
}
if (!empty($param_id)) {
$current_id_path = db_get_field("SELECT id_path FROM ?:static_data WHERE param_id = ?i", $param_id);
db_query("UPDATE ?:static_data SET ?u WHERE param_id = ?i", $data, $param_id);
db_query('UPDATE ?:static_data_descriptions SET ?u WHERE param_id = ?i AND lang_code = ?s', $data, $param_id, $lang_code);
} else {
$data['section'] = $section;
$param_id = $data['param_id'] = db_query("INSERT INTO ?:static_data ?e", $data);
foreach ((array) Registry::get('languages') as $data['lang_code'] => $_v) {
db_query('REPLACE INTO ?:static_data_descriptions ?e', $data);
}
}
// Generate ID path
if (isset($data['parent_id'])) {
if (!empty($data['parent_id'])) {
$new_id_path = db_get_field("SELECT id_path FROM ?:static_data WHERE param_id = ?i", $data['parent_id']);
$new_id_path .= '/' . $param_id;
} else {
$new_id_path = $param_id;
}
if (!empty($current_id_path) && $current_id_path != $new_id_path) {
db_query("UPDATE ?:static_data SET id_path = CONCAT(?s, SUBSTRING(id_path, ?i)) WHERE id_path LIKE ?l", "{$new_id_path}/", strlen($current_id_path . '/') + 1, "{$current_id_path}/%");
}
db_query("UPDATE ?:static_data SET id_path = ?s WHERE param_id = ?i", $new_id_path, $param_id);
}
if (!empty($section_data['icon'])) {
fn_attach_image_pairs('static_data_icon', $section_data['icon']['type'], $param_id, $lang_code);
}
return $param_id;
}
function fn_update_shipping($data, $shipping_id, $lang_code = DESCR_SL)
{
$data['localization'] = empty($data['localization']) ? '' : fn_implode_localizations($data['localization']);
$data['tax_ids'] = !empty($data['tax_ids']) ? fn_create_set($data['tax_ids']) : '';
$data['usergroup_ids'] = empty($data['usergroup_ids']) ? '' : implode(',', $data['usergroup_ids']);
fn_set_hook('update_shipping', $data, $shipping_id, $lang_code);
if (!empty($shipping_id)) {
db_query("UPDATE ?:shippings SET ?u WHERE shipping_id = ?i", $data, $shipping_id);
db_query("UPDATE ?:shipping_descriptions SET ?u WHERE shipping_id = ?i AND lang_code = ?s", $data, $shipping_id, $lang_code);
} else {
$shipping_id = $data['shipping_id'] = db_query("INSERT INTO ?:shippings ?e", $data);
foreach ((array) Registry::get('languages') as $data['lang_code'] => $_v) {
db_query("INSERT INTO ?:shipping_descriptions ?e", $data);
}
}
if ($shipping_id) {
fn_attach_image_pairs('shipping', 'shipping', $shipping_id, $lang_code);
}
return $shipping_id;
}
db_query('UPDATE ?:store_locations SET ?u WHERE store_location_id = ?i', $entry, $key);
db_query('UPDATE ?:store_location_descriptions SET ?u WHERE store_location_id = ?i AND lang_code = ?s', $entry, $key, DESCR_SL);
}
}
}
$suffix .= '.manage';
}
if ($mode == 'add') {
if (!empty($_REQUEST['add_store_location'][0])) {
$data = $_REQUEST['add_store_location'][0];
if (!empty($data['name'])) {
if (empty($data['position'])) {
$data['position'] = db_get_field('SELECT MAX(position) FROM ?:store_locations');
$data['position'] += 10;
}
$data['localization'] = empty($data['localization']) ? '' : fn_implode_localizations($data['localization']);
$id = db_query('INSERT INTO ?:store_locations ?e', $data);
if ($id) {
$data['store_location_id'] = $id;
foreach ((array) Registry::get('languages') as $data['lang_code'] => $v) {
db_query("INSERT INTO ?:store_location_descriptions ?e", $data);
}
}
}
}
$suffix .= '.manage';
}
return array(CONTROLLER_STATUS_OK, 'store_locator' . $suffix);
}
if ($mode == 'delete') {
if (!empty($_REQUEST['store_location_id'])) {
function fn_update_store_location($store_location_data, $store_location_id, $lang_code = DESCR_SL)
{
$store_location_data['localization'] = empty($store_location_data['localization']) ? '' : fn_implode_localizations($store_location_data['localization']);
if (empty($store_location_id)) {
if (empty($store_location_data['position'])) {
$store_location_data['position'] = db_get_field('SELECT MAX(position) FROM ?:store_locations');
$store_location_data['position'] += 10;
}
$store_location_id = db_query('INSERT INTO ?:store_locations ?e', $store_location_data);
$store_location_data['store_location_id'] = $store_location_id;
foreach (fn_get_translation_languages() as $store_location_data['lang_code'] => $v) {
db_query("INSERT INTO ?:store_location_descriptions ?e", $store_location_data);
}
} else {
db_query('UPDATE ?:store_locations SET ?u WHERE store_location_id = ?i', $store_location_data, $store_location_id);
db_query('UPDATE ?:store_location_descriptions SET ?u WHERE store_location_id = ?i AND lang_code = ?s', $store_location_data, $store_location_id, $lang_code);
}
// Update main images pair
fn_attach_image_pairs('store_locations', 'store_locations', $store_location_id, $lang_code);
// Update additional images
fn_attach_image_pairs('store_locations_additional', 'store_locations', $store_location_id, $lang_code);
// Adding new additional images
fn_attach_image_pairs('store_locations_add_additional', 'store_locations', $store_location_id, $lang_code);
//die($store_location_id);
return $store_location_id;
}
function fn_update_postcode_location($postcode_location_data, $postcode_location_id, $lang_code = DESCR_SL)
{
$postcode_location_data['localization'] = empty($postcode_location_data['localization']) ? '' : fn_implode_localizations($postcode_location_data['localization']);
if (empty($postcode_location_id)) {
if (empty($postcode_location_data['position'])) {
$postcode_location_data['position'] = db_get_field('SELECT MAX(position) FROM ?:postcode_locations');
$postcode_location_data['position'] += 10;
}
$postcode_location_id = db_query('INSERT INTO ?:postcode_locations ?e', $postcode_location_data);
$postcode_location_data['postcode_location_id'] = $postcode_location_id;
foreach (fn_get_translation_languages() as $postcode_location_data['lang_code'] => $v) {
db_query("INSERT INTO ?:postcode_location_descriptions ?e", $postcode_location_data);
}
} else {
db_query('UPDATE ?:postcode_locations SET ?u WHERE postcode_location_id = ?i', $postcode_location_data, $postcode_location_id);
db_query('UPDATE ?:postcode_location_descriptions SET ?u WHERE postcode_location_id = ?i AND lang_code = ?s', $postcode_location_data, $postcode_location_id, $lang_code);
}
return $postcode_location_id;
}
function fn_update_news($news_id, $news_data, $lang_code = CART_LANGUAGE)
{
// news title required
if (empty($news_data['news'])) {
return false;
}
$_data = $news_data;
$_data['date'] = fn_parse_date($news_data['date']);
if (isset($_data['localization'])) {
$_data['localization'] = empty($_data['localization']) ? '' : fn_implode_localizations($_data['localization']);
}
if (empty($news_id)) {
$create = true;
$news_id = $_data['news_id'] = db_query("REPLACE INTO ?:news ?e", $_data);
if (empty($news_id)) {
return false;
}
// Adding descriptions
foreach ((array) Registry::get('languages') as $_data['lang_code'] => $v) {
db_query("INSERT INTO ?:news_descriptions ?e", $_data);
}
} else {
if (!empty($news_data['block_id'])) {
fn_add_items_to_block($news_data['block_id'], $news_data['add_items'], $news_id, 'news');
}
db_query("UPDATE ?:news SET ?u WHERE news_id = ?i", $_data, $news_id);
// update news descriptions
$_data = $news_data;
db_query("UPDATE ?:news_descriptions SET ?u WHERE news_id = ?i AND lang_code = ?s", $_data, $news_id, $lang_code);
}
// Log news update/add
fn_log_event('news', !empty($create) ? 'create' : 'update', array('news_id' => $news_id));
fn_set_hook('update_news', $news_data, $news_id, $lang_code);
return $news_id;
}
function fn_update_destination($data, $destination_id, $lang_code = DESCR_SL)
{
$data['localization'] = empty($data['localization']) ? '' : fn_implode_localizations($data['localization']);
if (!empty($destination_id)) {
db_query('UPDATE ?:destinations SET ?u WHERE destination_id = ?i', $data, $destination_id);
db_query('UPDATE ?:destination_descriptions SET ?u WHERE destination_id = ?i AND lang_code = ?s', $data, $destination_id, $lang_code);
db_query("DELETE FROM ?:destination_elements WHERE destination_id = ?i", $destination_id);
} else {
$destination_id = $data['destination_id'] = db_query("REPLACE INTO ?:destinations ?e", $data);
foreach (fn_get_translation_languages() as $data['lang_code'] => $_v) {
db_query("REPLACE INTO ?:destination_descriptions ?e", $data);
}
}
$_data = array('destination_id' => $destination_id);
if (!empty($data['states'])) {
$_data['element_type'] = 'S';
foreach ($data['states'] as $key => $_data['element']) {
db_query("INSERT INTO ?:destination_elements ?e", $_data);
}
}
if (!empty($data['countries'])) {
$_data['element_type'] = 'C';
foreach ($data['countries'] as $key => $_data['element']) {
db_query("INSERT INTO ?:destination_elements ?e", $_data);
}
}
if (!empty($data['zipcodes'])) {
$zipcodes = explode("\n", $data['zipcodes']);
$_data['element_type'] = 'Z';
foreach ($zipcodes as $key => $value) {
$value = trim($value);
if (!empty($value)) {
$_data['element'] = $value;
db_query("INSERT INTO ?:destination_elements ?e", $_data);
}
}
}
if (!empty($data['cities'])) {
$cities = explode("\n", $data['cities']);
$_data['element_type'] = 'T';
foreach ($cities as $key => $value) {
$value = trim($value);
if (!empty($value)) {
$_data['element'] = $value;
db_query("INSERT INTO ?:destination_elements ?e", $_data);
}
}
}
if (!empty($data['addresses'])) {
$addresses = explode("\n", $data['addresses']);
$_data['element_type'] = 'A';
foreach ($addresses as $key => $value) {
$value = trim($value);
if (!empty($value)) {
$_data['element'] = $value;
db_query("INSERT INTO ?:destination_elements ?e", $_data);
}
}
}
return $destination_id;
}
/**
* Create/Update shipping name
*
* @param array $shipping_data shipping info
* @param int $shipping_id shipping identifier
* @param string $lang_code 2-letter language code (e.g. 'en', 'ru', etc.)
* @return string Shipping name if shipping identifier is not null; false otherwise
*/
function fn_update_shipping($shipping_data, $shipping_id, $lang_code = DESCR_SL)
{
if (!empty($shipping_data['shipping']) || !empty($shipping_id)) {
$shipping_data['localization'] = empty($shipping_data['localization']) ? '' : fn_implode_localizations($shipping_data['localization']);
$shipping_data['tax_ids'] = !empty($shipping_data['tax_ids']) ? fn_create_set($shipping_data['tax_ids']) : '';
$shipping_data['usergroup_ids'] = empty($shipping_data['usergroup_ids']) ? USERGROUP_ALL : (is_array($shipping_data['usergroup_ids']) ? implode(',', $shipping_data['usergroup_ids']) : $shipping_data['usergroup_ids']);
unset($shipping_data['shipping_id']);
if (isset($shipping_data['rate_calculation']) && $shipping_data['rate_calculation'] == 'M') {
$shipping_data['service_id'] = 0;
$shipping_data['service_params'] = array();
}
if (isset($shipping_data['service_params'])) {
$shipping_data['service_params'] = serialize($shipping_data['service_params']);
}
fn_set_hook('update_shipping', $shipping_data, $shipping_id, $lang_code);
if (!empty($shipping_id)) {
$action = 'update';
$arow = db_query("UPDATE ?:shippings SET ?u WHERE shipping_id = ?i", $shipping_data, $shipping_id);
db_query("UPDATE ?:shipping_descriptions SET ?u WHERE shipping_id = ?i AND lang_code = ?s", $shipping_data, $shipping_id, $lang_code);
if ($arow === false) {
fn_set_notification('E', __('error'), __('object_not_found', array('[object]' => __('shipping'))), '', '404');
$shipping_id = false;
}
} else {
$action = 'add';
$shipping_id = $shipping_data['shipping_id'] = db_query("INSERT INTO ?:shippings ?e", $shipping_data);
foreach (fn_get_translation_languages() as $shipping_data['lang_code'] => $_v) {
db_query("INSERT INTO ?:shipping_descriptions ?e", $shipping_data);
}
}
fn_set_hook('update_shipping_post', $shipping_data, $shipping_id, $lang_code, $action);
if ($shipping_id) {
fn_attach_image_pairs('shipping', 'shipping', $shipping_id, $lang_code);
if (!empty($shipping_data['rates'])) {
fn_update_shipping_rates($shipping_data, $shipping_id);
}
}
}
return $shipping_id;
}
/**
* Updates page data by id or create new
*
* @param array $page_data Page data
* @param int $page_id Page idetifier, if equals zero new page will be created
* @param string $lang_code 2 letters language code
* @return int Page identifier on success, false otherwise
*/
function fn_update_page($page_data, $page_id = 0, $lang_code = CART_LANGUAGE)
{
/**
* Actions before all checks and initializations
*
* @param array $page_data Page data
* @param int $page_id Page idetifier, if equals zero new page will be created
* @param string $lang_code 2 letters language code
*/
fn_set_hook('update_page_pre', $page_data, $page_id, $lang_code);
if (!empty($page_id) && !fn_check_company_id('pages', 'page_id', $page_id)) {
fn_company_access_denied_notification();
return false;
}
if (!empty($page_data)) {
SecurityHelper::sanitizeObjectData('page', $page_data);
if (!empty($page_data['avail_from_timestamp'])) {
$page_data['avail_from_timestamp'] = fn_parse_date($page_data['avail_from_timestamp']);
} else {
$page_data['avail_from_timestamp'] = 0;
}
if (!empty($page_data['avail_till_timestamp'])) {
$page_data['avail_till_timestamp'] = fn_parse_date($page_data['avail_till_timestamp']) + 86399;
} else {
$page_data['avail_till_timestamp'] = 0;
}
if (isset($page_data['usergroup_ids'])) {
$page_data['usergroup_ids'] = empty($page_data['usergroup_ids']) ? '0' : implode(',', $page_data['usergroup_ids']);
}
$page_data['add_items'] = empty($page_data['add_items']) ? array() : $page_data['add_items'];
if (isset($page_data['timestamp'])) {
$page_data['timestamp'] = fn_parse_date($page_data['timestamp']);
}
if (isset($page_data['localization'])) {
$page_data['localization'] = empty($page_data['localization']) ? '' : fn_implode_localizations($page_data['localization']);
}
$old_page_data = array();
/**
* Actions after all checks and initializations and before update page
*
* @param array $page_data Page data
* @param int $page_id Page idetifier, if equals zero new page will be created
* @param string $lang_code 2 letters language code
*/
fn_set_hook('update_page_before', $page_data, $page_id, $lang_code);
$parent_id = isset($page_data['parent_id']) ? $page_data['parent_id'] : null;
unset($page_data['parent_id']);
if (empty($page_id)) {
// page title required
if (empty($page_data['page'])) {
return false;
}
// add new page
$create = true;
$page_data['page_id'] = $page_id = db_query('INSERT INTO ?:pages ?e', $page_data);
foreach (fn_get_translation_languages() as $page_data['lang_code'] => $v) {
db_query('INSERT INTO ?:page_descriptions ?e', $page_data);
}
} else {
$old_page_data = fn_get_page_data($page_id, $lang_code);
$create = false;
// page title is not updated
if (empty($page_data['page'])) {
unset($page_data['page']);
}
// update existing page
db_query('UPDATE ?:pages SET ?u WHERE page_id = ?i', $page_data, $page_id);
db_query('UPDATE ?:page_descriptions SET ?u WHERE page_id = ?i AND lang_code = ?s', $page_data, $page_id, $lang_code);
}
$page_data['parent_id'] = $parent_id;
// regenerate id_path for child pages
if (isset($page_data['parent_id'])) {
fn_change_page_parent($page_id, intval($page_data['parent_id']));
}
}
/**
* Actions after page update
*
* @param array $page_data Page data
* @param int $page_id Page idetifier, if equals zero new page will be created
* @param string $lang_code 2 letters language code
* @param bool $create True if page was created, falce otherwise
* @param array $old_page_data Page data before update
*/
fn_set_hook('update_page_post', $page_data, $page_id, $lang_code, $create, $old_page_data);
return $page_id;
}
function fn_update_category($category_data, $category_id = 0, $lang_code = CART_LANGUAGE)
{
// category title required
if (empty($category_data['category'])) {
//return false; // FIXME: management page doesn't have category name
}
if (isset($category_data['localization'])) {
$category_data['localization'] = empty($category_data['localization']) ? '' : fn_implode_localizations($category_data['localization']);
}
if (isset($category_data['usergroup_ids'])) {
$category_data['usergroup_ids'] = empty($category_data['usergroup_ids']) ? '' : implode(',', $category_data['usergroup_ids']);
}
$_data = $category_data;
if (isset($category_data['timestamp'])) {
$_data['timestamp'] = fn_parse_date($category_data['timestamp']);
}
if (empty($_data['position']) && isset($_data['parent_id'])) {
$_data['position'] = db_get_field("SELECT max(position) FROM ?:categories WHERE parent_id = ?i", $_data['parent_id']);
$_data['position'] = $_data['position'] + 10;
}
if (!empty($_data['selected_layouts'])) {
$_data['selected_layouts'] = serialize($_data['selected_layouts']);
}
if (isset($_data['use_custom_templates']) && $_data['use_custom_templates'] == 'N') {
// Clear the layout settings if the category custom templates were disabled
$_data['product_columns'] = $_data['selected_layouts'] = $_data['default_layout'] = '';
}
// create new category
if (empty($category_id)) {
$create = true;
$category_id = db_query("INSERT INTO ?:categories ?e", $_data);
if (empty($category_id)) {
return false;
}
// now we need to update 'id_path' field, as we know $category_id
/* Generate id_path for category */
$parent_id = intval($_data['parent_id']);
if ($parent_id == 0) {
$id_path = $category_id;
} else {
$id_path = db_get_row("SELECT id_path FROM ?:categories WHERE category_id = ?i", $parent_id);
$id_path = $id_path['id_path'] . '/' . $category_id;
}
db_query('UPDATE ?:categories SET ?u WHERE category_id = ?i', array('id_path' => $id_path), $category_id);
//
// Adding same category descriptions for all cart languages
//
$_data = $category_data;
$_data['category_id'] = $category_id;
foreach ((array) Registry::get('languages') as $_data['lang_code'] => $v) {
db_query("INSERT INTO ?:category_descriptions ?e", $_data);
}
// update existing category
} else {
/* regenerate id_path for all child categories of the updated category */
if (isset($category_data['parent_id'])) {
fn_change_category_parent($category_id, intval($category_data['parent_id']));
}
db_query("UPDATE ?:categories SET ?u WHERE category_id = ?i", $_data, $category_id);
$_data = $category_data;
db_query("UPDATE ?:category_descriptions SET ?u WHERE category_id = ?i AND lang_code = ?s", $_data, $category_id, $lang_code);
}
// Log category add/update
fn_log_event('categories', !empty($create) ? 'create' : 'update', array('category_id' => $category_id));
// Assign usergroup to all subcategories
if (!empty($category_data['usergroup_to_subcats']) && $category_data['usergroup_to_subcats'] == 'Y') {
$id_path = db_get_field("SELECT id_path FROM ?:categories WHERE category_id = ?i", $category_id);
db_query("UPDATE ?:categories SET usergroup_ids = ?s WHERE id_path LIKE ?l", $category_data['usergroup_ids'], "{$id_path}/%");
}
if (!empty($category_data['block_id'])) {
fn_add_items_to_block($category_data['block_id'], $category_data['add_items'], $category_id, 'categories');
}
fn_set_hook('update_category', $category_data, $category_id, $lang_code);
return $category_id;
}