X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=admin%2Ffiscalyears.php;h=d6d05c5a14153a643c25e7fc4c924adcd66c32cc;hb=13fae1ba1d78cff66e326a006be2f538dd404248;hp=414f655c36cf57c265c2de8eb5127b99aa54110a;hpb=6183e9450dcd7e4c747889c10903f6ff1b0add33;p=fa-stable.git diff --git a/admin/fiscalyears.php b/admin/fiscalyears.php index 414f655c..d6d05c5a 100644 --- a/admin/fiscalyears.php +++ b/admin/fiscalyears.php @@ -1,51 +1,53 @@ . +***********************************************************************/ +$page_security = 'SA_FISCALYEARS'; +$path_to_root = ".."; include_once($path_to_root . "/includes/session.inc"); include_once($path_to_root . "/includes/date_functions.inc"); include_once($path_to_root . "/admin/db/company_db.inc"); +include_once($path_to_root . "/admin/db/fiscalyears_db.inc"); include_once($path_to_root . "/includes/ui.inc"); +include_once($path_to_root . "/sales/includes/db/cust_trans_db.inc"); +include_once($path_to_root . "/admin/db/maintenance_db.inc"); $js = ""; -if ($use_date_picker) +if (user_use_date_picker()) $js .= get_js_date_picker(); -page(_("Fiscal Years"), false, false, "", $js); - -//--------------------------------------------------------------------------------------------- - -if (isset($_GET['selected_id'])) -{ - $selected_id = $_GET['selected_id']; -} -elseif (isset($_POST['selected_id'])) -{ - $selected_id = $_POST['selected_id']; -} -else - $selected_id = null; +page(_($help_context = "Fiscal Years"), false, false, "", $js); +simple_page_mode(true); //--------------------------------------------------------------------------------------------- function check_data() { - if (!isset($selected_id)) - $from = $_POST['from_date']; - else - $from = $selected_id; - if (!is_date($from)) + if (!is_date($_POST['from_date']) || is_date_in_fiscalyears($_POST['from_date'])) { display_error( _("Invalid BEGIN date in fiscal year.")); set_focus('from_date'); return false; } - if (!is_date($_POST['to_date'])) + if (!is_date($_POST['to_date']) || is_date_in_fiscalyears($_POST['to_date'])) { display_error( _("Invalid END date in fiscal year.")); set_focus('to_date'); return false; } - if (date1_greater_date2($from, $_POST['to_date'])) + if (!check_begin_end_date($_POST['from_date'], $_POST['to_date'])) + { + display_error( _("Invalid BEGIN or END date in fiscal year.")); + set_focus('from_date'); + return false; + } + if (date1_greater_date2($_POST['from_date'], $_POST['to_date'])) { display_error( _("BEGIN date bigger than END date.")); set_focus('from_date'); @@ -54,108 +56,123 @@ function check_data() return true; } -//--------------------------------------------------------------------------------------------- - function handle_submit() { - global $selected_id; - - if (!check_data()) - return false; + global $selected_id, $Mode; - if (isset($selected_id)) + $ok = true; + if ($selected_id != -1) { - update_fiscalyear($_POST['from_date'], $_POST['closed']); - } - else + if ($_POST['closed'] == 1) + { + if (check_years_before($_POST['from_date'], false)) + { + display_error( _("Cannot CLOSE this year because there are open fiscal years before")); + set_focus('closed'); + return false; + } + $ok = close_year($selected_id); + } + else + open_year($selected_id); + if ($ok) + { + update_fiscalyear($selected_id, $_POST['closed']); + display_notification(_('Selected fiscal year has been updated')); + } + } + else { + if (!check_data()) + return false; add_fiscalyear($_POST['from_date'], $_POST['to_date'], $_POST['closed']); + display_notification(_('New fiscal year has been added')); } - - return true; + $Mode = 'RESET'; } //--------------------------------------------------------------------------------------------- -function check_can_delete($todate) +function check_can_delete($selected_id) { - global $selected_id; - + $myrow = get_fiscalyear($selected_id); // PREVENT DELETES IF DEPENDENT RECORDS IN gl_trans - $from = date2sql($selected_id); - $to = date2sql($todate); - $sql= "SELECT COUNT(*) FROM ".TB_PREF."gl_trans WHERE tran_date >= '$from' AND tran_date <= '$to'"; - $result = db_query($sql, "could not query gl_trans master"); - $myrow = db_fetch_row($result); - if ($myrow[0] > 0) + if (check_years_before(sql2date($myrow['begin']), true)) { - display_error(_("Cannot delete this fiscal year because items have been created referring to it.")); + display_error(_("Cannot delete this fiscal year because there are fiscal years before.")); + return false; + } + if ($myrow['closed'] == 0) + { + display_error(_("Cannot delete this fiscal year because the fiscal year is not closed.")); return false; } - return true; } -//--------------------------------------------------------------------------------------------- - -function handle_delete($todate) +function handle_delete() { - global $selected_id; + global $selected_id, $Mode; - if (!check_can_delete($todate)) - return; + if (check_can_delete($selected_id)) { //only delete if used in neither customer or supplier, comp prefs, bank trans accounts - - delete_fiscalyear($selected_id); - - meta_forward($_SERVER['PHP_SELF']); + delete_this_fiscalyear($selected_id); + display_notification(_('Selected fiscal year has been deleted')); + } + $Mode = 'RESET'; } //--------------------------------------------------------------------------------------------- function display_fiscalyears() { - global $table_style; - $company_year = get_company_pref('f_year'); $result = get_all_fiscalyears(); - - start_table($table_style); + start_form(); + display_note(_("Warning: Deleting a fiscal year all transactions + are removed and converted into relevant balances. This process is irreversible!"), + 0, 1, "class='currentfg'"); + start_table(TABLESTYLE); $th = array(_("Fiscal Year Begin"), _("Fiscal Year End"), _("Closed"), "", ""); table_header($th); $k=0; - while ($myrow=db_fetch($result)) + while ($myrow=db_fetch($result)) { - if ($myrow['id'] == $company_year) + if ($myrow['id'] == $company_year) { start_row("class='stockmankobg'"); - } + } else alt_table_row_color($k); $from = sql2date($myrow["begin"]); $to = sql2date($myrow["end"]); - if ($myrow["closed"] == 0) + if ($myrow["closed"] == 0) { $closed_text = _("No"); - } - else + } + else { $closed_text = _("Yes"); } label_cell($from); label_cell($to); label_cell($closed_text); - edit_link_cell("selected_id=" . urlencode($from)); - if ($myrow["id"] != $company_year) - delete_link_cell("selected_id=" . urlencode($from) . "&to_date=" . urlencode($to) . "&delete=1"); + edit_button_cell("Edit".$myrow['id'], _("Edit")); + if ($myrow["id"] != $company_year) { + delete_button_cell("Delete".$myrow['id'], _("Delete")); + submit_js_confirm("Delete".$myrow['id'], + sprintf(_("Are you sure you want to delete fiscal year %s - %s? All transactions are deleted and converted into relevant balances. Do you want to continue ?"), $from, $to)); + } else + label_cell(''); end_row(); } - end_table();; + end_table(); + end_form(); display_note(_("The marked fiscal year is the current fiscal year which cannot be deleted."), 0, 0, "class='currentfg'"); } @@ -163,61 +180,72 @@ function display_fiscalyears() function display_fiscalyear_edit($selected_id) { - global $table_style2; - + global $Mode; + start_form(); - start_table($table_style2); + start_table(TABLESTYLE2); - if ($selected_id) + if ($selected_id != -1) { - $myrow = get_fiscalyear($selected_id); - - $_POST['from_date'] = sql2date($myrow["begin"]); - $_POST['to_date'] = sql2date($myrow["end"]); - $_POST['closed'] = $myrow["closed"]; - hidden('selected_id', $selected_id); - hidden('from_date', $_POST['from_date']); - hidden('to_date', $_POST['to_date']); + if($Mode =='Edit') + { + $myrow = get_fiscalyear($selected_id); + + $_POST['from_date'] = sql2date($myrow["begin"]); + $_POST['to_date'] = sql2date($myrow["end"]); + $_POST['closed'] = $myrow["closed"]; + } + hidden('from_date'); + hidden('to_date'); label_row(_("Fiscal Year Begin:"), $_POST['from_date']); label_row(_("Fiscal Year End:"), $_POST['to_date']); - } - else + } + else { - date_row(_("Fiscal Year Begin:"), 'from_date', null, 0, 0, 1001); - date_row(_("Fiscal Year End:"), 'to_date', null, 0, 0, 1001); + $begin = next_begin_date(); + if ($begin && $Mode != 'ADD_ITEM') + { + $_POST['from_date'] = $begin; + $_POST['to_date'] = end_month(add_months($begin, 11)); + } + date_row(_("Fiscal Year Begin:"), 'from_date', '', null, 0, 0, 1001); + date_row(_("Fiscal Year End:"), 'to_date', '', null, 0, 0, 1001); } + hidden('selected_id', $selected_id); yesno_list_row(_("Is Closed:"), 'closed', null, "", "", false); end_table(1); - submit_add_or_update_center(!isset($selected_id)); + submit_add_or_update_center($selected_id == -1, '', 'both'); end_form(); } //--------------------------------------------------------------------------------------------- -if (isset($_POST['ADD_ITEM']) || isset($_POST['UPDATE_ITEM'])) +if ($Mode=='ADD_ITEM' || $Mode=='UPDATE_ITEM') { - if (handle_submit()) - { - meta_forward($_SERVER['PHP_SELF']); - } + handle_submit(); } //--------------------------------------------------------------------------------------------- -if (isset($_GET['delete'])) +if ($Mode == 'Delete') { - handle_delete($_GET['to_date']); + global $selected_id; + handle_delete($selected_id); } +if ($Mode == 'RESET') +{ + $selected_id = -1; +} //--------------------------------------------------------------------------------------------- display_fiscalyears(); -hyperlink_no_params($_SERVER['PHP_SELF'], _("Enter a New Fiscal Year")); +echo '
'; display_fiscalyear_edit($selected_id); @@ -225,4 +253,3 @@ display_fiscalyear_edit($selected_id); end_page(); -?>