首页 文章

Laravel MongoDB集团由

提问于
浏览 次
2

我目前正在joraggers-mongodb中使用mongodb 3.0.3在laravel 5中雄辩 . 我正在尝试加入两个不同的表，如下所示：

User Model

public function userpayment() {
    return $this->hasMany('App\Models\Userpayment', 'user_id', '_id');
}

Userpayment model

public function user() {
    return $this->belongsTo('App\Models\User','user_id');
}

我正在使用存储库模式

public function __construct() {
    $this->model = new User;
}

return $this->model->with(array('userpayment'=>function($query){
                                $query
                                ->groupBy('dealCodeNumber')
                                ->get();
                    }))
                    ->where('_id',$sid)

                    ->get();

groupBy dealCodeNumber返回NULL .

array:1 [▼
 0 => array:15 [▼
"_id" => "55813f4cbc59a3f1372e9e6f"
"full_name" => "Varathan"
"username" => "shopsyadmin"
"web_url" => ""
"userpayment" => []
]

没有groupby返回全部 .

array:1 [▼
0 => array:15 [▼
"_id" => "55813f4cbc59a3f1372e9e6f"
"full_name" => "Varathan"
"username" => "shopsyadmin"
"userpayment" => array:2 [▼
  0 => array:57 [▼
    "_id" => "55816ce7cc7d4bac0d000029"
    "dealCodeNumber" => "1398410837"
    "inserttime" => "1398411401"
    "status" => "Pending"
  ]
  1 => array:57 [▶]
]

与groupby的Querylog

[query] => shopsy_user_payment.aggregate([{"$match":{"user_id":{"$in":["55813f4cbc59a3f1372e9e6f"]}}},{"$group":{"_id":{"dealCodeNumber":"$dealCodeNumber"}

为什么groupby返回null？

php mongodb laravel-5 jenssegers-mongodb

1 回答

  • 2

    要对列进行分组，必须在分组之前选择它 . 将代码更改为以下工作：

    return $this->model->with(array('userpayment'=>function($query){
    $query
        ->select('product_id','user_id','dealCodeNumber')
        ->groupBy('dealCodeNumber')
        ->get();
}))
    ->where('_id',$sid)
    ->get();
    回复于

相关问题