<?php 
if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');

$admin_url = PHPWG_ROOT_PATH.'admin.php';

if ( !isset($_GET['cat']) )
  $_GET['cat'] = 'caddie';
$_GET['mode'] = 'map';
include (PHPWG_ROOT_PATH.'admin/element_set.php');

$template->concat('TABSHEET_TITLE', ' '.l10n_dec('%d photo', '%d photos', count($page['cat_elements_id'])).' - '.$page['title']);

if ( isset($_POST['submit']) )
{
  $collection = array();

  switch ($_POST['target'])
  {
    case 'all' :
      $collection = $page['cat_elements_id'];
      break;
    case 'selection' :
      if (!isset($_POST['selection']) or count($_POST['selection']) == 0)
        array_push($page['errors'], l10n('Select at least one picture'));
      else
        $collection = $_POST['selection'];
      break;
  }
  if ( count($collection)>0 )
  {
    $lat = trim($_POST['lat']);
    $lon = trim($_POST['lon']);

    if ( strlen($lat)>0 and strlen($lon)>0 )
    {
      if ( (double)$lat<=90 and (double)$lat>=-90
          and (double)$lon<=180 and (double)$lat>=-180 )
        $update_query = 'lat='.$lat.', lon='.$lon;
      else
        $page['errors'][] = 'Invalid lat or lon value';
    }
    elseif ( strlen($lat)==0 and strlen($lon)==0 )
      $update_query = 'lat=NULL, lon=NULL';
    else
      $page['errors'][] = 'Both lat/lon must be empty or not empty';

    if (isset($update_query))
    {
      $update_query = '
UPDATE '.IMAGES_TABLE.' SET '.$update_query.'
  WHERE id IN ('.implode(',',$collection).')';
      pwg_query($update_query);
      rvm_invalidate_cache();
    }
  }
}


$template->append(
  'specials',
  array(
		$admin_url.get_query_string_diff(array('start','cat')).'&amp;cat=caddie' => l10n('Caddie')
    ),
	true
  );

$query = '
SELECT id,name,uppercats,global_rank
  FROM '.CATEGORIES_TABLE.'
;';
$result = pwg_query($query);
$categories = array();
$selecteds = array();
if (!empty($result))
{
  while ($row = mysql_fetch_assoc($result))
  {
    $url = $admin_url.get_query_string_diff(array('start','cat')).'&amp;cat='.$row['id'];
    if ( $row['id']==$_GET['cat'] ) $selecteds[] = $url;
    $row['id']=$url;
    array_push($categories, $row);
  }
}
usort($categories, 'global_rank_compare');
display_select_categories($categories, $selecteds, 'categories', false);

if (!empty($_GET['display']))
{
  if ('all' == $_GET['display'])
    $page['nb_images'] = count($page['cat_elements_id']);
  else
    $page['nb_images'] = intval($_GET['display']);
}
else
  $page['nb_images'] = 20;

if ( !empty($page['cat_elements_id']) )
{
  $nav_bar = create_navigation_bar(
    $admin_url.get_query_string_diff(array('start')),
    count($page['cat_elements_id']),
    $page['start'],
    $page['nb_images']
    );
  $template->assign('navbar', $nav_bar);
}

$images=array();
if ( !empty($page['cat_elements_id']) )
{
  $query='
SELECT id,tn_ext,name,path,file,lat,lon FROM '.IMAGES_TABLE.'
  WHERE id IN ('.implode(',',$page['cat_elements_id']).')
  '.$conf['order_by'].'
  LIMIT '.$page['start'].', '.$page['nb_images'].'
;';
  $result = pwg_query($query);
  while ( $row=mysql_fetch_assoc($result) )
    $images[] = $row;
}

foreach ($images as $image)
{
	$tpl_var = array_merge( $image,
      array(
        'U_TN' => get_thumbnail_url($image),
        'TITLE' => get_thumbnail_title($image)
      )
    );
  if ( isset($image['lat']) )
    $tpl_var['U_MAP'] = rvm_make_map_picture_url( array('image_id'=>$image['id'], 'image_file'=>$image['file']) );
	$template->append('thumbnails', $tpl_var);
}

$template->assign(
    array(
      'U_DISPLAY'=> $admin_url.get_query_string_diff(array('display'))
    ) 
  );

?>