Ayuda con un insert en laravel

  • Autor Autor pa3lo022
  • Fecha de inicio Fecha de inicio
Les agradezco a ambos por la mano, la verdad me tendria que haber dedicado a corte y confección, no puede hacer nada con esto. Les paso el codigo completo.

Blade:

Insertar CODE, HTML o PHP:
@extends('layouts.mainAdmin')

@section('breadcrumb', 'Agregar nueva Ventas')

@section('script')
    <script type="text/javascript"
            src="{{ asset('styleAdmin/assets/js/plugins/forms/selects/bootstrap_select.min.js' )}}"></script>
    <script type="text/javascript" src="{{ asset('styleAdmin/assets/js/pages/form_bootstrap_select.js' )}}"></script>

    {{--<link href="//maxcdn.bootstrapcdn.com/bootstrap/3.3.0/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css">--}}
    {{--<script src="//maxcdn.bootstrapcdn.com/bootstrap/3.3.0/js/bootstrap.min.js"></script>--}}
    <script src="//code.jquery.com/jquery-1.11.1.min.js"></script>

    <script>
        $(document).ready(function () {
            var i = 1;
            $("#add_row").click(function () {
                b = i - 1;
                $('#addr' + i).html($('#addr' + b).html()).find('td:first-child').html(i + 1);
                $('#tab_logic').append('<tr id="addr' + (i + 1) + '"></tr>');
                i++;
            });
            $("#delete_row").click(function () {
                if (i > 1) {
                    $("#addr" + (i - 1)).html('');
                    i--;
                }
                calc();
            });

            $('#tab_logic tbody').on('keyup change', function () {
                calc();
            });
            $('#tax').on('keyup change', function () {
                calc_total();
            });


        });

        function calc() {
            $('#tab_logic tbody tr').each(function (i, element) {
                var html = $(this).html();
                if (html != '') {
                    var qty = $(this).find('.qty').val();
                    var price = $(this).find('.price').val();
                    var discount = $(this).find('.discount').val();
                    $(this).find('.total').val(qty * price - discount);

                    calc_total();
                }
            });
        }

        function calc_total() {
            total = 0;
            $('.total').each(function () {
                total += parseInt($(this).val());
            });
            $('#sub_total').val(total.toFixed(2));
            tax_sum = total / 100 * $('#tax').val();
            $('#tax_amount').val(tax_sum.toFixed(2));
            $('#total_amount').val((tax_sum + total).toFixed(2));
        }
    </script>
@endsection

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

        <div class="row">
            <div class="col-md-12">

                @include('alerts._errors')

                <div class="panel panel-flat">
                    <div class="panel-heading">
                        <h5 class="panel-title">Nueva Venta</h5>
                    </div>

                    <div class="row clearfix">
                        <div class="col-md-10 col-lg-offset-1" style="margin-bottom: 10px">
                            <button id="add_row" class="btn btn-default pull-left">Agregar Fila</button>
                            <button id='delete_row' class="pull-right btn btn-default">Borrar Fila</button>
                        </div>
                    </div>

                    <form method="post" action="{{ route('addNew.sale') }}">
                        @csrf
                        <div class="row clearfix">
                            <div class="col-md-12">

                                <div class="col-md-6 col-md-offset-0">
                                    <div class="form-group">
                                        <select class="bootstrap-select" name="customer_id" data-live-search="true"
                                                data-width="100%">
                                            <option value="">Elija el Cliente</option>
                                            @foreach($customers as $customer)
                                                <option value="{{ $customer->id }}">{{ $customer->name }}</option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>

                                <h4>Recibo # {{ $invoiceNumber->invoice }}</h4>

                                <table class="table table-bordered table-hover" id="tab_logic" style="font-size: 12px;">
                                    <thead>
                                    <tr>
                                        <th class="text-center"> #</th>
                                        <th class="text-center"> Producto</th>
                                        <th class="text-center"> Descripción</th>
                                        <th class="text-center"> Cantidad</th>
                                        <th class="text-center"> Precio</th>
                                        <th class="text-center"> Descuento</th>
                                        <th class="text-center"> Total</th>
                                    </tr>
                                    </thead>
                                    <tbody>
                                    <tr id='addr0'>
                                        <td>1</td>
                                        <td>
                                            <select name="stock_id[]">
                                                <option value="">Elija el Producto</option>
                                                @foreach($stocks as $stock)
                                                    <option value="{{ $stock->id }}">{{ $stock->name }}</option>
                                                @endforeach
                                            </select>
                                        </td>
                                        <td><input type="text" name='description[]'
                                                   class="form-control description" step="0" min="0"/></td>
                                        <td><input type="number" name='qty[]' required
                                                   class="form-control qty" step="0" min="0"/></td>
                                        <td><input type="number" name='price[]' required
                                                   class="form-control price" step="0.00" min="0"/></td>
                                        <td><input type="number" name='discount[]'
                                                   class="form-control discount"/></td>
                                        <td><input type="number" name='total[]' required
                                                   class="form-control total" readonly/></td>
                                    </tr>
                                    <tr id='addr1'></tr>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                        <div class="row clearfix" style="margin-top:20px">
                            <div class="pull-right col-md-4">
                                <table class="table table-bordered table-hover" id="tab_logic_total"
                                       style="font-size: 12px;">
                                    <tbody>
                                    <tr>
                                        <th class="text-center">Sub Total</th>
                                        <td class="text-center"><input type="number" name='sub_total' placeholder='0.00'
                                                                       class="form-control" id="sub_total" readonly/>
                                        </td>
                                    </tr>
                                    <tr>
                                        <th class="text-center">Impuesto</th>
                                        <td class="text-center">
                                            <div class="input-group mb-2 mb-sm-0">
                                                <input type="number" class="form-control" name="tax" id="tax" placeholder="0">
                                                <div class="input-group-addon">%</div>
                                            </div>
                                        </td>
                                    </tr>
                                    <tr>
                                        <th class="text-center">Impuesto $</th>
                                        <td class="text-center"><input type="number" name='tax_amount' id="tax_amount"
                                                                       placeholder='0.00' class="form-control"
                                                                       readonly/>
                                        </td>
                                    </tr>
                                    <tr>
                                        <th class="text-center">Total</th>
                                        <td class="text-center"><input type="number" name='total_amount'
                                                                       id="total_amount"
                                                                       placeholder='0.00' class="form-control"
                                                                       readonly/>
                                        </td>
                                    </tr>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                        <button type="submit" class="btn btn-primary legitRipple" style="margin: 20px 43px 20px 35px;">
                            Generar Recibo
                        </button>
                    </form>
                </div>
            </div>
        </div>
    </div>
