zyedu/application/wap/model/live/LiveGoods.php

<?php
// +----------------------------------------------------------------------
// | CRMEB [ CRMEB赋能开发者，助力企业发展 ]
// +----------------------------------------------------------------------
// | Copyright (c) 2016～2022 https://www.crmeb.com All rights reserved.
// +----------------------------------------------------------------------
// | Licensed CRMEB并不是自由软件，未经许可不能去掉CRMEB相关版权
// +----------------------------------------------------------------------
// | Author: CRMEB Team <admin@crmeb.com>
// +----------------------------------------------------------------------

namespace app\wap\model\live;

use app\wap\model\store\StoreOrder;
use app\wap\model\store\StoreProduct;
use basic\ModelBasic;
use service\SystemConfigService;
use traits\ModelTrait;
use app\wap\model\user\User;
use app\wap\model\special\Special;

/**直播带货
 * Class LiveGoods
 * @package app\wap\model\live
 */
class LiveGoods extends ModelBasic
{

    use ModelTrait;

    /**直播带货列表
     * @param $where
     * @param int $is_member
     * @param int $page
     * @param int $limit
     * @return array
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public static function getLiveGoodsList($where, $is_member = 0, $page = 0, $limit = 10)
    {
        $model = self::alias('g');
        $model = $model->where('g.is_delete', 0);
        if ($where['is_show'] != "" && isset($where['is_show'])) {
            $model = $model->where('g.is_show', $where['is_show']);
        }
        if ($where['live_id'] != 0 && isset($where['live_id'])) {
            $model = $model->where('g.live_id', $where['live_id']);
        }
        $model = $model->field('g.id as live_goods_id,g.special_id, g.sort as gsort, g.fake_sales as gfake_sales,g.type as gfake_type, g.is_show as gis_show, g.sales as gsales');
        $model = $model->order('g.sort desc');
        if ($page && $limit) {
            $list = $model->page((int)$page, (int)$limit)->select();
        } else {
            $list = $model->select();
        }
        $list = count($list) ? $list->toArray() : [];
        foreach ($list as $key => &$item) {
            if ($item['gfake_type'] == 0) {
                $special = Special::PreWhere()->where('id', $item['special_id'])->find();
                if (!$special) {
                    array_splice($list, $key, 1);
                    continue;
                }
                if (!$is_member && $special['is_mer_visible'] == 1) {
                    array_splice($list, $key, 1);
                    continue;
                }
                $item['id'] = $special['id'];
                $item['image'] = $special['image'];
                $item['title'] = $special['title'];
                $item['is_light'] = $special['is_light'];
                $item['member_pay_type'] = $special['member_pay_type'];
                $item['member_money'] = $special['member_money'];
                $item['money'] = $special['money'];
                $item['label'] = $special['label'];
                $item['_add_time'] = $special['add_time'];
                $item['pink_end_time'] = $special['pink_end_time'] ? strtotime($special['pink_end_time']) : 0;
                $item['sales'] = StoreOrder::where(['paid' => 1, 'cart_id' => $special['id'], 'refund_status' => 0, 'type' => 0])->count();
                //查看拼团状态,如果已结束关闭拼团
                if ($special['is_pink'] && $special['pink_end_time'] < time()) {
                    self::update(['is_pink' => 0], ['id' => $item['live_goods_id']]);
                    $item['is_pink'] = 0;
                }
            } else {
                $store = StoreProduct::where('id', $item['special_id'])->where('is_del', 0)->find();
                if (!$store) {
                    array_splice($list, $key, 1);
                    continue;
                }
                $item['id'] = $store['id'];
                $item['image'] = $store['image'];
                $item['title'] = $store['store_name'];
                $item['member_pay_type'] = 0;
                $item['member_money'] = $store['vip_price'];
                $item['money'] = $store['price'];
                $item['label'] = explode(',', $store['keyword']);
                $item['_add_time'] = date('Y-m-d H:i:s', $store['add_time']);
                $item['sales'] = $store['sales'];
            }
        }
        $page++;
        return ['list' => $list, 'page' => $page];
    }


}