1 /* vim: set expandtab sw=4 ts=4 sts=4: */
3 * @fileoverview functions used wherever an sql query form is used
6 * @requires js/functions.js
11 * decode a string URL_encoded
14 * @return string the URL-decoded string
17 function PMA_urldecode(str) {
18 return decodeURIComponent(str.replace(/\+/g, '%20'));
22 * Get the field name for the current field. Required to construct the query
25 * @param $this_field jQuery object that points to the current field's tr
26 * @param disp_mode string
28 function getFieldName($this_field, disp_mode) {
30 if(disp_mode == 'vertical') {
31 var field_name = $this_field.siblings('th').find('a').text();
32 // happens when just one row (headings contain no a)
33 if ("" == field_name) {
34 field_name = $this_field.siblings('th').text();
38 var this_field_index = $this_field.index();
39 // ltr or rtl direction does not impact how the DOM was generated
41 // 5 columns to account for the checkbox, edit, appended inline edit, copy and delete anchors but index is zero-based so substract 4
42 var field_name = $('#table_results').find('thead').find('th:nth('+ (this_field_index-4 )+') a').text();
43 // happens when just one row (headings contain no a)
44 if ("" == field_name) {
45 field_name = $('#table_results').find('thead').find('th:nth('+ (this_field_index-4 )+')').text();
49 field_name = $.trim(field_name);
55 * The function that iterates over each row in the table_results and appends a
56 * new inline edit anchor to each table row.
59 function appendInlineAnchor() {
60 var disp_mode = $("#top_direction_dropdown").val();
62 if (disp_mode == 'vertical') {
63 // there can be one or two tr containing this class, depending
64 // on the ModifyDeleteAtLeft and ModifyDeleteAtRight cfg parameters
65 $('#table_results tr')
66 .find('.edit_row_anchor')
67 .removeClass('.edit_row_anchor')
68 .parent().each(function() {
69 var $this_tr = $(this);
70 var $cloned_tr = $this_tr.clone();
72 var $img_object = $cloned_tr.find('img:first').attr('title', PMA_messages['strInlineEdit']);
73 if ($img_object.length != 0) {
74 var img_src = $img_object.attr('src').replace(/b_edit/,'b_inline_edit');
75 $img_object.attr('src', img_src);
79 .addClass('inline_edit_anchor')
80 .find('a').attr('href', '#')
82 .text(' ' + PMA_messages['strInlineEdit'])
83 .prepend($img_object);
85 $cloned_tr.insertAfter($this_tr);
88 $('#rowsDeleteForm').find('tbody').find('th').each(function() {
89 var $this_th = $(this);
90 if ($this_th.attr('rowspan') == 4) {
91 $this_th.attr('rowspan', '5');
97 $('.edit_row_anchor').each(function() {
99 var $this_td = $(this);
100 $this_td.removeClass('edit_row_anchor');
102 var $cloned_anchor = $this_td.clone();
104 var $img_object = $cloned_anchor.find('img').attr('title', PMA_messages['strInlineEdit']);
105 if ($img_object.length != 0) {
106 var img_src = $img_object.attr('src').replace(/b_edit/,'b_inline_edit');
107 $img_object.attr('src', img_src);
109 .find('a').attr('href', '#')
111 .text(' ' + PMA_messages['strInlineEdit']);
115 .prepend($img_object);
117 // the link was too big so <input type="image"> is there
118 $img_object = $cloned_anchor.find('input:image').attr('title', PMA_messages['strInlineEdit']);
119 var img_src = $img_object.attr('src').replace(/b_edit/,'b_inline_edit');
120 $img_object.attr('src', img_src);
122 .find('.clickprevimage')
123 .text(' ' + PMA_messages['strInlineEdit']);
127 .addClass('inline_edit_anchor');
129 $this_td.after($cloned_anchor);
132 $('#rowsDeleteForm').find('thead, tbody').find('th').each(function() {
133 var $this_th = $(this);
134 if ($this_th.attr('colspan') == 4) {
135 $this_th.attr('colspan', '5');
146 * @description <p>Ajax scripts for sql and browse pages</p>
148 * Actions ajaxified here:
150 * <li>Retrieve results of an SQL query</li>
151 * <li>Paginate the results table</li>
152 * <li>Sort the results table</li>
153 * <li>Change table according to display options</li>
154 * <li>Inline editing of data</li>
157 * @name document.ready
160 $(document).ready(function() {
163 * Set a parameter for all Ajax queries made on this page. Don't let the
164 * web server serve cached pages
171 * current value of the direction in which the table is displayed
176 var disp_mode = $("#top_direction_dropdown").val();
179 * Update value of {@link jQuery.disp_mode} everytime the direction dropdown changes value
181 * @name direction_dropdown_change
183 $("#top_direction_dropdown, #bottom_direction_dropdown").live('change', function(event) {
184 disp_mode = $(this).val();
188 * Attach the {@link appendInlineAnchor} function to a custom event, which
189 * will be triggered manually everytime the table of results is reloaded
192 $("#sqlqueryresults").live('appendAnchor',function() {
193 appendInlineAnchor();
197 * Trigger the appendAnchor event to prepare the first table for inline edit
198 * (see $GLOBALS['cfg']['AjaxEnable'])
200 * @name sqlqueryresults_trigger
202 $("#sqlqueryresults.ajax").trigger('appendAnchor');
205 * Append the "Show/Hide query box" message to the query input form
208 * @name appendToggleSpan
210 // do not add this link more than once
211 if (! $('#sqlqueryform').find('a').is('#togglequerybox')) {
212 $('<a id="togglequerybox"></a>')
213 .html(PMA_messages['strHideQueryBox'])
214 .appendTo("#sqlqueryform")
215 // initially hidden because at this point, nothing else
216 // appears under the link
219 // Attach the toggling of the query box visibility to a click
220 $("#togglequerybox").bind('click', function() {
222 $link.siblings().slideToggle("fast");
223 if ($link.text() == PMA_messages['strHideQueryBox']) {
224 $link.text(PMA_messages['strShowQueryBox']);
225 // cheap trick to add a spacer between the menu tabs
226 // and "Show query box"; feel free to improve!
227 $('#togglequerybox_spacer').remove();
228 $link.before('<br id="togglequerybox_spacer" />');
230 $link.text(PMA_messages['strHideQueryBox']);
232 // avoid default click action
238 * Ajax Event handler for 'SQL Query Submit'
240 * @see PMA_ajaxShowMessage()
241 * @see $cfg['AjaxEnable']
243 * @name sqlqueryform_submit
245 $("#sqlqueryform.ajax").live('submit', function(event) {
246 event.preventDefault();
247 // remove any div containing a previous error message
248 $('.error').remove();
251 PMA_ajaxShowMessage();
253 if (! $form.find('input:hidden').is('#ajax_request_hidden')) {
254 $form.append('<input type="hidden" id="ajax_request_hidden" name="ajax_request" value="true" />');
257 $.post($(this).attr('action'), $(this).serialize() , function(data) {
258 if(data.success == true) {
259 // fade out previous messages, if any
260 $('.success').fadeOut();
261 $('.sqlquery_message').fadeOut();
262 // show a message that stays on screen
263 $('#sqlqueryform').before(data.message);
264 // and display the query
265 $('<div class="sqlquery_message"></div>')
266 .html(data.sql_query)
267 .insertBefore('#sqlqueryform');
268 // unnecessary div that came from data.sql_query
269 $('.notice').remove();
270 $('#sqlqueryresults').show();
271 // this happens if a USE command was typed
272 if (typeof data.reload != 'undefined') {
273 $form.find('input[name=db]').val(data.db);
274 // need to regenerate the whole upper part
275 $form.find('input[name=ajax_request]').remove();
276 $form.append('<input type="hidden" name="reload" value="true" />');
277 $.post('db_sql.php', $form.serialize(), function(data) {
278 $('body').html(data);
279 }); // end inner post
282 else if (data.success == false ) {
283 // show an error message that stays on screen
284 $('#sqlqueryform').before(data.error);
285 $('#sqlqueryresults').hide();
288 // real results are returned
289 $received_data = $(data);
290 $zero_row_results = $received_data.find('textarea[name="sql_query"]');
291 // if zero rows are returned from the query execution
292 if ($zero_row_results.length > 0) {
293 $('#sqlquery').val($zero_row_results.val());
295 $('#sqlqueryresults').show();
296 $("#sqlqueryresults").html(data);
297 $("#sqlqueryresults").trigger('appendAnchor');
298 $('#togglequerybox').show();
299 if($("#togglequerybox").siblings(":visible").length > 0) {
300 $("#togglequerybox").trigger('click');
306 }) // end SQL Query submit
309 * Ajax Event handlers for Paginating the results table
313 * Paginate when we click any of the navigation buttons
314 * (only if the element has the ajax class, see $cfg['AjaxEnable'])
316 * @name paginate_nav_button_click
317 * @uses PMA_ajaxShowMessage()
318 * @see $cfg['AjaxEnable']
320 $("input[name=navig].ajax").live('click', function(event) {
322 event.preventDefault();
324 PMA_ajaxShowMessage();
327 * @var $the_form Object referring to the form element that paginates the results table
329 var $the_form = $(this).parent("form");
331 $the_form.append('<input type="hidden" name="ajax_request" value="true" />');
333 $.post($the_form.attr('action'), $the_form.serialize(), function(data) {
334 $("#sqlqueryresults").html(data);
335 $("#sqlqueryresults").trigger('appendAnchor');
338 })// end Paginate results table
341 * Paginate results with Page Selector dropdown
343 * @name paginate_dropdown_change
344 * @see $cfg['AjaxEnable']
346 $("#pageselector").live('change', function(event) {
347 var $the_form = $(this).parent("form");
349 if ($(this).hasClass('ajax')) {
350 event.preventDefault();
352 PMA_ajaxShowMessage();
354 $.post($the_form.attr('action'), $the_form.serialize() + '&ajax_request=true', function(data) {
355 $("#sqlqueryresults").html(data);
356 $("#sqlqueryresults").trigger('appendAnchor');
363 })// end Paginate results with Page Selector
366 * Ajax Event handler for sorting the results table
368 * @name table_results_sort_click
369 * @see $cfg['AjaxEnable']
371 $("#table_results.ajax").find("a[title=Sort]").live('click', function(event) {
372 event.preventDefault();
374 PMA_ajaxShowMessage();
378 $.get($anchor.attr('href'), $anchor.serialize() + '&ajax_request=true', function(data) {
379 $("#sqlqueryresults")
381 .trigger('appendAnchor');
383 })//end Sort results table
386 * Ajax Event handler for the display options
388 * @name displayOptionsForm_submit
389 * @see $cfg['AjaxEnable']
391 $("#displayOptionsForm.ajax").live('submit', function(event) {
392 event.preventDefault();
396 $.post($form.attr('action'), $form.serialize() + '&ajax_request=true' , function(data) {
397 $("#sqlqueryresults")
399 .trigger('appendAnchor');
403 //end displayOptionsForm handler
406 * Ajax Event handlers for Inline Editing
410 * On click, replace the fields of current row with an input/textarea
412 * @name inline_edit_start
413 * @see PMA_ajaxShowMessage()
414 * @see getFieldName()
416 $(".inline_edit_anchor").live('click', function(event) {
418 event.preventDefault();
419 $(this).removeClass('inline_edit_anchor').addClass('inline_edit_active');
421 // adding submit and hide buttons to inline edit <td>
422 // for "hide", button the original data to be restored is present in .original_data
423 // looping through all columns or rows, to find the required data and then storing it in an array.
425 var $this_children = $(this).children('span.nowrap').children('a').children('span.nowrap');
426 if (disp_mode != 'vertical') {
427 $this_children.empty();
428 $this_children.text(PMA_messages['strSave']);
431 data_vt = $this_children.html();
432 $this_children.text(PMA_messages['strSave']);
435 var hide_link = '<br /><br /><a id="hide">' + PMA_messages['strHide'] + '</a>';
436 if (disp_mode != 'vertical') {
437 $(this).append(hide_link);
438 $('#table_results tbody tr td a#hide').click(function() {
439 $this_children = $(this).siblings('span.nowrap').children('a').children('span.nowrap');
440 $this_children.empty();
441 $this_children.text(PMA_messages['strInlineEdit']);
443 var $this_hide = $(this).parent();
444 $this_hide.removeClass("inline_edit_active hover").addClass("inline_edit_anchor");
445 $this_hide.parent().removeClass("hover");
446 $this_hide.siblings().removeClass("hover");
448 var last_column = $this_hide.siblings().length;
450 for(var i = 4; i < last_column; i++) {
451 if($this_hide.siblings("td:eq(" + i + ")").hasClass("inline_edit") == false) {
454 txt = $this_hide.siblings("td:eq(" + i + ")").children(' .original_data').html();
455 if($this_hide.siblings("td:eq(" + i + ")").children().length != 0) {
456 $this_hide.siblings("td:eq(" + i + ")").empty();
457 $this_hide.siblings("td:eq(" + i + ")").append(txt);
460 $(this).prev().prev().remove();
461 $(this).prev().remove();
466 var rows = $(this).parent().siblings().length;
468 $(this).append(hide_link);
469 $('#table_results tbody tr td a#hide').click(function() {
470 var pos = $(this).parent().index();
471 var $chg_submit = $(this).parent().children('span.nowrap').children('a').children('span.nowrap');
473 $chg_submit.append(data_vt);
475 var $this_row = $(this).parent().parent();
476 if(parseInt(pos) % 2 == 0) {
477 $this_row.siblings("tr:eq(3) td:eq(" + pos + ")").removeClass("odd edit_row_anchor row_" + pos + " vpointer vmarker inline_edit_active").addClass("odd edit_row_anchor row_" + pos + " vpointer vmarker inline_edit_anchor");
479 $this_row.siblings("tr:eq(3) td:eq(" + pos + ")").removeClass("odd edit_row_anchor row_" + pos + " vpointer vmarker inline_edit_active hover").addClass("odd edit_row_anchor row_" + pos + " vpointer vmarker inline_edit_anchor");
481 $this_row.siblings("tr:eq(3) td:eq(" + pos + ")").removeClass("even edit_row_anchor row_" + pos + " vpointer vmarker inline_edit_active").addClass("even edit_row_anchor row_" + pos + " vpointer vmarker inline_edit_anchor");
483 $this_row.siblings("tr:eq(3) td:eq(" + pos + ")").removeClass("even edit_row_anchor row_" + pos + " vpointer vmarker inline_edit_active hover").addClass("even edit_row_anchor row_" + pos + " vpointer vmarker inline_edit_anchor");
485 for( var i = 6; i <= rows + 2; i++){
486 if( $this_row.siblings("tr:eq(" + i + ") td:eq(" + pos + ")").hasClass("inline_edit") == false) {
489 txt = $this_row.siblings("tr:eq(" + i + ") td:eq(" + pos + ") span.original_data").html();
490 $this_row.siblings("tr:eq(" + i + ") td:eq(" + pos + ")").empty();
491 $this_row.siblings("tr:eq(" + i + ") td:eq(" + pos + ")").append(txt);
493 $(this).prev().remove();
494 $(this).prev().remove();
499 // Initialize some variables
500 if(disp_mode == 'vertical') {
502 * @var this_row_index Index of the current <td> in the parent <tr>
503 * Current <td> is the inline edit anchor.
505 var this_row_index = $(this).index();
507 * @var $input_siblings Object referring to all inline editable events from same row
509 var $input_siblings = $(this).parents('tbody').find('tr').find('.inline_edit:nth('+this_row_index+')');
511 * @var where_clause String containing the WHERE clause to select this row
513 var where_clause = $(this).parents('tbody').find('tr').find('.where_clause:nth('+this_row_index+')').val();
517 var this_row_index = $(this).parent().index();
518 var $input_siblings = $(this).parent('tr').find('.inline_edit');
519 var where_clause = $(this).parent('tr').find('.where_clause').val();
522 $input_siblings.each(function() {
525 * @var data_value Current value of this field
527 var data_value = $(this).html();
529 // We need to retrieve the value from the server for truncated/relation fields
530 // Find the field name
533 * @var this_field Object referring to this field (<td>)
535 var $this_field = $(this);
537 * @var field_name String containing the name of this field.
538 * @see getFieldName()
540 var field_name = getFieldName($this_field, disp_mode);
542 * @var relation_curr_value String current value of the field (for fields that are foreign keyed).
544 var relation_curr_value = $this_field.find('a').text();
546 * @var curr_value String current value of the field (for fields that are of type enum or set).
548 var curr_value = $this_field.text();
550 if($this_field.is(':not(.not_null)')){
551 // add a checkbox to mark null for all the field that are nullable.
552 $this_field.html('<div class="null_div">Null :<input type="checkbox" class="checkbox_null_'+ field_name + '_' + this_row_index +'"></div>');
553 // check the 'checkbox_null_<field_name>_<row_index>' if the corresponding value is null
554 if($this_field.is('.null')) {
555 $('.checkbox_null_' + field_name + '_' + this_row_index).attr('checked', true);
558 // if the select/editor is changed un-check the 'checkbox_null_<field_name>_<row_index>'.
559 if ($this_field.is('.enum, .set')) {
560 $this_field.find('select').live('change', function(e) {
561 $('.checkbox_null_' + field_name + '_' + this_row_index).attr('checked', false);
563 } else if ($this_field.is('.relation')) {
564 $this_field.find('select').live('change', function(e) {
565 $('.checkbox_null_' + field_name + '_' + this_row_index).attr('checked', false);
567 $this_field.find('.browse_foreign').live('click', function(e) {
568 $('.checkbox_null_' + field_name + '_' + this_row_index).attr('checked', false);
571 $this_field.find('textarea').live('keypress', function(e) {
572 $('.checkbox_null_' + field_name + '_' + this_row_index).attr('checked', false);
576 // if 'chechbox_null_<field_name>_<row_index>' is clicked empty the corresponding select/editor.
577 $('.checkbox_null_' + field_name + '_' + this_row_index).bind('click', function(e) {
578 if ($this_field.is('.enum')) {
579 $this_field.find('select').attr('value', '');
580 } else if ($this_field.is('.set')) {
581 $this_field.find('select').find('option').each(function() {
582 var $option = $(this);
583 $option.attr('selected', false);
585 } else if ($this_field.is('.relation')) {
586 // if the dropdown is there to select the foreign value
587 if ($this_field.find('select').length > 0) {
588 $this_field.find('select').attr('value', '');
589 // if foriegn value is selected by browsing foreing values
591 $this_field.find('span.curr_value').empty();
594 $this_field.find('textarea').val('');
599 $this_field.html('<div class="null_div"></div>');
602 // In each input sibling, wrap the current value in a textarea
603 // and store the current value in a hidden span
604 if($this_field.is(':not(.truncated, .transformed, .relation, .enum, .set, .null)')) {
605 // handle non-truncated, non-transformed, non-relation values
606 // We don't need to get any more data, just wrap the value
607 $this_field.append('<textarea>'+data_value+'</textarea>');
608 $this_field.append('<span class="original_data">'+data_value+'</span>');
609 $(".original_data").hide();
611 else if($this_field.is('.truncated, .transformed')) {
613 //handle truncated/transformed values values
616 * @var sql_query String containing the SQL query used to retrieve value of truncated/transformed data
618 var sql_query = 'SELECT ' + field_name + ' FROM ' + window.parent.table + ' WHERE ' + where_clause;
620 // Make the Ajax call and get the data, wrap it and insert it
622 'token' : window.parent.token,
623 'db' : window.parent.db,
624 'ajax_request' : true,
625 'sql_query' : sql_query,
628 if(data.success == true) {
629 $this_field.append('<textarea>'+data.value+'</textarea>');
630 $this_field.append('<span class="original_data">'+data_value+'</span>');
631 $(".original_data").hide();
634 PMA_ajaxShowMessage(data.error);
638 else if($this_field.is('.relation')) {
643 * @var post_params Object containing parameters for the POST request
646 'ajax_request' : true,
647 'get_relational_values' : true,
648 'db' : window.parent.db,
649 'table' : window.parent.table,
650 'column' : field_name,
651 'token' : window.parent.token,
652 'curr_value' : relation_curr_value
655 $.post('sql.php', post_params, function(data) {
656 $this_field.append(data.dropdown);
657 $this_field.append('<span class="original_data">'+data_value+'</span>');
658 $(".original_data").hide();
661 else if($this_field.is('.enum')) {
666 * @var post_params Object containing parameters for the POST request
669 'ajax_request' : true,
670 'get_enum_values' : true,
671 'db' : window.parent.db,
672 'table' : window.parent.table,
673 'column' : field_name,
674 'token' : window.parent.token,
675 'curr_value' : curr_value
678 $.post('sql.php', post_params, function(data) {
679 $this_field.append(data.dropdown);
680 $this_field.append('<span class="original_data">'+data_value+'</span>');
681 $(".original_data").hide();
684 else if($this_field.is('.set')) {
689 * @var post_params Object containing parameters for the POST request
692 'ajax_request' : true,
693 'get_set_values' : true,
694 'db' : window.parent.db,
695 'table' : window.parent.table,
696 'column' : field_name,
697 'token' : window.parent.token,
698 'curr_value' : curr_value
701 $.post('sql.php', post_params, function(data) {
702 $this_field.append(data.select);
703 $this_field.append('<span class="original_data">'+data_value+'</span>');
704 $(".original_data").hide();
707 else if($this_field.is('.null')) {
709 $this_field.append('<textarea></textarea>');
710 $this_field.append('<span class="original_data">NULL</span>');
711 $(".original_data").hide();
714 }) // End On click, replace the current field with an input/textarea
717 * After editing, clicking again should post data
720 * @name inline_edit_save
721 * @see PMA_ajaxShowMessage()
722 * @see getFieldName()
724 $(".inline_edit_active span a").live('click', function(event) {
727 event.preventDefault();
730 * @var $this_td Object referring to the td containing the
731 * "Inline Edit" link that was clicked to save the row that is
735 var $this_td = $(this).parent().parent();
736 var $test_element = ''; // to test the presence of a element
738 // Initialize variables
739 if(disp_mode == 'vertical') {
741 * @var this_td_index Index of the current <td> in the parent <tr>
742 * Current <td> is the inline edit anchor.
744 var this_td_index = $this_td.index();
746 * @var $input_siblings Object referring to all inline editable events from same row
748 var $input_siblings = $this_td.parents('tbody').find('tr').find('.inline_edit:nth('+this_td_index+')');
750 * @var where_clause String containing the WHERE clause to select this row
752 var where_clause = $this_td.parents('tbody').find('tr').find('.where_clause:nth('+this_td_index+')').val();
754 var $input_siblings = $this_td.parent('tr').find('.inline_edit');
755 var where_clause = $this_td.parent('tr').find('.where_clause').val();
759 * @var nonunique Boolean, whether this row is unique or not
761 if($this_td.is('.nonunique')) {
768 // Collect values of all fields to submit, we don't know which changed
770 * @var relation_fields Array containing the name/value pairs of relational fields
772 var relation_fields = {};
774 * @var transform_fields Array containing the name/value pairs for transformed fields
776 var transform_fields = {};
778 * @var transformation_fields Boolean, if there are any transformed fields in this row
780 var transformation_fields = false;
783 * @var sql_query String containing the SQL query to update this row
785 var sql_query = 'UPDATE `' + window.parent.table + '` SET ';
787 $input_siblings.each(function() {
790 * @var this_field Object referring to this field (<td>)
792 var $this_field = $(this);
794 * @var field_name String containing the name of this field.
795 * @see getFieldName()
797 var field_name = getFieldName($this_field, disp_mode);
800 * @var this_field_params Array temporary storage for the name/value of current field
802 var this_field_params = {};
804 if($this_field.is('.transformed')) {
805 transformation_fields = true;
808 * @var is_null String capturing whether 'checkbox_null_<field_name>_<row_index>' is checked.
810 var is_null = $this_field.find('input:checkbox').is(':checked');
814 sql_query += ' `' + field_name + "`=NULL , ";
816 if($this_field.is(":not(.relation, .enum, .set)")) {
817 this_field_params[field_name] = $this_field.find('textarea').val();
818 if($this_field.is('.transformed')) {
819 $.extend(transform_fields, this_field_params);
821 } else if ($this_field.is('.set')) {
822 $test_element = $this_field.find('select');
823 this_field_params[field_name] = $test_element.map(function(){
824 return $(this).val();
827 // results from a drop-down
828 $test_element = $this_field.find('select');
829 if ($test_element.length != 0) {
830 this_field_params[field_name] = $test_element.val();
833 // results from Browse foreign value
834 $test_element = $this_field.find('span.curr_value');
835 if ($test_element.length != 0) {
836 this_field_params[field_name] = $test_element.text();
839 if($this_field.is('.relation')) {
840 $.extend(relation_fields, this_field_params);
843 sql_query += ' `' + field_name + "`='" + this_field_params[field_name].replace(/'/g, "''") + "' , ";
847 //Remove the last ',' appended in the above loop
848 sql_query = sql_query.replace(/,\s$/, '');
849 sql_query += ' WHERE ' + PMA_urldecode(where_clause);
852 * @var rel_fields_list String, url encoded representation of {@link relations_fields}
854 var rel_fields_list = $.param(relation_fields);
857 * @var transform_fields_list String, url encoded representation of {@link transform_fields}
859 var transform_fields_list = $.param(transform_fields);
861 // Make the Ajax post after setting all parameters
863 * @var post_params Object containing parameters for the POST request
865 var post_params = {'ajax_request' : true,
866 'sql_query' : sql_query,
867 'disp_direction' : disp_mode,
868 'token' : window.parent.token,
869 'db' : window.parent.db,
870 'table' : window.parent.table,
871 'clause_is_unique' : nonunique,
872 'where_clause' : where_clause,
873 'rel_fields_list' : rel_fields_list,
874 'do_transformations' : transformation_fields,
875 'transform_fields_list' : transform_fields_list,
877 'submit_type' : 'save'
880 // if inline_edit is successful, we need to go back to default view
881 var $del_hide=$(this).parent();
882 var $chg_submit=$(this);
884 $.post('tbl_replace.php', post_params, function(data) {
885 if(data.success == true) {
886 // deleting the hide button if my query was successful
887 // remove <br><br><a> tags
888 for ( var i=0;i<=2;i++) { $del_hide.next().remove(); }
889 if(disp_mode!='vertical'){
891 $chg_submit.html('<span class="nowrap"></span>');
892 $chg_submit.children('span.nowrap').text(PMA_messages['strInlineEdit']);
895 $chg_submit.children('span.nowrap').empty();
896 $chg_submit.children('span.nowrap').append(data_vt);
899 PMA_ajaxShowMessage(data.message);
900 $this_td.removeClass('inline_edit_active hover').addClass('inline_edit_anchor');
901 $this_td.parent().removeClass('hover')
902 $this_td.siblings().removeClass('hover');
904 $input_siblings.each(function() {
905 // Inline edit post has been successful.
906 $this_sibling = $(this);
908 var is_null = $this_sibling.find('input:checkbox').is(':checked');
910 $this_sibling.html('NULL');
911 $this_sibling.addClass('null');
913 $this_sibling.removeClass('null');
914 if($this_sibling.is(':not(.relation, .enum, .set)')) {
916 * @var new_html String containing value of the data field after edit
918 var new_html = $this_sibling.find('textarea').val();
920 if($this_sibling.is('.transformed')) {
921 var field_name = getFieldName($this_sibling, disp_mode);
922 $.each(data.transformations, function(key, value) {
923 if(key == field_name) {
924 if($this_sibling.is('.text_plain, .application_octetstream')) {
929 var new_value = $this_sibling.find('textarea').val();
930 new_html = $(value).append(new_value);
940 $test_element = $this_sibling.find('select');
941 if ($test_element.length != 0) {
942 new_value = $test_element.val();
945 $test_element = $this_sibling.find('span.curr_value');
946 if ($test_element.length != 0) {
947 new_value = $test_element.text();
950 if($this_sibling.is('.relation')) {
951 var field_name = getFieldName($this_sibling, disp_mode);
952 $.each(data.relations, function(key, value) {
953 if(key == field_name) {
954 new_html = $(value).append(new_value);
958 } else if ($this_sibling.is('.enum')) {
959 new_html = new_value;
960 } else if ($this_sibling.is('.set')) {
961 if (new_value != null) {
962 $.each(new_value, function(key, value) {
963 new_html = new_html + value + ',';
965 new_html = new_html.substring(0, new_html.length-1);
969 $this_sibling.html(new_html);
974 PMA_ajaxShowMessage(data.error);
977 }) // End After editing, clicking again should post data
978 }, 'top.frame_content') // end $(document).ready()
981 * Starting from some th, change the class of all td under it
983 function PMA_changeClassForColumn($this_th, newclass) {
984 // index 0 is the th containing the big T
985 var th_index = $this_th.index();
986 // .eq() is zero-based
988 var $tds = $this_th.closest('table').find('tbody tr').find('td.data:eq('+th_index+')');
989 if ($this_th.data('has_class_'+newclass)) {
990 $tds.removeClass(newclass);
991 $this_th.data('has_class_'+newclass, false);
993 $tds.addClass(newclass);
994 $this_th.data('has_class_'+newclass, true);
998 $(document).ready(function() {
1000 $('.browse_foreign').live('click', function(e) {
1002 window.open(this.href, 'foreigners', 'width=640,height=240,scrollbars=yes,resizable=yes');
1004 $anchor.addClass('browse_foreign_clicked');
1009 * vertical column highlighting in horizontal mode when hovering over the column header
1011 $('.column_heading').live('hover', function() {
1012 PMA_changeClassForColumn($(this), 'hover');
1016 * vertical column marking in horizontal mode when clicking the column header
1018 $('.column_heading').live('click', function() {
1019 PMA_changeClassForColumn($(this), 'marked');