$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; }