[Phpmyadmin-devel] Show/hide column feature

[Rouslan Placella]

On Tue, 2011-07-26 at 22:11 +0300, Tyron Madlener wrote:
> On Tue, Jul 26, 2011 at 8:27 PM, Aris Feryanto <aris_feryanto at yahoo.com> wrote:
> > Hi Tyron,
> >
> > On 26 Jul 2011, at 21:07, Tyron Madlener <tyronx at gmail.com> wrote:
> >
> >> Hi Aris
> >>
> >> Is there any possibility to partly or fully reuse the code for column
> >> show/hide feature and the column reordering?
> >> I would very much like to use the same features for my log tables on
> >> the Status page -> Monitor Tab.
> >
> > With current code, I think it is possible, but not fully compatible since current code is built to work with browse-mode table. Column reordering may work correctly, but you need to add "draggable" class for each <th> that want to be reordered. While for show/hide column, I think it won't work correctly, unless there is at least one "non-draggable" <th> like the "Action" <th> in browse-mode to place the column visibility drop-down.
> 
> That's good to hear. Sounds like it wouldn't be too much efforts to
> adjust to code to work for my tables :-)
> 
> >
> > Btw, about log tables on the Status -> Monitor, how to show the table? I have set log_output to TABLE, but cannot see the table. Maybe I can give a better description if I can see the table.

general_log and slow_log are tables in the mysql db ;)

Rouslan

> If general_log and/or slow_log is enabled to the server will start
> accumulate logs into those tables. Then you can select a timespan on
> any of the charts with the mouse. This will open a dialog where you
> can select to load data from either general_log or slow_log.
> 
> >
> >>
> >> Thanks,
> >> Tyron
> >>
> >> On Fri, Jun 24, 2011 at 8:04 PM, Aris Feryanto <aris_feryanto at yahoo.com> wrote:
> >>> Hi,
> >>>
> >>>
> >>> I've just pushed my commits for show/hide column feature. If you have some time, please give it a try at [0] and let me know if you have any comment or suggestion.
> >>>
> >>> When you are testing, please note that the feature still lack of some things:
> >>> - column visibility list drop-down arrows are shown in "too many" places when display mode = vertical AND repeatCells = small number
> >>> - the hide (small X) button is sometimes annoying, especially when we want to sort a small column (e.g., usually ID). I've tried to resize all columns using jQuery to properly display the "hide" button next to the column label. But, unfortunately, it is quite slow. Any other suggestion? Should we remove the "hide" button?
> >>>
> >>> [0] http://demo.phpmyadmin.net/gsoc-aris
> >>>
> >
> > --
> > Aris Feryanto