X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=inline;f=includes%2Fdate_functions.inc;h=c06dc4d323a8882e61726edd6894e09b11d33ee3;hb=9e804a1a25b41581b4c0a343879157d732d46db2;hp=febf609f7fe5b94ada520345dba9ac52820f41a8;hpb=481b39c0950b34482fb565ef9230345000938e7e;p=fa-stable.git
diff --git a/includes/date_functions.inc b/includes/date_functions.inc
index febf609f..c06dc4d3 100644
--- a/includes/date_functions.inc
+++ b/includes/date_functions.inc
@@ -1,14 +1,25 @@
.
+***********************************************************************/
/*
date validation and parsing functions
These functions refer to the global variable defining the date format
-The date format is defined in config.php called DefaultDateFormat
+The date format is defined in config.php called dateformats
this can be a string either "d/m/Y" for UK/Australia/New Zealand dates or
-"m/d/Y" for US/Canada format dates
+"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)
{
@@ -24,7 +35,7 @@ function __date($year, $month, $day)
$month = "0".$month;
if ($how == 0)
return $month.$sep.$day.$sep.$year;
- else if ($how == 1)
+ elseif ($how == 1)
return $day.$sep.$month.$sep.$year;
else
return $year.$sep.$month.$sep.$day;
@@ -94,7 +105,7 @@ function is_date($date_)
global $date_system;
if ($date_system == 1)
list($year, $month, $day) = jalali_to_gregorian($year, $month, $day);
- else if ($date_system == 2)
+ elseif ($date_system == 2)
list($year, $month, $day) = islamic_to_gregorian($year, $month, $day);
if (checkdate((int)$month, (int)$day, (int)$year))
{
@@ -120,7 +131,7 @@ function Today()
$day = date("j");
if ($date_system == 1)
list($year, $month, $day) = gregorian_to_jalali($year, $month, $day);
- else if ($date_system == 2)
+ elseif ($date_system == 2)
list($year, $month, $day) = gregorian_to_islamic($year, $month, $day);
return __date($year, $month, $day);
}
@@ -132,12 +143,27 @@ function Now()
else
return date("H:i");
}
+//
+// Retrieve and optionaly set default date for new document.
+//
+function new_doc_date($date=null)
+{
+ if (isset($date) && $date != '')
+ $_SESSION['_default_date'] = $date;
+
+ if (!isset($_SESSION['_default_date']) || !sticky_doc_date())
+ $_SESSION['_default_date'] = Today();
+
+ return $_SESSION['_default_date'];
+}
function is_date_in_fiscalyear($date, $convert=false)
{
global $path_to_root;
- include_once($path_to_root . "/admin/db/company_db.inc");
+ 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;
@@ -157,7 +183,7 @@ function is_date_in_fiscalyear($date, $convert=false)
function begin_fiscalyear()
{
global $path_to_root;
- include_once($path_to_root . "/admin/db/company_db.inc");
+ include_once($path_to_root . "/admin/db/fiscalyears_db.inc");
$myrow = get_current_fiscalyear();
return sql2date($myrow['begin']);
@@ -166,7 +192,7 @@ function begin_fiscalyear()
function end_fiscalyear()
{
global $path_to_root;
- include_once($path_to_root . "/admin/db/company_db.inc");
+ include_once($path_to_root . "/admin/db/fiscalyears_db.inc");
$myrow = get_current_fiscalyear();
return sql2date($myrow['end']);
@@ -178,7 +204,7 @@ function begin_month($date)
list($day, $month, $year) = explode_date_to_dmy($date);
if ($date_system == 1)
list($year, $month, $day) = gregorian_to_jalali($year, $month, $day);
- else if ($date_system == 2)
+ elseif ($date_system == 2)
list($year, $month, $day) = gregorian_to_islamic($year, $month, $day);
return __date($year, $month, 1);
}
@@ -192,7 +218,7 @@ function end_month($date)
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));
}
- else if ($date_system == 2)
+ elseif ($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));
@@ -211,7 +237,7 @@ function add_days($date, $days) // accepts negative values as well
{
if ($date_system == 1)
list($year, $month, $day) = gregorian_to_jalali(date("Y", $timet), date("n", $timet), date("j", $timet));
- else if ($date_system == 2)
+ elseif ($date_system == 2)
list($year, $month, $day) = gregorian_to_islamic(date("Y", $timet), date("n", $timet), date("j", $timet));
return __date($year, $month, $day);
}
@@ -227,7 +253,7 @@ function add_months($date, $months) // accepts negative values as well
{
if ($date_system == 1)
list($year, $month, $day) = gregorian_to_jalali(date("Y", $timet), date("n", $timet), date("j", $timet));
- else if ($date_system == 2)
+ elseif ($date_system == 2)
list($year, $month, $day) = gregorian_to_islamic(date("Y", $timet), date("n", $timet), date("j", $timet));
return __date($year, $month, $day);
}
@@ -243,7 +269,7 @@ function add_years($date, $years) // accepts negative values as well
{
if ($date_system == 1)
list($year, $month, $day) = gregorian_to_jalali(date("Y", $timet), date("n", $timet), date("j", $timet));
- else if ($date_system == 2)
+ elseif ($date_system == 2)
list($year, $month, $day) = gregorian_to_islamic(date("Y", $timet), date("n", $timet), date("j", $timet));
return __date($year, $month, $day);
}
@@ -275,7 +301,7 @@ function sql2date($date_)
}
if ($date_system == 1)
list($year, $month, $day) = gregorian_to_jalali($year, $month, $day);
- else if ($date_system == 2)
+ elseif ($date_system == 2)
list($year, $month, $day) = gregorian_to_islamic($year, $month, $day);
return __date($year, $month, $day);
} // end function sql2date
@@ -294,53 +320,18 @@ and converts to a yyyy/mm/dd format */
return "";
$date_ = trim($date_);
- $date_ = str_replace($sep, "", $date_);
+ $year = $month = $day = 0;
- if (strlen($date_) == 6)
- {
- if ($how == 0)
- {
- $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);
- }
- else
- {
- $day = substr($date_,4,2);
- $month = substr($date_,2,2);
- $year = substr($date_,0,2);
- }
- }
- elseif (strlen($date_) == 8)
- {
- if ($how == 0)
- {
- $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);
- }
- else
- {
- $day = substr($date_,6,2);
- $month = substr($date_,4,2);
- $year = substr($date_,0,4);
- }
- }
+ // Split up the date by the separator based on "how" to split it
+ if ($how == 0) // MMDDYYYY
+ list($month, $day, $year) = explode($sep, $date_);
+ elseif ($how == 1) // DDMMYYYY
+ list($day, $month, $year) = explode($sep, $date_);
+ else // $how == 2, YYYYMMDD
+ list($year, $month, $day) = explode($sep, $date_);
//to modify assumption in 2030
- if ($date_system == 0)
+ if ($date_system == 0 || $date_system == 3)
{
if ((int)$year < 60)
{
@@ -357,9 +348,16 @@ and converts to a yyyy/mm/dd format */
}
if ($date_system == 1)
list($year, $month, $day) = jalali_to_gregorian($year, $month, $day);
- else if ($date_system == 2)
+ elseif ($date_system == 2)
list($year, $month, $day) = islamic_to_gregorian($year, $month, $day);
- return $year."/".$month."/".$day;
+
+ // Pad with 0s if needed
+ if (strlen($month) == 1)
+ $month = "0$month";
+ if (strlen($day) == 1)
+ $day = "0$day";
+
+ return $year."-".$month."-".$day;
}// end of function
function date1_greater_date2 ($date1, $date2)
@@ -369,8 +367,9 @@ function date1_greater_date2 ($date1, $date2)
$date1 = date2sql($date1);
$date2 = date2sql($date2);
- list($year1, $month1, $day1) = explode("/", $date1);
- list($year2, $month2, $day2) = explode("/", $date2);
+
+ @list($year1, $month1, $day1) = explode("-", $date1);
+ @list($year2, $month2, $day2) = explode("-", $date2);
if ($year1 > $year2)
{
@@ -394,7 +393,7 @@ function date1_greater_date2 ($date1, $date2)
}
-function date_diff ($date1, $date2, $period)
+function date_diff2 ($date1, $date2, $period)
{
/* expects dates in the format specified in $DefaultDateFormat - period can be one of 'd','w','y','m'
@@ -403,8 +402,8 @@ provided that both dates are after 1970. Also only works for dates up to the yea
$date1 = date2sql($date1);
$date2 = date2sql($date2);
- list($year1, $month1, $day1) = explode("/", $date1);
- list($year2, $month2, $day2) = explode("/", $date2);
+ list($year1, $month1, $day1) = explode("-", $date1);
+ list($year2, $month2, $day2) = explode("-", $date2);
$stamp1 = mktime(0,0,0, (int)$month1, (int)$day1, (int)$year1);
$stamp2 = mktime(0,0,0, (int)$month2, (int)$day2, (int)$year2);
@@ -434,11 +433,9 @@ function explode_date_to_dmy($date_)
$date = date2sql($date_);
if ($date == "")
{
- $disp = user_date_display();
- echo "
Dates must be entered in the format $disp. Sent was $date_
";
- exit;
+ return array(0,0,0);
}
- list($year, $month, $day) = explode("/", $date);
+ list($year, $month, $day) = explode("-", $date);
return array($day, $month, $year);
}