@extends('layouts.app')
@section('title', 'BWSI')

<style type="text/css">
    .box-body{
        padding-bottom: 0px !important;
    }   
    .select2-container--default .select2-selection--single .select2-selection__clear {
        display: none;
    }    
    #bills tbody tr td,
    #payables tbody tr td{
        border  : 1px solid #e0e0e0;
    }
</style>

@section('body')
<!-- <div class="box box-spinner"> -->
    <div class="row" style="padding-left:5px; padding-right:5px">
        <div class="box-header with-border">
            <h3 class="box-title">REFUND POSTING</h3>
        </div>
    </div>

    <div class="row">
        <div class="col-xs-12">
            <div class="box box-success">
                <div class="box-body">
                    @include('billing.rs.account')
                </div>
            </div>
        </div>
    </div>

    <div class="row" id="body" style="display: none;">
        <div class="col-xs-4" style="padding-left: 15px; padding-right: 0px;">
            <div class="box box-default" style="margin-top: -10px;">
    			<div class="box-header with-border">
    				<h3 class="box-title">UNPAID BILLS</h3>
    			</div>
                <div class="box-body" style="height: 380px;">
                    @include('billing.rs.bills')
                </div>
            </div>
        </div>
        <div class="col-xs-4" style="padding-right: 0px;">
            <div class="box box-default" style="margin-top: -10px;">
    			<div class="box-header with-border">
    				<h3 class="box-title">OTHER PAYABLES</h3>
    			</div>
                <div class="box-body" style="height: 380px;">
                    @include('billing.rs.payables')
                </div>
            </div>
        </div>  
        <div class="col-xs-4">
            <div class="box box-info" style="margin-top: -10px;">
                <div class="box-body" style="height: 420px;">
                    @include('billing.rs.summary')
                </div>
            </div>
        </div>       
    </div>
<!-- </div> -->
@endsection

