function ShowTransactions()
{
$OB_Debit = 0;
$OB_Credit = 0;
$Grand_Total = 0;
$Grand_Total_Debit = 0;
$Grand_Total_Credit = 0;
$Grand_TR_Total_Debit = 0;
$Grand_TR_Total_Credit = 0;
$Grand_Total_Closing = 0;
$nResult = DB::table('coa')->where('parent_id', '=', 0)->orderBy('coa_code', 'asc')->get();
foreach ($nResult as $rstRow) {
// Show Main Head
echo "\t<tr>";
echo "\t\t<td >" . AccountName($rstRow->coa_code, $rstRow->coa_account) . "</td>";
echo "\t\t<td></td>";
echo "\t\t<td></td>";
echo "\t\t<td></td>";
echo "\t</tr>";
$nResultDetail = DB::table('coa')->where('parent_id', '=', $rstRow->coa_id)->orderBy('coa_code', 'asc')->get();
$Total_OB_Debit = 0;
$Total_OB_Credit = 0;
$Total_TR_Debit = 0;
$Total_TR_Credit = 0;
$Total_Closing = 0;
$OpBalance = 0;
$sub_Total_Debit = 0;
$sub_Total_Credit = 0;
$sub_Total_Closing = 0;
foreach ($nResultDetail as $key => $value) {
$OB_Balance = get_opening_balance($value->coa_code);
$is_Debit = "";
if (!empty($OB_Balance)) {
if ($OB_Balance[0]->coa_debit != 0) {
$is_Debit = "Dr";
} elseif ($OB_Balance[0]->coa_credit != 0) {
$is_Debit = "Cr";
}
}
$OB_Debit = $OB_Balance[0]->coa_debit;
$OB_Credit = $OB_Balance[0]->coa_credit;
$OpBalance = $OB_Debit + $OB_Credit;
$start_date = "2016-04-01";
$end_date = date("Y-m-d");
// Get all debit credit sum with opening balance
$allData = search_vouchers($value->coa_code, $start_date, $end_date, $OpBalance);
$Total_TR_Debit = $allData['Debit'];
$Total_TR_Credit = $allData['Credit'];
//$Total_Closing = ($OpBalance + $Total_TR_Debit) - $Total_TR_Credit;
if ($is_Debit == "Dr") {
$Total_Closing = $OpBalance + $Total_TR_Debit - $Total_TR_Credit;
} else {
$Total_Closing = $OpBalance - $Total_TR_Debit + $Total_TR_Credit;
}
$sub_Total_Debit += $Total_TR_Debit;
$sub_Total_Credit += $Total_TR_Credit;
echo "\t<tr>";
echo "\t\t<td >" . AccountName($value->coa_code, $value->coa_account) . "</td>";
echo "\t\t<td><span style='text-align:left; float:left; padding-left:20px'>" . number_format($OB_Debit) . "</span><span style='text-align:right; float:right;'>" . number_format($OB_Credit) . "</span></td>";
echo "\t\t<td><span style='text-align:left; float:left; padding-left:20px'>" . number_format($Total_TR_Debit) . "</span><span style='text-align:right; float:right;'>" . number_format($Total_TR_Credit) . "</span></td>";
echo "\t\t<td><span style='text-align:left; float:left; padding-left:20px'>0</span><span style='text-align:right; float:right;'>" . number_format($Total_Closing) . "</span></td>";
echo "\t</tr>";
$Total_OB_Debit += $OB_Debit;
$Total_OB_Credit += $OB_Credit;
$sub_Total_Closing += $Total_Closing;
}
// Sub total head
echo "\t<tr>";
echo "\t\t<td align='right' style='font-weight:bold;'>Sub Head Total:</td>";
echo "\t\t<td><span style='text-align:left; float:left; padding-left:20px; font-weight:bold'>" . number_format($Total_OB_Debit) . "</span><span style='text-align:right; float:right; font-weight:bold'>" . number_format($Total_OB_Credit) . "</span></td>";
echo "\t\t<td><span style='text-align:left; float:left; padding-left:20px; font-weight:bold'>" . number_format($sub_Total_Debit) . "</span><span style='text-align:right; float:right; font-weight:bold'>" . number_format($sub_Total_Credit) . "</span></td>";
echo "\t\t<td><span style='text-align:left; float:left; padding-left:20px; font-weight:bold'>0</span><span style='text-align:right; float:right; font-weight:bold'>" . number_format($sub_Total_Closing) . "</span></td>";
echo "\t</tr>";
$Grand_Total_Debit += $Total_OB_Debit;
$Grand_Total_Credit += $Total_OB_Credit;
$Grand_TR_Total_Debit += $sub_Total_Debit;
$Grand_TR_Total_Credit += $sub_Total_Credit;
$Grand_Total_Closing += $sub_Total_Closing;
}
// Grand total head
echo "\t<tr>";
echo "\t\t<td align='right' style='font-weight:bold;'>Grand Total:</td>";
echo "\t\t<td><span style='text-align:left; float:left; padding-left:20px; font-weight:bold'>" . number_format($Grand_Total_Debit) . "</span><span style='text-align:right; float:right; font-weight:bold'>" . number_format($Grand_Total_Credit) . "</span></td>";
echo "\t\t<td><span style='text-align:left; float:left; padding-left:20px; font-weight:bold'>" . number_format($Grand_TR_Total_Debit) . "</span><span style='text-align:right; float:right; font-weight:bold'>" . number_format($Grand_TR_Total_Credit) . "</span></td>";
echo "\t\t<td><span style='text-align:left; float:left; padding-left:20px; font-weight:bold'>0</span><span style='text-align:right; float:right; font-weight:bold'>" . number_format($Grand_Total_Closing) . "</span></td>";
echo "\t</tr>";
}
ProfileBar();
?>
</ul>
<nav>
<div class="nav-wrapper grey darken-3">
<!--<a href="#!" class="brand-logo">Logo</a>-->
<a href="#" data-activates="mobile-demo" class="button-collapse"><i class="mdi-navigation-menu"></i></a>
<ul class="left hide-on-med-and-down">
<?php
NavBar();
?>
</ul>
<ul class="right hide-on-med-and-down">
<?php
AdminEntry();
?>
<li><a class="dropdown-button" href="#!" data-activates="dropdown1" style="text-indent: .5em;"><?php
AccountName();
?>
<i class="mdi-navigation-expand-more right "></i></a></li>
</ul>
<ul class="side-nav" id="mobile-demo">
<?php
NavBar();
?>
</ul>
</div>
</nav>
