<?php

namespace Yunshop\GroupCode\models;

use app\common\models\BaseModel;
use Illuminate\Support\Facades\DB;

/**
 * Author: 芸众商城 www.yunzshop.com
 * Date: 2017/9/23
 * Time: 上午9:59
 */
class GroupCodeDayLogModel extends BaseModel
{
    public $table = 'yz_group_code_day_log';
    public $timestamps = true;
    protected $guarded = [''];

    public function groupCode()
    {
        return $this->belongsTo('Yunshop\GroupCode\models\GroupCodeModel','group_id','id');
    }

    public static function getStatisticList($search = [])
    {
        $model = self::uniacid();
        $model->select('group_id','date_day','total_count','new_count','cumulative','cumulative_new');

        $model->with('groupCode:id,code_name');

        if(isset($search['group_id']) && is_numeric($search['group_id'])){
            $model->where('group_id',$search['group_id']);
        }

        if(!empty($search['code_name'])){
            $model->whereHas('groupCode',function ($query) use ($search){
                $query->where('code_name','like','%'.$search['code_name'].'%');
            });
        }

        if(!empty($search['time']['start']) && !empty($search['time']['end'])){
            $range = [date('Y-m-d',$search['time']['start']), date('Y-m-d',$search['time']['end'])];
            $model->whereBetween('date_day', $range);
        }

        if(empty($search) || $search['order_by'] == 0){
            $model->orderBy('date_day', 'desc');
        }elseif (!empty($search) && $search['order_by'] == 1){
            $model->orderBy('total_count', 'desc');
        }else{
            $model->orderBy('new_count', 'desc');
        }
        return $model;
    }

    //批量插入数据
    public function addAllData($data)
    {
        $res = DB::table($this->getTable())->insert($data);
        return $res;
    }

}