Autocomplete

   <?php
    use yii\web\JsExpression;

    $data = Company::find()
    ->select(['name as value', 'name as  label','c_id as id'])
    ->asArray()
    ->all();

    echo AutoComplete::widget([
    'name' => 'Company',
    'id' => 'ddd',
    'clientOptions' => [
        'source' => $data,
        'autoFill'=>true,
        'minLength'=>'4',
        'select' => new JsExpression("function( event, ui ) {
                $('#user-company').val(ui.item.id);
            }")
        ],
     ]);
     ?>

    <?= Html::activeHiddenInput($model, 'company')?>

Extraer el año d euna fecha en sql

echo $query = 'SELECT count(fecha)  FROM al_entradas where extract(year from fecha)  ='.$value['periodo'];

$movimientos =  \Yii::$app->db->createCommand($query)->queryScalar();