<?php

namespace app\api\model\plus\groupbuy;

use app\common\model\plus\groupbuy\Active as ActiveModel;

/**
 * 团购活动模型（API端）
 */
class Active extends ActiveModel
{
    /**
     * 获取活动列表
     */
    public function getList($param)
    {
        $model = $this;
        if (isset($param['status']) && $param['status'] > -1) {
            $model = $model->where('status', '=', $param['status']);
        }
        if (isset($param['title']) && !empty($param['title'])) {
            // 修改为正确的字段名 active_name
            $model = $model->where('active_name', 'like', '%' . trim($param['title']) . '%');
        }
        $res = $model->with(['file'])
            ->order('create_time', 'desc')
            ->paginate($param);

        foreach ($res as $key => $val) {
            $res[$key]['start_time'] = format_time($val['start_time']);
            $res[$key]['end_time'] = format_time($val['end_time']);
        }
        return $res;
    }

    /**
     * 获取有效的团购活动
     */
    public static function getValidActive()
    {
        return (new static())
            ->where('start_time', '<=', time())
            ->where('end_time', '>', time())
            ->where('status', '=', 1)
            ->where('is_delete', '=', 0)
            ->order(['sort' => 'asc', 'create_time' => 'desc'])
            ->find();
    }

    /**
     * 获取团购商品列表
     */
    public function getGroupbuyProductList($groupbuy_active_id, $limit)
    {
        // 获取列表数据
        $list = $this->alias("a")
            ->with(['product.image.file', 'groupbuySku'])
            ->join('product product', 'product.product_id=a.product_id')
            ->join('supplier supplier', 'product.shop_supplier_id = supplier.shop_supplier_id', 'left')
            ->where('groupbuy_active_id', '=', $groupbuy_active_id)
            ->where('a.is_delete', '=', 0)
            ->where('a.status', '=', 10)
            ->where('a.state', '=', 10)
            ->where('product.is_delete', '=', 0)
            ->where('supplier.is_delete', '=', 0)
            ->where('supplier.status', '=', 0)
            ->limit($limit)
            ->select();

        $data = [];
        foreach ($list as $item) {
            $data[] = [
                'product' => $item['product'],
                'groupbuySku' => $item['groupbuySku'],
                'groupbuy_price' => $item['groupbuySku'][0]['groupbuy_price'],
                'product_price' => $item['groupbuySku'][0]['product_price'],
                'groupbuy_num' => $item['groupbuy_num'],
                'limit_num' => $item['limit_num'],
                'stock' => $item['groupbuySku'][0]['groupbuy_stock'],
                'product_sales' => $item['product']['product_sales'] + $item['sales_initial'],
            ];
        }
        return $data;
    }
}