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 span a").live('click', function(event) {
418 event.preventDefault();
420 var $edit_td = $(this).parents('td');
421 $edit_td.removeClass('inline_edit_anchor').addClass('inline_edit_active').parent('tr').addClass('noclick');
423 // Adding submit and hide buttons to inline edit <td>.
424 // For "hide" button the original data to be restored is
425 // kept in the jQuery data element 'original_data' inside the <td>.
426 // Looping through all columns or rows, to find the required data and then storing it in an array.
428 var $this_children = $edit_td.children('span.nowrap').children('a').children('span.nowrap');
429 if (disp_mode != 'vertical') {
430 $this_children.empty();
431 $this_children.text(PMA_messages['strSave']);
434 data_vt = $this_children.html();
435 $this_children.text(PMA_messages['strSave']);
438 var hide_link = '<br /><br /><a id="hide">' + PMA_messages['strHide'] + '</a>';
439 if (disp_mode != 'vertical') {
440 $edit_td.append(hide_link);
441 $('#table_results tbody tr td a#hide').click(function() {
442 $this_children = $(this).siblings('span.nowrap').children('a').children('span.nowrap');
443 $this_children.empty();
444 $this_children.text(PMA_messages['strInlineEdit']);
446 var $this_hide = $(this).parent();
447 $this_hide.removeClass("inline_edit_active hover").addClass("inline_edit_anchor");
448 $this_hide.parent().removeClass("hover noclick");
449 $this_hide.siblings().removeClass("hover");
451 var last_column = $this_hide.siblings().length;
453 for(var i = 4; i < last_column; i++) {
454 if($this_hide.siblings("td:eq(" + i + ")").hasClass("inline_edit") == false) {
457 txt = $this_hide.siblings("td:eq(" + i + ")").data('original_data');
458 if($this_hide.siblings("td:eq(" + i + ")").children().length != 0) {
459 $this_hide.siblings("td:eq(" + i + ")").empty();
460 $this_hide.siblings("td:eq(" + i + ")").append(txt);
463 $(this).prev().prev().remove();
464 $(this).prev().remove();
469 var rows = $edit_td.parent().siblings().length;
471 $edit_td.append(hide_link);
472 $('#table_results tbody tr td a#hide').click(function() {
473 var pos = $(this).parent().index();
474 var $chg_submit = $(this).parent().children('span.nowrap').children('a').children('span.nowrap');
476 $chg_submit.append(data_vt);
478 var $this_row = $(this).parents('tr');
479 // changing inline_edit_active to inline_edit_anchor
480 $this_row.siblings("tr:eq(3) td:eq(" + pos + ")").removeClass("inline_edit_active").addClass("inline_edit_anchor");
482 // removing marked and hover classes.
483 $this_row.parent('tbody').find('tr').find("td:eq(" + pos + ")").removeClass("marked hover");
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 + ")").data('original_data');
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 = $edit_td.index();
507 * @var $input_siblings Object referring to all inline editable events from same row
509 var $input_siblings = $edit_td.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 = $edit_td.parents('tbody').find('tr').find('.where_clause:nth('+this_row_index+')').val();
517 var this_row_index = $edit_td.parent().index();
518 var $input_siblings = $edit_td.parent('tr').find('.inline_edit');
519 var where_clause = $edit_td.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 'checkbox_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.data('original_data', data_value);
610 else if($this_field.is('.truncated, .transformed')) {
612 //handle truncated/transformed values values
615 * @var sql_query String containing the SQL query used to retrieve value of truncated/transformed data
617 var sql_query = 'SELECT ' + field_name + ' FROM ' + window.parent.table + ' WHERE ' + where_clause;
619 // Make the Ajax call and get the data, wrap it and insert it
621 'token' : window.parent.token,
622 'db' : window.parent.db,
623 'ajax_request' : true,
624 'sql_query' : sql_query,
627 if(data.success == true) {
628 $this_field.append('<textarea>'+data.value+'</textarea>');
629 $this_field.data('original_data', data_value);
632 PMA_ajaxShowMessage(data.error);
636 else if($this_field.is('.relation')) {
641 * @var post_params Object containing parameters for the POST request
644 'ajax_request' : true,
645 'get_relational_values' : true,
646 'db' : window.parent.db,
647 'table' : window.parent.table,
648 'column' : field_name,
649 'token' : window.parent.token,
650 'curr_value' : relation_curr_value
653 $.post('sql.php', post_params, function(data) {
654 $this_field.append(data.dropdown);
655 $this_field.data('original_data', data_value);
658 else if($this_field.is('.enum')) {
663 * @var post_params Object containing parameters for the POST request
666 'ajax_request' : true,
667 'get_enum_values' : true,
668 'db' : window.parent.db,
669 'table' : window.parent.table,
670 'column' : field_name,
671 'token' : window.parent.token,
672 'curr_value' : curr_value
675 $.post('sql.php', post_params, function(data) {
676 $this_field.append(data.dropdown);
677 $this_field.data('original_data', data_value);
680 else if($this_field.is('.set')) {
685 * @var post_params Object containing parameters for the POST request
688 'ajax_request' : true,
689 'get_set_values' : true,
690 'db' : window.parent.db,
691 'table' : window.parent.table,
692 'column' : field_name,
693 'token' : window.parent.token,
694 'curr_value' : curr_value
697 $.post('sql.php', post_params, function(data) {
698 $this_field.append(data.select);
699 $this_field.data('original_data', data_value);
702 else if($this_field.is('.null')) {
704 $this_field.append('<textarea></textarea>');
705 $this_field.data('original_data', 'NULL');
708 }) // End On click, replace the current field with an input/textarea
711 * After editing, clicking again should post data
714 * @name inline_edit_save
715 * @see PMA_ajaxShowMessage()
716 * @see getFieldName()
718 $(".inline_edit_active span a").live('click', function(event) {
721 event.preventDefault();
724 * @var $this_td Object referring to the td containing the
725 * "Inline Edit" link that was clicked to save the row that is
729 var $this_td = $(this).parent().parent();
730 var $test_element = ''; // to test the presence of a element
732 // Initialize variables
733 if(disp_mode == 'vertical') {
735 * @var this_td_index Index of the current <td> in the parent <tr>
736 * Current <td> is the inline edit anchor.
738 var this_td_index = $this_td.index();
740 * @var $input_siblings Object referring to all inline editable events from same row
742 var $input_siblings = $this_td.parents('tbody').find('tr').find('.inline_edit:nth('+this_td_index+')');
744 * @var where_clause String containing the WHERE clause to select this row
746 var where_clause = $this_td.parents('tbody').find('tr').find('.where_clause:nth('+this_td_index+')').val();
748 var $input_siblings = $this_td.parent('tr').find('.inline_edit');
749 var where_clause = $this_td.parent('tr').find('.where_clause').val();
753 * @var nonunique Boolean, whether this row is unique or not
755 if($this_td.is('.nonunique')) {
762 // Collect values of all fields to submit, we don't know which changed
764 * @var relation_fields Array containing the name/value pairs of relational fields
766 var relation_fields = {};
768 * @var transform_fields Array containing the name/value pairs for transformed fields
770 var transform_fields = {};
772 * @var transformation_fields Boolean, if there are any transformed fields in this row
774 var transformation_fields = false;
777 * @var sql_query String containing the SQL query to update this row
779 var sql_query = 'UPDATE `' + window.parent.table + '` SET ';
781 $input_siblings.each(function() {
784 * @var this_field Object referring to this field (<td>)
786 var $this_field = $(this);
788 * @var field_name String containing the name of this field.
789 * @see getFieldName()
791 var field_name = getFieldName($this_field, disp_mode);
794 * @var this_field_params Array temporary storage for the name/value of current field
796 var this_field_params = {};
798 if($this_field.is('.transformed')) {
799 transformation_fields = true;
802 * @var is_null String capturing whether 'checkbox_null_<field_name>_<row_index>' is checked.
804 var is_null = $this_field.find('input:checkbox').is(':checked');
808 sql_query += ' `' + field_name + "`=NULL , ";
810 if($this_field.is(":not(.relation, .enum, .set)")) {
811 this_field_params[field_name] = $this_field.find('textarea').val();
812 if($this_field.is('.transformed')) {
813 $.extend(transform_fields, this_field_params);
815 } else if ($this_field.is('.set')) {
816 $test_element = $this_field.find('select');
817 this_field_params[field_name] = $test_element.map(function(){
818 return $(this).val();
821 // results from a drop-down
822 $test_element = $this_field.find('select');
823 if ($test_element.length != 0) {
824 this_field_params[field_name] = $test_element.val();
827 // results from Browse foreign value
828 $test_element = $this_field.find('span.curr_value');
829 if ($test_element.length != 0) {
830 this_field_params[field_name] = $test_element.text();
833 if($this_field.is('.relation')) {
834 $.extend(relation_fields, this_field_params);
837 sql_query += ' `' + field_name + "`='" + this_field_params[field_name].replace(/'/g, "''") + "' , ";
841 //Remove the last ',' appended in the above loop
842 sql_query = sql_query.replace(/,\s$/, '');
843 sql_query += ' WHERE ' + PMA_urldecode(where_clause);
846 * @var rel_fields_list String, url encoded representation of {@link relations_fields}
848 var rel_fields_list = $.param(relation_fields);
851 * @var transform_fields_list String, url encoded representation of {@link transform_fields}
853 var transform_fields_list = $.param(transform_fields);
855 // Make the Ajax post after setting all parameters
857 * @var post_params Object containing parameters for the POST request
859 var post_params = {'ajax_request' : true,
860 'sql_query' : sql_query,
861 'disp_direction' : disp_mode,
862 'token' : window.parent.token,
863 'db' : window.parent.db,
864 'table' : window.parent.table,
865 'clause_is_unique' : nonunique,
866 'where_clause' : where_clause,
867 'rel_fields_list' : rel_fields_list,
868 'do_transformations' : transformation_fields,
869 'transform_fields_list' : transform_fields_list,
871 'submit_type' : 'save'
874 // if inline_edit is successful, we need to go back to default view
875 var $del_hide=$(this).parent();
876 var $chg_submit=$(this);
878 $.post('tbl_replace.php', post_params, function(data) {
879 if(data.success == true) {
880 // deleting the hide button if my query was successful
881 // remove <br><br><a> tags
882 for ( var i=0;i<=2;i++) { $del_hide.next().remove(); }
883 if(disp_mode!='vertical'){
885 $chg_submit.html('<span class="nowrap"></span>');
886 $chg_submit.children('span.nowrap').text(PMA_messages['strInlineEdit']);
889 $chg_submit.children('span.nowrap').empty();
890 $chg_submit.children('span.nowrap').append(data_vt);
893 PMA_ajaxShowMessage(data.message);
895 // changing inline_edit_active to inline_edit_anchor
896 $this_td.removeClass('inline_edit_active').addClass('inline_edit_anchor');
898 // removing hover, marked and noclick classes
899 $this_td.parent('tr').removeClass('noclick');
900 if(disp_mode != 'vertical') {
901 $this_td.parent('tr').removeClass('hover').find('td').removeClass('hover');
903 $this_td.parents('tbody').find('tr').find('td:eq(' + $this_td.index() + ')').removeClass('marked');
906 $input_siblings.each(function() {
907 // Inline edit post has been successful.
908 $this_sibling = $(this);
910 var is_null = $this_sibling.find('input:checkbox').is(':checked');
912 $this_sibling.html('NULL');
913 $this_sibling.addClass('null');
915 $this_sibling.removeClass('null');
916 if($this_sibling.is(':not(.relation, .enum, .set)')) {
918 * @var new_html String containing value of the data field after edit
920 var new_html = $this_sibling.find('textarea').val();
922 if($this_sibling.is('.transformed')) {
923 var field_name = getFieldName($this_sibling, disp_mode);
924 $.each(data.transformations, function(key, value) {
925 if(key == field_name) {
926 if($this_sibling.is('.text_plain, .application_octetstream')) {
931 var new_value = $this_sibling.find('textarea').val();
932 new_html = $(value).append(new_value);
942 $test_element = $this_sibling.find('select');
943 if ($test_element.length != 0) {
944 new_value = $test_element.val();
947 $test_element = $this_sibling.find('span.curr_value');
948 if ($test_element.length != 0) {
949 new_value = $test_element.text();
952 if($this_sibling.is('.relation')) {
953 var field_name = getFieldName($this_sibling, disp_mode);
954 $.each(data.relations, function(key, value) {
955 if(key == field_name) {
956 new_html = $(value).append(new_value);
960 } else if ($this_sibling.is('.enum')) {
961 new_html = new_value;
962 } else if ($this_sibling.is('.set')) {
963 if (new_value != null) {
964 $.each(new_value, function(key, value) {
965 new_html = new_html + value + ',';
967 new_html = new_html.substring(0, new_html.length-1);
971 $this_sibling.html(new_html);
976 PMA_ajaxShowMessage(data.error);
979 }) // End After editing, clicking again should post data
980 }, 'top.frame_content') // end $(document).ready()
983 * Starting from some th, change the class of all td under it
985 function PMA_changeClassForColumn($this_th, newclass) {
986 // index 0 is the th containing the big T
987 var th_index = $this_th.index();
988 // .eq() is zero-based
990 var $tds = $this_th.closest('table').find('tbody tr').find('td.data:eq('+th_index+')');
991 if ($this_th.data('has_class_'+newclass)) {
992 $tds.removeClass(newclass);
993 $this_th.data('has_class_'+newclass, false);
995 $tds.addClass(newclass);
996 $this_th.data('has_class_'+newclass, true);
1000 $(document).ready(function() {
1002 $('.browse_foreign').live('click', function(e) {
1004 window.open(this.href, 'foreigners', 'width=640,height=240,scrollbars=yes,resizable=yes');
1006 $anchor.addClass('browse_foreign_clicked');
1011 * vertical column highlighting in horizontal mode when hovering over the column header
1013 $('.column_heading').live('hover', function() {
1014 PMA_changeClassForColumn($(this), 'hover');
1018 * vertical column marking in horizontal mode when clicking the column header
1020 $('.column_heading').live('click', function() {
1021 PMA_changeClassForColumn($(this), 'marked');