000

<?php

namespace App\Http\Controllers;
use Illuminate\Support\Facades\View;
use Illuminate\support\Facades\DB;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Session;
use Maatwebsite\Excel\Facades\Excel;
// use App\Imports\ImportUser;
use App\Exports\ExportFormList;
use App\Exports\ExportOtherFormList;
use App\Exports\ExportMCF;
use App\Exports\ExportFNF;
use PDF;

class FinalApprovalController extends Controller
{

//member
	public function finalApproval()
	{
		$data['page'] = 'Final Approval Page';    	        
    
    	$data['members'] = \App\MembershipDetail::select('membership_details.*')->where('final_approval_status', 'Requested')->where('membership_details.is_active', 1)->get();
        
    	$data['requested_form'] = \App\MembershipDetail::where('final_approval_status', 'Requested')->where('membership_details.is_active', 1)->count();
    	
    	$data['user_id'] = \Auth::user()->id;
    
		return view('admin.final_approval.final-approval', $data);
	}
	
	
	public function finalApproveForm(Request $request) {
	   
	    $response=array();
        $validator = \Validator::make(
            $request->all(),
            array(
                'form_id' => 'required',
            )
        );
        if ($validator->fails()) {
            $response['flag'] = false;
            $response['errors'] = $this->parseErrorResponse($validator->getMessageBag());
        } else {
            
            $member_details =\App\MembershipDetail::where('id',$request->form_id)->where('is_active', 1)->first();
            if(!is_null($member_details)){
                $member_details->final_approval_status = 'Approved';
                $member_details->final_approved_by = \Auth::user()->id;
                $member_details->final_approval_date = date('Y-m-d');
                $member_details->save();
                
                $response['flag'] = 1;
                $response['message'] = 'Form Successfully Approved.'; 
            }else{
                $response['flag'] = 0;
                $response['error'] = 'NO Form Found With Id No. '.$request->form_id; 
            }
        }
        return response()->json($response);
	}
	
	
	public function finalApproveAll(Request $request) {
	    $response=array();
        $validator = \Validator::make(
            $request->all(),
            array(
                'form_id' => 'required',
            )
        );
        if ($validator->fails()) {
            $response['flag'] = false;
            $response['error'] = "Select Atleast One Form.";
        } else {
            
            try{
                
                \DB::beginTransaction();
                
                foreach($request->form_id as $key=>$form_id) {
                    $member_details =\App\MembershipDetail::where('id',$form_id)->where('is_active', 1)->first();    
                    if(!is_null($member_details)){
                        $member_details->final_approval_status = 'Approved';
                        $member_details->final_approved_by = \Auth::user()->id;
                        $member_details->final_approval_date = date('Y-m-d');
                        $member_details->save();
                    }                        
                }
                
                \DB::commit();
                
                $response['flag'] = 1;
                $response['message'] = 'Form Successfully Approved.'; 
                
            } catch(\Exception $exp) {
                \DB::rollBack(); 
                
                $response['flag'] = false;
                $response['error'] = $exp->getMessage();
            }
        }
        return response()->json($response);
	}
	
	
	public function finalRejectForm(Request $request) {
	    
	    $response=array();
        $validator = \Validator::make(
            $request->all(),
            array(
                'form_id' => 'required',
                'remark' => 'required',
            )
        );
        if ($validator->fails()) {
            $response['flag'] = false;
            $response['error'] = 'The Remark Field is Required.';
        } else {
            
            $member_details =\App\MembershipDetail::where('id',$request->form_id)->where('is_active', 1)->first();
            if(!is_null($member_details)){
                $member_details->final_approval_status = 'Rejected';
                $member_details->resubmit_status = 1;
                
                $finalArr = array();
		        $remarkArr[\Auth::user()->id.':'.'final'] = $request->remark;
		      
		        if(!is_null($member_details->remark )) {
		            $remarkdata = json_decode($member_details->remark, true);   
		            array_push($finalArr, $remarkdata);
		            array_push($finalArr, $remarkArr);
		            $member_details->remark = json_encode($finalArr);
		        } else {
		            $member_details->remark = json_encode($remarkArr);
		        }
		        
                $member_details->final_approved_by = \Auth::user()->id;
                $member_details->save();
                
                $response['flag'] = 1;
                $response['message'] = 'Form Successfully Rejected.'; 
            }else{
                $response['flag'] = 0;
                $response['error'] = 'NO Form Found With Id No. '.$request->form_id; 
            }
        }
        return response()->json($response);
	}
	
	public function finalRejectAll(Request $request) {
	   // dd($request->all());
	    $response=array();
        $validator = \Validator::make(
            $request->all(),
            array(
                'form_id' => 'required',
                'remark' => 'required',
            )
        );
        if ($validator->fails()) {
            $response['flag'] = false;
            $response['error'] = "Select Atleast One Form.";
        } else {
            
            try{
                
                \DB::beginTransaction();
                
                
                foreach($request->form_id as $key=>$form_id) {
                    $member_details =\App\MembershipDetail::where('id',$form_id)->where('is_active', 1)->first();
                    if(!is_null($member_details)){
                        $member_details->final_approval_status = 'Rejected';
                        
                        $finalArr = array();
        		        $remarkArr[\Auth::user()->id.':'.'final'] = $request->remark;
        		      
        		        if(!is_null($member_details->remark )) {
        		            $remarkdata = json_decode($member_details->remark, true);   
        		            array_push($finalArr, $remarkdata);
        		            array_push($finalArr, $remarkArr);
        		            $member_details->remark = json_encode($finalArr);
        		        } else {
        		            $member_details->remark = json_encode($remarkArr);
        		        }
        		        
                        $member_details->final_approved_by = \Auth::user()->id;
                        $member_details->save();
                    }                        
                }
                
                \DB::commit();
                
                $response['flag'] = 1;
                $response['message'] = 'Form Successfully Rejected.'; 
                
            } catch(\Exception $exp) {
                \DB::rollBack(); 
                
                $response['flag'] = false;
                $response['error'] = $exp->getMessage();
            }
        }
        return response()->json($response);
	}
	
	
	public function getApprovalStatusTracking($member_id) {
	    $data = array();
	   $data['form_data'] = \App\UserEditPermission::where('form_id', $member_id)->get();
	   //dd($data['form_data']);
	   $data['members'] = \App\MembershipDetail::select('membership_details.*')->where('id', $member_id)->where('membership_details.is_active', 1)->first();
	   
	   //dd($data['form_data']);
	   return view('admin.final_approval.tracking_approval_status', $data);
	   
	}

}