/**
* Вспомогательная рекурсивная функция для получения всех идентификаторов
* подразделов раздела с идентификатором $subdivision_id
* @param int $subdivision_id идентификатор раздела
* @return array идентификаторы подразделов
*/
function nc_get_subdivision_children($subdivision_id)
{
global $db;
$subdivision_id = intval($subdivision_id);
$parent_subs = $db->get_col("SELECT Subdivision_ID FROM Subdivision WHERE Parent_Sub_ID = {$subdivision_id}");
if (empty($parent_subs)) {
return array();
}
foreach ($parent_subs as $parent_sub_id) {
$parent_subs_array[] = $parent_sub_id;
$parent_subs_array = array_merge($parent_subs_array, nc_get_subdivision_children($parent_sub_id));
}
return $parent_subs_array;
}
function nc_copy_subdivision($sub_ids, $dest_catalogue_id, $dest_parent_sub_id, $with_child = 1, $with_сс = 1, $with_object = 1, $templates = array())
{
$nc_core = nc_Core::get_object();
global $db;
if (!is_array($sub_ids)) {
$sub_ids = array($sub_ids);
}
if (!$with_сс) {
$with_object = 0;
}
if (!$templates['sub_name']) {
$templates['sub_name'] = '%NAME%';
}
if (!$templates['sub_keyword']) {
$templates['sub_keyword'] = '%KEYWORD%';
}
if (!$templates['cc_name']) {
$templates['cc_name'] = '%NAME%';
}
if (!$templates['cc_keyword']) {
$templates['cc_keyword'] = '%KEYWORD%';
}
// разделы для копирования
$subdivisions = $db->get_results("SELECT * FROM `Subdivision`\n WHERE `Subdivision_ID` IN (" . join(',', $sub_ids) . ")\n ORDER BY `Subdivision_ID` ", ARRAY_A);
if (empty($subdivisions)) {
return 0;
}
if ($dest_parent_sub_id && in_array($dest_parent_sub_id, $sub_ids)) {
throw new Exception(TOOLS_COPYSUB_ERROR_LEVEL_COUNT);
}
// копирование в определенный раздел - можно вычислить сайт
if ($dest_parent_sub_id) {
$dest_subdivision = $db->get_row("SELECT `Catalogue_ID`, `Hidden_URL`, `EnglishName` FROM `Subdivision` WHERE `Subdivision_ID` = '" . $dest_parent_sub_id . "'", ARRAY_A);
$dest_catalogue_id = $dest_subdivision['Catalogue_ID'];
$hidden_url = $dest_subdivision['Hidden_URL'];
$english_name = $dest_subdivision['EnglishName'];
$child_english_names = $db->get_col("SELECT `EnglishName` FROM `Subdivision` WHERE `Parent_Sub_ID` = '" . $dest_parent_sub_id . "' ");
} else {
$hidden_url = '/';
$child_english_names = $db->get_col("SELECT `EnglishName` FROM `Subdivision` WHERE `Parent_Sub_ID` = '0' AND `Catalogue_ID` = '" . $dest_catalogue_id . "' ");
}
if (!$child_english_names) {
$child_english_names = array();
}
$fields = array_keys($subdivisions[0]);
$query_fields_subdivisions = array();
$insert_values_subdivisions = array();
unset($fields[0]);
foreach ($fields as $v) {
$query_fields_subdivisions[] = "`" . $v . "`";
}
foreach ($subdivisions as $subdivision) {
$rel[$subdivision['Subdivision_ID']] = 0;
// связка между старыми и новыми id
$subdivision['Subdivision_Name'] = str_replace('%NAME%', $subdivision['Subdivision_Name'], $templates['sub_name']);
$subdivision['Subdivision_Name'] = str_replace('%KEYWORD%', $subdivision['EnglishName'], $subdivision['Subdivision_Name']);
$subdivision['EnglishName'] = str_replace('%KEYWORD%', $subdivision['EnglishName'], $templates['sub_keyword']);
$subdivision['Parent_Sub_ID'] = $dest_parent_sub_id;
$subdivision['Catalogue_ID'] = $dest_catalogue_id;
$subdivision['Created'] = $subdivision['LastUpdated'] = date("Y-m-d H:i:s");
$subdivision['Hidden_URL'] = $hidden_url . $subdivision['EnglishName'] . '/';
if (!$nc_core->subdivision->validate_english_name($subdivision['EnglishName'])) {
throw new Exception(CONTROL_CONTENT_SUBDIVISION_INDEX_ERROR_THREE_KEYWORD_INVALID . "<br/>" . $subdivision['EnglishName']);
}
//if ( $english_name == $subdivision['EnglishName'] ) {
// throw new Exception(TOOLS_COPYSUB_ERROR_KEYWORD_EXIST);
//}
if (in_array($subdivision['EnglishName'], $child_english_names)) {
throw new Exception(TOOLS_COPYSUB_ERROR_KEYWORD_EXIST);
}
// нельзя скопировать раздел в подраздел этого же раздела
if ($dest_parent_sub_id) {
$childs = nc_get_subdivision_children($subdivision['Subdivision_ID']);
if (!empty($childs) && in_array($dest_parent_sub_id, $childs)) {
throw new Exception(TOOLS_COPYSUB_ERROR_LEVEL_COUNT);
}
}
$query_values = array();
foreach ($fields as $v) {
$query_values[] = "'" . $db->escape($subdivision[$v]) . "'";
}
$insert_values_subdivisions[$subdivision['Subdivision_ID']] = "(" . join(',', $query_values) . ")";
}
$nc_core->event->execute("addSubdivisionPrep", $dest_catalogue_id, 0);
foreach ($insert_values_subdivisions as $Subdivision_ID => $insert_value_subdivisions) {
$db->query("INSERT INTO `Subdivision` (" . join(',', $query_fields_subdivisions) . ") VALUES {$insert_value_subdivisions}");
if ($db->is_error) {
throw new nc_Exception_DB_Error($db->last_query, $db->last_error);
}
$inserted_id = $db->insert_id;
$rel[$Subdivision_ID] = $inserted_id;
if (!is_dir($nc_core->FILES_FOLDER . $inserted_id)) {
@mkdir($nc_core->FILES_FOLDER . $inserted_id, $nc_core->DIRCHMOD);
@chmod($nc_core->FILES_FOLDER . $inserted_id, $nc_core->DIRCHMOD);
}
}
$nc_core->event->execute("addSubdivision", $dest_catalogue_id, $rel);
// компоненты в разделе для копирования
$sub_classes = !$with_сс ? null : $db->get_results("SELECT * FROM `Sub_Class`\n WHERE `Subdivision_ID` IN (" . join(',', $sub_ids) . ")\n ORDER BY `Sub_Class_ID`", ARRAY_A);
$query_fields_subclasses = array();
$insert_values_subclasses = array();
if (!empty($sub_classes)) {
$fields = array_keys($sub_classes[0]);
unset($fields[0]);
foreach ($fields as $v) {
$query_fields_subclasses[] = "`" . $v . "`";
}
foreach ($sub_classes as $sub_class) {
$rel_cc[$sub_class['Sub_Class_ID']] = 0;
$sub_class['Subdivision_ID'] = $rel[$sub_class['Subdivision_ID']];
$sub_class['Sub_Class_Name'] = str_replace('%NAME%', $sub_class['Sub_Class_Name'], $templates['cc_name']);
$sub_class['EnglishName'] = str_replace('%KEYWORD%', $sub_class['EnglishName'], $templates['cc_keyword']);
$sub_class['Created'] = $sub_class['LastUpdated'] = date("Y-m-d H:i:s");
$sub_class['Catalogue_ID'] = $dest_catalogue_id;
if (!$nc_core->sub_class->validate_english_name($sub_class['EnglishName'])) {
throw new Exception(CONTROL_CONTENT_SUBDIVISION_INDEX_ERROR_THREE_KEYWORD_INVALID . "<br/>" . $sub_class['EnglishName']);
}
$query_values = array();
foreach ($fields as $v) {
$query_values[] = "'" . $db->escape($sub_class[$v]) . "'";
}
$insert_values_subclasses[$sub_class['Sub_Class_ID']] = "(" . join(',', $query_values) . ")";
}
foreach ($sub_classes as $sub_class) {
$nc_core->event->execute("addSubClassPrep", $dest_catalogue_id, $sub_class['Subdivision_ID'], 0);
$db->query("INSERT INTO `Sub_Class` (" . join(',', $query_fields_subclasses) . ") VALUES {$insert_values_subclasses[$sub_class['Sub_Class_ID']]}");
if ($db->is_error) {
throw new nc_Exception_DB_Error($db->last_query, $db->last_error);
}
$inserted_id = $db->insert_id;
$k = $sub_class['Sub_Class_ID'];
$rel_cc[$k] = $inserted_id;
$class_id = $sub_class['Class_ID'];
$is_system_table = $db->get_var("SELECT `System_Table_ID` FROM `Class` WHERE `Class_ID` = '" . $class_id . "' ");
$sub_id = $rel[$sub_class['Subdivision_ID']];
$nc_core->event->execute("addSubClass", $dest_catalogue_id, $sub_id, $rel_cc[$k]);
if (!is_dir($nc_core->FILES_FOLDER . $sub_id . "/" . $rel_cc[$k])) {
@mkdir($nc_core->FILES_FOLDER . $sub_id . "/" . $rel_cc[$k], $nc_core->DIRCHMOD);
@chmod($nc_core->FILES_FOLDER . $sub_id . "/" . $rel_cc[$k], $nc_core->DIRCHMOD);
}
// объекты для копирования
$messages = !$with_object || $is_system_table ? null : $db->get_results("SELECT * FROM `Message" . $class_id . "` WHERE `Sub_Class_ID` = '" . $k . "' ORDER BY `Message_ID`", ARRAY_A);
$query_fields_messages = array();
$insert_values_messages = array();
if (!empty($messages)) {
$fields = array_keys($messages[0]);
unset($fields[0]);
foreach ($fields as $v) {
$query_fields_messages[] = "`" . $v . "`";
}
$msg_ids = array();
$rel_message = array();
foreach ($messages as $message) {
$rel_message[$message['Message_ID']] = 0;
$message['Subdivision_ID'] = $rel[$message['Subdivision_ID']];
$message['Sub_Class_ID'] = $rel_cc[$message['Sub_Class_ID']];
$message['Created'] = $message['LastUpdated'] = date("Y-m-d H:i:s");
$msg_ids[] = $message['Message_ID'];
$query_values = array();
foreach ($fields as $v) {
$query_values[] = "'" . $db->escape($message[$v]) . "'";
}
$insert_values_messages[$message['Message_ID']] = "(" . join(',', $query_values) . ")";
}
// копирование файлов объекта
$file_fields = array();
$tmp = $db->get_results("SELECT `Field_ID` AS `id`, `Field_Name` AS `name` FROM `Field` WHERE `Class_ID`='" . $class_id . "' AND `TypeOfData_ID` = '6' ", ARRAY_A);
if ($tmp) {
foreach ($tmp as $v) {
$file_fields[$v['id']] = $v['name'];
}
$filetable = $db->get_results("SELECT * FROM `Filetable`\n WHERE `Field_ID` IN (" . join(',', array_keys($file_fields)) . ")\n AND `Message_ID` IN (" . join(',', $msg_ids) . ") ", ARRAY_A);
}
// Поля типа "множественная загрузка" в компоненте
$multifile_fields = $db->get_results("SELECT `Field_ID`, `Format`, `Field_Name`\n FROM `Field`\n WHERE Class_ID='" . $class_id . "'\n AND TypeOfData_ID='" . NC_FIELDTYPE_MULTIFILE . "'", ARRAY_A);
foreach ($messages as $message) {
$message_id = $message['Message_ID'];
// событие
$nc_core->event->execute("addMessagePrep", $dest_catalogue_id, $rel[$message['Subdivision_ID']], $rel_cc[$message['Sub_Class_ID']], $class_id, 0);
$db->query("INSERT INTO `Message" . $class_id . "` (" . join(',', $query_fields_messages) . ") VALUES {$insert_values_messages[$message_id]}");
if ($db->is_error) {
throw new nc_Exception_DB_Error($db->last_query, $db->last_error);
}
$inserted_id = $db->insert_id;
$k = $message_id;
$rel_message[$k] = $inserted_id;
// событие
$nc_core->event->execute("addMessage", $dest_catalogue_id, $rel[$message['Subdivision_ID']], $rel_cc[$message['Sub_Class_ID']], $class_id, $rel_message[$message_id]);
if (!empty($file_fields)) {
foreach ($file_fields as $field_id => $field_name) {
if ($value = $message[$field_name]) {
$is_copy = 0;
if (!empty($filetable)) {
foreach ($filetable as $v) {
if ($v['Message_ID'] == $message_id && $v['Field_ID'] == $field_id) {
$file_path = rtrim($nc_core->FILES_FOLDER, '/') . $v['File_Path'] . $v['Virt_Name'];
$new_name = md5($file_path . date("H:i:s d.m.Y") . uniqid("netcat"));
$new_file_path = $rel[$message['Subdivision_ID']] . "/" . $rel_cc[$message['Sub_Class_ID']];
@copy($file_path, $nc_core->FILES_FOLDER . $new_file_path . "/" . $new_name);
$to_filetable[] = "('" . $db->escape($v['Real_Name']) . "', '" . $new_name . "', '/" . $new_file_path . "/',\n '" . $v['File_Type'] . "', '" . $v['File_Size'] . "', '" . $rel_message[$message_id] . "',\n '" . $field_id . "', '" . $v['Content_Disposition'] . "')";
$is_copy = 1;
}
}
}
if ($is_copy) {
continue;
}
$file_data = explode(':', $value);
$file_name = $file_data[0];
$ext = nc_substr($file_name, nc_strrpos($file_name, "."));
// расширение файла
if ($file_data[3]) {
$new_name = nc_get_filename_for_original_fs($file_name, $nc_core->FILES_FOLDER . $rel[$message['Subdivision_ID']] . "/" . $rel_cc[$message['Sub_Class_ID']] . "/");
@copy($nc_core->FILES_FOLDER . $file_data[3], $nc_core->FILES_FOLDER . $rel[$message['Subdivision_ID']] . "/" . $rel_cc[$message['Sub_Class_ID']] . "/" . $new_name);
$dt = $file_data[0] . ":" . $file_data[1] . ":" . $file_data[2] . ":" . $rel[$message['Subdivision_ID']] . "/" . $rel_cc[$message['Sub_Class_ID']] . "/" . $new_name;
$db->query("UPDATE `Message" . $class_id . "` SET `" . $field_name . "` = '" . $dt . "' WHERE `Message_ID` = '" . $rel_message[$message_id] . "' ");
} else {
@copy($nc_core->FILES_FOLDER . $field_id . "_" . $message_id . $ext, $nc_core->FILES_FOLDER . $field_id . "_" . $rel_message[$message_id] . $ext);
}
}
}
}
// проходим по каждому полю
foreach ((array) $multifile_fields as $field) {
$field_id = (int) $field['Field_ID'];
$settings_http_path = nc_standardize_path_to_folder($nc_core->HTTP_FILES_PATH . "/multifile/{$field_id}/");
$settings_path = nc_standardize_path_to_folder($nc_core->DOCUMENT_ROOT . '/' . $nc_core->SUB_FOLDER . '/' . $settings_http_path);
//получаем список файлов
$sql = "SELECT `Priority`, `Name`, `Size`, `Path`, `Preview` FROM `Multifield` WHERE `Field_ID` = {$field_id} AND `Message_ID` = {$message_id}";
$files = $db->get_results($sql, ARRAY_A);
foreach ((array) $files as $file) {
foreach (array('Path', 'Preview') as $path) {
$file_path = $file[$path];
if ($file_path) {
$parts = explode('/', nc_standardize_path_to_file($file_path));
$file_name = array_pop($parts);
$new_file_name = nc_get_filename_for_original_fs($file_name, $settings_path);
@copy($settings_path . $file_name, $settings_path . $new_file_name);
$file[$path] = $settings_http_path . $new_file_name;
}
}
$priority = (int) $file['Priority'];
$name = $db->escape($file['Name']);
$size = (int) $file['Size'];
$path = $db->escape($file['Path']);
$preview = $db->escape($file['Preview']);
$sql = "INSERT INTO `Multifield` (`Field_ID`, `Message_ID`, `Priority`, `Name`, `Size`, `Path`, `Preview`) VALUES " . "({$field_id}, {$rel_message[$message_id]}, {$priority}, '{$name}', {$size}, '{$path}', '{$preview}')";
$db->query($sql);
}
}
}
}
}
}
//при копировании разделов проставлялись нули, если поле RecordsPerPage было не заполнено
$sub_cc_ids = join(', ', (array) $rel_cc);
if (!empty($sub_cc_ids)) {
$db->query("UPDATE `Sub_Class`\n SET `RecordsPerPage` = NULL\n WHERE `RecordsPerPage`= 0\n AND `Sub_Class_ID` IN ({$sub_cc_ids})");
}
// копирование файлов
$system_fields = $nc_core->get_system_table_fields("Subdivision");
$file_fields = array();
if (!empty($system_fields)) {
foreach ($system_fields as $v) {
if ($v['type'] == 6) {
$file_fields[$v['id']] = $v['name'];
}
}
}
if (!empty($file_fields)) {
$filetable = $db->get_results("SELECT * FROM `Filetable`\n WHERE `Field_ID` IN (" . join(',', array_keys($file_fields)) . ")\n AND `Message_ID` IN (" . join(',', $sub_ids) . ") ", ARRAY_A);
foreach ($subdivisions as $subdivision) {
$sub_id = $subdivision['Subdivision_ID'];
foreach ($file_fields as $field_id => $field_name) {
if ($value = $subdivision[$field_name]) {
$is_copy = 0;
if (!empty($filetable)) {
foreach ($filetable as $v) {
if ($v['Message_ID'] == $sub_id && $v['Field_ID'] == $field_id) {
$file_path = rtrim($nc_core->FILES_FOLDER, '/') . $v['File_Path'] . $v['Virt_Name'];
$new_name = md5($file_path . date("H:i:s d.m.Y") . uniqid("netcat"));
@copy($file_path, $nc_core->FILES_FOLDER . $rel[$sub_id] . "/" . $new_name);
$to_filetable[] = " ('" . $db->escape($v['Real_Name']) . "', '" . $new_name . "', '/" . $rel[$sub_id] . "/',\n '" . $v['File_Type'] . "', '" . $v['File_Size'] . "', '" . $rel[$sub_id] . "',\n '" . $field_id . "', '" . $v['Content_Disposition'] . "')";
// $db->debug();
$is_copy = 1;
}
}
}
if ($is_copy) {
continue;
}
$file_data = explode(':', $value);
$file_name = $file_data[0];
$ext = nc_substr($file_name, nc_strrpos($file_name, "."));
// расширение файла
if ($file_data[3]) {
$new_name = nc_get_filename_for_original_fs($file_name, $nc_core->FILES_FOLDER . $rel[$sub_id] . "/");
@copy($nc_core->FILES_FOLDER . $file_data[3], $nc_core->FILES_FOLDER . $rel[$sub_id] . "/" . $new_name);
$dt = $file_data[0] . ":" . $file_data[1] . ":" . $file_data[3] . ":" . $rel[$sub_id] . "/" . $new_name;
$db->query("UPDATE `Subdivision` SET `" . $field_name . "` = '" . $dt . "' WHERE `Subdivision_ID` = '" . $rel[$sub_id] . "' ");
// $db->debug();
} else {
@copy($nc_core->FILES_FOLDER . $field_id . "_" . $sub_id . $ext, $nc_core->FILES_FOLDER . $field_id . "_" . $rel[$sub_id] . $ext);
}
}
}
}
}
// update filetable
if (!empty($to_filetable)) {
$db->query("INSERT INTO `Filetable` (`Real_Name`, `Virt_Name`, `File_Path`,\n `File_Type`, `File_Size`, `Message_ID`, `Field_ID`, `Content_Disposition` )\n VALUES " . join(',', $to_filetable) . " ");
}
// рекурсивное копирование подразделов
if ($with_child) {
foreach ($rel as $k => $v) {
$childs = $db->get_col("SELECT `Subdivision_ID` FROM `Subdivision` WHERE `Parent_Sub_ID` = '" . $k . "' ");
if ($childs) {
nc_copy_subdivision($childs, 0, $v, $with_child, $with_сс, $with_object, $templates);
}
}
}
return 0;
}
