shamyyl

$query = (new Query())
                ->select($columns)
                ->from([BaseMaterial::tableName(), $table_name]);
            
            $dataProvider = new ActiveDataProvider([
                'query' => $query
            ]);

sendmail_path = '/usr/sbin/sendmail -t -i -fno-reply@my.domain.com -Fno-reply'

'components' => [
        'db' => [
              'class' => 'yii\db\Connection',
              'dsn' => 'pgsql:host=127.0.0.1;dbname=dbname',
              'username' => 'username',
              'password' => 'pass',
              'charset' => 'utf8',
              'enableSchemaCache' => YII_DEBUG ? false : true,
        ]
]