js/tbl_select.js

   1 /* vim: set expandtab sw=4 ts=4 sts=4: */
   2 /**
   3  * @fileoverview JavaScript functions used on tbl_select.php
   4  *
   5  * @requires    jQuery
   6  * @requires    js/functions.js
   7  */
   8
   9 /**
  10  * Ajax event handlers for this page
  11  *
  12  * Actions ajaxified here:
  13  * Table Search
  14  */
  15 $(document).ready(function() {
  16
  17     /**
  18      * Set a parameter for all Ajax queries made on this page.  Don't let the
  19      * web server serve cached pages
  20      */
  21     $.ajaxSetup({
  22         cache: 'false'
  23     });
  24
  25     /**
  26      * Prepare a div containing a link, otherwise it's incorrectly displayed
  27      * after a couple of clicks
  28      */
  29     $('<div id="togglesearchformdiv"><a id="togglesearchformlink"></a></div>')
  30      .insertAfter('#tbl_search_form')
  31      // don't show it until we have results on-screen
  32      .hide();
  33
  34     $('#togglesearchformlink')
  35         .html(PMA_messages['strShowSearchCriteria'])
  36         .bind('click', function() {
  37             var $link = $(this);
  38             $('#tbl_search_form').slideToggle();
  39             if ($link.text() == PMA_messages['strHideSearchCriteria']) {
  40                 $link.text(PMA_messages['strShowSearchCriteria']);
  41             } else {
  42                 $link.text(PMA_messages['strHideSearchCriteria']);
  43             }
  44             // avoid default click action
  45             return false;
  46         });
  47
  48     /**
  49      * Ajax event handler for Table Search
  50      *
  51      * (see $GLOBALS['cfg']['AjaxEnable'])
  52      * @uses    PMA_ajaxShowMessage()
  53      */
  54     $("#tbl_search_form.ajax").live('submit', function(event) {
  55         // jQuery object to reuse
  56         $search_form = $(this);
  57         event.preventDefault();
  58
  59         // empty previous search results while we are waiting for new results
  60         $("#sqlqueryresults").empty();
  61         var msgbox = PMA_ajaxShowMessage(PMA_messages['strSearching']);
  62
  63         PMA_prepareForAjaxRequest($search_form);
  64
  65         $.post($search_form.attr('action'), $search_form.serialize(), function(response) {
  66             if (typeof response == 'string') {
  67                 // found results
  68                 $("#sqlqueryresults").html(response);
  69                 $("#sqlqueryresults").trigger('appendAnchor');
  70                 $('#tbl_search_form')
  71                 // workaround for bug #3168569 - Issue on toggling the "Hide search criteria" in chrome.
  72                  .slideToggle()
  73                  .hide();
  74                 $('#togglesearchformlink')
  75                  // always start with the Show message
  76                  .text(PMA_messages['strShowSearchCriteria'])
  77                 $('#togglesearchformdiv')
  78                  // now it's time to show the div containing the link
  79                  .show();
  80             } else {
  81                 // error message (zero rows)
  82                 $("#sqlqueryresults").html(response['message']);
  83             }
  84
  85             msgbox.clearQueue().fadeOut('medium', function() {
  86                 $(this).hide();
  87             });
  88         }) // end $.post()
  89     })
  90
  91     // Following section is related to the 'function based search' for geometry data types.
  92     // Initialy hide all the open_gis_editor spans
  93     $('.open_search_gis_editor').hide();
  94
  95     $('.geom_func').bind('change', function() {
  96         var $geomFuncSelector = $(this);
  97
  98         var binaryFunctions = [
  99           'Contains',
 100           'Crosses',
 101           'Disjoint',
 102           'Equals',
 103           'Intersects',
 104           'Overlaps',
 105           'Touches',
 106           'Within',
 107           'MBRContains',
 108           'MBRDisjoint',
 109           'MBREquals',
 110           'MBRIntersects',
 111           'MBROverlaps',
 112           'MBRTouches',
 113           'MBRWithin',
 114           'ST_Contains',
 115           'ST_Crosses',
 116           'ST_Disjoint',
 117           'ST_Equals',
 118           'ST_Intersects',
 119           'ST_Overlaps',
 120           'ST_Touches',
 121           'ST_Within',
 122         ];
 123
 124         var tempArray = [
 125            'Envelope',
 126            'EndPoint',
 127            'StartPoint',
 128            'ExteriorRing',
 129            'Centroid',
 130            'PointOnSurface'
 131         ];
 132         var outputGeomFunctions = binaryFunctions.concat(tempArray);
 133
 134         // If the chosen function takes two geomerty objects as parameters
 135         var $operator = $geomFuncSelector.parents('tr').find('td:nth-child(5)').find('select');
 136         if ($.inArray($geomFuncSelector.val(), binaryFunctions) >= 0){
 137             $operator.attr('readonly', true);
 138         } else {
 139             $operator.attr('readonly', false);
 140         }
 141
 142         // if the chosen function's output is a geometry, enable GIS editor
 143         var $editorSpan = $geomFuncSelector.parents('tr').find('.open_search_gis_editor');
 144         if ($.inArray($geomFuncSelector.val(), outputGeomFunctions) >= 0){
 145             $editorSpan.show();
 146         } else {
 147             $editorSpan.hide();
 148         }
 149
 150     });
 151
 152     $('.open_search_gis_editor').live('click', function(event) {
 153         event.preventDefault();
 154
 155         var $span = $(this);
 156         // Current value
 157         var value = $span.parent('td').children("input[type='text']").val();
 158         // Field name
 159         var field = 'Parameter';
 160         // Column type
 161         var geom_func = $span.parents('tr').find('.geom_func').val();
 162         if (geom_func == 'Envelope') {
 163             var type = 'polygon';
 164         } else if (geom_func == 'ExteriorRing') {
 165             var type = 'linestring';
 166         } else {
 167             var type = 'point';
 168         }
 169         // Names of input field and null checkbox
 170         var input_name = $span.parent('td').children("input[type='text']").attr('name');
 171         //Token
 172         var token = $("input[name='token']").val();
 173
 174         openGISEditor(value, field, type, input_name, token);
 175     });
 176
 177 }, 'top.frame_content'); // end $(document).ready()