[jira] Created: (OFBIZ-794) POC: Rico LiveGrid

[Nicolas Malin (Jira)]

POC: Rico LiveGrid
------------------

                 Key: OFBIZ-794
                 URL: https://issues.apache.org/jira/browse/OFBIZ-794
             Project: OFBiz (The Open for Business Project)
          Issue Type: New Feature
            Reporter: Chris Howe
            Priority: Minor


POC to incorporate Rico LiveGrid into tabular data to create "pageless" result sets

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-794?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chris Howe updated OFBIZ-794:
-----------------------------

    Attachment: ricowt.patch

ricowt.patch

Covers a couple of concepts.  

1) Creates "pageless" result sets for Find Generic
2) New search done with every keystroke
3) demonstrates the <include/> statement in the controller.xml like in ecomclone but does it along with additional request-uri and view-map (not that there is anything to it, just not demonstrated in ecomclone).

Work in progress.  
a) Styling especially
b) table header doesn't line up because it requires separate tables for header and data.
c) needs additional call back to update header
d) I only looked at an Entity with few fields, probably gets pretty ugly with entities that creates a horizontal scrollbar (Rico LiveGrid Plus would solve this)
e) the rico.js included has been modified slightly to eliminate a bug

This is a quick test
a) apply patch to hot-deploy
b) start(restart) ofbiz
c) go to http://localhost:8080/ricowt/control/main and proceed to entity maintenance and click "All" on an entity you know has few fields, but large result set (Geo perhaps)

> POC: Rico LiveGrid
> ------------------
>
>                 Key: OFBIZ-794
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-794
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: New Feature
>            Reporter: Chris Howe
>            Priority: Minor
>         Attachments: ricowt.patch
>
>
> POC to incorporate Rico LiveGrid into tabular data to create "pageless" result sets

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-794?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12479362 ]

Chris Howe commented on OFBIZ-794:
----------------------------------

Just as a note, while the search after every keystroke works correctly, the underlying search uses equals instead of like, so on the Geo, if your query A!=AA

> POC: Rico LiveGrid
> ------------------
>
>                 Key: OFBIZ-794
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-794
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: New Feature
>            Reporter: Chris Howe
>            Priority: Minor
>         Attachments: ricowt.patch
>
>
> POC to incorporate Rico LiveGrid into tabular data to create "pageless" result sets

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-794?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Le Roux updated OFBIZ-794:
----------------------------------

    Attachment: rico.jpg

Chris,

Not sure why, I get this (screencopy attached) either on Firefox 2.0.02, IE 7 and Opera 9.02. Std webtools ok.

> POC: Rico LiveGrid
> ------------------
>
>                 Key: OFBIZ-794
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-794
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: New Feature
>            Reporter: Chris Howe
>            Priority: Minor
>         Attachments: rico.jpg, ricowt.patch
>
>
> POC to incorporate Rico LiveGrid into tabular data to create "pageless" result sets

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-794?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12481393 ]

Chris Howe commented on OFBIZ-794:
----------------------------------

That's what it's "supposed" to look like if there is no data.  Webtools probably wasn't the best POC.  I've been doing a much better one for the partymgr/control/main form.  I'll create a patch for it tomorrow with a screenshot.  

Because the fields and field widths are variable in the webtools, it's impossible without additional javascript to get that to look right when the header row and the data rows are separate tables.  In the std webtools, the header row and data rows are part of the same table, so their width is automatically set to the largest cell in the column.

Use the Firefox extension firebug to debug it along of course with your log files.


*"supposed" to meaning the extent of the artistic use that has been applied in the patch.

> POC: Rico LiveGrid
> ------------------
>
>                 Key: OFBIZ-794
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-794
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: New Feature
>            Reporter: Chris Howe
>            Priority: Minor
>         Attachments: rico.jpg, ricowt.patch
>
>
> POC to incorporate Rico LiveGrid into tabular data to create "pageless" result sets

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-794?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12481416 ]

Jacques Le Roux commented on OFBIZ-794:
---------------------------------------

Chris,

As I mentionned I have data in Geo and I can see them in webtools (676 records), not in ricowt. Did you tried it yourself ? Is it working on your machine ?

> POC: Rico LiveGrid
> ------------------
>
>                 Key: OFBIZ-794
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-794
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: New Feature
>            Reporter: Chris Howe
>            Priority: Minor
>         Attachments: rico.jpg, ricowt.patch
>
>
> POC to incorporate Rico LiveGrid into tabular data to create "pageless" result sets

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-794?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12481424 ]

Chris Howe commented on OFBIZ-794:
----------------------------------

Jacques,
I may have had something additionally in my classpath when I tested this originally.  I'll check it out and put another patch up here in an hour or so.

> POC: Rico LiveGrid
> ------------------
>
>                 Key: OFBIZ-794
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-794
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: New Feature
>            Reporter: Chris Howe
>            Priority: Minor
>         Attachments: rico.jpg, ricowt.patch
>
>
> POC to incorporate Rico LiveGrid into tabular data to create "pageless" result sets

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-794?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chris Howe updated OFBIZ-794:
-----------------------------

    Attachment: LiveGrid.jpg

