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>