$db->query("UPDATE `Sub_Class` SET `Catalogue_ID` = '" . $target['Catalogue_ID'] . "' WHERE `Subdivision_ID` = '" . $v . "'");
// execute core action
$nc_core->event->execute("updateSubClass", $target['Catalogue_ID'], $v, $subclasses);
}
}
}
$subclasses = $db->get_col("SELECT `Sub_Class_ID` FROM `Sub_Class` WHERE `Subdivision_ID` = '" . $dragged['Subdivision_ID'] . "'");
if (!empty($subclasses)) {
// execute core action
$nc_core->event->execute("updateSubClassPrep", $target['Catalogue_ID'], $dragged['Subdivision_ID'], $subclasses);
$db->query("UPDATE `Sub_Class`\n SET `Catalogue_ID` = '" . $target['Catalogue_ID'] . "'\n WHERE `Subdivision_ID` = '" . $dragged['Subdivision_ID'] . "'");
// execute core action
$nc_core->event->execute("updateSubClass", $target['Catalogue_ID'], $dragged['Subdivision_ID'], $subclasses);
}
if ($target_type == 'site' && $target['Catalogue_ID'] != $dragged['Catalogue_ID']) {
$parent_subs_array = GetChildrenSub($dragged['Subdivision_ID']);
if (!empty($parent_subs_array)) {
// execute core action
$nc_core->event->execute("updateSubdivisionPrep", $target['Catalogue_ID'], $parent_subs_array);
$db->query("UPDATE `Subdivision` SET `Catalogue_ID` = '" . $target['Catalogue_ID'] . "' WHERE `Subdivision_ID` IN (" . join(', ', $parent_subs_array) . ")");
// execute core action
$nc_core->event->execute("updateSubdivision", $target['Catalogue_ID'], $parent_subs_array);
foreach ($parent_subs_array as $value) {
// get subclass
$subclasses = $db->get_col("SELECT `Sub_Class_ID` FROM `Sub_Class` WHERE `Subdivision_ID` = '" . $value . "'");
if (!empty($subclasses)) {
// execute core action
$nc_core->event->execute("updateSubClassPrep", $target['Catalogue_ID'], $value, $subclasses);
$db->query("UPDATE `Sub_Class` SET `Catalogue_ID` = '" . $target['Catalogue_ID'] . "' WHERE `Sub_Class_ID` IN (" . join(", ", $subclasses) . ")");
// execute core action
$nc_core->event->execute("updateSubClass", $target['Catalogue_ID'], $value, $subclasses);
/**
* Return all sub childrens
*
* @param mixed parent sub
* @return array array with sub id
*/
function GetChildrenSub($sub)
{
global $db;
$sub = (array) $sub;
if (empty($sub)) {
return;
}
$ret = $db->get_col("SELECT `Subdivision_ID` FROM `Subdivision` WHERE `Parent_Sub_ID` IN (" . join(", ", $sub) . ")");
if (empty($ret)) {
return;
}
$ret = array_merge($ret, (array) GetChildrenSub($ret));
return $ret;
}
