Merge two data provider and show them in a grid

Yii 2.0 General Discussions
1

hi all, i’m trying to merge two table with different field in a grid but i get an error like i cant call second table fields

the tables

MovimentiCredito
|ID|IDTessera|IDTipoMovCredito|IDUtente|Data|MovCredito|Note|
MovimentiPunti
|ID|IDTessera|IDTipoMovPunti|IDUtente|Data|MovPunti|Note|

My Code

$MCdataprovider= new ActiveDataProvider([
‘query’ => MovimentiCredito::find()->where([‘IDTessera’=>$card->ID])->orderBy(‘data DESC’),
‘pagination’ => [
‘pageSize’ => 20,
],
]);
$MPdataprovider= new ActiveDataProvider([
‘query’ => MovimentiPunti::find()->where([‘IDTessera’=>$card->ID])->orderBy(‘data DESC’),
‘pagination’ => [
‘pageSize’ => 20,
],
]);
$datamov = array_replace_recursive ( $MPdataprovider->getModels(),$MCdataprovider->getModels());
$dataProvider_all = new ArrayDataProvider([
‘allModels’ => $datamov
]);

The Grid

<?php Pjax::begin(['id' => 'Movimenti2']) ?>        
  <?php Print_r($dataProvider_all);?>
          <?php echo GridView::widget([
    'dataProvider' => $dataProvider_all,
          'columns' => [
        [
            'attribute' => 'Data',
            'format' => 'text'
        ],
              ['attribute' => 'MovPunti',
            'format' => 'text'],
 ['attribute' => 'MovCredito',
            'format' => 'text'],
                 
                   ['attribute' => 'Note',
            'format' => 'text'],
            [
            'label' => 'Cancella',
            //'attribute' => 'education',
            //'filter' => ['0' => 'Elementary', '1' => 'Secondary', '2' => 'Higher'],
            //'filterInputOptions' => ['prompt' => 'All educations', 'class' => 'form-control', 'id' => null]
                 'format' => 'raw',
            'value' => function($data) {

                        return Html::a('modifica',['movimenti/delete','id' => $data['ID'] ]);
            }
    
        ],
              ]
]);
  ?>   

        
        
          <?php Pjax::end() ?>

the error

Unknown Property – yii\base\UnknownPropertyException

Getting unknown property: app\models\MovimentiCredito::MovPunti

if i change in
$datamov = array_replace_recursive ( $MPdataprovider->getModels(),$MCdataprovider->getModels());

the order of the dataprovider i get different error if Punti is first i get an error on Credito Field and viceversa, but if i print the combined dataprovider is full of data…
How can i solve?
Thanks for the help!

2

Try to write print_r($dataProvider_all->models) and show the structure of the table.

3

got this its look like doesn’t merge the activedata…

