yii2 calculate selected row in grid-view (checkbox-column) using jquery and submit the data

Question

I have a gridview like code below

<?= GridView::widget([
    'id' => 'table-penerimaan-produksi',
    'dataProvider' => $dataProvider,
    //'filterModel' => $searchModel,
    'columns' => [

        [
            'class' => 'yii\grid\CheckboxColumn',
            'checkboxOptions' =>
                function($model) {
                    return ['value' => $model->id, 'class' => 'checkbox-row'];
                }
        ],
        'ref.id',
        'ref.send_date',
        'received_date',
        'ref.vehicle_id',
        ['attribute' => 'netto', 'label' => 'Netto Terima', 'format' => ['decimal', 2]],
        ['attribute' => 'ref.netto', 'label' => 'Netto Kirim', 'format' => ['decimal', 2]],
        ['attribute' => 'susut', 'format' => ['decimal', 2]]
    ],
]); ?>

what i want is to calculate netto from selected row by using jquery. i have jquery like this:

$('.select-on-check-all, .checkbox-row').click(function(){
    calculateNetto();
})

function calculateNetto()
{
    var keys = $('#table-penerimaan-produksi').yiiGridView('getSelectedRows');        
}

How to get the value from keys and post to controller to save the ids selected?

Thanks in advance.

Wrap gridview with activeForm.

Insane Skull
– Insane Skull

2018-01-11 04:41:54 +00:00
Commented Jan 11, 2018 at 4:41 — Insane Skull
– Insane Skull, Commented Jan 11, 2018 at 4:41
already do that.

Wilson Ng
– Wilson Ng

2018-01-11 05:07:04 +00:00
Commented Jan 11, 2018 at 5:07 — Wilson Ng
– Wilson Ng, Commented Jan 11, 2018 at 5:07
this is my code

Wilson Ng
– Wilson Ng

2018-01-11 05:11:41 +00:00
Commented Jan 11, 2018 at 5:11 — Wilson Ng
– Wilson Ng, Commented Jan 11, 2018 at 5:11
Submit the form and check Yii::$app->request->post().

Insane Skull
– Insane Skull

2018-01-11 05:34:32 +00:00
Commented Jan 11, 2018 at 5:34 — Insane Skull
– Insane Skull, Commented Jan 11, 2018 at 5:34
how about iteration to calculate selected row netto ?

Wilson Ng
– Wilson Ng

2018-01-11 07:08:37 +00:00
Commented Jan 11, 2018 at 7:08 — Wilson Ng
– Wilson Ng, Commented Jan 11, 2018 at 7:08

Wilson Ng · Accepted Answer · 2018-01-17 07:39:24Z

I found my answer for calculating netto column which are selected using jquery

[
    'class' => 'yii\grid\CheckboxColumn',
    'checkboxOptions' =>
        function($model) {
            return ['value' => $model->id, 'class' => 'checkbox-row', 'id' => 'checkbox'];
        }
],

Adding id to CheckboxColumn and then using the following code to calculate netto

$('.select-on-check-all, .checkbox-row').click(function(){
    calculateNetto();
})

function calculateNetto()
{            
    var total_netto_send = 0; var total_netto_receive = 0;
    var netto_send = 0; var netto_receive = 0;
    for(var i=0; i < $('#checkbox.checkbox-row').length; i++)
    {           
        if($('#checkbox.checkbox-row')[i].checked == true) {
            netto_send = document.getElementById('table-penerimaan-produksi').getElementsByTagName('tr')[i+1].getElementsByTagName('td')[6].innerHTML;
            netto_receive = document.getElementById('table-penerimaan-produksi').getElementsByTagName('tr')[i+1].getElementsByTagName('td')[5].innerHTML;
            netto_send = netto_send == "" ? 0 : Number(netto_send.split(",").join(""));
            netto_receive = netto_receive == "" ? 0 : Number(netto_receive.split(",").join(""));
            total_netto_send += netto_send;
            total_netto_receive += netto_receive;
        }           
    }    
    $('#realisasiproduksi-total_netto_send').val(total_netto_send);
    $('#realisasiproduksi-total_netto_receive').val(total_netto_receive);
}

Patrick R · Accepted Answer · 2018-01-16 09:23:59Z

0

You can set selected rows count in a hidden field, and get it into your controller using Yii::$app->request->post() method. See following steps to get the desired result:

1) Add public variable in model:

// Model
public class TestModel extends Model {
    public $rows_count;
}

2) Add form and input field in view

// View
<?php $form = ActiveForm::begin(); ?>
<?= GridView::widget([
    'id' => 'table-penerimaan-produksi',
    'dataProvider' => $dataProvider,
    //'filterModel' => $searchModel,
    'columns' => [

        [
            'class' => 'yii\grid\CheckboxColumn',
            'checkboxOptions' =>
                function($model) {
                    return ['value' => $model->id, 'class' => 'checkbox-row'];
                }
        ],
        'ref.id',
        'ref.send_date',
        'received_date',
        'ref.vehicle_id',
        ['attribute' => 'netto', 'label' => 'Netto Terima', 'format' => ['decimal', 2]],
        ['attribute' => 'ref.netto', 'label' => 'Netto Kirim', 'format' => ['decimal', 2]],
        ['attribute' => 'susut', 'format' => ['decimal', 2]]
    ],
]); ?>
<?= $form->field($model, 'rows_count')->hiddenInput(['id' => 'rows_count']) ?>
<?= Html::submitButton('Submit', ['class' => 'btn btn-success']) ?>
<?php ActiveForm::end(); ?>

3) Set total selected rows count in hidden field

// Javascript Code
function calculateNetto() {
    var keys = $('#table-penerimaan-produksi').yiiGridView('getSelectedRows');
    $('#rows_count').val(keys);
}

4) Get total rows count in controller

// Controller
public function actionTestController() {
    $rows_count = Yii::$app->request->post('rows_count');
}

Let me know if any help needed.

Edit If you don't select all rows, then .yiiGridView('getSelectedRows') would return empty array, otherwise it would return array of selected row values. One more thing I would like to change in javascript code that instead of click event, use change event as follows, because it would give accurate result:

$('.select-on-check-all, .checkbox-row').click(function(){  // Here use change event instead of click event
    calculateNetto();
})

edited Jan 16, 2018 at 9:23

answered Jan 13, 2018 at 12:19

Patrick R

7,0061 gold badge26 silver badges27 bronze badges

3 Comments

Wilson Ng Over a year ago

what if not all rows selected?

Patrick R Over a year ago

If you don't select all rows, then .yiiGridView('getSelectedRows') would return empty array, otherwise it would return array of selected row values. One more thing I would like to change in javascript code that instead of click event, use change event as follows, because it would give accurate result, see updated answer

Wilson Ng Over a year ago

so, how can we know rows selected? because i want to sum the netto which selected.

Collectives™ on Stack Overflow

yii2 calculate selected row in grid-view (checkbox-column) using jquery and submit the data

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related