chamilo /
chamilo-lms
| @@ 180-199 (lines=20) @@ | ||
| 177 | * @param int $relation_type |
|
| 178 | * @return resource |
|
| 179 | **/ |
|
| 180 | public static function set_parent_group($group_id, $parent_group_id, $relation_type = 1) |
|
| 181 | { |
|
| 182 | $table = Database :: get_main_table(TABLE_MAIN_GROUP_REL_GROUP); |
|
| 183 | $group_id = intval($group_id); |
|
| 184 | $parent_group_id = intval($parent_group_id); |
|
| 185 | if ($parent_group_id == 0) { |
|
| 186 | $sql = "DELETE FROM $table WHERE subgroup_id = $group_id"; |
|
| 187 | } else { |
|
| 188 | $sql = "SELECT group_id FROM $table WHERE subgroup_id = $group_id"; |
|
| 189 | $res = Database::query($sql); |
|
| 190 | if (Database::num_rows($res) == 0) { |
|
| 191 | $sql = "INSERT INTO $table SET group_id = $parent_group_id, subgroup_id = $group_id, relation_type = $relation_type"; |
|
| 192 | } else { |
|
| 193 | $sql = "UPDATE $table SET group_id = $parent_group_id, relation_type = $relation_type |
|
| 194 | WHERE subgroup_id = $group_id"; |
|
| 195 | } |
|
| 196 | } |
|
| 197 | $res = Database::query($sql); |
|
| 198 | return $res; |
|
| 199 | } |
|
| 200 | ||
| 201 | /** |
|
| 202 | * Get the parent group |
|
| @@ 2334-2358 (lines=25) @@ | ||
| 2331 | * @param int $relation_type |
|
| 2332 | * @return resource |
|
| 2333 | **/ |
|
| 2334 | public static function set_parent_group($group_id, $parent_group_id, $relation_type = 1) |
|
| 2335 | { |
|
| 2336 | $table = Database :: get_main_table(TABLE_USERGROUP_REL_USERGROUP); |
|
| 2337 | $group_id = intval($group_id); |
|
| 2338 | $parent_group_id = intval($parent_group_id); |
|
| 2339 | if ($parent_group_id == 0) { |
|
| 2340 | $sql = "DELETE FROM $table WHERE subgroup_id = $group_id"; |
|
| 2341 | } else { |
|
| 2342 | $sql = "SELECT group_id FROM $table WHERE subgroup_id = $group_id"; |
|
| 2343 | $res = Database::query($sql); |
|
| 2344 | if (Database::num_rows($res) == 0) { |
|
| 2345 | $sql = "INSERT INTO $table SET |
|
| 2346 | group_id = $parent_group_id, |
|
| 2347 | subgroup_id = $group_id, |
|
| 2348 | relation_type = $relation_type"; |
|
| 2349 | } else { |
|
| 2350 | $sql = "UPDATE $table SET |
|
| 2351 | group_id = $parent_group_id, |
|
| 2352 | relation_type = $relation_type |
|
| 2353 | WHERE subgroup_id = $group_id"; |
|
| 2354 | } |
|
| 2355 | } |
|
| 2356 | $res = Database::query($sql); |
|
| 2357 | return $res; |
|
| 2358 | } |
|
| 2359 | ||
| 2360 | /** |
|
| 2361 | * Filter the groups/classes info to get a name list only |
|
