Yii2 ArrayHelper::map left join select

Question

I have users, orders and plans. When client buy plan, data is save in orders , plans are in account_plan and the information for user is in table users. In table orders is when the plan start and when it is expired. I use for Select2 ArrayHelper, but do not show the column here is a query

 $masAcc[0] = Yii::t('app', 'Choose plan');
 $masAcc['----------------'] = 
ArrayHelper::map(
\backend\models\Orders::find()
->select('orders.*,account_planLang.name as name')
->leftJoin('orders_props','`orders_props`.`order_id`= `orders`.`id`')
->leftJoin('account_plan','`orders_props`.`product_id`=`account_plan`.`id`')
->leftJoin('account_planLang','account_plan.id=account_planLang.plan_id')
->where('`orders`.`dt_end`<CURDATE() + INTERVAL 5 DAY AND `orders`.`dt_end`<CURDATE()')
->all(), 'id', 'name');

but the error is : Getting unknown property: backend\models\Orders::name here is Select2:

 $form->field($model, 'account')->widget(Select2::classname(), [
                        'model' => $model,
                        'theme' => 'bootstrap',
                        'options' => [
                            'placeholder' => Yii::t('app', 'app.choose'),
                            'class' => 'form-control select2'
                        ],
                        'data' => $masAcc,
                        'pluginOptions' => [
                            'allowClear' => true,
                        ],
                    ]);
                    }

rob006 · Accepted Answer · 2018-07-20 10:07:21Z

2

That is because your query returns list of Orders models, which does not have name column, so it cannot represent result of this query. You need to use asArray() when you want to query field that is not available in model:

ArrayHelper::map(
    \backend\models\Orders::find()
        ->select('orders.*,account_planLang.name as name')
        ->leftJoin('orders_props','`orders_props`.`order_id`= `orders`.`id`')
        ->leftJoin('account_plan','`orders_props`.`product_id`=`account_plan`.`id`')
        ->leftJoin('account_planLang','account_plan.id=account_planLang.plan_id')
        ->where('`orders`.`dt_end`<CURDATE() + INTERVAL 5 DAY AND `orders`.`dt_end`<CURDATE()')
        ->asArray() // <- this
        ->all(), 
    'id', 
    'name'
);

Or add name field to your model:

class Orders extends ActiveRecord {

    public $name;

    // ...

}

answered Jul 20, 2018 at 10:07

rob006

22.3k5 gold badges57 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Sudharshan Nair Over a year ago

I think user need to fetch account_planLang.name

Muhammad Omer Aslam Over a year ago

he is using alias account_planLang.name as name for the field. @SudharshanNair

Insane Skull · Accepted Answer · 2018-07-21 06:49:21Z

1

I guess there is no need to use ArrayHepler::map(). Try this way:

Orders::find()
  ->select('account_planLang.name as name, table_name.id as id')
  ->leftJoin('orders_props','`orders_props`.`order_id`= `orders`.`id`')
  ->leftJoin('account_plan','`orders_props`.`product_id`=`account_plan`.`id`')
  ->leftJoin('account_planLang','account_plan.id=account_planLang.plan_id')
  ->where('`orders`.`dt_end`<CURDATE() + INTERVAL 5 DAY AND `orders`.`dt_end`<CURDATE()')
  ->indexBy('id')
  ->column();

answered Jul 21, 2018 at 6:49

Insane Skull

9,3619 gold badges49 silver badges66 bronze badges

Collectives™ on Stack Overflow

Yii2 ArrayHelper::map left join select

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related