@endsection

<script>
</script>

Y aca trato de guardar lo datos

Insertar CODE, HTML o PHP:
 $veterinarian = Veterinarian::where('user_id', Auth::user()->id)
            ->first();


//        foreach ($request->all() as $value) {
//            dd(Arr::get($value,'stock_id'));
            Sale::create([
                'customer_id' => $request['customer_id'],
                'stock_id' => $request['stock_id'],
                'comment' => $request['description'],
                'quantity' => $request['qty'],
                'mount' => $request['price'],
                'discount' => $request['discount'],
                'invoice' => 92,
                'date' => now(),
                'status' => 'Pagada',
                'veterinarian_id' => $veterinarian->id,
            ]);

la verdad ya no se que hacer

muchas gracias por todo
 
Insertar CODE, HTML o PHP:
@extends('layouts.mainAdmin')

@section('breadcrumb', 'Agregar nueva Ventas')

@section('script')
    <script type="text/javascript"
            src="{{ asset('styleAdmin/assets/js/plugins/forms/selects/bootstrap_select.min.js' )}}"></script>
    <script type="text/javascript" src="{{ asset('styleAdmin/assets/js/pages/form_bootstrap_select.js' )}}"></script>

    {{--<link href="//maxcdn.bootstrapcdn.com/bootstrap/3.3.0/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css">--}}
    {{--<script src="//maxcdn.bootstrapcdn.com/bootstrap/3.3.0/js/bootstrap.min.js"></script>--}}
    <script src="//code.jquery.com/jquery-1.11.1.min.js"></script>

    <script>
        $(document).ready(function () {
            var i = 1;
            $("#add_row").click(function () {
                b = i - 1;
                $('#addr' + i).html($('#addr' + b).html()).find('td:first-child').html(i + 1);
                $('#tab_logic').append('<tr id="addr' + (i + 1) + '"></tr>');
                i++;
            });
            $("#delete_row").click(function () {
                if (i > 1) {
                    $("#addr" + (i - 1)).html('');
                    i--;
                }
                calc();
            });

            $('#tab_logic tbody').on('keyup change', function () {
                calc();
            });
            $('#tax').on('keyup change', function () {
                calc_total();
            });


        });

        function calc() {
            $('#tab_logic tbody tr').each(function (i, element) {
                var html = $(this).html();
                if (html != '') {
                    var qty = $(this).find('.qty').val();
                    var price = $(this).find('.price').val();
                    var discount = $(this).find('.discount').val();
                    $(this).find('.total').val(qty * price - discount);

                    calc_total();
                }
            });
        }

        function calc_total() {
            total = 0;
            $('.total').each(function () {
                total += parseInt($(this).val());
            });
            $('#sub_total').val(total.toFixed(2));
            tax_sum = total / 100 * $('#tax').val();
            $('#tax_amount').val(tax_sum.toFixed(2));
            $('#total_amount').val((tax_sum + total).toFixed(2));
        }
    </script>
