On Thu, Jun 9, 2011 at 10:35 PM, Marc Delisle marc@infomarc.info wrote:
Ammar Yasir a écrit :
On Sat, Jun 4, 2011 at 9:57 PM, Ammar Yasir <ammaryasir.88@gmail.com mailto:ammaryasir.88@gmail.com> wrote:
On Wed, Jun 1, 2011 at 7:47 PM, Madhura Jayaratne <madhura.cj@gmail.com <mailto:madhura.cj@gmail.com>> wrote: On Wed, Jun 1, 2011 at 5:30 PM, Marc Delisle <marc@infomarc.info <mailto:marc@infomarc.info>> wrote: Madhura Jayaratne a écrit : > > > On Wed, Jun 1, 2011 at 4:30 PM, Madhura Jayaratne <madhura.cj@gmail.com <mailto:madhura.cj@gmail.com> > <mailto:madhura.cj@gmail.com <mailto:madhura.cj@gmail.com>>> wrote: > > > > On Wed, Jun 1, 2011 at 2:10 AM, Ammar Yasir <ammaryasir.88@gmail.com <mailto:ammaryasir.88@gmail.com> > <mailto:ammaryasir.88@gmail.com <mailto:ammaryasir.88@gmail.com>>> wrote: > > > > On Wed, Jun 1, 2011 at 1:55 AM, Marc Delisle <marc@infomarc.info <mailto:marc@infomarc.info> > <mailto:marc@infomarc.info <mailto:marc@infomarc.info>>> wrote: > > Ammar Yasir a écrit : > > > > > > On Tue, May 31, 2011 at 10:14 PM, MarcDelisle
> <marc@infomarc.info <mailto:marc@infomarc.info> <mailto:marc@infomarc.info <mailto:marc@infomarc.info>> > > <mailto:marc@infomarc.info <mailto:marc@infomarc.info> <mailto:marc@infomarc.info <mailto:marc@infomarc.info>>>> > wrote: > > > > Ammar Yasir a écrit : > > > > > Parts refactored are: > > > - Setting titles (titles['Browse']]) > > > - getting fields list (getting column details) > > > - setting sub-tabs (Table search and Zoom search) > > > - setting table header of QBEdisplay
> > > - displaying foreign data > > > - search criteria input elements (HTML content > generation for the > > input > > > elements) > > > > Very good! > > > > Another trick you can use: when a function returns an > array, like your > > PMA_tbl_getFields(), to fill all the returned values > in one statement > > you can use this syntax: > > > > list($fields_list, $fields_type, $fields_collation, > $fields_null) = > > PMA_tbl_getFields($table,$db); > > > > > > I made some more changes. > > OK. There are still a few tab characters (found some in > libraries/tbl_select.lib.php). > > > Should I proceed now to try the charting libraries? > > Yes but in your proposal you wrote that you preferred > jQuery-SVG so I > assume you'll try this one first? > > I'll try SVG first. I'm following what others have to say about > SVG, Madhura is using it for his GIS visualization. Tyron > proposed real-time charting but I don't think it'll be of much > help in our case. > > > Hi Ammar, > > I'm not sure what exactly your requirement is. But pls have a look > at the visualization of data at [1] by clicking on the 'Visualize > GIS data' link in the 'Query results operations' section towards the > bottom of the page. Try out zooming by double clicking and panning > by dragging. I believe you are looking for something like this for > your zoom search feature. Madhura, I have issues operating panning and zooming. Here is the scenario: 1. Browse world_cities and click Visualize GIS data 2. Click-drag: pans OK 3. Double-click: this is a zoom out, I guess 4. Click-drag: no panning 5. Click "zoom out": data points are enlarging, isn't this a zoom-in? Marc, This is a Firefox compatibility problem. Resolved and pushed to the repo. Demo will take some time to upgrade to the new version. Meanwhile if you have Chrome, you can still experience what it's suppose to do. -- Thanks and Regards, Madhura Jayaratne Hi, I was looking up jQuery-SVG and SVG past two days. There has been a discussion going on in the list about whether to include a different plotting library than existing(pChart). For now, instead of including another plotting library, I've developed a prototype that creates the plot using just SVG. I'll push it to my repo sometime later today.Hi,
I've pushed my work. The basic plot functionality is implemented along with classes for the same. Currently it works only for numeric fields, I'll add support for other data types after some testing. You can try scenarios in 'sakila' database and search 'films' or 'film_actor' table.
Ammar, I'm concentrating on testing the interface right now, haven't looked at the code yet.
Hi,
- Let's say I choose film_actor, activate actor_id and film_id and
enter 1 as the actor id. When I get the results, I no longer see the value I entered in the dialog.
But this scenario gives me a notice: Notice in ./libraries/svg_plot/pma_scatter_plot.php#224 Undefined index:
Backtrace
./libraries/svg_plot/pma_scatter_plot.php#161: PMA_Scatter_Plot->_prepareDataSet( array, integer 0, array, string , ) ./libraries/svg_plot/pma_scatter_plot.php#176: PMA_Scatter_Plot->_svg() ./libraries/tbl_select.lib.php#373: PMA_Scatter_Plot->asSVG() ./tbl_zoom_select.php#131: PMA_SVG_scatter_plot( array, array, )
I fixed this issue. The notice comes if you do not select a label, I added
a default to it so the notice should not come now.
- What should I enter as data label to have meaningful results? Please
give an example.
Actually, we had to show a label for each data point. So for example in
'film' table or 'actor' table 'name' could be a label for points. I haven't implemented showing the label yet, the selection just stores the label for each point internally. I thought showing the label for now (without the zoom feature) would make the plot very difficult to understand.
- Did you find a table (in sakila) for which choosing two columns and
generating a plot would make me recognize some kind of trend in the data?
As an example, on a copy of the film table I did update film_copy set length = length*3 where film_id > 500
and I was able to see some trend in the plot.
I've added plotting string fields too, so some scenarios in sakila database
you can check: 'film_list' or 'nicer_but_slower_film_list' tables, plot fid vs category 'sales_by_film_category' table, plot total_sales vs category 'payment' table, plot customer_id vs amount
-- Marc Delisle http://infomarc.info
EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel