'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' => '
(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 = '| {\'Who can see this photo?\'|@translate} | ';
$add = '{\'Geotag\'|@translate} |
|
';
return str_replace($search, $add.$search, $content);
}
?>