@extends('layouts.sidik')

@section('content')
    <div class="row mt-5 justify-content-center">
        
        <div class="col-md-10">
            <div class="card-deck">
                
                <div class="card p-3">
                    <center>
                          <h3>Informasi Berkala <br> Data Keuangan Provinsi Kalimantan Timur</h3>
                          
                            
                    </center>
                </div>
            </div>
        </div>
    </div>
    
    <div class="row mt-5 justify-content-center">
        
        <div class="col-md-12">
            <div class="card-deck">
                
                <div class="card ">
                    <div style="overflow-x:scroll;max-height:500px;">
                        <table cellpadding="0" cellspacing="0" border="0" class="dTableAjax table table-bordered table-hover table-condensed" id="keuangan">
                    		<thead>
                            <tr>
                    			<th rowspan="2" class="text-center">ELEMEN DATA</th>
                                <th colspan="5" class="text-center">DATA TAHUN</th>
                                <th rowspan="2" class="text-center">SATUAN</th>
                                
                                <th rowspan="2" class="text-center">UPDATE TERAKHIR</th>
                                
                    		</tr>
                            <tr>
                                <th class="text-center">2014</th>
                                <th class="text-center">2015</th>
                                <th class="text-center">2016</th>
                                <th class="text-center">2017</th>
                                <th class="text-center">2018</th>
                            </tr>
                            </thead>
                    		<tbody></tbody>
                    	</table>
                    </div>
                    <center>
                        <center>
                        Sumber Data :
                        <a href="https://sidata.kaltimprov.go.id" style="color:blue;" target="_blank">Sidata Kaltim</a>
                        
                    </center>
                        
                    </center>
                    
                </div>
                
                
            </div>
        </div>
    </div>


