Add Dates To Array That Don't Exist In Query Result - Laravel 5

Question

So, I've hit a roadblock. I hope I can explain it well.

I'm creating a custom weekly calendar to display 'tasks' for the given week - Sun to Saturday.

I have the following code which is grabbing all tasks within a specified data range (works as it should).

However, I want to display the 7 panels on my view each representing the day of the week. I'll do this in my @foreach on the view itself (which I haven't tackled yet).

Problem is, if there's only 2 task for the week, say on Sunday and Tuesday, I won't be able to create empty panels on my view for the remaining days of the week that won't have any tasks.

How can I ensure all the week's dates are included in the array - even if they don't have a task assigned to them? Or is there a better way?

In Controller:

$weekly_tasks = Auth::user()->tasks()->withinDateRange($beginning_of_week, $end_of_week)->get();

foreach ($weekly_tasks as $task) {
    $date = new Carbon($task['date']);
    $days[$date->toFormattedDateString()][] = $task;
}

return $days;

Scope on Model:

public function scopeWithinDateRange($query, $start, $end)
{
    return $query->whereBetween('date', [$start->subDays(1), $end]);
}

$days array returns something like this FYI:

{
"Mar 22, 2015": [
    {
        "id": 1,
        "task": "stuff",
        "date": "2015-03-22 23:06:23"
    }
],
"Mar 24, 2015": [
    {
        "id": 2,
        "task": "more stuff",
        "date": "2015-03-22 23:06:23"
    }
],
}

Array should return something like this:

{
"Mar 22, 2015": [
    {
        "id": 1,
        "task": "stuff",
        "date": "2015-03-22 23:06:23"
    }
],
"Mar 23, 2015": [
],
"Mar 24, 2015": [
    {
        "id": 2,
        "task": "more stuff",
        "date": "2015-03-22 23:06:23"
    }
],
"Mar 25, 2015": [
],
"Mar 26, 2015": [
],
"Mar 27, 2015": [
],
"Mar 28, 2015": [
],
}

Soronbe · Accepted Answer · 2015-03-23 04:06:53Z

1

You could initialize the $days array with all the days of the week as keys pointing to empty empty arrays and then append all tasks to the corresponding array.

I have never used Laravel before, but a quick google thought me you can get the Carbon of the start of the week, and add the FormattedDateString as a key. Then get the next day using ->tomorrow() and rinse 'n repeat till you reach the end of the week. There probably is a better method though, so only use this if you're stuck.

EDIT: Assuming ($beginning_of_week, $end_of_week) are Carbon objects:

$days = array();
$iterator = $beginning_of_week;
while ( $iterator->lte($end_of_week)){
    $days[$iterator->toFormattedDateString()] = array();
    $iterator->addDay();
}

This initialises your $days, follow this with your foreach.

edited Mar 23, 2015 at 4:06

answered Mar 23, 2015 at 3:35

Soronbe

9265 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Mike Barwick Over a year ago

Code examples? This is not really an answer...more of a comment. But thanks. Thought of what you said, but can't wrap my head around the code.

Mike Barwick Over a year ago

Just noticed. If I have multiple tasks for the day, only one is showing up in the array? Any ideas?

Soronbe Over a year ago

Normally $days[$date->toFormattedDateString()][] = $task; like you used should work. Alternative is array_push($days[$date->toFormattedDateString()], $task)

Mike Barwick Over a year ago

Sorry...my mistake. Had something muck up with my homestead database. All good! Thanks again!

sayani · Accepted Answer · 2015-03-23 03:49:29Z

0

Define the week array(you should define this array dynamically) and an empty $weekly_tasks_data array. Then looping through that array copy the data to the new array $weekly_tasks_data, if data exists at all.

$week_arr = array("Mar 22, 2015", "Mar 23, 2015", "Mar 24, 2015", "Mar 25, 2015", "Mar 26, 2015", "Mar 27, 2015", "Mar 28, 2015");
$weekly_tasks_data = array();
foreach($week_arr as $k => $v) {
    if(array_key_exists($v, $weekly_tasks))
        $weekly_tasks_data[$v] = $weekly_tasks[$v];
    else
        $weekly_tasks_data[$v] = array();
}

answered Mar 23, 2015 at 3:49

sayani

1488 bronze badges

1 Comment

Mike Barwick Over a year ago

This returns each date, but all with an empty array...?

Collectives™ on Stack Overflow

Add Dates To Array That Don't Exist In Query Result - Laravel 5

2 Answers 2

4 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related