source: extensions/rv_gmaps/branches/2.3/mapl.php @ 29541

<?php
if ( !defined('PHPWG_ROOT_PATH') )
  define('PHPWG_ROOT_PATH','../../');

include_once( PHPWG_ROOT_PATH.'include/common.inc.php' );
include_once( dirname(__FILE__) .'/include/functions.php');
include_once( dirname(__FILE__) .'/include/functions_map.php');

check_status(ACCESS_GUEST);
if (!isset($rvm_dir))
  access_denied( 'Plugin not installed' );

rvm_load_language();

$section = '';
if ( $conf['question_mark_in_urls']==false and
     isset($_SERVER["PATH_INFO"]) and !empty($_SERVER["PATH_INFO"]) )
{
  $section = $_SERVER["PATH_INFO"];
  $section = str_replace('//', '/', $section);
  if ( !isset($page['root_path']) )
  {
    $path_count = count( explode('/', $section) );
    $page['root_path'] = PHPWG_ROOT_PATH.str_repeat('../', $path_count-1);
  }
}
else
{
  foreach ($_GET as $key=>$value)
  {
    if (!strlen($value)) $section=$key;
    break;
  }
}

// deleting first "/" if displayed
$tokens = explode(
  '/',
  preg_replace('#^/#', '', $section)
  );
$next_token = 0;
$result = rvm_parse_blowup_url($tokens, $next_token);
$page = array_merge( $page, $result );

$order_by=null;
if ( isset($page['ll']) )
  $where_sql = rvm_ll_to_sql($page['ll'], $order_by);
else
  $where_sql = rvm_bounds_to_sql( $page['box'] );

$img_fields = ' i.id,i.tn_ext,i.name,i.path,i.lat,i.lon';

$was_flat = @$page['flat'];
$page['flat']=true;
rvm_build_section_items($img_fields, $where_sql, RVM_BUILD_HASH, $order_by);
if (!$was_flat) unset($page['flat']);

$template->set_filename( 'map', dirname(__FILE__).'/template/mapl.tpl');

if (!empty($page['items']))
{
/* GENERATE THE CATEGORY LIST *************************************************/
$where_sql = 'i.id IN ('.implode(',', array_keys($page['items']) ).')';
$where_sql .= get_sql_condition_FandF(
        array( 'forbidden_categories' => 'category_id' ),
        ' AND'
      );
$query = '
SELECT DISTINCT c.id, c.name, c.permalink, COUNT(DISTINCT i.id) counter
  FROM '.IMAGES_TABLE.' i INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON i.id=image_id
    INNER JOIN '.CATEGORIES_TABLE.' c ON c.id=category_id
  WHERE '.$where_sql.'
  GROUP BY category_id
  ORDER BY counter DESC
  LIMIT 0,5
;';
$result = pwg_query($query);
$categories=array();
while ($row=mysql_fetch_assoc($result))
  array_push($categories, $row);
$categories = add_level_to_tags($categories);

foreach( $categories as $category)
{
  $template->append(
    'related_categories', array(
      'U_MAP' => rvm_make_map_index_url( array( 'category' => $category ) ),
      'URL' => make_index_url( array( 'category' => $category ) ),
      'NAME' => trigger_event('render_element_description', $category['name']),
      'TITLE' => l10n_dec( '%d photo', '%d photos', $category['counter'] ),
      'CLASS' => 'tagLevel'.$category['level']
    )
    );
}

/* GENERATE THE TAG LIST ******************************************************/
$tags = get_common_tags( array_keys($page['items']), $conf['content_tag_cloud_items_number'], null);
$tags = add_level_to_tags($tags);
function counter_compare($a, $b)
{
  $d = $a['counter'] - $b['counter'];
  if ($d==0)
    return strcmp($a['name'], $b['name']);
  return -$d;
}
usort($tags, 'counter_compare');
foreach ($tags as $tag)
{
  $template->append(
    'related_tags',
    array_merge( $tag,
      array(
        'U_MAP' => rvm_make_map_index_url( array( 'tags' => array($tag) ) ),
        'URL' => make_index_url( array( 'tags' => array($tag) ) ),
        'TITLE' => l10n_dec( '%d photo', '%d photos', $tag['counter'] ),
      )
    )
  );
}
} // end !empty items


$title = '<a target="_top" title="'.sprintf( l10n('go to %s'),$page['title']).'" href="'.duplicate_index_url( array('start'=>0) ).'">'.$page['title'].'</a>';
if ( count($page['items']) > 0)
  $title.=' ['.count($page['items']).']';

$template->assign(
  array(
    'PLUGIN_ROOT_URL' => get_absolute_root_url().'plugins/'.$rvm_dir,
    'TITLE'   => $title,
    'U_HOME'  => make_index_url(),
    'U_KML'   => rvm_duplicate_kml_index_url( array('flat'=>1), array('start') ),
    'KML_LINK_TITLE' => sprintf( l10n('opens %s in Google Earth'), strip_tags($page['title']) ),
  )
  );

$url = rvm_duplicate_blowup_url(array('start'=>0));
$navbar = create_navigation_bar($url, count( $page['items'] ), $page['start'], 48);
$template->assign('navbar', $navbar);

$page['items'] = array_slice(
  $page['items'],
  $page['start'],
  48
  );

foreach ($page['items'] as $img)
{
  $img['file'] = basename( $img['path'] );
  $thumbnail_url = get_thumbnail_url($img);
  $page_url = duplicate_picture_url(
        array(
          'image_id' => $img['id'],
          'image_file' => $img['file'],
          'flat' => 1,
        ),
        array('start')
      );
  if (!empty( $img['name'] ) )
    $title = $img['name'];
  else
    $title = str_replace('_', ' ', get_filename_wo_extension($img['file']));

  $template->append(
    'thumbnails',
    array(
      'TN_SRC'       => $thumbnail_url,
      'URL'  => $page_url,
      'TN_ALT'   => $img['file'],
      'TN_TITLE'   => $title,
      )
    );
}

$title = $page['title'];
$page['body_id'] = 'theMapListPage';

include(PHPWG_ROOT_PATH.'include/page_header.php');
$template->parse('map');
include(PHPWG_ROOT_PATH.'include/page_tail.php');

?>