SUM of total items on filtered days

Got something cool to share with AppGini users? Feel free to post it here!
Post Reply
chrisp
Posts: 3
Joined: 2016-04-26 10:51

SUM of total items on filtered days

Post by chrisp » 2016-04-26 12:17

Hi

New to all this, but loving getting stuck in.

I need to filter results of items to be delivered on a particular day. On a Monday for example, a table would show me all the items I need; 125 x item1, 200 x item2 etc.

The items would be pulled from the 'customer_data' table, 'monday_order' fields. There are around 15 items, so a field for each is needed.

I can do this in Excel, but a bit unsure with php/mysql. I can make the fields, but the count/sum function, and populating the fields with the results is where I struggle.

I just need pointing in the right direction, so any help is appreciated. Please bear in mind I am not a master of coding.

Many thanks in advance.

AhmedBR
AppGini Super Hero
AppGini Super Hero
Posts: 327
Joined: 2013-09-19 10:23

Re: SUM of total items on filtered days

Post by AhmedBR » 2016-04-28 03:01

There is no programing needed, just type the date and hit enter in table view of customer_data' table
AppGini will filter the result based on that.

You can also follow this tutorial:
https://bigprof.com/appgini/tips-and-tu ... ers/part-1

For the calculating part check this tutorial:
http://bigprof.com/appgini/tips-and-tut ... eld-values

And if it is something like invoice, check the project invoice:
https://bigprof.com/appgini/download-sample-projects
AppGini 22.14 - xampp 3.3.0 - PHP 7.4.30 - Summary reports - Calendar - Mass update - Messages - AppGiniHelper

Post Reply