move_up_down()

Complexity

Conditions	14
Paths	163

Size

Total Lines	87
Code Lines	60

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
function move_up_down($content, $direction, $id)
{
    $table_categories = Database::get_course_table(TABLE_FORUM_CATEGORY);
    $table_forums = Database::get_course_table(TABLE_FORUM);
    $table_item_property = Database::get_course_table(TABLE_ITEM_PROPERTY);
    $course_id = api_get_course_int_id();
    $id = (int) $id;

    // Determine which field holds the sort order.
    if ('forumcategory' == $content) {
        $table = $table_categories;
        $sort_column = 'cat_order';
        $id_column = 'cat_id';
        $sort_column = 'cat_order';
    } elseif ('forum' == $content) {
        $table = $table_forums;
        $sort_column = 'forum_order';
        $id_column = 'forum_id';
        $sort_column = 'forum_order';
        // We also need the forum_category of this forum.
        $sql = "SELECT forum_category FROM $table_forums
                WHERE c_id = $course_id AND forum_id = ".(int) $id;
        $result = Database::query($sql);
        $row = Database::fetch_array($result);
        $forum_category = $row['forum_category'];
    } else {
        return get_lang('Error');
    }

    // Determine the need for sorting ascending or descending order.
    if ('down' == $direction) {
        $sort_direction = 'ASC';
    } elseif ('up' == $direction) {
        $sort_direction = 'DESC';
    } else {
        return get_lang('Error');
    }

    // The SQL statement
    if ('forumcategory' == $content) {
        $sql = "SELECT *
                FROM $table_categories forum_categories, $table_item_property item_properties
                WHERE
                    forum_categories.c_id = $course_id AND
                    item_properties.c_id = $course_id AND
                    forum_categories.cat_id=item_properties.ref AND
                    item_properties.tool='".TOOL_FORUM_CATEGORY."'
                ORDER BY forum_categories.cat_order $sort_direction";
    }
    if ('forum' == $content) {
        $sql = "SELECT *
            FROM $table
            WHERE
                c_id = $course_id AND
                forum_category='".Database::escape_string($forum_category)."'
            ORDER BY forum_order $sort_direction";
    }
    // Finding the items that need to be switched.
    $result = Database::query($sql);
    $found = false;
    while ($row = Database::fetch_array($result)) {
        if ($found) {
            $next_id = $row[$id_column];
            $next_sort = $row[$sort_column];
            $found = false;
        }
        if ($id == $row[$id_column]) {
            $this_id = $id;
            $this_sort = $row[$sort_column];
            $found = true;
        }
    }

    // Committing the switch.
    // We do an extra check if we do not have illegal values. If your remove this if statement you will
    // be able to mess with the sorting by refreshing the page over and over again.
    if ('' != $this_sort && '' != $next_sort && '' != $next_id && '' != $this_id) {
        $sql = "UPDATE $table SET $sort_column='".Database::escape_string($this_sort)."'
                WHERE c_id = $course_id AND $id_column='".Database::escape_string($next_id)."'";
        Database::query($sql);

        $sql = "UPDATE $table SET $sort_column='".Database::escape_string($next_sort)."'
                WHERE c_id = $course_id AND $id_column='".Database::escape_string($this_id)."'";
        Database::query($sql);
    }

    return get_lang(ucfirst($content).'Moved');
}