configuration window and suggestion about yii2-dynagrid

[kartik-v]

What storage method are you using?

[rafaelwithoeft]

db

echo \kartik\dynagrid\DynaGrid::widget([
    'storage' => 'db',
    'columns' => $columns,
    'options' => [
        'id' => $idLista, // um identificador único é importante!
    ],
    'userSpecific' => false,
    'theme' => 'panel-primary',
    'showPersonalize' => true,
    'gridOptions' => [
        'dataProvider' => $dataProvider,
        'panel' => [
            'heading' => '<h3 class="panel-title center-text">' . Yii::t('app', $idLista) . '</h3>',
            //'before' => '',
            //'after' => '{export}',
        ],
    ],
]);

[kartik-v]

Can you debug for db errors in the Yii debug log files and let know?

[rafaelwithoeft]

Apparently there are no errors

Here a log of DB Queries

Database Queries
Total 32 itens.

Time Duration Type Query

1 16:26:01.759 37.0 ms UPDATE UPDATE sis_configuracao SET valor='{"page":"10","keys":["017e9e28","e3568eca","4556762a","f838a0a3","be2ede79","9b99539a"],"theme":"panel-primary"}' WHERE chave='lista_escritorio_grid'
C:\xampp\htdocs\prosind\vendor\kartik-v\yii2-dynagrid\dynagrid\DynaGrid.php (297)
C:\xampp\htdocs\prosind\vendor\kartik-v\yii2-dynagrid\dynagrid\DynaGrid.php (222)
C:\xampp\htdocs\prosind\vendor\kartik-v\yii2-dynagrid\dynagrid\DynaGrid.php (204)

2 16:26:02.131 22.0 ms SELECT SELECT * FROM sis_configuracao WHERE (grupo='log') AND (chave='log')
C:\xampp\htdocs\prosind\common\modules\configuracao\models\Configuracao.php (118)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (54)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (46)

3 16:26:01.741 9.0 ms SHOW SHOW FULL COLUMNS FROM sis_configuracao
C:\xampp\htdocs\prosind\vendor\kartik-v\yii2-dynagrid\dynagrid\DynaGrid.php (297)
C:\xampp\htdocs\prosind\vendor\kartik-v\yii2-dynagrid\dynagrid\DynaGrid.php (222)
C:\xampp\htdocs\prosind\vendor\kartik-v\yii2-dynagrid\dynagrid\DynaGrid.php (204)

4 16:26:02.049 2.0 ms SELECT SELECT * FROM psw_cidade WHERE id='2'
C:\xampp\htdocs\prosind\vendor\kartik-v\yii2-grid\grid\GridView.php (511)
C:\xampp\htdocs\prosind\vendor\kartik-v\yii2-dynagrid\dynagrid\DynaGrid.php (352)
C:\xampp\htdocs\prosind\vendor\kartik-v\yii2-dynagrid\dynagrid\DynaGrid.php (205)

5 16:26:01.938 2.0 ms SELECT SELECT * FROM sis_configuracao WHERE (grupo='log') AND (chave='log')
C:\xampp\htdocs\prosind\common\modules\configuracao\models\Configuracao.php (118)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (54)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (46)

6 16:26:02.020 2.0 ms SELECT SELECT psw_escritorio.* FROM psw_escritorio LEFT JOIN psw_endereco ON psw_escritorio.endereco_id = psw_endereco.id LEFT JOIN psw_cidade ON psw_endereco.cidade_id = psw_cidade.id WHERE psw_cidade.id='2' LIMIT 10
C:\xampp\htdocs\prosind\vendor\kartik-v\yii2-grid\grid\GridView.php (511)
C:\xampp\htdocs\prosind\vendor\kartik-v\yii2-dynagrid\dynagrid\DynaGrid.php (352)
C:\xampp\htdocs\prosind\vendor\kartik-v\yii2-dynagrid\dynagrid\DynaGrid.php (205)

7 16:26:02.190 2.0 ms SELECT SELECT * FROM sis_configuracao WHERE (grupo='log') AND (chave='log')
C:\xampp\htdocs\prosind\common\modules\configuracao\models\Configuracao.php (118)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (54)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (46)

8 16:26:02.066 1.0 ms SELECT SELECT * FROM psw_observacao WHERE id='18'
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (139)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (72)
C:\xampp\htdocs\prosind\vendor\kartik-v\yii2-grid\grid\GridView.php (511)

