Esempi in PHP per block_exabis_eportfolio_item_sort_to_sql

Esempio n. 1

File: shared_portfolio.php Progetto: hmatulis/RTL-BIDI-Hebrew-Moodle-Plugins

***************************************************************/
require_once dirname(__FILE__) . '/inc.php';
require_once dirname(__FILE__) . '/lib/sharelib.php';
$access = optional_param('access', 0, PARAM_TEXT);
require_login(0, true);
if (!($user = block_exabis_eportfolio_get_user_from_access($access))) {
    print_error("nouserforid", "block_exabis_eportfolio");
}
$userpreferences = block_exabis_eportfolio_get_user_preferences($user->id);
if ($user->access->request == 'intern') {
    block_exabis_eportfolio_print_header("sharedbookmarks");
} else {
    print_header(get_string("externaccess", "block_exabis_eportfolio"), get_string("externaccess", "block_exabis_eportfolio") . " " . fullname($user, $user->id));
}
$parsedsort = block_exabis_eportfolio_parse_item_sort($userpreferences->itemsort);
$order_by = block_exabis_eportfolio_item_sort_to_sql($parsedsort);
if ($user->access->request == 'extern') {
    $extraTable = "";
    $extraWhere = "i.externaccess=1";
} else {
    $extraTable = "LEFT JOIN {$CFG->prefix}block_exabeporitemshar ishar ON i.id=ishar.itemid AND ishar.userid={$USER->id}";
    $extraWhere = " ((i.shareall=1 AND ishar.userid IS NULL)";
    $extraWhere .= "  OR (i.shareall=0 AND ishar.userid IS NOT NULL))";
}
$items = get_records_sql("SELECT i.id, i.type, i.url, i.name, i.intro, i.attachment, i.timemodified, ic.name AS cname, ic2.name AS cname_parent\r\n\tFROM {$CFG->prefix}block_exabeporitem i\r\n\tJOIN {$CFG->prefix}block_exabeporcate ic ON i.categoryid = ic.id\r\n\t{$extraTable}\r\n\tLEFT JOIN {$CFG->prefix}block_exabeporcate ic2 on ic.pid = ic2.id\r\n\tWHERE i.userid='{$user->id}' AND {$extraWhere}\r\n\t{$order_by}");
if (!$items) {
    print_error("nobookmarksall", "block_exabis_eportfolio");
}
echo '<table cellspacing="0" class="forumpost blogpost blog" width="100%">';
echo '<tr class="header"><td class="picture left">';
print_user_picture($user->id, 0, $user->picture);

Esempio n. 2

File: view_items.php Progetto: hmatulis/RTL-BIDI-Hebrew-Moodle-Plugins

$userpreferences = block_exabis_eportfolio_get_user_preferences();
if (!$sort && $userpreferences && isset($userpreferences->itemsort)) {
    $sort = $userpreferences->itemsort;
}
// check sorting
$parsedsort = block_exabis_eportfolio_parse_item_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('itemsort' => $sort));
$sql_sort = block_exabis_eportfolio_item_sort_to_sql($parsedsort);
if ($type == 'all') {
    $sql_type_where = '';
} else {
    $sql_type_where = " AND i.type='" . $type . "'";
}
if (!empty($_GET['filtercategory'])) {
    $sql_type_where .= ' AND i.categoryid = ' . $_GET['filtercategory'] . ' ';
}
$query = "select i.*, ic.name AS cname, ic2.name AS cname_parent, c.fullname As coursename, COUNT(com.id) As comments" . " from {$CFG->prefix}block_exabeporitem i" . " join {$CFG->prefix}block_exabeporcate ic on i.categoryid = ic.id" . " left join {$CFG->prefix}block_exabeporcate ic2 on ic.pid = ic2.id" . " left join {$CFG->prefix}course c on i.courseid = c.id" . " left join {$CFG->prefix}block_exabeporitemcomm com on com.itemid = i.id" . " where i.userid = {$USER->id} {$sql_type_where} group by i.id, i.name, i.intro, i.timemodified, cname, cname_parent, coursename {$sql_sort}";
$items = get_records_sql($query);
if ($items) {
    $table = new stdClass();
    $table->width = "100%";
    $table->head = array();
    $table->size = array();