000

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use DB;

class UserController extends Controller
{
    
    public function memberList() {
        
		$data['page'] = 'MembershipDetail';
		$data['members'] = array();

if(\Auth::user()->role_type == '1') {
            $data['main_title'] = 'Area Officer';
			$data['members'] = \App\UserEditPermission::select('user_edit_permissions.*','membership_details.*','membership_details.id as member_id')->join("membership_details","membership_details.id","user_edit_permissions.form_id")->where('user_id', \Auth::user()->id)->where('user_edit_permissions.is_active', 1)->get();
		} 
		
		//Legal Officer
		if(\Auth::user()->role_type == '2') {
            $data['main_title'] = 'Legal Officer';
			$data['members'] = \DB::table('legal_edit_permissions')->select('legal_edit_permissions.*','membership_details.*','membership_details.id as member_id')->join("membership_details","membership_details.id","legal_edit_permissions.form_id")->where('user_id', \Auth::user()->id)->where('legal_edit_permissions.is_active', 1)->get();								
		}

//Finance Officer
		if(\Auth::user()->role_type == '3') {
            $data['main_title'] = 'Finance Officer';
			$data['members'] = \App\FinanceEditPermission::select('finance_edit_permissions.*','membership_details.*','membership_details.id as member_id')->join("membership_details","membership_details.id","finance_edit_permissions.form_id")->where('user_id', \Auth::user()->id)->where('finance_edit_permissions.is_active', 1)->get();
		}

return view('user.member-list', $data);
	}
	
	public function approvedMemberList() {
        
		$data['page'] = 'MembershipDetail';
		$data['members'] = array();

if(\Auth::user()->role_type == '1') {
            $data['main_title'] = 'Area Officer';
			$data['members'] = \App\UserEditPermission::select('user_edit_permissions.*','membership_details.*','membership_details.id as member_id')->join("membership_details","membership_details.id","user_edit_permissions.form_id")->where('user_id', \Auth::user()->id)->where('user_edit_permissions.is_active', 1)->where('user_edit_permissions.update_status','Approved')->get();
		} 
		
		//Legal Officer
		if(\Auth::user()->role_type == '2') {
            $data['main_title'] = 'Legal Officer';
			$data['members'] = \DB::table('legal_edit_permissions')->select('legal_edit_permissions.*','membership_details.*','membership_details.id as member_id')->join("membership_details","membership_details.id","legal_edit_permissions.form_id")->where('user_id', \Auth::user()->id)->where('legal_edit_permissions.is_active', 1)->where('legal_edit_permissions.update_status','Approved')->get();								
		}

return view('user.member-list', $data);
	}	
	
	public function pendingMemberList(Request $request) {
        
		$data['page'] = 'MembershipDetail';
        $data['mcc'] = \DB::table('mcc')->where('mcc.is_active', 1)->get();
        // $data['mcc'] = \DB::table('users')->select('assigned_mcc')->where('id', \Auth::user()->id)->where('users.is_active', 1)->first();
		$data['mpps'] = \DB::table('mpp')->where('is_active', 1)->get();
		$data['members'] = array();

if(\Auth::user()->role_type == '1') {
            $data['main_title'] = 'Area Officer';
            $AreaNotAllotedForm = \App\MembershipDetail::select('id','mcc_code')->whereNull('ao_approval_status')->where('is_active',1)->get();
            if(count($AreaNotAllotedForm)>0){
		        foreach($AreaNotAllotedForm as $form){
		            $this->assignFormToAreaOfficer($form['id'],$form['mcc_code']);
		        }
		    }
			$data['members'] = \App\UserEditPermission::select('user_edit_permissions.*','membership_details.*','membership_details.id as member_id')->join("membership_details","membership_details.id","user_edit_permissions.form_id")->where('user_id', \Auth::user()->id)->where('user_edit_permissions.is_active', 1)->whereIn('user_edit_permissions.update_status', array('Pending','Processing'))->where('membership_details.resubmit_status', null)->get();
		} 
		
		//Legal Officer
		if(\Auth::user()->role_type == '2') {
            $data['main_title'] = 'Legal Officer';
            $LegalNotAllotedForm = \App\MembershipDetail::select('id','mcc_code')->where('ao_approval_status', 'Approved')->whereNull('lo_approval_status')->where('is_active',1)->get();
            if(count($LegalNotAllotedForm)>0){
		        foreach($LegalNotAllotedForm as $form){
		            $this->assignFormToLegalOfficer($form['id']);
		        }
		    }
			$data['members'] = \DB::table('legal_edit_permissions')->select('legal_edit_permissions.*','membership_details.*','membership_details.id as member_id')->join("membership_details","membership_details.id","legal_edit_permissions.form_id")->where('user_id', \Auth::user()->id)->where('legal_edit_permissions.is_active', 1)->whereIn('legal_edit_permissions.update_status', array('Pending','Processing'))->where('membership_details.resubmit_status', null)->get();								
		}

//Finance Officer
		if(\Auth::user()->role_type == '3') {
            $data['main_title'] = 'Finance Officer';
            $financeNotAllotedForm = \App\MembershipDetail::select('id','mcc_code')->where('lo_approval_status', 'Approved')->whereNull('fo_approval_status')->where('is_active',1)->get();
            if(count($financeNotAllotedForm)>0){
		        foreach($financeNotAllotedForm as $form){
		            $this->assignFormToFinanceOfficer($form['id'],$form['mcc_code']);
		        }
		    }
			$data['members'] = \App\FinanceEditPermission::select('finance_edit_permissions.*','membership_details.*','membership_details.id as member_id')->join("membership_details","membership_details.id","finance_edit_permissions.form_id")->where('user_id', \Auth::user()->id)->where('finance_edit_permissions.is_active', 1)->whereIn('finance_edit_permissions.update_status', array('Pending','Processing'))->where('membership_details.resubmit_status', null)->get();
		} 
		$data['old_value']=array();
	   	if ($request->isMethod('post')){
	   	   // dd($request->all());
            if(\Auth::user()->role_type == '1'){
                $data['main_title'] = 'Area Officer';
                $from = $request->from_date;
				$to = $request->to_date;
				$currentDate= date('Y-m-d');
				$query = \App\UserEditPermission::query();
				if(!empty($from) && !empty($to)){
            	$query->whereBetween(DB::raw('date(user_edit_permissions.created_at)'),[$from,$to]);
                }
                if(!empty($from) && empty($to)){
                	$query->whereBetween(DB::raw('date(user_edit_permissions.created_at)'),[$from,date('Y-m-d')]);
                }
                if(!empty($request->mcc_name)){
                	$query->where('membership_details.mcc_code',$request->mcc_name);
                }
                if(!empty($request->mpp_name)){
                	$query->where('membership_details.mpp_code',$request->mpp_name);
                }
			    $data['members'] = $query->select('user_edit_permissions.*','membership_details.*','membership_details.id as member_id')->join("membership_details","membership_details.id","user_edit_permissions.form_id")->where('user_id', \Auth::user()->id)->where('user_edit_permissions.is_active', 1)->whereIn('user_edit_permissions.update_status', array('Pending','Processing'))->where('membership_details.resubmit_status', null)->get();
        	
            }
            if(\Auth::user()->role_type == '2'){
                $data['main_title'] = 'Legal Officer';
                $from = $request->from_date;
				$to = $request->to_date;
				$currentDate= date('Y-m-d');
				$query = \DB::table('legal_edit_permissions')->query();
				if(!empty($from) && !empty($to)){
            	$query->whereBetween(DB::raw('date(legal_edit_permissions.created_at)'),[$from,$to]);
                }
                if(!empty($from) && empty($to)){
                	$query->whereBetween(DB::raw('date(legal_edit_permissions.created_at)'),[$from,date('Y-m-d')]);
                }
                if(!empty($request->mcc_name)){
                	$query->where('membership_details.mcc_code',$request->mcc_name);
                }
                if(!empty($request->mpp_name)){
                	$query->where('membership_details.mpp_code',$request->mpp_name);
                }
			    $data['members'] = $query->select('legal_edit_permissions.*','membership_details.*','membership_details.id as member_id')->join("membership_details","membership_details.id","legal_edit_permissions.form_id")->where('user_id', \Auth::user()->id)->where('legal_edit_permissions.is_active', 1)->whereIn('legal_edit_permissions.update_status', array('Pending','Processing'))->where('membership_details.resubmit_status', null)->get();
        	
            }
            if(\Auth::user()->role_type == '3'){
                $data['main_title'] = 'Finance Officer';
                $from = $request->from_date;
				$to = $request->to_date;
				$currentDate= date('Y-m-d');
				$query = \App\FinanceEditPermission::query();
				if(!empty($from) && !empty($to)){
            	$query->whereBetween(DB::raw('date(finance_edit_permissions.created_at)'),[$from,$to]);
                }
                if(!empty($from) && empty($to)){
                	$query->whereBetween(DB::raw('date(finance_edit_permissions.created_at)'),[$from,date('Y-m-d')]);
                }
                if(!empty($request->mcc_name)){
                	$query->where('membership_details.mcc_code',$request->mcc_name);
                }
                if(!empty($request->mpp_name)){
                	$query->where('membership_details.mpp_code',$request->mpp_name);
                }
			    $data['members'] = $query->select('finance_edit_permissions.*','membership_details.*','membership_details.id as member_id')->join("membership_details","membership_details.id","finance_edit_permissions.form_id")->where('user_id', \Auth::user()->id)->where('finance_edit_permissions.is_active', 1)->whereIn('finance_edit_permissions.update_status', array('Pending','Processing'))->where('membership_details.resubmit_status', null)->get();
            }
            $data['old_value']=\Request::all();
            $data['fromDate'] = $request->from_date;
    		$data['toDate'] = $request->to_date;
    		$data['mccCode'] = $request->mcc_name;
    		$data['mppCode'] = $request->mpp_name;
            // dd($data['old_value']);
	   	}
		return view('user.member-list', $data);
	}
	
