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\Imports\ImportMcc;

use App\Imports\MppImport;

use App\Imports\ImportMasterData;

use App\Imports\ImportBankMasterData;

use App\Exports\ExportFormList;

use App\Exports\ExportOtherFormList;

use App\Exports\ExportHouseMemberList;

use App\Exports\ExportBankDetail;

use App\Exports\ExportMilkDetail;

use App\Exports\ExportGeneralFormat;

use App\Exports\ExportAssignedMpp;

use App\Exports\ExportMCF;

use App\Exports\ExportFNF;

use App\Exports\MemberFormExport;

use App\Exports\ExportMasterData;

use App\Exports\ExportBankMasterData;

use App\Exports\ExportMpp;

use Illuminate\Support\Facades\Validator;

use PDF;

use Carbon\Carbon;

use Illuminate\Support\Facades\Response;

use App\Http\Traits\GlobalTrait;

class MasterController extends Controller
{
    use GlobalTrait;

public function __construct()
    {
        \DB::statement(
            "SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));"
        );
    }

//member

// 	public function member()

// 	{

// 		$data['page'] = 'MembershipDetail';

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

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

//         }else{

//       		$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();

//       	}

// 		return view('admin.master.member', $data);

// 	}

public function transferMpp()
    {
        $data["mcc"] = \DB::table("mcc")
            ->where("is_active", 1)
            ->get();

$data["mpps"] = \DB::table("mpp")
            ->select("mpp.*", "mcc.name as mcc_name")
            ->leftJoin("mcc", "mcc.code", "mpp.mcc_code")
            ->where("mpp.is_active", 1)
            ->orderBy("mpp.id", "desc")
            ->get();

return view("admin.master.transfer-mpp", $data);
    }

public function transferMppToMcc(Request $request)
    {
        // 	 dd($request->all());

$response = [];

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

[
                "mcc_name_to" => "required",

"mpp_codes" => "required_without:mcc_name_to",
            ],

[
                "mcc_name_to.required" => "Select Mcc",

"mpp_codes.required_without" =>
                    "Select atleast one Mpp For Transfer.",
            ]
        );

if ($validator->fails()) {
            $response["flag"] = 2;

$response["error"] = $validator->getMessageBag();
        } else {
            //  $user = \App\User::where('id', $request->user_id)->first();

//  if(!is_null($user)){

//$mpp_codes = $request->mpp_codes;

//   $mpp_code_ids = explode(',',$mpp_codes);

foreach ($request->mpp_codes as $mpp_codes) {
                $newmppcode = substr($mpp_codes, 3);

$newmppcode = $request->mcc_name_to . $newmppcode;

$user = \DB::table("mpp")
                    ->where("code", $mpp_codes)

->update([
                        "mcc_code" => $request->mcc_name_to,
                        "code" => $newmppcode,
                    ]);
            }

if ($user) {
                $response["flag"] = true;

$response["message"] = " Transfer Successfully";
            } else {
                $response["flag"] = false;

$response["error"] = "Something Went Wrong";
            }

// 		 }else{

// 			$response['flag'] = false;

// 			$response['error'] = "User not Exist.";

// 		}
        }

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

public function mcc()
    {
        $data["mccs"] = \DB::table("mcc")
            ->where("is_active", 1)
            ->orderBy("id", "desc")
            ->get();

return view("admin.master.mcc", $data);
    }

public function animalType()
    {
        $data["animalTypes"] = \DB::table("animal_types")
            ->where("is_active", 1)
            ->orderBy("id", "desc")
            ->get();

return view("admin.master.animal-type", $data);
    }

public function animalBreed()
    {
        $data["animalBreeds"] = \DB::table("animal_breeds")
            ->where("is_active", 1)
            ->orderBy("id", "desc")
            ->get();

$data["animalTypes"] = DB::table("animal_types")
            ->where("is_active", 1)
            ->get();

return view("admin.master.animal-breed", $data);
    }

public function addAnimalType(Request $request)
    {
        $request->validate([
            "animal_type" => "required",
        ]);

// Create a new record in the animal_types table

$animalType = new \App\AnimalType();

$animalType->animal_type = $request->animal_type;

// Save and check if the operation was successful

if ($animalType->save()) {
            return response()->json([
                "success" => true,
                "message" => "Animal type added successfully",
            ]);
        } else {
            return response()->json(
                ["success" => false, "message" => "Failed to add animal type"],
                500
            );
        }
    }

public function addAnimalBreed(Request $request)
    {
        $request->validate([
            "animal_type" => "required",

"breed" => "required",
        ]);

// Create a new record in the animal_types table

$animalBreed = new \App\AnimalBreed();

$animalBreed->animal_type_id = $request->animal_type;

$animalBreed->breed_name = $request->breed;

// Save and check if the operation was successful

if ($animalBreed->save()) {
            return response()->json([
                "success" => true,
                "message" => "Animal Breed added successfully",
            ]);
        } else {
            return response()->json(
                ["success" => false, "message" => "Failed to add animal breed"],
                500
            );
        }
    }

public function downloadMccFormat()
    {
        $filepath = public_path("excel_format/mcc_excel_format.xlsx");

return response()->download($filepath);
    }

public function importMcc(Request $request)
    {
        //dd($request->all());

$response = [];

$validator = \Validator::make($request->all(), [
            "import_mcc_file" => "required",
        ]);

if ($validator->fails()) {
            $response["flag"] = false;

$response["errors"] = $validator->getMessageBag();
        } else {
            $extension = \File::extension(
                $request->file("import_mcc_file")->getClientOriginalName()
            );

if ($extension == "xlsx" || $extension == "xls") {
                $import = new \App\Imports\ImportMcc();

$result = Excel::import(
                    $import,
                    $request->file("import_mcc_file")
                );

if ($result == true) {
                    $response["flag"] = true;

$response["message"] = "File Imported Successfully";
                } else {
                    $response["flag"] = false;

$response["message"] = "File Not Imported";
                }
            } else {
                $response["flag"] = false;

$response["message"] = "Only excel file";
            }
        }

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

public function mpp()
    {
        $data["mpps"] = \DB::table("mpp")
            ->select("mpp.*", "mcc.name as mcc_name")
            ->leftJoin("mcc", "mcc.code", "mpp.mcc_code")
            ->where("mpp.is_active", 1)
            ->orderBy("mpp.id", "desc")
            ->get();

return view("admin.master.mpp", $data);
    }

public function downloadMppFormat()
    {
        $filepath = public_path("excel_format/mpp_excel_format.xlsx");

return response()->download($filepath);
    }

public function importMpp(Request $request)
    {
        //dd($request->all());

$response = [];

$validator = \Validator::make($request->all(), [
            "import_mpp_file" => "required",
        ]);

if ($validator->fails()) {
            $response["flag"] = false;

$response["errors"] = $validator->getMessageBag();
        } else {
            $extension = \File::extension(
                $request->file("import_mpp_file")->getClientOriginalName()
            );

if ($extension == "xlsx" || $extension == "xls") {
                $import = new \App\Imports\MppImport();

$result = Excel::import(
                    $import,
                    $request->file("import_mpp_file")
                );

if ($result == true) {
                    $response["flag"] = true;

$response["message"] = "File Imported Successfully";
                } else {
                    $response["flag"] = false;

$response["message"] = "File Not Imported";
                }
            } else {
                $response["flag"] = false;

$response["message"] = "Only excel file";
            }
        }

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

public function exportMpp()
    {
        return Excel::download(new ExportMpp(), "mpp_data.xlsx");
    }

public function masterData()
    {
        $data["masters"] = \DB::table("master")
            ->where("is_active", 1)
            ->orderBy("id", "desc")
            ->get();

return view("admin.master.master_data", $data);
    }

public function bankMaster()
    {
        $data["masters"] = \DB::table("bank_masters")
            ->where("is_active", 1)
            ->orderBy("id", "desc")
            ->get();

return view("admin.master.bank_master_data", $data);
    }

public function downloadMasterDataFormat()
    {
        $filepath = public_path("excel_format/master_data_excel_format.xlsx");

return response()->download($filepath);
    }

public function downloadBankMasterDataFormat()
    {
        $filepath = public_path(
            "excel_format/bank_master_data_excel_format.xlsx"
        );

return response()->download($filepath);
    }

public function importMasterData(Request $request)
    {
        $response = [];

$validator = \Validator::make($request->all(), [
            "import_master_file" => "required",
        ]);

if ($validator->fails()) {
            $response["flag"] = false;

$response["errors"] = $validator->getMessageBag();
        } else {
            $extension = \File::extension(
                $request->file("import_master_file")->getClientOriginalName()
            );

if ($extension == "xlsx" || $extension == "xls") {
                $import = new \App\Imports\ImportMasterData();

$result = Excel::import(
                    $import,
                    $request->file("import_master_file")
                );

if ($result == true) {
                    $response["flag"] = true;

$response["message"] = "File Imported Successfully";
                } else {
                    $response["flag"] = false;

$response["message"] = "File Not Imported";
                }
            } else {
                $response["flag"] = false;

$response["message"] = "Only excel file";
            }
        }

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

public function importBankMasterData(Request $request)
    {
        $response = [];

$validator = \Validator::make($request->all(), [
            "import_bank_master_file" => "required",
        ]);

if ($validator->fails()) {
            $response["flag"] = false;

$response["errors"] = $validator->getMessageBag();
        } else {
            $extension = \File::extension(
                $request
                    ->file("import_bank_master_file")
                    ->getClientOriginalName()
            );

if ($extension == "xlsx" || $extension == "xls") {
                $import = new \App\Imports\ImportBankMasterData();

$result = Excel::import(
                    $import,
                    $request->file("import_bank_master_file")
                );

if ($result == true) {
                    $response["flag"] = true;

$response["message"] = "File Imported Successfully";
                } else {
                    $response["flag"] = false;

$response["message"] = "File Not Imported";
                }
            } else {
                $response["flag"] = false;

$response["message"] = "Only excel file";
            }
        }

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

public function exportMasterData()
    {
        return Excel::download(new ExportMasterData(), "master_data.xlsx");
    }

public function exportBankMasterData()
    {
        return Excel::download(
            new ExportBankMasterData(),
            "bank_master_data.xlsx"
        );
    }

public function deactiveMaster($id)
    {
        // dd($id);

$response = [];

$master = \DB::table("master")
            ->where("id", $id)
            ->where("is_active", 1)
            ->first();

if (is_null($master)) {
            $response["flag"] = false;

$response["message"] = "Not Found";
        } else {
            // 			$master->is_active = 0;

// 			$master->updated_by = \Auth::user()->id;

$data = \DB::table("master")
                ->where("id", $id)
                ->where("is_active", 1)
                ->update(["is_active" => 0, "updated_by" => \Auth::user()->id]);

if ($data) {
                $response["flag"] = true;

$response["message"] = "Remove Successfully";
            } else {
                $response["flag"] = false;

$response["message"] = "Failed to Remove";
            }
        }

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

public function deactiveBankMaster($id)
    {
        // dd($id);

$response = [];

$master = \DB::table("bank_masters")
            ->where("id", $id)
            ->where("is_active", 1)
            ->first();

if (is_null($master)) {
            $response["flag"] = false;

$response["message"] = "Not Found";
        } else {
            // 			$master->is_active = 0;

// 			$master->updated_by = \Auth::user()->id;

$data = \DB::table("bank_masters")
                ->where("id", $id)
                ->where("is_active", 1)
                ->update(["is_active" => 0, "updated_by" => \Auth::user()->id]);

if ($data) {
                $response["flag"] = true;

$response["message"] = "Remove Successfully";
            } else {
                $response["flag"] = false;

$response["message"] = "Failed to Remove";
            }
        }

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

public function member(Request $request)
    {
        $data = [];

$data["page"] = "Total Form";

$data["user"] = \App\User::where("is_active", 1)
            ->where("role_id", 3)
            ->get();

$data["pibuser"] = \App\User::where("is_active", 1)
            ->where("role_id", 2)
            ->get();

$data["mcc"] = \DB::table("mcc")
            ->where("is_active", 1)
            ->get();

if (\Auth::user()->role_id == "1") {
            $data["members"] = \App\MembershipDetail::where(
                "is_active",
                1
            )->get();
        } else {
            // $data['members']= \App\MembershipDetail::where('created_by_id', \Auth::user()->id)->where('is_active', 1)->get();

$data["members"] = [];
        }

$data["old_value"] = [];

if ($request->isMethod("post")) {
            // dd($request->all());

if (\Auth::user()->role_id == "1") {
                $query = \App\MembershipDetail::query();

if ($request->user_id) {
                    $query->where("created_by_id", $request->user_id);
                }

if ($request->from_date && $request->to_date) {
                    $query->whereBetween("created_at", [
                        $request->from_date,
                        $request->to_date,
                    ]);
                }

if ($request->mcc_name) {
                    $query->where("mcc_code", $request->mcc_name);
                }

if ($request->mpp_name) {
                    $query->where("mpp_code", $request->mpp_name);
                }

if ($request->status) {
                    $query->where("final_approval_status", $request->status);
                }

$data["members"] = $query->where("is_active", 1)->get();
            }

// }elseif(\Auth::user()->role_id=='2'){

//     $user = \App\User::where('is_active',1)->where('role_id',2)->get();

//         // $data['members']= \App\MembershipDetail::where('created_by_id', \Auth::user()->id)->where('is_active', 1)->get();

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

// }

$data["old_value"] = \Request::all();

// dd($data['old_value']);
        }

return view("admin.master.member", $data);
    }

public function approvedMember(Request $request)
    {
        $data = [];

$data["page"] = "Total Form";

$data["user"] = \App\User::where("is_active", 1)
            ->where("role_id", 3)
            ->get();

$data["pibuser"] = \App\User::where("is_active", 1)
            ->where("role_id", 2)
            ->get();

$data["mcc"] = \DB::table("mcc")
            ->where("is_active", 1)
            ->get();

$data["mpps"] = \DB::table("mpp")
            ->where("is_active", 1)
            ->get();

if (\Auth::user()->role_id == "1") {
            $data["members"] = \App\MembershipDetail::where("is_active", 1)
                ->where("final_approval_status", "Approved")
                ->whereDate("created_at", Carbon::today())
                ->get();
        } else {
            // $data['members']= \App\MembershipDetail::where('created_by_id', \Auth::user()->id)->where('is_active', 1)->get();

$data["members"] = [];
        }

$data["old_value"] = [];

if ($request->isMethod("post")) {
            //dd($request->all());

if (\Auth::user()->role_id == "1") {
                $from = $request->from_date;

$to = $request->to_date;

$currentDate = date("Y-m-d");

if (
                    !empty($request->mcc_name) &&
                    empty($request->mpp_name) &&
                    empty($from) &&
                    empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mcc_code", "=", $request->mcc_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", "Approved"],
                    ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mccCode"] = $request->mcc_name;
                } elseif (
                    !empty($request->mcc_name) &&
                    !empty($request->mpp_name) &&
                    empty($from) &&
                    empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mcc_code", "=", $request->mcc_name],
                        ["mpp_code", "=", $request->mpp_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", "Approved"],
                    ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mccCode"] = $request->mcc_name;

$data["mppCode"] = $request->mpp_name;
                } elseif (
                    !empty($request->mcc_name) &&
                    !empty($request->mpp_name) &&
                    !empty($from) &&
                    empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mcc_code", "=", $request->mcc_name],
                        ["mpp_code", "=", $request->mpp_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", "Approved"],
                    ])
                        ->whereBetween(DB::raw("date(updated_at)"), [
                            $from,
                            $currentDate,
                        ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mccCode"] = $request->mcc_name;

$data["mppCode"] = $request->mpp_name;

$data["fromDate"] = $from;
                } elseif (
                    !empty($request->mcc_name) &&
                    !empty($request->mpp_name) &&
                    !empty($from) &&
                    !empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mcc_code", "=", $request->mcc_name],
                        ["mpp_code", "=", $request->mpp_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", "Approved"],
                    ])
                        ->whereBetween(DB::raw("date(updated_at)"), [
                            $from,
                            $to,
                        ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mccCode"] = $request->mcc_name;

$data["mppCode"] = $request->mpp_name;

$data["fromDate"] = $from;

$data["toDate"] = $to;
                } elseif (
                    !empty($request->mcc_name) &&
                    empty($request->mpp_name) &&
                    !empty($from) &&
                    !empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mcc_code", "=", $request->mcc_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", "Approved"],
                    ])
                        ->whereBetween(DB::raw("date(updated_at)"), [
                            $from,
                            $to,
                        ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mppCode"] = $request->mpp_name;

$data["fromDate"] = $from;

$data["toDate"] = $to;
                } elseif (
                    empty($request->mcc_name) &&
                    !empty($request->mpp_name) &&
                    empty($from) &&
                    empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mpp_code", "=", $request->mpp_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", "Approved"],
                    ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mppCode"] = $request->mpp_name;
                } elseif (
                    empty($request->mcc_name) &&
                    !empty($request->mpp_name) &&
                    !empty($from) &&
                    empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mpp_code", "=", $request->mpp_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", "Approved"],
                    ])
                        ->whereBetween(DB::raw("date(updated_at)"), [
                            $from,
                            $currentDate,
                        ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mppCode"] = $request->mpp_name;

$data["fromDate"] = $from;
                } elseif (
                    empty($request->mcc_name) &&
                    !empty($request->mpp_name) &&
                    !empty($from) &&
                    !empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mpp_code", "=", $request->mpp_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", "Approved"],
                    ])
                        ->whereBetween(DB::raw("date(updated_at)"), [
                            $from,
                            $to,
                        ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mppCode"] = $request->mpp_name;

$data["fromDate"] = $from;

$data["toDate"] = $to;
                } elseif (
                    empty($request->mcc_name) &&
                    empty($request->mpp_name) &&
                    !empty($from) &&
                    empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", "Approved"],
                    ])
                        ->whereBetween(DB::raw("date(updated_at)"), [
                            $from,
                            $currentDate,
                        ])
                        ->orderBy("id", "desc")
                        ->get();

$data["fromDate"] = $from;
                } elseif (
                    empty($request->mcc_name) &&
                    empty($request->mpp_name) &&
                    !empty($from) &&
                    !empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", "Approved"],
                    ])
                        ->whereBetween(DB::raw("date(updated_at)"), [
                            $from,
                            $to,
                        ])
                        ->orderBy("id", "desc")
                        ->get();

$data["fromDate"] = $from;

$data["toDate"] = $to;
                }

// $query = \App\MembershipDetail::query();

// if($request->user_id){

// 	$query->where('created_by_id',$request->user_id);

// }

// if($request->from_date && $request->to_date){

// 	$query->whereBetween('created_at',[$request->from_date,$request->to_date]);

// }

// if($request->mcc_name){

// 	$query->where('mcc_code',$request->mcc_name);

// }

// if($request->mpp_name){

// 	$query->where('mpp_code',$request->mpp_name);

// }

// if($request->status){

// 	$query->where('final_approval_status',$request->status);

// }

// $data['members'] = $query->where('is_active', 1)->where('final_approval_status', 'Approved')->get();
            } else {
                // $data['members']= \App\MembershipDetail::where('created_by_id', \Auth::user()->id)->where('is_active', 1)->get();

$data["members"] = [];
            }

$data["old_value"] = \Request::all();

// dd($data['old_value']);
        }

return view("admin.master.member", $data);
    }

public function pendingMember(Request $request)
    {
        $data = [];

$data["page"] = "Total Form";

$data["user"] = \App\User::where("is_active", 1)
            ->where("role_id", 3)
            ->get();

$data["pibuser"] = \App\User::where("is_active", 1)
            ->where("role_id", 2)
            ->get();

$data["mcc"] = \DB::table("mcc")
            ->where("is_active", 1)
            ->get();

$data["mpps"] = \DB::table("mpp")
            ->where("is_active", 1)
            ->get();

if (\Auth::user()->role_id == "1") {
            $data["members"] = \App\MembershipDetail::where("is_active", 1)
                ->where("final_approval_status", "=", null)
                ->get();
        } else {
            // $data['members']= \App\MembershipDetail::where('created_by_id', \Auth::user()->id)->where('is_active', 1)->get();

$data["members"] = [];
        }

$data["old_value"] = [];

if ($request->isMethod("post")) {
            // dd($request->all());

if (\Auth::user()->role_id == "1") {
                $from = $request->from_date;

$to = $request->to_date;

$currentDate = date("Y-m-d");

if (
                    !empty($request->mcc_name) &&
                    empty($request->mpp_name) &&
                    empty($from) &&
                    empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mcc_code", "=", $request->mcc_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", null],
                    ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mccCode"] = $request->mcc_name;
                } elseif (
                    !empty($request->mcc_name) &&
                    !empty($request->mpp_name) &&
                    empty($from) &&
                    empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mcc_code", "=", $request->mcc_name],
                        ["mpp_code", "=", $request->mpp_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", null],
                    ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mccCode"] = $request->mcc_name;

$data["mppCode"] = $request->mpp_name;
                } elseif (
                    !empty($request->mcc_name) &&
                    !empty($request->mpp_name) &&
                    !empty($from) &&
                    empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mcc_code", "=", $request->mcc_name],
                        ["mpp_code", "=", $request->mpp_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", null],
                    ])
                        ->whereBetween(DB::raw("date(updated_at)"), [
                            $from,
                            $currentDate,
                        ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mccCode"] = $request->mcc_name;

$data["mppCode"] = $request->mpp_name;

$data["fromDate"] = $from;
                } elseif (
                    !empty($request->mcc_name) &&
                    !empty($request->mpp_name) &&
                    !empty($from) &&
                    !empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mcc_code", "=", $request->mcc_name],
                        ["mpp_code", "=", $request->mpp_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", null],
                    ])
                        ->whereBetween(DB::raw("date(updated_at)"), [
                            $from,
                            $to,
                        ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mccCode"] = $request->mcc_name;

$data["mppCode"] = $request->mpp_name;

$data["fromDate"] = $from;

$data["toDate"] = $to;
                } elseif (
                    !empty($request->mcc_name) &&
                    empty($request->mpp_name) &&
                    !empty($from) &&
                    !empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mcc_code", "=", $request->mcc_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", null],
                    ])
                        ->whereBetween(DB::raw("date(updated_at)"), [
                            $from,
                            $to,
                        ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mppCode"] = $request->mpp_name;

$data["fromDate"] = $from;

$data["toDate"] = $to;
                } elseif (
                    empty($request->mcc_name) &&
                    !empty($request->mpp_name) &&
                    empty($from) &&
                    empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mpp_code", "=", $request->mpp_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", null],
                    ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mppCode"] = $request->mpp_name;
                } elseif (
                    empty($request->mcc_name) &&
                    !empty($request->mpp_name) &&
                    !empty($from) &&
                    empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mpp_code", "=", $request->mpp_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", null],
                    ])
                        ->whereBetween(DB::raw("date(updated_at)"), [
                            $from,
                            $currentDate,
                        ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mppCode"] = $request->mpp_name;

$data["fromDate"] = $from;
                } elseif (
                    empty($request->mcc_name) &&
                    !empty($request->mpp_name) &&
                    !empty($from) &&
                    !empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mpp_code", "=", $request->mpp_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", null],
                    ])
                        ->whereBetween(DB::raw("date(updated_at)"), [
                            $from,
                            $to,
                        ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mppCode"] = $request->mpp_name;

$data["fromDate"] = $from;

$data["toDate"] = $to;
                } elseif (
                    empty($request->mcc_name) &&
                    empty($request->mpp_name) &&
                    !empty($from) &&
                    empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", null],
                    ])
                        ->whereBetween(DB::raw("date(updated_at)"), [
                            $from,
                            $currentDate,
                        ])
                        ->orderBy("id", "desc")
                        ->get();

$data["fromDate"] = $from;
                } elseif (
                    empty($request->mcc_name) &&
                    empty($request->mpp_name) &&
                    !empty($from) &&
                    !empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", null],
                    ])
                        ->whereBetween(DB::raw("date(updated_at)"), [
                            $from,
                            $to,
                        ])
                        ->orderBy("id", "desc")
                        ->get();