9 16:26:01.703 1.0 ms SELECT SELECT * FROM psw_campo_bloqueado WHERE (modelo='endereco') AND (campo='endereco')
C:\xampp\htdocs\prosind\common\modules\configuracao\models\CampoBloqueado.php (116)
C:\xampp\htdocs\prosind\common\modules\configuracao\models\CampoBloqueado.php (192)
C:\xampp\htdocs\prosind\common\modules\configuracao\models\CampoBloqueado.php (152)

10 16:26:01.684 1.0 ms SELECT SELECT * FROM psw_usuario WHERE id='4'
C:\xampp\htdocs\prosind\common\modules\autenticacao\models\Usuario.php (71)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (244)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (59)

11 16:26:01.671 1.0 ms SELECT SELECT * FROM sis_configuracao WHERE (grupo='log') AND (chave='log')
C:\xampp\htdocs\prosind\common\modules\configuracao\models\Configuracao.php (118)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (54)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (46)

12 16:26:02.055 1.0 ms SELECT SELECT * FROM sis_configuracao WHERE (grupo='log') AND (chave='log')
C:\xampp\htdocs\prosind\common\modules\configuracao\models\Configuracao.php (118)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (54)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (46)

13 16:26:02.109 1.0 ms SELECT SELECT * FROM sis_configuracao WHERE (grupo='log') AND (chave='log')
C:\xampp\htdocs\prosind\common\modules\configuracao\models\Configuracao.php (118)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (54)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (46)

14 16:26:01.738 1.0 ms SELECT SELECT chave FROM sis_configuracao WHERE chave='lista_escritorio_grid'
C:\xampp\htdocs\prosind\vendor\kartik-v\yii2-dynagrid\dynagrid\DynaGrid.php (530)
C:\xampp\htdocs\prosind\vendor\kartik-v\yii2-dynagrid\dynagrid\DynaGrid.php (296)
C:\xampp\htdocs\prosind\vendor\kartik-v\yii2-dynagrid\dynagrid\DynaGrid.php (222)

15 16:26:02.041 1.0 ms SELECT SELECT * FROM psw_endereco WHERE id='5'
C:\xampp\htdocs\prosind\vendor\kartik-v\yii2-grid\grid\GridView.php (511)
C:\xampp\htdocs\prosind\vendor\kartik-v\yii2-dynagrid\dynagrid\DynaGrid.php (352)
C:\xampp\htdocs\prosind\vendor\kartik-v\yii2-dynagrid\dynagrid\DynaGrid.php (205)

16 16:26:02.077 1.0 ms SELECT SELECT * FROM psw_escritorio_tag WHERE escritorio_id='3'
C:\xampp\htdocs\prosind\frontend\modules\prosind\models\Escritorio.php (217)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (139)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (72)

17 16:26:01.960 1.0 ms SELECT SELECT * FROM sis_configuracao WHERE (grupo='log') AND (chave='log')
C:\xampp\htdocs\prosind\common\modules\configuracao\models\Configuracao.php (118)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (54)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (46)

18 16:26:02.010 1.0 ms SELECT SELECT * FROM sis_configuracao WHERE (grupo='log') AND (chave='log')
C:\xampp\htdocs\prosind\common\modules\configuracao\models\Configuracao.php (118)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (54)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (46)

19 16:26:02.026 1.0 ms SELECT SELECT * FROM sis_configuracao WHERE (grupo='log') AND (chave='log')
C:\xampp\htdocs\prosind\common\modules\configuracao\models\Configuracao.php (118)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (54)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (46)

20 16:26:02.034 1.0 ms SELECT SELECT * FROM sis_configuracao WHERE (grupo='log') AND (chave='log')
C:\xampp\htdocs\prosind\common\modules\configuracao\models\Configuracao.php (118)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (54)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (46)

21 16:26:02.104 1.0 ms SELECT SELECT * FROM sis_configuracao WHERE (grupo='log') AND (chave='log')
C:\xampp\htdocs\prosind\common\modules\configuracao\models\Configuracao.php (118)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (54)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (46)

22 16:26:02.114 1.0 ms SELECT SELECT * FROM sis_configuracao WHERE (grupo='log') AND (chave='log')
C:\xampp\htdocs\prosind\common\modules\configuracao\models\Configuracao.php (118)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (54)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (46)

23 16:26:02.120 1.0 ms SELECT SELECT * FROM sis_configuracao WHERE (grupo='log') AND (chave='log')
C:\xampp\htdocs\prosind\common\modules\configuracao\models\Configuracao.php (118)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (54)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (46)

24 16:26:02.161 1.0 ms SELECT SELECT * FROM sis_configuracao WHERE (grupo='log') AND (chave='log')
C:\xampp\htdocs\prosind\common\modules\configuracao\models\Configuracao.php (118)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (54)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (46)