	public function resubmittedMemberList() {
        
		$data['page'] = 'MembershipDetail';
		$data['members'] = array();

if(\Auth::user()->role_type == '1') {
            $data['main_title'] = 'Area Officer';
			$data['members'] = \App\UserEditPermission::select('user_edit_permissions.*','membership_details.*','membership_details.id as member_id')->join("membership_details","membership_details.id","user_edit_permissions.form_id")->where('user_id', \Auth::user()->id)->where('user_edit_permissions.is_active', 1)->whereIn('user_edit_permissions.update_status', array('Pending','Processing'))->where('membership_details.resubmit_status', 2)->get();
		} 
		
		//Legal Officer
		if(\Auth::user()->role_type == '2') {
            $data['main_title'] = 'Legal Officer';
			$data['members'] = \DB::table('legal_edit_permissions')->select('legal_edit_permissions.*','membership_details.*','membership_details.id as member_id')->join("membership_details","membership_details.id","legal_edit_permissions.form_id")->where('user_id', \Auth::user()->id)->where('legal_edit_permissions.is_active', 1)->whereIn('legal_edit_permissions.update_status', array('Pending','Processing'))->where('membership_details.resubmit_status', 2)->get();								
		}

return view('user.member-list', $data);
	}	
	
	public function rejectedMemberList() {
        
		$data['page'] = 'MembershipDetail';
		$data['members'] = array();

if(\Auth::user()->role_type == '1') {
            $data['main_title'] = 'Area Officer';
			$data['members'] = \App\UserEditPermission::select('user_edit_permissions.*','membership_details.*','membership_details.id as member_id')->join("membership_details","membership_details.id","user_edit_permissions.form_id")->where('user_id', \Auth::user()->id)->where('user_edit_permissions.is_active', 1)->where('user_edit_permissions.update_status','Rejected')->get();
		} 
		
		//Legal Officer
		if(\Auth::user()->role_type == '2') {
            $data['main_title'] = 'Legal Officer';
			$data['members'] = \DB::table('legal_edit_permissions')->select('legal_edit_permissions.*','membership_details.*','membership_details.id as member_id')->join("membership_details","membership_details.id","legal_edit_permissions.form_id")->where('user_id', \Auth::user()->id)->where('legal_edit_permissions.is_active', 1)->where('legal_edit_permissions.update_status','Rejected')->get();								
		}

return view('user.member-list', $data);
	}

public function viewMemberDetails($member_id) {

$data['page'] = 'View MembershipDetail';
		$data['id'] = $member_id;
		$data['members'] = \App\MembershipDetail::where('id', $member_id)->where('is_active', 1)->first();
		return view('user.view-member-details', $data);
    }

public function editMemberDetails($member_id)
	{
		$data['page'] = 'Edit MembershipDetail';
		$user_id = \Auth::user()->id;
        $data['user_id'] = \Auth::user()->id;
        $role_type = \Auth::user()->role_type;    	
        if(!is_null($role_type)) {
            $data['user_role_type'] = $role_type;
        } else {
            $data['user_role_type'] = 0;
        }
        
		$data['mcc'] = \DB::table('mcc')->where('is_active', 1)->get();

if(\Auth::user()->role_type == '1') {
            $data['main_title'] = 'Area Officer';

$member_data = \App\MembershipDetail::select('user_edit_permissions.*','membership_details.*','membership_details.id as member_id')->join("user_edit_permissions","user_edit_permissions.form_id","membership_details.id")->where('membership_details.id', $member_id)->where('user_edit_permissions.user_id', $user_id)->where('membership_details.is_active', 1)->first();

if(!is_null($member_data)) {
                $data['members'] = $member_data;
            }
		} 
		
		//Legal Officer
		if(\Auth::user()->role_type == '2') {
            $data['main_title'] = 'Legal Officer';

$member_data = \App\MembershipDetail::select('legal_edit_permissions.*','membership_details.*','membership_details.id as member_id')->join("legal_edit_permissions","legal_edit_permissions.form_id","membership_details.id")->where('membership_details.id', $member_id)->where('legal_edit_permissions.user_id', $user_id)->where('membership_details.is_active', 1)->first();			
            
            if(!is_null($member_data)) {
                $data['members'] = $member_data;                                        
            }
		}

//Finance Officer
		if(\Auth::user()->role_type == '3') {
            $data['main_title'] = 'Finance Officer';

$member_data = \App\MembershipDetail::select('finance_edit_permissions.*','membership_details.*','membership_details.id as member_id')->join("finance_edit_permissions","finance_edit_permissions.form_id","membership_details.id")->where('membership_details.id', $member_id)->where('finance_edit_permissions.user_id', $user_id)->where('membership_details.is_active', 1)->first();

if(!is_null($member_data)) {
                $data['members'] = $member_data;                                        
            }

} 
               
        $data['stepmodules'] = '';
		return view('user.edit-member-details', $data);
	}

public function updateMemberDetail(Request $request){
	  
		$response = array();
		$validator = \Validator::make($request->all(),
			array(
				'member_id' =>'required',
			)
		);
		if($validator->fails())
		{
			$response['flag'] = false;
			$response['errors'] = $validator->getMessageBag();
		}else{
            $model = '';
            if($request->user_role_type == 1) {
                $model = "\App\UserEditPermission";
            } elseif($request->user_role_type == 2) {
                $model = "\App\LegalEditPermission";
            } elseif($request->user_role_type == 3) {
                $model = "\App\FinanceEditPermission";
            }
          
            if($model != '') {
                $membershipDetail =  \App\MembershipDetail::where('id',$request->member_id)->where('is_active',1)->first();
    			if(is_null($membershipDetail)){
    				$response['flag'] = false;
    				$response['error'] = "Detail Not found";
    			}else{
    				// $membershipDetail->applicant_name = $request->applicant_name;
    				// $membershipDetail->husband_or_father = $request->husband_or_father;
    				// $membershipDetail->husband_or_father_name = $request->husband_or_father_name;
    				// $membershipDetail->dob = $request->dob;
    				// $membershipDetail->cast = $request->cast;
    				// $membershipDetail->education = $request->education;
    				if($membershipDetail->save()){
    				    
    				    $user_data = $model::where('form_id', $request->member_id)->where('user_id', $request->user_id)->first();
                       
    				    if($user_data != null) {
    				        if($user_data->update_status_details != null) {
    				            $arr = json_decode($user_data->update_status_details, true);
    				        } else {
    				            $arr = [];   
    				        }
    				        
    				        $arr[$request->stepmodule] = 1;
    				        $user_data->update_status_details = json_encode($arr);
    				        $user_data->save();
    				        
    				        $status = $this->checkUpdateStatus($user_data->module_id, $user_data->update_status_details);
    				        $user_data->update_status = $status;
    				        $user_data->save();    								
    				        
    				        if($request->user_role_type == 1) {
                                $model = "\App\UserEditPermission";
                                $approval_status = $this->checkApprovalStatus($request->member_id, $model);
                                $membershipDetail->ao_approval_status = $approval_status;
                                $membershipDetail->save();
                            
                                if($approval_status == 'Approved') {
                                   // $this->assignFormToLegalOfficer($request->member_id);
									$this->assignFormToFinanceOfficer($request->member_id,$membershipDetail->mcc_code);
                                }
                            } elseif($request->user_role_type == 2) {
                                $model = "\App\LegalEditPermission";
                                $approval_status = $this->checkApprovalStatus($request->member_id, $model);
                                $membershipDetail->lo_approval_status = $approval_status;
                                $membershipDetail->save();
                                
                                if($approval_status == 'Approved') {
                                    $this->assignFormToFinanceOfficer($request->member_id,$membershipDetail->mcc_code);
                                }
                            
                            } elseif($request->user_role_type == 3) {
                                $model = "\App\FinanceEditPermission";
                                $approval_status = $this->checkApprovalStatus($request->member_id, $model);
                                $membershipDetail->fo_approval_status = $approval_status;
                                $membershipDetail->save();
                                
                                if($approval_status == 'Approved') {
                                    $membershipDetail->final_approval_status = 'Requested';
                                    $membershipDetail->save();
                                }
                            }
    				        
    				        $response['flag'] = true;
    					    $response['message'] = "Updated Successfully";        
    				    } else {
    				        $response['flag'] = false;
    					    $response['message'] = "User Permissions Details Not Found.";        
    				    }
    				    
    				}else{
    					$response['flag'] = false;
    					$response['error'] = "Something Went Wrong";
    				}
    			}
            } else {
                $response['flag'] = false;
    		    $response['error'] = "Something Went Wrong";
            }			
		}
		return response()->json($response);
	}

public function updateACDetails(Request $request) {
	    
	    $response = array();
		$validator = \Validator::make($request->all(),
			array(
				'member_id' =>'required',
			)
		);
		if($validator->fails())
		{
			$response['flag'] = false;
			$response['errors'] = $validator->getMessageBag();
		}else{

if($model != '') {
                $membershipDetail =  \App\MembershipDetail::where('id',$request->member_id)->where('is_active',1)->first();
    			if(is_null($membershipDetail)){
    				$response['flag'] = false;
    				$response['error'] = "Detail Not found";
    			}else{
    				// $membershipDetail->house_no = $request->house_no;
    				// $membershipDetail->helmet = $request->helmet;
    				// $membershipDetail->village = $request->village;
    				// $membershipDetail->post_office = $request->post_office;
    				// $membershipDetail->tehsil = $request->tehsil;
    				// $membershipDetail->district = $request->district;
    				// $membershipDetail->state = $request->state;
    				// $membershipDetail->pincode = $request->pincode;
    				// $membershipDetail->mobile_no = $request->mobile_no;
    				// $membershipDetail->landline = $request->landline;
    				if($membershipDetail->save()){
    				    
    				    $user_data = $model::where('form_id', $request->member_id)->where('user_id', $request->user_id)->first();
    				    
    				    $arr = array();
    				    if($user_data != null) {
    				        if($user_data->update_status_details != null) {
    				            $arr = json_decode($user_data->update_status_details, true);
    				        }
    				        
    				        $arr[$request->stepmodule] = 1;
    				        $user_data->update_status_details = json_encode($arr);
    				        $user_data->save();
    				        
    				        $status = $this->checkUpdateStatus($user_data->module_id, $user_data->update_status_details);
    				        $user_data->update_status = $status;
    				        $user_data->save();
    				        
    				        if($request->user_role_type == 1) {
                                $model = "\App\UserEditPermission";
                                $approval_status = $this->checkApprovalStatus($request->member_id, $model);
                                $membershipDetail->ao_approval_status = $approval_status;
                                $membershipDetail->save();
                                
                                if($approval_status == 'Approved') {
                                    // $this->assignFormToLegalOfficer($request->member_id);
									$this->assignFormToFinanceOfficer($request->member_id,$membershipDetail->mcc_code);
                                }
                            
                            } elseif($request->user_role_type == 2) {
                                $model = "\App\LegalEditPermission";
                                $approval_status = $this->checkApprovalStatus($request->member_id, $model);
                                $membershipDetail->lo_approval_status = $approval_status;
                                $membershipDetail->save();
                                
                                if($approval_status == 'Approved') {
                                    $this->assignFormToFinanceOfficer($request->member_id,$membershipDetail->mcc_code);
                                }
                            
                            } elseif($request->user_role_type == 3) {
                                $model = "\App\FinanceEditPermission";
                                $approval_status = $this->checkApprovalStatus($request->member_id, $model);
                                $membershipDetail->fo_approval_status = $approval_status;
                                $membershipDetail->save();
                                
                                if($approval_status == 'Approved') {
                                    $membershipDetail->final_approval_status = 'Requested';
                                    $membershipDetail->save();
                                }
                            }
    				        
    				        $response['flag'] = true;
    					    $response['message'] = "Updated Successfully";
    				    } else {
    				        $response['flag'] = false;
    					    $response['message'] = "User Permission Details Not Found.";    
    				    }
    				    
    				}else{
    					$response['flag'] = false;
    					$response['error'] = "Something Went Wrong";
    				}
    			}
            } else {
                $response['flag'] = false;
    			$response['error'] = "Something Went Wrong";
            }			
		}
		return response()->json($response);
	}

public function updateMPCDetails(Request $request) {
	    
	    $response = array();
		$validator = \Validator::make($request->all(),
			array(
				'member_id' =>'required',
			)
		);
		if($validator->fails())
		{
			$response['flag'] = false;
			$response['errors'] = $validator->getMessageBag();
		}else{

} elseif($request->user_role_type == 3) {
                                $model = "\App\FinanceEditPermission";
                                $approval_status = $this->checkApprovalStatus($request->member_id, $model);
                                $membershipDetail->fo_approval_status = $approval_status;
                                $membershipDetail->save();
                                
                                if($approval_status == 'Approved') {
                                    $membershipDetail->final_approval_status = 'Requested';
                                    $membershipDetail->save();
                                }
                            }
    				        
    				        $response['flag'] = true;
    					    $response['message'] = "Updated Successfully";
    				    } else {
    				        $response['flag'] = false;
    					    $response['message'] = "User Permission Details Not Found.";    
    				    }
    				}else{
    					$response['flag'] = false;
    					$response['error'] = "Something Went Wrong";
    				}
    			}
            } else {
                $response['flag'] = false;
    			$response['error'] = "Something Went Wrong";
            }			
		}
		return response()->json($response);
	}

