xinyi_admin/application/common/model/BuyCarModel.php

<?php
namespace app\common\model;
/**
 * 会员购物车
 * Class BuyCarModel
 * @package app\common\model
 */

class BuyCarModel extends BaseModel
{
    protected $table = 'buy_car';

    /**
     * 获得购物车商品
     * @param $condition
     * @return false|\PDOStatement|string|\think\Collection
     */
    public function getCarAndProduct($condition = []){
        $list = $this->alias('car')
            ->field('car.*,product.product_name,product.market_price,product.member_price,product.images,product.product_id,dg.price as dg_price,promo.price as promo_price')
            ->join('product product','product.product_no=car.product_no','left')
            ->join('doctor_guide dg','dg.doctor_no = car.doctor_no and dg.product_no = car.product_no','LEFT')
            ->join('product_promo promo','promo.product_no = car.product_no','LEFT')
            ->where($condition)
            ->select();

        foreach ($list as &$pro){
            if($pro['dg_price'] != null){
                $member_price = $pro['dg_price'];
            }elseif($pro['promo_price'] != null){
                $member_price = $pro['promo_price'];
            }else{
                $member_price = $pro['member_price'];
            }
            $intPrice = intval($member_price/100);
            $dotPrice = intval($member_price%100);
            $dotPrice = str_pad($dotPrice,2,0);
            $pro['sales_price'] = $intPrice.".".$dotPrice;
        }
        return $list;
    }
}