@section('scripts')  
<script type="text/javascript">
	$(document).ready(function(){

            var BILLS_ID;
            var PAYABLES_ID;
            var BILLS_WITH_VALUE;
            var PAYABLES_WITH_VALUE;

            $('#acct_id').change(function(){
                var acctId = $(this).val();
                load_account_details(acctId);
            });

            $('#create-rs').click(function(){

                $.confirm({
                    title   : 'CREATE RS',
                    content : 'Do you want to proceed?',
                    type    : 'orange',
                    buttons : {
                        YES : function(){
                            post_rs();
                        },
                        NO  : function(){

                        }
                    },
                    draggable : true
                });

            });






            function post_rs(){
                var net = $('#np-val').text().includes('(') ? cleanUpCurrency($('#np-val').text()) : $('#np-val').text();
                var netAmount = cast(net);

                var reference = {
                    'bills'     : BILLS_ID,
                    'payables'  : PAYABLES_ID
                };

                var reference2 = {
                    'bills'     : BILLS_WITH_VALUE,
                    'payables'  : PAYABLES_WITH_VALUE
                };


                var data = {
                    'acct_id'       : $('#acct_id').val(),
                    'reference'     : reference,
                    'reference2'    : reference2,
                    'gdeposit'      : cast($('#gd-val').text()),
                    'bills'         : cast($('#unpaid_bills').text()),
                    'other_payables': cast($('#other_payables').text()),
                    'net_payable'   : netAmount < 0 ? netAmount : 0,
                    'net_refund'    : netAmount >= 0 ? netAmount : 0,
                    'remarks'       : $('#remarks').val(),
                    'jo_number'     : $('#do-number').text(),
                    'jo_date'       : $('#do-date').text()
                };


                $.ajax({
                    url  : $app_url + '/billing/refund-posting/post',
                    type : 'POST',
                    data : {
                        '_token' : $('[name=_token]').val(),
                        'data'   : data                        
                    },
                    success : function(response){                  
                        $.alert({
                            title     : 'RS POSTED!',
                            content   : 'You have successfully created refund slip.',
                            type      : 'blue',
                            draggable : true                        
                        });

                        $('#remarks').attr('readonly', true);
                        $('#create-rs').css('display', 'none');
                        $('div#slip-no').css('display', '');
                        $('span#slip-no').text(response);                        
                    },
                    error : function(xhr){
                        if(xhr.status != '422'){
                            $.alert({
                                title   : 'Oops, something went wrong!',
                                content : "<span style='font-size:20px' class='text-danger'>" 
                                            + xhr.status 
                                        + "</span>" + '&nbsp;&nbsp;' 
                                        + '<strong>'+xhr.statusText+'</strong>'
                                        + '<br />'
                                        + 'Refresh the page and try again.',
                                type    : 'red',
                                icon    : 'fa fa-warning',
                                draggable : true
                            });  
                        }                           
                    },
                    beforeSend : function(){
                        showBoxLoadingState();
                    },
                    complete : function(){
                        removeBoxLoadingState();
                    }
                });          
            }





            function load_account_details($id){
                $.ajax({
                    url  : $app_url + '/billing/refund-posting/account',
                    type : 'GET',
                    data : {
                        'account_id' : $id
                    },
                    success : function(response){
                        var a = response;
                        if(Object.keys(response).length > 0){
                            var accountAddr = a.address + ', ' + a.barangay + ', ' + a.city + ', ' + a.province;
                            var meterNo     = a.meter_no;
                            var contract    = a.contract_no;
                            var acct_class  = a.acct_class + ' - ' + a.acct_subclass;
                            var status      = a.account_status;
                            var data        = $('#acct_id').select2('data')[0];
                            var gd          = number_format(a.gdeposit);
                            var book        = a.book_code;
                            var donumber    = a.do ? a.do.jo_number : 'N/A';
                            var dodate      = a.do ? a.do.jo_date : 'N/A';

                            var log = {
                                'account_id' : a.id,
                                'meter_id'   : a.meter_id
                            };

                            console.log(log);                            

                            switch(status){
                                case 'ac' :
                                    status = "<span class='label label-primary'>ACTIVE</span>";
                                    break;
                                case 'ia' :
                                    status = "<span class='label label-danger'>INACTIVE</span>";
                                    break;
                                case 'dc' :
                                    status = "<span class='label label-warning'>DISCONNECTED</span>";
                                    break;                                
                            }

                            $('#account_no')        .text(data.acct_no);
                            $('#account_address')   .text(accountAddr.toUpperCase());
                            $('#meter_no')          .text(meterNo);
                            $('#contract_no')       .text( (contract || 'N/A') );
                            $('#account_class')     .text(acct_class);
                            $('#gd-val')            .text(gd);
                            $('#account_status')    .html(status);
                            $('#do-number')         .text(donumber);   
                            $('#do-date')           .text(dodate);

                            get_rs($id);                                     
                        }                          
                    },
                    error : function(xhr){
                        if(xhr.status != '422'){
                            $.alert({
                                title   : 'Oops, something went wrong!',
                                content : "<span style='font-size:20px' class='text-danger'>" 
                                            + xhr.status 
                                        + "</span>" + '&nbsp;&nbsp;' 
                                        + '<strong>'+xhr.statusText+'</strong>'
                                        + '<br />'
                                        + 'Refresh the page and try again.',
                                type    : 'red',
                                icon    : 'fa fa-warning',
                                draggable : true
                            });  
                        }   
                    },
                    beforeSend : function(){
                        // showBoxLoadingState();
                    },
                    complete : function(){
                        // removeBoxLoadingState();
                    }
                });
            }





            function get_rs($id){
                $.get($app_url + '/billing/refund-posting/get-rs', {
                    'account_id' : $id
                })
                .done(function(response){
                    if(Object.keys(response).length > 0){
                        $('div#body').css('display', 'none');
                        // console.log(response);
                    }else{
                        balance($id);
                    }
                });                
            }





            function balance(acctId){
                $.ajax({
                    url  : $app_url + '/billing/refund-posting/balance',
                    type : 'GET',
                    data : {
                        'account_id' : acctId
                    },
                    success : function(response){
                        $('#remarks').attr('readonly', false);
                        $('#remarks').val('');
                        $('#create-rs').css('display', '');
                        $('div#slip-no').css('display', 'none');

                        var bills    = response['bills'];
                        var payables = response['payables'];

                        var tbills = $('table#bills > tbody');
                        tbills.empty();    

                        var tpayables = $('table#payables > tbody');
                        tpayables.empty();                  

                        var total_unpaid_bills = 0;        
                        var total_payables     = 0;     
                        var amount_net         = 0;

                        BILLS_ID    = [];
                        PAYABLES_ID = [];

                        BILLS_WITH_VALUE = [];
                        PAYABLES_WITH_VALUE = [];

                        // load bills
                        $.each(bills, function(index){                      
                            var b = bills[index];

                            var balance = cast(b.bill_amount) + cast(b.penalty) - (cast(b.senior) + cast(b.tax) + cast(b.discount) + cast(b.advance)) - cast(b.amount_paid);
                            total_unpaid_bills += cast(balance);

                            if(cast(balance) > 0){
                                BILLS_ID.push(b.did);
                                BILLS_WITH_VALUE.push({
                                    'id'     : b.did,
                                    'amount' : cast(balance)
                                });

                                tbills.append("<tr data-id='"+b.did+"'>"
                                                +"<td class='text-center'>"
                                                    +b.bill_type
                                                +"</td>"
                                                +"<td>"
                                                    +b.present_rdg_date
                                                +"</td>"               
                                                +"<td>"
                                                    +b.bill_number
                                                +"</td>"
                                                +"<td class='text-right'>"
                                                    +number_format(balance)                                                             
                                                +"</td>"
                                            +"</tr>");
                            }
                        });

                        $('#unpaid_bills').text(number_format(total_unpaid_bills));

                        
                        // load payables
                        $.each(payables, function(index){                       
                            var p = payables[index];

                            total_payables += cast(p.amt_balance);

                            PAYABLES_ID.push(p.id);
                            PAYABLES_WITH_VALUE.push({
                                'id'     : p.id,
                                'amount' : cast(p.amt_balance)
                            });

                            tpayables.append("<tr data-id='"+p.id+"'>"
                                            +"<td style='text-align:left !important;'>"
                                                +p.reference.toUpperCase()
                                            +"</td>"
                                            +"<td>"
                                                +p.dt_created
                                            +"</td>"               
                                            +"<td style='text-align:right !important;'>"
                                                +number_format(p.amt_balance)                                                               
                                            +"</td>"
                                        +"</tr>");
                        });     

                        $('#other_payables').text(number_format(total_payables));    

                        var gd  = cast($('#gd-val').text());
                        var bal = cast(total_unpaid_bills) + cast(total_payables);
                        amount_net = gd - bal;
                        $('#np-val').text(number_format(amount_net));

                        if(gd >= bal){
                            $('#np-label').text('NET REFUND');
                        }else{
                            $('#np-label').text('NET PAYABLE');
                        }

                        $('div#body').css('display', '');                        
                    },
                    error : function(xhr){
                        if(xhr.status != '422'){
                            $.alert({
                                title   : 'Oops, something went wrong!',
                                content : "<span style='font-size:20px' class='text-danger'>" 
                                            + xhr.status 
                                        + "</span>" + '&nbsp;&nbsp;' 
                                        + '<strong>'+xhr.statusText+'</strong>'
                                        + '<br />'
                                        + 'Refresh the page and try again.',
                                type    : 'red',
                                icon    : 'fa fa-warning',
                                draggable : true
                            });  
                        }                           
                    },
                    beforeSend : function(){
                        showBoxLoadingState();
                    },
                    complete : function(){
                        removeBoxLoadingState();
                    }
                });         	
            }


            $('#acct_id').select2({
                allowClear: true,
                ajax: {
                    url: $app_url + '/select2-acct-search',
                    delay: 300,
                    cache : false,
                    data: function (params) {
                        return query = {
                            search: params.term,
                            page: params.page,
                            filter: ['ia']
                        }
                    },
                    processResults: function (data, params) {
                        params.page = params.page || 1;

                        return {
                            results: $.map(data.items, function (data) {
                                return {
                                    text          : data.cust_fullname ? data.cust_fullname : data.cust_bname,
                                    acct_no       : data.acct_number,        
                                    old_acct_no   : data.acct_number_old,                            
                                    acct_class    : data.acct_class + '-' + data.acct_subclass,
                                    account_class : data.acct_class,
                                    meter         : data.meter_no,
                                    address       : data.cust_address,
                                    id            : data.cust_id,
                                    sc            : data.sc_discount,
                                    adv           : data.adv_payment,
                                    acct_status   : data.acct_status,
                                    book_code     : data.book_code
                              }
                            }),
                            pagination: {
                                more: (params.page * 10) < data.count
                            }
                        };
                    }
                },
                escapeMarkup: function (markup) { return markup; },
                templateResult: formatAcctSearchResults
            });

            function formatAcctSearchResults(results) {
                if(results.loading) return results.text;

                var markup = "<div class='select2-result-repository clearfix'>" +
                             "<div class='select2-result-repository__title'>" 
                                +results.text.toUpperCase()
                            +"</div>";

                     markup +=  "<div class='select2-result-repository__forks'>"
                                    +"<i class='fa fa-lock fa-fw'></i>"
                                    +"<span style='font-size:14px;'>"                                    
                                        + results.acct_no
                                    +"</span>"
                                    +" | "
                                    +"<span>"
                                            + results.old_acct_no 
                                    +"</span>"                                
                                +"</div>";

                if (results.address) {
                    markup += "<div class='select2-result-repository__description'>"
                                +"<i class='fa fa-map-marker fa-fw'></i>" 
                                    +results.address
                                +"</div>";
                }

                markup +=   "<div class='select2-result-repository__statistics'>" +                                                            
                                "<div class='select2-result-repository__stargazers'>"
                                    +"<i class='fa fa-power-off fa-fw'></i>" 
                                        +results.acct_status 
                                    +"</div>"
                                +"<div class='select2-result-repository__stargazers'>"
                                    +"<i class='fa fa-dashboard fa-fw'></i>"
                                        +results.meter 
                                +"</div>"
                                +"<div class='select2-result-repository__stargazers'>"
                                    +"<i class='fa fa-street-view fa-fw'></i>" 
                                        +results.acct_class
                                +"</div>" +
                            "</div>";

                return markup;
            }

            function number_format(number){
                return numeral(number.toString().replace(/,/g, '')).format('(0,0.00)');
            }

            function cast(number){
                return Number(number.toString().replace(/,/g, ''));
            }		

            function cleanUpCurrency(s){
                var expression = /^\$?\(?[\d,\.]*\)?$/;

                //Check if it is in the proper format
                if(s.match(expression)){
                    //It matched - strip out parentheses and append - at front      
                    return parseFloat('-' + s.replace(/[\$\(\),]/g,''));
                }
                else{
                    return parseFloat(s);
                }   
            }              
	});
</script>
@endsection