public function updateSBADetails(Request $request) {
    	
	    $response = array();
		$validator = \Validator::make($request->all(),
			array(
				'member_id' =>'required',
			)
		);
		if($validator->fails())
		{
			$response['flag'] = false;
			$response['errors'] = $validator->getMessageBag();
		}else{

if($model != '') {
                $membershipDetail =  \App\MembershipDetail::where('id',$request->member_id)->where('is_active',1)->first();
    			if(is_null($membershipDetail)){
    				$response['flag'] = false;
    				$response['error'] = "Detail Not found";
    			}else{
    				// $membershipDetail->account_holder_name = $request->account_holder_name;
    				// $membershipDetail->s_account_number = $request->s_account_number;
    				// $membershipDetail->ifsc_code = $request->ifsc_code;
    				// $membershipDetail->bank_name = $request->bank_name;
    				// $membershipDetail->branch_name = $request->branch_name;
    				
    				if($membershipDetail->save()){
    				    
    				    $user_data = $model::where('form_id', $request->member_id)->where('user_id', $request->user_id)->first();
    				    
    				    $arr = array();
    				    if($user_data != null) {
    				        if($user_data->update_status_details != null) {
    				            $arr = json_decode($user_data->update_status_details, true);
    				        }
    				        
    				        $arr[$request->stepmodule] = 1;
    				        $user_data->update_status_details = json_encode($arr);
    				        $user_data->save();
    				        
    				        $status = $this->checkUpdateStatus($user_data->module_id, $user_data->update_status_details);
    				        $user_data->update_status = $status;
    				        $user_data->save();
    				        
    				        if($request->user_role_type == 1) {
                                $model = "\App\UserEditPermission";
                                $approval_status = $this->checkApprovalStatus($request->member_id, $model);
                                $membershipDetail->ao_approval_status = $approval_status;
                                $membershipDetail->save();
                            
                                if($approval_status == 'Approved') {
                                  //  $this->assignFormToLegalOfficer($request->member_id);
									$this->assignFormToFinanceOfficer($request->member_id,$membershipDetail->mcc_code);
                                }
                                
                            } elseif($request->user_role_type == 2) {
                                $model = "\App\LegalEditPermission";
                                $approval_status = $this->checkApprovalStatus($request->member_id, $model);
                                $membershipDetail->lo_approval_status = $approval_status;
                                $membershipDetail->save();
                            
                                if($approval_status == 'Approved') {
                                    $this->assignFormToFinanceOfficer($request->member_id,$membershipDetail->mcc_code);
                                }
                            } elseif($request->user_role_type == 3) {
                                $model = "\App\FinanceEditPermission";
                                $approval_status = $this->checkApprovalStatus($request->member_id, $model);
                                $membershipDetail->fo_approval_status = $approval_status;
                                $membershipDetail->save();
                                
                                if($approval_status == 'Approved') {
                                    $membershipDetail->final_approval_status = 'Requested';
                                    $membershipDetail->save();
                                }
                            }

$response['flag'] = true;
    					    $response['message'] = "Updated Successfully";
    				    } else {
    				        $response['flag'] = false;
    					    $response['message'] = "User Persmission Details Not Found.";
    				    }
    				}else{
    					$response['flag'] = false;
    					$response['error'] = "Something Went Wrong";
    				}
    			}
            } else {
                $response['flag'] = false;
    			$response['error'] = "Something Went Wrong";
            }			
		}
		return response()->json($response);
	}

