000

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use DB;

use App\Http\Traits\GlobalTrait;

class AdminController extends Controller

{

use GlobalTrait;

public function __construct(){

\DB::statement("SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));");

}

public function index()

{

$data = array();

$data['page']='Dashboard';

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

$data['members'] = \App\MembershipDetail::where('is_active', 1)->orderBy('updated_at', 'desc')->get();

$data['users'] = \App\MembershipDetail::join('users', 'users.id', '=','membership_details.created_by_id')->select('users.name','created_by_id', DB::raw('count(created_by_id) as total'))->where('membership_details.is_active',1)->groupBy('created_by_id')->get();

$data['totalFormList'] = \App\MembershipDetail::where('is_active',1)->count();

$data['totalFormRejected'] = \App\MembershipDetail::where('final_approval_status','Rejected')->where('is_active',1)->count();

$data['totalFormApproved'] = \App\MembershipDetail::where('final_approval_status','Approved')->where('is_active',1)->count();

$data['totalFormPending'] = \App\MembershipDetail::where(function ($query) {

$query->where('final_approval_status', 'Requested')

->orWhereNull('final_approval_status');

})->where('is_active',1)->count();

// 	$data['mcc_wise_count'] = \App\MembershipDetail::select(\DB::raw('count(mcc_code) as member_count'),'mcc_name', 'mcc_code')->groupBy('mcc_code')->get();

$mcc_name = \App\MembershipDetail::select('mcc_name','mcc_code')->groupBy('mcc_code')->get();

$mcc_count = \App\MembershipDetail::select(\DB::raw('count(mcc_code) as member_count'))->groupBy('mcc_code')->get();

// $mccwise_count = \DB::table('membership_details')->select(\DB::raw('count(mcc_code) as member_count'), 'mcc_name', 'mcc_code')->groupBy('mcc_code')->get();

// dd($mcc_name);

if(!$mcc_name->isEmpty()) {

$a=array();

foreach($mcc_name as $key=>$value) {

// $data[$key]['mcc_name'] = $value->mcc_name;

// $data[$key]['mcc_code'] = $value->mcc_code;

// $data[$key]['member_count'] = $value->member_count;

array_push($a,$value['mcc_name'].'('.$value['mcc_code'].')');

$data['mcc_name'] = $a;

}

}else{
				$data['mcc_name']  = [''];
			}

if(!$mcc_count->isEmpty()) {

$b=array();

foreach($mcc_count as $key=>$value) {

// $data[$key]['mcc_name'] = $value->mcc_name;

// $data[$key]['mcc_code'] = $value->mcc_code;

// $data[$key]['member_count'] = $value->member_count;

array_push($b,$value['member_count']);

$data['mcc_count'] = $b;

}

}else{
				$data['mcc_count'] = [''];
			}

}else{

$data['totalFormList'] = '';

$data['members'] = array();

$data['users'] = array();

$data['totalAllottedForm'] = '';

$data['totalFormPending'] = '';

$data['totalFormRejected'] = '';

$data['totalFormApproved'] = '';

$data['mcc_name'] = [''];

$data['mcc_count'] = [''];

}

// 	dd($b);

return view('admin.index',$data);

}

public function getDashboardData(Request $request) {

$response = array();

$validator = \Validator::make($request->all(),

array(

'type'=> 'required'

)

);

if($validator->fails())

{

$response['flag'] = false;

$response['error'] = $validator->getMessageBag();

}else{

if($request->type == 'total_form') {

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

$data = \App\MembershipDetail::where('is_active',1)->get();

}

if(\Auth::user()->role_id == 2) {

$data = \App\UserEditPermission::join('membership_details as md', 'md.id', 'user_edit_permissions.form_id')->where('user_id', \Auth::user()->id)->where('is_active',1)->get();

}

} elseif($request->type == 'pnd_req_form') {

$data = \App\MembershipDetail::where('approval_status','Pending')->orWhere('approval_status','Processing')->orWhere('approval_status','Requested')->orWhere('final_approval_status','Requested')->where('is_active',1)->get();

} elseif($request->type == 'pnd_req_form') {

}

$response['user_role'] = \Auth::user()->role_id;

if(!$data->isEmpty()){

$response['flag'] = true;

$response['data'] = $data;

}else{

$response['flag'] = false;

$response['error'] = "No Data Found";

}

return response()->json($response);

}