X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=sidebyside;f=gl%2Finquiry%2Fprofit_loss.php;h=91a2c2751dc5921435c2aa6cb0ac3f6722f37831;hb=534d4b6a6b5e771f3b61e0fc65afd856760a6408;hp=f7ba91767c1055bc9b1282c5f8830d58d90f76e1;hpb=0c760ea65c8c6f0a45ea8328abab53be649f2105;p=fa-stable.git diff --git a/gl/inquiry/profit_loss.php b/gl/inquiry/profit_loss.php index f7ba9176..91a2c275 100644 --- a/gl/inquiry/profit_loss.php +++ b/gl/inquiry/profit_loss.php @@ -21,11 +21,16 @@ include_once($path_to_root . "/includes/data_checks.inc"); include_once($path_to_root . "/gl/includes/gl_db.inc"); $js = ""; -if ($use_date_picker) +if (user_use_date_picker()) $js = get_js_date_picker(); page(_($help_context = "Profit & Loss Drilldown"), false, false, "", $js); +$compare_types = array( + _("Accumulated"), + _("Period Y-1"), + _("Budget") +); //---------------------------------------------------------------------------------------------------- // Ajax updates @@ -50,9 +55,9 @@ if (isset($_GET["AccGrp"])) //---------------------------------------------------------------------------------------------------- function display_type ($type, $typename, $from, $to, $begin, $end, $compare, $convert, - &$dec, &$pdec, &$rep, $dimension=0, $dimension2=0, $drilldown, $path_to_root) + $dimension, $dimension2, $drilldown) { - global $levelptr, $k; + global $path_to_root, $levelptr, $k; $code_per_balance = 0; $code_acc_balance = 0; @@ -63,7 +68,7 @@ function display_type ($type, $typename, $from, $to, $begin, $end, $compare, $co //Get Accounts directly under this group/type $result = get_gl_accounts(null, null, $type); - + while ($account=db_fetch($result)) { $per_balance = get_gl_trans_from_to($from, $to, $account["account_code"], $dimension, $dimension2); @@ -101,7 +106,7 @@ function display_type ($type, $typename, $from, $to, $begin, $end, $compare, $co while ($accounttype=db_fetch($result)) { $totals_arr = display_type($accounttype["id"], $accounttype["name"], $from, $to, $begin, $end, - $compare, $convert, $dec, $pdec, $rep, $dimension, $dimension2, $drilldown, $path_to_root); + $compare, $convert, $dimension, $dimension2, $drilldown); $per_balance_total += $totals_arr[0]; $acc_balance_total += $totals_arr[1]; } @@ -157,19 +162,24 @@ function Achieve($d1, $d2) function inquiry_controls() { + global $compare_types; + $dim = get_company_pref('use_dimension'); start_table(TABLESTYLE_NOBORDER); - date_cells(_("From:"), 'TransFromDate', '', null, -$_SESSION["wa_current_user"]->prefs->transaction_days()); + $date = today(); + if (!isset($_POST['TransToDate'])) + $_POST['TransToDate'] = end_month($date); + if (!isset($_POST['TransFromDate'])) + $_POST['TransFromDate'] = add_days(end_month($date), -user_transaction_days()); + date_cells(_("From:"), 'TransFromDate'); date_cells(_("To:"), 'TransToDate'); - //Compare Combo - global $sel; - $sel = array(_("Accumulated"), _("Period Y-1"), _("Budget")); echo ""._("Compare to").":\n"; echo ""; - echo array_selector('Compare', null, $sel); + echo array_selector('Compare', null, $compare_types); echo "\n"; + if ($dim >= 1) dimensions_list_cells(_("Dimension")." 1:", 'Dimension', null, true, " ", false, 1); if ($dim > 1) @@ -183,9 +193,9 @@ function inquiry_controls() //---------------------------------------------------------------------------------------------------- -function display_profit_and_loss() +function display_profit_and_loss($compare) { - global $path_to_root, $sel; + global $path_to_root, $compare_types; if (!isset($_POST['Dimension'])) $_POST['Dimension'] = 0; @@ -196,16 +206,12 @@ function display_profit_and_loss() $from = $_POST['TransFromDate']; $to = $_POST['TransToDate']; - $compare = $_POST['Compare']; if (isset($_POST["AccGrp"]) && (strlen($_POST['AccGrp']) > 0)) $drilldown = 1; // Deeper Level else $drilldown = 0; // Root level - $dec = 0; - $pdec = user_percent_dec(); - if ($compare == 0 || $compare == 2) { $end = $to; @@ -224,20 +230,17 @@ function display_profit_and_loss() div_start('pl_tbl'); - start_table(TABLESTYLE, "width=50%"); + start_table(TABLESTYLE, "width='50%'"); $tableheader = " " . _("Group/Account Name") . " " . _("Period") . " - " . $sel[$compare] . " + " . $compare_types[$compare] . " " . _("Achieved %") . " "; if (!$drilldown) //Root Level { - $parent = -1; - $classper = 0.0; - $classacc = 0.0; $salesper = 0.0; $salesacc = 0.0; @@ -255,10 +258,11 @@ function display_profit_and_loss() //Get Account groups/types under this group/type $typeresult = get_account_types(false, $class['cid'], -1); + $k = 0; // row color while ($accounttype=db_fetch($typeresult)) { - $TypeTotal = display_type($accounttype["id"], $accounttype["name"], $from, $to, $begin, $end, $compare, $convert, - $dec, $pdec, $rep, $dimension, $dimension2, $drilldown, $path_to_root); + $TypeTotal = display_type($accounttype["id"], $accounttype["name"], $from, $to, $begin, $end, + $compare, $convert, $dimension, $dimension2, $drilldown); $class_per_total += $TypeTotal[0]; $class_acc_total += $TypeTotal[1]; @@ -313,13 +317,14 @@ function display_profit_and_loss() table_section_title($_POST["AccGrp"] . " " . get_account_type_name($_POST["AccGrp"]),4); echo $tableheader; - $classtotal = display_type($accounttype["id"], $accounttype["name"], $from, $to, $begin, $end, $compare, $convert, - $dec, $pdec, $rep, $dimension, $dimension2, $drilldown, $path_to_root); + $classtotal = display_type($accounttype["id"], $accounttype["name"], $from, $to, $begin, $end, + $compare, $convert, $dimension, $dimension2, $drilldown); } - end_table(1); // outer table + end_table(); // outer table + hyperlink_params($_SERVER['PHP_SELF'], _("Back"), "TransFromDate=". $from . "&TransToDate=" . $to . "&Dimension=" . $dimension . "&Dimension2=" . $dimension2); div_end(); } @@ -329,10 +334,9 @@ start_form(); inquiry_controls(); -display_profit_and_loss(); +display_profit_and_loss(get_post('Compare')); end_form(); -end_page(); +end_page(false, true); -?> \ No newline at end of file