public function updatePOMHHMLWNDetails(Request $request) {
    
	    $response = array();
		$validator = \Validator::make($request->all(),
			array(
				'member_id' =>'required',
			)
		);
		if($validator->fails())
		{
			$response['flag'] = false;
			$response['errors'] = $validator->getMessageBag();
		}else{

if($model != '') {
                $membershipDetail =  \App\MembershipDetail::where('id',$request->member_id)->where('is_active',1)->first();
    			if(is_null($membershipDetail)){
    				$response['flag'] = false;
    				$response['error'] = "Detail Not found";
    			}else{
    			    $data1 = $request->relation11.','.$request->relation12.','.$request->relation13.','.$request->relation14;
    			    
    			    $data2 = $request->relation21.','.$request->relation22.','.$request->relation23.','.$request->relation24;
    			    
    			    $data3 = $request->relation31.','.$request->relation32.','.$request->relation33.','.$request->relation34;
    			    
    			    $data4 = $request->relation41.','.$request->relation42.','.$request->relation43.','.$request->relation44;
    			    
    			    $data5 = $request->relation51.','.$request->relation52.','.$request->relation53.','.$request->relation54;
    			    
    			    $data6 = $request->relation61.','.$request->relation62.','.$request->relation63.','.$request->relation64;
    			    
    				// $membershipDetail->relation1 = $data1;
    				// $membershipDetail->relation2 = $data2;
    				// $membershipDetail->relation3 = $data3;
    				// $membershipDetail->relation4 = $data4;
    				// $membershipDetail->relation5 = $data5;
    				// $membershipDetail->relation6 = $data6;
    			
    				if($membershipDetail->save()){
    				    
    				    $user_data = $model::where('form_id', $request->member_id)->where('user_id', $request->user_id)->first();
    				    
    				    $arr = array();
    				    if($user_data != null) {
    				        if($user_data->update_status_details != null) {
    				            $arr = json_decode($user_data->update_status_details, true);
    				        }
    				        
    				        $arr[$request->stepmodule] = 1;
    				        $user_data->update_status_details = json_encode($arr);
    				        $user_data->save();
    				        
    				        $status = $this->checkUpdateStatus($user_data->module_id, $user_data->update_status_details);
    				        $user_data->update_status = $status;
    				        $user_data->save();
    				        
    				        if($request->user_role_type == 1) {
                                $model = "\App\UserEditPermission";
                                $approval_status = $this->checkApprovalStatus($request->member_id, $model);
                                $membershipDetail->ao_approval_status = $approval_status;
                                $membershipDetail->save();
                                                            
                                if($approval_status == 'Approved') {
                                  //  $this->assignFormToLegalOfficer($request->member_id);
									$this->assignFormToFinanceOfficer($request->member_id,$membershipDetail->mcc_code);
                                }
                                
                            } elseif($request->user_role_type == 2) {
                                $model = "\App\LegalEditPermission";
                                $approval_status = $this->checkApprovalStatus($request->member_id, $model);
                                $membershipDetail->lo_approval_status = $approval_status;
                                $membershipDetail->save();

if($approval_status == 'Approved') {
                                    $this->assignFormToFinanceOfficer($request->member_id,$membershipDetail->mcc_code);
                                }
                            } elseif($request->user_role_type == 3) {
                                $model = "\App\FinanceEditPermission";
                                $approval_status = $this->checkApprovalStatus($request->member_id, $model);
                                $membershipDetail->fo_approval_status = $approval_status;
                                $membershipDetail->save();
                                
                                if($approval_status == 'Approved') {
                                    $membershipDetail->final_approval_status = 'Requested';
                                    $membershipDetail->save();
                                }
                            }
    				    
    				        $response['flag'] = true;
    					    $response['message'] = "Updated Successfully";
    				    } else {
    				        $response['flag'] = false;
    					    $response['message'] = "User Persmission Details Not Found.";
    				    }
    				    
    				}else{
    					$response['flag'] = false;
    					$response['error'] = "Something Went Wrong";
    				}
    			}
            } else {
                $response['flag'] = false;
    			$response['error'] = "Something Went Wrong";
            }			
		}
		return response()->json($response);
	}

