Re: [Dolibarr-dev] Question and bug about num_between_day in date.lib.php

[[Kreiz IT] Cédric GROSS]

Php directly :
$dte=date_create("@$timestampStart");
$day1=date_format($dte,'d/m/Y H:i:s');
Echo "$day1\n";

You will notice that we go to summer time on 30/03/2014 ;)

Hum surely something with time zone. In France we have 1 hour from UTC in
winter and 2 hour from UTC in summer time.
May be here is the clue.

Cedric

-----Message d'origine-----
De : address@hidden
[mailto:address@hidden De la part de
Florian Henry
Envoyé : mercredi 5 mars 2014 14:14
À : Posts about Dolibarr ERP & CRM development and coding
Objet : Re: [Dolibarr-dev] Question and bug about num_between_day in
date.lib.php

How do you find the value ?

1395961200 = 27/03/2014 23:00:00
And
1396216800 = 30/03/2014 22:00:00



if I do more debug with a dol_print_date($xxx,'dayhour') I've got this :

$timestampStart=1395961200
dol_print_date($timestampStart,'dayhour')=28/03/2014 00:00

$timestampEnd=1396216800
dol_print_date($timestampEnd,'dayhour')=31/03/2014 00:00


Regards

Florian HENRY
address@hidden there a matter around the tmz or gmt
parameters ?
+33 6 03 76 48 07
http://www.open-concept.pro
Twitter : @_Open_Concept_

Le 05/03/2014 13:43, [Kreiz IT]Cédric GROSS a écrit :
> Hello Henry,
>
> I just check your timestamp and I get :
> 1395961200 = 27/03/2014 23:00:00
> And
> 1396216800 = 30/03/2014 22:00:00
>
> So result is quite good (3 days and 23h) may be you should strip hour 
> from your timestamp if you wish only "day" difference.
>
> Cedric
>
> -----Message d'origine-----
> De : address@hidden
> [mailto:address@hidden De la 
> part de Florian Henry Envoyé : mercredi 5 mars 2014 12:22 À : ML 
> Dolibarr Dev Objet : [Dolibarr-dev] Question and bug about 
> num_between_day in date.lib.php
>
> Hi all,
>
>       I've got a problem into Holiday module, but also can give some 
> strange result to other part of code that use function num_between_day 
> of date.lib.php
>
>       My case :
>           Find number of day betwenn 21-March-2014 and 24-March-2014 
> Result is 4 => OK (Friday,Saturday,Sunday,Monday)
>           Find number of day betwenn 28-March-2014 and 31-March-2014 
> Result is 3 => KO. (Friday,Saturday,Sunday,Monday)
>
>       If I look into code of this function we have a basic timestamp 
> substraction, that should give a good result, but in fact not. Is it 
> the only case ? I don't know.
>
>       I put some trace and there is the result :
>
>               21-24 :
>                   $timestampStart=1395356400
>                   $timestampEnd  =1395615600
>                   $bit=0
>                   ($timestampEnd - $timestampStart)/(60*60*24) +1 - $bits
= 4
>                   floor(4) = 4
>
>               28-31 :
>                   $timestampStart=1395961200
>                   $timestampEnd  =1396216800
>                   $bit=0
>                   ($timestampEnd - $timestampStart)/(60*60*24) + 1 - 
> $bits =
> 3.9583333333333
>                   floor(3.9583333333333) = 3
>
>
>               As we do a floor on this ($timestampEnd -
> $timestampStart)/(60*60*24) the second result is KO
>
>       If I use the DateTime php object method the result is correct. 
> But this core php object exists only for php version 5.3 and more. So 
> more than the minimum version 5.2.1 describe into the wiki.
>
>       As patch for now I use round instead of floor but all php code 
> line I can found on internet use floor for this type of calculation, 
> so what is the good option ?
>
>       I've create a bug into DoliForge :
> https://doliforge.org/tracker/?func=detail&aid=1287&atid=246&group_id=144
>       but still do not have a clue about why the strong calculation 
> rule do not work in this specifics case.
>
> Regards
>


_______________________________________________
Dolibarr-dev mailing list
address@hidden
https://lists.nongnu.org/mailman/listinfo/dolibarr-dev