File "DashboardController.php"
Full Path: /home/palsarh/web/palsarh.in/public_html/app/Http/Controllers/instructor/DashboardController.php
File size: 994 bytes
MIME-type: text/x-php
Charset: utf-8
<?php
namespace App\Http\Controllers\instructor;
use App\Http\Controllers\Controller;
use App\Models\Course;
use App\Models\Lesson;
use App\Models\Payment_history;
use Illuminate\Http\Request;
class DashboardController extends Controller
{
public function index()
{
$monthly_amount = array(0);
for ($i = 1; $i <= 12; $i++) {
$total_amount = date('t', strtotime(date("Y-$i-1 00:00:00")));
$amount = Payment_history::whereDate('created_at', '>=', date("Y-$i-1 00:00:00"))->whereDate('created_at', '<=', date("Y-$i-$total_amount 23:59:59"))->get();
if (count($amount) > 0) {
array_push($monthly_amount, array_sum($amount->pluck('instructor_revenue')->toArray()));
} else {
array_push($monthly_amount, 0);
}
}
$page_data['monthly_amount'] = $monthly_amount;
return view('instructor.dashboard.index', $page_data);
}
}