@extends('layouts.admin.app')

@section('content')
    <h3>@lang("dashboard.Dashboard")</h3>
    <div class="row">
        <div class="col-md-9 col-sm-9 col-xs-9" style="background: #02383C;padding-bottom: 10px;">
            <div class="main-section">
                <div class="dashbord">
                    <div class="icon-section">
                        <i class="fa fa-calendar-check-o" aria-hidden="true"></i><br>
                        <small>@lang("dashboard.Today's Sales")</small>
                        <p>{{ $today_sale->count() }}</p>
                    </div>
                    <div class="detail-section">
                        <a href="javascript:void(0);"></a>
                    </div>
                </div>
                <div class="dashbord dashbord-green">
                    <div class="icon-section">
                        <i class="fa fa-retweet" aria-hidden="true"></i><br>
                        <small>@lang("dashboard.Today's Sales Return")</small>
                        <p>{{ $today_sale_return_count }}</p>
                    </div>
                    <div class="detail-section">
                        <a href="javascript:void(0);"></a>
                    </div>
                </div>
                <div class="dashbord dashbord-orange">
                    <div class="icon-section">
                        <i class="fa fa-bell" aria-hidden="true"></i><br>
                        <small>@lang("dashboard.Alert")</small>
                        <p>{{ $alert_count }}</p>
                    </div>
                    <div class="detail-section">
                        <a href="{{ route('admin.reports.ledger.stockAlert') }}"></a>
                    </div>
                </div>
                <div class="dashbord dashbord-red">
                    <div class="icon-section">
                        <i class="fa fa-money" aria-hidden="true"></i><br>
                        <small>@lang("dashboard.Daily Sales")</small>
                        <p>৳ {{ round($today_sale->sum('total'), 2) }}</p>
                    </div>
                    <div class="detail-section">
                        <a href="javascript:void(0);"></a>
                    </div>
                </div>
                <div class="dashbord dashbord-blue">
                    <div class="icon-section">
                        <i class="fa fa-money" aria-hidden="true"></i><br>
                        <small>@lang("dashboard.Today's Expense")</small>
                        <p>৳ {{ round($today_expense_count, 2) }}</p>
                    </div>
                    <div class="detail-section">
                        <a href="javascript:void(0);"></a>
                    </div>
                </div>
                <div class="dashbord dashbord-red">
                    <div class="icon-section">
                        <i class="fa fa-money" aria-hidden="true"></i><br>
                        <small>@lang("dashboard.Total Sales")</small>
                        <p>৳ {{ round($totla_sale, 2) }}</p>
                    </div>
                    <div class="detail-section">
                        <a href="javascript:void(0);"></a>
                    </div>
                </div>
                <div class="dashbord dashbord-skyblue">
                    <div class="icon-section">
                        <i class="fa fa-money" aria-hidden="true"></i><br>
                        <small>@lang("dashboard.Total Purchase")</small>
                        <p>৳ {{ $totla_purchase }}</p>
                    </div>
                    <div class="detail-section">
                        <a href="javascript:void(0);"></a>
                    </div>
                </div>
                <div class="dashbord dashbord-red">
                    <div class="icon-section">
                        <i class="fa fa-money" aria-hidden="true"></i><br>
                        <small>@lang("dashboard.Customer Dues")</small>
                        <p>৳ {{ round($customer_dues, 2) }}</p>
                    </div>
                    <div class="detail-section">
                        <a href="javascript:void(0);"></a>
                    </div>
                </div>
                <div class="dashbord dashbord-skyblue">
                    <div class="icon-section">
                        <i class="fa fa-money" aria-hidden="true"></i><br>
                        <small>@lang("dashboard.Supplier Dues")</small>
                        <p>৳ {{ round($supplier_dues, 2) }}</p>
                    </div>
                    <div class="detail-section">
                        <a href="javascript:void(0);"></a>
                    </div>
                </div>
                <div class="dashbord">
                    <div class="icon-section">
                        <i class="fa fa-users" aria-hidden="true"></i><br>
                        <small>@lang("dashboard.Total Customer")</small>
                        <p>{{ count($client->where('type', 'customer')) }}</p>
                    </div>
                    <div class="detail-section">
                        <a href="javascript:void(0);"></a>
                    </div>
                </div>
                <div class="dashbord dashbord-green">
                    <div class="icon-section">
                        <i class="fa fa-users" aria-hidden="true"></i><br>
                        <small>@lang("dashboard.Total Supplier")</small>
                        <p>{{ count($client->where('type', 'supplier')) }}</p>
                    </div>
                    <div class="detail-section">
                        <a href="javascript:void(0);"></a>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-md-3 col-sm-3 col-xs-3">
            <h5 class="card-subtitle mb-2 text-muted">@lang("dashboard.My Task")</h5><hr>
            <form method="POST" action="{{ url('/admin/taskManager/task') }}" accept-charset="UTF-8"
                class="form-horizontal" enctype="multipart/form-data">
                {{ csrf_field() }}
                <div class="row mb-5">
                    <div class="col-md-8 col-sm-8 col-xs-8">
                        <textarea class="form-control" name="note" id="note" cols="10" rows="3"></textarea>
                    </div>
                    <div class="col-md-4 col-sm-4 col-xs-4">
                        <input class="btn btn-primary btn-sm" type="submit" value="@lang("dashboard.Add")">
                    </div>
                </div>
            </form>
            @foreach ($myTask as $item)
                <div class="row mb-3">
                    <div class="col-md-8 col-sm-8 col-xs-8" style="border-left-style: ridge; -webkit-text-stroke: thin;">
                        {{$item->note}}
                    </div>
                    <div class="col-md-4 col-sm-4 col-xs-4">
                        <form method="POST" id="deleteButton{{$item->id}}"
                            action="{{ url('/admin/taskManager/task' . '/' . $item->id) }}" accept-charset="UTF-8"
                            style="display:inline">
                            {{ method_field('DELETE') }}
                            {{ csrf_field() }}
                            <button type="submit" class="btn btn-danger btn-sm" title="Delete Task"
                                onclick="sweetalert2Delete({{$item->id}})"><i class="fa fa-trash"
                                    aria-hidden="true"></i></button>
                        </form>
                    </div>
                </div>
            @endforeach
        </div>
    </div>
    <hr>
    <div class="row">
        <div class="col-sm-12 col-xs-12" style="background: #fff;">
            <div class="line_chart">
                <div style="padding-top: 10px;">
                    <h4>@lang("dashboard.Sales & Puechase Summary")</h4>
                    <div class="text-muted" style="float: left;margin: 0 10px;">@lang("dashboard.Sales Amount")</div><div style="background: green;width: 20px;height: 15px;float: left;margin: 4px;"></div>
                    <div class="text-muted" style="float: left;margin: 0 10px;">@lang("dashboard.Purchased Amount")</div><div style="background: blue;width: 20px;height: 15px;float: left;margin: 4px;"></div>
                    <div class="text-muted" style="float: left;margin: 0 10px;">@lang("dashboard.Profit Amount")</div><div style="background: red;width: 20px;height: 15px;float: left;margin: 4px;"></div>
                </div><br><br>
                <canvas id="lineChart" width="400" height="150"></canvas>
            </div>
        </div>
    </div>

    <div class="row" style="background: #fff;">
        <div class="col-md-6 col-sm-6 col-xs-6">
            <div class="card m-3" style="max-height: 32rem; overflow: auto;">
                <div class="card-body">
                    <h5 class="card-subtitle mb-2 text-muted">@lang("dashboard.Customer Dues")</h5>
                    <div class="table-responsive">
                <table class="table datatable">
                    <thead>
                        <tr>
                            <th scope="col" width='10'>#</th>
                            <th scope="col">@lang("dashboard.Date")</th>
                            <th scope="col">@lang("dashboard.Name")</th>
                            <th scope="col">@lang("dashboard.Amount")</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach ($client->where('type', 'customer')->whereNotNull('due')->where('due', '>', '0') as $item)
                            <tr>
                                <td>{{ $loop->iteration }}</td>
                                <td>{{ isset($item->date)?$item->date:'' }}</td>
                                <td>{{ isset($item->title)?$item->title:'' }}</td>
                                <td>{{ isset($item->due)?$item->due:'0' }}</td>
                            </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
                </div>
            </div>
        </div>
        <div class="col-md-6 col-sm-6 col-xs-6">
            <div class="card m-3" style="max-height: 32rem; overflow: auto;">
                <div class="card-body">
                    <h5 class="card-subtitle mb-2 text-muted">@lang("dashboard.Supplier Dues")</h5>
                    <div class="table-responsive">
                <table class="table datatable">
                    <thead>
                        <tr>
                            <th scope="col" width='10'>#</th>
                            <th scope="col">@lang("dashboard.Date")</th>
                            <th scope="col">@lang("dashboard.Name")</th>
                            <th scope="col">@lang("dashboard.Amount")</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach ($client->where('type', 'supplier')->whereNotNull('due')->where('due', '>', '0') as $item)
                            <tr>
                                <td>{{ $loop->iteration }}</td>
                                <td>{{ isset($item->date)?$item->date:'' }}</td>
                                <td>{{ isset($item->title)?$item->title:'' }}</td>
                                <td>{{ isset($item->due)?$item->due:'' }}</td>
                            </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
                </div>
            </div>
        </div>
        <div class="col-md-6 col-sm-6 col-xs-6">
            <div class="card m-3" style="max-height: 32rem; overflow: auto;">
                <div class="card-body">
                    <h5 class="card-subtitle mb-2 text-muted">@lang("dashboard.Today's Stock Out Product")</h5>
                    <div class="table-responsive">
                        <table class="table datatable">
                            <thead>
                                <tr>
                                    <th scope="col" width='10'>#</th>
                                    <th scope="col">@lang("dashboard.Date")</th>
                                    <th scope="col">@lang("dashboard.Invoice") #</th>
                                    <th scope="col">@lang("dashboard.Product")</th>
                                    <th scope="col">@lang("dashboard.QTY")</th>
                                    <th scope="col">@lang("dashboard.Amount")</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach ($today_stock_out as $item)
                                    <tr>
                                        <td>{{ $loop->iteration }}</td>
                                        <td>{{ isset($item->date)?$item->date:'' }}</td>
                                        <td> <a href="{{ url('/admin/saleRegisters/sale/' . $item->sale_invoice_id) }}">INV-000{{ isset($item->sale_invoice_id)?$item->sale_invoice_id:'' }}</a></td>
                                        <td>{{ isset($item->getProduct->title)?$item->getProduct->title:'' }}</td>
                                        <td>{{ isset($item->qty)?$item->qty:'' }}</td>
                                        <td>৳ {{ isset($item->total)?$item->total:'' }}</td>
                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-md-6 col-sm-6 col-xs-6">
            <div class="card m-3" style="max-height: 32rem; overflow: auto;">
                <div class="card-body">
                    <h5 class="card-subtitle mb-2 text-muted">@lang("dashboard.Today's Stock In Product")</h5>
                    <div class="table-responsive">
                        <table class="table datatable">
                            <thead>
                                <tr>
                                    <th scope="col" width='10'>#</th>
                                    <th scope="col">@lang("dashboard.Date")</th>
                                    <th scope="col">@lang("dashboard.Invoice") #</th>
                                    <th scope="col">@lang("dashboard.Product")</th>
                                    <th scope="col">@lang("dashboard.QTY")</th>
                                    <th scope="col">@lang("dashboard.Amount")</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach ($today_stock_in as $item)
                                    <tr>
                                        <td>{{ $loop->iteration }}</td>
                                        <td>{{ isset($item->date)?$item->date:'' }}</td>
                                        <td> <a href="{{ url('/admin/purchaseRegisters/purchase/' . $item->purchase_invoice_id) }}">INV-000{{ isset($item->purchase_invoice_id)?$item->purchase_invoice_id:'' }}</a></td>
                                        <td>{{ isset($item->getProduct->title)?$item->getProduct->title:'' }}</td>
                                        <td>{{ isset($item->qty)?$item->qty:'' }}</td>
                                        <td>৳ {{ isset($item->total)?$item->total:'' }}</td>
                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>

    
    @php
    $user_landing_page = App\UserLandingPage::where('user_id', Auth::user()->id)->first();
    // dd($user_landing_page->landing_page);
    @endphp
    @if (isset($user_landing_page->landing_page))
        <script>
            window.location = "{{ $user_landing_page->landing_page }}";

        </script>
    @endif



    {{-- Line Chart --}}
    <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.9.3/Chart.min.js"></script>
    <script>
    var jan_sales_amount = 0; var fab_sales_amount = 0; var mar_sales_amount = 0; var apr_sales_amount = 0; var may_sales_amount = 0; var jun_sales_amount = 0;
    var jul_sales_amount = 0; var aug_sales_amount = 0; var sep_sales_amount = 0; var oct_sales_amount = 0; var nov_sales_amount = 0; var dec_sales_amount = 0;

    var jan_purchase_amount = 0; var fab_purchase_amount = 0; var mar_purchase_amount = 0; var apr_purchase_amount = 0; var may_purchase_amount = 0; var jun_purchase_amount = 0;
    var jul_purchase_amount = 0; var aug_purchase_amount = 0; var sep_purchase_amount = 0; var oct_purchase_amount = 0; var nov_purchase_amount = 0; var dec_purchase_amount = 0;
    
    var jan_profit_amount = 0; var fab_profit_amount = 0; var mar_profit_amount = 0; var apr_profit_amount = 0; var may_profit_amount = 0; var jun_profit_amount = 0;
    var jul_profit_amount = 0; var aug_profit_amount = 0; var sep_profit_amount = 0; var oct_profit_amount = 0; var nov_profit_amount = 0; var dec_profit_amount = 0;
    
    // saleInvoice table
    var array = @json($saleInvoiceForlineChart);
    console.log(array);
    array.forEach(salesArrFunction);
    function salesArrFunction(value){
        if(new Date(value["date"]).getMonth()==0){
            if(value["payable"]!=null){
            jan_sales_amount = jan_sales_amount + parseFloat(value["payable"]);
            }
        }
        if(new Date(value["date"]).getMonth()==1){
            if(value["payable"]!=null){
            fab_sales_amount = fab_sales_amount + parseFloat(value["payable"]);
            }
        }
        if(new Date(value["date"]).getMonth()==2){
            if(value["payable"]!=null){
            mar_sales_amount = mar_sales_amount + parseFloat(value["payable"]);
            }
        }
        if(new Date(value["date"]).getMonth()==3){
            if(value["payable"]!=null){
            apr_sales_amount = apr_sales_amount + parseFloat(value["payable"]);
            }
        }
        if(new Date(value["date"]).getMonth()==4){
            if(value["payable"]!=null){
            may_sales_amount = may_sales_amount + parseFloat(value["payable"]);
            }
        }
        if(new Date(value["date"]).getMonth()==5){
            if(value["payable"]!=null){
            jun_sales_amount = jun_sales_amount + parseFloat(value["payable"]);
            }
        }
        if(new Date(value["date"]).getMonth()==6){
            if(value["payable"]!=null){
            jul_sales_amount = jul_sales_amount + parseFloat(value["payable"]);
            }
        }
        if(new Date(value["date"]).getMonth()==7){
            if(value["payable"]!=null){
            aug_sales_amount = aug_sales_amount + parseFloat(value["payable"]);
            }
        }
        if(new Date(value["date"]).getMonth()==8){
            if(value["payable"]!=null){
            sep_sales_amount = sep_sales_amount + parseFloat(value["payable"]);
            }
        }
        if(new Date(value["date"]).getMonth()==9){
            if(value["payable"]!=null){
            oct_sales_amount = oct_sales_amount + parseFloat(value["payable"]);
            }
        }
        if(new Date(value["date"]).getMonth()==10){
            if(value["payable"]!=null){
            nov_sales_amount = nov_sales_amount + parseFloat(value["payable"]);
            }
        }
        if(new Date(value["date"]).getMonth()==11){
            if(value["payable"]!=null){
            dec_sales_amount = dec_sales_amount + parseFloat(value["payable"]);
            }
        }

    }

    //purchaseInvoice table
    var array = @json($purchaseInvoiceForlineChart);
    console.log(array);
    array.forEach(purchaseArrFunction);
    function purchaseArrFunction(value){
        if(new Date(value["date"]).getMonth()==0){
            if(value["payable"]!=null){
            jan_purchase_amount = jan_purchase_amount + parseFloat(value["payable"]);
            }
        }
        if(new Date(value["date"]).getMonth()==1){
            if(value["payable"]!=null){
            fab_purchase_amount = fab_purchase_amount + parseFloat(value["payable"]);
            }
        }
        if(new Date(value["date"]).getMonth()==2){
            if(value["payable"]!=null){
            mar_purchase_amount = mar_purchase_amount + parseFloat(value["payable"]);
            }
        }
        if(new Date(value["date"]).getMonth()==3){
            if(value["payable"]!=null){
            apr_purchase_amount = apr_purchase_amount + parseFloat(value["payable"]);
            }
        }
        if(new Date(value["date"]).getMonth()==4){
            if(value["payable"]!=null){
            may_purchase_amount = may_purchase_amount + parseFloat(value["payable"]);
            }
        }
        if(new Date(value["date"]).getMonth()==5){
            if(value["payable"]!=null){
            jun_purchase_amount = jun_purchase_amount + parseFloat(value["payable"]);
            }
        }
        if(new Date(value["date"]).getMonth()==6){
            if(value["payable"]!=null){
            jul_purchase_amount = jul_purchase_amount + parseFloat(value["payable"]);
            }
        }
        if(new Date(value["date"]).getMonth()==7){
            if(value["payable"]!=null){
            aug_purchase_amount = aug_purchase_amount + parseFloat(value["payable"]);
            }
        }
        if(new Date(value["date"]).getMonth()==8){
            if(value["payable"]!=null){
            sep_purchase_amount = sep_purchase_amount + parseFloat(value["payable"]);
            }
        }
        if(new Date(value["date"]).getMonth()==9){
            if(value["payable"]!=null){
            oct_purchase_amount = oct_purchase_amount + parseFloat(value["payable"]);
            }
        }
        if(new Date(value["date"]).getMonth()==10){
            if(value["payable"]!=null){
            nov_purchase_amount = nov_purchase_amount + parseFloat(value["payable"]);
            }
        }
        if(new Date(value["date"]).getMonth()==11){
            if(value["payable"]!=null){
            dec_purchase_amount = dec_purchase_amount + parseFloat(value["payable"]);
            }
        }

    }

    //Profit table
    var array = @json($saleForlineChart);
    console.log(array);
    array.forEach(profitArrFunction);
    function profitArrFunction(value){
        if(new Date(value["date"]).getMonth()==0){
            if(value["total"]!=null){
                let sale=value["total"];
                let cost=value["purchase_value"]?value["purchase_value"]:0;
                let return_sale=value["return_amount"]?value["return_amount"]:0;
                let return_cost=((return_sale)/(sale))*(cost);
                let profit=(sale-return_sale)-(cost-return_cost);
                if (value["qty"]!=0 && value["rate"]!=0) {
                    jan_profit_amount = jan_profit_amount + parseFloat(profit);
                }
            }
        }
        if(new Date(value["date"]).getMonth()==1){
            if(value["total"]!=null){
                let sale=value["total"];
                let cost=value["purchase_value"]?value["purchase_value"]:0;
                let return_sale=value["return_amount"]?value["return_amount"]:0;
                let return_cost=((return_sale)/(sale))*(cost);
                let profit=(sale-return_sale)-(cost-return_cost);
                if(value["qty"]!=0 && value["rate"]!=0){
                    fab_profit_amount = fab_profit_amount + parseFloat(profit);
                }
            }
        }
        if(new Date(value["date"]).getMonth()==2){
            if(value["total"]!=null){
                let sale=value["total"];
                let cost=value["purchase_value"]?value["purchase_value"]:0;
                let return_sale=value["return_amount"]?value["return_amount"]:0;
                let return_cost=((return_sale)/(sale))*(cost);
                let profit=(sale-return_sale)-(cost-return_cost);
                if(value["qty"]!=0 && value["rate"]!=0){
                    mar_profit_amount = mar_profit_amount + parseFloat(profit);
                }
            }
        }
        if(new Date(value["date"]).getMonth()==3){
            if(value["total"]!=null){
                let sale=value["total"];
                let cost=value["purchase_value"]?value["purchase_value"]:0;
                let return_sale=value["return_amount"]?value["return_amount"]:0;
                let return_cost=((return_sale)/(sale))*(cost);
                let profit=(sale-return_sale)-(cost-return_cost);
                if(value["qty"]!=0 && value["rate"]!=0){
                    apr_profit_amount = apr_profit_amount + parseFloat(profit);
                }
            }
        }
        if(new Date(value["date"]).getMonth()==4){
            if(value["total"]!=null){
                let sale=value["total"];
                let cost=value["purchase_value"]?value["purchase_value"]:0;
                let return_sale=value["return_amount"]?value["return_amount"]:0;
                let return_cost=((return_sale)/(sale))*(cost);
                let profit=(sale-return_sale)-(cost-return_cost);
                if(value["qty"]!=0 && value["rate"]!=0){
                    may_profit_amount = may_profit_amount + parseFloat(profit);
                }
            }
        }
        if(new Date(value["date"]).getMonth()==5){
            if(value["total"]!=null){
                let sale=value["total"];
                let cost=value["purchase_value"]?value["purchase_value"]:0;
                let return_sale=value["return_amount"]?value["return_amount"]:0;
                let return_cost=((return_sale)/(sale))*(cost);
                let profit=(sale-return_sale)-(cost-return_cost);
                if(value["qty"]!=0 && value["rate"]!=0){
                    jun_profit_amount = jun_profit_amount + parseFloat(profit);
                }
            }
        }
        if(new Date(value["date"]).getMonth()==6){
            if(value["total"]!=null){
                let sale=value["total"];
                let cost=value["purchase_value"]?value["purchase_value"]:0;
                let return_sale=value["return_amount"]?value["return_amount"]:0;
                let return_cost=((return_sale)/(sale))*(cost);
                let profit=(sale-return_sale)-(cost-return_cost);
                if(value["qty"]!=0 && value["rate"]!=0){
                    jul_profit_amount = jul_profit_amount + parseFloat(profit);
                }
            }
        }
        if(new Date(value["date"]).getMonth()==7){
            if(value["total"]!=null){
                let sale=value["total"];
                let cost=value["purchase_value"]?value["purchase_value"]:0;
                let return_sale=value["return_amount"]?value["return_amount"]:0;
                let return_cost=((return_sale)/(sale))*(cost);
                let profit=(sale-return_sale)-(cost-return_cost);
                if(value["qty"]!=0 && value["rate"]!=0){
                    aug_profit_amount = aug_profit_amount + parseFloat(profit);
                }
            }
        }
        if(new Date(value["date"]).getMonth()==8){
            if(value["total"]!=null){
                let sale=value["total"];
                let cost=value["purchase_value"]?value["purchase_value"]:0;
                let return_sale=value["return_amount"]?value["return_amount"]:0;
                let return_cost=((return_sale)/(sale))*(cost);
                let profit=(sale-return_sale)-(cost-return_cost);
                if(value["qty"]!=0 && value["rate"]!=0){
                    sep_profit_amount = sep_profit_amount + parseFloat(profit);
                }
            }
        }
        if(new Date(value["date"]).getMonth()==9){
            if(value["total"]!=null){
                let sale=value["total"];
                let cost=value["purchase_value"]?value["purchase_value"]:0;
                let return_sale=value["return_amount"]?value["return_amount"]:0;
                let return_cost=((return_sale)/(sale))*(cost);
                let profit=(sale-return_sale)-(cost-return_cost);
                if(value["qty"]!=0 && value["rate"]!=0){
                    oct_profit_amount = oct_profit_amount + parseFloat(profit);
                }
            }
        }
        if(new Date(value["date"]).getMonth()==10){
            if(value["total"]!=null){
                let sale=value["total"];
                let cost=value["purchase_value"]?value["purchase_value"]:0;
                let return_sale=value["return_amount"]?value["return_amount"]:0;
                let return_cost=((return_sale)/(sale))*(cost);
                let profit=(sale-return_sale)-(cost-return_cost);
                if(value["qty"]!=0 && value["rate"]!=0){
                    nov_profit_amount = nov_profit_amount + parseFloat(profit);
                }
            }
        }
        if(new Date(value["date"]).getMonth()==11){
            if(value["total"]!=null){
                let sale=value["total"];
                let cost=value["purchase_value"]?value["purchase_value"]:0;
                let return_sale=value["return_amount"]?value["return_amount"]:0;
                let return_cost=((return_sale)/(sale))*(cost);
                let profit=(sale-return_sale)-(cost-return_cost);
                if(value["qty"]!=0 && value["rate"]!=0){
                    dec_profit_amount = dec_profit_amount + parseFloat(profit);
                }
            }
        }

    }

    var xValues = ['Jan', 'Fab', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'];

    new Chart("lineChart", {
        type: "line",
        data: {
        labels: xValues,
        datasets: [{ 
                data: [jan_sales_amount, fab_sales_amount, mar_sales_amount, apr_sales_amount, may_sales_amount, jun_sales_amount, jul_sales_amount, aug_sales_amount, sep_sales_amount, oct_sales_amount, nov_sales_amount, dec_sales_amount],
                borderColor: "green",
                fill: false
            }, { 
                data: [jan_purchase_amount, fab_purchase_amount, mar_purchase_amount, apr_purchase_amount, may_purchase_amount, jun_purchase_amount, jul_purchase_amount, aug_purchase_amount, sep_purchase_amount, oct_purchase_amount, nov_purchase_amount, dec_purchase_amount],
                borderColor: "blue",
                fill: false
            }, { 
                data: [jan_profit_amount, fab_profit_amount, mar_profit_amount, apr_profit_amount, may_profit_amount, jun_profit_amount, jul_profit_amount, aug_profit_amount, sep_profit_amount, oct_profit_amount, nov_profit_amount, dec_profit_amount],
                borderColor: "red",
                fill: false
            }]
        },
        options: {
        legend: {display: false}
        }
    });
        
    </script>
    {{-- line chart end --}}

@endsection