25 16:26:02.168 1.0 ms SELECT SELECT * FROM sis_configuracao WHERE (grupo='log') AND (chave='log')
C:\xampp\htdocs\prosind\common\modules\configuracao\models\Configuracao.php (118)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (54)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (46)

26 16:26:02.175 1.0 ms SELECT SELECT * FROM sis_configuracao WHERE (grupo='log') AND (chave='log')
C:\xampp\htdocs\prosind\common\modules\configuracao\models\Configuracao.php (118)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (54)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (46)

27 16:26:02.182 1.0 ms SELECT SELECT * FROM sis_configuracao WHERE (grupo='log') AND (chave='log')
C:\xampp\htdocs\prosind\common\modules\configuracao\models\Configuracao.php (118)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (54)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (46)

28 16:26:01.953 1.0 ms SELECT SELECT COUNT(*) FROM psw_escritorio LEFT JOIN psw_endereco ON psw_escritorio.endereco_id = psw_endereco.id LEFT JOIN psw_cidade ON psw_endereco.cidade_id = psw_cidade.id WHERE psw_cidade.id='2'
C:\xampp\htdocs\prosind\vendor\kartik-v\yii2-grid\grid\GridView.php (511)
C:\xampp\htdocs\prosind\vendor\kartik-v\yii2-dynagrid\dynagrid\DynaGrid.php (352)
C:\xampp\htdocs\prosind\vendor\kartik-v\yii2-dynagrid\dynagrid\DynaGrid.php (205)

29 16:26:02.088 1.0 ms SELECT SELECT nome FROM psw_tag WHERE id IN ('1', '2', '3', '4', '6')
C:\xampp\htdocs\prosind\frontend\modules\prosind\models\Escritorio.php (217)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (139)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (72)

30 16:26:01.752 1.0 ms SHOW SHOW CREATE TABLE sis_configuracao
C:\xampp\htdocs\prosind\vendor\kartik-v\yii2-dynagrid\dynagrid\DynaGrid.php (297)
C:\xampp\htdocs\prosind\vendor\kartik-v\yii2-dynagrid\dynagrid\DynaGrid.php (222)
C:\xampp\htdocs\prosind\vendor\kartik-v\yii2-dynagrid\dynagrid\DynaGrid.php (204)

31 16:26:01.700 0.0 ms SELECT SELECT * FROM psw_campo_bloqueado WHERE modelo='escritorio'
C:\xampp\htdocs\prosind\common\modules\configuracao\models\CampoBloqueado.php (126)
C:\xampp\htdocs\prosind\common\modules\configuracao\models\CampoBloqueado.php (139)
C:\xampp\htdocs\prosind\frontend\modules\prosind\models\Escritorio.php (287)

32 16:26:02.093 0.0 ms SELECT SELECT * FROM sis_configuracao WHERE (grupo='log') AND (chave='log')
C:\xampp\htdocs\prosind\common\modules\configuracao\models\Configuracao.php (118)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (54)
C:\xampp\htdocs\prosind\common\behaviors\LogBehavior.php (46)

[kartik-v]

Do not see any data insert.

Ensure you have the tbl_dynagrid table created or any name --- and your dynagrid module has the dbSettings configured as described in module setup

[rafaelwithoeft]

In the first request has a update on the target table of the dynagrid

'dynagrid' => [
        'class' => 'kartik\dynagrid\Module',
        'dbSettings' => [
            'tableName' => 'sis_configuracao',
            'idAttr' => 'chave',
            'dataAttr' => 'valor',
        ],
        'i18n' => [
            'class' => 'yii\i18n\PhpMessageSource',
            'basePath' => '@kvdynagrid/messages',
            'forceTranslation' => true
        ],
    ],
    'gridview' => [
        'class' => 'kartik\grid\Module',
    ],

[kartik-v]

• Do you see the correct updated data in your table sis_configuracao as shown in the query?
• Are you populating other fields in the same table? Check for data inconsistencies/errors?

[rafaelwithoeft]

The application generate a dynamic query based on selected fields by user... but the first, or another request if is different of the configuration request... it works
Example:
I click in the header columns to order results... it works
First request.. its work too

[kartik-v]

I am not able to replicate your situation. The extension is tested with all storage options - including db and it works okay on every save.

• Can you mention at what stage you receive blank data?
• If you have changed the extension code in any way - I may not be able to help - you need to check your code for such a condition which is causing your behavior.

[kartik-v]

If you are logging in as different users the property userSpecific should control how the dynagrid appears for different users.

[kartik-v]

I pushed in a few minor fixes for theming and changing private variables to protected. Closing the issue... in case you find something with your error let know and this can be reopened.