| blob | ce3a696a71887a8cb2349b01f40745524bb7686d |
1 /* vim: set expandtab sw=4 ts=4 sts=4: */
2 /**
3 * JavaScript functionality for Routines, Triggers and Events.
4 *
5 * @package PhpMyadmin
6 */
7 /**
8 * @var RTE Contains all the JavaScript functionality
9 * for Routines, Triggers and Events
10 */
11 var RTE = {
12 /**
13 * Construct for the object that provides the
14 * functionality for Routines, Triggers and Events
15 */
16 object: function (type) {
17 $.extend(this, RTE.COMMON);
18 switch (type) {
19 case 'routine':
20 $.extend(this, RTE.ROUTINE);
21 break;
22 case 'trigger':
23 // nothing extra yet for triggers
24 break;
25 case 'event':
26 $.extend(this, RTE.EVENT);
27 break;
28 default:
29 break;
30 }
31 },
32 /**
33 * @var string param_template Template for a row in the routine editor
34 */
35 param_template: ''
36 };
38 /**
39 * @var RTE.COMMON a JavaScript namespace containing the functionality
40 * for Routines, Triggers and Events
41 *
42 * This namespace is extended by the functionality required
43 * to handle a specific item (a routine, trigger or event)
44 * in the relevant javascript files in this folder
45 */
46 RTE.COMMON = {
47 /**
48 * @var $ajaxDialog Query object containing the reference to the
49 * dialog that contains the editor
50 */
51 $ajaxDialog: null,
52 /**
53 * @var syntaxHiglighter Reference to the codemirror editor
54 */
55 syntaxHiglighter: null,
56 /**
57 * @var buttonOptions Object containing options for
58 * the jQueryUI dialog buttons
59 */
60 buttonOptions: {},
61 /**
62 * Validate editor form fields.
63 */
64 validate: function () {
65 /**
66 * @var $elm a jQuery object containing the reference
67 * to an element that is being validated
68 */
69 var $elm = null;
70 // Common validation. At the very least the name
71 // and the definition must be provided for an item
72 $elm = $('table.rte_table').last().find('input[name=item_name]');
73 if ($elm.val() === '') {
74 $elm.focus();
75 alert(PMA_messages.strFormEmpty);
76 return false;
77 }
78 $elm = $('table.rte_table').find('textarea[name=item_definition]');
79 if ($elm.val() === '') {
80 if (this.syntaxHiglighter !== null) {
81 this.syntaxHiglighter.focus();
82 }
83 else {
84 $('textarea[name=item_definition]').last().focus();
85 }
86 alert(PMA_messages.strFormEmpty);
87 return false;
88 }
89 // The validation has so far passed, so now
90 // we can validate item-specific fields.
91 return this.validateCustom();
92 }, // end validate()
93 /**
94 * Validate custom editor form fields.
95 * This function can be overridden by
96 * other files in this folder
97 */
98 validateCustom: function () {
99 return true;
100 }, // end validateCustom()
101 /**
102 * Execute some code after the ajax
103 * dialog for the editor is shown.
104 * This function can be overridden by
105 * other files in this folder
106 */
107 postDialogShow: function () {
108 // Nothing by default
109 }, // end postDialogShow()
111 exportDialog: function ($this) {
112 var $msg = PMA_ajaxShowMessage();
113 if ($this.hasClass('mult_submit')) {
114 var combined = {
115 success: true,
116 title: PMA_messages.strExport,
117 message: '',
118 error: ''
119 };
120 // export anchors of all selected rows
121 var export_anchors = $('input.checkall:checked').parents('tr').find('.export_anchor');
122 var count = export_anchors.length;
123 var returnCount = 0;
125 export_anchors.each(function () {
126 $.get($(this).attr('href'), {'ajax_request': true}, function (data) {
127 returnCount++;
128 if (data.success === true) {
129 combined.message += "\n" + data.message + "\n";
130 if (returnCount == count) {
131 showExport(combined);
132 }
133 } else {
134 // complain even if one export is failing
135 combined.success = false;
136 combined.error += "\n" + data.error + "\n";
137 if (returnCount == count) {
138 showExport(combined);
139 }
140 }
141 });
142 });
143 } else {
144 $.get($this.attr('href'), {'ajax_request': true}, showExport);
145 }
147 function showExport(data) {
148 if (data.success === true) {
149 PMA_ajaxRemoveMessage($msg);
150 /**
151 * @var button_options Object containing options
152 * for jQueryUI dialog buttons
153 */
154 var button_options = {};
155 button_options[PMA_messages.strClose] = function () {
156 $(this).dialog("close").remove();
157 };
158 /**
159 * Display the dialog to the user
160 */
161 data.message = '<textarea cols="40" rows="15" style="width: 100%;">' + data.message + '</textarea>';
162 var $ajaxDialog = $('<div>' + data.message + '</div>').dialog({
163 width: 500,
164 buttons: button_options,
165 title: data.title
166 });
167 // Attach syntax highlighted editor to export dialog
168 /**
169 * @var $elm jQuery object containing the reference
170 * to the Export textarea.
171 */
172 var $elm = $ajaxDialog.find('textarea');
173 PMA_getSQLEditor($elm);
174 } else {
175 PMA_ajaxShowMessage(data.error, false);
176 }
177 } // end showExport()
178 }, // end exportDialog()
179 editorDialog: function (is_new, $this) {
180 var that = this;
181 /**
182 * @var $edit_row jQuery object containing the reference to
183 * the row of the the item being edited
184 * from the list of items
185 */
186 var $edit_row = null;
187 if ($this.hasClass('edit_anchor')) {
188 // Remeber the row of the item being edited for later,
189 // so that if the edit is successful, we can replace the
190 // row with info about the modified item.
191 $edit_row = $this.parents('tr');
192 }
193 /**
194 * @var $msg jQuery object containing the reference to
195 * the AJAX message shown to the user
196 */
197 var $msg = PMA_ajaxShowMessage();
198 $.get($this.attr('href'), {'ajax_request': true}, function (data) {
199 if (data.success === true) {
200 // We have successfully fetched the editor form
201 PMA_ajaxRemoveMessage($msg);
202 // Now define the function that is called when
203 // the user presses the "Go" button
204 that.buttonOptions[PMA_messages.strGo] = function () {
205 // Move the data from the codemirror editor back to the
206 // textarea, where it can be used in the form submission.
207 if (typeof CodeMirror != 'undefined') {
208 that.syntaxHiglighter.save();
209 }
210 // Validate editor and submit request, if passed.
211 if (that.validate()) {
212 /**
213 * @var data Form data to be sent in the AJAX request
214 */
215 var data = $('form.rte_form').last().serialize();
216 $msg = PMA_ajaxShowMessage(
217 PMA_messages.strProcessingRequest
218 );
219 var url = $('form.rte_form').last().attr('action');
220 $.post(url, data, function (data) {
221 if (data.success === true) {
222 // Item created successfully
223 PMA_ajaxRemoveMessage($msg);
224 PMA_slidingMessage(data.message);
225 that.$ajaxDialog.dialog('close');
226 // If we are in 'edit' mode, we must
227 // remove the reference to the old row.
228 if (mode === 'edit' && $edit_row !== null ) {
229 $edit_row.remove();
230 }
231 // Sometimes, like when moving a trigger from
232 // a table to another one, the new row should
233 // not be inserted into the list. In this case
234 // "data.insert" will be set to false.
235 if (data.insert) {
236 // Insert the new row at the correct
237 // location in the list of items
238 /**
239 * @var text Contains the name of an item from
240 * the list that is used in comparisons
241 * to find the correct location where
242 * to insert a new row.
243 */
244 var text = '';
245 /**
246 * @var inserted Whether a new item has been
247 * inserted in the list or not
248 */
249 var inserted = false;
250 $('table.data').find('tr').each(function () {
251 text = $(this)
252 .children('td')
253 .eq(0)
254 .find('strong')
255 .text()
256 .toUpperCase();
257 text = $.trim(text);
258 if (text !== '' && text > data.name) {
259 $(this).before(data.new_row);
260 inserted = true;
261 return false;
262 }
263 });
264 if (! inserted) {
265 // If we didn't manage to insert the row yet,
266 // it must belong at the end of the list,
267 // so we insert it there.
268 $('table.data').append(data.new_row);
269 }
270 // Fade-in the new row
271 $('tr.ajaxInsert')
272 .show('slow')
273 .removeClass('ajaxInsert');
274 } else if ($('table.data').find('tr').has('td').length === 0) {
275 // If we are not supposed to insert the new row,
276 // we will now check if the table is empty and
277 // needs to be hidden. This will be the case if
278 // we were editing the only item in the list,
279 // which we removed and will not be inserting
280 // something else in its place.
281 $('table.data').hide("slow", function () {
282 $('#nothing2display').show("slow");
283 });
284 }
285 // Now we have inserted the row at the correct
286 // position, but surely at least some row classes
287 // are wrong now. So we will itirate throught
288 // all rows and assign correct classes to them
289 /**
290 * @var ct Count of processed rows
291 */
292 var ct = 0;
293 /**
294 * @var rowclass Class to be attached to the row
295 * that is being processed
296 */
297 var rowclass = '';
298 $('table.data').find('tr').has('td').each(function () {
299 rowclass = (ct % 2 === 0) ? 'odd' : 'even';
300 $(this).removeClass().addClass(rowclass);
301 ct++;
302 });
303 // If this is the first item being added, remove
304 // the "No items" message and show the list.
305 if ($('table.data').find('tr').has('td').length > 0 &&
306 $('#nothing2display').is(':visible')
307 ) {
308 $('#nothing2display').hide("slow", function () {
309 $('table.data').show("slow");
310 });
311 }
312 PMA_reloadNavigation();
313 } else {
314 PMA_ajaxShowMessage(data.error, false);
315 }
316 }); // end $.post()
317 } // end "if (that.validate())"
318 }; // end of function that handles the submission of the Editor
319 that.buttonOptions[PMA_messages.strClose] = function () {
320 $(this).dialog("close");
321 };
322 /**
323 * Display the dialog to the user
324 */
325 that.$ajaxDialog = $('<div id="rteDialog">' + data.message + '</div>').dialog({
326 width: 700,
327 minWidth: 500,
328 maxHeight: $(window).height(),
329 buttons: that.buttonOptions,
330 title: data.title,
331 modal: true,
332 open: function () {
333 if ($('#rteDialog').parents('.ui-dialog').height() > $(window).height()) {
334 $('#rteDialog').dialog("option", "height", $(window).height());
335 }
336 $(this).find('input[name=item_name]').focus();
337 $(this).find('input.datefield').each(function () {
338 PMA_addDatepicker($(this).css('width', '95%'), 'date');
339 });
340 $(this).find('input.datetimefield').each(function () {
341 PMA_addDatepicker($(this).css('width', '95%'), 'datetime');
342 });
343 $.datepicker.initialized = false;
344 },
345 close: function () {
346 $(this).remove();
347 }
348 });
349 /**
350 * @var mode Used to remeber whether the editor is in
351 * "Edit" or "Add" mode
352 */
353 var mode = 'add';
354 if ($('input[name=editor_process_edit]').length > 0) {
355 mode = 'edit';
356 }
357 // Attach syntax highlighted editor to the definition
358 /**
359 * @var elm jQuery object containing the reference to
360 * the Definition textarea.
361 */
362 var $elm = $('textarea[name=item_definition]').last();
363 that.syntaxHiglighter = PMA_getSQLEditor($elm);
365 // Execute item-specific code
366 that.postDialogShow(data);
367 } else {
368 PMA_ajaxShowMessage(data.error, false);
369 }
370 }); // end $.get()
371 },
373 dropDialog: function ($this) {
374 /**
375 * @var $curr_row Object containing reference to the current row
376 */
377 var $curr_row = $this.parents('tr');
378 /**
379 * @var question String containing the question to be asked for confirmation
380 */
381 var question = $('<div/>').text(
382 $curr_row.children('td').children('.drop_sql').html()
383 );
384 // We ask for confirmation first here, before submitting the ajax request
385 $this.PMA_confirm(question, $this.attr('href'), function (url) {
386 /**
387 * @var msg jQuery object containing the reference to
388 * the AJAX message shown to the user
389 */
390 var $msg = PMA_ajaxShowMessage(PMA_messages.strProcessingRequest);
391 $.post(url, {'is_js_confirmed': 1, 'ajax_request': true}, function (data) {
392 if (data.success === true) {
393 /**
394 * @var $table Object containing reference
395 * to the main list of elements
396 */
397 var $table = $curr_row.parent();
398 // Check how many rows will be left after we remove
399 // the one that the user has requested us to remove
400 if ($table.find('tr').length === 3) {
401 // If there are two rows left, it means that they are
402 // the header of the table and the rows that we are
403 // about to remove, so after the removal there will be
404 // nothing to show in the table, so we hide it.
405 $table.hide("slow", function () {
406 $(this).find('tr.even, tr.odd').remove();
407 $('.withSelected').remove();
408 $('#nothing2display').show("slow");
409 });
410 } else {
411 $curr_row.hide("slow", function () {
412 $(this).remove();
413 // Now we have removed the row from the list, but maybe
414 // some row classes are wrong now. So we will itirate
415 // throught all rows and assign correct classes to them.
416 /**
417 * @var ct Count of processed rows
418 */
419 var ct = 0;
420 /**
421 * @var rowclass Class to be attached to the row
422 * that is being processed
423 */
424 var rowclass = '';
425 $table.find('tr').has('td').each(function () {
426 rowclass = (ct % 2 === 1) ? 'odd' : 'even';
427 $(this).removeClass().addClass(rowclass);
428 ct++;
429 });
430 });
431 }
432 // Get rid of the "Loading" message
433 PMA_ajaxRemoveMessage($msg);
434 // Show the query that we just executed
435 PMA_slidingMessage(data.sql_query);
436 PMA_reloadNavigation();
437 } else {
438 PMA_ajaxShowMessage(data.error, false);
439 }
440 }); // end $.post()
441 }); // end $.PMA_confirm()
442 },
444 dropMultipleDialog: function ($this) {
445 // We ask for confirmation here
446 $this.PMA_confirm(PMA_messages.strDropRTEitems, '', function (url) {
447 /**
448 * @var msg jQuery object containing the reference to
449 * the AJAX message shown to the user
450 */
451 var $msg = PMA_ajaxShowMessage(PMA_messages.strProcessingRequest);
453 // drop anchors of all selected rows
454 var drop_anchors = $('input.checkall:checked').parents('tr').find('.drop_anchor');
455 var success = true;
456 var count = drop_anchors.length;
457 var returnCount = 0;
459 drop_anchors.each(function () {
460 var $anchor = $(this);
461 /**
462 * @var $curr_row Object containing reference to the current row
463 */
464 var $curr_row = $anchor.parents('tr');
465 $.post($anchor.attr('href'), {'is_js_confirmed': 1, 'ajax_request': true}, function (data) {
466 returnCount++;
467 if (data.success === true) {
468 /**
469 * @var $table Object containing reference
470 * to the main list of elements
471 */
472 var $table = $curr_row.parent();
473 // Check how many rows will be left after we remove
474 // the one that the user has requested us to remove
475 if ($table.find('tr').length === 3) {
476 // If there are two rows left, it means that they are
477 // the header of the table and the rows that we are
478 // about to remove, so after the removal there will be
479 // nothing to show in the table, so we hide it.
480 $table.hide("slow", function () {
481 $(this).find('tr.even, tr.odd').remove();
482 $('.withSelected').remove();
483 $('#nothing2display').show("slow");
484 });
485 } else {
486 $curr_row.hide("fast", function () {
487 $(this).remove();
488 // Now we have removed the row from the list, but maybe
489 // some row classes are wrong now. So we will itirate
490 // throught all rows and assign correct classes to them.
491 /**
492 * @var ct Count of processed rows
493 */
494 var ct = 0;
495 /**
496 * @var rowclass Class to be attached to the row
497 * that is being processed
498 */
499 var rowclass = '';
500 $table.find('tr').has('td').each(function () {
501 rowclass = (ct % 2 === 1) ? 'odd' : 'even';
502 $(this).removeClass().addClass(rowclass);
503 ct++;
504 });
505 });
506 }
507 if (returnCount == count) {
508 if (success) {
509 // Get rid of the "Loading" message
510 PMA_ajaxRemoveMessage($msg);
511 $('#rteListForm_checkall').prop({checked: false, indeterminate: false});
512 }
513 PMA_reloadNavigation();
514 }
515 } else {
516 PMA_ajaxShowMessage(data.error, false);
517 success = false;
518 if (returnCount == count) {
519 PMA_reloadNavigation();
520 }
521 }
522 }); // end $.post()
523 }); // end drop_anchors.each()
524 }); // end $.PMA_confirm()
525 }
526 }; // end RTE namespace
528 /**
529 * @var RTE.EVENT JavaScript functionality for events
530 */
531 RTE.EVENT = {
532 validateCustom: function () {
533 /**
534 * @var elm a jQuery object containing the reference
535 * to an element that is being validated
536 */
537 var $elm = null;
538 if (this.$ajaxDialog.find('select[name=item_type]').find(':selected').val() === 'RECURRING') {
539 // The interval field must not be empty for recurring events
540 $elm = this.$ajaxDialog.find('input[name=item_interval_value]');
541 if ($elm.val() === '') {
542 $elm.focus();
543 alert(PMA_messages.strFormEmpty);
544 return false;
545 }
546 } else {
547 // The execute_at field must not be empty for "once off" events
548 $elm = this.$ajaxDialog.find('input[name=item_execute_at]');
549 if ($elm.val() === '') {
550 $elm.focus();
551 alert(PMA_messages.strFormEmpty);
552 return false;
553 }
554 }
555 return true;
556 }
557 };
559 /**
560 * @var RTE.ROUTINE JavaScript functionality for routines
561 */
562 RTE.ROUTINE = {
563 /**
564 * Overriding the postDialogShow() function defined in common.js
565 *
566 * @param data JSON-encoded data from the ajax request
567 */
568 postDialogShow: function (data) {
569 // Cache the template for a parameter table row
570 RTE.param_template = data.param_template;
571 var that = this;
572 // Make adjustments in the dialog to make it AJAX compatible
573 $('td.routine_param_remove').show();
574 $('input[name=routine_removeparameter]').remove();
575 $('input[name=routine_addparameter]').css('width', '100%');
576 // Enable/disable the 'options' dropdowns for parameters as necessary
577 $('table.routine_params_table').last().find('th[colspan=2]').attr('colspan', '1');
578 $('table.routine_params_table').last().find('tr').has('td').each(function () {
579 that.setOptionsForParameter(
580 $(this).find('select[name^=item_param_type]'),
581 $(this).find('input[name^=item_param_length]'),
582 $(this).find('select[name^=item_param_opts_text]'),
583 $(this).find('select[name^=item_param_opts_num]')
584 );
585 });
586 // Enable/disable the 'options' dropdowns for
587 // function return value as necessary
588 this.setOptionsForParameter(
589 $('table.rte_table').last().find('select[name=item_returntype]'),
590 $('table.rte_table').last().find('input[name=item_returnlength]'),
591 $('table.rte_table').last().find('select[name=item_returnopts_text]'),
592 $('table.rte_table').last().find('select[name=item_returnopts_num]')
593 );
594 // Allow changing parameter order
595 $('.routine_params_table tbody').sortable({
596 containment: '.routine_params_table tbody',
597 handle: '.dragHandle',
598 stop: function(event, ui) {
599 that.reindexParameters();
600 },
601 });
602 },
603 /**
604 * Reindexes the parameters after dropping a parameter or reordering parameters
605 */
606 reindexParameters: function () {
607 /**
608 * @var index Counter used for reindexing the input
609 * fields in the routine parameters table
610 */
611 var index = 0;
612 $('table.routine_params_table tbody').find('tr').each(function () {
613 $(this).find(':input').each(function () {
614 /**
615 * @var inputname The value of the name attribute of
616 * the input field being reindexed
617 */
618 var inputname = $(this).attr('name');
619 if (inputname.substr(0, 14) === 'item_param_dir') {
620 $(this).attr('name', inputname.substr(0, 14) + '[' + index + ']');
621 } else if (inputname.substr(0, 15) === 'item_param_name') {
622 $(this).attr('name', inputname.substr(0, 15) + '[' + index + ']');
623 } else if (inputname.substr(0, 15) === 'item_param_type') {
624 $(this).attr('name', inputname.substr(0, 15) + '[' + index + ']');
625 } else if (inputname.substr(0, 17) === 'item_param_length') {
626 $(this).attr('name', inputname.substr(0, 17) + '[' + index + ']');
627 $(this).attr('id', 'item_param_length_' + index);
628 } else if (inputname.substr(0, 20) === 'item_param_opts_text') {
629 $(this).attr('name', inputname.substr(0, 20) + '[' + index + ']');
630 } else if (inputname.substr(0, 19) === 'item_param_opts_num') {
631 $(this).attr('name', inputname.substr(0, 19) + '[' + index + ']');
632 }
633 });
634 index++;
635 });
636 },
637 /**
638 * Overriding the validateCustom() function defined in common.js
639 */
640 validateCustom: function () {
641 /**
642 * @var isSuccess Stores the outcome of the validation
643 */
644 var isSuccess = true;
645 /**
646 * @var inputname The value of the "name" attribute for
647 * the field that is being processed
648 */
649 var inputname = '';
650 this.$ajaxDialog.find('table.routine_params_table').last().find('tr').each(function () {
651 // Every parameter of a routine must have
652 // a non-empty direction, name and type
653 if (isSuccess) {
654 $(this).find(':input').each(function () {
655 inputname = $(this).attr('name');
656 if (inputname.substr(0, 14) === 'item_param_dir' ||
657 inputname.substr(0, 15) === 'item_param_name' ||
658 inputname.substr(0, 15) === 'item_param_type') {
659 if ($(this).val() === '') {
660 $(this).focus();
661 isSuccess = false;
662 return false;
663 }
664 }
665 });
666 } else {
667 return false;
668 }
669 });
670 if (! isSuccess) {
671 alert(PMA_messages.strFormEmpty);
672 return false;
673 }
674 this.$ajaxDialog.find('table.routine_params_table').last().find('tr').each(function () {
675 // SET, ENUM, VARCHAR and VARBINARY fields must have length/values
676 var $inputtyp = $(this).find('select[name^=item_param_type]');
677 var $inputlen = $(this).find('input[name^=item_param_length]');
678 if ($inputtyp.length && $inputlen.length) {
679 if (($inputtyp.val() === 'ENUM' || $inputtyp.val() === 'SET' || $inputtyp.val().substr(0, 3) === 'VAR') &&
680 $inputlen.val() === ''
681 ) {
682 $inputlen.focus();
683 isSuccess = false;
684 return false;
685 }
686 }
687 });
688 if (! isSuccess) {
689 alert(PMA_messages.strFormEmpty);
690 return false;
691 }
692 if (this.$ajaxDialog.find('select[name=item_type]').find(':selected').val() === 'FUNCTION') {
693 // The length/values of return variable for functions must
694 // be set, if the type is SET, ENUM, VARCHAR or VARBINARY.
695 var $returntyp = this.$ajaxDialog.find('select[name=item_returntype]');
696 var $returnlen = this.$ajaxDialog.find('input[name=item_returnlength]');
697 if (($returntyp.val() === 'ENUM' || $returntyp.val() === 'SET' || $returntyp.val().substr(0, 3) === 'VAR') &&
698 $returnlen.val() === ''
699 ) {
700 $returnlen.focus();
701 alert(PMA_messages.strFormEmpty);
702 return false;
703 }
704 }
705 if ($('select[name=item_type]').find(':selected').val() === 'FUNCTION') {
706 // A function must contain a RETURN statement in its definition
707 if (this.$ajaxDialog.find('table.rte_table').find('textarea[name=item_definition]').val().toUpperCase().indexOf('RETURN') < 0) {
708 this.syntaxHiglighter.focus();
709 alert(PMA_messages.MissingReturn);
710 return false;
711 }
712 }
713 return true;
714 },
715 /**
716 * Enable/disable the "options" dropdown and "length" input for
717 * parameters and the return variable in the routine editor
718 * as necessary.
719 *
720 * @param type a jQuery object containing the reference
721 * to the "Type" dropdown box
722 * @param len a jQuery object containing the reference
723 * to the "Length" input box
724 * @param text a jQuery object containing the reference
725 * to the dropdown box with options for
726 * parameters of text type
727 * @param num a jQuery object containing the reference
728 * to the dropdown box with options for
729 * parameters of numeric type
730 */
731 setOptionsForParameter: function ($type, $len, $text, $num) {
732 /**
733 * @var no_opts a jQuery object containing the reference
734 * to an element to be displayed when no
735 * options are available
736 */
737 var $no_opts = $text.parent().parent().find('.no_opts');
738 /**
739 * @var no_len a jQuery object containing the reference
740 * to an element to be displayed when no
741 * "length/values" field is available
742 */
743 var $no_len = $len.parent().parent().find('.no_len');
745 // Process for parameter options
746 switch ($type.val()) {
747 case 'TINYINT':
748 case 'SMALLINT':
749 case 'MEDIUMINT':
750 case 'INT':
751 case 'BIGINT':
752 case 'DECIMAL':
753 case 'FLOAT':
754 case 'DOUBLE':
755 case 'REAL':
756 $text.parent().hide();
757 $num.parent().show();
758 $no_opts.hide();
759 break;
760 case 'TINYTEXT':
761 case 'TEXT':
762 case 'MEDIUMTEXT':
763 case 'LONGTEXT':
764 case 'CHAR':
765 case 'VARCHAR':
766 case 'SET':
767 case 'ENUM':
768 $text.parent().show();
769 $num.parent().hide();
770 $no_opts.hide();
771 break;
772 default:
773 $text.parent().hide();
774 $num.parent().hide();
775 $no_opts.show();
776 break;
777 }
778 // Process for parameter length
779 switch ($type.val()) {
780 case 'DATE':
781 case 'DATETIME':
782 case 'TIME':
783 case 'TINYBLOB':
784 case 'TINYTEXT':
785 case 'BLOB':
786 case 'TEXT':
787 case 'MEDIUMBLOB':
788 case 'MEDIUMTEXT':
789 case 'LONGBLOB':
790 case 'LONGTEXT':
791 $text.closest('tr').find('a:first').hide();
792 $len.parent().hide();
793 $no_len.show();
794 break;
795 default:
796 if ($type.val() == 'ENUM' || $type.val() == 'SET') {
797 $text.closest('tr').find('a:first').show();
798 } else {
799 $text.closest('tr').find('a:first').hide();
800 }
801 $len.parent().show();
802 $no_len.hide();
803 break;
804 }
805 },
806 executeDialog: function ($this) {
807 var that = this;
808 /**
809 * @var msg jQuery object containing the reference to
810 * the AJAX message shown to the user
811 */
812 var $msg = PMA_ajaxShowMessage();
813 $.post($this.attr('href'), {'ajax_request': true}, function (data) {
814 if (data.success === true) {
815 PMA_ajaxRemoveMessage($msg);
816 // If 'data.dialog' is true we show a dialog with a form
817 // to get the input parameters for routine, otherwise
818 // we just show the results of the query
819 if (data.dialog) {
820 // Define the function that is called when
821 // the user presses the "Go" button
822 that.buttonOptions[PMA_messages.strGo] = function () {
823 /**
824 * @var data Form data to be sent in the AJAX request
825 */
826 var data = $('form.rte_form').last().serialize();
827 $msg = PMA_ajaxShowMessage(
828 PMA_messages.strProcessingRequest
829 );
830 $.post('db_routines.php', data, function (data) {
831 if (data.success === true) {
832 // Routine executed successfully
833 PMA_ajaxRemoveMessage($msg);
834 PMA_slidingMessage(data.message);
835 $ajaxDialog.dialog('close');
836 } else {
837 PMA_ajaxShowMessage(data.error, false);
838 }
839 });
840 };
841 that.buttonOptions[PMA_messages.strClose] = function () {
842 $(this).dialog("close");
843 };
844 /**
845 * Display the dialog to the user
846 */
847 var $ajaxDialog = $('<div>' + data.message + '</div>').dialog({
848 width: 650,
849 buttons: that.buttonOptions,
850 title: data.title,
851 modal: true,
852 close: function () {
853 $(this).remove();
854 }
855 });
856 $ajaxDialog.find('input[name^=params]').first().focus();
857 /**
858 * Attach the datepickers to the relevant form fields
859 */
860 $ajaxDialog.find('input.datefield, input.datetimefield').each(function () {
861 PMA_addDatepicker($(this).css('width', '95%'));
862 });
863 /*
864 * Define the function if the user presses enter
865 */
866 $('form.rte_form').on('keyup', function (event) {
867 event.preventDefault();
868 if (event.keyCode === 13) {
869 /**
870 * @var data Form data to be sent in the AJAX request
871 */
872 var data = $(this).serialize();
873 $msg = PMA_ajaxShowMessage(
874 PMA_messages.strProcessingRequest
875 );
876 var url = $(this).attr('action');
877 $.post(url, data, function (data) {
878 if (data.success === true) {
879 // Routine executed successfully
880 PMA_ajaxRemoveMessage($msg);
881 PMA_slidingMessage(data.message);
882 $('form.rte_form').off('keyup');
883 $ajaxDialog.remove();
884 } else {
885 PMA_ajaxShowMessage(data.error, false);
886 }
887 });
888 }
889 });
890 } else {
891 // Routine executed successfully
892 PMA_slidingMessage(data.message);
893 }
894 } else {
895 PMA_ajaxShowMessage(data.error, false);
896 }
897 }); // end $.post()
898 }
899 };
901 /**
902 * Attach Ajax event handlers for the Routines, Triggers and Events editor
903 */
904 $(function () {
905 /**
906 * Attach Ajax event handlers for the Add/Edit functionality.
907 */
908 $(document).on('click', 'a.ajax.add_anchor, a.ajax.edit_anchor', function (event) {
909 event.preventDefault();
910 var type = $(this).attr('href').substr(0, $(this).attr('href').indexOf('?'));
911 if (type.indexOf('routine') != -1) {
912 type = 'routine';
913 } else if (type.indexOf('trigger') != -1) {
914 type = 'trigger';
915 } else if (type.indexOf('event') != -1) {
916 type = 'event';
917 } else {
918 type = '';
919 }
920 var dialog = new RTE.object(type);
921 dialog.editorDialog($(this).hasClass('add_anchor'), $(this));
922 }); // end $(document).on()
924 /**
925 * Attach Ajax event handlers for the Execute routine functionality
926 */
927 $(document).on('click', 'a.ajax.exec_anchor', function (event) {
928 event.preventDefault();
929 var dialog = new RTE.object('routine');
930 dialog.executeDialog($(this));
931 }); // end $(document).on()
933 /**
934 * Attach Ajax event handlers for Export of Routines, Triggers and Events
935 */
936 $(document).on('click', 'a.ajax.export_anchor', function (event) {
937 event.preventDefault();
938 var dialog = new RTE.object();
939 dialog.exportDialog($(this));
940 }); // end $(document).on()
942 $(document).on('click', '#rteListForm.ajax .mult_submit[value="export"]', function (event) {
943 event.preventDefault();
944 var dialog = new RTE.object();
945 dialog.exportDialog($(this));
946 }); // end $(document).on()
948 /**
949 * Attach Ajax event handlers for Drop functionality
950 * of Routines, Triggers and Events.
951 */
952 $(document).on('click', 'a.ajax.drop_anchor', function (event) {
953 event.preventDefault();
954 var dialog = new RTE.object();
955 dialog.dropDialog($(this));
956 }); // end $(document).on()
958 $(document).on('click', '#rteListForm.ajax .mult_submit[value="drop"]', function (event) {
959 event.preventDefault();
960 var dialog = new RTE.object();
961 dialog.dropMultipleDialog($(this));
962 }); // end $(document).on()
964 /**
965 * Attach Ajax event handlers for the "Change event/routine type"
966 * functionality in the events editor, so that the correct
967 * rows are shown in the editor when changing the event type
968 */
969 $(document).on('change', 'select[name=item_type]', function () {
970 $(this)
971 .closest('table')
972 .find('tr.recurring_event_row, tr.onetime_event_row, tr.routine_return_row, .routine_direction_cell')
973 .toggle();
974 }); // end $(document).on()
976 /**
977 * Attach Ajax event handlers for the "Change parameter type"
978 * functionality in the routines editor, so that the correct
979 * option/length fields, if any, are shown when changing
980 * a parameter type
981 */
982 $(document).on('change', 'select[name^=item_param_type]', function () {
983 /**
984 * @var row jQuery object containing the reference to
985 * a row in the routine parameters table
986 */
987 var $row = $(this).parents('tr').first();
988 var rte = new RTE.object('routine');
989 rte.setOptionsForParameter(
990 $row.find('select[name^=item_param_type]'),
991 $row.find('input[name^=item_param_length]'),
992 $row.find('select[name^=item_param_opts_text]'),
993 $row.find('select[name^=item_param_opts_num]')
994 );
995 }); // end $(document).on()
997 /**
998 * Attach Ajax event handlers for the "Change the type of return
999 * variable of function" functionality, so that the correct fields,
1000 * if any, are shown when changing the function return type type
1001 */
1002 $(document).on('change', 'select[name=item_returntype]', function () {
1003 var rte = new RTE.object('routine');
1004 var $table = $(this).closest('table.rte_table');
1005 rte.setOptionsForParameter(
1006 $table.find('select[name=item_returntype]'),
1007 $table.find('input[name=item_returnlength]'),
1008 $table.find('select[name=item_returnopts_text]'),
1009 $table.find('select[name=item_returnopts_num]')
1010 );
1011 }); // end $(document).on()
1013 /**
1014 * Attach Ajax event handlers for the "Add parameter to routine" functionality
1015 */
1016 $(document).on('click', 'input[name=routine_addparameter]', function (event) {
1017 event.preventDefault();
1018 /**
1019 * @var routine_params_table jQuery object containing the reference
1020 * to the routine parameters table
1021 */
1022 var $routine_params_table = $(this).closest('div.ui-dialog').find('.routine_params_table');
1023 /**
1024 * @var new_param_row A string containing the HTML code for the
1025 * new row for the routine parameters table
1026 */
1027 var new_param_row = RTE.param_template.replace(/%s/g, $routine_params_table.find('tr').length - 1);
1028 // Append the new row to the parameters table
1029 $routine_params_table.append(new_param_row);
1030 // Make sure that the row is correctly shown according to the type of routine
1031 if ($(this).closest('div.ui-dialog').find('table.rte_table select[name=item_type]').val() === 'FUNCTION') {
1032 $('tr.routine_return_row').show();
1033 $('td.routine_direction_cell').hide();
1034 }
1035 /**
1036 * @var newrow jQuery object containing the reference to the newly
1037 * inserted row in the routine parameters table
1038 */
1039 var $newrow = $(this).closest('div.ui-dialog').find('table.routine_params_table').find('tr').has('td').last();
1040 // Enable/disable the 'options' dropdowns for parameters as necessary
1041 var rte = new RTE.object('routine');
1042 rte.setOptionsForParameter(
1043 $newrow.find('select[name^=item_param_type]'),
1044 $newrow.find('input[name^=item_param_length]'),
1045 $newrow.find('select[name^=item_param_opts_text]'),
1046 $newrow.find('select[name^=item_param_opts_num]')
1047 );
1048 }); // end $(document).on()
1050 /**
1051 * Attach Ajax event handlers for the
1052 * "Remove parameter from routine" functionality
1053 */
1054 $(document).on('click', 'a.routine_param_remove_anchor', function (event) {
1055 event.preventDefault();
1056 $(this).parent().parent().remove();
1057 // After removing a parameter, the indices of the name attributes in
1058 // the input fields lose the correct order and need to be reordered.
1059 RTE.ROUTINE.reindexParameters();
1060 }); // end $(document).on()
1061 }); // end of $()