function fn_get_seo_rules($params = array(), $items_per_page = 0, $lang_code = DESCR_SL)
{
$lang_code = fn_get_corrected_seo_lang_code($lang_code);
$global_total = db_get_fields("SELECT dispatch FROM ?:seo_names WHERE object_id = '0' AND type = 's' GROUP BY dispatch");
$local_total = db_get_fields("SELECT dispatch FROM ?:seo_names WHERE object_id = '0' AND type = 's' AND lang_code = ?s", $lang_code);
if ($diff = array_diff($global_total, $local_total)) {
foreach ($diff as $disp) {
fn_create_seo_name(0, 's', str_replace('.', '-', $disp), 0, $disp, DESCR_SL);
}
}
// Init filter
$params = fn_init_view('seo_rules', $params);
// Set default values to input params
$params['page'] = empty($params['page']) ? 1 : $params['page'];
// default page is 1
$condition = '';
if (isset($params['name']) && fn_string_no_empty($params['name'])) {
$condition .= db_quote(" AND name LIKE ?l", "%" . trim($params['name']) . "%");
}
if (isset($params['controller']) && fn_string_no_empty($params['controller'])) {
$condition .= db_quote(" AND dispatch LIKE ?l", "%" . trim($params['controller']) . "%");
}
$limit = '';
if (!empty($items_per_page)) {
$total = db_get_field("SELECT COUNT(*) FROM ?:seo_names WHERE object_id = '0' AND type = 's' AND lang_code = ?s ?p", $lang_code, $condition);
$limit = fn_paginate($params['page'], $total, $items_per_page);
}
$seo_data = db_get_array("SELECT name, dispatch FROM ?:seo_names WHERE object_id = '0' AND type = 's' AND lang_code = ?s ?p ORDER BY dispatch {$limit}", $lang_code, $condition);
return array($seo_data, $params);
}
function fn_get_seo_rules($params = array(), $items_per_page = 0, $lang_code = DESCR_SL)
{
$condition = fn_get_seo_company_condition('?:seo_names.company_id');
$lang_code = fn_get_corrected_seo_lang_code($lang_code);
$global_total = db_get_fields("SELECT dispatch FROM ?:seo_names WHERE object_id = '0' AND type = 's' ?p GROUP BY dispatch", $condition);
$local_total = db_get_fields("SELECT dispatch FROM ?:seo_names WHERE object_id = '0' AND type = 's' AND lang_code = ?s ?p", $lang_code, $condition);
if ($diff = array_diff($global_total, $local_total)) {
foreach ($diff as $disp) {
fn_create_seo_name(0, 's', str_replace('.', '-', $disp), 0, $disp, '', DESCR_SL);
}
}
// Init filter
$params = LastView::instance()->update('seo_rules', $params);
// Set default values to input params
$default_params = array('page' => 1, 'items_per_page' => $items_per_page);
$params = array_merge($default_params, $params);
if (isset($params['name']) && fn_string_not_empty($params['name'])) {
$condition .= db_quote(" AND name LIKE ?l", "%" . trim($params['name']) . "%");
}
if (isset($params['rule_params']) && fn_string_not_empty($params['rule_params'])) {
$condition .= db_quote(" AND dispatch LIKE ?l", "%" . trim($params['rule_params']) . "%");
}
$limit = '';
if (!empty($params['items_per_page'])) {
$params['total_items'] = db_get_field("SELECT COUNT(*) FROM ?:seo_names WHERE object_id = '0' AND type = 's' AND lang_code = ?s ?p", $lang_code, $condition);
$limit = db_paginate($params['page'], $params['items_per_page'], $params['total_items']);
}
$seo_data = db_get_array("SELECT name, dispatch FROM ?:seo_names WHERE object_id = '0' AND type = 's' AND lang_code = ?s ?p ORDER BY dispatch {$limit}", $lang_code, $condition);
return array($seo_data, $params);
}
/**
* Generates SEO name for imported product
*
* @param int $object_id Product identificator
* @param int $object_type One-letter object type identificator
* @param string $object_name SEO-name to import with
* @param array $product_name Product name for specified language code
* @param int $index
* @param string $dispatch
* @param string $company_id Company identifier
* @param string $lang_code Two-letter language code
* @param string $company_name Company name product imported for
* @return array SEO name for specified language code
*/
function fn_create_import_seo_name($object_id, $object_type = 'p', $object_name, $product_name, $index = 0, $dispatch = '', $company_id = '', $lang_code = CART_LANGUAGE, $company_name = '')
{
if (empty($company_id) && !empty($company_name) && !Registry::get('runtime.company_id')) {
$company_id = fn_get_company_id_by_name($company_name);
}
if (!is_array($object_name)) {
$object_name = array($lang_code => $object_name);
}
$result = array();
foreach ($object_name as $name_lang_code => $seo_name) {
if (empty($seo_name)) {
$seo_name = reset($product_name);
}
$result[$name_lang_code] = fn_create_seo_name($object_id, $object_type, $seo_name, $index, $dispatch, $company_id, $name_lang_code);
}
return $result;
}
function fn_seo_settings_update($type, $option, $new_value, $redirect_only)
{
$old_value = Registry::get('addons.seo.' . $option);
fn_iterate_through_seo_names(function ($seo_name) use($option, $old_value, $new_value, $redirect_only) {
// We shouldn't consider null value
if (false === fn_check_seo_object_exists($seo_name['object_id'], $seo_name['type'], $seo_name['company_id'])) {
fn_delete_seo_name($seo_name['object_id'], $seo_name['type'], '', $seo_name['company_id']);
return;
}
Registry::set('addons.seo.' . $option, $old_value);
$url = fn_generate_seo_url_from_schema(array('type' => $seo_name['type'], 'object_id' => $seo_name['object_id'], 'lang_code' => $seo_name['lang_code']), false);
fn_seo_update_redirect(array('src' => $url, 'type' => $seo_name['type'], 'object_id' => $seo_name['object_id'], 'company_id' => $seo_name['company_id'], 'lang_code' => $seo_name['lang_code']), 0, false);
if (!$redirect_only) {
Registry::set('addons.seo.' . $option, $new_value);
fn_create_seo_name($seo_name['object_id'], $seo_name['type'], $seo_name['name'], 0, '', $seo_name['company_id'], $seo_name['lang_code'], true);
}
}, db_quote("type = ?s ?p", $type, fn_get_seo_company_condition('?:seo_names.company_id', $type)));
}
function fn_seo_settings_update($type, $option, $new_value, $redirect_only)
{
$i = 0;
$items_per_pass = 100;
$old_value = Registry::get('addons.seo.' . $option);
$company_condition = fn_get_seo_company_condition('?:seo_names.company_id', $type);
while ($update_data = db_get_array("SELECT * FROM ?:seo_names WHERE type = ?s ?p LIMIT {$i}, {$items_per_pass}", $type, $company_condition)) {
foreach ($update_data as $data) {
Registry::set('addons.seo.' . $option, $old_value);
$url = fn_generate_seo_url_from_schema(array('type' => $data['type'], 'object_id' => $data['object_id'], 'lang_code' => $data['lang_code']), false);
fn_seo_update_redirect(array('src' => $url, 'type' => $data['type'], 'object_id' => $data['object_id'], 'company_id' => $data['company_id'], 'lang_code' => $data['lang_code']), 0, false);
if (!$redirect_only) {
Registry::set('addons.seo.' . $option, $new_value);
fn_create_seo_name($data['object_id'], $data['type'], $data['name'], 0, '', $data['company_id'], $data['lang_code'], true);
}
}
$i += $items_per_pass;
}
}
die('Access denied');
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
// Delete seo names
if ($mode == 'delete_languages') {
if (!empty($_REQUEST['lang_codes'])) {
foreach ((array) $_REQUEST['lang_codes'] as $v) {
db_query("DELETE FROM ?:seo_names WHERE lang_code = ?s", $v);
}
}
}
// Add static seo rules
if ($mode == 'add_languages') {
$new_language = $_REQUEST['new_language'];
if (!empty($new_language['lang_code']) && !empty($new_language['name'])) {
$is_exists = db_get_field("SELECT COUNT(*) FROM ?:seo_names WHERE lang_code = ?s", $new_language['lang_code']);
if (empty($is_exists)) {
$global_total = db_get_fields("SELECT dispatch FROM ?:seo_names WHERE object_id = '0' AND type = 's' GROUP BY dispatch");
foreach ($global_total as $disp) {
fn_create_seo_name(0, 's', str_replace('.', '-', $disp), 0, $disp, $new_language['lang_code']);
}
}
}
}
}
// Delete seo names
if ($mode == 'delete_language') {
if (!empty($_REQUEST['lang_code'])) {
db_query("DELETE FROM ?:seo_names WHERE lang_code = ?s", $_REQUEST['lang_code']);
}
}
function fn_seo_update_language_post(&$language_data, &$lang_id, &$action)
{
if ($action == 'update') {
return false;
}
$condition = fn_get_seo_company_condition('?:seo_names.company_id');
if (!empty($language_data['lang_code'])) {
$is_exists = db_get_field("SELECT COUNT(*) FROM ?:seo_names WHERE lang_code = ?s ?p", $language_data['lang_code'], $condition);
if (empty($is_exists)) {
$global_total = db_get_fields("SELECT dispatch FROM ?:seo_names WHERE object_id = '0' AND type = 's' ?p GROUP BY dispatch", $condition);
foreach ($global_total as $disp) {
fn_create_seo_name(0, 's', str_replace('.', '-', $disp), 0, $disp, '', $language_data['lang_code']);
}
}
}
}
