Problems with yii2 associating queries using hasMay - Codes Helper - Programming Question Answer

Problems with yii2 associating queries using hasMay

 $order = Orders::find()
        ->where(["order_sn" => $order_sn, "user_id" => Yii::$app->user->identity->id])
        ->all();
        



{
"success": true,
"code": 200,
"message": "OK",
"data": [
    {
        "id": "658",
        "order_sn": "201811088879168432",
        "user_id": "290",
        "order_status": 15,
        "shipping_id": 0,
        "shipping_name": "",
        "pay_id": 0,
        "pay_name": "",
        "goods_amount": "1067.00",
        "user_discount": 100,
        "shipping_fee": "0.00",
        "pay_fee": "0.00",
        "integral_money": "0.00",
        "coupon_id": "0",
        "coupon": "0.00",
        "order_amount": "1067.00",
        "created_at": "1541658432",
        "pay_time": "0",
        "shipping_time": "0",
        "finish_time": "0",
        "shipping_no": "",
        "pay_note": "",
        "ip_address": "127.0.0.1",
        "region_id": 12,
        "coupon_code_id": null,
        "discount_amount": null
    }
]

}

ordes associates multiple tables, but there is only order table data in the json data of the query

previously, if you want to query the associated data in the view, you can use the result set to call it again, for example: $orders- > user- > email;
, but what do you do now in the form of api?

Dec.08,2021

$order = Orders::find()
            ->where(['order_sn' => $order_sn, 'user_id' => Yii::$app->user->identity->id])
            ->all();

$data = [];
foreach ($order as $k => $val) {
      $data[] = [
          'id' => $val->id,
          'order_sn' => $val->order_sn,
          'user_email' => $val->user->email,
           ...
      ];
}

return json_encode($data);

Model file Orders.php can use fields () method

public function fields()
{
    $fields = parent::fields();
    $extraFields = ['user'];

    return array_merge($fields, $extraFields);
}

Previous: Is there any useful tool to check for js memory leaks? Ask for the recommendation of the boss, it is best to have a tutorial.

Next: Group by multiple fields and then fetch the most recent record

Yii2 adminlte
how do I set the menu highlight? ...

Yii2 php

Mar.04,2021
Upload yii2 pictures
how does yii2 upload pictures across servers? There is no corresponding expansion package recommendation. Thank you ...

Yii2 php

Mar.04,2021
Yii2 calls interface across controllers?
how can yii2 be called across controller calling interfaces, and parameters can be passed in. ...

Yii2 php

Mar.05,2021
How to realize dynamic attribute assignment in yii2
1. The client passes a value to the server such as: username=admin instantiate a class on the server, and the simple assignment is as follows: $userform=new UserForm (); $userform- > username= "admin "; but if the client passes password= "123456 " ...

Yii2 php

Mar.06,2021
Help to analyze the reasons for the slow running of YII2.
I installed the advance version, which runs very fast on other people s virtual machines. It takes me more than 3 seconds to run, just a simple page . enabled, but opcache,session uses redis ask for help, thank you! ...

Yii2 php

Mar.12,2021
How is YII2 written and configured before and after all action requests?
this is my ActionTimeFilter, so how can I configure it in web.php to enable every action to pass through this filter? Wait online. I ve been in a hurry all day. Is it so good? <?php namespace app filters; use Yii; use yii base Action; use yii ...

Yii2 php

Mar.17,2021
Yii restful request 405
the default RESTful, in the advanced application template prompts 405 Method Not Allowed [version 2.0] except GET I follow the similar method of creating a new application body in the advanced application template in this article, copy the Backend app...

Yii2 php yii

Mar.18,2021
Cpu99% when phpexcel reads the file
** * Excels * * @param string $file * @param array $sheet_names * * @return array|bool * @throws PHPExcel_Exception * @throws PHPExcel_Reader_Exception * public static function importExcel($file, ...

Cpu-is-too-high yii2 phpexcel excel php

Mar.20,2021
How do you save large chunks of text with oracle?
Save large chunks of text with clob if(!$this->validate()){ return false; } $model = new Article(); $model->TITLE = $this->TITLE; $model->CID = $this->CID; $model->CONTENT_DATA = $this->CONTENT_DATA; CONTENT_DATACLOB $model-...

Oracle yii2 php

Mar.28,2021
On the question of the size of the laravel and yii framework project packages, why are the packages downloaded by composer more than 100m?
such as the title vendor extension and many are not used, how to make a reasonable choice and delete? ...

Yii2 php laravel

Apr.05,2021
Problems when using each () in yii join table query
the program uses the linked table to get all the field values of the associated table, and uses each () to generate the generator. Each time the value obtained in the loop contains only the data of the main table but not the data of the associated table,...

Yii2 php

Aug.03,2021
Yii2.0 operates transactions with multiple databases
I am like this now. The project has a lot of databases, all under the same mysql server, and there is db,db2,db3 in main.php. Now there is a storage operation like this. Table A comes from db2,B table and comes from db3,. When using transactions, it is ...

Transaction mysql yii2 php

Oct.23,2021
Questions about Yii writing api
1. For example: I use yii api to write the interface for submitting orders for example, the information in the form is verified at the front end. How can I implement the verification? used to use form model validation rules and load to load data. D...

Api yii2 php

Dec.08,2021
Yii2 always fails to install yii2-easy-wechat using composer
problem description this is the expansion pack I want to install: https: github.com jianyan74 . use the command to install composer require jianyan74 yii2-easy-wechat the environmental background of the problems and what methods you have tried ...

Yii yii2 php

Jan.12,2022
Timeout release problem of swoole Cooperative redis connection Pool
use the redis, of the swoole protocol and then implement the connection pool by yourself (just a yii2-swoole written by a big god), which is stored in SplQueue, but I found that after the connection is inside, when it is idle for a long time, these conne...

Yii2 php redis swoole

Feb.07,2022

Menu