"; $f->displayDescription($description); $f->setRight("om_sig_map_wms"); $f->isAuthorized(); // Paramétrage =============================================================== $DEBUG=0; if (isset($_GET['idx'])) { $sql = "INSERT INTO ".DB_PREFIXE."om_sig_map_wms( om_sig_map_wms, om_sig_wms, om_sig_map, ol_map, ordre, visibility, ". "panier, pa_nom, pa_layer, pa_attribut, pa_encaps, pa_sql, pa_type_geometrie, sql_filter, baselayer, singletile, maxzoomlevel) ". "SELECT nextval('".DB_PREFIXE."om_sig_map_wms_seq'), ori.om_sig_wms, map.om_sig_map, ori.ol_map, CASE WHEN ord.ordre IS NULL THEN 1 ELSE ord.ordre+1 END AS ordre, ". "ori.visibility, ori.panier, ori.pa_nom, ori.pa_layer, ori.pa_attribut, ori.pa_encaps, ori.pa_sql, ori.pa_type_geometrie, ori.sql_filter, ori.baselayer, ori.singletile, ori.maxzoomlevel ". "FROM ".DB_PREFIXE."om_sig_map map LEFT JOIN (SELECT om_sig_map, max(ordre) AS ordre FROM ".DB_PREFIXE."om_sig_map_wms group by om_sig_map) ord ON ord.om_sig_map = map.om_sig_map ". "JOIN ".DB_PREFIXE."om_sig_map_wms ori ON ori.om_sig_map_wms = ".$_GET['idx']." WHERE map.om_sig_map NOT IN ( SELECT distinct om_sig_map FROM ".DB_PREFIXE."om_sig_map_wms ". "WHERE om_sig_wms IN (SELECT om_sig_wms FROM ".DB_PREFIXE."om_sig_map_wms WHERE om_sig_map_wms = ".$_GET['idx']."))"; $res=$f->db->query($sql); $f->isDatabaseError($res); echo '
'; echo 'Copie terminée'; } ?>