BankingSystem/JMEAgentSystem/Scripts/ReferralReports/ViewStatement.js

$("#searchStatement").click(function () {
    $("#loadingDiv").LoadingOverlay("show");
    reqField = "fromDate,toDate";
    if (ValidRequiredField(reqField) === false) {
        return false;
    }
    $('#searchStatement').attr('disabled', true);
    var dataObject = {
        MethodName: 'ViewStatement',
        FromDate: $('#' + mId + 'fromDate').val(),
        ToDate: $('#' + mId + 'toDate').val()
    };

    url = '';
    $.post(url, dataObject, function (data) {
        var count = 1;
        var runningBalance = 0;
        var openingBalance = 0;
        var totalDr = 0;
        var drCount = 0;
        var crCount = 0;
        var totalCr = 0;
        var amount = 0;
        var arrayData = [];
        var table = $('#statementReportTbl');
        table.find("tbody tr").remove();

        $('#searchStatement').attr('disabled', false);
        var result = data;//jQuery.parseJSON(data);
        $.each(result, function (i, d) {
            if (d['JMENumber'] != 'Balance Brought Forward') {
                if (d['TranType'].toLowerCase() == 'dr') {
                    totalDr += parseFloat(d['Amount']);
                    drCount++;
                }
                else {
                    totalCr += parseFloat(d['Amount']);
                    crCount++;
                }
            }
            else {
                openingBalance = d['Amount'];
            }

            runningBalance += parseFloat(d['Amount']);

            arrayData.push({
                "SNo": count,
                "TranDate": d['TranDate'],
                "JMENumber": d['JMENumber'],
                "SenderName": d['SenderName'],
                "TransactionAmount": CurrencyFormatted(parseFloat(d['Amount'])),
                "RunningBalance": CurrencyFormatted(runningBalance)
            });
            count++;
        });

        table.DataTable().destroy();
        table.DataTable({
            data: arrayData,
            dom: 'Bfrtip',
            responsive: true,
            paging: false,
            ordering: false,
            info: false,
            buttons: [
                //'excelHtml5',
                'pdfHtml5',
                'print'
            ],
            columns: [
                { "data": "SNo" },
                { "data": "TranDate" },
                { "data": "JMENumber" },
                { "data": "SenderName" },
                { "data": "TransactionAmount" },
                { "data": "RunningBalance" }
            ]
        });

        $('#openingBalance').text(CurrencyFormatted(openingBalance));
        $('#totalCrCount').text(crCount);
        $('#totalCR').text(CurrencyFormatted(totalCr));
        $('#totalDrCount').text(drCount);
        $('#totalDR').text(CurrencyFormatted(totalDr));
        if (runningBalance > 0) {
            $('#DrOrCr').text('CR');
        }
        else {
            $('#DrOrCr').text('DR');
        }
        $('#closingBalance').text(CurrencyFormatted(runningBalance));

        $("#loadingDiv").LoadingOverlay("hide", true);
    }).fail(function () {
        $("#loadingDiv").LoadingOverlay("hide", true);

        swal(result.Msg, "Error Occured", "error");
    });
});

//Textbox with Comma Separation
function CurrencyFormatted(amount) {
    var i = parseFloat(amount);
    if (isNaN(i)) { i = 0.00; }
    var minus = '';
    if (i < 0) { minus = '-'; }
    i = Math.abs(i);
    i = parseInt((i + .005) * 100);
    i = i / 100;
    s = new String(i);
    if (s.indexOf('.') < 0) { s += '.00'; }
    if (s.indexOf('.') == (s.length - 2)) { s += '0'; }
    //s = minus + s;

    //if (amount < 0)
    //    s = -1 * amount;

    return CommaFormatted(s, amount);
}

function CommaFormatted(amount, amountMain) {
    var delimiter = ",";
    var a = amount.split('.', 2);
    var d = a[1];
    var i = parseInt(a[0]);
    if (isNaN(i)) { return ''; }
    var minus = '';
    if (i < 0) { minus = '-'; }
    i = Math.abs(i);
    var n = new String(i);
    var a = [];
    while (n.length > 3) {
        var nn = n.substr(n.length - 3);
        a.unshift(nn);
        n = n.substr(0, n.length - 3);
    }
    if (n.length > 0) { a.unshift(n); }
    n = a.join(delimiter);
    if (d.length < 1) { amount = n; }
    else { amount = n + '.' + d; }
    amount = minus + amount;

    if (amountMain < 0)
        return "(" + amount + ")";
    else
        return amount;
}
$(document).on('click', '.cmdPdf', function () {
    var prtContent = document.getElementById('mainFrame');
    var html = prtContent.contentWindow.document.getElementById("main").innerHTML;
    //alert(html);
    if (prtContent == null || prtContent == "" || prtContent == undefined) {
        return false;
    }
    window.open('data:application/vnd.ms-excel,' + encodeURIComponent(html));
});