X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=gl%2Finquiry%2Fgl_trial_balance.php;h=0dd1dcfa0327ef8f740b374d8c0acf89b2d70724;hb=2b573e0be560fd27613c66b07f9a88a5b768ba66;hp=27c38dac7b68338cd838ab30fc0ca3d0655142a8;hpb=0c1ab57c09d87eed2bd248892dbfe3f256767a82;p=fa-stable.git diff --git a/gl/inquiry/gl_trial_balance.php b/gl/inquiry/gl_trial_balance.php index 27c38dac..0dd1dcfa 100644 --- a/gl/inquiry/gl_trial_balance.php +++ b/gl/inquiry/gl_trial_balance.php @@ -1,12 +1,12 @@ . ***********************************************************************/ $page_security = 'SA_GLANALYTIC'; @@ -33,7 +33,7 @@ $pdeb = $pcre = $cdeb = $ccre = $tdeb = $tcre = $pbal = $cbal = $tbal = 0; //---------------------------------------------------------------------------------------------------- // Ajax updates // -if (get_post('Show')) +if (get_post('Show')) { $Ajax->activate('balance_tbl'); } @@ -50,7 +50,8 @@ function gl_inquiry_controls() if (!isset($_POST['TransToDate'])) $_POST['TransToDate'] = end_month($date); if (!isset($_POST['TransFromDate'])) - $_POST['TransFromDate'] = add_days(end_month($date), -$_SESSION["wa_current_user"]->prefs->transaction_days()); + $_POST['TransFromDate'] = add_days(end_month($date), -user_transaction_days()); + start_row(); date_cells(_("From:"), 'TransFromDate'); date_cells(_("To:"), 'TransToDate'); if ($dim >= 1) @@ -59,8 +60,8 @@ function gl_inquiry_controls() dimensions_list_cells(_("Dimension")." 2:", 'Dimension2', null, true, " ", false, 2); check_cells(_("No zero values"), 'NoZero', null); check_cells(_("Only balances"), 'Balance', null); - submit_cells('Show',_("Show"),'','', 'default'); + end_row(); end_table(); end_form(); } @@ -69,7 +70,7 @@ function gl_inquiry_controls() function display_trial_balance($type, $typename) { - global $path_to_root, $clear_trial_balance_opening, + global $path_to_root, $SysPrefs, $k, $pdeb, $pcre, $cdeb, $ccre, $tdeb, $tcre, $pbal, $cbal, $tbal; $printtitle = 0; //Flag for printing type name @@ -84,9 +85,19 @@ function display_trial_balance($type, $typename) $begin = $_POST['TransFromDate']; $begin = add_days($begin, -1); + $Apdeb=$pdeb; + $Apcre=$pcre; + $Acdeb=$cdeb; + $Accre=$ccre; + $Atdeb=$tdeb; + $Atcre=$tcre; + $Apbal=$pbal; + $Acbal=$cbal; + $Atbal=$tbal; + while ($account = db_fetch($accounts)) { - //Print Type Title if it has atleast one non-zero account + //Print Type Title if it has atleast one non-zero account if (!$printtitle) { start_row("class='inquirybg' style='font-weight:bold'"); @@ -97,7 +108,7 @@ function display_trial_balance($type, $typename) // FA doesn't really clear the closed year, therefore the brought forward balance includes all the transactions from the past, even though the balance is null. // If we want to remove the balanced part for the past years, this option removes the common part from from the prev and tot figures. - if (@$clear_trial_balance_opening) + if (@$SysPrefs->clear_trial_balance_opening) { $open = get_balance($account["account_code"], $_POST['Dimension'], $_POST['Dimension2'], $begin, $begin, false, true); $offset = min($open['debit'], $open['credit']); @@ -136,7 +147,7 @@ function display_trial_balance($type, $typename) $ccre += $curr['credit']; $tdeb += $tot['debit']; $tcre += $tot['credit']; - } + } $pbal += $prev['balance']; $cbal += $curr['balance']; $tbal += $tot['balance']; @@ -158,6 +169,26 @@ function display_trial_balance($type, $typename) } display_trial_balance($accounttype["id"], $accounttype["name"].' ('.$typename.')'); } + + start_row("class='inquirybg' style='font-weight:bold'"); + label_cell(_("Total") ." - ".$typename, "colspan=2"); + + if (!check_value('Balance')) + { + amount_cell($pdeb-$Apdeb ); + amount_cell($pcre-$Apcre); + amount_cell($cdeb-$Acdeb ); + amount_cell($ccre-$Accre ); + amount_cell($tdeb-$Atdeb ); + amount_cell($tcre-$Atcre); + } + else + { + display_debit_or_credit_cells($pbal-$Apbal); + display_debit_or_credit_cells($cbal-$Acbal ); + display_debit_or_credit_cells($tbal-$Atbal); + } + end_row(); } //---------------------------------------------------------------------------------------------------- @@ -214,36 +245,31 @@ while ($class = db_fetch($classresult)) } } - //$prev = get_balance(null, $begin, $_POST['TransFromDate'], false, false); - //$curr = get_balance(null, $_POST['TransFromDate'], $_POST['TransToDate'], true, true); - //$tot = get_balance(null, $begin, $_POST['TransToDate'], false, true); - if (!check_value('Balance')) - { - start_row("class='inquirybg' style='font-weight:bold'"); - label_cell(_("Total") ." - ".$_POST['TransToDate'], "colspan=2"); - amount_cell($pdeb); - amount_cell($pcre); - amount_cell($cdeb); - amount_cell($ccre); - amount_cell($tdeb); - amount_cell($tcre); - end_row(); - } +if (!check_value('Balance')) +{ start_row("class='inquirybg' style='font-weight:bold'"); - label_cell(_("Ending Balance") ." - ".$_POST['TransToDate'], "colspan=2"); - display_debit_or_credit_cells($pbal); - display_debit_or_credit_cells($cbal); - display_debit_or_credit_cells($tbal); + label_cell(_("Total") ." - ".$_POST['TransToDate'], "colspan=2"); + amount_cell($pdeb); + amount_cell($pcre); + amount_cell($cdeb); + amount_cell($ccre); + amount_cell($tdeb); + amount_cell($tcre); end_row(); - - end_table(1); - if (($pbal = round2($pbal, user_price_dec())) != 0 && $_POST['Dimension'] == 0 && $_POST['Dimension2'] == 0) - display_warning(_("The Opening Balance is not in balance, probably due to a non closed Previous Fiscalyear.")); - div_end(); +} +start_row("class='inquirybg' style='font-weight:bold'"); +label_cell(_("Ending Balance") ." - ".$_POST['TransToDate'], "colspan=2"); +display_debit_or_credit_cells($pbal); +display_debit_or_credit_cells($cbal); +display_debit_or_credit_cells($tbal); +end_row(); + +end_table(1); +if (($pbal = round2($pbal, user_price_dec())) != 0 && $_POST['Dimension'] == 0 && $_POST['Dimension2'] == 0) + display_warning(_("The Opening Balance is not in balance, probably due to a non closed Previous Fiscalyear.")); +div_end(); //---------------------------------------------------------------------------------------------------- end_page(); -?> -