<?php
/**
 * Created by PhpStorm
 * Author: 向往那片天空
 * Date: 2020/6/9
 * Time: 9:07
 * 微信/QQ: 250023777
 * 格言: 抓住中心，宁精勿杂，宁专勿多
 */

namespace app\admin\model\ump;


use app\admin\model\order\StoreOrder;
use crmeb\basic\BaseModel;
use crmeb\services\PHPExcelService;
use crmeb\traits\ModelTrait;

class StoreTryProduct extends BaseModel
{
    /**
     * 数据表主键
     * @var string
     */
    protected $pk = 'id';

    /**
     * 模型名称
     * @var string
     */
    protected $name = 'store_try_product';

    use ModelTrait;
    /**
     * @param $where
     * @return array
     */
    public static function systemPage($where)
    {
        $model = self::setWhere($where)->where('is_del=0')->limit(bcmul($where['page'], $where['limit'], 0), $where['limit']);
        return self::page($model,$where, $where['limit']);
    }
    /**
     * 设置拼团 where 条件
     * @param $where
     * @param null $model
     * @return mixed
     */
    public static function setWhere($where, $model = null)
    {
        $model = $model === null ? new self() : $model;
        if (isset($where['is_show']) && $where['is_show'] != '') $model = $model->where('is_show', $where['is_show']);
        if (isset($where['is_finish']) && $where['is_finish'] != '') $model = $model->where('is_finish', $where['is_finish']);
        if (isset($where['store_name']) && $where['store_name'] != '') $model = $model->where('store_name', 'LIKE', "%$where[store_name]%");
        return $model->order('sort desc,id desc')->where('is_del', 0);
    }

    public static function getCombinationIdAll(){
        return self::where('is_del', 0)->column('id', 'id');
    }
}