@extends('Modules.Delivery.layouts.main')

<link href="{{URL::to('src/css/jquery-ui.css')}}" rel="stylesheet" type="text/css" />
<link rel="icon" href="{{URL::to('src/img/Dairycare.ico') }}">
<link rel="stylesheet" href="//code.jquery.com/mobile/1.5.0-alpha.1/jquery.mobile-1.5.0-alpha.1.min.css"/>
<link type="text/css" href="{{URL::to('src/css/loading-overlay.css')}}" rel="stylesheet">
<link href=" {{URL::to('src/datatable_buttons/css/buttons.dataTables.min.css') }}" rel="stylesheet" />

<title>Customer Delivery Dashboard</title>
<style>
    .x_panel{position:relative;width:100%;margin-bottom:10px;padding:10px 17px;display:inline-block;background:#fff;border:1px solid #E6E9ED;-webkit-column-break-inside:avoid;-moz-column-break-inside:avoid;column-break-inside:avoid;opacity:1;transition:all .2s ease}.x_title{border-bottom:2px solid #E6E9ED;padding:1px 5px 6px;margin-bottom:10px}.x_title .filter{width:40%;float:right}.x_title h2{margin:5px 0 6px;float:left;display:block;text-overflow:ellipsis;overflow:hidden;white-space:nowrap}.x_title h2 small{margin-left:10px}.x_title span{color:#BDBDBD}.x_content{padding:0 5px 6px;position:relative;width:100%;float:left;clear:both;margin-top:5px}.x_content h4{font-size:16px;font-weight:500}legend{padding-bottom:7px}.demo-placeholder{height:280px}
    .content-wrapper{
        min-height: 700px !important;
        background-image: url('img/thumb-1920-407882.jpg');
    }
    .description,
    .card-description,
    .footer-big p {
        color: #999999;
    }

    .text-warning {
        color: #ff9800;
    }

    .text-primary {
        color: #9c27b0;
    }

    .text-danger {
        color: #f44336;
    }

    .text-success {
        color: #4caf50;
    }

    .text-info {
        color: #00bcd4;
    }
    .text-bilal {
        color: #9B6F52;
    }

    .text-rose {
        color: #e91e63;
    }

    .text-gray {
        color: #999999;
    }
    body.inverse .card,
    body.inverse .card .form-control {
        background-color: initial;
        color: initial;
    }
.card {
    display: inline-block;
    position: relative;
    width: 100%;
    margin: 25px 0;
    box-shadow: 0 1px 4px 0 rgba(0, 0, 0, 0.14);
    border-radius: 3px;
    color: rgba(0, 0, 0, 0.87);
    background: #fff;
}

.card .card-height-indicator {
    margin-top: 100%;
}

.card.row-space .header {
    padding: 15px 20px 0;
}

.card .title {
    margin-top: 0;
    margin-bottom: 5px;
}

.card .card-image {
    height: 60%;
    position: relative;
    overflow: hidden;
    margin-left: 15px;
    margin-right: 15px;
    margin-top: -30px;
    border-radius: 6px;
}

.card .card-image img {
    width: 100%;
    height: 100%;
    border-radius: 6px;
    pointer-events: none;
}

.card .card-image .card-title {
    position: absolute;
    bottom: 15px;
    left: 15px;
    color: #fff;
    font-size: 1.3em;
    text-shadow: 0 2px 5px rgba(33, 33, 33, 0.5);
}

.card .category:not([class*="text-"]) {
    color: #999999;
}

.card .card-content {
    padding: 15px 20px;
}

.card .card-content .category {
    margin-bottom: 0;
}

.card .card-header {
    box-shadow: 0 10px 30px -12px rgba(0, 0, 0, 0.42), 0 4px 25px 0px rgba(0, 0, 0, 0.12), 0 8px 10px -5px rgba(0, 0, 0, 0.2);
    margin: -20px 15px 0;
    border-radius: 3px;
    padding: 15px;
    background-color: #999999;
}

.card .card-header .title {
    color: #FFFFFF;
}

.card .card-header .category {
    margin-bottom: 0;
    color: rgba(255, 255, 255, 0.62);
}

.card .card-header.card-chart {
    padding: 0;
    min-height: 160px;
}

.card .card-header.card-chart+.content h4 {
    margin-top: 0;
}

.card .card-header .ct-label {
    color: rgba(255, 255, 255, 0.7);
}

.card .card-header .ct-grid {
    stroke: rgba(255, 255, 255, 0.2);
}

.card .card-header .ct-series-a .ct-point,
.card .card-header .ct-series-a .ct-line,
.card .card-header .ct-series-a .ct-bar,
.card .card-header .ct-series-a .ct-slice-donut {
    stroke: rgba(255, 255, 255, 0.8);
}

.card .card-header .ct-series-a .ct-slice-pie,
.card .card-header .ct-series-a .ct-area {
    fill: rgba(255, 255, 255, 0.4);
}

.card .chart-title {
    position: absolute;
    top: 25px;
    width: 100%;
    text-align: center;
}

.card .chart-title h3 {
    margin: 0;
    color: #FFFFFF;
}

.card .chart-title h6 {
    margin: 0;
    color: rgba(255, 255, 255, 0.4);
}

.card .card-footer {
    margin: 0 20px 10px;
    padding-top: 10px;
    border-top: 1px solid #eeeeee;
}

.card .card-footer .content {
    display: block;
}

.card .card-footer div {
    display: inline-block;
}

.card .card-footer .author {
    color: #999999;
}

.card .card-footer .stats {
    line-height: 22px;
    color: #999999;
    font-size: 12px;
}

.card .card-footer .stats .material-icons {
    position: relative;
    top: 4px;
    font-size: 16px;
}

.card .card-footer h6 {
    color: #999999;
}

.card img {
    width: 100%;
    height: auto;
}

.card .category .material-icons {
    position: relative;
    top: 6px;
    line-height: 0;
}

.card .category-social .fa {
    font-size: 24px;
    position: relative;
    margin-top: -4px;
    top: 2px;
    margin-right: 5px;
}

.card .author .avatar {
    width: 30px;
    height: 30px;
    overflow: hidden;
    border-radius: 50%;
    margin-right: 5px;
}

.card .author a {
    color: #3C4858;
    text-decoration: none;
}

.card .author a .ripple-container {
    display: none;
}

.card .table {
    margin-bottom: 0;
}

.card .table tr:first-child td {
    border-top: none;
}

.card [data-background-color="purple"] {
    background: linear-gradient(60deg, #ab47bc, #8e24aa);
    box-shadow: 0 12px 20px -10px rgba(156, 39, 176, 0.28), 0 4px 20px 0px rgba(0, 0, 0, 0.12), 0 7px 8px -5px rgba(156, 39, 176, 0.2);
}

.card [data-background-color="blue"] {
    background: linear-gradient(60deg, #26c6da, #00acc1);
    box-shadow: 0 12px 20px -10px rgba(0, 188, 212, 0.28), 0 4px 20px 0px rgba(0, 0, 0, 0.12), 0 7px 8px -5px rgba(0, 188, 212, 0.2);
}

.card [data-background-color="green"] {
    background: linear-gradient(60deg, #66bb6a, #43a047);
    box-shadow: 0 12px 20px -10px rgba(76, 175, 80, 0.28), 0 4px 20px 0px rgba(0, 0, 0, 0.12), 0 7px 8px -5px rgba(76, 175, 80, 0.2);
}

.card [data-background-color="orange"] {
    background: linear-gradient(60deg, #ffa726, #fb8c00);
    box-shadow: 0 12px 20px -10px rgba(255, 152, 0, 0.28), 0 4px 20px 0px rgba(0, 0, 0, 0.12), 0 7px 8px -5px rgba(255, 152, 0, 0.2);
}

.card [data-background-color="red"] {
    background: linear-gradient(60deg, #ef5350, #e53935);
    box-shadow: 0 12px 20px -10px rgba(244, 67, 54, 0.28), 0 4px 20px 0px rgba(0, 0, 0, 0.12), 0 7px 8px -5px rgba(244, 67, 54, 0.2);
}

.card [data-background-color="bilal_red"] {
    background: linear-gradient(60deg, #FF5252, #B71C1C);
    box-shadow: 0 13px 21px -10px rgb(183, 28, 28), 0 4px 20px 0px rgba(0, 0, 0, 0.12), 0 7px 8px -5px rgba(244, 67, 54, 0.2);
}
.card [data-background-color="bilal_brown"] {
    background: linear-gradient(60deg, #9B6F52, #533233);
    box-shadow: 0 13px 21px -10px rgb(155, 111, 82), 0 4px 20px 0px rgba(0, 0, 0, 0.12), 0 7px 8px -5px rgba(244, 67, 54, 0.2);
}
.card [data-background-color="bilal_green"] {
    background: linear-gradient(60deg, #00C851, #007E33);
    box-shadow: 0 13px 21px -10px rgb(0, 126, 51), 0 4px 20px 0px rgba(0, 0, 0, 0.12), 0 7px 8px -5px rgba(244, 67, 54, 0.2);
}
.card [data-background-color="bilal_orange"] {
    background: linear-gradient(60deg, #FFA000, #E65100);
    box-shadow: 0 13px 21px -10px rgb(255, 160, 0), 0 4px 20px 0px rgba(0, 0, 0, 0.12), 0 7px 8px -5px rgba(255, 152, 0, 0.2);
}
.card [data-background-color] {
    color: #FFFFFF;
}

.card [data-background-color] a {
    color: #FFFFFF;
}

.card-stats .title {
    margin: 0;
}

.card-stats .card-header {
    float: left;
    text-align: center;
}

.card-stats .card-header i {
    font-size: 36px;
    line-height: 56px;
    width: 56px;
    height: 56px;
}

.card-stats .card-content {
    text-align: right;
    padding-top: 10px;
}

.card-nav-tabs .header-raised {
    margin-top: -30px;
}

.card-nav-tabs .nav-tabs {
    background: transparent;
    padding: 0;
}

.card-nav-tabs .nav-tabs-title {
    float: left;
    padding: 10px 10px 10px 0;
    line-height: 24px;
}

.card-plain {
    background: transparent;
    box-shadow: none;
}

.card-plain .card-header {
    margin-left: 0;
    margin-right: 0;
}

.card-plain .content {
    padding-left: 5px;
    padding-right: 5px;
}

.card-plain .card-image {
    margin: 0;
    border-radius: 3px;
}

.card-plain .card-image img {
    border-radius: 3px;
}

.iframe-container {
    margin: 0 -20px 0;
}

.iframe-container iframe {
    width: 100%;
    height: 500px;
    border: 0;
    box-shadow: 0 10px 30px -12px rgba(0, 0, 0, 0.42), 0 4px 25px 0px rgba(0, 0, 0, 0.12), 0 8px 10px -5px rgba(0, 0, 0, 0.2);
}

.card-profile,
.card-testimonial {
    margin-top: 30px;
    text-align: center;
}

.card-profile .btn-just-icon.btn-raised,
.card-testimonial .btn-just-icon.btn-raised {
    margin-left: 6px;
    margin-right: 6px;
}

.card-profile .card-avatar,
.card-testimonial .card-avatar {
    max-width: 130px;
    max-height: 130px;
    margin: -50px auto 0;
    border-radius: 50%;
    overflow: hidden;
    box-shadow: 0 10px 30px -12px rgba(0, 0, 0, 0.42), 0 4px 25px 0px rgba(0, 0, 0, 0.12), 0 8px 10px -5px rgba(0, 0, 0, 0.2);
}

.card-profile .card-avatar+.content,
.card-testimonial .card-avatar+.content {
    margin-top: 15px;
}

.card-profile.card-plain .card-avatar,
.card-testimonial.card-plain .card-avatar {
    margin-top: 0;
}
.card form [class*="col-"] {
        padding: 6px;
    }
    .card form [class*="col-"]:first-child {
        padding-left: 15px;
    }
    .card form [class*="col-"]:last-child {
        padding-right: 15px;
    }
    .btn.btn-fab.btn-fab-mini.material-icons,
.btn-group-sm .btn.btn-fab.material-icons,
.navbar .navbar-nav>li>a.btn.btn-fab.btn-fab-mini.material-icons,
.btn-group-sm .navbar .navbar-nav>li>a.btn.btn-fab.material-icons {
    top: -3.5px;
    left: -3.5px;
}

.btn.btn-fab.btn-fab-mini .material-icons,
.btn-group-sm .btn.btn-fab .material-icons,
.navbar .navbar-nav>li>a.btn.btn-fab.btn-fab-mini .material-icons,
.btn-group-sm .navbar .navbar-nav>li>a.btn.btn-fab .material-icons {
    font-size: 17px;
}

.btn.btn-fab i.material-icons,
.navbar .navbar-nav>li>a.btn.btn-fab i.material-icons {
    position: absolute;
    top: 50%;
    left: 50%;
    transform: translate(-12px, -12px);
    line-height: 24px;
    width: 24px;
    font-size: 24px;
}
.btn .material-icons {
    vertical-align: middle;
    font-size: 17px;
    top: -1px;
    position: relative;
}
.navbar .navbar-nav>li>a:not(.btn) .material-icons {
    margin-top: -3px;
    top: 0px;
    position: relative;
    margin-right: 3px;
}
a .material-icons {
    vertical-align: middle;
}

#monthly_table,td.details-control {
  background: url('../img/details_open.png') no-repeat center center;
  cursor: pointer;
}

#monthly_table,tr.shown td.details-control{
  background: url('img/details_close.png') no-repeat center center;
}

</style>
        
@section('main-content')
@if(Auth::user()->hasRole('Admin') || Auth::user()->hasRole('Visitor'))
 <link href="{{URL::to('src/css/css/AdminLTE.css') }}" rel="stylesheet" type="text/css" />
<link href=" {{URL::to('src/css/css/bootstrap.min.css') }}" rel="stylesheet" type="text/css" />
<link href="{{URL::to('src/css/jquery-ui.css')}}" rel="stylesheet" type="text/css" /> 
<link href="{{URL::to('src/plugins/iCheck/square/green.css')}}" rel="stylesheet" type="text/css">
<style>
        
       .x_panel{position:relative;width:100%;margin-bottom:10px;padding:10px 17px;display:inline-block;background:#fff;border:1px solid #E6E9ED;-webkit-column-break-inside:avoid;-moz-column-break-inside:avoid;column-break-inside:avoid;opacity:1;transition:all .2s ease}.x_title{border-bottom:2px solid #E6E9ED;padding:1px 5px 6px;margin-bottom:10px}.x_title .filter{width:40%;float:right}.x_title h2{margin:5px 0 6px;float:left;display:block;text-overflow:ellipsis;overflow:hidden;white-space:nowrap}.x_title h2 small{margin-left:10px}.x_title span{color:#BDBDBD}.x_content{padding:0 5px 6px;position:relative;width:100%;float:left;clear:both;margin-top:5px}.x_content h4{font-size:16px;font-weight:500}legend{padding-bottom:7px}.demo-placeholder{height:280px}
       .content-wrapper{
        height:auto  !important;
        background-image: url('../img/main.jpeg');
        background-size:cover;
        }

       .chart-wrapper {
           position: relative;
           padding-bottom: 10%;
           margin-top: -40px;
           width:100%;
           float:left;
           background: transparent;
       }

       .chart-inner {
           position: absolute;
           width: 80%; height: 100%;
           opacity: 0.9;
       }
</style>
 <link href=" {{URL::to('src/css/material_icons.css') }}" rel="stylesheet" type="text/css" />
<div class="row">
    
    <div class="col-lg-3 col-md-6 col-sm-6" id="active_customers_div">

        <div class="card card-stats">
            <div class="card-header" data-background-color="bilal_green">
                <img src="{{URL::to('img/customers.png')}}" alt="Cow" title="Cow" width="20" height="20">
            </div>
                <a href="{{url('View-Active-Customers-Fast')}}">
            <div class="card-content">
                <p class="category" style="font-size:12px;">Active Customers</p>
                <h3 class="title text-success">{{$customers}}</h3>
            </div>
                </a>
            <div class="card-footer">
                <div class="stats">
                    <i class="material-icons text-success">update</i> <a href="javascript:show_active_customers()">View Details</a>
                </div>
            </div>
        </div>
        
    </div>
   
    
    <div class="col-lg-3 col-md-6 col-sm-6" class="total_receivables">
        <a href="javascript:receivable_details()">
        <div class="card card-stats" id="total_receivables_under">
            <div class="card-header" data-background-color="bilal_green">
                <img src="{{URL::to('img/cash_receive.png')}}" alt="Cow" title="Cow" width="20" height="20">
            </div>
            <div class="card-content">
                <p class="category" style="font-size:12px;">Total Receivable</p>
                <h3 class="title text-success" style="font-size: 21px;" ><div id="total_receivable_value"></div></h3>
            </div>
            <div class="card-footer">
                <div class="stats">
                    <i class="material-icons text-success">update</i> Just Updated
                </div>
            </div>
        </div>
        </a>
    </div>
    
    <div class="col-lg-3 col-md-6 col-sm-6" id="today_sales_div">
        <a href="javascript:today_sale_details()">
        <div class="card card-stats">
            <div class="card-header" data-background-color="bilal_green">
                <img src="{{URL::to('img/cash_receive.png')}}" alt="Cow" title="Cow" width="20" height="20">
            </div>
            <div class="card-content">
                <p class="category" style="font-size:12px;">Today Sale</p>
                <h3 class="title text-success">{{$today_sale}}</h3>
            </div>
            <div class="card-footer">
                <div class="stats">
                    <i class="material-icons text-success">update</i> <a href="javascript:today_sale_details()">View Details</a>
                </div>
            </div>
        </div>
        </a>
    </div>
    
    <div class="col-lg-3 col-md-6 col-sm-6" id="month_sales_div">
        <a href="javascript:month_sale_details()">
        <div class="card card-stats">
            <div class="card-header" data-background-color="bilal_green">
                <img src="{{URL::to('img/cash_receive.png')}}" alt="Cow" title="Cow" width="20" height="20">
            </div>
            <div class="card-content">
                <p class="category" style="font-size:12px;">Month Sale</p>
                <h3 class="title text-success">{{$month_sale}}</h3>
            </div>
            <div class="card-footer">
                <div class="stats">
                    <i class="material-icons text-success">update</i> <a href="javascript:month_sale_details()">View Details</a>
                </div>
            </div>
        </div>
        </a>
    </div>
    
    <div class="col-lg-3 col-md-6 col-sm-6" style="display: none;">
        <a href="{{url('view_active_customers')}}">
        <div class="card card-stats">
            <div class="card-header" data-background-color="blue">
                <img src="{{URL::to('img/milk_bottle.png')}}" alt="Cow" title="Cow" width="20" height="20">
            </div>
            <div class="card-content">
                <p class="category " style="font-size:12px;">Milk</p>
                <h3 class="title text-bilal">{{$milk_stock}}</h3>
            </div>
            <div class="card-footer">
                <div class="stats">
                    <i class="material-icons text-bilal">local_offer</i> Just Updated
                </div>
            </div>
        </div>
        </a>
    </div>

    <div class="col-lg-6 col-md-6 col-sm-6" >
        <div class="chart-wrapper">
            <div class="chart-inner">
        <div id="pie_container" style=" height: 200px; margin: -50px auto; background: transparent;"></div>
            </div>
        </div>
    </div>
</div>
 
 <div class="row">
    
    <div class="col-lg-8">
        <div class="table-responsive" id="monthly_div">
            <table class="table table-bordered" style="background-color: white;" id="monthly_table">
                <thead id="monthly_head">
                </thead>
                <tfoot style="border-top:2px solid #008D39;font-size: 14px;" >
                    <tr id="monthly_foot">
                        <th style="text-align:center;">Total</th>
                        <th id="total_month_sale" style="text-align:center;"></th>
                        <th id="total_month_receiving" style="text-align:center;"></th>
                    </tr>
                </tfoot>

            </table>
        </div>
    </div>
     
    <div class="col-lg-4">
        <div class="table-responsive" id="credit_limit_div">
            <table class="table table-bordered" style="background-color: white;" id="credit_limit_table">
                <thead id="credit_limit_head">
                </thead>
<!--                <tfoot style="border-top:2px solid #008D39;font-size: 14px;" >
                    <tr id="monthly_foot">
                        <th style="text-align:center;">Total</th>
                        <th id="total_month_sale" style="text-align:center;"></th>
                        <th id="total_month_receiving" style="text-align:center;"></th>
                    </tr>
                </tfoot>-->

            </table>
        </div>
    </div>
     
     
 </div>
<script src="https://code.highcharts.com/highcharts.js"></script>
<script src="https://code.highcharts.com/modules/exporting.js"></script>
<script src="https://code.highcharts.com/modules/export-data.js"></script>
<script src="{{URL::to('src/js/loading-overlay-corrected.min.js')}}"></script>


    <script type="text/javascript"
            src="{{URL::to('src/js/jquery-dataTables.min.js') }}"></script>

    <script src="{{URL::to('src/js/select2.min.js') }}" type="text/javascript"></script>
    <script src="{{URL::to('src/plugins/iCheck/icheck.js')}}" type="text/javascript"></script>



    <link href=" {{URL::to('src/fixed_datatable/css/jquery.dataTables.min.css')}}" rel="stylesheet" />
    <script src="{{URL::to('src/fixed_datatable/js/jquery.dataTables.min.js')}}" type="text/javascript"></script>


    <script src="{{URL::to('src/datatable_buttons/js/dataTables.buttons.min.js') }}" type="text/javascript"></script>
    <script src="{{URL::to('src/datatable_buttons/js/buttons.colVis.min.js') }}" type="text/javascript"></script>

    <script src="{{URL::to('src/datatable_buttons/js/buttons.flash.min.js') }}" type="text/javascript"></script>
    <script src="{{URL::to('src/datatable_buttons/js/jszip.min.js') }}" type="text/javascript"></script>
    <script src="{{URL::to('src/datatable_buttons/js/pdfmake.min.js') }}" type="text/javascript"></script>
    <script src="{{URL::to('src/datatable_buttons/js/vfs_fonts.js') }}" type="text/javascript"></script>
    <script src="{{URL::to('src/datatable_buttons/js/buttons.html5.min.js') }}" type="text/javascript"></script>
    <script src="{{URL::to('src/datatable_buttons/js/buttons.print.min.js') }}" type="text/javascript"></script>
    <script src="{{URL::to('src/js/keyboard_shortcuts.js') }}"></script>



<div class="x_panel" style="border: #2A3F54 1px solid; opacity: 0.94;">
    <div class="row">
        <div class="col-sm-6">
            <div id="profit_loss" style=" height: 400px; margin: 0 auto; "></div>
            <div id="container" style=" height: 400px; margin: 0 auto; display: none;"></div>
        </div>
        <div class="col-sm-6">
            <div id="customer" style=" height: 400px; margin: 0 auto; "></div>
        </div>
    </div>
        


</div>

<div class="modal fade" id="today_sale_modal" tabindex="-1" role="dialog">
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <div class="modal-header" style="color:#008D39;padding: 0px !important;">
                <h3 style="padding: 0px !important;text-align:center;" id="title">Today Sales</h3>
            </div>
            <div class="modal-body" id="today_sale_details_div">
                
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-default" data-dismiss="modal"> <i class="glyphicon glyphicon-remove-sign"></i> Close</button>
            </div>

        </div>
    </div>
</div>
    
<div class="modal fade" id="active_customer_modal" tabindex="-1" role="dialog">
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <div class="modal-header" style="color:#008D39;padding: 0px !important;">
                <h3 style="padding: 0px !important;text-align:center;" id="title">Active Customers</h3>
            </div>
            <div class="modal-body" id="active_customer_details_div">
                
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-default" data-dismiss="modal"> <i class="glyphicon glyphicon-remove-sign"></i> Close</button>
            </div>
        </div>
    </div>
</div>

<div class="modal fade bd-example-modal-lg" id="month_sale_modal" tabindex="-1" role="dialog">
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <div class="modal-header" style="color:#008D39;padding: 0px !important;">
                <h3 style="padding: 0px !important;text-align:center;" id="title">Month Sales</h3>
            </div>
            <div class="modal-body" id="month_sale_details_div">
                
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-default" data-dismiss="modal"> <i class="glyphicon glyphicon-remove-sign"></i> Close</button>
            </div>

        </div>
    </div>
</div>    
    
<div class="modal fade" id="receivable_modal" tabindex="-1" role="dialog">
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <div class="modal-header" style="color:#008D39;padding: 0px !important;">
                <h3 style="padding: 0px !important;text-align:center;" id="title">Receivable Aging</h3>
            </div>
            <div class="modal-body">
                <div class="table-responsive" >
                    <table class="table table-bordered" width="100%" style="background-color: white;" id="receivable_table">
                        <thead>
                        <tr style="background-color: wheat;color:#008D39;">
                            <th style="text-align: center;">#</th>
                            <th style="text-align: center;">Amount</th>
                        </tr>


                        </thead>
                        <tbody id="receivable_body">

                        </tbody>
                        <tfoot id="receivable_foot">

                        </tfoot>

                    </table>
                </div>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-default" data-dismiss="modal"> <i class="glyphicon glyphicon-remove-sign"></i> Close</button>
            </div>

        </div>
    </div>
</div>

@else
<h3>Insufficient Permission</h3>
@endif
<script>

function BalanceReport()
{
    $.ajax({
        method: 'GET',
        url: '{{url("sale_graph")}}',
        data: {
        },
        success: function(response)
        {
            $('.nav-md').css({'padding-right':'0px'});
            var balance_data = JSON.parse(response);
            
            var original_head_array = []; 
            var original_customer_array = [];
            
            var balance_length=balance_data.sale_data.length;
            
            var j=0;
            for(var i=balance_length-1;i>=0;i--)
            {
                var tmp=[];
                tmp[0]=balance_data.sale_data[i].name;
                tmp[1]=parseFloat(balance_data.sale_data[i].amount);
                
                original_head_array[j]=tmp;
                var tmp=[];
                tmp[0]=balance_data.customer_data[i].name;
                tmp[1]=balance_data.customer_data[i].count;
                
                original_customer_array[j]=tmp;
                
                j++;
            }

            Highcharts.chart('container', {
            chart: {
                type: 'column'
            },
            title: {
                text: 'Monthly Sale Income'
            },
            subtitle: {
                text: ''
            },
            xAxis: {
                type: 'category',
                labels: {
                    rotation: -45,
                    style: {
                        fontSize: '13px',
                        fontFamily: '"Trebuchet MS", Verdana, sans-serif'
                    }
                }
            },
            yAxis: {
                min: 0,
                title: {
                    text: 'Income in Numbers'
                }
            },
            legend: {
                enabled: false
            },
            tooltip: {
                pointFormat: '<b>{point.y:.1f} nos</b>'
            },
            credits: {
                text: 'A-I-T Solutions',
                href: 'http://ait-solutions.org/'
            },
            series: [{
                name: 'Population',
                data: original_head_array,
                dataLabels: {
                    enabled: true,
                    rotation: -90,
                    color: '#FFFFFF',
                    align: 'right',
                    format: '{point.y:.1f}', // one decimal
                    y: 10, // 10 pixels down from the top
                    style: {
                        fontSize: '13px',
                        fontFamily: 'Verdana, sans-serif'
                    }
                }
            }]
        });
        
            Highcharts.chart('customer', {
                chart: {
                    type: 'column'
                },
                title: {
                    text: 'Monthly Customer Joining'
                },
                subtitle: {
                    text: ''
                },
                xAxis: {
                    type: 'category',
                    labels: {
                        rotation: -45,
                        style: {
                            fontSize: '13px',
                            fontFamily: 'Verdana, sans-serif'
                        }
                    }
                },
                yAxis: {
                    min: 0,
                    title: {
                        text: 'Joining in Numbers'
                    }
                },
                legend: {
                    enabled: false
                },
                tooltip: {
                    pointFormat: '<b>{point.y:.1f} nos</b>'
                },
                credits: {
                    text: 'A-I-T Solutions',
                    href: 'http://ait-solutions.org/'
                },
                series: [{
                    name: 'Population',
                    data: original_customer_array,
                    dataLabels: {
                        enabled: true,
                        rotation: -90,
                        color: '#FFFFFF',
                        align: 'right',
                        format: '{point.y:.1f}', // one decimal
                        y: 10, // 10 pixels down from the top
                        style: {
                            fontSize: '13px',
                            fontFamily: 'Verdana, sans-serif'
                        }
                    }
                }]
            });         
        },
        error: function (jqXHR, status, err) {
            
        }
    });
}

function get_receivables()
{
    jQuery(function ($) {
        var target = $('#total_receivables');

        $('.toggle-loading').click(function () {
            if (target.hasClass('loading')) {
                target.loadingOverlay('remove');
            } else {
                target.loadingOverlay();
                $(".loading-overlay").css('z-index',5);
            };
        });
    });
 
    $("#total_receivables_under").LoadingOverlay("show");

    $("#total_receivables_under").LoadingOverlay("show", {
    background  : "rgba(171, 210, 236, 0.5)"
    });
    
    
    $.ajax({
        method: 'GET',
        url: '{{url("get_receivables_dashboard")}}',
        data: {
        },
        success: function(response)
        {
            $('.nav-md').css({'padding-right':'0px'});
            var balance_data = JSON.parse(response);
            
            setTimeout(function(){
                $("#total_receivables_under").LoadingOverlay("hide", true);
            }, 500);
            
            $("#total_receivable_value").text(balance_data.receivables);
        },
        error: function (jqXHR, status, err) {

        }
    }); 
}

function profit_graph()
{
    $.ajax({
        method: 'GET',
        url: '{{url("profit_graph")}}',
        data: {
            
        },
        success: function(response)
        {
            $('.nav-md').css({'padding-right':'0px'});
            var balance_data = JSON.parse(response);

            var data=JSON.parse(response);
            var aData = response.d;
            var arr = [];

            $.map(data.profit, function (item, index) {
               var dat=[];
               for (var k=0;k<item.data.length;k++)
               {
                   dat.push(parseFloat(item.data[k]));
               }

                var obj = {};
                obj.name = item.name;
                obj.data = item.data;
                obj.stack = item.stack;
                arr.push(obj);
            });
            var myJsonString = JSON.stringify(arr);
            var jsonArray = JSON.parse(JSON.stringify(arr));

            console.log( jsonArray);
            Highcharts.chart('profit_loss', {

                chart: {
                    type: 'column'
                },

                title: {
                    text: 'Profit-Loss, Income & Expense'
                },

                xAxis: {
                    categories: data.category
                },

                yAxis: {
                    allowDecimals: false,
                    min: 0,
                    title: {
                        text: 'Amount'
                    }
                },

                tooltip: {
                    formatter: function () {
                        return '<b>' + this.x + '</b><br/>' +
                            this.series.name + ': ' + this.y + '<br/>' +
                            'Total: ' + this.point.stackTotal;
                    }
                },
                credits: {
                    text: 'A-I-T Solutions',
                    href: 'http://ait-solutions.org/'
                },
                plotOptions: {
                    column: {
                        stacking: 'normal'
                    }
                },

                series: jsonArray
            });
        },
        error: function (jqXHR, status, err) {

        }

    });


    /*Highcharts.chart('pie_container', {
        chart: {
            plotBackgroundColor: null,
            plotBorderWidth: null,
            plotShadow: false,
            type: 'pie'
        },
        title: {
            text: 'Browser market shares in January, 2018'
        },
        tooltip: {
            pointFormat: '{series.name}: <b>{point.percentage:.1f}%</b>'
        },
        plotOptions: {
            pie: {
                allowPointSelect: false,
                cursor: 'pointer',
                dataLabels: {
                    enabled: false
                },
                showInLegend: false
            }
        },
        series: [{
            name: 'Brands',
            colorByPoint: true,
            data: [{
                name: 'Chrome',
                y: 61.41,
                sliced: true,
                selected: true
            }, {
                name: 'Internet Explorer',
                y: 11.84
            }, {
                name: 'Firefox',
                y: 10.85
            }, {
                name: 'Edge',
                y: 4.67
            }, {
                name: 'Safari',
                y: 4.18
            }, {
                name: 'Other',
                y: 7.05
            }]
        }]
    });*/
}

get_receivables();
profit_graph();
BalanceReport();
get_monthly_sales();

function today_sale_details()
{
    jQuery(function ($) {
        var target = $('#today_sales_div');

        $('.toggle-loading').click(function () {
            if (target.hasClass('loading')) {
                target.loadingOverlay('remove');
            } else {
                target.loadingOverlay();
                $(".loading-overlay").css('z-index',5);
            };
        });
    });
    
    $("#today_sale_details_div").empty();
    $("#today_sale_details_div").append('<div class="table-responsive">\n\
        <table class="table table-bordered" width="100%" style="background-color: white;" id="today_sale_table">\n\
                        <thead>\n\
                        <tr style="background-color: wheat;color:#008D39;">\n\
                            <th style="text-align: center;">Product</th>\n\
                            <th style="text-align: center;">Cash Quan</th>\n\
                            <th style="text-align: center;">Credit Quan</th>\n\
                            <th style="text-align: center;">Total Quan</th>\n\
                            <th style="text-align: center;">Cash Sale</th>\n\
                            <th style="text-align: center;">Credit Sale</th>\n\
                            <th style="text-align: center;">Total Sale</th>\n\
                        </tr>\n\
                        </thead>\n\
                        <tbody id="today_sale_body">\n\
                        </tbody>\n\
                        <tfoot id="today_sale_foot">\n\
                        </tfoot>\n\
                    </table>\n\
                </div>');
    $("#today_sale_modal").modal('show');
        
    $("#today_sale_table").LoadingOverlay("show");

    $("#today_sale_table").LoadingOverlay("show", {
    background  : "rgba(171, 210, 236, 0.5)"
    });
    
    
    $.ajax({
        method: 'GET',
        url: '{{url("get_today_sales")}}',
        data: {
        },
        success: function(response)
        {
            $('.nav-md').css({'padding-right':'0px'});
            var balance_data = JSON.parse(response);
            var balance_length=balance_data.products.length;
            var j=0,k=0,l=0,m=0;
            var cash_total=0,credit_total=0;
            if(balance_length!==0)
            {
                for(var i=0;i<balance_length;i++)
                {
                    var total_quantity=0;
                    var total_sale=0;
                    var id='b'+i;
                    $("#today_sale_body").append('<tr id="'+id+'">\n\
                    <td style="text-align:center;border: 1px solid #78693A;font-size:12px;">'+balance_data.products[i].name+'</td></tr>');  
                     
                    if(balance_data.cash_quantity.length>0 && balance_data.cash_quantity.length>j) 
                    {
                       
                        if(balance_data.products[i].id==balance_data.cash_quantity[j].product_id)
                        {
                            $('#'+id+'').append('<td style="text-align:center;border: 1px solid #78693A;font-size:12px;">'+numberWithCommas(balance_data.cash_quantity[j].quantity)+'</td>');
                            total_quantity = parseFloat(total_quantity) + parseFloat(balance_data.cash_quantity[j].quantity);
                            j++;
                        }
                        else
                        {
                            $('#'+id+'').append('<td style="text-align:center;border: 1px solid #78693A;font-size:12px;">0</td>');
                        }
                    }
                    else
                    {
                        $('#'+id+'').append('<td style="text-align:center;border: 1px solid #78693A;font-size:12px;">0</td>');
                    }
                    
                    if(balance_data.credit_quantity.length>0 && balance_data.credit_quantity.length>k) 
                    {
                        if(balance_data.products[i].id==balance_data.credit_quantity[k].product_id)
                        {
                            $('#'+id+'').append('<td style="text-align:center;border: 1px solid #78693A;font-size:12px;">'+numberWithCommas(balance_data.credit_quantity[k].quantity)+'</td>');
                            total_quantity = parseFloat(total_quantity) + parseFloat(balance_data.credit_quantity[k].quantity);
                            k++;
                        }
                        else
                        {
                            $('#'+id+'').append('<td style="text-align:center;border: 1px solid #78693A;font-size:12px;">0</td>');
                        }
                    }
                    else
                    {
                        $('#'+id+'').append('<td style="text-align:center;border: 1px solid #78693A;font-size:12px;">0</td>');
                    }
                    
                    $('#'+id+'').append('<td style="text-align:center;border: 1px solid #78693A;font-size:12px;">'+numberWithCommas(total_quantity)+'</td>');
                    
                    if(balance_data.cash_sale.length>0 && balance_data.cash_sale.length>l) 
                    {
                        if(balance_data.products[i].id==balance_data.cash_sale[l].product_id)
                        {
                            $('#'+id+'').append('<td style="text-align:center;border: 1px solid #78693A;font-size:12px;">'+numberWithCommas(balance_data.cash_sale[l].amount)+'</td>');
                            total_sale = total_sale + parseFloat(balance_data.cash_sale[l].amount);
                            cash_total = parseFloat(cash_total) + parseFloat(balance_data.cash_sale[l].amount);
                            l++;
                        }
                        else
                        {
                            $('#'+id+'').append('<td style="text-align:center;border: 1px solid #78693A;font-size:12px;">0</td>');
                        }
                    }
                    else
                    {
                        $('#'+id+'').append('<td style="text-align:center;border: 1px solid #78693A;font-size:12px;">0</td>');
                    }
                    
                    if(balance_data.credit_sale.length>0 && balance_data.credit_sale.length>m) 
                    {
                        if(balance_data.products[i].id==balance_data.credit_sale[m].product_id)
                        {
                            $('#'+id+'').append('<td style="text-align:center;border: 1px solid #78693A;font-size:12px;">'+numberWithCommas(balance_data.credit_sale[m].amount)+'</td>');
                            total_sale = total_sale + parseFloat(balance_data.credit_sale[m].amount);
                            credit_total = credit_total + parseFloat(balance_data.credit_sale[m].amount);
                            m++;
                        }
                        else
                        {
                            $('#'+id+'').append('<td style="text-align:center;border: 1px solid #78693A;font-size:12px;">0</td>');
                        }
                    }
                    else
                    {
                        $('#'+id+'').append('<td style="text-align:center;border: 1px solid #78693A;font-size:12px;">0</td>');
                    }
                    
                    $('#'+id+'').append('<td style="text-align:center;border: 1px solid #78693A;font-size:12px;">'+numberWithCommas(total_sale)+'</td>');
                    
                }

                
                $("#today_sale_foot").append('<tr>' +
                        '<th colspan="4" style="text-align: center;">Total</th><th style="text-align:center;font-size:13px;">'+parseFloat(cash_total.toFixed(2))+'</th><th style="text-align:center;font-size:13px;">'+parseFloat(credit_total.toFixed(2))+'</th><th style="text-align: center;font-size:13px;">'+parseFloat(cash_total.toFixed(2)+credit_total.toFixed(2))+'</th></tr>');
            
                var table = $('#today_sale_table').DataTable({
                    "iDisplayLength": 1000,
                    "lengthMenu": [[10, 25, 500,1000,2000, -1], [10, 25, 500,1000,2000, "All"]],
                    "aaSorting": [[ 3, "desc" ]],
                    columnDefs: [
                        { type: 'formatted-num', targets: 1 }
                    ]
                });
            }
            $("#today_sale_table").LoadingOverlay("hide", true);
        },
        error: function (jqXHR, status, err) {

        }
    }); 
}

function show_active_customers()
{
    jQuery(function ($) {
        var target = $('#active_customers_div');

        $('.toggle-loading').click(function () {
            if (target.hasClass('loading')) {
                target.loadingOverlay('remove');
            } else {
                target.loadingOverlay();
                $(".loading-overlay").css('z-index',5);
            };
        });
    });
    
    $("#active_customer_details_div").empty();
    $("#active_customer_details_div").append('<div class="table-responsive">\n\
        <table class="table table-bordered" width="100%" style="background-color: white;" id="active_customer_table">\n\
            <thead>\n\
            <tr style="background-color: wheat;color:#008D39;">\n\
                <th style="text-align: center;">Type</th>\n\
                <th style="text-align: center;">Customer</th>\n\
            </tr>\n\
            </thead>\n\
            <tbody id="today_sale_body">\n\
            </tbody>\n\
            <tfoot id="today_sale_foot">\n\
            </tfoot>\n\
        </table>\n\
    </div>');
    $("#active_customer_modal").modal('show');
        
    $("#today_sale_table").LoadingOverlay("show");

    $("#today_sale_table").LoadingOverlay("show", {
    background  : "rgba(171, 210, 236, 0.5)"
    });
    
    $.ajax({
        method: 'GET',
        url: '{{url("get_active_customer_details")}}',
        data: {
        },
        success: function(response)
        {
            $('.nav-md').css({'padding-right':'0px'});
            var balance_data = JSON.parse(response);
            var balance_length=balance_data.result.length;
            var j=0;
            if(balance_length!==0)
            {
                for(var i=0;i<balance_length;i++)
                {
                    $("#today_sale_body").append('<tr>\n\
                    <td style="text-align:center;border: 1px solid #78693A;font-size:12px;">'+balance_data.result[i].type+'</td>\n\
                    <td style="text-align:center;border: 1px solid #78693A;font-size:12px;">'+balance_data.result[i].customers+'</td></tr>');  
                }
                
//                $("#today_sale_foot").append('<tr>' +
//                        '<th colspan="4" style="text-align: center;">Total</th><th style="text-align:center;font-size:13px;">'+parseFloat(cash_total.toFixed(2))+'</th><th style="text-align:center;font-size:13px;">'+parseFloat(credit_total.toFixed(2))+'</th><th style="text-align: center;font-size:13px;">'+parseFloat(cash_total.toFixed(2)+credit_total.toFixed(2))+'</th></tr>');
                
                var table = $('#today_sale_table').DataTable({
                    "iDisplayLength": 1000,
                    "lengthMenu": [[10, 25, 500,1000,2000, -1], [10, 25, 500,1000,2000, "All"]],
                    "aaSorting": [[ 3, "desc" ]],
                    columnDefs: [
                        { type: 'formatted-num', targets: 1 }
                    ]
                });
            }
            $("#active_customer_table").LoadingOverlay("hide", true);
        },
        error: function (jqXHR, status, err) {

        }
    }); 
}

function numberWithCommas(x) {
    return x.toString().replace(/\B(?=(\d{3})+(?!\d))/g, ",");
}

function roundToXDigits(value, digits)
{
    if (!digits) {
        digits = 2;
    }

    value = value * Math.pow(10, digits);
    value = Math.round(value);
    value = value / Math.pow(10, digits);

    return value;
}

function month_sale_details()
{
    jQuery(function ($) {
        var target = $('#month_sales_div');

        $('.toggle-loading').click(function () {
            if (target.hasClass('loading')) {
                target.loadingOverlay('remove');
            } else {
                target.loadingOverlay();
                $(".loading-overlay").css('z-index',5);
            };
        });
    });
    $("#month_sale_details_div").empty();
    $("#month_sale_details_div").append('<div class="table-responsive">\n\
        <table class="table table-bordered" width="100%" style="background-color: white;" id="month_sale_table">\n\
                        <thead>\n\
                        <tr style="background-color: wheat;color:#008D39;">\n\
                            <th style="text-align: center;">Product</th>\n\
                            <th style="text-align: center;">Cash Quan</th>\n\
                            <th style="text-align: center;">Credit Quan</th>\n\
                            <th style="text-align: center;">Total Quan</th>\n\
                            <th style="text-align: center;">Cash Sale</th>\n\
                            <th style="text-align: center;">Credit Sale</th>\n\
                            <th style="text-align: center;">Total Sale</th>\n\
                        </tr>\n\
                        </thead>\n\
                        <tbody id="month_sale_body">\n\
                        </tbody>\n\
                        <tfoot id="month_sale_foot">\n\
                        </tfoot>\n\
                    </table>\n\
                </div>');
    
    $("#month_sale_modal").modal('show');
        
    $("#month_sale_table").LoadingOverlay("show");

    $("#month_sale_table").LoadingOverlay("show", {
    background  : "rgba(171, 210, 236, 0.5)"
    });
    
    $.ajax({
        method: 'GET',
        url: '{{url("get_month_sales")}}',
        data: {
        },
        success: function(response)
        {
            $('.nav-md').css({'padding-right':'0px'});
            var balance_data = JSON.parse(response);
            var balance_length=balance_data.products.length;
           
            var j=0,k=0,l=0,m=0;
            var cash_total=0,credit_total=0;
            if(balance_length!==0)
            {
                for(var i=0;i<balance_length;i++)
                {
                    var total_quantity=0;
                    var total_sale=0;
                    var id='a'+i;
//                    $("#month_sale_body").append('<tr id="'+id+'">\n\
//                    <td style="text-align:center;border: 1px solid #78693A;font-size:12px;">'+balance_data.products[i].name+'</td>\n\
//                    <td style="text-align:center;border: 1px solid #78693A;font-size:12px;">'+balance_data.result[i].cash_quantity+'</td>\n\
//                    <td style="text-align:center;border: 1px solid #78693A;font-size:12px;">'+balance_data.result[i].credit_quantity+'</td>\n\
//                    <td style="text-align:center;border: 1px solid #78693A;font-size:12px;">'+balance_data.result[i].total_quantity+'</td>\n\
//                    <td style="text-align:center;border: 1px solid #78693A;font-size:12px;">'+balance_data.result[i].cash_sale+'</td>\n\
//                    <td style="text-align:center;border: 1px solid #78693A;font-size:12px;">'+balance_data.result[i].credit_sale+'</td>\n\
//                    <td style="text-align:center;border: 1px solid #78693A;font-size:12px;">'+balance_data.result[i].total_sale+'</td></tr>');  
                       
                    $("#month_sale_body").append('<tr id="'+id+'">\n\
                    <td style="text-align:center;border: 1px solid #78693A;font-size:12px;">'+balance_data.products[i].name+'</td></tr>');  
                     
                    if(balance_data.cash_quantity.length>0 && balance_data.cash_quantity.length>j) 
                    {
                        if(balance_data.products[i].id==balance_data.cash_quantity[j].product_id)
                        {
                            $('#'+id+'').append('<td style="text-align:center;border: 1px solid #78693A;font-size:12px;">'+numberWithCommas(balance_data.cash_quantity[j].quantity)+'</td>');
                            total_quantity = total_quantity + parseFloat(balance_data.cash_quantity[j].quantity);
                            j++;
                        }
                        else
                        {
                            $('#'+id+'').append('<td style="text-align:center;border: 1px solid #78693A;font-size:12px;">0</td>');
                        }
                    }
                    else
                    {
                        $('#'+id+'').append('<td style="text-align:center;border: 1px solid #78693A;font-size:12px;">0</td>');
                    }
                    
                    if(balance_data.credit_quantity.length>0 && balance_data.credit_quantity.length>k) 
                    {
                        if(balance_data.products[i].id==balance_data.credit_quantity[k].product_id)
                        {
                            $('#'+id+'').append('<td style="text-align:center;border: 1px solid #78693A;font-size:12px;">'+numberWithCommas(balance_data.credit_quantity[k].quantity)+'</td>');
                            total_quantity = total_quantity + parseFloat(balance_data.credit_quantity[k].quantity);
                            k++;
                        }
                        else
                        {
                            $('#'+id+'').append('<td style="text-align:center;border: 1px solid #78693A;font-size:12px;">0</td>');
                        }
                    }
                    else
                    {
                        $('#'+id+'').append('<td style="text-align:center;border: 1px solid #78693A;font-size:12px;">0</td>');
                    }
                    
                    $('#'+id+'').append('<td style="text-align:center;border: 1px solid #78693A;font-size:12px;">'+numberWithCommas(total_quantity)+'</td>');
                    
                    if(balance_data.cash_sale.length>0 && balance_data.cash_sale.length>l) 
                    {
                        if(balance_data.products[i].id==balance_data.cash_sale[l].product_id)
                        {
                            $('#'+id+'').append('<td style="text-align:center;border: 1px solid #78693A;font-size:12px;">'+numberWithCommas(balance_data.cash_sale[l].amount)+'</td>');
                            total_sale = total_sale + parseFloat(balance_data.cash_sale[l].amount);
                            cash_total = cash_total + parseFloat(balance_data.cash_sale[l].amount);
                            l++;
                        }
                        else
                        {
                            $('#'+id+'').append('<td style="text-align:center;border: 1px solid #78693A;font-size:12px;">0</td>');
                        }
                    }
                    else
                    {
                        $('#'+id+'').append('<td style="text-align:center;border: 1px solid #78693A;font-size:12px;">0</td>');
                    }
                    
                    if(balance_data.credit_sale.length>0 && balance_data.credit_sale.length>m) 
                    {
                        if(balance_data.products[i].id==balance_data.credit_sale[m].product_id)
                        {
                            $('#'+id+'').append('<td style="text-align:center;border: 1px solid #78693A;font-size:12px;">'+numberWithCommas(balance_data.credit_sale[m].amount)+'</td>');
                            total_sale = total_sale + parseFloat(balance_data.credit_sale[m].amount);
                            credit_total = credit_total + parseFloat(balance_data.credit_sale[m].amount);
                            m++;
                        }
                        else
                        {
                            $('#'+id+'').append('<td style="text-align:center;border: 1px solid #78693A;font-size:12px;">0</td>');
                        }
                    }
                    else
                    {
                        $('#'+id+'').append('<td style="text-align:center;border: 1px solid #78693A;font-size:12px;">0</td>');
                    }
                    
                    $('#'+id+'').append('<td style="text-align:center;border: 1px solid #78693A;font-size:12px;">'+numberWithCommas(total_sale)+'</td>');
                    
                }
                
                $("#month_sale_foot").append('<tr>' +
                        '<th colspan="4" style="text-align: center;">Total</th><th style="text-align:center;font-size:13px;">'+numberWithCommas(cash_total)+'</th><th style="text-align:center;font-size:13px;">'+numberWithCommas(credit_total)+'</th><th style="text-align: center;font-size:13px;">'+numberWithCommas(cash_total+credit_total)+'</th></tr>');
            
                var table = $('#month_sale_table').DataTable({
                    "iDisplayLength": 1000,
                    "lengthMenu": [[10, 25, 500,1000,2000, -1], [10, 25, 500,1000,2000, "All"]],
                    "aaSorting": [[ 3, "desc" ]],
                    columnDefs: [
                        { type: 'formatted-num', targets: 1 }
                    ]
                });
            
            }  
            
            $("#month_sale_table").LoadingOverlay("hide", true);
        },
        error: function (jqXHR, status, err) {

        }
    }); 
}

function receivable_details()
{
    jQuery(function ($) {
        var target = $('#today_sales_div');

        $('.toggle-loading').click(function () {
            if (target.hasClass('loading')) {
                target.loadingOverlay('remove');
            } else {
                target.loadingOverlay();
                $(".loading-overlay").css('z-index',5);
            };
        });
    });
    
    $("#receivable_body").empty();
    $("#receivable_foot").empty();
    $("#receivable_modal").modal('show');
        
    $("#receivable_table").LoadingOverlay("show");

    $("#receivable_table").LoadingOverlay("show", {
        background  : "rgba(171, 210, 236, 0.5)"
    });
    
    
    $.ajax({
        method: 'GET',
        url: '{{url("get_receivables_aging")}}',
        data: {
        },
        success: function(response)
        {
            $('.nav-md').css({'padding-right':'0px'});
            var balance_data = JSON.parse(response);
            var balance_length=balance_data.result.length;
            
            setTimeout(function(){
                $("#receivable_table").LoadingOverlay("hide", true);
            }, 500);
            
            if(balance_length!==0)
            {
                for(var i=0;i<balance_length;i++)
                {
                    var id='a'+i;
                    $("#receivable_body").append('<tr id="'+id+'"><td style="text-align:center; border: 1px solid #78693A;">'+balance_data.result[i].days+'</td><td style="text-align:center;border: 1px solid #78693A;">'+balance_data.result[i].amount+'</td></tr>');  
                }
                
            }  
        },
        error: function (jqXHR, status, err) {

        }
    }); 
}

function get_monthly_sales()
{
    jQuery(function ($) {
        var target = $('#monthly_div');

        $('.toggle-loading').click(function () {
            if (target.hasClass('loading')) {
                target.loadingOverlay('remove');
            } else {
                target.loadingOverlay();
                $(".loading-overlay").css('z-index',5);
            };
        });
    });
    
    $("#monthly_head").empty();
    //$("#receivable_foot").empty();
   
    $("#monthly_table").LoadingOverlay("show");

    $("#monthly_table").LoadingOverlay("show", {
        background  : "rgba(171, 210, 236, 0.5)"
    });
    var hash = new Object(); 
    var hash_sale = new Object();
    
    $.ajax({
        method: 'GET',
        url: '{{url("get_monthly_sales_fast")}}',
        data: {
        },
        success: function(response)
        {
            $('.nav-md').css({'padding-right':'0px'});
            var data = JSON.parse(response);
            var balance_length=data.result.length;
            var total_sale=0;
            var total_receiving=0;
            
            setTimeout(function(){
                $("#monthly_table").LoadingOverlay("hide", true);
            }, 100);
            
            $("#monthly_head").append('<tr id="mytd1" style="background-color:wheat;color:#008D39;"><th style="text-align:center;font-size:11px;">Month</th><th style="text-align:center;font-size:11px;">Sale</th><th style="text-align:center;font-size:11px;">Receiving</th></tr>');
            
            for(var k=0;k<data.products.length;k++)
            {
                $('#mytd1').append('<th style="text-align:center;font-size:11px;">'+data.products[k].name+'</th>');
            }
            
            if(balance_length!==0)
            {
                for(var i=0;i<data.months.length;i++)
                {
                    var id='a'+i;
                    $("#monthly_head").append('<tr class="'+id+'"><th style="text-align:center; color:#008D39; font-size:11px;">'+data.months[i]+'-'+data.year[i]+'</th><th style="text-align:center;font-size:12px;" id="'+data.months[i]+'-'+data.year[i]+'-sale'+'">0</th><th style="text-align:center;font-size:12px;"id="'+data.months[i]+'-'+data.year[i]+'-receiving'+'">0</th></tr>');  
                    
                    for(var l=0;l<data.products.length;l++)
                    {
                        $('.'+id+'').append('<th style="text-align:center;font-size:12px;" id="'+data.products[l].id+'-'+data.months[i]+'-'+data.year[i]+'-quantity'+'">0</th>');
                    }
                }
                
                
                for (var i = 0; i < data.result.length; i++)
                {
                    var quan_id=data.result[i].product_id+"-"+data.result[i].mm+"-"+data.result[i].yy+"-quantity";
                    console.log(quan_id);
                    //var am_id=data.result[i].product_id+"-"+data.result[i].mm+"-"+data.result[i].yy+"-amount";
                    //alert(quan_id);
                    $('#'+quan_id+'').text(numberWithCommas(roundToXDigits(data.result[i].actual_quantity,2)));
                    //$('#'+am_id+'').text(numberWithCommas(roundToXDigits(data.result[i].amount,2)));
                    
//                    var sale_id=data.result[i].mm+"-"+data.result[i].yy+"-sale";
//                    
//                    var sale =  $('#'+sale_id+'').text();
//                    var new_sale = parseFloat(sale)+parseFloat(data.result[i].amount);
//                    $('#'+sale_id+'').text(new_sale);
                    
                    var hash_sale_key = data.result[i].mm+"-"+data.result[i].yy+"-sale";

                    if(hash_sale[hash_sale_key]!==undefined)
                    {
                        var child_quan = parseFloat(hash_sale[hash_sale_key][0]['sale']) + parseFloat(data.result[i].amount);
                        //var child_amount = parseFloat(hash[hash_key][0]['amount']) + parseFloat(data.result[i].amount);
                        var child_array = [];
                        child_array.push({"sale": child_quan});

                        hash_sale[hash_sale_key] = child_array;
                    }
                    else
                    {
                        var child_array = [];
                        child_array.push({"sale": data.result[i].amount});

                        hash_sale[hash_sale_key]=child_array;
                    }

                    var hash_key = data.result[i].product_id+"-"+"total_quantity";

                    if(hash[hash_key]!==undefined)
                    {
                        var child_quan = parseFloat(hash[hash_key][0]['quantity']) + parseFloat(data.result[i].actual_quantity);
                        //var child_amount = parseFloat(hash[hash_key][0]['amount']) + parseFloat(data.result[i].amount);
                        var child_array = [];
                        child_array.push({"quantity": child_quan});

                        hash[hash_key] = child_array;
                    }
                    else
                    {
                        var child_array = [];
                        child_array.push({"quantity": data.result[i].actual_quantity});

                        hash[hash_key]=child_array;
                    }

                }

                console.log(hash);

                for (var i = 0; i < data.sales_return.length; i++)
                {
                    var quan_id=data.sales_return[i].product_id+"-"+data.sales_return[i].mm+"-"+data.sales_return[i].yy+"-quantity";
                    //var am_id=data.sales_return[i].product_id+"-"+data.sales_return[i].mm+"-"+data.sales_return[i].yy+"-amount";


                    var quantity =  parseFloat($('#'+quan_id+'').text().replace(/,/g,'')) - data.sales_return[i].actual_quantity;
                    //var amount = parseFloat($('#'+am_id+'').text().replace(/,/g,'')) - data.sales_return[i].amount;

                    $('#'+quan_id+'').text(numberWithCommas(roundToXDigits(quantity,2)));
                    //$('#'+am_id+'').text(numberWithCommas(roundToXDigits(amount,2)));
                    
//                    var sale_id=data.result[i].mm+"-"+data.result[i].yy+"-sale";
//                    
//                    var sale =  $('#'+sale_id+'').text();
//                    var new_sale = parseFloat(sale)-parseFloat(data.result[i].amount);
//                    $('#'+sale_id+'').text(new_sale);


                    var hash_sale_key = data.result[i].product_id+"-"+"total_quantity";

                    if(hash_sale[hash_sale_key]!==undefined)
                    {
                        var child_quan = parseFloat(hash_sale[hash_sale_key][0]['sale']) - parseFloat(data.result[i].amount);
                        //var child_amount = parseFloat(hash[hash_key][0]['amount']) + parseFloat(data.result[i].amount);
                        var child_array = [];
                        child_array.push({"sale": child_quan});

                        hash_sale[hash_sale_key] = child_array;
                    }
                    else
                    {
                        var child_array = [];
                        child_array.push({"sale": data.result[i].amount});

                        hash_sale[hash_sale_key]=child_array;
                    }

                    var hash_key = data.sales_return[i].mm+"-"+data.sales_return[i].yy;

                    if(hash[hash_key]!==undefined)
                    {
                        var child_quan = parseFloat(hash[hash_key][0]['quantity']) - parseFloat(data.sales_return[i].actual_quantity);
                        //var child_amount = parseFloat(hash[hash_key][0]['amount']) - parseFloat(data.sales_return[i].amount);
                        console.log(parseFloat(data.sales_return[i].amount));
                        console.log("\n");
                        var child_array = [];
                        child_array.push({"quantity": child_quan});

                        hash[hash_key] = child_array;
                    }
                    else
                    {
                        var child_array = [];
                        child_array.push({"quantity": data.sales_return[i].actual_quantity});

                        hash[hash_key]=child_array;
                    }

                }

                console.log(hash);
                
                
                
                for(var k=0;k<data.months.length;k++)
                {
                    var hash_sale_key = data.months[k]+"-"+data.year[k]+"-sale";
                    if(hash_sale[hash_sale_key]!==undefined)
                    {
                        total_sale=total_sale+hash_sale[hash_sale_key][0]['sale'];
                        $('#'+hash_sale_key+'').text(numberWithCommas(roundToXDigits(hash_sale[hash_sale_key][0]['sale'],2)));
                        
                        //$("#tfoot").append('<th style="text-align:center; font-size:14px;">'+numberWithCommas(roundToXDigits(hash[hash_key][0]['quantity'],2))+'</th><th style="text-align:center;font-size:14px;">'+numberWithCommas(roundToXDigits(hash[hash_key][0]['amount'],2))+'</th>');
                    }
                }
                
                
                for (var i = 0; i < data.receiving.length; i++)
                {
                    var rec_id=data.receiving[i].mm+"-"+data.receiving[i].yy+"-receiving";
                    total_receiving=total_receiving+data.receiving[i].amount;
                    $('#'+rec_id+'').text(numberWithCommas(roundToXDigits(data.receiving[i].amount,2)));
                }
                
                
            } 
            
            for(var k=0;k<data.products.length;k++)
            {
                //var hash_key = data.months[k]+"-"+data.year[k];
                var hash_key = data.products[k].id+"-"+"total_quantity";
                if(hash[hash_key]!==undefined)
                {
                    $("#monthly_foot").append('<th style="text-align:center; font-size:14px;">'+numberWithCommas(roundToXDigits(hash[hash_key][0]['quantity'],2))+'</th>');
                }
                else
                {
                    $("#monthly_foot").append('<th style="text-align:center; font-size:14px;">0</th>');
                }
            }
            
//            for(var m=0;m<balance_data.full_all_products.length;m++)
//            {
//                $("#monthly_foot").append('<th style="text-align:center;">'+balance_data.full_all_products[m]+'</th>');
//            }
            
            $("#total_month_sale").text(numberWithCommas(roundToXDigits(total_sale,2)));
            $("#total_month_receiving").text(numberWithCommas(roundToXDigits(total_receiving,2)));
            
            
            var table = $('#monthly_table').DataTable({
                paging: false
            });
            
            
            $("#monthly_table_filter").hide();
            $("#monthly_table_info").hide();
        },
        error: function (jqXHR, status, err) {

        }
    }); 
}
//get_customer_above_credit_limit();
function get_customer_above_credit_limit()
{
    jQuery(function ($) {
        var target = $('#credit_limit_div');

        $('.toggle-loading').click(function () {
            if (target.hasClass('loading')) {
                target.loadingOverlay('remove');
            } else {
                target.loadingOverlay();
                $(".loading-overlay").css('z-index',5);
            };
        });
    });
    
    $("#credit_limit_head").empty();
    //$("#receivable_foot").empty();
   
    $("#credit_limit_table").LoadingOverlay("show");

    $("#credit_limit_table").LoadingOverlay("show", {
        background  : "rgba(171, 210, 236, 0.5)"
    });
    var hash = new Object(); 
    var hash_sale = new Object();
    
    $.ajax({
        method: 'GET',
        url: '{{url("get_customer_above_credit_limit")}}',
        data: {
        },
        success: function(response)
        {
            $('.nav-md').css({'padding-right':'0px'});
            var data = JSON.parse(response);
            var balance_length=data.customers.length;
            var total_sale=0;
            var total_receiving=0;
            
            setTimeout(function(){
                $("#credit_limit_table").LoadingOverlay("hide", true);
            }, 100);
            
            $("#credit_limit_head").append('<tr id="mytd2" style="background-color:wheat;color:#008D39;"><th style="text-align:center;font-size:11px;">ID</th><th style="text-align:center;font-size:11px;">Customer</th><th style="text-align:center;font-size:11px;">Credit Limit</th><th style="text-align:center;font-size:11px;">Balance</th></tr>');
            
            
            
            if(balance_length!==0)
            {
                for(var i=0;i<data.customers.length;i++)
                {
                    $("#credit_limit_table").append('<tr><th style="text-align:center; color:#008D39; font-size:11px;">'+data.customers[i].customer_id+'</th><th style="text-align:center; color:#008D39; font-size:11px;">'+data.customers[i].name+'</th><th style="text-align:center;font-size:12px;">'+data.customers[i].credit_limit+'</th><th style="text-align:center;font-size:12px;">'+numberWithCommas(roundToXDigits(data.customers[i].amount,2))+'</th></tr>');  
                }    
            }
            
            var table = $('#credit_limit_table').DataTable({
                paging: false,
                scrollY: "360px",
                aaSorting: [[ 3, "desc" ]]
            });
            
            $("#credit_limit_table_filter").hide();
            $("#credit_limit_table_info").hide();
            
        },
        error: function (jqXHR, status, err) {

        }
    }); 
}

</script>

@endsection