<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use DB;
use Auth;

class StreamerEarningController extends Controller
{
    //
    public function streamer_earning(){
    		$addvalidity[0]=" -0 days";
    	$addvalidity[1]=" -7 days";
    	$addvalidity[2]=" -1 months";
    	$addvalidity[3]=" -1 year";

    	//$dat2=DB::table('packages')->get();
    	$dat4=DB::table('donation_viewer')->sum('amount_usd');

for($i=0;$i<4;$i++){
    	$dat3=DB::table('donation_viewer')->whereBetween('created_at', [date('Y-m-d', strtotime($addvalidity[$i])), date('Y-m-d')])->where('receivername','tarek7955')->sum('amount_usd');
    	$income[$i][0]=$dat3;

    }

$income[$i][0]=$dat4;

return view('streamer_earning',compact('income'));

    }
}