Preview
Video Player
00:00
00:00
Totaling Time
3:39Without organizing and filtering the data, it's difficult to even see WHAT you have, let alone make that data useful. We'll write our first report that calculates how much time we've spent on tasks
[MUSIC]
0:00
Imagine walking into
a library full of books.
0:04
Hundreds of thousands of books.
0:08
To those of us who like books,
this is starting to sound pretty great.
0:10
Now imagine that those books
are just randomly placed on shelves.
0:14
What a let down.
0:19
How will you ever find what you're looking
for or even know that they have it?
0:19
The same is true for databases.
0:24
Without organizing and filtering the data,
0:27
it's difficult to even see what you have,
let alone make use of that data.
0:29
Reports allow us to use
that data to write a story.
0:35
A report may describe your site's visitors
and which pages are the most popular.
0:39
Reports can help you forecast inventory
0:44
by telling how many products have been
purchased in the last six months.
0:47
Reports can also give us the information
we need to bill clients for our time.
0:52
In the next few videos,
we'll read data from our database and
0:56
organize that data to create
several different reports.
1:00
We'll start by setting up a table
to display the Task Information and
1:04
summarize the time spent by
including a grand total at the end.
1:08
Let's take a look at the starting point.
1:12
In a browser when we choose Reports,
we see a table with a grand total.
1:15
We need to add the actual grand total and
1:20
the rest of the report
information from our database.
1:23
So let's get started.
1:25
Back in workspaces, open reports.php.
1:27
Let's add opening and closing PHP tags
right after the opening table tag.
1:31
We know we're going to need a total for
the grand total.
1:43
So let's start with a variable
named Total, and set it equal to 0.
1:46
Now we need to loop through each of our
tasks, and add the time to our total.
1:51
We've done this loop before so
it should look familiar.
1:55
foreach (get_task_list() as $item).
1:59
Now we want to $total +=
2:08
$item['time'].
2:13
And finally, we can use that total for
our grand total.
2:18
echo $total.
2:25
Let's view this in the browser again.
2:28
Great, we have a total.
2:32
Now let's show where that total came from.
2:33
Back in our foreach loop,
let's add a new table row.
2:36
Then add cells for the task details.
2:49
Title, date and time.
3:13
Let's go back to the browser and
check this out.
3:17
Now we see a list of all our tasks
along with that grand total.
3:21
This is pretty much just like our
task list page with more details.
3:26
It doesn't give us too much
of an insight into our data.
3:30
In the next few videos,
3:33
we'll organize our data into more
informative and useful reports.
3:35