jbangjia/app/model/TuanGoods.php

<?php

namespace app\model;

use think\Model;
use think\facade\Db;

class TuanGoods extends Model
{
    protected $connection = 'mysql';

    protected $pk = 'id';

    protected $name = 'tuan_goods';

    public function goods()
    {
        return $this->hasOne(Goods::class, 'id', 'goods_id')->bind([
            'district_name',
            'city_name',
            'province_name'
        ]);
    }

    public static function setGoodslist($goods)
    {
        if (!empty($goods)) {
            foreach ($goods as &$vo) {
                $goodsdata = Goods::find($vo['goods_id']);
                if (!empty($goodsdata)) {
                    $vo['goods'] = $goodsdata->toArray();
                    $vo['image'] = toimg($vo['goods']['image']);
                    $vo['ptype'] = $vo['goods']['ptype'];
                    $vo['time_amount'] = $vo['goods']['time_amount'];
                    $vo['quantity_unit'] = $vo['goods']['quantity_unit'];
                    if (empty($vo['quantity_unit']) && $vo['is_times'] != 3) {
                        $vo['quantity_unit'] = '次';
                    }
                    $vo['is_timer'] = $vo['goods']['is_timer'];

                    $vo['is_times'] = $vo['goods']['is_times'];
                    $vo['timesmum'] = $vo['goods']['timesmum'];

                    //$vo['price'] = floatval($vo['price']);
                    $vo['price'] = floatval(Goods::setPrice($vo)["price"]);
                }
            }
        }
        return $goods;
    }

    public static function getTuanGoods($id)
    {
        $tuangoods = self::find($id);
        if (!empty($tuangoods)) {
            $data['tuan'] = $tuangoods->toArray();
            $goods = Goods::find($data['tuan']['goods_id']);
            if (!empty($goods)) {
                $data['goods'] = $goods->toArray();
                $data['goods']['image'] = toimg($data['goods']['image']);
            }
        }
        return $data;
    }

    public static function getDiyTuanGoods($count = 4, $goodsSort = "all", $ocid = 0)
    {
        $Configdata = Config::getconfig();        
        $query = Db::name('tuan_goods')
			->alias('tg')
			->leftJoin('goods', 'tg.goods_id = goods.id')
			->field('tg.*, goods.district_name, goods.city_name, goods.province_name');

        $query->where('tg.weid', weid());
        $query->where('tg.status', 1);
        if (empty($Configdata['show_storegoods'])) {
            $query->where('tg.sid', 0);
        }

        //$query = MiaoshaGoods::where($where);
       
        /*
        $withJoin = [
            'goods' => ['weid'=>'goodsweid','district_name', 'city_name', 'province_name'],
        ];
        $query->withJoin($withJoin, 'left');
*/

        if ($ocid) {
            $query->where(function ($q) use ($ocid) {
                $Operatingcity = Operatingcity::find($ocid);
                if (!empty($Operatingcity)) {
                    $Operatingcity = $Operatingcity->toArray();
                    if (empty($Operatingcity['areatype'])) {
                        $Operatingcity['areatype'] = 3;
                    }
                    if ($Operatingcity['areatype'] == 3) {
                        $q->where('goods.district_name', $Operatingcity['district_name'])->whereOr('goods.district_name', '');
                    } elseif ($Operatingcity['areatype'] == 2) {
                        $q->where('goods.city_name', $Operatingcity['city_name'])->whereOr('goods.city_name', '');
                    } elseif ($Operatingcity['areatype'] == 1) {
                        $q->where('goods.province_name', $Operatingcity['province_name'])->whereOr('goods.province_name', '');
                    }
                } else {
                    $q->where('goods.city_name', '');
                }
            });
        } else {
            $query->where('goods.city_name', '');
        }

        if ($goodsSort == "all") {
            $Sort = 'tg.sort asc,tg.id desc';
        } elseif ($goodsSort == "sales") {
            $Sort = 'tg.sale_count desc';
        } elseif ($goodsSort == "price") {
            $Sort = 'tg.price asc';
        }

        $data = $query->limit((int) $count)
            ->order($Sort)->select()->toArray();

        //$sql = $query->getLastSql();
        $retdata = Goods::setGoodslist($data);
        //$retdata['sql'] = $sql;
        return $retdata;
    }
}