[CORE-295] Recurring invoice daylight savings time anomaly - Blesta

Details

Type: Bug
Status: Closed
Priority: Minor
Resolution: Fixed
Affects Version/s: 3.0.0.a5
Fix Version/s: 4.1.2, 4.2.0-b1
Component/s: None
Labels:
None

Description

When the invoice days before renewal option, and the renew date window overlaps with a daylight savings time change odd behavior is seen.

In the case of a daily invoice, the invoice skips a day and is then be billed twice on the subsequent day. This pattern repeats until the time change occurs. It appears to generate the correct number of invoices overall, but not on the proper day. Once daylight savings actually rolls over, billing returns to normal. This was observed on March 10, 2013 when the clocks were changed forward 1 hour.

This may also occur with recurring services, though it was not observed.

The effect of this should be less substantial in most cases, as with monthly invoices an invoice may just be generated 1 day late during this window. It's an issue that needs to be resolved, but we did not find a solution at this time.

Activity

Ascending order - Click to sort in descending order

Paul Phillips created issue - 13/Mar/13 12:21 PM

Cody Phillips (Inactive) made changes - 23/Apr/13 11:53 AM

Field	Original Value	New Value
Fix Version/s		3.0.0.b1 [ 10102 ]

Paul Phillips made changes - 14/May/13 5:29 PM

Fix Version/s		3.0.0.b2 [ 10206 ]
Fix Version/s	3.0.0.b1 [ 10102 ]

Paul Phillips made changes - 23/May/13 2:19 PM

Fix Version/s		3.0.0.b3 [ 10207 ]
Fix Version/s	3.0.0.b2 [ 10206 ]

Paul Phillips made changes - 30/May/13 6:46 PM

Fix Version/s		3.0.0.b4 [ 10208 ]
Fix Version/s	3.0.0.b3 [ 10207 ]

Paul Phillips made changes - 14/Jun/13 6:09 PM

Fix Version/s		3.0.0.b5 [ 10209 ]
Fix Version/s	3.0.0.b4 [ 10208 ]

Paul Phillips made changes - 03/Jul/13 6:39 PM

Fix Version/s		3.0.0.b6 [ 10210 ]
Fix Version/s	3.0.0.b5 [ 10209 ]

Paul Phillips made changes - 19/Jul/13 7:07 PM

Fix Version/s		3.0.0.b7 [ 10211 ]
Fix Version/s	3.0.0.b6 [ 10210 ]

Paul Phillips made changes - 02/Aug/13 6:38 PM

Fix Version/s		3.0.0 [ 10000 ]
Fix Version/s	3.0.0.b7 [ 10211 ]

Paul Phillips made changes - 14/Aug/13 11:59 AM

Fix Version/s		3.0.1 [ 10212 ]
Fix Version/s	3.0.0 [ 10000 ]

Paul Phillips made changes - 21/Aug/13 6:46 PM

Fix Version/s		3.0.2 [ 10213 ]
Fix Version/s	3.0.1 [ 10212 ]

Paul Phillips made changes - 03/Sep/13 4:15 PM

Fix Version/s		3.0.3 [ 10214 ]
Fix Version/s	3.0.2 [ 10213 ]

Paul Phillips made changes - 18/Sep/13 3:31 PM

Fix Version/s		3.0.4 [ 10215 ]
Fix Version/s	3.0.3 [ 10214 ]

Paul Phillips made changes - 07/Oct/13 6:33 PM

Fix Version/s		3.0.5 [ 10300 ]
Fix Version/s	3.0.4 [ 10215 ]

Paul Phillips made changes - 24/Oct/13 4:17 PM

Fix Version/s		3.0.6 [ 10301 ]
Fix Version/s	3.0.5 [ 10300 ]

Paul Phillips made changes - 13/Nov/13 6:27 PM

Fix Version/s		3.0.7 [ 10302 ]
Fix Version/s	3.0.6 [ 10301 ]

Paul Phillips made changes - 20/Dec/13 3:45 PM

Fix Version/s		3.0.8 [ 10304 ]
Fix Version/s	3.0.7 [ 10302 ]

Paul Phillips made changes - 16/Jan/14 2:19 PM

Fix Version/s		3.1.1 [ 10306 ]
Fix Version/s	3.0.8 [ 10304 ]

Paul Phillips made changes - 12/Feb/14 3:50 PM

Fix Version/s		3.1.2 [ 10403 ]
Fix Version/s	3.1.1 [ 10306 ]

Paul Phillips made changes - 26/Feb/14 5:04 PM

