Does Grouping provides footer total

QuestionsDoes Grouping provides footer total
Jayashri Patil asked 7 years ago

Does Grouping provides footer total as well does it provide facility to add WHERE conditions to query?

11 Answers
Abu Ghufran answered 7 years ago

The grouping feature is somewhat limited in JQGrid (js component from github) as it works with paging.
You need to have high number of records in grid page to work properly.

Footer summary is doable but with some code level changes.

Jayashri Patil answered 7 years ago

So this mean, in grouping we can use sql query with where clause, correct? Also can you please provide code to show Footer summary?
Thanks in Advance

Abu Ghufran answered 7 years ago

Footer summary with grouping is not ready to release. It's still in development.
However another version of footer summary without grouping is available, that shows listing total, sub-total, grand total etc.

Jayashri Patil answered 7 years ago

Ok will wait for release of footer summary with grouping. But still for grouping I am unable to use where condition with dynamic variables. Like for example: "SELECT * FROM table WHERE id=".$id, if we hardcode id then its works but not for dynamic. Please help
Thanks

Abu Ghufran answered 7 years ago

Please check faq question in faq page.
Q) How to load grid based on $_POST data from other page?

Jayashri Patil answered 7 years ago

yes now post values work with version, can you please provide code for
"footer summary without grouping is available, that shows listing total, sub-total, grand total etc."
Thanks

Abu Ghufran answered 7 years ago

I've emailed you the demo.

Jayashri Patil answered 7 years ago

Thanks for demo, but the script doesn't work for me nothing shows in footer, I think JS functions of to set footer Data doesn't work. Please help.
Thanks

Abu Ghufran answered 7 years ago

This is available as a part of paid version.

Here is the link for demo
http://www.phpgrid.org/demo/demos/appearence/footer-row.php

PRANAV BATRA answered 7 years ago

can you please provide code for
"footer summary without grouping is available, that shows listing total, sub-total, grand total etc."
Thanks

Abu Ghufran answered 7 years ago

I've emailed you latest build.

Your Answer

7 + 13 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?