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\Exports\UserInactiveFormExport;

use App\Http\Traits\GlobalTrait;

class DeactivateFormController extends Controller
{

use GlobalTrait;
    
    public function __construct(){

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

}
	
	public function allFormList(Request $request)
	{
    	$data['page'] = 'All Form';
    	$data['members'] = \App\MembershipDetail::orderBy('id','desc')->whereNull('member_code')->where('is_active', 1)->orWhere('is_active', 2)->get();
    	
		return view('admin.all-form', $data);
	}
	
	public function deactivateForm(Request $request)
	{
	  $user_data =  \App\MembershipDetail::where('id', $request->form_id)->where('is_active', 1)->get();
	   if(count($user_data) > 0){
		$updateStatus = \App\MembershipDetail::where('id', $request->form_id)->update(['is_active' => '2','deactivated_by' => \Auth::user()->id]);
		$uep = \App\UserEditPermission::where('form_id', $request->form_id)->update(['is_active' => '2']);
		$fep = \App\FinanceEditPermission::where('form_id', $request->form_id)->update(['is_active' => '2']);
		$lep = \App\LegalEditPermission::where('form_id', $request->form_id)->update(['is_active' => '2']);
		
	        if ($updateStatus) {
				$response['flag'] = true;
				$response['message'] = $user_data[0]->form_no."  Form Deleted Successfully";
			} else {
				$response['flag'] = false;
				$response['error'] = "Something Went Wrong";
			}
	   }else{
	   	$updateStatus = \App\MembershipDetail::where('id', $request->form_id)->update(['is_active' => '1']);
	   	$uep = \App\UserEditPermission::where('form_id', $request->form_id)->update(['is_active' => '1']);
		$fep = \App\FinanceEditPermission::where('form_id', $request->form_id)->update(['is_active' => '1']);
		$lep = \App\LegalEditPermission::where('form_id', $request->form_id)->update(['is_active' => '1']);
		if ($updateStatus) {
				$response['flag'] = true;
				$response['message'] = "Activated Successfully";
			} else {
				$response['flag'] = false;
				$response['error'] = "Something Went Wrong";
			}
	   }
		return response()->json($response);

}
	
	public function formDeletion(Request $request)
	{
	   // dd($request->all());
	  $user_data =  \App\MembershipDetail::where('id', $request->form_id)->where('is_active', 1)->get();
	   if(count($user_data) > 0){
		$updateStatus = \App\MembershipDetail::where('id', $request->form_id)->update(['is_active' => '0','deactivated_by' => \Auth::user()->id]);
		$uep = \App\UserEditPermission::where('form_id', $request->form_id)->update(['is_active' => '0']);
		$fep = \App\FinanceEditPermission::where('form_id', $request->form_id)->update(['is_active' => '0']);
		$lep = \App\LegalEditPermission::where('form_id', $request->form_id)->update(['is_active' => '0']);
		
	        if ($updateStatus) {
				$response['flag'] = true;
				$response['message'] = $user_data[0]->form_no."  Form Deleted Successfully";
			} else {
				$response['flag'] = false;
				$response['error'] = "Something Went Wrong";
			}
	   }else{
				$response['flag'] = true;
				$response['message'] = "Form Already Deleted";

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

}
	
	public function inactiveFormExcelReport(){
        return Excel::download(new UserInactiveFormExport, 'inactive_form_report.xlsx');
    }

}