/** * 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_exim_1c_update_category($category_data, $category_id, $lang_code) { $_data = $category_data; unset($_data['parent_id']); $_data['timestamp'] = fn_parse_date($category_data['timestamp']); if (empty($category_id)) { $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; } else { db_query("UPDATE ?:categories SET ?u WHERE category_id = ?i", $_data, $category_id); db_query("UPDATE ?:category_descriptions SET ?u WHERE category_id = ?i AND lang_code = ?s", $_data, $category_id, $lang_code); } if ($category_id) { if (isset($category_data['parent_id'])) { fn_change_category_parent($category_id, intval($category_data['parent_id'])); } } return $category_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; }