$data["fromDate"] = $from;

$data["toDate"] = $to;
                }
            } else {
                // $data['members']= \App\MembershipDetail::where('created_by_id', \Auth::user()->id)->where('is_active', 1)->get();

$data["members"] = [];
            }

$data["old_value"] = \Request::all();

// dd($data['old_value']);
        }

return view("admin.master.member", $data);
    }

public function rejectedMember(Request $request)
    {
        $data = [];

$data["page"] = "Total Form";

$data["user"] = \App\User::where("is_active", 1)
            ->where("role_id", 3)
            ->get();

$data["pibuser"] = \App\User::where("is_active", 1)
            ->where("role_id", 2)
            ->get();

$data["mcc"] = \DB::table("mcc")
            ->where("is_active", 1)
            ->get();

$data["mpps"] = \DB::table("mpp")
            ->where("is_active", 1)
            ->get();

if (\Auth::user()->role_id == "1") {
            $data["members"] = \App\MembershipDetail::where("is_active", 1)
                ->where("final_approval_status", "Rejected")
                ->get();
        } else {
            // $data['members']= \App\MembershipDetail::where('created_by_id', \Auth::user()->id)->where('is_active', 1)->get();

$data["members"] = [];
        }

$data["old_value"] = [];

if ($request->isMethod("post")) {
            // dd($request->all());

if (\Auth::user()->role_id == "1") {
                $from = $request->from_date;

$to = $request->to_date;

$currentDate = date("Y-m-d");

if (
                    !empty($request->mcc_name) &&
                    empty($request->mpp_name) &&
                    empty($from) &&
                    empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mcc_code", "=", $request->mcc_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", "Rejected"],
                    ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mccCode"] = $request->mcc_name;
                } elseif (
                    !empty($request->mcc_name) &&
                    !empty($request->mpp_name) &&
                    empty($from) &&
                    empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mcc_code", "=", $request->mcc_name],
                        ["mpp_code", "=", $request->mpp_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", "Rejected"],
                    ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mccCode"] = $request->mcc_name;

$data["mppCode"] = $request->mpp_name;
                } elseif (
                    !empty($request->mcc_name) &&
                    !empty($request->mpp_name) &&
                    !empty($from) &&
                    empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mcc_code", "=", $request->mcc_name],
                        ["mpp_code", "=", $request->mpp_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", "Rejected"],
                    ])
                        ->whereBetween(DB::raw("date(updated_at)"), [
                            $from,
                            $currentDate,
                        ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mccCode"] = $request->mcc_name;

$data["mppCode"] = $request->mpp_name;

$data["fromDate"] = $from;
                } elseif (
                    !empty($request->mcc_name) &&
                    !empty($request->mpp_name) &&
                    !empty($from) &&
                    !empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mcc_code", "=", $request->mcc_name],
                        ["mpp_code", "=", $request->mpp_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", "Rejected"],
                    ])
                        ->whereBetween(DB::raw("date(updated_at)"), [
                            $from,
                            $to,
                        ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mccCode"] = $request->mcc_name;

$data["mppCode"] = $request->mpp_name;

$data["fromDate"] = $from;

$data["toDate"] = $to;
                } elseif (
                    !empty($request->mcc_name) &&
                    empty($request->mpp_name) &&
                    !empty($from) &&
                    !empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mcc_code", "=", $request->mcc_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", "Rejected"],
                    ])
                        ->whereBetween(DB::raw("date(updated_at)"), [
                            $from,
                            $to,
                        ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mppCode"] = $request->mpp_name;

$data["fromDate"] = $from;

$data["toDate"] = $to;
                } elseif (
                    empty($request->mcc_name) &&
                    !empty($request->mpp_name) &&
                    empty($from) &&
                    empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mpp_code", "=", $request->mpp_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", "Rejected"],
                    ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mppCode"] = $request->mpp_name;
                } elseif (
                    empty($request->mcc_name) &&
                    !empty($request->mpp_name) &&
                    !empty($from) &&
                    empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mpp_code", "=", $request->mpp_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", "Rejected"],
                    ])
                        ->whereBetween(DB::raw("date(updated_at)"), [
                            $from,
                            $currentDate,
                        ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mppCode"] = $request->mpp_name;

$data["fromDate"] = $from;
                } elseif (
                    empty($request->mcc_name) &&
                    !empty($request->mpp_name) &&
                    !empty($from) &&
                    !empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mpp_code", "=", $request->mpp_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", "Rejected"],
                    ])
                        ->whereBetween(DB::raw("date(updated_at)"), [
                            $from,
                            $to,
                        ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mppCode"] = $request->mpp_name;

$data["fromDate"] = $from;

$data["toDate"] = $to;
                } elseif (
                    empty($request->mcc_name) &&
                    empty($request->mpp_name) &&
                    !empty($from) &&
                    empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", "Rejected"],
                    ])
                        ->whereBetween(DB::raw("date(updated_at)"), [
                            $from,
                            $currentDate,
                        ])
                        ->orderBy("id", "desc")
                        ->get();

