@extends('layouts.app')

@section('content')
<div class="container">
     <h3>Detalle de  Pedido</h3>
        <div class="row top-buffer">
            <div class="col-sm-5">
                <label for="clientsearch">Cliente</label>
                <input type="clientsearch" class="form-control" id="clientsearch" value="{{ $client->name }}" disabled>
                <input type="hidden" class="form-control" id="customerid" value="{{ $client->id }}">
                <input type="hidden" class="form-control" id="pricelistid" value="{{ $client->pricelist_id }}">
                <input type="hidden" class="form-control" id="orderid" value="{{ $order->id }}">
                <input type="hidden" class="form-control" id="orderstatus" value="{{ $order->status }}">
            </div> 
            <div class="col-sm-5">
                <label for="clientsearch">Estatus</label>
                <select class="form-control" id="cmbStatus" name="cmbStatus">
                    @foreach($status as $stat)
                    <option value="{{ $stat->id }}">{{ $stat->name}}</option>
                    @endforeach
                </select> 
            </div>
            

          
        </div>
       <br />
       <br />
        <table class="table table-bordered">
            <tr><td>RFC: </td><td><span id="lbrfc">{{ $client->rfc }}</span></td><td>Contacto: </td><td><span id="lbcontact">{{ $client->contac1.$client->contact2 }}</span></td></tr>
            <tr><td>Telefono: </td><td><span id="lbphone">{{ $client->phone }}</span></td><td>Email: </td><td><span id="lbmail">{{ $client->mail }}</span></td></tr>
        </table>
  
    <fieldset class="border p-2">
        <legend class="w-auto">Productos</legend>
        <div class="row">
            <div class="col-sm-5">
                <label for="productsearch">Producto</label>
                <input type="productsearch" class="form-control" id="productsearch">
                <input type="hidden" class="form-control" id="productid">
            </div>  
            <div class="col-sm-1">
                <label for="productqty">Cantidad</label>
                <input type="productqty" class="form-control" id="productqty">
            </div>  
            <div class="col-sm-1">
                <label for="productqty">Accion</label>
                <a href="#" class="btn btn-success" id="btnAdd" name="btnAdd">Agregar</a>
            </div>   
        </div>
        <br />
        <br />
        <div class="row">
            <div class="col-sm-9">
                <table class="table table-bordered" id="tbl_inventory">
                    <thead>
                        <tr>
                            <td>Codigo</td>
                            <td>Producto</td>
                            <td>Cantidad</td>
                            <td>Precio</td>
                            <td>SubTotal</td>
                            <td>IVA</td>
                            <td>IEPS</td>
                            <td>Total</td>
                            <td style="display: none">Id</td>
                            <td>Borrar</td>
                        </tr>
                    </thead>
                    
                    <tbody>
                    @foreach($orderdetails as $orderdetail)
                        <tr>
                            <td>{{$orderdetail->code}}</td>
                            <td>{{$orderdetail->productname}}</td>
                            <td>{{$orderdetail->qty}}</td>
                            <td>{{$orderdetail->price}}</td>
                            <td>{{$orderdetail->subtotal}}</td>
                            <td>{{$orderdetail->taxes1}}</td>
                            <td>{{$orderdetail->taxes2}}</td>
                            <td>{{$orderdetail->total}}</td>
                            <td style="display: none">{{$orderdetail->id}}</td>
                            <td><a href='#'  class='btn btn-danger btndelete'>Borrar</a></td>
                        </tr>
                    @endforeach
                    </tbody>
                </table>
            </div>
            <div class="col-sm-3">
                <div class="w-60 p-3 " style="background-color: #eee; text-align: right;">SubTotal: <span id="txtSubTotal"></span></div>
                <div class="w-60 p-3" style="background-color: #eee; text-align: right;">Impuestos: <span id="txtTaxes"></span></div>
                <div class="w-60 p-3 " style="background-color: #eee; text-align: right;">Total: <span id="txtTotal"></span></div>
            </div>
        </div>
    </fieldset>
    <fieldset>
    <legend>Comentarios</legend>
        
        <div class="row">
            <div class="col-md-12"><textarea class="form-control" id="comments" rows="4" cols="50"></textarea></div>
        </div>
        <h3>Historico</t3>
        <table class="table table-bordered" id="tbl_inventory">
            <thead>
                <tr>
                    <td>id</td>
                    <td>Tipo</td>
                    <td>Comentario</td>
                    <td>Fecha</td>
                </tr>
            </thead>
            <tbody>
            @foreach ($comments as $comment)
                <tr>
                    <td>{{ $comment->id }}</td>
                    <td>{{ $comment->type }}</td>
                    <td>{{ $comment->comments }}</td>
                    <td>{{ $comment->created_at }}</td>
                </tr>
            @endforeach
            </tbody>
        </table>
    </fieldset>
   
        <div class="row top-buffer">
            <input type="hidden" name="_token" id="_token" value="{{ csrf_token() }}">
            <div class="col-md-12">
                <a href="#" class="btn btn-success" id="btnGrabar" name="btnGrabar">Grabar</a>
                <a href="#" class="btn btn-success" id="btnFacturar" name="btnFacturar">Facturar</a>
            </div>
            
        </div>
    
    <div class="modal"><!-- Place at bottom of page --></div>

