Call Order Date plus 5

[brandonturpin]

This is probably something simple I am overlooking, I have a client that wants to show the order date +5 in the admin. I have found where it calls the order date in the admin in control/orders.php

<td class="dataTableContent" align="center"><?php echo zen_datetime_short($orders->fields['date_purchased']); ?></td>

Now I need to take that date purchased and add 5 days to it. I know this is completely wrong but something like

$ordered_date = zen_datetime_short($orders->fields['date_purchased']);
$ordered_date_plus_five = $ordered_date+5;

I know that is far from correct and I need to pull out the day of the date but just so you get the idea.. then I can call the $ordered_date_plus_five in the loop

Any help would be nice!
Thanks in advance!

[kobra]

order date in the admin in control/orders.php

There is no folder named "control" is a default distribution
Where/what created this?

[swguy]

I think "control" is his renamed admin panel. But remember that this is supposed to be a secret!

[swguy]

@Brandon, Prior to calling zen_datetime_short, you should be adding 5 days to $orders->fields['date_purchased'].

(5 * 24 * 60 * 60 is 5 days in seconds.)

[brandonturpin]

I think "control" is his renamed admin panel. But remember that this is supposed to be a secret!

Ha good thing its just a test environment! :-)

@Brandon, Prior to calling zen_datetime_short, you should be adding 5 days to $orders->fields['date_purchased'].

(5 * 24 * 60 * 60 is 5 days in seconds.)

I am having troubles adding 5 days to the $orders->fields['date_purchased']); any ideas how I would add to this?!?

Thanks in advance for the help! :-)

[brandonturpin]

Got it!!

For those that need to know (although I am not sure if any will)

$order_date_plus_five = zen_datetime_short(date('Y-m-d H:i:s', strtotime($orders->fields['date_purchased']) + 5 * 24 * 3600 ));

[swguy]

Note that another way to do this would be to do it as part of the database query.

SELECT date_add(date_purchased, INTERVAL 5 DAY) AS dayplus5 FROM orders;