source: extensions/edit_gmaps/admin/admin_edit.php @ 4545

<?php 
if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');
global $lang;
load_language('lang', dirname(__FILE__).'/../');
$admin_url = PHPWG_ROOT_PATH.'admin.php';

$sql="SELECT * 
FROM `".$prefixeTable."plugins` 
WHERE `id` LIKE 'edit_gmaps'
";
 $result = @pwg_query($sql);
        if ($result) {
            $versions = mysql_fetch_array($result,MYSQL_ASSOC);
        }
$version= $versions['version'];

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 element', '%d elements', count($page['cat_elements_id'])).' - '.$page['title']);

 
if ( isset($_POST['submit']) and !is_adviser() )
{


  $collection = array();
$_POST['target']=isset($_POST['target']) ? $_POST['target']: "" ;
  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;
  }
//===========================================================================  
$match="";

  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 ($_POST['submit']=='Valider' )
  {
        if (isset($update_query))
        {
                $update_query = '
                                        UPDATE '.IMAGES_TABLE.' SET '.$update_query.'
                                        WHERE id IN ('.implode(',',$collection).')';
                pwg_query($update_query);
                rvm_invalidate_cache();
        }
                 $_POST['selection']=array();
                 unset($collection);
                 
        }
  }
//===========================================================================  

 if ($_POST['submit']=='Raz' )
 {
       $_POST['selection']=array();
            unset($collection);
 }
 if ($_POST['submit']=='cherche' )
  {  
  $match  = $_POST['match'] ;

   
  }
 }
 
$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('NAV_BAR', $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')),
           'VERSION'=> $version,
              ) 
  );
//==================================================================================  
$template->assign(
    array(        
                        'GMAPS_API_KEY' => $conf['gmaps_api_key'],
                 )
           );
//==================================================================================
$src="";

if (isset($collection)) 
{   
    $lat =1000;

if ($match<>"" && $match<>"/" )
{   
$match=str_replace(" ","+",$match);

       $src="http://maps.google.com/maps/geo?q=".$match."&output=xml&sensor=true_or_false&key=".$conf['gmaps_api_key'];
//json,kml,xml,csv
  
                $location = file_get_contents($src);
                $location = explode("coordinates>",$location );
                $location = explode(",",$location[1]);
                $lat=$location[1];
                $lon=$location[0];
                                $template->assign(      array('lat' => $lat ,
                                                                      'lon' => $lon ,));
   }
                                                                        
  foreach ($collection as $id_0)  {
                foreach ($images as $image)  {

                        if (array_search($id_0,$image)) {
                         if ($lat==1000) {
                            $lat= ($image['lat'] <> '') ? $image['lat'] : '49.0'  ;
                                $lon= ($image['lon']  <> '') ? $image['lon'] : '3.0'  ;
                                $template->assign(      array('lat' => $lat ,
                                                                      'lon' => $lon ,
                                                              )
                                );
                        }
                  
                         $tpl_var = array_merge( 
                                    $image,
                                        array(
                                                 'src'  => $src ,
                                                   'match' => $_POST['match']  ,
                                                   'check' => $_POST['submit']  ,
                                                'U_TN' => get_thumbnail_url($image),
                                                'TITLE' => get_thumbnail_title($image),
                                                        'U_MAP' => rvm_make_map_picture_url(
                                                                                            array(
                                                                                                 'image_id'=>$image['id'],
                                                                                                 'image_file'=>$image['file'],
                                                                                                 ) 

                                                                                    ),
                                                                )                                                               
                                                );
                                                 
                $template->append('Selectthumbnails', $tpl_var);        
                
                }
        }       
}


}
 if ($_POST['submit']=='Valider' )
 {
 
  $_POST['selection']=array();  
   $collection =array();  
  }
  //=======================================================================

?>