时间戳

首页 > 解决方案 > 联合查询到 Laravel Eloquent 查询

php - 联合查询到 Laravel Eloquent 查询

问题描述

需要帮助将此查询转换为 laravel Eloquent 查询

select `pin`.*,`pin_reviews`.`review`,( 3959 * acos( cos( radians('27.788870') ) * cos( radians( lat ) ) * cos( radians( lng ) - radians('72.978920') ) + sin( radians('27.788870') ) * sin( radians( lat ) ) ) ) AS distance,COUNT(`pin_reviews`.`pin_id`) as `totalUserRating`,SUM(`pin_reviews`.`rating`) / (COUNT(`pin_reviews`.rating * 5)) as `rating`,`ads`.`product_name`,`ads`.`id` as 'adId',`ads`.`notes`,`ads`.`add_status`,`ads`.`description` as 'adsDescription',`c`.`name` as 'catName',`c`.`id` as 'catId',`sc`.`id` as 'subcatId', `sc`.`name` as 'subName',`ssc`.`id` as 'SubsubId',`ssc`.`name` as 'subsubName' from ( 

  ( SELECT
        *
    FROM
        pin WHERE `subscription_plan` = 'Premium' LIMIT 2)
    UNION 
       ( SELECT
            *
        FROM
            pin WHERE `subscription_plan` = 'Platinum' LIMIT 1)
    UNION
        (SELECT
            *
            FROM pin WHERE `subscription_plan` = 'Free' LIMIT 10)
)

 AS pin
left join `pin_reviews` on `pin_reviews`.`pin_id` = `pin`.`id` left 
join `ads` on `ads`.`pin_id` = `pin`.`id` left join `category` as `c` 
on `c`.`id` = `ads`.`category_id` left join `category` as `sc` on 
`sc`.`id` = `ads`.`sub_category_id` left join `category` as `ssc` on 
`ssc`.`id` = `ads`.`sub_sub_category` where `pin`.`status` = 1 group 
by 
`pin`.`id` having `distance` < 380 order by `distance` asc limit 15

标签： phpmysqllaraveleloquentlaravel-5.2

解决方案

Laravel eloquent 支持union()您进行另一个查询，但在这种情况下，将所有查询放在一个DB::selectRaw()

https://laravel.com/docs/5.6/queries#unions

https://laravel.com/docs/5.6/queries#raw-expressions

推荐阅读