* 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 . "'";
}
