首页 > 其他 > 详细

laravel中连表查询

时间:2019-02-28 16:36:55      阅读:471      评论:0      收藏:0      [点我收藏+]
        $skuList = ProductSkuModel::selectRaw(‘product_skus.id as sku_id,
                                    product_skus.code as code, 
                                    product_skus.wname as sku_name,
                                    product_skus.stocks as stocks,
                                    if(`product_skus`.`status`=1,\‘上架\‘,\‘下架\‘) as status,
                                    brands.name as brand,
                                    product_attributes.attribute_name as basic_attribute,
                                    product_attributes.attribute_value_name as basic_attribute_name,
                                    sku_attributes.attribute_name as price_attribute,
                                    sku_attributes.attribute_value_name as price_attribute_name)
                        ->leftJoin(‘product_attributes‘, ‘product_skus.product_id‘,
                            ‘=‘, ‘product_attributes.product_id‘)
                        ->leftJoin(‘sku_attributes‘, ‘product_skus.id‘,
                            ‘=‘, ‘sku_attributes.sku_id‘)
                        ->leftJoin(‘brands‘, ‘product_skus.brand_id‘,
                            ‘=‘, ‘brands.id‘)
                        ->where(‘sku_attributes.status‘, 1)
                        ->where(‘product_attributes.status‘, 1)
                        ->get()->toArray();

 

laravel中连表查询

原文:https://www.cnblogs.com/cjjjj/p/10451225.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!