</div>
@stop
@push('scripts')
<script src="//cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"> defer</script>
<script src="https://cdn.datatables.net/buttons/1.0.3/js/dataTables.buttons.min.js"></script>
<script>
var tblInventory,orderstatus;
var insertar = [];
$( document ).ready(function() {
    orderStatus( $("#orderstatus").val() );
    $("#cmbStatus").val( $("#orderstatus").val() );


    $("#cmbStatus").on('change', function() {
        orderStatus( $(this).val() );
    });
    
    $("#clientsearch").autocomplete({
		    delay: 1000,
        source: function( request, response ) {
            $.ajax({
                url : "{{ route('searchclient') }}",
                dataType: "json",
                type: "GET",
                data: {
                    searchdata: request.term
                },
                success: function( data ) {
                    response( $.map( data, function( item ) {
                    console.log(item.resultado);
                            return {
                                label: item.code+"-"+item.name,
                                value: item.code+"-"+item.name,
                                data : item
                            }
                    }));
                }
            });
        },
        messages: {
            noResults: '',
            results: function() {}
        },
        autoFocus: true,	      	
        minLength: 2,
        select: function( event, ui ) {
            var clientData = ui.item.data;
            $("#customerid").val(clientData.id);
            $("#lbname").html(clientData.name);
            $("#lbrfc").html(clientData.rfc);
            $("#lbcontac").html(clientData.contact1+" "+clientData.contact2);
            $("#lbphone").html(clientData.telephone1+" "+clientData.telephone2);
            $("#lbmail").html(clientData.email);
            $("#pricelistid").val(clientData.pricelist_id);

             
           
           
            
        }		      	
    });

    $("#productsearch").autocomplete({
		    delay: 1000,
        source: function( request, response ) {
            $.ajax({
                url : "{{ route('searchproduct') }}",
                dataType: "json",
                type: "GET",
                data: {
                    searchdata: request.term,
                    pricelistid: $("#pricelistid").val()
                },
                success: function( data ) {
                    response( $.map( data, function( item ) {
                    console.log(item.resultado);
                            return {
                                label: item.code+"-"+item.name+" Inventario:"+item.available,
                                value: item.code+"-"+item.name,
                                data : item
                            }
                    }));
                }
            });
        },
        messages: {
            noResults: '',
            results: function() {}
        },
        autoFocus: true,	      	
        minLength: 2,
        select: function( event, ui ) {
            var productData = ui.item.data;
             
            insertar = [
                productData.code,
                productData.name,
                0,
                productData.price,
                0,
                productData.taxes1,
                productData.taxes2,
                0,
                productData.id
            ];

           
           
            
        }		      	
    });

    $('#tbl_inventory tbody').on( 'click', 'a', function () {
        if( $("#orderstatus").val() == 1 ) {
            tblInventory
            .row( $(this).parents('tr') )
            .remove()
            .draw();
        } else {
            alertMod();
           
        }
    } );

    tblInventory =  $('#tbl_inventory').DataTable({
        ordering :false,
        language: {
              "url": "//cdn.datatables.net/plug-ins/9dcbecd42ad/i18n/Spanish.json"
              },
        dom: 't',
        aoColumnDefs: [
           
           {
            "targets": [ 8 ],
            "visible": false,
            "searchable": false
           }
        ],
        initComplete: function(settings, json) {
            updateTotal()
        }
    });

   
     

    $('#productqty').keypress(function(event){
            if(event.keyCode == 13){
                $('#btnAdd').click();
            }
        });

    $("#btnAdd").on("click", function() {
        if($("#orderstatus").val() < '3') {
            var inventory = tblInventory.rows().data();
            if($("#productqty").val().length > 0 && Number.isInteger( parseInt( $("#productqty").val() ) ) ) {
                var counter = 0;
                var SubTotal = 0;
                var Total = 0;
                var Tax1Total = 0;
                var Tax2Total = 0;
                insertar[3] = currency(insertar[3])
                insertar[4] = currency(insertar[4])
                insertar[5] = currency(insertar[5])
                insertar[6] = currency(insertar[6])
                insertar[7] = currency(insertar[7])

                if(inventory.length > 0 ) {
                    
                    tblInventory.rows().every( function ( rowIdx, tableLoop, rowLoop ) {
                        var value =  this.data();
                    
                        if(value['0'] == insertar['0'] ) {

                            var data = tblInventory.rows( rowIdx ).data();
                            cant = parseInt(insertar[2]) + parseInt($("#productqty").val());
                            cantOld = parseInt(data[0][2]);
                            //Calcular SubTotal
                            insertar[4] = currency( (cant+cantOld)* insertar[3].value );
                            //Calcular Iva y IEPS
                            insertar[5] = currency( insertar[5].value * ( (cant+cantOld)* insertar[3].value ) );
                            insertar[6] = currency( insertar[6].value * ( (cant+cantOld)* insertar[3].value ) );

                            total = ( insertar[4].value + insertar[5].value + insertar[6].value);
                            //tblInventory.row( index ).col(4) = cant + cantOld;
                            tblInventory.cell({row:rowIdx, column:2}).data(cant + cantOld)
                            tblInventory.cell({row:rowIdx, column:4}).data(insertar[4])
                            tblInventory.cell({row:rowIdx, column:5}).data(insertar[5])
                            tblInventory.cell({row:rowIdx, column:6}).data(insertar[6])
                            tblInventory.cell({row:rowIdx, column:7}).data(currency(total , { formatWithSymbol: true }).format())
                            $("#productqty").val("");
                            $("#productsearch").val("");
                    
                            counter++;
                            return false;
                            
                        } 
                    });

                    if(counter == 0) {
                        var cant = parseInt(insertar[2]) + parseInt($("#productqty").val());
                        insertar[2] = cant;
                        //Calcular SubTotal
                        insertar[4] = currency( ( cant* insertar[3].value ) );
                        //Calcular Iva y IEPS
                        insertar[5] = currency(insertar[5].value * ( cant* insertar[3].value ) );
                        insertar[6] = currency(insertar[6].value * ( cant* insertar[3].value ) );
                    
                        insertar[7] = currency( insertar[4] + insertar[5].value + insertar[6].value , { formatWithSymbol: true }).format() 
                        insertar.push( "<a href='#'  class='btn btn-danger btndelete'>Borrar</a>" );
                        insertar[3] = currency( insertar[3] , { formatWithSymbol: true }).format() 
                        insertar[4] = currency( insertar[4] , { formatWithSymbol: true }).format() 
                        insertar[5] = currency( insertar[5] , { formatWithSymbol: true }).format() 
                        insertar[6] = currency( insertar[6] , { formatWithSymbol: true }).format() 
                        tblInventory.row.add(insertar).draw();
                        $("#productqty").val("");
                        $("#productsearch").val("");

            
                        
                    }



                } else {
                    var cant =  parseInt($("#productqty").val());
                    insertar[2] =  cant
                    //Calcular SubTotal
                    insertar[4] = ( cant* insertar[3].value );
                    //Calcular Iva y IEPS
                    insertar[5] = insertar[5].value * insertar[4];
                    insertar[6] = insertar[6].value * insertar[4];
                    insertar[7] = currency( insertar[4] + insertar[5] + insertar[6] , { formatWithSymbol: true }).format() ;
                    insertar.push( "<a href='#' id='btndelete' class='btn btn-danger btndelete'>Borrar</a>" );
                    insertar[3] = currency( insertar[3] , { formatWithSymbol: true }).format() 
                    insertar[4] = currency( insertar[4] , { formatWithSymbol: true }).format() 
                    insertar[5] = currency( insertar[5] , { formatWithSymbol: true }).format() 
                    insertar[6] = currency( insertar[6] , { formatWithSymbol: true }).format() 
                    tblInventory.row.add(insertar).draw();
                    $("#productqty").val("");
                    $("#productsearch").val("");

                
                
                }

                updateTotal()

            } else {
                alert('Debes Capturar una Cantidad');
            }
        } else {
            alertMod();
        }

    });

    $('#tbl_inventory tbody').on( 'click', 'a', function () {
        tblInventory
        .row( $(this).parents('tr') )
        .remove()
        .draw();
    } );

    $("#btnGrabar").on('click', function() {
        if($("#orderstatus").val() < '3') {
            $body = $("body");
            $body.addClass("loading");
            var inventory = tblInventory.rows().data();
            var allproducts = [];
            
            $.each(inventory, function(index,value) {
                allproducts[index] = { 
                    products_id: value[8],
                    qty: value[2] , 
                    price: currency(value[3]),
                    subtotal : currency(value[4]),
                    taxes1 : currency(value[5]),
                    taxes2: currency(value[6]),
                    total: currency(value[7]),

                };
            })
            var client = $("#customerid").val();
            var comments = $("#comments").val();
            var counter = 0;
            

            $.ajax({
                type: 'POST',
                url: "{{ route('orders.store') }}", // call your php file
                data: { products: JSON.stringify(allproducts),_token: $("#_token").val(),client_id: client, comments: comments },
                cache: false,
                success: function(data){
                // var info = JSON.parse(data);
                if(data) {
                    $body.removeClass("loading");
                    tblInventory
                        .rows()
                        .remove()
                        .draw();
                    alert('La Orden fue generada');
                    
                    window.location.replace( "{{ action('OrderController@index') }}" );
                }  
                }
            });
        } else {
            alertMod();
        }
    })

    $("#btnFacturar").on("click", function() {

        var customerId = $("#customerid").val();

        $.ajax({
            type: 'GET',
            url: "{{ route('createinvoice') }}", // call your php file
            data: { custId: customerId  },
            cache: false,
            success: function(data){
            // var info = JSON.parse(data);
              alert(data);
            }
        });

    })

    
 
});

    function updateTotal() {
        var SubTotal = 0;
        var Total = 0;
        var Tax1Total = 0;
        var Tax2Total = 0;
        tblInventory.rows().every( function ( rowIdx, tableLoop, rowLoop ) {
            var value =  this.data();
            var subTotal = currency(value[4]);
            var tax1 = currency(value[5]);
            var tax2 = currency(value[6]);
          

            SubTotal = SubTotal + subTotal.value;
            Tax1Total = Tax1Total + tax1.value;
            Tax2Total = Tax2Total + tax2.value;
           
            //tblInventory.cell({row:rowIdx, column:2}).data(cant + cantOld)
        });

        Total = Total + SubTotal + Tax1Total + Tax2Total;

        $("#txtSubTotal").html( currency( SubTotal, { formatWithSymbol: true }).format() );
        $("#txtTaxes").html( currency(Tax1Total + Tax2Total, { formatWithSymbol: true }).format() );
        $("#txtTotal").html(currency(Total, { formatWithSymbol: true }).format() );
    }

    function orderStatus(ordstatus) {
        switch(ordstatus) {
          case "1":
            $("#productsearch").attr('disabled',true);
            $("#productqty").attr('disabled',true);
            $("#btnAdd").attr('disabled',true);
            $("#btnGrabar").attr('disabled',true);
            $(".btndelete").attr('disabled',true);
          break;
          case "7":
            $("#productsearch").attr('disabled',false);
            $("#productqty").attr('disabled',false);
            $("#btnAdd").attr('disabled',false);
            $("#btnGrabar").attr('disabled',false);
            $(".btndelete").attr('disabled',false);
          break;
          default:
            $("#productsearch").attr('disabled',true);
            $("#productqty").attr('disabled',true);
            $("#btnAdd").attr('disabled',true);
            $("#btnGrabar").attr('disabled',true);
            $(".btndelete").attr('disabled',true);
         
          
        }
    }

    function alertMod() {
        var valor = $("#cmbStatus option:selected").text()
        alert("La Orden no puede ser modificada porque esta en Estatus: "+valor )

    }

</script>
@endpush