37 -11=>
"Pacific/Midway",
38 -10=>
"Pacific/Fakaofo",
39 -9=>
"America/Anchorage",
40 -8=>
"America/Los_Angeles",
41 -7=>
"America/Dawson_Creek",
42 -6=>
"America/Chicago",
44 -4=>
"America/Anguilla",
45 -3=>
"America/Araguaina",
46 -2=>
"America/Noronha",
47 -1=>
"Atlantic/Azores",
58 10=>
"Australia/Sydney",
60 12=>
"Pacific/Auckland",
61 13=>
"Pacific/Enderbury"
74 return @date_default_timezone_get();
85 if (method_exists(
'DateTimeZone',
'getOffset')) {
91 if ($refgmtdate ==
'now') {
92 $newrefgmtdate = $yearref.
'-'.$monthref.
'-'.$dayref;
93 } elseif ($refgmtdate ==
'summer') {
94 $newrefgmtdate = $yearref.
'-08-01';
96 $newrefgmtdate = $yearref.
'-01-01';
98 $newrefgmtdate .=
'T00:00:00+00:00';
100 $localdt =
new DateTime($newrefgmtdate, $localtz);
101 $tmp = -1 * $localtz->getOffset($localdt);
107 $tz = round(($tmp < 0 ? 1 : -1) * abs($tmp / 3600));
125 if ($duration_unit ==
's') {
126 return $time + ($duration_value);
128 if ($duration_value == 0) {
131 if ($duration_unit ==
'i') {
132 return $time + (60 * $duration_value);
134 if ($duration_unit ==
'h') {
135 return $time + (3600 * $duration_value);
137 if ($duration_unit ==
'w') {
138 return $time + (3600 * 24 * 7 * $duration_value);
143 if ($duration_value > 0) {
144 $deltastring .= abs($duration_value);
147 if ($duration_value < 0) {
148 $deltastring .= abs($duration_value);
151 if ($duration_unit ==
'd') {
154 if ($duration_unit ==
'm') {
157 if ($duration_unit ==
'y') {
161 $date =
new DateTime();
162 if (!empty($conf->global->MAIN_DATE_IN_MEMORY_ARE_GMT)) {
163 $date->setTimezone(
new DateTimeZone(
'UTC'));
165 $date->setTimestamp($time);
166 $interval =
new DateInterval($deltastring);
169 $date->sub($interval);
171 $date->add($interval);
174 if ($ruleforendofmonth == 1 && $duration_unit ==
'm') {
177 $timetotalmonths = (($timeyear * 12) + $timemonth);
179 $monthsexpected = ($timetotalmonths + $duration_value);
181 $newtime = $date->getTimestamp();
185 $newtimetotalmonths = (($newtimeyear * 12) + $newtimemonth);
187 if ($monthsexpected < $newtimetotalmonths) {
192 $datelim =
dol_mktime($newtimehours, $newtimemins, $newtimesecs, $newtimemonth, 1, $newtimeyear);
193 $datelim -= (3600 * 24);
195 $date->setTimestamp($datelim);
198 return $date->getTimestamp();
213 $iResult = ((int) $iHours * 3600) + ((int) $iMinutes * 60) + (int) $iSeconds;
244 if (empty($lengthOfDay)) {
245 $lengthOfDay = 86400;
247 if (empty($lengthOfWeek)) {
250 $nbHbyDay = $lengthOfDay / 3600;
252 if ($format ==
'all' || $format ==
'allwithouthour' || $format ==
'allhour' || $format ==
'allhourmin' || $format ==
'allhourminsec') {
253 if ((
int) $iSecond === 0) {
261 if ($iSecond >= $lengthOfDay) {
262 for ($i = $iSecond; $i >= $lengthOfDay; $i -= $lengthOfDay) {
264 $iSecond -= $lengthOfDay;
266 $dayTranslate = $langs->trans(
"Day");
267 if ($iSecond >= ($lengthOfDay * 2)) {
268 $dayTranslate = $langs->trans(
"Days");
272 if ($lengthOfWeek < 7) {
274 if ($sDay >= $lengthOfWeek) {
275 $sWeek = (int) (($sDay - $sDay % $lengthOfWeek) / $lengthOfWeek);
276 $sDay = $sDay % $lengthOfWeek;
277 $weekTranslate = $langs->trans(
"DurationWeek");
279 $weekTranslate = $langs->trans(
"DurationWeeks");
281 $sTime .= $sWeek.
' '.$weekTranslate.
' ';
286 $dayTranslate = $langs->trans(
"Day");
288 $dayTranslate = $langs->trans(
"Days");
290 $sTime .= $sDay.
' '.$langs->trans(
"d").
' ';
293 if ($format ==
'all') {
294 if ($iSecond || empty($sDay)) {
297 } elseif ($format ==
'allhourminsec') {
298 return sprintf(
"%02d", ($sWeek * $lengthOfWeek * $nbHbyDay + $sDay * $nbHbyDay + (
int) floor($iSecond/3600))).
':'.sprintf(
"%02d", ((
int) floor(($iSecond % 3600) / 60))).
':'.sprintf(
"%02d", ((
int) ($iSecond % 60)));
299 } elseif ($format ==
'allhourmin') {
300 return sprintf(
"%02d", ($sWeek * $lengthOfWeek * $nbHbyDay + $sDay * $nbHbyDay + (
int) floor($iSecond/3600))).
':'.sprintf(
"%02d", ((
int) floor(($iSecond % 3600)/60)));
301 } elseif ($format ==
'allhour') {
302 return sprintf(
"%02d", ($sWeek * $lengthOfWeek * $nbHbyDay + $sDay * $nbHbyDay + (
int) floor($iSecond/3600)));
304 } elseif ($format ==
'hour') {
306 } elseif ($format ==
'fullhour') {
307 if (!empty($iSecond)) {
308 $iSecond = $iSecond / 3600;
313 } elseif ($format ==
'min') {
315 } elseif ($format ==
'sec') {
317 } elseif ($format ==
'month') {
319 } elseif ($format ==
'year') {
336 if ($duration_unit ==
's') $result = $duration_value / 3600;
337 if ($duration_unit ==
'i') $result = $duration_value / 60;
338 if ($duration_unit ==
'h') $result = $duration_value;
339 if ($duration_unit ==
'd') $result = $duration_value * 24;
340 if ($duration_unit ==
'w') $result = $duration_value * 24 * 7;
341 if ($duration_unit ==
'm') $result = $duration_value * 730.484;
342 if ($duration_unit ==
'y') $result = $duration_value * 365 * 24;
360 function dolSqlDateFilter($datefield, $day_date, $month_date, $year_date, $excludefirstand = 0, $gm =
false)
365 $day_date = intval($day_date);
366 $month_date = intval($month_date);
367 $year_date = intval($year_date);
369 if ($month_date > 0) {
370 if ($month_date > 12) {
373 if ($year_date > 0 && empty($day_date)) {
374 $sqldate .= ($excludefirstand ?
"" :
" AND ").$datefield.
" BETWEEN '".$db->idate(
dol_get_first_day($year_date, $month_date, $gm));
375 $sqldate .=
"' AND '".$db->idate(
dol_get_last_day($year_date, $month_date, $gm)).
"'";
376 } elseif ($year_date > 0 && !empty($day_date)) {
377 $sqldate .= ($excludefirstand ?
"" :
" AND ").$datefield.
" BETWEEN '".$db->idate(
dol_mktime(0, 0, 0, $month_date, $day_date, $year_date, $gm));
378 $sqldate .=
"' AND '".$db->idate(
dol_mktime(23, 59, 59, $month_date, $day_date, $year_date, $gm)).
"'";
381 $sqldate .= ($excludefirstand ?
"" :
" AND ").
" date_format( ".$datefield.
", '%c') = '".$db->escape($month_date).
"'";
383 } elseif ($year_date > 0) {
384 $sqldate .= ($excludefirstand ?
"" :
" AND ").$datefield.
" BETWEEN '".$db->idate(
dol_get_first_day($year_date, 1, $gm));
385 $sqldate .=
"' AND '".$db->idate(
dol_get_last_day($year_date, 12, $gm)).
"'";
413 if (preg_match(
'/^([0-9]+)\/([0-9]+)\/([0-9]+)\s?([0-9]+)?:?([0-9]+)?:?([0-9]+)?/i', $string, $reg)) {
414 dol_syslog(
"dol_stringtotime call to function with deprecated parameter format", LOG_WARNING);
426 if ($syear >= 50 && $syear < 100) {
429 $string = sprintf(
"%04d%02d%02d%02d%02d%02d", $syear, $smonth, $sday, $shour, $smin, $ssec);
430 } elseif (preg_match(
'/^([0-9]{4})-([0-9]{2})-([0-9]{2})T([0-9]{2}):([0-9]{2}):([0-9]{2})Z$/i', $string, $reg)
431 || preg_match(
'/^([0-9]{4})-([0-9]{2})-([0-9]{2}) ([0-9]{2}):([0-9]{2}):([0-9]{2})$/i', $string, $reg)
432 || preg_match(
'/^([0-9]{4})([0-9]{2})([0-9]{2})T([0-9]{2})([0-9]{2})([0-9]{2})Z$/i', $string, $reg)
440 $string = sprintf(
"%04d%02d%02d%02d%02d%02d", $syear, $smonth, $sday, $shour, $smin, $ssec);
443 $string = preg_replace(
'/([^0-9])/i',
'', $string);
444 $tmp = $string.
'000000';
448 } elseif (empty($gm) || $gm ===
'tzserver') {
452 $date =
dol_mktime(substr($tmp, 8, 2), substr($tmp, 10, 2), substr($tmp, 12, 2), substr($tmp, 4, 2), substr($tmp, 6, 2), substr($tmp, 0, 4), $gm);
467 $time =
dol_mktime(12, 0, 0, $month, $day, $year, 1, 0);
468 $time -= 24 * 60 * 60;
470 return array(
'year' => $tmparray[
'year'],
'month' => $tmparray[
'mon'],
'day' => $tmparray[
'mday']);
483 $time =
dol_mktime(12, 0, 0, $month, $day, $year, 1, 0);
484 $time += 24 * 60 * 60;
486 return array(
'year' => $tmparray[
'year'],
'month' => $tmparray[
'mon'],
'day' => $tmparray[
'mday']);
500 $prev_year = $year - 1;
502 $prev_month = $month - 1;
505 return array(
'year' => $prev_year,
'month' => $prev_month);
519 $next_year = $year + 1;
521 $next_month = $month + 1;
524 return array(
'year' => $next_year,
'month' => $next_month);
540 $time =
dol_mktime(12, 0, 0, $month, $tmparray[
'first_day'], $year, 1, 0);
541 $time -= 24 * 60 * 60 * 7;
543 return array(
'year' => $tmparray[
'year'],
'month' => $tmparray[
'mon'],
'day' => $tmparray[
'mday']);
559 $time =
dol_mktime(12, 0, 0, $tmparray[
'first_month'], $tmparray[
'first_day'], $tmparray[
'first_year'], 1, 0);
560 $time += 24 * 60 * 60 * 7;
563 return array(
'year' => $tmparray[
'year'],
'month' => $tmparray[
'mon'],
'day' => $tmparray[
'mday']);
582 return dol_mktime(0, 0, 0, $month, 1, $year, $gm);
609 $datelim =
dol_mktime(23, 59, 59, $month, 1, $year, $gm);
610 $datelim -= (3600 * 24);
625 $tmparray =
dol_getdate($date,
false, ($gm ==
'gmt' ?
'gmt' :
''));
626 return dol_mktime(23, 59, 59, $tmparray[
'mon'], $tmparray[
'mday'], $tmparray[
'year'], $gm);
639 $tmparray =
dol_getdate($date,
false, ($gm ==
'gmt' ?
'gmt' :
''));
640 return dol_mktime(0, 0, 0, $tmparray[
'mon'], $tmparray[
'mday'], $tmparray[
'year'], $gm);
657 $date =
dol_mktime(0, 0, 0, $month, $day, $year, $gm);
660 $start_week = (isset($conf->global->MAIN_START_WEEK) ? $conf->global->MAIN_START_WEEK : 1);
665 $days = $start_week - $tmparray[
'wday'];
670 $seconds = $days * 24 * 60 * 60;
674 $tmpdaytms = date($tmparray[0]) - $seconds;
675 $tmpday = date(
"d", $tmpdaytms);
678 if ($tmpday > $day) {
679 $prev_month = $month - 1;
682 if ($prev_month == 0) {
684 $prev_year = $year - 1;
687 $prev_month = $month;
690 $tmpmonth = $prev_month;
691 $tmpyear = $prev_year;
694 $tmptime =
dol_mktime(12, 0, 0, $month, $tmpday, $year, 1, 0);
695 $tmptime -= 24 * 60 * 60 * 7;
697 $prev_day = $tmparray[
'mday'];
700 if ($prev_day > $tmpday) {
701 $prev_month = $month - 1;
704 if ($prev_month == 0) {
706 $prev_year = $year - 1;
710 $week = date(
"W",
dol_mktime(0, 0, 0, $tmpmonth, $tmpday, $tmpyear, $gm));
712 return array(
'year' => $year,
'month' => $month,
'week' => $week,
'first_day' => $tmpday,
'first_month' => $tmpmonth,
'first_year' => $tmpyear,
'prev_year' => $prev_year,
'prev_month' => $prev_month,
'prev_day' => $prev_day);
724 $base =
new DateTime(
"$year-03-21",
new DateTimeZone(
"UTC"));
725 $days = easter_days($year);
726 $tmp = $base->add(
new DateInterval(
"P{$days}D"));
727 return $tmp->getTimestamp();
746 function num_public_holiday($timestampStart, $timestampEnd, $country_code =
'', $lastday = 0, $includesaturday = -1, $includesunday = -1, $includefriday = -1, $includemonday = -1)
748 global $db, $conf, $mysoc;
753 if ((($timestampEnd - $timestampStart) % 86400) != 0) {
754 return 'Error Dates must use same hours and must be GMT dates';
757 if (empty($country_code)) {
758 $country_code = $mysoc->country_code;
760 if ($includemonday < 0) {
761 $includemonday = (isset($conf->global->MAIN_NON_WORKING_DAYS_INCLUDE_MONDAY) ? $conf->global->MAIN_NON_WORKING_DAYS_INCLUDE_MONDAY : 0);
763 if ($includefriday < 0) {
764 $includefriday = (isset($conf->global->MAIN_NON_WORKING_DAYS_INCLUDE_FRIDAY) ? $conf->global->MAIN_NON_WORKING_DAYS_INCLUDE_FRIDAY : 0);
766 if ($includesaturday < 0) {
767 $includesaturday = (isset($conf->global->MAIN_NON_WORKING_DAYS_INCLUDE_SATURDAY) ? $conf->global->MAIN_NON_WORKING_DAYS_INCLUDE_SATURDAY : 1);
769 if ($includesunday < 0) {
770 $includesunday = (isset($conf->global->MAIN_NON_WORKING_DAYS_INCLUDE_SUNDAY) ? $conf->global->MAIN_NON_WORKING_DAYS_INCLUDE_SUNDAY : 1);
773 $country_id =
dol_getIdFromCode($db, $country_code,
'c_country',
'code',
'rowid');
776 while ((($lastday == 0 && $timestampStart < $timestampEnd) || ($lastday && $timestampStart <= $timestampEnd))
779 $specialdayrule = array();
781 $jour = gmdate(
"d", $timestampStart);
782 $mois = gmdate(
"m", $timestampStart);
783 $annee = gmdate(
"Y", $timestampStart);
789 $sql =
"SELECT code, entity, fk_country, dayrule, year, month, day, active";
790 $sql .=
" FROM ".MAIN_DB_PREFIX.
"c_hrm_public_holiday";
791 $sql .=
" WHERE active = 1 and fk_country IN (0".($country_id > 0 ?
", ".$country_id : 0).
")";
792 $sql .=
" AND entity IN (0," .getEntity(
'holiday') .
")";
794 $resql = $db->query(
$sql);
796 $num_rows = $db->num_rows($resql);
798 while ($i < $num_rows) {
799 $obj = $db->fetch_object($resql);
801 if (!empty($obj->dayrule) && $obj->dayrule !=
'date') {
802 $specialdayrule[$obj->dayrule] = $obj->dayrule;
805 if (!empty($obj->year) && $obj->year != $annee) {
808 if ($obj->month != $mois) {
811 if ($obj->day != $jour) {
824 return 'Error sql '.$db->lasterror();
831 if (in_array(
'easter', $specialdayrule)) {
834 $jour_paques = gmdate(
"d", $date_paques);
835 $mois_paques = gmdate(
"m", $date_paques);
836 if ($jour_paques == $jour && $mois_paques == $mois) {
842 if (in_array(
'eastermonday', $specialdayrule)) {
846 $date_lundi_paques = $date_paques + (3600 * 24);
847 $jour_lundi_paques = gmdate(
"d", $date_lundi_paques);
848 $mois_lundi_paques = gmdate(
"m", $date_lundi_paques);
849 if ($jour_lundi_paques == $jour && $mois_lundi_paques == $mois) {
857 if (in_array(
'goodfriday', $specialdayrule)) {
862 $date_good_friday = $easter - (2 * 3600 * 24);
863 $dom_good_friday = gmdate(
"d", $date_good_friday);
864 $month_good_friday = gmdate(
"m", $date_good_friday);
866 if ($dom_good_friday == $jour && $month_good_friday == $mois) {
871 if (in_array(
'ascension', $specialdayrule)) {
874 $date_ascension = $date_paques + (3600 * 24 * 39);
875 $jour_ascension = gmdate(
"d", $date_ascension);
876 $mois_ascension = gmdate(
"m", $date_ascension);
877 if ($jour_ascension == $jour && $mois_ascension == $mois) {
883 if (in_array(
'pentecote', $specialdayrule)) {
886 $date_pentecote = $date_paques + (3600 * 24 * 49);
887 $jour_pentecote = gmdate(
"d", $date_pentecote);
888 $mois_pentecote = gmdate(
"m", $date_pentecote);
889 if ($jour_pentecote == $jour && $mois_pentecote == $mois) {
894 if (in_array(
'pentecotemonday', $specialdayrule)) {
897 $date_pentecote = $date_paques + (3600 * 24 * 50);
898 $jour_pentecote = gmdate(
"d", $date_pentecote);
899 $mois_pentecote = gmdate(
"m", $date_pentecote);
900 if ($jour_pentecote == $jour && $mois_pentecote == $mois) {
906 if (in_array(
'viernessanto', $specialdayrule)) {
909 $date_viernes = $date_paques - (3600 * 24 * 2);
910 $jour_viernes = gmdate(
"d", $date_viernes);
911 $mois_viernes = gmdate(
"m", $date_viernes);
912 if ($jour_viernes == $jour && $mois_viernes == $mois) {
918 if (in_array(
'fronleichnam', $specialdayrule)) {
921 $date_fronleichnam = $date_paques + (3600 * 24 * 60);
922 $jour_fronleichnam = gmdate(
"d", $date_fronleichnam);
923 $mois_fronleichnam = gmdate(
"m", $date_fronleichnam);
924 if ($jour_fronleichnam == $jour && $mois_fronleichnam == $mois) {
930 if (in_array(
'genevafast', $specialdayrule)) {
932 $date_1sunsept = strtotime(
'next thursday', strtotime(
'next sunday', mktime(0, 0, 0, 9, 1, $annee)));
933 $jour_1sunsept = date(
"d", $date_1sunsept);
934 $mois_1sunsept = date(
"m", $date_1sunsept);
935 if ($jour_1sunsept == $jour && $mois_1sunsept == $mois) $ferie=
true;
943 if ($includefriday || $includesaturday || $includesunday) {
944 $jour_julien = unixtojd($timestampStart);
945 $jour_semaine = jddayofweek($jour_julien, 0);
946 if ($includefriday) {
947 if ($jour_semaine == 5) {
951 if ($includesaturday) {
952 if ($jour_semaine == 6) {
956 if ($includesunday) {
957 if ($jour_semaine == 0) {
993 if ($timestampStart < $timestampEnd) {
999 $nbjours = (int) floor(($timestampEnd - $timestampStart) / (60 * 60 * 24)) + 1 - $bit;
1017 function num_open_day($timestampStart, $timestampEnd, $inhour = 0, $lastday = 0, $halfday = 0, $country_code =
'')
1019 global $langs, $mysoc;
1021 if (empty($country_code)) {
1022 $country_code = $mysoc->country_code;
1025 dol_syslog(
'num_open_day timestampStart='.$timestampStart.
' timestampEnd='.$timestampEnd.
' bit='.$lastday.
' country_code='.$country_code);
1028 if (!is_int($timestampStart) && !is_float($timestampStart)) {
1029 return 'ErrorBadParameter_num_open_day';
1031 if (!is_int($timestampEnd) && !is_float($timestampEnd)) {
1032 return 'ErrorBadParameter_num_open_day';
1036 if ($timestampStart < $timestampEnd) {
1039 $numholidays =
num_public_holiday($timestampStart, $timestampEnd, $country_code, $lastday);
1040 $nbOpenDay = ($numdays - $numholidays);
1041 if ($inhour == 1 && $nbOpenDay <= 3) {
1042 $nbOpenDay = ($nbOpenDay * 24);
1044 return $nbOpenDay - (($inhour == 1 ? 12 : 0.5) * abs($halfday));
1045 } elseif ($timestampStart == $timestampEnd) {
1048 $numholidays =
num_public_holiday($timestampStart, $timestampEnd, $country_code, $lastday);
1049 if ($numholidays == 1) {
1054 $nbOpenDay = $lastday;
1057 $nbOpenDay = ($nbOpenDay * 24);
1059 return $nbOpenDay - (($inhour == 1 ? 12 : 0.5) * abs($halfday));
1061 return $langs->trans(
"Error");
1077 $montharray = array(
1078 1 => $outputlangs->trans(
"Month01"),
1079 2 => $outputlangs->trans(
"Month02"),
1080 3 => $outputlangs->trans(
"Month03"),
1081 4 => $outputlangs->trans(
"Month04"),
1082 5 => $outputlangs->trans(
"Month05"),
1083 6 => $outputlangs->trans(
"Month06"),
1084 7 => $outputlangs->trans(
"Month07"),
1085 8 => $outputlangs->trans(
"Month08"),
1086 9 => $outputlangs->trans(
"Month09"),
1087 10 => $outputlangs->trans(
"Month10"),
1088 11 => $outputlangs->trans(
"Month11"),
1089 12 => $outputlangs->trans(
"Month12")
1092 if (!empty($short)) {
1093 $montharray = array(
1094 1 => $outputlangs->trans(
"MonthShort01"),
1095 2 => $outputlangs->trans(
"MonthShort02"),
1096 3 => $outputlangs->trans(
"MonthShort03"),
1097 4 => $outputlangs->trans(
"MonthShort04"),
1098 5 => $outputlangs->trans(
"MonthShort05"),
1099 6 => $outputlangs->trans(
"MonthShort06"),
1100 7 => $outputlangs->trans(
"MonthShort07"),
1101 8 => $outputlangs->trans(
"MonthShort08"),
1102 9 => $outputlangs->trans(
"MonthShort09"),
1103 10 => $outputlangs->trans(
"MonthShort10"),
1104 11 => $outputlangs->trans(
"MonthShort11"),
1105 12 => $outputlangs->trans(
"MonthShort12")
1120 $nb_days = cal_days_in_month(CAL_GREGORIAN, $month, $year);
1122 for ($day = 1; $day < $nb_days; $day++) {
1124 $TWeek[$week_number] = $week_number;
1137 $TFirstDayOfWeek = array();
1138 foreach ($TWeek as $weekNb) {
1139 if (in_array(
'01', $TWeek) && in_array(
'52', $TWeek) && $weekNb ==
'01') {
1142 $TFirstDayOfWeek[$weekNb] = date(
'd', strtotime($year.
'W'.$weekNb));
1144 return $TFirstDayOfWeek;
1155 $TLastDayOfWeek = array();
1156 foreach ($TWeek as $weekNb) {
1157 $TLastDayOfWeek[$weekNb] = date(
'd', strtotime($year.
'W'.$weekNb.
'+6 days'));
1159 return $TLastDayOfWeek;
1171 $date =
new DateTime($year.
'-'.$month.
'-'.$day);
1172 $week = $date->format(
"W");
if(isModEnabled('facture') && $user->hasRight('facture', 'lire')) if((isModEnabled('fournisseur') &&empty($conf->global->MAIN_USE_NEW_SUPPLIERMOD) && $user->hasRight("fournisseur", "facture", "lire"))||(isModEnabled('supplier_invoice') && $user->hasRight("supplier_invoice", "lire"))) if(isModEnabled('don') && $user->hasRight('don', 'lire')) if(isModEnabled('tax') &&!empty($user->rights->tax->charges->lire)) if(isModEnabled('facture') &&isModEnabled('commande') && $user->hasRight("commande", "lire") &&empty($conf->global->WORKFLOW_DISABLE_CREATE_INVOICE_FROM_ORDER)) $sql
Social contributions to pay.
dol_get_prev_month($month, $year)
Return previous month.
dol_get_first_hour($date, $gm='tzserver')
Return GMT time for first hour of a given GMT date (it removes hours, min and second part)
dol_get_next_day($day, $month, $year)
Return next day.
dol_get_next_week($day, $week, $month, $year)
Return next week.
dolSqlDateFilter($datefield, $day_date, $month_date, $year_date, $excludefirstand=0, $gm=false)
Generate a SQL string to make a filter into a range (for second of date until last second of date).
getServerTimeZoneString()
Return server timezone string.
dol_get_last_hour($date, $gm='tzserver')
Return GMT time for last hour of a given GMT date (it replaces hours, min and second part to 23:59:59...
getLastDayOfEachWeek($TWeek, $year)
Return array of last day of weeks.
getWeekNumbersOfMonth($month, $year)
Return array of week numbers.
getServerTimeZoneInt($refgmtdate='now')
Return server timezone int.
dol_get_first_day_week($day, $month, $year, $gm=false)
Return first day of week for a date.
getGMTEasterDatetime($year)
Return the easter day in GMT time.
convertDurationtoHour($duration_value, $duration_unit)
Convert duration to hour.
get_tz_array()
Return an array with timezone values.
dol_get_prev_day($day, $month, $year)
Return previous day.
dol_get_first_day($year, $month=1, $gm=false)
Return GMT time for first day of a month or year.
getFirstDayOfEachWeek($TWeek, $year)
Return array of first day of weeks.
dol_get_next_month($month, $year)
Return next month.
getWeekNumber($day, $month, $year)
Return week number.
num_between_day($timestampStart, $timestampEnd, $lastday=0)
Function to return number of days between two dates (date must be UTC date !) Example: 2012-01-01 201...
convertTime2Seconds($iHours=0, $iMinutes=0, $iSeconds=0)
Convert hours and minutes into seconds.
num_open_day($timestampStart, $timestampEnd, $inhour=0, $lastday=0, $halfday=0, $country_code='')
Function to return number of working days (and text of units) between two dates (working days)
dol_time_plus_duree($time, $duration_value, $duration_unit, $ruleforendofmonth=0)
Add a delay to a date.
convertSecondToTime($iSecond, $format='all', $lengthOfDay=86400, $lengthOfWeek=7)
Return, in clear text, value of a number of seconds in days, hours and minutes.
dol_get_prev_week($day, $week, $month, $year)
Return previous week.
dol_stringtotime($string, $gm=1)
Convert a string date into a GM Timestamps date Warning: YYYY-MM-DDTHH:MM:SS+02:00 (RFC3339) is not s...
dol_get_last_day($year, $month=12, $gm=false)
Return GMT time for last day of a month or year.
monthArray($outputlangs, $short=0)
Return array of translated months or selected month.
num_public_holiday($timestampStart, $timestampEnd, $country_code='', $lastday=0, $includesaturday=-1, $includesunday=-1, $includefriday=-1, $includemonday=-1)
Return the number of non working days including Friday, Saturday and Sunday (or not) between 2 dates ...
dol_mktime($hour, $minute, $second, $month, $day, $year, $gm='auto', $check=1)
Return a timestamp date built from detailed informations (by default a local PHP server timestamp) Re...
dol_print_error($db='', $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs='', $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
dol_now($mode='auto')
Return date for now.
dol_getIdFromCode($db, $key, $tablename, $fieldkey='code', $fieldid='id', $entityfilter=0, $filters='')
Return an id or code from a code or id.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
dol_getdate($timestamp, $fast=false, $forcetimezone='')
Return an array with locale date info.