@endsection

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

        <div class="row">
            <div class="col-md-12">

                @include('alerts._errors')

                <div class="panel panel-flat">
                    <div class="panel-heading">
                        <h5 class="panel-title">Nueva Venta</h5>
                    </div>

                    <div class="row clearfix">
                        <div class="col-md-10 col-lg-offset-1" style="margin-bottom: 10px">
                            <button id="add_row" class="btn btn-default pull-left">Agregar Fila</button>
                            <button id='delete_row' class="pull-right btn btn-default">Borrar Fila</button>
                        </div>
                    </div>

                    <form method="post" action="{{ route('addNew.sale') }}">
                        @csrf
                        <div class="row clearfix">
                            <div class="col-md-12">

                                <div class="col-md-6 col-md-offset-0">
                                    <div class="form-group">
                                        <select class="bootstrap-select" name="customer_id" data-live-search="true"
                                                data-width="100%">
                                            <option value="">Elija el Cliente</option>
                                            @foreach($customers as $customer)
                                                <option value="{{ $customer->id }}">{{ $customer->name }}</option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>

                                <h4>Recibo # {{ $invoiceNumber->invoice }}</h4>

                                <table class="table table-bordered table-hover" id="tab_logic" style="font-size: 12px;">
                                    <thead>
                                    <tr>
                                        <th class="text-center"> #</th>
                                        <th class="text-center"> Producto</th>
                                        <th class="text-center"> Descripción</th>
                                        <th class="text-center"> Cantidad</th>
                                        <th class="text-center"> Precio</th>
                                        <th class="text-center"> Descuento</th>
                                        <th class="text-center"> Total</th>
                                    </tr>
                                    </thead>
                                    <tbody>
                                    <tr id='addr0'>
                                        <td>1</td>
                                        <td>
                                            <select name="products[addr0][stock_id]">
                                                <option value="">Elija el Producto</option>
                                                @foreach($stocks as $stock)
                                                    <option value="{{ $stock->id }}">{{ $stock->name }}</option>
                                                @endforeach
                                            </select>
                                        </td>
                                        <td><input type="text" name='products[addr0][description]'
                                                   class="form-control description" step="0" min="0"/></td>
                                        <td><input type="number" name='products[addr0][qty]' required
                                                   class="form-control qty" step="0" min="0"/></td>
                                        <td><input type="number" name='products[addr0][price]' required
                                                   class="form-control price" step="0.00" min="0"/></td>
                                        <td><input type="number" name='products[addr0][discount]'
                                                   class="form-control discount"/></td>
                                        <td><input type="number" name='products[addr0][total]' required
                                                   class="form-control total" readonly/></td>
                                    </tr>
                                    <tr id='addr1'></tr>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                        <div class="row clearfix" style="margin-top:20px">
                            <div class="pull-right col-md-4">
                                <table class="table table-bordered table-hover" id="tab_logic_total"
                                       style="font-size: 12px;">
                                    <tbody>
                                    <tr>
                                        <th class="text-center">Sub Total</th>
                                        <td class="text-center"><input type="number" name='sub_total' placeholder='0.00'
                                                                       class="form-control" id="sub_total" readonly/>
                                        </td>
                                    </tr>
                                    <tr>
                                        <th class="text-center">Impuesto</th>
                                        <td class="text-center">
                                            <div class="input-group mb-2 mb-sm-0">
                                                <input type="number" class="form-control" name="tax" id="tax" placeholder="0">
                                                <div class="input-group-addon">%</div>
                                            </div>
                                        </td>
                                    </tr>
                                    <tr>
                                        <th class="text-center">Impuesto $</th>
                                        <td class="text-center"><input type="number" name='tax_amount' id="tax_amount"
                                                                       placeholder='0.00' class="form-control"
                                                                       readonly/>
                                        </td>
                                    </tr>
                                    <tr>
                                        <th class="text-center">Total</th>
                                        <td class="text-center"><input type="number" name='total_amount'
                                                                       id="total_amount"
                                                                       placeholder='0.00' class="form-control"
                                                                       readonly/>
                                        </td>
                                    </tr>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                        <button type="submit" class="btn btn-primary legitRipple" style="margin: 20px 43px 20px 35px;">
                            Generar Recibo
                        </button>
                    </form>
                </div>
            </div>
        </div>
    </div>
@endsection

<script>
</script>
 
Atrás
Arriba