source: extensions/piwigo-openstreetmap/admin/admin_sync.php @ 31930

<?php
/***********************************************
* File      :   admin_sync.php
* Project   :   piwigo-openstreetmap
* Descr     :   Generate the admin panel
* Base on   :   RV Maps & Earth plugin
*
* Created   :   12.06.2013
*
* Copyright 2013 <xbgmsharp@gmail.com>
*
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program.  If not, see <http://www.gnu.org/licenses/>.
*
************************************************/

// Check whether we are indeed included by Piwigo.
if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');

// Geneate default value
$sync_options = array(
        'simulate'              => true,
        'cat_id'                => 0,
        'subcats_included'      => true,
);

if ( isset($_POST['submit']) )
{
        // Override default value from the form
        $sync_options = array(
                'simulate' => isset($_POST['simulate']),
                'cat_id' => isset($_POST['cat_id']) ? (int)$_POST['cat_id'] : 0,
                'subcats_included' => isset($_POST['subcats_included']),
        );

        include_once(PHPWG_ROOT_PATH.'include/functions_picture.inc.php');
        include_once( dirname(__FILE__).'/../include/functions_metadata.php' );
        $where_clauses = array();
        if ( $sync_options['cat_id']!=0 )
        {
                $query=' SELECT id FROM '.CATEGORIES_TABLE.' WHERE ';

                if ( $sync_options['subcats_included'])
                        $query .= 'uppercats REGEXP \'(^|,)'.$sync_options['cat_id'].'(,|$)\'';
                else
                        $query .= 'id='.$sync_options['cat_id'];
                        $cat_ids = array_from_query($query, 'id');
        
                $query='SELECT `id`, `path` ,`lat` ,`lon` FROM '.IMAGES_TABLE.' INNER JOIN '.IMAGE_CATEGORY_TABLE.' ON id=image_id
                        WHERE category_id IN ('.implode(',', $cat_ids).')
                        GROUP BY id';
        }
        else
        {
                $query='SELECT `id`, `path` ,`lat` ,`lon` FROM '.IMAGES_TABLE;
        }

        $images = hash_from_query( $query, 'id');
        $datas = array();
        $errors = array();
        foreach ($images as $image)
        {
                $filename = $image['path'];
                $exif = @read_exif_data( $filename );
                if ( empty($exif) )
                        continue;

                $ll = osm_exif_to_lat_lon($exif);
                if (!is_array($ll))
                {
                        if (!empty($ll))
                                $errors[] = $filename. ': '.$ll;
                        continue;
                }
                
                $infos[] = $filename. " has exif_data";
                $datas[] = array (
                        'id'    => $image['id'],
                        'lat'   => $ll[0],
                        'lon'   => $ll[1],
                );
        }

        if ( count($datas)>0 and !$sync_options['simulate'] )
        {
                mass_updates(
                        IMAGES_TABLE,
                                array(
                                        'primary'       => array('id'),
                                        'update'        => array('lat', 'lon')
                                ),
                                $datas
                );
        }


        // Send sync result to template
        $template->assign('sync_errors', $errors );
        $template->assign('sync_infos', $infos );

        // Send result to templates
        $template->assign(
                'metadata_result',
                array(
                        'NB_ELEMENTS_DONE'              => count($datas),
                        'NB_ELEMENTS_CANDIDATES'        => count($images),
                        'NB_ERRORS'                     => count($errors),
                )
        );
}

$query = 'SELECT COUNT(*) FROM '.IMAGES_TABLE.' WHERE `lat` IS NOT NULL and `lon` IS NOT NULL ';
list($nb_geotagged) = pwg_db_fetch_array( pwg_query($query) );

$query = 'SELECT id, CONCAT(name, IF(dir IS NULL, " (V)", "") ) AS name, uppercats, global_rank  FROM '.CATEGORIES_TABLE;
display_select_cat_wrapper($query,
                           array( $sync_options['cat_id'] ),
                           'categories',
                           false);

// Send value to templates
$template->assign(
        array(
                'SUBCATS_INCLUDED_CHECKED'      => $sync_options['subcats_included'] ? 'checked="checked"' : '',
                'NB_GEOTAGGED'                  => $nb_geotagged,
        )
);

?>