if (get_opendb_config_var('item_display', 'show_item_image') !== FALSE && is_user_granted_permission(PERM_VIEW_ITEM_COVERS)) {
$results = fetch_item_attribute_type_rs($item_r['s_item_type'], 'IMAGE');
if ($results) {
$coverimages_rs = NULL;
while ($image_attribute_type_r = db_fetch_assoc($results)) {
$imageurl_r = fetch_attribute_val_r($item_r['item_id'], $item_r['instance_no'], $image_attribute_type_r['s_attribute_type'], $image_attribute_type_r['order_no']);
if ($imageurl_r !== FALSE) {
while (list(, $imageurl) = each($imageurl_r)) {
$coverimages_rs[] = array('file' => file_cache_get_image_r($imageurl, 'display'), 'prompt' => $image_attribute_type_r['prompt']);
}
}
}
db_free_result($results);
// provide default if no images
if ($coverimages_rs == NULL) {
$coverimages_rs[] = array('file' => file_cache_get_image_r(NULL, 'display'));
}
echo "<ul class=\"coverimages\">";
while (list(, $coverimage_r) = each($coverimages_rs)) {
echo "<li>";
$file_r = $coverimage_r['file'];
if (strlen($file_r['fullsize']['url']) > 0) {
$width = $file_r['fullsize']['width'];
$height = $file_r['fullsize']['height'];
// IE hack
if ($_OpendbBrowserSniffer->isBrowser('ie')) {
if (is_numeric($width)) {
$width += 40;
}
if (is_numeric($height)) {
$height += 40;
function get_item_display_field($item_r, $item_attribute_type_r, $value = NULL, $dowrap = TRUE, $prompt_mask = NULL)
{
if ($item_attribute_type_r['display_type'] == 'hidden') {
return '';
} else {
if ($item_attribute_type_r['display_type'] == 'fileviewer') {
$format_mask = ifempty($item_attribute_type_r['display_type_arg1'], '%value%');
$width = ifempty($item_attribute_type_r['display_type_arg2'], '400');
$height = ifempty($item_attribute_type_r['display_type_arg3'], '300');
$target = ifempty($item_attribute_type_r['display_type_arg4'], '_blank');
if (is_array($value)) {
$values = $value;
} else {
$values[] = $value;
}
if (count($values) > 0) {
$display_value_r = array();
while (list(, $value) = each($values)) {
$value = trim($value);
$value_format_mask = $format_mask;
if (strpos($value_format_mask, '%img%') !== FALSE) {
$file_type_r = fetch_file_type_r(fetch_file_type_for_extension(get_file_ext($value)));
if (strlen($file_type_r['image']) > 0 && ($image_src = theme_image_src($file_type_r['image'])) !== FALSE) {
$img = '<img src="' . $image_src . '" title="' . $value . '">';
} else {
$img = '';
}
$value_format_mask = str_replace('%img%', $img, $value_format_mask);
}
if (strpos($value_format_mask, '%value%') !== FALSE) {
$value_format_mask = str_replace('%value%', $value, $value_format_mask);
}
$file_r = file_cache_get_image_r($value, 'display');
$url = $file_r['fullsize']['url'];
$display_value_r[] = "<a href=\"" . $value . "\" onclick=\"fileviewer('{$url}' ,'" . ($width + 20) . "', '" . ($height + 25) . "', '" . $target . "'); return false;\" title=\"" . $item_attribute_type_r['prompt'] . "\" class=\"popuplink\">{$value_format_mask}</a>";
}
$field = format_multivalue_block($display_value_r, 'fileviewer');
if ($dowrap) {
return format_field($item_attribute_type_r['prompt'], $field, $prompt_mask);
} else {
return $field;
}
} else {
return '';
}
} else {
if ($item_attribute_type_r['display_type'] == 'datetime') {
if (is_array($value)) {
$values = $value;
} else {
$values[] = $value;
}
if (count($values) > 0) {
$display_value_r = array();
while (list(, $value) = each($values)) {
$value = trim($value);
$timestamp = get_timestamp_for_datetime($value, 'YYYYMMDDHH24MISS');
if ($timestamp !== FALSE) {
if (strlen($item_attribute_type_r['display_type_arg1']) == 0) {
$item_attribute_type_r['display_type_arg1'] = 'DD/MM/YYYY';
}
$datetime = get_localised_timestamp($item_attribute_type_r['display_type_arg1'], $timestamp);
if ($datetime !== FALSE) {
$display_value_r[] = $datetime;
} else {
$display_value_r[] = $value;
}
} else {
$display_value_r[] = $value;
}
}
$field = format_multivalue_block($display_value_r, 'datetime');
if ($dowrap) {
return format_field($item_attribute_type_r['prompt'], $field, $prompt_mask);
} else {
return $field;
}
} else {
return '';
}
} else {
if ($item_attribute_type_r['display_type'] == 'format_mins') {
if (is_array($value)) {
$values = $value;
} else {
$values[] = $value;
}
if (count($values) > 0) {
$display_value_r = array();
while (list(, $value) = each($values)) {
$value = trim($value);
if (is_numeric($value)) {
// Ensure we have a mask to work with.
$display_mask = $item_attribute_type_r['display_type_arg1'];
if (strlen($display_mask) == 0) {
$display_mask = '%h %H %m %M';
}
$hrs = floor($value / 60);
// hours
$mins = $value % 60;
// minutes
// Process display_mask and remove any bits that are not needed because the hour/minute is zero.
if ($mins == 0 && $hrs > 0) {
// only get rid of minutes if $hrs is a value.
$index = strpos($display_mask, '%H');
if ($index !== FALSE) {
$display_mask = substr($display_mask, 0, $index + 2);
} else {
$index = strpos($display_mask, '%m');
if ($index != FALSE) {
$display_mask = substr($display_mask, 0, $index);
}
//include the %H
}
} else {
if ($hrs == 0) {
$index = strpos($display_mask, '%m');
if ($index != FALSE) {
$display_mask = substr($display_mask, $index);
}
//include the %H
}
}
// Unfortunately we need to do $mins>0 and $hrs>0 if's twice, because otherwise once we
// replace the %h and %H the test for $mins>0 would not be able to cut the display_mask,
// based on the %h/%H...
if ($hrs > 0) {
// Now do all replacements.
$display_mask = str_replace('%h', $hrs, $display_mask);
if ($hrs != 1) {
$display_mask = str_replace('%H', get_opendb_lang_var('hours'), $display_mask);
} else {
$display_mask = str_replace('%H', get_opendb_lang_var('hour'), $display_mask);
}
}
if ($mins >= 0 || $hrs === 0 && $mins === 0) {
// Now do minute replacements only.
$display_mask = str_replace('%m', $mins, $display_mask);
if ($mins != 1) {
$display_mask = str_replace('%M', get_opendb_lang_var('minutes'), $display_mask);
} else {
$display_mask = str_replace('%M', get_opendb_lang_var('minute'), $display_mask);
}
}
$display_value_r[] = $display_mask;
} else {
// what else can we do here?!
$display_value_r[] = $value;
}
}
$field = format_multivalue_block($display_value_r, 'format_mins');
if ($dowrap) {
return format_field($item_attribute_type_r['prompt'], $field, $prompt_mask);
} else {
return $field;
}
} else {
return '';
}
} else {
if ($item_attribute_type_r['display_type'] == 'star_rating') {
// arg[0] = rating range
if (is_array($value)) {
$values = $value;
} else {
$values[] = $value;
}
if (count($values) > 0) {
$display_value_r = array();
while (list(, $value) = each($values)) {
$value = trim($value);
// no point unless numeric
if (is_numeric($value)) {
$total_count = $item_attribute_type_r['display_type_arg1'];
if (is_numeric($total_count)) {
$display_value = '';
$j = $value;
for ($i = 0; $i < $total_count; ++$i) {
if ($j >= 0.75) {
$display_value .= theme_image('rs.gif');
} else {
if ($j >= 0.25) {
$display_value .= theme_image('rgs.gif');
} else {
$display_value .= theme_image('gs.gif');
}
}
$j = $j - 1;
}
$ratingmask = $item_attribute_type_r['display_type_arg2'];
if (strlen($ratingmask) > 0) {
$ratingmask = str_replace('%value%', $value, $ratingmask);
$ratingmask = str_replace('%maxrange%', $total_count, $ratingmask);
$display_value = str_replace('%starrating%', $display_value, $ratingmask);
}
if ($item_attribute_type_r['listing_link_ind'] == 'Y') {
$display_value = format_listing_link($value, $display_value, $item_attribute_type_r, NULL);
}
}
$display_value_r[] = $display_value;
}
}
$field = format_multivalue_block($display_value_r, 'starrating');
if ($dowrap) {
return format_field($item_attribute_type_r['prompt'], $field, $prompt_mask);
} else {
return $field;
}
} else {
return '';
// nothing to do!
}
} else {
if (!is_array($value) && $item_attribute_type_r['display_type'] == 'display' && ifempty($item_attribute_type_r['display_type_arg1'], '%value%') == '%value%') {
// Support newline formatting by default.
$value = nl2br(trim($value));
if ($item_attribute_type_r['listing_link_ind'] == 'Y') {
$field = format_listing_links($value, $item_attribute_type_r, 'exact');
} else {
$field = $value;
}
if ($dowrap) {
return format_field($item_attribute_type_r['prompt'], $field, $prompt_mask);
} else {
return $field;
}
} else {
if ($item_attribute_type_r['display_type'] == 'list') {
//list(list_type [,delimiter])
if (is_array($value)) {
$values = $value;
$attr_match = 'exact';
} else {
$value = trim($value);
if (strlen($item_attribute_type_r['display_type_arg2']) == 0) {
// Use newline!
$values = explode_lines($value);
$attr_match = 'partial';
} else {
$values = explode($item_attribute_type_r['display_type_arg2'], $value);
if (strlen(trim($item_attribute_type_r['display_type_arg2'])) === 0) {
$attr_match = 'word';
} else {
$attr_match = 'partial';
}
}
}
$field = format_list_from_array($values, $item_attribute_type_r, $item_attribute_type_r['listing_link_ind'] == 'Y' ? $attr_match : FALSE);
if ($dowrap) {
return format_field($item_attribute_type_r['prompt'], $field, $prompt_mask);
} else {
return $field;
}
} else {
if ($item_attribute_type_r['display_type'] == 'category' || $item_attribute_type_r['display_type'] == 'display') {
$field = '';
if (is_array($value)) {
$value_array = $value;
} else {
$value_array[] = $value;
}
$attribute_value_rs = array();
if ($item_attribute_type_r['lookup_attribute_ind'] == 'Y') {
$results = fetch_value_match_attribute_type_lookup_rs($item_attribute_type_r['s_attribute_type'], $value_array, get_lookup_order_by($item_attribute_type_r['display_type_arg1']), 'asc');
if ($results) {
while ($lookup_r = db_fetch_assoc($results)) {
$lookup_key = array_search2($lookup_r['value'], $value_array, TRUE);
if ($lookup_key !== FALSE) {
// Remove the matched element
array_splice($value_array, $lookup_key, 1);
$attribute_value_rs[] = array(value => $lookup_r['value'], display => $lookup_r['display'], img => $lookup_r['img']);
}
}
db_free_result($results);
}
}
// where extra items that do not have a matching lookup value.
if (is_not_empty_array($value_array)) {
reset($value_array);
while (list(, $value) = each($value_array)) {
if (strlen(trim($value)) > 0) {
// In case there are extra spaces
$attribute_value_rs[] = array(value => $value, display => $value);
}
}
}
if (is_not_empty_array($attribute_value_rs)) {
$field = format_lookup_display_block($item_attribute_type_r, $attribute_value_rs);
if (strlen($field) > 0) {
if ($dowrap) {
return format_field($item_attribute_type_r['prompt'], $field, $prompt_mask);
} else {
return $field;
}
} else {
return NULL;
}
}
} else {
if ($item_attribute_type_r['display_type'] == 'review') {
$total_count = fetch_attribute_type_cnt('S_RATING');
if (is_numeric($total_count)) {
$value = trim($value);
if (!is_numeric($value)) {
$value = 0;
}
$field = '';
$j = $value;
for ($i = 0; $i < $total_count; ++$i) {
if ($j >= 0.75) {
$field .= theme_image('rs.gif');
} else {
if ($j >= 0.25) {
$field .= theme_image('rgs.gif');
} else {
$field .= theme_image('gs.gif');
}
}
$j = $j - 1;
}
// If a mask is defined, format the display value.
if (strlen($item_attribute_type_r['display_type_arg1']) > 0) {
$lookup_r = fetch_attribute_type_lookup_r('S_RATING', $value);
if (is_not_empty_array($lookup_r)) {
$field .= format_display_value($item_attribute_type_r['display_type_arg1'], $lookup_r['img'], $lookup_r['value'], $lookup_r['display']);
}
}
return $field;
// this is only used in a few places.
}
}
}
}
}
}
}
}
}
}
//else -- no display type match.
if ($dowrap) {
return format_field($item_attribute_type_r['prompt'], nl2br($value), $prompt_mask);
} else {
return nl2br($value);
}
}
function handle_site_search(&$sitePlugin, $HTTP_VARS, &$errors, &$footer_links_r)
{
global $PHP_SELF;
$HTTP_VARS['op'] = 'site';
$formContents = '<div id="site-search">';
if ($sitePlugin->_queryListing($HTTP_VARS) !== FALSE) {
$searchQuery = $sitePlugin->getSearchQuery();
if (is_not_empty_array($searchQuery)) {
$formContents .= "<h3>" . get_opendb_lang_var('site_search_results', array('site_title' => $sitePlugin->getTitle())) . "</h3>";
$formContents .= '<div class="search-query"><dl>';
for ($i = 0; $i < count($searchQuery); $i++) {
if ($searchQuery[$i]['field_type'] != 'hidden') {
$formContents .= '<dt>' . $searchQuery[$i]['prompt'] . "</dt>";
$formContents .= '<dd>' . htmlspecialchars($searchQuery[$i]['value']) . '</dd>';
}
}
$formContents .= '</dl></div>';
}
if ($sitePlugin->getRowCount() > 0) {
// exact title match.
if ($sitePlugin->getRowCount() == 1 && $sitePlugin->isPreviousPage() === FALSE) {
// the site plugin process will have already queried for the itemData
// based on the single row returned.
return "__EXACT_TITLE_MATCH__";
} else {
$formContents .= "\n<table class=\"listing-table\">";
$class = 'oddRow';
for ($i = 0; $i < $sitePlugin->getRowCount(); $i++) {
$formContents .= "\n<tr class=\"{$class}\">";
$row_data_r = $sitePlugin->getRowData($i);
$file_r = file_cache_get_image_r($row_data_r['cover_image_url'], 'site-add');
if (is_not_empty_array($file_r)) {
$imageblock = "<img src=\"" . $file_r['thumbnail']['url'] . "\" ";
if (is_numeric($file_r['thumbnail']['width'])) {
$imageblock .= ' width="' . $file_r['thumbnail']['width'] . '"';
}
if (is_numeric($file_r['thumbnail']['height'])) {
$imageblock .= ' height="' . $file_r['thumbnail']['height'] . '"';
}
$imageblock .= ">";
}
$formContents .= "\n<td class=\"image\">" . $imageblock . "</td>";
$formContents .= "\n<td class=\"title\">";
$formContents .= "\n<a href=\"" . "item_input.php?" . $row_data_r['opendb_link_url'] . "\">" . $row_data_r['title'] . "</a>";
if (strlen($row_data_r['comments']) > 0) {
$formContents .= '<p class=\\"comments\\">' . nl2br($row_data_r['comments']) . '</p>';
}
$formContents .= "\n</td>";
if (strlen($row_data_r['more_info_url']) > 0) {
$formContents .= "\n<td class=\"moreInfo\"><a href=\"" . $row_data_r['more_info_url'] . "\" target=\"_new\">" . get_opendb_lang_var('more_info') . "</a></td>";
}
$formContents .= "\n</tr>";
$class = $class == 'oddRow' ? 'evenRow' : 'oddRow';
}
$formContents .= "\n</table>";
unset($HTTP_VARS['page_no']);
if ($sitePlugin->isPreviousPage() || $sitePlugin->isNextPage()) {
if ($sitePlugin->isPreviousPage() || $sitePlugin->isNextPage()) {
$HTTP_VARS['op'] = 'site-search';
$page_nav_url = get_url_string($HTTP_VARS);
$formContents .= "<ul class=\"listingPager\">";
if ($sitePlugin->isPreviousPage()) {
$formContents .= "<li class=\"previousPage\"><a href=\"item_input.php?{$page_nav_url}&page_no=" . ($sitePlugin->getPageNo() - 1) . "\">" . get_opendb_lang_var('previous_page') . "</a></li>";
} else {
$formContents .= "<li class=\"previousPage disabled\">" . get_opendb_lang_var('previous_page') . "</a></li>";
}
if ($sitePlugin->isNextPage()) {
$formContents .= "<li class=\"nextPage\"><a href=\"item_input.php?{$page_nav_url}&page_no=" . ($sitePlugin->getPageNo() + 1) . "\">" . get_opendb_lang_var('next_page') . "</a></li>";
} else {
$formContents .= "<li class=\"nextPage disabled\">" . get_opendb_lang_var('next_page') . "</a></li>";
}
$formContents .= "</ul>";
}
}
}
} else {
$formContents .= "<p class=\"error\">" . get_opendb_lang_var('no_matches_found') . "</p>";
}
$http_url_vars = get_url_string($HTTP_VARS, NULL, array('op', 'site_type', 's_item_type'));
// either site-add / site-refresh
if (is_exists_item_instance($HTTP_VARS['item_id'], $HTTP_VARS['instance'])) {
$footer_links_r[] = array(url => "item_input.php?op=site-refresh" . (strlen($http_url_vars) > 0 ? "&" . $http_url_vars : ""), text => get_opendb_lang_var('new_search'));
} else {
$footer_links_r[] = array(url => "item_input.php?op=site-add" . (strlen($http_url_vars) > 0 ? "&" . $http_url_vars : ""), text => get_opendb_lang_var('new_search'));
}
$formContents .= "</div>";
return $formContents;
} else {
$errors = $sitePlugin->getErrors();
if ($errors === FALSE) {
$errors = get_opendb_lang_var('undefined_error');
}
return FALSE;
}
}
function writeRowImpl($row_column_rs)
{
if ($this->_toggle) {
$this->rowclass = "oddRow";
} else {
$this->rowclass = "evenRow";
}
$this->_write("\n<tr class=\"" . $this->rowclass . "\">");
for ($i = 0; $i < count($row_column_rs); $i++) {
$header_column_r = $this->_header_column_rs[$i];
$columnClass = NULL;
if (strlen($header_column_r['fieldname']) > 0) {
$columnClass = $header_column_r['fieldname'];
}
switch ($row_column_rs[$i]['column_type']) {
case 'action_links':
$this->_write('<td class="action_links ' . $columnClass . '">');
$this->_write(ifempty(format_action_links($row_column_rs[$i]['action_links']), get_opendb_lang_var('not_applicable')));
$this->_write('</td>');
break;
case 'username':
$this->_write('<td class="username ' . $columnClass . '">');
$user_id = $row_column_rs[$i]['user_id'];
$fullname = $row_column_rs[$i]['fullname'];
if ($user_id == get_opendb_session_var('user_id')) {
$this->_write(get_opendb_lang_var('current_user', array('fullname' => $fullname, 'user_id' => $user_id)));
} else {
$user_name = get_opendb_lang_var('user_name', array('fullname' => $fullname, 'user_id' => $user_id));
if ($this->_include_href_links && is_user_granted_permission(PERM_VIEW_USER_PROFILE)) {
$item_title = '';
// lets find the title column.
for ($j = 0; $j < count($row_column_rs); $j++) {
if ($row_column_rs[$j]['column_type'] == 'title') {
$item_title = trim(strip_tags($row_column_rs[$j]['item_title']));
break;
}
}
$url = "user_profile.php?uid=" . $user_id;
if (is_array($row_column_rs[$i]['extra_http_vars'])) {
$url .= "&" . get_url_string($row_column_rs[$i]['extra_http_vars']);
}
$url .= "&subject=" . urlencode(ifempty($item_title, get_opendb_lang_var('no_subject')));
$this->_write("<a href=\"{$url}\" title=\"" . htmlspecialchars(get_opendb_lang_var('user_profile')) . "\">{$user_name}</a>");
} else {
$this->_write($user_name);
}
}
$this->_write('</td>');
break;
case 'interest':
// opendb_logger(OPENDB_LOG_INFO, __FILE__, __FUNCTION__, "_xajax=" . $_xajax===NULL?"nulles":"nonnul");
$item_id = $row_column_rs[$i]['item_id'];
$instance_no = $row_column_rs[$i]['instance_no'];
$level = $row_column_rs[$i]['level'];
if ($level > 0) {
$this->addHelpEntry(get_opendb_lang_var('interest_help'), 'interest_1.gif', 'interest');
$new_level_value = 0;
$level_display .= "<img" . " id=\"interest_level_{$item_id}" . "_{$instance_no}\"" . " src=\"" . theme_image_src('interest_1.gif') . "\"" . " alt=\"" . get_opendb_lang_var('interest_remove') . "\"" . " title=\"" . get_opendb_lang_var('interest_remove') . "\"" . " onclick=\"xajax_ajax_update_interest_level('{$item_id}', '{$instance_no}', document.getElementById('new_level_value_{$item_id}\\_{$instance_no}').value);\"" . " style=\"cursor:pointer;\"" . " >";
} else {
$new_level_value = 1;
$level_display .= "<img" . " id=\"interest_level_{$item_id}" . "_{$instance_no}\"" . " src=\"" . theme_image_src('interest_0.gif') . "\"" . " alt=\"" . get_opendb_lang_var('interest_mark') . "\"" . " title=\"" . get_opendb_lang_var('interest_mark') . "\"" . " onclick=\"xajax_ajax_update_interest_level('{$item_id}','{$instance_no}', document.getElementById('new_level_value_{$item_id}\\_{$instance_no}').value);\"" . " style=\"cursor:pointer;\"" . " >";
}
$this->_write('<td class="interest ' . $columnClass . '">');
$this->_write("<input id=\"new_level_value_{$item_id}" . "_{$instance_no}\" type=\"hidden\" value=\"{$new_level_value}\" />");
$this->_write($level_display);
$this->_write('</td>');
break;
case 'item_type_image':
$this->_write('<td class="item_type_image ' . $columnClass . '">');
$s_item_type = $row_column_rs[$i]['s_item_type'];
if (!is_array($this->_item_type_rs[$s_item_type]) || strlen($this->_item_type_rs[$s_item_type]['image']) == 0) {
$this->_item_type_rs[$s_item_type] = fetch_item_type_r($s_item_type);
// expand to the actual location once only.
if (strlen($this->_item_type_rs[$s_item_type]['image']) > 0) {
$this->_item_type_rs[$s_item_type]['image'] = theme_image_src($this->_item_type_rs[$s_item_type]['image']);
} else {
$this->_item_type_rs[$s_item_type]['image'] = 'none';
}
if (strlen($this->_item_type_rs[$s_item_type]['description']) > 0) {
$this->_item_type_rs[$s_item_type]['description'] = htmlspecialchars($this->_item_type_rs[$s_item_type]['description']);
} else {
$this->_item_type_rs[$s_item_type]['description'] = NULL;
}
}
if (strlen($this->_item_type_rs[$s_item_type]['image']) > 0 && $this->_item_type_rs[$s_item_type]['image'] != 'none') {
$this->_write(theme_image($this->_item_type_rs[$s_item_type]['image'], $this->_item_type_rs[$s_item_type]['description'], 's_item_type'));
} else {
// otherwise write the item type itself in place of the image.
$this->_write($s_item_type);
}
$this->_write('</td>');
break;
case 'theme_image':
$this->_write('<td class="' . $columnClass . '">');
$this->_write(theme_image($row_column_rs[$i]['src'], htmlspecialchars($row_column_rs[$i]['title']), $row_column_rs[$i]['type']));
$this->_write('</td>');
break;
case 'title':
$title_href_link = $row_column_rs[$i]['title_href_link'];
$is_item_reviewed = $row_column_rs[$i]['is_item_reviewed'];
$is_borrowed_or_returned = $row_column_rs[$i]['is_borrowed_or_returned'];
$item_title = '';
if ($this->_include_href_links && is_user_granted_permission(PERM_VIEW_ITEM_DISPLAY)) {
$item_title = '<a href="' . $title_href_link . '">' . $row_column_rs[$i]['item_title'] . '</a>';
} else {
$item_title = $row_column_rs[$i]['item_title'];
}
if ($is_item_reviewed) {
// show star if rated - Add it to the actual title, so we can do a bit more with title masks
$this->addHelpEntry(get_opendb_lang_var('item_reviewed'), 'rs.gif', 'item_reviewed');
$item_title .= theme_image('rs.gif', get_opendb_lang_var('item_reviewed'), 'item_reviewed');
}
if ($is_borrowed_or_returned) {
$this->addHelpEntry(get_opendb_lang_var('youve_borrow_or_return'), 'tick.gif', 'borrow_or_return');
$item_title .= theme_image("tick.gif", get_opendb_lang_var('youve_borrow_or_return'), 'borrow_or_return');
// show tick if previously borrowed or returned.
}
$this->_write('<td class="title ' . $columnClass . '">');
$this->_write($item_title);
$this->_write('</td>');
break;
case 'coverimage':
$item_cover_image = $row_column_rs[$i]['item_cover_image'];
$title_href_link = $row_column_rs[$i]['title_href_link'];
$this->_write('<td class="coverimage ' . $columnId . 'Column">');
$file_r = file_cache_get_image_r($item_cover_image, 'listing');
if (is_array($file_r)) {
$cover_image_tag = '<img src="' . $file_r['thumbnail']['url'] . '"';
if (is_numeric($file_r['thumbnail']['width'])) {
$cover_image_tag .= ' width="' . $file_r['thumbnail']['width'] . '"';
}
if (is_numeric($file_r['thumbnail']['height'])) {
$cover_image_tag .= ' height="' . $file_r['thumbnail']['height'] . '"';
}
$cover_image_tag .= '>';
if ($this->_mode != 'printable' && $this->_include_href_links) {
$cover_image_tag = '<a href="' . $title_href_link . '">' . $cover_image_tag . '</a>';
}
$this->_write($cover_image_tag);
}
$this->_write('</td>');
break;
case 'display':
$this->_write('<td class="' . $columnClass . '">');
$this->_write(get_display_field($row_column_rs[$i]['attribute_type'], $row_column_rs[$i]['prompt'], $row_column_rs[$i]['display_type'], $row_column_rs[$i]['value'], FALSE));
$this->_write('</td>');
break;
case 'attribute_display':
$this->_write('<td class="' . $columnClass . '">');
$this->_write(get_item_display_field($row_column_rs[$i]['item_r'], $row_column_rs[$i]['attribute_type_r'], $row_column_rs[$i]['value'], FALSE));
$this->_write('</td>');
break;
case 'checkbox':
$this->_write('<td class="checkbox">');
$value = $row_column_rs[$i]['value'];
$this->_write('<input type="checkbox" class="checkbox" name="' . $this->_header_column_rs[$i]['fieldname'] . '[]" value="' . $value . '">');
$this->_write('</td>');
break;
default:
$this->_write('<td class="' . $columnClass . '">');
$this->_write($row_column_rs[$i]['value']);
$this->_write('</td>');
break;
}
}
$this->_write("\n</tr>");
}
function get_last_num_items_rs($num_of_items, $owner_id = NULL, $s_item_type = NULL, $update_on = NULL, $not_owner_id = NULL, $site_url_prefix = NULL, $title_mask_id = NULL)
{
if (strlen($owner_id) > 0) {
$search_vars_r['owner_id'] = $owner_id;
}
if (strlen($s_item_type) > 0) {
$search_vars_r['s_item_type'] = $s_item_type;
}
if (strlen($update_on) > 0) {
$search_vars_r['update_on'] = $update_on;
}
if (strlen($not_owner_id) > 0) {
$search_vars_r['not_owner_id'] = $not_owner_id;
}
$dummy_r = NULL;
$results = fetch_item_listing_rs($search_vars_r, $dummy_r, 'update_on', 'DESC', 0, $num_of_items);
if ($results) {
if ($title_mask_id == 'feeds') {
$title_mask_group = array('feeds', 'item_display');
} else {
$title_mask_group = array('last_items_list', 'item_listing');
}
$titleMaskCfg = new TitleMask($title_mask_group);
$image_attribute_type_rs = NULL;
while ($item_r = db_fetch_assoc($results)) {
$item_r['title'] = $titleMaskCfg->expand_item_title($item_r);
$item_r['update_on'] = get_localised_timestamp(get_opendb_config_var('welcome.last_items_list', 'datetime_mask'), $item_r['update_on']);
$item_r['item_display_url'] = 'item_display.php?item_id=' . $item_r['item_id'] . '&instance_no=' . $item_r['instance_no'];
if ($site_url_prefix != NULL) {
$item_r['item_display_url'] = $site_url_prefix . $item_r['item_display_url'];
}
$item_type_r = fetch_item_type_r($item_r['s_item_type']);
$itemtypeimagesrc = theme_image_src($item_type_r['image']);
$size = @getimagesize($itemtypeimagesrc);
if (is_array($size)) {
$item_r['itemtypeimage']['width'] = $size[0];
$item_r['itemtypeimage']['height'] = $size[1];
}
$item_r['itemtypeimage']['url'] = $itemtypeimagesrc;
if ($site_url_prefix != NULL) {
$item_r['itemtypeimage']['url'] = $site_url_prefix . $item_r['itemtypeimage']['url'];
}
$item_r['itemtypeimage']['title'] = $item_type_r['description'];
$item_r['itemtypeimage']['s_item_type'] = $item_r['s_item_type'];
if (get_opendb_config_var('welcome.last_items_list', 'show_item_image') !== FALSE) {
if (!is_array($image_attribute_type_rs) || !is_array($image_attribute_type_rs[$item_r['s_item_type']])) {
$image_attribute_type_rs[$item_r['s_item_type']] = fetch_sfieldtype_item_attribute_type_r($item_r['s_item_type'], 'IMAGE');
}
// of a IMAGE s_attribute defined for this s_item_type
if (is_array($image_attribute_type_rs[$item_r['s_item_type']])) {
$attribute_type_r = $image_attribute_type_rs[$item_r['s_item_type']];
$imageurl = fetch_attribute_val($item_r['item_id'], NULL, $attribute_type_r['s_attribute_type']);
$file_r = file_cache_get_image_r($imageurl, 'display');
$item_r['imageurl']['url'] = $file_r['thumbnail']['url'];
if ($site_url_prefix != NULL) {
$item_r['imageurl']['url'] = $site_url_prefix . $item_r['imageurl']['url'];
}
$item_r['imageurl']['width'] = $file_r['thumbnail']['width'];
$item_r['imageurl']['height'] = $file_r['thumbnail']['height'];
$item_r['imageurl']['title'] = $item_r['title'];
}
}
$item_rs[] = $item_r;
unset($item_r);
}
//while
db_free_result($results);
}
return $item_rs;
}