<script>
    var dataJson = JSON.parse('<br />
<b>Warning</b>:  Undefined variable $data in <b>/home/aplikasiposinfo/public_html/ppid.aplikasipos.info/resources/views/sidik/keuangan.blade.php</b> on line <b>66</b><br />
null');
</script>
@endsection



@push('script')

<script>
    $(document).ready(function() {
        function formatMoneyNoDecimal (val, type, full) {
    		var places = 0;
    		var symbol = "";
    		var thousand = ".";
    		var decimal = ",";
    		places = !isNaN(places = Math.abs(places)) ? places : 2;
    		symbol = symbol !== undefined ? symbol : "";
    		thousand = thousand || ",";
    		decimal = decimal || ".";
    		var number = val,
    			negative = number < 0 ? "-" : "",
    			i = parseInt(number = Math.abs(+number || 0).toFixed(places), 10) + "",
    			j = (j = i.length) > 3 ? j % 3 : 0;
    		return symbol + negative + (j ? i.substr(0, j) + thousand : "") + i.substr(j).replace(/(\d{3})(?=\d)/g, "$1" + thousand) + (places ? decimal + Math.abs(number - i).toFixed(places).slice(2) : "");
    };
    
    function formatMoneyNoDecimalNull (val, type, full) {
    		if (val==null) {
    		  return 'n/a';
    		}else {
            var places = 0;
    		var symbol = "";
    		var thousand = ",";
    		var decimal = ".";
    		places = !isNaN(places = Math.abs(places)) ? places : 2;
    		symbol = symbol !== undefined ? symbol : "";
    		thousand = thousand || ",";
    		decimal = decimal || ".";
    		var number = val,
    			negative = number < 0 ? "-" : "",
    			i = parseInt(number = Math.abs(+number || 0).toFixed(places), 10) + "",
    			j = (j = i.length) > 3 ? j % 3 : 0;
    		return symbol + negative + (j ? i.substr(0, j) + thousand : "") + i.substr(j).replace(/(\d{3})(?=\d)/g, "$1" + thousand) + (places ? decimal + Math.abs(number - i).toFixed(places).slice(2) : "");
            }
    };
        
    function formatMoney4Decimal (val, type, full) {
    	var places = 4;
    	var symbol = "";
    	var thousand = ",";
    	var decimal = ".";
    	places = !isNaN(places = Math.abs(places)) ? places : 4;
    	symbol = symbol !== undefined ? symbol : "";
    	thousand = thousand || ",";
    	decimal = decimal || ".";
    	var number = val,
    		negative = number < 0 ? "-" : "",
    		i = parseInt(number = Math.abs(+number || 0).toFixed(places), 10) + "",
    		j = (j = i.length) > 3 ? j % 3 : 0;
    	return symbol + negative + (j ? i.substr(0, j) + thousand : "") + i.substr(j).replace(/(\d{3})(?=\d)/g, "$1" + thousand) + (places ? decimal + Math.abs(number - i).toFixed(places).slice(2) : "");
    };
    
    function formatMoney2Decimal (val, type, full) {
    	var places = 2;
    	var symbol = "";
    	var thousand = ",";
    	var decimal = ".";
    	places = !isNaN(places = Math.abs(places)) ? places : 2;
    	symbol = symbol !== undefined ? symbol : "";
    	thousand = thousand || ",";
    	decimal = decimal || ".";
    	var number = val,
    		negative = number < 0 ? "-" : "",
    		i = parseInt(number = Math.abs(+number || 0).toFixed(places), 10) + "",
    		j = (j = i.length) > 3 ? j % 3 : 0;
    	return symbol + negative + (j ? i.substr(0, j) + thousand : "") + i.substr(j).replace(/(\d{3})(?=\d)/g, "$1" + thousand) + (places ? decimal + Math.abs(number - i).toFixed(places).slice(2) : "");
    };
    
    function formatMoney2DecimalInd (val, type, full) {
    	var places = 2;
    	var symbol = "";
    	var thousand = ".";
    	var decimal = ",";
    	places = !isNaN(places = Math.abs(places)) ? places : 2;
    	symbol = symbol !== undefined ? symbol : "";
    	thousand = thousand || ".";
    	decimal = decimal || ",";
    	var number = val,
    		negative = number < 0 ? "-" : "",
    		i = parseInt(number = Math.abs(+number || 0).toFixed(places), 10) + "",
    		j = (j = i.length) > 3 ? j % 3 : 0;
    	return symbol + negative + (j ? i.substr(0, j) + thousand : "") + i.substr(j).replace(/(\d{3})(?=\d)/g, "$1" + thousand) + (places ? decimal + Math.abs(number - i).toFixed(places).slice(2) : "");
    };
    
    function formatfloatnull(val,type,full) {
        if (val==null) {
    		  return 'n/a';
        }else if (val=="") {
            return "";
        }else if (val.indexOf('<input type') != -1) {
            return val;
        }
        else {
            var tmp = val.split(".");
            if (tmp.length == 1) return formatMoneyNoDecimal(tmp[0]);
            else {
                //var koma = Number(tmp[1]).toFixed(2);
                //return formatMoneyNoDecimal(tmp[0]) + "," + tmp[1];
                return formatMoney2DecimalInd(val);    
            } 
            
        }
    }
        var legendtext = '<span class="label" style="background-color:#010101">&nbsp;&nbsp;</span> ' +
                        'Tetap |&nbsp;' +
                        '<span class="label" style="background-color:#E9F004">&nbsp;&nbsp;</span> '+ 
                        'Aram |&nbsp;' +
                        '<span class="label" style="background-color:#4BE240">&nbsp;&nbsp;</span> '+  
                        'Sangat Sementara |&nbsp;'+
                        '<span class="label" style="background-color:#FF0101">&nbsp;&nbsp;</span> '+  
                        'Sementara |&nbsp;' +
                        '<span class="label" style="background-color:#0128FF">&nbsp;&nbsp;</span> '+  
                        'Proyeksi |&nbsp;' +
                        'n/a Tidak Ada';
        var oTable = $('#keuangan')
            .dataTable({
        	"data" : dataJson,
            "aoColumns": [
              { "mData": "uraian"},
              { "mData": "t_2014", "sClass": "text-right", "sWidth": "6%", "mRender": formatfloatnull  },
              { "mData": "t_2015", "sClass": "text-right", "sWidth": "6%", "mRender": formatfloatnull  },
              { "mData": "t_2016", "sClass": "text-right", "sWidth": "6%", "mRender": formatfloatnull  },
              { "mData": "t_2017", "sClass": "text-right", "sWidth": "6%", "mRender": formatfloatnull  },
              { "mData": "t_2018", "sClass": "text-right", "sWidth": "6%", "mRender": formatfloatnull  },
              { "mData": "satuan"},
              { "mData": "tglupdate", "sClass": "text-center", "sWidth": "125px"},
             
            ],
            "fnRowCallback": function( nRow, aData, iDisplayIndex, iDisplayIndexFull ) {
              if ( aData["level"] == "1" && aData["isprov"] == "1" )
              {
                    $('td', nRow).css('background-color', '#F9E7E7');
                    $('td', nRow).css('color','black');
              }
              
              if ( aData["isprov"] == "0" )
              {
                    $('td', nRow).css('background-color', '#EDFBF8');
                    $('td', nRow).css('color','black');
                    $('td', nRow).css('font-style','italic');
              }
              
              if ( aData["isprov"] == "3" )
              {
                    $('td', nRow).css('font-weight','bold');
              }
              
              if ( aData["isdata"] == "Y") {
                    //var st = parseInt(aData["level"]);
                    $('td', nRow).eq(5).css('color',aData["j_2014"]);
                    $('td', nRow).eq(6).css('color',aData["j_2015"]);
                    $('td', nRow).eq(7).css('color',aData["j_2016"]);
                    $('td', nRow).eq(8).css('color',aData["j_2017"]);
                    $('td', nRow).eq(9).css('color',aData["j_2018"]);
              }
              
            },
        	"sDom": "t<'row'<'col-sm-10 hidden-xs'i><'col-sm-2 col-xs-12 clearfix'>>",
            "oLanguage": {
                "sZeroRecords": "Tidak ada data yang ditampilkan",
                "sInfo": "<input type='text' class='text-center text-info' size='15px' readonly value='_TOTAL_ Elemen Data' />"
            },
        	"bPaginate": false,
            "bFilter": false,
        	"bJQueryUI": false,
            //"aaAutoWidth": true,
        	"bAutoWidth": false,
            "bSort" : false,
        	
            "fnDrawCallback": function( oSettings ) {
        		$(".grafik").click(function(){
        			var id = $(this).attr("id");
                    //alert(id);
                    $.post('https://sidata.kaltimprov.go.id/index.php/dataprofil/getdatagrafik',{id:id},function(result){  
                        if (result.errorMsg){     
                        } else {                
                            var newchartdata = result.rows;
                            var rows = result.rowcap;
                            var row = rows[0];
                            //if (row){
                            //satuan = row.satuan;
                            chart.dataProvider = newchartdata;
                            //satuan = row.satuan;
                            //chart.valueAxes = [{'title':'%'}];
                            chart.validateData();
                            $('#headchart').html('<h4>' + row.uraian + ' (' + row.satuan + ')</h4><h5>Unit Pengentri : ' + row.nm_unit + '</h5>');
                            $('#bodychart').html('<h6>' + row.an1 + '</h6><h6>' + row.an2 + '</h6><h6>' + row.an3 + '</h6><h6>' + row.an4 + '</h6>');
                            $('#ketchart').html('<h6>'+ row.catatan +'</h6>');
                            $('#dlgchart').modal('show');
                            //chart.dataProvider = newchartdata;
                            
                            //}
            			}
                    },'json');
        		});
        	}
        });
    });
</script>

@endpush