AppGini Community Forums

Posted: **2020-04-20 09:05**

Forgive me if I missed this when searching the forums, but for my current project I have an "Orders" table that AG generates the link for on the homepage and I have chosen to "Show record count in homepage". However, these orders will have a status of "Complete" assigned as they are processed and I would like to filter that count to disregard those orders.

I found this topic (viewtopic.php?f=7&t=3474&hilit=homepage+count+badge) which would allow me to create a custom link and hide the AG generated link, and I may do that if there is not an easier solution to configure the query used to generate the record count. I considered creating a parallel orders table to dump completed orders into but (and I can't remember the issue I encountered) for some reason I abandoned that path. I may be better served to go back and solve whatever that issue was?

Thanks!
Brandon

Posted: **2020-04-20 19:15**

Hi,

I don't think you can "easily" change that.

I see couple options that you may consider:

- as you already saw, create a custom link and remove the original one and possibly rearange the display in the homepage

- replace the badge counter directly via hooks/header-extras.php by checking if you are on the homepage and replace the badge counter with the result of your query

- edit the home.php file and put a dedicated query for your orders table (drawback, this will be overwritten if you recreate your app)

Posted: **2020-04-22 06:13**

Thanks for the reply! Ended up just using the header-extras.php option. Even though there is only one badge and I already have customizations on the homepage think this makes most sense to avoid further modifications to homepage. Please correct me if this should be done differently, but the below worked for my setup:

Code: Select all

<!-- BEGIN adjust orders count on homepage //-->
<?php
$activeOrders = sqlValue("SELECT count(1) FROM orders WHERE status <> 'Complete' AND status <> 'Cancelled'");
?>
<script> 
jQuery(function () {
	$j('#orders-tile').find('.badge').text('<?php echo $activeOrders ?>');
})
</script>
<!-- END adjust orders count on homepage //-->

Brandon

Posted: **2020-04-22 18:29**

Hi,

great to see that you got it working. The solution is fine.

AppGini Community Forums

Configure query for homepage record count badge

Configure query for homepage record count badge

Re: Configure query for homepage record count badge

Re: Configure query for homepage record count badge

Re: Configure query for homepage record count badge