X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=includes%2Fdate_functions.inc;h=f80bb2713e2564ef1597cf5d7818ea03ffbb4fa7;hb=268a54dcfd08aff7113bc3afe8b784f36db2d0d4;hp=64fdfab4b8a28012f9a61e48d5207439e1df85ff;hpb=46c5f7a65a7659a44ae8254c63152074363d3987;p=fa-stable.git diff --git a/includes/date_functions.inc b/includes/date_functions.inc index 64fdfab4..f80bb271 100644 --- a/includes/date_functions.inc +++ b/includes/date_functions.inc @@ -18,80 +18,113 @@ this can be a string either "d/m/Y" for UK/Australia/New Zealand dates or "m/d/Y" for US/Canada format dates depending on setting in preferences. */ -if(function_exists("date_default_timezone_set") && function_exists("date_default_timezone_get")) - @date_default_timezone_set(@date_default_timezone_get()); function __date($year, $month, $day) { - global $dateseps; + global $SysPrefs, $tmonths; $how = user_date_format(); - $sep = $dateseps[user_date_sep()]; + $sep = $SysPrefs->dateseps[user_date_sep()]; $day = (int)$day; $month = (int)$month; - if ($day < 10) - $day = "0".$day; - if ($month < 10) - $month = "0".$month; + if ($how < 3) + { + if ($day < 10) + $day = "0".$day; + if ($month < 10) + $month = "0".$month; + } if ($how == 0) return $month.$sep.$day.$sep.$year; elseif ($how == 1) return $day.$sep.$month.$sep.$year; - else + elseif ($how == 2) return $year.$sep.$month.$sep.$day; + elseif ($how == 3) + return $tmonths[$month].$sep.$day.$sep.$year; + elseif ($how == 4) + return $day.$sep.$tmonths[$month].$sep.$year; + else + return $year.$sep.$tmonths[$month].$sep.$day; } function is_date($date_) { - global $dateseps; + global $SysPrefs; if ($date_ == null || $date_ == "") return 0; $how = user_date_format(); - $sep = $dateseps[user_date_sep()]; + $sep = $SysPrefs->dateseps[user_date_sep()]; $date_ = trim($date_); - $date_ = str_replace($sep, "", $date_); - if (strlen($date_) == 6) + $date = str_replace($sep, "", $date_); + + if ($how > 2) + { + global $tmonths; + $dd = explode($sep, $date_); + if ($how == 3) + { + $day = $dd[1]; + $month = array_search($dd[0], $tmonths); + $year = $dd[2]; + } + elseif ($how == 4) + { + $day = $dd[0]; + $month = array_search($dd[1], $tmonths); + $year = $dd[2]; + } + else + { + $day = $dd[2]; + $month = array_search($dd[1], $tmonths); + $year = $dd[0]; + } + if ($year < 1000) + return 0; + } + elseif (strlen($date) == 6) { if ($how == 0) { - $day = substr($date_,2,2); - $month = substr($date_,0,2); - $year = substr($date_,4,2); + $day = substr($date,2,2); + $month = substr($date,0,2); + $year = substr($date,4,2); } elseif ($how == 1) { - $day = substr($date_,0,2); - $month = substr($date_,2,2); - $year = substr($date_,4,2); + $day = substr($date,0,2); + $month = substr($date,2,2); + $year = substr($date,4,2); } else { - $day = substr($date_,4,2); - $month = substr($date_,2,2); - $year = substr($date_,0,2); + $day = substr($date,4,2); + $month = substr($date,2,2); + $year = substr($date,0,2); } } - elseif (strlen($date_) == 8) + elseif (strlen($date) == 8) { if ($how == 0) { - $day = substr($date_,2,2); - $month = substr($date_,0,2); - $year = substr($date_,4,4); + $day = substr($date,2,2); + $month = substr($date,0,2); + $year = substr($date,4,4); } elseif ($how == 1) { - $day = substr($date_,0,2); - $month = substr($date_,2,2); - $year = substr($date_,4,4); + $day = substr($date,0,2); + $month = substr($date,2,2); + $year = substr($date,4,4); } else { - $day = substr($date_,6,2); - $month = substr($date_,4,2); - $year = substr($date_,0,4); + $day = substr($date,6,2); + $month = substr($date,4,2); + $year = substr($date,0,4); } } if (!isset($year)|| (int)$year > 9999) @@ -99,13 +132,12 @@ function is_date($date_) return 0; } - if (is_long((int)$day) && is_long((int)$month) && is_long((int)$year)) { - global $date_system; - if ($date_system == 1) + global $SysPrefs; + if ($SysPrefs->date_system == 1) list($year, $month, $day) = jalali_to_gregorian($year, $month, $day); - elseif ($date_system == 2) + elseif ($SysPrefs->date_system == 2) list($year, $month, $day) = islamic_to_gregorian($year, $month, $day); if (checkdate((int)$month, (int)$day, (int)$year)) { @@ -124,14 +156,14 @@ function is_date($date_) function Today() { - global $date_system; + global $SysPrefs; $year = date("Y"); $month = date("n"); $day = date("j"); - if ($date_system == 1) + if ($SysPrefs->date_system == 1) list($year, $month, $day) = gregorian_to_jalali($year, $month, $day); - elseif ($date_system == 2) + elseif ($SysPrefs->date_system == 2) list($year, $month, $day) = gregorian_to_islamic($year, $month, $day); return __date($year, $month, $day); } @@ -162,15 +194,18 @@ function is_date_in_fiscalyear($date, $convert=false) global $path_to_root; include_once($path_to_root . "/admin/db/fiscalyears_db.inc"); - if ($_SESSION["wa_current_user"]->can_access('SA_MULTIFISCALYEARS')) // allow all open years for this one - return is_date_in_fiscalyears($date, false); - $myrow = get_current_fiscalyear(); - if ($myrow['closed'] == 1) - return 0; if ($convert) $date2 = sql2date($date); else $date2 = $date; + + if (is_date_closed($date2)) + return 0; + + if (user_check_access('SA_MULTIFISCALYEARS')) // allow all open years for this one + return is_date_in_fiscalyears($date2, false); + + $myrow = get_current_fiscalyear(); $begin = sql2date($myrow['begin']); $end = sql2date($myrow['end']); if (date1_greater_date2($begin, $date2) || date1_greater_date2($date2, $end)) @@ -180,6 +215,11 @@ function is_date_in_fiscalyear($date, $convert=false) return 1; } +function is_date_closed($date) +{ + return !date1_greater_date2($date, sql2date(get_company_pref('gl_closing_date'))); +} + function begin_fiscalyear() { global $path_to_root; @@ -200,91 +240,116 @@ function end_fiscalyear() function begin_month($date) { - global $date_system; + global $SysPrefs; list($day, $month, $year) = explode_date_to_dmy($date); - if ($date_system == 1) + if ($SysPrefs->date_system == 1) list($year, $month, $day) = gregorian_to_jalali($year, $month, $day); - elseif ($date_system == 2) + elseif ($SysPrefs->date_system == 2) list($year, $month, $day) = gregorian_to_islamic($year, $month, $day); return __date($year, $month, 1); } -function end_month($date) +function days_in_month($month, $year) { - global $date_system; - list($day, $month, $year) = explode_date_to_dmy($date); - if ($date_system == 1) + global $SysPrefs; + + if ($SysPrefs->date_system == 1) { - list($year, $month, $day) = gregorian_to_jalali($year, $month, $day); $days_in_month = array(31, 31, 31, 31, 31, 31, 30, 30, 30, 30, 30, ((((((($year - (($year > 0) ? 474 : 473)) % 2820) + 474) + 38) * 682) % 2816) < 682 ? 30 : 29)); } - elseif ($date_system == 2) + elseif ($SysPrefs->date_system == 2) { - list($year, $month, $day) = gregorian_to_islamic($year, $month, $day); $days_in_month = array(30, 29, 30, 29, 30, 29, 30, 29, 30, 29, 30, (((((11 * $year) + 14) % 30) < 11) ? 30 : 29)); } else // gregorian date $days_in_month = array(31, ((!($year % 4 ) && (($year % 100) || !($year % 400)))?29:28), 31, 30, 31, 30, 31, 31, 30, 31, 30, 31); - return __date($year, $month, $days_in_month[$month - 1]); + + return $days_in_month[$month - 1]; +} + +function end_month($date) +{ + global $SysPrefs; + + list($day, $month, $year) = explode_date_to_dmy($date); + if ($SysPrefs->date_system == 1) + { + list($year, $month, $day) = gregorian_to_jalali($year, $month, $day); + } + elseif ($SysPrefs->date_system == 2) + { + list($year, $month, $day) = gregorian_to_islamic($year, $month, $day); + } + + return __date($year, $month, days_in_month($month, $year)); } function add_days($date, $days) // accepts negative values as well { - global $date_system; + global $SysPrefs; list($day, $month, $year) = explode_date_to_dmy($date); - $timet = Mktime(0,0,0, $month, $day + $days, $year); - if ($date_system == 1 || $date_system == 2) + $timet = mktime(0,0,0, $month, $day + $days, $year); + if ($SysPrefs->date_system == 1 || $SysPrefs->date_system == 2) { - if ($date_system == 1) + if ($SysPrefs->date_system == 1) list($year, $month, $day) = gregorian_to_jalali(date("Y", $timet), date("n", $timet), date("j", $timet)); - elseif ($date_system == 2) + elseif ($SysPrefs->date_system == 2) list($year, $month, $day) = gregorian_to_islamic(date("Y", $timet), date("n", $timet), date("j", $timet)); return __date($year, $month, $day); } - return date(user_date_display(), $timet); + list($year, $month, $day) = explode("-", date("Y-m-d", $timet)); + return __date($year, $month, $day); } function add_months($date, $months) // accepts negative values as well { - global $date_system; + global $SysPrefs; + list($day, $month, $year) = explode_date_to_dmy($date); - $timet = Mktime(0,0,0, $month + $months, $day, $year); - if ($date_system == 1 || $date_system == 2) + + $months += $year*12+$month; + $month = ($months-1)%12+1; + $year = ($months-$month)/12; + + $timet = mktime(0,0,0, $month, min($day, days_in_month($month, $year)), $year); + + if ($SysPrefs->date_system == 1 || $SysPrefs->date_system == 2) { - if ($date_system == 1) + if ($SysPrefs->date_system == 1) list($year, $month, $day) = gregorian_to_jalali(date("Y", $timet), date("n", $timet), date("j", $timet)); - elseif ($date_system == 2) + elseif ($SysPrefs->date_system == 2) list($year, $month, $day) = gregorian_to_islamic(date("Y", $timet), date("n", $timet), date("j", $timet)); return __date($year, $month, $day); } - return date(user_date_display(), $timet); + list($year, $month, $day) = explode("-", date("Y-m-d", $timet)); + return __date($year, $month, $day); } function add_years($date, $years) // accepts negative values as well { - global $date_system; + global $SysPrefs; + list($day, $month, $year) = explode_date_to_dmy($date); $timet = Mktime(0,0,0, $month, $day, $year + $years); - if ($date_system == 1 || $date_system == 2) + if ($SysPrefs->date_system == 1 || $SysPrefs->date_system == 2) { - if ($date_system == 1) + if ($SysPrefs->date_system == 1) list($year, $month, $day) = gregorian_to_jalali(date("Y", $timet), date("n", $timet), date("j", $timet)); - elseif ($date_system == 2) + elseif ($SysPrefs->date_system == 2) list($year, $month, $day) = gregorian_to_islamic(date("Y", $timet), date("n", $timet), date("j", $timet)); return __date($year, $month, $day); } - return date(user_date_display(), $timet); + list($year, $month, $day) = explode("-", date("Y-m-d", $timet)); + return __date($year, $month, $day); } //_______________________________________________________________ function sql2date($date_) { - global $date_system; + global $SysPrefs; //for MySQL dates are in the format YYYY-mm-dd - if ($date_ == null || strlen($date_) == 0) - return ""; if (strpos($date_, "/")) { // In MySQL it could be either / or - @@ -294,14 +359,16 @@ function sql2date($date_) { list($year, $month, $day) = explode("-", $date_); } + if (!isset($day)) // data format error + return ""; if (strlen($day) > 4) { /*chop off the time stuff */ $day = substr($day, 0, 2); } - if ($date_system == 1) + if ($SysPrefs->date_system == 1) list($year, $month, $day) = gregorian_to_jalali($year, $month, $day); - elseif ($date_system == 2) + elseif ($SysPrefs->date_system == 2) list($year, $month, $day) = gregorian_to_islamic($year, $month, $day); return __date($year, $month, $day); } // end function sql2date @@ -309,51 +376,88 @@ function sql2date($date_) function date2sql($date_) { - global $dateseps, $date_system; + global $SysPrefs, $tmonths; /* takes a date in a the format specified in $DefaultDateFormat and converts to a yyyy/mm/dd format */ $how = user_date_format(); - $sep = $dateseps[user_date_sep()]; + $sep = $SysPrefs->dateseps[user_date_sep()]; + $date_ = trim($date_); if ($date_ == null || strlen($date_) == 0) return ""; - $date_ = trim($date_); $year = $month = $day = 0; - // Split up the date by the separator based on "how" to split it - if ($how == 0) // MMDDYYYY + if ($how == 0 || $how == 3) // MMDDYYYY or MmmDDYYYY list($month, $day, $year) = explode($sep, $date_); - elseif ($how == 1) // DDMMYYYY + elseif ($how == 1 || $how == 4) // DDMMYYYY or DDMmYYYY list($day, $month, $year) = explode($sep, $date_); - else // $how == 2, YYYYMMDD + else // $how == 2 || $how == 5, YYYYMMDD or YYYYMmmDD list($year, $month, $day) = explode($sep, $date_); -//to modify assumption in 2030 - if ($date_system == 0 || $date_system == 3) + if ($how > 2) { - if ((int)$year < 60) + global $tmonths; + $month = array_search($month, $tmonths); + } + if ($year+$day+$month) { + //to modify assumption in 2030 + if ($SysPrefs->date_system == 0 || $SysPrefs->date_system == 3) { - $year = "20".$year; - } - elseif ((int)$year > 59 && (int)$year < 100) + if ((int)$year < 60) + { + $year = "20".$year; + } + elseif ((int)$year > 59 && (int)$year < 100) + { + $year = "19".$year; + } + } + if ((int)$year > 9999) { - $year = "19".$year; + return 0; } - } - if ((int)$year > 9999) - { - return 0; + if ($SysPrefs->date_system == 1) + list($year, $month, $day) = jalali_to_gregorian($year, $month, $day); + elseif ($SysPrefs->date_system == 2) + list($year, $month, $day) = islamic_to_gregorian($year, $month, $day); } - if ($date_system == 1) - list($year, $month, $day) = jalali_to_gregorian($year, $month, $day); - elseif ($date_system == 2) - list($year, $month, $day) = islamic_to_gregorian($year, $month, $day); - return sprintf("%04d-%02d-%02d", $year, $month, $day); }// end of function +/** + * Compare dates in sql format. + * Return +1 if sql date1>date2, -1 if date1