public function updateNNDetails(Request $request) {
	    
	    $response = array();
		$validator = \Validator::make($request->all(),
			array(
				'member_id' =>'required',
			)
		);
		if($validator->fails())
		{
			$response['flag'] = false;
			$response['errors'] = $validator->getMessageBag();
		}else{

if($model != '') {
                $membershipDetail =  \App\MembershipDetail::where('id',$request->member_id)->where('is_active',1)->first();
    			if(is_null($membershipDetail)){
    				$response['flag'] = false;
    				$response['error'] = "Detail Not found";
    			}else{
    				// $membershipDetail->nominee_name = $request->nominee_name;
    				// $membershipDetail->relation_with_application = $request->relation_with_application;
    				// $membershipDetail->guardian_name = $request->guardian_name;
    				// $membershipDetail->age = $request->age;
    				// $membershipDetail->address = $request->address;
    			
    				if($membershipDetail->save()){
    				    
    				    $user_data = $model::where('form_id', $request->member_id)->where('user_id', $request->user_id)->first();
    				    
    				    $arr = array();
    				    if($user_data != null) {
    				        if($user_data->update_status_details != null) {
    				            $arr = json_decode($user_data->update_status_details, true);
    				        }
    				        
    				        $arr[$request->stepmodule] = 1;
    				        $user_data->update_status_details = json_encode($arr);
    				        $user_data->save();
    				        
    				        $status = $this->checkUpdateStatus($user_data->module_id, $user_data->update_status_details);
    				        $user_data->update_status = $status;
    				        $user_data->save();
    				        
    				        if($request->user_role_type == 1) {
                                $model = "\App\UserEditPermission";
                                $approval_status = $this->checkApprovalStatus($request->member_id, $model);
                                $membershipDetail->ao_approval_status = $approval_status;
                                $membershipDetail->save();
                            
                                if($approval_status == 'Approved') {
                                   // $this->assignFormToLegalOfficer($request->member_id);
									$this->assignFormToFinanceOfficer($request->member_id,$membershipDetail->mcc_code);
                                }
                                
                            } elseif($request->user_role_type == 2) {
                                $model = "\App\LegalEditPermission";
                                $approval_status = $this->checkApprovalStatus($request->member_id, $model);
                                $membershipDetail->lo_approval_status = $approval_status;
                                $membershipDetail->save();
                            
                                if($approval_status == 'Approved') {
                                    $this->assignFormToFinanceOfficer($request->member_id,$membershipDetail->mcc_code);
                                }
                            } elseif($request->user_role_type == 3) {
                                $model = "\App\FinanceEditPermission";
                                $approval_status = $this->checkApprovalStatus($request->member_id, $model);
                                $membershipDetail->fo_approval_status = $approval_status;
                                $membershipDetail->save();
                                
                                if($approval_status == 'Approved') {
                                    $membershipDetail->final_approval_status = 'Requested';
                                    $membershipDetail->save();
                                }
                            }
    				        
    				        $response['flag'] = true;
    					    $response['message'] = "Updated Successfully";
    				    } else {
    				        $response['flag'] = false;
    					    $response['message'] = "User Persmission Details Not Found.";
    				    }
    				}else{
    					$response['flag'] = false;
    					$response['error'] = "Something Went Wrong";
    				}
    			}                    
            } else {
                $response['flag'] = false;
    			$response['error'] = "Something Went Wrong";
            }			
		}
		return response()->json($response);
	}

