<?php

namespace app\api\model;


use think\Db;
use think\Model;

class Week extends Model
{
    
    public function serial_index($user_id, $type){
        
        $user_info = db::name('user')->where('uid', $user_id)->field('uid,base64_nick_name,head_pic')->find();
		$user_info['nickname'] = mb_convert_encoding(base64_decode($user_info['base64_nick_name']), 'UTF-8', 'UTF-8');
		if(!isset($user_info['uid'])){
			return ajaxReturn(201, '该用户不存在', null);
			exit;
		}
		
        $query = db::name('user_send_gift')
            ->where('room_uid', $user_id)
            ->order('add_time desc');
            
            
		if($type==2){
		    $query = $query->whereTime('add_time', 'last week');
		}else if($type==3){
		    $query = $query->whereTime('add_time', 'month');
		}else if($type==4){
		    $query = $query->whereTime('add_time', 'last month');
		}else{
		    $query = $query->whereTime('add_time', 'week');
		}
		$list = $query->select();
		
        // $_list = collection($list)->toArray();
        $_list = $list;
		$list=[];
		$total=0;
		foreach($_list as $val){
			$t=date("Y-m-d", $val['add_time']);
			if(isset($list[$t])){
				$list[$t]['total_price'] += $val['gift_total_price'];
			}else{
				$list[$t]['total_price'] = $val['gift_total_price'];
				$list[$t]['ct'] = $t;
				$list[$t]['box_price'] = $t;
			}
			$total += $val['gift_total_price'];
		}

		$list = array_values($list);
		
        $result = array("rows" => $list, 'total'=>$total,'userinfo'=>$user_info);
        
        return ['code' => 200, 'msg' => '获取成功', 'data' => $result];
        
    }
    
}