000

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

class DashboardController extends Controller
{
    public function userDashboard() {
        $data = array();
        $data['page']='Dashboard';
        $data['totalFormList'] = '';

if(\Auth::user()->role_type == 1) {

$data['members'] = \App\MembershipDetail::join('user_edit_permissions', 'user_edit_permissions.form_id', 'membership_details.id')->where('user_edit_permissions.user_id', \Auth::user()->id)->where('membership_details.is_active', 1)->where('user_edit_permissions.is_active', 1)->get();

$data['totalAllottedForm'] = \App\UserEditPermission::where('user_id', \Auth::user()->id)->where('is_active',1)->count();
            
    	    $data['totalFormPending'] = \App\UserEditPermission::where('user_id', \Auth::user()->id)->where(function ($query){
    	        $query->where('update_status','Pending')->orWhere('update_status','Processing');
    	    })->where('is_active',1)->count();
    	    
    	    $data['totalFormRejected'] = \App\UserEditPermission::where('user_id', \Auth::user()->id)->where('update_status','Rejected')->where('is_active',1)->count();

$data['totalFormApproved'] = \App\UserEditPermission::where('user_id', \Auth::user()->id)->where('update_status','Approved')->where('is_active',1)->count();

} elseif(\Auth::user()->role_type == 2) {

$data['members'] = \App\MembershipDetail::join('legal_edit_permissions', 'legal_edit_permissions.form_id', 'membership_details.id')->where('legal_edit_permissions.user_id', \Auth::user()->id)->where('membership_details.is_active', 1)->where('legal_edit_permissions.is_active', 1)->get();

$data['totalAllottedForm'] = \App\LegalEditPermission::where('user_id', \Auth::user()->id)->where('is_active',1)->count();

$data['totalFormPending'] = \App\LegalEditPermission::where('user_id', \Auth::user()->id)->where(function ($query){
    	        $query->where('update_status','Pending')->orWhere('update_status','Processing');
    	    })->where('is_active',1)->count();

$data['totalFormRejected'] = \App\LegalEditPermission::where('user_id', \Auth::user()->id)->where('update_status','Rejected')->where('is_active',1)->count();

$data['totalFormApproved'] = \App\LegalEditPermission::where('user_id', \Auth::user()->id)->where('update_status','Approved')->where('is_active',1)->count();

} elseif(\Auth::user()->role_type == 3) {

$data['members'] = \App\MembershipDetail::join('finance_edit_permissions', 'finance_edit_permissions.form_id', 'membership_details.id')->where('finance_edit_permissions.user_id', \Auth::user()->id)->where('membership_details.is_active', 1)->where('finance_edit_permissions.is_active', 1)->get();

$data['totalAllottedForm'] = \App\FinanceEditPermission::where('user_id', \Auth::user()->id)->where('is_active',1)->count();

$data['totalFormPending'] = \App\FinanceEditPermission::where('user_id', \Auth::user()->id)->where(function ($query){
    	        $query->where('update_status','Pending')->orWhere('update_status','Processing');
    	    })->where('is_active',1)->count();

$data['totalFormRejected'] = \App\FinanceEditPermission::where('user_id', \Auth::user()->id)->where('update_status','Rejected')->where('is_active',1)->count();

$data['totalFormApproved'] = \App\FinanceEditPermission::where('user_id', \Auth::user()->id)->where('update_status','Approved')->where('is_active',1)->count();

}

return view('user.dashboard.dashboard', $data);
    }
}