public function updateVDetails(Request $request) {

$response = array();
		$validator = \Validator::make($request->all(),
			array(
				'member_id' =>'required',
			)
		);
		if($validator->fails())
		{
			$response['flag'] = false;
			$response['errors'] = $validator->getMessageBag();
		}else{

if($model != '') {
                $membershipDetail =  \App\MembershipDetail::where('id',$request->member_id)->where('is_active',1)->first();
    			if(is_null($membershipDetail)){
    				$response['flag'] = false;
    				$response['error'] = "Detail Not found";
    			}else{
    				// $membershipDetail->milk_producer_name = $request->milk_producer_name;
    				// $membershipDetail->mcc_name = $request->mcc_name;
    				// $membershipDetail->mcc_code = $request->mcc_code;
    				// $membershipDetail->mpp_name = $request->mpp_name;
    				// $membershipDetail->mpp_code = $request->mpp_code;
    				
    				// $membershipDetail->revanue_vill_name = $request->revanue_vill_name;
    				// $membershipDetail->revanue_vill_code = $request->revanue_vill_code;
    				// $membershipDetail->tehsil_name = $request->tehsil_name;
    				// $membershipDetail->district_name = $request->district_name;
    				// $membershipDetail->pooling_point_code = $request->pooling_point_code;
    			
    				if($membershipDetail->save()){
    				    
    				    $user_data = $model::where('form_id', $request->member_id)->where('user_id', $request->user_id)->first();
    				    
    				    $arr = array();
    				    if($user_data != null) {
    				        if($user_data->update_status_details != null) {
    				            $arr = json_decode($user_data->update_status_details, true);
    				        }
    				        
    				        $arr[$request->stepmodule] = 1;
    				        $user_data->update_status_details = json_encode($arr);
    				        $user_data->save();
    				        
    				        $status = $this->checkUpdateStatus($user_data->module_id, $user_data->update_status_details);
    				        $user_data->update_status = $status;
    				        $user_data->save();
    				        
    				        if($request->user_role_type == 1) {
                                $model = "\App\UserEditPermission";
                                $approval_status = $this->checkApprovalStatus($request->member_id, $model);
                                $membershipDetail->ao_approval_status = $approval_status;
                                $membershipDetail->save();
                            
                                if($approval_status == 'Approved') {
                                   //  $this->assignFormToLegalOfficer($request->member_id);
									 $this->assignFormToFinanceOfficer($request->member_id,$membershipDetail->mcc_code);
                                }
                            } elseif($request->user_role_type == 2) {
                                $model = "\App\LegalEditPermission";
                                $approval_status = $this->checkApprovalStatus($request->member_id, $model);
                                $membershipDetail->lo_approval_status = $approval_status;
                                $membershipDetail->save();
                            
                                if($approval_status == 'Approved') {
                                    $this->assignFormToFinanceOfficer($request->member_id,$membershipDetail->mcc_code);
                                }
                            } elseif($request->user_role_type == 3) {
                                $model = "\App\FinanceEditPermission";
                                $approval_status = $this->checkApprovalStatus($request->member_id, $model);
                                $membershipDetail->fo_approval_status = $approval_status;
                                $membershipDetail->save();
                                
                                if($approval_status == 'Approved') {
                                   $membershipDetail->final_approval_status = 'Requested';
                                    $membershipDetail->save();
                                }
                            }
    				        
    				        $response['flag'] = true;
    					    $response['message'] = "Updated Successfully";
    				    } else {
    				        $response['flag'] = false;
    					    $response['message'] = "User Persmission Details Not Found.";
    				    }
    				}else{
    					$response['flag'] = false;
    					$response['error'] = "Something Went Wrong";
    				}
    			}
            } else {
                $response['flag'] = false;
    			$response['error'] = "Something Went Wrong";
            }			
		}
		return response()->json($response);
	}

