CoreFiles by mySites.guru
widget.js305 lines, 14,718 bytes, from Joomla_4.0.0-beta1-Beta-Full_Package.zip
Raw History Compare with 3.9.0-beta4
md5
68a2de5e71f34e80c685f852e4787bf8
sha1
2d76b8330815095d8d805ad988e14512a3ac2d1a
sha256
bbfe51609d22eba4e744ce9d1ecd566a90abf544ac51708351c3c8d1379ed1d3
(function ($) {

    var csscls = PhpDebugBar.utils.makecsscls('phpdebugbar-widgets-')

    /**
     * Widget for the displaying sql queries
     *
     * Options:
     *  - data
     */
    var SQLQueriesWidget = PhpDebugBar.Widgets.SQLQueriesWidget = PhpDebugBar.Widget.extend({

        className: csscls('sqlqueries'),

        onFilterClick: function (el) {
            $(el).toggleClass(csscls('excluded'))

            var excludedLabels = []
            this.$toolbar.find(csscls('.filter') + csscls('.excluded')).each(function () {
                excludedLabels.push(this.rel)
            })

            this.$list.$el.find('li[connection=' + $(el).attr('rel') + ']').toggle()

            this.set('exclude', excludedLabels)
        },
        onFilterDupesClick: function (el) {
            $(el).toggleClass(csscls('excluded'))

            var excludedLabels = []
            this.$toolbar.find(csscls('.filter') + csscls('.excluded')).each(function () {
                excludedLabels.push(this.rel)
            })

            this.$list.$el.find('li[dupeindex=' + $(el).attr('rel') + ']').toggle()

            this.set('exclude', excludedLabels)
        },
        onCopyToClipboard: function (el) {
            var code = $(el).parent('li').find('code').get(0)
            var copy = function () {
                try {
                    document.execCommand('copy')
                    alert('Query copied to the clipboard')
                } catch (err) {
                    console.log('Oops, unable to copy')
                }
            }
            var select = function (node) {
                if (document.selection) {
                    var range = document.body.createTextRange()
                    range.moveToElementText(node)
                    range.select()
                } else if (window.getSelection) {
                    var range = document.createRange()
                    range.selectNodeContents(node)
                    window.getSelection().removeAllRanges()
                    window.getSelection().addRange(range)
                }
                copy()
                window.getSelection().removeAllRanges()
            }
            select(code)
        },
        render: function () {
            this.$status = $('<div />').addClass(csscls('status')).appendTo(this.$el)

            this.$toolbar = $('<div></div>').addClass(csscls('toolbar')).appendTo(this.$el)

            var filters = [], self = this

            this.$list = new PhpDebugBar.Widgets.ListWidget({
                itemRenderer: function (li, stmt) {
                    $('<code />').addClass(csscls('sql')).html(PhpDebugBar.Widgets.highlight(stmt.sql, 'sql')).appendTo(li)
                    if (stmt.duration_str) {
                        $('<span title="Duration" />').addClass(csscls('duration')).text(stmt.duration_str).appendTo(li)
                    }
                    if (stmt.memory_str) {
                        $('<span title="Memory usage" />').addClass(csscls('memory')).text(stmt.memory_str).appendTo(li)
                    }
                    if (typeof(stmt.row_count) != 'undefined') {
                        $('<span title="Row count" />').addClass(csscls('row-count')).text(stmt.row_count).appendTo(li)
                    }
                    if (typeof(stmt.stmt_id) != 'undefined' && stmt.stmt_id) {
                        $('<span title="Prepared statement ID" />').addClass(csscls('stmt-id')).text(stmt.stmt_id).appendTo(li)
                    }
                    if (stmt.connection) {
                        $('<span title="Connection" />').addClass(csscls('database')).text(stmt.connection).appendTo(li)
                        li.attr('connection', stmt.connection)
                        if ($.inArray(stmt.connection, filters) == -1) {
                            filters.push(stmt.connection)
                            $('<a />')
                                .addClass(csscls('filter'))
                                .text(stmt.connection)
                                .attr('rel', stmt.connection)
                                .on('click', function () {
                                    self.onFilterClick(this)
                                })
                                .appendTo(self.$toolbar)
                            if (filters.length > 1) {
                                self.$toolbar.show()
                                self.$list.$el.css('margin-bottom', '20px')
                            }
                        }
                    }
                    if (typeof(stmt.is_success) != 'undefined' && !stmt.is_success) {
                        li.addClass(csscls('error'))
                        li.append($('<span />').addClass(csscls('error')).text('[' + stmt.error_code + '] ' + stmt.error_message))
                    }
                    if (stmt.params && !$.isEmptyObject(stmt.params)) {
                        var table = $('<table><tr><th colspan="2">Params</th></tr></table>').addClass(csscls('params')).appendTo(li)
                        for (var key in stmt.params) {
                            if (typeof stmt.params[key] !== 'function') {
                                table.append('<tr><td class="' + csscls('name') + '">' + key + '</td><td class="' + csscls('value') +
                                    '">' + stmt.params[key] + '</td></tr>')
                            }
                        }
                        li.css('cursor', 'pointer').click(function () {
                            if (table.is(':visible')) {
                                table.hide()
                            } else {
                                table.show()
                            }
                        })
                    }

                    var tableExplain

                    if (stmt.explain && !$.isEmptyObject(stmt.explain)) {
                        var btnExplain = $('<span title="Explain" />')
                            .text('Explain')
                            .addClass(csscls('eye'))
                            .css('cursor', 'pointer')
                            .on('click', function () {
                                if (tableExplain.is(':visible')) {
                                    tableExplain.hide()
                                    btnExplain.addClass(csscls('eye'))
                                    btnExplain.removeClass(csscls('eye-dash'))
                                } else {
                                    tableExplain.show()
                                    btnExplain.addClass(csscls('eye-dash'))
                                    btnExplain.removeClass(csscls('eye'))
                                }
                            })
                            .appendTo(li)

                        tableExplain = $('<table><thead>'
                            + '<tr><th colspan="10">Explain</th></tr>'
                            + '<tr><th>Id</th><th>Select Type</th><th>Table</th><th>Type</th><th>Possible Keys</th><th>Key</th><th>Key Len</th><th>Ref</th><th>Rows</th><th>Extra</th></tr>'
                            + '</thead></table>').addClass(csscls('callstack'))
                    }

                    var tableStack

                    if (stmt.callstack && !$.isEmptyObject(stmt.callstack)) {
                        var btnStack = $('<span title="Call Stack" />')
                            .text('Stack')
                            .addClass(csscls('eye'))
                            .css('cursor', 'pointer')
                            .on('click', function () {
                                if (tableStack.is(':visible')) {
                                    tableStack.hide()
                                    btnStack.addClass(csscls('eye'))
                                    btnStack.removeClass(csscls('eye-dash'))
                                } else {
                                    tableStack.show()
                                    btnStack.addClass(csscls('eye-dash'))
                                    btnStack.removeClass(csscls('eye'))
                                }
                            })
                            .appendTo(li)

                        tableStack = $('<table><thead><tr><th colspan="3">Call Stack</th></tr></thead></table>').addClass(csscls('callstack'))
                    }

                    if (typeof(stmt.caller) != 'undefined' && stmt.caller) {
                        var caller = stmt.caller.replace(self.root_path, '')
                        if (self.xdebug_link) {
                            var parts = stmt.caller.split(':')
                            $('<a />')
                                .text(caller)
                                .addClass(csscls('editor-link'))
                                .attr('href', self.xdebug_link.replace('%f', parts[0]).replace('%l', parts[1]))
                                .appendTo(li)
                        } else {
                            $('<span title="Caller" />')
                                .text(caller)
                                .addClass(csscls('stmt-id'))
                                .appendTo(li)
                        }
                    }

                    $('<span title="Copy to clipboard" />')
                        .text('Copy')
                        .addClass(csscls('copy-clipboard'))
                        .css('cursor', 'pointer')
                        .on('click', function (event) {
                            self.onCopyToClipboard(this)
                            event.stopPropagation()
                        })
                        .appendTo(li)

                    if (tableStack) {
                        tableStack.appendTo(li)
                        for (var i in stmt.callstack) {
                            var entry = stmt.callstack[i]
                            var location = entry[3] ? entry[3].replace(self.root_path, '') + ':' + entry[4] : ''
                            var caller = entry[2].replace(self.root_path, '')
                            var cssClass = entry[1] ? 'caller' : ''
                            if (location && self.xdebug_link) {
                                location = '<a href="' + self.xdebug_link.replace('%f', entry[3]).replace('%l', entry[4]) + '">' + location + '</a>'
                            }
                            tableStack.append('<tr class="' + cssClass + '"><th>' + entry[0] + '</th><td>' + caller + '</td><td>' + location + '</td></tr>')
                        }
                    }

                    if (tableExplain) {
                        tableExplain.appendTo(li)
                        for (i in stmt.explain) {
                            var entry = stmt.explain[i]
                            tableExplain.append('<tr>'
                                + '<td>' + entry.id + '</td><td>' + entry.select_type + '</td><td>' + entry.table + '</td>'
                                + '<td>' + entry.type + '</td><td>' + entry.possible_keys + '</td><td>' + entry.key + '</td>'
                                + '<td>' + entry.key_len + '</td><td>' + entry.ref + '</td><td>' + entry.rows + '</td>'
                                + '<td>' + entry.Extra + '</td>'
                                + '</tr>')
                        }
                    }

                    li.attr('dupeindex', 'dupe-0')
                }
            })
            this.$list.$el.appendTo(this.$el)

            this.bindAttr('data', function (data) {
                // the collector maybe is empty
                if (data.length <= 0) {
                    return false
                }

                this.root_path = data.root_path
                this.xdebug_link = data.xdebug_link
                this.$list.set('data', data.statements)
                this.$status.empty()

                // Search for duplicate statements.
                for (var sql = {}, unique = 0, duplicate = 0, i = 0; i < data.statements.length; i++) {
                    var stmt = data.statements[i].sql
                    if (data.statements[i].params && !$.isEmptyObject(data.statements[i].params)) {
                        stmt += ' {' + $.param(data.statements[i].params, false) + '}'
                    }
                    sql[stmt] = sql[stmt] || {keys: []}
                    sql[stmt].keys.push(i)
                }
                // Add classes to all duplicate SQL statements.
                var cnt = 0
                for (var stmt in sql) {
                    if (sql[stmt].keys.length > 1) {
                        duplicate += sql[stmt].keys.length
                        cnt++
                        for (var i = 0; i < sql[stmt].keys.length; i++) {
                            this.$list.$el.find('.' + csscls('list-item')).eq(sql[stmt].keys[i])
                                .addClass(csscls('sql-duplicate'))
                                .attr('dupeindex', 'dupe-' + cnt)
                        }
                    } else {
                        unique++
                    }
                }

                if (duplicate) {
                    for (i = 0; i <= cnt; i++) {
                        $('<a />')
                            .addClass(csscls('filter'))
                            .text(i ? 'Duplicates ' + i : 'Uniques')
                            .attr('rel', 'dupe-' + i)
                            .on('click', function () {
                                self.onFilterDupesClick(this)
                            })
                            .appendTo(self.$toolbar)
                    }
                    self.$toolbar.show()
                    self.$list.$el.css('margin-bottom', '20px')
                }

                var t = $('<span />').text(data.nb_statements + ' statements were executed').appendTo(this.$status)
                if (data.nb_failed_statements) {
                    t.append(', ' + data.nb_failed_statements + ' of which failed')
                }
                if (duplicate) {
                    t.append(', ' + duplicate + ' of which were duplicates')
                    t.append(', ' + unique + ' unique')
                }
                if (data.accumulated_duration_str) {
                    this.$status.append($('<span title="Accumulated duration" />').addClass(csscls('duration')).text(data.accumulated_duration_str))
                }
                if (data.memory_usage_str) {
                    this.$status.append($('<span title="Memory usage" />').addClass(csscls('memory')).text(data.memory_usage_str))
                }
            })
        }

    })

})(PhpDebugBar.$)

The same content is in 11 releases, Joomla 4.0.0-alpha5 to 4.0.0-beta3. See them all, or every version of this file.