> POC: Rico LiveGrid
> ------------------
>
>                 Key: OFBIZ-794
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-794
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: New Feature
>            Reporter: Chris Howe
>            Priority: Minor
>         Attachments: LiveGrid.jpg, rico.jpg, ricowt.patch
>
>
> POC to incorporate Rico LiveGrid into tabular data to create "pageless" result sets

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-794?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chris Howe updated OFBIZ-794:
-----------------------------

    Attachment: ricowt.patch

ricowt.patch

Apparently I was trying to use ricowt/images/rico/*.js instead of ricowt/webapp/images/rico/*.js

This should fix it

> POC: Rico LiveGrid
> ------------------
>
>                 Key: OFBIZ-794
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-794
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: New Feature
>            Reporter: Chris Howe
>            Priority: Minor
>         Attachments: LiveGrid.jpg, rico.jpg, ricowt.patch, ricowt.patch
>
>
> POC to incorporate Rico LiveGrid into tabular data to create "pageless" result sets

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-794?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12481542 ]

Jacques Le Roux commented on OFBIZ-794:
---------------------------------------

Ha yes, great !

Some strange behaviours, either on FF, IE and Opera , when you browse up and down (colums dynamically redimensionned I guess,we should be able to fix colums widths to the max used).

So success as a POC IMHO. We should use this instead of the tedious current pagination (unusable in fact because it miss at least page numbers to quickly jump for instance). BTW did you try it with very large set of records ? (Geo is only 676).

> POC: Rico LiveGrid
> ------------------
>
>                 Key: OFBIZ-794
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-794
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: New Feature
>            Reporter: Chris Howe
>            Priority: Minor
>         Attachments: LiveGrid.jpg, rico.jpg, ricowt.patch, ricowt.patch
>
>
> POC to incorporate Rico LiveGrid into tabular data to create "pageless" result sets

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-794?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12481546 ]

Jacques Le Roux commented on OFBIZ-794:
---------------------------------------

Chris,

Another point, are you sure that all lines are there ? Also they do not seem to be sorted ? Ok it's only a POC, just to check ;o)

> POC: Rico LiveGrid
> ------------------
>
>                 Key: OFBIZ-794
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-794
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: New Feature
>            Reporter: Chris Howe
>            Priority: Minor
>         Attachments: LiveGrid.jpg, rico.jpg, ricowt.patch, ricowt.patch
>
>
> POC to incorporate Rico LiveGrid into tabular data to create "pageless" result sets

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-794?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12481619 ]

Chris Howe commented on OFBIZ-794:
----------------------------------

I'll finish up the party manager lookup form this evening which is a much better POC because the underlying service does "LIKE" queries (so you can see the keystroke update, my co-workers have been using it all week and you still hear giggles) and the column widths are known.  

The result set number is hard coded to 100, this number should obviously be returned from the service (which is why you can't scroll all of the records).   A large dataset should only affect the server running the query service as only x number of records are sent to the client at a time and only those x number of records stay with the client (I don't believe they are appended to their resultset), that same issue exists with pagination though.  

I did an interesting use of this with ecommerce where instead of returning columns, I made one return cell and in that cell did a screens.render for the product summary. It's a little buggy but can be corrected with line-height multiples being known.

> POC: Rico LiveGrid
> ------------------
>
>                 Key: OFBIZ-794
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-794
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: New Feature
>            Reporter: Chris Howe
>            Priority: Minor
>         Attachments: LiveGrid.jpg, rico.jpg, ricowt.patch, ricowt.patch
>
>
> POC to incorporate Rico LiveGrid into tabular data to create "pageless" result sets

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-794?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chris Howe updated OFBIZ-794:
-----------------------------

    Attachment: ricowt.patch

ricowt.patch

> POC: Rico LiveGrid
> ------------------
>
>                 Key: OFBIZ-794
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-794
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: New Feature
>            Reporter: Chris Howe
>            Priority: Minor
>         Attachments: LiveGrid.jpg, rico.jpg, ricowt.patch, ricowt.patch, ricowt.patch
>
>
> POC to incorporate Rico LiveGrid into tabular data to create "pageless" result sets

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-794?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chris Howe updated OFBIZ-794:
-----------------------------

    Attachment: ricowt.patch

ricowt.patch                        for some reason my "enter" key isn't working...this is the same basic implementation using LiveGridPlus instead....a couple issues that need to be worked out  1) handle the new query syntax this uses 2) improve the FindGeneric.bsh script to use various operators (like, etc) instead of just equals 3) return the <rowcount> in t he response so the slider knows the proper size of the result set

> POC: Rico LiveGrid
> ------------------
>
>                 Key: OFBIZ-794
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-794
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: New Feature
>            Reporter: Chris Howe
>            Priority: Minor
>         Attachments: LiveGrid.jpg, rico.jpg, ricowt.patch, ricowt.patch, ricowt.patch, ricowt.patch
>
>
> POC to incorporate Rico LiveGrid into tabular data to create "pageless" result sets

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-794?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chris Howe updated OFBIZ-794:
-----------------------------

    Attachment: liveGridPlus.jpg

> POC: Rico LiveGrid
> ------------------
>
>                 Key: OFBIZ-794
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-794
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: New Feature
>            Reporter: Chris Howe
>            Priority: Minor
>         Attachments: LiveGrid.jpg, liveGridPlus.jpg, rico.jpg, ricowt.patch, ricowt.patch, ricowt.patch, ricowt.patch
>
>
> POC to incorporate Rico LiveGrid into tabular data to create "pageless" result sets

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-794?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12483144 ]

Jacques Le Roux commented on OFBIZ-794:
---------------------------------------

Crhis,

I like it, the web begin to look like desktop :o) Is it possible to implement columns sorting ?

> POC: Rico LiveGrid
> ------------------
>
>                 Key: OFBIZ-794
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-794
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: New Feature
>            Reporter: Chris Howe
>            Priority: Minor
>         Attachments: LiveGrid.jpg, liveGridPlus.jpg, rico.jpg, ricowt.patch, ricowt.patch, ricowt.patch, ricowt.patch
>
>
> POC to incorporate Rico LiveGrid into tabular data to create "pageless" result sets

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-794?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12483152 ]

Chris Howe commented on OFBIZ-794:
----------------------------------

I've been playing with this all week, parameterizing everything in the included header.ftl file, etc.  There hasn't been any response on including it in special apps, so I think I'm going to add this to sandbox on sf.net for the benefit of SVN.  

Sorting is controlled by clicking on the search box for the field.  You'll get an up and down arrow.  The ajax controller response needs to handle the sorting parameter names correctly. (it needs to handle all of the parameter names).  Meaning it's an OFBiz issue rather than a javascript issue.  -I like OFBiz issues a lot more than javascript ones :-).

Additionally, if you double click on the cells, you'll get a menu that can be customized to your heart's content.  This is where the "Delete" and Show various relationships might come up.  

After playing around with this, I think you can see where my interest in an ofbiz webapp developer tool comes from.

I'm not sure if you had mentioned it before as well, but Firebug https://addons.mozilla.org/firefox/1843/ is awesome at debugging and understanding the underlying stuff.

> POC: Rico LiveGrid
> ------------------
>
>                 Key: OFBIZ-794
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-794
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: New Feature
>            Reporter: Chris Howe
>            Priority: Minor
>         Attachments: LiveGrid.jpg, liveGridPlus.jpg, rico.jpg, ricowt.patch, ricowt.patch, ricowt.patch, ricowt.patch
>
>
> POC to incorporate Rico LiveGrid into tabular data to create "pageless" result sets

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-794?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12483168 ]

Jacques Le Roux commented on OFBIZ-794:
---------------------------------------

Thans for comments Chris,

Webapp developer tool : just looking at the clarity David S. pdf right now :o)

Firebug : yes I mentionned it, and yes it's really *great* when it comes to debug some javascript, surely mandatory in Ajax's case  !

> POC: Rico LiveGrid
> ------------------
>
>                 Key: OFBIZ-794
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-794
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: New Feature
>            Reporter: Chris Howe
>            Priority: Minor
>         Attachments: LiveGrid.jpg, liveGridPlus.jpg, rico.jpg, ricowt.patch, ricowt.patch, ricowt.patch, ricowt.patch
>
>
> POC to incorporate Rico LiveGrid into tabular data to create "pageless" result sets

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-794?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12483175 ]

Jacques Le Roux commented on OFBIZ-794:
---------------------------------------

Mmm... Clarity CA seems a little bit out of subject, isn'it ?

> POC: Rico LiveGrid
> ------------------
>
>                 Key: OFBIZ-794
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-794
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: New Feature
>            Reporter: Chris Howe
>            Priority: Minor
>         Attachments: LiveGrid.jpg, liveGridPlus.jpg, rico.jpg, ricowt.patch, ricowt.patch, ricowt.patch, ricowt.patch
>
>
> POC to incorporate Rico LiveGrid into tabular data to create "pageless" result sets

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-794?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12483179 ]

Jacques Le Roux commented on OFBIZ-794:
---------------------------------------

Sorry Clarity was not a David S.'s pdf but Christopher Snow...

> POC: Rico LiveGrid
> ------------------
>
>                 Key: OFBIZ-794
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-794
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: New Feature
>            Reporter: Chris Howe
>            Priority: Minor
>         Attachments: LiveGrid.jpg, liveGridPlus.jpg, rico.jpg, ricowt.patch, ricowt.patch, ricowt.patch, ricowt.patch
>
>
> POC to incorporate Rico LiveGrid into tabular data to create "pageless" result sets

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.