X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=gl%2Fgl_budget.php;h=6c2ad64b3fc66b6e05833fcf1554957bb78f5ef1;hb=268a54dcfd08aff7113bc3afe8b784f36db2d0d4;hp=b503a61c5f3db15fccafdad1cfa6c7ad81796b9c;hpb=c09be0dad6b05131e240349a375af7a4b7bf3444;p=fa-stable.git diff --git a/gl/gl_budget.php b/gl/gl_budget.php index b503a61c..6c2ad64b 100644 --- a/gl/gl_budget.php +++ b/gl/gl_budget.php @@ -1,93 +1,53 @@ . +***********************************************************************/ +$page_security = 'SA_BUDGETENTRY'; +$path_to_root = ".."; +include_once($path_to_root . "/includes/session.inc"); add_js_file('budget.js'); -page(_("Budget Entry")); +page(_($help_context = "Budget Entry")); -include($path_to_root . "/includes/ui.inc"); -include($path_to_root . "/gl/includes/gl_db.inc"); +include_once($path_to_root . "/includes/ui.inc"); +include_once($path_to_root . "/gl/includes/gl_db.inc"); include_once($path_to_root . "/includes/data_checks.inc"); +include_once($path_to_root . "/admin/db/fiscalyears_db.inc"); -check_db_has_gl_account_groups(_("There are no account groups defined. Please define at least one account group before entering accounts.")); - -//------------------------------------------------------------------------------------- - -function exists_gl_budget($date_, $account, $dimension, $dimension2) -{ - $sql = "SELECT account FROM ".TB_PREF."budget_trans WHERE account='$account' AND tran_date='$date_' AND - dimension_id=$dimension AND dimension2_id=$dimension2"; - $result = db_query($sql, "Cannot retreive a gl transaction"); - - return (db_num_rows($result) > 0); -} - -function add_update_gl_budget_trans($date_, $account, $dimension, $dimension2, $amount) -{ - $date = date2sql($date_); - - if (exists_gl_budget($date, $account, $dimension, $dimension2)) - $sql = "UPDATE ".TB_PREF."budget_trans SET amount=$amount WHERE account='$account' AND - dimension_id=$dimension AND dimension2_id=$dimension2 AND tran_date='$date'"; - else - $sql = "INSERT INTO ".TB_PREF."budget_trans (tran_date, - account, dimension_id, dimension2_id, amount) VALUES ('$date', - '$account', $dimension, $dimension2, $amount)"; - - db_query($sql, "The GL budget transaction could not be saved"); -} - -function delete_gl_budget_trans($date_, $account, $dimension, $dimension2) -{ - $date = date2sql($date_); - - $sql = "DELETE FROM ".TB_PREF."budget_trans WHERE account='$account' AND - dimension_id=$dimension AND dimension2_id=$dimension2 AND tran_date='$date'"; - db_query($sql, "The GL budget transaction could not be deleted"); -} - -function get_only_budget_trans_from_to($from_date, $to_date, $account, $dimension=0, $dimension2=0) -{ - - $from = date2sql($from_date); - $to = date2sql($to_date); - - $sql = "SELECT SUM(amount) FROM ".TB_PREF."budget_trans - WHERE account='$account' AND tran_date >= '$from' AND tran_date <= '$to' - AND dimension_id = $dimension AND dimension2_id = $dimension2"; - $result = db_query($sql,"No budget accounts were returned"); - $row = db_fetch_row($result); - return $row[0]; -} +check_db_has_gl_account_groups(_("There are no account groups defined. Please define at least one account group before entering accounts.")); //------------------------------------------------------------------------------------- -if (isset($_POST['add']) || isset($_POST['delete'])) +if (isset($_POST['add']) || isset($_POST['delete'])) { begin_transaction(); - + for ($i = 0, $da = $_POST['begin']; date1_greater_date2($_POST['end'], $da); $i++) { if (isset($_POST['add'])) add_update_gl_budget_trans($da, $_POST['account'], $_POST['dim1'], $_POST['dim2'], input_num('amount'.$i)); - else + else delete_gl_budget_trans($da, $_POST['account'], $_POST['dim1'], $_POST['dim2']); $da = add_months($da, 1); } commit_transaction(); - + if (isset($_POST['add'])) display_notification_centered(_("The Budget has been saved.")); - else + else display_notification_centered(_("The Budget has been deleted.")); - - //meta_forward($_SERVER['PHP_SELF']); + $Ajax->activate('budget_tbl'); -} +} if (isset($_POST['submit']) || isset($_POST['update'])) $Ajax->activate('budget_tbl'); @@ -95,22 +55,22 @@ if (isset($_POST['submit']) || isset($_POST['update'])) start_form(); -if (db_has_gl_accounts()) +if (db_has_gl_accounts()) { $dim = get_company_pref('use_dimension'); - start_table($table_style2); + start_table(TABLESTYLE2); fiscalyears_list_row(_("Fiscal Year:"), 'fyear', null); gl_all_accounts_list_row(_("Account Code:"), 'account', null); - if (!isset($_POST['dim1'])) - $_POST['dim1'] = 0; - if (!isset($_POST['dim2'])) - $_POST['dim2'] = 0; + if (!isset($_POST['dim1'])) + $_POST['dim1'] = 0; + if (!isset($_POST['dim2'])) + $_POST['dim2'] = 0; if ($dim == 2) { dimensions_list_row(_("Dimension")." 1", 'dim1', $_POST['dim1'], true, null, false, 1); dimensions_list_row(_("Dimension")." 2", 'dim2', $_POST['dim2'], true, null, false, 2); } - else if ($dim == 1) + elseif ($dim == 1) { dimensions_list_row(_("Dimension"), 'dim1', $_POST['dim1'], true, null, false, 1); hidden('dim2', 0); @@ -123,21 +83,17 @@ if (db_has_gl_accounts()) submit_row('submit', _("Get"), true, '', '', true); end_table(1); div_start('budget_tbl'); - start_table($table_style2); - $showdims = (($dim == 1 && $_POST['dim1'] == 0) || + start_table(TABLESTYLE2); + $showdims = (($dim == 1 && $_POST['dim1'] == 0) || ($dim == 2 && $_POST['dim1'] == 0 && $_POST['dim2'] == 0)); - if ($showdims) + if ($showdims) $th = array(_("Period"), _("Amount"), _("Dim. incl."), _("Last Year")); - else + else $th = array(_("Period"), _("Amount"), _("Last Year")); - table_header($th); + table_header($th); $year = $_POST['fyear']; if (get_post('update') == '') { - $sql = "SELECT * FROM ".TB_PREF."fiscal_year WHERE id=$year"; - - $result = db_query($sql, "could not get current fiscal year"); - - $fyear = db_fetch($result); + $fyear = get_fiscalyear($year); $_POST['begin'] = sql2date($fyear['begin']); $_POST['end'] = sql2date($fyear['end']); } @@ -149,16 +105,16 @@ if (db_has_gl_accounts()) start_row(); if (get_post('update') == '') $_POST['amount'.$i] = number_format2(get_only_budget_trans_from_to( - $date_, $date_, $_POST['account'], $_POST['dim1'], $_POST['dim2']), 0); - - label_cell($date_); + $date_, $date_, $_POST['account'], $_POST['dim1'], $_POST['dim2']), 0); + + label_cell($date_); amount_cells(null, 'amount'.$i, null, 15, null, 0); if ($showdims) { $d = get_budget_trans_from_to($date_, $date_, $_POST['account'], $_POST['dim1'], $_POST['dim2']); label_cell(number_format2($d, 0), "nowrap align=right"); $btotal += $d; - } + } $lamount = get_gl_trans_from_to(add_years($date_, -1), add_years(end_month($date_), -1), $_POST['account'], $_POST['dim1'], $_POST['dim2']); $total += input_num('amount'.$i); $ltotal += $lamount; @@ -176,11 +132,10 @@ if (db_has_gl_accounts()) end_table(1); div_end(); submit_center_first('update', _("Update"), '', null); - submit('add', _("Save"), true, '', true); + submit('add', _("Save"), true, '', 'default'); submit_center_last('delete', _("Delete"), '', true); -} +} end_form(); - + end_page(); - -?> +