* This copyright notice MUST APPEAR in all copies of the script! ***************************************************************/ 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">';
function block_exabis_eportfolio_item_sort_to_sql($sort) { $sort = block_exabis_eportfolio_parse_item_sort($sort); $column = $sort[0]; $order = $sort[1]; if ($column == "date") { $sql_sort = "i.timemodified " . $order; } elseif ($column == "category") { $sql_sort = "cname " . $order . ", i.timemodified"; } else { $sql_sort = "i." . $column . " " . $order . ", i.timemodified"; } return ' order by ' . $sql_sort; }
echo get_string('addnewitem', 'block_exabis_eportfolio'); echo '<select name="type">'; echo '<option value="link">' . get_string("link", "block_exabis_eportfolio") . "</option>"; echo '<option value="file">' . get_string("file", "block_exabis_eportfolio") . "</option>"; echo '<option value="note">' . get_string("note", "block_exabis_eportfolio") . "</option>"; echo '</select>'; echo "<input type=\"submit\" value=\"" . get_string("new", "block_exabis_eportfolio") . "\"/>"; } echo "</fieldset>\n </form>"; echo "</div>"; $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 . "'"; }