Fix Version/s		3.1.3 [ 10405 ]
Fix Version/s	3.1.2 [ 10403 ]

Paul Phillips made changes - 27/Mar/14 11:31 AM

Fix Version/s		3.1.4 [ 10500 ]
Fix Version/s	3.1.3 [ 10405 ]

Paul Phillips made changes - 14/May/14 1:09 PM

Fix Version/s		3.2.1 [ 10504 ]
Fix Version/s	3.1.4 [ 10500 ]

Paul Phillips made changes - 25/Jun/14 7:08 PM

Fix Version/s		3.2.2 [ 10505 ]
Fix Version/s	3.2.1 [ 10504 ]

Paul Phillips made changes - 30/Jul/14 5:25 PM

Fix Version/s		3.2.3 [ 10506 ]
Fix Version/s	3.2.2 [ 10505 ]

Paul Phillips made changes - 06/Oct/14 5:37 PM

Fix Version/s		3.3.0 [ 10508 ]
Fix Version/s	3.2.3 [ 10506 ]

Tyson Phillips (Inactive) made changes - 21/Oct/14 7:08 PM

Fix Version/s		3.3.2 [ 10602 ]
Fix Version/s	3.3.0 [ 10508 ]

Paul Phillips made changes - 11/Nov/14 2:09 PM

Fix Version/s		3.3.3 [ 10604 ]
Fix Version/s	3.3.2 [ 10602 ]

Cody Phillips (Inactive) made changes - 26/Jan/15 6:42 PM

Fix Version/s

3.3.3 [ 10604 ]

Cody Phillips (Inactive) made changes - 23/Mar/15 11:16 AM

Rank

Ranked higher

Cody Phillips (Inactive) made changes - 13/May/15 11:37 AM

Rank

Ranked higher

Cody Phillips (Inactive) made changes - 13/May/15 11:38 AM

Rank

Ranked lower

Tyson Phillips (Inactive) made changes - 30/Aug/17 7:06 PM

Assignee

Cody Phillips [ cody ]

Jonathan Reissmueller [ jonathan ]

Hide

Permalink

Tyson Phillips (Inactive) added a comment - 30/Aug/17 7:08 PM

This probably can be resolved with the Date helper since it's been updated to use the DateTime library, and can better set future dates in the given timezone to avoid it being off an hour when it crosses one of the daylight savings days. Of course, the issue will need to be replicated first to be sure it hasn't already been resolved.

Show

Tyson Phillips (Inactive) added a comment - 30/Aug/17 7:08 PM This probably can be resolved with the Date helper since it's been updated to use the DateTime library, and can better set future dates in the given timezone to avoid it being off an hour when it crosses one of the daylight savings days. Of course, the issue will need to be replicated first to be sure it hasn't already been resolved.

Tyson Phillips (Inactive) made changes - 30/Aug/17 7:08 PM

Fix Version/s		4.1.1 [ 11015 ]
Fix Version/s		4.2.0-b1 [ 11014 ]

Tyson Phillips (Inactive) made changes - 30/Aug/17 7:36 PM

Sprint

4.2.0 Sprint 1 [ 44 ]

Tyson Phillips (Inactive) made changes - 30/Aug/17 7:36 PM

Rank

Ranked higher

Automated transition triggered when Jonathan Reissmueller created a branch in Stash - 01/Sep/17 3:42 PM

Status

Open [ 1 ]

In Progress [ 3 ]

Jonathan Reissmueller made changes - 01/Sep/17 3:50 PM

Remaining Estimate		0 minutes [ 0 ]
Time Spent		2 hours, 48 minutes [ 10080 ]
Worklog Id	10215 [ 10215 ]

Automated transition triggered when Jonathan Reissmueller created pull request #311 in Stash - 01/Sep/17 3:55 PM

Status	In Progress [ 3 ]	In Review [ 5 ]
Resolution		Fixed [ 1 ]

Jonathan Reissmueller made changes - 01/Sep/17 4:17 PM

Rank

Ranked higher

Jonathan Reissmueller made changes - 13/Sep/17 12:18 PM

Time Spent	2 hours, 48 minutes [ 10080 ]	3 hours, 31 minutes [ 12660 ]
Worklog Id	10250 [ 10250 ]

Tyson Phillips (Inactive) made changes - 13/Sep/17 7:35 PM

Time Spent	3 hours, 31 minutes [ 12660 ]	3 hours, 57 minutes [ 14220 ]
Worklog Id	10256 [ 10256 ]

Jonathan Reissmueller made changes - 14/Sep/17 1:44 PM

