@extends('layouts.app', ['page' => 'dashboard'])

@section('title', __('Dashboard - Servicio de Compras'))

@section('page_header')

@php

$con1 = mysqli_connect("localhost","boxshopd_compras","c0GvwJvfhslg","boxshopd_billing");
    if (mysqli_connect_errno()){
	echo "Failed to connect to MySQL: " . mysqli_connect_error();
	die();
	}


$result = mysqli_query(
    $con1,
    "SELECT * FROM estimates ORDER BY id DESC"
    );
while($row = mysqli_fetch_array($result)){ 
$estatus1 = $row["estatus"];
$html ="";

if (strpos($estatus1, 'POR COTIZAR') !== false) {  
$html = "  <script src='https://code.jquery.com/jquery-3.3.1.slim.min.js' integrity='sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo' crossorigin='anonymous'></script>
<script src='https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.3/umd/popper.min.js' integrity='sha384-ZMP7rVo3mIykV+2+9J3UJ46jBk0WLaUAdn689aCwoqbBJiSnjAK/l8WvCWPIPm49' crossorigin='anonymous'></script>
<script src='https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js' integrity='sha384-ChfqqxuZUCnJSK3+MXmPNIyE6ZbWh2IMqE241rYiqJxyMiZ6OW/JmZQ5stwEULTy' crossorigin='anonymous'></script>
<div class='text-center'>
                <a href='#myModal' class='trigger-btn' data-toggle='modal'></a>
            </div>   

        <!-- Modal HTML -->
        <div id='myModal' class='modal fade'>
            <div class='modal-dialog modal-login'>
                <div class='modal-content'>
                    <div class='modal-header'>
                        <h4 class='modal-title'>COTIZACIÓN PENDIENTE</h4>
                        <button type='button' class='close' data-dismiss='modal' aria-hidden='true'>&times;</button>
                    </div>
                    <div class='modal-body'>
                        
<p style='text-align: center;'>HAY UNA COTIZACI&Oacute;N PENDIENTE POR ACTUALIZAR.</p>
<p style='text-align: center;'>VERIFICAR POR FAVOR</p>

                    </div>
                    <div class='modal-footer'><a href='https://dashboard.boxshoplogistics.com/estimates/all?filter%5Bid%5D=&filter%5Bestatus%5D=POR+COTIZAR'>Verificar Aqui!</a></div>
                </div>
            </div>
        </div>  
         <script>
     {
    $('#myModal').modal('toggle')
};
</script>";
echo $html;
}}	

@endphp



      <div class="page__heading d-flex align-items-center">

        
        <div class="flex">
                <a href="{{ route('invoices.create') }}" class="btn btn-success">
            <i class="material-icons">add</i> 
            Crear Orden
        </a>
        
           <a href="{{ route('estimates.create') }}" class="btn btn-success">
            <i class="material-icons">add</i> 
            Crear Cotizacion
        </a>
<p>&nbsp;</p>

            <nav aria-label="breadcrumb">
                <ol class="breadcrumb mb-0">
                    <li class="breadcrumb-item"><a href="#"><i class="material-icons icon-20pt">home</i></a></li>
                    <li class="breadcrumb-item active" aria-current="page">{{ __('messages.dashboard') }}</li>
                </ol>
            </nav>
            @if(($authUser->reportecarga) == "1")
            <iframe src="https://recepcion.boxshoplogistics.com/dashboard.php?user={{ $authUser->full_name }}&role={{ $authUser->getRoleNames()->first() }}" width="100%" height="1200">
</iframe>
@endif

            <h1 class="m-0">{{ __('messages.dashboard') }}</h1>
        </div>
        
    </div>
    
@endsection

