commit_transaction();
}
-function is_date_in_fiscalyears($date)
+function is_date_in_fiscalyears($date, $closed=true)
{
$date = date2sql($date);
$sql = "SELECT * FROM ".TB_PREF."fiscal_year WHERE '$date' >= begin AND '$date' <= end";
-
+ if (!$closed)
+ $sql .= " AND closed=0";
$result = db_query($sql, "could not get all fiscal years");
return db_fetch($result) !== false;
}
-function is_bad_begin_date($date)
+function check_begin_end_date($date1, $date2)
{
- $bdate = date2sql($date);
- $sql = "SELECT MAX(end) FROM ".TB_PREF."fiscal_year WHERE begin < '$bdate'";
+ $sql = "SELECT MAX(end), MIN(begin) FROM ".TB_PREF."fiscal_year";
+ $result = db_query($sql, "could not retrieve last fiscal years");
+ $row = db_fetch_row($result);
+ if ($row[0] === null)
+ return true;
+ $max = add_days(sql2date($row[0]), 1);
+ $min = add_days(sql2date($row[1]), -1);
+ return ($max === $date1 || $min === $date2);
+}
+function next_begin_date()
+{
+ $sql = "SELECT MAX(end) FROM ".TB_PREF."fiscal_year";
$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);
+ return add_days(sql2date($row[0]), 1);
}
function check_years_before($date, $closed=false)
{
if ($row['type'] == ST_SALESINVOICE)
{
- $deliveries = get_parent_trans(ST_SALESINVOICE,$row['trans_no']);
+ $deliveries = get_sales_parent_numbers($row['type'], $row['trans_no']);
foreach ($deliveries as $delivery)
{
$sql = "DELETE FROM ".TB_PREF."debtor_trans_details WHERE debtor_trans_no = $delivery AND debtor_trans_type = ".ST_CUSTDELIVERY;