PHP claro_sql_pager::set_sort_key示例

        $noQUERY_STRING = true;
    }
}
/**
 * PREPARE DISPLAY
 *
 * Display contains 2 parts:
 *
 * 1/ Filter/search panel
 * 2/ List of datas
 */
$sqlCourseList = prepare_get_filtred_course_list();
$myPager = new claro_sql_pager($sqlCourseList, $offsetC, get_conf('coursePerPage', 20));
$sortKey = isset($_GET['sort']) ? $_GET['sort'] : 'officialCode, intitule';
$sortDir = isset($_GET['dir']) ? $_GET['dir'] : SORT_ASC;
$myPager->set_sort_key($sortKey, $sortDir);
$myPager->set_pager_call_param_name('offsetC');
$courseList = $myPager->get_result_list();
if (is_array($courseList)) {
    $tbl_mdb_names = claro_sql_get_main_tbl();
    foreach ($courseList as $courseKey => $course) {
        $sql = "SELECT\n    count(IF(`isCourseManager`=0,1,null))\n    AS `qty_stu`,\n    #count only lines where user is not course manager\n\n    count(IF(`isCourseManager`=1,1,null))\n    AS `qty_cm`\n    #count only lines where statut of user is 1\n           FROM  `" . $tbl_mdb_names['rel_course_user'] . "`\n           WHERE code_cours  = '" . claro_sql_escape($course['sysCode']) . "'\n          GROUP BY code_cours";
        $result = claro_sql_query_get_single_row($sql);
        $courseList[$courseKey]['qty_stu'] = $result['qty_stu'];
        $courseList[$courseKey]['qty_cm'] = $result['qty_cm'];
    }
}
// Prepare display of search/Filter panel
$advanced_search_query_string = array();
$isSearched = '';
if (!empty($_REQUEST['search'])) {

示例#2

显示文件

文件： adminusercourses.php 项目： rhertzog/lcs

        switch (claro_failure::get_last_failure()) {
            case 'cannot_unsubscribe_the_last_course_manager':
                $dialogBox->error(get_lang('You cannot unsubscribe the last course manager of the course'));
                break;
            case 'course_manager_cannot_unsubscribe_himself':
                $dialogBox->error(get_lang('Course manager cannot unsubscribe himself'));
                break;
            default:
                $dialogBox->error(get_lang('Unknow error during unsubscribing'));
        }
    }
}
$addToUrl = 'ulist' == $cfrom ? '&amp;cfrom=ulist' : '';
$sqlUserCourseList = prepare_sql_get_courses_of_a_user($uidToEdit);
$myPager = new claro_sql_pager($sqlUserCourseList, $offset, get_conf('coursePerPage', 20));
$myPager->set_sort_key($pagerSortKey, $pagerSortDir);
$userCourseList = $myPager->get_result_list();
$userCourseGrid = array();
foreach ($userCourseList as $courseKey => $course) {
    $userCourseGrid[$courseKey]['officialCode'] = $course['officialCode'];
    $iconUrl = get_course_access_icon($course['access']);
    $userCourseGrid[$courseKey]['name'] = '<img class="iconDefinitionList" src="' . $iconUrl . '" alt="" />' . '<a href="' . get_path('clarolineRepositoryWeb') . 'course/index.php?cid=' . claro_htmlspecialchars($course['sysCode']) . '">' . $course['name'] . '</a><br />' . $course['titular'];
    $userCourseGrid[$courseKey]['profileId'] = claro_get_profile_name($course['profileId']);
    if ($course['isCourseManager']) {
        $userCourseGrid[$courseKey]['isCourseManager'] = '<img class="qtip" src="' . get_icon_url('manager') . '" alt="' . get_lang('Course manager') . '" />';
    } else {
        $userCourseGrid[$courseKey]['isCourseManager'] = '<img class="qtip" src="' . get_icon_url('user') . '" alt="' . get_lang('Student') . '" />';
    }
    $userCourseGrid[$courseKey]['edit_course_user'] = '******' . $course['sysCode'] . '&amp;uidToEdit=' . $uidToEdit . '&amp;ccfrom=uclist">' . '<img src="' . get_icon_url('edit') . '" alt="' . get_lang('Course manager') . '" title="' . get_lang('User\'s course settings') . '" />' . '</a>';
    $userCourseGrid[$courseKey]['delete'] = '<a href="' . $_SERVER['PHP_SELF'] . '?uidToEdit=' . $uidToEdit . '&amp;cmd=unsubscribe' . $addToUrl . '&amp;courseId=' . claro_htmlspecialchars($course['sysCode']) . '&amp;sort=' . $pagerSortKey . '&amp;dir=' . $pagerSortDir . '&amp;offset=' . $offset . '"' . ' onclick="return ADMIN.confirmationUnReg(\'' . clean_str_for_javascript($userData['firstname'] . ' ' . $userData['lastname']) . '\');">' . "\n" . '<img src="' . get_icon_url('unenroll') . '" alt="' . get_lang('Delete') . '" />' . "\n" . '</a>' . "\n";
}