public function updateMFDetails(Request $request) {
    	
	    $response = array();
		$validator = \Validator::make($request->all(),
			array(
				'member_id' =>'required',
			)
		);
		if($validator->fails())
		{
			$response['flag'] = false;
			$response['errors'] = $validator->getMessageBag();
		}else{

$model = '';
            if($request->user_role_type == 1) {
                $model = "\App\UserEditPermission";
            } elseif($request->user_role_type == 2) {
                $model = "\App\LegalEditPermission";
            } elseif($request->user_role_type == 3) {
                $model = "\App\FinanceEditPermission";
            }
            
            if($model != '') {
                $membershipDetail =  \App\MembershipDetail::where('id',$request->member_id)->where('is_active',1)->first();
    			if(is_null($membershipDetail)){
    				$response['flag'] = false;
    				$response['error'] = "Detail Not found";
    			}else{
    				// $membershipDetail->admission_fee = $request->admission_fee;
    				// $membershipDetail->share_quantity = $request->share_quantity;
    				// $membershipDetail->received_amount = $request->received_amount;
    				// $membershipDetail->cash_dd = $request->cash_dd;
    				// $membershipDetail->fee_bank_name = $request->fee_bank_name;
    				// $membershipDetail->fee_branch_name = $request->fee_branch_name;
    				// $membershipDetail->fee_receipt_no = $request->fee_receipt_no;
    				// $membershipDetail->fee_receipt_date = $request->fee_receipt_date;
    				// $membershipDetail->amount = $request->amount;
    				// $membershipDetail->shg_member = $request->shg_member;
    			
    				if($membershipDetail->save()){
    				    
    				    $user_data = $model::where('form_id', $request->member_id)->where('user_id', $request->user_id)->first();
    				    
    				    $arr = array();
    				    if($user_data != null) {
    				        if($user_data->update_status_details != null) {
    				            $arr = json_decode($user_data->update_status_details, true);
    				        }
    				        
    				        $arr[$request->stepmodule] = 1;
    				        $user_data->update_status_details = json_encode($arr);
    				        $user_data->save();
    				        
    				        $status = $this->checkUpdateStatus($user_data->module_id, $user_data->update_status_details);
    				        $user_data->update_status = $status;
    				        $user_data->save();												        
    				            				        
                            if($request->user_role_type == 1) {
                                $model = "\App\UserEditPermission";
                                $approval_status = $this->checkApprovalStatus($request->member_id, $model);
                                $membershipDetail->ao_approval_status = $approval_status;
                                $membershipDetail->save();
                            
                                if($approval_status == 'Approved') {
                                  //  $this->assignFormToLegalOfficer($request->member_id);
									$this->assignFormToFinanceOfficer($request->member_id,$membershipDetail->mcc_code);
                                }
                            // } elseif($request->user_role_type == 2) {
                            //     $model = "\App\LegalEditPermission";
                            //     $approval_status = $this->checkApprovalStatus($request->member_id, $model);
                            //     $membershipDetail->lo_approval_status = $approval_status;
                            //     $membershipDetail->save();
                                
                            //     if($approval_status == 'Approved') {
                            //         $this->assignFormToFinanceOfficer($request->member_id,$membershipDetail->mcc_code);
                            //     }
                            } elseif($request->user_role_type == 3) {
                                $model = "\App\FinanceEditPermission";
                                $approval_status = $this->checkApprovalStatus($request->member_id, $model);
                                $membershipDetail->fo_approval_status = $approval_status;
                                $membershipDetail->save();
                                
                                if($approval_status == 'Approved') {
                                    $membershipDetail->final_approval_status = 'Requested';
                                    $membershipDetail->save();
                                }
                            }
    				        
    				        $response['flag'] = true;
    					    $response['message'] = "Updated Successfully";
    				    } else {
    				        $response['flag'] = false;
    					    $response['message'] = "User Persmission Details Not Found.";
    				    }
    				   
    				}else{
    					$response['flag'] = false;
    					$response['error'] = "Something Went Wrong";
    				}
    			}
            } else {
                $response['flag'] = false;
    			$response['error'] = "You are not allowed to update data.";
            }			
		}
		return response()->json($response);
	}
	
	
	public function rejectFormByUser(Request $request) {
	   // dd($request->all());
	    $response = array();
		$validator = \Validator::make($request->all(),
			array(
				'member_id' =>'required',
				'user_id' => 'required',
				'module_id' => 'required',
				'remark' => 'required|regex:/^[\pL\s]+$/u|min:3',
			)
		);
		if($validator->fails())
		{
			$response['flag'] = false;
			$response['errors'] = $validator->getMessageBag();
		}else{
			$membershipDetail =  \App\MembershipDetail::where('id',$request->member_id)->where('is_active',1)->first();
			if(is_null($membershipDetail)){
				$response['flag'] = false;
				$response['error'] = "Member Details Not found";
			}else{
			    
			    $user = \App\User::where('id', $request->user_id)->first();
			    
    			$model = '';
                if($user->role_type == 1) {
                    $model = "\App\UserEditPermission";
                } elseif($user->role_type == 2) {
                    $model = "\App\LegalEditPermission";
                } elseif($user->role_type == 3) {
                    $model = "\App\FinanceEditPermission";
                }
                
                if($model != '') {
                    $user_data = $model::where('form_id', $request->member_id)->where('user_id', $request->user_id)->first();
    			    if($user_data != null) {
    			        
    			        try{
    			            
    			            \DB::beginTransaction();
    			            
    			                
    			            if($user_data->update_status_details != null) {
        			          $arr = json_decode($user_data->update_status_details, true);
        			        } else {
        			          $arr = [];   
        			        }
        			        
        			        $arr[$request->module_id] = 0;
        			        $user_data->update_status = 'Rejected';
        			        $user_data->update_status_details = json_encode($arr);
        			        $user_data->save();
        			        
        			        $approval_status = $this->checkApprovalStatus($request->member_id, $model);
        			        if($approval_status == 'Rejected') {
        			            $membershipDetail->final_approval_status = $approval_status;
        			        }
        			     
        			        $finalArr = array();
        			        $remarkArr[$request->user_id.':'.$request->module_id] = $request->remark;
        			       
        			        if(!is_null($membershipDetail->remark )) {
            			         $finalArr = json_decode($membershipDetail->remark, true);
            			         array_push($finalArr, $remarkArr);
        			        
        			            $membershipDetail->remark = json_encode($finalArr);
        			        } else {
        			            array_push($finalArr, $remarkArr);
        			            $membershipDetail->remark = json_encode($finalArr);
        			        }
        			        
        			        if($user->role_type == 1) {
        			            $membershipDetail->ao_approval_status = $approval_status;    
        			            $membershipDetail->save();
        			        } elseif($user->role_type == 2) {
        			            $membershipDetail->lo_approval_status = $approval_status;    
        			            $membershipDetail->save();
        			        } elseif($user->role_type == 3) {
        			            $membershipDetail->fo_approval_status = $approval_status;    
        			            $membershipDetail->save();
        			        }
        			        
    			            \DB::commit();
    			            
    			            $response['flag'] = true;
        				    $response['message'] = "Rejected Successfully";
    			            
    			        } catch(\Exception $e) {
    			            \DB::rollback();
    			            
    			            $response['flag'] = false;
        				    $response['message'] = "Something went wrong.";
        				    
        				    logger("member id is :".$request->member_id.' --Exception message-- '.$e->getMessage());
    			                
    			        }
    			    } else {
    			        $response['flag'] = true;
    				    $response['message'] = "User Permission Details Not Found.";
    			    }   
                } else {
                    $response['flag'] = true;
    				$response['message'] = "You are not allowed to update data.";
                }
			}
		}
		return response()->json($response);
	}

