@extends('layouts.app')

@section('content')
<div class="container">
     <h3>Generar Pedido</h3>
        <div class="row">
            <div class="col-sm-5">
                <label for="suppliersearch">Proveedor</label>
                <input type="suppliersearch" class="form-control" id="suppliersearch">
                <input type="hidden" class="form-control" id="supplierid" value='0'>
            </div>  

          
        </div>
       <br />
       <br />
        <table class="table table-bordered">
            <tr><td>RFC: </td><td><span id="lbrfc"></span></td><td>Persona Contacto: </td><td><span id="lbcontact"></span></td></tr>
            <tr><td>Telefono: </td><td><span id="lbphone"></span></td><td>Email: </td><td><span id="lbmail"></span></td></tr>
            <tr><td>Dirección: </td><td><span id="lbaddress"></span></td><td>Tipo Pago</td><td><span id="lbpaymenttype"></span></td></tr>
        </table>
  
    <fieldset class="border p-2">
        <legend class="w-auto h-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 class="col-sm-5">
              <img src="http://via.placeholder.com/360x360" alt="..." class="img-thumbnail">
            </div> 
        </div>
        <br />
        <br />
        <div class="row">
            <div class="col-sm-10">
                <table class="table table-bordered" id="tbl_inventory">
                    <thead>
                        <tr>
                            <td>Codigo</td>
                            <td>Producto</td>
                            <td>Cantidad</td>
                            <td>Costo</td>
                            <td>SubTotal</td>
                            <td>IVA</td>
                            <td>IEPS</td>
                            <td>Total</td>
                            <td style="display: none">Id</td>
                            <td>Borrar</td>
                        </tr>
                    </thead>
                </table>
            </div>
            <div class="col-sm-2">
                <div class="w-65 p-3 " style="background-color: #eee; text-align: right;">SubTotal: <span id="txtSubTotal"></span></div>
                <div class="w-65 p-3" style="background-color: #eee; text-align: right;">Impuestos: <span id="txtTaxes"></span></div>
                <div class="w-65 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>
        
        
    </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></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 tblProducts;
var insertar = [];
$( document ).ready(function() {
    
    $("#suppliersearch").autocomplete({
		    delay: 1000,
        source: function( request, response ) {
            $.ajax({
                url : "{{ route('searchsupplier') }}",
                dataType: "json",
                type: "GET",
                data: {
                    searchdata: request.term
                },
                success: function( data ) {
                    response( $.map( data, function( item ) {
                    console.log(item.resultado);
                            return {
                                label: item.id+"-"+item.name,
                                value: item.id+"-"+item.name,
                                data : item
                            }
                    }));
                }
            });
        },
        messages: {
            noResults: '',
            results: function() {}
        },
        autoFocus: true,	      	
        minLength: 2,
        select: function( event, ui ) {
            var supplierData = ui.item.data;
            $("#supplierid").val(supplierData.id);
            $("#lbname").html(supplierData.name);
            $("#lbrfc").html(supplierData.rfc);
            $("#lbcontact").html(supplierData.contact);
            $("#lbphone").html(supplierData.telephone1+" "+supplierData.telephone2);
            $("#lbmail").html(supplierData.email);
            $("#lbaddress").html(supplierData.address);
            $("#lbpaymenttype").html(supplierData.paymenttype);
            
  
            
        }		      	
    });

    $("#productsearch").autocomplete({
		    delay: 1000,
        source: function( request, response ) {
            $.ajax({
                url : "{{ route('searchproductpo') }}",
                dataType: "json",
                type: "GET",
                data: {
                    searchdata: request.term,
                    supplierid: $("#supplierid").val()
                },
                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 productData = ui.item.data;
             
            insertar = [
                productData.code,
                productData.name,
                0,
                productData.cost,
                0,
                productData.iva,
                productData.ieps,
                0,
                productData.id
            ];

           
           
            
        }		      	
    });

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

    tblProducts =  $('#tbl_inventory').DataTable({
        ordering :false,
        paging:false,
        language: {
              "url": "//cdn.datatables.net/plug-ins/9dcbecd42ad/i18n/Spanish.json"
              },
        dom: 't',
        aoColumnDefs: [
           { "width": "40%", "targets": 1 },
           {
            "targets": [ 8 ],
            "visible": false,
            "searchable": false
           }
        ]
    });

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

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

        var inventory = tblProducts.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 ) {
                
                tblProducts.rows().every( function ( rowIdx, tableLoop, rowLoop ) {
                    var value =  this.data();
                   
                    if(value['0'] == insertar['0'] ) {

                        var data = tblProducts.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);
                        //tblProducts.row( index ).col(4) = cant + cantOld;
                        tblProducts.cell({row:rowIdx, column:2}).data(cant + cantOld)
                        tblProducts.cell({row:rowIdx, column:4}).data(insertar[4])
                        tblProducts.cell({row:rowIdx, column:5}).data(insertar[5])
                        tblProducts.cell({row:rowIdx, column:6}).data(insertar[6])
                        tblProducts.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='#' id='btndelete' class='btn btn-danger'>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() 
                    tblProducts.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'>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() 
                tblProducts.row.add(insertar).draw();
                $("#productqty").val("");
                $("#productsearch").val("");

              
               
            }

            updateTotal()

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

    });

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

    $("#btnGrabar").on('click', function() {
        $body = $("body");
      //  $body.addClass("loading");
        var inventory = tblProducts.rows().data();
        var allproducts = [];
        
        $.each(inventory, function(index,value) {
            allproducts[index] = { 
                products_id: value[8],
                qty: value[2] , 
                cost: currency(value[3]),
                subtotal : currency(value[4]),
                iva : currency(value[5]),
                ieps: currency(value[6]),
                total: currency(value[7]),

            };
        })
        var supplier = $("#supplierid").val();
        var comments = $("#comments").val();
        var counter = 0;
        

        $.ajax({
            type: 'POST',
            url: "{{ route('purchaseorders.store') }}", // call your php file
            data: { products: JSON.stringify(allproducts),_token: $("#_token").val(),supplierid: supplier, comments: comments },
            cache: false,
            success: function(data){
               // var info = JSON.parse(data);
              if(data) {
                var info = JSON.parse(data);
                $body.removeClass("loading");
                tblProducts
                    .rows()
                    .remove()
                    .draw();
                alert('La Orden de compra fue generada');
                window.open(info.pdf);
                window.location.replace( "{{ action('PurchaseorderController@index') }}" );
              } 
            },
            error: function(xhr, ajaxOptions, thrownError) {
                alert(xhr);
            } 
        });
    })

    function updateTotal() {
        var SubTotal = 0;
        var Total = 0;
        var Tax1Total = 0;
        var Tax2Total = 0;
        tblProducts.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;
           
            //tblProducts.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() );
    }
});

</script>
@endpush