1 /* vim: set expandtab sw=4 ts=4 sts=4: */
3 * @fileoverview JavaScript functions used on tbl_select.php
6 * @requires js/functions.js
10 * Ajax event handlers for this page
12 * Actions ajaxified here:
15 $(document).ready(function() {
17 * Prepare a div containing a link, otherwise it's incorrectly displayed
18 * after a couple of clicks
20 $('<div id="togglesearchformdiv"><a id="togglesearchformlink"></a></div>')
21 .insertAfter('#tbl_search_form')
22 // don't show it until we have results on-screen
25 $('#togglesearchformlink')
26 .html(PMA_messages['strShowSearchCriteria'])
27 .bind('click', function() {
29 $('#tbl_search_form').slideToggle();
30 if ($link.text() == PMA_messages['strHideSearchCriteria']) {
31 $link.text(PMA_messages['strShowSearchCriteria']);
33 $link.text(PMA_messages['strHideSearchCriteria']);
35 // avoid default click action
40 * Ajax event handler for Table Search
42 * (see $GLOBALS['cfg']['AjaxEnable'])
43 * @uses PMA_ajaxShowMessage()
45 $("#tbl_search_form.ajax").live('submit', function(event) {
47 var unaryFunctions = [
53 // jQuery object to reuse
54 $search_form = $(this);
55 event.preventDefault();
57 // empty previous search results while we are waiting for new results
58 $("#sqlqueryresults").empty();
59 var $msgbox = PMA_ajaxShowMessage(PMA_messages['strSearching'], false);
61 PMA_prepareForAjaxRequest($search_form);
64 $search_form.find(':input').each(function() {
66 if ($input.attr('type') == 'checkbox' || $input.attr('type') == 'radio') {
67 if ($input.is(':checked')) {
68 values[this.name] = $input.val();
71 values[this.name] = $input.val();
74 var columnCount = $('select[name="param[]"] option').length;
75 // Submit values only for the columns that have unary column operator or a search criteria
76 for (var a = 0; a < columnCount; a++) {
78 if ($.inArray(values['func[' + a + ']'], unaryFunctions) >= 0) {
81 if (values['fields[' + a + ']'] == '' || values['fields[' + a + ']'] == null) {
82 delete values['fields[' + a + ']'];
83 delete values['func[' + a + ']'];
84 delete values['names[' + a + ']'];
85 delete values['types[' + a + ']'];
86 delete values['collations[' + a + ']'];
89 // If all columns are selected, use a single parameter to indicate that
90 if (values['param[]'] != null) {
91 if (values['param[]'].length == columnCount) {
92 delete values['param[]'];
93 values['displayAllColumns'] = true;
96 values['displayAllColumns'] = true;
99 $.post($search_form.attr('action'), values, function(response) {
100 PMA_ajaxRemoveMessage($msgbox);
101 if (typeof response == 'string') {
103 $("#sqlqueryresults").html(response);
104 $("#sqlqueryresults").trigger('makegrid');
105 $('#tbl_search_form')
106 // workaround for bug #3168569 - Issue on toggling the "Hide search criteria" in chrome.
109 $('#togglesearchformlink')
110 // always start with the Show message
111 .text(PMA_messages['strShowSearchCriteria'])
112 $('#togglesearchformdiv')
113 // now it's time to show the div containing the link
115 // needed for the display options slider in the results
118 // error message (zero rows)
119 if (response.message != undefined) {
120 $("#sqlqueryresults").html(response['message']);
122 // other error (syntax error?)
123 if (response.error != undefined) {
124 $("#sqlqueryresults").html(response['error']);
130 // Following section is related to the 'function based search' for geometry data types.
131 // Initialy hide all the open_gis_editor spans
132 $('.open_search_gis_editor').hide();
134 $('.geom_func').bind('change', function() {
135 var $geomFuncSelector = $(this);
137 var binaryFunctions = [
171 var outputGeomFunctions = binaryFunctions.concat(tempArray);
173 // If the chosen function takes two geomerty objects as parameters
174 var $operator = $geomFuncSelector.parents('tr').find('td:nth-child(5)').find('select');
175 if ($.inArray($geomFuncSelector.val(), binaryFunctions) >= 0){
176 $operator.attr('readonly', true);
178 $operator.attr('readonly', false);
181 // if the chosen function's output is a geometry, enable GIS editor
182 var $editorSpan = $geomFuncSelector.parents('tr').find('.open_search_gis_editor');
183 if ($.inArray($geomFuncSelector.val(), outputGeomFunctions) >= 0){
191 $('.open_search_gis_editor').live('click', function(event) {
192 event.preventDefault();
196 var value = $span.parent('td').children("input[type='text']").val();
198 var field = 'Parameter';
200 var geom_func = $span.parents('tr').find('.geom_func').val();
201 if (geom_func == 'Envelope') {
202 var type = 'polygon';
203 } else if (geom_func == 'ExteriorRing') {
204 var type = 'linestring';
208 // Names of input field and null checkbox
209 var input_name = $span.parent('td').children("input[type='text']").attr('name');
211 var token = $("input[name='token']").val();
214 if (!gisEditorLoaded) {
215 loadJSAndGISEditor(value, field, type, input_name, token);
217 loadGISEditor(value, field, type, input_name, token);
221 }, 'top.frame_content'); // end $(document).ready()