//legal officer approval entry
	public function assignFormToLegalOfficer($form_id) {

$user = \App\User::where('is_active', 1)->where('role_type', 2)->first();
		if(!is_null($user)) {
		    
		    $form_data = \DB::table('legal_edit_permissions')->where('form_id', $form_id)->first();
		    
		    if(is_null($form_data)) {
		        \DB::table('legal_edit_permissions')->insert([
    				'form_id' => $form_id,
    				'module_id' => $user->assigned_sections,
    				'user_id' => $user->id,
    				'update_status' => 'Pending',						
    			]);	
    			
    			$membership = \App\MembershipDetail::where('id', $form_id)->first();
    			$membership->lo_approval_status = 'Pending';
    			$membership->save();   
		    } else {
		        logger($form_id." already alotted, Can't assign again.");
		    }
		} else {
		    logger($form_id." can't be assigned beacause finance officer not found in database.");
		}		
	}

//finance officer approval entry
// 	public function assignFormToFinanceOfficer($form_id) {

// 		$user = \App\User::where('is_active', 1)->where('role_type', 3)->first();
// 		if(!is_null($user)) {	
		    
// 		    $form_data = \DB::table('finance_edit_permissions')->where('form_id', $form_id)->first();
		    
// 		    if(is_null($form_data)) {
// 		        \DB::table('finance_edit_permissions')->insert([
//     				'form_id' => $form_id,
//     				'module_id' => $user->assigned_sections,
//     				'user_id' => $user->id,
//     				'update_status' => 'Pending',						
//     			]);
    			
//     			$membership = \App\MembershipDetail::where('id', $form_id)->first();
//     			$membership->fo_approval_status = 'Pending';
//     			$membership->save();    
// 		    } else {
// 		        logger($form_id." already allotted , can't assign again.");
// 		    }
			
// 		} else {
// 		    logger($form_id." can't be assigned beacause finance officer not found in database.");
// 		}		
// 	}
	
	public function assignFormToFinanceOfficer($form_id,$mcc_code) {

$users_data = \App\User::where('is_active', 1)->where('role_type', 3)->get();
		
		if(!$users_data->isEmpty()) {
            $mcc_user_id = '';
            $assigned_sections = '';
            foreach ($users_data as $key => $user) {
                $mcc = explode(',', $user->assigned_mcc);
                if(in_array($mcc_code, $mcc)){
                    $mcc_user_id = $user->id;
                    // dd($mcc_user_id);
                    $assigned_sections = $user->assigned_sections;
                }
            }
            
            if($mcc_user_id != '') {
		    
		    $form_data = \DB::table('finance_edit_permissions')->where('form_id', $form_id)->first();
		    
		    if(is_null($form_data)) {
		        
		        \DB::table('finance_edit_permissions')->insert([
    				'form_id' => $form_id,
    				'module_id' => $assigned_sections,
    				'user_id' => $mcc_user_id,
    				'update_status' => 'Pending',						
    			]);	
    			
    			$membership = \App\MembershipDetail::where('id', $form_id)->first();
    			$membership->fo_approval_status = 'Pending';
    			$membership->save();   
		    } else {
		        logger($form_id." already alotted, Can't assign again.");
		    }
		  }
		} else {
		    logger($form_id." can't be assigned beacause finance officer not found in database.");
		}		
	}
	
	public function assignFormToAreaOfficer($form_id, $mcc_code) {
        
        $response = [];
        $sections_id = \DB::table('form_sections')->pluck('id');
        $sections_id = $sections_id->toArray();
        if(count($sections_id)) {
            $sections_id = implode(',', $sections_id);
        } else {
            $sections_id = '';
        }
        
        $users_data = \App\User::select('id','assigned_mcc')->where('is_active', 1)->where('role_type', 1)->get();
        
        if(!$users_data->isEmpty()) {
            $mcc_user_id = '';
            foreach ($users_data as $key => $user) {
                $mcc = explode(',', $user->assigned_mcc);
                if(in_array($mcc_code, $mcc)){
                    $mcc_user_id = $user->id;
                }
            }
            
            if($mcc_user_id != '') {

try{
                    \DB::beginTransaction();

$user_edit = new \App\UserEditPermission();
                    $user_edit->form_id = $form_id;
                    $user_edit->module_id = $sections_id;
                    $user_edit->user_id = $mcc_user_id;
                    $user_edit->update_status = 'Pending';
                    $user_edit->save();
                    
                    $member_data = \App\MembershipDetail::where('id', $form_id)->first();
                    if(!is_null($member_data)) {
                        $member_data->ao_approval_status = 'Pending';
                        $member_data->save();   
                    }

\DB::commit();     
                    $response['msg'] = 'saved successfully.';
                } catch(\Exception $exp) {
                    \DB::rollback();
                    
                    $response['error'] = $exp->getMessage();
                }

return true;
            }                             
        } 
        
        return false;
    }

public function checkUpdateStatus($module_id, $update_status_details) {
	    
	    if($update_status_details != null) {
            $update_arr = json_decode($update_status_details, true);   
            if(in_array(0, $update_arr)) {
                return 'Rejected';
            } else {
                $update_count = array_sum($update_arr);
                $module = explode(',', $module_id);
                $module_count = count($module);   
                
                if($update_count == $module_count) {
                    return 'Approved';
                } else {
                    return 'Processing';
                }
            }
        } else {
            return 'Pending';
        } 
	}

public function checkApprovalStatus($form_id, $model) {
        $data = $model::where('form_id', $form_id)->pluck('update_status');
       
        $data = $data->toArray();       
        
        if(in_array('Processing', $data)) {
            $status = 'Processing';
        } else if(in_array('Pending', $data) && in_array('Approved', $data)) {
            $status = 'Processing';
        } else if(in_array('Pending', $data)){
            $status = 'Pending';
        } else if(in_array('Rejected', $data)) {
            $status = 'Rejected';
        } else if(in_array('Approved', $data)){
            $status = 'Approved';
        }            
        
        return $status;
    }

}