{include file="sections/header.tpl"}

<div class="row">


    <div class="col-lg-12 col-md-12 col-sm-12">
        <div class="ibox float-e-margins">
            <div class="ibox-title">
                <h5>{$_L['Reports by Date']} </h5>

            </div>
            <div class="ibox-content">

                <div id="dpx"></div>

                <div id="result">
                    <h4>{$_L['Total Income']}: {$_c['currency_code']} {number_format($cr,2,$_c['dec_point'],$_c['thousands_sep'])}</h4>
                    <h4>{$_L['Total Expense']}: {$_c['currency_code']} {number_format($dr,2,$_c['dec_point'],$_c['thousands_sep'])}</h4>

                    <hr>
                    <h4>{$_L['All Transactions at Date']}: <span id="tdate">{date( $_c['df'], strtotime($mdate))}</span> </h4>
                    <hr>
                    <table class="table table-striped table-bordered table-responsive">

                        <th>{$_L['Account']}</th>
                        <th>{$_L['Type']}</th>
                        <th class="hidden-xs hidden-sm">{$_L['Category']}</th>
                        <th class="text-right">{$_L['Amount']}</th>
                        <th class="hidden-xs hidden-sm hidden-md">{$_L['Payer']}</th>
                        <th class="hidden-xs hidden-sm hidden-md">{$_L['Payee']}</th>
                        <th class="hidden-xs hidden-sm hidden-md">{$_L['Method']}</th>
                        <th class="hidden-xs hidden-sm hidden-md">{$_L['Ref']}</th>
                        <th>{$_L['Description']}</th>
                        <th class="text-right">{$_L['Dr']}</th>
                        <th class="text-right">{$_L['Cr']}</th>
                        <th class="text-right">{$_L['Balance']}</th>

                        {foreach $d as $ds}
                            <tr>

                                <td>{$ds['account']}</td>
                                {*<td>{$ds['type']}</td>*}
                                <td>{ib_lan_get_line($ds['type'])}</td>
                                <td>{if $ds['category'] == 'Uncategorized'}{$_L['Uncategorized']} {else} {$ds['category']} {/if}</td>
                                <td class="text-right">{$_c['currency_code']} {number_format($ds['amount'],2,$_c['dec_point'],$_c['thousands_sep'])}</td>
                                <td class="hidden-xs hidden-sm hidden-md">{$ds['payer']}</td>
                                <td class="hidden-xs hidden-sm hidden-md">{$ds['payee']}</td>
                                <td class="hidden-xs hidden-sm hidden-md">{$ds['method']}</td>
                                <td class="hidden-xs hidden-sm hidden-md">{$ds['ref']}</td>
                                <td>{$ds['description']}</td>
                                <td class="text-right">{$_c['currency_code']} {number_format($ds['dr'],2,$_c['dec_point'],$_c['thousands_sep'])}</td>
                                <td class="text-right">{$_c['currency_code']} {number_format($ds['cr'],2,$_c['dec_point'],$_c['thousands_sep'])}</td>
                                <td class="text-right"><span {if $ds['bal'] < 0}class="text-red"{/if}>{$_c['currency_code']} {number_format($ds['bal'],2,$_c['dec_point'],$_c['thousands_sep'])}</span></td>

                            </tr>
                        {/foreach}



                    </table>
                </div>


            </div>
        </div>
    </div>



    <!-- Widget-2 end-->
</div>


<input type="hidden" id="_lan_i18n" value="{Ib_I18n::get_code($_c['language'])}">
{include file="sections/footer.tpl"}