<?php $this->load->view("common/header"); ?>

<link rel="stylesheet" href="<?php echo asset_url(); ?>css/jquery.dataTables.min.css">
<style type="text/css">
/* .table-striped > tbody > tr:nth-child(2n+1) > td, .table-striped > tbody > tr:nth-child(2n+1) > th */
/* .table-striped > tbody tr.odd > .sorting_1, table.dataTable.order-column.stripe tbody tr.odd > .sorting_1 ,
.table-striped > tbody tr.odd > td:nth-child(9) {
	background-color: #f1f1f1 !important;
} */
.table-striped > tbody > tr:nth-child(2n+1) > td {
	background-color: #f1f1f1 !important;
}
.table > thead:first-child > tr:first-child > th, .table > thead:first-child > tr:first-child > td, .table-striped thead tr.primary:nth-child(2n+1) th{
    background-color: #fff;
	border-color: #fff;
	border-bottom: 1px solid #357ebd;
	color: #000;
	text-align: center;
}
</style>
<!-- end: CSS REQUIRED FOR THIS PAGE ONLY -->
<!-- end: HEAD -->
<!-- start: BODY -->

<body onLoad="colapseMe()">
    <!-- start: HEADER -->
    <div class="navbar navbar-inverse navbar-fixed-top">
        <!-- start: TOP NAVIGATION CONTAINER -->
        <div class="container">
            <div class="navbar-header">
                <!-- start: RESPONSIVE MENU TOGGLER -->
                <button data-target=".navbar-collapse" data-toggle="collapse" class="navbar-toggle" type="button"> <span class="clip-list-2"></span> </button>
                <!-- end: RESPONSIVE MENU TOGGLER -->
                <!-- start: LOGO -->
                <?php $this->load->view("common/logo"); ?>
                <!-- end: LOGO -->
            </div>
            <div class="navbar-tools">
                <!-- start: TOP NAVIGATION MENU -->
                <?php $this->load->view("common/notifications.php"); ?>
                <!-- end: TOP NAVIGATION MENU -->
            </div>
        </div>
        <!-- end: TOP NAVIGATION CONTAINER -->
    </div>
    <!-- end: HEADER -->
    <!-- start: MAIN CONTAINER -->
    <div class="main-container">
        <div class="navbar-content">
            <!-- start: SIDEBAR -->
            <?php $this->load->view("common/navigation"); ?>
            <!-- end: SIDEBAR -->
        </div>
        <!-- start: PAGE -->
        <div class="main-content">
            <!-- end: SPANEL CONFIGURATION MODAL FORM -->
            <div class="container">
                <!-- start: PAGE HEADER -->
                <div class="row">
                    <div class="col-sm-12">
                        <!-- start: PAGE TITLE & BREADCRUMB -->
                        <ol class="breadcrumb">
                            <li> <a href="<?php echo base_url('dashboard'); ?>"> Dashboard </a> </li>
                            <li> <a href="#"> Reports </a> </li>
                            <li class="active"> Cash Report </li>
                            <li class="search-box">
                                <form class="sidebar-search">
                                    <div class="form-group">
                                        <input type="text" placeholder="Start Searching...">
                                        <button class="submit"> <i class="clip-search-3"></i> </button>
                                    </div>
                                </form>
                            </li>
                        </ol>
                        <div class="page-header">
                            <h1>Supplier Account Payable Report</h1>
                        </div>
                        <p>Please use the table below to navigate or filter the results. </p>
                    </div>
                </div>
                <!-- end: PAGE HEADER -->
                <!-- start: PAGE CONTENT -->
                <!-- start grid -->
                <div class="row">
                    <div class="col-md-12">
                        <!-- start: DYNAMIC TABLE PANEL -->
                        <div class="panel panel-default">
                            <div class="panel-heading"> <i class="fa fa-external-link-square"></i> User Payments
                                <div class="panel-tools" style="top:2px;">
                                    <!--<button onClick="JavaScript:fbs_click('<?php echo base_url('reports/print_sale?srh_warehouse_id=1'); ?>');" class="btn btn-blue dropdown-toggle" data-toggle="dropdown">
													<i class="fa fa-print"></i>
												</button>-->

                                </div>
                            </div>
                        </div>
                        <div class="panel-body">
                            <div id="error"></div>
                            <div class="col-md-12">
                                <div class="panel panel-default">
                                    <div style="font-weight: 700;" class="panel-heading"></div>
                                    <div class="panel-body">
                                        <div class="col-sm-4">
                                            <div class="form-group">
                                                <?php

                                                $ss_group_id = $this->session->userdata('ss_group_id');
                                                //echo $ss_group_id;
                                                if ($ss_group_id == 1) { ?>
                                                    <label>Warehouse </label>
                                                    <select id="srh_warehouse_id" class="form-control" name="srh_warehouse_id">
                                                        
                                                        <option value="">-All-</option>
                                                        <?php
                                                        $ss_warehouse_id = $this->session->userdata('ss_warehouse_id');
                                                        foreach ($warehouse_list as $row) {
                                                            $sel = '';
                                                            if ($ss_warehouse_id == $row->id) {
                                                                $sel = ' selected="selected"';
                                                            }
                                                        ?>
                                                            <option value="<?php echo $row->id; ?>" <?php //echo $sel; ?>> <?php echo $row->name; ?> </option>
                                                        <?php } ?>
                                                    </select>
                                                <?php } else if ($ss_group_id == 3) {

                                                ?>
                                                    <input name="srh_warehouse_id" type="hidden" value="<?php echo $this->session->userdata('ss_warehouse_id'); ?>">
                                                <?php } ?>
                                            </div>
                                        </div>
                                        <div class="col-sm-4">
                                            <div class="form-group">

                                                <label>Supplier *</label>
                                                <select id="supplier" name="supplier" class="form-control search-select">
                                                    <option value="">&nbsp;</option>
                                                    <?php foreach ($suppliers as $key => $sup) {
                                                        //print_r($sup);

                                                        echo "<option value=" . $sup['supp_id'] . ">" . $sup['supp_company_name'] . "</option>";
                                                    } ?>
                                                </select>

                                            </div>
                                        </div>
                                        <div class="col-sm-4" style="min-height: 90px;"></div>

                                        <!-- <div class="col-sm-4">
                                            <div class="form-group">
                                                <label>Type </label>
                                                <select id="srh_type" class="form-control" name="srh_type">
                                                    <option value="">-- Select --</option>
                                                    <option value="sale"> Sales </option>
                                                    <option value="sales_return"> Sales Return </option>
                                                </select>
                                            </div>
                                        </div> -->
                                        <!-- <div class="col-sm-4">
                                            <div class="form-group">
                                                <label>Payment Term </label>
                                                <select id="srh_payment_term" class="form-control" name="srh_payment_term">
                                                    <option value="">-- Select --</option>
                                                    <option value="Cash"> Cash </option>
                                                    <option value="Cheque"> Cheque </option>
                                                    <option value="Return Payment"> Return Payment </option>
                                                    <option value="Credit Card"> Credit Card </option>
                                                </select>
                                            </div>
                                        </div> -->
                                        <div class="col-sm-4" style="display:none">
                                            <div class="form-group">
                                                <label>From Date </label>
                                                <!--<input id="srh_from_date" name="srh_from_date" type='text' class="form-control date" value="" data-bv-field="date"/>                    -->

                                                <input id="srh_from_date" name="srh_from_date" type='text' class="form-control date-picker" value="" data-bv-field="date" />
                                                <?php //echo date('m/d/Y', strtotime('-1 day', strtotime(date('m/d/Y')))); 
                                                ?>
                                            </div>
                                        </div>
                                        <div class="col-sm-4" style="display:none">
                                            <div class="form-group">
                                                <label for="s2id_autogen1">To Date </label>

                                                <!--<input id="srh_to_date" name="srh_to_date" type='text' class="form-control date" value="" data-bv-field="date"/>        -->

                                                <input id="srh_to_date" name="srh_to_date" type='text' class="form-control date-picker" value="<?php echo date('Y-m-d'); ?>" data-bv-field="date" />
                                            </div>
                                        </div>
                                        <div class="col-sm-4" style="display:none">
                                            <div class="form-group">
                                                <?php
                                                $ss_group_id = $this->session->userdata('ss_group_id');

                                                $disable = 'disabled';
                                                $collapse    = 'collapse';
                                                //if($ss_group_id ==1)
                                                {
                                                    $disable  = '';
                                                    $collapse = '';
                                                }

                                                ?>
                                                <input type="hidden" id="user_group" name="user_group" value=" <?php echo $ss_group_id ?>">
                                                <label>User </label>
                                                <select id="srh_user_id" class="form-control" name="srh_user_id" <?php //echo $disable 
                                                                                                                    ?>>
                                                    <option value=""> -Select- </option>
                                                    <?php
                                                    $ss_user_id = $this->session->userdata('ss_user_id');
                                                    foreach ($user_list as $row) {
                                                        $sel = '';
                                                        if ($ss_user_id == $row->user_id) {
                                                            //$sel=' selected="selected"';
                                                        }
                                                    ?>
                                                        <option value="<?php echo $row->user_id; ?>" <?php echo $sel; ?>> <?php echo $row->user_first_name; ?> </option>
                                                    <?php } ?>
                                                </select>
                                            </div>
                                        </div>

                                        <div class="col-sm-4 pull-right">
                                            <div class="form-group">
                                                <label for="s2id_autogen1">&nbsp;<br>
                                                    <br>
                                                </label>
                                                <input type="submit" name="add_category" value="Search" class="btn btn-primary" onClick="searchDetails()">
                                                &nbsp;&nbsp;
                                                <input type="submit" name="add_category" value="Reset" class="btn btn-danger" onClick="searchDetailsReset()">
                                                &nbsp;&nbsp;

                                                <!--  <input onClick="print_booking_report();" type="submit" name="add_category" value="Print" class="btn btn-success">-->

                                            </div>
                                        </div>
                                    </div>
                                </div>
                                <button class="btn btn-blue dropdown-toggle" data-toggle="dropdown" id="excel"> <i class="fa fa-fw" aria-hidden="true" title="Copy to use file-excel-o"></i> </button>
                                <button onClick="printDiv('printableArea')" class="btn btn-blue dropdown-toggle" data-toggle="dropdown"> <i class="fa fa-print"></i> </button>

                                <!-- <input type="button" class="pull-right" value="Print Cash Report" onClick="printDiv('printableArea')">-->
                                <br>
                                <br>
                                <?php //echo '<pre>';print_r($warehouse); echo '</pre>';

                                //print_r( $this->session->userdata['ss_warehouse_id']);

                                ?>
                                <div id="ExcelArea">
                                    <div id="printableArea">
                                        <div class="page-header">
                                            <h1>Supplier Account Payable Report</h1>
                                            <button style="display:none" value="hello" data-toggle="collapse" data-onstyle="success" data-size="small" data-target="#not_for_sales_staff" />
                                        </div>
                                        <table id="" class="table table-bordered table-condensed table-hover table-striped dataTable" style="display:none">
                                            <tbody>
                                                <tr>
                                                    <td></td>
                                                    <td class="text-right">From Date: <span id="f-date-txt"></span>, To Date: <span id="t-date-txt"></span></td>
                                                </tr>
                                                <tr>
                                                    <th width="50%">Sales Total Received Amount</th>
                                                    <td width="50%">
                                                        <div id="sales_summ_tbl">0.00</div>
                                                    </td>
                                                </tr>
                                                <tr class="">
                                                    <th>Cash</th>
                                                    <td>
                                                        <div id="cash_summ_tbl">0.00</div>
                                                    </td>
                                                </tr>
                                                <tr class="">
                                                    <th>Credit Card</th>
                                                    <td>
                                                        <div id="credit_card_summ_tbl">0.00</div>
                                                    </td>
                                                </tr>
                                                <tr class="">
                                                    <th>Cheque</th>
                                                    <td>
                                                        <div id="cheque_summ_tbl">0.00</div>
                                                    </td>
                                                </tr>
                                                <tr class="">
                                                    <th>Credit Card Interest</th>
                                                    <td>
                                                        <div id="credit_card_int_summ_tbl">0.00</div>
                                                    </td>
                                                </tr>
                                                <tr class="">
                                                    <th width="50%">Sales Return</th>
                                                    <td width="50%">
                                                        <div id="sales_return_tbl">0.00</div>
                                                    </td>
                                                </tr>
                                                <tr class="" style="display:none">
                                                    <th width="50%">GRN</th>
                                                    <td width="50%">
                                                        <div id="sales_grn_tbl">0.00</div>
                                                    </td>
                                                </tr>
                                                <tr class="" style="display:none">
                                                    <th width="50%">GRN Return</th>
                                                    <td width="50%">
                                                        <div id="sales_return_grn_tbl">0.00</div>
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <th>Expenses</th>
                                                    <td>
                                                        <div id="exp_summ_tbl">0.00</div>
                                                    </td>
                                                </tr>
                                                <!-- <tr>
                    <th>Sales Return </th>
                    <td><div id="sales-rtn-cost-tbl">0.00</div></td>
                    </tr>-->
                                                <tr>
                                                    <th>Service</th>
                                                    <td>
                                                        <div id="ser_summ_tbl">0.00</div>
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <th>Cash in Hand</th>
                                                    <td>
                                                        <div id="cash_in_hand_tbl_2">0.00</div>
                                                    </td>
                                                </tr>
                                            </tbody>
                                        </table>
                                    </div>
                                    <br>
                                    <br>
                                    <div class="panel-heading"> <i class="fa fa-external-link-square"></i> Supplier Account Payable Report </div>
                                    <div>&nbsp;</div>
                                    <table width="100%" class="table  table-condensed table-hover table-striped dataTable" id="warehouse_table">
                                        <thead>
                                            <tr>
                                                <th>Date</th>
                                                <th>GRN / Return</th>
                                                <th>Ref. No.</th>
                                                <th>Payment Method</th>
                                                <th>Purchased Amount</th>
                                                <th>Returned Amount</th>
                                                <th>Paid Amount</th>
                                                <th>Return Amount</th>
                                                <th>Sup Adj </th>
                                                <th>Sup Adj Pay</th>
                                                 <th>Addition</th>
                                                  <th>Diduction</th>
                                                <th>Balance</th>
                                                <!--<th>Customer</th>-->
                                                <!-- <th class="text-right" style="text-align:right !important;">Date</th>
                                                <th class="text-right" style="text-align:right !important;">GRN / Return</th>
                                                <th class="text-right" style="text-align:right !important;">Ref. No.</th>
                                                <th class="text-right" style="text-align:right !important;">Payment Ref.No</th>
                                                <th class="text-right" style="text-align:right !important;">Purchased Amount</th>
                                                <th class="text-right" style="text-align:right !important;">Paid Amount</th>
                                                <th class="text-right" style="text-align:right !important;">Return Amount</th>
                                                <th class="text-right" style="text-align:right !important;">Balance</th> -->
                                            </tr>
                                        </thead>
                                        <tfoot>
                                            <tr>
                                                <th>&nbsp;</th>
                                                <th>&nbsp;</th>
                                                <th>&nbsp;</th>
                                                <th>&nbsp;</th>
                                                <th>&nbsp;</th>
                                                <th>&nbsp;</th>
                                                <th>&nbsp;</th>
                                                <th>&nbsp;</th>
                                                <th>&nbsp;</th>
                                                <th>&nbsp;</th>
                                                <th>&nbsp;</th>
                                                <th>&nbsp;</th>
                                                <th>&nbsp;</th>
                                                <!-- <th>&nbsp;</th>
                                                <th>&nbsp;</th> -->
                                            </tr>
                                        </tfoot>
                                    </table>
                                    <div>&nbsp;</div>
                                </div>
                                <br>
                                <br>
                            </div>

                            <!-- end: DYNAMIC TABLE PANEL -->
                        </div>
                    </div>

                    <!-- end grid -->

                    <input name="" id="credit_card_summ_fld" type="hidden">
                    <input name="" id="cheque_summ_fld" type="hidden">
                    <input name="" id="credit_card_int_summ_tbl" type="hidden">
                    <input name="" id="sales_summ_fld" type="hidden">
                    <input name="" id="sales_rtn_summ_fld" type="hidden">
                    <input name="" id="grn_summ_fld" type="hidden">
                    <input name="" id="grn_return_summ_fld" type="hidden">
                    <input name="" id="exp_summ_fld" type="hidden">
                    <input name="" id="ser_summ_fld" type="hidden">
                </div>
                <!-- end: PAGE -->
            </div>
            <!-- end: MAIN CONTAINER -->
            <!-- start: FOOTER -->
            <div class="footer clearfix">
                <div class="footer-inner"> </div>
                <div class="footer-items"> <span class="go-top"><i class="clip-chevron-up"></i></span> </div>
            </div>
            <!-- end: FOOTER -->
            <!-- start: RIGHT SIDEBAR -->
            <!-- end: RIGHT SIDEBAR -->
            <div id="event-management" class="modal fade" tabindex="-1" data-width="760" style="display: none;">
                <div class="modal-dialog">
                    <div class="modal-content">
                        <div class="modal-header">
                            <button type="button" class="close" data-dismiss="modal" aria-hidden="true"> &times; </button>
                            <h4 class="modal-title">Event Management</h4>
                        </div>
                        <div class="modal-body"></div>
                        <div class="modal-footer">
                            <button type="button" data-dismiss="modal" class="btn btn-light-grey"> Close </button>
                            <button type="button" class="btn btn-danger remove-event no-display"> <i class='fa fa-trash-o'></i> Delete Event </button>
                            <button type='submit' class='btn btn-success save-event'> <i class='fa fa-check'></i> Save </button>
                        </div>
                    </div>
                </div>
            </div>

            <!-- start ajax model -->
            <div id="ajax-modal" class="modal fade" data-backdrop="static" data-keyboard="false" tabindex="-1" style="display: none;"></div>
            <!-- end ajax model -->

            <!-- start: MAIN JAVASCRIPTS -->
            <?php $this->load->view("common/footer"); ?>
            <script src="<?php echo asset_url(); ?>js/jquery-ui.js"></script>
            <script src="<?php echo asset_url(); ?>js/moment-with-locales.js"></script>
            <script type="text/javascript" language="javascript" src="<?php echo asset_url(); ?>js/bootstrap-datetimepicker.js"></script>
            <script type="text/javascript" language="javascript" src="<?php echo asset_url(); ?>js/bootbox.min.js"></script>
            <!-- <script type="text/javascript" language="javascript" src="<?php echo asset_url(); ?>js/accounting.js"></script> -->
            <script type="text/javascript" language="javascript" src="<?php echo asset_url(); ?>js/accounting.min.js"></script>
            <!-- end: MAIN JAVASCRIPTS -->
            <script type="text/javascript" language="javascript" src="<?php echo asset_url(); ?>js/jquery.dataTables.min.js"></script>
            <script type="text/javascript" language="javascript" src="<?php echo asset_url(); ?>js/dataTables.bootstrap.min.js"></script>
            <script type="text/javascript" language="javascript" src="<?php echo asset_url(); ?>js/dataTables.buttons.min.js"></script>
            <script type="text/javascript" language="javascript" src="<?php echo asset_url(); ?>js/buttons.print.min.js"></script>
            <script type="text/javascript" language="javascript" src="<?php echo asset_url(); ?>js/buttons.flash.min.js"></script>
            <script type="text/javascript" language="javascript" src="<?php echo asset_url(); ?>js/jszip.min.js"></script>
            <script type="text/javascript" language="javascript" src="<?php echo asset_url(); ?>js/pdfmake.min.js"></script>
            <script type="text/javascript" language="javascript" src="<?php echo asset_url(); ?>js/vfs_fonts.js"></script>
            <script type="text/javascript" language="javascript" src="<?php echo asset_url(); ?>js/buttons.html5.min.js"></script>
            <!-- <script type="text/javascript" language="javascript" src="<?php echo asset_url(); ?>js/sum.js"></script> -->
            <script>
                function searchDetailsReset() {
                    $('#srh_to_date').val('');
                    $('#srh_from_date').val('');
                }

                function searchDetails() {
                    loadGrid();
                    //loadexpenses();
                }
                //fu//nction loadexpenses(){
                //}
                
                function loadGrid() {
                    var table;
                    var srh_from_date = $('#srh_from_date').val();
                    var srh_to_date = $('#srh_to_date').val();
                    $('#f-date-txt').text(srh_from_date);
                    $('#t-date-txt').text(srh_to_date);
                    var srh_warehouse_id = $('#srh_warehouse_id').val();
                    var srh_type = $('#srh_type').val();
                    var srh_payment_term = $('#srh_payment_term').val();
                    var ss_user_id = $('#srh_user_id').val();
                    var supplier_id = $('#supplier').val();
                    if(!supplier_id){bootbox.alert("Please select supplier first!"); return false;}
                    //	alert(ss_user_id);
                    
                    var s_data = $('#supplier').select2('data');



                    var message = "<div  style='text-align:center'>  <h4><?php echo $warehouse['name']; ?></h4><?php echo $warehouse['address']; ?>, Phone: <?php echo $warehouse['phone']; ?> <br/> Email: <?php echo $warehouse['email']; ?><br/><h4>Supplier Ledger :"+s_data.text+  "</h4></div>";
                    table = $('#warehouse_table').DataTable({
                        dom: 'Blfrtip',
                        columnDefs: [
    { className: 'text-right', targets: [4,5,6,7, 8,9,10,11,12] },
  //  { className: 'text-center', targets: [5] },
  ],
                        buttons: [{
                            extend: 'print',
                            text: 'Print',
                            footer: true,
                            messageTop: function() {
                                return message;
                            },
                            message: message,
                            customize: function(win) {
                                $(win.document.body).find('h1')
                                    .css('display', 'none');
                            }
                            //autoPrint: false
                        }, {
                            extend: 'excel',
                            text: 'Save as Excel',
                            footer: true
                        }, {
                            extend: 'pdf',
                            text: 'Save as Pdf',
                            footer: true
                        }, ],
                        "ajax": {
                            'type': 'POST',
                            'url': '<?php echo base_url('reports/get_supplier_data_for_report'); ?>',
                            'data': {
                                srh_from_date: srh_from_date,
                                srh_to_date: srh_to_date,
                                srh_warehouse_id: srh_warehouse_id,
                                /* srh_type: srh_type,
                                srh_payment_term: srh_payment_term, */
                                ss_user_id: ss_user_id,
                                supplier_id: supplier_id
                            },
                            'done':function(){
                                alert();
                            }
                        },
                        "bDestroy": true,
                        "iDisplayLength": -1,
                        "order": [
                            [0, "asc"]
                        ],
                        "lengthMenu": [
                            [-1, 25, 50, -1],
                            ["All", 25, 50, "All"]
                        ]
                        ,
                        "fnFooterCallback": function(nRow, aaData, iStart, iEnd, aiDisplay) {
                            /**
                            
                            
                             */
                            /* setTimeout(()=>{
                                var tr = document.getElementById("warehouse_table").rows;
                                
                                console.log(tr[1].cells[0]);

$(tr[0].cells[0]).text("SSS");

                            },2000) */

                            



                            

                            //console.log(aaData);

                            var pay_total = 0;
                            var cash_total = 0;
                            var cheque_total = 0;
                            var cc_total = 0;
                            var sales_grn_tot = 0;
                            var cash_summ = 0;
                            var credit_card_int_summ = 0;
                            var total_10=0;
                            var total_11=0;
                            var total_4=0;
                            var total_5=0;
                            //var sales_rtn=0;
                            for (var i = 0; i < aaData.length; i++) {
                                pay_total += parseFloat(aaData[[i]][6].replace(",", ""));
                                cash_total += parseFloat(aaData[[i]][7].replace(",", ""));
                                cheque_total += parseFloat(aaData[[i]][8].replace(",", ""));
                                cc_total += parseFloat(aaData[[i]][9].replace(",", ""));
                                 total_10 += parseFloat(aaData[[i]][10].replace(",", ""));
                                   total_11 += parseFloat(aaData[[i]][11].replace(",", ""));
                                 total_4 += parseFloat(aaData[[i]][4].replace(",", ""));
                                 total_5 += parseFloat(aaData[[i]][5].replace(",", ""));


                            }
                            var nCells = nRow.getElementsByTagName('th');
                            nCells[6].innerHTML = '<div class="text-right">' + accounting.formatMoney(pay_total, "", 2, ",", ".") + ' </div>';
                            nCells[7].innerHTML = '<div class="text-right">' + accounting.formatMoney(cash_total, "", 2, ",", ".") + ' </div>';
                            nCells[8].innerHTML = '<div class="text-right">' + accounting.formatMoney(cheque_total, "", 2, ",", ".") + ' </div>';
                            nCells[9].innerHTML = '<div class="text-right">' + accounting.formatMoney(cc_total, "", 2, ",", ".") + ' </div>';
                            
                            //nCells[10].innerHTML = '<div class="text-right">' + accounting.formatMoney(total_10, "", 2, ",", ".") + ' </div>';
                            nCells[4].innerHTML = '<div class="text-right">' + accounting.formatMoney(total_4, "", 2, ",", ".") + ' </div>';
                            nCells[5].innerHTML = '<div class="text-right">' + accounting.formatMoney(total_5, "", 2, ",", ".") + ' </div>';
                            nCells[10].innerHTML = '<div class="text-right">' + accounting.formatMoney(total_10, "", 2, ",", ".") + ' </div>';
                            
                            nCells[11].innerHTML = '<div class="text-right">' + accounting.formatMoney(total_11, "", 2, ",", ".") + ' </div>';
 
                            /* for(var c = 0; c < aaData.length;c++){
                                var nCells = nRow.getElementsByTagName('th');
                            } */
                        }
                    });
                    
                    /*
                    
                    setTimeout(
  function() 
  {
   
                    $("html, body").animate({ 
                    scrollTop: $( 
                      'html, body').get(0).scrollHeight 
                }, 1000); 
                
  }, 3000
  */

                }

                function calculate_cah_in_hand() {}
                jQuery(document).ready(function() {
                    //calculate_cah_in_hand();
                    //TableData.init();
                    var tomorrow = new Date();
                    currentDate = tomorrow.setDate(tomorrow.getDate() - 30);
                    $('#srh_to_date').datetimepicker({
                        defaultDate: new Date(),
                        format: 'YYYY-MM-DD'
                    });
                    $('#srh_from_date').datetimepicker({
                       // defaultDate: new Date(),
                        format: 'YYYY-MM-DD'
                    });
                    //loadGrid(); //FormElements.init();

                    $('#supplier').select2();

                });

                function printDiv(divName) {
                    var printContents = document.getElementById(divName).innerHTML;
                    var originalContents = document.body.innerHTML;

                    document.body.innerHTML = printContents;

                    window.print();

                    document.body.innerHTML = originalContents;
                }
            </script>
            

            <!--<script type="text/javascript" src="http://code.jquery.com/jquery-1.9.0.js">            </script>-->
            <script type="text/javascript">
                $(function() {
                    $('#excel').click(function() {
                        var url = 'data:application/vnd.ms-excel,' + encodeURIComponent($('#ExcelArea').html())
                        location.href = url
                        return false
                    })
                })

                function colapseMe() {

                    //alert('test');
                }
            </script>
            <div id="log"> </div>
</body>
<!-- end: BODY -->

</html>