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

@section('title', __('messages.estimates'))
    
@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+MXmPNIyE2JWhb2IMqE241rYiqJxyMiZ6OW/JmZQ5stwEULTy' crossorigin='anonymous'></script>

        <div class='text-center'>
            <a href='#myModal' class='trigger-btn' data-toggle='modal'></a>
        </div>

        <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Ó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 Aquí</a>
                    </div>
                </div>
            </div>
        </div>

        <script>
            $('#myModal').modal('toggle');
        </script>
        ";
        echo $html;
        break;
    }
}

@endphp

<div class="orders-page">
    <div class="page__heading d-flex align-items-center justify-content-between flex-wrap">
        <div class="flex">
            <nav aria-label="breadcrumb">
                <ol class="breadcrumb mb-1">
                    <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.estimates') }}</li>
                </ol>
            </nav>
            <h1 class="m-0 page-title">{{ __('messages.estimates') }}</h1>
        </div>

        <a href="{{ route('estimates.create') }}" class="btn btn-success btn-create-order ml-3">
            <i class="material-icons">add</i>
            {{ __('messages.create_estimate') }}
        </a>
    </div>

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

    $result2 = mysqli_query($con2, "SELECT * FROM estimates ORDER BY id DESC");

    while($row = mysqli_fetch_array($result2)){ 
        $estatus = $row["estatus"];

        if (strpos($estatus, 'PAGO WEB') !== false) {  
            $html2 = "
            <div class='alert alert-warning mt-3 mb-4' role='alert'>
                COTIZACIÓN | Actualizar Pagos Vía Web.
                <a href='https://dashboard.boxshoplogistics.com/estimates/all?filter%5Bestatus%5D=PAGO+WEB' class='alert-link'>Ver aquí</a>.
            </div>";
            echo $html2;
            break;
        }
    }
    @endphp
</div>
@endsection

@section('content')
<div class="orders-page">

    <div class="filters-wrapper mb-4">
        @include('application.estimates._filters')
    </div>

    <div class="table-card">
        <div class="card-header bg-white p-0 border-0">
        </div>

        @include('application.estimates._table')
    </div>

</div>
@endsection