Time Spent	3 hours, 57 minutes [ 14220 ]	5 hours, 9 minutes [ 18540 ]
Worklog Id	10257 [ 10257 ]

Tyson Phillips (Inactive) made changes - 15/Sep/17 7:33 PM

Time Spent	5 hours, 9 minutes [ 18540 ]	5 hours, 51 minutes [ 21060 ]
Worklog Id	10270 [ 10270 ]

Tyson Phillips (Inactive) made changes - 18/Sep/17 7:39 PM

Time Spent	5 hours, 51 minutes [ 21060 ]	1 day, 47 minutes [ 31620 ]
Worklog Id	10271 [ 10271 ]

Tyson Phillips (Inactive) made changes - 19/Sep/17 3:35 PM

Time Spent	1 day, 47 minutes [ 31620 ]	1 day, 3 hours, 7 minutes [ 40020 ]
Worklog Id	10272 [ 10272 ]

Tyson Phillips (Inactive) made changes - 19/Sep/17 6:36 PM

Time Spent	1 day, 3 hours, 7 minutes [ 40020 ]	1 day, 6 hours, 7 minutes [ 50820 ]
Worklog Id	10273 [ 10273 ]

Tyson Phillips (Inactive) made changes - 19/Sep/17 7:40 PM

Time Spent	1 day, 6 hours, 7 minutes [ 50820 ]	1 day, 6 hours, 48 minutes [ 53280 ]
Worklog Id	10275 [ 10275 ]

Tyson Phillips (Inactive) made changes - 22/Sep/17 6:28 PM

Sprint

4.1.1 Sprint 1 [ 44 ]

4.2.0 Sprint 1 [ 46 ]

Tyson Phillips (Inactive) made changes - 22/Sep/17 6:28 PM

Fix Version/s

4.1.1 [ 11015 ]

Tyson Phillips (Inactive) made changes - 27/Sep/17 5:44 PM

Rank

Ranked higher

Tyson Phillips (Inactive) made changes - 29/Sep/17 3:53 PM

Fix Version/s

4.1.2 [ 11016 ]

Tyson Phillips (Inactive) made changes - 18/Oct/17 1:16 PM

Time Spent	1 day, 6 hours, 48 minutes [ 53280 ]	1 day, 7 hours, 14 minutes [ 54840 ]
Worklog Id	10325 [ 10325 ]

Tyson Phillips (Inactive) made changes - 18/Oct/17 1:56 PM

Sprint

4.2.0 Sprint 1 [ 46 ]

4.2.0 Sprint 1, 4.2.0 Sprint 2 [ 46, 47 ]

Tyson Phillips (Inactive) made changes - 18/Oct/17 1:57 PM

Rank

Ranked higher

Jonathan Reissmueller made changes - 18/Oct/17 2:51 PM

Time Spent	1 day, 7 hours, 14 minutes [ 54840 ]	2 days, 15 minutes [ 58500 ]
Worklog Id	10331 [ 10331 ]

Jonathan Reissmueller made changes - 18/Oct/17 4:07 PM

Time Spent	2 days, 15 minutes [ 58500 ]	2 days, 45 minutes [ 60300 ]
Worklog Id	10331 [ 10331 ]

Automated transition triggered when Tyson Phillips (Inactive) merged pull request #311 in Stash - 20/Oct/17 12:15 PM

Status

In Review [ 5 ]

Closed [ 6 ]

Jonathan Reissmueller made changes - 25/Oct/17 11:47 AM

Resolution	Fixed [ 1 ]
Status	Closed [ 6 ]	Reopened [ 4 ]

Jonathan Reissmueller made changes - 25/Oct/17 11:47 AM

Original Estimate		0 minutes [ 0 ]
Security	Private [ 10000 ]

Jonathan Reissmueller made changes - 25/Oct/17 11:47 AM

Status	Reopened [ 4 ]	Closed [ 6 ]
Resolution		Fixed [ 1 ]

People

Assignee:

Jonathan Reissmueller

Reporter:

Paul Phillips

Votes:

0 Vote for this issue

Watchers:

2 Start watching this issue

Dates

Created:

13/Mar/13 12:21 PM

Updated:

25/Oct/17 11:47 AM

Resolved:

25/Oct/17 11:47 AM

Fix Release Date:

25/Oct/17

Time Tracking

Estimated:

Remaining:

Logged:

2d 45m

Agile

Completed Sprints:

4.2.0 Sprint 1 ended 18/Oct/17
4.2.0 Sprint 2 ended 03/Nov/17
View on Board