[0000277] Changed so FA suggest the next begin day in new Fiscal Year (read only).

[fa-stable.git] / admin / db / fiscalyears_db.inc

diff --git a/admin/db/fiscalyears_db.inc b/admin/db/fiscalyears_db.inc
index ebf6d4773e6680f076282cd9b7e8e679848fdea7..b2f62413045d903703db9f67ecc5d7b1b0bb6a6d 100644 (file)
--- a/admin/db/fiscalyears_db.inc
+++ b/admin/db/fiscalyears_db.inc
@@ -81,17 +81,23 @@ function is_date_in_fiscalyears($date, $closed=true)
        return db_fetch($result) !== false;
 }
 
-function is_bad_begin_date($date)
+function check_begin_date($date="", $check=true)
 {
-       $bdate = date2sql($date);
-       $sql = "SELECT MAX(end) FROM ".TB_PREF."fiscal_year WHERE begin < '$bdate'";
-
+       $sql = "SELECT MAX(end) FROM ".TB_PREF."fiscal_year";
+       if ($date !== "")
+       {
+               $bdate = date2sql($date);
+               $sql .= " WHERE begin < '$bdate'";
+       }
        $result = db_query($sql, "could not retrieve last fiscal years");
        $row = db_fetch_row($result);
        if ($row[0] === null)
                return false;
        $max = add_days(sql2date($row[0]), 1);
-       return ($max !== $date);
+       if ($check)
+               return ($max === $date);
+       else 
+               return $max;
 }
 
 function check_years_before($date, $closed=false)