$data["fromDate"] = $from;
                } elseif (
                    empty($request->mcc_name) &&
                    empty($request->mpp_name) &&
                    !empty($from) &&
                    !empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", "Rejected"],
                    ])
                        ->whereBetween(DB::raw("date(updated_at)"), [
                            $from,
                            $to,
                        ])
                        ->orderBy("id", "desc")
                        ->get();

$data["fromDate"] = $from;

$data["toDate"] = $to;
                }
            } else {
                // $data['members']= \App\MembershipDetail::where('created_by_id', \Auth::user()->id)->where('is_active', 1)->get();

$data["members"] = [];
            }

$data["old_value"] = \Request::all();

// dd($data['old_value']);
        }

return view("admin.master.member", $data);
    }

public function resubmittedMember(Request $request)
    {
        $data = [];

$data["page"] = "Total Form";

$data["user"] = \App\User::where("is_active", 1)
            ->where("role_id", 3)
            ->get();

$data["pibuser"] = \App\User::where("is_active", 1)
            ->where("role_id", 2)
            ->get();

$data["mcc"] = \DB::table("mcc")
            ->where("is_active", 1)
            ->get();

$data["mpps"] = \DB::table("mpp")
            ->where("is_active", 1)
            ->get();

if (\Auth::user()->role_id == "1") {
            $data["members"] = \App\MembershipDetail::where("is_active", 1)
                ->where("final_approval_status", null)
                ->where("resubmit_status", 2)
                ->get();
        } else {
            // $data['members']= \App\MembershipDetail::where('created_by_id', \Auth::user()->id)->where('is_active', 1)->get();

$data["members"] = [];
        }

$data["old_value"] = [];

if ($request->isMethod("post")) {
            // dd($request->all());

if (\Auth::user()->role_id == "1") {
                $from = $request->from_date;

$to = $request->to_date;

$currentDate = date("Y-m-d");

if (
                    !empty($request->mcc_name) &&
                    empty($request->mpp_name) &&
                    empty($from) &&
                    empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mcc_code", "=", $request->mcc_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", "Rejected"],
                    ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mccCode"] = $request->mcc_name;
                } elseif (
                    !empty($request->mcc_name) &&
                    !empty($request->mpp_name) &&
                    empty($from) &&
                    empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mcc_code", "=", $request->mcc_name],
                        ["mpp_code", "=", $request->mpp_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", "Rejected"],
                    ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mccCode"] = $request->mcc_name;

$data["mppCode"] = $request->mpp_name;
                } elseif (
                    !empty($request->mcc_name) &&
                    !empty($request->mpp_name) &&
                    !empty($from) &&
                    empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mcc_code", "=", $request->mcc_name],
                        ["mpp_code", "=", $request->mpp_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", "Rejected"],
                    ])
                        ->whereBetween(DB::raw("date(updated_at)"), [
                            $from,
                            $currentDate,
                        ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mccCode"] = $request->mcc_name;

$data["mppCode"] = $request->mpp_name;

$data["fromDate"] = $from;
                } elseif (
                    !empty($request->mcc_name) &&
                    !empty($request->mpp_name) &&
                    !empty($from) &&
                    !empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mcc_code", "=", $request->mcc_name],
                        ["mpp_code", "=", $request->mpp_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", "Rejected"],
                    ])
                        ->whereBetween(DB::raw("date(updated_at)"), [
                            $from,
                            $to,
                        ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mccCode"] = $request->mcc_name;

$data["mppCode"] = $request->mpp_name;

$data["fromDate"] = $from;

$data["toDate"] = $to;
                } elseif (
                    !empty($request->mcc_name) &&
                    empty($request->mpp_name) &&
                    !empty($from) &&
                    !empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mcc_code", "=", $request->mcc_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", "Rejected"],
                    ])
                        ->whereBetween(DB::raw("date(updated_at)"), [
                            $from,
                            $to,
                        ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mppCode"] = $request->mpp_name;

$data["fromDate"] = $from;

$data["toDate"] = $to;
                } elseif (
                    empty($request->mcc_name) &&
                    !empty($request->mpp_name) &&
                    empty($from) &&
                    empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mpp_code", "=", $request->mpp_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", "Rejected"],
                    ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mppCode"] = $request->mpp_name;
                } elseif (
                    empty($request->mcc_name) &&
                    !empty($request->mpp_name) &&
                    !empty($from) &&
                    empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mpp_code", "=", $request->mpp_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", "Rejected"],
                    ])
                        ->whereBetween(DB::raw("date(updated_at)"), [
                            $from,
                            $currentDate,
                        ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mppCode"] = $request->mpp_name;

$data["fromDate"] = $from;
                } elseif (
                    empty($request->mcc_name) &&
                    !empty($request->mpp_name) &&
                    !empty($from) &&
                    !empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["mpp_code", "=", $request->mpp_name],
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", "Rejected"],
                    ])
                        ->whereBetween(DB::raw("date(updated_at)"), [
                            $from,
                            $to,
                        ])
                        ->orderBy("id", "desc")
                        ->get();

$data["mppCode"] = $request->mpp_name;

$data["fromDate"] = $from;

$data["toDate"] = $to;
                } elseif (
                    empty($request->mcc_name) &&
                    empty($request->mpp_name) &&
                    !empty($from) &&
                    empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", "Rejected"],
                    ])
                        ->whereBetween(DB::raw("date(updated_at)"), [
                            $from,
                            $currentDate,
                        ])
                        ->orderBy("id", "desc")
                        ->get();

$data["fromDate"] = $from;
                } elseif (
                    empty($request->mcc_name) &&
                    empty($request->mpp_name) &&
                    !empty($from) &&
                    !empty($to)
                ) {
                    $data["members"] = \App\MembershipDetail::where([
                        ["is_active", "=", 1],
                        ["final_approval_status", "=", "Rejected"],
                    ])
                        ->whereBetween(DB::raw("date(updated_at)"), [
                            $from,
                            $to,
                        ])
                        ->orderBy("id", "desc")
                        ->get();

$data["fromDate"] = $from;

$data["toDate"] = $to;
                }
            } else {
                // $data['members']= \App\MembershipDetail::where('created_by_id', \Auth::user()->id)->where('is_active', 1)->get();

$data["members"] = [];
            }

$data["old_value"] = \Request::all();

// dd($data['old_value']);
        }

return view("admin.master.member", $data);
    }

public function getForm($id)
    {
        $data["user"] = \App\User::where("is_active", 1)
            ->where("role_id", 3)
            ->get();

$data["pibuser"] = \App\User::where("is_active", 1)
            ->where("role_id", 2)
            ->get();

$data["mcc"] = \DB::table("mcc")
            ->where("is_active", 1)
            ->get();

$data["old_value"] = [];

if (\Auth::user()->role_id == "1") {
            $data["members"] = \App\MembershipDetail::where("is_active", 1)
                ->where("created_by_id", $id)
                ->orderBy("created_at", "desc")
                ->get();
        } else {
            $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("created_by_id", $id)
                ->where("user_id", \Auth::user()->id)
                ->where("user_edit_permissions.is_active", 1)
                ->get();
        }

$name = \App\User::select("name")
            ->where("id", $id)
            ->where("is_active", 1)
            ->first();

$data["page"] = "Forms Of " . $name["name"];

return view("admin.master.member", $data);
    }

public function viewMember($id)
    {
        $data["page"] = "View MembershipDetail";

$data["id"] = $id;

if (\Auth::user()->role_id == 1) {
            $members = \App\MembershipDetail::where("id", $id)
                ->where("is_active", 1)
                ->first();
        } elseif (\Auth::user()->role_type == 1) {
            $members = \App\MembershipDetail::join(
                "user_edit_permissions as uep",
                "uep.form_id",
                "membership_details.id"
            )
                ->where("membership_details.id", $id)
                ->where("membership_details.is_active", 1)
                ->where("uep.is_active", 1)
                ->first();
        } elseif (\Auth::user()->role_type == 2) {
            $members = \App\MembershipDetail::join(
                "legal_edit_permissions as lep",
                "lep.form_id",
                "membership_details.id"
            )
                ->where("membership_details.id", $id)
                ->where("membership_details.is_active", 1)
                ->where("lep.is_active", 1)
                ->first();
        } elseif (\Auth::user()->role_type == 3) {
            $members = \App\MembershipDetail::join(
                "finance_edit_permissions as fep",
                "fep.form_id",
                "membership_details.id"
            )
                ->where("membership_details.id", $id)
                ->where("membership_details.is_active", 1)
                ->where("fep.is_active", 1)
                ->first();
        }

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

return view("admin.master.view-member", $data);
    }

