JoinWith - assign a column aliases to an attribute of related model

[minitia]

This is my query:

$tripQry = Trip::find()
        ->select(['{{trip}}.*', 'distance' => 'MIN((((acos(sin(('.$coords_data[0].'*pi()/180)) * sin(({{trip_points}}.[[lat]]*pi()/180))+cos(('.$coords_data[0].'*pi()/180)) * cos(({{trip_points}}.[[lat]]*pi()/180)) * cos((('.$coords_data[1].'- {{trip_points}}.[[lng]]) * pi()/180))))*180/pi())*60*1.1515*1.609344))'])
        ->joinWith(['tripPoints'])
        ->where(['{{trip}}.[[matches_id]]' => $match_id])
        ->orderBy(['distance'=>SORT_ASC])
        ->groupBy('id');

I'd like to assign distance value to tripPoints.distance attribute.
It seems that I can assign to Trip attribute.

Any suggestion?

Thank you,
Mattia

[arogachev]

@minitia Please format your code properly.

As for your problem, seems like it's already covered in offiical docs in Active Record - Selecting extra fields section. The given example uses one model, but instead of assigning to tripPoints.distance attribute you can assign calculation results to tripPointsDistance additional attribute of the main model.

If you want to assign distance as attribute of tripPoints, you can try to use the same technique but customize joinWith like so:

->joinWith(['books' => function (\yii\db\ActiveQuery $query) {
    $query->addSelect('distance' => 'your expression goes here']);
}]

You can find more info about joinWith and addSelect in official docs.

[yii-bot]

This is an automated comment, triggered by adding the label question.

Please note, that the GitHub Issue Tracker is for bug reports and feature requests only.

We are happy to help you on the support forum, on IRC (#yii on freenode), or Gitter.

Please use one of the above mentioned resources to discuss the problem.
If the result of the discussion turns out that there really is a bug in the framework, feel free to
come back and provide information on how to reproduce the issue. This issue will be closed for now.

[minitia]

Probably I have not explained well.
I'd like to assign "distance" columns alias not to del principal "Trip model" but to the related one "TripPoint" used in joinWith condition.

[arogachev]

@minitia I covered this with separate example. Same technique is used, the only difference is you need to move selecting distance part to joinWith relation call.

[minitia]

@arogachev thank you.
Now I've understand but adding the selecting part of distance in joinWith relational call the problem is that the $coordsvariable used in calculation is not visible inside the function.

[arogachev]

@minitia In PHP you can pass additional variables to closure using use keyword:

function (\yii\db\ActiveQuery $query) use ($coords) {
    // Use $coords here
}

[minitia]

Thanks you so much!

Il 26 ott 2016 2:00 PM, "Alexey Rogachev" notifications@github.com ha
scritto:

@minitia https://github.com/minitia In PHP you can pass additional
variables to closure using use keyword:

function (\yii\db\ActiveQuery $query) use ($yourAdditionalVariable) { // Use $yourAdditionalVariable here}

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#12846 (comment), or mute
the thread
https://github.com/notifications/unsubscribe-auth/ANZq6tdHAAMsG2spcpp2Oobxvb7DP6vhks5q30DLgaJpZM4Kg9zj
.