insert multiple laravel checkbox datatable

Question

I want to insert multi rows checked in my data table, when I click a button valider, everyone I have a problem in a laravel framework, I want to insert line check in a data table when click on button validate, this my code
the display of the salary list

<body>
    <div class="container" id="app">
      <div class="list-group">
       <div class="list-group-item">

    <h3>Pointage Mensuel</h3>
    <div class="col-md-6 col-md-offset-3">
        <h3>jour : {{$data['datek']}} chantier : {{$data['chantier_name']}}</h3>
    </div>
    <button class="btn btn-success add-all" data-url="">Valider Pointage de mois</button>
</div>
</div>

  <div class="list-group">
   <div class="list-group-item">
    <table class="table table-bordered">
        <tr>
            <th>Archive</th>
            <th><input type="checkbox" id="check_all"></th>
            <th>S.No.</th>
            <th>matricule</th>
            <th>nom & prenom</th>
            <th>salaire net</th>
            <th>nbre de jour </th>
            <th>prime</th>
        </tr>
        @if($salaries->count())
            @foreach($salaries as $key => $salarie)
                <tr id="tr_{{$salarie->id}}">
                  <td>archive</td>
                  <td><input type="checkbox" class="checkbox" data-id="{{$salarie->id}}"></td>
                  <td>{{ ++$key }}</td>
                  <td>{{ $salarie->matricule }}</td>
                  <td>{{ $salarie->nom }} {{ $salarie->prenom }}</td>
                  <td>{{ $salarie->salairenet }}</td>
                  <td><input type="text" name="nbreJ" class="form-control" value="{{$data['nbr']}}"></td>
                  <td><input type="text" name="prime" class="form-control" value="0"></td>
                </tr>
            @endforeach
        @endif
    </table>
 </div>
</div>
<!-------------------//////////////////////////------------->
</div> 
</body>

code ajax for checked all /uncheck and

<script type="text/javascript">
    $(document).ready(function () {
        $('#check_all').on('click', function(e) {
         if($(this).is(':checked',true)) {
            $(".checkbox").prop('checked', true);  
         } else {  
            $(".checkbox").prop('checked',false);  }  });
         $('.checkbox').on('click',function(){
            if($('.checkbox:checked').length == $('.checkbox').length){
                $('#check_all').prop('checked',true);
            }else{
                $('#check_all').prop('checked',false); }});
        $('.add-all').on('click', function(e) {
            var idsArr = [];  
            $(".checkbox:checked").each(function() {  
                idsArr.push($(this).attr('data-id'));});  
            if(idsArr.length <=0)  {  
                alert("Please select atleast one record to pointer.");  
            }  else {  
                    var strIds = idsArr.join(","); 
                    $.ajax({
                        url: "{{ route('salarie.multiple-add') }}",
                        type: 'POST',
                        headers: {'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')},
                        data: {
                            'ids' : strIds},
                        success: function (data) {
                            if (data['status']==true) {
                                $(".checkbox:checked").each(function() { 
                                    alert(strIds); });
                                alert(data['message']);
                            } else {
                                alert('Whoops Something went wrong!!');}
                            window.location.reload()},
                        error: function (data) {
                            alert(data.responseText);}});}  }); });
</script>

function controller addMultiple

   public function addMultiple(Request $request){
        $pointage=new Pointage();

        $pointage->datep=$request->datep;
        $pointage->nbrj=$request->nbrj;
        $pointage->prime=$request->prime;
        $pointage->solde=$request->solde;
     return response()->json(['status'=>true]); 
    }

What is your main goal here? to save multiple rows to the DB at once or do some validation? — Jelly Bean
– Jelly Bean, Commented Jun 8, 2019 at 7:13
hey ,I have not yet solved this problem, it is a difficult problem, — Najib Marzouk
– Najib Marzouk, Commented Jun 9, 2019 at 9:12

Jelly Bean · Accepted Answer · 2019-06-10 06:25:05Z

1

Apologies for late answer laptop died on me while i was busy but one way you could do it is by using array names for example:

 <td><input type="checkbox" class="checkbox" name="row[$key][salarie]" data-id="{{$salarie->id}}"></td>

baiclly if you have multiple of these inputs with the same group it will make an array of inputs on your backend which you can loop through. to test this dd(request()); in your controller function above everything else. then you should be able to see what it returns in your console.

foreach(request(inputgroup) as $value){

   Pointage::create([
      'some_column' => $value['actualInputName']
   ]);
}

Update your function to something like this:

public function addMultiple(Request $request){
    dd(request());

    $pointage=new Pointage();

    foreach(request('row') as $row){
       // this is the important line $row is your request and ['salari'] is the name of the input   
       $pointage->salarie = $row['salarie'];
       $pointage->save();      
     }

     return response()->json(['status'=>true]); 
}

edited Jun 10, 2019 at 6:25

answered Jun 8, 2019 at 17:45

Jelly Bean

1,2191 gold badge13 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Najib Marzouk Over a year ago

Maybe I did not know how to use this method

Jelly Bean Over a year ago

Let me know where you got stuck, best thing to do would be set the array names as iv shown then dd() your request to see how the data is returned. Post your result and I can help further

Jelly Bean Over a year ago

@NajibMarzouk i have updated my answer to hopefully make it easier to understand

Collectives™ on Stack Overflow

insert multiple laravel checkbox datatable

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related