X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=sidebyside;f=includes%2Fdate_functions.inc;h=2538f79d65f3edc24c031ae23f176a5359e10592;hb=716ddd8b68b285b432e47626939165d9f6c48f90;hp=c0bcbe94476acb565053bbd7268ac01479270b92;hpb=7c0d74930927c837225710f89591cba93d16ac5f;p=fa-stable.git

diff --git a/includes/date_functions.inc b/includes/date_functions.inc
index c0bcbe94..2538f79d 100644
--- a/includes/date_functions.inc
+++ b/includes/date_functions.inc
@@ -350,7 +350,8 @@ function sql2date($date_)
 	global $SysPrefs;
 
 	//for MySQL dates are in the format YYYY-mm-dd
-
+	if ($date_ == null)
+		return "";
 	if (strpos($date_, "/")) 
 	{ // In MySQL it could be either / or -
 		list($year, $month, $day) = explode("/", $date_);
@@ -395,32 +396,34 @@ and converts to a yyyy/mm/dd format */
         list($day, $month, $year) = explode($sep, $date_);
     else // $how == 2 || $how == 5, YYYYMMDD or YYYYMmmDD
         list($year, $month, $day) = explode($sep, $date_);
+
 	if ($how > 2)
 	{
 		global $tmonths;
 		$month = array_search($month, $tmonths);
-	}	
-//to modify assumption in 2030
-	if ($SysPrefs->date_system == 0 || $SysPrefs->date_system == 3)
-	{
-		if ((int)$year < 60)
+	}
+	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 ($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); 
-
 	return sprintf("%04d-%02d-%02d", $year, $month, $day);
 }// end of function