public function memberApprove(Request $request)
    {
        $updateStatus = \App\MembershipDetail::where("id", $request->id)
            ->where("is_active", 1)
            ->update(["approval_status" => "Approved"]);

if ($updateStatus) {
            $response["flag"] = true;

$response["message"] = "Approved Successfully";
        } else {
            $response["flag"] = false;

$response["error"] = "Something Went Wrong";
        }

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

public function memberReject(Request $request)
    {
        // dd($request->all());

$updateStatus = \App\MembershipDetail::where("id", $request->id)
            ->where("is_active", 1)
            ->update([
                "approval_status" => "Rejected",
                "remark" => $request->remark,
            ]);

if ($updateStatus) {
            $response["flag"] = true;

$response["message"] = "Reject Successfully";
        } else {
            $response["flag"] = false;

$response["error"] = "Something Went Wrong";
        }

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

public function getUserSection()
    {
        $data = [];

$data["page"] = "User Assign Sections";

$data["all_users"] = \App\User::where("role_id", 2)
            ->where("is_active", 1)
            ->get();

$sections = \DB::table("form_sections")
            ->where("is_active", 1)
            ->get();

$data["all_bmc"] = \DB::table("mcc")
            ->where("is_active", 1)
            ->get();

if (!is_null($sections)) {
            $data["sections"] = $sections;
        } else {
            $data["sections"] = "";
        }

return view("admin.master.user-assign-section", $data);
    }

public function updateUserSection(Request $request)
    {
        // dd($request->all());

$response = [];

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

[
                "user_id" => "required",

"bmc" => "required_without:sections",

"sections" => "required_without:bmc",
            ],

[
                "user_id.required" => "Selete User",

"bmc.required_without" => "Select atleast One BMC.",

"sections.required_without" => "Select atleast one Section.",
            ]
        );

if ($validator->fails()) {
            $response["flag"] = 2;

$response["error"] = $validator->getMessageBag();
        } else {
            $user = \App\User::where("id", $request->user_id)->first();

if (!is_null($user)) {
                if (isset($request->sections)) {
                    $sections = implode(",", $request->sections);

$user->assigned_sections = $sections;
                }

if (isset($request->bmc)) {
                    $bmc = implode(",", $request->bmc);

$user->assigned_mcc = $bmc;
                }

if ($user->save()) {
                    $response["flag"] = true;

$response["message"] = " Assigned Successfully";
                } else {
                    $response["flag"] = false;

$response["error"] = "Something Went Wrong";
                }
            } else {
                $response["flag"] = false;

$response["error"] = "User not Exist.";
            }
        }

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

public function getMppByMcc(Request $request)
    {
        $mcc = \DB::table("mcc")
            ->where("code", $request->mcc_name)
            ->where("is_active", 1)
            ->first();

$mpp = \DB::table("mpp")
            ->where("mcc_code", $mcc->code)
            ->where("is_active", 1)
            ->get();

if ($mpp) {
            $response["flag"] = true;

$response["mcc"] = $mcc;

$response["mpp"] = $mpp;
        } else {
            $response["flag"] = false;

$response["error"] = "Something Went Wrong";
        }

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

public function getAllByMpp(Request $request)
    {
        $mcc = \DB::table("mcc")
            ->where("name", $request->mcc_name)
            ->where("is_active", 1)
            ->first();

$mpp = \DB::table("mpp")
            ->where("name", $request->mpp_name)
            ->where("is_active", 1)
            ->first();

$all = \DB::table("master")
            ->where("mcc_code", $mcc->code)
            ->where("mpp_code", $mpp->code)
            ->where("is_active", 1)
            ->first();

if ($all) {
            $response["flag"] = true;

$response["mpp"] = $all;
        } else {
            $response["flag"] = false;

$response["error"] = "Something Went Wrong";
        }

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

public function manageUser()
    {
        $data["page"] = "Users";

if (\Auth::user()->role_id == "1") {
            $data["users"] = \App\User::where("is_active", 1)->get();
        } else {
            $data["users"] = \App\User::where("id", \Auth::user()->id)
                ->where("is_active", 1)
                ->get();
        }

return view("admin.master.mange-user", $data);
    }

public function forceLogout(Request $request)
    {
        // 	  dd($request->all());

$user_data = \App\User::where("id", $request->user_id)
            ->where("is_active", 1)
            ->get();

if (count($user_data) > 0) {
            $updateStatus = \App\User::where("id", $request->user_id)->update([
                "api_token" => null,
            ]);

if ($updateStatus) {
                $response["flag"] = true;

$response["message"] =
                    $request->name . "'s Device Log Out Successfully.";
            } else {
                $response["flag"] = false;

$response["error"] = "Something Went Wrong Or already clear.";
            }
        }

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

public function userChangeVersion(Request $request)
    {
        // 	  dd($request->all());

$response = [];

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

[
                "user_id" => "required",

"version" => "required",
            ]
        );

if ($validator->fails()) {
            $response["flag"] = false;

$response["errors"] = $validator->getMessageBag();
        } else {
            $user = \App\User::where("id", $request->user_id)
                ->where("is_active", 1)
                ->first();

// 			dd($membershipDetail);

if (is_null($user)) {
                $response["flag"] = false;

$response["errors"] = "User Not found";
            } else {
                //   dd('dasd');

$user->app_version = $request->version;

if ($user->save()) {
                    $response["flag"] = true;

$response["message"] = "App Version Changed Successfully";
                } else {
                    $response["flag"] = false;

$response["errors"] = "Something Went Wrong";
                }
            }
        }

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

public function allForceLogout()
    {
        $updateStatus = \App\User::where("role_id", 3)->update([
            "api_token" => null,
        ]);

if ($updateStatus) {
            $response["flag"] = true;

$response["message"] = "Log Out Successfully.";
        } else {
            $response["flag"] = false;

$response["error"] = "Something Went Wrong Or already clear.";
        }

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

public function downloadAssignedMpp(Request $request)
    {
        return Excel::download(
            new ExportAssignedMpp($request->user_id),
            "AssignedMpp.xlsx"
        );
    }

public function importAssignedMpp(Request $request)
    {
        $response = [];

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

[
                "mpp_file" => "required",
            ]
        );

if ($validator->fails()) {
            $response["flag"] = false;

$response["error"] = $validator->getMessageBag();
        } else {
            if ($request->mpp_file != "undefined") {
                $extension = \File::extension(
                    $request->file("mpp_file")->getClientOriginalName()
                );

if (
                    $extension == "xlsx" ||
                    $extension == "xls" ||
                    $extension == "csv"
                ) {
                    $import = new \App\Imports\ImportMpp($request->user_id);

$data1 = \Excel::import(
                        $import,
                        $request->file("mpp_file")
                    );

$mpp_not_found = $import->mppNotFound();

$mpp_not_found = implode(",", $mpp_not_found);

$response["flag"] = true;

$response["message"] = "Mpp  added Successfully.";
                } else {
                    $response["flag"] = false;

$response["error"] = "Invalid File type";
                }
            } else {
                $response["flag"] = false;

$response["error"] = "Please Select File.";
            }
        }

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

public function assignToUser($id)
    {
        $data["page"] = "Assign To User";

$data["mcc"] = \DB::table("mcc")
            ->where("is_active", 1)
            ->get();

$data["assign_users"] = \App\AssignUser::select(
            "assign_users.*",
            "users.name",
            "mcc.name as mcc_name"
        )
            ->join("users", "users.id", "assign_users.user_id")
            ->join("mcc", "mcc.code", "assign_users.mcc_code")
            ->where("assign_users.is_active", 1)
            ->where("assign_users.user_id", $id)
            ->get();

return view("admin.master.assign", $data, compact("id"));
    }

public function addAssignToUser(Request $request)
    {
        // dd($request->all());

$response = [];

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

[
                "mcc_name" => "required",

"mpp_name" => "required",

"user_id" => "required",
            ]
        );

if ($validator->fails()) {
            $response["flag"] = false;

$response["error"] = $validator->getMessageBag();
        } else {
            $user = \App\User::where("id", $request->user_id)->first();

if ($user->role_id == 3) {
                $data = \App\AssignUser::where("mcc_code", $request->mcc_name)
                    ->where("user_id", $request->user_id)
                    ->where("is_active", 1)
                    ->first();

if (is_null($data)) {
                    $asign = new \App\AssignUser();

$asign->user_id = $request->user_id;

$asign->mcc_code = $request->mcc_name;

$mpp = implode(",", $request->mpp_name);

$asign->mpp_code = $mpp;

if ($asign->save()) {
                        $response["flag"] = true;

$response["message"] = " Assign Successfully";
                    } else {
                        $response["flag"] = false;

$response["error"] = "Something Went Wrong";
                    }
                } else {
                    //  $mppArr = explode(',', $data->mpp_code);

//  if(in_array(, $mppArr)) {

//  }

$response["flag"] = false;

$response["error"] =
                        $data->mcc_code . " ,Already Assigned To User";
                }
            } else {
                $response["error"] = "User is not Authorized.";

$response["flag"] = false;
            }
        }

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

public function removeAssignToUser($id)
    {
        $response = [];

$role = \App\AssignUser::where("id", $id)
            ->where("is_active", 1)
            ->first();

if (is_null($role)) {
            $response["flag"] = false;

$response["message"] = "Not Found";
        } else {
            $role->is_active = 0;

if ($role->save()) {
                $response["flag"] = true;

$response["message"] = "Remove Successfully";
            } else {
                $response["flag"] = false;

$response["message"] = "Failed to delete";
            }
        }

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

public function allotForm($id)
    {
        $data["page"] = "Allot Form";

$data["max_allowed_sections"] = $this->max_allowed_sections;

$user_data = \App\User::select("name", "assigned_sections")
            ->where("id", $id)
            ->where("is_active", 1)
            ->first();

if (!is_null($user_data->assigned_sections)) {
            $assigned_sections = explode(",", $user_data->assigned_sections);

$data["assigned_sections"] = \DB::table("form_sections")
                ->whereIn("id", $assigned_sections)
                ->where("is_active", 1)
                ->get();

$data["assign_status"] = true;

$data["name"] = $user_data->name;
        } else {
            $data["assigned_sections"] = \DB::table("form_sections")
                ->where("is_active", 1)
                ->get();

$data["assign_status"] = false;

$data["name"] = "";
        }

$data["id"] = $id;

$data["districts"] = \App\MembershipDetail::select(
            "membership_details.mcc_code",
            "mcc.name"
        )
            ->join("mcc", "mcc.code", "membership_details.mcc_code")
            ->where("membership_details.is_active", 1)
            ->groupBy("mcc_code")
            ->get();

$data["forms"] = \App\MembershipDetail::where("is_active", 1)->get();

$data["allot_forms"] = \App\UserEditPermission::select(
            "user_edit_permissions.*",
            "membership_details.form_no",
            "users.name"
        )
            ->join(
                "membership_details",
                "membership_details.id",
                "user_edit_permissions.form_id"
            )
            ->join("users", "users.id", "user_edit_permissions.user_id")
            ->where("user_edit_permissions.is_active", 1)
            ->where("user_edit_permissions.user_id", $id)
            ->get();

return view("admin.master.allot-form", $data);
    }

public function getFormDistrictWise(Request $request)
    {
        $response = [];

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

[
                "mcc_code" => "required",
            ]
        );

if ($validator->fails()) {
            $response["flag"] = false;

$response["error"] = $validator->getMessageBag();
        } else {
            $form_numbers = \App\MembershipDetail::select("id", "form_no")
                ->where("is_active", 1)
                ->whereIn("mcc_code", $request->mcc_code)
                ->where("final_approval_status", null)
                ->get();

$finalModuleArr = [];

if (!$form_numbers->isEmpty()) {
                foreach ($form_numbers as $key => $form_no) {
                    $form_data = \App\UserEditPermission::where(
                        "form_id",
                        $form_no->id
                    )->get();

if (!$form_data->isEmpty()) {
                        $modules = [];

$finalModuleArrInt = [];

foreach ($form_data as $key => $form) {
                            array_push(
                                $modules,
                                explode(",", $form->module_id)
                            );
                        }

$finalModuleArrInt = call_user_func_array(
                            "array_merge",
                            $modules
                        );

if (
                            count($finalModuleArrInt) <
                            $this->max_allowed_sections
                        ) {
                            array_push($finalModuleArr, [
                                "form_id" => $form_no->id,
                                "form_no" => $form_no->form_no,
                            ]);
                        }
                    } else {
                        array_push($finalModuleArr, [
                            "form_id" => $form_no->id,
                            "form_no" => $form_no->form_no,
                        ]);
                    }
                }
            }

$response["districts"] = $finalModuleArr;

$response["flag"] = true;
        }

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

public function addAllotForm(Request $request)
    {
        //status = 0 - validation error

//status = 1 - success

//status = 2 - normal error

$response = [];

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

[
                "form_id" => "required",

"module_id" => "required",

"user_id" => "required",
            ]
        );

if ($validator->fails()) {
            $response["status"] = 0;

$response["error"] = $validator->getMessageBag();
        } else {
            $user = \App\User::where("id", $request->user_id)->first();

if ($user->role_id == 2) {
                $final_msg = "";

$flag = true;

$max_allocation_flag = false;

$max_allocation_msg = "";

$agn_mod_form = "";

$assigned_modules = "";

$assigned_flag = false;

$formIdArrExt = $request->form_id;

$moduleArrExt = $request->module_id;

foreach ($formIdArrExt as $key => $form_id) {
                    $forms_allotted = \App\UserEditPermission::where(
                        "form_id",
                        $form_id
                    )
                        ->where("is_active", 1)
                        ->get();

$finalModuleArrInt = [];

$matchArr = [];

if (!$forms_allotted->isEmpty()) {
                        $moudelArrInt = [];

foreach ($forms_allotted as $key => $value) {
                            array_push(
                                $moudelArrInt,
                                explode(",", $value->module_id)
                            );
                        }

$finalModuleArrInt = call_user_func_array(
                            "array_merge",
                            $moudelArrInt
                        );

//get setions values which are already assigned

$matchArr = array_intersect(
                            $finalModuleArrInt,
                            $moduleArrExt
                        );

if (count($matchArr) > 0) {
                            $agn_mod_form .= $form_id . ",";

$assigned_modules = implode(",", $matchArr);

$assigned_flag = true;

$flag = false;
                        }
                    }

//code to check max allocated modules limit

if (
                        count($finalModuleArrInt) + count($moduleArrExt) >
                        $this->max_allowed_sections
                    ) {
                        $max_allocation_msg .= $form_id . ",";

$max_allocation_flag = true;

$flag = false;
                    }
                }

// moudle assigning process

if ($flag) {
                    try {
                        \DB::beginTransaction();

foreach ($request->form_id as $key => $form_id) {
                            $data = \App\UserEditPermission::where(
                                "form_id",
                                $form_id
                            )
                                ->where("user_id", $request->user_id)
                                ->where("is_active", 1)
                                ->first();

if (is_null($data)) {
                                $asign = new \App\UserEditPermission();

$asign->user_id = $request->user_id;

//$forms=implode(",",$request->form_id);

$asign->form_id = $form_id;

$modules = implode(",", $request->module_id);

$asign->update_status = "Pending";

$asign->module_id = $modules;

if ($asign->save()) {
                                    $member = \App\MembershipDetail::find(
                                        $form_id
                                    );

$member->ao_approval_status = "Pending";

$member->save();
                                }
                            } else {
                                $modules = implode(",", $request->module_id);

$data->module_id =
                                    $data->module_id . "," . $modules;

if ($data->update_status == "Pending") {
                                    $data->update_status = "Pending";
                                } else {
                                    $data->update_status = "Processing";

$member = \App\MembershipDetail::find(
                                        $form_id
                                    );

$member->ao_approval_status = "Processing";

$member->save();
                                }

$data->save();
                            }
                        }

\DB::commit();

$response["message"] = "Section Alotted successfully";

$response["status"] = 1;
                    } catch (\Exception $exp) {
                        \DB::rollBack();

$response["error"] = $exp->getMessage();

$response["status"] = 2;
                    }
                } else {
                    if ($max_allocation_flag) {
                        $max_allocation_msg = rtrim($max_allocation_msg, ",");

$max_allocation_msg = explode(",", $max_allocation_msg);

$form_no = \App\MembershipDetail::whereIn(
                            "id",
                            $max_allocation_msg
                        )->pluck("form_no");

$final_msg .=
                            " Form No " .
                            $form_no .
                            " has only " .
                            $this->max_allowed_sections .
                            " sections allowed.\n";
                    }

if ($assigned_flag) {
                        $assigned_modules = rtrim($assigned_modules, ",");

$agn_mod_form = rtrim($agn_mod_form, ",");

$agn_mod_form = explode(",", $agn_mod_form);

$agn_mod_form = \App\MembershipDetail::whereIn(
                            "id",
                            $agn_mod_form
                        )->pluck("form_no");

$final_msg .=
                            "Section " .
                            $assigned_modules .
                            " already assigned to Form " .
                            $agn_mod_form .
                            ".";
                    }

$response["status"] = 2;

$response["error"] = $final_msg;
                }
            } else {
                $response["error"] = "This user is not Authorized.";

$response["status"] = 2;
            }
        }

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

public function deactivateUSer(Request $request)
    {
        // dd($request->all());

$user_data = \App\User::where("id", $request->user_id)
            ->where("is_active", 1)
            ->get();

if (count($user_data) > 0) {
            $updateStatus = \App\User::where("id", $request->user_id)->update([
                "is_active" => "0",
                "api_token" => null,
            ]);

if ($updateStatus) {
                $response["flag"] = true;

$response["message"] = "Deactivated Successfully";
            } else {
                $response["flag"] = false;

$response["error"] = "Something Went Wrong";
            }
        } else {
            $updateStatus = \App\User::where("id", $request->user_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 clearUserDeviceId(Request $request)
    {
        // 	  dd($request->all());

$user_data = \App\User::where("id", $request->user_id)
            ->where("is_active", 1)
            ->get();

if (count($user_data) > 0) {
            $updateStatus = \App\User::where("id", $request->user_id)->update([
                "imei_no" => null,
            ]);

if ($updateStatus) {
                $response["flag"] = true;

$response["message"] =
                    $request->name .
                    "'s device ID has been cleared successfully.";
            } else {
                $response["flag"] = false;

$response["error"] = "Something Went Wrong Or already clear.";
            }
        }

// 	   }else{

// 	   	$updateStatus = \App\User::where('id', $request->user_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 userChangePassword(Request $request)
    {
        // 	  dd($request->all());

$response = [];

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

[
                "user_id" => "required",

"password" => "required",

"con_password" => "required|same:password",
            ]
        );

if ($validator->fails()) {
            $response["flag"] = false;

$response["errors"] = $validator->getMessageBag();
        } else {
            $user = \App\User::where("id", $request->user_id)
                ->where("is_active", 1)
                ->first();

// 			dd($membershipDetail);

if (is_null($user)) {
                $response["flag"] = false;

$response["errors"] = "User Not found";
            } else {
                //   dd('dasd');

$user->plain_password = $request->password;

$user->password = \Hash::make($request->password);

if ($user->save()) {
                    $response["flag"] = true;

$response["message"] = "Password Changed Successfully";
                } else {
                    $response["flag"] = false;

$response["errors"] = "Something Went Wrong";
                }
            }
        }

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

public function userSignUpload(Request $request)
    {
        // 	  dd($request->all());

$response = [];

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

[
                "user_id" => "required",

"sign" => "required",
            ]
        );

if ($validator->fails()) {
            $response["flag"] = false;

$response["errors"] = $validator->getMessageBag();
        } else {
            $user = \App\User::where("id", $request->user_id)
                ->where("is_active", 1)
                ->first();

// 			dd($membershipDetail);

if (is_null($user)) {
                $response["flag"] = false;

$response["errors"] = "User Not found";
            } else {
                if (!is_null($user)) {
                    $user_id = $user->id + 1;
                } else {
                    $user_id = 1;
                }

$name = strtolower($user->name);

$name = str_replace(" ", "_", $name);

$final_name = $user_id . "_" . $name;

if ($request->sign) {
                    $sign = $final_name . "sign." . $request->sign->extension();

$request->sign->move(public_path("user_sign"), $sign);

$user->Signature = "/user_sign/" . $sign;
                }

if ($user->save()) {
                    $response["flag"] = true;

$response["message"] = "Sign Uploaded Successfully";
                } else {
                    $response["flag"] = false;

$response["errors"] = "Something Went Wrong";
                }
            }
        }

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

// 	public function formList()

// 	{

//     	$data['page'] = 'Form List';

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

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

//     	}else{

// 	        $data['members'] = \App\MembershipDetail::where('created_by_id', \Auth::user()->id)->where('is_active', 1)->where('final_approval_status', 'Approved')->get();

//     	}

// 		return view('admin.master.form-list', $data);

// 	}

public function formList(Request $request)
    {
        $data["page"] = "Form List";

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

$data["mcc"] = \DB::table("mcc")
            ->where("is_active", 1)
            ->get();
                $today = date('Y-m-d');
                $endDate = date('Y-m-d', strtotime('-7 days'));
        $data["members"] = \App\MembershipDetail::where("is_active", 1)->whereBetween(DB::raw("date(membership_details.final_approval_date)"),[$endDate, $today])->where("final_approval_status", "Approved")->orderBy("id", "desc")->get();
      
      
        if ($request->isMethod("post")) {
        
            $validator = \Validator::make($request->all(),["from_date" => "required_with:to_date","to_date" => "nullable|after_or_equal:from_date"],
                [
                    "from_date.required_with" =>
                        "The 'From Date' field is required when 'To Date' is present.",

"to_date.after_or_equal" =>
                        "'To Date' must not be less than 'From Date'",
                ]
            );

if ($validator->fails()) {
                return redirect()
                    ->back()
                    ->withErrors($validator)
                    ->withInput();
            } else {
                $from = $request->from_date;

$to = $request->to_date;
                
                $mcc = $request->mcc_code;

$currentDate = date("Y-m-d");
                $query = \App\MembershipDetail::query();

if (!empty($from) && !empty($to) && empty($mcc)) {$query->whereBetween(DB::raw("date(final_approval_date)"), [$from,$to,]);

$data["fromDate"] = $from;

$data["toDate"] = $to;
                }
                if (!empty($from) && !empty($to) && !empty($mcc)) {$query->whereBetween(DB::raw("date(final_approval_date)"), [$from,$to,])->where('mcc_code', $mcc);

$data["fromDate"] = $from;

$data["toDate"] = $to;
                    
                    $data["mcc_code"] = $mcc;
                }
                
                 if (empty($from) && empty($to) && !empty($mcc)) {$query->where('mcc_code', $mcc);

$data["mcc_code"] = $mcc;
                }

if (!empty($from) && empty($to) && empty($mcc)) {$query->whereBetween(DB::raw("date(final_approval_date)"), [$from,$currentDate]);

$data["fromDate"] = $from;
                }
                if (!empty($from) && empty($to) && !empty($mcc)) {$query->whereBetween(DB::raw("date(final_approval_date)"), [$from,$currentDate])->where('mcc_code', $mcc);

$data["fromDate"] = $from;
                    $data["mcc_code"] = $mcc;
                }

if ($request->mc_fn) {
                    if ($request->mc_fn == "MemberCode") {
                        $query->where("member_code", "!=", null);

$data["memberCodeFolio"] = $request->mc_fn;
                    }

if ($request->mc_fn == "NonMemberCode") {
                        $query->where("member_code", null);

$data["memberCodeFolio"] = $request->mc_fn;
                    }

if ($request->mc_fn == "FolioNumber") {
                        $query->where("folio_number", "!=", null);

$data["memberCodeFolio"] = $request->mc_fn;
                    }

if ($request->mc_fn == "NonFolioNumber") {
                        $query->where("folio_number", null);

$data["memberCodeFolio"] = $request->mc_fn;
                    }
                }

$data["members"] = $query
                    ->where("is_active", 1)
                    ->where("final_approval_status", "Approved")
                    ->orderBy("id", "desc")
                    ->get();
            }
        }

return view("admin.master.form-list", $data);
    }

// 	public function exportFormList(Request $request){

//         return Excel::download(new ExportFormList, 'FormList.xlsx');

//     }

//     public function exportOtherFormList(Request $request){

//         return Excel::download(new ExportOtherFormList, 'OtherFormList.xlsx');

//     }

//     public function exportHouseMemberList(Request $request){

//         return Excel::download(new ExportHouseMemberList, 'HouseMemberList.xlsx');

//     }

//     public function exportBankDetail(Request $request){

//         return Excel::download(new ExportBankDetail, 'BankDetail.xlsx');

//     }

//     public function exportMilkdetail(Request $request){

//         return Excel::download(new ExportMilkDetail, 'MilkDetail.xlsx');

//     }

public function exportFormList(Request $request)
    {
        //dd($request->all());

return Excel::download(
            new ExportFormList(
                $request->from_date,
                $request->to_date,
                $request->mc_fn
            ),
            "FormList.xlsx"
        );
    }

public function exportOtherFormList(Request $request)
    {
        return Excel::download(
            new ExportOtherFormList(
                $request->from_date,
                $request->to_date,
                $request->mc_fn
            ),
            "OtherFormList.xlsx"
        );
    }

public function exportHouseMemberList(Request $request)
    {
        return Excel::download(
            new ExportHouseMemberList(
                $request->from_date,
                $request->to_date,
                $request->mc_fn
            ),
            "HouseMemberList.xlsx"
        );
    }

public function exportBankDetail(Request $request)
    {
        return Excel::download(
            new ExportBankDetail(
                $request->from_date,
                $request->to_date,
                $request->mc_fn
            ),
            "BankDetail.xlsx"
        );
    }

public function exportMilkdetail(Request $request)
    {
        return Excel::download(
            new ExportMilkDetail(
                $request->from_date,
                $request->to_date,
                $request->mc_fn
            ),
            "MilkDetail.xlsx"
        );
    }

public function exportGeneralFormat(Request $request)
    {
        // dd($request->all());

return Excel::download(
            new ExportGeneralFormat(
                $request->from_date,
                $request->to_date,
                $request->mc_fn
            ),
            "GeneralFormat.xlsx"
        );
    }

public function exportMemberCodeFormat(Request $request)
    {
        // dd($request->all());

return Excel::download(new ExportMCF(), "ImportMemberCode.xlsx");
    }

public function exportFolioNumberFormat(Request $request)
    {
        // dd($request->all());

return Excel::download(new ExportFNF(), "ImportFolioNumber.xlsx");
    }

public function memberCodeAndFolio()
    {
        $data["page"] = "Member Code & Folio Number";

return view("admin.master.import-member-code-and-folio", $data);
    }

public function importMemberCode(Request $request)
    {
        // dd($request->all());

$response = [];

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

[
                "file" => "required",
            ]
        );

if ($validator->fails()) {
            $response["flag"] = false;

$response["error"] = $validator->getMessageBag();
        } else {
            $extension = \File::extension(
                $request->file("file")->getClientOriginalName()
            );

if (
                $extension == "xlsx" ||
                $extension == "xls" ||
                $extension == "csv"
            ) {
                $import = new \App\Imports\MemberCodeImport();

$data1 = \Excel::import($import, $request->file("file"));

$not_found = $import->memberShipNotFoundId();

$found = $import->memberShipFoundId();

$memberShipNotFoundId = implode(",", $not_found);

$memberShipFoundId = implode(",", $found);

$response["flag"] = true;

$response["message"] =
                    "These Form Number Member Code Imported Successfully   ( " .
                    $memberShipFoundId .
                    ") And These Form Number Not Exist In List ( " .
                    $memberShipNotFoundId .
                    " )";
            } else {
                $response["flag"] = false;

$response["error"] = "Invalid File type";
            }
        }

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

public function importFolioNumber(Request $request)
    {
        // dd($request->all());

$response = [];

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

[
                "file" => "required",
            ]
        );

if ($validator->fails()) {
            $response["flag"] = false;

$response["error"] = $validator->getMessageBag();
        } else {
            $extension = \File::extension(
                $request->file("file")->getClientOriginalName()
            );

if (
                $extension == "xlsx" ||
                $extension == "xls" ||
                $extension == "csv"
            ) {
                $import = new \App\Imports\FolioNumberImport();

$data1 = \Excel::import($import, $request->file("file"));

$not_found = $import->memberShipNotFoundId();

$found = $import->memberShipFoundId();

$memberShipNotFoundId = implode(",", $not_found);

$memberShipFoundId = implode(",", $found);

$response["flag"] = true;

$response["message"] =
                    "These Form Number Folio Number Imported Successfully   ( " .
                    $memberShipFoundId .
                    ") And These Member Code Not Exist In List ( " .
                    $memberShipNotFoundId .
                    " )";
            } else {
                $response["flag"] = false;

$response["error"] = "Invalid File type";
            }
        }

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

//     public function printForm($id)

// 	{

// 		$data['page'] = 'Hindi Print Form';

//     	$data['member'] = \App\MembershipDetail::where('id', $id)->where('is_active', 1)->first();

// 		return view('admin.master.print-form', $data);

// 	}

public function printForm($id)
    {
        $data["page"] = "Hindi Print Form";

$data["member"] = \App\MembershipDetail::select(
            "membership_details.*",
            "users.signature",
            "user_edit_permissions.updated_at as user_app_date",
            "master.mcc_name as mccname",
            "master.mcc_code as mcccode",
            "master.mpp_name as mppname",
            "master.mpp_code as mppcode"
        )
            ->leftJoin("users", "users.id", "membership_details.created_by_id")
            ->leftJoin(
                "user_edit_permissions",
                "user_edit_permissions.form_id",
                "membership_details.id"
            )
            ->join("master", function ($join) {
                $join->on("master.mpp_name", "membership_details.mpp_name");

$join->on("master.mcc_name", "membership_details.mcc_name");
            })
            ->where("membership_details.id", $id)
            ->where("membership_details.is_active", 1)
            ->where("master.is_active", 1)
            ->first();

$area_officer = \App\User::select("id", "assigned_mcc")
            ->where("is_active", 1)
            ->where("role_type", 1)
            ->get();

if (!$area_officer->isEmpty()) {
            $mcc_user_id = "";

foreach ($area_officer as $key => $user) {
                $mcc = explode(",", $user->assigned_mcc);

if (in_array($data["member"]->mcc_code, $mcc)) {
                    $mcc_user_id = $user->id;
                }
            }
        }

$data["area_officer"] = \App\User::where("role_id", 2)
            ->where("role_type", 1)
            ->where("id", $mcc_user_id)
            ->where("is_active", 1)
            ->first();

$data["finance"] = \App\User::where("role_id", 2)
            ->where("role_type", 3)
            ->where("is_active", 1)
            ->first();

$data["leagal"] = \App\User::where("role_id", 2)
            ->where("role_type", 2)
            ->where("is_active", 1)
            ->first();

// 	dd($data);

// return view('admin.master.print-form', $data);

return view("admin.master.print-form-new", $data);
    }

// 	public function allPrintForm()

// 	{

// 		$data['page'] = 'All Print Form';

//     	$data['members'] = \App\MembershipDetail::where('final_approval_status', 'Approved')->whereNotNull('final_approval_status')->where('is_active', 1)->get();

// 		return view('admin.master.all-print-form', $data);

// 	}

// 	public function allPrintForm()

// 	{

// 		$data['page'] = 'All Print Form';

//     	$data['members'] = \App\MembershipDetail::select('membership_details.*','users.signature','user_edit_permissions.updated_at as user_app_date')->leftJoin('users','users.id','membership_details.created_by_id')->leftJoin("user_edit_permissions","user_edit_permissions.form_id","membership_details.id")->where('membership_details.final_approval_status', 'Approved')->whereNotNull('membership_details.final_approval_status')->where('membership_details.is_active', 1)->get();

// 		return view('admin.master.all-print-form', $data);

// 	}

//  public function allPrintForm(Request $request)

//     {

//         // dd($request->all());

//         $data['page'] = 'All Print Form';

//         if($request->isMethod('post')){

//             $query = \App\MembershipDetail::query();

//             if(!empty($request->date1) && !empty($request->date2)){

//                 $query->whereBetween(DB::raw('date(membership_details.updated_at)'),[$request->date1,$request->date2]);

//             }

//             if(!empty($request->date1) && empty($request->date2)){

//                 $query->whereBetween(DB::raw('date(membership_details.updated_at)'),[$request->date1,date('Y-m-d')]);

//             }

//             if($request->mc_fn_print){

//             if($request->mc_fn_print=='MemberCode'){

//                 $query->where('membership_details.member_code','!=',null);

//             }

//             if($request->mc_fn_print=='NonMemberCode'){

//                 $query->where('membership_details.member_code',null);

//             }

//             if($request->mc_fn_print=='FolioNumber'){

//                 $query->where('membership_details.folio_number','!=',null);

//             }

//             if($request->mc_fn_print=='NonFolioNumber'){

//                 $query->where('membership_details.folio_number',null);

//             }

//             $data['members'] = $query->select('membership_details.*','users.signature','user_edit_permissions.updated_at as user_app_date','user_edit_permissions.user_id','master.mcc_name as mccname','master.mcc_code as mcccode','master.mpp_name as mppname','master.mpp_code as mppcode')->leftJoin('users','users.id','membership_details.created_by_id')->leftJoin("user_edit_permissions","user_edit_permissions.form_id","membership_details.id")->join('master', function($join){

//                 $join->on('master.mpp_name', 'membership_details.mpp_name');

//                 $join->on('master.mcc_name', 'membership_details.mcc_name');

//             })->where('membership_details.is_active', 1)->where('master.is_active', 1)->where('user_edit_permissions.is_active', 1)->where('membership_details.final_approval_status', 'Approved')->orderBy('membership_details.id','desc')->get();

//             $data['finance'] = \App\User::where('role_id', 2)->where('role_type', 3)->where('is_active', 1)->first();

//     	    $data['leagal'] = \App\User::where('role_id', 2)->where('role_type', 2)->where('is_active', 1)->first();

//             // dd($data['members'] );

//         }

//         return view('admin.master.all-english-print-form', $data);

//     }

public function allPrintForm(Request $request)
    {
        // dd($request->all());

$data["page"] = "All Print Form";

if ($request->isMethod("post")) {
            $query = \App\MembershipDetail::query();

if (!empty($request->date1) && !empty($request->date2) && empty($request->mcc)) {
                $query->whereBetween(
                    DB::raw("date(membership_details.final_approval_date)"),
                    [$request->date1, $request->date2]
                );
            }
            if (!empty($request->date1) && !empty($request->date2) && !empty($request->mcc)) {
                $query->whereBetween(
                    DB::raw("date(membership_details.final_approval_date)"),
                    [$request->date1, $request->date2]
                )->where('mcc_code', $request->mcc);
            }
            if (empty($request->date1) && empty($request->date2) && !empty($request->mcc)) {
                $query->where('mcc_code', $request->mcc);
            }
            if (!empty($request->date1) && empty($request->date2) && empty($request->mcc)) {
                $query->whereBetween(
                    DB::raw("date(membership_details.final_approval_date)"),
                    [$request->date1, date("Y-m-d")]
                );
            }
            if (!empty($request->date1) && empty($request->date2) && !empty($request->mcc)) {
                $query->whereBetween(
                    DB::raw("date(membership_details.final_approval_date)"),
                    [$request->date1, date("Y-m-d")]
                )->where('mcc_code', $request->mcc);
            }
            if (empty($request->date1) && empty($request->date2) && empty($request->mcc)) {
                $today = date('Y-m-d');
                $endDate = date('Y-m-d', strtotime('-7 days'));
                $query->whereBetween(
                    DB::raw("date(membership_details.final_approval_date)"),
                    [$endDate, $today]
                );
            }

if ($request->mc_fn_print) {
                if ($request->mc_fn_print == "MemberCode") {
                    $query->where("membership_details.member_code", "!=", null);
                }

if ($request->mc_fn_print == "NonMemberCode") {
                    $query->where("membership_details.member_code", null);
                }

if ($request->mc_fn_print == "FolioNumber") {
                    $query->where(
                        "membership_details.folio_number",
                        "!=",
                        null
                    );
                }

if ($request->mc_fn_print == "NonFolioNumber") {
                    $query->where("membership_details.folio_number", null);
                }
            }

$members = $query
                ->select(
                    "membership_details.*",
                    "users.signature",
                    "user_edit_permissions.updated_at as user_app_date",
                    "user_edit_permissions.user_id"
                )
                ->leftJoin(
                    "users",
                    "users.id",
                    "membership_details.created_by_id"
                )
                ->leftJoin(
                    "user_edit_permissions",
                    "user_edit_permissions.form_id",
                    "membership_details.id"
                )
                ->where("membership_details.is_active", 1)
                ->where("user_edit_permissions.is_active", 1)
                ->where("membership_details.final_approval_status", "Approved")
                ->orderBy("membership_details.id", "desc")
                ->get();

$newData = [];

foreach ($members as $k => $md) {
                $temp = [];

$area_officer = \App\User::select("id", "assigned_mcc")
                    ->where("is_active", 1)
                    ->where("role_type", 1)
                    ->get();

if (!$area_officer->isEmpty()) {
                    $mcc_user_id = "";

foreach ($area_officer as $key => $user) {
                        $mcc = explode(",", $user->assigned_mcc);

if (in_array($md->mcc_code, $mcc)) {
                            $mcc_user_id = $user->id;
                        }
                    }
                }

$area_officer = \App\User::where("role_id", 2)
                    ->where("role_type", 1)
                    ->where("id", $mcc_user_id)
                    ->where("is_active", 1)
                    ->first();

$md["ao_sign"] = $area_officer["signature"];

$md["ao_name"] = $area_officer["name"];

$newData[] = $md;
            }

$data["members"] = $newData;

$data["finance"] = \App\User::where("role_id", 2)
                ->where("role_type", 3)
                ->where("is_active", 1)
                ->first();

$data["leagal"] = \App\User::where("role_id", 2)
                ->where("role_type", 2)
                ->where("is_active", 1)
                ->first();
        }

return view("admin.master.all-english-print-form", $data);
    }

public function printSomePages(Request $request)
    {
        // dd($request->all());

$data["page"] = "Print Some Page";

if ($request->isMethod("post")) {
            $query = \App\MembershipDetail::query();

if (!empty($request->date1) && !empty($request->date2)) {
                $query->whereBetween(
                    DB::raw("date(membership_details.updated_at)"),
                    [$request->date1, $request->date2]
                );
            }

if (!empty($request->date1) && empty($request->date2)) {
                $query->whereBetween(
                    DB::raw("date(membership_details.updated_at)"),
                    [$request->date1, date("Y-m-d")]
                );
            }

if ($request->mc_fn_print) {
                if ($request->mc_fn_print == "MemberCode") {
                    $query->where("membership_details.member_code", "!=", null);
                }

if ($request->mc_fn_print == "NonMemberCode") {
                    $query->where("membership_details.member_code", null);
                }

if ($request->mc_fn_print == "NonFolioNumber") {
                    $query->where("membership_details.folio_number", null);
                }
            }

$data["members"] = $query
                ->select(
                    "membership_details.*",
                    "users.signature",
                    "user_edit_permissions.updated_at as user_app_date",
                    "user_edit_permissions.user_id"
                )
                ->leftJoin(
                    "users",
                    "users.id",
                    "membership_details.created_by_id"
                )
                ->leftJoin(
                    "user_edit_permissions",
                    "user_edit_permissions.form_id",
                    "membership_details.id"
                )
                ->where("membership_details.is_active", 1)
                ->where("user_edit_permissions.is_active", 1)
                ->where("membership_details.final_approval_status", "Approved")
                ->orderBy("membership_details.id", "desc")
                ->get();

$data["finance"] = \App\User::where("role_id", 2)
                ->where("role_type", 3)
                ->where("is_active", 1)
                ->first();

$data["leagal"] = \App\User::where("role_id", 2)
                ->where("role_type", 2)
                ->where("is_active", 1)
                ->first();

// dd($data['members'] );
        }

return view("admin.master.print-some-pages", $data);
    }

public function englishPrintForm($id)
    {
        $data["page"] = "English Print Form";

$area_officer = \App\User::select("id", "assigned_mcc")
            ->where("is_active", 1)
            ->where("role_type", 1)
            ->get();

if (!$area_officer->isEmpty()) {
            $mcc_user_id = "";

foreach ($area_officer as $key => $user) {
                $mcc = explode(",", $user->assigned_mcc);

if (in_array($data["member"]->mcc_code, $mcc)) {
                    $mcc_user_id = $user->id;
                }
            }
        }

$data["area_officer"] = \App\User::where("role_id", 2)
            ->where("role_type", 1)
            ->where("id", $mcc_user_id)
            ->where("is_active", 1)
            ->first();

$data["finance"] = \App\User::where("role_id", 2)
            ->where("role_type", 3)
            ->where("is_active", 1)
            ->first();

$data["leagal"] = \App\User::where("role_id", 2)
            ->where("role_type", 2)
            ->where("is_active", 1)
            ->first();

// 	dd($data);

return view("admin.master.english-print-form", $data);
    }

public function download()
    {
        $page = "Pdf";

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

// foreach ($data as $members) {

// $members['id']

$member = \App\MembershipDetail::where("id", 3)
            ->where("is_active", 1)
            ->first();

// Generate the HTML for the dynamic print page

// $html = View::make('admin.master.print-form', compact('member','page'))->render();

$pdf = PDF::loadView(
            "admin.master.print-in-bulk",
            compact("member", "page")
        ); // Load your view with the data and generate the PDF

//  dd($pdf);

return $pdf->download("file.pdf");

// }
    }

public function editMember($id)
    {
        $data["page"] = "Edit MembershipDetail";

$user_id = \Auth::user()->id;

$data["user_id"] = \Auth::user()->id;

$data["mcc"] = \DB::table("mcc")
            ->where("is_active", 1)
            ->get();

$data["members"] = \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", $id)
            ->where("user_edit_permissions.user_id", $user_id)
            ->where("membership_details.is_active", 1)
            ->first();

return view("admin.master.edit-member", $data);
    }

// public function rejectFormByUser(Request $request) {

//     $response = array();

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

// 		array(

// 			'member_id' =>'required',

// 			'user_id' => 'required',

// 			'module_id' => 'required'

// 		)

// 	);

// 	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'] = "Detail Not found";

// 		}else{

// 		    $user_data = \App\UserEditPermission::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->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);

// 		        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 )) {

// 		            $remark_data = json_decode($membershipDetail->remark, true);

// 		            array_push($finalArr, $remark_data);

// 		            array_push($finalArr, $remarkArr);

// 		            $membershipDetail->remark = json_encode($finalArr);

// 		        } else {

// 		            $membershipDetail->remark = json_encode($remarkArr);

// 		        }

// 		      $membershipDetail->ao_approval_status = $approval_status;

// 			    $membershipDetail->save();

// 		        $response['flag'] = true;

// 			    $response['message'] = "Rejected Successfully";

// 		    } else {

// 		        $response['flag'] = true;

// 			    $response['message'] = "User Permission Details Not Found.";

// 		    }

// 		}

// 	}

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

// }

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)
    {
        $data = \App\UserEditPermission::where("form_id", $form_id)->pluck(
            "update_status"
        );

$moudle_data = \App\UserEditPermission::where(
            "form_id",
            $form_id
        )->pluck("module_id");

$module_count = 0;

foreach ($moudle_data as $key => $value) {
            $a = explode(",", $value);

$module_count += count($a);
        }

$data = $data->toArray();

if ($module_count == $this->max_allowed_sections) {
            if (in_array("Processing", $data)) {
                $status = "Processing";
            } elseif (
                in_array("Pending", $data) &&
                in_array("Approved", $data)
            ) {
                $status = "Processing";
            } elseif (in_array("Pending", $data)) {
                $status = "Pending";
            } elseif (in_array("Rejected", $data)) {
                $status = "Rejected";
            } elseif (in_array("Approved", $data)) {
                $status = "Approved";
            }
        } else {
            if (in_array("Processing", $data)) {
                $status = "Processing";
            } elseif (
                in_array("Pending", $data) &&
                in_array("Approved", $data)
            ) {
                $status = "Processing";
            } elseif (in_array("Pending", $data)) {
                $status = "Pending";
            } elseif (in_array("Rejected", $data)) {
                $status = "Processing";
            } elseif (in_array("Approved", $data)) {
                $status = "Processing";
            }
        }

return $status;
    }

//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)) {
            \DB::table("legal_edit_permissions")->insert([
                "form_id" => $form_id,

"module_id" => $user->assigned_sections,

"user_id" => $user->id,

"update_status" => "Pending",
            ]);
        }
    }

public function updateMemberImage(Request $request)
    {
        //dd($request->all());

$validator = \Validator::make($request->all(), [
            "form_id" => "required",

"update_image" => "required",

"field_name" => "required",
        ]);

if ($validator->fails()) {
            $response["flag"] = false;

$response["errors"] = $validator->getMessageBag();
        } else {
            $updateMemberDetail = \App\MembershipDetail::where(
                "id",
                $request->form_id
            )->first();

if (!is_null($updateMemberDetail)) {
                $originalName = $request->update_image->getClientOriginalName();

$renamed_name = $request->field_name . "_" . $originalName;

if ($request->field_name == "aadhar_front_file") {
                    $request->update_image->move(
                        public_path("member_image/img_adhar/"),
                        $renamed_name
                    );

$updateMemberDetail->aadhar_front_file =
                        "img_adhar/" . $renamed_name;
                } elseif ($request->field_name == "aadhar_back_file") {
                    $request->update_image->move(
                        public_path("member_image/img_adhar/"),
                        $renamed_name
                    );

$updateMemberDetail->aadhar_back_file =
                        "img_adhar/" . $renamed_name;
                } elseif ($request->field_name == "pic_file") {
                    $request->update_image->move(
                        public_path("member_image/img_farmer/"),
                        $renamed_name
                    );

$updateMemberDetail->pic_file =
                        "img_farmer/" . $renamed_name;
                } elseif ($request->field_name == "Signature") {
                    $request->update_image->move(
                        public_path("member_image/img_sign/"),
                        $renamed_name
                    );

$updateMemberDetail->Signature =
                        "img_sign/" . $renamed_name;
                } elseif ($request->field_name == "passbook_file") {
                    $request->update_image->move(
                        public_path("member_image/img_passbook/"),
                        $renamed_name
                    );

$updateMemberDetail->passbook_file =
                        "img_passbook/" . $renamed_name;
                }

if ($updateMemberDetail->save()) {
                    $response["flag"] = true;

$response["message"] = "Changes Saved Successfully";
                } else {
                    $response["flag"] = false;

$response["message"] = "Something Went Wrong";
                }
            } else {
                $response["flag"] = false;

$response["message"] = "Something Went Wrong";
            }
        }

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

public function getEditMaster($id)
    {
        // dd($id);

$data["master"] = \DB::table("master")
            ->where("id", $id)
            ->where("is_active", 1)
            ->first();

return view("admin.master.edit-master", $data);
    }

public function getEditBankMaster($id)
    {
        // dd($id);

$data["master"] = \DB::table("bank_masters")
            ->where("id", $id)
            ->where("is_active", 1)
            ->first();

return view("admin.master.edit-bank-master", $data);
    }

public function updateMaster(Request $request)
    {
        // dd($request->all());

$response = [];

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

[
                "district_name" => "required",

"district_code" => "required",

"village_name" => "required",

"village_code" => "required",

"hamlet_name" => "required",

"hamlet_code" => "required",

"mcc_name" => "required",

// 'mcc_code' => 'required',

"mpp_name" => "required",

// 'mpp_code' => 'required',

"state_name" => "required",

"state_code" => "required",

"tehsil_name" => "required",

"tehsil_code" => "required",
            ]
        );

if ($validator->fails()) {
            $response["flag"] = false;

$response["errors"] = $validator->getMessageBag();
        } else {
            $master = \DB::table("master")
                ->where("id", $request->id)
                ->where("is_active", 1)
                ->first();

if (is_null($master)) {
                $response["flag"] = false;

$response["error"] = "Master Not found";
            } else {
                // $master->district_name = $request->district_name;

$data = \DB::table("master")
                    ->where("id", $request->id)
                    ->where("is_active", 1)
                    ->update([
                        "district_name" => $request->district_name,
                        "district_code" => trim($request->district_code),
                        "village_name" => $request->village_name,
                        "village_code" => trim($request->village_code),
                        "hamlet_name" => $request->hamlet_name,
                        "hamlet_code" => trim($request->hamlet_code),
                        "mcc_name" => $request->mcc_name,

// 'mcc_code' => trim($request->mcc_code),

"mpp_name" => $request->mpp_name,

// 'mpp_code' => trim($request->mpp_code),

"state_name" => $request->state_name,
                        "state_code" => trim($request->state_code),
                        "tehsil_name" => $request->tehsil_name,
                        "tehsil_code" => trim($request->tehsil_code),
                        "updated_by" => \Auth::user()->id,
                    ]);

if ($data) {
                    $response["flag"] = true;

$response["message"] = "Master Updated Successfully";
                } else {
                    $response["flag"] = false;

$response["error"] = "Something Went Wrong";
                }
            }
        }

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

public function updateBankMaster(Request $request)
    {
        // dd($request->all());

$response = [];

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

[
                "bank_name" => "required",

"ifsc_code" => "required",

"branch" => "required",
            ]
        );

if ($validator->fails()) {
            $response["flag"] = false;

$response["errors"] = $validator->getMessageBag();
        } else {
            $master = \DB::table("bank_masters")
                ->where("id", $request->id)
                ->where("is_active", 1)
                ->first();

if (is_null($master)) {
                $response["flag"] = false;

$response["error"] = "Bank Master Not found";
            } else {
                // $master->district_name = $request->district_name;

$data = \DB::table("bank_masters")
                    ->where("id", $request->id)
                    ->where("is_active", 1)
                    ->update([
                        "bank_name" => $request->bank_name,
                        "ifsc_code" => $request->ifsc_code,
                        "branch" => $request->branch,
                        "updated_by" => \Auth::user()->id,
                    ]);

if ($data) {
                    $response["flag"] = true;

$response["message"] = "Bank Master Updated Successfully";
                } else {
                    $response["flag"] = false;

$response["error"] = "Something Went Wrong";
                }
            }
        }

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

public function getEditMpp($id)
    {
        // dd($id);

$data["mpp"] = \DB::table("mpp")
            ->where("id", $id)
            ->where("is_active", 1)
            ->first();

return view("admin.master.edit-mpp", $data);
    }

public function updateMpp(Request $request)
    {
        // dd($request->all());

$response = [];

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

[
                "mcc_code" => "required",

"name" => "required",

"code" => "required",
            ]
        );

if ($validator->fails()) {
            $response["flag"] = false;

$response["errors"] = $validator->getMessageBag();
        } else {
            $master = \DB::table("mpp")
                ->where("id", $request->id)
                ->where("is_active", 1)
                ->first();

if (is_null($master)) {
                $response["flag"] = false;

$response["error"] = "Mpp Not found";
            } else {
                // $master->district_name = $request->district_name;

$data = \DB::table("mpp")
                    ->where("id", $request->id)
                    ->where("is_active", 1)
                    ->update([
                        "name" => $request->name,
                        "code" => trim($request->code),
                        "mcc_code" => trim($request->mcc_code),
                        "updated_by" => \Auth::user()->id,
                    ]);

if ($data) {
                    $response["flag"] = true;

$response["message"] = "Mpp Updated Successfully";
                } else {
                    $response["flag"] = false;

$response["error"] = "Something Went Wrong";
                }
            }
        }

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

public function deleteMpp($id)
    {
        // dd($id);

$response = [];

$master = \DB::table("mpp")
            ->where("id", $id)
            ->where("is_active", 1)
            ->first();

if (is_null($master)) {
            $response["flag"] = false;

$response["message"] = "Mpp Not Found";
        } else {
            $master->is_active = 0;

// 			$data=\DB::table('master')->where('id', $id)->where('is_active', 1)->update(['is_active' => 0]);

$data = \DB::table("mpp")
                ->where("id", $id)
                ->where("is_active", 1)
                ->update(["is_active" => 0, "updated_by" => \Auth::user()->id]);

if ($data) {
                $response["flag"] = true;

$response["message"] = "Mpp Deleted";
            } else {
                $response["flag"] = false;

$response["message"] = "Failed to delete";
            }
        }

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

public function getEditMcc($id)
    {
        // dd($id);

$data["mcc"] = \DB::table("mcc")
            ->where("id", $id)
            ->where("is_active", 1)
            ->first();

return view("admin.master.edit-mcc", $data);
    }

public function getEditAnimalType($id)
    {
        // dd($id);

$data["mcc"] = \DB::table("animal_types")
            ->where("id", $id)
            ->where("is_active", 1)
            ->first();

return view("admin.master.edit-animal-type", $data);
    }

public function getEditAnimalBreed($id)
    {
        // dd($id);

$data["mcc"] = \DB::table("animal_breeds")
            ->where("id", $id)
            ->where("is_active", 1)
            ->first();

$data["animalTypes"] = \DB::table("animal_types")
            ->where("is_active", 1)
            ->get();

return view("admin.master.edit-animal-breed", $data);
    }

public function updateMcc(Request $request)
    {
        // dd($request->all());

$response = [];

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

[
                "name" => "required",

"code" => "required",
            ]
        );

if ($validator->fails()) {
            $response["flag"] = false;

$response["errors"] = $validator->getMessageBag();
        } else {
            $master = \DB::table("mcc")
                ->where("id", $request->id)
                ->where("is_active", 1)
                ->first();

if (is_null($master)) {
                $response["flag"] = false;

$response["error"] = "Mcc Not found";
            } else {
                // $master->district_name = $request->district_name;

$data = \DB::table("mcc")
                    ->where("id", $request->id)
                    ->where("is_active", 1)
                    ->update([
                        "name" => $request->name,
                        "code" => trim($request->code),
                        "updated_by" => \Auth::user()->id,
                    ]);

if ($data) {
                    $response["flag"] = true;

$response["message"] = "Mcc Updated Successfully";
                } else {
                    $response["flag"] = false;

$response["error"] = "Something Went Wrong";
                }
            }
        }

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

public function updateAnimalType(Request $request)
    {
        // dd($request->all());

$response = [];

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

[
                "name" => "required",
            ]
        );

if ($validator->fails()) {
            $response["flag"] = false;

$response["errors"] = $validator->getMessageBag();
        } else {
            $master = \DB::table("animal_types")
                ->where("id", $request->id)
                ->where("is_active", 1)
                ->first();

if (is_null($master)) {
                $response["flag"] = false;

$response["error"] = "Animal Type Not found";
            } else {
                // $master->district_name = $request->district_name;

$data = \DB::table("animal_types")
                    ->where("id", $request->id)
                    ->where("is_active", 1)
                    ->update(["animal_type" => $request->name]);

if ($data) {
                    $response["flag"] = true;

$response["message"] = "Animal Type Updated Successfully";
                } else {
                    $response["flag"] = false;

$response["error"] = "Something Went Wrong";
                }
            }
        }

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

public function updateAnimalBreed(Request $request)
    {
        // dd($request->all());

$response = [];

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

[
                "animal_type" => "required",

"breed" => "required",
            ]
        );

if ($validator->fails()) {
            $response["flag"] = false;

$response["errors"] = $validator->getMessageBag();
        } else {
            $master = \DB::table("animal_breeds")
                ->where("id", $request->id)
                ->where("is_active", 1)
                ->first();

if (is_null($master)) {
                $response["flag"] = false;

$response["error"] = "Animal Breed Not found";
            } else {
                // $master->district_name = $request->district_name;

$data = \DB::table("animal_breeds")
                    ->where("id", $request->id)
                    ->where("is_active", 1)
                    ->update([
                        "animal_type_id" => $request->animal_type,
                        "breed_name" => $request->breed,
                    ]);

if ($data) {
                    $response["flag"] = true;

$response["message"] = "Animal Bread Updated Successfully";
                } else {
                    $response["flag"] = false;

$response["error"] = "Something Went Wrong";
                }
            }
        }

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

public function deleteMcc($id)
    {
        // dd($id);

$response = [];

$master = \DB::table("mcc")
            ->where("id", $id)
            ->where("is_active", 1)
            ->first();

if (is_null($master)) {
            $response["flag"] = false;

$response["message"] = "Mcc Not Found";
        } else {
            $master->is_active = 0;

$data = \DB::table("mcc")
                ->where("id", $id)
                ->where("is_active", 1)
                ->update(["is_active" => 0, "updated_by" => \Auth::user()->id]);

if ($data) {
                $response["flag"] = true;

$response["message"] = "Mcc Deleted";
            } else {
                $response["flag"] = false;

$response["message"] = "Failed to delete";
            }
        }

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

public function deleteAnimalType($id)
    {
        $response = [];

// Find the active animal type by ID

$master = \DB::table("animal_types")
            ->where("id", $id)
            ->where("is_active", 1)
            ->first();

// Check if the animal type is linked with any active animal breeds

$animalBreed = \DB::table("animal_breeds")
            ->where("animal_type_id", $id)
            ->where("is_active", 1)
            ->first();

if (!is_null($animalBreed)) {
            $response["flag"] = false;

$response["message"] =
                "This animal type is linked with an animal breed. Please delete the animal breed first!";

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

if (is_null($master)) {
            $response["flag"] = false;

$response["message"] = "Animal Type Not Found";
        } else {
            // Mark the animal type as inactive (soft delete)

$data = \DB::table("animal_types")
                ->where("id", $id)
                ->update(["is_active" => 0]);

if ($data) {
                $response["flag"] = true;

$response["message"] = "Animal Type Deleted";
            } else {
                $response["flag"] = false;

$response["message"] = "Failed to delete animal type";
            }
        }

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

public function deleteAnimalBreed($id)
    {
        $response = [];

// Find the active animal type by ID

$master = \DB::table("animal_breeds")
            ->where("id", $id)
            ->where("is_active", 1)
            ->first();

if (is_null($master)) {
            $response["flag"] = false;

$response["message"] = "Animal Breed Not Found";
        } else {
            // Mark the animal type as inactive (soft delete)

$data = \DB::table("animal_breeds")
                ->where("id", $id)
                ->update(["is_active" => 0]);

if ($data) {
                $response["flag"] = true;

$response["message"] = "Animal Breed Deleted";
            } else {
                $response["flag"] = false;

$response["message"] = "Failed to delete animal breed";
            }
        }

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

public function formExcelReport(Request $request)
    {
        return Excel::download(
            new MemberFormExport($request),
            "member_form_report.xlsx"
        );
    }

public function transferForm($id)
    {
        // dd($id);

$data["page"] = "Transfer Form To Facilitator";

$data["forms"] = \App\MembershipDetail::where("is_active", 1)
            ->where("created_by_id", $id)
            ->get();

return view("admin.master.transfer-form", $data);
    }

public function transferFormById($id)
    {
        // dd($id);

$data["member"] = \App\MembershipDetail::where("is_active", 1)
            ->where("id", $id)
            ->first();

$data["facilitators"] = \App\User::where("is_active", 1)
            ->where("role_id", 3)
            ->get();

return view("admin.master.transfer-form-by-id", $data);
    }

public function transferToUser(Request $request)
    {
        // 	 dd($request);

$response = [];

if (is_null($request->form_id)) {
            $response["flag"] = false;

$response["message"] = "Form Not Found";
        } else {
            $datass = \App\MembershipDetail::where(
                "id",
                $request->form_id
            )->first();

$mcc = $datass->mcc_code;

$mpp = $datass->mpp_code;

$new = $request->facilitator_id;

$datas = \App\AssignUser::where("user_id", $request->facilitator_id)
                ->where("mcc_code", $mcc)
                ->where("is_active", "1")
                ->first();

$array = explode(",", $datas->mpp_code);

if (in_array($mpp, $array)) {
                $data = \App\MembershipDetail::where("id", $request->form_id)
                    ->where("is_active", 1)
                    ->update([
                        "created_by_id" => $request->facilitator_id,
                        "transfer_by" => \Auth::user()->id,
                    ]);

$response["flag"] = true;

$response["message"] = "Form Transfer Successfull";
            } else {
                $response["flag"] = false;

$response["message"] =
                    "Please Allocate Mpp Then Transfer The Form";
            }
        }

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

public function mppTransfer(Request $request)
    {
        $data['page'] = 'Member Mpp Transfer';
        $data['mcc'] = \DB::table('mcc')->where('is_active', 1)->get();
        $data['mpps'] = \DB::table('mpp')->where('is_active', 1)->get();
        $data['members'] = [];
        if($request->isMethod('post')){
             
            $data['members']=\App\MembershipDetail::where('mpp_code', $request->mpp_name)->where('is_active', 1)->get();
		      
        }
        
    
        return view("admin.master.mpp-transfer", $data);
    }

public function mppTransferEdit(Request $request)
    {
        
        $masterData = \DB::table('master')->where('mcc_code', $request->mcc)->where('mpp_code', $request->mpp)->first();
        if (!$masterData) {
            return response()->json(['flag' => false, 'error' => 'MPP not found in master table.']);
        }else{
    
            foreach ($request->form_id as $id) {
                \DB::table('membership_details')->where('id', $id)->update(['mcc_code' => $masterData->mcc_code, 'mcc_name' => $masterData->mcc_name,'mpp_code' => $masterData->mpp_code, 'mpp_name'=> $masterData->mpp_name]);
            }
        }
    
        return response()->json(['flag' => true, 'message' => 'Membership details updated successfully.']);
    }

public function animalSap(Request $request)
    {
        /// Fetch data from the database

$members = \App\MembershipDetail::where("is_active", 1)
        ->where("final_approval_status", "Approved");

// Apply filters if request is a POST request

if ($request->isMethod("post")) {
            if (!empty($request->date1) && !empty($request->date2) && empty($request->mcc)) {
                $members->whereBetween(
                    DB::raw("date(membership_details.final_approval_date)"),
                    [$request->date1, $request->date2]
                );
            }
            if (!empty($request->date1) && !empty($request->date2) && !empty($request->mcc)) {
                $members->whereBetween(
                    DB::raw("date(membership_details.final_approval_date)"),
                    [$request->date1, $request->date2]
                )->where('mcc_code', $request->mcc);
            }

if (!empty($request->date1) && empty($request->date2) && empty($request->mcc)) {
                $members->whereBetween(
                    DB::raw("date(membership_details.final_approval_date)"),
                    [$request->date1, date("Y-m-d")]
                );
            }
            if (!empty($request->date1) && !empty($request->date2) && !empty($request->mcc)) {
                $members->whereBetween(
                    DB::raw("date(membership_details.final_approval_date)"),
                    [$request->date1, $request->date2]
                )->where('mcc_code', $request->mcc);
            }
            if (empty($request->date1) && empty($request->date2) && !empty($request->mcc)) {
                $members->where('mcc_code', $request->mcc);
            }
            if (empty($request->date1) && empty($request->date2) && empty($request->mcc)) {
                $today = date('Y-m-d');
                $endDate = date('Y-m-d', strtotime('-7 days'));
                $members->whereBetween(
                    DB::raw("date(membership_details.final_approval_date)"),
                    [$endDate, $today]
                );
            }
        }

// Fetch the filtered results

$members = $members->get();

// Start XML structure with the root element

$xml = new \SimpleXMLElement("<MAF_MT_Sen/>");

// Create 'Header' element

$header = $xml->addChild("Header");

// Iterate over each member data and map it to the XML structure

foreach ($members as $member) {
            // Create 'Item' element for each member

$item = $header->addChild("Item");

// Add data from the database (replace with your column names)

$item->addChild("FormNo", $member->form_no);

$item->addChild("MPPType", 0);

$item->addChild(
                "FormReceivingDate",
                date("Ymd", strtotime($member->created_at))
            );

$item->addChild("Applicant_Name", $member->account_holder_name);

$item->addChild("Nameaccordingto", "4");

if($member->gender == "Female"){
                $item->addChild("Gender", "F");
            }else{
                $item->addChild("Gender", "M");
            }

if( $member->husband_or_father == "Son"){
                $item->addChild("RelationwithMiddlename", "1");
            }else if($member->husband_or_father == "FATHER"){
               $item->addChild("RelationwithMiddlename", "2");
            }else if($member->husband_or_father == "Brother"){
              $item->addChild("RelationwithMiddlename", "3");
            }else if($member->husband_or_father == "Daughter"){
                $item->addChild("RelationwithMiddlename", "4");
            }else if($member->husband_or_father == "Mother"){
                 $item->addChild("RelationwithMiddlename", "5" );
            }else if($member->husband_or_father == "Sister"){
                 $item->addChild("RelationwithMiddlename", "6");
            }else if($member->husband_or_father == "Other"){
                $item->addChild("RelationwithMiddlename", "7");
            }else if($member->husband_or_father == "HUSBAND"){
                $item->addChild("RelationwithMiddlename", "8" );
            }else if($member->husband_or_father == "Wife"){
                  $item->addChild("RelationwithMiddlename", "9");
            }

$item->addChild("Father_Name", $member->husband_or_father_name);

$item->addChild("Education", $member->education);

$item->addChild("MobileNo", $member->mobile_no);

$item->addChild("E_MailAddress", $member->email);

$item->addChild("Houseno", $member->village);

$item->addChild("Address", $member->village);

$item->addChild("Dhani", $member->village);

$item->addChild("Village", $member->village);

$item->addChild("Tahsil", $member->tehsil);

$item->addChild("District", $member->district);

$item->addChild("Post_Office", $member->post_office);

$item->addChild("Plant", $member->mcc_code);

$item->addChild("BMCCode", "");

$item->addChild("MPPCode", substr($member->mpp_code, -3));

$item->addChild("PinCode", $member->pincode);

$item->addChild("Occupation", "FARMER AND MILK PRODUCER");

$item->addChild("MemberAge", $member->applicant_age);

if( $member->cast == "General"){
                 $item->addChild("Category", "1");
            }else if($member->cast == "OBC"){
                 $item->addChild("Category", "2");
            }elseif($member->cast == "ST/SC"){
                 $item->addChild("Category", "3");
            }else{
                 $item->addChild("Category", "4");
            }

$item->addChild("APL", "X");

$item->addChild("BPL", "");

$item->addChild("Nationality", "IN");

$item->addChild("AdharAvl", 1);

$item->addChild("AdharNo", $member->aadhar_card);

$item->addChild("Nominee", $member->nominee_name);

$item->addChild(
                "RelationWithAppl",
                $member->relation_with_application
            );

$dob = new \DateTime($member->age);

$createdAt = new \DateTime($member->created_at);

$ageInterval = $dob->diff($createdAt);

$item->addChild("NomineeAge", $ageInterval->y);

$desiCow = explode(",", $member->desiCow);

$buffalo = explode(",", $member->buffalo);

$crossBred = explode(",", $member->crossBred);

$item->addChild("DESICOW_H", isset($desiCow[0]) ? $desiCow[0] : 0);

$item->addChild("DESICOW_M", isset($desiCow[2]) ? $desiCow[2] : 0);

$item->addChild("DESICOW_D", isset($desiCow[1]) ? $desiCow[1] : 0);

$item->addChild("DESICOW_P", "");

$item->addChild(
                "CROSCOW_H",
                isset($crossBred[0]) ? $crossBred[0] : 0
            );

$item->addChild(
                "CROSCOW_M",
                isset($crossBred[2]) ? $crossBred[2] : 0
            );

$item->addChild(
                "CROSCOW_D",
                isset($crossBred[1]) ? $crossBred[1] : 0
            );

$item->addChild("CROSCOW_P", "");

$item->addChild("BUFF_H", isset($buffalo[0]) ? $buffalo[0] : 0);

$item->addChild("BUFF_M", isset($buffalo[2]) ? $buffalo[2] : 0);

$item->addChild("BUFF_D", isset($buffalo[1]) ? $buffalo[1] : 0);

$item->addChild("BUFF_P", "");

$TOTAL_H =
                (isset($desiCow[0]) ? $desiCow[0] : 0) +
                (isset($crossBred[0]) ? $crossBred[0] : 0) +
                (isset($buffalo[0]) ? $buffalo[0] : 0);

$TOTAL_M =
                (isset($desiCow[2]) ? $desiCow[2] : 0) +
                (isset($crossBred[2]) ? $crossBred[2] : 0) +
                (isset($buffalo[2]) ? $buffalo[2] : 0);

$TOTAL_D =
                (isset($desiCow[1]) ? $desiCow[1] : 0) +
                (isset($crossBred[1]) ? $crossBred[1] : 0) +
                (isset($buffalo[1]) ? $buffalo[1] : 0);

$item->addChild("TOTAL_H", $TOTAL_H);

$item->addChild("TOTAL_M", $TOTAL_M);

$item->addChild("TOTAL_D", $TOTAL_D);

$item->addChild("TOTAL_P", "");

$item->addChild("HOME_LPD", $member->HouseHoldConsumption);

$item->addChild("MARKT_LPD", $member->MarketableSurplus);

$item->addChild("Bank_Type", 1);

$item->addChild("BankKey", $member->bank_name);

$item->addChild("BankAcNo", $member->s_account_number);

$item->addChild("IFSCCode", $member->ifsc_code);

$item->addChild("PrimaryAc", 1);

$item->addChild("AnnualComm", $member->AnnualMilkCommitment);

$item->addChild("Item_number", "");

$item->addChild("Share_type", "");

if($member->cash_dd == "Cash"){
                  $item->addChild("Modeofpayment", "1");
            }else if($member->cash_dd == "DD"){
                 $item->addChild("Modeofpayment", "2");
            }

$item->addChild("Bank_name", $member->bank_name);

$item->addChild("Bank_Branch", $member->branch_name);

$item->addChild("Receipt_no", "XX");

$item->addChild(
                "Dateofdeposit",
                date("Ymd", strtotime($member->fee_receipt_date))
            );

$item->addChild("Amount_Deposited", $member->received_amount);

$item->addChild("Cheque_DD_BANK", "SBI");

$item->addChild("Shareapplied", $member->share_quantity);

$item->addChild("AdmissionFee", $member->admission_fee);

$item->addChild("Shareamountpayable", "500");

$item->addChild("sharepremiumamount", "0");

$item->addChild("Balanceamount", "");

$item->addChild("Excessamount", "");

if($member->final_approval_status == "NULL"){
                 $item->addChild("Application_Status", "1");
            }else if($member->final_approval_status == "Rejected"){
                $item->addChild("Application_Status", "4");
            }else if($member->final_approval_status == "Approved"){
                $item->addChild("Application_Status", "3");
            }

$item->addChild("Approval_Status", "1");

// $master_data1 = \DB::table('master')->where('state_name', 'like', '%' . $member->state . '%')->where('is_active', 1)->first();

// if ($master_data1) {

// 	$item->addChild('State_Code', $master_data1->state_code);

// } else {

// 	$item->addChild('State_Code', ''); // Add a default or fallback value

// }

// $master_data2 = \DB::table('master')->where('district_name', 'like', '%' . $member->district . '%')->where('is_active', 1)->first();

// if ($master_data2) {

// 	$item->addChild('District_Code', $master_data2->district_code);

// } else {

// 	$item->addChild('District_Code', ''); // Add a default or fallback value

// }

$item->addChild("Tag1", "X");

$item->addChild("Tag2", "");

// Create 'Family_Details' as a child of 'Item' (so it stays in the same row in Excel)
			$familyDetails = $item->addChild("Family_Details");

// Add family details
			$familyDetails->addChild("FormNo", $member->form_no);
			$familyDetails->addChild("Plant", $member->mcc_code);
			$familyDetails->addChild("PPCode", substr($member->mpp_code, -3));
			$familyDetails->addChild("Serialnumber", "");

// Assuming $member->relation1 contains comma-separated data
			$relationData = explode(",", $member->relation1);

// Extract individual fields from the array
			$name = $relationData[0] ?? ''; // Name
			$gender = $relationData[1] ?? ''; // Gender
			$age = $relationData[2] ?? ''; // Age
			$relation = $relationData[3] ?? ''; // Relation with applicant

$familyDetails->addChild("Name", $name);
			
			if( $relation == "Son"){
            $familyDetails->addChild("Relationwithapplicant", "1");
            }else if($relation == "Father"){
              $familyDetails->addChild("Relationwithapplicant", "2");
            }else if($relation == "Brother"){
              $familyDetails->addChild("Relationwithapplicant", "3");
            }else if($relation == "Daughter"){
                $familyDetails->addChild("Relationwithapplicant", "4");
            }else if($relation == "Mother"){
                $familyDetails->addChild("Relationwithapplicant", "5");
            }else if($relation == "Sister"){
                $familyDetails->addChild("Relationwithapplicant", "6");
            }else if($relation == "Other"){
                $familyDetails->addChild("Relationwithapplicant", "7");
            }else if($relation == "Husband"){
                $familyDetails->addChild("Relationwithapplicant", "8");
            }else if($relation == "Wife"){
                  $familyDetails->addChild("Relationwithapplicant", "9");
            }
		
			if($gender == "Female"){
               $familyDetails->addChild("Gender", "F");
            }else{
                $familyDetails->addChild("Gender", "M");
            }
			$familyDetails->addChild("DateofBirth", ""); // Empty since not available in the stored format
			$familyDetails->addChild("Age", $age);
			$familyDetails->addChild("Tag1", "X");
			$familyDetails->addChild("Tag2", "");
			$familyDetails->addChild("Remarks", "");
        }

// Beautify the XML

$dom = new \DOMDocument("1.0");

$dom->preserveWhiteSpace = false;

$dom->formatOutput = true;

$dom->loadXML($xml->asXML());

// Set the headers for downloading the XML file

$headers = [
            "Content-type" => "text/xml",

"Content-Disposition" => 'attachment; filename="SAP_Data.xml"',

"Pragma" => "no-cache",

"Expires" => "0",
        ];

// Return the response with XML data

return Response::make($dom->saveXML(), 200, $headers);
    }
}