[Mapbender_dev] Re: [Mapbender] #786: savewms and loadwmc in my updated guis

[Mapbender]

#786: savewms and loadwmc in my updated guis
-------------------------------------------------------+--------------------
 Reporter:  frankjaeger                                |       Owner:  dev          
     Type:  defect                                     |      Status:  new          
 Priority:  major                                      |   Milestone:  2.7.1 release
Component:  installation                               |     Version:  2.7          
 Keywords:  savewmc, loadwmc,jq_ui_dialog,savewmcHtml  |  
-------------------------------------------------------+--------------------

Comment(by astrid_emde):

 Vorschlag für SQL von Frank:


 -- Einfuegen jq_ui_dialog
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment,
 e_title,
 e_element, e_src, e_attributes,
     e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content,
 e_closetag, e_js_file, e_mb_mod,
     e_target, e_requires, e_url)
 SELECT gui.gui_id,'jq_ui_dialog',5,1,
   'Module to manage jQuery UI dialog windows with multiple options for
 customization.','',
   'div','','',-1,-1,NULL ,NULL ,NULL ,'','','div','',
   '../extensions/jquery-ui-1.8.1.custom/development-
 bundle/ui/jquery.ui.dialog.js','',
 'jq_ui,jq_ui_widget,jq_ui_button,jq_ui_draggable,jq_ui_mouse,jq_ui_position,jq_ui_resizable',''
 FROM gui
 WHERE gui.gui_id NOT LIKE 'admin%'
   AND gui.gui_id NOT LIKE 'wms%'
   AND gui.gui_id
       NOT IN (SELECT fkey_gui_id
                 FROM gui_element
                WHERE e_id = 'jq_ui_dialog')
   --AND gui.gui_id
   --        IN (SELECT fkey_gui_id
   --              FROM gui_element
   --             WHERE e_id in ('loadwmc','savewmc'))
 ;

 -- Einfuegen jq_ui_button
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment,
 e_title,
 e_element, e_src, e_attributes,
    e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content,
 e_closetag, e_js_file, e_mb_mod,
    e_target, e_requires, e_url)
 SELECT gui.gui_id,'jq_ui_button',4,1,
   'jQuery UI button','','','','',NULL ,NULL ,NULL ,NULL ,NULL
 ,'','','','',
   '../extensions/jquery-ui-1.8.1.custom/development-
 bundle/ui/jquery.ui.button.js',
   '','jq_ui,jq_ui_widget',''
 FROM gui
 WHERE gui.gui_id NOT LIKE 'admin%'
   AND gui.gui_id NOT LIKE 'wms%'
   AND gui.gui_id
       NOT IN (SELECT fkey_gui_id
               FROM   gui_element
               WHERE  e_id = 'jq_ui_button')
   --AND gui.gui_id
   --        IN (SELECT fkey_gui_id
   --              FROM gui_element
   --             WHERE e_id in ('loadwmc','savewmc'))

-- 
Ticket URL: <http://trac.osgeo.org/mapbender/ticket/786#comment:2>
Mapbender <http://www.mapbender.org/>
Mapbender