[Phpmyadmin-devel] Show/hide column feature

[Tyron Madlener]

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.

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
>
> ------------------------------------------------------------------------------
> Magic Quadrant for Content-Aware Data Loss Prevention
> Research study explores the data loss prevention market. Includes in-depth
> analysis on the changes within the DLP market, and the criteria used to
> evaluate the strengths and weaknesses of these DLP solutions.
> http://www.accelacomm.com/jaw/sfnl/114/51385063/
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>