Array ( [0] => app\models\MovimentiCredito Object ( [_attributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => B48E56CD-1AD4-4645-B550-BA0441F56A07 [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2019-12-24 15:18:14.040 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_oldAttributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => B48E56CD-1AD4-4645-B550-BA0441F56A07 [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2019-12-24 15:18:14.040 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_related:yii\db\BaseActiveRecord:private] => Array ( ) [_relationsDependencies:yii\db\BaseActiveRecord:private] => Array ( ) [_errors:yii\base\Model:private] => [_validators:yii\base\Model:private] => [_scenario:yii\base\Model:private] => default [_events:yii\base\Component:private] => Array ( ) [_eventWildcards:yii\base\Component:private] => Array ( ) [_behaviors:yii\base\Component:private] => Array ( ) ) [1] => app\models\MovimentiCredito Object ( [_attributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => B3A4B0F5-C183-4929-B4CF-E533DB817B7A [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2019-12-22 20:08:51.663 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_oldAttributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => B3A4B0F5-C183-4929-B4CF-E533DB817B7A [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2019-12-22 20:08:51.663 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_related:yii\db\BaseActiveRecord:private] => Array ( ) [_relationsDependencies:yii\db\BaseActiveRecord:private] => Array ( ) [_errors:yii\base\Model:private] => [_validators:yii\base\Model:private] => [_scenario:yii\base\Model:private] => default [_events:yii\base\Component:private] => Array ( ) [_eventWildcards:yii\base\Component:private] => Array ( ) [_behaviors:yii\base\Component:private] => Array ( ) ) [2] => app\models\MovimentiCredito Object ( [_attributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => 46EB3841-CC76-4FD6-AFE0-03E30C4B501E [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2019-12-22 20:08:13.200 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_oldAttributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => 46EB3841-CC76-4FD6-AFE0-03E30C4B501E [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2019-12-22 20:08:13.200 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_related:yii\db\BaseActiveRecord:private] => Array ( ) [_relationsDependencies:yii\db\BaseActiveRecord:private] => Array ( ) [_errors:yii\base\Model:private] => [_validators:yii\base\Model:private] => [_scenario:yii\base\Model:private] => default [_events:yii\base\Component:private] => Array ( ) [_eventWildcards:yii\base\Component:private] => Array ( ) [_behaviors:yii\base\Component:private] => Array ( ) ) [3] => app\models\MovimentiCredito Object ( [_attributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => B344BAD4-D7C9-4326-A436-A7232D628CBD [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2019-12-22 19:55:28.510 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_oldAttributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => B344BAD4-D7C9-4326-A436-A7232D628CBD [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2019-12-22 19:55:28.510 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_related:yii\db\BaseActiveRecord:private] => Array ( ) [_relationsDependencies:yii\db\BaseActiveRecord:private] => Array ( ) [_errors:yii\base\Model:private] => [_validators:yii\base\Model:private] => [_scenario:yii\base\Model:private] => default [_events:yii\base\Component:private] => Array ( ) [_eventWildcards:yii\base\Component:private] => Array ( ) [_behaviors:yii\base\Component:private] => Array ( ) ) [4] => app\models\MovimentiCredito Object ( [_attributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => F0EBA269-CE36-407B-B67C-57FF92E43BB1 [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2019-12-20 20:00:54.330 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_oldAttributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => F0EBA269-CE36-407B-B67C-57FF92E43BB1 [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2019-12-20 20:00:54.330 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_related:yii\db\BaseActiveRecord:private] => Array ( ) [_relationsDependencies:yii\db\BaseActiveRecord:private] => Array ( ) [_errors:yii\base\Model:private] => [_validators:yii\base\Model:private] => [_scenario:yii\base\Model:private] => default [_events:yii\base\Component:private] => Array ( ) [_eventWildcards:yii\base\Component:private] => Array ( ) [_behaviors:yii\base\Component:private] => Array ( ) ) [5] => app\models\MovimentiCredito Object ( [_attributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => 21D96CCD-F7A9-4EDB-A946-2EAB3E32A06A [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2019-12-20 19:52:35.650 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_oldAttributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => 21D96CCD-F7A9-4EDB-A946-2EAB3E32A06A [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2019-12-20 19:52:35.650 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_related:yii\db\BaseActiveRecord:private] => Array ( ) [_relationsDependencies:yii\db\BaseActiveRecord:private] => Array ( ) [_errors:yii\base\Model:private] => [_validators:yii\base\Model:private] => [_scenario:yii\base\Model:private] => default [_events:yii\base\Component:private] => Array ( ) [_eventWildcards:yii\base\Component:private] => Array ( ) [_behaviors:yii\base\Component:private] => Array ( ) ) [6] => app\models\MovimentiCredito Object ( [_attributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => A02F5865-1BF5-47E5-9817-8C1562FBF9CA [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2019-09-14 10:55:34.850 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_oldAttributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => A02F5865-1BF5-47E5-9817-8C1562FBF9CA [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2019-09-14 10:55:34.850 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_related:yii\db\BaseActiveRecord:private] => Array ( ) [_relationsDependencies:yii\db\BaseActiveRecord:private] => Array ( ) [_errors:yii\base\Model:private] => [_validators:yii\base\Model:private] => [_scenario:yii\base\Model:private] => default [_events:yii\base\Component:private] => Array ( ) [_eventWildcards:yii\base\Component:private] => Array ( ) [_behaviors:yii\base\Component:private] => Array ( ) ) [7] => app\models\MovimentiCredito Object ( [_attributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => 24CC142A-39B7-4255-928A-B428C0142F2B [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2019-03-27 12:17:14.040 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_oldAttributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => 24CC142A-39B7-4255-928A-B428C0142F2B [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2019-03-27 12:17:14.040 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_related:yii\db\BaseActiveRecord:private] => Array ( ) [_relationsDependencies:yii\db\BaseActiveRecord:private] => Array ( ) [_errors:yii\base\Model:private] => [_validators:yii\base\Model:private] => [_scenario:yii\base\Model:private] => default [_events:yii\base\Component:private] => Array ( ) [_eventWildcards:yii\base\Component:private] => Array ( ) [_behaviors:yii\base\Component:private] => Array ( ) ) [8] => app\models\MovimentiCredito Object ( [_attributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => 43D46284-9040-47B3-9F38-2D55932C929A [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2018-06-04 11:40:41.360 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_oldAttributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => 43D46284-9040-47B3-9F38-2D55932C929A [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2018-06-04 11:40:41.360 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_related:yii\db\BaseActiveRecord:private] => Array ( ) [_relationsDependencies:yii\db\BaseActiveRecord:private] => Array ( ) [_errors:yii\base\Model:private] => [_validators:yii\base\Model:private] => [_scenario:yii\base\Model:private] => default [_events:yii\base\Component:private] => Array ( ) [_eventWildcards:yii\base\Component:private] => Array ( ) [_behaviors:yii\base\Component:private] => Array ( ) ) [9] => app\models\MovimentiCredito Object ( [_attributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => 9A2111D2-B942-4BBE-824D-C6BC8EFEAF2E [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2018-05-24 10:32:57.163 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_oldAttributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => 9A2111D2-B942-4BBE-824D-C6BC8EFEAF2E [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2018-05-24 10:32:57.163 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_related:yii\db\BaseActiveRecord:private] => Array ( ) [_relationsDependencies:yii\db\BaseActiveRecord:private] => Array ( ) [_errors:yii\base\Model:private] => [_validators:yii\base\Model:private] => [_scenario:yii\base\Model:private] => default [_events:yii\base\Component:private] => Array ( ) [_eventWildcards:yii\base\Component:private] => Array ( ) [_behaviors:yii\base\Component:private] => Array ( ) ) [10] => app\models\MovimentiCredito Object ( [_attributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => 8EB496FD-E430-4776-9739-5F4677830D20 [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2018-04-21 16:34:30.913 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_oldAttributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => 8EB496FD-E430-4776-9739-5F4677830D20 [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2018-04-21 16:34:30.913 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_related:yii\db\BaseActiveRecord:private] => Array ( ) [_relationsDependencies:yii\db\BaseActiveRecord:private] => Array ( ) [_errors:yii\base\Model:private] => [_validators:yii\base\Model:private] => [_scenario:yii\base\Model:private] => default [_events:yii\base\Component:private] => Array ( ) [_eventWildcards:yii\base\Component:private] => Array ( ) [_behaviors:yii\base\Component:private] => Array ( ) ) [11] => app\models\MovimentiCredito Object ( [_attributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => 98F1C60B-5502-44C2-889B-7D1544CAD56D [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2017-11-24 10:09:40.107 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_oldAttributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => 98F1C60B-5502-44C2-889B-7D1544CAD56D [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2017-11-24 10:09:40.107 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_related:yii\db\BaseActiveRecord:private] => Array ( ) [_relationsDependencies:yii\db\BaseActiveRecord:private] => Array ( ) [_errors:yii\base\Model:private] => [_validators:yii\base\Model:private] => [_scenario:yii\base\Model:private] => default [_events:yii\base\Component:private] => Array ( ) [_eventWildcards:yii\base\Component:private] => Array ( ) [_behaviors:yii\base\Component:private] => Array ( ) ) [12] => app\models\MovimentiCredito Object ( [_attributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => 9A00DEE2-4F7F-4A17-B04C-478D4CC57432 [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2017-09-30 12:12:21.250 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_oldAttributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => 9A00DEE2-4F7F-4A17-B04C-478D4CC57432 [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2017-09-30 12:12:21.250 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_related:yii\db\BaseActiveRecord:private] => Array ( ) [_relationsDependencies:yii\db\BaseActiveRecord:private] => Array ( ) [_errors:yii\base\Model:private] => [_validators:yii\base\Model:private] => [_scenario:yii\base\Model:private] => default [_events:yii\base\Component:private] => Array ( ) [_eventWildcards:yii\base\Component:private] => Array ( ) [_behaviors:yii\base\Component:private] => Array ( ) ) [13] => app\models\MovimentiCredito Object ( [_attributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => FBD86EB3-023B-4293-8678-0BD1B4715B49 [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2017-09-28 09:50:31.293 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_oldAttributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => FBD86EB3-023B-4293-8678-0BD1B4715B49 [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2017-09-28 09:50:31.293 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_related:yii\db\BaseActiveRecord:private] => Array ( ) [_relationsDependencies:yii\db\BaseActiveRecord:private] => Array ( ) [_errors:yii\base\Model:private] => [_validators:yii\base\Model:private] => [_scenario:yii\base\Model:private] => default [_events:yii\base\Component:private] => Array ( ) [_eventWildcards:yii\base\Component:private] => Array ( ) [_behaviors:yii\base\Component:private] => Array ( ) ) [14] => app\models\MovimentiCredito Object ( [_attributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => 0D3C1120-6D10-4832-87C8-A221925533E2 [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2017-09-28 09:45:01.477 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_oldAttributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => 0D3C1120-6D10-4832-87C8-A221925533E2 [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2017-09-28 09:45:01.477 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_related:yii\db\BaseActiveRecord:private] => Array ( ) [_relationsDependencies:yii\db\BaseActiveRecord:private] => Array ( ) [_errors:yii\base\Model:private] => [_validators:yii\base\Model:private] => [_scenario:yii\base\Model:private] => default [_events:yii\base\Component:private] => Array ( ) [_eventWildcards:yii\base\Component:private] => Array ( ) [_behaviors:yii\base\Component:private] => Array ( ) ) [15] => app\models\MovimentiCredito Object ( [_attributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => 4AAD1D1E-092E-42D8-B7F1-743678E1D3CD [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2017-09-25 11:14:14.220 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_oldAttributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => 4AAD1D1E-092E-42D8-B7F1-743678E1D3CD [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2017-09-25 11:14:14.220 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_related:yii\db\BaseActiveRecord:private] => Array ( ) [_relationsDependencies:yii\db\BaseActiveRecord:private] => Array ( ) [_errors:yii\base\Model:private] => [_validators:yii\base\Model:private] => [_scenario:yii\base\Model:private] => default [_events:yii\base\Component:private] => Array ( ) [_eventWildcards:yii\base\Component:private] => Array ( ) [_behaviors:yii\base\Component:private] => Array ( ) ) [16] => app\models\MovimentiCredito Object ( [_attributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => 1F2EDAA9-54AD-49D0-834F-F50605D3FC90 [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2017-05-05 10:47:42.370 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_oldAttributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => 1F2EDAA9-54AD-49D0-834F-F50605D3FC90 [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2017-05-05 10:47:42.370 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_related:yii\db\BaseActiveRecord:private] => Array ( ) [_relationsDependencies:yii\db\BaseActiveRecord:private] => Array ( ) [_errors:yii\base\Model:private] => [_validators:yii\base\Model:private] => [_scenario:yii\base\Model:private] => default [_events:yii\base\Component:private] => Array ( ) [_eventWildcards:yii\base\Component:private] => Array ( ) [_behaviors:yii\base\Component:private] => Array ( ) ) [17] => app\models\MovimentiCredito Object ( [_attributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => D7B7E3DA-D9AC-49A3-B92D-4B96EEA3698A [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2017-04-10 10:14:43.783 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_oldAttributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => D7B7E3DA-D9AC-49A3-B92D-4B96EEA3698A [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2017-04-10 10:14:43.783 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_related:yii\db\BaseActiveRecord:private] => Array ( ) [_relationsDependencies:yii\db\BaseActiveRecord:private] => Array ( ) [_errors:yii\base\Model:private] => [_validators:yii\base\Model:private] => [_scenario:yii\base\Model:private] => default [_events:yii\base\Component:private] => Array ( ) [_eventWildcards:yii\base\Component:private] => Array ( ) [_behaviors:yii\base\Component:private] => Array ( ) ) [18] => app\models\MovimentiCredito Object ( [_attributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => 1F05B83B-D8D4-4C47-B923-83373E56055A [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 79 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2016-12-31 23:59:00.000 [MovCredito] => 25.00 [Note] => Azzeramento fine promozione ) [_oldAttributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => 1F05B83B-D8D4-4C47-B923-83373E56055A [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 79 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2016-12-31 23:59:00.000 [MovCredito] => 25.00 [Note] => Azzeramento fine promozione ) [_related:yii\db\BaseActiveRecord:private] => Array ( ) [_relationsDependencies:yii\db\BaseActiveRecord:private] => Array ( ) [_errors:yii\base\Model:private] => [_validators:yii\base\Model:private] => [_scenario:yii\base\Model:private] => default [_events:yii\base\Component:private] => Array ( ) [_eventWildcards:yii\base\Component:private] => Array ( ) [_behaviors:yii\base\Component:private] => Array ( ) ) [19] => app\models\MovimentiCredito Object ( [_attributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => 782B08C6-8188-458A-8CDC-EEB3323DCAB8 [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2016-12-19 11:14:19.977 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_oldAttributes:yii\db\BaseActiveRecord:private] => Array ( [ID] => 782B08C6-8188-458A-8CDC-EEB3323DCAB8 [IDTessera] => 9A4DD124-D3FF-47EA-9C92-84D51E5A7013 [IDTipoMovCredito] => 2 [IDUtente] => 40709E3C-8F2C-4C49-BF00-209087786ADD [Data] => 2016-12-19 11:14:19.977 [MovCredito] => 25.00 [Note] => [PREMIO] [DESFG] buono 25 euro ) [_related:yii\db\BaseActiveRecord:private] => Array ( ) [_relationsDependencies:yii\db\BaseActiveRecord:private] => Array ( ) [_errors:yii\base\Model:private] => [_validators:yii\base\Model:private] => [_scenario:yii\base\Model:private] => default [_events:yii\base\Component:private] => Array ( ) [_eventWildcards:yii\base\Component:private] => Array ( ) [_behaviors:yii\base\Component:private] => Array ( ) ) )

4

First try Yii::warining($dataProvider_all->models) instead of print_r.
You will see at the Yii debug bar a warning message (yallow) for cleaner debug.

Second try to use ArrayDataProvider instead of your 2 ActiveDataProvider. Add asArray()->all() to your queries and don’t forget to replace 'query' with 'allModels'

5

hi tks for the help but i got the same result

$MCdataprovider= new ArrayDataProvider ([
‘allModels’ => MovimentiCredito::find()->where([‘IDTessera’=>$card->ID])->orderBy(‘data DESC’)->asArray()->all(),
‘pagination’ => [
‘pageSize’ => 20,
],
]);
$MPdataprovider= new ArrayDataProvider ([
‘allModels’ => MovimentiPunti::find()->where([‘IDTessera’=>$card->ID])->orderBy(‘data DESC’)->asArray()->all(),
‘pagination’ => [
‘pageSize’ => 20,
],
]);
Yii::warning($MCdataprovider->getModels());
Yii::warning($MPdataprovider->getModels());
$datamov = array_merge ($MCdataprovider->getModels(),$MPdataprovider->getModels());
$dataProvider_all = new ArrayDataProvider([
‘allModels’ => $datamov
]);
Yii::warning($dataProvider_all->models);

in warning no referre to “Punti”

[
[
    'ID' => '9AC95D39-52F7-42E8-B59D-EBADF0CF21F9',
    'IDTessera' => '01C2C54C-0787-48F8-836E-90EED0EA3CEB',
    'IDTipoMovCredito' => '2',
    'IDUtente' => '7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB',
    'Data' => '2019-12-06 18:36:47.647',
    'MovCredito' => '25.00',
    'Note' => '[PREMIO] [DSCAS] buono',
],
[
    'ID' => '79954111-77B4-48FC-B9A2-48A89D329D2D',
    'IDTessera' => '01C2C54C-0787-48F8-836E-90EED0EA3CEB',
    'IDTipoMovCredito' => '2',
    'IDUtente' => '7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB',
    'Data' => '2019-11-03 15:38:49.297',
    'MovCredito' => '25.00',
    'Note' => '[PREMIO] [DSCAS] buono',
],
[
    'ID' => 'C35B0938-97DE-488B-B579-452FDCE5D730',
    'IDTessera' => '01C2C54C-0787-48F8-836E-90EED0EA3CEB',
    'IDTipoMovCredito' => '2',
    'IDUtente' => '7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB',
    'Data' => '2019-06-17 11:22:43.763',
    'MovCredito' => '25.00',
    'Note' => '[PREMIO] [DSCAS] buono',
],
[
    'ID' => 'C7BE39BE-CDFA-46DD-80F4-2383C499B9EA',
    'IDTessera' => '01C2C54C-0787-48F8-836E-90EED0EA3CEB',
    'IDTipoMovCredito' => '2',
    'IDUtente' => '7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB',
    'Data' => '2019-05-04 15:26:03.223',
    'MovCredito' => '55.00',
    'Note' => '[PREMIO] [DSCAS] Buono50',
],
[
    'ID' => '2887BC77-8EC1-490D-A8C6-6F99B376031F',
    'IDTessera' => '01C2C54C-0787-48F8-836E-90EED0EA3CEB',
    'IDTipoMovCredito' => '2',
    'IDUtente' => '7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB',
    'Data' => '2018-12-22 17:51:20.270',
    'MovCredito' => '25.00',
    'Note' => '[PREMIO] [DSCAS] buono',
],
[
    'ID' => '67FD40FF-BABC-4349-A64D-8BAD00E8C34F',
    'IDTessera' => '01C2C54C-0787-48F8-836E-90EED0EA3CEB',
    'IDTipoMovCredito' => '2',
    'IDUtente' => '7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB',
    'Data' => '2018-11-16 09:56:33.480',
    'MovCredito' => '25.00',
    'Note' => '[PREMIO] [DSCAS] buono',
],
[
    'ID' => '8B49935A-5636-46B5-B265-06195945DE83',
    'IDTessera' => '01C2C54C-0787-48F8-836E-90EED0EA3CEB',
    'IDTipoMovCredito' => '2',
    'IDUtente' => '7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB',
    'Data' => '2018-06-18 17:22:04.917',
    'MovCredito' => '25.00',
    'Note' => '[PREMIO] [DSCAS] buono',
],
[
    'ID' => '51CB20CB-68D3-4CB5-969C-C5FF7A988EDD',
    'IDTessera' => '01C2C54C-0787-48F8-836E-90EED0EA3CEB',
    'IDTipoMovCredito' => '2',
    'IDUtente' => '7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB',
    'Data' => '2018-06-18 17:19:54.950',
    'MovCredito' => '25.00',
    'Note' => '[PREMIO] [DSCAS] buono',
],
[
    'ID' => '72BC0FFB-C174-44B1-8599-31453A8487BA',
    'IDTessera' => '01C2C54C-0787-48F8-836E-90EED0EA3CEB',
    'IDTipoMovCredito' => '2',
    'IDUtente' => '7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB',
    'Data' => '2018-05-28 15:50:08.883',
    'MovCredito' => '25.00',
    'Note' => '[PREMIO] [DSCAS] buono',
],
[
    'ID' => '23FB2175-1A38-4CAC-96BE-1F35B0F442F3',
    'IDTessera' => '01C2C54C-0787-48F8-836E-90EED0EA3CEB',
    'IDTipoMovCredito' => '2',
    'IDUtente' => '7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB',
    'Data' => '2018-03-25 16:06:02.457',
    'MovCredito' => '25.00',
    'Note' => '[PREMIO] [DSCAS] buono',
],
[
    'ID' => '13F96F9D-3530-4829-BA7E-28DBA8D7CB78',
    'IDTessera' => '01C2C54C-0787-48F8-836E-90EED0EA3CEB',
    'IDTipoMovCredito' => '2',
    'IDUtente' => '7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB',
    'Data' => '2017-12-20 16:07:35.980',
    'MovCredito' => '25.00',
    'Note' => '[PREMIO] [DSCAS] buono',
],
[
    'ID' => '85B74F5A-920E-4F37-B968-A0896B43CA7A',
    'IDTessera' => '01C2C54C-0787-48F8-836E-90EED0EA3CEB',
    'IDTipoMovCredito' => '2',
    'IDUtente' => '7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB',
    'Data' => '2017-11-10 15:05:00.297',
    'MovCredito' => '25.00',
    'Note' => '[PREMIO] [DSCAS] buono',
],
[
    'ID' => '057B483E-2AAC-4CB6-B361-37FFB21E2557',
    'IDTessera' => '01C2C54C-0787-48F8-836E-90EED0EA3CEB',
    'IDTipoMovCredito' => '2',
    'IDUtente' => '7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB',
    'Data' => '2017-10-10 15:39:18.487',
    'MovCredito' => '25.00',
    'Note' => '[PREMIO] [DSCAS] buono',
],
[
    'ID' => 'F66C72DB-A36E-48AF-AF10-2A411EA0F59C',
    'IDTessera' => '01C2C54C-0787-48F8-836E-90EED0EA3CEB',
    'IDTipoMovCredito' => '2',
    'IDUtente' => '7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB',
    'Data' => '2017-10-10 15:35:20.520',
    'MovCredito' => '25.00',
    'Note' => '[PREMIO] [DSCAS] buono',
],
[
    'ID' => 'FC3AE1BD-CC16-4761-94D0-BBCF1D272DD9',
    'IDTessera' => '01C2C54C-0787-48F8-836E-90EED0EA3CEB',
    'IDTipoMovCredito' => '2',
    'IDUtente' => '7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB',
    'Data' => '2017-08-02 10:19:33.533',
    'MovCredito' => '25.00',
    'Note' => '[PREMIO] [DSCAS] buono',
],
[
    'ID' => 'BB4BCD18-BA36-41E9-AD61-2F7B9B6491AF',
    'IDTessera' => '01C2C54C-0787-48F8-836E-90EED0EA3CEB',
    'IDTipoMovCredito' => '2',
    'IDUtente' => '7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB',
    'Data' => '2017-06-20 10:26:01.823',
    'MovCredito' => '55.00',
    'Note' => '[PREMIO] [DSCAS] Buono50',
],
[
    'ID' => '55538D18-F131-470D-8494-8D477A349820',
    'IDTessera' => '01C2C54C-0787-48F8-836E-90EED0EA3CEB',
    'IDTipoMovCredito' => '2',
    'IDUtente' => '7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB',
    'Data' => '2016-12-27 17:12:02.940',
    'MovCredito' => '25.00',
    'Note' => '[PREMIO] [DSCAS] buono',
],
[
    'ID' => '89D5CC87-E4A3-44CA-816F-7F6AE5659D77',
    'IDTessera' => '01C2C54C-0787-48F8-836E-90EED0EA3CEB',
    'IDTipoMovCredito' => '2',
    'IDUtente' => '7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB',
    'Data' => '2016-10-07 16:20:15.017',
    'MovCredito' => '25.00',
    'Note' => '[PREMIO] [DSCAS] buono',
],
[
    'ID' => 'D7AFC53C-155E-45F5-B911-2A179B9A2A4A',
    'IDTessera' => '01C2C54C-0787-48F8-836E-90EED0EA3CEB',
    'IDTipoMovCredito' => '2',
    'IDUtente' => '7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB',
    'Data' => '2016-10-07 16:17:19.407',
    'MovCredito' => '25.00',
    'Note' => '[PREMIO] [DSCAS] buono',
],
[
    'ID' => 'E5CFDEA0-420D-42D8-B5AB-A692D4E58EC0',
    'IDTessera' => '01C2C54C-0787-48F8-836E-90EED0EA3CEB',
    'IDTipoMovCredito' => '2',
    'IDUtente' => '7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB',
    'Data' => '2016-10-01 17:56:28.347',
    'MovCredito' => '25.00',
    'Note' => '[PREMIO] [DSCAS] buono',
],

]

6

Can you print what’s in $datamov variable?

7

yes its alive in datamov but if iput datamov as dataprovider for the grid

<?php echo GridView::widget([ 
'dataProvider' => $datamov,
      'columns' => [
    [
        'attribute' => 'data',
        'format' => 'text'
    ],

[‘attribute’ => ‘MovCredito’,
‘format’ => ‘text’],
[‘attribute’ => ‘MovPunti’,
‘format’ => ‘text’],
[‘attribute’ => ‘note’,
‘format’ => ‘text’],
[
‘label’ => ‘Cancella’,
//‘attribute’ => ‘education’,
//‘filter’ => [‘0’ => ‘Elementary’, ‘1’ => ‘Secondary’, ‘2’ => ‘Higher’],
//‘filterInputOptions’ => [‘prompt’ => ‘All educations’, ‘class’ => ‘form-control’, ‘id’ => null]
‘format’ => ‘raw’,
‘value’ => function($data) {
return Html::a(‘modifica’,[‘movimenti/delete’,‘id’ => $data[‘IDC’] ]);
}

    ],
          ]

]);
?>

i get

Error

Call to a member function getCount() on array

datamov

[
[
‘ID’ => ‘9AC95D39-52F7-42E8-B59D-EBADF0CF21F9’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovCredito’ => ‘2’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2019-12-06 18:36:47.647’,
‘MovCredito’ => ‘25.00’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘79954111-77B4-48FC-B9A2-48A89D329D2D’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovCredito’ => ‘2’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2019-11-03 15:38:49.297’,
‘MovCredito’ => ‘25.00’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘C35B0938-97DE-488B-B579-452FDCE5D730’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovCredito’ => ‘2’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2019-06-17 11:22:43.763’,
‘MovCredito’ => ‘25.00’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘C7BE39BE-CDFA-46DD-80F4-2383C499B9EA’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovCredito’ => ‘2’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2019-05-04 15:26:03.223’,
‘MovCredito’ => ‘55.00’,
‘Note’ => ‘[PREMIO] [DSCAS] Buono50’,
],
[
‘ID’ => ‘2887BC77-8EC1-490D-A8C6-6F99B376031F’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovCredito’ => ‘2’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2018-12-22 17:51:20.270’,
‘MovCredito’ => ‘25.00’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘67FD40FF-BABC-4349-A64D-8BAD00E8C34F’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovCredito’ => ‘2’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2018-11-16 09:56:33.480’,
‘MovCredito’ => ‘25.00’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘8B49935A-5636-46B5-B265-06195945DE83’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovCredito’ => ‘2’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2018-06-18 17:22:04.917’,
‘MovCredito’ => ‘25.00’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘51CB20CB-68D3-4CB5-969C-C5FF7A988EDD’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovCredito’ => ‘2’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2018-06-18 17:19:54.950’,
‘MovCredito’ => ‘25.00’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘72BC0FFB-C174-44B1-8599-31453A8487BA’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovCredito’ => ‘2’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2018-05-28 15:50:08.883’,
‘MovCredito’ => ‘25.00’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘23FB2175-1A38-4CAC-96BE-1F35B0F442F3’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovCredito’ => ‘2’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2018-03-25 16:06:02.457’,
‘MovCredito’ => ‘25.00’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘13F96F9D-3530-4829-BA7E-28DBA8D7CB78’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovCredito’ => ‘2’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2017-12-20 16:07:35.980’,
‘MovCredito’ => ‘25.00’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘85B74F5A-920E-4F37-B968-A0896B43CA7A’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovCredito’ => ‘2’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2017-11-10 15:05:00.297’,
‘MovCredito’ => ‘25.00’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘057B483E-2AAC-4CB6-B361-37FFB21E2557’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovCredito’ => ‘2’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2017-10-10 15:39:18.487’,
‘MovCredito’ => ‘25.00’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘F66C72DB-A36E-48AF-AF10-2A411EA0F59C’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovCredito’ => ‘2’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2017-10-10 15:35:20.520’,
‘MovCredito’ => ‘25.00’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘FC3AE1BD-CC16-4761-94D0-BBCF1D272DD9’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovCredito’ => ‘2’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2017-08-02 10:19:33.533’,
‘MovCredito’ => ‘25.00’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘BB4BCD18-BA36-41E9-AD61-2F7B9B6491AF’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovCredito’ => ‘2’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2017-06-20 10:26:01.823’,
‘MovCredito’ => ‘55.00’,
‘Note’ => ‘[PREMIO] [DSCAS] Buono50’,
],
[
‘ID’ => ‘55538D18-F131-470D-8494-8D477A349820’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovCredito’ => ‘2’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2016-12-27 17:12:02.940’,
‘MovCredito’ => ‘25.00’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘89D5CC87-E4A3-44CA-816F-7F6AE5659D77’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovCredito’ => ‘2’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2016-10-07 16:20:15.017’,
‘MovCredito’ => ‘25.00’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘D7AFC53C-155E-45F5-B911-2A179B9A2A4A’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovCredito’ => ‘2’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2016-10-07 16:17:19.407’,
‘MovCredito’ => ‘25.00’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘E5CFDEA0-420D-42D8-B5AB-A692D4E58EC0’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovCredito’ => ‘2’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2016-10-01 17:56:28.347’,
‘MovCredito’ => ‘25.00’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘765F9817-8A56-4FB9-A3D2-D44D15259A35’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovPunti’ => ‘3’,
‘IDUtente’ => ‘46FE35A3-E579-4FBF-8303-25F52344C4B9’,
‘Data’ => ‘2019-12-31 00:00:00.000’,
‘MovPunti’ => ‘191’,
‘Note’ => ‘azzeramento fine anno’,
],
[
‘ID’ => ‘9AC95D39-52F7-42E8-B59D-EBADF0CF21F9’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovPunti’ => ‘3’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2019-12-06 18:36:47.647’,
‘MovPunti’ => ‘250’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘79954111-77B4-48FC-B9A2-48A89D329D2D’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovPunti’ => ‘3’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2019-11-03 15:38:49.297’,
‘MovPunti’ => ‘250’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘C35B0938-97DE-488B-B579-452FDCE5D730’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovPunti’ => ‘3’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2019-06-17 11:22:43.763’,
‘MovPunti’ => ‘250’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘C7BE39BE-CDFA-46DD-80F4-2383C499B9EA’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovPunti’ => ‘3’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2019-05-04 15:26:03.223’,
‘MovPunti’ => ‘500’,
‘Note’ => ‘[PREMIO] [DSCAS] Buono50’,
],
[
‘ID’ => ‘167B093F-7925-4CE4-85D9-5B53B79631F0’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovPunti’ => ‘3’,
‘IDUtente’ => ‘4091248B-EBDC-4BC7-AF07-7B0AB32808D9’,
‘Data’ => ‘2018-12-31 00:00:00.000’,
‘MovPunti’ => ‘68’,
‘Note’ => ‘azzeramento’,
],
[
‘ID’ => ‘2887BC77-8EC1-490D-A8C6-6F99B376031F’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovPunti’ => ‘3’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2018-12-22 17:51:20.270’,
‘MovPunti’ => ‘250’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘67FD40FF-BABC-4349-A64D-8BAD00E8C34F’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovPunti’ => ‘3’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2018-11-16 09:56:33.480’,
‘MovPunti’ => ‘250’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘8B49935A-5636-46B5-B265-06195945DE83’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovPunti’ => ‘3’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2018-06-18 17:22:04.917’,
‘MovPunti’ => ‘250’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘51CB20CB-68D3-4CB5-969C-C5FF7A988EDD’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovPunti’ => ‘3’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2018-06-18 17:19:54.950’,
‘MovPunti’ => ‘250’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘72BC0FFB-C174-44B1-8599-31453A8487BA’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovPunti’ => ‘3’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2018-05-28 15:50:08.883’,
‘MovPunti’ => ‘250’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘23FB2175-1A38-4CAC-96BE-1F35B0F442F3’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovPunti’ => ‘3’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2018-03-25 16:06:02.457’,
‘MovPunti’ => ‘250’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘A369300C-EADE-416B-A310-511327FD0D96’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovPunti’ => ‘3’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2017-12-31 23:59:00.000’,
‘MovPunti’ => ‘149’,
‘Note’ => ‘Azzeramento per fine promozione’,
],
[
‘ID’ => ‘13F96F9D-3530-4829-BA7E-28DBA8D7CB78’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovPunti’ => ‘3’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2017-12-20 16:07:35.980’,
‘MovPunti’ => ‘250’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘85B74F5A-920E-4F37-B968-A0896B43CA7A’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovPunti’ => ‘3’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2017-11-10 15:05:00.297’,
‘MovPunti’ => ‘250’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘057B483E-2AAC-4CB6-B361-37FFB21E2557’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovPunti’ => ‘3’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2017-10-10 15:39:18.487’,
‘MovPunti’ => ‘250’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘F66C72DB-A36E-48AF-AF10-2A411EA0F59C’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovPunti’ => ‘3’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2017-10-10 15:35:20.520’,
‘MovPunti’ => ‘250’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘FC3AE1BD-CC16-4761-94D0-BBCF1D272DD9’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovPunti’ => ‘3’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2017-08-02 10:19:33.533’,
‘MovPunti’ => ‘250’,
‘Note’ => ‘[PREMIO] [DSCAS] buono’,
],
[
‘ID’ => ‘BB4BCD18-BA36-41E9-AD61-2F7B9B6491AF’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovPunti’ => ‘3’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2017-06-20 10:26:01.823’,
‘MovPunti’ => ‘500’,
‘Note’ => ‘[PREMIO] [DSCAS] Buono50’,
],
[
‘ID’ => ‘B6FDBC60-3CB9-4D27-A15D-218F194BE98B’,
‘IDTessera’ => ‘01C2C54C-0787-48F8-836E-90EED0EA3CEB’,
‘IDTipoMovPunti’ => ‘71’,
‘IDUtente’ => ‘7EDCE6A0-32F9-4AE4-A925-6C1D1DAF00DB’,
‘Data’ => ‘2016-12-27 18:47:19.200’,
‘MovPunti’ => ‘263’,
‘Note’ => ‘’,
],
]

8

You can’t put an array as a dataProvider for a GridView.

Now put back $dataProvider_all in the gridView and delete all what is in the columns array, you should have something like this columns => [].

9

now works with this code…

$MCdataprovider= new ArrayDataProvider ([
‘allModels’ => MovimentiCredito::find()->where([‘IDTessera’=>$card->ID])->orderBy(‘data DESC’)->asArray()->all(),
‘pagination’ => [
‘pageSize’ => 20,
],
]);
$MPdataprovider= new ArrayDataProvider ([
‘allModels’ => MovimentiPunti::find()->where([‘IDTessera’=>$card->ID])->orderBy(‘data DESC’)->asArray()->all(),
‘pagination’ => [
‘pageSize’ => 20,
],
]);
$datamov = array_replace_recursive ($MCdataprovider->getModels(),$MPdataprovider->getModels()); > $dataProvider_all = new ArrayDataProvider([
‘key’=>‘ID’,
‘allModels’ => $datamov,
‘sort’ => [
‘attributes’ => [‘Id’, ‘Data’ ],
],
]);

and in grid

<?php echo GridView::widget([ 'dataProvider' => $dataProvider_all,//$movcp, 'columns' => [ [ 'attribute' => 'Data', 'format' => 'text' ],

[‘attribute’ => ‘MovCredito’,
‘format’ => ‘text’],
[‘attribute’ => ‘MovPunti’,
‘format’ => ‘text’],

               ['attribute' => 'Note',
        'format' => 'text'],
                             
        [
        'label' => 'Cancella',
        //'attribute' => 'education',
        //'filter' => ['0' => 'Elementary', '1' => 'Secondary', '2' => 'Higher'],
        //'filterInputOptions' => ['prompt' => 'All educations', 'class' => 'form-control', 'id' => null]
             'format' => 'raw',
        'value' => function($data) {

                    return Html::a('modifica',['movimenti/delete','id' => $data['ID'] ]);
        }   
    ],
          ]

]);
?>

i think that the key was the key to solve the problem…:slight_smile:

10

The keys in your data provider were just indexes.

11

I think you need to flatten your array.
use this function
public static function array_flatten($array)
{
if (!is_array($array)) {
return FALSE;
}
$result = array();
foreach ($array as $key => $value) {
if (is_array($value)) {
$result = array_merge($result, self::array_flatten($value));
} else {
$result[$key] = $value;
}
}
return $result;
}

13

you need to flatten your Array consider the following function

public static function array_flatten($array)
    {
        if (!is_array($array)) {
            return FALSE;
        }
        $result = array();
        foreach ($array as $key => $value) {
            if (is_array($value)) {
                $result = array_merge($result, self::array_flatten($value));
            } else {
                $result[$key] = $value;
            }
        }
        return $result;
    }