PHP block_exabis_eportfolio_view_sort_to_sqlの例

コード例 #1

ファイル: shared_views.php プロジェクト: hmatulis/RTL-BIDI-Hebrew-Moodle-Plugins

require_once dirname(__FILE__) . '/inc.php';
require_once dirname(__FILE__) . '/lib/sharelib.php';
$courseid = required_param('courseid', PARAM_INT);
$sort = optional_param('sort', '', PARAM_RAW);
$access = optional_param('access', 0, PARAM_TEXT);
require_login($courseid);
$context = get_context_instance(CONTEXT_SYSTEM);
require_capability('block/exabis_eportfolio:use', $context);
if (!($course = get_record("course", "id", $courseid))) {
    error("That's an invalid course id");
}
if (!($user = block_exabis_eportfolio_get_user_from_access($access))) {
    print_error("nouserforid", "block_exabis_eportfolio");
}
$parsedsort = block_exabis_eportfolio_parse_view_sort($sort);
$sql_sort = block_exabis_eportfolio_view_sort_to_sql($parsedsort);
$sort = $parsedsort[0] . '.' . $parsedsort[1];
$sortkey = $parsedsort[0];
if ($parsedsort[1] == "desc") {
    $newsort = $sortkey . ".asc";
} else {
    $newsort = $sortkey . ".desc";
}
$sorticon = $parsedsort[1] . '.gif';
block_exabis_eportfolio_print_header("sharedbookmarks");
$strheader = get_string("sharedbookmarks", "block_exabis_eportfolio");
/*
$navlinks = array();
$navlinks[] = array('name' => $strheader, 'link' => null, 'type' => 'misc');

$navigation = build_navigation($navlinks);

コード例 #2

ファイル: views_list.php プロジェクト: hmatulis/RTL-BIDI-Hebrew-Moodle-Plugins

$userpreferences = block_exabis_eportfolio_get_user_preferences();
if (!$sort && $userpreferences && isset($userpreferences->viewsort)) {
    $sort = $userpreferences->viewsort;
}
// check sorting
$parsedsort = block_exabis_eportfolio_parse_view_sort($sort);
$sort = $parsedsort[0] . '.' . $parsedsort[1];
$sortkey = $parsedsort[0];
if ($parsedsort[1] == "desc") {
    $newsort = $sortkey . ".asc";
} else {
    $newsort = $sortkey . ".desc";
}
$sorticon = $parsedsort[1] . '.gif';
block_exabis_eportfolio_set_user_preferences(array('viewsort' => $sort));
$query = "select v.*" . " from {$CFG->prefix}block_exabeporview v" . " where v.userid = {$USER->id}" . block_exabis_eportfolio_view_sort_to_sql($parsedsort);
$views = get_records_sql($query);
if (!$views) {
    echo get_string("noviews", "block_exabis_eportfolio");
} else {
    $table = new stdClass();
    $table->width = "100%";
    $table->head = array();
    $table->size = array();
    $table->head['name'] = '<a href="' . $_SERVER['PHP_SELF'] . '?courseid=' . $courseid . '&sort=' . ($sortkey == 'name' ? $newsort : 'name') . '">' . get_string("name", "block_exabis_eportfolio") . "</a>";
    $table->size['name'] = "30";
    $table->head['timemodified'] = '<a href="' . $_SERVER['PHP_SELF'] . '?courseid=' . $courseid . '&sort=' . ($sortkey == 'timemodified' ? $newsort : 'timemodified.desc') . '">' . get_string("date", "block_exabis_eportfolio") . "</a>";
    $table->size['timemodified'] = "20";
    $table->head['accessoptions'] = get_string("accessoptions", "block_exabis_eportfolio");
    $table->size['accessoptions'] = "30";
    /*