koperasi/script/lap/saldo.js

globalThis.acc = JSON.parse(_id('acc').innerHTML);
_id('tgl1').innerHTML = tanggal().normal2
_id('tgl2').innerHTML = tanggal().normal3

var d = _id('report').querySelector('tbody')

_id('filterpath').innerHTML = `
    <div style="display: block" width="600px;">
        <div style="display:grid; grid-gap:5px; grid-template-columns: 160px 100px 100px 80px">
            <select id="app" class="form-control mr-1">
                <option value="acc,usp">Induk & USP</option>
                <option value="acc">Induk</option>
                <option value="usp">USP</option>
            </select>
            <select id="bulan" class="form-control">
                <option value="">...</option>
                <option value="01">Januari</option>
                <option value="02">Februari</option>
                <option value="03">Maret</option>
                <option value="04">April</option>
                <option value="05">Mei</option>
                <option value="06">Juni</option>
                <option value="07">Juli</option>
                <option value="08">Agustus</option>
                <option value="09">September</option>
                <option value="10">Oktober</option>
                <option value="11">November</option>
                <option value="12">Desember</option>
            </select>
            <input id="tahun" class="form-control" placeholder="..." type="number" value="${tanggal().normal.split("-")[0]}" />
            <button id="play" class="btn btn-primary">
                <i class="la la-play"></i>
            </button>
        </div>
    </div>
`;

_id('bulan').value = tanggal().normal.split('-')[1];

var loader = function( callback ){
    d.innerHTML = (function(v){
        if(v === 'usp' || v === 'acc'){
            return acc.like('app', v);
        }
        return acc;
    })(_id('app').value).map(function (s) {
        if (s.dk == 'D') {
            return `
                    <tr>
                        <td>${s.kode}</td>
                        <td>${s.nama}</td>
                        <td>${s.dk}</td>
                        <td class="nmap" data-kode="${s.kode}" style="text-align:right; white-space:nowrap;">Rp. 0</td>
                        <td  style="text-align:right">-</td>
                    </tr>
                `;
        } else {
            return `
                    <tr>
                        <td>${s.kode}</td>
                        <td>${s.nama}</td>
                        <td>${s.dk}</td>
                        <td  style="text-align:right">-</td>
                        <td  style="text-align:right; white-space:nowrap;" class="nmap" data-kode="${s.kode}">Rp. 0</td>
                    </tr>
                `;
        }
    }).join('') + `
            <tr >
                <td colspan="3">Grand Total</td>
                <td  style="text-align:right; white-space:nowrap;" class="totald">Rp. 0</td>
                <td  style="text-align:right; white-space:nowrap;" class="totalk">Rp. 0</td>
            </tr>
        `;

    setTimeout(function(){
        callback();
    })
    
}

loader(function(){
    setTimeout(function(){
        loadData();
    },100)
})
    
_id('play').addEventListener('click', function(){
    loader(function () {
        setTimeout(function () {
            loadData();
        }, 100)
    })
});

function loadData() {
    _bbData(function (d) {
        var akunP = Array.from(document.querySelectorAll('td[data-kode]'))
        var totd = document.querySelector('td.totald')
        var totk = document.querySelector('td.totalk')
        var totDeb = 0;
        var totKre = 0;
        akunP.forEach(function (k) {
            var g = d.cond(k.dataset.kode, 'rek');
            if (g.length > 0) {
                g = g[0];
                var total = g.total.number(2);
                if (g.dk == 'D') {
                    totDeb += total
                } else {
                    totKre += total
                }
                k.innerHTML = total.rp(0);
            }
        })
        totd.innerHTML = totDeb.rp(0)
        totk.innerHTML = totKre.rp(0)
    }, function(){
        var day = tanggal(_id('tahun').value+'-'+_id('bulan').value).normal3;
        _id('tgl1').innerHTML = tanggal(day).normal2
        _id('tgl2').innerHTML = tanggal(day).normal3
        return ` WHERE lap_bb.tgl <= "${day}"  
        `;
    })
};


_id('print').addEventListener('click', function () {
    var layout = {
        "p": "a4portrait.css",
        "l": "a4landscape.css"
    }

    $('#report').printThis({
        // base: 'https://jasonday.github.io/printThis',
        header: null,               // prefix to html
        footer: null,
        importCSS: true,
        loadCSS: ["{{PATH}}/" + layout['p'], '{{PATH}}/assets/css/bootstrap.min.css'],
        header: false,
    });
}, false)