$totaleq_lib2 = 0; while ($row = $xoopsDB->fetchArray($query)) { $accountcode_full = $row['accountcode_full']; $accounts_name = $row['accounts_name']; $placeholder = $row['placeholder']; $accounts_id = $row['accounts_id']; $classtype = $row['classtype']; $treelevel = $row['treelevel']; $accounts_nameori = $row['accounts_name']; //$lastbalance1=$acc->getAccountLastBalanceOnPeriod($periodfrom_id,$accounts_id); //$lastbalance2=$acc->getAccountLastBalanceOnPeriod($periodto_id,$accounts_id); if ($placeholder == 0 || $placeholder == 1 && $treelevel < $reportlevel) { $lastbalance1 = $acc->getAccountLastBalanceOnPeriod($periodfrom_id, $accounts_id); $lastbalance2 = $acc->getAccountLastBalanceOnPeriod($periodto_id, $accounts_id); } else { $lastbalance1 = $acc->getAccountsPeriodLastBalanceSheet($periodfrom_id, $accounts_id); $lastbalance2 = $acc->getAccountsPeriodLastBalanceSheet($periodto_id, $accounts_id); } if ($showaccountcode == "on") { $accounts_name = $accountcode_full . '-' . $accounts_name; } $bracket1 = ""; $bracket2 = ""; if ($placeholder == 0) { if ($currentcategory == "5A") { if ($lastbalance1 < 0) { $displayamt1 = number_format(abs($lastbalance1), 2); $bracket1 = "(-)"; //$displayamt="(-)$displayamt"; } else { $displayamt1 = number_format(abs($lastbalance1), 2);
if ($placeholder == 0) { if ($currentcategory == "5A") { if ($lastbalance < 0) { $displayamt = changeNegativeNumberFormat(abs($lastbalance), 2); $bracket = "(-)"; //$displayamt="(-)$displayamt"; } else { $displayamt = changeNegativeNumberFormat(abs($lastbalance), 2); } } else { $displayamt = changeNegativeNumberFormat(abs($lastbalance), 2); } } elseif ($placeholder == 1 && $treelevel < $reportlevel) { $displayamt = ""; } else { $displayamt = $acc->getAccountsPeriodLastBalanceSheet($periodfrom_id, $accounts_id); $displayamt = changeNegativeNumberFormat($displayamt, 2); } if ($treelevel == 1) { $prefix = ""; } elseif ($treelevel == 2) { $prefix = " "; } elseif ($treelevel == 3) { $prefix = " "; } elseif ($treelevel == 4) { $prefix = " "; } if ($showplacefolderindicator == 1 && $placeholder == 1) { $displaytext = $prefix . "[" . $accounts_name . "]"; } else { $displaytext = $prefix . $accounts_name;