get_group_user_data()

Complexity

Conditions	10
Paths	26

Size

Total Lines	95
Code Lines	63

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
function get_group_user_data($from, $number_of_items, $column, $direction)
{
    $direction = !in_array(strtolower(trim($direction)), ['asc', 'desc']) ? 'asc' : $direction;
    $groupInfo = GroupManager::get_group_properties(api_get_group_id());
    $course_id = api_get_course_int_id();
    $column = (int) $column;

    if (empty($groupInfo) || empty($course_id)) {
        return 0;
    }

    // Database table definition
    $table_group_user = Database::get_course_table(TABLE_GROUP_USER);
    $table_user = Database::get_main_table(TABLE_MAIN_USER);
    $tableGroup = Database::get_course_table(TABLE_GROUP);

    // Query
    if (api_get_setting('show_email_addresses') === 'true') {
        $sql = "SELECT user.id 	AS col0,
				".(
            api_is_western_name_order() ?
                "user.firstname 	AS col1,
				user.lastname 	AS col2,"
                :
                "user.lastname 	AS col1,
				user.firstname 	AS col2,"
            )."
				user.email		AS col3
				, user.active AS col4
				FROM $table_user user 
				INNER JOIN $table_group_user group_rel_user
				ON (group_rel_user.user_id = user.id)
				INNER JOIN $tableGroup g
				ON (group_rel_user.group_id = g.iid)
				WHERE 
				    group_rel_user.c_id = $course_id AND 
				    g.iid = '".$groupInfo['iid']."'
                ORDER BY col$column $direction 
                LIMIT $from, $number_of_items";
    } else {
        if (api_is_allowed_to_edit()) {
            $sql = "SELECT DISTINCT
                        u.id AS col0,
                        ".(api_is_western_name_order() ?
                        "u.firstname 	AS col1,
                            u.lastname 	AS col2,"
                        :
                        "u.lastname 	AS col1,
                        u.firstname 	AS col2,")."
                        u.email		AS col3
                        , u.active AS col4
                    FROM $table_user u 
                    INNER JOIN $table_group_user gu 
                    ON (gu.user_id = u.id)
                    INNER JOIN $tableGroup g
				    ON (gu.group_id = g.iid)
                    WHERE 
                        g.iid = '".$groupInfo['iid']."' AND 
                        gu.c_id = $course_id
                    ORDER BY col$column $direction 
                    LIMIT $from, $number_of_items";
        } else {
            $sql = "SELECT DISTINCT
						user.id 	AS col0,
						".(
                api_is_western_name_order() ?
                    "user.firstname 	AS col1,
						user.lastname 	AS col2 "
                    :
                    "user.lastname 	AS col1,
						user.firstname 	AS col2 "
                    )."
                    , user.active AS col3
                    FROM $table_user user 
                    INNER JOIN $table_group_user group_rel_user
                    ON (group_rel_user.user_id = user.id)
                    INNER JOIN $tableGroup g
                    ON (group_rel_user.group_id = g.iid)
                    WHERE 
                        g.iid = '".$groupInfo['iid']."' AND 
                        group_rel_user.c_id = $course_id AND  
                        group_rel_user.user_id = user.id AND 
                        g.iid = '".$groupInfo['iid']."'
                    ORDER BY col$column $direction 
                    LIMIT $from, $number_of_items";
        }
    }

    $return = [];
    $result = Database::query($sql);
    while ($row = Database::fetch_row($result)) {
        $return[] = $row;
    }

    return $return;
}