source: extensions/rv_gmaps/trunk/admin/admin_boot.php @ 17705

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

include_once( dirname(dirname(__FILE__)) .'/include/functions.php');

add_event_handler('invalidate_user_cache', 'rvm_invalidate_cache' );

add_event_handler('get_admin_plugin_menu_links', 'rvm_plugin_admin_menu' );
function rvm_plugin_admin_menu($menu)
{
        array_push($menu,
                        array(
                                'NAME' => 'Maps & Earth',
                                'URL' => get_admin_plugin_menu_link(dirname(__FILE__).'/admin.php')
                        )
                );
        return $menu;
}

add_event_handler('get_batch_manager_prefilters', 'rvm_get_batch_manager_prefilters');
function rvm_get_batch_manager_prefilters($prefilters)
{
        rvm_load_language();
        $prefilters[] = array('ID' => 'geotagged', 'NAME' => l10n('Geotagged'));
        $prefilters[] = array('ID' => 'not geotagged', 'NAME' => l10n('Not geotagged'));
        return $prefilters;
}

add_event_handler('perform_batch_manager_prefilters', 'rvm_perform_batch_manager_prefilters', 50, 2);
function rvm_perform_batch_manager_prefilters($filter_sets, $prefilter)
{
        if ($prefilter==="geotagged")
                $query = 'lat IS NOT NULL AND lon IS NOT NULL';
        elseif ($prefilter==="not geotagged")
                $query = 'lat IS NULL OR lon IS NULL';

        if ( isset($query) )
        {
    $query = '
SELECT id
  FROM '.IMAGES_TABLE.'
  WHERE '.$query;
                $filter_sets[] = array_from_query($query, 'id');
        }
        return $filter_sets;
}

add_event_handler('loc_end_element_set_global', 'rvm_loc_end_element_set_global');
function rvm_loc_end_element_set_global()
{
        rvm_load_language();
        global $template;
        $template->append('element_set_global_plugins_actions',
                array('ID' => 'geotag', 'NAME'=>l10n('Geotag'), 'CONTENT' => '
  <label>{\'Latitude\'|@translate} (-90=S to 90=N)
    <input type="text" size="8" name="lat">
  </label>
  <label>{\'Longitude\'|@translate} (-180=E to 180=W)
    <input type="text" size="9" name="lon">
  </label> (Empty values will erase coordinates)
'));
}

add_event_handler('element_set_global_action', 'rvm_element_set_global_action', 50, 2);
function rvm_element_set_global_action($action, $collection)
{
        if ($action!=="geotag")
                return;
        global $page;
        $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)$lon>=-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();
  }
}

add_event_handler('loc_begin_element_set_unit', 'rvm_loc_begin_element_set_unit');
function rvm_loc_begin_element_set_unit()
{
  global $page;
  
  if (isset($_POST['submit']))
  {
    $collection = explode(',', $_POST['element_ids']);
    
    $datas = array();
    $errors = array();
    
    $query = '
SELECT id, name
  FROM '.IMAGES_TABLE.'
  WHERE id IN ('.implode(',', $collection).')
;';
    $result = pwg_query($query);
    
    while ($row = pwg_db_fetch_assoc($result))
    {
      $data = array();
      $error = false;
      $data['id'] = $row['id'];
      $data['lat'] = trim($_POST['lat-'.$row['id']]);
      $data['lon'] = trim($_POST['lon-'.$row['id']]);
      
      if ( strlen($data['lat'])>0 and strlen($data['lon'])>0 )
      {
        if ( (double)$data['lat']>90 or (double)$data['lat']<-90
            or (double)$data['lon']>180 or (double)$data['lon']<-180 )
          $error = true;
      }
      elseif ( strlen($data['lat'])==0 and strlen($data['lon'])==0 )
      {
        // nothing
      }
      else
      {
        $error = true;
      }
      
      if ($error)
        array_push($errors, $row['name']);
      else
        array_push($datas, $data);
    }
    
    mass_updates(
      IMAGES_TABLE,
      array(
        'primary' => array('id'),
        'update' => array('lat', 'lon')
        ),
      $datas
      );
    
    if (count($errors)>0)
    {
      array_push($page['errors'], 'Invalid lat or lon value for files: '.implode(', ', $errors));
    }
  }
}

add_event_handler('loc_end_element_set_unit', 'rvm_loc_end_element_set_unit');
function rvm_loc_end_element_set_unit()
{
  global $template, $conf, $page, $is_category, $category_info;
  
  $query = '
SELECT id,lat,lon
  FROM '.IMAGES_TABLE;
  
  if ($is_category)
  {
    $category_info = get_cat_info($_SESSION['bulk_manager_filter']['category']);
    
    $conf['order_by'] = $conf['order_by_inside_category'];
    if (!empty($category_info['image_order']))
    {
      $conf['order_by'] = ' ORDER BY '.$category_info['image_order'];
    }

    $query.= '
    JOIN '.IMAGE_CATEGORY_TABLE.' ON id = image_id';
  }

  $query.= '
  WHERE id IN ('.implode(',', $page['cat_elements_id']).')';

  if ($is_category)
  {
    $query.= '
    AND category_id = '.$_SESSION['bulk_manager_filter']['category'];
  }

  $query.= '
  '.$conf['order_by'].'
  LIMIT '.$page['nb_images'].' OFFSET '.$page['start'].'
;';
  $result = pwg_query($query);

  $tpl_vars = array();
  while ($row = pwg_db_fetch_assoc($result))
  {
    // remove last zeros for better display
    $row['lat'] = preg_replace('#\.([0-9]*?)([0]+)$#', '.$1', $row['lat']);
    $row['lon'] = preg_replace('#\.([0-9]*?)([0]+)$#', '.$1', $row['lon']);
    
    $tpl_vars[ $row['id'] ] = array(
      'LAT' => rtrim($row['lat'], '.'),
      'LON' => rtrim($row['lon'], '.'),
      );
  }
  
  $template->assign('GEOTAG', $tpl_vars);
  
  $template->set_prefilter('batch_manager_unit', 'rvm_prefilter_batch_manager_unit');
}

function rvm_prefilter_batch_manager_unit($content, &$smarty)
{
  $search = '<td><strong>{\'Who can see this photo?\'|@translate}</strong></td>';
  $add = '<td><strong>{\'Geotag\'|@translate}</strong></td>
      <td>
        <label>{\'Latitude\'|@translate}
          <input type="text" size="8" name="lat-{$element.ID}" value="{$GEOTAG[$element.ID].LAT}">
        </label>
        <label>{\'Longitude\'|@translate}
          <input type="text" size="9" name="lon-{$element.ID}" value="{$GEOTAG[$element.ID].LON}">
        </label>
      </td>
    </tr>

    <tr>
      ';
  return str_replace($search, $add.$search, $content);
}
?>