X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=admin%2Fdb%2Ffiscalyears_db.inc;h=ebf6d4773e6680f076282cd9b7e8e679848fdea7;hb=69fde1eed360af911850c868e86fb2f63700195b;hp=4dc32b6952de79e35ceb4e50a7f8d72336a16e44;hpb=d23b97ed26bc0608c9ba1037b66058c709e83765;p=fa-stable.git diff --git a/admin/db/fiscalyears_db.inc b/admin/db/fiscalyears_db.inc index 4dc32b69..ebf6d477 100644 --- a/admin/db/fiscalyears_db.inc +++ b/admin/db/fiscalyears_db.inc @@ -71,11 +71,12 @@ function delete_fiscalyear($id) 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; } @@ -235,7 +236,7 @@ function delete_this_fiscalyear($selected_id) { 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;