DER2021102201/app/common/model/user/Favorite.php

<?php


namespace app\common\model\user;

use app\common\model\BaseModel;
use app\api\model\product\Product as ProductModel;
use app\api\model\supplier\Category as CategoryModel;
/**
 * 收藏模型
 */
class Favorite extends BaseModel
{
    protected $pk = 'favorite_id';
    protected $name = 'user_favorite';

    //获取收藏商品列表
    public function getList($where,$param){
        $list = $this->where($where)
                    ->with(['product','image.file'])
                    ->field("*")
                    ->order('create_time desc')
                    ->paginate($param);
        foreach ($list as &$product) {
            // 商品主图
            $product['product_image'] = $product['image'][0]['file_path'];
            $product['product_name'] = $product['product'][0]['product_name'];
            $product['product_price'] = $product['product'][0]['product_price'];
            $product['product_id'] = $product['product'][0]['product_id'];
            $product['city_name'] = $product['product'][0]['city_name'];
            $product['line_price'] = $product['product'][0]['line_price'];
            $product['product_sales'] = $product['product'][0]['product_sales'];
            unset($product['image']);unset($product['product']);
        }
        return $list;
    }
     //获取关注店铺列表
    public function getMySupplier($where,$param){
        $product_model = new ProductModel;
        $list = $this->alias('s')->where($where)
                        ->with(['supplier','supplier.logo'])
                        ->field("*")
                        ->order('create_time desc')
                        ->paginate($param);
        foreach ($list as $key => &$value) {
           $value['store_name'] = $value['supplier']['name'];
           $value['shop_supplier_id'] = $value['supplier']['shop_supplier_id'];
           $value['logo'] = $value['supplier']['logo']['file_path'];
           $value['score'] = $value['supplier']['score'];
           $value['fav_count'] = $value['supplier']['fav_count'];
           $value['categoryName'] = $value['supplier']['category_id']?(new CategoryModel())->where('category_id','=',$value['supplier']['category_id'])->value('name'):'';
           unset($value['supplier']);
           //获取最新上架商品
            $productList = $product_model->with(['image.file'])->where(['product_status'=>10,'shop_supplier_id'=>$value['shop_supplier_id'],'audit_status'=>10,'is_delete'=>0])->field("product_name,product_id,sales_initial,sales_actual,product_price,line_price")->order('product_id desc')->limit(3)->select();
            foreach ($productList as $kk => &$vv) {
                $vv['logo'] = $vv['image'][0]['file_path'];
                unset($vv['image']);
            }
            $value['productList'] = $productList;
        }
        return $list;
    }
    /**
     * 关联商品图片表
     */
    public function image()
    {
        return $this->hasMany('app\\common\\model\\product\\ProductImage','product_id','pid')->order(['id' => 'asc']);
    }
    /**
     * 关联商品表
     */
    public function product()
    {
        return $this->hasMany('app\\common\\model\\product\\Product','product_id','pid')->bind(['product_id','sales_actual']);
    }
    /**
     * 关联店铺
     */
    public function supplier()
    {
        return $this->hasOne('app\\common\\model\\supplier\\Supplier','shop_supplier_id','pid')->hidden(['user_id','password','total_money','money','freeze_money','cash_money','is_delete','app_id','create_time','update_time']);
    }

    /**
     * 关联用户
     */
    public function user()
    {
        return $this->hasOne('app\\common\\model\\user\\User','user_id','user_id')
            ->field(['user_id','nickName','mobile','avatarUrl','create_time','country','province','city','gender']);
    }

    /**
     * 根据收藏id，类型，用户查询，判断用户是否收藏
     */
    public static function detail($pid, $type, $user_id){
        $where['pid'] = $pid;
        $where['type'] = $type;
        $where['user_id'] = $user_id;
        return (new static())->where($where)->find();
    }
}