@section('content')



    <div class="row card-group-row">
        <div class="col-lg-3 col-md-6 card-group-row__col">
            <div class="card card-group-row__card">
                <div class="card-body-x-lg card-body d-flex flex-row align-items-center">
                    <div class="flex">
                        <a href="{{route('customers')}}" class="text-decoration-none">
                            <div class="card-header__title text-muted mb-2 d-flex">
                                Clientes
                            </div>
                            <span class="h4 m-0">{{ $customersCount }}</span>
                        </a>
                    </div>
                    <div><i class="material-icons icon-muted icon-40pt ml-3">account_box</i></div>
                </div>
            </div>
        </div>
        <div class="col-lg-3 col-md-6 card-group-row__col">
            <div class="card card-group-row__card">
                <div class="card-body-x-lg card-body d-flex flex-row align-items-center">
                    <div class="flex">
                        <a href="https://billing.boxshopdavid.com/invoices/all" class="text-decoration-none">
                            <div class="card-header__title text-muted mb-2 d-flex">
                                Ordenes
                            </div>
                            <span class="h4 m-0">{{ $invoicesCount }}</span>
                        </a>
                    </div>
                    <div><i class="material-icons icon-muted icon-40pt ml-3">receipt</i></div>
                </div>
            </div>
        </div>
        <div class="col-lg-3 col-md-6 card-group-row__col">
            <div class="card card-group-row__card">
                <div class="card-body-x-lg card-body d-flex flex-row align-items-center">
                    <div class="flex">
                        <a href="{{route('estimates')}}" class="text-decoration-none">
                            <div class="card-header__title text-muted mb-2 d-flex">
                                Estimados
                            </div>
                            <span class="h4 m-0">{{ $estimatesCount }}</span>
                        </a>
                    </div>
                    <div><i class="material-icons icon-muted icon-40pt ml-3">description</i></div>
                </div>
            </div>
        </div>
        <div class="col-lg-3 col-md-6 card-group-row__col">
            <div class="card card-group-row__card">
                <div class="card-body-x-lg card-body d-flex flex-row align-items-center">
                    <div class="flex">
                        <div class="card-header__title text-muted mb-2 d-flex">Deuda Clientes</div>
                        <span class="h4 m-0">{!! money($totalDueAmount, $currentCompany->currency->code) !!}</span>
                    </div>
                    <div><i class="material-icons icon-muted icon-40pt ml-3">monetization_on</i></div>
                </div>
            </div>
        </div>
    </div>

   

    
@endsection

@section('page_body_scripts')
    <script src="{{ asset('assets/js/settings.js') }}"></script>
    <script src="{{ asset('assets/vendor/Chart.min.js') }}"></script>
    <script src="{{ asset('assets/js/chartjs-rounded-bar.js') }}"></script>
    <script src="{{ asset('assets/js/charts.js') }}"></script>

    <script>
        (function () {
            'use strict';
            Charts.init();

            var Orders = function Orders(id) {
                var type = arguments.length > 1 && arguments[1] !== undefined ? arguments[1] : 'roundedBar';
                var options = arguments.length > 2 && arguments[2] !== undefined ? arguments[2] : {};
                options = Chart.helpers.merge({
                    barRoundness: 1.2,
                    scales: {
                        yAxes: [{
                            ticks: {
                                callback: function callback(a) {
                                    return a.toLocaleString("en-US", {style:"currency", currency: "{{ $currency_code }}"});
                                }
                            }
                        }]
                    },
                    tooltips: {
                        callbacks: {
                            label: function label(a, e) {
                                var t = e.datasets[a.datasetIndex].label || "",
                                    o = a.yLabel,
                                    r = "",
                                    val = o.toLocaleString("en-US", {style:"currency", currency: "{{ $currency_code }}"});
                                return 1 < e.datasets.length && (r += '<span class="popover-body-label mr-auto">' + t + "</span>"), r += '<span class="popover-body-value">' + val + "</span>";
                            }
                        }
                    }
                }, options);
                var data = {
                    labels: @json($expense_stats_label),
                    datasets: [{
                        label: "Expenses",
                        data: @json($expense_stats)
                    }]
                };
                Charts.create(id, type, options, data);
            };
            Orders('#expensesChart');
        })();
    </script>
   
@endsection